SP1 - Details for Query 6040

Submitted Time: 2026/03/27 14:29:51
Duration: 1 s
Succeeded Jobs: 9191 9192 9193 9194
Show the Stage ID and Task ID that corresponds to the max metric
Details
== Physical Plan ==
AdaptiveSparkPlan (86)
+- == Final Plan ==
   LocalTableScan (1)
+- == Initial Plan ==
   CollectLimit (85)
   +- Project (84)
      +- Project (83)
         +- SortMergeJoin LeftOuter (82)
            :- Sort (56)
            :  +- Exchange (55)
            :     +- Project (54)
            :        +- Project (53)
            :           +- Project (52)
            :              +- Generate (51)
            :                 +- Project (50)
            :                    +- Project (49)
            :                       +- Filter (48)
            :                          +- Generate (47)
            :                             +- Union (46)
            :                                :- Project (5)
            :                                :  +- Project (4)
            :                                :     +- Filter (3)
            :                                :        +- Scan csv  (2)
            :                                :- Project (9)
            :                                :  +- Project (8)
            :                                :     +- Filter (7)
            :                                :        +- Scan parquet  (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)
            +- Sort (81)
               +- Exchange (80)
                  +- Project (79)
                     +- CartesianProduct Inner (78)
                        :- Project (74)
                        :  +- SortMergeJoin Cross (73)
                        :     :- Sort (68)
                        :     :  +- Exchange (67)
                        :     :     +- Union (66)
                        :     :        :- Project (59)
                        :     :        :  +- Filter (58)
                        :     :        :     +- Scan parquet  (57)
                        :     :        :- Project (62)
                        :     :        :  +- Filter (61)
                        :     :        :     +- Scan parquet  (60)
                        :     :        +- Project (65)
                        :     :           +- Filter (64)
                        :     :              +- Scan parquet  (63)
                        :     +- Sort (72)
                        :        +- Exchange (71)
                        :           +- Project (70)
                        :              +- Scan csv  (69)
                        +- Project (77)
                           +- Filter (76)
                              +- Scan csv  (75)


