== 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_3342162`, 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)#110255, RAWTOHEX(PATIENT_ID)#110256, IN_DATE#110257, OUT_DATE#110258, IN_MODE#110259, OUT_MODE#110260, IN_UNIT#110261, OUT_UNIT#110262, VISIT_TYPE#110263, CHAMP_PMSI#110264, UNIT_PATH#110265, EMERGENCY#110266, CANCELED#110267], false
(4) Project
Arguments: [RAWTOHEX(VISIT_ID)#110255, RAWTOHEX(PATIENT_ID)#110256, IN_DATE#110257, OUT_DATE#110258, IN_MODE#110259, OUT_MODE#110260, IN_UNIT#110261, OUT_UNIT#110262, VISIT_TYPE#110263, CHAMP_PMSI#110264, UNIT_PATH#110265, staticinvoke(class org.apache.spark.sql.catalyst.util.CharVarcharCodegenUtils, StringType, readSidePadding, EMERGENCY#110266, 1, true, false, true) AS EMERGENCY#110269, CANCELED#110267]
(5) Project
Arguments: [RAWTOHEX(VISIT_ID)#110255 AS COLL0#110283, RAWTOHEX(PATIENT_ID)#110256 AS COLL1#110284, IN_DATE#110257 AS COLL2#110285, OUT_DATE#110258 AS COLL3#110286, IN_MODE#110259 AS COLL4#110287, OUT_MODE#110260 AS COLL5#110288, IN_UNIT#110261 AS COLL6#110289, OUT_UNIT#110262 AS COLL7#110290, VISIT_TYPE#110263 AS COLL8#110291, CHAMP_PMSI#110264 AS COLL9#110292, UNIT_PATH#110265 AS COLL10#110293, EMERGENCY#110269 AS COLL11#110294, CANCELED#110267 AS COLL12#110295]
(6) Project
Arguments: [COLL0#110283 AS COLL0#110309, COLL1#110284 AS COLL1#110310, COLL2#110285 AS COLL2#110311, COLL3#110286 AS COLL3#110312, COLL4#110287 AS COLL4#110313, COLL5#110288 AS COLL5#110314, COLL6#110289 AS COLL6#110315, COLL7#110290 AS COLL7#110316, COLL8#110291 AS COLL8#110317, COLL9#110292 AS COLL9#110318, COLL10#110293 AS COLL10#110319, COLL11#110294 AS COLL11#110320, COLL12#110295 AS COLL12#110321]
(7) Project
Arguments: [COLL0#110309, COLL1#110310, COLL2#110311, COLL3#110312, COLL4#110313, COLL5#110314, COLL6#110315, COLL7#110316, COLL8#110317, COLL9#110318, COLL10#110319, COLL11#110320, COLL12#110321]
(8) Project
Arguments: [cast(COLL12#110321 as int) AS CANCELED_3355#110348, COLL9#110318 AS CHAMP_PMSI_3352#110349, COLL11#110320 AS EMERGENCY_3354#110350, COLL2#110311 AS IN_DATE_3345#110351, COLL4#110313 AS IN_MODE_3347#110352, COLL6#110315 AS IN_UNIT_3349#110353, COLL3#110312 AS OUT_DATE_3346#110354, COLL5#110314 AS OUT_MODE_3348#110355, COLL7#110316 AS OUT_UNIT_3350#110356, COLL1#110310 AS PATIENT_ID_3344#110357, COLL10#110319 AS UNIT_PATH_3353#110358, COLL0#110309 AS VISIT_ID_3343#110359, COLL8#110317 AS VISIT_TYPE_3351#110360]
(9) Project
Arguments: [CANCELED_3355#110348, CHAMP_PMSI_3352#110349, EMERGENCY_3354#110350, IN_DATE_3345#110351, IN_MODE_3347#110352, IN_UNIT_3349#110353, OUT_DATE_3346#110354, OUT_MODE_3348#110355, OUT_UNIT_3350#110356, PATIENT_ID_3344#110357, UNIT_PATH_3353#110358, VISIT_ID_3343#110359, VISIT_TYPE_3351#110360, str_encrypt(VISIT_ID_3343#110359) AS ENCRYPT_3536#110374]