SP1 - Details for Query 371

Submitted Time: 2026/06/25 16:05:47
Duration: 0.4 s
Succeeded Jobs: 473 474

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

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; subgraph cluster1 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: 113 ms"; 2 [labelType="html" label=" Project "]; 3 [labelType="html" label="Filter number of output rows: 554"]; } 4 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster5 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 132 ms"; 6 [labelType="html" label="Sort sort time: 1 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 7 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 635.5 KiB number of coalesced partitions: 1"]; 8 [labelType="html" label="Exchange shuffle records written: 1,455 local merged chunks fetched: 0 shuffle write time: 3 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,455 local bytes read: 613.7 KiB 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: 1409.7 KiB 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: 613.7 KiB"]; subgraph cluster9 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 31 ms"; 10 [labelType="html" label=" Project "]; 11 [labelType="html" label="ColumnarToRow number of output rows: 1,455 number of input batches: 1"]; } 12 [labelType="html" label="Scan parquet number of files read: 1 scan time: 10 ms metadata time: 0 ms size of files read: 312.5 KiB number of output rows: 1,455"]; 2->0; 3->2; 4->3; 6->4; 7->6; 8->7; 10->8; 11->10; 12->11; }

AdaptiveSparkPlan isFinalPlan=true

Project [COL_BDDD46A4_898A_46D0_BF9B_C8BDFD746148#135321, COL_112BF58B_E911_46A2_8CA3_F6BFD5487579#135322, COL_04CE5AE8_BD39_4552_A33A_7B2C61DB9DD8#135323, COL_CC4AD334_C6F3_41DC_BDFF_CA980FFD3103#135324, COL_E69D8529_33F6_4429_BC58_D9698BF43562#135325, COL_A524D044_4115_4EE1_A8D8_247AAAD9E865#135326, COL_C55F8B0B_76B6_41EB_ADA7_B2FAAEBC9DFD#135327, COL_FBA805A9_48CA_4000_8AA3_998A562DE4E8#135328, COL_F0DBA7B9_11A3_4000_A26C_25F26BA2E9AA#135329, COL_FF182A2D_F1FD_4A7D_9AC0_67C34229FD64#135330, COL_5630B852_23CF_4C16_983F_69061354A034#135331, COL_22BEBE7F_9399_4512_9B79_1F24D9CA5C4D#135332, COL_D6D62F83_1651_43DE_A301_70E2648D65C0#135333, COL_9EF97016_78F9_4ACA_B680_526303781A4D#135334, COL_0B6D2DDD_1396_40A5_BC34_E1607A996FCF#135335, COL_6A763AB2_89BB_4758_BFC3_D9EFE73A1A7F#135336, COL_E54617EF_8ABA_4DA5_BE7A_D1B1DA88B241#135337, COL_08BA1D86_CB77_4294_B113_11DE299A15B0#135338, COL_59FD146E_C36E_4942_997C_23DFD8C14823#135339, COL_B5BDC057_DDE0_46D1_99DC_B1B7B729228E#135340, COL_8771C528_8E8F_4BBD_8130_45C0B95832BC#135341, COL_BD6164EB_302B_48FF_A1C3_F9478E4424D6#135342, COL_9FDC40A3_05F1_4E6E_9E28_D6C6C713E9E4#135343, COL_00FE6DB8_28B4_4067_9010_D825E080B8D4#135344, ... 38 more fields]

Filter (((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BDDD46A4_898A_46D0_BF9B_C8BDFD746148#135321)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BDDD46A4_898A_46D0_BF9B_C8BDFD746148#135321)), MAISON) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_112BF58B_E911_46A2_8CA3_F6BFD5487579#135322)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_112BF58B_E911_46A2_8CA3_F6BFD5487579#135322)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_04CE5AE8_BD39_4552_A33A_7B2C61DB9DD8#135323)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_04CE5AE8_BD39_4552_A33A_7B2C61DB9DD8#135323)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CC4AD334_C6F3_41DC_BDFF_CA980FFD3103#135324)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_CC4AD334_C6F3_41DC_BDFF_CA980FFD3103#135324)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E69D8529_33F6_4429_BC58_D9698BF43562#135325)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_E69D8529_33F6_4429_BC58_D9698BF43562#135325)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A524D044_4115_4EE1_A8D8_247AAAD9E865#135326)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_A524D044_4115_4EE1_A8D8_247AAAD9E865#135326)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C55F8B0B_76B6_41EB_ADA7_B2FAAEBC9DFD#135327)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_C55F8B0B_76B6_41EB_ADA7_B2FAAEBC9DFD#135327)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FBA805A9_48CA_4000_8AA3_998A562DE4E8#135328)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_FBA805A9_48CA_4000_8AA3_998A562DE4E8#135328)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F0DBA7B9_11A3_4000_A26C_25F26BA2E9AA#135329)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_F0DBA7B9_11A3_4000_A26C_25F26BA2E9AA#135329)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FF182A2D_F1FD_4A7D_9AC0_67C34229FD64#135330)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_FF182A2D_F1FD_4A7D_9AC0_67C34229FD64#135330)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5630B852_23CF_4C16_983F_69061354A034#135331)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_5630B852_23CF_4C16_983F_69061354A034#135331)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_22BEBE7F_9399_4512_9B79_1F24D9CA5C4D#135332)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_22BEBE7F_9399_4512_9B79_1F24D9CA5C4D#135332)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D6D62F83_1651_43DE_A301_70E2648D65C0#135333)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D6D62F83_1651_43DE_A301_70E2648D65C0#135333)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9EF97016_78F9_4ACA_B680_526303781A4D#135334)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9EF97016_78F9_4ACA_B680_526303781A4D#135334)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0B6D2DDD_1396_40A5_BC34_E1607A996FCF#135335)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0B6D2DDD_1396_40A5_BC34_E1607A996FCF#135335)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_6A763AB2_89BB_4758_BFC3_D9EFE73A1A7F#135336)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_6A763AB2_89BB_4758_BFC3_D9EFE73A1A7F#135336)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E54617EF_8ABA_4DA5_BE7A_D1B1DA88B241#135337)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_E54617EF_8ABA_4DA5_BE7A_D1B1DA88B241#135337)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_08BA1D86_CB77_4294_B113_11DE299A15B0#135338)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_08BA1D86_CB77_4294_B113_11DE299A15B0#135338)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_59FD146E_C36E_4942_997C_23DFD8C14823#135339)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_59FD146E_C36E_4942_997C_23DFD8C14823#135339)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B5BDC057_DDE0_46D1_99DC_B1B7B729228E#135340)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_B5BDC057_DDE0_46D1_99DC_B1B7B729228E#135340)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8771C528_8E8F_4BBD_8130_45C0B95832BC#135341)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_8771C528_8E8F_4BBD_8130_45C0B95832BC#135341)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BD6164EB_302B_48FF_A1C3_F9478E4424D6#135342)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BD6164EB_302B_48FF_A1C3_F9478E4424D6#135342)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9FDC40A3_05F1_4E6E_9E28_D6C6C713E9E4#135343)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9FDC40A3_05F1_4E6E_9E28_D6C6C713E9E4#135343)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_00FE6DB8_28B4_4067_9010_D825E080B8D4#135344)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_00FE6DB8_28B4_4067_9010_D825E080B8D4#135344)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D74020B3_0DA5_40AC_A47C_11416AC28AF4#135345)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D74020B3_0DA5_40AC_A47C_11416AC28AF4#135345)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D6094745_F373_4BC5_989E_5CF535CFCBB5#135346)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D6094745_F373_4BC5_989E_5CF535CFCBB5#135346)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_89F38B9C_F688_4EF4_BDBE_C91D1F850C38#135347)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_89F38B9C_F688_4EF4_BDBE_C91D1F850C38#135347)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F1B016E2_4B2D_4662_84F7_FDFFEF4DA77D#135348)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_F1B016E2_4B2D_4662_84F7_FDFFEF4DA77D#135348)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_34BD3744_B4A8_4EC7_BFC0_0C5A40F1C327#135349)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_34BD3744_B4A8_4EC7_BFC0_0C5A40F1C327#135349)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BD669204_86B3_4535_A501_BE61CA1FA1E7#135350)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BD669204_86B3_4535_A501_BE61CA1FA1E7#135350)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_762064E2_E380_4F66_8654_4E2A4E6F10EC#135351)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_762064E2_E380_4F66_8654_4E2A4E6F10EC#135351)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D2A1070D_1A38_4AC9_B0C3_AF39D0FE8B98#135352)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D2A1070D_1A38_4AC9_B0C3_AF39D0FE8B98#135352)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_56232655_74C2_472C_BE05_4C82BD2AD03F#135353)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_56232655_74C2_472C_BE05_4C82BD2AD03F#135353)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B2D747F9_A7DA_431E_8137_303431EF82C0#135354)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_B2D747F9_A7DA_431E_8137_303431EF82C0#135354)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_7F4EA0F4_47F8_472E_B602_EF9B6F33DCF1#135355)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_7F4EA0F4_47F8_472E_B602_EF9B6F33DCF1#135355)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CE24648B_5C53_473A_86BA_1B425D6D4B60#135356)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_CE24648B_5C53_473A_86BA_1B425D6D4B60#135356)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_46D16570_A31B_40CE_8FAE_2908C4E4431A#135357)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_46D16570_A31B_40CE_8FAE_2908C4E4431A#135357)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_4E1FD930_1CDF_430C_994E_8E65963C7F7D#135358)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_4E1FD930_1CDF_430C_994E_8E65963C7F7D#135358)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_450A716A_1E80_4B2E_BF35_B0BD3DE78D2A#135370)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_450A716A_1E80_4B2E_BF35_B0BD3DE78D2A#135370)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A3644F3E_0D2F_4A06_A6FE_1A4FD7E3FB39#135371)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_A3644F3E_0D2F_4A06_A6FE_1A4FD7E3FB39#135371)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A2BECAE4_1350_4597_8721_6D25DB616635#135372)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_A2BECAE4_1350_4597_8721_6D25DB616635#135372)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CD29F452_4E41_4A81_99C0_3A9914B3299D#135373)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_CD29F452_4E41_4A81_99C0_3A9914B3299D#135373)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_3FC0C414_AA21_4D9D_9AEA_27F86B234A86#135374)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_3FC0C414_AA21_4D9D_9AEA_27F86B234A86#135374)), MAISON) END)

WholeStageCodegen (3)

Window [sum(COL_B1616C39_761D_4EC9_A694_7CDDA1510A6C#135369) windowspecdefinition(COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_D966E020_40A5_4B41_B24F_4232E020D829#135490, avg(COL_B1616C39_761D_4EC9_A694_7CDDA1510A6C#135369) windowspecdefinition(COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_875AF143_68C5_428B_9C50_50F9977CE713#135664, avg(COL_14928EC1_3619_418E_A05E_FAA96E7AFD98#135360) windowspecdefinition(COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_1B6D0FE5_8D59_4DA4_BDA0_97D87621A96C#135841, avg(COL_807020CE_20A5_41C4_AE2B_10B99D472FA2#135364) windowspecdefinition(COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_F6C8888C_051F_4CA6_9982_DCCA73EC4144#136021, sum(COL_61B8AC70_1B93_419C_A3E2_102A864B3280#135375) windowspecdefinition(COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_C4B3810B_E130_4598_B8BD_A0CBB7213550#136204, count(1) windowspecdefinition(COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_59FA6040_6707_4B54_9108_CEDCF1D097AC#136391L, row_number() windowspecdefinition(COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_BB374D42_5C0B_4A05_AFD1_5C9C423D0535#136580], [COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368], [1 DESC NULLS LAST]

Sort [COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

WholeStageCodegen (2)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368, 10), ENSURE_REQUIREMENTS, [plan_id=19431]

Project [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#134881 AS COL_BDDD46A4_898A_46D0_BF9B_C8BDFD746148#135321, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#134882 AS COL_112BF58B_E911_46A2_8CA3_F6BFD5487579#135322, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#134883 AS COL_04CE5AE8_BD39_4552_A33A_7B2C61DB9DD8#135323, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#134884 AS COL_CC4AD334_C6F3_41DC_BDFF_CA980FFD3103#135324, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#134885 AS COL_E69D8529_33F6_4429_BC58_D9698BF43562#135325, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#134886 AS COL_A524D044_4115_4EE1_A8D8_247AAAD9E865#135326, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#134887 AS COL_C55F8B0B_76B6_41EB_ADA7_B2FAAEBC9DFD#135327, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#134888 AS COL_FBA805A9_48CA_4000_8AA3_998A562DE4E8#135328, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#134889 AS COL_F0DBA7B9_11A3_4000_A26C_25F26BA2E9AA#135329, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#134890 AS COL_FF182A2D_F1FD_4A7D_9AC0_67C34229FD64#135330, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#134891 AS COL_5630B852_23CF_4C16_983F_69061354A034#135331, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#134892 AS COL_22BEBE7F_9399_4512_9B79_1F24D9CA5C4D#135332, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#134893 AS COL_D6D62F83_1651_43DE_A301_70E2648D65C0#135333, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#134894 AS COL_9EF97016_78F9_4ACA_B680_526303781A4D#135334, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#134895 AS COL_0B6D2DDD_1396_40A5_BC34_E1607A996FCF#135335, COL_98B2878A_418E_4331_B333_2493994BB807#134896 AS COL_6A763AB2_89BB_4758_BFC3_D9EFE73A1A7F#135336, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#134897 AS COL_E54617EF_8ABA_4DA5_BE7A_D1B1DA88B241#135337, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#134898 AS COL_08BA1D86_CB77_4294_B113_11DE299A15B0#135338, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#134899 AS COL_59FD146E_C36E_4942_997C_23DFD8C14823#135339, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#134900 AS COL_B5BDC057_DDE0_46D1_99DC_B1B7B729228E#135340, COL_E722B691_2CA2_4160_A578_D9CD4920A842#134901 AS COL_8771C528_8E8F_4BBD_8130_45C0B95832BC#135341, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#134902 AS COL_BD6164EB_302B_48FF_A1C3_F9478E4424D6#135342, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#134903 AS COL_9FDC40A3_05F1_4E6E_9E28_D6C6C713E9E4#135343, COL_D897344F_9AC3_429E_A95D_88390F445758#134904 AS COL_00FE6DB8_28B4_4067_9010_D825E080B8D4#135344, ... 31 more fields]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#134881,COL_956F91E2_2027_457F_A229_B9CF20D9FF63#134882,COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#134883,COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#134884,COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#134885,COL_FB65F162_1AB6_4971_99DA_F8A943944A66#134886,COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#134887,COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#134888,COL_573E3A58_7401_4F3F_9EFA_058729D28B72#134889,COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#134890,COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#134891,COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#134892,COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#134893,COL_C42F735E_237B_4569_996D_76FF5A4A65DF#134894,COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#134895,COL_98B2878A_418E_4331_B333_2493994BB807#134896,COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#134897,COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#134898,COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#134899,COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#134900,COL_E722B691_2CA2_4160_A578_D9CD4920A842#134901,COL_D600764E_8D81_4891_BF21_ACC3F0938E57#134902,COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#134903,COL_D897344F_9AC3_429E_A95D_88390F445758#134904,... 31 more fields] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/MATCHING_ANALYS_405366], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399:string,COL_956F91E2_2027_457F_A229_B9CF20D9FF63:s...

Details

== Physical Plan ==
AdaptiveSparkPlan (18)
+- == Final Plan ==
   * Project (10)
   +- * Filter (9)
      +- Window (8)
         +- * Sort (7)
            +- AQEShuffleRead (6)
               +- ShuffleQueryStage (5), Statistics(sizeInBytes=1409.7 KiB, rowCount=1.46E+3)
                  +- Exchange (4)
                     +- * Project (3)
                        +- * ColumnarToRow (2)
                           +- Scan parquet  (1)
+- == Initial Plan ==
   CollectLimit (17)
   +- Project (16)
      +- Filter (15)
         +- Window (14)
            +- Sort (13)
               +- Exchange (12)
                  +- Project (11)
                     +- Scan parquet  (1)


(1) Scan parquet 
Output [55]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#134881, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#134882, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#134883, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#134884, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#134885, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#134886, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#134887, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#134888, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#134889, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#134890, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#134891, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#134892, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#134893, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#134894, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#134895, COL_98B2878A_418E_4331_B333_2493994BB807#134896, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#134897, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#134898, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#134899, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#134900, COL_E722B691_2CA2_4160_A578_D9CD4920A842#134901, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#134902, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#134903, COL_D897344F_9AC3_429E_A95D_88390F445758#134904, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#134905, COL_52167438_70F6_4E26_B5CD_17C5990F8948#134906, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#134907, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#134908, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#134909, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#134910, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#134911, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#134912, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#134913, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#134914, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#134915, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#134916, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#134917, COL_1FF33786_C88A_4789_B428_364FF98B1905#134918, COL_35375170_B542_49DE_AFA2_0A2D31967891#134919L, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#134920, COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#134921, COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#134922, COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#134923, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#134924, COL_0D8E2436_E961_45FA_A7F3_A7C5D2ED89CF#134925, COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD#134926, COL_566EB258_CFF9_4285_BB8C_DBD46A1BE5B9#134927, COL_23424D2C_0B0A_403F_9061_1D8B148D6A67#134928, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#134929, COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#134930, COL_8068E186_2734_4730_8D2C_A788B2226179#134931, COL_DA667933_29E5_49E1_8724_A537DCE9735F#134932, COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#134933, COL_C5B37418_B2B7_49D0_8C7C_3E0D61B4DAD7#134934, COL_A6B4C7B1_4D23_4C04_AACE_CCD82E9AC458#134935]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/MATCHING_ANALYS_405366]
ReadSchema: struct<COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399:string,COL_956F91E2_2027_457F_A229_B9CF20D9FF63:string,COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3:string,COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3:string,COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C:string,COL_FB65F162_1AB6_4971_99DA_F8A943944A66:string,COL_04BFCB87_D14B_4364_A366_6B179BF9CD20:string,COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C:string,COL_573E3A58_7401_4F3F_9EFA_058729D28B72:string,COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF:string,COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159:string,COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9:string,COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084:string,COL_C42F735E_237B_4569_996D_76FF5A4A65DF:string,COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214:string,COL_98B2878A_418E_4331_B333_2493994BB807:string,COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C:string,COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF:string,COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE:string,COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63:string,COL_E722B691_2CA2_4160_A578_D9CD4920A842:string,COL_D600764E_8D81_4891_BF21_ACC3F0938E57:string,COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5:string,COL_D897344F_9AC3_429E_A95D_88390F445758:string,COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9:string,COL_52167438_70F6_4E26_B5CD_17C5990F8948:string,COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17:string,COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3:string,COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539:string,COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9:string,COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6:string,COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9:string,COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49:string,COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7:string,COL_D0A8A26A_A602_4462_BBB1_8286F0724054:string,COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30:string,COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3:string,COL_1FF33786_C88A_4789_B428_364FF98B1905:string,COL_35375170_B542_49DE_AFA2_0A2D31967891:bigint,COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF:double,COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9:double,COL_C0CA120C_6738_4CF5_B569_FD209A7B518A:double,COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3:double,COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE:double,COL_0D8E2436_E961_45FA_A7F3_A7C5D2ED89CF:double,COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD:double,COL_566EB258_CFF9_4285_BB8C_DBD46A1BE5B9:double,COL_23424D2C_0B0A_403F_9061_1D8B148D6A67:double,COL_5CDC74F0_3D28_463C_9042_237BDAB52540:string,COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028:double,COL_8068E186_2734_4730_8D2C_A788B2226179:string,COL_DA667933_29E5_49E1_8724_A537DCE9735F:string,COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4:string,COL_C5B37418_B2B7_49D0_8C7C_3E0D61B4DAD7:string,COL_A6B4C7B1_4D23_4C04_AACE_CCD82E9AC458:string>

(2) ColumnarToRow [codegen id : 1]
Input [55]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#134881, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#134882, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#134883, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#134884, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#134885, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#134886, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#134887, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#134888, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#134889, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#134890, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#134891, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#134892, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#134893, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#134894, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#134895, COL_98B2878A_418E_4331_B333_2493994BB807#134896, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#134897, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#134898, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#134899, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#134900, COL_E722B691_2CA2_4160_A578_D9CD4920A842#134901, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#134902, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#134903, COL_D897344F_9AC3_429E_A95D_88390F445758#134904, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#134905, COL_52167438_70F6_4E26_B5CD_17C5990F8948#134906, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#134907, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#134908, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#134909, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#134910, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#134911, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#134912, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#134913, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#134914, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#134915, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#134916, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#134917, COL_1FF33786_C88A_4789_B428_364FF98B1905#134918, COL_35375170_B542_49DE_AFA2_0A2D31967891#134919L, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#134920, COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#134921, COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#134922, COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#134923, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#134924, COL_0D8E2436_E961_45FA_A7F3_A7C5D2ED89CF#134925, COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD#134926, COL_566EB258_CFF9_4285_BB8C_DBD46A1BE5B9#134927, COL_23424D2C_0B0A_403F_9061_1D8B148D6A67#134928, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#134929, COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#134930, COL_8068E186_2734_4730_8D2C_A788B2226179#134931, COL_DA667933_29E5_49E1_8724_A537DCE9735F#134932, COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#134933, COL_C5B37418_B2B7_49D0_8C7C_3E0D61B4DAD7#134934, COL_A6B4C7B1_4D23_4C04_AACE_CCD82E9AC458#134935]

(3) Project [codegen id : 1]
Output [55]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#134881 AS COL_BDDD46A4_898A_46D0_BF9B_C8BDFD746148#135321, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#134882 AS COL_112BF58B_E911_46A2_8CA3_F6BFD5487579#135322, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#134883 AS COL_04CE5AE8_BD39_4552_A33A_7B2C61DB9DD8#135323, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#134884 AS COL_CC4AD334_C6F3_41DC_BDFF_CA980FFD3103#135324, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#134885 AS COL_E69D8529_33F6_4429_BC58_D9698BF43562#135325, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#134886 AS COL_A524D044_4115_4EE1_A8D8_247AAAD9E865#135326, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#134887 AS COL_C55F8B0B_76B6_41EB_ADA7_B2FAAEBC9DFD#135327, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#134888 AS COL_FBA805A9_48CA_4000_8AA3_998A562DE4E8#135328, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#134889 AS COL_F0DBA7B9_11A3_4000_A26C_25F26BA2E9AA#135329, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#134890 AS COL_FF182A2D_F1FD_4A7D_9AC0_67C34229FD64#135330, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#134891 AS COL_5630B852_23CF_4C16_983F_69061354A034#135331, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#134892 AS COL_22BEBE7F_9399_4512_9B79_1F24D9CA5C4D#135332, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#134893 AS COL_D6D62F83_1651_43DE_A301_70E2648D65C0#135333, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#134894 AS COL_9EF97016_78F9_4ACA_B680_526303781A4D#135334, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#134895 AS COL_0B6D2DDD_1396_40A5_BC34_E1607A996FCF#135335, COL_98B2878A_418E_4331_B333_2493994BB807#134896 AS COL_6A763AB2_89BB_4758_BFC3_D9EFE73A1A7F#135336, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#134897 AS COL_E54617EF_8ABA_4DA5_BE7A_D1B1DA88B241#135337, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#134898 AS COL_08BA1D86_CB77_4294_B113_11DE299A15B0#135338, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#134899 AS COL_59FD146E_C36E_4942_997C_23DFD8C14823#135339, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#134900 AS COL_B5BDC057_DDE0_46D1_99DC_B1B7B729228E#135340, COL_E722B691_2CA2_4160_A578_D9CD4920A842#134901 AS COL_8771C528_8E8F_4BBD_8130_45C0B95832BC#135341, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#134902 AS COL_BD6164EB_302B_48FF_A1C3_F9478E4424D6#135342, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#134903 AS COL_9FDC40A3_05F1_4E6E_9E28_D6C6C713E9E4#135343, COL_D897344F_9AC3_429E_A95D_88390F445758#134904 AS COL_00FE6DB8_28B4_4067_9010_D825E080B8D4#135344, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#134905 AS COL_D74020B3_0DA5_40AC_A47C_11416AC28AF4#135345, COL_52167438_70F6_4E26_B5CD_17C5990F8948#134906 AS COL_D6094745_F373_4BC5_989E_5CF535CFCBB5#135346, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#134907 AS COL_89F38B9C_F688_4EF4_BDBE_C91D1F850C38#135347, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#134908 AS COL_F1B016E2_4B2D_4662_84F7_FDFFEF4DA77D#135348, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#134909 AS COL_34BD3744_B4A8_4EC7_BFC0_0C5A40F1C327#135349, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#134910 AS COL_BD669204_86B3_4535_A501_BE61CA1FA1E7#135350, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#134911 AS COL_762064E2_E380_4F66_8654_4E2A4E6F10EC#135351, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#134912 AS COL_D2A1070D_1A38_4AC9_B0C3_AF39D0FE8B98#135352, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#134913 AS COL_56232655_74C2_472C_BE05_4C82BD2AD03F#135353, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#134914 AS COL_B2D747F9_A7DA_431E_8137_303431EF82C0#135354, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#134915 AS COL_7F4EA0F4_47F8_472E_B602_EF9B6F33DCF1#135355, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#134916 AS COL_CE24648B_5C53_473A_86BA_1B425D6D4B60#135356, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#134917 AS COL_46D16570_A31B_40CE_8FAE_2908C4E4431A#135357, COL_1FF33786_C88A_4789_B428_364FF98B1905#134918 AS COL_4E1FD930_1CDF_430C_994E_8E65963C7F7D#135358, COL_35375170_B542_49DE_AFA2_0A2D31967891#134919L AS COL_F69ABF00_2F53_43DD_9C29_8913549D724E#135359L, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#134920 AS COL_14928EC1_3619_418E_A05E_FAA96E7AFD98#135360, COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#134921 AS COL_485383C3_A25B_4F35_A5C0_8D577B11C7B2#135361, COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#134922 AS COL_BC40A0F2_B6A4_4987_B401_A0611EBA19FF#135362, COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#134923 AS COL_9F8EB11D_CC94_41D1_BC9B_75A2B62F1ED0#135363, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#134924 AS COL_807020CE_20A5_41C4_AE2B_10B99D472FA2#135364, COL_0D8E2436_E961_45FA_A7F3_A7C5D2ED89CF#134925 AS COL_23B332B1_5432_4C70_A9F0_E9F65D9F5480#135365, COL_566EB258_CFF9_4285_BB8C_DBD46A1BE5B9#134927 AS COL_ECF7F350_45ED_4F11_9C26_DF0672965A4D#135366, COL_23424D2C_0B0A_403F_9061_1D8B148D6A67#134928 AS COL_68C11010_06FC_40D9_A241_778AA8AE588D#135367, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#134929 AS COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368, COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#134930 AS COL_B1616C39_761D_4EC9_A694_7CDDA1510A6C#135369, COL_8068E186_2734_4730_8D2C_A788B2226179#134931 AS COL_450A716A_1E80_4B2E_BF35_B0BD3DE78D2A#135370, COL_DA667933_29E5_49E1_8724_A537DCE9735F#134932 AS COL_A3644F3E_0D2F_4A06_A6FE_1A4FD7E3FB39#135371, COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#134933 AS COL_A2BECAE4_1350_4597_8721_6D25DB616635#135372, COL_C5B37418_B2B7_49D0_8C7C_3E0D61B4DAD7#134934 AS COL_CD29F452_4E41_4A81_99C0_3A9914B3299D#135373, COL_A6B4C7B1_4D23_4C04_AACE_CCD82E9AC458#134935 AS COL_3FC0C414_AA21_4D9D_9AEA_27F86B234A86#135374, COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD#134926 AS COL_61B8AC70_1B93_419C_A3E2_102A864B3280#135375]
Input [55]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#134881, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#134882, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#134883, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#134884, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#134885, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#134886, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#134887, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#134888, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#134889, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#134890, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#134891, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#134892, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#134893, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#134894, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#134895, COL_98B2878A_418E_4331_B333_2493994BB807#134896, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#134897, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#134898, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#134899, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#134900, COL_E722B691_2CA2_4160_A578_D9CD4920A842#134901, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#134902, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#134903, COL_D897344F_9AC3_429E_A95D_88390F445758#134904, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#134905, COL_52167438_70F6_4E26_B5CD_17C5990F8948#134906, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#134907, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#134908, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#134909, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#134910, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#134911, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#134912, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#134913, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#134914, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#134915, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#134916, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#134917, COL_1FF33786_C88A_4789_B428_364FF98B1905#134918, COL_35375170_B542_49DE_AFA2_0A2D31967891#134919L, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#134920, COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#134921, COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#134922, COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#134923, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#134924, COL_0D8E2436_E961_45FA_A7F3_A7C5D2ED89CF#134925, COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD#134926, COL_566EB258_CFF9_4285_BB8C_DBD46A1BE5B9#134927, COL_23424D2C_0B0A_403F_9061_1D8B148D6A67#134928, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#134929, COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#134930, COL_8068E186_2734_4730_8D2C_A788B2226179#134931, COL_DA667933_29E5_49E1_8724_A537DCE9735F#134932, COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#134933, COL_C5B37418_B2B7_49D0_8C7C_3E0D61B4DAD7#134934, COL_A6B4C7B1_4D23_4C04_AACE_CCD82E9AC458#134935]

(4) Exchange
Input [55]: [COL_BDDD46A4_898A_46D0_BF9B_C8BDFD746148#135321, COL_112BF58B_E911_46A2_8CA3_F6BFD5487579#135322, COL_04CE5AE8_BD39_4552_A33A_7B2C61DB9DD8#135323, COL_CC4AD334_C6F3_41DC_BDFF_CA980FFD3103#135324, COL_E69D8529_33F6_4429_BC58_D9698BF43562#135325, COL_A524D044_4115_4EE1_A8D8_247AAAD9E865#135326, COL_C55F8B0B_76B6_41EB_ADA7_B2FAAEBC9DFD#135327, COL_FBA805A9_48CA_4000_8AA3_998A562DE4E8#135328, COL_F0DBA7B9_11A3_4000_A26C_25F26BA2E9AA#135329, COL_FF182A2D_F1FD_4A7D_9AC0_67C34229FD64#135330, COL_5630B852_23CF_4C16_983F_69061354A034#135331, COL_22BEBE7F_9399_4512_9B79_1F24D9CA5C4D#135332, COL_D6D62F83_1651_43DE_A301_70E2648D65C0#135333, COL_9EF97016_78F9_4ACA_B680_526303781A4D#135334, COL_0B6D2DDD_1396_40A5_BC34_E1607A996FCF#135335, COL_6A763AB2_89BB_4758_BFC3_D9EFE73A1A7F#135336, COL_E54617EF_8ABA_4DA5_BE7A_D1B1DA88B241#135337, COL_08BA1D86_CB77_4294_B113_11DE299A15B0#135338, COL_59FD146E_C36E_4942_997C_23DFD8C14823#135339, COL_B5BDC057_DDE0_46D1_99DC_B1B7B729228E#135340, COL_8771C528_8E8F_4BBD_8130_45C0B95832BC#135341, COL_BD6164EB_302B_48FF_A1C3_F9478E4424D6#135342, COL_9FDC40A3_05F1_4E6E_9E28_D6C6C713E9E4#135343, COL_00FE6DB8_28B4_4067_9010_D825E080B8D4#135344, COL_D74020B3_0DA5_40AC_A47C_11416AC28AF4#135345, COL_D6094745_F373_4BC5_989E_5CF535CFCBB5#135346, COL_89F38B9C_F688_4EF4_BDBE_C91D1F850C38#135347, COL_F1B016E2_4B2D_4662_84F7_FDFFEF4DA77D#135348, COL_34BD3744_B4A8_4EC7_BFC0_0C5A40F1C327#135349, COL_BD669204_86B3_4535_A501_BE61CA1FA1E7#135350, COL_762064E2_E380_4F66_8654_4E2A4E6F10EC#135351, COL_D2A1070D_1A38_4AC9_B0C3_AF39D0FE8B98#135352, COL_56232655_74C2_472C_BE05_4C82BD2AD03F#135353, COL_B2D747F9_A7DA_431E_8137_303431EF82C0#135354, COL_7F4EA0F4_47F8_472E_B602_EF9B6F33DCF1#135355, COL_CE24648B_5C53_473A_86BA_1B425D6D4B60#135356, COL_46D16570_A31B_40CE_8FAE_2908C4E4431A#135357, COL_4E1FD930_1CDF_430C_994E_8E65963C7F7D#135358, COL_F69ABF00_2F53_43DD_9C29_8913549D724E#135359L, COL_14928EC1_3619_418E_A05E_FAA96E7AFD98#135360, COL_485383C3_A25B_4F35_A5C0_8D577B11C7B2#135361, COL_BC40A0F2_B6A4_4987_B401_A0611EBA19FF#135362, COL_9F8EB11D_CC94_41D1_BC9B_75A2B62F1ED0#135363, COL_807020CE_20A5_41C4_AE2B_10B99D472FA2#135364, COL_23B332B1_5432_4C70_A9F0_E9F65D9F5480#135365, COL_ECF7F350_45ED_4F11_9C26_DF0672965A4D#135366, COL_68C11010_06FC_40D9_A241_778AA8AE588D#135367, COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368, COL_B1616C39_761D_4EC9_A694_7CDDA1510A6C#135369, COL_450A716A_1E80_4B2E_BF35_B0BD3DE78D2A#135370, COL_A3644F3E_0D2F_4A06_A6FE_1A4FD7E3FB39#135371, COL_A2BECAE4_1350_4597_8721_6D25DB616635#135372, COL_CD29F452_4E41_4A81_99C0_3A9914B3299D#135373, COL_3FC0C414_AA21_4D9D_9AEA_27F86B234A86#135374, COL_61B8AC70_1B93_419C_A3E2_102A864B3280#135375]
Arguments: hashpartitioning(COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368, 10), ENSURE_REQUIREMENTS, [plan_id=19431]

(5) ShuffleQueryStage
Output [55]: [COL_BDDD46A4_898A_46D0_BF9B_C8BDFD746148#135321, COL_112BF58B_E911_46A2_8CA3_F6BFD5487579#135322, COL_04CE5AE8_BD39_4552_A33A_7B2C61DB9DD8#135323, COL_CC4AD334_C6F3_41DC_BDFF_CA980FFD3103#135324, COL_E69D8529_33F6_4429_BC58_D9698BF43562#135325, COL_A524D044_4115_4EE1_A8D8_247AAAD9E865#135326, COL_C55F8B0B_76B6_41EB_ADA7_B2FAAEBC9DFD#135327, COL_FBA805A9_48CA_4000_8AA3_998A562DE4E8#135328, COL_F0DBA7B9_11A3_4000_A26C_25F26BA2E9AA#135329, COL_FF182A2D_F1FD_4A7D_9AC0_67C34229FD64#135330, COL_5630B852_23CF_4C16_983F_69061354A034#135331, COL_22BEBE7F_9399_4512_9B79_1F24D9CA5C4D#135332, COL_D6D62F83_1651_43DE_A301_70E2648D65C0#135333, COL_9EF97016_78F9_4ACA_B680_526303781A4D#135334, COL_0B6D2DDD_1396_40A5_BC34_E1607A996FCF#135335, COL_6A763AB2_89BB_4758_BFC3_D9EFE73A1A7F#135336, COL_E54617EF_8ABA_4DA5_BE7A_D1B1DA88B241#135337, COL_08BA1D86_CB77_4294_B113_11DE299A15B0#135338, COL_59FD146E_C36E_4942_997C_23DFD8C14823#135339, COL_B5BDC057_DDE0_46D1_99DC_B1B7B729228E#135340, COL_8771C528_8E8F_4BBD_8130_45C0B95832BC#135341, COL_BD6164EB_302B_48FF_A1C3_F9478E4424D6#135342, COL_9FDC40A3_05F1_4E6E_9E28_D6C6C713E9E4#135343, COL_00FE6DB8_28B4_4067_9010_D825E080B8D4#135344, COL_D74020B3_0DA5_40AC_A47C_11416AC28AF4#135345, COL_D6094745_F373_4BC5_989E_5CF535CFCBB5#135346, COL_89F38B9C_F688_4EF4_BDBE_C91D1F850C38#135347, COL_F1B016E2_4B2D_4662_84F7_FDFFEF4DA77D#135348, COL_34BD3744_B4A8_4EC7_BFC0_0C5A40F1C327#135349, COL_BD669204_86B3_4535_A501_BE61CA1FA1E7#135350, COL_762064E2_E380_4F66_8654_4E2A4E6F10EC#135351, COL_D2A1070D_1A38_4AC9_B0C3_AF39D0FE8B98#135352, COL_56232655_74C2_472C_BE05_4C82BD2AD03F#135353, COL_B2D747F9_A7DA_431E_8137_303431EF82C0#135354, COL_7F4EA0F4_47F8_472E_B602_EF9B6F33DCF1#135355, COL_CE24648B_5C53_473A_86BA_1B425D6D4B60#135356, COL_46D16570_A31B_40CE_8FAE_2908C4E4431A#135357, COL_4E1FD930_1CDF_430C_994E_8E65963C7F7D#135358, COL_F69ABF00_2F53_43DD_9C29_8913549D724E#135359L, COL_14928EC1_3619_418E_A05E_FAA96E7AFD98#135360, COL_485383C3_A25B_4F35_A5C0_8D577B11C7B2#135361, COL_BC40A0F2_B6A4_4987_B401_A0611EBA19FF#135362, COL_9F8EB11D_CC94_41D1_BC9B_75A2B62F1ED0#135363, COL_807020CE_20A5_41C4_AE2B_10B99D472FA2#135364, COL_23B332B1_5432_4C70_A9F0_E9F65D9F5480#135365, COL_ECF7F350_45ED_4F11_9C26_DF0672965A4D#135366, COL_68C11010_06FC_40D9_A241_778AA8AE588D#135367, COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368, COL_B1616C39_761D_4EC9_A694_7CDDA1510A6C#135369, COL_450A716A_1E80_4B2E_BF35_B0BD3DE78D2A#135370, COL_A3644F3E_0D2F_4A06_A6FE_1A4FD7E3FB39#135371, COL_A2BECAE4_1350_4597_8721_6D25DB616635#135372, COL_CD29F452_4E41_4A81_99C0_3A9914B3299D#135373, COL_3FC0C414_AA21_4D9D_9AEA_27F86B234A86#135374, COL_61B8AC70_1B93_419C_A3E2_102A864B3280#135375]
Arguments: 0

(6) AQEShuffleRead
Input [55]: [COL_BDDD46A4_898A_46D0_BF9B_C8BDFD746148#135321, COL_112BF58B_E911_46A2_8CA3_F6BFD5487579#135322, COL_04CE5AE8_BD39_4552_A33A_7B2C61DB9DD8#135323, COL_CC4AD334_C6F3_41DC_BDFF_CA980FFD3103#135324, COL_E69D8529_33F6_4429_BC58_D9698BF43562#135325, COL_A524D044_4115_4EE1_A8D8_247AAAD9E865#135326, COL_C55F8B0B_76B6_41EB_ADA7_B2FAAEBC9DFD#135327, COL_FBA805A9_48CA_4000_8AA3_998A562DE4E8#135328, COL_F0DBA7B9_11A3_4000_A26C_25F26BA2E9AA#135329, COL_FF182A2D_F1FD_4A7D_9AC0_67C34229FD64#135330, COL_5630B852_23CF_4C16_983F_69061354A034#135331, COL_22BEBE7F_9399_4512_9B79_1F24D9CA5C4D#135332, COL_D6D62F83_1651_43DE_A301_70E2648D65C0#135333, COL_9EF97016_78F9_4ACA_B680_526303781A4D#135334, COL_0B6D2DDD_1396_40A5_BC34_E1607A996FCF#135335, COL_6A763AB2_89BB_4758_BFC3_D9EFE73A1A7F#135336, COL_E54617EF_8ABA_4DA5_BE7A_D1B1DA88B241#135337, COL_08BA1D86_CB77_4294_B113_11DE299A15B0#135338, COL_59FD146E_C36E_4942_997C_23DFD8C14823#135339, COL_B5BDC057_DDE0_46D1_99DC_B1B7B729228E#135340, COL_8771C528_8E8F_4BBD_8130_45C0B95832BC#135341, COL_BD6164EB_302B_48FF_A1C3_F9478E4424D6#135342, COL_9FDC40A3_05F1_4E6E_9E28_D6C6C713E9E4#135343, COL_00FE6DB8_28B4_4067_9010_D825E080B8D4#135344, COL_D74020B3_0DA5_40AC_A47C_11416AC28AF4#135345, COL_D6094745_F373_4BC5_989E_5CF535CFCBB5#135346, COL_89F38B9C_F688_4EF4_BDBE_C91D1F850C38#135347, COL_F1B016E2_4B2D_4662_84F7_FDFFEF4DA77D#135348, COL_34BD3744_B4A8_4EC7_BFC0_0C5A40F1C327#135349, COL_BD669204_86B3_4535_A501_BE61CA1FA1E7#135350, COL_762064E2_E380_4F66_8654_4E2A4E6F10EC#135351, COL_D2A1070D_1A38_4AC9_B0C3_AF39D0FE8B98#135352, COL_56232655_74C2_472C_BE05_4C82BD2AD03F#135353, COL_B2D747F9_A7DA_431E_8137_303431EF82C0#135354, COL_7F4EA0F4_47F8_472E_B602_EF9B6F33DCF1#135355, COL_CE24648B_5C53_473A_86BA_1B425D6D4B60#135356, COL_46D16570_A31B_40CE_8FAE_2908C4E4431A#135357, COL_4E1FD930_1CDF_430C_994E_8E65963C7F7D#135358, COL_F69ABF00_2F53_43DD_9C29_8913549D724E#135359L, COL_14928EC1_3619_418E_A05E_FAA96E7AFD98#135360, COL_485383C3_A25B_4F35_A5C0_8D577B11C7B2#135361, COL_BC40A0F2_B6A4_4987_B401_A0611EBA19FF#135362, COL_9F8EB11D_CC94_41D1_BC9B_75A2B62F1ED0#135363, COL_807020CE_20A5_41C4_AE2B_10B99D472FA2#135364, COL_23B332B1_5432_4C70_A9F0_E9F65D9F5480#135365, COL_ECF7F350_45ED_4F11_9C26_DF0672965A4D#135366, COL_68C11010_06FC_40D9_A241_778AA8AE588D#135367, COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368, COL_B1616C39_761D_4EC9_A694_7CDDA1510A6C#135369, COL_450A716A_1E80_4B2E_BF35_B0BD3DE78D2A#135370, COL_A3644F3E_0D2F_4A06_A6FE_1A4FD7E3FB39#135371, COL_A2BECAE4_1350_4597_8721_6D25DB616635#135372, COL_CD29F452_4E41_4A81_99C0_3A9914B3299D#135373, COL_3FC0C414_AA21_4D9D_9AEA_27F86B234A86#135374, COL_61B8AC70_1B93_419C_A3E2_102A864B3280#135375]
Arguments: coalesced

(7) Sort [codegen id : 2]
Input [55]: [COL_BDDD46A4_898A_46D0_BF9B_C8BDFD746148#135321, COL_112BF58B_E911_46A2_8CA3_F6BFD5487579#135322, COL_04CE5AE8_BD39_4552_A33A_7B2C61DB9DD8#135323, COL_CC4AD334_C6F3_41DC_BDFF_CA980FFD3103#135324, COL_E69D8529_33F6_4429_BC58_D9698BF43562#135325, COL_A524D044_4115_4EE1_A8D8_247AAAD9E865#135326, COL_C55F8B0B_76B6_41EB_ADA7_B2FAAEBC9DFD#135327, COL_FBA805A9_48CA_4000_8AA3_998A562DE4E8#135328, COL_F0DBA7B9_11A3_4000_A26C_25F26BA2E9AA#135329, COL_FF182A2D_F1FD_4A7D_9AC0_67C34229FD64#135330, COL_5630B852_23CF_4C16_983F_69061354A034#135331, COL_22BEBE7F_9399_4512_9B79_1F24D9CA5C4D#135332, COL_D6D62F83_1651_43DE_A301_70E2648D65C0#135333, COL_9EF97016_78F9_4ACA_B680_526303781A4D#135334, COL_0B6D2DDD_1396_40A5_BC34_E1607A996FCF#135335, COL_6A763AB2_89BB_4758_BFC3_D9EFE73A1A7F#135336, COL_E54617EF_8ABA_4DA5_BE7A_D1B1DA88B241#135337, COL_08BA1D86_CB77_4294_B113_11DE299A15B0#135338, COL_59FD146E_C36E_4942_997C_23DFD8C14823#135339, COL_B5BDC057_DDE0_46D1_99DC_B1B7B729228E#135340, COL_8771C528_8E8F_4BBD_8130_45C0B95832BC#135341, COL_BD6164EB_302B_48FF_A1C3_F9478E4424D6#135342, COL_9FDC40A3_05F1_4E6E_9E28_D6C6C713E9E4#135343, COL_00FE6DB8_28B4_4067_9010_D825E080B8D4#135344, COL_D74020B3_0DA5_40AC_A47C_11416AC28AF4#135345, COL_D6094745_F373_4BC5_989E_5CF535CFCBB5#135346, COL_89F38B9C_F688_4EF4_BDBE_C91D1F850C38#135347, COL_F1B016E2_4B2D_4662_84F7_FDFFEF4DA77D#135348, COL_34BD3744_B4A8_4EC7_BFC0_0C5A40F1C327#135349, COL_BD669204_86B3_4535_A501_BE61CA1FA1E7#135350, COL_762064E2_E380_4F66_8654_4E2A4E6F10EC#135351, COL_D2A1070D_1A38_4AC9_B0C3_AF39D0FE8B98#135352, COL_56232655_74C2_472C_BE05_4C82BD2AD03F#135353, COL_B2D747F9_A7DA_431E_8137_303431EF82C0#135354, COL_7F4EA0F4_47F8_472E_B602_EF9B6F33DCF1#135355, COL_CE24648B_5C53_473A_86BA_1B425D6D4B60#135356, COL_46D16570_A31B_40CE_8FAE_2908C4E4431A#135357, COL_4E1FD930_1CDF_430C_994E_8E65963C7F7D#135358, COL_F69ABF00_2F53_43DD_9C29_8913549D724E#135359L, COL_14928EC1_3619_418E_A05E_FAA96E7AFD98#135360, COL_485383C3_A25B_4F35_A5C0_8D577B11C7B2#135361, COL_BC40A0F2_B6A4_4987_B401_A0611EBA19FF#135362, COL_9F8EB11D_CC94_41D1_BC9B_75A2B62F1ED0#135363, COL_807020CE_20A5_41C4_AE2B_10B99D472FA2#135364, COL_23B332B1_5432_4C70_A9F0_E9F65D9F5480#135365, COL_ECF7F350_45ED_4F11_9C26_DF0672965A4D#135366, COL_68C11010_06FC_40D9_A241_778AA8AE588D#135367, COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368, COL_B1616C39_761D_4EC9_A694_7CDDA1510A6C#135369, COL_450A716A_1E80_4B2E_BF35_B0BD3DE78D2A#135370, COL_A3644F3E_0D2F_4A06_A6FE_1A4FD7E3FB39#135371, COL_A2BECAE4_1350_4597_8721_6D25DB616635#135372, COL_CD29F452_4E41_4A81_99C0_3A9914B3299D#135373, COL_3FC0C414_AA21_4D9D_9AEA_27F86B234A86#135374, COL_61B8AC70_1B93_419C_A3E2_102A864B3280#135375]
Arguments: [COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(8) Window
Input [55]: [COL_BDDD46A4_898A_46D0_BF9B_C8BDFD746148#135321, COL_112BF58B_E911_46A2_8CA3_F6BFD5487579#135322, COL_04CE5AE8_BD39_4552_A33A_7B2C61DB9DD8#135323, COL_CC4AD334_C6F3_41DC_BDFF_CA980FFD3103#135324, COL_E69D8529_33F6_4429_BC58_D9698BF43562#135325, COL_A524D044_4115_4EE1_A8D8_247AAAD9E865#135326, COL_C55F8B0B_76B6_41EB_ADA7_B2FAAEBC9DFD#135327, COL_FBA805A9_48CA_4000_8AA3_998A562DE4E8#135328, COL_F0DBA7B9_11A3_4000_A26C_25F26BA2E9AA#135329, COL_FF182A2D_F1FD_4A7D_9AC0_67C34229FD64#135330, COL_5630B852_23CF_4C16_983F_69061354A034#135331, COL_22BEBE7F_9399_4512_9B79_1F24D9CA5C4D#135332, COL_D6D62F83_1651_43DE_A301_70E2648D65C0#135333, COL_9EF97016_78F9_4ACA_B680_526303781A4D#135334, COL_0B6D2DDD_1396_40A5_BC34_E1607A996FCF#135335, COL_6A763AB2_89BB_4758_BFC3_D9EFE73A1A7F#135336, COL_E54617EF_8ABA_4DA5_BE7A_D1B1DA88B241#135337, COL_08BA1D86_CB77_4294_B113_11DE299A15B0#135338, COL_59FD146E_C36E_4942_997C_23DFD8C14823#135339, COL_B5BDC057_DDE0_46D1_99DC_B1B7B729228E#135340, COL_8771C528_8E8F_4BBD_8130_45C0B95832BC#135341, COL_BD6164EB_302B_48FF_A1C3_F9478E4424D6#135342, COL_9FDC40A3_05F1_4E6E_9E28_D6C6C713E9E4#135343, COL_00FE6DB8_28B4_4067_9010_D825E080B8D4#135344, COL_D74020B3_0DA5_40AC_A47C_11416AC28AF4#135345, COL_D6094745_F373_4BC5_989E_5CF535CFCBB5#135346, COL_89F38B9C_F688_4EF4_BDBE_C91D1F850C38#135347, COL_F1B016E2_4B2D_4662_84F7_FDFFEF4DA77D#135348, COL_34BD3744_B4A8_4EC7_BFC0_0C5A40F1C327#135349, COL_BD669204_86B3_4535_A501_BE61CA1FA1E7#135350, COL_762064E2_E380_4F66_8654_4E2A4E6F10EC#135351, COL_D2A1070D_1A38_4AC9_B0C3_AF39D0FE8B98#135352, COL_56232655_74C2_472C_BE05_4C82BD2AD03F#135353, COL_B2D747F9_A7DA_431E_8137_303431EF82C0#135354, COL_7F4EA0F4_47F8_472E_B602_EF9B6F33DCF1#135355, COL_CE24648B_5C53_473A_86BA_1B425D6D4B60#135356, COL_46D16570_A31B_40CE_8FAE_2908C4E4431A#135357, COL_4E1FD930_1CDF_430C_994E_8E65963C7F7D#135358, COL_F69ABF00_2F53_43DD_9C29_8913549D724E#135359L, COL_14928EC1_3619_418E_A05E_FAA96E7AFD98#135360, COL_485383C3_A25B_4F35_A5C0_8D577B11C7B2#135361, COL_BC40A0F2_B6A4_4987_B401_A0611EBA19FF#135362, COL_9F8EB11D_CC94_41D1_BC9B_75A2B62F1ED0#135363, COL_807020CE_20A5_41C4_AE2B_10B99D472FA2#135364, COL_23B332B1_5432_4C70_A9F0_E9F65D9F5480#135365, COL_ECF7F350_45ED_4F11_9C26_DF0672965A4D#135366, COL_68C11010_06FC_40D9_A241_778AA8AE588D#135367, COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368, COL_B1616C39_761D_4EC9_A694_7CDDA1510A6C#135369, COL_450A716A_1E80_4B2E_BF35_B0BD3DE78D2A#135370, COL_A3644F3E_0D2F_4A06_A6FE_1A4FD7E3FB39#135371, COL_A2BECAE4_1350_4597_8721_6D25DB616635#135372, COL_CD29F452_4E41_4A81_99C0_3A9914B3299D#135373, COL_3FC0C414_AA21_4D9D_9AEA_27F86B234A86#135374, COL_61B8AC70_1B93_419C_A3E2_102A864B3280#135375]
Arguments: [sum(COL_B1616C39_761D_4EC9_A694_7CDDA1510A6C#135369) windowspecdefinition(COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_D966E020_40A5_4B41_B24F_4232E020D829#135490, avg(COL_B1616C39_761D_4EC9_A694_7CDDA1510A6C#135369) windowspecdefinition(COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_875AF143_68C5_428B_9C50_50F9977CE713#135664, avg(COL_14928EC1_3619_418E_A05E_FAA96E7AFD98#135360) windowspecdefinition(COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_1B6D0FE5_8D59_4DA4_BDA0_97D87621A96C#135841, avg(COL_807020CE_20A5_41C4_AE2B_10B99D472FA2#135364) windowspecdefinition(COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_F6C8888C_051F_4CA6_9982_DCCA73EC4144#136021, sum(COL_61B8AC70_1B93_419C_A3E2_102A864B3280#135375) windowspecdefinition(COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_C4B3810B_E130_4598_B8BD_A0CBB7213550#136204, count(1) windowspecdefinition(COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_59FA6040_6707_4B54_9108_CEDCF1D097AC#136391L, row_number() windowspecdefinition(COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_BB374D42_5C0B_4A05_AFD1_5C9C423D0535#136580], [COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368], [1 DESC NULLS LAST]

(9) Filter [codegen id : 3]
Input [62]: [COL_BDDD46A4_898A_46D0_BF9B_C8BDFD746148#135321, COL_112BF58B_E911_46A2_8CA3_F6BFD5487579#135322, COL_04CE5AE8_BD39_4552_A33A_7B2C61DB9DD8#135323, COL_CC4AD334_C6F3_41DC_BDFF_CA980FFD3103#135324, COL_E69D8529_33F6_4429_BC58_D9698BF43562#135325, COL_A524D044_4115_4EE1_A8D8_247AAAD9E865#135326, COL_C55F8B0B_76B6_41EB_ADA7_B2FAAEBC9DFD#135327, COL_FBA805A9_48CA_4000_8AA3_998A562DE4E8#135328, COL_F0DBA7B9_11A3_4000_A26C_25F26BA2E9AA#135329, COL_FF182A2D_F1FD_4A7D_9AC0_67C34229FD64#135330, COL_5630B852_23CF_4C16_983F_69061354A034#135331, COL_22BEBE7F_9399_4512_9B79_1F24D9CA5C4D#135332, COL_D6D62F83_1651_43DE_A301_70E2648D65C0#135333, COL_9EF97016_78F9_4ACA_B680_526303781A4D#135334, COL_0B6D2DDD_1396_40A5_BC34_E1607A996FCF#135335, COL_6A763AB2_89BB_4758_BFC3_D9EFE73A1A7F#135336, COL_E54617EF_8ABA_4DA5_BE7A_D1B1DA88B241#135337, COL_08BA1D86_CB77_4294_B113_11DE299A15B0#135338, COL_59FD146E_C36E_4942_997C_23DFD8C14823#135339, COL_B5BDC057_DDE0_46D1_99DC_B1B7B729228E#135340, COL_8771C528_8E8F_4BBD_8130_45C0B95832BC#135341, COL_BD6164EB_302B_48FF_A1C3_F9478E4424D6#135342, COL_9FDC40A3_05F1_4E6E_9E28_D6C6C713E9E4#135343, COL_00FE6DB8_28B4_4067_9010_D825E080B8D4#135344, COL_D74020B3_0DA5_40AC_A47C_11416AC28AF4#135345, COL_D6094745_F373_4BC5_989E_5CF535CFCBB5#135346, COL_89F38B9C_F688_4EF4_BDBE_C91D1F850C38#135347, COL_F1B016E2_4B2D_4662_84F7_FDFFEF4DA77D#135348, COL_34BD3744_B4A8_4EC7_BFC0_0C5A40F1C327#135349, COL_BD669204_86B3_4535_A501_BE61CA1FA1E7#135350, COL_762064E2_E380_4F66_8654_4E2A4E6F10EC#135351, COL_D2A1070D_1A38_4AC9_B0C3_AF39D0FE8B98#135352, COL_56232655_74C2_472C_BE05_4C82BD2AD03F#135353, COL_B2D747F9_A7DA_431E_8137_303431EF82C0#135354, COL_7F4EA0F4_47F8_472E_B602_EF9B6F33DCF1#135355, COL_CE24648B_5C53_473A_86BA_1B425D6D4B60#135356, COL_46D16570_A31B_40CE_8FAE_2908C4E4431A#135357, COL_4E1FD930_1CDF_430C_994E_8E65963C7F7D#135358, COL_F69ABF00_2F53_43DD_9C29_8913549D724E#135359L, COL_14928EC1_3619_418E_A05E_FAA96E7AFD98#135360, COL_485383C3_A25B_4F35_A5C0_8D577B11C7B2#135361, COL_BC40A0F2_B6A4_4987_B401_A0611EBA19FF#135362, COL_9F8EB11D_CC94_41D1_BC9B_75A2B62F1ED0#135363, COL_807020CE_20A5_41C4_AE2B_10B99D472FA2#135364, COL_23B332B1_5432_4C70_A9F0_E9F65D9F5480#135365, COL_ECF7F350_45ED_4F11_9C26_DF0672965A4D#135366, COL_68C11010_06FC_40D9_A241_778AA8AE588D#135367, COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368, COL_B1616C39_761D_4EC9_A694_7CDDA1510A6C#135369, COL_450A716A_1E80_4B2E_BF35_B0BD3DE78D2A#135370, COL_A3644F3E_0D2F_4A06_A6FE_1A4FD7E3FB39#135371, COL_A2BECAE4_1350_4597_8721_6D25DB616635#135372, COL_CD29F452_4E41_4A81_99C0_3A9914B3299D#135373, COL_3FC0C414_AA21_4D9D_9AEA_27F86B234A86#135374, COL_61B8AC70_1B93_419C_A3E2_102A864B3280#135375, COL_D966E020_40A5_4B41_B24F_4232E020D829#135490, COL_875AF143_68C5_428B_9C50_50F9977CE713#135664, COL_1B6D0FE5_8D59_4DA4_BDA0_97D87621A96C#135841, COL_F6C8888C_051F_4CA6_9982_DCCA73EC4144#136021, COL_C4B3810B_E130_4598_B8BD_A0CBB7213550#136204, COL_59FA6040_6707_4B54_9108_CEDCF1D097AC#136391L, COL_BB374D42_5C0B_4A05_AFD1_5C9C423D0535#136580]
Condition : (((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BDDD46A4_898A_46D0_BF9B_C8BDFD746148#135321)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BDDD46A4_898A_46D0_BF9B_C8BDFD746148#135321)), MAISON) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_112BF58B_E911_46A2_8CA3_F6BFD5487579#135322)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_112BF58B_E911_46A2_8CA3_F6BFD5487579#135322)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_04CE5AE8_BD39_4552_A33A_7B2C61DB9DD8#135323)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_04CE5AE8_BD39_4552_A33A_7B2C61DB9DD8#135323)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CC4AD334_C6F3_41DC_BDFF_CA980FFD3103#135324)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_CC4AD334_C6F3_41DC_BDFF_CA980FFD3103#135324)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E69D8529_33F6_4429_BC58_D9698BF43562#135325)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_E69D8529_33F6_4429_BC58_D9698BF43562#135325)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A524D044_4115_4EE1_A8D8_247AAAD9E865#135326)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_A524D044_4115_4EE1_A8D8_247AAAD9E865#135326)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C55F8B0B_76B6_41EB_ADA7_B2FAAEBC9DFD#135327)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_C55F8B0B_76B6_41EB_ADA7_B2FAAEBC9DFD#135327)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FBA805A9_48CA_4000_8AA3_998A562DE4E8#135328)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_FBA805A9_48CA_4000_8AA3_998A562DE4E8#135328)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F0DBA7B9_11A3_4000_A26C_25F26BA2E9AA#135329)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_F0DBA7B9_11A3_4000_A26C_25F26BA2E9AA#135329)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FF182A2D_F1FD_4A7D_9AC0_67C34229FD64#135330)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_FF182A2D_F1FD_4A7D_9AC0_67C34229FD64#135330)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5630B852_23CF_4C16_983F_69061354A034#135331)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_5630B852_23CF_4C16_983F_69061354A034#135331)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_22BEBE7F_9399_4512_9B79_1F24D9CA5C4D#135332)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_22BEBE7F_9399_4512_9B79_1F24D9CA5C4D#135332)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D6D62F83_1651_43DE_A301_70E2648D65C0#135333)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D6D62F83_1651_43DE_A301_70E2648D65C0#135333)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9EF97016_78F9_4ACA_B680_526303781A4D#135334)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9EF97016_78F9_4ACA_B680_526303781A4D#135334)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0B6D2DDD_1396_40A5_BC34_E1607A996FCF#135335)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0B6D2DDD_1396_40A5_BC34_E1607A996FCF#135335)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_6A763AB2_89BB_4758_BFC3_D9EFE73A1A7F#135336)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_6A763AB2_89BB_4758_BFC3_D9EFE73A1A7F#135336)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E54617EF_8ABA_4DA5_BE7A_D1B1DA88B241#135337)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_E54617EF_8ABA_4DA5_BE7A_D1B1DA88B241#135337)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_08BA1D86_CB77_4294_B113_11DE299A15B0#135338)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_08BA1D86_CB77_4294_B113_11DE299A15B0#135338)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_59FD146E_C36E_4942_997C_23DFD8C14823#135339)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_59FD146E_C36E_4942_997C_23DFD8C14823#135339)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B5BDC057_DDE0_46D1_99DC_B1B7B729228E#135340)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_B5BDC057_DDE0_46D1_99DC_B1B7B729228E#135340)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8771C528_8E8F_4BBD_8130_45C0B95832BC#135341)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_8771C528_8E8F_4BBD_8130_45C0B95832BC#135341)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BD6164EB_302B_48FF_A1C3_F9478E4424D6#135342)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BD6164EB_302B_48FF_A1C3_F9478E4424D6#135342)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9FDC40A3_05F1_4E6E_9E28_D6C6C713E9E4#135343)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9FDC40A3_05F1_4E6E_9E28_D6C6C713E9E4#135343)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_00FE6DB8_28B4_4067_9010_D825E080B8D4#135344)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_00FE6DB8_28B4_4067_9010_D825E080B8D4#135344)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D74020B3_0DA5_40AC_A47C_11416AC28AF4#135345)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D74020B3_0DA5_40AC_A47C_11416AC28AF4#135345)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D6094745_F373_4BC5_989E_5CF535CFCBB5#135346)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D6094745_F373_4BC5_989E_5CF535CFCBB5#135346)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_89F38B9C_F688_4EF4_BDBE_C91D1F850C38#135347)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_89F38B9C_F688_4EF4_BDBE_C91D1F850C38#135347)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F1B016E2_4B2D_4662_84F7_FDFFEF4DA77D#135348)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_F1B016E2_4B2D_4662_84F7_FDFFEF4DA77D#135348)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_34BD3744_B4A8_4EC7_BFC0_0C5A40F1C327#135349)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_34BD3744_B4A8_4EC7_BFC0_0C5A40F1C327#135349)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BD669204_86B3_4535_A501_BE61CA1FA1E7#135350)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BD669204_86B3_4535_A501_BE61CA1FA1E7#135350)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_762064E2_E380_4F66_8654_4E2A4E6F10EC#135351)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_762064E2_E380_4F66_8654_4E2A4E6F10EC#135351)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D2A1070D_1A38_4AC9_B0C3_AF39D0FE8B98#135352)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D2A1070D_1A38_4AC9_B0C3_AF39D0FE8B98#135352)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_56232655_74C2_472C_BE05_4C82BD2AD03F#135353)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_56232655_74C2_472C_BE05_4C82BD2AD03F#135353)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B2D747F9_A7DA_431E_8137_303431EF82C0#135354)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_B2D747F9_A7DA_431E_8137_303431EF82C0#135354)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_7F4EA0F4_47F8_472E_B602_EF9B6F33DCF1#135355)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_7F4EA0F4_47F8_472E_B602_EF9B6F33DCF1#135355)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CE24648B_5C53_473A_86BA_1B425D6D4B60#135356)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_CE24648B_5C53_473A_86BA_1B425D6D4B60#135356)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_46D16570_A31B_40CE_8FAE_2908C4E4431A#135357)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_46D16570_A31B_40CE_8FAE_2908C4E4431A#135357)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_4E1FD930_1CDF_430C_994E_8E65963C7F7D#135358)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_4E1FD930_1CDF_430C_994E_8E65963C7F7D#135358)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_450A716A_1E80_4B2E_BF35_B0BD3DE78D2A#135370)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_450A716A_1E80_4B2E_BF35_B0BD3DE78D2A#135370)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A3644F3E_0D2F_4A06_A6FE_1A4FD7E3FB39#135371)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_A3644F3E_0D2F_4A06_A6FE_1A4FD7E3FB39#135371)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A2BECAE4_1350_4597_8721_6D25DB616635#135372)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_A2BECAE4_1350_4597_8721_6D25DB616635#135372)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CD29F452_4E41_4A81_99C0_3A9914B3299D#135373)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_CD29F452_4E41_4A81_99C0_3A9914B3299D#135373)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_3FC0C414_AA21_4D9D_9AEA_27F86B234A86#135374)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_3FC0C414_AA21_4D9D_9AEA_27F86B234A86#135374)), MAISON) END)

(10) Project [codegen id : 3]
Output [62]: [COL_BDDD46A4_898A_46D0_BF9B_C8BDFD746148#135321, COL_112BF58B_E911_46A2_8CA3_F6BFD5487579#135322, COL_04CE5AE8_BD39_4552_A33A_7B2C61DB9DD8#135323, COL_CC4AD334_C6F3_41DC_BDFF_CA980FFD3103#135324, COL_E69D8529_33F6_4429_BC58_D9698BF43562#135325, COL_A524D044_4115_4EE1_A8D8_247AAAD9E865#135326, COL_C55F8B0B_76B6_41EB_ADA7_B2FAAEBC9DFD#135327, COL_FBA805A9_48CA_4000_8AA3_998A562DE4E8#135328, COL_F0DBA7B9_11A3_4000_A26C_25F26BA2E9AA#135329, COL_FF182A2D_F1FD_4A7D_9AC0_67C34229FD64#135330, COL_5630B852_23CF_4C16_983F_69061354A034#135331, COL_22BEBE7F_9399_4512_9B79_1F24D9CA5C4D#135332, COL_D6D62F83_1651_43DE_A301_70E2648D65C0#135333, COL_9EF97016_78F9_4ACA_B680_526303781A4D#135334, COL_0B6D2DDD_1396_40A5_BC34_E1607A996FCF#135335, COL_6A763AB2_89BB_4758_BFC3_D9EFE73A1A7F#135336, COL_E54617EF_8ABA_4DA5_BE7A_D1B1DA88B241#135337, COL_08BA1D86_CB77_4294_B113_11DE299A15B0#135338, COL_59FD146E_C36E_4942_997C_23DFD8C14823#135339, COL_B5BDC057_DDE0_46D1_99DC_B1B7B729228E#135340, COL_8771C528_8E8F_4BBD_8130_45C0B95832BC#135341, COL_BD6164EB_302B_48FF_A1C3_F9478E4424D6#135342, COL_9FDC40A3_05F1_4E6E_9E28_D6C6C713E9E4#135343, COL_00FE6DB8_28B4_4067_9010_D825E080B8D4#135344, COL_D74020B3_0DA5_40AC_A47C_11416AC28AF4#135345, COL_D6094745_F373_4BC5_989E_5CF535CFCBB5#135346, COL_89F38B9C_F688_4EF4_BDBE_C91D1F850C38#135347, COL_F1B016E2_4B2D_4662_84F7_FDFFEF4DA77D#135348, COL_34BD3744_B4A8_4EC7_BFC0_0C5A40F1C327#135349, COL_BD669204_86B3_4535_A501_BE61CA1FA1E7#135350, COL_762064E2_E380_4F66_8654_4E2A4E6F10EC#135351, COL_D2A1070D_1A38_4AC9_B0C3_AF39D0FE8B98#135352, COL_56232655_74C2_472C_BE05_4C82BD2AD03F#135353, COL_B2D747F9_A7DA_431E_8137_303431EF82C0#135354, COL_7F4EA0F4_47F8_472E_B602_EF9B6F33DCF1#135355, COL_CE24648B_5C53_473A_86BA_1B425D6D4B60#135356, COL_46D16570_A31B_40CE_8FAE_2908C4E4431A#135357, COL_4E1FD930_1CDF_430C_994E_8E65963C7F7D#135358, COL_F69ABF00_2F53_43DD_9C29_8913549D724E#135359L, COL_14928EC1_3619_418E_A05E_FAA96E7AFD98#135360, COL_485383C3_A25B_4F35_A5C0_8D577B11C7B2#135361, COL_BC40A0F2_B6A4_4987_B401_A0611EBA19FF#135362, COL_9F8EB11D_CC94_41D1_BC9B_75A2B62F1ED0#135363, COL_807020CE_20A5_41C4_AE2B_10B99D472FA2#135364, COL_23B332B1_5432_4C70_A9F0_E9F65D9F5480#135365, COL_ECF7F350_45ED_4F11_9C26_DF0672965A4D#135366, COL_68C11010_06FC_40D9_A241_778AA8AE588D#135367, COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368, COL_B1616C39_761D_4EC9_A694_7CDDA1510A6C#135369, COL_450A716A_1E80_4B2E_BF35_B0BD3DE78D2A#135370, COL_A3644F3E_0D2F_4A06_A6FE_1A4FD7E3FB39#135371, COL_A2BECAE4_1350_4597_8721_6D25DB616635#135372, COL_CD29F452_4E41_4A81_99C0_3A9914B3299D#135373, COL_3FC0C414_AA21_4D9D_9AEA_27F86B234A86#135374, COL_D966E020_40A5_4B41_B24F_4232E020D829#135490, round(COL_875AF143_68C5_428B_9C50_50F9977CE713#135664, 2) AS COL_875AF143_68C5_428B_9C50_50F9977CE713#136761, round(COL_1B6D0FE5_8D59_4DA4_BDA0_97D87621A96C#135841, 2) AS COL_1B6D0FE5_8D59_4DA4_BDA0_97D87621A96C#136762, round(COL_F6C8888C_051F_4CA6_9982_DCCA73EC4144#136021, 2) AS COL_F6C8888C_051F_4CA6_9982_DCCA73EC4144#136763, COL_59FA6040_6707_4B54_9108_CEDCF1D097AC#136391L, COL_BB374D42_5C0B_4A05_AFD1_5C9C423D0535#136580, COL_61B8AC70_1B93_419C_A3E2_102A864B3280#135375, round(COL_C4B3810B_E130_4598_B8BD_A0CBB7213550#136204, 2) AS COL_C4B3810B_E130_4598_B8BD_A0CBB7213550#136767]
Input [62]: [COL_BDDD46A4_898A_46D0_BF9B_C8BDFD746148#135321, COL_112BF58B_E911_46A2_8CA3_F6BFD5487579#135322, COL_04CE5AE8_BD39_4552_A33A_7B2C61DB9DD8#135323, COL_CC4AD334_C6F3_41DC_BDFF_CA980FFD3103#135324, COL_E69D8529_33F6_4429_BC58_D9698BF43562#135325, COL_A524D044_4115_4EE1_A8D8_247AAAD9E865#135326, COL_C55F8B0B_76B6_41EB_ADA7_B2FAAEBC9DFD#135327, COL_FBA805A9_48CA_4000_8AA3_998A562DE4E8#135328, COL_F0DBA7B9_11A3_4000_A26C_25F26BA2E9AA#135329, COL_FF182A2D_F1FD_4A7D_9AC0_67C34229FD64#135330, COL_5630B852_23CF_4C16_983F_69061354A034#135331, COL_22BEBE7F_9399_4512_9B79_1F24D9CA5C4D#135332, COL_D6D62F83_1651_43DE_A301_70E2648D65C0#135333, COL_9EF97016_78F9_4ACA_B680_526303781A4D#135334, COL_0B6D2DDD_1396_40A5_BC34_E1607A996FCF#135335, COL_6A763AB2_89BB_4758_BFC3_D9EFE73A1A7F#135336, COL_E54617EF_8ABA_4DA5_BE7A_D1B1DA88B241#135337, COL_08BA1D86_CB77_4294_B113_11DE299A15B0#135338, COL_59FD146E_C36E_4942_997C_23DFD8C14823#135339, COL_B5BDC057_DDE0_46D1_99DC_B1B7B729228E#135340, COL_8771C528_8E8F_4BBD_8130_45C0B95832BC#135341, COL_BD6164EB_302B_48FF_A1C3_F9478E4424D6#135342, COL_9FDC40A3_05F1_4E6E_9E28_D6C6C713E9E4#135343, COL_00FE6DB8_28B4_4067_9010_D825E080B8D4#135344, COL_D74020B3_0DA5_40AC_A47C_11416AC28AF4#135345, COL_D6094745_F373_4BC5_989E_5CF535CFCBB5#135346, COL_89F38B9C_F688_4EF4_BDBE_C91D1F850C38#135347, COL_F1B016E2_4B2D_4662_84F7_FDFFEF4DA77D#135348, COL_34BD3744_B4A8_4EC7_BFC0_0C5A40F1C327#135349, COL_BD669204_86B3_4535_A501_BE61CA1FA1E7#135350, COL_762064E2_E380_4F66_8654_4E2A4E6F10EC#135351, COL_D2A1070D_1A38_4AC9_B0C3_AF39D0FE8B98#135352, COL_56232655_74C2_472C_BE05_4C82BD2AD03F#135353, COL_B2D747F9_A7DA_431E_8137_303431EF82C0#135354, COL_7F4EA0F4_47F8_472E_B602_EF9B6F33DCF1#135355, COL_CE24648B_5C53_473A_86BA_1B425D6D4B60#135356, COL_46D16570_A31B_40CE_8FAE_2908C4E4431A#135357, COL_4E1FD930_1CDF_430C_994E_8E65963C7F7D#135358, COL_F69ABF00_2F53_43DD_9C29_8913549D724E#135359L, COL_14928EC1_3619_418E_A05E_FAA96E7AFD98#135360, COL_485383C3_A25B_4F35_A5C0_8D577B11C7B2#135361, COL_BC40A0F2_B6A4_4987_B401_A0611EBA19FF#135362, COL_9F8EB11D_CC94_41D1_BC9B_75A2B62F1ED0#135363, COL_807020CE_20A5_41C4_AE2B_10B99D472FA2#135364, COL_23B332B1_5432_4C70_A9F0_E9F65D9F5480#135365, COL_ECF7F350_45ED_4F11_9C26_DF0672965A4D#135366, COL_68C11010_06FC_40D9_A241_778AA8AE588D#135367, COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368, COL_B1616C39_761D_4EC9_A694_7CDDA1510A6C#135369, COL_450A716A_1E80_4B2E_BF35_B0BD3DE78D2A#135370, COL_A3644F3E_0D2F_4A06_A6FE_1A4FD7E3FB39#135371, COL_A2BECAE4_1350_4597_8721_6D25DB616635#135372, COL_CD29F452_4E41_4A81_99C0_3A9914B3299D#135373, COL_3FC0C414_AA21_4D9D_9AEA_27F86B234A86#135374, COL_61B8AC70_1B93_419C_A3E2_102A864B3280#135375, COL_D966E020_40A5_4B41_B24F_4232E020D829#135490, COL_875AF143_68C5_428B_9C50_50F9977CE713#135664, COL_1B6D0FE5_8D59_4DA4_BDA0_97D87621A96C#135841, COL_F6C8888C_051F_4CA6_9982_DCCA73EC4144#136021, COL_C4B3810B_E130_4598_B8BD_A0CBB7213550#136204, COL_59FA6040_6707_4B54_9108_CEDCF1D097AC#136391L, COL_BB374D42_5C0B_4A05_AFD1_5C9C423D0535#136580]

(11) Project
Output [55]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#134881 AS COL_BDDD46A4_898A_46D0_BF9B_C8BDFD746148#135321, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#134882 AS COL_112BF58B_E911_46A2_8CA3_F6BFD5487579#135322, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#134883 AS COL_04CE5AE8_BD39_4552_A33A_7B2C61DB9DD8#135323, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#134884 AS COL_CC4AD334_C6F3_41DC_BDFF_CA980FFD3103#135324, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#134885 AS COL_E69D8529_33F6_4429_BC58_D9698BF43562#135325, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#134886 AS COL_A524D044_4115_4EE1_A8D8_247AAAD9E865#135326, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#134887 AS COL_C55F8B0B_76B6_41EB_ADA7_B2FAAEBC9DFD#135327, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#134888 AS COL_FBA805A9_48CA_4000_8AA3_998A562DE4E8#135328, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#134889 AS COL_F0DBA7B9_11A3_4000_A26C_25F26BA2E9AA#135329, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#134890 AS COL_FF182A2D_F1FD_4A7D_9AC0_67C34229FD64#135330, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#134891 AS COL_5630B852_23CF_4C16_983F_69061354A034#135331, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#134892 AS COL_22BEBE7F_9399_4512_9B79_1F24D9CA5C4D#135332, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#134893 AS COL_D6D62F83_1651_43DE_A301_70E2648D65C0#135333, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#134894 AS COL_9EF97016_78F9_4ACA_B680_526303781A4D#135334, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#134895 AS COL_0B6D2DDD_1396_40A5_BC34_E1607A996FCF#135335, COL_98B2878A_418E_4331_B333_2493994BB807#134896 AS COL_6A763AB2_89BB_4758_BFC3_D9EFE73A1A7F#135336, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#134897 AS COL_E54617EF_8ABA_4DA5_BE7A_D1B1DA88B241#135337, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#134898 AS COL_08BA1D86_CB77_4294_B113_11DE299A15B0#135338, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#134899 AS COL_59FD146E_C36E_4942_997C_23DFD8C14823#135339, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#134900 AS COL_B5BDC057_DDE0_46D1_99DC_B1B7B729228E#135340, COL_E722B691_2CA2_4160_A578_D9CD4920A842#134901 AS COL_8771C528_8E8F_4BBD_8130_45C0B95832BC#135341, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#134902 AS COL_BD6164EB_302B_48FF_A1C3_F9478E4424D6#135342, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#134903 AS COL_9FDC40A3_05F1_4E6E_9E28_D6C6C713E9E4#135343, COL_D897344F_9AC3_429E_A95D_88390F445758#134904 AS COL_00FE6DB8_28B4_4067_9010_D825E080B8D4#135344, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#134905 AS COL_D74020B3_0DA5_40AC_A47C_11416AC28AF4#135345, COL_52167438_70F6_4E26_B5CD_17C5990F8948#134906 AS COL_D6094745_F373_4BC5_989E_5CF535CFCBB5#135346, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#134907 AS COL_89F38B9C_F688_4EF4_BDBE_C91D1F850C38#135347, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#134908 AS COL_F1B016E2_4B2D_4662_84F7_FDFFEF4DA77D#135348, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#134909 AS COL_34BD3744_B4A8_4EC7_BFC0_0C5A40F1C327#135349, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#134910 AS COL_BD669204_86B3_4535_A501_BE61CA1FA1E7#135350, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#134911 AS COL_762064E2_E380_4F66_8654_4E2A4E6F10EC#135351, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#134912 AS COL_D2A1070D_1A38_4AC9_B0C3_AF39D0FE8B98#135352, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#134913 AS COL_56232655_74C2_472C_BE05_4C82BD2AD03F#135353, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#134914 AS COL_B2D747F9_A7DA_431E_8137_303431EF82C0#135354, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#134915 AS COL_7F4EA0F4_47F8_472E_B602_EF9B6F33DCF1#135355, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#134916 AS COL_CE24648B_5C53_473A_86BA_1B425D6D4B60#135356, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#134917 AS COL_46D16570_A31B_40CE_8FAE_2908C4E4431A#135357, COL_1FF33786_C88A_4789_B428_364FF98B1905#134918 AS COL_4E1FD930_1CDF_430C_994E_8E65963C7F7D#135358, COL_35375170_B542_49DE_AFA2_0A2D31967891#134919L AS COL_F69ABF00_2F53_43DD_9C29_8913549D724E#135359L, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#134920 AS COL_14928EC1_3619_418E_A05E_FAA96E7AFD98#135360, COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#134921 AS COL_485383C3_A25B_4F35_A5C0_8D577B11C7B2#135361, COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#134922 AS COL_BC40A0F2_B6A4_4987_B401_A0611EBA19FF#135362, COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#134923 AS COL_9F8EB11D_CC94_41D1_BC9B_75A2B62F1ED0#135363, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#134924 AS COL_807020CE_20A5_41C4_AE2B_10B99D472FA2#135364, COL_0D8E2436_E961_45FA_A7F3_A7C5D2ED89CF#134925 AS COL_23B332B1_5432_4C70_A9F0_E9F65D9F5480#135365, COL_566EB258_CFF9_4285_BB8C_DBD46A1BE5B9#134927 AS COL_ECF7F350_45ED_4F11_9C26_DF0672965A4D#135366, COL_23424D2C_0B0A_403F_9061_1D8B148D6A67#134928 AS COL_68C11010_06FC_40D9_A241_778AA8AE588D#135367, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#134929 AS COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368, COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#134930 AS COL_B1616C39_761D_4EC9_A694_7CDDA1510A6C#135369, COL_8068E186_2734_4730_8D2C_A788B2226179#134931 AS COL_450A716A_1E80_4B2E_BF35_B0BD3DE78D2A#135370, COL_DA667933_29E5_49E1_8724_A537DCE9735F#134932 AS COL_A3644F3E_0D2F_4A06_A6FE_1A4FD7E3FB39#135371, COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#134933 AS COL_A2BECAE4_1350_4597_8721_6D25DB616635#135372, COL_C5B37418_B2B7_49D0_8C7C_3E0D61B4DAD7#134934 AS COL_CD29F452_4E41_4A81_99C0_3A9914B3299D#135373, COL_A6B4C7B1_4D23_4C04_AACE_CCD82E9AC458#134935 AS COL_3FC0C414_AA21_4D9D_9AEA_27F86B234A86#135374, COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD#134926 AS COL_61B8AC70_1B93_419C_A3E2_102A864B3280#135375]
Input [55]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#134881, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#134882, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#134883, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#134884, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#134885, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#134886, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#134887, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#134888, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#134889, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#134890, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#134891, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#134892, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#134893, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#134894, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#134895, COL_98B2878A_418E_4331_B333_2493994BB807#134896, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#134897, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#134898, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#134899, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#134900, COL_E722B691_2CA2_4160_A578_D9CD4920A842#134901, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#134902, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#134903, COL_D897344F_9AC3_429E_A95D_88390F445758#134904, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#134905, COL_52167438_70F6_4E26_B5CD_17C5990F8948#134906, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#134907, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#134908, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#134909, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#134910, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#134911, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#134912, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#134913, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#134914, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#134915, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#134916, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#134917, COL_1FF33786_C88A_4789_B428_364FF98B1905#134918, COL_35375170_B542_49DE_AFA2_0A2D31967891#134919L, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#134920, COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#134921, COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#134922, COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#134923, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#134924, COL_0D8E2436_E961_45FA_A7F3_A7C5D2ED89CF#134925, COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD#134926, COL_566EB258_CFF9_4285_BB8C_DBD46A1BE5B9#134927, COL_23424D2C_0B0A_403F_9061_1D8B148D6A67#134928, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#134929, COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#134930, COL_8068E186_2734_4730_8D2C_A788B2226179#134931, COL_DA667933_29E5_49E1_8724_A537DCE9735F#134932, COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#134933, COL_C5B37418_B2B7_49D0_8C7C_3E0D61B4DAD7#134934, COL_A6B4C7B1_4D23_4C04_AACE_CCD82E9AC458#134935]

(12) Exchange
Input [55]: [COL_BDDD46A4_898A_46D0_BF9B_C8BDFD746148#135321, COL_112BF58B_E911_46A2_8CA3_F6BFD5487579#135322, COL_04CE5AE8_BD39_4552_A33A_7B2C61DB9DD8#135323, COL_CC4AD334_C6F3_41DC_BDFF_CA980FFD3103#135324, COL_E69D8529_33F6_4429_BC58_D9698BF43562#135325, COL_A524D044_4115_4EE1_A8D8_247AAAD9E865#135326, COL_C55F8B0B_76B6_41EB_ADA7_B2FAAEBC9DFD#135327, COL_FBA805A9_48CA_4000_8AA3_998A562DE4E8#135328, COL_F0DBA7B9_11A3_4000_A26C_25F26BA2E9AA#135329, COL_FF182A2D_F1FD_4A7D_9AC0_67C34229FD64#135330, COL_5630B852_23CF_4C16_983F_69061354A034#135331, COL_22BEBE7F_9399_4512_9B79_1F24D9CA5C4D#135332, COL_D6D62F83_1651_43DE_A301_70E2648D65C0#135333, COL_9EF97016_78F9_4ACA_B680_526303781A4D#135334, COL_0B6D2DDD_1396_40A5_BC34_E1607A996FCF#135335, COL_6A763AB2_89BB_4758_BFC3_D9EFE73A1A7F#135336, COL_E54617EF_8ABA_4DA5_BE7A_D1B1DA88B241#135337, COL_08BA1D86_CB77_4294_B113_11DE299A15B0#135338, COL_59FD146E_C36E_4942_997C_23DFD8C14823#135339, COL_B5BDC057_DDE0_46D1_99DC_B1B7B729228E#135340, COL_8771C528_8E8F_4BBD_8130_45C0B95832BC#135341, COL_BD6164EB_302B_48FF_A1C3_F9478E4424D6#135342, COL_9FDC40A3_05F1_4E6E_9E28_D6C6C713E9E4#135343, COL_00FE6DB8_28B4_4067_9010_D825E080B8D4#135344, COL_D74020B3_0DA5_40AC_A47C_11416AC28AF4#135345, COL_D6094745_F373_4BC5_989E_5CF535CFCBB5#135346, COL_89F38B9C_F688_4EF4_BDBE_C91D1F850C38#135347, COL_F1B016E2_4B2D_4662_84F7_FDFFEF4DA77D#135348, COL_34BD3744_B4A8_4EC7_BFC0_0C5A40F1C327#135349, COL_BD669204_86B3_4535_A501_BE61CA1FA1E7#135350, COL_762064E2_E380_4F66_8654_4E2A4E6F10EC#135351, COL_D2A1070D_1A38_4AC9_B0C3_AF39D0FE8B98#135352, COL_56232655_74C2_472C_BE05_4C82BD2AD03F#135353, COL_B2D747F9_A7DA_431E_8137_303431EF82C0#135354, COL_7F4EA0F4_47F8_472E_B602_EF9B6F33DCF1#135355, COL_CE24648B_5C53_473A_86BA_1B425D6D4B60#135356, COL_46D16570_A31B_40CE_8FAE_2908C4E4431A#135357, COL_4E1FD930_1CDF_430C_994E_8E65963C7F7D#135358, COL_F69ABF00_2F53_43DD_9C29_8913549D724E#135359L, COL_14928EC1_3619_418E_A05E_FAA96E7AFD98#135360, COL_485383C3_A25B_4F35_A5C0_8D577B11C7B2#135361, COL_BC40A0F2_B6A4_4987_B401_A0611EBA19FF#135362, COL_9F8EB11D_CC94_41D1_BC9B_75A2B62F1ED0#135363, COL_807020CE_20A5_41C4_AE2B_10B99D472FA2#135364, COL_23B332B1_5432_4C70_A9F0_E9F65D9F5480#135365, COL_ECF7F350_45ED_4F11_9C26_DF0672965A4D#135366, COL_68C11010_06FC_40D9_A241_778AA8AE588D#135367, COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368, COL_B1616C39_761D_4EC9_A694_7CDDA1510A6C#135369, COL_450A716A_1E80_4B2E_BF35_B0BD3DE78D2A#135370, COL_A3644F3E_0D2F_4A06_A6FE_1A4FD7E3FB39#135371, COL_A2BECAE4_1350_4597_8721_6D25DB616635#135372, COL_CD29F452_4E41_4A81_99C0_3A9914B3299D#135373, COL_3FC0C414_AA21_4D9D_9AEA_27F86B234A86#135374, COL_61B8AC70_1B93_419C_A3E2_102A864B3280#135375]
Arguments: hashpartitioning(COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368, 10), ENSURE_REQUIREMENTS, [plan_id=19413]

(13) Sort
Input [55]: [COL_BDDD46A4_898A_46D0_BF9B_C8BDFD746148#135321, COL_112BF58B_E911_46A2_8CA3_F6BFD5487579#135322, COL_04CE5AE8_BD39_4552_A33A_7B2C61DB9DD8#135323, COL_CC4AD334_C6F3_41DC_BDFF_CA980FFD3103#135324, COL_E69D8529_33F6_4429_BC58_D9698BF43562#135325, COL_A524D044_4115_4EE1_A8D8_247AAAD9E865#135326, COL_C55F8B0B_76B6_41EB_ADA7_B2FAAEBC9DFD#135327, COL_FBA805A9_48CA_4000_8AA3_998A562DE4E8#135328, COL_F0DBA7B9_11A3_4000_A26C_25F26BA2E9AA#135329, COL_FF182A2D_F1FD_4A7D_9AC0_67C34229FD64#135330, COL_5630B852_23CF_4C16_983F_69061354A034#135331, COL_22BEBE7F_9399_4512_9B79_1F24D9CA5C4D#135332, COL_D6D62F83_1651_43DE_A301_70E2648D65C0#135333, COL_9EF97016_78F9_4ACA_B680_526303781A4D#135334, COL_0B6D2DDD_1396_40A5_BC34_E1607A996FCF#135335, COL_6A763AB2_89BB_4758_BFC3_D9EFE73A1A7F#135336, COL_E54617EF_8ABA_4DA5_BE7A_D1B1DA88B241#135337, COL_08BA1D86_CB77_4294_B113_11DE299A15B0#135338, COL_59FD146E_C36E_4942_997C_23DFD8C14823#135339, COL_B5BDC057_DDE0_46D1_99DC_B1B7B729228E#135340, COL_8771C528_8E8F_4BBD_8130_45C0B95832BC#135341, COL_BD6164EB_302B_48FF_A1C3_F9478E4424D6#135342, COL_9FDC40A3_05F1_4E6E_9E28_D6C6C713E9E4#135343, COL_00FE6DB8_28B4_4067_9010_D825E080B8D4#135344, COL_D74020B3_0DA5_40AC_A47C_11416AC28AF4#135345, COL_D6094745_F373_4BC5_989E_5CF535CFCBB5#135346, COL_89F38B9C_F688_4EF4_BDBE_C91D1F850C38#135347, COL_F1B016E2_4B2D_4662_84F7_FDFFEF4DA77D#135348, COL_34BD3744_B4A8_4EC7_BFC0_0C5A40F1C327#135349, COL_BD669204_86B3_4535_A501_BE61CA1FA1E7#135350, COL_762064E2_E380_4F66_8654_4E2A4E6F10EC#135351, COL_D2A1070D_1A38_4AC9_B0C3_AF39D0FE8B98#135352, COL_56232655_74C2_472C_BE05_4C82BD2AD03F#135353, COL_B2D747F9_A7DA_431E_8137_303431EF82C0#135354, COL_7F4EA0F4_47F8_472E_B602_EF9B6F33DCF1#135355, COL_CE24648B_5C53_473A_86BA_1B425D6D4B60#135356, COL_46D16570_A31B_40CE_8FAE_2908C4E4431A#135357, COL_4E1FD930_1CDF_430C_994E_8E65963C7F7D#135358, COL_F69ABF00_2F53_43DD_9C29_8913549D724E#135359L, COL_14928EC1_3619_418E_A05E_FAA96E7AFD98#135360, COL_485383C3_A25B_4F35_A5C0_8D577B11C7B2#135361, COL_BC40A0F2_B6A4_4987_B401_A0611EBA19FF#135362, COL_9F8EB11D_CC94_41D1_BC9B_75A2B62F1ED0#135363, COL_807020CE_20A5_41C4_AE2B_10B99D472FA2#135364, COL_23B332B1_5432_4C70_A9F0_E9F65D9F5480#135365, COL_ECF7F350_45ED_4F11_9C26_DF0672965A4D#135366, COL_68C11010_06FC_40D9_A241_778AA8AE588D#135367, COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368, COL_B1616C39_761D_4EC9_A694_7CDDA1510A6C#135369, COL_450A716A_1E80_4B2E_BF35_B0BD3DE78D2A#135370, COL_A3644F3E_0D2F_4A06_A6FE_1A4FD7E3FB39#135371, COL_A2BECAE4_1350_4597_8721_6D25DB616635#135372, COL_CD29F452_4E41_4A81_99C0_3A9914B3299D#135373, COL_3FC0C414_AA21_4D9D_9AEA_27F86B234A86#135374, COL_61B8AC70_1B93_419C_A3E2_102A864B3280#135375]
Arguments: [COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(14) Window
Input [55]: [COL_BDDD46A4_898A_46D0_BF9B_C8BDFD746148#135321, COL_112BF58B_E911_46A2_8CA3_F6BFD5487579#135322, COL_04CE5AE8_BD39_4552_A33A_7B2C61DB9DD8#135323, COL_CC4AD334_C6F3_41DC_BDFF_CA980FFD3103#135324, COL_E69D8529_33F6_4429_BC58_D9698BF43562#135325, COL_A524D044_4115_4EE1_A8D8_247AAAD9E865#135326, COL_C55F8B0B_76B6_41EB_ADA7_B2FAAEBC9DFD#135327, COL_FBA805A9_48CA_4000_8AA3_998A562DE4E8#135328, COL_F0DBA7B9_11A3_4000_A26C_25F26BA2E9AA#135329, COL_FF182A2D_F1FD_4A7D_9AC0_67C34229FD64#135330, COL_5630B852_23CF_4C16_983F_69061354A034#135331, COL_22BEBE7F_9399_4512_9B79_1F24D9CA5C4D#135332, COL_D6D62F83_1651_43DE_A301_70E2648D65C0#135333, COL_9EF97016_78F9_4ACA_B680_526303781A4D#135334, COL_0B6D2DDD_1396_40A5_BC34_E1607A996FCF#135335, COL_6A763AB2_89BB_4758_BFC3_D9EFE73A1A7F#135336, COL_E54617EF_8ABA_4DA5_BE7A_D1B1DA88B241#135337, COL_08BA1D86_CB77_4294_B113_11DE299A15B0#135338, COL_59FD146E_C36E_4942_997C_23DFD8C14823#135339, COL_B5BDC057_DDE0_46D1_99DC_B1B7B729228E#135340, COL_8771C528_8E8F_4BBD_8130_45C0B95832BC#135341, COL_BD6164EB_302B_48FF_A1C3_F9478E4424D6#135342, COL_9FDC40A3_05F1_4E6E_9E28_D6C6C713E9E4#135343, COL_00FE6DB8_28B4_4067_9010_D825E080B8D4#135344, COL_D74020B3_0DA5_40AC_A47C_11416AC28AF4#135345, COL_D6094745_F373_4BC5_989E_5CF535CFCBB5#135346, COL_89F38B9C_F688_4EF4_BDBE_C91D1F850C38#135347, COL_F1B016E2_4B2D_4662_84F7_FDFFEF4DA77D#135348, COL_34BD3744_B4A8_4EC7_BFC0_0C5A40F1C327#135349, COL_BD669204_86B3_4535_A501_BE61CA1FA1E7#135350, COL_762064E2_E380_4F66_8654_4E2A4E6F10EC#135351, COL_D2A1070D_1A38_4AC9_B0C3_AF39D0FE8B98#135352, COL_56232655_74C2_472C_BE05_4C82BD2AD03F#135353, COL_B2D747F9_A7DA_431E_8137_303431EF82C0#135354, COL_7F4EA0F4_47F8_472E_B602_EF9B6F33DCF1#135355, COL_CE24648B_5C53_473A_86BA_1B425D6D4B60#135356, COL_46D16570_A31B_40CE_8FAE_2908C4E4431A#135357, COL_4E1FD930_1CDF_430C_994E_8E65963C7F7D#135358, COL_F69ABF00_2F53_43DD_9C29_8913549D724E#135359L, COL_14928EC1_3619_418E_A05E_FAA96E7AFD98#135360, COL_485383C3_A25B_4F35_A5C0_8D577B11C7B2#135361, COL_BC40A0F2_B6A4_4987_B401_A0611EBA19FF#135362, COL_9F8EB11D_CC94_41D1_BC9B_75A2B62F1ED0#135363, COL_807020CE_20A5_41C4_AE2B_10B99D472FA2#135364, COL_23B332B1_5432_4C70_A9F0_E9F65D9F5480#135365, COL_ECF7F350_45ED_4F11_9C26_DF0672965A4D#135366, COL_68C11010_06FC_40D9_A241_778AA8AE588D#135367, COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368, COL_B1616C39_761D_4EC9_A694_7CDDA1510A6C#135369, COL_450A716A_1E80_4B2E_BF35_B0BD3DE78D2A#135370, COL_A3644F3E_0D2F_4A06_A6FE_1A4FD7E3FB39#135371, COL_A2BECAE4_1350_4597_8721_6D25DB616635#135372, COL_CD29F452_4E41_4A81_99C0_3A9914B3299D#135373, COL_3FC0C414_AA21_4D9D_9AEA_27F86B234A86#135374, COL_61B8AC70_1B93_419C_A3E2_102A864B3280#135375]
Arguments: [sum(COL_B1616C39_761D_4EC9_A694_7CDDA1510A6C#135369) windowspecdefinition(COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_D966E020_40A5_4B41_B24F_4232E020D829#135490, avg(COL_B1616C39_761D_4EC9_A694_7CDDA1510A6C#135369) windowspecdefinition(COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_875AF143_68C5_428B_9C50_50F9977CE713#135664, avg(COL_14928EC1_3619_418E_A05E_FAA96E7AFD98#135360) windowspecdefinition(COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_1B6D0FE5_8D59_4DA4_BDA0_97D87621A96C#135841, avg(COL_807020CE_20A5_41C4_AE2B_10B99D472FA2#135364) windowspecdefinition(COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_F6C8888C_051F_4CA6_9982_DCCA73EC4144#136021, sum(COL_61B8AC70_1B93_419C_A3E2_102A864B3280#135375) windowspecdefinition(COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_C4B3810B_E130_4598_B8BD_A0CBB7213550#136204, count(1) windowspecdefinition(COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_59FA6040_6707_4B54_9108_CEDCF1D097AC#136391L, row_number() windowspecdefinition(COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_BB374D42_5C0B_4A05_AFD1_5C9C423D0535#136580], [COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368], [1 DESC NULLS LAST]

(15) Filter
Input [62]: [COL_BDDD46A4_898A_46D0_BF9B_C8BDFD746148#135321, COL_112BF58B_E911_46A2_8CA3_F6BFD5487579#135322, COL_04CE5AE8_BD39_4552_A33A_7B2C61DB9DD8#135323, COL_CC4AD334_C6F3_41DC_BDFF_CA980FFD3103#135324, COL_E69D8529_33F6_4429_BC58_D9698BF43562#135325, COL_A524D044_4115_4EE1_A8D8_247AAAD9E865#135326, COL_C55F8B0B_76B6_41EB_ADA7_B2FAAEBC9DFD#135327, COL_FBA805A9_48CA_4000_8AA3_998A562DE4E8#135328, COL_F0DBA7B9_11A3_4000_A26C_25F26BA2E9AA#135329, COL_FF182A2D_F1FD_4A7D_9AC0_67C34229FD64#135330, COL_5630B852_23CF_4C16_983F_69061354A034#135331, COL_22BEBE7F_9399_4512_9B79_1F24D9CA5C4D#135332, COL_D6D62F83_1651_43DE_A301_70E2648D65C0#135333, COL_9EF97016_78F9_4ACA_B680_526303781A4D#135334, COL_0B6D2DDD_1396_40A5_BC34_E1607A996FCF#135335, COL_6A763AB2_89BB_4758_BFC3_D9EFE73A1A7F#135336, COL_E54617EF_8ABA_4DA5_BE7A_D1B1DA88B241#135337, COL_08BA1D86_CB77_4294_B113_11DE299A15B0#135338, COL_59FD146E_C36E_4942_997C_23DFD8C14823#135339, COL_B5BDC057_DDE0_46D1_99DC_B1B7B729228E#135340, COL_8771C528_8E8F_4BBD_8130_45C0B95832BC#135341, COL_BD6164EB_302B_48FF_A1C3_F9478E4424D6#135342, COL_9FDC40A3_05F1_4E6E_9E28_D6C6C713E9E4#135343, COL_00FE6DB8_28B4_4067_9010_D825E080B8D4#135344, COL_D74020B3_0DA5_40AC_A47C_11416AC28AF4#135345, COL_D6094745_F373_4BC5_989E_5CF535CFCBB5#135346, COL_89F38B9C_F688_4EF4_BDBE_C91D1F850C38#135347, COL_F1B016E2_4B2D_4662_84F7_FDFFEF4DA77D#135348, COL_34BD3744_B4A8_4EC7_BFC0_0C5A40F1C327#135349, COL_BD669204_86B3_4535_A501_BE61CA1FA1E7#135350, COL_762064E2_E380_4F66_8654_4E2A4E6F10EC#135351, COL_D2A1070D_1A38_4AC9_B0C3_AF39D0FE8B98#135352, COL_56232655_74C2_472C_BE05_4C82BD2AD03F#135353, COL_B2D747F9_A7DA_431E_8137_303431EF82C0#135354, COL_7F4EA0F4_47F8_472E_B602_EF9B6F33DCF1#135355, COL_CE24648B_5C53_473A_86BA_1B425D6D4B60#135356, COL_46D16570_A31B_40CE_8FAE_2908C4E4431A#135357, COL_4E1FD930_1CDF_430C_994E_8E65963C7F7D#135358, COL_F69ABF00_2F53_43DD_9C29_8913549D724E#135359L, COL_14928EC1_3619_418E_A05E_FAA96E7AFD98#135360, COL_485383C3_A25B_4F35_A5C0_8D577B11C7B2#135361, COL_BC40A0F2_B6A4_4987_B401_A0611EBA19FF#135362, COL_9F8EB11D_CC94_41D1_BC9B_75A2B62F1ED0#135363, COL_807020CE_20A5_41C4_AE2B_10B99D472FA2#135364, COL_23B332B1_5432_4C70_A9F0_E9F65D9F5480#135365, COL_ECF7F350_45ED_4F11_9C26_DF0672965A4D#135366, COL_68C11010_06FC_40D9_A241_778AA8AE588D#135367, COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368, COL_B1616C39_761D_4EC9_A694_7CDDA1510A6C#135369, COL_450A716A_1E80_4B2E_BF35_B0BD3DE78D2A#135370, COL_A3644F3E_0D2F_4A06_A6FE_1A4FD7E3FB39#135371, COL_A2BECAE4_1350_4597_8721_6D25DB616635#135372, COL_CD29F452_4E41_4A81_99C0_3A9914B3299D#135373, COL_3FC0C414_AA21_4D9D_9AEA_27F86B234A86#135374, COL_61B8AC70_1B93_419C_A3E2_102A864B3280#135375, COL_D966E020_40A5_4B41_B24F_4232E020D829#135490, COL_875AF143_68C5_428B_9C50_50F9977CE713#135664, COL_1B6D0FE5_8D59_4DA4_BDA0_97D87621A96C#135841, COL_F6C8888C_051F_4CA6_9982_DCCA73EC4144#136021, COL_C4B3810B_E130_4598_B8BD_A0CBB7213550#136204, COL_59FA6040_6707_4B54_9108_CEDCF1D097AC#136391L, COL_BB374D42_5C0B_4A05_AFD1_5C9C423D0535#136580]
Condition : (((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BDDD46A4_898A_46D0_BF9B_C8BDFD746148#135321)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BDDD46A4_898A_46D0_BF9B_C8BDFD746148#135321)), MAISON) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_112BF58B_E911_46A2_8CA3_F6BFD5487579#135322)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_112BF58B_E911_46A2_8CA3_F6BFD5487579#135322)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_04CE5AE8_BD39_4552_A33A_7B2C61DB9DD8#135323)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_04CE5AE8_BD39_4552_A33A_7B2C61DB9DD8#135323)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CC4AD334_C6F3_41DC_BDFF_CA980FFD3103#135324)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_CC4AD334_C6F3_41DC_BDFF_CA980FFD3103#135324)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E69D8529_33F6_4429_BC58_D9698BF43562#135325)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_E69D8529_33F6_4429_BC58_D9698BF43562#135325)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A524D044_4115_4EE1_A8D8_247AAAD9E865#135326)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_A524D044_4115_4EE1_A8D8_247AAAD9E865#135326)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C55F8B0B_76B6_41EB_ADA7_B2FAAEBC9DFD#135327)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_C55F8B0B_76B6_41EB_ADA7_B2FAAEBC9DFD#135327)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FBA805A9_48CA_4000_8AA3_998A562DE4E8#135328)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_FBA805A9_48CA_4000_8AA3_998A562DE4E8#135328)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F0DBA7B9_11A3_4000_A26C_25F26BA2E9AA#135329)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_F0DBA7B9_11A3_4000_A26C_25F26BA2E9AA#135329)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FF182A2D_F1FD_4A7D_9AC0_67C34229FD64#135330)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_FF182A2D_F1FD_4A7D_9AC0_67C34229FD64#135330)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5630B852_23CF_4C16_983F_69061354A034#135331)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_5630B852_23CF_4C16_983F_69061354A034#135331)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_22BEBE7F_9399_4512_9B79_1F24D9CA5C4D#135332)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_22BEBE7F_9399_4512_9B79_1F24D9CA5C4D#135332)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D6D62F83_1651_43DE_A301_70E2648D65C0#135333)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D6D62F83_1651_43DE_A301_70E2648D65C0#135333)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9EF97016_78F9_4ACA_B680_526303781A4D#135334)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9EF97016_78F9_4ACA_B680_526303781A4D#135334)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0B6D2DDD_1396_40A5_BC34_E1607A996FCF#135335)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0B6D2DDD_1396_40A5_BC34_E1607A996FCF#135335)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_6A763AB2_89BB_4758_BFC3_D9EFE73A1A7F#135336)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_6A763AB2_89BB_4758_BFC3_D9EFE73A1A7F#135336)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E54617EF_8ABA_4DA5_BE7A_D1B1DA88B241#135337)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_E54617EF_8ABA_4DA5_BE7A_D1B1DA88B241#135337)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_08BA1D86_CB77_4294_B113_11DE299A15B0#135338)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_08BA1D86_CB77_4294_B113_11DE299A15B0#135338)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_59FD146E_C36E_4942_997C_23DFD8C14823#135339)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_59FD146E_C36E_4942_997C_23DFD8C14823#135339)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B5BDC057_DDE0_46D1_99DC_B1B7B729228E#135340)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_B5BDC057_DDE0_46D1_99DC_B1B7B729228E#135340)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8771C528_8E8F_4BBD_8130_45C0B95832BC#135341)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_8771C528_8E8F_4BBD_8130_45C0B95832BC#135341)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BD6164EB_302B_48FF_A1C3_F9478E4424D6#135342)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BD6164EB_302B_48FF_A1C3_F9478E4424D6#135342)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9FDC40A3_05F1_4E6E_9E28_D6C6C713E9E4#135343)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9FDC40A3_05F1_4E6E_9E28_D6C6C713E9E4#135343)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_00FE6DB8_28B4_4067_9010_D825E080B8D4#135344)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_00FE6DB8_28B4_4067_9010_D825E080B8D4#135344)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D74020B3_0DA5_40AC_A47C_11416AC28AF4#135345)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D74020B3_0DA5_40AC_A47C_11416AC28AF4#135345)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D6094745_F373_4BC5_989E_5CF535CFCBB5#135346)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D6094745_F373_4BC5_989E_5CF535CFCBB5#135346)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_89F38B9C_F688_4EF4_BDBE_C91D1F850C38#135347)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_89F38B9C_F688_4EF4_BDBE_C91D1F850C38#135347)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F1B016E2_4B2D_4662_84F7_FDFFEF4DA77D#135348)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_F1B016E2_4B2D_4662_84F7_FDFFEF4DA77D#135348)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_34BD3744_B4A8_4EC7_BFC0_0C5A40F1C327#135349)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_34BD3744_B4A8_4EC7_BFC0_0C5A40F1C327#135349)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BD669204_86B3_4535_A501_BE61CA1FA1E7#135350)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_BD669204_86B3_4535_A501_BE61CA1FA1E7#135350)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_762064E2_E380_4F66_8654_4E2A4E6F10EC#135351)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_762064E2_E380_4F66_8654_4E2A4E6F10EC#135351)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D2A1070D_1A38_4AC9_B0C3_AF39D0FE8B98#135352)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D2A1070D_1A38_4AC9_B0C3_AF39D0FE8B98#135352)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_56232655_74C2_472C_BE05_4C82BD2AD03F#135353)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_56232655_74C2_472C_BE05_4C82BD2AD03F#135353)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B2D747F9_A7DA_431E_8137_303431EF82C0#135354)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_B2D747F9_A7DA_431E_8137_303431EF82C0#135354)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_7F4EA0F4_47F8_472E_B602_EF9B6F33DCF1#135355)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_7F4EA0F4_47F8_472E_B602_EF9B6F33DCF1#135355)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CE24648B_5C53_473A_86BA_1B425D6D4B60#135356)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_CE24648B_5C53_473A_86BA_1B425D6D4B60#135356)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_46D16570_A31B_40CE_8FAE_2908C4E4431A#135357)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_46D16570_A31B_40CE_8FAE_2908C4E4431A#135357)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_4E1FD930_1CDF_430C_994E_8E65963C7F7D#135358)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_4E1FD930_1CDF_430C_994E_8E65963C7F7D#135358)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_450A716A_1E80_4B2E_BF35_B0BD3DE78D2A#135370)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_450A716A_1E80_4B2E_BF35_B0BD3DE78D2A#135370)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A3644F3E_0D2F_4A06_A6FE_1A4FD7E3FB39#135371)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_A3644F3E_0D2F_4A06_A6FE_1A4FD7E3FB39#135371)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A2BECAE4_1350_4597_8721_6D25DB616635#135372)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_A2BECAE4_1350_4597_8721_6D25DB616635#135372)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CD29F452_4E41_4A81_99C0_3A9914B3299D#135373)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_CD29F452_4E41_4A81_99C0_3A9914B3299D#135373)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_3FC0C414_AA21_4D9D_9AEA_27F86B234A86#135374)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_3FC0C414_AA21_4D9D_9AEA_27F86B234A86#135374)), MAISON) END)

(16) Project
Output [62]: [COL_BDDD46A4_898A_46D0_BF9B_C8BDFD746148#135321, COL_112BF58B_E911_46A2_8CA3_F6BFD5487579#135322, COL_04CE5AE8_BD39_4552_A33A_7B2C61DB9DD8#135323, COL_CC4AD334_C6F3_41DC_BDFF_CA980FFD3103#135324, COL_E69D8529_33F6_4429_BC58_D9698BF43562#135325, COL_A524D044_4115_4EE1_A8D8_247AAAD9E865#135326, COL_C55F8B0B_76B6_41EB_ADA7_B2FAAEBC9DFD#135327, COL_FBA805A9_48CA_4000_8AA3_998A562DE4E8#135328, COL_F0DBA7B9_11A3_4000_A26C_25F26BA2E9AA#135329, COL_FF182A2D_F1FD_4A7D_9AC0_67C34229FD64#135330, COL_5630B852_23CF_4C16_983F_69061354A034#135331, COL_22BEBE7F_9399_4512_9B79_1F24D9CA5C4D#135332, COL_D6D62F83_1651_43DE_A301_70E2648D65C0#135333, COL_9EF97016_78F9_4ACA_B680_526303781A4D#135334, COL_0B6D2DDD_1396_40A5_BC34_E1607A996FCF#135335, COL_6A763AB2_89BB_4758_BFC3_D9EFE73A1A7F#135336, COL_E54617EF_8ABA_4DA5_BE7A_D1B1DA88B241#135337, COL_08BA1D86_CB77_4294_B113_11DE299A15B0#135338, COL_59FD146E_C36E_4942_997C_23DFD8C14823#135339, COL_B5BDC057_DDE0_46D1_99DC_B1B7B729228E#135340, COL_8771C528_8E8F_4BBD_8130_45C0B95832BC#135341, COL_BD6164EB_302B_48FF_A1C3_F9478E4424D6#135342, COL_9FDC40A3_05F1_4E6E_9E28_D6C6C713E9E4#135343, COL_00FE6DB8_28B4_4067_9010_D825E080B8D4#135344, COL_D74020B3_0DA5_40AC_A47C_11416AC28AF4#135345, COL_D6094745_F373_4BC5_989E_5CF535CFCBB5#135346, COL_89F38B9C_F688_4EF4_BDBE_C91D1F850C38#135347, COL_F1B016E2_4B2D_4662_84F7_FDFFEF4DA77D#135348, COL_34BD3744_B4A8_4EC7_BFC0_0C5A40F1C327#135349, COL_BD669204_86B3_4535_A501_BE61CA1FA1E7#135350, COL_762064E2_E380_4F66_8654_4E2A4E6F10EC#135351, COL_D2A1070D_1A38_4AC9_B0C3_AF39D0FE8B98#135352, COL_56232655_74C2_472C_BE05_4C82BD2AD03F#135353, COL_B2D747F9_A7DA_431E_8137_303431EF82C0#135354, COL_7F4EA0F4_47F8_472E_B602_EF9B6F33DCF1#135355, COL_CE24648B_5C53_473A_86BA_1B425D6D4B60#135356, COL_46D16570_A31B_40CE_8FAE_2908C4E4431A#135357, COL_4E1FD930_1CDF_430C_994E_8E65963C7F7D#135358, COL_F69ABF00_2F53_43DD_9C29_8913549D724E#135359L, COL_14928EC1_3619_418E_A05E_FAA96E7AFD98#135360, COL_485383C3_A25B_4F35_A5C0_8D577B11C7B2#135361, COL_BC40A0F2_B6A4_4987_B401_A0611EBA19FF#135362, COL_9F8EB11D_CC94_41D1_BC9B_75A2B62F1ED0#135363, COL_807020CE_20A5_41C4_AE2B_10B99D472FA2#135364, COL_23B332B1_5432_4C70_A9F0_E9F65D9F5480#135365, COL_ECF7F350_45ED_4F11_9C26_DF0672965A4D#135366, COL_68C11010_06FC_40D9_A241_778AA8AE588D#135367, COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368, COL_B1616C39_761D_4EC9_A694_7CDDA1510A6C#135369, COL_450A716A_1E80_4B2E_BF35_B0BD3DE78D2A#135370, COL_A3644F3E_0D2F_4A06_A6FE_1A4FD7E3FB39#135371, COL_A2BECAE4_1350_4597_8721_6D25DB616635#135372, COL_CD29F452_4E41_4A81_99C0_3A9914B3299D#135373, COL_3FC0C414_AA21_4D9D_9AEA_27F86B234A86#135374, COL_D966E020_40A5_4B41_B24F_4232E020D829#135490, round(COL_875AF143_68C5_428B_9C50_50F9977CE713#135664, 2) AS COL_875AF143_68C5_428B_9C50_50F9977CE713#136761, round(COL_1B6D0FE5_8D59_4DA4_BDA0_97D87621A96C#135841, 2) AS COL_1B6D0FE5_8D59_4DA4_BDA0_97D87621A96C#136762, round(COL_F6C8888C_051F_4CA6_9982_DCCA73EC4144#136021, 2) AS COL_F6C8888C_051F_4CA6_9982_DCCA73EC4144#136763, COL_59FA6040_6707_4B54_9108_CEDCF1D097AC#136391L, COL_BB374D42_5C0B_4A05_AFD1_5C9C423D0535#136580, COL_61B8AC70_1B93_419C_A3E2_102A864B3280#135375, round(COL_C4B3810B_E130_4598_B8BD_A0CBB7213550#136204, 2) AS COL_C4B3810B_E130_4598_B8BD_A0CBB7213550#136767]
Input [62]: [COL_BDDD46A4_898A_46D0_BF9B_C8BDFD746148#135321, COL_112BF58B_E911_46A2_8CA3_F6BFD5487579#135322, COL_04CE5AE8_BD39_4552_A33A_7B2C61DB9DD8#135323, COL_CC4AD334_C6F3_41DC_BDFF_CA980FFD3103#135324, COL_E69D8529_33F6_4429_BC58_D9698BF43562#135325, COL_A524D044_4115_4EE1_A8D8_247AAAD9E865#135326, COL_C55F8B0B_76B6_41EB_ADA7_B2FAAEBC9DFD#135327, COL_FBA805A9_48CA_4000_8AA3_998A562DE4E8#135328, COL_F0DBA7B9_11A3_4000_A26C_25F26BA2E9AA#135329, COL_FF182A2D_F1FD_4A7D_9AC0_67C34229FD64#135330, COL_5630B852_23CF_4C16_983F_69061354A034#135331, COL_22BEBE7F_9399_4512_9B79_1F24D9CA5C4D#135332, COL_D6D62F83_1651_43DE_A301_70E2648D65C0#135333, COL_9EF97016_78F9_4ACA_B680_526303781A4D#135334, COL_0B6D2DDD_1396_40A5_BC34_E1607A996FCF#135335, COL_6A763AB2_89BB_4758_BFC3_D9EFE73A1A7F#135336, COL_E54617EF_8ABA_4DA5_BE7A_D1B1DA88B241#135337, COL_08BA1D86_CB77_4294_B113_11DE299A15B0#135338, COL_59FD146E_C36E_4942_997C_23DFD8C14823#135339, COL_B5BDC057_DDE0_46D1_99DC_B1B7B729228E#135340, COL_8771C528_8E8F_4BBD_8130_45C0B95832BC#135341, COL_BD6164EB_302B_48FF_A1C3_F9478E4424D6#135342, COL_9FDC40A3_05F1_4E6E_9E28_D6C6C713E9E4#135343, COL_00FE6DB8_28B4_4067_9010_D825E080B8D4#135344, COL_D74020B3_0DA5_40AC_A47C_11416AC28AF4#135345, COL_D6094745_F373_4BC5_989E_5CF535CFCBB5#135346, COL_89F38B9C_F688_4EF4_BDBE_C91D1F850C38#135347, COL_F1B016E2_4B2D_4662_84F7_FDFFEF4DA77D#135348, COL_34BD3744_B4A8_4EC7_BFC0_0C5A40F1C327#135349, COL_BD669204_86B3_4535_A501_BE61CA1FA1E7#135350, COL_762064E2_E380_4F66_8654_4E2A4E6F10EC#135351, COL_D2A1070D_1A38_4AC9_B0C3_AF39D0FE8B98#135352, COL_56232655_74C2_472C_BE05_4C82BD2AD03F#135353, COL_B2D747F9_A7DA_431E_8137_303431EF82C0#135354, COL_7F4EA0F4_47F8_472E_B602_EF9B6F33DCF1#135355, COL_CE24648B_5C53_473A_86BA_1B425D6D4B60#135356, COL_46D16570_A31B_40CE_8FAE_2908C4E4431A#135357, COL_4E1FD930_1CDF_430C_994E_8E65963C7F7D#135358, COL_F69ABF00_2F53_43DD_9C29_8913549D724E#135359L, COL_14928EC1_3619_418E_A05E_FAA96E7AFD98#135360, COL_485383C3_A25B_4F35_A5C0_8D577B11C7B2#135361, COL_BC40A0F2_B6A4_4987_B401_A0611EBA19FF#135362, COL_9F8EB11D_CC94_41D1_BC9B_75A2B62F1ED0#135363, COL_807020CE_20A5_41C4_AE2B_10B99D472FA2#135364, COL_23B332B1_5432_4C70_A9F0_E9F65D9F5480#135365, COL_ECF7F350_45ED_4F11_9C26_DF0672965A4D#135366, COL_68C11010_06FC_40D9_A241_778AA8AE588D#135367, COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368, COL_B1616C39_761D_4EC9_A694_7CDDA1510A6C#135369, COL_450A716A_1E80_4B2E_BF35_B0BD3DE78D2A#135370, COL_A3644F3E_0D2F_4A06_A6FE_1A4FD7E3FB39#135371, COL_A2BECAE4_1350_4597_8721_6D25DB616635#135372, COL_CD29F452_4E41_4A81_99C0_3A9914B3299D#135373, COL_3FC0C414_AA21_4D9D_9AEA_27F86B234A86#135374, COL_61B8AC70_1B93_419C_A3E2_102A864B3280#135375, COL_D966E020_40A5_4B41_B24F_4232E020D829#135490, COL_875AF143_68C5_428B_9C50_50F9977CE713#135664, COL_1B6D0FE5_8D59_4DA4_BDA0_97D87621A96C#135841, COL_F6C8888C_051F_4CA6_9982_DCCA73EC4144#136021, COL_C4B3810B_E130_4598_B8BD_A0CBB7213550#136204, COL_59FA6040_6707_4B54_9108_CEDCF1D097AC#136391L, COL_BB374D42_5C0B_4A05_AFD1_5C9C423D0535#136580]

(17) CollectLimit
Input [62]: [COL_BDDD46A4_898A_46D0_BF9B_C8BDFD746148#135321, COL_112BF58B_E911_46A2_8CA3_F6BFD5487579#135322, COL_04CE5AE8_BD39_4552_A33A_7B2C61DB9DD8#135323, COL_CC4AD334_C6F3_41DC_BDFF_CA980FFD3103#135324, COL_E69D8529_33F6_4429_BC58_D9698BF43562#135325, COL_A524D044_4115_4EE1_A8D8_247AAAD9E865#135326, COL_C55F8B0B_76B6_41EB_ADA7_B2FAAEBC9DFD#135327, COL_FBA805A9_48CA_4000_8AA3_998A562DE4E8#135328, COL_F0DBA7B9_11A3_4000_A26C_25F26BA2E9AA#135329, COL_FF182A2D_F1FD_4A7D_9AC0_67C34229FD64#135330, COL_5630B852_23CF_4C16_983F_69061354A034#135331, COL_22BEBE7F_9399_4512_9B79_1F24D9CA5C4D#135332, COL_D6D62F83_1651_43DE_A301_70E2648D65C0#135333, COL_9EF97016_78F9_4ACA_B680_526303781A4D#135334, COL_0B6D2DDD_1396_40A5_BC34_E1607A996FCF#135335, COL_6A763AB2_89BB_4758_BFC3_D9EFE73A1A7F#135336, COL_E54617EF_8ABA_4DA5_BE7A_D1B1DA88B241#135337, COL_08BA1D86_CB77_4294_B113_11DE299A15B0#135338, COL_59FD146E_C36E_4942_997C_23DFD8C14823#135339, COL_B5BDC057_DDE0_46D1_99DC_B1B7B729228E#135340, COL_8771C528_8E8F_4BBD_8130_45C0B95832BC#135341, COL_BD6164EB_302B_48FF_A1C3_F9478E4424D6#135342, COL_9FDC40A3_05F1_4E6E_9E28_D6C6C713E9E4#135343, COL_00FE6DB8_28B4_4067_9010_D825E080B8D4#135344, COL_D74020B3_0DA5_40AC_A47C_11416AC28AF4#135345, COL_D6094745_F373_4BC5_989E_5CF535CFCBB5#135346, COL_89F38B9C_F688_4EF4_BDBE_C91D1F850C38#135347, COL_F1B016E2_4B2D_4662_84F7_FDFFEF4DA77D#135348, COL_34BD3744_B4A8_4EC7_BFC0_0C5A40F1C327#135349, COL_BD669204_86B3_4535_A501_BE61CA1FA1E7#135350, COL_762064E2_E380_4F66_8654_4E2A4E6F10EC#135351, COL_D2A1070D_1A38_4AC9_B0C3_AF39D0FE8B98#135352, COL_56232655_74C2_472C_BE05_4C82BD2AD03F#135353, COL_B2D747F9_A7DA_431E_8137_303431EF82C0#135354, COL_7F4EA0F4_47F8_472E_B602_EF9B6F33DCF1#135355, COL_CE24648B_5C53_473A_86BA_1B425D6D4B60#135356, COL_46D16570_A31B_40CE_8FAE_2908C4E4431A#135357, COL_4E1FD930_1CDF_430C_994E_8E65963C7F7D#135358, COL_F69ABF00_2F53_43DD_9C29_8913549D724E#135359L, COL_14928EC1_3619_418E_A05E_FAA96E7AFD98#135360, COL_485383C3_A25B_4F35_A5C0_8D577B11C7B2#135361, COL_BC40A0F2_B6A4_4987_B401_A0611EBA19FF#135362, COL_9F8EB11D_CC94_41D1_BC9B_75A2B62F1ED0#135363, COL_807020CE_20A5_41C4_AE2B_10B99D472FA2#135364, COL_23B332B1_5432_4C70_A9F0_E9F65D9F5480#135365, COL_ECF7F350_45ED_4F11_9C26_DF0672965A4D#135366, COL_68C11010_06FC_40D9_A241_778AA8AE588D#135367, COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368, COL_B1616C39_761D_4EC9_A694_7CDDA1510A6C#135369, COL_450A716A_1E80_4B2E_BF35_B0BD3DE78D2A#135370, COL_A3644F3E_0D2F_4A06_A6FE_1A4FD7E3FB39#135371, COL_A2BECAE4_1350_4597_8721_6D25DB616635#135372, COL_CD29F452_4E41_4A81_99C0_3A9914B3299D#135373, COL_3FC0C414_AA21_4D9D_9AEA_27F86B234A86#135374, COL_D966E020_40A5_4B41_B24F_4232E020D829#135490, COL_875AF143_68C5_428B_9C50_50F9977CE713#136761, COL_1B6D0FE5_8D59_4DA4_BDA0_97D87621A96C#136762, COL_F6C8888C_051F_4CA6_9982_DCCA73EC4144#136763, COL_59FA6040_6707_4B54_9108_CEDCF1D097AC#136391L, COL_BB374D42_5C0B_4A05_AFD1_5C9C423D0535#136580, COL_61B8AC70_1B93_419C_A3E2_102A864B3280#135375, COL_C4B3810B_E130_4598_B8BD_A0CBB7213550#136767]
Arguments: 1500

(18) AdaptiveSparkPlan
Output [62]: [COL_BDDD46A4_898A_46D0_BF9B_C8BDFD746148#135321, COL_112BF58B_E911_46A2_8CA3_F6BFD5487579#135322, COL_04CE5AE8_BD39_4552_A33A_7B2C61DB9DD8#135323, COL_CC4AD334_C6F3_41DC_BDFF_CA980FFD3103#135324, COL_E69D8529_33F6_4429_BC58_D9698BF43562#135325, COL_A524D044_4115_4EE1_A8D8_247AAAD9E865#135326, COL_C55F8B0B_76B6_41EB_ADA7_B2FAAEBC9DFD#135327, COL_FBA805A9_48CA_4000_8AA3_998A562DE4E8#135328, COL_F0DBA7B9_11A3_4000_A26C_25F26BA2E9AA#135329, COL_FF182A2D_F1FD_4A7D_9AC0_67C34229FD64#135330, COL_5630B852_23CF_4C16_983F_69061354A034#135331, COL_22BEBE7F_9399_4512_9B79_1F24D9CA5C4D#135332, COL_D6D62F83_1651_43DE_A301_70E2648D65C0#135333, COL_9EF97016_78F9_4ACA_B680_526303781A4D#135334, COL_0B6D2DDD_1396_40A5_BC34_E1607A996FCF#135335, COL_6A763AB2_89BB_4758_BFC3_D9EFE73A1A7F#135336, COL_E54617EF_8ABA_4DA5_BE7A_D1B1DA88B241#135337, COL_08BA1D86_CB77_4294_B113_11DE299A15B0#135338, COL_59FD146E_C36E_4942_997C_23DFD8C14823#135339, COL_B5BDC057_DDE0_46D1_99DC_B1B7B729228E#135340, COL_8771C528_8E8F_4BBD_8130_45C0B95832BC#135341, COL_BD6164EB_302B_48FF_A1C3_F9478E4424D6#135342, COL_9FDC40A3_05F1_4E6E_9E28_D6C6C713E9E4#135343, COL_00FE6DB8_28B4_4067_9010_D825E080B8D4#135344, COL_D74020B3_0DA5_40AC_A47C_11416AC28AF4#135345, COL_D6094745_F373_4BC5_989E_5CF535CFCBB5#135346, COL_89F38B9C_F688_4EF4_BDBE_C91D1F850C38#135347, COL_F1B016E2_4B2D_4662_84F7_FDFFEF4DA77D#135348, COL_34BD3744_B4A8_4EC7_BFC0_0C5A40F1C327#135349, COL_BD669204_86B3_4535_A501_BE61CA1FA1E7#135350, COL_762064E2_E380_4F66_8654_4E2A4E6F10EC#135351, COL_D2A1070D_1A38_4AC9_B0C3_AF39D0FE8B98#135352, COL_56232655_74C2_472C_BE05_4C82BD2AD03F#135353, COL_B2D747F9_A7DA_431E_8137_303431EF82C0#135354, COL_7F4EA0F4_47F8_472E_B602_EF9B6F33DCF1#135355, COL_CE24648B_5C53_473A_86BA_1B425D6D4B60#135356, COL_46D16570_A31B_40CE_8FAE_2908C4E4431A#135357, COL_4E1FD930_1CDF_430C_994E_8E65963C7F7D#135358, COL_F69ABF00_2F53_43DD_9C29_8913549D724E#135359L, COL_14928EC1_3619_418E_A05E_FAA96E7AFD98#135360, COL_485383C3_A25B_4F35_A5C0_8D577B11C7B2#135361, COL_BC40A0F2_B6A4_4987_B401_A0611EBA19FF#135362, COL_9F8EB11D_CC94_41D1_BC9B_75A2B62F1ED0#135363, COL_807020CE_20A5_41C4_AE2B_10B99D472FA2#135364, COL_23B332B1_5432_4C70_A9F0_E9F65D9F5480#135365, COL_ECF7F350_45ED_4F11_9C26_DF0672965A4D#135366, COL_68C11010_06FC_40D9_A241_778AA8AE588D#135367, COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#135368, COL_B1616C39_761D_4EC9_A694_7CDDA1510A6C#135369, COL_450A716A_1E80_4B2E_BF35_B0BD3DE78D2A#135370, COL_A3644F3E_0D2F_4A06_A6FE_1A4FD7E3FB39#135371, COL_A2BECAE4_1350_4597_8721_6D25DB616635#135372, COL_CD29F452_4E41_4A81_99C0_3A9914B3299D#135373, COL_3FC0C414_AA21_4D9D_9AEA_27F86B234A86#135374, COL_D966E020_40A5_4B41_B24F_4232E020D829#135490, COL_875AF143_68C5_428B_9C50_50F9977CE713#136761, COL_1B6D0FE5_8D59_4DA4_BDA0_97D87621A96C#136762, COL_F6C8888C_051F_4CA6_9982_DCCA73EC4144#136763, COL_59FA6040_6707_4B54_9108_CEDCF1D097AC#136391L, COL_BB374D42_5C0B_4A05_AFD1_5C9C423D0535#136580, COL_61B8AC70_1B93_419C_A3E2_102A864B3280#135375, COL_C4B3810B_E130_4598_B8BD_A0CBB7213550#136767]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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