== Physical Plan ==
Execute CreateViewCommand (1)
+- CreateViewCommand (2)
+- Project (13)
+- Project (12)
+- SubqueryAlias (11)
+- View (10)
+- Project (9)
+- Project (8)
+- Project (7)
+- Project (6)
+- Project (5)
+- Project (4)
+- LogicalRelation (3)
(1) Execute CreateViewCommand
Output: []
(2) CreateViewCommand
Arguments: `VISIT_BIS_3537162`, 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]
(10) View
Arguments: `VISIT_3342162`, true
(11) SubqueryAlias
Arguments: VISIT_3342162
(12) Project
Arguments: [CANCELED_3355#115036 AS VISIT_3342_CANCELED_3355#115091, CHAMP_PMSI_3352#115037 AS VISIT_3342_CHAMP_PMSI_3352#115092, EMERGENCY_3354#115038 AS VISIT_3342_EMERGENCY_3354#115093, IN_DATE_3345#115039 AS VISIT_3342_IN_DATE_3345#115094, IN_MODE_3347#115040 AS VISIT_3342_IN_MODE_3347#115095, IN_UNIT_3349#115041 AS VISIT_3342_IN_UNIT_3349#115096, OUT_DATE_3346#115042 AS VISIT_3342_OUT_DATE_3346#115097, OUT_MODE_3348#115043 AS VISIT_3342_OUT_MODE_3348#115098, OUT_UNIT_3350#115044 AS VISIT_3342_OUT_UNIT_3350#115099, PATIENT_ID_3344#115045 AS VISIT_3342_PATIENT_ID_3344#115100, UNIT_PATH_3353#115046 AS VISIT_3342_UNIT_PATH_3353#115101, VISIT_ID_3343#115047 AS VISIT_3342_VISIT_ID_3343#115102, VISIT_TYPE_3351#115048 AS VISIT_3342_VISIT_TYPE_3351#115103, ENCRYPT_3536#115062 AS VISIT_3342_ENCRYPT_3536#115104]
(13) Project
Arguments: [cast(VISIT_3342_VISIT_ID_3343#115102 as string) AS COL_E7A10ED9_1790_4719_B1B6_FAA15D035CB8#115133, cast(VISIT_3342_PATIENT_ID_3344#115100 as string) AS COL_250578DF_CAD1_40F3_8EF7_09E99AC843A0#115134, cast(VISIT_3342_IN_DATE_3345#115094 as timestamp) AS COL_1118E418_5410_4DE3_B805_4EDAFDD340EA#115135, cast(VISIT_3342_OUT_DATE_3346#115097 as timestamp) AS COL_5E4B938E_4D5C_4C99_842D_1433A793DC2F#115136, cast(VISIT_3342_IN_MODE_3347#115095 as string) AS COL_8533859E_CA0E_4D74_9588_09E146E29F8F#115137, cast(VISIT_3342_OUT_MODE_3348#115098 as string) AS COL_BE46E6B4_0114_49AE_A1A6_E69C87926E43#115138, cast(VISIT_3342_IN_UNIT_3349#115096 as string) AS COL_ACB9EBCB_0C1E_40E3_A99A_4BF5582EA889#115139, cast(VISIT_3342_OUT_UNIT_3350#115099 as string) AS COL_C2552693_5E75_4DD5_9F1B_0E8D69029131#115140, cast(VISIT_3342_VISIT_TYPE_3351#115103 as string) AS COL_4492D92E_39F3_4726_8168_27A2C89197CD#115141, cast(VISIT_3342_CHAMP_PMSI_3352#115092 as string) AS COL_216F1184_233D_4FD2_8517_CD7A5EEC298B#115142, cast(VISIT_3342_UNIT_PATH_3353#115101 as string) AS COL_32E4B9FB_0DD4_4A55_8C75_7141B3933E86#115143, cast(VISIT_3342_EMERGENCY_3354#115093 as string) AS COL_A5718A42_16D9_4FB5_AF83_FBC6343B541E#115144, cast(VISIT_3342_CANCELED_3355#115091 as int) AS COL_68D82A2A_6C78_4416_9D7D_02E747AEA1D0#115145, cast(VISIT_3342_ENCRYPT_3536#115104 as string) AS COL_C58C9484_03D4_4E8C_B4E5_78EC80E6265B#115146]