== Physical Plan ==
Execute CreateViewCommand (1)
+- CreateViewCommand (2)
+- Project (9)
+- Project (8)
+- Project (7)
+- Project (6)
+- Project (5)
+- Project (4)
+- LogicalRelation (3)
(1) Execute CreateViewCommand
Output: []
(2) CreateViewCommand
Arguments: `VISIT_3342165`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: JDBCRelation((SELECT RAWTOHEX(VISIT_ID), RAWTOHEX(PATIENT_ID), "IN_DATE", "OUT_DATE", "IN_MODE", "OUT_MODE", "IN_UNIT", "OUT_UNIT", "VISIT_TYPE", "CHAMP_PMSI", "UNIT_PATH", "EMERGENCY", "CANCELED" FROM "DTM_622"."VISIT") x) [numPartitions=1], [RAWTOHEX(VISIT_ID)#114188, RAWTOHEX(PATIENT_ID)#114189, IN_DATE#114190, OUT_DATE#114191, IN_MODE#114192, OUT_MODE#114193, IN_UNIT#114194, OUT_UNIT#114195, VISIT_TYPE#114196, CHAMP_PMSI#114197, UNIT_PATH#114198, EMERGENCY#114199, CANCELED#114200], false
(4) Project
Arguments: [RAWTOHEX(VISIT_ID)#114188, RAWTOHEX(PATIENT_ID)#114189, IN_DATE#114190, OUT_DATE#114191, IN_MODE#114192, OUT_MODE#114193, IN_UNIT#114194, OUT_UNIT#114195, VISIT_TYPE#114196, CHAMP_PMSI#114197, UNIT_PATH#114198, staticinvoke(class org.apache.spark.sql.catalyst.util.CharVarcharCodegenUtils, StringType, readSidePadding, EMERGENCY#114199, 1, true, false, true) AS EMERGENCY#114201, CANCELED#114200]
(5) Project
Arguments: [RAWTOHEX(VISIT_ID)#114188 AS COLL0#114215, RAWTOHEX(PATIENT_ID)#114189 AS COLL1#114216, IN_DATE#114190 AS COLL2#114217, OUT_DATE#114191 AS COLL3#114218, IN_MODE#114192 AS COLL4#114219, OUT_MODE#114193 AS COLL5#114220, IN_UNIT#114194 AS COLL6#114221, OUT_UNIT#114195 AS COLL7#114222, VISIT_TYPE#114196 AS COLL8#114223, CHAMP_PMSI#114197 AS COLL9#114224, UNIT_PATH#114198 AS COLL10#114225, EMERGENCY#114201 AS COLL11#114226, CANCELED#114200 AS COLL12#114227]
(6) Project
Arguments: [COLL0#114215 AS COLL0#114241, COLL1#114216 AS COLL1#114242, COLL2#114217 AS COLL2#114243, COLL3#114218 AS COLL3#114244, COLL4#114219 AS COLL4#114245, COLL5#114220 AS COLL5#114246, COLL6#114221 AS COLL6#114247, COLL7#114222 AS COLL7#114248, COLL8#114223 AS COLL8#114249, COLL9#114224 AS COLL9#114250, COLL10#114225 AS COLL10#114251, COLL11#114226 AS COLL11#114252, COLL12#114227 AS COLL12#114253]
(7) Project
Arguments: [COLL0#114241, COLL1#114242, COLL2#114243, COLL3#114244, COLL4#114245, COLL5#114246, COLL6#114247, COLL7#114248, COLL8#114249, COLL9#114250, COLL10#114251, COLL11#114252, COLL12#114253]
(8) Project
Arguments: [cast(COLL12#114253 as int) AS CANCELED_3355#114280, COLL9#114250 AS CHAMP_PMSI_3352#114281, COLL11#114252 AS EMERGENCY_3354#114282, COLL2#114243 AS IN_DATE_3345#114283, COLL4#114245 AS IN_MODE_3347#114284, COLL6#114247 AS IN_UNIT_3349#114285, COLL3#114244 AS OUT_DATE_3346#114286, COLL5#114246 AS OUT_MODE_3348#114287, COLL7#114248 AS OUT_UNIT_3350#114288, COLL1#114242 AS PATIENT_ID_3344#114289, COLL10#114251 AS UNIT_PATH_3353#114290, COLL0#114241 AS VISIT_ID_3343#114291, COLL8#114249 AS VISIT_TYPE_3351#114292]
(9) Project
Arguments: [CANCELED_3355#114280, CHAMP_PMSI_3352#114281, EMERGENCY_3354#114282, IN_DATE_3345#114283, IN_MODE_3347#114284, IN_UNIT_3349#114285, OUT_DATE_3346#114286, OUT_MODE_3348#114287, OUT_UNIT_3350#114288, PATIENT_ID_3344#114289, UNIT_PATH_3353#114290, VISIT_ID_3343#114291, VISIT_TYPE_3351#114292, str_encrypt(VISIT_ID_3343#114291) AS ENCRYPT_3536#114306]