== 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)#113952, RAWTOHEX(PATIENT_ID)#113953, IN_DATE#113954, OUT_DATE#113955, IN_MODE#113956, OUT_MODE#113957, IN_UNIT#113958, OUT_UNIT#113959, VISIT_TYPE#113960, CHAMP_PMSI#113961, UNIT_PATH#113962, EMERGENCY#113963, CANCELED#113964], false
(4) Project
Arguments: [RAWTOHEX(VISIT_ID)#113952, RAWTOHEX(PATIENT_ID)#113953, IN_DATE#113954, OUT_DATE#113955, IN_MODE#113956, OUT_MODE#113957, IN_UNIT#113958, OUT_UNIT#113959, VISIT_TYPE#113960, CHAMP_PMSI#113961, UNIT_PATH#113962, staticinvoke(class org.apache.spark.sql.catalyst.util.CharVarcharCodegenUtils, StringType, readSidePadding, EMERGENCY#113963, 1, true, false, true) AS EMERGENCY#113965, CANCELED#113964]
(5) Project
Arguments: [RAWTOHEX(VISIT_ID)#113952 AS COLL0#113979, RAWTOHEX(PATIENT_ID)#113953 AS COLL1#113980, IN_DATE#113954 AS COLL2#113981, OUT_DATE#113955 AS COLL3#113982, IN_MODE#113956 AS COLL4#113983, OUT_MODE#113957 AS COLL5#113984, IN_UNIT#113958 AS COLL6#113985, OUT_UNIT#113959 AS COLL7#113986, VISIT_TYPE#113960 AS COLL8#113987, CHAMP_PMSI#113961 AS COLL9#113988, UNIT_PATH#113962 AS COLL10#113989, EMERGENCY#113965 AS COLL11#113990, CANCELED#113964 AS COLL12#113991]
(6) Project
Arguments: [COLL0#113979 AS COLL0#114005, COLL1#113980 AS COLL1#114006, COLL2#113981 AS COLL2#114007, COLL3#113982 AS COLL3#114008, COLL4#113983 AS COLL4#114009, COLL5#113984 AS COLL5#114010, COLL6#113985 AS COLL6#114011, COLL7#113986 AS COLL7#114012, COLL8#113987 AS COLL8#114013, COLL9#113988 AS COLL9#114014, COLL10#113989 AS COLL10#114015, COLL11#113990 AS COLL11#114016, COLL12#113991 AS COLL12#114017]
(7) Project
Arguments: [COLL0#114005, COLL1#114006, COLL2#114007, COLL3#114008, COLL4#114009, COLL5#114010, COLL6#114011, COLL7#114012, COLL8#114013, COLL9#114014, COLL10#114015, COLL11#114016, COLL12#114017]
(8) Project
Arguments: [cast(COLL12#114017 as int) AS CANCELED_3355#114044, COLL9#114014 AS CHAMP_PMSI_3352#114045, COLL11#114016 AS EMERGENCY_3354#114046, COLL2#114007 AS IN_DATE_3345#114047, COLL4#114009 AS IN_MODE_3347#114048, COLL6#114011 AS IN_UNIT_3349#114049, COLL3#114008 AS OUT_DATE_3346#114050, COLL5#114010 AS OUT_MODE_3348#114051, COLL7#114012 AS OUT_UNIT_3350#114052, COLL1#114006 AS PATIENT_ID_3344#114053, COLL10#114015 AS UNIT_PATH_3353#114054, COLL0#114005 AS VISIT_ID_3343#114055, COLL8#114013 AS VISIT_TYPE_3351#114056]
(9) Project
Arguments: [CANCELED_3355#114044, CHAMP_PMSI_3352#114045, EMERGENCY_3354#114046, IN_DATE_3345#114047, IN_MODE_3347#114048, IN_UNIT_3349#114049, OUT_DATE_3346#114050, OUT_MODE_3348#114051, OUT_UNIT_3350#114052, PATIENT_ID_3344#114053, UNIT_PATH_3353#114054, VISIT_ID_3343#114055, VISIT_TYPE_3351#114056, str_encrypt(VISIT_ID_3343#114055) AS ENCRYPT_3536#114070]