== 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_3332165`, 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)#68601, BIRTH_DATE#68602, GENDER#68603, PSEUDO#68604, INHOSPITAL_DEATH_DATE#68605, INHOSPITAL_DEATH_CODE#68606, DEATH_DATE#68607, EXTERNAL_DEATH_PROCESS_ID#68608], false
(4) Project
Arguments: [RAWTOHEX(PATIENT_ID)#68601 AS COLL0#68617, BIRTH_DATE#68602 AS COLL1#68618, GENDER#68603 AS COLL2#68619, PSEUDO#68604 AS COLL3#68620, INHOSPITAL_DEATH_DATE#68605 AS COLL4#68621, INHOSPITAL_DEATH_CODE#68606 AS COLL5#68622, DEATH_DATE#68607 AS COLL6#68623, EXTERNAL_DEATH_PROCESS_ID#68608 AS COLL7#68624]
(5) Project
Arguments: [COLL0#68617 AS COLL0#68633, COLL1#68618 AS COLL1#68634, COLL2#68619 AS COLL2#68635, COLL3#68620 AS COLL3#68636, COLL4#68621 AS COLL4#68637, COLL5#68622 AS COLL5#68638, COLL6#68623 AS COLL6#68639, COLL7#68624 AS COLL7#68640]
(6) Project
Arguments: [COLL0#68633, COLL1#68634, COLL2#68635, COLL3#68636, COLL4#68637, COLL5#68638, COLL6#68639, COLL7#68640]
(7) Project
Arguments: [COLL1#68634 AS BIRTH_DATE_3334#68657, COLL6#68639 AS DEATH_DATE_3339#68658, cast(COLL7#68640 as int) AS EXTERNAL_DEATH__3340#68659, COLL2#68635 AS GENDER_3335#68660, COLL4#68637 AS INHOSPITAL_DEAT_3337#68661, COLL5#68638 AS INHOSPITAL_DEAT_3338#68662, COLL0#68633 AS PATIENT_ID_3333#68663, COLL3#68636 AS PSEUDO_3336#68664]
(8) Project
Arguments: [BIRTH_DATE_3334#68657, DEATH_DATE_3339#68658, EXTERNAL_DEATH__3340#68659, GENDER_3335#68660, INHOSPITAL_DEAT_3337#68661, INHOSPITAL_DEAT_3338#68662, PATIENT_ID_3333#68663, PSEUDO_3336#68664]