== 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_3332163`, 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)#104645, BIRTH_DATE#104646, GENDER#104647, PSEUDO#104648, INHOSPITAL_DEATH_DATE#104649, INHOSPITAL_DEATH_CODE#104650, DEATH_DATE#104651, EXTERNAL_DEATH_PROCESS_ID#104652], false
(4) Project
Arguments: [RAWTOHEX(PATIENT_ID)#104645 AS COLL0#104661, BIRTH_DATE#104646 AS COLL1#104662, GENDER#104647 AS COLL2#104663, PSEUDO#104648 AS COLL3#104664, INHOSPITAL_DEATH_DATE#104649 AS COLL4#104665, INHOSPITAL_DEATH_CODE#104650 AS COLL5#104666, DEATH_DATE#104651 AS COLL6#104667, EXTERNAL_DEATH_PROCESS_ID#104652 AS COLL7#104668]
(5) Project
Arguments: [COLL0#104661 AS COLL0#104677, COLL1#104662 AS COLL1#104678, COLL2#104663 AS COLL2#104679, COLL3#104664 AS COLL3#104680, COLL4#104665 AS COLL4#104681, COLL5#104666 AS COLL5#104682, COLL6#104667 AS COLL6#104683, COLL7#104668 AS COLL7#104684]
(6) Project
Arguments: [COLL0#104677, COLL1#104678, COLL2#104679, COLL3#104680, COLL4#104681, COLL5#104682, COLL6#104683, COLL7#104684]
(7) Project
Arguments: [COLL1#104678 AS BIRTH_DATE_3334#104701, COLL6#104683 AS DEATH_DATE_3339#104702, cast(COLL7#104684 as int) AS EXTERNAL_DEATH__3340#104703, COLL2#104679 AS GENDER_3335#104704, COLL4#104681 AS INHOSPITAL_DEAT_3337#104705, COLL5#104682 AS INHOSPITAL_DEAT_3338#104706, COLL0#104677 AS PATIENT_ID_3333#104707, COLL3#104680 AS PSEUDO_3336#104708]
(8) Project
Arguments: [BIRTH_DATE_3334#104701, DEATH_DATE_3339#104702, EXTERNAL_DEATH__3340#104703, GENDER_3335#104704, INHOSPITAL_DEAT_3337#104705, INHOSPITAL_DEAT_3338#104706, PATIENT_ID_3333#104707, PSEUDO_3336#104708]