== 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_3342166`, 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)#106414, RAWTOHEX(PATIENT_ID)#106415, IN_DATE#106416, OUT_DATE#106417, IN_MODE#106418, OUT_MODE#106419, IN_UNIT#106420, OUT_UNIT#106421, VISIT_TYPE#106422, CHAMP_PMSI#106423, UNIT_PATH#106424, EMERGENCY#106425, CANCELED#106426], false
(4) Project
Arguments: [RAWTOHEX(VISIT_ID)#106414, RAWTOHEX(PATIENT_ID)#106415, IN_DATE#106416, OUT_DATE#106417, IN_MODE#106418, OUT_MODE#106419, IN_UNIT#106420, OUT_UNIT#106421, VISIT_TYPE#106422, CHAMP_PMSI#106423, UNIT_PATH#106424, staticinvoke(class org.apache.spark.sql.catalyst.util.CharVarcharCodegenUtils, StringType, readSidePadding, EMERGENCY#106425, 1, true, false, true) AS EMERGENCY#106427, CANCELED#106426]
(5) Project
Arguments: [RAWTOHEX(VISIT_ID)#106414 AS COLL0#106441, RAWTOHEX(PATIENT_ID)#106415 AS COLL1#106442, IN_DATE#106416 AS COLL2#106443, OUT_DATE#106417 AS COLL3#106444, IN_MODE#106418 AS COLL4#106445, OUT_MODE#106419 AS COLL5#106446, IN_UNIT#106420 AS COLL6#106447, OUT_UNIT#106421 AS COLL7#106448, VISIT_TYPE#106422 AS COLL8#106449, CHAMP_PMSI#106423 AS COLL9#106450, UNIT_PATH#106424 AS COLL10#106451, EMERGENCY#106427 AS COLL11#106452, CANCELED#106426 AS COLL12#106453]
(6) Project
Arguments: [COLL0#106441 AS COLL0#106467, COLL1#106442 AS COLL1#106468, COLL2#106443 AS COLL2#106469, COLL3#106444 AS COLL3#106470, COLL4#106445 AS COLL4#106471, COLL5#106446 AS COLL5#106472, COLL6#106447 AS COLL6#106473, COLL7#106448 AS COLL7#106474, COLL8#106449 AS COLL8#106475, COLL9#106450 AS COLL9#106476, COLL10#106451 AS COLL10#106477, COLL11#106452 AS COLL11#106478, COLL12#106453 AS COLL12#106479]
(7) Project
Arguments: [COLL0#106467, COLL1#106468, COLL2#106469, COLL3#106470, COLL4#106471, COLL5#106472, COLL6#106473, COLL7#106474, COLL8#106475, COLL9#106476, COLL10#106477, COLL11#106478, COLL12#106479]
(8) Project
Arguments: [cast(COLL12#106479 as int) AS CANCELED_3355#106506, COLL9#106476 AS CHAMP_PMSI_3352#106507, COLL11#106478 AS EMERGENCY_3354#106508, COLL2#106469 AS IN_DATE_3345#106509, COLL4#106471 AS IN_MODE_3347#106510, COLL6#106473 AS IN_UNIT_3349#106511, COLL3#106470 AS OUT_DATE_3346#106512, COLL5#106472 AS OUT_MODE_3348#106513, COLL7#106474 AS OUT_UNIT_3350#106514, COLL1#106468 AS PATIENT_ID_3344#106515, COLL10#106477 AS UNIT_PATH_3353#106516, COLL0#106467 AS VISIT_ID_3343#106517, COLL8#106475 AS VISIT_TYPE_3351#106518]
(9) Project
Arguments: [CANCELED_3355#106506, CHAMP_PMSI_3352#106507, EMERGENCY_3354#106508, IN_DATE_3345#106509, IN_MODE_3347#106510, IN_UNIT_3349#106511, OUT_DATE_3346#106512, OUT_MODE_3348#106513, OUT_UNIT_3350#106514, PATIENT_ID_3344#106515, UNIT_PATH_3353#106516, VISIT_ID_3343#106517, VISIT_TYPE_3351#106518, str_encrypt(VISIT_ID_3343#106517) AS ENCRYPT_3536#106532]