SP1 - Details for Query 2536

Submitted Time: 2026/06/11 09:56:08
Duration: 0.5 s
Succeeded Jobs: 3847 3848 3849 3850

Show the Stage ID and Task ID that corresponds to the max metric

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; 1 [labelType="html" label=" CollectLimit "]; subgraph cluster2 { isCluster="true"; label="WholeStageCodegen (12)\n \nduration: 0 ms"; 3 [labelType="html" label=" Project "]; 4 [labelType="html" label="Generate number of output rows: 1"]; 5 [labelType="html" label=" Project "]; 6 [labelType="html" label=" Project "]; 7 [labelType="html" label=" Project "]; 8 [labelType="html" label="Filter number of output rows: 1"]; } 9 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster10 { isCluster="true"; label="WholeStageCodegen (11)\n \nduration: 35 ms"; 11 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; 12 [labelType="html" label=" Project "]; 13 [labelType="html" label="SortMergeJoin number of output rows: 2 spill size: 0.0 B"]; } subgraph cluster14 { isCluster="true"; label="WholeStageCodegen (9)\n \nduration: 5 ms"; 15 [labelType="html" label=" Project "]; } 16 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster17 { isCluster="true"; label="WholeStageCodegen (8)\n \nduration: 97 ms"; 18 [labelType="html" label=" Project "]; } 19 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster20 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: 8 ms"; 21 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 22 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 304.0 B number of coalesced partitions: 1"]; 23 [labelType="html" label="Exchange shuffle records written: 2 local merged chunks fetched: 0 shuffle write time: 0 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 2 local bytes read: 285.0 B fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 392.0 B local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 285.0 B"]; subgraph cluster24 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: 1 ms"; 25 [labelType="html" label=" Project "]; 26 [labelType="html" label="Filter number of output rows: 2"]; } 27 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster28 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 7 ms"; 29 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 30 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 532.0 B number of coalesced partitions: 1"]; 31 [labelType="html" label="Exchange shuffle records written: 7 local merged chunks fetched: 0 shuffle write time: 1 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 7 local bytes read: 523.0 B fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 1120.0 B local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 523.0 B"]; subgraph cluster32 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: 54 ms"; 33 [labelType="html" label=" Project "]; } 34 [labelType="html" label="CartesianProduct number of output rows: 7"]; subgraph cluster35 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 55 ms"; 36 [labelType="html" label=" Project "]; 37 [labelType="html" label="Filter number of output rows: 7"]; 38 [labelType="html" label="ColumnarToRow number of output rows: 7 number of input batches: 1"]; } 39 [labelType="html" label="Scan parquet number of files read: 1 scan time: 5 ms metadata time: 0 ms size of files read: 20.3 KiB number of output rows: 7"]; subgraph cluster40 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 7 ms"; 41 [labelType="html" label=" Project "]; 42 [labelType="html" label="Filter number of output rows: 1"]; } 43 [labelType="html" label="Scan csv number of output rows: 1 number of files read: 1 metadata time: 0 ms size of files read: 174.0 B"]; subgraph cluster44 { isCluster="true"; label="WholeStageCodegen (10)\n \nduration: 5 ms"; 45 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 46 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 129.0 B number of coalesced partitions: 1"]; 47 [labelType="html" label="Exchange shuffle records written: 1 local merged chunks fetched: 0 shuffle write time: 0 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 1 local bytes read: 124.0 B fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 112.0 B local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 124.0 B"]; subgraph cluster48 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: total (min, med, max (stageId: taskId))\n400 ms (4 ms, 52 ms, 55 ms (stage 8125.0: task 8807))"; 49 [labelType="html" label=" Project "]; 50 [labelType="html" label="Filter number of output rows: 1"]; 51 [labelType="html" label="ColumnarToRow number of output rows: 20,000 number of input batches: 5"]; } 52 [labelType="html" label="Scan parquet number of files read: 10 scan time total (min, med, max (stageId: taskId)) 151 ms (3 ms, 6 ms, 51 ms (stage 8125.0: task 8809)) metadata time: 0 ms size of files read: 30.5 MiB number of output rows: 20,000"]; 1->0; 3->1; 4->3; 5->4; 6->5; 7->6; 8->7; 9->8; 11->9; 12->11; 13->12; 15->13; 16->15; 18->16; 19->18; 21->19; 22->21; 23->22; 25->23; 26->25; 27->26; 29->27; 30->29; 31->30; 33->31; 34->33; 36->34; 37->36; 38->37; 39->38; 41->34; 42->41; 43->42; 45->13; 46->45; 47->46; 49->47; 50->49; 51->50; 52->51; }

AdaptiveSparkPlan isFinalPlan=true

CollectLimit 1500

