== 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_3342161`, 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)#109288, RAWTOHEX(PATIENT_ID)#109289, IN_DATE#109290, OUT_DATE#109291, IN_MODE#109292, OUT_MODE#109293, IN_UNIT#109294, OUT_UNIT#109295, VISIT_TYPE#109296, CHAMP_PMSI#109297, UNIT_PATH#109298, EMERGENCY#109299, CANCELED#109300], false
(4) Project
Arguments: [RAWTOHEX(VISIT_ID)#109288, RAWTOHEX(PATIENT_ID)#109289, IN_DATE#109290, OUT_DATE#109291, IN_MODE#109292, OUT_MODE#109293, IN_UNIT#109294, OUT_UNIT#109295, VISIT_TYPE#109296, CHAMP_PMSI#109297, UNIT_PATH#109298, staticinvoke(class org.apache.spark.sql.catalyst.util.CharVarcharCodegenUtils, StringType, readSidePadding, EMERGENCY#109299, 1, true, false, true) AS EMERGENCY#109301, CANCELED#109300]
(5) Project
Arguments: [RAWTOHEX(VISIT_ID)#109288 AS COLL0#109315, RAWTOHEX(PATIENT_ID)#109289 AS COLL1#109316, IN_DATE#109290 AS COLL2#109317, OUT_DATE#109291 AS COLL3#109318, IN_MODE#109292 AS COLL4#109319, OUT_MODE#109293 AS COLL5#109320, IN_UNIT#109294 AS COLL6#109321, OUT_UNIT#109295 AS COLL7#109322, VISIT_TYPE#109296 AS COLL8#109323, CHAMP_PMSI#109297 AS COLL9#109324, UNIT_PATH#109298 AS COLL10#109325, EMERGENCY#109301 AS COLL11#109326, CANCELED#109300 AS COLL12#109327]
(6) Project
Arguments: [COLL0#109315 AS COLL0#109341, COLL1#109316 AS COLL1#109342, COLL2#109317 AS COLL2#109343, COLL3#109318 AS COLL3#109344, COLL4#109319 AS COLL4#109345, COLL5#109320 AS COLL5#109346, COLL6#109321 AS COLL6#109347, COLL7#109322 AS COLL7#109348, COLL8#109323 AS COLL8#109349, COLL9#109324 AS COLL9#109350, COLL10#109325 AS COLL10#109351, COLL11#109326 AS COLL11#109352, COLL12#109327 AS COLL12#109353]
(7) Project
Arguments: [COLL0#109341, COLL1#109342, COLL2#109343, COLL3#109344, COLL4#109345, COLL5#109346, COLL6#109347, COLL7#109348, COLL8#109349, COLL9#109350, COLL10#109351, COLL11#109352, COLL12#109353]
(8) Project
Arguments: [cast(COLL12#109353 as int) AS CANCELED_3355#109380, COLL9#109350 AS CHAMP_PMSI_3352#109381, COLL11#109352 AS EMERGENCY_3354#109382, COLL2#109343 AS IN_DATE_3345#109383, COLL4#109345 AS IN_MODE_3347#109384, COLL6#109347 AS IN_UNIT_3349#109385, COLL3#109344 AS OUT_DATE_3346#109386, COLL5#109346 AS OUT_MODE_3348#109387, COLL7#109348 AS OUT_UNIT_3350#109388, COLL1#109342 AS PATIENT_ID_3344#109389, COLL10#109351 AS UNIT_PATH_3353#109390, COLL0#109341 AS VISIT_ID_3343#109391, COLL8#109349 AS VISIT_TYPE_3351#109392]
(9) Project
Arguments: [CANCELED_3355#109380, CHAMP_PMSI_3352#109381, EMERGENCY_3354#109382, IN_DATE_3345#109383, IN_MODE_3347#109384, IN_UNIT_3349#109385, OUT_DATE_3346#109386, OUT_MODE_3348#109387, OUT_UNIT_3350#109388, PATIENT_ID_3344#109389, UNIT_PATH_3353#109390, VISIT_ID_3343#109391, VISIT_TYPE_3351#109392, str_encrypt(VISIT_ID_3343#109391) AS ENCRYPT_3536#109406]