== 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)#110014, RAWTOHEX(PATIENT_ID)#110015, IN_DATE#110016, OUT_DATE#110017, IN_MODE#110018, OUT_MODE#110019, IN_UNIT#110020, OUT_UNIT#110021, VISIT_TYPE#110022, CHAMP_PMSI#110023, UNIT_PATH#110024, EMERGENCY#110025, CANCELED#110026], false
(4) Project
Arguments: [RAWTOHEX(VISIT_ID)#110014, RAWTOHEX(PATIENT_ID)#110015, IN_DATE#110016, OUT_DATE#110017, IN_MODE#110018, OUT_MODE#110019, IN_UNIT#110020, OUT_UNIT#110021, VISIT_TYPE#110022, CHAMP_PMSI#110023, UNIT_PATH#110024, staticinvoke(class org.apache.spark.sql.catalyst.util.CharVarcharCodegenUtils, StringType, readSidePadding, EMERGENCY#110025, 1, true, false, true) AS EMERGENCY#110027, CANCELED#110026]
(5) Project
Arguments: [RAWTOHEX(VISIT_ID)#110014 AS COLL0#110041, RAWTOHEX(PATIENT_ID)#110015 AS COLL1#110042, IN_DATE#110016 AS COLL2#110043, OUT_DATE#110017 AS COLL3#110044, IN_MODE#110018 AS COLL4#110045, OUT_MODE#110019 AS COLL5#110046, IN_UNIT#110020 AS COLL6#110047, OUT_UNIT#110021 AS COLL7#110048, VISIT_TYPE#110022 AS COLL8#110049, CHAMP_PMSI#110023 AS COLL9#110050, UNIT_PATH#110024 AS COLL10#110051, EMERGENCY#110027 AS COLL11#110052, CANCELED#110026 AS COLL12#110053]
(6) Project
Arguments: [COLL0#110041 AS COLL0#110067, COLL1#110042 AS COLL1#110068, COLL2#110043 AS COLL2#110069, COLL3#110044 AS COLL3#110070, COLL4#110045 AS COLL4#110071, COLL5#110046 AS COLL5#110072, COLL6#110047 AS COLL6#110073, COLL7#110048 AS COLL7#110074, COLL8#110049 AS COLL8#110075, COLL9#110050 AS COLL9#110076, COLL10#110051 AS COLL10#110077, COLL11#110052 AS COLL11#110078, COLL12#110053 AS COLL12#110079]
(7) Project
Arguments: [COLL0#110067, COLL1#110068, COLL2#110069, COLL3#110070, COLL4#110071, COLL5#110072, COLL6#110073, COLL7#110074, COLL8#110075, COLL9#110076, COLL10#110077, COLL11#110078, COLL12#110079]
(8) Project
Arguments: [cast(COLL12#110079 as int) AS CANCELED_3355#110106, COLL9#110076 AS CHAMP_PMSI_3352#110107, COLL11#110078 AS EMERGENCY_3354#110108, COLL2#110069 AS IN_DATE_3345#110109, COLL4#110071 AS IN_MODE_3347#110110, COLL6#110073 AS IN_UNIT_3349#110111, COLL3#110070 AS OUT_DATE_3346#110112, COLL5#110072 AS OUT_MODE_3348#110113, COLL7#110074 AS OUT_UNIT_3350#110114, COLL1#110068 AS PATIENT_ID_3344#110115, COLL10#110077 AS UNIT_PATH_3353#110116, COLL0#110067 AS VISIT_ID_3343#110117, COLL8#110075 AS VISIT_TYPE_3351#110118]
(9) Project
Arguments: [CANCELED_3355#110106, CHAMP_PMSI_3352#110107, EMERGENCY_3354#110108, IN_DATE_3345#110109, IN_MODE_3347#110110, IN_UNIT_3349#110111, OUT_DATE_3346#110112, OUT_MODE_3348#110113, OUT_UNIT_3350#110114, PATIENT_ID_3344#110115, UNIT_PATH_3353#110116, VISIT_ID_3343#110117, VISIT_TYPE_3351#110118, str_encrypt(VISIT_ID_3343#110117) AS ENCRYPT_3536#110132]