digraph G {
0 [labelType="html" label="<br><b>AdaptiveSparkPlan</b><br><br>"];
subgraph cluster1 {
isCluster="true";
label="WholeStageCodegen (6)\n \nduration: 0 ms";
2 [labelType="html" label="<br><b>Project</b><br><br>"];
3 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 2"];
}
4 [labelType="html" label="<b>Window</b><br><br>spill size: 0.0 B"];
subgraph cluster5 {
isCluster="true";
label="WholeStageCodegen (5)\n \nduration: 26 ms";
6 [labelType="html" label="<b>Sort</b><br><br>sort time: 0 ms<br>peak memory: 16.1 MiB<br>spill size: 0.0 B"];
7 [labelType="html" label="<br><b>Project</b><br><br>"];
8 [labelType="html" label="<br><b>Project</b><br><br>"];
}
9 [labelType="html" label="<b>Window</b><br><br>spill size: 0.0 B"];
subgraph cluster10 {
isCluster="true";
label="WholeStageCodegen (4)\n \nduration: 69 ms";
11 [labelType="html" label="<b>Sort</b><br><br>sort time: 0 ms<br>peak memory: 16.1 MiB<br>spill size: 0.0 B"];
}
12 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 1<br>partition data size: 532.0 B<br>number of coalesced partitions: 1"];
13 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 7<br>local merged chunks fetched: 0<br>shuffle write time: 0 ms<br>remote merged bytes read: 0.0 B<br>local merged blocks fetched: 0<br>corrupt merged block chunks: 0<br>remote merged reqs duration: 0 ms<br>remote merged blocks fetched: 0<br>records read: 7<br>local bytes read: 516.0 B<br>fetch wait time: 0 ms<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 1<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size: 1120.0 B<br>local merged bytes read: 0.0 B<br>number of partitions: 10<br>remote reqs duration: 0 ms<br>remote bytes read to disk: 0.0 B<br>shuffle bytes written: 516.0 B"];
subgraph cluster14 {
isCluster="true";
label="WholeStageCodegen (3)\n \nduration: 19 ms";
15 [labelType="html" label="<br><b>Project</b><br><br>"];
}
16 [labelType="html" label="<b>CartesianProduct</b><br><br>number of output rows: 7"];
subgraph cluster17 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 29 ms";
18 [labelType="html" label="<br><b>Project</b><br><br>"];
19 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 7"];
20 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 7<br>number of input batches: 1"];
}
21 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 1<br>scan time: 3 ms<br>metadata time: 0 ms<br>size of files read: 20.3 KiB<br>number of output rows: 7"];
subgraph cluster22 {
isCluster="true";
label="WholeStageCodegen (2)\n \nduration: 7 ms";
23 [labelType="html" label="<br><b>Project</b><br><br>"];
24 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 1"];
}
25 [labelType="html" label="<b>Scan csv </b><br><br>number of output rows: 1<br>number of files read: 1<br>metadata time: 0 ms<br>size of files read: 174.0 B"];
2->0;
3->2;
4->3;
6->4;
7->6;
8->7;
9->8;
11->9;
12->11;
13->12;
15->13;
16->15;
18->16;
19->18;
20->19;
21->20;
23->16;
24->23;
25->24;
}
26
AdaptiveSparkPlan isFinalPlan=true
Project [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509, COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, COL_64C7EA76_2D35_48CA_BBB2_A23E235A2A21#792583, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#792596, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#792628, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388]
Filter (COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#792628 <=> 1)
WholeStageCodegen (6)
Window [row_number() windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#792628], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485], [COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387 ASC NULLS LAST]
Sort [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382 ASC NULLS FIRST, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485 ASC NULLS FIRST, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387 ASC NULLS LAST], false, 0
Project [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, str_if_with_rule(CASE WHEN isnull(Contains(COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, SSN)) THEN false ELSE Contains(COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, SSN) END, str_join(array(SSN, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485), *), str_if_with_rule(CASE WHEN isnull(Contains(COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, SSF)) THEN false ELSE Contains(COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, SSF) END, str_join(array(SSF, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485), *), null)) AS COL_64C7EA76_2D35_48CA_BBB2_A23E235A2A21#792583, str_extract_by_str(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, *, RIGHT) AS COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#792596]
Project [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, str_list_as_str(COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509) AS COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571]
WholeStageCodegen (5)
Window [collect_set(COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, 0, 0) windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485], [1 DESC NULLS LAST]
Sort [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382 ASC NULLS FIRST, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
WholeStageCodegen (4)
AQEShuffleRead coalesced
Exchange hashpartitioning(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, 10), ENSURE_REQUIREMENTS, [plan_id=488677]
Project [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, str_extract_by_str(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, *, LEFT) AS COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, str_extract_by_str(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, *, RIGHT) AS COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485]
WholeStageCodegen (3)
CartesianProduct
Project [COL_64ED17E5_A991_405B_AEED_8A2977283F76#792055 AS COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#792056 AS COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#792097 AS COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#792089 AS COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#792103 AS COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7D270645_B926_42AF_A110_EB3A1A53031B#792077 AS COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#792108 AS COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388]
Filter (COL_64ED17E5_A991_405B_AEED_8A2977283F76#792055 <=> 011040518)
ColumnarToRow
WholeStageCodegen (1)
FileScan parquet [COL_64ED17E5_A991_405B_AEED_8A2977283F76#792055,COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#792056,COL_7D270645_B926_42AF_A110_EB3A1A53031B#792077,COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#792089,COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#792097,COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#792103,COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#792108] Batched: true, DataFilters: [(COL_64ED17E5_A991_405B_AEED_8A2977283F76#792055 <=> 011040518)], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/00_B_ACTES_PATI_210234], PartitionFilters: [], PushedFilters: [EqualNullSafe(COL_64ED17E5_A991_405B_AEED_8A2977283F76,011040518)], ReadSchema: struct<COL_64ED17E5_A991_405B_AEED_8A2977283F76:string,COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62:s...
Project
Filter ((isnotnull(REGLES#792180) AND (RC-SSN-SSF = REGLES#792180)) AND (APPLICABLE#792181 <=> O))
WholeStageCodegen (2)
FileScan csv [REGLES#792180,APPLICABLE#792181] Batched: false, DataFilters: [isnotnull(REGLES#792180), (RC-SSN-SSF = REGLES#792180), (APPLICABLE#792181 <=> O)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/REGLES_APPLICAB_209983/REGLES-A-TTT new..., PartitionFilters: [], PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-SSN-SSF), EqualNullSafe(APPLICABLE,O)], ReadSchema: struct<REGLES:string,APPLICABLE:string>
== Physical Plan ==
AdaptiveSparkPlan (37)
+- == Final Plan ==
* Project (20)
+- * Filter (19)
+- Window (18)
+- * Sort (17)
+- * Project (16)
+- * Project (15)
+- Window (14)
+- * Sort (13)
+- AQEShuffleRead (12)
+- ShuffleQueryStage (11), Statistics(sizeInBytes=1120.0 B, rowCount=7)
+- Exchange (10)
+- * Project (9)
+- CartesianProduct Inner (8)
:- * Project (4)
: +- * Filter (3)
: +- * ColumnarToRow (2)
: +- Scan parquet (1)
+- * Project (7)
+- * Filter (6)
+- Scan csv (5)
+- == Initial Plan ==
CollectLimit (36)
+- Project (35)
+- Filter (34)
+- Window (33)
+- Sort (32)
+- Project (31)
+- Project (30)
+- Window (29)
+- Sort (28)
+- Exchange (27)
+- Project (26)
+- CartesianProduct Inner (25)
:- Project (22)
: +- Filter (21)
: +- Scan parquet (1)
+- Project (24)
+- Filter (23)
+- Scan csv (5)
(1) Scan parquet
Output [7]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#792055, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#792056, COL_7D270645_B926_42AF_A110_EB3A1A53031B#792077, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#792089, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#792097, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#792103, COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#792108]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/00_B_ACTES_PATI_210234]
PushedFilters: [EqualNullSafe(COL_64ED17E5_A991_405B_AEED_8A2977283F76,011040518)]
ReadSchema: struct<COL_64ED17E5_A991_405B_AEED_8A2977283F76:string,COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62:string,COL_7D270645_B926_42AF_A110_EB3A1A53031B:string,COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157:string,COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28:string,COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A:string,COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF:timestamp>
(2) ColumnarToRow [codegen id : 1]
Input [7]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#792055, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#792056, COL_7D270645_B926_42AF_A110_EB3A1A53031B#792077, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#792089, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#792097, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#792103, COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#792108]
(3) Filter [codegen id : 1]
Input [7]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#792055, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#792056, COL_7D270645_B926_42AF_A110_EB3A1A53031B#792077, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#792089, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#792097, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#792103, COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#792108]
Condition : (COL_64ED17E5_A991_405B_AEED_8A2977283F76#792055 <=> 011040518)
(4) Project [codegen id : 1]
Output [7]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#792055 AS COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#792056 AS COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#792097 AS COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#792089 AS COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#792103 AS COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7D270645_B926_42AF_A110_EB3A1A53031B#792077 AS COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#792108 AS COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388]
Input [7]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#792055, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#792056, COL_7D270645_B926_42AF_A110_EB3A1A53031B#792077, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#792089, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#792097, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#792103, COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#792108]
(5) Scan csv
Output [2]: [REGLES#792180, APPLICABLE#792181]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/REGLES_APPLICAB_209983/REGLES-A-TTT new.csv]
PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-SSN-SSF), EqualNullSafe(APPLICABLE,O)]
ReadSchema: struct<REGLES:string,APPLICABLE:string>
(6) Filter [codegen id : 2]
Input [2]: [REGLES#792180, APPLICABLE#792181]
Condition : ((isnotnull(REGLES#792180) AND (RC-SSN-SSF = REGLES#792180)) AND (APPLICABLE#792181 <=> O))
(7) Project [codegen id : 2]
Output: []
Input [2]: [REGLES#792180, APPLICABLE#792181]
(8) CartesianProduct
Join type: Inner
Join condition: None
(9) Project [codegen id : 3]
Output [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, str_extract_by_str(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, *, LEFT) AS COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, str_extract_by_str(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, *, RIGHT) AS COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485]
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388]
(10) Exchange
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485]
Arguments: hashpartitioning(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, 10), ENSURE_REQUIREMENTS, [plan_id=488677]
(11) ShuffleQueryStage
Output [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485]
Arguments: 0
(12) AQEShuffleRead
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485]
Arguments: coalesced
(13) Sort [codegen id : 4]
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485]
Arguments: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382 ASC NULLS FIRST, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
(14) Window
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485]
Arguments: [collect_set(COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, 0, 0) windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485], [1 DESC NULLS LAST]
(15) Project [codegen id : 5]
Output [11]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, str_list_as_str(COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509) AS COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571]
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509]
(16) Project [codegen id : 5]
Output [13]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, str_if_with_rule(CASE WHEN isnull(Contains(COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, SSN)) THEN false ELSE Contains(COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, SSN) END, str_join(array(SSN, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485), *), str_if_with_rule(CASE WHEN isnull(Contains(COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, SSF)) THEN false ELSE Contains(COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, SSF) END, str_join(array(SSF, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485), *), null)) AS COL_64C7EA76_2D35_48CA_BBB2_A23E235A2A21#792583, str_extract_by_str(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, *, RIGHT) AS COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#792596]
Input [11]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571]
(17) Sort [codegen id : 5]
Input [13]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, COL_64C7EA76_2D35_48CA_BBB2_A23E235A2A21#792583, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#792596]
Arguments: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382 ASC NULLS FIRST, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485 ASC NULLS FIRST, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387 ASC NULLS LAST], false, 0
(18) Window
Input [13]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, COL_64C7EA76_2D35_48CA_BBB2_A23E235A2A21#792583, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#792596]
Arguments: [row_number() windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#792628], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485], [COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387 ASC NULLS LAST]
(19) Filter [codegen id : 6]
Input [14]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, COL_64C7EA76_2D35_48CA_BBB2_A23E235A2A21#792583, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#792596, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#792628]
Condition : (COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#792628 <=> 1)
(20) Project [codegen id : 6]
Output [14]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509, COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, COL_64C7EA76_2D35_48CA_BBB2_A23E235A2A21#792583, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#792596, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#792628, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388]
Input [14]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, COL_64C7EA76_2D35_48CA_BBB2_A23E235A2A21#792583, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#792596, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#792628]
(21) Filter
Input [7]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#792055, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#792056, COL_7D270645_B926_42AF_A110_EB3A1A53031B#792077, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#792089, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#792097, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#792103, COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#792108]
Condition : (COL_64ED17E5_A991_405B_AEED_8A2977283F76#792055 <=> 011040518)
(22) Project
Output [7]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#792055 AS COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#792056 AS COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#792097 AS COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#792089 AS COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#792103 AS COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7D270645_B926_42AF_A110_EB3A1A53031B#792077 AS COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#792108 AS COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388]
Input [7]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#792055, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#792056, COL_7D270645_B926_42AF_A110_EB3A1A53031B#792077, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#792089, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#792097, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#792103, COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#792108]
(23) Filter
Input [2]: [REGLES#792180, APPLICABLE#792181]
Condition : ((isnotnull(REGLES#792180) AND (RC-SSN-SSF = REGLES#792180)) AND (APPLICABLE#792181 <=> O))
(24) Project
Output: []
Input [2]: [REGLES#792180, APPLICABLE#792181]
(25) CartesianProduct
Join type: Inner
Join condition: None
(26) Project
Output [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, str_extract_by_str(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, *, LEFT) AS COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, str_extract_by_str(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, *, RIGHT) AS COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485]
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388]
(27) Exchange
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485]
Arguments: hashpartitioning(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, 10), ENSURE_REQUIREMENTS, [plan_id=488633]
(28) Sort
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485]
Arguments: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382 ASC NULLS FIRST, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
(29) Window
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485]
Arguments: [collect_set(COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, 0, 0) windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485], [1 DESC NULLS LAST]
(30) Project
Output [11]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, str_list_as_str(COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509) AS COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571]
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509]
(31) Project
Output [13]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, str_if_with_rule(CASE WHEN isnull(Contains(COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, SSN)) THEN false ELSE Contains(COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, SSN) END, str_join(array(SSN, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485), *), str_if_with_rule(CASE WHEN isnull(Contains(COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, SSF)) THEN false ELSE Contains(COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, SSF) END, str_join(array(SSF, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485), *), null)) AS COL_64C7EA76_2D35_48CA_BBB2_A23E235A2A21#792583, str_extract_by_str(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, *, RIGHT) AS COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#792596]
Input [11]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571]
(32) Sort
Input [13]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, COL_64C7EA76_2D35_48CA_BBB2_A23E235A2A21#792583, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#792596]
Arguments: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382 ASC NULLS FIRST, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485 ASC NULLS FIRST, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387 ASC NULLS LAST], false, 0
(33) Window
Input [13]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, COL_64C7EA76_2D35_48CA_BBB2_A23E235A2A21#792583, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#792596]
Arguments: [row_number() windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#792628], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485], [COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387 ASC NULLS LAST]
(34) Filter
Input [14]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, COL_64C7EA76_2D35_48CA_BBB2_A23E235A2A21#792583, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#792596, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#792628]
Condition : (COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#792628 <=> 1)
(35) Project
Output [14]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509, COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, COL_64C7EA76_2D35_48CA_BBB2_A23E235A2A21#792583, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#792596, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#792628, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388]
Input [14]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388, COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, COL_64C7EA76_2D35_48CA_BBB2_A23E235A2A21#792583, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#792596, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#792628]
(36) CollectLimit
Input [14]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509, COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, COL_64C7EA76_2D35_48CA_BBB2_A23E235A2A21#792583, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#792596, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#792628, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388]
Arguments: 1500
(37) AdaptiveSparkPlan
Output [14]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#792382, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#792383, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#792384, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#792385, COL_CE34C768_2435_4E81_8576_51D0A78AC868#792476, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#792485, COL_FED1FCC8_B7C1_4554_B39C_E5A6B682A4A7#792509, COL_2D3250CB_A0F8_432D_934A_94F63788CCC6#792571, COL_64C7EA76_2D35_48CA_BBB2_A23E235A2A21#792583, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#792386, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#792387, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#792596, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#792628, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#792388]
Arguments: isFinalPlan=true