digraph G {
0 [labelType="html" label="<br><b>AdaptiveSparkPlan</b><br><br>"];
1 [labelType="html" label="<br><b>HashAggregate</b><br><br>"];
2 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 9<br>shuffle write time total (min, med, max (stageId: taskId))<br>13 ms (0 ms, 0 ms, 7 ms (stage 45084.0: task 64478))<br>data size total (min, med, max (stageId: taskId))<br>144.0 B (0.0 B, 16.0 B, 16.0 B (stage 45084.0: task 64483))<br>number of partitions: 1<br>shuffle bytes written total (min, med, max (stageId: taskId))<br>507.0 B (0.0 B, 56.0 B, 59.0 B (stage 45084.0: task 64486))"];
subgraph cluster3 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n50.6 s (0 ms, 9 ms, 50.5 s (stage 45084.0: task 64486))";
4 [labelType="html" label="<b>HashAggregate</b><br><br>time in aggregation build total (min, med, max (stageId: taskId))<br>50.6 s (0 ms, 8 ms, 50.5 s (stage 45084.0: task 64486))<br>number of output rows: 9"];
5 [labelType="html" label="<br><b>Project</b><br><br>"];
6 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 354"];
7 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 2,493,718<br>number of input batches: 609"];
}
8 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 1<br>scan time total (min, med, max (stageId: taskId))<br>1.5 s (5 ms, 8 ms, 883 ms (stage 45084.0: task 64481))<br>metadata time: 0 ms<br>size of files read: 192.7 MiB<br>number of output rows: 2,493,718"];
1->0;
2->1;
4->2;
5->4;
6->5;
7->6;
8->7;
}
9
AdaptiveSparkPlan isFinalPlan=false
HashAggregate(keys=[], functions=[count(1)])
Exchange SinglePartition, ENSURE_REQUIREMENTS, [plan_id=1826020]
HashAggregate(keys=[], functions=[partial_count(1)])
Project
Filter ((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478)), CS N) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888479)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888479)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888480)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888480)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888491)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888491)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888492)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888492)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888495)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888495)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888496)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888496)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888497)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888497)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888498)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888498)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888499)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888499)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888500)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888500)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888501)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888501)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888502)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888502)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888503)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888503)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888506)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888506)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888505)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888505)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE))), CS N)) THEN false ELSE Contains(str_remove_accent(upper(str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE))), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((((str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> CS) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> CS N)) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> CS F)) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> APC)), str_join(array(str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE), COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888492), -), null))), CS N)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((((str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> CS) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> CS N)) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> CS F)) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> APC)), str_join(array(str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE), COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888492), -), null))), CS N) END)
ColumnarToRow
WholeStageCodegen (1)
FileScan parquet [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478,COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888479,COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888480,COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481,COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888491,COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888492,COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888495,COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888496,COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888497,COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888498,COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888499,COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888500,COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888501,COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888502,COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888503,COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888505,COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888506] Batched: true, DataFilters: [((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E76BCE3C_BF78_45B5_AC59_..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/00_A_RSF_SOURCE_215882], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF:string,COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730:s...
== Physical Plan ==
AdaptiveSparkPlan (14)
+- == Current Plan ==
HashAggregate (8)
+- ShuffleQueryStage (7)
+- 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 [17]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888479, COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888480, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888491, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888492, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888495, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888496, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888497, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888498, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888499, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888500, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888501, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888502, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888503, COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888505, COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888506]
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_410747F2_ADCB_4C39_B9B9_C56104DAC484:string,COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5: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 [17]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888479, COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888480, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888491, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888492, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888495, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888496, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888497, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888498, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888499, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888500, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888501, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888502, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888503, COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888505, COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888506]
(3) Filter [codegen id : 1]
Input [17]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888479, COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888480, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888491, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888492, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888495, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888496, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888497, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888498, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888499, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888500, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888501, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888502, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888503, COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888505, COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888506]
Condition : ((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478)), CS N) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888479)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888479)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888480)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888480)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888491)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888491)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888492)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888492)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888495)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888495)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888496)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888496)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888497)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888497)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888498)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888498)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888499)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888499)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888500)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888500)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888501)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888501)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888502)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888502)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888503)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888503)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888506)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888506)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888505)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888505)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE))), CS N)) THEN false ELSE Contains(str_remove_accent(upper(str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE))), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((((str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> CS) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> CS N)) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> CS F)) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> APC)), str_join(array(str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE), COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888492), -), null))), CS N)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((((str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> CS) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> CS N)) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> CS F)) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> APC)), str_join(array(str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE), COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888492), -), null))), CS N) END)
(4) Project [codegen id : 1]
Output: []
Input [17]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888479, COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888480, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888491, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888492, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888495, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888496, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888497, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888498, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888499, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888500, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888501, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888502, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888503, COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888505, COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888506]
(5) HashAggregate [codegen id : 1]
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#3888897L]
Results [1]: [count#3888898L]
(6) Exchange
Input [1]: [count#3888898L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=1826020]
(7) ShuffleQueryStage
Output [1]: [count#3888898L]
Arguments: 0
(8) HashAggregate
Input [1]: [count#3888898L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#3888894L]
Results [1]: [count(1)#3888894L AS count#3888895L]
(9) Filter
Input [17]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888479, COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888480, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888491, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888492, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888495, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888496, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888497, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888498, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888499, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888500, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888501, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888502, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888503, COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888505, COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888506]
Condition : ((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478)), CS N) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888479)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888479)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888480)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888480)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888491)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888491)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888492)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888492)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888495)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888495)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888496)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888496)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888497)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888497)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888498)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888498)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888499)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888499)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888500)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888500)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888501)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888501)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888502)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888502)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888503)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888503)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888506)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888506)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888505)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888505)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE))), CS N)) THEN false ELSE Contains(str_remove_accent(upper(str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE))), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((((str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> CS) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> CS N)) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> CS F)) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> APC)), str_join(array(str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE), COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888492), -), null))), CS N)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((((str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> CS) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> CS N)) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> CS F)) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> APC)), str_join(array(str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE), COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888492), -), null))), CS N) END)
(10) Project
Output: []
Input [17]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888479, COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888480, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888491, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888492, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888495, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888496, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888497, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888498, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888499, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888500, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888501, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888502, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888503, COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888505, COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888506]
(11) HashAggregate
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#3888897L]
Results [1]: [count#3888898L]
(12) Exchange
Input [1]: [count#3888898L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=1826000]
(13) HashAggregate
Input [1]: [count#3888898L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#3888894L]
Results [1]: [count(1)#3888894L AS count#3888895L]
(14) AdaptiveSparkPlan
Output [1]: [count#3888895L]
Arguments: isFinalPlan=false