(1) LocalTableScan
Output [17]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1370994, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1370998, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1370995, COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1371204, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1371461, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1371559, COL_24B70AFC_A481_42F7_BC8F_E9E89DEC4255#1371575, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1371592, COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#1371674, COL_CFEBEA6B_3FE9_463F_8774_B2A3942E56AB#1371815, COL_6FA3C539_F981_4B55_80EE_5B06D96ED482#1371816, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1371832, COL_E20E6071_1A49_495A_9004_23ED33C98669#1370999, COL_6348CDD7_7FF9_4337_B9DE_365982DB3BA3#1372039, COL_493B3625_15CC_4C3E_B552_CFFC349A58D4#1372040, COL_A2516838_D999_49FB_A245_E9F9B72D742A#1371000, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#1372042]
Arguments: <empty>, [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1370994, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1370998, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1370995, COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1371204, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1371461, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1371559, COL_24B70AFC_A481_42F7_BC8F_E9E89DEC4255#1371575, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1371592, COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#1371674, COL_CFEBEA6B_3FE9_463F_8774_B2A3942E56AB#1371815, COL_6FA3C539_F981_4B55_80EE_5B06D96ED482#1371816, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1371832, COL_E20E6071_1A49_495A_9004_23ED33C98669#1370999, COL_6348CDD7_7FF9_4337_B9DE_365982DB3BA3#1372039, COL_493B3625_15CC_4C3E_B552_CFFC349A58D4#1372040, COL_A2516838_D999_49FB_A245_E9F9B72D742A#1371000, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#1372042]

(2) Scan csv 
Output [1]: [c0#1367818]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/execution/empty.csv]
PushedFilters: [IsNotNull(c0)]
ReadSchema: struct<c0:string>

(3) Filter
Input [1]: [c0#1367818]
Condition : ((isnotnull(c0#1367818) AND (size(str_split(str_if_with_rule(CASE WHEN isnull(Contains(c0#1367818, [)) THEN false ELSE Contains(c0#1367818, [) END, str_concat(array(str_extract_by_str(c0#1367818, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(c0#1367818, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(c0#1367818, _, RIGHT))), c0#1367818), ,), true) > 0)) AND isnotnull(str_split(str_if_with_rule(CASE WHEN isnull(Contains(c0#1367818, [)) THEN false ELSE Contains(c0#1367818, [) END, str_concat(array(str_extract_by_str(c0#1367818, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(c0#1367818, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(c0#1367818, _, RIGHT))), c0#1367818), ,)))

(4) Project
Output [8]: [c0#1367818 AS COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1370994, c0#1367818 AS COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1370998, c0#1367818 AS COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1370995, c0#1367818 AS COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1370996, c0#1367818 AS COL_E20E6071_1A49_495A_9004_23ED33C98669#1370999, cast(c0#1367818 as int) AS COL_A2516838_D999_49FB_A245_E9F9B72D742A#1371000, str_if_with_rule(CASE WHEN isnull(Contains(c0#1367818, [)) THEN false ELSE Contains(c0#1367818, [) END, str_concat(array(str_extract_by_str(c0#1367818, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(c0#1367818, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(c0#1367818, _, RIGHT))), c0#1367818) AS COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1371078, str_split(c0#1367818, @) AS COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1371087]
Input [1]: [c0#1367818]

(5) Project
Output [7]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1370994, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1370998, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1370995, str_if_with_rule(CASE WHEN isnull(Contains(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1370996, [)) THEN false ELSE Contains(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1370996, [) END, str_join(array(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1371087, 0), str_list_get(str_split(str_remove_extend(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1371087, 1), [[,], ]), ,), 0), str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1371087, 2)), @), COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1370996) AS COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1371204, str_split(COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1371078, ,) AS COL_57A67974_536D_441A_A117_CB017D967D15#1371205, COL_E20E6071_1A49_495A_9004_23ED33C98669#1370999, COL_A2516838_D999_49FB_A245_E9F9B72D742A#1371000]
Input [8]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1370994, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1370998, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1370995, COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1370996, COL_E20E6071_1A49_495A_9004_23ED33C98669#1370999, COL_A2516838_D999_49FB_A245_E9F9B72D742A#1371000, COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1371078, COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1371087]

(6) Scan parquet 
Output [6]: [COL_A2523D82_F590_40F1_85E5_30011BEEEDF5#1367767, COL_02D44CEA_1031_4290_8F23_AB2C6AE7B557#1367768, COL_5047AF2B_F05A_487E_9152_F4FE82797C45#1367769, COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0#1367770, COL_FEC7AB55_AB69_43FE_9E2B_2AC5EA7FE569#1367771, COL_786AACC4_3E04_4312_A7F0_A2F045C018D7#1367774]
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_A2523D82_F590_40F1_85E5_30011BEEEDF5:string,COL_02D44CEA_1031_4290_8F23_AB2C6AE7B557:string,COL_5047AF2B_F05A_487E_9152_F4FE82797C45:string,COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0:string,COL_FEC7AB55_AB69_43FE_9E2B_2AC5EA7FE569:string,COL_786AACC4_3E04_4312_A7F0_A2F045C018D7:string>

(7) Filter
Input [6]: [COL_A2523D82_F590_40F1_85E5_30011BEEEDF5#1367767, COL_02D44CEA_1031_4290_8F23_AB2C6AE7B557#1367768, COL_5047AF2B_F05A_487E_9152_F4FE82797C45#1367769, COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0#1367770, COL_FEC7AB55_AB69_43FE_9E2B_2AC5EA7FE569#1367771, COL_786AACC4_3E04_4312_A7F0_A2F045C018D7#1367774]
Condition : ((isnotnull(COL_02D44CEA_1031_4290_8F23_AB2C6AE7B557#1367768) AND (size(str_split(str_if_with_rule(CASE WHEN isnull(Contains(COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0#1367770, [)) THEN false ELSE Contains(COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0#1367770, [) END, str_concat(array(str_extract_by_str(COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0#1367770, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0#1367770, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0#1367770, _, RIGHT))), COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0#1367770), ,), true) > 0)) AND isnotnull(str_split(str_if_with_rule(CASE WHEN isnull(Contains(COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0#1367770, [)) THEN false ELSE Contains(COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0#1367770, [) END, str_concat(array(str_extract_by_str(COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0#1367770, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0#1367770, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0#1367770, _, RIGHT))), COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0#1367770), ,)))

(8) Project
Output [7]: [COL_02D44CEA_1031_4290_8F23_AB2C6AE7B557#1367768 AS COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1372116, COL_A2523D82_F590_40F1_85E5_30011BEEEDF5#1367767 AS COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1372120, COL_5047AF2B_F05A_487E_9152_F4FE82797C45#1367769 AS COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1372117, COL_FEC7AB55_AB69_43FE_9E2B_2AC5EA7FE569#1367771 AS COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372118, COL_786AACC4_3E04_4312_A7F0_A2F045C018D7#1367774 AS COL_E20E6071_1A49_495A_9004_23ED33C98669#1372121, str_if_with_rule(CASE WHEN isnull(Contains(COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0#1367770, [)) THEN false ELSE Contains(COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0#1367770, [) END, str_concat(array(str_extract_by_str(COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0#1367770, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0#1367770, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0#1367770, _, RIGHT))), COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0#1367770) AS COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1372149, str_split(COL_FEC7AB55_AB69_43FE_9E2B_2AC5EA7FE569#1367771, @) AS COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372150]
Input [6]: [COL_A2523D82_F590_40F1_85E5_30011BEEEDF5#1367767, COL_02D44CEA_1031_4290_8F23_AB2C6AE7B557#1367768, COL_5047AF2B_F05A_487E_9152_F4FE82797C45#1367769, COL_070B5B98_14EA_42D5_A6A0_7EDB0FD6E2B0#1367770, COL_FEC7AB55_AB69_43FE_9E2B_2AC5EA7FE569#1367771, COL_786AACC4_3E04_4312_A7F0_A2F045C018D7#1367774]

(9) Project
Output [7]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1372116, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1372120, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1372117, str_if_with_rule(CASE WHEN isnull(Contains(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372118, [)) THEN false ELSE Contains(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372118, [) END, str_join(array(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372150, 0), str_list_get(str_split(str_remove_extend(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372150, 1), [[,], ]), ,), 0), str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372150, 2)), @), COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372118) AS COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372169, str_split(COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1372149, ,) AS COL_57A67974_536D_441A_A117_CB017D967D15#1372170, COL_E20E6071_1A49_495A_9004_23ED33C98669#1372121, null AS COL_A2516838_D999_49FB_A245_E9F9B72D742A#1372122]
Input [7]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1372116, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1372120, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1372117, COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372118, COL_E20E6071_1A49_495A_9004_23ED33C98669#1372121, COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1372149, COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372150]

(10) Scan parquet 
Output [6]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#1367719, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#1367720, COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672#1367721, COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1367722, COL_6425C53C_6469_4002_9B2C_22D29F3F3B08#1367723, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#1367724]
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_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC:string,COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA:string,COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672:string,COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990:string,COL_6425C53C_6469_4002_9B2C_22D29F3F3B08:string,COL_46598A01_D8BC_436B_975B_00D168E3C4D6:string>

(11) Filter
Input [6]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#1367719, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#1367720, COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672#1367721, COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1367722, COL_6425C53C_6469_4002_9B2C_22D29F3F3B08#1367723, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#1367724]
Condition : ((isnotnull(COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#1367720) AND (size(str_split(str_if_with_rule(CASE WHEN isnull(Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1367722, [)) THEN false ELSE Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1367722, [) END, str_concat(array(str_extract_by_str(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1367722, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1367722, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1367722, _, RIGHT))), COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1367722), ,), true) > 0)) AND isnotnull(str_split(str_if_with_rule(CASE WHEN isnull(Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1367722, [)) THEN false ELSE Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1367722, [) END, str_concat(array(str_extract_by_str(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1367722, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1367722, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1367722, _, RIGHT))), COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1367722), ,)))

(12) Project
Output [7]: [COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#1367720 AS COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1372109, COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#1367719 AS COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1372113, COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672#1367721 AS COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1372110, COL_6425C53C_6469_4002_9B2C_22D29F3F3B08#1367723 AS COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372111, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#1367724 AS COL_E20E6071_1A49_495A_9004_23ED33C98669#1372114, str_if_with_rule(CASE WHEN isnull(Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1367722, [)) THEN false ELSE Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1367722, [) END, str_concat(array(str_extract_by_str(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1367722, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1367722, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1367722, _, RIGHT))), COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1367722) AS COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1372151, str_split(COL_6425C53C_6469_4002_9B2C_22D29F3F3B08#1367723, @) AS COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372152]
Input [6]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#1367719, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#1367720, COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672#1367721, COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#1367722, COL_6425C53C_6469_4002_9B2C_22D29F3F3B08#1367723, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#1367724]

(13) Project
Output [7]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1372109, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1372113, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1372110, str_if_with_rule(CASE WHEN isnull(Contains(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372111, [)) THEN false ELSE Contains(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372111, [) END, str_join(array(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372152, 0), str_list_get(str_split(str_remove_extend(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372152, 1), [[,], ]), ,), 0), str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372152, 2)), @), COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372111) AS COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372171, str_split(COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1372151, ,) AS COL_57A67974_536D_441A_A117_CB017D967D15#1372172, COL_E20E6071_1A49_495A_9004_23ED33C98669#1372114, null AS COL_A2516838_D999_49FB_A245_E9F9B72D742A#1372115]
Input [7]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1372109, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1372113, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1372110, COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372111, COL_E20E6071_1A49_495A_9004_23ED33C98669#1372114, COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1372151, COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372152]

(14) Scan parquet 
Output [6]: [COL_C1BA47D9_AEF9_436A_BB27_DA703A71CB47#1367751, COL_396E8D55_189C_4D5F_9FE7_BE58E689C220#1367752, COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1367753, COL_3E4D50AC_3EF2_419C_9E64_261B846141B7#1367754, COL_2CE6F04E_400A_4B26_B5F1_1D1491AB05C1#1367755, COL_5CAAE9FF_D259_4F49_9DD0_9D30F27381EE#1367757]
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_396E8D55_189C_4D5F_9FE7_BE58E689C220:string,COL_8E27793F_C19E_4F60_B3EA_298A2C07831D:string,COL_3E4D50AC_3EF2_419C_9E64_261B846141B7:string,COL_2CE6F04E_400A_4B26_B5F1_1D1491AB05C1:string,COL_5CAAE9FF_D259_4F49_9DD0_9D30F27381EE:string>

(15) Filter
Input [6]: [COL_C1BA47D9_AEF9_436A_BB27_DA703A71CB47#1367751, COL_396E8D55_189C_4D5F_9FE7_BE58E689C220#1367752, COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1367753, COL_3E4D50AC_3EF2_419C_9E64_261B846141B7#1367754, COL_2CE6F04E_400A_4B26_B5F1_1D1491AB05C1#1367755, COL_5CAAE9FF_D259_4F49_9DD0_9D30F27381EE#1367757]
Condition : ((isnotnull(COL_C1BA47D9_AEF9_436A_BB27_DA703A71CB47#1367751) AND (size(str_split(str_if_with_rule(CASE WHEN isnull(Contains(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1367753, [)) THEN false ELSE Contains(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1367753, [) END, str_concat(array(str_extract_by_str(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1367753, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1367753, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1367753, _, RIGHT))), COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1367753), ,), true) > 0)) AND isnotnull(str_split(str_if_with_rule(CASE WHEN isnull(Contains(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1367753, [)) THEN false ELSE Contains(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1367753, [) END, str_concat(array(str_extract_by_str(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1367753, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1367753, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1367753, _, RIGHT))), COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1367753), ,)))

(16) Project
Output [7]: [COL_C1BA47D9_AEF9_436A_BB27_DA703A71CB47#1367751 AS COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1372102, COL_396E8D55_189C_4D5F_9FE7_BE58E689C220#1367752 AS COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1372106, COL_2CE6F04E_400A_4B26_B5F1_1D1491AB05C1#1367755 AS COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1372103, COL_3E4D50AC_3EF2_419C_9E64_261B846141B7#1367754 AS COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372104, COL_5CAAE9FF_D259_4F49_9DD0_9D30F27381EE#1367757 AS COL_E20E6071_1A49_495A_9004_23ED33C98669#1372107, str_if_with_rule(CASE WHEN isnull(Contains(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1367753, [)) THEN false ELSE Contains(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1367753, [) END, str_concat(array(str_extract_by_str(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1367753, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1367753, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1367753, _, RIGHT))), COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1367753) AS COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1372153, str_split(COL_3E4D50AC_3EF2_419C_9E64_261B846141B7#1367754, @) AS COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372154]
Input [6]: [COL_C1BA47D9_AEF9_436A_BB27_DA703A71CB47#1367751, COL_396E8D55_189C_4D5F_9FE7_BE58E689C220#1367752, COL_8E27793F_C19E_4F60_B3EA_298A2C07831D#1367753, COL_3E4D50AC_3EF2_419C_9E64_261B846141B7#1367754, COL_2CE6F04E_400A_4B26_B5F1_1D1491AB05C1#1367755, COL_5CAAE9FF_D259_4F49_9DD0_9D30F27381EE#1367757]

(17) Project
Output [7]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1372102, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1372106, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1372103, str_if_with_rule(CASE WHEN isnull(Contains(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372104, [)) THEN false ELSE Contains(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372104, [) END, str_join(array(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372154, 0), str_list_get(str_split(str_remove_extend(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372154, 1), [[,], ]), ,), 0), str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372154, 2)), @), COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372104) AS COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372173, str_split(COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1372153, ,) AS COL_57A67974_536D_441A_A117_CB017D967D15#1372174, COL_E20E6071_1A49_495A_9004_23ED33C98669#1372107, null AS COL_A2516838_D999_49FB_A245_E9F9B72D742A#1372108]
Input [7]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1372102, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1372106, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1372103, COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372104, COL_E20E6071_1A49_495A_9004_23ED33C98669#1372107, COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1372153, COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372154]

(18) Scan parquet 
Output [6]: [COL_6D461599_696B_4415_9E1E_62284656C432#1370579, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1370580, COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1370583, COL_933B88C4_338B_4EF6_855E_77D0BD55E21B#1370584, COL_DD2AB634_4673_4F2B_8EED_107C0AC50267#1370585, COL_96193E27_D3D2_4476_8CFF_4911255A14C5#1370586]
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_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5:string,COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B:string,COL_933B88C4_338B_4EF6_855E_77D0BD55E21B:string,COL_DD2AB634_4673_4F2B_8EED_107C0AC50267:string,COL_96193E27_D3D2_4476_8CFF_4911255A14C5:string>

(19) Filter
Input [6]: [COL_6D461599_696B_4415_9E1E_62284656C432#1370579, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1370580, COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1370583, COL_933B88C4_338B_4EF6_855E_77D0BD55E21B#1370584, COL_DD2AB634_4673_4F2B_8EED_107C0AC50267#1370585, COL_96193E27_D3D2_4476_8CFF_4911255A14C5#1370586]
Condition : ((isnotnull(COL_6D461599_696B_4415_9E1E_62284656C432#1370579) AND (size(str_split(str_if_with_rule(CASE WHEN isnull(Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1370583, [)) THEN false ELSE Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1370583, [) END, str_concat(array(str_extract_by_str(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1370583, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1370583, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1370583, _, RIGHT))), COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1370583), ,), true) > 0)) AND isnotnull(str_split(str_if_with_rule(CASE WHEN isnull(Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1370583, [)) THEN false ELSE Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1370583, [) END, str_concat(array(str_extract_by_str(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1370583, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1370583, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1370583, _, RIGHT))), COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1370583), ,)))

(20) Project
Output [7]: [COL_6D461599_696B_4415_9E1E_62284656C432#1370579 AS COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1372095, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1370580 AS COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1372099, COL_DD2AB634_4673_4F2B_8EED_107C0AC50267#1370585 AS COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1372096, COL_933B88C4_338B_4EF6_855E_77D0BD55E21B#1370584 AS COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372097, COL_96193E27_D3D2_4476_8CFF_4911255A14C5#1370586 AS COL_E20E6071_1A49_495A_9004_23ED33C98669#1372100, str_if_with_rule(CASE WHEN isnull(Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1370583, [)) THEN false ELSE Contains(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1370583, [) END, str_concat(array(str_extract_by_str(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1370583, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1370583, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1370583, _, RIGHT))), COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1370583) AS COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1372155, str_split(COL_933B88C4_338B_4EF6_855E_77D0BD55E21B#1370584, @) AS COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372156]
Input [6]: [COL_6D461599_696B_4415_9E1E_62284656C432#1370579, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1370580, COL_5A1AA04A_4A92_4CD6_860E_F6C22704E75B#1370583, COL_933B88C4_338B_4EF6_855E_77D0BD55E21B#1370584, COL_DD2AB634_4673_4F2B_8EED_107C0AC50267#1370585, COL_96193E27_D3D2_4476_8CFF_4911255A14C5#1370586]

(21) Project
Output [7]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1372095, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1372099, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1372096, str_if_with_rule(CASE WHEN isnull(Contains(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372097, [)) THEN false ELSE Contains(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372097, [) END, str_join(array(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372156, 0), str_list_get(str_split(str_remove_extend(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372156, 1), [[,], ]), ,), 0), str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372156, 2)), @), COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372097) AS COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372175, str_split(COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1372155, ,) AS COL_57A67974_536D_441A_A117_CB017D967D15#1372176, COL_E20E6071_1A49_495A_9004_23ED33C98669#1372100, null AS COL_A2516838_D999_49FB_A245_E9F9B72D742A#1372101]
Input [7]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1372095, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1372099, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1372096, COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372097, COL_E20E6071_1A49_495A_9004_23ED33C98669#1372100, COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1372155, COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372156]

(22) Scan parquet 
Output [6]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1367847, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#1367848, COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D#1367849, COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1367850, COL_EB745243_852A_470C_A1E1_722CE684E626#1367852, COL_EF5B8E51_0EA9_4466_A691_A2B708205606#1367854]
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_3BB817E2_7134_465C_BB2D_103FF5885DA0:string,COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA:string,COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D:string,COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B:string,COL_EB745243_852A_470C_A1E1_722CE684E626:string,COL_EF5B8E51_0EA9_4466_A691_A2B708205606:string>

(23) Filter
Input [6]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1367847, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#1367848, COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D#1367849, COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1367850, COL_EB745243_852A_470C_A1E1_722CE684E626#1367852, COL_EF5B8E51_0EA9_4466_A691_A2B708205606#1367854]
Condition : ((isnotnull(COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#1367848) AND (size(str_split(str_if_with_rule(CASE WHEN isnull(Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1367850, [)) THEN false ELSE Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1367850, [) END, str_concat(array(str_extract_by_str(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1367850, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1367850, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1367850, _, RIGHT))), COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1367850), ,), true) > 0)) AND isnotnull(str_split(str_if_with_rule(CASE WHEN isnull(Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1367850, [)) THEN false ELSE Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1367850, [) END, str_concat(array(str_extract_by_str(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1367850, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1367850, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1367850, _, RIGHT))), COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1367850), ,)))

(24) Project
Output [7]: [COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#1367848 AS COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1372088, COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1367847 AS COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1372092, COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D#1367849 AS COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1372089, COL_EB745243_852A_470C_A1E1_722CE684E626#1367852 AS COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372090, COL_EF5B8E51_0EA9_4466_A691_A2B708205606#1367854 AS COL_E20E6071_1A49_495A_9004_23ED33C98669#1372093, str_if_with_rule(CASE WHEN isnull(Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1367850, [)) THEN false ELSE Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1367850, [) END, str_concat(array(str_extract_by_str(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1367850, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1367850, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1367850, _, RIGHT))), COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1367850) AS COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1372157, str_split(COL_EB745243_852A_470C_A1E1_722CE684E626#1367852, @) AS COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372158]
Input [6]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#1367847, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#1367848, COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D#1367849, COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#1367850, COL_EB745243_852A_470C_A1E1_722CE684E626#1367852, COL_EF5B8E51_0EA9_4466_A691_A2B708205606#1367854]

(25) Project
Output [7]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1372088, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1372092, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1372089, str_if_with_rule(CASE WHEN isnull(Contains(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372090, [)) THEN false ELSE Contains(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372090, [) END, str_join(array(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372158, 0), str_list_get(str_split(str_remove_extend(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372158, 1), [[,], ]), ,), 0), str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372158, 2)), @), COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372090) AS COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372177, str_split(COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1372157, ,) AS COL_57A67974_536D_441A_A117_CB017D967D15#1372178, COL_E20E6071_1A49_495A_9004_23ED33C98669#1372093, null AS COL_A2516838_D999_49FB_A245_E9F9B72D742A#1372094]
Input [7]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1372088, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1372092, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1372089, COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372090, COL_E20E6071_1A49_495A_9004_23ED33C98669#1372093, COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1372157, COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372158]

(26) Scan parquet 
Output [6]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1367739, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1367740, COL_C85C6E08_90B7_4393_94E6_7D80D91002DE#1367741, COL_D6EF6DFC_79A6_470E_BA52_073402820059#1367742, COL_7C996DEA_C14E_49A5_B230_77E504C67A0F#1367743, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#1367744]
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_4E30F557_0D51_42D5_8031_A4EAB6C1C247:string,COL_680B8808_CA1F_43BB_9FD6_545FE101582E:string,COL_C85C6E08_90B7_4393_94E6_7D80D91002DE:string,COL_D6EF6DFC_79A6_470E_BA52_073402820059:string,COL_7C996DEA_C14E_49A5_B230_77E504C67A0F:string,COL_394635B6_CBFF_48E1_A7F6_382580FC1E24:string>

(27) Filter
Input [6]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1367739, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1367740, COL_C85C6E08_90B7_4393_94E6_7D80D91002DE#1367741, COL_D6EF6DFC_79A6_470E_BA52_073402820059#1367742, COL_7C996DEA_C14E_49A5_B230_77E504C67A0F#1367743, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#1367744]
Condition : ((isnotnull(COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1367740) AND (size(str_split(str_if_with_rule(CASE WHEN isnull(Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1367742, [)) THEN false ELSE Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1367742, [) END, str_concat(array(str_extract_by_str(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1367742, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1367742, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1367742, _, RIGHT))), COL_D6EF6DFC_79A6_470E_BA52_073402820059#1367742), ,), true) > 0)) AND isnotnull(str_split(str_if_with_rule(CASE WHEN isnull(Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1367742, [)) THEN false ELSE Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1367742, [) END, str_concat(array(str_extract_by_str(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1367742, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1367742, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1367742, _, RIGHT))), COL_D6EF6DFC_79A6_470E_BA52_073402820059#1367742), ,)))

(28) Project
Output [7]: [COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1367740 AS COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1372081, COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1367739 AS COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1372085, COL_C85C6E08_90B7_4393_94E6_7D80D91002DE#1367741 AS COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1372082, COL_7C996DEA_C14E_49A5_B230_77E504C67A0F#1367743 AS COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372083, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#1367744 AS COL_E20E6071_1A49_495A_9004_23ED33C98669#1372086, str_if_with_rule(CASE WHEN isnull(Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1367742, [)) THEN false ELSE Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1367742, [) END, str_concat(array(str_extract_by_str(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1367742, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1367742, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1367742, _, RIGHT))), COL_D6EF6DFC_79A6_470E_BA52_073402820059#1367742) AS COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1372159, str_split(COL_7C996DEA_C14E_49A5_B230_77E504C67A0F#1367743, @) AS COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372160]
Input [6]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1367739, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1367740, COL_C85C6E08_90B7_4393_94E6_7D80D91002DE#1367741, COL_D6EF6DFC_79A6_470E_BA52_073402820059#1367742, COL_7C996DEA_C14E_49A5_B230_77E504C67A0F#1367743, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#1367744]

(29) Project
Output [7]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1372081, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1372085, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1372082, str_if_with_rule(CASE WHEN isnull(Contains(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372083, [)) THEN false ELSE Contains(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372083, [) END, str_join(array(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372160, 0), str_list_get(str_split(str_remove_extend(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372160, 1), [[,], ]), ,), 0), str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372160, 2)), @), COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372083) AS COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372179, str_split(COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1372159, ,) AS COL_57A67974_536D_441A_A117_CB017D967D15#1372180, COL_E20E6071_1A49_495A_9004_23ED33C98669#1372086, null AS COL_A2516838_D999_49FB_A245_E9F9B72D742A#1372087]
Input [7]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1372081, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1372085, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1372082, COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372083, COL_E20E6071_1A49_495A_9004_23ED33C98669#1372086, COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1372159, COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372160]

(30) Scan parquet 
Output [6]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1367783, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1367784, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1367785, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367786, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#1367787, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1367788]
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_568DEDCB_F936_41B1_A0EC_986E8205D003:string,COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA:string,COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77:string,COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2:string,COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30:string,COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2:string>

(31) Filter
Input [6]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1367783, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1367784, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1367785, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367786, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#1367787, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1367788]
Condition : ((isnotnull(COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1367784) AND (size(str_split(str_if_with_rule(CASE WHEN isnull(Contains(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367786, [)) THEN false ELSE Contains(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367786, [) END, str_concat(array(str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367786, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367786, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367786, _, RIGHT))), COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367786), ,), true) > 0)) AND isnotnull(str_split(str_if_with_rule(CASE WHEN isnull(Contains(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367786, [)) THEN false ELSE Contains(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367786, [) END, str_concat(array(str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367786, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367786, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367786, _, RIGHT))), COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367786), ,)))

(32) Project
Output [7]: [COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1367784 AS COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1372074, COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1367783 AS COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1372078, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1367785 AS COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1372075, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#1367787 AS COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372076, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1367788 AS COL_E20E6071_1A49_495A_9004_23ED33C98669#1372079, str_if_with_rule(CASE WHEN isnull(Contains(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367786, [)) THEN false ELSE Contains(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367786, [) END, str_concat(array(str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367786, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367786, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367786, _, RIGHT))), COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367786) AS COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1372161, str_split(COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#1367787, @) AS COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372162]
Input [6]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1367783, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1367784, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1367785, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367786, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#1367787, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1367788]

(33) Project
Output [7]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1372074, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1372078, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1372075, str_if_with_rule(CASE WHEN isnull(Contains(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372076, [)) THEN false ELSE Contains(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372076, [) END, str_join(array(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372162, 0), str_list_get(str_split(str_remove_extend(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372162, 1), [[,], ]), ,), 0), str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372162, 2)), @), COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372076) AS COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372181, str_split(COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1372161, ,) AS COL_57A67974_536D_441A_A117_CB017D967D15#1372182, COL_E20E6071_1A49_495A_9004_23ED33C98669#1372079, null AS COL_A2516838_D999_49FB_A245_E9F9B72D742A#1372080]
Input [7]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1372074, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1372078, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1372075, COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372076, COL_E20E6071_1A49_495A_9004_23ED33C98669#1372079, COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1372161, COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372162]

(34) Scan parquet 
Output [6]: [COL_D610971A_3CE5_4463_92C0_C0A5309658BE#1367707, COL_37FB33EF_F56C_40A0_8E69_3CD53BA5E5BD#1367708, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1367709, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367710, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#1367711, COL_9297F7A5_EA15_4188_A13A_37E1612F4D26#1367712]
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_D610971A_3CE5_4463_92C0_C0A5309658BE:string,COL_37FB33EF_F56C_40A0_8E69_3CD53BA5E5BD:string,COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77:string,COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2:string,COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30:string,COL_9297F7A5_EA15_4188_A13A_37E1612F4D26:string>

(35) Filter
Input [6]: [COL_D610971A_3CE5_4463_92C0_C0A5309658BE#1367707, COL_37FB33EF_F56C_40A0_8E69_3CD53BA5E5BD#1367708, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1367709, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367710, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#1367711, COL_9297F7A5_EA15_4188_A13A_37E1612F4D26#1367712]
Condition : ((isnotnull(COL_37FB33EF_F56C_40A0_8E69_3CD53BA5E5BD#1367708) AND (size(str_split(str_if_with_rule(CASE WHEN isnull(Contains(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367710, [)) THEN false ELSE Contains(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367710, [) END, str_concat(array(str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367710, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367710, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367710, _, RIGHT))), COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367710), ,), true) > 0)) AND isnotnull(str_split(str_if_with_rule(CASE WHEN isnull(Contains(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367710, [)) THEN false ELSE Contains(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367710, [) END, str_concat(array(str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367710, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367710, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367710, _, RIGHT))), COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367710), ,)))

(36) Project
Output [7]: [COL_37FB33EF_F56C_40A0_8E69_3CD53BA5E5BD#1367708 AS COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1372067, COL_D610971A_3CE5_4463_92C0_C0A5309658BE#1367707 AS COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1372071, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1367709 AS COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1372068, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#1367711 AS COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372069, COL_9297F7A5_EA15_4188_A13A_37E1612F4D26#1367712 AS COL_E20E6071_1A49_495A_9004_23ED33C98669#1372072, str_if_with_rule(CASE WHEN isnull(Contains(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367710, [)) THEN false ELSE Contains(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367710, [) END, str_concat(array(str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367710, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367710, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367710, _, RIGHT))), COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367710) AS COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1372163, str_split(COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#1367711, @) AS COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372164]
Input [6]: [COL_D610971A_3CE5_4463_92C0_C0A5309658BE#1367707, COL_37FB33EF_F56C_40A0_8E69_3CD53BA5E5BD#1367708, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1367709, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367710, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#1367711, COL_9297F7A5_EA15_4188_A13A_37E1612F4D26#1367712]

(37) Project
Output [7]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1372067, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1372071, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1372068, str_if_with_rule(CASE WHEN isnull(Contains(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372069, [)) THEN false ELSE Contains(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372069, [) END, str_join(array(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372164, 0), str_list_get(str_split(str_remove_extend(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372164, 1), [[,], ]), ,), 0), str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372164, 2)), @), COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372069) AS COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372183, str_split(COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1372163, ,) AS COL_57A67974_536D_441A_A117_CB017D967D15#1372184, COL_E20E6071_1A49_495A_9004_23ED33C98669#1372072, null AS COL_A2516838_D999_49FB_A245_E9F9B72D742A#1372073]
Input [7]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1372067, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1372071, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1372068, COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372069, COL_E20E6071_1A49_495A_9004_23ED33C98669#1372072, COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1372163, COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372164]

(38) Scan parquet 
Output [6]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#1367863, COL_D055870D_7682_4410_A82D_BC4C41964169#1367864, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1367865, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367866, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#1367867, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#1367868]
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_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586:string,COL_D055870D_7682_4410_A82D_BC4C41964169:string,COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77:string,COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2:string,COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30:string,COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8:string>

(39) Filter
Input [6]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#1367863, COL_D055870D_7682_4410_A82D_BC4C41964169#1367864, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1367865, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367866, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#1367867, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#1367868]
Condition : ((isnotnull(COL_D055870D_7682_4410_A82D_BC4C41964169#1367864) AND (size(str_split(str_if_with_rule(CASE WHEN isnull(Contains(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367866, [)) THEN false ELSE Contains(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367866, [) END, str_concat(array(str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367866, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367866, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367866, _, RIGHT))), COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367866), ,), true) > 0)) AND isnotnull(str_split(str_if_with_rule(CASE WHEN isnull(Contains(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367866, [)) THEN false ELSE Contains(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367866, [) END, str_concat(array(str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367866, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367866, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367866, _, RIGHT))), COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367866), ,)))

(40) Project
Output [7]: [COL_D055870D_7682_4410_A82D_BC4C41964169#1367864 AS COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1372060, COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#1367863 AS COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1372064, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1367865 AS COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1372061, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#1367867 AS COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372062, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#1367868 AS COL_E20E6071_1A49_495A_9004_23ED33C98669#1372065, str_if_with_rule(CASE WHEN isnull(Contains(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367866, [)) THEN false ELSE Contains(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367866, [) END, str_concat(array(str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367866, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367866, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367866, _, RIGHT))), COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367866) AS COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1372165, str_split(COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#1367867, @) AS COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372166]
Input [6]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#1367863, COL_D055870D_7682_4410_A82D_BC4C41964169#1367864, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1367865, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1367866, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#1367867, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#1367868]

(41) Project
Output [7]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1372060, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1372064, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1372061, str_if_with_rule(CASE WHEN isnull(Contains(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372062, [)) THEN false ELSE Contains(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372062, [) END, str_join(array(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372166, 0), str_list_get(str_split(str_remove_extend(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372166, 1), [[,], ]), ,), 0), str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372166, 2)), @), COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372062) AS COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372185, str_split(COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1372165, ,) AS COL_57A67974_536D_441A_A117_CB017D967D15#1372186, COL_E20E6071_1A49_495A_9004_23ED33C98669#1372065, null AS COL_A2516838_D999_49FB_A245_E9F9B72D742A#1372066]
Input [7]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1372060, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1372064, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1372061, COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372062, COL_E20E6071_1A49_495A_9004_23ED33C98669#1372065, COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1372165, COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372166]

(42) Scan parquet 
Output [7]: [COL_6A75989B_D287_4B6C_893B_7D78A3023D30#1367642, COL_129360FD_BB12_46AD_A00B_165330B80A60#1367643, COL_1DB4A2D9_3B6B_4DB7_ACEB_6FF7B071AD7C#1367644, COL_910DC838_241D_4365_A8A3_070714C6238B#1367645, COL_481586E2_E506_44E5_9DC4_79601A1736D6#1367646, COL_48A39647_D8F8_4138_9D64_310E44B62D64#1367647, COL_6EEBBF86_F538_4FCC_A04D_D13ADE91BB7B#1367649]
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_129360FD_BB12_46AD_A00B_165330B80A60:string,COL_1DB4A2D9_3B6B_4DB7_ACEB_6FF7B071AD7C:string,COL_910DC838_241D_4365_A8A3_070714C6238B:string,COL_481586E2_E506_44E5_9DC4_79601A1736D6:string,COL_48A39647_D8F8_4138_9D64_310E44B62D64:string,COL_6EEBBF86_F538_4FCC_A04D_D13ADE91BB7B:int>

(43) Filter
Input [7]: [COL_6A75989B_D287_4B6C_893B_7D78A3023D30#1367642, COL_129360FD_BB12_46AD_A00B_165330B80A60#1367643, COL_1DB4A2D9_3B6B_4DB7_ACEB_6FF7B071AD7C#1367644, COL_910DC838_241D_4365_A8A3_070714C6238B#1367645, COL_481586E2_E506_44E5_9DC4_79601A1736D6#1367646, COL_48A39647_D8F8_4138_9D64_310E44B62D64#1367647, COL_6EEBBF86_F538_4FCC_A04D_D13ADE91BB7B#1367649]
Condition : ((isnotnull(COL_6A75989B_D287_4B6C_893B_7D78A3023D30#1367642) AND (size(str_split(str_if_with_rule(CASE WHEN isnull(Contains(COL_910DC838_241D_4365_A8A3_070714C6238B#1367645, [)) THEN false ELSE Contains(COL_910DC838_241D_4365_A8A3_070714C6238B#1367645, [) END, str_concat(array(str_extract_by_str(COL_910DC838_241D_4365_A8A3_070714C6238B#1367645, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_910DC838_241D_4365_A8A3_070714C6238B#1367645, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_910DC838_241D_4365_A8A3_070714C6238B#1367645, _, RIGHT))), COL_910DC838_241D_4365_A8A3_070714C6238B#1367645), ,), true) > 0)) AND isnotnull(str_split(str_if_with_rule(CASE WHEN isnull(Contains(COL_910DC838_241D_4365_A8A3_070714C6238B#1367645, [)) THEN false ELSE Contains(COL_910DC838_241D_4365_A8A3_070714C6238B#1367645, [) END, str_concat(array(str_extract_by_str(COL_910DC838_241D_4365_A8A3_070714C6238B#1367645, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_910DC838_241D_4365_A8A3_070714C6238B#1367645, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_910DC838_241D_4365_A8A3_070714C6238B#1367645, _, RIGHT))), COL_910DC838_241D_4365_A8A3_070714C6238B#1367645), ,)))

(44) Project
Output [8]: [COL_6A75989B_D287_4B6C_893B_7D78A3023D30#1367642, COL_129360FD_BB12_46AD_A00B_165330B80A60#1367643, COL_1DB4A2D9_3B6B_4DB7_ACEB_6FF7B071AD7C#1367644, COL_481586E2_E506_44E5_9DC4_79601A1736D6#1367646, COL_48A39647_D8F8_4138_9D64_310E44B62D64#1367647, COL_6EEBBF86_F538_4FCC_A04D_D13ADE91BB7B#1367649, str_if_with_rule(CASE WHEN isnull(Contains(COL_910DC838_241D_4365_A8A3_070714C6238B#1367645, [)) THEN false ELSE Contains(COL_910DC838_241D_4365_A8A3_070714C6238B#1367645, [) END, str_concat(array(str_extract_by_str(COL_910DC838_241D_4365_A8A3_070714C6238B#1367645, !, LEFT), !, str_list_get(str_split(str_replace_extend(str_extract_by_str(str_extract_by_str(COL_910DC838_241D_4365_A8A3_070714C6238B#1367645, !, RIGHT), _, LEFT), [[,], ], [,,]), ,), 0), _, str_extract_by_str(COL_910DC838_241D_4365_A8A3_070714C6238B#1367645, _, RIGHT))), COL_910DC838_241D_4365_A8A3_070714C6238B#1367645) AS COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1372167, str_split(COL_481586E2_E506_44E5_9DC4_79601A1736D6#1367646, @) AS COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372168]
Input [7]: [COL_6A75989B_D287_4B6C_893B_7D78A3023D30#1367642, COL_129360FD_BB12_46AD_A00B_165330B80A60#1367643, COL_1DB4A2D9_3B6B_4DB7_ACEB_6FF7B071AD7C#1367644, COL_910DC838_241D_4365_A8A3_070714C6238B#1367645, COL_481586E2_E506_44E5_9DC4_79601A1736D6#1367646, COL_48A39647_D8F8_4138_9D64_310E44B62D64#1367647, COL_6EEBBF86_F538_4FCC_A04D_D13ADE91BB7B#1367649]

(45) Project
Output [7]: [COL_6A75989B_D287_4B6C_893B_7D78A3023D30#1367642, COL_129360FD_BB12_46AD_A00B_165330B80A60#1367643, COL_1DB4A2D9_3B6B_4DB7_ACEB_6FF7B071AD7C#1367644, str_if_with_rule(CASE WHEN isnull(Contains(COL_481586E2_E506_44E5_9DC4_79601A1736D6#1367646, [)) THEN false ELSE Contains(COL_481586E2_E506_44E5_9DC4_79601A1736D6#1367646, [) END, str_join(array(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372168, 0), str_list_get(str_split(str_remove_extend(str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372168, 1), [[,], ]), ,), 0), str_list_get(COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372168, 2)), @), COL_481586E2_E506_44E5_9DC4_79601A1736D6#1367646) AS COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1372187, str_split(COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1372167, ,) AS COL_57A67974_536D_441A_A117_CB017D967D15#1372188, COL_48A39647_D8F8_4138_9D64_310E44B62D64#1367647, COL_6EEBBF86_F538_4FCC_A04D_D13ADE91BB7B#1367649]
Input [8]: [COL_6A75989B_D287_4B6C_893B_7D78A3023D30#1367642, COL_129360FD_BB12_46AD_A00B_165330B80A60#1367643, COL_1DB4A2D9_3B6B_4DB7_ACEB_6FF7B071AD7C#1367644, COL_481586E2_E506_44E5_9DC4_79601A1736D6#1367646, COL_48A39647_D8F8_4138_9D64_310E44B62D64#1367647, COL_6EEBBF86_F538_4FCC_A04D_D13ADE91BB7B#1367649, COL_F775B810_3B8F_42F8_9CF4_2AE3A80E4F91#1372167, COL_05FCAD0B_4C02_47FA_A757_466108E3C588#1372168]

(46) Union

(47) Generate
Input [7]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1370994, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1370998, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1370995, COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1371204, COL_57A67974_536D_441A_A117_CB017D967D15#1371205, COL_E20E6071_1A49_495A_9004_23ED33C98669#1370999, COL_A2516838_D999_49FB_A245_E9F9B72D742A#1371000]
Arguments: explode(COL_57A67974_536D_441A_A117_CB017D967D15#1371205), [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1370994, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1370998, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1370995, COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1371204, COL_E20E6071_1A49_495A_9004_23ED33C98669#1370999, COL_A2516838_D999_49FB_A245_E9F9B72D742A#1371000], false, [COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221]

(48) Filter
Input [7]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1370994, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1370998, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1370995, COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1371204, COL_E20E6071_1A49_495A_9004_23ED33C98669#1370999, COL_A2516838_D999_49FB_A245_E9F9B72D742A#1371000, COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221]
Condition : ((size(str_split(str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x, LEFT), 1) <=> 2), str_join(array(str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x, RIGHT), COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221), str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x, RIGHT), COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221)), ,), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x, LEFT), 1) <=> 3), str_join(array(str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x, RIGHT), COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221), str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x, RIGHT), COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221), str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x, RIGHT), COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221)), ,), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x, LEFT), 1) <=> 4), str_join(array(str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x, RIGHT), COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221), str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x, RIGHT), COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221), str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x, RIGHT), COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221), str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x, RIGHT), COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221)), ,), str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x, RIGHT), COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221)))), ,), true) > 0) AND isnotnull(str_split(str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x, LEFT), 1) <=> 2), str_join(array(str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x, RIGHT), COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221), str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x, RIGHT), COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221)), ,), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x, LEFT), 1) <=> 3), str_join(array(str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x, RIGHT), COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221), str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x, RIGHT), COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221), str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x, RIGHT), COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221)), ,), str_if_with_rule((str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x, LEFT), 1) <=> 4), str_join(array(str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x, RIGHT), COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221), str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x, RIGHT), COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221), str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x, RIGHT), COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221), str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x, RIGHT), COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221)), ,), str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x, RIGHT), COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221)))), ,)))

