== 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_3399163`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [CANCELED_3355#15970, CHAMP_PMSI_3352#15971, EMERGENCY_3354#15972, IN_DATE_3345#15973, IN_MODE_3347#15974, IN_UNIT_3349#15975, OUT_DATE_3346#15976, OUT_MODE_3348#15977, OUT_UNIT_3350#15978, PATIENT_ID_3344#15979, UNIT_PATH_3353#15980, VISIT_ID_3343#15981, VISIT_TYPE_3351#15982], false
(4) Project
Arguments: [CANCELED_3355#15970, CHAMP_PMSI_3352#15971, staticinvoke(class org.apache.spark.sql.catalyst.util.CharVarcharCodegenUtils, StringType, readSidePadding, EMERGENCY_3354#15972, 1, true, false, true) AS EMERGENCY_3354#15983, IN_DATE_3345#15973, IN_MODE_3347#15974, IN_UNIT_3349#15975, OUT_DATE_3346#15976, OUT_MODE_3348#15977, OUT_UNIT_3350#15978, PATIENT_ID_3344#15979, UNIT_PATH_3353#15980, VISIT_ID_3343#15981, VISIT_TYPE_3351#15982]
(5) View
Arguments: `VISIT_3342163`, true
(6) SubqueryAlias
Arguments: VISIT_3342163
(7) Project
Arguments: [CANCELED_3355#15970 AS VISIT_3342_CANCELED_3355#16014, CHAMP_PMSI_3352#15971 AS VISIT_3342_CHAMP_PMSI_3352#16015, EMERGENCY_3354#15983 AS VISIT_3342_EMERGENCY_3354#16016, IN_DATE_3345#15973 AS VISIT_3342_IN_DATE_3345#16017, IN_MODE_3347#15974 AS VISIT_3342_IN_MODE_3347#16018, IN_UNIT_3349#15975 AS VISIT_3342_IN_UNIT_3349#16019, OUT_DATE_3346#15976 AS VISIT_3342_OUT_DATE_3346#16020, OUT_MODE_3348#15977 AS VISIT_3342_OUT_MODE_3348#16021, OUT_UNIT_3350#15978 AS VISIT_3342_OUT_UNIT_3350#16022, PATIENT_ID_3344#15979 AS VISIT_3342_PATIENT_ID_3344#16023, UNIT_PATH_3353#15980 AS VISIT_3342_UNIT_PATH_3353#16024, VISIT_ID_3343#15981 AS VISIT_3342_VISIT_ID_3343#16025, VISIT_TYPE_3351#15982 AS VISIT_3342_VISIT_TYPE_3351#16026]
(8) Project
Arguments: [cast(VISIT_3342_VISIT_ID_3343#16025 as string) AS COL_EEA9697B_DB68_4A22_8733_70F35E85FA8C#16053, cast(VISIT_3342_PATIENT_ID_3344#16023 as string) AS COL_8859F9BF_E9D0_49C6_AD56_9C140D4C38A1#16054, cast(VISIT_3342_IN_DATE_3345#16017 as timestamp) AS COL_AA4B3BC4_44A1_47D3_AC4B_C41D5CB3B3E9#16055, cast(VISIT_3342_OUT_DATE_3346#16020 as timestamp) AS COL_F89F7AFE_9225_468C_A09B_7E0D4F0CD71B#16056, cast(VISIT_3342_IN_MODE_3347#16018 as string) AS COL_058F9F93_2D83_40ED_B3F6_4CAE6CD3C909#16057, cast(VISIT_3342_OUT_MODE_3348#16021 as string) AS COL_6514FE18_2F15_46F7_BE9B_8C8A1CDED5B0#16058, cast(VISIT_3342_IN_UNIT_3349#16019 as string) AS COL_0C85CE96_902F_49B0_8699_B1D8041E9741#16059, cast(VISIT_3342_OUT_UNIT_3350#16022 as string) AS COL_93D07A84_DAB1_4601_8776_58638D68C63B#16060, cast(VISIT_3342_VISIT_TYPE_3351#16026 as string) AS COL_69F7D2CB_3582_450F_B81C_F35E14BD2F3A#16061, cast(VISIT_3342_CHAMP_PMSI_3352#16015 as string) AS COL_8DD6299D_F88E_4923_BA4A_AA5963BBA243#16062, cast(VISIT_3342_UNIT_PATH_3353#16024 as string) AS COL_8F292832_9A81_4CB6_A3E8_AAF5E0E2B9D1#16063, cast(VISIT_3342_EMERGENCY_3354#16016 as string) AS COL_119B8687_79BA_47AC_A253_99B3F514F94F#16064, cast(VISIT_3342_CANCELED_3355#16014 as int) AS COL_7A51C905_886C_4162_94AE_BCBA7820952A#16065]
(9) Project
Arguments: [COL_EEA9697B_DB68_4A22_8733_70F35E85FA8C#16053 AS COL_EEA9697B_DB68_4A22_8733_70F35E85FA8C#16079, COL_8859F9BF_E9D0_49C6_AD56_9C140D4C38A1#16054 AS COL_8859F9BF_E9D0_49C6_AD56_9C140D4C38A1#16080, COL_AA4B3BC4_44A1_47D3_AC4B_C41D5CB3B3E9#16055 AS COL_AA4B3BC4_44A1_47D3_AC4B_C41D5CB3B3E9#16081, COL_F89F7AFE_9225_468C_A09B_7E0D4F0CD71B#16056 AS COL_F89F7AFE_9225_468C_A09B_7E0D4F0CD71B#16082, COL_058F9F93_2D83_40ED_B3F6_4CAE6CD3C909#16057 AS COL_058F9F93_2D83_40ED_B3F6_4CAE6CD3C909#16083, COL_6514FE18_2F15_46F7_BE9B_8C8A1CDED5B0#16058 AS COL_6514FE18_2F15_46F7_BE9B_8C8A1CDED5B0#16084, COL_0C85CE96_902F_49B0_8699_B1D8041E9741#16059 AS COL_0C85CE96_902F_49B0_8699_B1D8041E9741#16085, COL_93D07A84_DAB1_4601_8776_58638D68C63B#16060 AS COL_93D07A84_DAB1_4601_8776_58638D68C63B#16086, COL_69F7D2CB_3582_450F_B81C_F35E14BD2F3A#16061 AS COL_69F7D2CB_3582_450F_B81C_F35E14BD2F3A#16087, COL_8DD6299D_F88E_4923_BA4A_AA5963BBA243#16062 AS COL_8DD6299D_F88E_4923_BA4A_AA5963BBA243#16088, COL_8F292832_9A81_4CB6_A3E8_AAF5E0E2B9D1#16063 AS COL_8F292832_9A81_4CB6_A3E8_AAF5E0E2B9D1#16089, COL_119B8687_79BA_47AC_A253_99B3F514F94F#16064 AS COL_119B8687_79BA_47AC_A253_99B3F514F94F#16090, COL_7A51C905_886C_4162_94AE_BCBA7820952A#16065 AS COL_7A51C905_886C_4162_94AE_BCBA7820952A#16091]
(10) Project
Arguments: [COL_EEA9697B_DB68_4A22_8733_70F35E85FA8C#16079, COL_8859F9BF_E9D0_49C6_AD56_9C140D4C38A1#16080, COL_AA4B3BC4_44A1_47D3_AC4B_C41D5CB3B3E9#16081, COL_F89F7AFE_9225_468C_A09B_7E0D4F0CD71B#16082, COL_058F9F93_2D83_40ED_B3F6_4CAE6CD3C909#16083, COL_6514FE18_2F15_46F7_BE9B_8C8A1CDED5B0#16084, COL_0C85CE96_902F_49B0_8699_B1D8041E9741#16085, COL_93D07A84_DAB1_4601_8776_58638D68C63B#16086, COL_69F7D2CB_3582_450F_B81C_F35E14BD2F3A#16087, COL_8DD6299D_F88E_4923_BA4A_AA5963BBA243#16088, COL_8F292832_9A81_4CB6_A3E8_AAF5E0E2B9D1#16089, COL_119B8687_79BA_47AC_A253_99B3F514F94F#16090, COL_7A51C905_886C_4162_94AE_BCBA7820952A#16091, str_join(array(COL_0C85CE96_902F_49B0_8699_B1D8041E9741#16085, COL_93D07A84_DAB1_4601_8776_58638D68C63B#16086), cast(> as string)) AS COL_163AB4E6_D7B0_4397_BF6B_992AF7938586#16105]
(11) Project
Arguments: [COL_EEA9697B_DB68_4A22_8733_70F35E85FA8C#16079 AS COL_EEA9697B_DB68_4A22_8733_70F35E85FA8C#16127, COL_8859F9BF_E9D0_49C6_AD56_9C140D4C38A1#16080 AS COL_8859F9BF_E9D0_49C6_AD56_9C140D4C38A1#16128, COL_AA4B3BC4_44A1_47D3_AC4B_C41D5CB3B3E9#16081 AS COL_AA4B3BC4_44A1_47D3_AC4B_C41D5CB3B3E9#16129, COL_F89F7AFE_9225_468C_A09B_7E0D4F0CD71B#16082 AS COL_F89F7AFE_9225_468C_A09B_7E0D4F0CD71B#16130, COL_058F9F93_2D83_40ED_B3F6_4CAE6CD3C909#16083 AS COL_058F9F93_2D83_40ED_B3F6_4CAE6CD3C909#16131, COL_6514FE18_2F15_46F7_BE9B_8C8A1CDED5B0#16084 AS COL_6514FE18_2F15_46F7_BE9B_8C8A1CDED5B0#16132, COL_0C85CE96_902F_49B0_8699_B1D8041E9741#16085 AS COL_0C85CE96_902F_49B0_8699_B1D8041E9741#16133, COL_93D07A84_DAB1_4601_8776_58638D68C63B#16086 AS COL_93D07A84_DAB1_4601_8776_58638D68C63B#16134, COL_69F7D2CB_3582_450F_B81C_F35E14BD2F3A#16087 AS COL_69F7D2CB_3582_450F_B81C_F35E14BD2F3A#16135, COL_8DD6299D_F88E_4923_BA4A_AA5963BBA243#16088 AS COL_8DD6299D_F88E_4923_BA4A_AA5963BBA243#16136, COL_8F292832_9A81_4CB6_A3E8_AAF5E0E2B9D1#16089 AS COL_8F292832_9A81_4CB6_A3E8_AAF5E0E2B9D1#16137, COL_119B8687_79BA_47AC_A253_99B3F514F94F#16090 AS COL_119B8687_79BA_47AC_A253_99B3F514F94F#16138, COL_7A51C905_886C_4162_94AE_BCBA7820952A#16091 AS COL_7A51C905_886C_4162_94AE_BCBA7820952A#16139, COL_163AB4E6_D7B0_4397_BF6B_992AF7938586#16105 AS COL_163AB4E6_D7B0_4397_BF6B_992AF7938586#16140]