Generate explode(COL_DD5D4F74_6719_435E_ACCF_6D12BBA233D8#799856), [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_06C34AF4_5684_463F_907D_CDFD03718F51#799455, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#799456, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#799552, COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#799662, COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#799682, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#799454, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#799781, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#799495, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, COL_610987DD_EB5B_42AE_AB45_B039DACF3912#799809, COL_9FC6ABC3_98A5_4A4F_B6F4_E7EA22349E96#799832, COL_DD5D4F74_6719_435E_ACCF_6D12BBA233D8#799856], false, [COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#799882]

Project [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_06C34AF4_5684_463F_907D_CDFD03718F51#799455, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#799456, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#799552, COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#799662, COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#799682, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#799454, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#799781, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#799495, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, COL_610987DD_EB5B_42AE_AB45_B039DACF3912#799809, COL_9FC6ABC3_98A5_4A4F_B6F4_E7EA22349E96#799832, str_list_union(COL_610987DD_EB5B_42AE_AB45_B039DACF3912#799809, COL_9FC6ABC3_98A5_4A4F_B6F4_E7EA22349E96#799832) AS COL_DD5D4F74_6719_435E_ACCF_6D12BBA233D8#799856]

Project [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_06C34AF4_5684_463F_907D_CDFD03718F51#799455, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#799456, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#799552, COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#799662, COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#799682, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#799454, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458, str_join(array(str_join(array(SSN/SSF Déduit Infos Patient absent RSF, str_list_as_str(COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#799662)), : ), str_join(array(SSN/SSF dans RSF et absent des Infos Patient, str_list_as_str(COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#799682)), : ), str_join(array(Acte - Spé - Date , str_list_as_str(COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#799495)), : )), - ) AS COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#799781, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#799495, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, str_split(str_replace_extend(str_replace_extend(str_list_as_str(COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#799662), [SSN,SSF], [SSN+,SSF+]), [[,",]], [,,]), ,) AS COL_610987DD_EB5B_42AE_AB45_B039DACF3912#799809, str_split(str_replace_extend(str_replace_extend(str_list_as_str(COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#799682), [SSN,SSF], [SSN-,SSF-]), [[,",]], [,,]), ,) AS COL_9FC6ABC3_98A5_4A4F_B6F4_E7EA22349E96#799832]

Filter ((COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#799552 <=> 1) AND ((size(str_list_union(str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457)), [SSN,SSF], [SSN+,SSF+]), [[,",]], [,,]), ,), str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020)), [SSN,SSF], [SSN-,SSF-]), [[,",]], [,,]), ,)), true) > 0) AND isnotnull(str_list_union(str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457)), [SSN,SSF], [SSN+,SSF+]), [[,",]], [,,]), ,), str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020)), [SSN,SSF], [SSN-,SSF-]), [[,",]], [,,]), ,)))))

WholeStageCodegen (12)

Window [collect_set(COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, 0, 0) windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#799495, row_number() windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#799552], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614], [COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458 DESC NULLS LAST]

Sort [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614 ASC NULLS FIRST, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458 DESC NULLS LAST], false, 0

Project [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, 02_A_ELIGIBLE_210376_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#799224 AS COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#799454, 02_A_ELIGIBLE_210376_COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#799260 AS COL_06C34AF4_5684_463F_907D_CDFD03718F51#799455, 02_A_ELIGIBLE_210376_COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#799261 AS COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#799456, 02_A_ELIGIBLE_210376_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#799264 AS COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457, 02_A_ELIGIBLE_210376_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#799265 AS COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458]

SortMergeJoin [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614], [02_A_ELIGIBLE_210376_COL_F76265AB_8748_4114_92B4_00E37DE25D34#799228], Inner

WholeStageCodegen (11)

WholeStageCodegen (9)

Window [concatwithseparatorudaf(_w0#799074, com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@32b37650, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614], [1 DESC NULLS LAST]

WholeStageCodegen (8)

Window [collect_set(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, 0, 0) windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614], [1 DESC NULLS LAST]

Sort [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

WholeStageCodegen (7)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, 10), ENSURE_REQUIREMENTS, [plan_id=490814]

Filter (COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860 <=> 1)

WholeStageCodegen (6)

Window [row_number() windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#798788, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#798788], [COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619 ASC NULLS LAST]

Sort [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614 ASC NULLS FIRST, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#798788 ASC NULLS FIRST, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619 ASC NULLS LAST], false, 0

WholeStageCodegen (5)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#798788, 10), ENSURE_REQUIREMENTS, [plan_id=490641]

Project [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, str_extract_by_str(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, *, RIGHT) AS COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#798788, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, str_extract_by_str(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, *, RIGHT) AS COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828]

WholeStageCodegen (3)

CartesianProduct

Project [COL_64ED17E5_A991_405B_AEED_8A2977283F76#798067 AS COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#798068 AS COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#798109 AS COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#798101 AS COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#798115 AS COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7D270645_B926_42AF_A110_EB3A1A53031B#798089 AS COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#798120 AS COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620]

Filter ((COL_64ED17E5_A991_405B_AEED_8A2977283F76#798067 <=> 011040518) AND isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#798067))

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_64ED17E5_A991_405B_AEED_8A2977283F76#798067,COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#798068,COL_7D270645_B926_42AF_A110_EB3A1A53031B#798089,COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#798101,COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#798109,COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#798115,COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#798120] Batched: true, DataFilters: [(COL_64ED17E5_A991_405B_AEED_8A2977283F76#798067 <=> 011040518), isnotnull(COL_64ED17E5_A991_405..., 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), IsNotNull(COL_64ED17E5_A991_4..., ReadSchema: struct<COL_64ED17E5_A991_405B_AEED_8A2977283F76:string,COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62:s...

Project

Filter ((isnotnull(REGLES#798306) AND (RC-SSN-SSF = REGLES#798306)) AND (APPLICABLE#798307 <=> O))

WholeStageCodegen (2)

FileScan csv [REGLES#798306,APPLICABLE#798307] Batched: false, DataFilters: [isnotnull(REGLES#798306), (RC-SSN-SSF = REGLES#798306), (APPLICABLE#798307 <=> 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>

Sort [02_A_ELIGIBLE_210376_COL_F76265AB_8748_4114_92B4_00E37DE25D34#799228 ASC NULLS FIRST], false, 0

WholeStageCodegen (10)

AQEShuffleRead coalesced

Exchange hashpartitioning(02_A_ELIGIBLE_210376_COL_F76265AB_8748_4114_92B4_00E37DE25D34#799228, 10), ENSURE_REQUIREMENTS, [plan_id=490688]

Project [COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#798329 AS 02_A_ELIGIBLE_210376_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#799224, COL_F76265AB_8748_4114_92B4_00E37DE25D34#798333 AS 02_A_ELIGIBLE_210376_COL_F76265AB_8748_4114_92B4_00E37DE25D34#799228, COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#798365 AS 02_A_ELIGIBLE_210376_COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#799260, COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#798366 AS 02_A_ELIGIBLE_210376_COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#799261, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#798369 AS 02_A_ELIGIBLE_210376_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#799264, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#798370 AS 02_A_ELIGIBLE_210376_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#799265]

Filter (((isnotnull(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#798328) AND (A = COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#798328)) AND (COL_F76265AB_8748_4114_92B4_00E37DE25D34#798333 <=> 011040518)) AND isnotnull(COL_F76265AB_8748_4114_92B4_00E37DE25D34#798333))

ColumnarToRow

WholeStageCodegen (4)

FileScan parquet [COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#798328,COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#798329,COL_F76265AB_8748_4114_92B4_00E37DE25D34#798333,COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#798365,COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#798366,COL_95383EBC_3648_4E94_9C53_D311092BF5F4#798369,COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#798370] Batched: true, DataFilters: [isnotnull(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#798328), (A = COL_1DDA21A4_0127_416B_A5DB_7ED..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/02_A_ELIGIBLE_210376], PartitionFilters: [], PushedFilters: [IsNotNull(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56), EqualTo(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC..., ReadSchema: struct<COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56:string,COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB:s...

Details

== Physical Plan ==
AdaptiveSparkPlan (76)
+- == Final Plan ==
   CollectLimit (43)
   +- * Project (42)
      +- * Generate (41)
         +- * Project (40)
            +- * Project (39)
               +- * Project (38)
                  +- * Filter (37)
                     +- Window (36)
                        +- * Sort (35)
                           +- * Project (34)
                              +- * SortMergeJoin Inner (33)
                                 :- * Project (24)
                                 :  +- Window (23)
                                 :     +- * Project (22)
                                 :        +- Window (21)
                                 :           +- * Sort (20)
                                 :              +- AQEShuffleRead (19)
                                 :                 +- ShuffleQueryStage (18), Statistics(sizeInBytes=392.0 B, rowCount=2)
                                 :                    +- Exchange (17)
                                 :                       +- * Project (16)
                                 :                          +- * Filter (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)
                                 +- * Sort (32)
                                    +- AQEShuffleRead (31)
                                       +- ShuffleQueryStage (30), Statistics(sizeInBytes=112.0 B, rowCount=1)
                                          +- Exchange (29)
                                             +- * Project (28)
                                                +- * Filter (27)
                                                   +- * ColumnarToRow (26)
                                                      +- Scan parquet  (25)
+- == Initial Plan ==
   CollectLimit (75)
   +- Project (74)
      +- Generate (73)
         +- Project (72)
            +- Project (71)
               +- Project (70)
                  +- Filter (69)
                     +- Window (68)
                        +- Sort (67)
                           +- Project (66)
                              +- SortMergeJoin Inner (65)
                                 :- Project (60)
                                 :  +- Window (59)
                                 :     +- Project (58)
                                 :        +- Window (57)
                                 :           +- Sort (56)
                                 :              +- Exchange (55)
                                 :                 +- Project (54)
                                 :                    +- Filter (53)
                                 :                       +- Window (52)
                                 :                          +- Sort (51)
                                 :                             +- Exchange (50)
                                 :                                +- Project (49)
                                 :                                   +- CartesianProduct Inner (48)
                                 :                                      :- Project (45)
                                 :                                      :  +- Filter (44)
                                 :                                      :     +- Scan parquet  (1)
                                 :                                      +- Project (47)
                                 :                                         +- Filter (46)
                                 :                                            +- Scan csv  (5)
                                 +- Sort (64)
                                    +- Exchange (63)
                                       +- Project (62)
                                          +- Filter (61)
                                             +- Scan parquet  (25)


(1) Scan parquet 
Output [7]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#798067, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#798068, COL_7D270645_B926_42AF_A110_EB3A1A53031B#798089, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#798101, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#798109, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#798115, COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#798120]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/00_B_ACTES_PATI_210234]
PushedFilters: [EqualNullSafe(COL_64ED17E5_A991_405B_AEED_8A2977283F76,011040518), IsNotNull(COL_64ED17E5_A991_405B_AEED_8A2977283F76)]
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#798067, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#798068, COL_7D270645_B926_42AF_A110_EB3A1A53031B#798089, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#798101, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#798109, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#798115, COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#798120]

(3) Filter [codegen id : 1]
Input [7]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#798067, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#798068, COL_7D270645_B926_42AF_A110_EB3A1A53031B#798089, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#798101, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#798109, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#798115, COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#798120]
Condition : ((COL_64ED17E5_A991_405B_AEED_8A2977283F76#798067 <=> 011040518) AND isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#798067))

(4) Project [codegen id : 1]
Output [7]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#798067 AS COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#798068 AS COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#798109 AS COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#798101 AS COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#798115 AS COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7D270645_B926_42AF_A110_EB3A1A53031B#798089 AS COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#798120 AS COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620]
Input [7]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#798067, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#798068, COL_7D270645_B926_42AF_A110_EB3A1A53031B#798089, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#798101, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#798109, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#798115, COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#798120]

(5) Scan csv 
Output [2]: [REGLES#798306, APPLICABLE#798307]
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#798306, APPLICABLE#798307]
Condition : ((isnotnull(REGLES#798306) AND (RC-SSN-SSF = REGLES#798306)) AND (APPLICABLE#798307 <=> O))

(7) Project [codegen id : 2]
Output: []
Input [2]: [REGLES#798306, APPLICABLE#798307]

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

(9) Project [codegen id : 3]
Output [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, str_extract_by_str(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, *, RIGHT) AS COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#798788, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, str_extract_by_str(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, *, RIGHT) AS COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828]
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620]

(10) Exchange
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#798788, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828]
Arguments: hashpartitioning(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#798788, 10), ENSURE_REQUIREMENTS, [plan_id=490641]

(11) ShuffleQueryStage
Output [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#798788, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828]
Arguments: 0

(12) AQEShuffleRead
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#798788, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828]
Arguments: coalesced

(13) Sort [codegen id : 5]
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#798788, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828]
Arguments: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614 ASC NULLS FIRST, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#798788 ASC NULLS FIRST, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619 ASC NULLS LAST], false, 0

(14) Window
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#798788, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828]
Arguments: [row_number() windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#798788, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#798788], [COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619 ASC NULLS LAST]

(15) Filter [codegen id : 6]
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#798788, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860]
Condition : (COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860 <=> 1)

(16) Project [codegen id : 6]
Output [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620]
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#798788, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860]

(17) Exchange
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620]
Arguments: hashpartitioning(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, 10), ENSURE_REQUIREMENTS, [plan_id=490814]

(18) ShuffleQueryStage
Output [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620]
Arguments: 2

(19) AQEShuffleRead
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620]
Arguments: coalesced

(20) Sort [codegen id : 7]
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620]
Arguments: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(21) Window
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620]
Arguments: [collect_set(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, 0, 0) windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614], [1 DESC NULLS LAST]

(22) Project [codegen id : 8]
Output [11]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, ARRAY_TO_STR_BEFORE_CONCAT(COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617) AS _w0#799074]
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020]

(23) Window
Input [11]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, _w0#799074]
Arguments: [concatwithseparatorudaf(_w0#799074, com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@32b37650, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614], [1 DESC NULLS LAST]

(24) Project [codegen id : 9]
Output [11]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620]
Input [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, _w0#799074, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073]

(25) Scan parquet 
Output [7]: [COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#798328, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#798329, COL_F76265AB_8748_4114_92B4_00E37DE25D34#798333, COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#798365, COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#798366, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#798369, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#798370]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/02_A_ELIGIBLE_210376]
PushedFilters: [IsNotNull(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56), EqualTo(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56,A), EqualNullSafe(COL_F76265AB_8748_4114_92B4_00E37DE25D34,011040518), IsNotNull(COL_F76265AB_8748_4114_92B4_00E37DE25D34)]
ReadSchema: struct<COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56:string,COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB:string,COL_F76265AB_8748_4114_92B4_00E37DE25D34:string,COL_D7508510_B4D7_44C5_A063_A2132B6EF08A:array<string>,COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E:string,COL_95383EBC_3648_4E94_9C53_D311092BF5F4:array<string>,COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD:string>

(26) ColumnarToRow [codegen id : 4]
Input [7]: [COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#798328, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#798329, COL_F76265AB_8748_4114_92B4_00E37DE25D34#798333, COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#798365, COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#798366, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#798369, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#798370]

(27) Filter [codegen id : 4]
Input [7]: [COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#798328, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#798329, COL_F76265AB_8748_4114_92B4_00E37DE25D34#798333, COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#798365, COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#798366, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#798369, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#798370]
Condition : (((isnotnull(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#798328) AND (A = COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#798328)) AND (COL_F76265AB_8748_4114_92B4_00E37DE25D34#798333 <=> 011040518)) AND isnotnull(COL_F76265AB_8748_4114_92B4_00E37DE25D34#798333))

(28) Project [codegen id : 4]
Output [6]: [COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#798329 AS 02_A_ELIGIBLE_210376_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#799224, COL_F76265AB_8748_4114_92B4_00E37DE25D34#798333 AS 02_A_ELIGIBLE_210376_COL_F76265AB_8748_4114_92B4_00E37DE25D34#799228, COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#798365 AS 02_A_ELIGIBLE_210376_COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#799260, COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#798366 AS 02_A_ELIGIBLE_210376_COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#799261, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#798369 AS 02_A_ELIGIBLE_210376_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#799264, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#798370 AS 02_A_ELIGIBLE_210376_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#799265]
Input [7]: [COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#798328, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#798329, COL_F76265AB_8748_4114_92B4_00E37DE25D34#798333, COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#798365, COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#798366, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#798369, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#798370]

(29) Exchange
Input [6]: [02_A_ELIGIBLE_210376_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#799224, 02_A_ELIGIBLE_210376_COL_F76265AB_8748_4114_92B4_00E37DE25D34#799228, 02_A_ELIGIBLE_210376_COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#799260, 02_A_ELIGIBLE_210376_COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#799261, 02_A_ELIGIBLE_210376_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#799264, 02_A_ELIGIBLE_210376_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#799265]
Arguments: hashpartitioning(02_A_ELIGIBLE_210376_COL_F76265AB_8748_4114_92B4_00E37DE25D34#799228, 10), ENSURE_REQUIREMENTS, [plan_id=490688]

(30) ShuffleQueryStage
Output [6]: [02_A_ELIGIBLE_210376_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#799224, 02_A_ELIGIBLE_210376_COL_F76265AB_8748_4114_92B4_00E37DE25D34#799228, 02_A_ELIGIBLE_210376_COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#799260, 02_A_ELIGIBLE_210376_COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#799261, 02_A_ELIGIBLE_210376_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#799264, 02_A_ELIGIBLE_210376_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#799265]
Arguments: 1

(31) AQEShuffleRead
Input [6]: [02_A_ELIGIBLE_210376_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#799224, 02_A_ELIGIBLE_210376_COL_F76265AB_8748_4114_92B4_00E37DE25D34#799228, 02_A_ELIGIBLE_210376_COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#799260, 02_A_ELIGIBLE_210376_COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#799261, 02_A_ELIGIBLE_210376_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#799264, 02_A_ELIGIBLE_210376_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#799265]
Arguments: coalesced

(32) Sort [codegen id : 10]
Input [6]: [02_A_ELIGIBLE_210376_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#799224, 02_A_ELIGIBLE_210376_COL_F76265AB_8748_4114_92B4_00E37DE25D34#799228, 02_A_ELIGIBLE_210376_COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#799260, 02_A_ELIGIBLE_210376_COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#799261, 02_A_ELIGIBLE_210376_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#799264, 02_A_ELIGIBLE_210376_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#799265]
Arguments: [02_A_ELIGIBLE_210376_COL_F76265AB_8748_4114_92B4_00E37DE25D34#799228 ASC NULLS FIRST], false, 0

(33) SortMergeJoin [codegen id : 11]
Left keys [1]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614]
Right keys [1]: [02_A_ELIGIBLE_210376_COL_F76265AB_8748_4114_92B4_00E37DE25D34#799228]
Join type: Inner
Join condition: None

(34) Project [codegen id : 11]
Output [16]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, 02_A_ELIGIBLE_210376_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#799224 AS COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#799454, 02_A_ELIGIBLE_210376_COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#799260 AS COL_06C34AF4_5684_463F_907D_CDFD03718F51#799455, 02_A_ELIGIBLE_210376_COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#799261 AS COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#799456, 02_A_ELIGIBLE_210376_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#799264 AS COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457, 02_A_ELIGIBLE_210376_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#799265 AS COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458]
Input [17]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, 02_A_ELIGIBLE_210376_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#799224, 02_A_ELIGIBLE_210376_COL_F76265AB_8748_4114_92B4_00E37DE25D34#799228, 02_A_ELIGIBLE_210376_COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#799260, 02_A_ELIGIBLE_210376_COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#799261, 02_A_ELIGIBLE_210376_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#799264, 02_A_ELIGIBLE_210376_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#799265]

(35) Sort [codegen id : 11]
Input [16]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#799454, COL_06C34AF4_5684_463F_907D_CDFD03718F51#799455, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#799456, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458]
Arguments: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614 ASC NULLS FIRST, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458 DESC NULLS LAST], false, 0

(36) Window
Input [16]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#799454, COL_06C34AF4_5684_463F_907D_CDFD03718F51#799455, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#799456, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458]
Arguments: [collect_set(COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, 0, 0) windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#799495, row_number() windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#799552], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614], [COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458 DESC NULLS LAST]

(37) Filter [codegen id : 12]
Input [18]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#799454, COL_06C34AF4_5684_463F_907D_CDFD03718F51#799455, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#799456, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#799495, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#799552]
Condition : ((COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#799552 <=> 1) AND ((size(str_list_union(str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457)), [SSN,SSF], [SSN+,SSF+]), [[,",]], [,,]), ,), str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020)), [SSN,SSF], [SSN-,SSF-]), [[,",]], [,,]), ,)), true) > 0) AND isnotnull(str_list_union(str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457)), [SSN,SSF], [SSN+,SSF+]), [[,",]], [,,]), ,), str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020)), [SSN,SSF], [SSN-,SSF-]), [[,",]], [,,]), ,)))))

(38) Project [codegen id : 12]
Output [20]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_06C34AF4_5684_463F_907D_CDFD03718F51#799455, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#799456, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#799552, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#799454, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#799495, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, array_except(COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457) AS COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#799662, array_except(COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020) AS COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#799682]
Input [18]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#799454, COL_06C34AF4_5684_463F_907D_CDFD03718F51#799455, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#799456, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#799495, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#799552]

(39) Project [codegen id : 12]
Output [23]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_06C34AF4_5684_463F_907D_CDFD03718F51#799455, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#799456, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#799552, COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#799662, COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#799682, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#799454, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458, str_join(array(str_join(array(SSN/SSF Déduit Infos Patient absent RSF, str_list_as_str(COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#799662)),  : ), str_join(array(SSN/SSF dans RSF et absent des Infos Patient, str_list_as_str(COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#799682)),  : ), str_join(array(Acte - Spé - Date , str_list_as_str(COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#799495)),  : )),  - ) AS COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#799781, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#799495, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, str_split(str_replace_extend(str_replace_extend(str_list_as_str(COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#799662), [SSN,SSF], [SSN+,SSF+]), [[,",]], [,,]), ,) AS COL_610987DD_EB5B_42AE_AB45_B039DACF3912#799809, str_split(str_replace_extend(str_replace_extend(str_list_as_str(COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#799682), [SSN,SSF], [SSN-,SSF-]), [[,",]], [,,]), ,) AS COL_9FC6ABC3_98A5_4A4F_B6F4_E7EA22349E96#799832]
Input [20]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_06C34AF4_5684_463F_907D_CDFD03718F51#799455, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#799456, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#799552, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#799454, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#799495, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#799662, COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#799682]

(40) Project [codegen id : 12]
Output [24]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_06C34AF4_5684_463F_907D_CDFD03718F51#799455, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#799456, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#799552, COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#799662, COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#799682, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#799454, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#799781, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#799495, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, COL_610987DD_EB5B_42AE_AB45_B039DACF3912#799809, COL_9FC6ABC3_98A5_4A4F_B6F4_E7EA22349E96#799832, str_list_union(COL_610987DD_EB5B_42AE_AB45_B039DACF3912#799809, COL_9FC6ABC3_98A5_4A4F_B6F4_E7EA22349E96#799832) AS COL_DD5D4F74_6719_435E_ACCF_6D12BBA233D8#799856]
Input [23]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_06C34AF4_5684_463F_907D_CDFD03718F51#799455, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#799456, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#799552, COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#799662, COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#799682, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#799454, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#799781, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#799495, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, COL_610987DD_EB5B_42AE_AB45_B039DACF3912#799809, COL_9FC6ABC3_98A5_4A4F_B6F4_E7EA22349E96#799832]

(41) Generate [codegen id : 12]
Input [24]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_06C34AF4_5684_463F_907D_CDFD03718F51#799455, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#799456, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#799552, COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#799662, COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#799682, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#799454, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#799781, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#799495, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, COL_610987DD_EB5B_42AE_AB45_B039DACF3912#799809, COL_9FC6ABC3_98A5_4A4F_B6F4_E7EA22349E96#799832, COL_DD5D4F74_6719_435E_ACCF_6D12BBA233D8#799856]
Arguments: explode(COL_DD5D4F74_6719_435E_ACCF_6D12BBA233D8#799856), [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_06C34AF4_5684_463F_907D_CDFD03718F51#799455, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#799456, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#799552, COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#799662, COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#799682, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#799454, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#799781, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#799495, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, COL_610987DD_EB5B_42AE_AB45_B039DACF3912#799809, COL_9FC6ABC3_98A5_4A4F_B6F4_E7EA22349E96#799832, COL_DD5D4F74_6719_435E_ACCF_6D12BBA233D8#799856], false, [COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#799882]

(42) Project [codegen id : 12]
Output [25]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_06C34AF4_5684_463F_907D_CDFD03718F51#799455, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#799456, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#799552, COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#799662, COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#799682, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#799454, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458, COL_610987DD_EB5B_42AE_AB45_B039DACF3912#799809, COL_9FC6ABC3_98A5_4A4F_B6F4_E7EA22349E96#799832, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#799882, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#799781, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#799495, COL_DD5D4F74_6719_435E_ACCF_6D12BBA233D8#799856, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620]
Input [25]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_06C34AF4_5684_463F_907D_CDFD03718F51#799455, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#799456, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#799552, COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#799662, COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#799682, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#799454, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#799781, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#799495, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, COL_610987DD_EB5B_42AE_AB45_B039DACF3912#799809, COL_9FC6ABC3_98A5_4A4F_B6F4_E7EA22349E96#799832, COL_DD5D4F74_6719_435E_ACCF_6D12BBA233D8#799856, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#799882]

(43) CollectLimit
Input [25]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_06C34AF4_5684_463F_907D_CDFD03718F51#799455, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#799456, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#799552, COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#799662, COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#799682, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#799454, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458, COL_610987DD_EB5B_42AE_AB45_B039DACF3912#799809, COL_9FC6ABC3_98A5_4A4F_B6F4_E7EA22349E96#799832, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#799882, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#799781, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#799495, COL_DD5D4F74_6719_435E_ACCF_6D12BBA233D8#799856, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620]
Arguments: 1500

(44) Filter
Input [7]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#798067, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#798068, COL_7D270645_B926_42AF_A110_EB3A1A53031B#798089, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#798101, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#798109, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#798115, COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#798120]
Condition : ((COL_64ED17E5_A991_405B_AEED_8A2977283F76#798067 <=> 011040518) AND isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#798067))

(45) Project
Output [7]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#798067 AS COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#798068 AS COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#798109 AS COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#798101 AS COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#798115 AS COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7D270645_B926_42AF_A110_EB3A1A53031B#798089 AS COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#798120 AS COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620]
Input [7]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#798067, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#798068, COL_7D270645_B926_42AF_A110_EB3A1A53031B#798089, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#798101, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#798109, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#798115, COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#798120]

(46) Filter
Input [2]: [REGLES#798306, APPLICABLE#798307]
Condition : ((isnotnull(REGLES#798306) AND (RC-SSN-SSF = REGLES#798306)) AND (APPLICABLE#798307 <=> O))

(47) Project
Output: []
Input [2]: [REGLES#798306, APPLICABLE#798307]

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

(49) Project
Output [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, str_extract_by_str(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, *, RIGHT) AS COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#798788, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, str_extract_by_str(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, *, RIGHT) AS COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828]
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620]

(50) Exchange
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#798788, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828]
Arguments: hashpartitioning(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#798788, 10), ENSURE_REQUIREMENTS, [plan_id=490570]

(51) Sort
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#798788, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828]
Arguments: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614 ASC NULLS FIRST, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#798788 ASC NULLS FIRST, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619 ASC NULLS LAST], false, 0

(52) Window
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#798788, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828]
Arguments: [row_number() windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#798788, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#798788], [COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619 ASC NULLS LAST]

(53) Filter
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#798788, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860]
Condition : (COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860 <=> 1)

(54) Project
Output [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620]
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#798788, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860]

(55) Exchange
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620]
Arguments: hashpartitioning(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, 10), ENSURE_REQUIREMENTS, [plan_id=490576]

(56) Sort
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620]
Arguments: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(57) Window
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620]
Arguments: [collect_set(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, 0, 0) windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614], [1 DESC NULLS LAST]

(58) Project
Output [11]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, ARRAY_TO_STR_BEFORE_CONCAT(COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617) AS _w0#799074]
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020]

(59) Window
Input [11]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, _w0#799074]
Arguments: [concatwithseparatorudaf(_w0#799074, com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@32b37650, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614], [1 DESC NULLS LAST]

(60) Project
Output [11]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620]
Input [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, _w0#799074, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073]

(61) Filter
Input [7]: [COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#798328, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#798329, COL_F76265AB_8748_4114_92B4_00E37DE25D34#798333, COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#798365, COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#798366, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#798369, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#798370]
Condition : (((isnotnull(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#798328) AND (A = COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#798328)) AND (COL_F76265AB_8748_4114_92B4_00E37DE25D34#798333 <=> 011040518)) AND isnotnull(COL_F76265AB_8748_4114_92B4_00E37DE25D34#798333))

(62) Project
Output [6]: [COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#798329 AS 02_A_ELIGIBLE_210376_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#799224, COL_F76265AB_8748_4114_92B4_00E37DE25D34#798333 AS 02_A_ELIGIBLE_210376_COL_F76265AB_8748_4114_92B4_00E37DE25D34#799228, COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#798365 AS 02_A_ELIGIBLE_210376_COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#799260, COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#798366 AS 02_A_ELIGIBLE_210376_COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#799261, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#798369 AS 02_A_ELIGIBLE_210376_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#799264, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#798370 AS 02_A_ELIGIBLE_210376_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#799265]
Input [7]: [COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#798328, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#798329, COL_F76265AB_8748_4114_92B4_00E37DE25D34#798333, COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#798365, COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#798366, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#798369, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#798370]

(63) Exchange
Input [6]: [02_A_ELIGIBLE_210376_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#799224, 02_A_ELIGIBLE_210376_COL_F76265AB_8748_4114_92B4_00E37DE25D34#799228, 02_A_ELIGIBLE_210376_COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#799260, 02_A_ELIGIBLE_210376_COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#799261, 02_A_ELIGIBLE_210376_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#799264, 02_A_ELIGIBLE_210376_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#799265]
Arguments: hashpartitioning(02_A_ELIGIBLE_210376_COL_F76265AB_8748_4114_92B4_00E37DE25D34#799228, 10), ENSURE_REQUIREMENTS, [plan_id=490584]

(64) Sort
Input [6]: [02_A_ELIGIBLE_210376_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#799224, 02_A_ELIGIBLE_210376_COL_F76265AB_8748_4114_92B4_00E37DE25D34#799228, 02_A_ELIGIBLE_210376_COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#799260, 02_A_ELIGIBLE_210376_COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#799261, 02_A_ELIGIBLE_210376_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#799264, 02_A_ELIGIBLE_210376_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#799265]
Arguments: [02_A_ELIGIBLE_210376_COL_F76265AB_8748_4114_92B4_00E37DE25D34#799228 ASC NULLS FIRST], false, 0

(65) SortMergeJoin
Left keys [1]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614]
Right keys [1]: [02_A_ELIGIBLE_210376_COL_F76265AB_8748_4114_92B4_00E37DE25D34#799228]
Join type: Inner
Join condition: None

(66) Project
Output [16]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, 02_A_ELIGIBLE_210376_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#799224 AS COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#799454, 02_A_ELIGIBLE_210376_COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#799260 AS COL_06C34AF4_5684_463F_907D_CDFD03718F51#799455, 02_A_ELIGIBLE_210376_COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#799261 AS COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#799456, 02_A_ELIGIBLE_210376_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#799264 AS COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457, 02_A_ELIGIBLE_210376_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#799265 AS COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458]
Input [17]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, 02_A_ELIGIBLE_210376_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#799224, 02_A_ELIGIBLE_210376_COL_F76265AB_8748_4114_92B4_00E37DE25D34#799228, 02_A_ELIGIBLE_210376_COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#799260, 02_A_ELIGIBLE_210376_COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#799261, 02_A_ELIGIBLE_210376_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#799264, 02_A_ELIGIBLE_210376_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#799265]

(67) Sort
Input [16]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#799454, COL_06C34AF4_5684_463F_907D_CDFD03718F51#799455, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#799456, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458]
Arguments: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614 ASC NULLS FIRST, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458 DESC NULLS LAST], false, 0

(68) Window
Input [16]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#799454, COL_06C34AF4_5684_463F_907D_CDFD03718F51#799455, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#799456, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458]
Arguments: [collect_set(COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, 0, 0) windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#799495, row_number() windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#799552], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614], [COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458 DESC NULLS LAST]

(69) Filter
Input [18]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#799454, COL_06C34AF4_5684_463F_907D_CDFD03718F51#799455, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#799456, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#799495, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#799552]
Condition : ((COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#799552 <=> 1) AND ((size(str_list_union(str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457)), [SSN,SSF], [SSN+,SSF+]), [[,",]], [,,]), ,), str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020)), [SSN,SSF], [SSN-,SSF-]), [[,",]], [,,]), ,)), true) > 0) AND isnotnull(str_list_union(str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457)), [SSN,SSF], [SSN+,SSF+]), [[,",]], [,,]), ,), str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020)), [SSN,SSF], [SSN-,SSF-]), [[,",]], [,,]), ,)))))

(70) Project
Output [20]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_06C34AF4_5684_463F_907D_CDFD03718F51#799455, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#799456, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#799552, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#799454, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#799495, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, array_except(COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457) AS COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#799662, array_except(COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020) AS COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#799682]
Input [18]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#799454, COL_06C34AF4_5684_463F_907D_CDFD03718F51#799455, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#799456, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#799495, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#799552]

(71) Project
Output [23]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_06C34AF4_5684_463F_907D_CDFD03718F51#799455, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#799456, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#799552, COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#799662, COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#799682, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#799454, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458, str_join(array(str_join(array(SSN/SSF Déduit Infos Patient absent RSF, str_list_as_str(COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#799662)),  : ), str_join(array(SSN/SSF dans RSF et absent des Infos Patient, str_list_as_str(COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#799682)),  : ), str_join(array(Acte - Spé - Date , str_list_as_str(COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#799495)),  : )),  - ) AS COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#799781, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#799495, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, str_split(str_replace_extend(str_replace_extend(str_list_as_str(COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#799662), [SSN,SSF], [SSN+,SSF+]), [[,",]], [,,]), ,) AS COL_610987DD_EB5B_42AE_AB45_B039DACF3912#799809, str_split(str_replace_extend(str_replace_extend(str_list_as_str(COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#799682), [SSN,SSF], [SSN-,SSF-]), [[,",]], [,,]), ,) AS COL_9FC6ABC3_98A5_4A4F_B6F4_E7EA22349E96#799832]
Input [20]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_06C34AF4_5684_463F_907D_CDFD03718F51#799455, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#799456, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#799552, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#799454, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#799495, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#799662, COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#799682]

(72) Project
Output [24]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_06C34AF4_5684_463F_907D_CDFD03718F51#799455, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#799456, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#799552, COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#799662, COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#799682, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#799454, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#799781, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#799495, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, COL_610987DD_EB5B_42AE_AB45_B039DACF3912#799809, COL_9FC6ABC3_98A5_4A4F_B6F4_E7EA22349E96#799832, str_list_union(COL_610987DD_EB5B_42AE_AB45_B039DACF3912#799809, COL_9FC6ABC3_98A5_4A4F_B6F4_E7EA22349E96#799832) AS COL_DD5D4F74_6719_435E_ACCF_6D12BBA233D8#799856]
Input [23]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_06C34AF4_5684_463F_907D_CDFD03718F51#799455, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#799456, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#799552, COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#799662, COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#799682, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#799454, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#799781, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#799495, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, COL_610987DD_EB5B_42AE_AB45_B039DACF3912#799809, COL_9FC6ABC3_98A5_4A4F_B6F4_E7EA22349E96#799832]

(73) Generate
Input [24]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_06C34AF4_5684_463F_907D_CDFD03718F51#799455, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#799456, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#799552, COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#799662, COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#799682, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#799454, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#799781, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#799495, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, COL_610987DD_EB5B_42AE_AB45_B039DACF3912#799809, COL_9FC6ABC3_98A5_4A4F_B6F4_E7EA22349E96#799832, COL_DD5D4F74_6719_435E_ACCF_6D12BBA233D8#799856]
Arguments: explode(COL_DD5D4F74_6719_435E_ACCF_6D12BBA233D8#799856), [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_06C34AF4_5684_463F_907D_CDFD03718F51#799455, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#799456, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#799552, COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#799662, COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#799682, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#799454, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#799781, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#799495, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, COL_610987DD_EB5B_42AE_AB45_B039DACF3912#799809, COL_9FC6ABC3_98A5_4A4F_B6F4_E7EA22349E96#799832, COL_DD5D4F74_6719_435E_ACCF_6D12BBA233D8#799856], false, [COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#799882]

(74) Project
Output [25]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_06C34AF4_5684_463F_907D_CDFD03718F51#799455, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#799456, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#799552, COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#799662, COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#799682, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#799454, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458, COL_610987DD_EB5B_42AE_AB45_B039DACF3912#799809, COL_9FC6ABC3_98A5_4A4F_B6F4_E7EA22349E96#799832, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#799882, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#799781, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#799495, COL_DD5D4F74_6719_435E_ACCF_6D12BBA233D8#799856, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620]
Input [25]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_06C34AF4_5684_463F_907D_CDFD03718F51#799455, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#799456, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#799552, COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#799662, COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#799682, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#799454, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#799781, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#799495, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620, COL_610987DD_EB5B_42AE_AB45_B039DACF3912#799809, COL_9FC6ABC3_98A5_4A4F_B6F4_E7EA22349E96#799832, COL_DD5D4F74_6719_435E_ACCF_6D12BBA233D8#799856, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#799882]

(75) CollectLimit
Input [25]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_06C34AF4_5684_463F_907D_CDFD03718F51#799455, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#799456, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#799552, COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#799662, COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#799682, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#799454, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458, COL_610987DD_EB5B_42AE_AB45_B039DACF3912#799809, COL_9FC6ABC3_98A5_4A4F_B6F4_E7EA22349E96#799832, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#799882, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#799781, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#799495, COL_DD5D4F74_6719_435E_ACCF_6D12BBA233D8#799856, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620]
Arguments: 1500

(76) AdaptiveSparkPlan
Output [25]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#798614, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#798615, COL_06C34AF4_5684_463F_907D_CDFD03718F51#799455, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#799456, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#799552, COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#799662, COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#799682, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#799454, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#798616, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#798617, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#799020, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#799073, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#799457, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#799458, COL_610987DD_EB5B_42AE_AB45_B039DACF3912#799809, COL_9FC6ABC3_98A5_4A4F_B6F4_E7EA22349E96#799832, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#799882, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#799781, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#798618, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#799495, COL_DD5D4F74_6719_435E_ACCF_6D12BBA233D8#799856, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#798619, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#798828, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#798860, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#798620]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

Name	Value
spark.sql.optimizer.nestedPredicatePushdown.supportedFileSources	parquet,orc,geoparquet