== Parsed Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
+- Project [COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#20067 AS COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#20095, COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#20076L AS COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#20096L, COL_39BBB014_7AC3_4E75_A0B3_78A989ACE08E#20091 AS COL_39BBB014_7AC3_4E75_A0B3_78A989ACE08E#20097]
+- Project [COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#20039 AS COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#20067, COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#20040L AS COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#20076L, COL_39BBB014_7AC3_4E75_A0B3_78A989ACE08E#20041 AS COL_39BBB014_7AC3_4E75_A0B3_78A989ACE08E#20091]
+- Project [COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#20027 AS COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#20039, COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#20028L AS COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#20040L, COL_39BBB014_7AC3_4E75_A0B3_78A989ACE08E#20035 AS COL_39BBB014_7AC3_4E75_A0B3_78A989ACE08E#20041]
+- Sort true
+- Project [COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#20027, COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#20028L, str_if_with_rule((COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#20027 <=> cast(1 as int)), cast(Annuler as string), cast(Autres as string)) AS COL_39BBB014_7AC3_4E75_A0B3_78A989ACE08E#20035]
+- Project [COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#20022 AS COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#20027, COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#20023L AS COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#20028L]
+- Project [COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#19988 AS COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#20022, COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#20013L AS COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#20023L]
+- Project [COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#19988, COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#20013L]
+- Aggregate [COL_18AD7666_01D2_4ABD_9679_86105797736C#19914], [COL_18AD7666_01D2_4ABD_9679_86105797736C#19914 AS COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#19988, 1 AS NULL_1#20014, count(COL_83066F8F_DD8F_453E_938F_934128D9E9B9#19908) AS COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#20013L]
+- Project [COL_83066F8F_DD8F_453E_938F_934128D9E9B9#19908, COL_086A629B_840E_4DD2_81F4_BE36CC1C71AF#19909, COL_2E123050_0514_4FA4_8DC9_C024A7A943B6#19910, COL_B0C7FE24_CB98_49DE_BE2A_7B519325B151#19911, COL_7EB61862_07AE_46C5_A762_B62427E6497C#19912, COL_31159F89_02E9_4586_BDE9_BEBF7DE7147B#19913, COL_18AD7666_01D2_4ABD_9679_86105797736C#19914, COL_C0568947_9665_4A70_944C_B06C636DD141#19915, COL_EA9D7951_2501_49E1_89FE_1913B8B33C88#19916, COL_65BD15C1_BCB0_4783_BEBF_8ACC9BAD5995#19917, COL_108BC341_51D9_425D_8F9F_A0D02F617F7B#19918, COL_E4E4C36F_51B4_4845_BA9F_6BA80D9BB3B5#19919, COL_92602840_5907_4BAB_ADD9_1DC40B6C8CAA#19920, COL_7C1592A3_A801_4F55_8D75_A2B260B89054#19921, COL_5B3F8C0A_F174_4503_A717_C646CDFCA597#19922, COL_0474BFA5_7C7E_4F39_8082_D2950F938333#19923, COL_DAF39CF1_AC31_453D_9031_E3C3788CC0EA#19924, COL_F139D9E2_0197_4395_A4D3_B9D38247671D#19925, COL_AC07AFA6_FBCB_4684_AA1E_322B5B13A62A#19926, COL_A01EA7BD_46AF_433E_87CF_47D08BD89F09#19927, COL_12C8C4DF_CE41_4893_8EDB_039AE1A23619#19928, COL_FE57D81E_81C1_4262_ABA9_AC672A72613F#19929]
+- Project [cast(QUALITE_ANOMALI_37460_COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#19826 as string) AS COL_83066F8F_DD8F_453E_938F_934128D9E9B9#19908, cast(QUALITE_ANOMALI_37460_COL_A7E7D68F_B3E4_46B9_BD51_1B1B9A90CF55#19827 as int) AS COL_086A629B_840E_4DD2_81F4_BE36CC1C71AF#19909, cast(QUALITE_ANOMALI_37460_COL_88D2F303_585E_4763_A8BA_B4A82A90D8F1#19828 as int) AS COL_2E123050_0514_4FA4_8DC9_C024A7A943B6#19910, cast(QUALITE_ANOMALI_37460_COL_187EC0AD_22E4_4370_AE9A_63E3CD00AE8C#19829 as int) AS COL_B0C7FE24_CB98_49DE_BE2A_7B519325B151#19911, cast(QUALITE_ANOMALI_37460_COL_D0EE5893_E0DD_499B_A309_6AD9BD8FEC2A#19830 as int) AS COL_7EB61862_07AE_46C5_A762_B62427E6497C#19912, cast(QUALITE_ANOMALI_37460_COL_6CCFACA8_0D70_498B_B125_A70DC40A6C00#19831 as string) AS COL_31159F89_02E9_4586_BDE9_BEBF7DE7147B#19913, cast(QUALITE_ANOMALI_37460_COL_FB931C53_C68F_4BE1_8F92_2F4726DB2BE3#19832 as int) AS COL_18AD7666_01D2_4ABD_9679_86105797736C#19914, cast(QUALITE_ANOMALI_37460_COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#19833 as string) AS COL_C0568947_9665_4A70_944C_B06C636DD141#19915, cast(QUALITE_ANOMALI_37460_COL_1771B7C9_84A4_49CA_89AD_E21CC59F80AC#19834 as string) AS COL_EA9D7951_2501_49E1_89FE_1913B8B33C88#19916, cast(QUALITE_ANOMALI_37460_COL_27299A39_F4ED_4BAA_B6D8_E9E34602F275#19835 as string) AS COL_65BD15C1_BCB0_4783_BEBF_8ACC9BAD5995#19917, cast(QUALITE_ANOMALI_37460_COL_ED0ED18D_F6DD_4C36_B65D_D4312655138C#19836 as int) AS COL_108BC341_51D9_425D_8F9F_A0D02F617F7B#19918, cast(QUALITE_ANOMALI_37460_COL_1E2EDDF0_6F68_4372_81E6_E7D4483B1426#19837 as int) AS COL_E4E4C36F_51B4_4845_BA9F_6BA80D9BB3B5#19919, cast(QUALITE_ANOMALI_37460_COL_D6237111_5F6F_4655_89BD_4363977DD265#19838 as string) AS COL_92602840_5907_4BAB_ADD9_1DC40B6C8CAA#19920, cast(QUALITE_ANOMALI_37460_COL_5954D6BD_E743_4173_BE3A_CCD220954079#19839 as int) AS COL_7C1592A3_A801_4F55_8D75_A2B260B89054#19921, cast(QUALITE_ANOMALI_37460_COL_F5BD5B00_42AC_48E6_AA86_843A2B8200E8#19840 as int) AS COL_5B3F8C0A_F174_4503_A717_C646CDFCA597#19922, cast(QUALITE_ANOMALI_37460_COL_4D2413C6_01B9_4979_8D39_445C4C2D06FF#19841 as string) AS COL_0474BFA5_7C7E_4F39_8082_D2950F938333#19923, cast(QUALITE_ANOMALI_37460_COL_5223D55D_762F_4807_9CED_CCF479B3A227#19842 as int) AS COL_DAF39CF1_AC31_453D_9031_E3C3788CC0EA#19924, cast(QUALITE_ANOMALI_37460_COL_F8ECA8B6_1154_4E3C_AFD9_B77493423FAF#19843 as int) AS COL_F139D9E2_0197_4395_A4D3_B9D38247671D#19925, cast(QUALITE_ANOMALI_37460_COL_F4C9E045_08D4_4CFC_844A_0960BB072DAE#19844 as string) AS COL_AC07AFA6_FBCB_4684_AA1E_322B5B13A62A#19926, cast(QUALITE_ANOMALI_37460_COL_8C575FAD_BF3D_4EBA_AB0D_D9B4A5CF50EF#19845 as int) AS COL_A01EA7BD_46AF_433E_87CF_47D08BD89F09#19927, cast(QUALITE_ANOMALI_37460_COL_21870150_5C07_42CC_BB77_BCA92051856C#19846 as int) AS COL_12C8C4DF_CE41_4893_8EDB_039AE1A23619#19928, cast(QUALITE_ANOMALI_37460_COL_7CCF963F_B46D_40AE_94BC_F7846B290E74#19847 as string) AS COL_FE57D81E_81C1_4262_ABA9_AC672A72613F#19929]
+- Project [COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#19703 AS QUALITE_ANOMALI_37460_COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#19826, COL_A7E7D68F_B3E4_46B9_BD51_1B1B9A90CF55#19704 AS QUALITE_ANOMALI_37460_COL_A7E7D68F_B3E4_46B9_BD51_1B1B9A90CF55#19827, COL_88D2F303_585E_4763_A8BA_B4A82A90D8F1#19705 AS QUALITE_ANOMALI_37460_COL_88D2F303_585E_4763_A8BA_B4A82A90D8F1#19828, COL_187EC0AD_22E4_4370_AE9A_63E3CD00AE8C#19706 AS QUALITE_ANOMALI_37460_COL_187EC0AD_22E4_4370_AE9A_63E3CD00AE8C#19829, COL_D0EE5893_E0DD_499B_A309_6AD9BD8FEC2A#19707 AS QUALITE_ANOMALI_37460_COL_D0EE5893_E0DD_499B_A309_6AD9BD8FEC2A#19830, COL_6CCFACA8_0D70_498B_B125_A70DC40A6C00#19708 AS QUALITE_ANOMALI_37460_COL_6CCFACA8_0D70_498B_B125_A70DC40A6C00#19831, COL_FB931C53_C68F_4BE1_8F92_2F4726DB2BE3#19709 AS QUALITE_ANOMALI_37460_COL_FB931C53_C68F_4BE1_8F92_2F4726DB2BE3#19832, COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#19710 AS QUALITE_ANOMALI_37460_COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#19833, COL_1771B7C9_84A4_49CA_89AD_E21CC59F80AC#19711 AS QUALITE_ANOMALI_37460_COL_1771B7C9_84A4_49CA_89AD_E21CC59F80AC#19834, COL_27299A39_F4ED_4BAA_B6D8_E9E34602F275#19712 AS QUALITE_ANOMALI_37460_COL_27299A39_F4ED_4BAA_B6D8_E9E34602F275#19835, COL_ED0ED18D_F6DD_4C36_B65D_D4312655138C#19713 AS QUALITE_ANOMALI_37460_COL_ED0ED18D_F6DD_4C36_B65D_D4312655138C#19836, COL_1E2EDDF0_6F68_4372_81E6_E7D4483B1426#19714 AS QUALITE_ANOMALI_37460_COL_1E2EDDF0_6F68_4372_81E6_E7D4483B1426#19837, COL_D6237111_5F6F_4655_89BD_4363977DD265#19715 AS QUALITE_ANOMALI_37460_COL_D6237111_5F6F_4655_89BD_4363977DD265#19838, COL_5954D6BD_E743_4173_BE3A_CCD220954079#19716 AS QUALITE_ANOMALI_37460_COL_5954D6BD_E743_4173_BE3A_CCD220954079#19839, COL_F5BD5B00_42AC_48E6_AA86_843A2B8200E8#19717 AS QUALITE_ANOMALI_37460_COL_F5BD5B00_42AC_48E6_AA86_843A2B8200E8#19840, COL_4D2413C6_01B9_4979_8D39_445C4C2D06FF#19718 AS QUALITE_ANOMALI_37460_COL_4D2413C6_01B9_4979_8D39_445C4C2D06FF#19841, COL_5223D55D_762F_4807_9CED_CCF479B3A227#19719 AS QUALITE_ANOMALI_37460_COL_5223D55D_762F_4807_9CED_CCF479B3A227#19842, COL_F8ECA8B6_1154_4E3C_AFD9_B77493423FAF#19720 AS QUALITE_ANOMALI_37460_COL_F8ECA8B6_1154_4E3C_AFD9_B77493423FAF#19843, COL_F4C9E045_08D4_4CFC_844A_0960BB072DAE#19721 AS QUALITE_ANOMALI_37460_COL_F4C9E045_08D4_4CFC_844A_0960BB072DAE#19844, COL_8C575FAD_BF3D_4EBA_AB0D_D9B4A5CF50EF#19722 AS QUALITE_ANOMALI_37460_COL_8C575FAD_BF3D_4EBA_AB0D_D9B4A5CF50EF#19845, COL_21870150_5C07_42CC_BB77_BCA92051856C#19723 AS QUALITE_ANOMALI_37460_COL_21870150_5C07_42CC_BB77_BCA92051856C#19846, COL_7CCF963F_B46D_40AE_94BC_F7846B290E74#19724 AS QUALITE_ANOMALI_37460_COL_7CCF963F_B46D_40AE_94BC_F7846B290E74#19847]
+- SubqueryAlias QUALITE_ANOMALI_37460115
+- Relation[COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#19703,COL_A7E7D68F_B3E4_46B9_BD51_1B1B9A90CF55#19704,COL_88D2F303_585E_4763_A8BA_B4A82A90D8F1#19705,COL_187EC0AD_22E4_4370_AE9A_63E3CD00AE8C#19706,COL_D0EE5893_E0DD_499B_A309_6AD9BD8FEC2A#19707,COL_6CCFACA8_0D70_498B_B125_A70DC40A6C00#19708,COL_FB931C53_C68F_4BE1_8F92_2F4726DB2BE3#19709,COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#19710,COL_1771B7C9_84A4_49CA_89AD_E21CC59F80AC#19711,COL_27299A39_F4ED_4BAA_B6D8_E9E34602F275#19712,COL_ED0ED18D_F6DD_4C36_B65D_D4312655138C#19713,COL_1E2EDDF0_6F68_4372_81E6_E7D4483B1426#19714,COL_D6237111_5F6F_4655_89BD_4363977DD265#19715,COL_5954D6BD_E743_4173_BE3A_CCD220954079#19716,COL_F5BD5B00_42AC_48E6_AA86_843A2B8200E8#19717,COL_4D2413C6_01B9_4979_8D39_445C4C2D06FF#19718,COL_5223D55D_762F_4807_9CED_CCF479B3A227#19719,COL_F8ECA8B6_1154_4E3C_AFD9_B77493423FAF#19720,COL_F4C9E045_08D4_4CFC_844A_0960BB072DAE#19721,COL_8C575FAD_BF3D_4EBA_AB0D_D9B4A5CF50EF#19722,COL_21870150_5C07_42CC_BB77_BCA92051856C#19723,COL_7CCF963F_B46D_40AE_94BC_F7846B290E74#19724] 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#20067 AS COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#20095, COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#20076L AS COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#20096L, COL_39BBB014_7AC3_4E75_A0B3_78A989ACE08E#20091 AS COL_39BBB014_7AC3_4E75_A0B3_78A989ACE08E#20097]
+- Project [COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#20039 AS COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#20067, COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#20040L AS COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#20076L, COL_39BBB014_7AC3_4E75_A0B3_78A989ACE08E#20041 AS COL_39BBB014_7AC3_4E75_A0B3_78A989ACE08E#20091]
+- Project [COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#20027 AS COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#20039, COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#20028L AS COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#20040L, COL_39BBB014_7AC3_4E75_A0B3_78A989ACE08E#20035 AS COL_39BBB014_7AC3_4E75_A0B3_78A989ACE08E#20041]
+- Sort true
+- Project [COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#20027, COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#20028L, str_if_with_rule((COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#20027 <=> cast(1 as int)), cast(Annuler as string), cast(Autres as string)) AS COL_39BBB014_7AC3_4E75_A0B3_78A989ACE08E#20035]
+- Project [COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#20022 AS COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#20027, COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#20023L AS COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#20028L]
+- Project [COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#19988 AS COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#20022, COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#20013L AS COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#20023L]
+- Project [COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#19988, COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#20013L]
+- Aggregate [COL_18AD7666_01D2_4ABD_9679_86105797736C#19914], [COL_18AD7666_01D2_4ABD_9679_86105797736C#19914 AS COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#19988, 1 AS NULL_1#20014, count(COL_83066F8F_DD8F_453E_938F_934128D9E9B9#19908) AS COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#20013L]
+- Project [COL_83066F8F_DD8F_453E_938F_934128D9E9B9#19908, COL_086A629B_840E_4DD2_81F4_BE36CC1C71AF#19909, COL_2E123050_0514_4FA4_8DC9_C024A7A943B6#19910, COL_B0C7FE24_CB98_49DE_BE2A_7B519325B151#19911, COL_7EB61862_07AE_46C5_A762_B62427E6497C#19912, COL_31159F89_02E9_4586_BDE9_BEBF7DE7147B#19913, COL_18AD7666_01D2_4ABD_9679_86105797736C#19914, COL_C0568947_9665_4A70_944C_B06C636DD141#19915, COL_EA9D7951_2501_49E1_89FE_1913B8B33C88#19916, COL_65BD15C1_BCB0_4783_BEBF_8ACC9BAD5995#19917, COL_108BC341_51D9_425D_8F9F_A0D02F617F7B#19918, COL_E4E4C36F_51B4_4845_BA9F_6BA80D9BB3B5#19919, COL_92602840_5907_4BAB_ADD9_1DC40B6C8CAA#19920, COL_7C1592A3_A801_4F55_8D75_A2B260B89054#19921, COL_5B3F8C0A_F174_4503_A717_C646CDFCA597#19922, COL_0474BFA5_7C7E_4F39_8082_D2950F938333#19923, COL_DAF39CF1_AC31_453D_9031_E3C3788CC0EA#19924, COL_F139D9E2_0197_4395_A4D3_B9D38247671D#19925, COL_AC07AFA6_FBCB_4684_AA1E_322B5B13A62A#19926, COL_A01EA7BD_46AF_433E_87CF_47D08BD89F09#19927, COL_12C8C4DF_CE41_4893_8EDB_039AE1A23619#19928, COL_FE57D81E_81C1_4262_ABA9_AC672A72613F#19929]
+- Project [cast(QUALITE_ANOMALI_37460_COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#19826 as string) AS COL_83066F8F_DD8F_453E_938F_934128D9E9B9#19908, cast(QUALITE_ANOMALI_37460_COL_A7E7D68F_B3E4_46B9_BD51_1B1B9A90CF55#19827 as int) AS COL_086A629B_840E_4DD2_81F4_BE36CC1C71AF#19909, cast(QUALITE_ANOMALI_37460_COL_88D2F303_585E_4763_A8BA_B4A82A90D8F1#19828 as int) AS COL_2E123050_0514_4FA4_8DC9_C024A7A943B6#19910, cast(QUALITE_ANOMALI_37460_COL_187EC0AD_22E4_4370_AE9A_63E3CD00AE8C#19829 as int) AS COL_B0C7FE24_CB98_49DE_BE2A_7B519325B151#19911, cast(QUALITE_ANOMALI_37460_COL_D0EE5893_E0DD_499B_A309_6AD9BD8FEC2A#19830 as int) AS COL_7EB61862_07AE_46C5_A762_B62427E6497C#19912, cast(QUALITE_ANOMALI_37460_COL_6CCFACA8_0D70_498B_B125_A70DC40A6C00#19831 as string) AS COL_31159F89_02E9_4586_BDE9_BEBF7DE7147B#19913, cast(QUALITE_ANOMALI_37460_COL_FB931C53_C68F_4BE1_8F92_2F4726DB2BE3#19832 as int) AS COL_18AD7666_01D2_4ABD_9679_86105797736C#19914, cast(QUALITE_ANOMALI_37460_COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#19833 as string) AS COL_C0568947_9665_4A70_944C_B06C636DD141#19915, cast(QUALITE_ANOMALI_37460_COL_1771B7C9_84A4_49CA_89AD_E21CC59F80AC#19834 as string) AS COL_EA9D7951_2501_49E1_89FE_1913B8B33C88#19916, cast(QUALITE_ANOMALI_37460_COL_27299A39_F4ED_4BAA_B6D8_E9E34602F275#19835 as string) AS COL_65BD15C1_BCB0_4783_BEBF_8ACC9BAD5995#19917, cast(QUALITE_ANOMALI_37460_COL_ED0ED18D_F6DD_4C36_B65D_D4312655138C#19836 as int) AS COL_108BC341_51D9_425D_8F9F_A0D02F617F7B#19918, cast(QUALITE_ANOMALI_37460_COL_1E2EDDF0_6F68_4372_81E6_E7D4483B1426#19837 as int) AS COL_E4E4C36F_51B4_4845_BA9F_6BA80D9BB3B5#19919, cast(QUALITE_ANOMALI_37460_COL_D6237111_5F6F_4655_89BD_4363977DD265#19838 as string) AS COL_92602840_5907_4BAB_ADD9_1DC40B6C8CAA#19920, cast(QUALITE_ANOMALI_37460_COL_5954D6BD_E743_4173_BE3A_CCD220954079#19839 as int) AS COL_7C1592A3_A801_4F55_8D75_A2B260B89054#19921, cast(QUALITE_ANOMALI_37460_COL_F5BD5B00_42AC_48E6_AA86_843A2B8200E8#19840 as int) AS COL_5B3F8C0A_F174_4503_A717_C646CDFCA597#19922, cast(QUALITE_ANOMALI_37460_COL_4D2413C6_01B9_4979_8D39_445C4C2D06FF#19841 as string) AS COL_0474BFA5_7C7E_4F39_8082_D2950F938333#19923, cast(QUALITE_ANOMALI_37460_COL_5223D55D_762F_4807_9CED_CCF479B3A227#19842 as int) AS COL_DAF39CF1_AC31_453D_9031_E3C3788CC0EA#19924, cast(QUALITE_ANOMALI_37460_COL_F8ECA8B6_1154_4E3C_AFD9_B77493423FAF#19843 as int) AS COL_F139D9E2_0197_4395_A4D3_B9D38247671D#19925, cast(QUALITE_ANOMALI_37460_COL_F4C9E045_08D4_4CFC_844A_0960BB072DAE#19844 as string) AS COL_AC07AFA6_FBCB_4684_AA1E_322B5B13A62A#19926, cast(QUALITE_ANOMALI_37460_COL_8C575FAD_BF3D_4EBA_AB0D_D9B4A5CF50EF#19845 as int) AS COL_A01EA7BD_46AF_433E_87CF_47D08BD89F09#19927, cast(QUALITE_ANOMALI_37460_COL_21870150_5C07_42CC_BB77_BCA92051856C#19846 as int) AS COL_12C8C4DF_CE41_4893_8EDB_039AE1A23619#19928, cast(QUALITE_ANOMALI_37460_COL_7CCF963F_B46D_40AE_94BC_F7846B290E74#19847 as string) AS COL_FE57D81E_81C1_4262_ABA9_AC672A72613F#19929]
+- Project [COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#19703 AS QUALITE_ANOMALI_37460_COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#19826, COL_A7E7D68F_B3E4_46B9_BD51_1B1B9A90CF55#19704 AS QUALITE_ANOMALI_37460_COL_A7E7D68F_B3E4_46B9_BD51_1B1B9A90CF55#19827, COL_88D2F303_585E_4763_A8BA_B4A82A90D8F1#19705 AS QUALITE_ANOMALI_37460_COL_88D2F303_585E_4763_A8BA_B4A82A90D8F1#19828, COL_187EC0AD_22E4_4370_AE9A_63E3CD00AE8C#19706 AS QUALITE_ANOMALI_37460_COL_187EC0AD_22E4_4370_AE9A_63E3CD00AE8C#19829, COL_D0EE5893_E0DD_499B_A309_6AD9BD8FEC2A#19707 AS QUALITE_ANOMALI_37460_COL_D0EE5893_E0DD_499B_A309_6AD9BD8FEC2A#19830, COL_6CCFACA8_0D70_498B_B125_A70DC40A6C00#19708 AS QUALITE_ANOMALI_37460_COL_6CCFACA8_0D70_498B_B125_A70DC40A6C00#19831, COL_FB931C53_C68F_4BE1_8F92_2F4726DB2BE3#19709 AS QUALITE_ANOMALI_37460_COL_FB931C53_C68F_4BE1_8F92_2F4726DB2BE3#19832, COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#19710 AS QUALITE_ANOMALI_37460_COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#19833, COL_1771B7C9_84A4_49CA_89AD_E21CC59F80AC#19711 AS QUALITE_ANOMALI_37460_COL_1771B7C9_84A4_49CA_89AD_E21CC59F80AC#19834, COL_27299A39_F4ED_4BAA_B6D8_E9E34602F275#19712 AS QUALITE_ANOMALI_37460_COL_27299A39_F4ED_4BAA_B6D8_E9E34602F275#19835, COL_ED0ED18D_F6DD_4C36_B65D_D4312655138C#19713 AS QUALITE_ANOMALI_37460_COL_ED0ED18D_F6DD_4C36_B65D_D4312655138C#19836, COL_1E2EDDF0_6F68_4372_81E6_E7D4483B1426#19714 AS QUALITE_ANOMALI_37460_COL_1E2EDDF0_6F68_4372_81E6_E7D4483B1426#19837, COL_D6237111_5F6F_4655_89BD_4363977DD265#19715 AS QUALITE_ANOMALI_37460_COL_D6237111_5F6F_4655_89BD_4363977DD265#19838, COL_5954D6BD_E743_4173_BE3A_CCD220954079#19716 AS QUALITE_ANOMALI_37460_COL_5954D6BD_E743_4173_BE3A_CCD220954079#19839, COL_F5BD5B00_42AC_48E6_AA86_843A2B8200E8#19717 AS QUALITE_ANOMALI_37460_COL_F5BD5B00_42AC_48E6_AA86_843A2B8200E8#19840, COL_4D2413C6_01B9_4979_8D39_445C4C2D06FF#19718 AS QUALITE_ANOMALI_37460_COL_4D2413C6_01B9_4979_8D39_445C4C2D06FF#19841, COL_5223D55D_762F_4807_9CED_CCF479B3A227#19719 AS QUALITE_ANOMALI_37460_COL_5223D55D_762F_4807_9CED_CCF479B3A227#19842, COL_F8ECA8B6_1154_4E3C_AFD9_B77493423FAF#19720 AS QUALITE_ANOMALI_37460_COL_F8ECA8B6_1154_4E3C_AFD9_B77493423FAF#19843, COL_F4C9E045_08D4_4CFC_844A_0960BB072DAE#19721 AS QUALITE_ANOMALI_37460_COL_F4C9E045_08D4_4CFC_844A_0960BB072DAE#19844, COL_8C575FAD_BF3D_4EBA_AB0D_D9B4A5CF50EF#19722 AS QUALITE_ANOMALI_37460_COL_8C575FAD_BF3D_4EBA_AB0D_D9B4A5CF50EF#19845, COL_21870150_5C07_42CC_BB77_BCA92051856C#19723 AS QUALITE_ANOMALI_37460_COL_21870150_5C07_42CC_BB77_BCA92051856C#19846, COL_7CCF963F_B46D_40AE_94BC_F7846B290E74#19724 AS QUALITE_ANOMALI_37460_COL_7CCF963F_B46D_40AE_94BC_F7846B290E74#19847]
+- SubqueryAlias QUALITE_ANOMALI_37460115
+- Relation[COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#19703,COL_A7E7D68F_B3E4_46B9_BD51_1B1B9A90CF55#19704,COL_88D2F303_585E_4763_A8BA_B4A82A90D8F1#19705,COL_187EC0AD_22E4_4370_AE9A_63E3CD00AE8C#19706,COL_D0EE5893_E0DD_499B_A309_6AD9BD8FEC2A#19707,COL_6CCFACA8_0D70_498B_B125_A70DC40A6C00#19708,COL_FB931C53_C68F_4BE1_8F92_2F4726DB2BE3#19709,COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#19710,COL_1771B7C9_84A4_49CA_89AD_E21CC59F80AC#19711,COL_27299A39_F4ED_4BAA_B6D8_E9E34602F275#19712,COL_ED0ED18D_F6DD_4C36_B65D_D4312655138C#19713,COL_1E2EDDF0_6F68_4372_81E6_E7D4483B1426#19714,COL_D6237111_5F6F_4655_89BD_4363977DD265#19715,COL_5954D6BD_E743_4173_BE3A_CCD220954079#19716,COL_F5BD5B00_42AC_48E6_AA86_843A2B8200E8#19717,COL_4D2413C6_01B9_4979_8D39_445C4C2D06FF#19718,COL_5223D55D_762F_4807_9CED_CCF479B3A227#19719,COL_F8ECA8B6_1154_4E3C_AFD9_B77493423FAF#19720,COL_F4C9E045_08D4_4CFC_844A_0960BB072DAE#19721,COL_8C575FAD_BF3D_4EBA_AB0D_D9B4A5CF50EF#19722,COL_21870150_5C07_42CC_BB77_BCA92051856C#19723,COL_7CCF963F_B46D_40AE_94BC_F7846B290E74#19724] parquet
== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
+- Aggregate [COL_18AD7666_01D2_4ABD_9679_86105797736C#19914], [COL_18AD7666_01D2_4ABD_9679_86105797736C#19914 AS COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#20027, count(COL_83066F8F_DD8F_453E_938F_934128D9E9B9#19908) AS COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#20028L, str_if_with_rule((COL_18AD7666_01D2_4ABD_9679_86105797736C#19914 <=> 1), Annuler, Autres) AS COL_39BBB014_7AC3_4E75_A0B3_78A989ACE08E#20035]
+- Project [COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#19703 AS COL_83066F8F_DD8F_453E_938F_934128D9E9B9#19908, COL_FB931C53_C68F_4BE1_8F92_2F4726DB2BE3#19709 AS COL_18AD7666_01D2_4ABD_9679_86105797736C#19914]
+- Relation[COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#19703,COL_A7E7D68F_B3E4_46B9_BD51_1B1B9A90CF55#19704,COL_88D2F303_585E_4763_A8BA_B4A82A90D8F1#19705,COL_187EC0AD_22E4_4370_AE9A_63E3CD00AE8C#19706,COL_D0EE5893_E0DD_499B_A309_6AD9BD8FEC2A#19707,COL_6CCFACA8_0D70_498B_B125_A70DC40A6C00#19708,COL_FB931C53_C68F_4BE1_8F92_2F4726DB2BE3#19709,COL_5A025BFB_94AE_4641_BF66_8FEA0E3F389B#19710,COL_1771B7C9_84A4_49CA_89AD_E21CC59F80AC#19711,COL_27299A39_F4ED_4BAA_B6D8_E9E34602F275#19712,COL_ED0ED18D_F6DD_4C36_B65D_D4312655138C#19713,COL_1E2EDDF0_6F68_4372_81E6_E7D4483B1426#19714,COL_D6237111_5F6F_4655_89BD_4363977DD265#19715,COL_5954D6BD_E743_4173_BE3A_CCD220954079#19716,COL_F5BD5B00_42AC_48E6_AA86_843A2B8200E8#19717,COL_4D2413C6_01B9_4979_8D39_445C4C2D06FF#19718,COL_5223D55D_762F_4807_9CED_CCF479B3A227#19719,COL_F8ECA8B6_1154_4E3C_AFD9_B77493423FAF#19720,COL_F4C9E045_08D4_4CFC_844A_0960BB072DAE#19721,COL_8C575FAD_BF3D_4EBA_AB0D_D9B4A5CF50EF#19722,COL_21870150_5C07_42CC_BB77_BCA92051856C#19723,COL_7CCF963F_B46D_40AE_94BC_F7846B290E74#19724] parquet
== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- CollectLimit 500000
+- *(2) HashAggregate(keys=[COL_18AD7666_01D2_4ABD_9679_86105797736C#19914], functions=[count(COL_83066F8F_DD8F_453E_938F_934128D9E9B9#19908)], output=[COL_E7DC7832_0FCC_4A3B_813E_333EAD8BB739#20027, COL_E951BD43_8CE6_431B_B9AA_0E399D7D739A#20028L, COL_39BBB014_7AC3_4E75_A0B3_78A989ACE08E#20035])
+- CustomShuffleReader coalesced
+- ShuffleQueryStage 0
+- Exchange hashpartitioning(COL_18AD7666_01D2_4ABD_9679_86105797736C#19914, 200), true, [id=#2007]
+- *(1) HashAggregate(keys=[COL_18AD7666_01D2_4ABD_9679_86105797736C#19914], functions=[partial_count(COL_83066F8F_DD8F_453E_938F_934128D9E9B9#19908)], output=[COL_18AD7666_01D2_4ABD_9679_86105797736C#19914, count#20212L])
+- *(1) Project [COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#19703 AS COL_83066F8F_DD8F_453E_938F_934128D9E9B9#19908, COL_FB931C53_C68F_4BE1_8F92_2F4726DB2BE3#19709 AS COL_18AD7666_01D2_4ABD_9679_86105797736C#19914]
+- *(1) ColumnarToRow
+- FileScan parquet [COL_90452E40_8E06_4EEE_A6CA_2655AF2AFA12#19703,COL_FB931C53_C68F_4BE1_8F92_2F4726DB2BE3#19709] 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>
