== 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)#108900, RAWTOHEX(PATIENT_ID)#108901, IN_DATE#108902, OUT_DATE#108903, IN_MODE#108904, OUT_MODE#108905, IN_UNIT#108906, OUT_UNIT#108907, VISIT_TYPE#108908, CHAMP_PMSI#108909, UNIT_PATH#108910, EMERGENCY#108911, CANCELED#108912], false
(4) Project
Arguments: [RAWTOHEX(VISIT_ID)#108900, RAWTOHEX(PATIENT_ID)#108901, IN_DATE#108902, OUT_DATE#108903, IN_MODE#108904, OUT_MODE#108905, IN_UNIT#108906, OUT_UNIT#108907, VISIT_TYPE#108908, CHAMP_PMSI#108909, UNIT_PATH#108910, staticinvoke(class org.apache.spark.sql.catalyst.util.CharVarcharCodegenUtils, StringType, readSidePadding, EMERGENCY#108911, 1, true, false, true) AS EMERGENCY#108913, CANCELED#108912]
(5) Project
Arguments: [RAWTOHEX(VISIT_ID)#108900 AS COLL0#108927, RAWTOHEX(PATIENT_ID)#108901 AS COLL1#108928, IN_DATE#108902 AS COLL2#108929, OUT_DATE#108903 AS COLL3#108930, IN_MODE#108904 AS COLL4#108931, OUT_MODE#108905 AS COLL5#108932, IN_UNIT#108906 AS COLL6#108933, OUT_UNIT#108907 AS COLL7#108934, VISIT_TYPE#108908 AS COLL8#108935, CHAMP_PMSI#108909 AS COLL9#108936, UNIT_PATH#108910 AS COLL10#108937, EMERGENCY#108913 AS COLL11#108938, CANCELED#108912 AS COLL12#108939]
(6) Project
Arguments: [COLL0#108927 AS COLL0#108953, COLL1#108928 AS COLL1#108954, COLL2#108929 AS COLL2#108955, COLL3#108930 AS COLL3#108956, COLL4#108931 AS COLL4#108957, COLL5#108932 AS COLL5#108958, COLL6#108933 AS COLL6#108959, COLL7#108934 AS COLL7#108960, COLL8#108935 AS COLL8#108961, COLL9#108936 AS COLL9#108962, COLL10#108937 AS COLL10#108963, COLL11#108938 AS COLL11#108964, COLL12#108939 AS COLL12#108965]
(7) Project
Arguments: [COLL0#108953, COLL1#108954, COLL2#108955, COLL3#108956, COLL4#108957, COLL5#108958, COLL6#108959, COLL7#108960, COLL8#108961, COLL9#108962, COLL10#108963, COLL11#108964, COLL12#108965]
(8) Project
Arguments: [cast(COLL12#108965 as int) AS CANCELED_3355#108992, COLL9#108962 AS CHAMP_PMSI_3352#108993, COLL11#108964 AS EMERGENCY_3354#108994, COLL2#108955 AS IN_DATE_3345#108995, COLL4#108957 AS IN_MODE_3347#108996, COLL6#108959 AS IN_UNIT_3349#108997, COLL3#108956 AS OUT_DATE_3346#108998, COLL5#108958 AS OUT_MODE_3348#108999, COLL7#108960 AS OUT_UNIT_3350#109000, COLL1#108954 AS PATIENT_ID_3344#109001, COLL10#108963 AS UNIT_PATH_3353#109002, COLL0#108953 AS VISIT_ID_3343#109003, COLL8#108961 AS VISIT_TYPE_3351#109004]
(9) Project
Arguments: [CANCELED_3355#108992, CHAMP_PMSI_3352#108993, EMERGENCY_3354#108994, IN_DATE_3345#108995, IN_MODE_3347#108996, IN_UNIT_3349#108997, OUT_DATE_3346#108998, OUT_MODE_3348#108999, OUT_UNIT_3350#109000, PATIENT_ID_3344#109001, UNIT_PATH_3353#109002, VISIT_ID_3343#109003, VISIT_TYPE_3351#109004, str_encrypt(VISIT_ID_3343#109003) AS ENCRYPT_3536#109018]