(49) Project
Output [8]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1370994, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1370998, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1370995, COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1371204, str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x, LEFT), 1) AS COL_74E4AA79_E475_4A8C_9DF2_DFCCEC22A999#1371322, str_if_with_rule(CASE WHEN isnull(Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x)) THEN false ELSE Contains(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x) END, str_extract_by_str(COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221, x, RIGHT), COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221) AS COL_939D5ED4_4BBE_4A87_A8A2_1A6889E61C8C#1371323, COL_E20E6071_1A49_495A_9004_23ED33C98669#1370999, COL_A2516838_D999_49FB_A245_E9F9B72D742A#1371000]
Input [7]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1370994, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1370998, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1370995, COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1371204, COL_E20E6071_1A49_495A_9004_23ED33C98669#1370999, COL_A2516838_D999_49FB_A245_E9F9B72D742A#1371000, COL_FE2DEFB8_B2DF_4276_B4E5_03EF2C0412EF#1371221]

(50) Project
Output [8]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1370994, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1370998, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1370995, COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1371204, COL_939D5ED4_4BBE_4A87_A8A2_1A6889E61C8C#1371323, str_split(str_if_with_rule((COL_74E4AA79_E475_4A8C_9DF2_DFCCEC22A999#1371322 <=> 2), str_join(array(COL_939D5ED4_4BBE_4A87_A8A2_1A6889E61C8C#1371323, COL_939D5ED4_4BBE_4A87_A8A2_1A6889E61C8C#1371323), ,), str_if_with_rule((COL_74E4AA79_E475_4A8C_9DF2_DFCCEC22A999#1371322 <=> 3), str_join(array(COL_939D5ED4_4BBE_4A87_A8A2_1A6889E61C8C#1371323, COL_939D5ED4_4BBE_4A87_A8A2_1A6889E61C8C#1371323, COL_939D5ED4_4BBE_4A87_A8A2_1A6889E61C8C#1371323), ,), str_if_with_rule((COL_74E4AA79_E475_4A8C_9DF2_DFCCEC22A999#1371322 <=> 4), str_join(array(COL_939D5ED4_4BBE_4A87_A8A2_1A6889E61C8C#1371323, COL_939D5ED4_4BBE_4A87_A8A2_1A6889E61C8C#1371323, COL_939D5ED4_4BBE_4A87_A8A2_1A6889E61C8C#1371323, COL_939D5ED4_4BBE_4A87_A8A2_1A6889E61C8C#1371323), ,), COL_939D5ED4_4BBE_4A87_A8A2_1A6889E61C8C#1371323))), ,) AS COL_61AA9492_75C1_4D8D_9A82_1FC107966A1A#1371378, COL_E20E6071_1A49_495A_9004_23ED33C98669#1370999, COL_A2516838_D999_49FB_A245_E9F9B72D742A#1371000]
Input [8]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1370994, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1370998, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1370995, COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1371204, COL_74E4AA79_E475_4A8C_9DF2_DFCCEC22A999#1371322, COL_939D5ED4_4BBE_4A87_A8A2_1A6889E61C8C#1371323, COL_E20E6071_1A49_495A_9004_23ED33C98669#1370999, COL_A2516838_D999_49FB_A245_E9F9B72D742A#1371000]

