== 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)#108402, RAWTOHEX(PATIENT_ID)#108403, IN_DATE#108404, OUT_DATE#108405, IN_MODE#108406, OUT_MODE#108407, IN_UNIT#108408, OUT_UNIT#108409, VISIT_TYPE#108410, CHAMP_PMSI#108411, UNIT_PATH#108412, EMERGENCY#108413, CANCELED#108414], false
(4) Project
Arguments: [RAWTOHEX(VISIT_ID)#108402, RAWTOHEX(PATIENT_ID)#108403, IN_DATE#108404, OUT_DATE#108405, IN_MODE#108406, OUT_MODE#108407, IN_UNIT#108408, OUT_UNIT#108409, VISIT_TYPE#108410, CHAMP_PMSI#108411, UNIT_PATH#108412, staticinvoke(class org.apache.spark.sql.catalyst.util.CharVarcharCodegenUtils, StringType, readSidePadding, EMERGENCY#108413, 1, true, false, true) AS EMERGENCY#108415, CANCELED#108414]
(5) Project
Arguments: [RAWTOHEX(VISIT_ID)#108402 AS COLL0#108429, RAWTOHEX(PATIENT_ID)#108403 AS COLL1#108430, IN_DATE#108404 AS COLL2#108431, OUT_DATE#108405 AS COLL3#108432, IN_MODE#108406 AS COLL4#108433, OUT_MODE#108407 AS COLL5#108434, IN_UNIT#108408 AS COLL6#108435, OUT_UNIT#108409 AS COLL7#108436, VISIT_TYPE#108410 AS COLL8#108437, CHAMP_PMSI#108411 AS COLL9#108438, UNIT_PATH#108412 AS COLL10#108439, EMERGENCY#108415 AS COLL11#108440, CANCELED#108414 AS COLL12#108441]
(6) Project
Arguments: [COLL0#108429 AS COLL0#108455, COLL1#108430 AS COLL1#108456, COLL2#108431 AS COLL2#108457, COLL3#108432 AS COLL3#108458, COLL4#108433 AS COLL4#108459, COLL5#108434 AS COLL5#108460, COLL6#108435 AS COLL6#108461, COLL7#108436 AS COLL7#108462, COLL8#108437 AS COLL8#108463, COLL9#108438 AS COLL9#108464, COLL10#108439 AS COLL10#108465, COLL11#108440 AS COLL11#108466, COLL12#108441 AS COLL12#108467]
(7) Project
Arguments: [COLL0#108455, COLL1#108456, COLL2#108457, COLL3#108458, COLL4#108459, COLL5#108460, COLL6#108461, COLL7#108462, COLL8#108463, COLL9#108464, COLL10#108465, COLL11#108466, COLL12#108467]
(8) Project
Arguments: [cast(COLL12#108467 as int) AS CANCELED_3355#108494, COLL9#108464 AS CHAMP_PMSI_3352#108495, COLL11#108466 AS EMERGENCY_3354#108496, COLL2#108457 AS IN_DATE_3345#108497, COLL4#108459 AS IN_MODE_3347#108498, COLL6#108461 AS IN_UNIT_3349#108499, COLL3#108458 AS OUT_DATE_3346#108500, COLL5#108460 AS OUT_MODE_3348#108501, COLL7#108462 AS OUT_UNIT_3350#108502, COLL1#108456 AS PATIENT_ID_3344#108503, COLL10#108465 AS UNIT_PATH_3353#108504, COLL0#108455 AS VISIT_ID_3343#108505, COLL8#108463 AS VISIT_TYPE_3351#108506]
(9) Project
Arguments: [CANCELED_3355#108494, CHAMP_PMSI_3352#108495, EMERGENCY_3354#108496, IN_DATE_3345#108497, IN_MODE_3347#108498, IN_UNIT_3349#108499, OUT_DATE_3346#108500, OUT_MODE_3348#108501, OUT_UNIT_3350#108502, PATIENT_ID_3344#108503, UNIT_PATH_3353#108504, VISIT_ID_3343#108505, VISIT_TYPE_3351#108506, str_encrypt(VISIT_ID_3343#108505) AS ENCRYPT_3536#108520]