== 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_3342162`, 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)#114944, RAWTOHEX(PATIENT_ID)#114945, IN_DATE#114946, OUT_DATE#114947, IN_MODE#114948, OUT_MODE#114949, IN_UNIT#114950, OUT_UNIT#114951, VISIT_TYPE#114952, CHAMP_PMSI#114953, UNIT_PATH#114954, EMERGENCY#114955, CANCELED#114956], false
(4) Project
Arguments: [RAWTOHEX(VISIT_ID)#114944, RAWTOHEX(PATIENT_ID)#114945, IN_DATE#114946, OUT_DATE#114947, IN_MODE#114948, OUT_MODE#114949, IN_UNIT#114950, OUT_UNIT#114951, VISIT_TYPE#114952, CHAMP_PMSI#114953, UNIT_PATH#114954, staticinvoke(class org.apache.spark.sql.catalyst.util.CharVarcharCodegenUtils, StringType, readSidePadding, EMERGENCY#114955, 1, true, false, true) AS EMERGENCY#114957, CANCELED#114956]
(5) Project
Arguments: [RAWTOHEX(VISIT_ID)#114944 AS COLL0#114971, RAWTOHEX(PATIENT_ID)#114945 AS COLL1#114972, IN_DATE#114946 AS COLL2#114973, OUT_DATE#114947 AS COLL3#114974, IN_MODE#114948 AS COLL4#114975, OUT_MODE#114949 AS COLL5#114976, IN_UNIT#114950 AS COLL6#114977, OUT_UNIT#114951 AS COLL7#114978, VISIT_TYPE#114952 AS COLL8#114979, CHAMP_PMSI#114953 AS COLL9#114980, UNIT_PATH#114954 AS COLL10#114981, EMERGENCY#114957 AS COLL11#114982, CANCELED#114956 AS COLL12#114983]
(6) Project
Arguments: [COLL0#114971 AS COLL0#114997, COLL1#114972 AS COLL1#114998, COLL2#114973 AS COLL2#114999, COLL3#114974 AS COLL3#115000, COLL4#114975 AS COLL4#115001, COLL5#114976 AS COLL5#115002, COLL6#114977 AS COLL6#115003, COLL7#114978 AS COLL7#115004, COLL8#114979 AS COLL8#115005, COLL9#114980 AS COLL9#115006, COLL10#114981 AS COLL10#115007, COLL11#114982 AS COLL11#115008, COLL12#114983 AS COLL12#115009]
(7) Project
Arguments: [COLL0#114997, COLL1#114998, COLL2#114999, COLL3#115000, COLL4#115001, COLL5#115002, COLL6#115003, COLL7#115004, COLL8#115005, COLL9#115006, COLL10#115007, COLL11#115008, COLL12#115009]
(8) Project
Arguments: [cast(COLL12#115009 as int) AS CANCELED_3355#115036, COLL9#115006 AS CHAMP_PMSI_3352#115037, COLL11#115008 AS EMERGENCY_3354#115038, COLL2#114999 AS IN_DATE_3345#115039, COLL4#115001 AS IN_MODE_3347#115040, COLL6#115003 AS IN_UNIT_3349#115041, COLL3#115000 AS OUT_DATE_3346#115042, COLL5#115002 AS OUT_MODE_3348#115043, COLL7#115004 AS OUT_UNIT_3350#115044, COLL1#114998 AS PATIENT_ID_3344#115045, COLL10#115007 AS UNIT_PATH_3353#115046, COLL0#114997 AS VISIT_ID_3343#115047, COLL8#115005 AS VISIT_TYPE_3351#115048]
(9) Project
Arguments: [CANCELED_3355#115036, CHAMP_PMSI_3352#115037, EMERGENCY_3354#115038, IN_DATE_3345#115039, IN_MODE_3347#115040, IN_UNIT_3349#115041, OUT_DATE_3346#115042, OUT_MODE_3348#115043, OUT_UNIT_3350#115044, PATIENT_ID_3344#115045, UNIT_PATH_3353#115046, VISIT_ID_3343#115047, VISIT_TYPE_3351#115048, str_encrypt(VISIT_ID_3343#115047) AS ENCRYPT_3536#115062]