== 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_3332164`, 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)#67134, BIRTH_DATE#67135, GENDER#67136, PSEUDO#67137, INHOSPITAL_DEATH_DATE#67138, INHOSPITAL_DEATH_CODE#67139, DEATH_DATE#67140, EXTERNAL_DEATH_PROCESS_ID#67141], false
(4) Project
Arguments: [RAWTOHEX(PATIENT_ID)#67134 AS COLL0#67150, BIRTH_DATE#67135 AS COLL1#67151, GENDER#67136 AS COLL2#67152, PSEUDO#67137 AS COLL3#67153, INHOSPITAL_DEATH_DATE#67138 AS COLL4#67154, INHOSPITAL_DEATH_CODE#67139 AS COLL5#67155, DEATH_DATE#67140 AS COLL6#67156, EXTERNAL_DEATH_PROCESS_ID#67141 AS COLL7#67157]
(5) Project
Arguments: [COLL0#67150 AS COLL0#67166, COLL1#67151 AS COLL1#67167, COLL2#67152 AS COLL2#67168, COLL3#67153 AS COLL3#67169, COLL4#67154 AS COLL4#67170, COLL5#67155 AS COLL5#67171, COLL6#67156 AS COLL6#67172, COLL7#67157 AS COLL7#67173]
(6) Project
Arguments: [COLL0#67166, COLL1#67167, COLL2#67168, COLL3#67169, COLL4#67170, COLL5#67171, COLL6#67172, COLL7#67173]
(7) Project
Arguments: [COLL1#67167 AS BIRTH_DATE_3334#67190, COLL6#67172 AS DEATH_DATE_3339#67191, cast(COLL7#67173 as int) AS EXTERNAL_DEATH__3340#67192, COLL2#67168 AS GENDER_3335#67193, COLL4#67170 AS INHOSPITAL_DEAT_3337#67194, COLL5#67171 AS INHOSPITAL_DEAT_3338#67195, COLL0#67166 AS PATIENT_ID_3333#67196, COLL3#67169 AS PSEUDO_3336#67197]
(8) Project
Arguments: [BIRTH_DATE_3334#67190, DEATH_DATE_3339#67191, EXTERNAL_DEATH__3340#67192, GENDER_3335#67193, INHOSPITAL_DEAT_3337#67194, INHOSPITAL_DEAT_3338#67195, PATIENT_ID_3333#67196, PSEUDO_3336#67197]