== 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)#106692, RAWTOHEX(PATIENT_ID)#106693, IN_DATE#106694, OUT_DATE#106695, IN_MODE#106696, OUT_MODE#106697, IN_UNIT#106698, OUT_UNIT#106699, VISIT_TYPE#106700, CHAMP_PMSI#106701, UNIT_PATH#106702, EMERGENCY#106703, CANCELED#106704], false
(4) Project
Arguments: [RAWTOHEX(VISIT_ID)#106692, RAWTOHEX(PATIENT_ID)#106693, IN_DATE#106694, OUT_DATE#106695, IN_MODE#106696, OUT_MODE#106697, IN_UNIT#106698, OUT_UNIT#106699, VISIT_TYPE#106700, CHAMP_PMSI#106701, UNIT_PATH#106702, staticinvoke(class org.apache.spark.sql.catalyst.util.CharVarcharCodegenUtils, StringType, readSidePadding, EMERGENCY#106703, 1, true, false, true) AS EMERGENCY#106705, CANCELED#106704]
(5) Project
Arguments: [RAWTOHEX(VISIT_ID)#106692 AS COLL0#106719, RAWTOHEX(PATIENT_ID)#106693 AS COLL1#106720, IN_DATE#106694 AS COLL2#106721, OUT_DATE#106695 AS COLL3#106722, IN_MODE#106696 AS COLL4#106723, OUT_MODE#106697 AS COLL5#106724, IN_UNIT#106698 AS COLL6#106725, OUT_UNIT#106699 AS COLL7#106726, VISIT_TYPE#106700 AS COLL8#106727, CHAMP_PMSI#106701 AS COLL9#106728, UNIT_PATH#106702 AS COLL10#106729, EMERGENCY#106705 AS COLL11#106730, CANCELED#106704 AS COLL12#106731]
(6) Project
Arguments: [COLL0#106719 AS COLL0#106745, COLL1#106720 AS COLL1#106746, COLL2#106721 AS COLL2#106747, COLL3#106722 AS COLL3#106748, COLL4#106723 AS COLL4#106749, COLL5#106724 AS COLL5#106750, COLL6#106725 AS COLL6#106751, COLL7#106726 AS COLL7#106752, COLL8#106727 AS COLL8#106753, COLL9#106728 AS COLL9#106754, COLL10#106729 AS COLL10#106755, COLL11#106730 AS COLL11#106756, COLL12#106731 AS COLL12#106757]
(7) Project
Arguments: [COLL0#106745, COLL1#106746, COLL2#106747, COLL3#106748, COLL4#106749, COLL5#106750, COLL6#106751, COLL7#106752, COLL8#106753, COLL9#106754, COLL10#106755, COLL11#106756, COLL12#106757]
(8) Project
Arguments: [cast(COLL12#106757 as int) AS CANCELED_3355#106784, COLL9#106754 AS CHAMP_PMSI_3352#106785, COLL11#106756 AS EMERGENCY_3354#106786, COLL2#106747 AS IN_DATE_3345#106787, COLL4#106749 AS IN_MODE_3347#106788, COLL6#106751 AS IN_UNIT_3349#106789, COLL3#106748 AS OUT_DATE_3346#106790, COLL5#106750 AS OUT_MODE_3348#106791, COLL7#106752 AS OUT_UNIT_3350#106792, COLL1#106746 AS PATIENT_ID_3344#106793, COLL10#106755 AS UNIT_PATH_3353#106794, COLL0#106745 AS VISIT_ID_3343#106795, COLL8#106753 AS VISIT_TYPE_3351#106796]
(9) Project
Arguments: [CANCELED_3355#106784, CHAMP_PMSI_3352#106785, EMERGENCY_3354#106786, IN_DATE_3345#106787, IN_MODE_3347#106788, IN_UNIT_3349#106789, OUT_DATE_3346#106790, OUT_MODE_3348#106791, OUT_UNIT_3350#106792, PATIENT_ID_3344#106793, UNIT_PATH_3353#106794, VISIT_ID_3343#106795, VISIT_TYPE_3351#106796, str_encrypt(VISIT_ID_3343#106795) AS ENCRYPT_3536#106810]