Filter (((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3887718)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3887718)), CS F) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3887719)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3887719)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D16817E6_135B_4508_A082_6C19AC9542DE#3887720)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_D16817E6_135B_4508_A082_6C19AC9542DE#3887720)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3887721)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3887721)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_71C73F12_7D79_456A_A833_96D8469F46F2#3887723)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_71C73F12_7D79_456A_A833_96D8469F46F2#3887723)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E9867A66_711B_4AA1_A283_E4318900C80F#3887724)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_E9867A66_711B_4AA1_A283_E4318900C80F#3887724)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_DECBC528_D590_4F99_88FD_C86D82DEF299#3887725)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_DECBC528_D590_4F99_88FD_C86D82DEF299#3887725)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#3887726)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#3887726)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#3887727)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#3887727)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#3887728)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#3887728)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#3887729)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#3887729)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_553A0519_208D_498B_AEFE_829D7F40180B#3887730)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_553A0519_208D_498B_AEFE_829D7F40180B#3887730)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3887731)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3887731)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3887732)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3887732)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A655765E_D1A6_4D67_8879_F5186F86A670#3887734)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_A655765E_D1A6_4D67_8879_F5186F86A670#3887734)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3887735)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3887735)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3887736)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3887736)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3887737)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3887737)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3887738)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3887738)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3887739)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3887739)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3887740)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3887740)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3887741)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3887741)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3887742)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3887742)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3887743)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3887743)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_119C9448_3C3F_46EA_80E7_062422A2830D#3887745)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_119C9448_3C3F_46EA_80E7_062422A2830D#3887745)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06CB38F0_2321_426B_AA44_D37094826BC3#3887746)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_06CB38F0_2321_426B_AA44_D37094826BC3#3887746)), CS F) END)
== Physical Plan ==
AdaptiveSparkPlan (14)
+- == Final Plan ==
* HashAggregate (8)
+- ShuffleQueryStage (7), Statistics(sizeInBytes=160.0 B, rowCount=10)
+- Exchange (6)
+- * HashAggregate (5)
+- * Project (4)
+- * Filter (3)
+- * ColumnarToRow (2)
+- Scan parquet (1)
+- == Initial Plan ==
HashAggregate (13)
+- Exchange (12)
+- HashAggregate (11)
+- Project (10)
+- Filter (9)
+- Scan parquet (1)
(1) Scan parquet
Output [26]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3887718, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3887719, COL_D16817E6_135B_4508_A082_6C19AC9542DE#3887720, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3887721, COL_71C73F12_7D79_456A_A833_96D8469F46F2#3887723, COL_E9867A66_711B_4AA1_A283_E4318900C80F#3887724, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#3887725, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#3887726, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#3887727, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#3887728, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#3887729, COL_553A0519_208D_498B_AEFE_829D7F40180B#3887730, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3887731, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3887732, COL_A655765E_D1A6_4D67_8879_F5186F86A670#3887734, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3887735, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3887736, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3887737, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3887738, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3887739, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3887740, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3887741, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3887742, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3887743, COL_119C9448_3C3F_46EA_80E7_062422A2830D#3887745, COL_06CB38F0_2321_426B_AA44_D37094826BC3#3887746]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/00_A_RSF_SOURCE_215882]
ReadSchema: struct<COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF:string,COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730:string,COL_D16817E6_135B_4508_A082_6C19AC9542DE:string,COL_2EE853AF_4512_4E8D_ABAE_19143D81E357:string,COL_71C73F12_7D79_456A_A833_96D8469F46F2:string,COL_E9867A66_711B_4AA1_A283_E4318900C80F:string,COL_DECBC528_D590_4F99_88FD_C86D82DEF299:string,COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6:string,COL_15227A48_1CE9_407E_A0B2_D27AC3B06473:string,COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1:string,COL_6DFC44EF_67E4_461D_912F_4BA7773246D2:string,COL_553A0519_208D_498B_AEFE_829D7F40180B:string,COL_410747F2_ADCB_4C39_B9B9_C56104DAC484:string,COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5:string,COL_A655765E_D1A6_4D67_8879_F5186F86A670:string,COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A:string,COL_07AE9250_614D_4D42_854B_0EDF3D549B40:string,COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A:string,COL_06D0B7A1_9E5A_4504_BE77_E30488C56572:string,COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7:string,COL_F76740BC_E84C_42AE_9492_D66CDA0E9344:string,COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B:string,COL_BFA8E75B_6083_4911_8D50_3443279CCEC8:string,COL_86734EEA_482B_4537_86F3_6ACCB97C98E9:string,COL_119C9448_3C3F_46EA_80E7_062422A2830D:string,COL_06CB38F0_2321_426B_AA44_D37094826BC3:string>
(2) ColumnarToRow [codegen id : 1]
Input [26]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3887718, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3887719, COL_D16817E6_135B_4508_A082_6C19AC9542DE#3887720, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3887721, COL_71C73F12_7D79_456A_A833_96D8469F46F2#3887723, COL_E9867A66_711B_4AA1_A283_E4318900C80F#3887724, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#3887725, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#3887726, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#3887727, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#3887728, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#3887729, COL_553A0519_208D_498B_AEFE_829D7F40180B#3887730, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3887731, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3887732, COL_A655765E_D1A6_4D67_8879_F5186F86A670#3887734, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3887735, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3887736, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3887737, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3887738, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3887739, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3887740, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3887741, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3887742, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3887743, COL_119C9448_3C3F_46EA_80E7_062422A2830D#3887745, COL_06CB38F0_2321_426B_AA44_D37094826BC3#3887746]
(3) Filter [codegen id : 1]
Input [26]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3887718, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3887719, COL_D16817E6_135B_4508_A082_6C19AC9542DE#3887720, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3887721, COL_71C73F12_7D79_456A_A833_96D8469F46F2#3887723, COL_E9867A66_711B_4AA1_A283_E4318900C80F#3887724, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#3887725, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#3887726, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#3887727, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#3887728, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#3887729, COL_553A0519_208D_498B_AEFE_829D7F40180B#3887730, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3887731, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3887732, COL_A655765E_D1A6_4D67_8879_F5186F86A670#3887734, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3887735, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3887736, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3887737, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3887738, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3887739, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3887740, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3887741, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3887742, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3887743, COL_119C9448_3C3F_46EA_80E7_062422A2830D#3887745, COL_06CB38F0_2321_426B_AA44_D37094826BC3#3887746]
Condition : (((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3887718)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3887718)), CS F) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3887719)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3887719)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D16817E6_135B_4508_A082_6C19AC9542DE#3887720)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_D16817E6_135B_4508_A082_6C19AC9542DE#3887720)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3887721)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3887721)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_71C73F12_7D79_456A_A833_96D8469F46F2#3887723)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_71C73F12_7D79_456A_A833_96D8469F46F2#3887723)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E9867A66_711B_4AA1_A283_E4318900C80F#3887724)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_E9867A66_711B_4AA1_A283_E4318900C80F#3887724)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_DECBC528_D590_4F99_88FD_C86D82DEF299#3887725)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_DECBC528_D590_4F99_88FD_C86D82DEF299#3887725)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#3887726)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#3887726)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#3887727)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#3887727)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#3887728)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#3887728)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#3887729)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#3887729)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_553A0519_208D_498B_AEFE_829D7F40180B#3887730)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_553A0519_208D_498B_AEFE_829D7F40180B#3887730)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3887731)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3887731)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3887732)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3887732)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A655765E_D1A6_4D67_8879_F5186F86A670#3887734)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_A655765E_D1A6_4D67_8879_F5186F86A670#3887734)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3887735)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3887735)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3887736)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3887736)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3887737)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3887737)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3887738)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3887738)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3887739)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3887739)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3887740)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3887740)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3887741)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3887741)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3887742)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3887742)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3887743)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3887743)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_119C9448_3C3F_46EA_80E7_062422A2830D#3887745)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_119C9448_3C3F_46EA_80E7_062422A2830D#3887745)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06CB38F0_2321_426B_AA44_D37094826BC3#3887746)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_06CB38F0_2321_426B_AA44_D37094826BC3#3887746)), CS F) END)
(4) Project [codegen id : 1]
Output: []
Input [26]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3887718, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3887719, COL_D16817E6_135B_4508_A082_6C19AC9542DE#3887720, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3887721, COL_71C73F12_7D79_456A_A833_96D8469F46F2#3887723, COL_E9867A66_711B_4AA1_A283_E4318900C80F#3887724, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#3887725, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#3887726, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#3887727, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#3887728, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#3887729, COL_553A0519_208D_498B_AEFE_829D7F40180B#3887730, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3887731, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3887732, COL_A655765E_D1A6_4D67_8879_F5186F86A670#3887734, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3887735, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3887736, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3887737, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3887738, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3887739, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3887740, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3887741, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3887742, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3887743, COL_119C9448_3C3F_46EA_80E7_062422A2830D#3887745, COL_06CB38F0_2321_426B_AA44_D37094826BC3#3887746]
(5) HashAggregate [codegen id : 1]
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#3888069L]
Results [1]: [count#3888070L]
(6) Exchange
Input [1]: [count#3888070L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=1825943]
(7) ShuffleQueryStage
Output [1]: [count#3888070L]
Arguments: 0
(8) HashAggregate [codegen id : 2]
Input [1]: [count#3888070L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#3888066L]
Results [1]: [count(1)#3888066L AS count#3888067L]
(9) Filter
Input [26]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3887718, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3887719, COL_D16817E6_135B_4508_A082_6C19AC9542DE#3887720, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3887721, COL_71C73F12_7D79_456A_A833_96D8469F46F2#3887723, COL_E9867A66_711B_4AA1_A283_E4318900C80F#3887724, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#3887725, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#3887726, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#3887727, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#3887728, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#3887729, COL_553A0519_208D_498B_AEFE_829D7F40180B#3887730, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3887731, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3887732, COL_A655765E_D1A6_4D67_8879_F5186F86A670#3887734, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3887735, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3887736, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3887737, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3887738, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3887739, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3887740, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3887741, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3887742, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3887743, COL_119C9448_3C3F_46EA_80E7_062422A2830D#3887745, COL_06CB38F0_2321_426B_AA44_D37094826BC3#3887746]
Condition : (((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3887718)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3887718)), CS F) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3887719)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3887719)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D16817E6_135B_4508_A082_6C19AC9542DE#3887720)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_D16817E6_135B_4508_A082_6C19AC9542DE#3887720)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3887721)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3887721)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_71C73F12_7D79_456A_A833_96D8469F46F2#3887723)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_71C73F12_7D79_456A_A833_96D8469F46F2#3887723)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E9867A66_711B_4AA1_A283_E4318900C80F#3887724)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_E9867A66_711B_4AA1_A283_E4318900C80F#3887724)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_DECBC528_D590_4F99_88FD_C86D82DEF299#3887725)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_DECBC528_D590_4F99_88FD_C86D82DEF299#3887725)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#3887726)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#3887726)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#3887727)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#3887727)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#3887728)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#3887728)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#3887729)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#3887729)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_553A0519_208D_498B_AEFE_829D7F40180B#3887730)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_553A0519_208D_498B_AEFE_829D7F40180B#3887730)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3887731)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3887731)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3887732)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3887732)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A655765E_D1A6_4D67_8879_F5186F86A670#3887734)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_A655765E_D1A6_4D67_8879_F5186F86A670#3887734)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3887735)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3887735)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3887736)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3887736)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3887737)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3887737)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3887738)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3887738)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3887739)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3887739)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3887740)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3887740)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3887741)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3887741)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3887742)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3887742)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3887743)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3887743)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_119C9448_3C3F_46EA_80E7_062422A2830D#3887745)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_119C9448_3C3F_46EA_80E7_062422A2830D#3887745)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06CB38F0_2321_426B_AA44_D37094826BC3#3887746)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_06CB38F0_2321_426B_AA44_D37094826BC3#3887746)), CS F) END)
(10) Project
Output: []
Input [26]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3887718, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3887719, COL_D16817E6_135B_4508_A082_6C19AC9542DE#3887720, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3887721, COL_71C73F12_7D79_456A_A833_96D8469F46F2#3887723, COL_E9867A66_711B_4AA1_A283_E4318900C80F#3887724, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#3887725, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#3887726, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#3887727, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#3887728, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#3887729, COL_553A0519_208D_498B_AEFE_829D7F40180B#3887730, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3887731, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3887732, COL_A655765E_D1A6_4D67_8879_F5186F86A670#3887734, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3887735, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3887736, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3887737, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3887738, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3887739, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3887740, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3887741, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3887742, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3887743, COL_119C9448_3C3F_46EA_80E7_062422A2830D#3887745, COL_06CB38F0_2321_426B_AA44_D37094826BC3#3887746]
(11) HashAggregate
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#3888069L]
Results [1]: [count#3888070L]
(12) Exchange
Input [1]: [count#3888070L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=1825923]
(13) HashAggregate
Input [1]: [count#3888070L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#3888066L]
Results [1]: [count(1)#3888066L AS count#3888067L]
(14) AdaptiveSparkPlan
Output [1]: [count#3888067L]
Arguments: isFinalPlan=true