== Physical Plan ==
Execute CreateViewCommand (1)
+- CreateViewCommand (2)
+- Project (8)
+- Project (7)
+- Project (6)
+- Project (5)
+- Project (4)
+- LogicalRelation (3)
(1) Execute CreateViewCommand
Output: []
(2) CreateViewCommand
Arguments: `PATIENT_3332162`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: JDBCRelation((SELECT RAWTOHEX(PATIENT_ID), "BIRTH_DATE", "GENDER", "PSEUDO", "INHOSPITAL_DEATH_DATE", "INHOSPITAL_DEATH_CODE", "DEATH_DATE", "EXTERNAL_DEATH_PROCESS_ID" FROM "DTM_622"."PATIENT") x) [numPartitions=1], [RAWTOHEX(PATIENT_ID)#67641, BIRTH_DATE#67642, GENDER#67643, PSEUDO#67644, INHOSPITAL_DEATH_DATE#67645, INHOSPITAL_DEATH_CODE#67646, DEATH_DATE#67647, EXTERNAL_DEATH_PROCESS_ID#67648], false
(4) Project
Arguments: [RAWTOHEX(PATIENT_ID)#67641 AS COLL0#67657, BIRTH_DATE#67642 AS COLL1#67658, GENDER#67643 AS COLL2#67659, PSEUDO#67644 AS COLL3#67660, INHOSPITAL_DEATH_DATE#67645 AS COLL4#67661, INHOSPITAL_DEATH_CODE#67646 AS COLL5#67662, DEATH_DATE#67647 AS COLL6#67663, EXTERNAL_DEATH_PROCESS_ID#67648 AS COLL7#67664]
(5) Project
Arguments: [COLL0#67657 AS COLL0#67673, COLL1#67658 AS COLL1#67674, COLL2#67659 AS COLL2#67675, COLL3#67660 AS COLL3#67676, COLL4#67661 AS COLL4#67677, COLL5#67662 AS COLL5#67678, COLL6#67663 AS COLL6#67679, COLL7#67664 AS COLL7#67680]
(6) Project
Arguments: [COLL0#67673, COLL1#67674, COLL2#67675, COLL3#67676, COLL4#67677, COLL5#67678, COLL6#67679, COLL7#67680]
(7) Project
Arguments: [COLL1#67674 AS BIRTH_DATE_3334#67697, COLL6#67679 AS DEATH_DATE_3339#67698, cast(COLL7#67680 as int) AS EXTERNAL_DEATH__3340#67699, COLL2#67675 AS GENDER_3335#67700, COLL4#67677 AS INHOSPITAL_DEAT_3337#67701, COLL5#67678 AS INHOSPITAL_DEAT_3338#67702, COLL0#67673 AS PATIENT_ID_3333#67703, COLL3#67676 AS PSEUDO_3336#67704]
(8) Project
Arguments: [BIRTH_DATE_3334#67697, DEATH_DATE_3339#67698, EXTERNAL_DEATH__3340#67699, GENDER_3335#67700, INHOSPITAL_DEAT_3337#67701, INHOSPITAL_DEAT_3338#67702, PATIENT_ID_3333#67703, PSEUDO_3336#67704]