== Physical Plan ==
AdaptiveSparkPlan (89)
+- == Final Plan ==
* HashAggregate (5)
+- ShuffleQueryStage (4), Statistics(sizeInBytes=0.0 B, rowCount=0)
+- Exchange (3)
+- * HashAggregate (2)
+- * LocalTableScan (1)
+- == Initial Plan ==
HashAggregate (88)
+- Exchange (87)
+- HashAggregate (86)
+- Project (85)
+- SortMergeJoin LeftOuter (84)
:- Sort (58)
: +- Exchange (57)
: +- Project (56)
: +- Generate (55)
: +- Project (54)
: +- Project (53)
: +- Filter (52)
: +- Generate (51)
: +- Union (50)
: :- Project (9)
: : +- Project (8)
: : +- Filter (7)
: : +- Scan csv (6)
: :- Project (13)
: : +- Project (12)
: : +- Filter (11)
: : +- Scan parquet (10)
: :- Project (17)
: : +- Project (16)
: : +- Filter (15)
: : +- Scan parquet (14)
: :- Project (21)
: : +- Project (20)
: : +- Filter (19)
: : +- Scan parquet (18)
: :- Project (25)
: : +- Project (24)
: : +- Filter (23)
: : +- Scan parquet (22)
: :- Project (29)
: : +- Project (28)
: : +- Filter (27)
: : +- Scan parquet (26)
: :- Project (33)
: : +- Project (32)
: : +- Filter (31)
: : +- Scan parquet (30)
: :- Project (37)
: : +- Project (36)
: : +- Filter (35)
: : +- Scan parquet (34)
: :- Project (41)
: : +- Project (40)
: : +- Filter (39)
: : +- Scan parquet (38)
: :- Project (45)
: : +- Project (44)
: : +- Filter (43)
: : +- Scan parquet (42)
: +- Project (49)
: +- Project (48)
: +- Filter (47)
: +- Scan parquet (46)
+- Sort (83)
+- Exchange (82)
+- Project (81)
+- CartesianProduct Inner (80)
:- Project (76)
: +- SortMergeJoin Cross (75)
: :- Sort (70)
: : +- Exchange (69)
: : +- Union (68)
: : :- Project (61)
: : : +- Filter (60)
: : : +- Scan parquet (59)
: : :- Project (64)
: : : +- Filter (63)
: : : +- Scan parquet (62)
: : +- Project (67)
: : +- Filter (66)
: : +- Scan parquet (65)
: +- Sort (74)
: +- Exchange (73)
: +- Project (72)
: +- Scan csv (71)
+- Project (79)
+- Filter (78)
+- Scan csv (77)
(1) LocalTableScan [codegen id : 22]
Output: []
Arguments: <empty>
(2) HashAggregate [codegen id : 22]
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#1370092L]
Results [1]: [count#1370093L]
(3) Exchange
Input [1]: [count#1370093L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=716983]
(4) ShuffleQueryStage
Output [1]: [count#1370093L]
Arguments: 4
(5) HashAggregate [codegen id : 23]
Input [1]: [count#1370093L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#1369964L]
Results [1]: [count(1)#1369964L AS count#1369965L]
(6) Scan csv
Output [1]: [c0#1367525]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/execution/empty.csv]
PushedFilters: [IsNotNull(c0)]
ReadSchema: struct<c0:string>
(7) Filter
Input [1]: [c0#1367525]
Condition : ((isnotnull(c0#1367525) AND (size(str_split(str_if_with_rule(CASE WHEN isnull(Contains(c0#1367525, [)) THEN false ELSE Contains(c0#1367525, [) END, str_concat(array(str_extract_by_str(c0#1367525, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(c0#1367525, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(c0#1367525, _, RIGHT))), c0#1367525), ,), true) > 0)) AND isnotnull(str_split(str_if_with_rule(CASE WHEN isnull(Contains(c0#1367525, [)) THEN false ELSE Contains(c0#1367525, [) END, str_concat(array(str_extract_by_str(c0#1367525, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(c0#1367525, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(c0#1367525, _, RIGHT))), c0#1367525), ,)))
(8) Project
Output [3]: [c0#1367525 AS COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1368883, str_if_with_rule(CASE WHEN isnull(Contains(c0#1367525, [)) THEN false ELSE Contains(c0#1367525, [) END, str_concat(array(str_extract_by_str(c0#1367525, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(c0#1367525, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(c0#1367525, _, RIGHT))), c0#1367525) AS COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1368965, str_split(c0#1367525, @) AS COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1368974]
Input [1]: [c0#1367525]
(9) Project
Output [2]: [str_if_with_rule(CASE WHEN isnull(Contains(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1368883, [)) THEN false ELSE Contains(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1368883, [) END, str_join(array(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1368974, 0), str_list_get(str_split(str_remove_extend(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1368974, 1), [[,], ]), ,), 0), str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1368974, 2)), @), COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1368883) AS COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1369091, str_split(COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1368965, ,) AS COL_57A67974_536D_441A_A117_CB017D967D15#1369092]
Input [3]: [COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1368883, COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1368965, COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1368974]
(10) Scan parquet
Output [3]: [COL_02D44CEA_1031_4290_8F23_AB2C6AE7B557#1367475, COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0#1367477, COL_FEC7AB55_AB69_43FE_9E2B_2AC5EA7FE569#1367478]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/05_GR4_SUM_205117]
PushedFilters: [IsNotNull(COL_02D44CEA_1031_4290_8F23_AB2C6AE7B557)]
ReadSchema: struct<COL_02D44CEA_1031_4290_8F23_AB2C6AE7B557:string,COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0:string,COL_FEC7AB55_AB69_43FE_9E2B_2AC5EA7FE569:string>
(11) Filter
Input [3]: [COL_02D44CEA_1031_4290_8F23_AB2C6AE7B557#1367475, COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0#1367477, COL_FEC7AB55_AB69_43FE_9E2B_2AC5EA7FE569#1367478]
Condition : ((isnotnull(COL_02D44CEA_1031_4290_8F23_AB2C6AE7B557#1367475) AND (size(str_split(str_if_with_rule(CASE WHEN isnull(Contains(COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0#1367477, [)) THEN false ELSE Contains(COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0#1367477, [) END, str_concat(array(str_extract_by_str(COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0#1367477, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0#1367477, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0#1367477, _, RIGHT))), COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0#1367477), ,), true) > 0)) AND isnotnull(str_split(str_if_with_rule(CASE WHEN isnull(Contains(COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0#1367477, [)) THEN false ELSE Contains(COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0#1367477, [) END, str_concat(array(str_extract_by_str(COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0#1367477, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0#1367477, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0#1367477, _, RIGHT))), COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0#1367477), ,)))
(12) Project
Output [3]: [COL_FEC7AB55_AB69_43FE_9E2B_2AC5EA7FE569#1367478 AS COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1370025, str_if_with_rule(CASE WHEN isnull(Contains(COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0#1367477, [)) THEN false ELSE Contains(COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0#1367477, [) END, str_concat(array(str_extract_by_str(COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0#1367477, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0#1367477, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0#1367477, _, RIGHT))), COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0#1367477) AS COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1370052, str_split(COL_FEC7AB55_AB69_43FE_9E2B_2AC5EA7FE569#1367478, @) AS COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370053]
Input [3]: [COL_02D44CEA_1031_4290_8F23_AB2C6AE7B557#1367475, COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0#1367477, COL_FEC7AB55_AB69_43FE_9E2B_2AC5EA7FE569#1367478]
(13) Project
Output [2]: [str_if_with_rule(CASE WHEN isnull(Contains(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1370025, [)) THEN false ELSE Contains(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1370025, [) END, str_join(array(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370053, 0), str_list_get(str_split(str_remove_extend(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370053, 1), [[,], ]), ,), 0), str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370053, 2)), @), COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1370025) AS COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1370072, str_split(COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1370052, ,) AS COL_57A67974_536D_441A_A117_CB017D967D15#1370073]
Input [3]: [COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1370025, COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1370052, COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370053]
(14) Scan parquet
Output [3]: [COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#1367427, COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1367429, COL_6425C53C_6469_4002_9B2C_22D29F3F3B08#1367430]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/05_GR3_SUB_SB2__204812]
PushedFilters: [IsNotNull(COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA)]
ReadSchema: struct<COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA:string,COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990:string,COL_6425C53C_6469_4002_9B2C_22D29F3F3B08:string>
(15) Filter
Input [3]: [COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#1367427, COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1367429, COL_6425C53C_6469_4002_9B2C_22D29F3F3B08#1367430]
Condition : ((isnotnull(COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#1367427) AND (size(str_split(str_if_with_rule(CASE WHEN isnull(Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1367429, [)) THEN false ELSE Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1367429, [) END, str_concat(array(str_extract_by_str(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1367429, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1367429, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1367429, _, RIGHT))), COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1367429), ,), true) > 0)) AND isnotnull(str_split(str_if_with_rule(CASE WHEN isnull(Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1367429, [)) THEN false ELSE Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1367429, [) END, str_concat(array(str_extract_by_str(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1367429, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1367429, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1367429, _, RIGHT))), COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1367429), ,)))
(16) Project
Output [3]: [COL_6425C53C_6469_4002_9B2C_22D29F3F3B08#1367430 AS COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1370018, str_if_with_rule(CASE WHEN isnull(Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1367429, [)) THEN false ELSE Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1367429, [) END, str_concat(array(str_extract_by_str(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1367429, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1367429, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1367429, _, RIGHT))), COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1367429) AS COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1370054, str_split(COL_6425C53C_6469_4002_9B2C_22D29F3F3B08#1367430, @) AS COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370055]
Input [3]: [COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#1367427, COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1367429, COL_6425C53C_6469_4002_9B2C_22D29F3F3B08#1367430]
(17) Project
Output [2]: [str_if_with_rule(CASE WHEN isnull(Contains(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1370018, [)) THEN false ELSE Contains(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1370018, [) END, str_join(array(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370055, 0), str_list_get(str_split(str_remove_extend(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370055, 1), [[,], ]), ,), 0), str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370055, 2)), @), COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1370018) AS COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1370074, str_split(COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1370054, ,) AS COL_57A67974_536D_441A_A117_CB017D967D15#1370075]
Input [3]: [COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1370018, COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1370054, COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370055]
(18) Scan parquet
Output [3]: [COL_C1BA47D9_AEF9_436A_BB27_DA703A71CB47#1367458, COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1367460, COL_3E4D50AC_3EF2_419C_9E64_261B846141B7#1367461]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/05_GR1_FPU_FPV__204830]
PushedFilters: [IsNotNull(COL_C1BA47D9_AEF9_436A_BB27_DA703A71CB47)]
ReadSchema: struct<COL_C1BA47D9_AEF9_436A_BB27_DA703A71CB47:string,COL_8E27793F_C19E_4F60_B3EA_298A2C07831D:string,COL_3E4D50AC_3EF2_419C_9E64_261B846141B7:string>
(19) Filter
Input [3]: [COL_C1BA47D9_AEF9_436A_BB27_DA703A71CB47#1367458, COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1367460, COL_3E4D50AC_3EF2_419C_9E64_261B846141B7#1367461]
Condition : ((isnotnull(COL_C1BA47D9_AEF9_436A_BB27_DA703A71CB47#1367458) AND (size(str_split(str_if_with_rule(CASE WHEN isnull(Contains(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1367460, [)) THEN false ELSE Contains(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1367460, [) END, str_concat(array(str_extract_by_str(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1367460, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1367460, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1367460, _, RIGHT))), COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1367460), ,), true) > 0)) AND isnotnull(str_split(str_if_with_rule(CASE WHEN isnull(Contains(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1367460, [)) THEN false ELSE Contains(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1367460, [) END, str_concat(array(str_extract_by_str(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1367460, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1367460, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1367460, _, RIGHT))), COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1367460), ,)))
(20) Project
Output [3]: [COL_3E4D50AC_3EF2_419C_9E64_261B846141B7#1367461 AS COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1370011, str_if_with_rule(CASE WHEN isnull(Contains(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1367460, [)) THEN false ELSE Contains(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1367460, [) END, str_concat(array(str_extract_by_str(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1367460, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1367460, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1367460, _, RIGHT))), COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1367460) AS COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1370056, str_split(COL_3E4D50AC_3EF2_419C_9E64_261B846141B7#1367461, @) AS COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370057]
Input [3]: [COL_C1BA47D9_AEF9_436A_BB27_DA703A71CB47#1367458, COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1367460, COL_3E4D50AC_3EF2_419C_9E64_261B846141B7#1367461]
(21) Project
Output [2]: [str_if_with_rule(CASE WHEN isnull(Contains(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1370011, [)) THEN false ELSE Contains(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1370011, [) END, str_join(array(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370057, 0), str_list_get(str_split(str_remove_extend(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370057, 1), [[,], ]), ,), 0), str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370057, 2)), @), COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1370011) AS COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1370076, str_split(COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1370056, ,) AS COL_57A67974_536D_441A_A117_CB017D967D15#1370077]
Input [3]: [COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1370011, COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1370056, COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370057]
(22) Scan parquet
Output [3]: [COL_6D461599_696B_4415_9E1E_62284656C432#1368466, COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1368470, COL_933B88C4_338B_4EF6_855E_77D0BD55E21B#1368471]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/05_GR2_FU0_FU1__205170]
PushedFilters: [IsNotNull(COL_6D461599_696B_4415_9E1E_62284656C432)]
ReadSchema: struct<COL_6D461599_696B_4415_9E1E_62284656C432:string,COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B:string,COL_933B88C4_338B_4EF6_855E_77D0BD55E21B:string>
(23) Filter
Input [3]: [COL_6D461599_696B_4415_9E1E_62284656C432#1368466, COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1368470, COL_933B88C4_338B_4EF6_855E_77D0BD55E21B#1368471]
Condition : ((isnotnull(COL_6D461599_696B_4415_9E1E_62284656C432#1368466) AND (size(str_split(str_if_with_rule(CASE WHEN isnull(Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1368470, [)) THEN false ELSE Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1368470, [) END, str_concat(array(str_extract_by_str(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1368470, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1368470, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1368470, _, RIGHT))), COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1368470), ,), true) > 0)) AND isnotnull(str_split(str_if_with_rule(CASE WHEN isnull(Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1368470, [)) THEN false ELSE Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1368470, [) END, str_concat(array(str_extract_by_str(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1368470, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1368470, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1368470, _, RIGHT))), COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1368470), ,)))
(24) Project
Output [3]: [COL_933B88C4_338B_4EF6_855E_77D0BD55E21B#1368471 AS COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1370004, str_if_with_rule(CASE WHEN isnull(Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1368470, [)) THEN false ELSE Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1368470, [) END, str_concat(array(str_extract_by_str(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1368470, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1368470, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1368470, _, RIGHT))), COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1368470) AS COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1370058, str_split(COL_933B88C4_338B_4EF6_855E_77D0BD55E21B#1368471, @) AS COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370059]
Input [3]: [COL_6D461599_696B_4415_9E1E_62284656C432#1368466, COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1368470, COL_933B88C4_338B_4EF6_855E_77D0BD55E21B#1368471]
(25) Project
Output [2]: [str_if_with_rule(CASE WHEN isnull(Contains(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1370004, [)) THEN false ELSE Contains(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1370004, [) END, str_join(array(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370059, 0), str_list_get(str_split(str_remove_extend(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370059, 1), [[,], ]), ,), 0), str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370059, 2)), @), COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1370004) AS COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1370078, str_split(COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1370058, ,) AS COL_57A67974_536D_441A_A117_CB017D967D15#1370079]
Input [3]: [COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1370004, COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1370058, COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370059]
(26) Scan parquet
Output [3]: [COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#1367555, COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1367557, COL_EB745243_852A_470C_A1E1_722CE684E626#1367559]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/05_GR5_SU2_SU3_205130]
PushedFilters: [IsNotNull(COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA)]
ReadSchema: struct<COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA:string,COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B:string,COL_EB745243_852A_470C_A1E1_722CE684E626:string>
(27) Filter
Input [3]: [COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#1367555, COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1367557, COL_EB745243_852A_470C_A1E1_722CE684E626#1367559]
Condition : ((isnotnull(COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#1367555) AND (size(str_split(str_if_with_rule(CASE WHEN isnull(Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1367557, [)) THEN false ELSE Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1367557, [) END, str_concat(array(str_extract_by_str(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1367557, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1367557, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1367557, _, RIGHT))), COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1367557), ,), true) > 0)) AND isnotnull(str_split(str_if_with_rule(CASE WHEN isnull(Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1367557, [)) THEN false ELSE Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1367557, [) END, str_concat(array(str_extract_by_str(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1367557, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1367557, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1367557, _, RIGHT))), COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1367557), ,)))
(28) Project
Output [3]: [COL_EB745243_852A_470C_A1E1_722CE684E626#1367559 AS COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1369997, str_if_with_rule(CASE WHEN isnull(Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1367557, [)) THEN false ELSE Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1367557, [) END, str_concat(array(str_extract_by_str(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1367557, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1367557, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1367557, _, RIGHT))), COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1367557) AS COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1370060, str_split(COL_EB745243_852A_470C_A1E1_722CE684E626#1367559, @) AS COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370061]
Input [3]: [COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#1367555, COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1367557, COL_EB745243_852A_470C_A1E1_722CE684E626#1367559]
(29) Project
Output [2]: [str_if_with_rule(CASE WHEN isnull(Contains(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1369997, [)) THEN false ELSE Contains(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1369997, [) END, str_join(array(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370061, 0), str_list_get(str_split(str_remove_extend(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370061, 1), [[,], ]), ,), 0), str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370061, 2)), @), COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1369997) AS COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1370080, str_split(COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1370060, ,) AS COL_57A67974_536D_441A_A117_CB017D967D15#1370081]
Input [3]: [COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1369997, COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1370060, COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370061]
(30) Scan parquet
Output [3]: [COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1367447, COL_D6EF6DFC_79A6_470E_BA52_073402820059#1367449, COL_7C996DEA_C14E_49A5_B230_77E504C67A0F#1367450]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/05_GR7_SUN_SUF_204823]
PushedFilters: [IsNotNull(COL_680B8808_CA1F_43BB_9FD6_545FE101582E)]
ReadSchema: struct<COL_680B8808_CA1F_43BB_9FD6_545FE101582E:string,COL_D6EF6DFC_79A6_470E_BA52_073402820059:string,COL_7C996DEA_C14E_49A5_B230_77E504C67A0F:string>
(31) Filter
Input [3]: [COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1367447, COL_D6EF6DFC_79A6_470E_BA52_073402820059#1367449, COL_7C996DEA_C14E_49A5_B230_77E504C67A0F#1367450]
Condition : ((isnotnull(COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1367447) AND (size(str_split(str_if_with_rule(CASE WHEN isnull(Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1367449, [)) THEN false ELSE Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1367449, [) END, str_concat(array(str_extract_by_str(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1367449, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1367449, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1367449, _, RIGHT))), COL_D6EF6DFC_79A6_470E_BA52_073402820059#1367449), ,), true) > 0)) AND isnotnull(str_split(str_if_with_rule(CASE WHEN isnull(Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1367449, [)) THEN false ELSE Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1367449, [) END, str_concat(array(str_extract_by_str(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1367449, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1367449, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1367449, _, RIGHT))), COL_D6EF6DFC_79A6_470E_BA52_073402820059#1367449), ,)))
(32) Project
Output [3]: [COL_7C996DEA_C14E_49A5_B230_77E504C67A0F#1367450 AS COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1369990, str_if_with_rule(CASE WHEN isnull(Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1367449, [)) THEN false ELSE Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1367449, [) END, str_concat(array(str_extract_by_str(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1367449, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1367449, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1367449, _, RIGHT))), COL_D6EF6DFC_79A6_470E_BA52_073402820059#1367449) AS COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1370062, str_split(COL_7C996DEA_C14E_49A5_B230_77E504C67A0F#1367450, @) AS COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370063]
Input [3]: [COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1367447, COL_D6EF6DFC_79A6_470E_BA52_073402820059#1367449, COL_7C996DEA_C14E_49A5_B230_77E504C67A0F#1367450]
(33) Project
Output [2]: [str_if_with_rule(CASE WHEN isnull(Contains(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1369990, [)) THEN false ELSE Contains(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1369990, [) END, str_join(array(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370063, 0), str_list_get(str_split(str_remove_extend(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370063, 1), [[,], ]), ,), 0), str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370063, 2)), @), COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1369990) AS COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1370082, str_split(COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1370062, ,) AS COL_57A67974_536D_441A_A117_CB017D967D15#1370083]
Input [3]: [COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1369990, COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1370062, COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370063]
(34) Scan parquet
Output [3]: [COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1367491, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367493, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#1367494]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/05_GR6_SSN_SSF_204680]
PushedFilters: [IsNotNull(COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA)]
ReadSchema: struct<COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA:string,COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2:string,COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30:string>
(35) Filter
Input [3]: [COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1367491, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367493, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#1367494]
Condition : ((isnotnull(COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1367491) AND (size(str_split(str_if_with_rule(CASE WHEN isnull(Contains(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367493, [)) THEN false ELSE Contains(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367493, [) END, str_concat(array(str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367493, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367493, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367493, _, RIGHT))), COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367493), ,), true) > 0)) AND isnotnull(str_split(str_if_with_rule(CASE WHEN isnull(Contains(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367493, [)) THEN false ELSE Contains(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367493, [) END, str_concat(array(str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367493, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367493, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367493, _, RIGHT))), COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367493), ,)))
(36) Project
Output [3]: [COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#1367494 AS COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1369983, str_if_with_rule(CASE WHEN isnull(Contains(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367493, [)) THEN false ELSE Contains(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367493, [) END, str_concat(array(str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367493, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367493, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367493, _, RIGHT))), COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367493) AS COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1370064, str_split(COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#1367494, @) AS COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370065]
Input [3]: [COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1367491, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367493, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#1367494]
(37) Project
Output [2]: [str_if_with_rule(CASE WHEN isnull(Contains(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1369983, [)) THEN false ELSE Contains(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1369983, [) END, str_join(array(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370065, 0), str_list_get(str_split(str_remove_extend(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370065, 1), [[,], ]), ,), 0), str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370065, 2)), @), COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1369983) AS COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1370084, str_split(COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1370064, ,) AS COL_57A67974_536D_441A_A117_CB017D967D15#1370085]
Input [3]: [COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1369983, COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1370064, COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370065]
(38) Scan parquet
Output [3]: [COL_37FB33EF_F56C_40A0_8E69_3CD53BA5E5BD#1367415, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367417, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#1367418]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/05_GR6_SAS_204733]
PushedFilters: [IsNotNull(COL_37FB33EF_F56C_40A0_8E69_3CD53BA5E5BD)]
ReadSchema: struct<COL_37FB33EF_F56C_40A0_8E69_3CD53BA5E5BD:string,COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2:string,COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30:string>
(39) Filter
Input [3]: [COL_37FB33EF_F56C_40A0_8E69_3CD53BA5E5BD#1367415, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367417, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#1367418]
Condition : ((isnotnull(COL_37FB33EF_F56C_40A0_8E69_3CD53BA5E5BD#1367415) AND (size(str_split(str_if_with_rule(CASE WHEN isnull(Contains(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367417, [)) THEN false ELSE Contains(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367417, [) END, str_concat(array(str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367417, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367417, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367417, _, RIGHT))), COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367417), ,), true) > 0)) AND isnotnull(str_split(str_if_with_rule(CASE WHEN isnull(Contains(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367417, [)) THEN false ELSE Contains(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367417, [) END, str_concat(array(str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367417, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367417, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367417, _, RIGHT))), COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367417), ,)))
(40) Project
Output [3]: [COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#1367418 AS COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1369976, str_if_with_rule(CASE WHEN isnull(Contains(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367417, [)) THEN false ELSE Contains(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367417, [) END, str_concat(array(str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367417, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367417, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367417, _, RIGHT))), COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367417) AS COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1370066, str_split(COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#1367418, @) AS COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370067]
Input [3]: [COL_37FB33EF_F56C_40A0_8E69_3CD53BA5E5BD#1367415, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367417, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#1367418]
(41) Project
Output [2]: [str_if_with_rule(CASE WHEN isnull(Contains(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1369976, [)) THEN false ELSE Contains(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1369976, [) END, str_join(array(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370067, 0), str_list_get(str_split(str_remove_extend(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370067, 1), [[,], ]), ,), 0), str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370067, 2)), @), COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1369976) AS COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1370086, str_split(COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1370066, ,) AS COL_57A67974_536D_441A_A117_CB017D967D15#1370087]
Input [3]: [COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1369976, COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1370066, COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370067]
(42) Scan parquet
Output [3]: [COL_D055870D_7682_4410_A82D_BC4C41964169#1367571, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367573, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#1367574]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/05_GR6_SIC_SIM_204690]
PushedFilters: [IsNotNull(COL_D055870D_7682_4410_A82D_BC4C41964169)]
ReadSchema: struct<COL_D055870D_7682_4410_A82D_BC4C41964169:string,COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2:string,COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30:string>
(43) Filter
Input [3]: [COL_D055870D_7682_4410_A82D_BC4C41964169#1367571, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367573, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#1367574]
Condition : ((isnotnull(COL_D055870D_7682_4410_A82D_BC4C41964169#1367571) AND (size(str_split(str_if_with_rule(CASE WHEN isnull(Contains(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367573, [)) THEN false ELSE Contains(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367573, [) END, str_concat(array(str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367573, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367573, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367573, _, RIGHT))), COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367573), ,), true) > 0)) AND isnotnull(str_split(str_if_with_rule(CASE WHEN isnull(Contains(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367573, [)) THEN false ELSE Contains(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367573, [) END, str_concat(array(str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367573, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367573, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367573, _, RIGHT))), COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367573), ,)))
(44) Project
Output [3]: [COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#1367574 AS COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1369969, str_if_with_rule(CASE WHEN isnull(Contains(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367573, [)) THEN false ELSE Contains(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367573, [) END, str_concat(array(str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367573, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367573, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367573, _, RIGHT))), COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367573) AS COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1370068, str_split(COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#1367574, @) AS COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370069]
Input [3]: [COL_D055870D_7682_4410_A82D_BC4C41964169#1367571, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367573, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#1367574]
(45) Project
Output [2]: [str_if_with_rule(CASE WHEN isnull(Contains(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1369969, [)) THEN false ELSE Contains(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1369969, [) END, str_join(array(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370069, 0), str_list_get(str_split(str_remove_extend(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370069, 1), [[,], ]), ,), 0), str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370069, 2)), @), COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1369969) AS COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1370088, str_split(COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1370068, ,) AS COL_57A67974_536D_441A_A117_CB017D967D15#1370089]
Input [3]: [COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1369969, COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1370068, COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370069]
(46) Scan parquet
Output [3]: [COL_6A75989B_D287_4B6C_893B_7D78A3023D30#1367397, COL_910DC838_241D_4365_A8A3_070714C6238B#1367400, COL_481586E2_E506_44E5_9DC4_79601A1736D6#1367401]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/05_GR8_DOUBLON__205219]
PushedFilters: [IsNotNull(COL_6A75989B_D287_4B6C_893B_7D78A3023D30)]
ReadSchema: struct<COL_6A75989B_D287_4B6C_893B_7D78A3023D30:string,COL_910DC838_241D_4365_A8A3_070714C6238B:string,COL_481586E2_E506_44E5_9DC4_79601A1736D6:string>
(47) Filter
Input [3]: [COL_6A75989B_D287_4B6C_893B_7D78A3023D30#1367397, COL_910DC838_241D_4365_A8A3_070714C6238B#1367400, COL_481586E2_E506_44E5_9DC4_79601A1736D6#1367401]
Condition : ((isnotnull(COL_6A75989B_D287_4B6C_893B_7D78A3023D30#1367397) AND (size(str_split(str_if_with_rule(CASE WHEN isnull(Contains(COL_910DC838_241D_4365_A8A3_070714C6238B#1367400, [)) THEN false ELSE Contains(COL_910DC838_241D_4365_A8A3_070714C6238B#1367400, [) END, str_concat(array(str_extract_by_str(COL_910DC838_241D_4365_A8A3_070714C6238B#1367400, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_910DC838_241D_4365_A8A3_070714C6238B#1367400, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_910DC838_241D_4365_A8A3_070714C6238B#1367400, _, RIGHT))), COL_910DC838_241D_4365_A8A3_070714C6238B#1367400), ,), true) > 0)) AND isnotnull(str_split(str_if_with_rule(CASE WHEN isnull(Contains(COL_910DC838_241D_4365_A8A3_070714C6238B#1367400, [)) THEN false ELSE Contains(COL_910DC838_241D_4365_A8A3_070714C6238B#1367400, [) END, str_concat(array(str_extract_by_str(COL_910DC838_241D_4365_A8A3_070714C6238B#1367400, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_910DC838_241D_4365_A8A3_070714C6238B#1367400, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_910DC838_241D_4365_A8A3_070714C6238B#1367400, _, RIGHT))), COL_910DC838_241D_4365_A8A3_070714C6238B#1367400), ,)))
(48) Project
Output [3]: [COL_481586E2_E506_44E5_9DC4_79601A1736D6#1367401, str_if_with_rule(CASE WHEN isnull(Contains(COL_910DC838_241D_4365_A8A3_070714C6238B#1367400, [)) THEN false ELSE Contains(COL_910DC838_241D_4365_A8A3_070714C6238B#1367400, [) END, str_concat(array(str_extract_by_str(COL_910DC838_241D_4365_A8A3_070714C6238B#1367400, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_910DC838_241D_4365_A8A3_070714C6238B#1367400, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_910DC838_241D_4365_A8A3_070714C6238B#1367400, _, RIGHT))), COL_910DC838_241D_4365_A8A3_070714C6238B#1367400) AS COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1370070, str_split(COL_481586E2_E506_44E5_9DC4_79601A1736D6#1367401, @) AS COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370071]
Input [3]: [COL_6A75989B_D287_4B6C_893B_7D78A3023D30#1367397, COL_910DC838_241D_4365_A8A3_070714C6238B#1367400, COL_481586E2_E506_44E5_9DC4_79601A1736D6#1367401]
(49) Project
Output [2]: [str_if_with_rule(CASE WHEN isnull(Contains(COL_481586E2_E506_44E5_9DC4_79601A1736D6#1367401, [)) THEN false ELSE Contains(COL_481586E2_E506_44E5_9DC4_79601A1736D6#1367401, [) END, str_join(array(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370071, 0), str_list_get(str_split(str_remove_extend(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370071, 1), [[,], ]), ,), 0), str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370071, 2)), @), COL_481586E2_E506_44E5_9DC4_79601A1736D6#1367401) AS COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1370090, str_split(COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1370070, ,) AS COL_57A67974_536D_441A_A117_CB017D967D15#1370091]
Input [3]: [COL_481586E2_E506_44E5_9DC4_79601A1736D6#1367401, COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1370070, COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1370071]
(50) Union
(51) Generate
Input [2]: [COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1369091, COL_57A67974_536D_441A_A117_CB017D967D15#1369092]
Arguments: explode(COL_57A67974_536D_441A_A117_CB017D967D15#1369092), [COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1369091], false, [COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108]
(52) Filter
Input [2]: [COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1369091, COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108]
Condition : ((size(str_split(str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x, LEFT), 1) <=> 2), str_join(array(str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x, RIGHT), COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108), str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x, RIGHT), COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108)), ,), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x, LEFT), 1) <=> 3), str_join(array(str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x, RIGHT), COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108), str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x, RIGHT), COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108), str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x, RIGHT), COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108)), ,), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x, LEFT), 1) <=> 4), str_join(array(str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x, RIGHT), COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108), str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x, RIGHT), COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108), str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x, RIGHT), COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108), str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x, RIGHT), COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108)), ,), str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x, RIGHT), COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108)))), ,), true) > 0) AND isnotnull(str_split(str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x, LEFT), 1) <=> 2), str_join(array(str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x, RIGHT), COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108), str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x, RIGHT), COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108)), ,), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x, LEFT), 1) <=> 3), str_join(array(str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x, RIGHT), COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108), str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x, RIGHT), COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108), str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x, RIGHT), COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108)), ,), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x, LEFT), 1) <=> 4), str_join(array(str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x, RIGHT), COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108), str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x, RIGHT), COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108), str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x, RIGHT), COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108), str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x, RIGHT), COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108)), ,), str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x, RIGHT), COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108)))), ,)))
(53) Project
Output [3]: [COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1369091, str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x, LEFT), 1) AS COL_74E4AA79_E475_4A8C_9DF2_DFCCEC22A999#1369209, str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108, x, RIGHT), COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108) AS COL_939D5ED4_4BBE_4A87_A8A2_1A6889E61C8C#1369210]
Input [2]: [COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1369091, COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1369108]
(54) Project
Output [3]: [COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1369091, COL_939D5ED4_4BBE_4A87_A8A2_1A6889E61C8C#1369210, str_split(str_if_with_rule((COL_74E4AA79_E475_4A8C_9DF2_DFCCEC22A999#1369209 <=> 2), str_join(array(COL_939D5ED4_4BBE_4A87_A8A2_1A6889E61C8C#1369210, COL_939D5ED4_4BBE_4A87_A8A2_1A6889E61C8C#1369210), ,), str_if_with_rule((COL_74E4AA79_E475_4A8C_9DF2_DFCCEC22A999#1369209 <=> 3), str_join(array(COL_939D5ED4_4BBE_4A87_A8A2_1A6889E61C8C#1369210, COL_939D5ED4_4BBE_4A87_A8A2_1A6889E61C8C#1369210, COL_939D5ED4_4BBE_4A87_A8A2_1A6889E61C8C#1369210), ,), str_if_with_rule((COL_74E4AA79_E475_4A8C_9DF2_DFCCEC22A999#1369209 <=> 4), str_join(array(COL_939D5ED4_4BBE_4A87_A8A2_1A6889E61C8C#1369210, COL_939D5ED4_4BBE_4A87_A8A2_1A6889E61C8C#1369210, COL_939D5ED4_4BBE_4A87_A8A2_1A6889E61C8C#1369210, COL_939D5ED4_4BBE_4A87_A8A2_1A6889E61C8C#1369210), ,), COL_939D5ED4_4BBE_4A87_A8A2_1A6889E61C8C#1369210))), ,) AS COL_61AA9492_75C1_4D8D_9A82_1FC107966A1A#1369265]
Input [3]: [COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1369091, COL_74E4AA79_E475_4A8C_9DF2_DFCCEC22A999#1369209, COL_939D5ED4_4BBE_4A87_A8A2_1A6889E61C8C#1369210]
(55) Generate
Input [3]: [COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1369091, COL_939D5ED4_4BBE_4A87_A8A2_1A6889E61C8C#1369210, COL_61AA9492_75C1_4D8D_9A82_1FC107966A1A#1369265]
Arguments: explode(COL_61AA9492_75C1_4D8D_9A82_1FC107966A1A#1369265), [COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1369091, COL_939D5ED4_4BBE_4A87_A8A2_1A6889E61C8C#1369210], false, [COL_CBC48D63_A38A_42F7_8994_3AAE60BEF796#1369280]
(56) Project
Output [2]: [str_remove_space(str_extract_by_str(str_remove(COL_CBC48D63_A38A_42F7_8994_3AAE60BEF796#1369280, str_if_with_rule((((((CASE WHEN isnull(StartsWith(COL_CBC48D63_A38A_42F7_8994_3AAE60BEF796#1369280, SIC)) THEN false ELSE StartsWith(COL_CBC48D63_A38A_42F7_8994_3AAE60BEF796#1369280, SIC) END OR CASE WHEN isnull(StartsWith(COL_CBC48D63_A38A_42F7_8994_3AAE60BEF796#1369280, SIM)) THEN false ELSE StartsWith(COL_CBC48D63_A38A_42F7_8994_3AAE60BEF796#1369280, SIM) END) OR CASE WHEN isnull(StartsWith(COL_CBC48D63_A38A_42F7_8994_3AAE60BEF796#1369280, SSN)) THEN false ELSE StartsWith(COL_CBC48D63_A38A_42F7_8994_3AAE60BEF796#1369280, SSN) END) OR CASE WHEN isnull(StartsWith(COL_CBC48D63_A38A_42F7_8994_3AAE60BEF796#1369280, SSF)) THEN false ELSE StartsWith(COL_CBC48D63_A38A_42F7_8994_3AAE60BEF796#1369280, SSF) END) OR CASE WHEN isnull(StartsWith(COL_CBC48D63_A38A_42F7_8994_3AAE60BEF796#1369280, SAS)) THEN false ELSE StartsWith(COL_CBC48D63_A38A_42F7_8994_3AAE60BEF796#1369280, SAS) END) OR CASE WHEN isnull(Contains(COL_939D5ED4_4BBE_4A87_A8A2_1A6889E61C8C#1369210, !)) THEN false ELSE Contains(COL_939D5ED4_4BBE_4A87_A8A2_1A6889E61C8C#1369210, !) END), str_extract(str_list_get(str_split(COL_CBC48D63_A38A_42F7_8994_3AAE60BEF796#1369280, !), 0), RIGHT, 1), str_extract(COL_CBC48D63_A38A_42F7_8994_3AAE60BEF796#1369280, RIGHT, 1))), !, LEFT), ALL) AS COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1369556, str_to_datez(str_create(str_list_get(str_split(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1369091, @), 1)), ddMMyyyy, Europe/Paris, fr_FR) AS COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#1369561]
Input [3]: [COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1369091, COL_939D5ED4_4BBE_4A87_A8A2_1A6889E61C8C#1369210, COL_CBC48D63_A38A_42F7_8994_3AAE60BEF796#1369280]
(57) Exchange
Input [2]: [COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1369556, COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#1369561]
Arguments: hashpartitioning(COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1369556, 10), ENSURE_REQUIREMENTS, [plan_id=715577]
(58) Sort
Input [2]: [COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1369556, COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#1369561]
Arguments: [COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1369556 ASC NULLS FIRST], false, 0
(59) Scan parquet
Output [4]: [Code+Acte#1367883, Date_effet#1367886, Date_r%C3%A9vocation#1367887, Trigramme#1367888]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/TARIF_FORFAIT_S_204547_274be423bf1a3d58c0f39a2302df7a46/Region-PUBGUAMAR_tarifs_forfait_urgences.xlsx_5d546fbfc1e3b1698716e5202de40c38]
PushedFilters: [IsNotNull(`Code+Acte`)]
ReadSchema: struct<Code+Acte:string,Date_effet:string,Date_r%C3%A9vocation:string,Trigramme:string>
(60) Filter
Input [4]: [Code+Acte#1367883, Date_effet#1367886, Date_r%C3%A9vocation#1367887, Trigramme#1367888]
Condition : ((isnotnull(Code+Acte#1367883) AND isnotnull(str_to_datez(Date_effet#1367886, dd/MM/yyyy, null, null))) AND isnotnull(str_to_datez(Date_r%C3%A9vocation#1367887, dd/MM/yyyy, null, null)))
(61) Project
Output [4]: [Code+Acte#1367883 AS COL_F05D8F93_FCBE_4BA2_9D4A_3C8081F87ED3#1368201, str_to_datez(Date_effet#1367886, dd/MM/yyyy, null, null) AS COL_1D6A3709_2A33_426C_B4B5_1DA6C10FD0F8#1368204, str_to_datez(Date_r%C3%A9vocation#1367887, dd/MM/yyyy, null, null) AS COL_D015AE15_A356_4304_B074_7B20946EFE9F#1368205, Trigramme#1367888 AS COL_C2DEADC4_EC1C_44BB_94AA_E5A923AE1BC6#1368206]
Input [4]: [Code+Acte#1367883, Date_effet#1367886, Date_r%C3%A9vocation#1367887, Trigramme#1367888]
(62) Scan parquet
Output [4]: [Code+Acte#1367954, Date_effet#1367957, Date_r%C3%A9vocation#1367958, Trigramme#1367959]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/TARIF_FORFAIT_S_204547_b255eb64d67b40991c7bed86f8ee8a79/Region-PUBGUYRE_tarifs_forfait_urgences.xlsx_cc307cf742b139dc7c9231b83236d243]
PushedFilters: [IsNotNull(`Code+Acte`)]
ReadSchema: struct<Code+Acte:string,Date_effet:string,Date_r%C3%A9vocation:string,Trigramme:string>
(63) Filter
Input [4]: [Code+Acte#1367954, Date_effet#1367957, Date_r%C3%A9vocation#1367958, Trigramme#1367959]
Condition : ((isnotnull(Code+Acte#1367954) AND isnotnull(str_to_datez(Date_effet#1367957, dd/MM/yyyy, null, null))) AND isnotnull(str_to_datez(Date_r%C3%A9vocation#1367958, dd/MM/yyyy, null, null)))
(64) Project
Output [4]: [Code+Acte#1367954 AS COL_F05D8F93_FCBE_4BA2_9D4A_3C8081F87ED3#1370044, str_to_datez(Date_effet#1367957, dd/MM/yyyy, null, null) AS COL_1D6A3709_2A33_426C_B4B5_1DA6C10FD0F8#1370045, str_to_datez(Date_r%C3%A9vocation#1367958, dd/MM/yyyy, null, null) AS COL_D015AE15_A356_4304_B074_7B20946EFE9F#1370046, Trigramme#1367959 AS COL_C2DEADC4_EC1C_44BB_94AA_E5A923AE1BC6#1370047]
Input [4]: [Code+Acte#1367954, Date_effet#1367957, Date_r%C3%A9vocation#1367958, Trigramme#1367959]
(65) Scan parquet
Output [4]: [Code+Acte#1368032, Date_effet#1368035, Date_r%C3%A9vocation#1368036, Trigramme#1368037]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/TARIF_FORFAIT_S_204547_a01b941d8e1c3b188589c3065ab053d6/Region-PUBMET_tarifs_forfait_urgences.xlsx_55aacabb831c5dadfd3753786ad24321]
PushedFilters: [IsNotNull(`Code+Acte`)]
ReadSchema: struct<Code+Acte:string,Date_effet:string,Date_r%C3%A9vocation:string,Trigramme:string>
(66) Filter
Input [4]: [Code+Acte#1368032, Date_effet#1368035, Date_r%C3%A9vocation#1368036, Trigramme#1368037]
Condition : ((isnotnull(Code+Acte#1368032) AND isnotnull(str_to_datez(Date_effet#1368035, dd/MM/yyyy, null, null))) AND isnotnull(str_to_datez(Date_r%C3%A9vocation#1368036, dd/MM/yyyy, null, null)))
(67) Project
Output [4]: [Code+Acte#1368032 AS COL_F05D8F93_FCBE_4BA2_9D4A_3C8081F87ED3#1370048, str_to_datez(Date_effet#1368035, dd/MM/yyyy, null, null) AS COL_1D6A3709_2A33_426C_B4B5_1DA6C10FD0F8#1370049, str_to_datez(Date_r%C3%A9vocation#1368036, dd/MM/yyyy, null, null) AS COL_D015AE15_A356_4304_B074_7B20946EFE9F#1370050, Trigramme#1368037 AS COL_C2DEADC4_EC1C_44BB_94AA_E5A923AE1BC6#1370051]
Input [4]: [Code+Acte#1368032, Date_effet#1368035, Date_r%C3%A9vocation#1368036, Trigramme#1368037]
(68) Union
(69) Exchange
Input [4]: [COL_F05D8F93_FCBE_4BA2_9D4A_3C8081F87ED3#1368201, COL_1D6A3709_2A33_426C_B4B5_1DA6C10FD0F8#1368204, COL_D015AE15_A356_4304_B074_7B20946EFE9F#1368205, COL_C2DEADC4_EC1C_44BB_94AA_E5A923AE1BC6#1368206]
Arguments: hashpartitioning(coalesce(COL_C2DEADC4_EC1C_44BB_94AA_E5A923AE1BC6#1368206, ), isnull(COL_C2DEADC4_EC1C_44BB_94AA_E5A923AE1BC6#1368206), 10), ENSURE_REQUIREMENTS, [plan_id=715565]
(70) Sort
Input [4]: [COL_F05D8F93_FCBE_4BA2_9D4A_3C8081F87ED3#1368201, COL_1D6A3709_2A33_426C_B4B5_1DA6C10FD0F8#1368204, COL_D015AE15_A356_4304_B074_7B20946EFE9F#1368205, COL_C2DEADC4_EC1C_44BB_94AA_E5A923AE1BC6#1368206]
Arguments: [coalesce(COL_C2DEADC4_EC1C_44BB_94AA_E5A923AE1BC6#1368206, ) ASC NULLS FIRST, isnull(COL_C2DEADC4_EC1C_44BB_94AA_E5A923AE1BC6#1368206) ASC NULLS FIRST], false, 0
(71) Scan csv
Output [1]: [region-tarif#1367662]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/execution/INFO_DATAAPPS_204516/current/info_dataapps.csv]
ReadSchema: struct<region-tarif:string>
(72) Project
Output [1]: [region-tarif#1367662 AS INFO_DATAAPPS_204709_COL_5EF90F7F_94BB_48D9_B288_FA990D2ABCB2#1368217]
Input [1]: [region-tarif#1367662]
(73) Exchange
Input [1]: [INFO_DATAAPPS_204709_COL_5EF90F7F_94BB_48D9_B288_FA990D2ABCB2#1368217]
Arguments: hashpartitioning(coalesce(INFO_DATAAPPS_204709_COL_5EF90F7F_94BB_48D9_B288_FA990D2ABCB2#1368217, ), isnull(INFO_DATAAPPS_204709_COL_5EF90F7F_94BB_48D9_B288_FA990D2ABCB2#1368217), 10), ENSURE_REQUIREMENTS, [plan_id=715566]
(74) Sort
Input [1]: [INFO_DATAAPPS_204709_COL_5EF90F7F_94BB_48D9_B288_FA990D2ABCB2#1368217]
Arguments: [coalesce(INFO_DATAAPPS_204709_COL_5EF90F7F_94BB_48D9_B288_FA990D2ABCB2#1368217, ) ASC NULLS FIRST, isnull(INFO_DATAAPPS_204709_COL_5EF90F7F_94BB_48D9_B288_FA990D2ABCB2#1368217) ASC NULLS FIRST], false, 0
(75) SortMergeJoin
Left keys [2]: [coalesce(COL_C2DEADC4_EC1C_44BB_94AA_E5A923AE1BC6#1368206, ), isnull(COL_C2DEADC4_EC1C_44BB_94AA_E5A923AE1BC6#1368206)]
Right keys [2]: [coalesce(INFO_DATAAPPS_204709_COL_5EF90F7F_94BB_48D9_B288_FA990D2ABCB2#1368217, ), isnull(INFO_DATAAPPS_204709_COL_5EF90F7F_94BB_48D9_B288_FA990D2ABCB2#1368217)]
Join type: Cross
Join condition: None
(76) Project
Output [3]: [COL_F05D8F93_FCBE_4BA2_9D4A_3C8081F87ED3#1368201, COL_1D6A3709_2A33_426C_B4B5_1DA6C10FD0F8#1368204, COL_D015AE15_A356_4304_B074_7B20946EFE9F#1368205]
Input [5]: [COL_F05D8F93_FCBE_4BA2_9D4A_3C8081F87ED3#1368201, COL_1D6A3709_2A33_426C_B4B5_1DA6C10FD0F8#1368204, COL_D015AE15_A356_4304_B074_7B20946EFE9F#1368205, COL_C2DEADC4_EC1C_44BB_94AA_E5A923AE1BC6#1368206, INFO_DATAAPPS_204709_COL_5EF90F7F_94BB_48D9_B288_FA990D2ABCB2#1368217]
(77) Scan csv
Output [1]: [REGLES#1367607]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/REGLES_APPLICAB_204526/REGLES-A-TTT new.csv]
PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,FP-TO-LC)]
ReadSchema: struct<REGLES:string>
(78) Filter
Input [1]: [REGLES#1367607]
Condition : (isnotnull(REGLES#1367607) AND (FP-TO-LC = REGLES#1367607))
(79) Project
Output: []
Input [1]: [REGLES#1367607]
(80) CartesianProduct
Join type: Inner
Join condition: None
(81) Project
Output [3]: [COL_F05D8F93_FCBE_4BA2_9D4A_3C8081F87ED3#1368201 AS TARIFS_DES_FORF_204701_COL_F05D8F93_FCBE_4BA2_9D4A_3C8081F87ED3#1369587, COL_1D6A3709_2A33_426C_B4B5_1DA6C10FD0F8#1368204 AS TARIFS_DES_FORF_204701_COL_1D6A3709_2A33_426C_B4B5_1DA6C10FD0F8#1369590, COL_D015AE15_A356_4304_B074_7B20946EFE9F#1368205 AS TARIFS_DES_FORF_204701_COL_D015AE15_A356_4304_B074_7B20946EFE9F#1369591]
Input [3]: [COL_F05D8F93_FCBE_4BA2_9D4A_3C8081F87ED3#1368201, COL_1D6A3709_2A33_426C_B4B5_1DA6C10FD0F8#1368204, COL_D015AE15_A356_4304_B074_7B20946EFE9F#1368205]
(82) Exchange
Input [3]: [TARIFS_DES_FORF_204701_COL_F05D8F93_FCBE_4BA2_9D4A_3C8081F87ED3#1369587, TARIFS_DES_FORF_204701_COL_1D6A3709_2A33_426C_B4B5_1DA6C10FD0F8#1369590, TARIFS_DES_FORF_204701_COL_D015AE15_A356_4304_B074_7B20946EFE9F#1369591]
Arguments: hashpartitioning(TARIFS_DES_FORF_204701_COL_F05D8F93_FCBE_4BA2_9D4A_3C8081F87ED3#1369587, 10), ENSURE_REQUIREMENTS, [plan_id=715578]
(83) Sort
Input [3]: [TARIFS_DES_FORF_204701_COL_F05D8F93_FCBE_4BA2_9D4A_3C8081F87ED3#1369587, TARIFS_DES_FORF_204701_COL_1D6A3709_2A33_426C_B4B5_1DA6C10FD0F8#1369590, TARIFS_DES_FORF_204701_COL_D015AE15_A356_4304_B074_7B20946EFE9F#1369591]
Arguments: [TARIFS_DES_FORF_204701_COL_F05D8F93_FCBE_4BA2_9D4A_3C8081F87ED3#1369587 ASC NULLS FIRST], false, 0
(84) SortMergeJoin
Left keys [1]: [COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1369556]
Right keys [1]: [TARIFS_DES_FORF_204701_COL_F05D8F93_FCBE_4BA2_9D4A_3C8081F87ED3#1369587]
Join type: LeftOuter
Join condition: ((COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#1369561 >= TARIFS_DES_FORF_204701_COL_1D6A3709_2A33_426C_B4B5_1DA6C10FD0F8#1369590) AND (COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#1369561 <= TARIFS_DES_FORF_204701_COL_D015AE15_A356_4304_B074_7B20946EFE9F#1369591))
(85) Project
Output: []
Input [5]: [COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1369556, COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#1369561, TARIFS_DES_FORF_204701_COL_F05D8F93_FCBE_4BA2_9D4A_3C8081F87ED3#1369587, TARIFS_DES_FORF_204701_COL_1D6A3709_2A33_426C_B4B5_1DA6C10FD0F8#1369590, TARIFS_DES_FORF_204701_COL_D015AE15_A356_4304_B074_7B20946EFE9F#1369591]
(86) HashAggregate
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#1370092L]
Results [1]: [count#1370093L]
(87) Exchange
Input [1]: [count#1370093L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=715585]
(88) HashAggregate
Input [1]: [count#1370093L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#1369964L]
Results [1]: [count(1)#1369964L AS count#1369965L]
(89) AdaptiveSparkPlan
Output [1]: [count#1369965L]
Arguments: isFinalPlan=true