== 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_3332161`, 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)#68121, BIRTH_DATE#68122, GENDER#68123, PSEUDO#68124, INHOSPITAL_DEATH_DATE#68125, INHOSPITAL_DEATH_CODE#68126, DEATH_DATE#68127, EXTERNAL_DEATH_PROCESS_ID#68128], false
(4) Project
Arguments: [RAWTOHEX(PATIENT_ID)#68121 AS COLL0#68137, BIRTH_DATE#68122 AS COLL1#68138, GENDER#68123 AS COLL2#68139, PSEUDO#68124 AS COLL3#68140, INHOSPITAL_DEATH_DATE#68125 AS COLL4#68141, INHOSPITAL_DEATH_CODE#68126 AS COLL5#68142, DEATH_DATE#68127 AS COLL6#68143, EXTERNAL_DEATH_PROCESS_ID#68128 AS COLL7#68144]
(5) Project
Arguments: [COLL0#68137 AS COLL0#68153, COLL1#68138 AS COLL1#68154, COLL2#68139 AS COLL2#68155, COLL3#68140 AS COLL3#68156, COLL4#68141 AS COLL4#68157, COLL5#68142 AS COLL5#68158, COLL6#68143 AS COLL6#68159, COLL7#68144 AS COLL7#68160]
(6) Project
Arguments: [COLL0#68153, COLL1#68154, COLL2#68155, COLL3#68156, COLL4#68157, COLL5#68158, COLL6#68159, COLL7#68160]
(7) Project
Arguments: [COLL1#68154 AS BIRTH_DATE_3334#68177, COLL6#68159 AS DEATH_DATE_3339#68178, cast(COLL7#68160 as int) AS EXTERNAL_DEATH__3340#68179, COLL2#68155 AS GENDER_3335#68180, COLL4#68157 AS INHOSPITAL_DEAT_3337#68181, COLL5#68158 AS INHOSPITAL_DEAT_3338#68182, COLL0#68153 AS PATIENT_ID_3333#68183, COLL3#68156 AS PSEUDO_3336#68184]
(8) Project
Arguments: [BIRTH_DATE_3334#68177, DEATH_DATE_3339#68178, EXTERNAL_DEATH__3340#68179, GENDER_3335#68180, INHOSPITAL_DEAT_3337#68181, INHOSPITAL_DEAT_3338#68182, PATIENT_ID_3333#68183, PSEUDO_3336#68184]