(51) Generate
Input [8]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1370994, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1370998, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1370995, COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1371204, COL_939D5ED4_4BBE_4A87_A8A2_1A6889E61C8C#1371323, COL_61AA9492_75C1_4D8D_9A82_1FC107966A1A#1371378, COL_E20E6071_1A49_495A_9004_23ED33C98669#1370999, COL_A2516838_D999_49FB_A245_E9F9B72D742A#1371000]
Arguments: explode(COL_61AA9492_75C1_4D8D_9A82_1FC107966A1A#1371378), [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1370994, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1370998, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1370995, COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1371204, COL_939D5ED4_4BBE_4A87_A8A2_1A6889E61C8C#1371323, COL_E20E6071_1A49_495A_9004_23ED33C98669#1370999, COL_A2516838_D999_49FB_A245_E9F9B72D742A#1371000], false, [COL_CBC48D63_A38A_42F7_8994_3AAE60BEF796#1371393]

(52) Project
Output [8]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1370994, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1370998, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1370995, COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1371204, COL_CBC48D63_A38A_42F7_8994_3AAE60BEF796#1371393, COL_E20E6071_1A49_495A_9004_23ED33C98669#1370999, COL_A2516838_D999_49FB_A245_E9F9B72D742A#1371000, str_if_with_rule((((((CASE WHEN isnull(StartsWith(COL_CBC48D63_A38A_42F7_8994_3AAE60BEF796#1371393, SIC)) THEN false ELSE StartsWith(COL_CBC48D63_A38A_42F7_8994_3AAE60BEF796#1371393, SIC) END OR CASE WHEN isnull(StartsWith(COL_CBC48D63_A38A_42F7_8994_3AAE60BEF796#1371393, SIM)) THEN false ELSE StartsWith(COL_CBC48D63_A38A_42F7_8994_3AAE60BEF796#1371393, SIM) END) OR CASE WHEN isnull(StartsWith(COL_CBC48D63_A38A_42F7_8994_3AAE60BEF796#1371393, SSN)) THEN false ELSE StartsWith(COL_CBC48D63_A38A_42F7_8994_3AAE60BEF796#1371393, SSN) END) OR CASE WHEN isnull(StartsWith(COL_CBC48D63_A38A_42F7_8994_3AAE60BEF796#1371393, SSF)) THEN false ELSE StartsWith(COL_CBC48D63_A38A_42F7_8994_3AAE60BEF796#1371393, SSF) END) OR CASE WHEN isnull(StartsWith(COL_CBC48D63_A38A_42F7_8994_3AAE60BEF796#1371393, SAS)) THEN false ELSE StartsWith(COL_CBC48D63_A38A_42F7_8994_3AAE60BEF796#1371393, SAS) END) OR CASE WHEN isnull(Contains(COL_939D5ED4_4BBE_4A87_A8A2_1A6889E61C8C#1371323, !)) THEN false ELSE Contains(COL_939D5ED4_4BBE_4A87_A8A2_1A6889E61C8C#1371323, !) END), str_extract(str_list_get(str_split(COL_CBC48D63_A38A_42F7_8994_3AAE60BEF796#1371393, !), 0), RIGHT, 1), str_extract(COL_CBC48D63_A38A_42F7_8994_3AAE60BEF796#1371393, RIGHT, 1)) AS COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1371461]
Input [8]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1370994, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1370998, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1370995, COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1371204, COL_939D5ED4_4BBE_4A87_A8A2_1A6889E61C8C#1371323, COL_E20E6071_1A49_495A_9004_23ED33C98669#1370999, COL_A2516838_D999_49FB_A245_E9F9B72D742A#1371000, COL_CBC48D63_A38A_42F7_8994_3AAE60BEF796#1371393]

(53) Project
Output [10]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1370994, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1370998, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1370995, COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1371204, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1371461, COL_E20E6071_1A49_495A_9004_23ED33C98669#1370999, COL_A2516838_D999_49FB_A245_E9F9B72D742A#1371000, str_remove_space(str_extract_by_str(str_remove(COL_CBC48D63_A38A_42F7_8994_3AAE60BEF796#1371393, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1371461), !, LEFT), ALL) AS COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1371559, str_create(str_list_get(str_split(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1371204, @), 1)) AS COL_24B70AFC_A481_42F7_BC8F_E9E89DEC4255#1371575, str_if_with_rule(((((CASE WHEN isnull(StartsWith(COL_CBC48D63_A38A_42F7_8994_3AAE60BEF796#1371393, SIC)) THEN false ELSE StartsWith(COL_CBC48D63_A38A_42F7_8994_3AAE60BEF796#1371393, SIC) END OR CASE WHEN isnull(StartsWith(COL_CBC48D63_A38A_42F7_8994_3AAE60BEF796#1371393, SIM)) THEN false ELSE StartsWith(COL_CBC48D63_A38A_42F7_8994_3AAE60BEF796#1371393, SIM) END) OR CASE WHEN isnull(StartsWith(COL_CBC48D63_A38A_42F7_8994_3AAE60BEF796#1371393, SAS)) THEN false ELSE StartsWith(COL_CBC48D63_A38A_42F7_8994_3AAE60BEF796#1371393, SAS) END) OR CASE WHEN isnull(StartsWith(COL_CBC48D63_A38A_42F7_8994_3AAE60BEF796#1371393, SSF)) THEN false ELSE StartsWith(COL_CBC48D63_A38A_42F7_8994_3AAE60BEF796#1371393, SSF) END) OR CASE WHEN isnull(StartsWith(COL_CBC48D63_A38A_42F7_8994_3AAE60BEF796#1371393, SSN)) THEN false ELSE StartsWith(COL_CBC48D63_A38A_42F7_8994_3AAE60BEF796#1371393, SSN) END), str_extract_by_str(str_list_get(str_split(COL_CBC48D63_A38A_42F7_8994_3AAE60BEF796#1371393, !), 1), _, RIGHT), ) AS COL_06545D41_928E_4A54_93BF_65904FCF81AA#1371592]
Input [8]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1370994, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1370998, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1370995, COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1371204, COL_CBC48D63_A38A_42F7_8994_3AAE60BEF796#1371393, COL_E20E6071_1A49_495A_9004_23ED33C98669#1370999, COL_A2516838_D999_49FB_A245_E9F9B72D742A#1371000, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1371461]

(54) Project
Output [11]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1370994, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1370998, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1370995, COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1371204, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1371461, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1371559, COL_24B70AFC_A481_42F7_BC8F_E9E89DEC4255#1371575, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1371592, str_to_datez(COL_24B70AFC_A481_42F7_BC8F_E9E89DEC4255#1371575, ddMMyyyy, Europe/Paris, fr_FR) AS COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#1371674, COL_E20E6071_1A49_495A_9004_23ED33C98669#1370999, COL_A2516838_D999_49FB_A245_E9F9B72D742A#1371000]
Input [10]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1370994, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1370998, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1370995, COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1371204, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1371461, COL_E20E6071_1A49_495A_9004_23ED33C98669#1370999, COL_A2516838_D999_49FB_A245_E9F9B72D742A#1371000, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1371559, COL_24B70AFC_A481_42F7_BC8F_E9E89DEC4255#1371575, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1371592]

(55) Exchange
Input [11]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1370994, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1370998, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1370995, COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1371204, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1371461, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1371559, COL_24B70AFC_A481_42F7_BC8F_E9E89DEC4255#1371575, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1371592, COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#1371674, COL_E20E6071_1A49_495A_9004_23ED33C98669#1370999, COL_A2516838_D999_49FB_A245_E9F9B72D742A#1371000]
Arguments: hashpartitioning(COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1371559, 10), ENSURE_REQUIREMENTS, [plan_id=716385]

(56) Sort
Input [11]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1370994, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1370998, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1370995, COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1371204, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1371461, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1371559, COL_24B70AFC_A481_42F7_BC8F_E9E89DEC4255#1371575, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1371592, COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#1371674, COL_E20E6071_1A49_495A_9004_23ED33C98669#1370999, COL_A2516838_D999_49FB_A245_E9F9B72D742A#1371000]
Arguments: [COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1371559 ASC NULLS FIRST], false, 0

(57) Scan parquet 
Output [6]: [Code+Acte#1370094, Montant#1370095, Ligne+RSF#1370096, Date_effet#1370097, Date_r%C3%A9vocation#1370098, Trigramme#1370099]
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,Montant:string,Ligne+RSF:string,Date_effet:string,Date_r%C3%A9vocation:string,Trigramme:string>

(58) Filter
Input [6]: [Code+Acte#1370094, Montant#1370095, Ligne+RSF#1370096, Date_effet#1370097, Date_r%C3%A9vocation#1370098, Trigramme#1370099]
Condition : ((isnotnull(Code+Acte#1370094) AND isnotnull(str_to_datez(Date_effet#1370097, dd/MM/yyyy, null, null))) AND isnotnull(str_to_datez(Date_r%C3%A9vocation#1370098, dd/MM/yyyy, null, null)))

(59) Project
Output [6]: [Code+Acte#1370094 AS COL_F05D8F93_FCBE_4BA2_9D4A_3C8081F87ED3#1370397, cast(REFORMAT_FOR_DOUBLE(Montant#1370095) as double) AS COL_463070EC_F0BE_4455_8042_9C01F9FF79FF#1370398, Ligne+RSF#1370096 AS COL_E7E98D16_7FF3_4782_9A33_CD4775848437#1370399, str_to_datez(Date_effet#1370097, dd/MM/yyyy, null, null) AS COL_1D6A3709_2A33_426C_B4B5_1DA6C10FD0F8#1370400, str_to_datez(Date_r%C3%A9vocation#1370098, dd/MM/yyyy, null, null) AS COL_D015AE15_A356_4304_B074_7B20946EFE9F#1370401, Trigramme#1370099 AS COL_C2DEADC4_EC1C_44BB_94AA_E5A923AE1BC6#1370402]
Input [6]: [Code+Acte#1370094, Montant#1370095, Ligne+RSF#1370096, Date_effet#1370097, Date_r%C3%A9vocation#1370098, Trigramme#1370099]

(60) Scan parquet 
Output [6]: [Code+Acte#1370165, Montant#1370166, Ligne+RSF#1370167, Date_effet#1370168, Date_r%C3%A9vocation#1370169, Trigramme#1370170]
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,Montant:string,Ligne+RSF:string,Date_effet:string,Date_r%C3%A9vocation:string,Trigramme:string>

(61) Filter
Input [6]: [Code+Acte#1370165, Montant#1370166, Ligne+RSF#1370167, Date_effet#1370168, Date_r%C3%A9vocation#1370169, Trigramme#1370170]
Condition : ((isnotnull(Code+Acte#1370165) AND isnotnull(str_to_datez(Date_effet#1370168, dd/MM/yyyy, null, null))) AND isnotnull(str_to_datez(Date_r%C3%A9vocation#1370169, dd/MM/yyyy, null, null)))

(62) Project
Output [6]: [Code+Acte#1370165 AS COL_F05D8F93_FCBE_4BA2_9D4A_3C8081F87ED3#1372137, cast(REFORMAT_FOR_DOUBLE(Montant#1370166) as double) AS COL_463070EC_F0BE_4455_8042_9C01F9FF79FF#1372138, Ligne+RSF#1370167 AS COL_E7E98D16_7FF3_4782_9A33_CD4775848437#1372139, str_to_datez(Date_effet#1370168, dd/MM/yyyy, null, null) AS COL_1D6A3709_2A33_426C_B4B5_1DA6C10FD0F8#1372140, str_to_datez(Date_r%C3%A9vocation#1370169, dd/MM/yyyy, null, null) AS COL_D015AE15_A356_4304_B074_7B20946EFE9F#1372141, Trigramme#1370170 AS COL_C2DEADC4_EC1C_44BB_94AA_E5A923AE1BC6#1372142]
Input [6]: [Code+Acte#1370165, Montant#1370166, Ligne+RSF#1370167, Date_effet#1370168, Date_r%C3%A9vocation#1370169, Trigramme#1370170]

(63) Scan parquet 
Output [6]: [Code+Acte#1370244, Montant#1370245, Ligne+RSF#1370246, Date_effet#1370247, Date_r%C3%A9vocation#1370248, Trigramme#1370249]
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,Montant:string,Ligne+RSF:string,Date_effet:string,Date_r%C3%A9vocation:string,Trigramme:string>

(64) Filter
Input [6]: [Code+Acte#1370244, Montant#1370245, Ligne+RSF#1370246, Date_effet#1370247, Date_r%C3%A9vocation#1370248, Trigramme#1370249]
Condition : ((isnotnull(Code+Acte#1370244) AND isnotnull(str_to_datez(Date_effet#1370247, dd/MM/yyyy, null, null))) AND isnotnull(str_to_datez(Date_r%C3%A9vocation#1370248, dd/MM/yyyy, null, null)))

(65) Project
Output [6]: [Code+Acte#1370244 AS COL_F05D8F93_FCBE_4BA2_9D4A_3C8081F87ED3#1372143, cast(REFORMAT_FOR_DOUBLE(Montant#1370245) as double) AS COL_463070EC_F0BE_4455_8042_9C01F9FF79FF#1372144, Ligne+RSF#1370246 AS COL_E7E98D16_7FF3_4782_9A33_CD4775848437#1372145, str_to_datez(Date_effet#1370247, dd/MM/yyyy, null, null) AS COL_1D6A3709_2A33_426C_B4B5_1DA6C10FD0F8#1372146, str_to_datez(Date_r%C3%A9vocation#1370248, dd/MM/yyyy, null, null) AS COL_D015AE15_A356_4304_B074_7B20946EFE9F#1372147, Trigramme#1370249 AS COL_C2DEADC4_EC1C_44BB_94AA_E5A923AE1BC6#1372148]
Input [6]: [Code+Acte#1370244, Montant#1370245, Ligne+RSF#1370246, Date_effet#1370247, Date_r%C3%A9vocation#1370248, Trigramme#1370249]

(66) Union

(67) Exchange
Input [6]: [COL_F05D8F93_FCBE_4BA2_9D4A_3C8081F87ED3#1370397, COL_463070EC_F0BE_4455_8042_9C01F9FF79FF#1370398, COL_E7E98D16_7FF3_4782_9A33_CD4775848437#1370399, COL_1D6A3709_2A33_426C_B4B5_1DA6C10FD0F8#1370400, COL_D015AE15_A356_4304_B074_7B20946EFE9F#1370401, COL_C2DEADC4_EC1C_44BB_94AA_E5A923AE1BC6#1370402]
Arguments: hashpartitioning(coalesce(COL_C2DEADC4_EC1C_44BB_94AA_E5A923AE1BC6#1370402, ), isnull(COL_C2DEADC4_EC1C_44BB_94AA_E5A923AE1BC6#1370402), 10), ENSURE_REQUIREMENTS, [plan_id=716373]

(68) Sort
Input [6]: [COL_F05D8F93_FCBE_4BA2_9D4A_3C8081F87ED3#1370397, COL_463070EC_F0BE_4455_8042_9C01F9FF79FF#1370398, COL_E7E98D16_7FF3_4782_9A33_CD4775848437#1370399, COL_1D6A3709_2A33_426C_B4B5_1DA6C10FD0F8#1370400, COL_D015AE15_A356_4304_B074_7B20946EFE9F#1370401, COL_C2DEADC4_EC1C_44BB_94AA_E5A923AE1BC6#1370402]
Arguments: [coalesce(COL_C2DEADC4_EC1C_44BB_94AA_E5A923AE1BC6#1370402, ) ASC NULLS FIRST, isnull(COL_C2DEADC4_EC1C_44BB_94AA_E5A923AE1BC6#1370402) ASC NULLS FIRST], false, 0

(69) Scan csv 
Output [1]: [region-tarif#1368421]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/execution/INFO_DATAAPPS_204516/current/info_dataapps.csv]
ReadSchema: struct<region-tarif:string>

(70) Project
Output [1]: [region-tarif#1368421 AS INFO_DATAAPPS_204709_COL_5EF90F7F_94BB_48D9_B288_FA990D2ABCB2#1370413]
Input [1]: [region-tarif#1368421]

(71) Exchange
Input [1]: [INFO_DATAAPPS_204709_COL_5EF90F7F_94BB_48D9_B288_FA990D2ABCB2#1370413]
Arguments: hashpartitioning(coalesce(INFO_DATAAPPS_204709_COL_5EF90F7F_94BB_48D9_B288_FA990D2ABCB2#1370413, ), isnull(INFO_DATAAPPS_204709_COL_5EF90F7F_94BB_48D9_B288_FA990D2ABCB2#1370413), 10), ENSURE_REQUIREMENTS, [plan_id=716374]

(72) Sort
Input [1]: [INFO_DATAAPPS_204709_COL_5EF90F7F_94BB_48D9_B288_FA990D2ABCB2#1370413]
Arguments: [coalesce(INFO_DATAAPPS_204709_COL_5EF90F7F_94BB_48D9_B288_FA990D2ABCB2#1370413, ) ASC NULLS FIRST, isnull(INFO_DATAAPPS_204709_COL_5EF90F7F_94BB_48D9_B288_FA990D2ABCB2#1370413) ASC NULLS FIRST], false, 0

(73) SortMergeJoin
Left keys [2]: [coalesce(COL_C2DEADC4_EC1C_44BB_94AA_E5A923AE1BC6#1370402, ), isnull(COL_C2DEADC4_EC1C_44BB_94AA_E5A923AE1BC6#1370402)]
Right keys [2]: [coalesce(INFO_DATAAPPS_204709_COL_5EF90F7F_94BB_48D9_B288_FA990D2ABCB2#1370413, ), isnull(INFO_DATAAPPS_204709_COL_5EF90F7F_94BB_48D9_B288_FA990D2ABCB2#1370413)]
Join type: Cross
Join condition: None

(74) Project
Output [5]: [COL_F05D8F93_FCBE_4BA2_9D4A_3C8081F87ED3#1370397, COL_463070EC_F0BE_4455_8042_9C01F9FF79FF#1370398, COL_E7E98D16_7FF3_4782_9A33_CD4775848437#1370399, COL_1D6A3709_2A33_426C_B4B5_1DA6C10FD0F8#1370400, COL_D015AE15_A356_4304_B074_7B20946EFE9F#1370401]
Input [7]: [COL_F05D8F93_FCBE_4BA2_9D4A_3C8081F87ED3#1370397, COL_463070EC_F0BE_4455_8042_9C01F9FF79FF#1370398, COL_E7E98D16_7FF3_4782_9A33_CD4775848437#1370399, COL_1D6A3709_2A33_426C_B4B5_1DA6C10FD0F8#1370400, COL_D015AE15_A356_4304_B074_7B20946EFE9F#1370401, COL_C2DEADC4_EC1C_44BB_94AA_E5A923AE1BC6#1370402, INFO_DATAAPPS_204709_COL_5EF90F7F_94BB_48D9_B288_FA990D2ABCB2#1370413]

(75) Scan csv 
Output [2]: [REGLES#1368247, APPLICABLE#1368248]
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,APPLICABLE:string>

(76) Filter
Input [2]: [REGLES#1368247, APPLICABLE#1368248]
Condition : (isnotnull(REGLES#1368247) AND (FP-TO-LC = REGLES#1368247))

(77) Project
Output [1]: [APPLICABLE#1368248 AS REGLES_A_APPLIQ_204654_APPLICABLE_204656#1370465]
Input [2]: [REGLES#1368247, APPLICABLE#1368248]

(78) CartesianProduct
Join type: Inner
Join condition: None

(79) Project
Output [5]: [COL_F05D8F93_FCBE_4BA2_9D4A_3C8081F87ED3#1370397 AS TARIFS_DES_FORF_204701_COL_F05D8F93_FCBE_4BA2_9D4A_3C8081F87ED3#1371700, COL_463070EC_F0BE_4455_8042_9C01F9FF79FF#1370398 AS TARIFS_DES_FORF_204701_COL_463070EC_F0BE_4455_8042_9C01F9FF79FF#1371701, str_if_with_rule(((REGLES_A_APPLIQ_204654_APPLICABLE_204656#1370465 <=> O) AND CASE WHEN isnull(StartsWith(COL_F05D8F93_FCBE_4BA2_9D4A_3C8081F87ED3#1370397, FP)) THEN false ELSE StartsWith(COL_F05D8F93_FCBE_4BA2_9D4A_3C8081F87ED3#1370397, FP) END), C, COL_E7E98D16_7FF3_4782_9A33_CD4775848437#1370399) AS TARIFS_DES_FORF_204701_COL_E7E98D16_7FF3_4782_9A33_CD4775848437#1371702, COL_1D6A3709_2A33_426C_B4B5_1DA6C10FD0F8#1370400 AS TARIFS_DES_FORF_204701_COL_1D6A3709_2A33_426C_B4B5_1DA6C10FD0F8#1371703, COL_D015AE15_A356_4304_B074_7B20946EFE9F#1370401 AS TARIFS_DES_FORF_204701_COL_D015AE15_A356_4304_B074_7B20946EFE9F#1371704]
Input [6]: [COL_F05D8F93_FCBE_4BA2_9D4A_3C8081F87ED3#1370397, COL_463070EC_F0BE_4455_8042_9C01F9FF79FF#1370398, COL_E7E98D16_7FF3_4782_9A33_CD4775848437#1370399, COL_1D6A3709_2A33_426C_B4B5_1DA6C10FD0F8#1370400, COL_D015AE15_A356_4304_B074_7B20946EFE9F#1370401, REGLES_A_APPLIQ_204654_APPLICABLE_204656#1370465]

(80) Exchange
Input [5]: [TARIFS_DES_FORF_204701_COL_F05D8F93_FCBE_4BA2_9D4A_3C8081F87ED3#1371700, TARIFS_DES_FORF_204701_COL_463070EC_F0BE_4455_8042_9C01F9FF79FF#1371701, TARIFS_DES_FORF_204701_COL_E7E98D16_7FF3_4782_9A33_CD4775848437#1371702, TARIFS_DES_FORF_204701_COL_1D6A3709_2A33_426C_B4B5_1DA6C10FD0F8#1371703, TARIFS_DES_FORF_204701_COL_D015AE15_A356_4304_B074_7B20946EFE9F#1371704]
Arguments: hashpartitioning(TARIFS_DES_FORF_204701_COL_F05D8F93_FCBE_4BA2_9D4A_3C8081F87ED3#1371700, 10), ENSURE_REQUIREMENTS, [plan_id=716386]

(81) Sort
Input [5]: [TARIFS_DES_FORF_204701_COL_F05D8F93_FCBE_4BA2_9D4A_3C8081F87ED3#1371700, TARIFS_DES_FORF_204701_COL_463070EC_F0BE_4455_8042_9C01F9FF79FF#1371701, TARIFS_DES_FORF_204701_COL_E7E98D16_7FF3_4782_9A33_CD4775848437#1371702, TARIFS_DES_FORF_204701_COL_1D6A3709_2A33_426C_B4B5_1DA6C10FD0F8#1371703, TARIFS_DES_FORF_204701_COL_D015AE15_A356_4304_B074_7B20946EFE9F#1371704]
Arguments: [TARIFS_DES_FORF_204701_COL_F05D8F93_FCBE_4BA2_9D4A_3C8081F87ED3#1371700 ASC NULLS FIRST], false, 0

(82) SortMergeJoin
Left keys [1]: [COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1371559]
Right keys [1]: [TARIFS_DES_FORF_204701_COL_F05D8F93_FCBE_4BA2_9D4A_3C8081F87ED3#1371700]
Join type: LeftOuter
Join condition: ((COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#1371674 >= TARIFS_DES_FORF_204701_COL_1D6A3709_2A33_426C_B4B5_1DA6C10FD0F8#1371703) AND (COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#1371674 <= TARIFS_DES_FORF_204701_COL_D015AE15_A356_4304_B074_7B20946EFE9F#1371704))

(83) Project
Output [14]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1370994, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1370998, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1370995, COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1371204, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1371461, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1371559, COL_24B70AFC_A481_42F7_BC8F_E9E89DEC4255#1371575, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1371592, COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#1371674, TARIFS_DES_FORF_204701_COL_463070EC_F0BE_4455_8042_9C01F9FF79FF#1371701 AS COL_CFEBEA6B_3FE9_463F_8774_B2A3942E56AB#1371815, TARIFS_DES_FORF_204701_COL_E7E98D16_7FF3_4782_9A33_CD4775848437#1371702 AS COL_6FA3C539_F981_4B55_80EE_5B06D96ED482#1371816, COL_E20E6071_1A49_495A_9004_23ED33C98669#1370999, COL_A2516838_D999_49FB_A245_E9F9B72D742A#1371000, dec_if_with_rule((COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1371461 <=> -), dec_mult(array(TARIFS_DES_FORF_204701_COL_463070EC_F0BE_4455_8042_9C01F9FF79FF#1371701, -1.0)), TARIFS_DES_FORF_204701_COL_463070EC_F0BE_4455_8042_9C01F9FF79FF#1371701) AS COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1371832]
Input [16]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1370994, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1370998, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1370995, COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1371204, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1371461, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1371559, COL_24B70AFC_A481_42F7_BC8F_E9E89DEC4255#1371575, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1371592, COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#1371674, COL_E20E6071_1A49_495A_9004_23ED33C98669#1370999, COL_A2516838_D999_49FB_A245_E9F9B72D742A#1371000, TARIFS_DES_FORF_204701_COL_F05D8F93_FCBE_4BA2_9D4A_3C8081F87ED3#1371700, TARIFS_DES_FORF_204701_COL_463070EC_F0BE_4455_8042_9C01F9FF79FF#1371701, TARIFS_DES_FORF_204701_COL_E7E98D16_7FF3_4782_9A33_CD4775848437#1371702, TARIFS_DES_FORF_204701_COL_1D6A3709_2A33_426C_B4B5_1DA6C10FD0F8#1371703, TARIFS_DES_FORF_204701_COL_D015AE15_A356_4304_B074_7B20946EFE9F#1371704]

(84) Project
Output [17]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1370994, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1370998, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1370995, COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1371204, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1371461, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1371559, COL_24B70AFC_A481_42F7_BC8F_E9E89DEC4255#1371575, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1371592, COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#1371674, COL_CFEBEA6B_3FE9_463F_8774_B2A3942E56AB#1371815, COL_6FA3C539_F981_4B55_80EE_5B06D96ED482#1371816, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1371832, COL_E20E6071_1A49_495A_9004_23ED33C98669#1370999, str_if_with_rule(((((((COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1371461 <=> +) AND NOT CASE WHEN isnull(StartsWith(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1371204, Swi)) THEN false ELSE StartsWith(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1371204, Swi) END) OR CASE WHEN isnull(StartsWith(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1371204, Swi)) THEN false ELSE StartsWith(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1371204, Swi) END) OR CASE WHEN isnull(Contains(COL_E20E6071_1A49_495A_9004_23ED33C98669#1370999, Doublon)) THEN false ELSE Contains(COL_E20E6071_1A49_495A_9004_23ED33C98669#1370999, Doublon) END) OR (COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1371559 <=> CFU)) OR (COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1371559 <=> FPV)), Optimisation, ) AS COL_6348CDD7_7FF9_4337_B9DE_365982DB3BA3#1372039, str_if_with_rule(CASE WHEN isnull(StartsWith(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1371204, Swi)) THEN false ELSE StartsWith(COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1371204, Swi) END, Switch, str_if_with_rule((COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1371461 <=> +), Ajout, Suppression)) AS COL_493B3625_15CC_4C3E_B552_CFFC349A58D4#1372040, COL_A2516838_D999_49FB_A245_E9F9B72D742A#1371000, dec_if_with_rule(((((COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1371559 <=> FPL) OR (COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1371559 <=> FPM)) OR (COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1371559 <=> FPU)) OR (COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1371559 <=> FPV)), 0.0, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1371832) AS COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#1372042]
Input [14]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1370994, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1370998, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1370995, COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1371204, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1371461, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1371559, COL_24B70AFC_A481_42F7_BC8F_E9E89DEC4255#1371575, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1371592, COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#1371674, COL_CFEBEA6B_3FE9_463F_8774_B2A3942E56AB#1371815, COL_6FA3C539_F981_4B55_80EE_5B06D96ED482#1371816, COL_E20E6071_1A49_495A_9004_23ED33C98669#1370999, COL_A2516838_D999_49FB_A245_E9F9B72D742A#1371000, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1371832]

(85) CollectLimit
Input [17]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1370994, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1370998, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1370995, COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1371204, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1371461, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1371559, COL_24B70AFC_A481_42F7_BC8F_E9E89DEC4255#1371575, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1371592, COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#1371674, COL_CFEBEA6B_3FE9_463F_8774_B2A3942E56AB#1371815, COL_6FA3C539_F981_4B55_80EE_5B06D96ED482#1371816, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1371832, COL_E20E6071_1A49_495A_9004_23ED33C98669#1370999, COL_6348CDD7_7FF9_4337_B9DE_365982DB3BA3#1372039, COL_493B3625_15CC_4C3E_B552_CFFC349A58D4#1372040, COL_A2516838_D999_49FB_A245_E9F9B72D742A#1371000, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#1372042]
Arguments: 1500

(86) AdaptiveSparkPlan
Output [17]: [COL_EB47ADCA_4440_4090_8691_F8499DB4555E#1370994, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#1370998, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#1370995, COL_1BE7C81D_C98B_4777_B767_B833588E5C16#1371204, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#1371461, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#1371559, COL_24B70AFC_A481_42F7_BC8F_E9E89DEC4255#1371575, COL_06545D41_928E_4A54_93BF_65904FCF81AA#1371592, COL_0A41C34D_A1FB_4EC3_8E48_5C7A1E003394#1371674, COL_CFEBEA6B_3FE9_463F_8774_B2A3942E56AB#1371815, COL_6FA3C539_F981_4B55_80EE_5B06D96ED482#1371816, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#1371832, COL_E20E6071_1A49_495A_9004_23ED33C98669#1370999, COL_6348CDD7_7FF9_4337_B9DE_365982DB3BA3#1372039, COL_493B3625_15CC_4C3E_B552_CFFC349A58D4#1372040, COL_A2516838_D999_49FB_A245_E9F9B72D742A#1371000, COL_8EA5D1BB_B903_4AA6_811C_01F4D36D9299#1372042]
Arguments: isFinalPlan=true
SQL / DataFrame Properties
Name	Value
spark.sql.optimizer.nestedPredicatePushdown.supportedFileSources	parquet,orc,geoparquet