== 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)#70194, BIRTH_DATE#70195, GENDER#70196, PSEUDO#70197, INHOSPITAL_DEATH_DATE#70198, INHOSPITAL_DEATH_CODE#70199, DEATH_DATE#70200, EXTERNAL_DEATH_PROCESS_ID#70201], false
(4) Project
Arguments: [RAWTOHEX(PATIENT_ID)#70194 AS COLL0#70218, BIRTH_DATE#70195 AS COLL1#70221, GENDER#70196 AS COLL2#70223, PSEUDO#70197 AS COLL3#70225, INHOSPITAL_DEATH_DATE#70198 AS COLL4#70227, INHOSPITAL_DEATH_CODE#70199 AS COLL5#70229, DEATH_DATE#70200 AS COLL6#70231, EXTERNAL_DEATH_PROCESS_ID#70201 AS COLL7#70233]
(5) Project
Arguments: [COLL0#70218 AS COLL0#70251, COLL1#70221 AS COLL1#70252, COLL2#70223 AS COLL2#70254, COLL3#70225 AS COLL3#70256, COLL4#70227 AS COLL4#70258, COLL5#70229 AS COLL5#70260, COLL6#70231 AS COLL6#70262, COLL7#70233 AS COLL7#70264]
(6) Project
Arguments: [COLL0#70251, COLL1#70252, COLL2#70254, COLL3#70256, COLL4#70258, COLL5#70260, COLL6#70262, COLL7#70264]
(7) Project
Arguments: [COLL1#70252 AS BIRTH_DATE_3334#70300, COLL6#70262 AS DEATH_DATE_3339#70301, cast(COLL7#70264 as int) AS EXTERNAL_DEATH__3340#70304, COLL2#70254 AS GENDER_3335#70305, COLL4#70258 AS INHOSPITAL_DEAT_3337#70306, COLL5#70260 AS INHOSPITAL_DEAT_3338#70309, COLL0#70251 AS PATIENT_ID_3333#70311, COLL3#70256 AS PSEUDO_3336#70313]
(8) Project
Arguments: [BIRTH_DATE_3334#70300, DEATH_DATE_3339#70301, EXTERNAL_DEATH__3340#70304, GENDER_3335#70305, INHOSPITAL_DEAT_3337#70306, INHOSPITAL_DEAT_3338#70309, PATIENT_ID_3333#70311, PSEUDO_3336#70313]