== 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_3342163`, 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)#114448, RAWTOHEX(PATIENT_ID)#114449, IN_DATE#114450, OUT_DATE#114451, IN_MODE#114452, OUT_MODE#114453, IN_UNIT#114454, OUT_UNIT#114455, VISIT_TYPE#114456, CHAMP_PMSI#114457, UNIT_PATH#114458, EMERGENCY#114459, CANCELED#114460], false
(4) Project
Arguments: [RAWTOHEX(VISIT_ID)#114448, RAWTOHEX(PATIENT_ID)#114449, IN_DATE#114450, OUT_DATE#114451, IN_MODE#114452, OUT_MODE#114453, IN_UNIT#114454, OUT_UNIT#114455, VISIT_TYPE#114456, CHAMP_PMSI#114457, UNIT_PATH#114458, staticinvoke(class org.apache.spark.sql.catalyst.util.CharVarcharCodegenUtils, StringType, readSidePadding, EMERGENCY#114459, 1, true, false, true) AS EMERGENCY#114461, CANCELED#114460]
(5) Project
Arguments: [RAWTOHEX(VISIT_ID)#114448 AS COLL0#114475, RAWTOHEX(PATIENT_ID)#114449 AS COLL1#114476, IN_DATE#114450 AS COLL2#114477, OUT_DATE#114451 AS COLL3#114478, IN_MODE#114452 AS COLL4#114479, OUT_MODE#114453 AS COLL5#114480, IN_UNIT#114454 AS COLL6#114481, OUT_UNIT#114455 AS COLL7#114482, VISIT_TYPE#114456 AS COLL8#114483, CHAMP_PMSI#114457 AS COLL9#114484, UNIT_PATH#114458 AS COLL10#114485, EMERGENCY#114461 AS COLL11#114486, CANCELED#114460 AS COLL12#114487]
(6) Project
Arguments: [COLL0#114475 AS COLL0#114501, COLL1#114476 AS COLL1#114502, COLL2#114477 AS COLL2#114503, COLL3#114478 AS COLL3#114504, COLL4#114479 AS COLL4#114505, COLL5#114480 AS COLL5#114506, COLL6#114481 AS COLL6#114507, COLL7#114482 AS COLL7#114508, COLL8#114483 AS COLL8#114509, COLL9#114484 AS COLL9#114510, COLL10#114485 AS COLL10#114511, COLL11#114486 AS COLL11#114512, COLL12#114487 AS COLL12#114513]
(7) Project
Arguments: [COLL0#114501, COLL1#114502, COLL2#114503, COLL3#114504, COLL4#114505, COLL5#114506, COLL6#114507, COLL7#114508, COLL8#114509, COLL9#114510, COLL10#114511, COLL11#114512, COLL12#114513]
(8) Project
Arguments: [cast(COLL12#114513 as int) AS CANCELED_3355#114540, COLL9#114510 AS CHAMP_PMSI_3352#114541, COLL11#114512 AS EMERGENCY_3354#114542, COLL2#114503 AS IN_DATE_3345#114543, COLL4#114505 AS IN_MODE_3347#114544, COLL6#114507 AS IN_UNIT_3349#114545, COLL3#114504 AS OUT_DATE_3346#114546, COLL5#114506 AS OUT_MODE_3348#114547, COLL7#114508 AS OUT_UNIT_3350#114548, COLL1#114502 AS PATIENT_ID_3344#114549, COLL10#114511 AS UNIT_PATH_3353#114550, COLL0#114501 AS VISIT_ID_3343#114551, COLL8#114509 AS VISIT_TYPE_3351#114552]
(9) Project
Arguments: [CANCELED_3355#114540, CHAMP_PMSI_3352#114541, EMERGENCY_3354#114542, IN_DATE_3345#114543, IN_MODE_3347#114544, IN_UNIT_3349#114545, OUT_DATE_3346#114546, OUT_MODE_3348#114547, OUT_UNIT_3350#114548, PATIENT_ID_3344#114549, UNIT_PATH_3353#114550, VISIT_ID_3343#114551, VISIT_TYPE_3351#114552, str_encrypt(VISIT_ID_3343#114551) AS ENCRYPT_3536#114566]