== Physical Plan ==
Execute CreateViewCommand (1)
+- CreateViewCommand (2)
+- Project (11)
+- Project (10)
+- Project (9)
+- Project (8)
+- Project (7)
+- SubqueryAlias (6)
+- View (5)
+- Project (4)
+- LogicalRelation (3)
(1) Execute CreateViewCommand
Output: []
(2) CreateViewCommand
Arguments: `VISIT_3399165`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [CANCELED_3355#13040, CHAMP_PMSI_3352#13041, EMERGENCY_3354#13042, IN_DATE_3345#13043, IN_MODE_3347#13044, IN_UNIT_3349#13045, OUT_DATE_3346#13046, OUT_MODE_3348#13047, OUT_UNIT_3350#13048, PATIENT_ID_3344#13049, UNIT_PATH_3353#13050, VISIT_ID_3343#13051, VISIT_TYPE_3351#13052], false
(4) Project
Arguments: [CANCELED_3355#13040, CHAMP_PMSI_3352#13041, staticinvoke(class org.apache.spark.sql.catalyst.util.CharVarcharCodegenUtils, StringType, readSidePadding, EMERGENCY_3354#13042, 1, true, false, true) AS EMERGENCY_3354#13053, IN_DATE_3345#13043, IN_MODE_3347#13044, IN_UNIT_3349#13045, OUT_DATE_3346#13046, OUT_MODE_3348#13047, OUT_UNIT_3350#13048, PATIENT_ID_3344#13049, UNIT_PATH_3353#13050, VISIT_ID_3343#13051, VISIT_TYPE_3351#13052]
(5) View
Arguments: `VISIT_3342165`, true
(6) SubqueryAlias
Arguments: VISIT_3342165
(7) Project
Arguments: [CANCELED_3355#13040 AS VISIT_3342_CANCELED_3355#13080, CHAMP_PMSI_3352#13041 AS VISIT_3342_CHAMP_PMSI_3352#13081, EMERGENCY_3354#13053 AS VISIT_3342_EMERGENCY_3354#13082, IN_DATE_3345#13043 AS VISIT_3342_IN_DATE_3345#13083, IN_MODE_3347#13044 AS VISIT_3342_IN_MODE_3347#13084, IN_UNIT_3349#13045 AS VISIT_3342_IN_UNIT_3349#13085, OUT_DATE_3346#13046 AS VISIT_3342_OUT_DATE_3346#13086, OUT_MODE_3348#13047 AS VISIT_3342_OUT_MODE_3348#13087, OUT_UNIT_3350#13048 AS VISIT_3342_OUT_UNIT_3350#13088, PATIENT_ID_3344#13049 AS VISIT_3342_PATIENT_ID_3344#13089, UNIT_PATH_3353#13050 AS VISIT_3342_UNIT_PATH_3353#13090, VISIT_ID_3343#13051 AS VISIT_3342_VISIT_ID_3343#13091, VISIT_TYPE_3351#13052 AS VISIT_3342_VISIT_TYPE_3351#13092]
(8) Project
Arguments: [cast(VISIT_3342_VISIT_ID_3343#13091 as string) AS COL_EEA9697B_DB68_4A22_8733_70F35E85FA8C#13119, cast(VISIT_3342_PATIENT_ID_3344#13089 as string) AS COL_8859F9BF_E9D0_49C6_AD56_9C140D4C38A1#13120, cast(VISIT_3342_IN_DATE_3345#13083 as timestamp) AS COL_AA4B3BC4_44A1_47D3_AC4B_C41D5CB3B3E9#13121, cast(VISIT_3342_OUT_DATE_3346#13086 as timestamp) AS COL_F89F7AFE_9225_468C_A09B_7E0D4F0CD71B#13122, cast(VISIT_3342_IN_MODE_3347#13084 as string) AS COL_058F9F93_2D83_40ED_B3F6_4CAE6CD3C909#13123, cast(VISIT_3342_OUT_MODE_3348#13087 as string) AS COL_6514FE18_2F15_46F7_BE9B_8C8A1CDED5B0#13124, cast(VISIT_3342_IN_UNIT_3349#13085 as string) AS COL_0C85CE96_902F_49B0_8699_B1D8041E9741#13125, cast(VISIT_3342_OUT_UNIT_3350#13088 as string) AS COL_93D07A84_DAB1_4601_8776_58638D68C63B#13126, cast(VISIT_3342_VISIT_TYPE_3351#13092 as string) AS COL_69F7D2CB_3582_450F_B81C_F35E14BD2F3A#13127, cast(VISIT_3342_CHAMP_PMSI_3352#13081 as string) AS COL_8DD6299D_F88E_4923_BA4A_AA5963BBA243#13128, cast(VISIT_3342_UNIT_PATH_3353#13090 as string) AS COL_8F292832_9A81_4CB6_A3E8_AAF5E0E2B9D1#13129, cast(VISIT_3342_EMERGENCY_3354#13082 as string) AS COL_119B8687_79BA_47AC_A253_99B3F514F94F#13130, cast(VISIT_3342_CANCELED_3355#13080 as int) AS COL_7A51C905_886C_4162_94AE_BCBA7820952A#13131]
(9) Project
Arguments: [COL_EEA9697B_DB68_4A22_8733_70F35E85FA8C#13119 AS COL_EEA9697B_DB68_4A22_8733_70F35E85FA8C#13145, COL_8859F9BF_E9D0_49C6_AD56_9C140D4C38A1#13120 AS COL_8859F9BF_E9D0_49C6_AD56_9C140D4C38A1#13146, COL_AA4B3BC4_44A1_47D3_AC4B_C41D5CB3B3E9#13121 AS COL_AA4B3BC4_44A1_47D3_AC4B_C41D5CB3B3E9#13147, COL_F89F7AFE_9225_468C_A09B_7E0D4F0CD71B#13122 AS COL_F89F7AFE_9225_468C_A09B_7E0D4F0CD71B#13148, COL_058F9F93_2D83_40ED_B3F6_4CAE6CD3C909#13123 AS COL_058F9F93_2D83_40ED_B3F6_4CAE6CD3C909#13149, COL_6514FE18_2F15_46F7_BE9B_8C8A1CDED5B0#13124 AS COL_6514FE18_2F15_46F7_BE9B_8C8A1CDED5B0#13150, COL_0C85CE96_902F_49B0_8699_B1D8041E9741#13125 AS COL_0C85CE96_902F_49B0_8699_B1D8041E9741#13151, COL_93D07A84_DAB1_4601_8776_58638D68C63B#13126 AS COL_93D07A84_DAB1_4601_8776_58638D68C63B#13152, COL_69F7D2CB_3582_450F_B81C_F35E14BD2F3A#13127 AS COL_69F7D2CB_3582_450F_B81C_F35E14BD2F3A#13153, COL_8DD6299D_F88E_4923_BA4A_AA5963BBA243#13128 AS COL_8DD6299D_F88E_4923_BA4A_AA5963BBA243#13154, COL_8F292832_9A81_4CB6_A3E8_AAF5E0E2B9D1#13129 AS COL_8F292832_9A81_4CB6_A3E8_AAF5E0E2B9D1#13155, COL_119B8687_79BA_47AC_A253_99B3F514F94F#13130 AS COL_119B8687_79BA_47AC_A253_99B3F514F94F#13156, COL_7A51C905_886C_4162_94AE_BCBA7820952A#13131 AS COL_7A51C905_886C_4162_94AE_BCBA7820952A#13157]
(10) Project
Arguments: [COL_EEA9697B_DB68_4A22_8733_70F35E85FA8C#13145, COL_8859F9BF_E9D0_49C6_AD56_9C140D4C38A1#13146, COL_AA4B3BC4_44A1_47D3_AC4B_C41D5CB3B3E9#13147, COL_F89F7AFE_9225_468C_A09B_7E0D4F0CD71B#13148, COL_058F9F93_2D83_40ED_B3F6_4CAE6CD3C909#13149, COL_6514FE18_2F15_46F7_BE9B_8C8A1CDED5B0#13150, COL_0C85CE96_902F_49B0_8699_B1D8041E9741#13151, COL_93D07A84_DAB1_4601_8776_58638D68C63B#13152, COL_69F7D2CB_3582_450F_B81C_F35E14BD2F3A#13153, COL_8DD6299D_F88E_4923_BA4A_AA5963BBA243#13154, COL_8F292832_9A81_4CB6_A3E8_AAF5E0E2B9D1#13155, COL_119B8687_79BA_47AC_A253_99B3F514F94F#13156, COL_7A51C905_886C_4162_94AE_BCBA7820952A#13157, str_join(array(COL_0C85CE96_902F_49B0_8699_B1D8041E9741#13151, COL_93D07A84_DAB1_4601_8776_58638D68C63B#13152), cast(> as string)) AS COL_163AB4E6_D7B0_4397_BF6B_992AF7938586#13171]
(11) Project
Arguments: [COL_EEA9697B_DB68_4A22_8733_70F35E85FA8C#13145 AS COL_EEA9697B_DB68_4A22_8733_70F35E85FA8C#13186, COL_8859F9BF_E9D0_49C6_AD56_9C140D4C38A1#13146 AS COL_8859F9BF_E9D0_49C6_AD56_9C140D4C38A1#13187, COL_AA4B3BC4_44A1_47D3_AC4B_C41D5CB3B3E9#13147 AS COL_AA4B3BC4_44A1_47D3_AC4B_C41D5CB3B3E9#13188, COL_F89F7AFE_9225_468C_A09B_7E0D4F0CD71B#13148 AS COL_F89F7AFE_9225_468C_A09B_7E0D4F0CD71B#13189, COL_058F9F93_2D83_40ED_B3F6_4CAE6CD3C909#13149 AS COL_058F9F93_2D83_40ED_B3F6_4CAE6CD3C909#13190, COL_6514FE18_2F15_46F7_BE9B_8C8A1CDED5B0#13150 AS COL_6514FE18_2F15_46F7_BE9B_8C8A1CDED5B0#13191, COL_0C85CE96_902F_49B0_8699_B1D8041E9741#13151 AS COL_0C85CE96_902F_49B0_8699_B1D8041E9741#13192, COL_93D07A84_DAB1_4601_8776_58638D68C63B#13152 AS COL_93D07A84_DAB1_4601_8776_58638D68C63B#13193, COL_69F7D2CB_3582_450F_B81C_F35E14BD2F3A#13153 AS COL_69F7D2CB_3582_450F_B81C_F35E14BD2F3A#13194, COL_8DD6299D_F88E_4923_BA4A_AA5963BBA243#13154 AS COL_8DD6299D_F88E_4923_BA4A_AA5963BBA243#13195, COL_8F292832_9A81_4CB6_A3E8_AAF5E0E2B9D1#13155 AS COL_8F292832_9A81_4CB6_A3E8_AAF5E0E2B9D1#13196, COL_119B8687_79BA_47AC_A253_99B3F514F94F#13156 AS COL_119B8687_79BA_47AC_A253_99B3F514F94F#13197, COL_7A51C905_886C_4162_94AE_BCBA7820952A#13157 AS COL_7A51C905_886C_4162_94AE_BCBA7820952A#13198, COL_163AB4E6_D7B0_4397_BF6B_992AF7938586#13171 AS COL_163AB4E6_D7B0_4397_BF6B_992AF7938586#13199]