== 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)#110536, RAWTOHEX(PATIENT_ID)#110537, IN_DATE#110538, OUT_DATE#110539, IN_MODE#110540, OUT_MODE#110541, IN_UNIT#110542, OUT_UNIT#110543, VISIT_TYPE#110544, CHAMP_PMSI#110545, UNIT_PATH#110546, EMERGENCY#110547, CANCELED#110548], false
(4) Project
Arguments: [RAWTOHEX(VISIT_ID)#110536, RAWTOHEX(PATIENT_ID)#110537, IN_DATE#110538, OUT_DATE#110539, IN_MODE#110540, OUT_MODE#110541, IN_UNIT#110542, OUT_UNIT#110543, VISIT_TYPE#110544, CHAMP_PMSI#110545, UNIT_PATH#110546, staticinvoke(class org.apache.spark.sql.catalyst.util.CharVarcharCodegenUtils, StringType, readSidePadding, EMERGENCY#110547, 1, true, false, true) AS EMERGENCY#110549, CANCELED#110548]
(5) Project
Arguments: [RAWTOHEX(VISIT_ID)#110536 AS COLL0#110563, RAWTOHEX(PATIENT_ID)#110537 AS COLL1#110564, IN_DATE#110538 AS COLL2#110565, OUT_DATE#110539 AS COLL3#110566, IN_MODE#110540 AS COLL4#110567, OUT_MODE#110541 AS COLL5#110568, IN_UNIT#110542 AS COLL6#110569, OUT_UNIT#110543 AS COLL7#110570, VISIT_TYPE#110544 AS COLL8#110571, CHAMP_PMSI#110545 AS COLL9#110572, UNIT_PATH#110546 AS COLL10#110573, EMERGENCY#110549 AS COLL11#110574, CANCELED#110548 AS COLL12#110575]
(6) Project
Arguments: [COLL0#110563 AS COLL0#110589, COLL1#110564 AS COLL1#110590, COLL2#110565 AS COLL2#110591, COLL3#110566 AS COLL3#110592, COLL4#110567 AS COLL4#110593, COLL5#110568 AS COLL5#110594, COLL6#110569 AS COLL6#110595, COLL7#110570 AS COLL7#110596, COLL8#110571 AS COLL8#110597, COLL9#110572 AS COLL9#110598, COLL10#110573 AS COLL10#110599, COLL11#110574 AS COLL11#110600, COLL12#110575 AS COLL12#110601]
(7) Project
Arguments: [COLL0#110589, COLL1#110590, COLL2#110591, COLL3#110592, COLL4#110593, COLL5#110594, COLL6#110595, COLL7#110596, COLL8#110597, COLL9#110598, COLL10#110599, COLL11#110600, COLL12#110601]
(8) Project
Arguments: [cast(COLL12#110601 as int) AS CANCELED_3355#110628, COLL9#110598 AS CHAMP_PMSI_3352#110629, COLL11#110600 AS EMERGENCY_3354#110630, COLL2#110591 AS IN_DATE_3345#110631, COLL4#110593 AS IN_MODE_3347#110632, COLL6#110595 AS IN_UNIT_3349#110633, COLL3#110592 AS OUT_DATE_3346#110634, COLL5#110594 AS OUT_MODE_3348#110635, COLL7#110596 AS OUT_UNIT_3350#110636, COLL1#110590 AS PATIENT_ID_3344#110637, COLL10#110599 AS UNIT_PATH_3353#110638, COLL0#110589 AS VISIT_ID_3343#110639, COLL8#110597 AS VISIT_TYPE_3351#110640]
(9) Project
Arguments: [CANCELED_3355#110628, CHAMP_PMSI_3352#110629, EMERGENCY_3354#110630, IN_DATE_3345#110631, IN_MODE_3347#110632, IN_UNIT_3349#110633, OUT_DATE_3346#110634, OUT_MODE_3348#110635, OUT_UNIT_3350#110636, PATIENT_ID_3344#110637, UNIT_PATH_3353#110638, VISIT_ID_3343#110639, VISIT_TYPE_3351#110640, str_encrypt(VISIT_ID_3343#110639) AS ENCRYPT_3536#110654]