== Parsed Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
+- Project [COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#4229 AS COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#4235, COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#4230L AS COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#4236L, COL_39BBB014_7AC3_4E75_A0B3_78A989ACE08E#4231 AS COL_39BBB014_7AC3_4E75_A0B3_78A989ACE08E#4237]
+- Project [COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#4223 AS COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#4229, COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#4224L AS COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#4230L, COL_39BBB014_7AC3_4E75_A0B3_78A989ACE08E#4225 AS COL_39BBB014_7AC3_4E75_A0B3_78A989ACE08E#4231]
+- Project [COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#4215 AS COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#4223, COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#4216L AS COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#4224L, COL_39BBB014_7AC3_4E75_A0B3_78A989ACE08E#4219 AS COL_39BBB014_7AC3_4E75_A0B3_78A989ACE08E#4225]
+- Sort true
+- Project [COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#4215, COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#4216L, str_if_with_rule((COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#4215 <=> cast(1 as int)), cast(Annuler as string), cast(Autres as string)) AS COL_39BBB014_7AC3_4E75_A0B3_78A989ACE08E#4219]
+- Project [COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#4154 AS COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#4215, COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#4155L AS COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#4216L]
+- Project [COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#4122 AS COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#4154, COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#4147L AS COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#4155L]
+- Project [COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#4122, COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#4147L]
+- Aggregate [COL_18AD7666_01D2_4ABD_9679_86105797736C#4062], [COL_18AD7666_01D2_4ABD_9679_86105797736C#4062 AS COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#4122, 1 AS NULL_1#4148, count(COL_83066F8F_DD8F_453E_938F_934128D9E9B9#4056) AS COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#4147L]
+- Project [COL_83066F8F_DD8F_453E_938F_934128D9E9B9#4056, COL_086A629B_840E_4DD2_81F4_BE36CC1C71AF#4057, COL_2E123050_0514_4FA4_8DC9_C024A7A943B6#4058, COL_B0C7FE24_CB98_49DE_BE2A_7B519325B151#4059, COL_7EB61862_07AE_46C5_A762_B62427E6497C#4060, COL_31159F89_02E9_4586_BDE9_BEBF7DE7147B#4061, COL_18AD7666_01D2_4ABD_9679_86105797736C#4062, COL_C0568947_9665_4A70_944C_B06C636DD141#4063, COL_EA9D7951_2501_49E1_89FE_1913B8B33C88#4064, COL_65BD15C1_BCB0_4783_BEBF_8ACC9BAD5995#4065, COL_108BC341_51D9_425D_8F9F_A0D02F617F7B#4066, COL_E4E4C36F_51B4_4845_BA9F_6BA80D9BB3B5#4067, COL_92602840_5907_4BAB_ADD9_1DC40B6C8CAA#4068, COL_7C1592A3_A801_4F55_8D75_A2B260B89054#4069, COL_5B3F8C0A_F174_4503_A717_C646CDFCA597#4070, COL_0474BFA5_7C7E_4F39_8082_D2950F938333#4071, COL_DAF39CF1_AC31_453D_9031_E3C3788CC0EA#4072, COL_F139D9E2_0197_4395_A4D3_B9D38247671D#4073, COL_AC07AFA6_FBCB_4684_AA1E_322B5B13A62A#4074, COL_A01EA7BD_46AF_433E_87CF_47D08BD89F09#4075, COL_12C8C4DF_CE41_4893_8EDB_039AE1A23619#4076, COL_FE57D81E_81C1_4262_ABA9_AC672A72613F#4077]
+- Project [cast(QUALITE_ANOMALI_37460_COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#3985 as string) AS COL_83066F8F_DD8F_453E_938F_934128D9E9B9#4056, cast(QUALITE_ANOMALI_37460_COL_A7E7D68F_B3E4_46B9_BD51_1B1B9A90CF55#3986 as int) AS COL_086A629B_840E_4DD2_81F4_BE36CC1C71AF#4057, cast(QUALITE_ANOMALI_37460_COL_88D2F303_585E_4763_A8BA_B4A82A90D8F1#3987 as int) AS COL_2E123050_0514_4FA4_8DC9_C024A7A943B6#4058, cast(QUALITE_ANOMALI_37460_COL_187EC0AD_22E4_4370_AE9A_63E3CD00AE8C#3988 as int) AS COL_B0C7FE24_CB98_49DE_BE2A_7B519325B151#4059, cast(QUALITE_ANOMALI_37460_COL_D0EE5893_E0DD_499B_A309_6AD9BD8FEC2A#3989 as int) AS COL_7EB61862_07AE_46C5_A762_B62427E6497C#4060, cast(QUALITE_ANOMALI_37460_COL_6CCFACA8_0D70_498B_B125_A70DC40A6C00#3990 as string) AS COL_31159F89_02E9_4586_BDE9_BEBF7DE7147B#4061, cast(QUALITE_ANOMALI_37460_COL_FB931C53_C68F_4BE1_8F92_2F4726DB2BE3#3991 as int) AS COL_18AD7666_01D2_4ABD_9679_86105797736C#4062, cast(QUALITE_ANOMALI_37460_COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#3992 as string) AS COL_C0568947_9665_4A70_944C_B06C636DD141#4063, cast(QUALITE_ANOMALI_37460_COL_1771B7C9_84A4_49CA_89AD_E21CC59F80AC#3993 as string) AS COL_EA9D7951_2501_49E1_89FE_1913B8B33C88#4064, cast(QUALITE_ANOMALI_37460_COL_27299A39_F4ED_4BAA_B6D8_E9E34602F275#3994 as string) AS COL_65BD15C1_BCB0_4783_BEBF_8ACC9BAD5995#4065, cast(QUALITE_ANOMALI_37460_COL_ED0ED18D_F6DD_4C36_B65D_D4312655138C#3995 as int) AS COL_108BC341_51D9_425D_8F9F_A0D02F617F7B#4066, cast(QUALITE_ANOMALI_37460_COL_1E2EDDF0_6F68_4372_81E6_E7D4483B1426#3996 as int) AS COL_E4E4C36F_51B4_4845_BA9F_6BA80D9BB3B5#4067, cast(QUALITE_ANOMALI_37460_COL_D6237111_5F6F_4655_89BD_4363977DD265#3997 as string) AS COL_92602840_5907_4BAB_ADD9_1DC40B6C8CAA#4068, cast(QUALITE_ANOMALI_37460_COL_5954D6BD_E743_4173_BE3A_CCD220954079#3998 as int) AS COL_7C1592A3_A801_4F55_8D75_A2B260B89054#4069, cast(QUALITE_ANOMALI_37460_COL_F5BD5B00_42AC_48E6_AA86_843A2B8200E8#3999 as int) AS COL_5B3F8C0A_F174_4503_A717_C646CDFCA597#4070, cast(QUALITE_ANOMALI_37460_COL_4D2413C6_01B9_4979_8D39_445C4C2D06FF#4000 as string) AS COL_0474BFA5_7C7E_4F39_8082_D2950F938333#4071, cast(QUALITE_ANOMALI_37460_COL_5223D55D_762F_4807_9CED_CCF479B3A227#4001 as int) AS COL_DAF39CF1_AC31_453D_9031_E3C3788CC0EA#4072, cast(QUALITE_ANOMALI_37460_COL_F8ECA8B6_1154_4E3C_AFD9_B77493423FAF#4002 as int) AS COL_F139D9E2_0197_4395_A4D3_B9D38247671D#4073, cast(QUALITE_ANOMALI_37460_COL_F4C9E045_08D4_4CFC_844A_0960BB072DAE#4003 as string) AS COL_AC07AFA6_FBCB_4684_AA1E_322B5B13A62A#4074, cast(QUALITE_ANOMALI_37460_COL_8C575FAD_BF3D_4EBA_AB0D_D9B4A5CF50EF#4004 as int) AS COL_A01EA7BD_46AF_433E_87CF_47D08BD89F09#4075, cast(QUALITE_ANOMALI_37460_COL_21870150_5C07_42CC_BB77_BCA92051856C#4005 as int) AS COL_12C8C4DF_CE41_4893_8EDB_039AE1A23619#4076, cast(QUALITE_ANOMALI_37460_COL_7CCF963F_B46D_40AE_94BC_F7846B290E74#4006 as string) AS COL_FE57D81E_81C1_4262_ABA9_AC672A72613F#4077]
+- Project [COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#3917 AS QUALITE_ANOMALI_37460_COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#3985, COL_A7E7D68F_B3E4_46B9_BD51_1B1B9A90CF55#3918 AS QUALITE_ANOMALI_37460_COL_A7E7D68F_B3E4_46B9_BD51_1B1B9A90CF55#3986, COL_88D2F303_585E_4763_A8BA_B4A82A90D8F1#3919 AS QUALITE_ANOMALI_37460_COL_88D2F303_585E_4763_A8BA_B4A82A90D8F1#3987, COL_187EC0AD_22E4_4370_AE9A_63E3CD00AE8C#3920 AS QUALITE_ANOMALI_37460_COL_187EC0AD_22E4_4370_AE9A_63E3CD00AE8C#3988, COL_D0EE5893_E0DD_499B_A309_6AD9BD8FEC2A#3921 AS QUALITE_ANOMALI_37460_COL_D0EE5893_E0DD_499B_A309_6AD9BD8FEC2A#3989, COL_6CCFACA8_0D70_498B_B125_A70DC40A6C00#3922 AS QUALITE_ANOMALI_37460_COL_6CCFACA8_0D70_498B_B125_A70DC40A6C00#3990, COL_FB931C53_C68F_4BE1_8F92_2F4726DB2BE3#3923 AS QUALITE_ANOMALI_37460_COL_FB931C53_C68F_4BE1_8F92_2F4726DB2BE3#3991, COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#3924 AS QUALITE_ANOMALI_37460_COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#3992, COL_1771B7C9_84A4_49CA_89AD_E21CC59F80AC#3925 AS QUALITE_ANOMALI_37460_COL_1771B7C9_84A4_49CA_89AD_E21CC59F80AC#3993, COL_27299A39_F4ED_4BAA_B6D8_E9E34602F275#3926 AS QUALITE_ANOMALI_37460_COL_27299A39_F4ED_4BAA_B6D8_E9E34602F275#3994, COL_ED0ED18D_F6DD_4C36_B65D_D4312655138C#3927 AS QUALITE_ANOMALI_37460_COL_ED0ED18D_F6DD_4C36_B65D_D4312655138C#3995, COL_1E2EDDF0_6F68_4372_81E6_E7D4483B1426#3928 AS QUALITE_ANOMALI_37460_COL_1E2EDDF0_6F68_4372_81E6_E7D4483B1426#3996, COL_D6237111_5F6F_4655_89BD_4363977DD265#3929 AS QUALITE_ANOMALI_37460_COL_D6237111_5F6F_4655_89BD_4363977DD265#3997, COL_5954D6BD_E743_4173_BE3A_CCD220954079#3930 AS QUALITE_ANOMALI_37460_COL_5954D6BD_E743_4173_BE3A_CCD220954079#3998, COL_F5BD5B00_42AC_48E6_AA86_843A2B8200E8#3931 AS QUALITE_ANOMALI_37460_COL_F5BD5B00_42AC_48E6_AA86_843A2B8200E8#3999, COL_4D2413C6_01B9_4979_8D39_445C4C2D06FF#3932 AS QUALITE_ANOMALI_37460_COL_4D2413C6_01B9_4979_8D39_445C4C2D06FF#4000, COL_5223D55D_762F_4807_9CED_CCF479B3A227#3933 AS QUALITE_ANOMALI_37460_COL_5223D55D_762F_4807_9CED_CCF479B3A227#4001, COL_F8ECA8B6_1154_4E3C_AFD9_B77493423FAF#3934 AS QUALITE_ANOMALI_37460_COL_F8ECA8B6_1154_4E3C_AFD9_B77493423FAF#4002, COL_F4C9E045_08D4_4CFC_844A_0960BB072DAE#3935 AS QUALITE_ANOMALI_37460_COL_F4C9E045_08D4_4CFC_844A_0960BB072DAE#4003, COL_8C575FAD_BF3D_4EBA_AB0D_D9B4A5CF50EF#3936 AS QUALITE_ANOMALI_37460_COL_8C575FAD_BF3D_4EBA_AB0D_D9B4A5CF50EF#4004, COL_21870150_5C07_42CC_BB77_BCA92051856C#3937 AS QUALITE_ANOMALI_37460_COL_21870150_5C07_42CC_BB77_BCA92051856C#4005, COL_7CCF963F_B46D_40AE_94BC_F7846B290E74#3938 AS QUALITE_ANOMALI_37460_COL_7CCF963F_B46D_40AE_94BC_F7846B290E74#4006]
+- SubqueryAlias QUALITE_ANOMALI_37460118
+- Relation[COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#3917,COL_A7E7D68F_B3E4_46B9_BD51_1B1B9A90CF55#3918,COL_88D2F303_585E_4763_A8BA_B4A82A90D8F1#3919,COL_187EC0AD_22E4_4370_AE9A_63E3CD00AE8C#3920,COL_D0EE5893_E0DD_499B_A309_6AD9BD8FEC2A#3921,COL_6CCFACA8_0D70_498B_B125_A70DC40A6C00#3922,COL_FB931C53_C68F_4BE1_8F92_2F4726DB2BE3#3923,COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#3924,COL_1771B7C9_84A4_49CA_89AD_E21CC59F80AC#3925,COL_27299A39_F4ED_4BAA_B6D8_E9E34602F275#3926,COL_ED0ED18D_F6DD_4C36_B65D_D4312655138C#3927,COL_1E2EDDF0_6F68_4372_81E6_E7D4483B1426#3928,COL_D6237111_5F6F_4655_89BD_4363977DD265#3929,COL_5954D6BD_E743_4173_BE3A_CCD220954079#3930,COL_F5BD5B00_42AC_48E6_AA86_843A2B8200E8#3931,COL_4D2413C6_01B9_4979_8D39_445C4C2D06FF#3932,COL_5223D55D_762F_4807_9CED_CCF479B3A227#3933,COL_F8ECA8B6_1154_4E3C_AFD9_B77493423FAF#3934,COL_F4C9E045_08D4_4CFC_844A_0960BB072DAE#3935,COL_8C575FAD_BF3D_4EBA_AB0D_D9B4A5CF50EF#3936,COL_21870150_5C07_42CC_BB77_BCA92051856C#3937,COL_7CCF963F_B46D_40AE_94BC_F7846B290E74#3938] parquet
== Analyzed Logical Plan ==
COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739: int, COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A: bigint, COL_39BBB014_7AC3_4E75_A0B3_78A989ACE08E: string
GlobalLimit 500000
+- LocalLimit 500000
+- Project [COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#4229 AS COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#4235, COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#4230L AS COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#4236L, COL_39BBB014_7AC3_4E75_A0B3_78A989ACE08E#4231 AS COL_39BBB014_7AC3_4E75_A0B3_78A989ACE08E#4237]
+- Project [COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#4223 AS COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#4229, COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#4224L AS COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#4230L, COL_39BBB014_7AC3_4E75_A0B3_78A989ACE08E#4225 AS COL_39BBB014_7AC3_4E75_A0B3_78A989ACE08E#4231]
+- Project [COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#4215 AS COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#4223, COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#4216L AS COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#4224L, COL_39BBB014_7AC3_4E75_A0B3_78A989ACE08E#4219 AS COL_39BBB014_7AC3_4E75_A0B3_78A989ACE08E#4225]
+- Sort true
+- Project [COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#4215, COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#4216L, str_if_with_rule((COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#4215 <=> cast(1 as int)), cast(Annuler as string), cast(Autres as string)) AS COL_39BBB014_7AC3_4E75_A0B3_78A989ACE08E#4219]
+- Project [COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#4154 AS COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#4215, COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#4155L AS COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#4216L]
+- Project [COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#4122 AS COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#4154, COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#4147L AS COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#4155L]
+- Project [COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#4122, COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#4147L]
+- Aggregate [COL_18AD7666_01D2_4ABD_9679_86105797736C#4062], [COL_18AD7666_01D2_4ABD_9679_86105797736C#4062 AS COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#4122, 1 AS NULL_1#4148, count(COL_83066F8F_DD8F_453E_938F_934128D9E9B9#4056) AS COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#4147L]
+- Project [COL_83066F8F_DD8F_453E_938F_934128D9E9B9#4056, COL_086A629B_840E_4DD2_81F4_BE36CC1C71AF#4057, COL_2E123050_0514_4FA4_8DC9_C024A7A943B6#4058, COL_B0C7FE24_CB98_49DE_BE2A_7B519325B151#4059, COL_7EB61862_07AE_46C5_A762_B62427E6497C#4060, COL_31159F89_02E9_4586_BDE9_BEBF7DE7147B#4061, COL_18AD7666_01D2_4ABD_9679_86105797736C#4062, COL_C0568947_9665_4A70_944C_B06C636DD141#4063, COL_EA9D7951_2501_49E1_89FE_1913B8B33C88#4064, COL_65BD15C1_BCB0_4783_BEBF_8ACC9BAD5995#4065, COL_108BC341_51D9_425D_8F9F_A0D02F617F7B#4066, COL_E4E4C36F_51B4_4845_BA9F_6BA80D9BB3B5#4067, COL_92602840_5907_4BAB_ADD9_1DC40B6C8CAA#4068, COL_7C1592A3_A801_4F55_8D75_A2B260B89054#4069, COL_5B3F8C0A_F174_4503_A717_C646CDFCA597#4070, COL_0474BFA5_7C7E_4F39_8082_D2950F938333#4071, COL_DAF39CF1_AC31_453D_9031_E3C3788CC0EA#4072, COL_F139D9E2_0197_4395_A4D3_B9D38247671D#4073, COL_AC07AFA6_FBCB_4684_AA1E_322B5B13A62A#4074, COL_A01EA7BD_46AF_433E_87CF_47D08BD89F09#4075, COL_12C8C4DF_CE41_4893_8EDB_039AE1A23619#4076, COL_FE57D81E_81C1_4262_ABA9_AC672A72613F#4077]
+- Project [cast(QUALITE_ANOMALI_37460_COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#3985 as string) AS COL_83066F8F_DD8F_453E_938F_934128D9E9B9#4056, cast(QUALITE_ANOMALI_37460_COL_A7E7D68F_B3E4_46B9_BD51_1B1B9A90CF55#3986 as int) AS COL_086A629B_840E_4DD2_81F4_BE36CC1C71AF#4057, cast(QUALITE_ANOMALI_37460_COL_88D2F303_585E_4763_A8BA_B4A82A90D8F1#3987 as int) AS COL_2E123050_0514_4FA4_8DC9_C024A7A943B6#4058, cast(QUALITE_ANOMALI_37460_COL_187EC0AD_22E4_4370_AE9A_63E3CD00AE8C#3988 as int) AS COL_B0C7FE24_CB98_49DE_BE2A_7B519325B151#4059, cast(QUALITE_ANOMALI_37460_COL_D0EE5893_E0DD_499B_A309_6AD9BD8FEC2A#3989 as int) AS COL_7EB61862_07AE_46C5_A762_B62427E6497C#4060, cast(QUALITE_ANOMALI_37460_COL_6CCFACA8_0D70_498B_B125_A70DC40A6C00#3990 as string) AS COL_31159F89_02E9_4586_BDE9_BEBF7DE7147B#4061, cast(QUALITE_ANOMALI_37460_COL_FB931C53_C68F_4BE1_8F92_2F4726DB2BE3#3991 as int) AS COL_18AD7666_01D2_4ABD_9679_86105797736C#4062, cast(QUALITE_ANOMALI_37460_COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#3992 as string) AS COL_C0568947_9665_4A70_944C_B06C636DD141#4063, cast(QUALITE_ANOMALI_37460_COL_1771B7C9_84A4_49CA_89AD_E21CC59F80AC#3993 as string) AS COL_EA9D7951_2501_49E1_89FE_1913B8B33C88#4064, cast(QUALITE_ANOMALI_37460_COL_27299A39_F4ED_4BAA_B6D8_E9E34602F275#3994 as string) AS COL_65BD15C1_BCB0_4783_BEBF_8ACC9BAD5995#4065, cast(QUALITE_ANOMALI_37460_COL_ED0ED18D_F6DD_4C36_B65D_D4312655138C#3995 as int) AS COL_108BC341_51D9_425D_8F9F_A0D02F617F7B#4066, cast(QUALITE_ANOMALI_37460_COL_1E2EDDF0_6F68_4372_81E6_E7D4483B1426#3996 as int) AS COL_E4E4C36F_51B4_4845_BA9F_6BA80D9BB3B5#4067, cast(QUALITE_ANOMALI_37460_COL_D6237111_5F6F_4655_89BD_4363977DD265#3997 as string) AS COL_92602840_5907_4BAB_ADD9_1DC40B6C8CAA#4068, cast(QUALITE_ANOMALI_37460_COL_5954D6BD_E743_4173_BE3A_CCD220954079#3998 as int) AS COL_7C1592A3_A801_4F55_8D75_A2B260B89054#4069, cast(QUALITE_ANOMALI_37460_COL_F5BD5B00_42AC_48E6_AA86_843A2B8200E8#3999 as int) AS COL_5B3F8C0A_F174_4503_A717_C646CDFCA597#4070, cast(QUALITE_ANOMALI_37460_COL_4D2413C6_01B9_4979_8D39_445C4C2D06FF#4000 as string) AS COL_0474BFA5_7C7E_4F39_8082_D2950F938333#4071, cast(QUALITE_ANOMALI_37460_COL_5223D55D_762F_4807_9CED_CCF479B3A227#4001 as int) AS COL_DAF39CF1_AC31_453D_9031_E3C3788CC0EA#4072, cast(QUALITE_ANOMALI_37460_COL_F8ECA8B6_1154_4E3C_AFD9_B77493423FAF#4002 as int) AS COL_F139D9E2_0197_4395_A4D3_B9D38247671D#4073, cast(QUALITE_ANOMALI_37460_COL_F4C9E045_08D4_4CFC_844A_0960BB072DAE#4003 as string) AS COL_AC07AFA6_FBCB_4684_AA1E_322B5B13A62A#4074, cast(QUALITE_ANOMALI_37460_COL_8C575FAD_BF3D_4EBA_AB0D_D9B4A5CF50EF#4004 as int) AS COL_A01EA7BD_46AF_433E_87CF_47D08BD89F09#4075, cast(QUALITE_ANOMALI_37460_COL_21870150_5C07_42CC_BB77_BCA92051856C#4005 as int) AS COL_12C8C4DF_CE41_4893_8EDB_039AE1A23619#4076, cast(QUALITE_ANOMALI_37460_COL_7CCF963F_B46D_40AE_94BC_F7846B290E74#4006 as string) AS COL_FE57D81E_81C1_4262_ABA9_AC672A72613F#4077]
+- Project [COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#3917 AS QUALITE_ANOMALI_37460_COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#3985, COL_A7E7D68F_B3E4_46B9_BD51_1B1B9A90CF55#3918 AS QUALITE_ANOMALI_37460_COL_A7E7D68F_B3E4_46B9_BD51_1B1B9A90CF55#3986, COL_88D2F303_585E_4763_A8BA_B4A82A90D8F1#3919 AS QUALITE_ANOMALI_37460_COL_88D2F303_585E_4763_A8BA_B4A82A90D8F1#3987, COL_187EC0AD_22E4_4370_AE9A_63E3CD00AE8C#3920 AS QUALITE_ANOMALI_37460_COL_187EC0AD_22E4_4370_AE9A_63E3CD00AE8C#3988, COL_D0EE5893_E0DD_499B_A309_6AD9BD8FEC2A#3921 AS QUALITE_ANOMALI_37460_COL_D0EE5893_E0DD_499B_A309_6AD9BD8FEC2A#3989, COL_6CCFACA8_0D70_498B_B125_A70DC40A6C00#3922 AS QUALITE_ANOMALI_37460_COL_6CCFACA8_0D70_498B_B125_A70DC40A6C00#3990, COL_FB931C53_C68F_4BE1_8F92_2F4726DB2BE3#3923 AS QUALITE_ANOMALI_37460_COL_FB931C53_C68F_4BE1_8F92_2F4726DB2BE3#3991, COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#3924 AS QUALITE_ANOMALI_37460_COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#3992, COL_1771B7C9_84A4_49CA_89AD_E21CC59F80AC#3925 AS QUALITE_ANOMALI_37460_COL_1771B7C9_84A4_49CA_89AD_E21CC59F80AC#3993, COL_27299A39_F4ED_4BAA_B6D8_E9E34602F275#3926 AS QUALITE_ANOMALI_37460_COL_27299A39_F4ED_4BAA_B6D8_E9E34602F275#3994, COL_ED0ED18D_F6DD_4C36_B65D_D4312655138C#3927 AS QUALITE_ANOMALI_37460_COL_ED0ED18D_F6DD_4C36_B65D_D4312655138C#3995, COL_1E2EDDF0_6F68_4372_81E6_E7D4483B1426#3928 AS QUALITE_ANOMALI_37460_COL_1E2EDDF0_6F68_4372_81E6_E7D4483B1426#3996, COL_D6237111_5F6F_4655_89BD_4363977DD265#3929 AS QUALITE_ANOMALI_37460_COL_D6237111_5F6F_4655_89BD_4363977DD265#3997, COL_5954D6BD_E743_4173_BE3A_CCD220954079#3930 AS QUALITE_ANOMALI_37460_COL_5954D6BD_E743_4173_BE3A_CCD220954079#3998, COL_F5BD5B00_42AC_48E6_AA86_843A2B8200E8#3931 AS QUALITE_ANOMALI_37460_COL_F5BD5B00_42AC_48E6_AA86_843A2B8200E8#3999, COL_4D2413C6_01B9_4979_8D39_445C4C2D06FF#3932 AS QUALITE_ANOMALI_37460_COL_4D2413C6_01B9_4979_8D39_445C4C2D06FF#4000, COL_5223D55D_762F_4807_9CED_CCF479B3A227#3933 AS QUALITE_ANOMALI_37460_COL_5223D55D_762F_4807_9CED_CCF479B3A227#4001, COL_F8ECA8B6_1154_4E3C_AFD9_B77493423FAF#3934 AS QUALITE_ANOMALI_37460_COL_F8ECA8B6_1154_4E3C_AFD9_B77493423FAF#4002, COL_F4C9E045_08D4_4CFC_844A_0960BB072DAE#3935 AS QUALITE_ANOMALI_37460_COL_F4C9E045_08D4_4CFC_844A_0960BB072DAE#4003, COL_8C575FAD_BF3D_4EBA_AB0D_D9B4A5CF50EF#3936 AS QUALITE_ANOMALI_37460_COL_8C575FAD_BF3D_4EBA_AB0D_D9B4A5CF50EF#4004, COL_21870150_5C07_42CC_BB77_BCA92051856C#3937 AS QUALITE_ANOMALI_37460_COL_21870150_5C07_42CC_BB77_BCA92051856C#4005, COL_7CCF963F_B46D_40AE_94BC_F7846B290E74#3938 AS QUALITE_ANOMALI_37460_COL_7CCF963F_B46D_40AE_94BC_F7846B290E74#4006]
+- SubqueryAlias QUALITE_ANOMALI_37460118
+- Relation[COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#3917,COL_A7E7D68F_B3E4_46B9_BD51_1B1B9A90CF55#3918,COL_88D2F303_585E_4763_A8BA_B4A82A90D8F1#3919,COL_187EC0AD_22E4_4370_AE9A_63E3CD00AE8C#3920,COL_D0EE5893_E0DD_499B_A309_6AD9BD8FEC2A#3921,COL_6CCFACA8_0D70_498B_B125_A70DC40A6C00#3922,COL_FB931C53_C68F_4BE1_8F92_2F4726DB2BE3#3923,COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#3924,COL_1771B7C9_84A4_49CA_89AD_E21CC59F80AC#3925,COL_27299A39_F4ED_4BAA_B6D8_E9E34602F275#3926,COL_ED0ED18D_F6DD_4C36_B65D_D4312655138C#3927,COL_1E2EDDF0_6F68_4372_81E6_E7D4483B1426#3928,COL_D6237111_5F6F_4655_89BD_4363977DD265#3929,COL_5954D6BD_E743_4173_BE3A_CCD220954079#3930,COL_F5BD5B00_42AC_48E6_AA86_843A2B8200E8#3931,COL_4D2413C6_01B9_4979_8D39_445C4C2D06FF#3932,COL_5223D55D_762F_4807_9CED_CCF479B3A227#3933,COL_F8ECA8B6_1154_4E3C_AFD9_B77493423FAF#3934,COL_F4C9E045_08D4_4CFC_844A_0960BB072DAE#3935,COL_8C575FAD_BF3D_4EBA_AB0D_D9B4A5CF50EF#3936,COL_21870150_5C07_42CC_BB77_BCA92051856C#3937,COL_7CCF963F_B46D_40AE_94BC_F7846B290E74#3938] parquet
== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
+- Aggregate [COL_18AD7666_01D2_4ABD_9679_86105797736C#4062], [COL_18AD7666_01D2_4ABD_9679_86105797736C#4062 AS COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#4215, count(COL_83066F8F_DD8F_453E_938F_934128D9E9B9#4056) AS COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#4216L, str_if_with_rule((COL_18AD7666_01D2_4ABD_9679_86105797736C#4062 <=> 1), Annuler, Autres) AS COL_39BBB014_7AC3_4E75_A0B3_78A989ACE08E#4219]
+- Project [COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#3917 AS COL_83066F8F_DD8F_453E_938F_934128D9E9B9#4056, COL_FB931C53_C68F_4BE1_8F92_2F4726DB2BE3#3923 AS COL_18AD7666_01D2_4ABD_9679_86105797736C#4062]
+- Relation[COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#3917,COL_A7E7D68F_B3E4_46B9_BD51_1B1B9A90CF55#3918,COL_88D2F303_585E_4763_A8BA_B4A82A90D8F1#3919,COL_187EC0AD_22E4_4370_AE9A_63E3CD00AE8C#3920,COL_D0EE5893_E0DD_499B_A309_6AD9BD8FEC2A#3921,COL_6CCFACA8_0D70_498B_B125_A70DC40A6C00#3922,COL_FB931C53_C68F_4BE1_8F92_2F4726DB2BE3#3923,COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#3924,COL_1771B7C9_84A4_49CA_89AD_E21CC59F80AC#3925,COL_27299A39_F4ED_4BAA_B6D8_E9E34602F275#3926,COL_ED0ED18D_F6DD_4C36_B65D_D4312655138C#3927,COL_1E2EDDF0_6F68_4372_81E6_E7D4483B1426#3928,COL_D6237111_5F6F_4655_89BD_4363977DD265#3929,COL_5954D6BD_E743_4173_BE3A_CCD220954079#3930,COL_F5BD5B00_42AC_48E6_AA86_843A2B8200E8#3931,COL_4D2413C6_01B9_4979_8D39_445C4C2D06FF#3932,COL_5223D55D_762F_4807_9CED_CCF479B3A227#3933,COL_F8ECA8B6_1154_4E3C_AFD9_B77493423FAF#3934,COL_F4C9E045_08D4_4CFC_844A_0960BB072DAE#3935,COL_8C575FAD_BF3D_4EBA_AB0D_D9B4A5CF50EF#3936,COL_21870150_5C07_42CC_BB77_BCA92051856C#3937,COL_7CCF963F_B46D_40AE_94BC_F7846B290E74#3938] parquet
== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- CollectLimit 500000
+- *(2) HashAggregate(keys=[COL_18AD7666_01D2_4ABD_9679_86105797736C#4062], functions=[count(COL_83066F8F_DD8F_453E_938F_934128D9E9B9#4056)], output=[COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#4215, COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#4216L, COL_39BBB014_7AC3_4E75_A0B3_78A989ACE08E#4219])
+- CustomShuffleReader coalesced
+- ShuffleQueryStage 0
+- Exchange hashpartitioning(COL_18AD7666_01D2_4ABD_9679_86105797736C#4062, 200), true, [id=#684]
+- *(1) HashAggregate(keys=[COL_18AD7666_01D2_4ABD_9679_86105797736C#4062], functions=[partial_count(COL_83066F8F_DD8F_453E_938F_934128D9E9B9#4056)], output=[COL_18AD7666_01D2_4ABD_9679_86105797736C#4062, count#4242L])
+- *(1) Project [COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#3917 AS COL_83066F8F_DD8F_453E_938F_934128D9E9B9#4056, COL_FB931C53_C68F_4BE1_8F92_2F4726DB2BE3#3923 AS COL_18AD7666_01D2_4ABD_9679_86105797736C#4062]
+- *(1) ColumnarToRow
+- FileScan parquet [COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#3917,COL_FB931C53_C68F_4BE1_8F92_2F4726DB2BE3#3923] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/QUALITE_ANOMALI_37460], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12:string,COL_FB931C53_C68F_4BE1_8F92_2F4726DB2BE3:int>
