hdh-spark-job - Details for Query 1388

Submitted Time: 2026/10/23 13:28:34
Duration: 1 s
Succeeded Jobs: 1385 1391

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 (4)\n \nduration: 7 ms"; 2 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 0 ms peak memory: 64.2 MiB number of output rows: 46 number of sort fallback tasks: 0 avg hash probes per key: 1"]; } 3 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 13.8 KiB number of coalesced partitions: 1"]; 4 [labelType="html" label="Exchange shuffle records written: 92 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 2 ms (1 ms, 1 ms, 1 ms (stage 2005.0: task 1750)) 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: 92 local bytes read: 13.0 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 2 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 54.1 KiB (27.1 KiB, 27.1 KiB, 27.1 KiB (stage 2005.0: task 1750)) 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 total (min, med, max (stageId: taskId)) 13.0 KiB (6.5 KiB, 6.5 KiB, 6.5 KiB (stage 2005.0: task 1750))"]; subgraph cluster5 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n371 ms (184 ms, 187 ms, 187 ms (stage 2005.0: task 1750))"; 6 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 351 ms (174 ms, 177 ms, 177 ms (stage 2005.0: task 1750)) peak memory total (min, med, max (stageId: taskId)) 128.5 MiB (64.2 MiB, 64.2 MiB, 64.2 MiB (stage 2005.0: task 1750)) number of output rows: 92 number of sort fallback tasks: 0 avg hash probes per key (min, med, max (stageId: taskId)): (1, 1, 1 (stage 2005.0: task 1750))"]; } 7 [labelType="html" label=" Union "]; subgraph cluster8 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 186 ms"; 9 [labelType="html" label=" Project "]; 10 [labelType="html" label="Filter number of output rows: 46"]; 11 [labelType="html" label="Scan JDBCRelation((SELECT \"rg_codorg\", \"rg_typorg\", \"rg_nomorg\", \"rg_adr_1\", \"rg_adr_2\", \"rg_codpos\", \"rg_ville\", \"rg_telbur\", \"rg_fax\", \"rg_e_mail\", \"rg_prefix\", \"rg_contac\", \"rg_numbor\", \"rg_tauxre\", \"rg_codreg\", \"rg_codcai\", \"rg_codcen\", \"rg_fltele\", \"rg_datmaj\", \"rg_coduti\", \"rg_codccp\", \"rg_fltp\", \"rg_idmut\", \"rg_fltopr\", \"rg_numcpt\", \"rg_cmpimp_f\", \"rg_cmpimp_h\", \"rg_relctx\", \"rg_relpage\", \"rg_relref\", \"rg_datenv\", \"rg_datede\", \"rg_datefi\", \"rg_typoc\", \"rg_orgpayeur\", \"rg_adr_3\", \"rg_notrel\", \"rg_comment\", \"rg_flpecdep\", \"rg_numcpt_a\", \"rg_flpav\", \"rg_reclam\", \"rg_trirel\", \"rg_notbord\", \"rg_flchorus\", \"rg_numsir\", \"rg_flliseng\", \"rg_modreg\", \"rg_numcpt_c\", \"rg_numcpt_c_ft\" FROM \"xplore\".\"h_organ\") as x) [numPartitions=1] number of output rows: 6,195"]; } subgraph cluster12 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 182 ms"; 13 [labelType="html" label=" Project "]; 14 [labelType="html" label="Filter number of output rows: 46"]; 15 [labelType="html" label="Scan JDBCRelation((SELECT \"rg_codorg\", \"rg_typorg\", \"rg_nomorg\", \"rg_adr_1\", \"rg_adr_2\", \"rg_codpos\", \"rg_ville\", \"rg_telbur\", \"rg_fax\", \"rg_e_mail\", \"rg_prefix\", \"rg_contac\", \"rg_numbor\", \"rg_tauxre\", \"rg_codreg\", \"rg_codcai\", \"rg_codcen\", \"rg_fltele\", \"rg_datmaj\", \"rg_coduti\", \"rg_codccp\", \"rg_fltp\", \"rg_idmut\", \"rg_fltopr\", \"rg_numcpt\", \"rg_cmpimp_f\", \"rg_cmpimp_h\", \"rg_relctx\", \"rg_relpage\", \"rg_relref\", \"rg_datenv\", \"rg_datede\", \"rg_datefi\", \"rg_typoc\", \"rg_orgpayeur\", \"rg_adr_3\", \"rg_notrel\", \"rg_comment\", \"rg_flpecdep\", \"rg_numcpt_a\", \"rg_flpav\", \"rg_reclam\", \"rg_trirel\", \"rg_notbord\", \"rg_flchorus\", \"rg_numsir\", \"rg_flliseng\", \"rg_modreg\", \"rg_numcpt_c\", \"rg_numcpt_c_ft\" FROM \"xplore2\".\"h_organ\") as x) [numPartitions=1] number of output rows: 6,195"]; } 2->0; 3->2; 4->3; 6->4; 7->6; 9->7; 10->9; 11->10; 13->7; 14->13; 15->14; }

AdaptiveSparkPlan isFinalPlan=true

HashAggregate(keys=[ORIGINE_440148#700363, RG_ADR_1_437974#700364, RG_ADR_2_437975#700365, RG_ADR_3_438006#700366, RG_CMPIMP_F_437996#700367, RG_CMPIMP_H_437997#700368, RG_CODCAI_437986#700369, RG_CODCCP_437991#700370, RG_CODCEN_437987#700371, RG_CODORG_437971#700372, RG_CODPOS_437976#700373, RG_CODREG_437985#700374, RG_CODUTI_437990#700375, RG_COMMENT_438008#700376, RG_CONTAC_437982#700377, RG_DATEDE_438002#700378, RG_DATEFI_438003#700379, RG_DATENV_438001#700380, RG_DATMAJ_437989#700381, RG_E_MAIL_437980#700382, RG_FAX_437979#700383, RG_FLCHORUS_438015#700384, RG_FLLISENG_438017#700385, RG_FLPAV_438011#700386, ... 27 more fields], functions=[])

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(ORIGINE_440148#700363, RG_ADR_1_437974#700364, RG_ADR_2_437975#700365, RG_ADR_3_438006#700366, RG_CMPIMP_F_437996#700367, RG_CMPIMP_H_437997#700368, RG_CODCAI_437986#700369, RG_CODCCP_437991#700370, RG_CODCEN_437987#700371, RG_CODORG_437971#700372, RG_CODPOS_437976#700373, RG_CODREG_437985#700374, RG_CODUTI_437990#700375, RG_COMMENT_438008#700376, RG_CONTAC_437982#700377, RG_DATEDE_438002#700378, RG_DATEFI_438003#700379, RG_DATENV_438001#700380, RG_DATMAJ_437989#700381, RG_E_MAIL_437980#700382, RG_FAX_437979#700383, RG_FLCHORUS_438015#700384, RG_FLLISENG_438017#700385, RG_FLPAV_438011#700386, ... 28 more fields), ENSURE_REQUIREMENTS, [plan_id=37464]

WholeStageCodegen (3)

Union

Project [null AS ORIGINE_440148#700363, rg_adr_1#700016 AS RG_ADR_1_437974#700364, rg_adr_2#700017 AS RG_ADR_2_437975#700365, rg_adr_3#700048 AS RG_ADR_3_438006#700366, rg_cmpimp_f#700038 AS RG_CMPIMP_F_437996#700367, rg_cmpimp_h#700039 AS RG_CMPIMP_H_437997#700368, rg_codcai#700028 AS RG_CODCAI_437986#700369, rg_codccp#700033 AS RG_CODCCP_437991#700370, rg_codcen#700029 AS RG_CODCEN_437987#700371, rg_codorg#700013 AS RG_CODORG_437971#700372, rg_codpos#700018 AS RG_CODPOS_437976#700373, rg_codreg#700027 AS RG_CODREG_437985#700374, rg_coduti#700032 AS RG_CODUTI_437990#700375, rg_comment#700050 AS RG_COMMENT_438008#700376, rg_contac#700024 AS RG_CONTAC_437982#700377, rg_datede#700044 AS RG_DATEDE_438002#700378, rg_datefi#700045 AS RG_DATEFI_438003#700379, rg_datenv#700043 AS RG_DATENV_438001#700380, rg_datmaj#700031 AS RG_DATMAJ_437989#700381, rg_e_mail#700022 AS RG_E_MAIL_437980#700382, rg_fax#700021 AS RG_FAX_437979#700383, rg_flchorus#700057 AS RG_FLCHORUS_438015#700384, rg_flliseng#700059 AS RG_FLLISENG_438017#700385, rg_flpav#700053 AS RG_FLPAV_438011#700386, ... 27 more fields]

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codorg#700013)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codorg#700013)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typorg#700014)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_typorg#700014)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_nomorg#700015)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_nomorg#700015)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_1#700016)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_1#700016)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_2#700017)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_2#700017)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codpos#700018)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codpos#700018)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_ville#700019)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_ville#700019)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_telbur#700020)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_telbur#700020)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fax#700021)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fax#700021)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_e_mail#700022)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_e_mail#700022)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_prefix#700023)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_prefix#700023)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_contac#700024)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_contac#700024)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numbor#700025)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numbor#700025)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_tauxre#700026)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_tauxre#700026)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codreg#700027)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codreg#700027)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcai#700028)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcai#700028)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcen#700029)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcen#700029)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltele#700030)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltele#700030)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datmaj#700031)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datmaj#700031)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_coduti#700032)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_coduti#700032)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codccp#700033)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codccp#700033)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltp#700034)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltp#700034)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_idmut#700035)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_idmut#700035)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltopr#700036)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltopr#700036)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt#700037)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt#700037)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_f#700038)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_f#700038)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_h#700039)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_h#700039)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relctx#700040)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relctx#700040)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relpage#700041)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relpage#700041)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relref#700042)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relref#700042)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datenv#700043)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datenv#700043)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datede#700044)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datede#700044)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datefi#700045)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datefi#700045)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typoc#700046)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_typoc#700046)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_orgpayeur#700047)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_orgpayeur#700047)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_3#700048)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_3#700048)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notrel#700049)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_notrel#700049)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_comment#700050)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_comment#700050)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpecdep#700051)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpecdep#700051)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_a#700052)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_a#700052)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpav#700053)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpav#700053)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_reclam#700054)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_reclam#700054)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_trirel#700055)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_trirel#700055)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notbord#700056)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_notbord#700056)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flchorus#700057)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flchorus#700057)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numsir#700058)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numsir#700058)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flliseng#700059)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flliseng#700059)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_modreg#700060)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_modreg#700060)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c#700061)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c#700061)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c_ft#700062)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c_ft#700062)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(null), MAIN)) THEN false ELSE Contains(str_remove_accent(null), MAIN) END)

Scan JDBCRelation((SELECT "rg_codorg", "rg_typorg", "rg_nomorg", "rg_adr_1", "rg_adr_2", "rg_codpos", "rg_ville", "rg_telbur", "rg_fax", "rg_e_mail", "rg_prefix", "rg_contac", "rg_numbor", "rg_tauxre", "rg_codreg", "rg_codcai", "rg_codcen", "rg_fltele", "rg_datmaj", "rg_coduti", "rg_codccp", "rg_fltp", "rg_idmut", "rg_fltopr", "rg_numcpt", "rg_cmpimp_f", "rg_cmpimp_h", "rg_relctx", "rg_relpage", "rg_relref", "rg_datenv", "rg_datede", "rg_datefi", "rg_typoc", "rg_orgpayeur", "rg_adr_3", "rg_notrel", "rg_comment", "rg_flpecdep", "rg_numcpt_a", "rg_flpav", "rg_reclam", "rg_trirel", "rg_notbord", "rg_flchorus", "rg_numsir", "rg_flliseng", "rg_modreg", "rg_numcpt_c", "rg_numcpt_c_ft" FROM "xplore"."h_organ") as x) [numPartitions=1] [rg_adr_1#700016,rg_adr_2#700017,rg_adr_3#700048,rg_cmpimp_f#700038,rg_cmpimp_h#700039,rg_codcai#700028,rg_codccp#700033,rg_codcen#700029,rg_codorg#700013,rg_codpos#700018,rg_codreg#700027,rg_coduti#700032,rg_comment#700050,rg_contac#700024,rg_datede#700044,rg_datefi#700045,rg_datenv#700043,rg_datmaj#700031,rg_e_mail#700022,rg_fax#700021,rg_flchorus#700057,rg_flliseng#700059,rg_flpav#700053,rg_flpecdep#700051,... 26 more fields] PushedFilters: [], ReadSchema: struct<rg_adr_1:string,rg_adr_2:string,rg_adr_3:string,rg_cmpimp_f:string,rg_cmpimp_h:string,rg_c...

WholeStageCodegen (1)

Project [null AS ORIGINE_440148#700815, rg_adr_1#700468 AS RG_ADR_1_437974#700816, rg_adr_2#700469 AS RG_ADR_2_437975#700817, rg_adr_3#700500 AS RG_ADR_3_438006#700818, rg_cmpimp_f#700490 AS RG_CMPIMP_F_437996#700819, rg_cmpimp_h#700491 AS RG_CMPIMP_H_437997#700820, rg_codcai#700480 AS RG_CODCAI_437986#700821, rg_codccp#700485 AS RG_CODCCP_437991#700822, rg_codcen#700481 AS RG_CODCEN_437987#700823, rg_codorg#700465 AS RG_CODORG_437971#700824, rg_codpos#700470 AS RG_CODPOS_437976#700825, rg_codreg#700479 AS RG_CODREG_437985#700826, rg_coduti#700484 AS RG_CODUTI_437990#700827, rg_comment#700502 AS RG_COMMENT_438008#700828, rg_contac#700476 AS RG_CONTAC_437982#700829, rg_datede#700496 AS RG_DATEDE_438002#700830, rg_datefi#700497 AS RG_DATEFI_438003#700831, rg_datenv#700495 AS RG_DATENV_438001#700832, rg_datmaj#700483 AS RG_DATMAJ_437989#700833, rg_e_mail#700474 AS RG_E_MAIL_437980#700834, rg_fax#700473 AS RG_FAX_437979#700835, rg_flchorus#700509 AS RG_FLCHORUS_438015#700836, rg_flliseng#700511 AS RG_FLLISENG_438017#700837, rg_flpav#700505 AS RG_FLPAV_438011#700838, ... 27 more fields]

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codorg#700465)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codorg#700465)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typorg#700466)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_typorg#700466)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_nomorg#700467)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_nomorg#700467)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_1#700468)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_1#700468)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_2#700469)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_2#700469)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codpos#700470)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codpos#700470)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_ville#700471)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_ville#700471)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_telbur#700472)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_telbur#700472)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fax#700473)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fax#700473)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_e_mail#700474)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_e_mail#700474)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_prefix#700475)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_prefix#700475)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_contac#700476)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_contac#700476)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numbor#700477)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numbor#700477)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_tauxre#700478)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_tauxre#700478)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codreg#700479)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codreg#700479)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcai#700480)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcai#700480)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcen#700481)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcen#700481)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltele#700482)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltele#700482)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datmaj#700483)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datmaj#700483)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_coduti#700484)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_coduti#700484)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codccp#700485)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codccp#700485)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltp#700486)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltp#700486)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_idmut#700487)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_idmut#700487)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltopr#700488)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltopr#700488)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt#700489)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt#700489)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_f#700490)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_f#700490)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_h#700491)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_h#700491)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relctx#700492)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relctx#700492)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relpage#700493)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relpage#700493)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relref#700494)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relref#700494)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datenv#700495)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datenv#700495)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datede#700496)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datede#700496)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datefi#700497)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datefi#700497)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typoc#700498)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_typoc#700498)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_orgpayeur#700499)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_orgpayeur#700499)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_3#700500)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_3#700500)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notrel#700501)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_notrel#700501)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_comment#700502)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_comment#700502)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpecdep#700503)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpecdep#700503)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_a#700504)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_a#700504)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpav#700505)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpav#700505)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_reclam#700506)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_reclam#700506)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_trirel#700507)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_trirel#700507)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notbord#700508)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_notbord#700508)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flchorus#700509)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flchorus#700509)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numsir#700510)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numsir#700510)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flliseng#700511)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flliseng#700511)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_modreg#700512)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_modreg#700512)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c#700513)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c#700513)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c_ft#700514)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c_ft#700514)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(null), MAIN)) THEN false ELSE Contains(str_remove_accent(null), MAIN) END)

Scan JDBCRelation((SELECT "rg_codorg", "rg_typorg", "rg_nomorg", "rg_adr_1", "rg_adr_2", "rg_codpos", "rg_ville", "rg_telbur", "rg_fax", "rg_e_mail", "rg_prefix", "rg_contac", "rg_numbor", "rg_tauxre", "rg_codreg", "rg_codcai", "rg_codcen", "rg_fltele", "rg_datmaj", "rg_coduti", "rg_codccp", "rg_fltp", "rg_idmut", "rg_fltopr", "rg_numcpt", "rg_cmpimp_f", "rg_cmpimp_h", "rg_relctx", "rg_relpage", "rg_relref", "rg_datenv", "rg_datede", "rg_datefi", "rg_typoc", "rg_orgpayeur", "rg_adr_3", "rg_notrel", "rg_comment", "rg_flpecdep", "rg_numcpt_a", "rg_flpav", "rg_reclam", "rg_trirel", "rg_notbord", "rg_flchorus", "rg_numsir", "rg_flliseng", "rg_modreg", "rg_numcpt_c", "rg_numcpt_c_ft" FROM "xplore2"."h_organ") as x) [numPartitions=1] [rg_adr_1#700468,rg_adr_2#700469,rg_adr_3#700500,rg_cmpimp_f#700490,rg_cmpimp_h#700491,rg_codcai#700480,rg_codccp#700485,rg_codcen#700481,rg_codorg#700465,rg_codpos#700470,rg_codreg#700479,rg_coduti#700484,rg_comment#700502,rg_contac#700476,rg_datede#700496,rg_datefi#700497,rg_datenv#700495,rg_datmaj#700483,rg_e_mail#700474,rg_fax#700473,rg_flchorus#700509,rg_flliseng#700511,rg_flpav#700505,rg_flpecdep#700503,... 26 more fields] PushedFilters: [], ReadSchema: struct<rg_adr_1:string,rg_adr_2:string,rg_adr_3:string,rg_cmpimp_f:string,rg_cmpimp_h:string,rg_c...

WholeStageCodegen (2)

Details

== Physical Plan ==
AdaptiveSparkPlan (18)
+- == Final Plan ==
   * HashAggregate (12)
   +- AQEShuffleRead (11)
      +- ShuffleQueryStage (10), Statistics(sizeInBytes=54.1 KiB, rowCount=92)
         +- Exchange (9)
            +- * HashAggregate (8)
               +- Union (7)
                  :- * Project (3)
                  :  +- * Filter (2)
                  :     +- * Scan JDBCRelation((SELECT "rg_codorg", "rg_typorg", "rg_nomorg", "rg_adr_1", "rg_adr_2", "rg_codpos", "rg_ville", "rg_telbur", "rg_fax", "rg_e_mail", "rg_prefix", "rg_contac", "rg_numbor", "rg_tauxre", "rg_codreg", "rg_codcai", "rg_codcen", "rg_fltele", "rg_datmaj", "rg_coduti", "rg_codccp", "rg_fltp", "rg_idmut", "rg_fltopr", "rg_numcpt", "rg_cmpimp_f", "rg_cmpimp_h", "rg_relctx", "rg_relpage", "rg_relref", "rg_datenv", "rg_datede", "rg_datefi", "rg_typoc", "rg_orgpayeur", "rg_adr_3", "rg_notrel", "rg_comment", "rg_flpecdep", "rg_numcpt_a", "rg_flpav", "rg_reclam", "rg_trirel", "rg_notbord", "rg_flchorus", "rg_numsir", "rg_flliseng", "rg_modreg", "rg_numcpt_c", "rg_numcpt_c_ft" FROM "xplore"."h_organ") as x) [numPartitions=1]  (1)
                  +- * Project (6)
                     +- * Filter (5)
                        +- * Scan JDBCRelation((SELECT "rg_codorg", "rg_typorg", "rg_nomorg", "rg_adr_1", "rg_adr_2", "rg_codpos", "rg_ville", "rg_telbur", "rg_fax", "rg_e_mail", "rg_prefix", "rg_contac", "rg_numbor", "rg_tauxre", "rg_codreg", "rg_codcai", "rg_codcen", "rg_fltele", "rg_datmaj", "rg_coduti", "rg_codccp", "rg_fltp", "rg_idmut", "rg_fltopr", "rg_numcpt", "rg_cmpimp_f", "rg_cmpimp_h", "rg_relctx", "rg_relpage", "rg_relref", "rg_datenv", "rg_datede", "rg_datefi", "rg_typoc", "rg_orgpayeur", "rg_adr_3", "rg_notrel", "rg_comment", "rg_flpecdep", "rg_numcpt_a", "rg_flpav", "rg_reclam", "rg_trirel", "rg_notbord", "rg_flchorus", "rg_numsir", "rg_flliseng", "rg_modreg", "rg_numcpt_c", "rg_numcpt_c_ft" FROM "xplore2"."h_organ") as x) [numPartitions=1]  (4)
+- == Initial Plan ==
   CollectLimit (17)
   +- HashAggregate (16)
      +- Exchange (15)
         +- HashAggregate (14)
            +- Union (13)
               :- Project (3)
               :  +- Filter (2)
               :     +- Scan JDBCRelation((SELECT "rg_codorg", "rg_typorg", "rg_nomorg", "rg_adr_1", "rg_adr_2", "rg_codpos", "rg_ville", "rg_telbur", "rg_fax", "rg_e_mail", "rg_prefix", "rg_contac", "rg_numbor", "rg_tauxre", "rg_codreg", "rg_codcai", "rg_codcen", "rg_fltele", "rg_datmaj", "rg_coduti", "rg_codccp", "rg_fltp", "rg_idmut", "rg_fltopr", "rg_numcpt", "rg_cmpimp_f", "rg_cmpimp_h", "rg_relctx", "rg_relpage", "rg_relref", "rg_datenv", "rg_datede", "rg_datefi", "rg_typoc", "rg_orgpayeur", "rg_adr_3", "rg_notrel", "rg_comment", "rg_flpecdep", "rg_numcpt_a", "rg_flpav", "rg_reclam", "rg_trirel", "rg_notbord", "rg_flchorus", "rg_numsir", "rg_flliseng", "rg_modreg", "rg_numcpt_c", "rg_numcpt_c_ft" FROM "xplore"."h_organ") as x) [numPartitions=1]  (1)
               +- Project (6)
                  +- Filter (5)
                     +- Scan JDBCRelation((SELECT "rg_codorg", "rg_typorg", "rg_nomorg", "rg_adr_1", "rg_adr_2", "rg_codpos", "rg_ville", "rg_telbur", "rg_fax", "rg_e_mail", "rg_prefix", "rg_contac", "rg_numbor", "rg_tauxre", "rg_codreg", "rg_codcai", "rg_codcen", "rg_fltele", "rg_datmaj", "rg_coduti", "rg_codccp", "rg_fltp", "rg_idmut", "rg_fltopr", "rg_numcpt", "rg_cmpimp_f", "rg_cmpimp_h", "rg_relctx", "rg_relpage", "rg_relref", "rg_datenv", "rg_datede", "rg_datefi", "rg_typoc", "rg_orgpayeur", "rg_adr_3", "rg_notrel", "rg_comment", "rg_flpecdep", "rg_numcpt_a", "rg_flpav", "rg_reclam", "rg_trirel", "rg_notbord", "rg_flchorus", "rg_numsir", "rg_flliseng", "rg_modreg", "rg_numcpt_c", "rg_numcpt_c_ft" FROM "xplore2"."h_organ") as x) [numPartitions=1]  (4)


(1) Scan JDBCRelation((SELECT "rg_codorg", "rg_typorg", "rg_nomorg", "rg_adr_1", "rg_adr_2", "rg_codpos", "rg_ville", "rg_telbur", "rg_fax", "rg_e_mail", "rg_prefix", "rg_contac", "rg_numbor", "rg_tauxre", "rg_codreg", "rg_codcai", "rg_codcen", "rg_fltele", "rg_datmaj", "rg_coduti", "rg_codccp", "rg_fltp", "rg_idmut", "rg_fltopr", "rg_numcpt", "rg_cmpimp_f", "rg_cmpimp_h", "rg_relctx", "rg_relpage", "rg_relref", "rg_datenv", "rg_datede", "rg_datefi", "rg_typoc", "rg_orgpayeur", "rg_adr_3", "rg_notrel", "rg_comment", "rg_flpecdep", "rg_numcpt_a", "rg_flpav", "rg_reclam", "rg_trirel", "rg_notbord", "rg_flchorus", "rg_numsir", "rg_flliseng", "rg_modreg", "rg_numcpt_c", "rg_numcpt_c_ft" FROM "xplore"."h_organ") as x) [numPartitions=1]  [codegen id : 1]
Output [50]: [rg_adr_1#700016, rg_adr_2#700017, rg_adr_3#700048, rg_cmpimp_f#700038, rg_cmpimp_h#700039, rg_codcai#700028, rg_codccp#700033, rg_codcen#700029, rg_codorg#700013, rg_codpos#700018, rg_codreg#700027, rg_coduti#700032, rg_comment#700050, rg_contac#700024, rg_datede#700044, rg_datefi#700045, rg_datenv#700043, rg_datmaj#700031, rg_e_mail#700022, rg_fax#700021, rg_flchorus#700057, rg_flliseng#700059, rg_flpav#700053, rg_flpecdep#700051, rg_fltele#700030, rg_fltopr#700036, rg_fltp#700034, rg_idmut#700035, rg_modreg#700060, rg_nomorg#700015, rg_notbord#700056, rg_notrel#700049, rg_numbor#700025, rg_numcpt#700037, rg_numcpt_a#700052, rg_numcpt_c#700061, rg_numcpt_c_ft#700062, rg_numsir#700058, rg_orgpayeur#700047, rg_prefix#700023, rg_reclam#700054, rg_relctx#700040, rg_relpage#700041, rg_relref#700042, rg_tauxre#700026, rg_telbur#700020, rg_trirel#700055, rg_typoc#700046, rg_typorg#700014, rg_ville#700019]
ReadSchema: struct<rg_adr_1:string,rg_adr_2:string,rg_adr_3:string,rg_cmpimp_f:string,rg_cmpimp_h:string,rg_codcai:string,rg_codccp:string,rg_codcen:string,rg_codorg:string,rg_codpos:string,rg_codreg:string,rg_coduti:string,rg_comment:string,rg_contac:string,rg_datede:string,rg_datefi:string,rg_datenv:string,rg_datmaj:string,rg_e_mail:string,rg_fax:string,rg_flchorus:string,rg_flliseng:string,rg_flpav:string,rg_flpecdep:string,rg_fltele:string,rg_fltopr:string,rg_fltp:string,rg_idmut:string,rg_modreg:string,rg_nomorg:string,rg_notbord:string,rg_notrel:string,rg_numbor:string,rg_numcpt:string,rg_numcpt_a:string,rg_numcpt_c:string,rg_numcpt_c_ft:string,rg_numsir:string,rg_orgpayeur:string,rg_prefix:string,rg_reclam:string,rg_relctx:string,rg_relpage:string,rg_relref:string,rg_tauxre:string,rg_telbur:string,rg_trirel:string,rg_typoc:string,rg_typorg:string,rg_ville:string>

(2) Filter [codegen id : 1]
Input [50]: [rg_adr_1#700016, rg_adr_2#700017, rg_adr_3#700048, rg_cmpimp_f#700038, rg_cmpimp_h#700039, rg_codcai#700028, rg_codccp#700033, rg_codcen#700029, rg_codorg#700013, rg_codpos#700018, rg_codreg#700027, rg_coduti#700032, rg_comment#700050, rg_contac#700024, rg_datede#700044, rg_datefi#700045, rg_datenv#700043, rg_datmaj#700031, rg_e_mail#700022, rg_fax#700021, rg_flchorus#700057, rg_flliseng#700059, rg_flpav#700053, rg_flpecdep#700051, rg_fltele#700030, rg_fltopr#700036, rg_fltp#700034, rg_idmut#700035, rg_modreg#700060, rg_nomorg#700015, rg_notbord#700056, rg_notrel#700049, rg_numbor#700025, rg_numcpt#700037, rg_numcpt_a#700052, rg_numcpt_c#700061, rg_numcpt_c_ft#700062, rg_numsir#700058, rg_orgpayeur#700047, rg_prefix#700023, rg_reclam#700054, rg_relctx#700040, rg_relpage#700041, rg_relref#700042, rg_tauxre#700026, rg_telbur#700020, rg_trirel#700055, rg_typoc#700046, rg_typorg#700014, rg_ville#700019]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codorg#700013)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codorg#700013)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typorg#700014)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_typorg#700014)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_nomorg#700015)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_nomorg#700015)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_1#700016)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_1#700016)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_2#700017)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_2#700017)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codpos#700018)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codpos#700018)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_ville#700019)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_ville#700019)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_telbur#700020)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_telbur#700020)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fax#700021)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fax#700021)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_e_mail#700022)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_e_mail#700022)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_prefix#700023)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_prefix#700023)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_contac#700024)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_contac#700024)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numbor#700025)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numbor#700025)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_tauxre#700026)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_tauxre#700026)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codreg#700027)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codreg#700027)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcai#700028)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcai#700028)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcen#700029)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcen#700029)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltele#700030)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltele#700030)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datmaj#700031)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datmaj#700031)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_coduti#700032)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_coduti#700032)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codccp#700033)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codccp#700033)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltp#700034)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltp#700034)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_idmut#700035)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_idmut#700035)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltopr#700036)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltopr#700036)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt#700037)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt#700037)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_f#700038)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_f#700038)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_h#700039)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_h#700039)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relctx#700040)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relctx#700040)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relpage#700041)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relpage#700041)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relref#700042)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relref#700042)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datenv#700043)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datenv#700043)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datede#700044)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datede#700044)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datefi#700045)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datefi#700045)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typoc#700046)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_typoc#700046)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_orgpayeur#700047)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_orgpayeur#700047)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_3#700048)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_3#700048)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notrel#700049)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_notrel#700049)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_comment#700050)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_comment#700050)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpecdep#700051)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpecdep#700051)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_a#700052)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_a#700052)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpav#700053)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpav#700053)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_reclam#700054)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_reclam#700054)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_trirel#700055)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_trirel#700055)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notbord#700056)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_notbord#700056)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flchorus#700057)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flchorus#700057)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numsir#700058)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numsir#700058)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flliseng#700059)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flliseng#700059)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_modreg#700060)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_modreg#700060)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c#700061)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c#700061)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c_ft#700062)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c_ft#700062)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(null), MAIN)) THEN false ELSE Contains(str_remove_accent(null), MAIN) END)

(3) Project [codegen id : 1]
Output [51]: [null AS ORIGINE_440148#700363, rg_adr_1#700016 AS RG_ADR_1_437974#700364, rg_adr_2#700017 AS RG_ADR_2_437975#700365, rg_adr_3#700048 AS RG_ADR_3_438006#700366, rg_cmpimp_f#700038 AS RG_CMPIMP_F_437996#700367, rg_cmpimp_h#700039 AS RG_CMPIMP_H_437997#700368, rg_codcai#700028 AS RG_CODCAI_437986#700369, rg_codccp#700033 AS RG_CODCCP_437991#700370, rg_codcen#700029 AS RG_CODCEN_437987#700371, rg_codorg#700013 AS RG_CODORG_437971#700372, rg_codpos#700018 AS RG_CODPOS_437976#700373, rg_codreg#700027 AS RG_CODREG_437985#700374, rg_coduti#700032 AS RG_CODUTI_437990#700375, rg_comment#700050 AS RG_COMMENT_438008#700376, rg_contac#700024 AS RG_CONTAC_437982#700377, rg_datede#700044 AS RG_DATEDE_438002#700378, rg_datefi#700045 AS RG_DATEFI_438003#700379, rg_datenv#700043 AS RG_DATENV_438001#700380, rg_datmaj#700031 AS RG_DATMAJ_437989#700381, rg_e_mail#700022 AS RG_E_MAIL_437980#700382, rg_fax#700021 AS RG_FAX_437979#700383, rg_flchorus#700057 AS RG_FLCHORUS_438015#700384, rg_flliseng#700059 AS RG_FLLISENG_438017#700385, rg_flpav#700053 AS RG_FLPAV_438011#700386, rg_flpecdep#700051 AS RG_FLPECDEP_438009#700387, rg_fltele#700030 AS RG_FLTELE_437988#700388, rg_fltopr#700036 AS RG_FLTOPR_437994#700389, rg_fltp#700034 AS RG_FLTP_437992#700390, rg_idmut#700035 AS RG_IDMUT_437993#700391, rg_modreg#700060 AS RG_MODREG_438018#700392, rg_nomorg#700015 AS RG_NOMORG_437973#700393, rg_notbord#700056 AS RG_NOTBORD_438014#700394, rg_notrel#700049 AS RG_NOTREL_438007#700395, rg_numbor#700025 AS RG_NUMBOR_437983#700396, rg_numcpt#700037 AS RG_NUMCPT_437995#700397, rg_numcpt_a#700052 AS RG_NUMCPT_A_438010#700398, rg_numcpt_c#700061 AS RG_NUMCPT_C_438019#700399, rg_numcpt_c_ft#700062 AS RG_NUMCPT_C_FT_438020#700400, rg_numsir#700058 AS RG_NUMSIR_438016#700401, rg_orgpayeur#700047 AS RG_ORGPAYEUR_438005#700402, rg_prefix#700023 AS RG_PREFIX_437981#700403, rg_reclam#700054 AS RG_RECLAM_438012#700404, rg_relctx#700040 AS RG_RELCTX_437998#700405, rg_relpage#700041 AS RG_RELPAGE_437999#700406, rg_relref#700042 AS RG_RELREF_438000#700407, rg_tauxre#700026 AS RG_TAUXRE_437984#700408, rg_telbur#700020 AS RG_TELBUR_437978#700409, rg_trirel#700055 AS RG_TRIREL_438013#700410, rg_typoc#700046 AS RG_TYPOC_438004#700411, rg_typorg#700014 AS RG_TYPORG_437972#700412, rg_ville#700019 AS RG_VILLE_437977#700413]
Input [50]: [rg_adr_1#700016, rg_adr_2#700017, rg_adr_3#700048, rg_cmpimp_f#700038, rg_cmpimp_h#700039, rg_codcai#700028, rg_codccp#700033, rg_codcen#700029, rg_codorg#700013, rg_codpos#700018, rg_codreg#700027, rg_coduti#700032, rg_comment#700050, rg_contac#700024, rg_datede#700044, rg_datefi#700045, rg_datenv#700043, rg_datmaj#700031, rg_e_mail#700022, rg_fax#700021, rg_flchorus#700057, rg_flliseng#700059, rg_flpav#700053, rg_flpecdep#700051, rg_fltele#700030, rg_fltopr#700036, rg_fltp#700034, rg_idmut#700035, rg_modreg#700060, rg_nomorg#700015, rg_notbord#700056, rg_notrel#700049, rg_numbor#700025, rg_numcpt#700037, rg_numcpt_a#700052, rg_numcpt_c#700061, rg_numcpt_c_ft#700062, rg_numsir#700058, rg_orgpayeur#700047, rg_prefix#700023, rg_reclam#700054, rg_relctx#700040, rg_relpage#700041, rg_relref#700042, rg_tauxre#700026, rg_telbur#700020, rg_trirel#700055, rg_typoc#700046, rg_typorg#700014, rg_ville#700019]

(4) Scan JDBCRelation((SELECT "rg_codorg", "rg_typorg", "rg_nomorg", "rg_adr_1", "rg_adr_2", "rg_codpos", "rg_ville", "rg_telbur", "rg_fax", "rg_e_mail", "rg_prefix", "rg_contac", "rg_numbor", "rg_tauxre", "rg_codreg", "rg_codcai", "rg_codcen", "rg_fltele", "rg_datmaj", "rg_coduti", "rg_codccp", "rg_fltp", "rg_idmut", "rg_fltopr", "rg_numcpt", "rg_cmpimp_f", "rg_cmpimp_h", "rg_relctx", "rg_relpage", "rg_relref", "rg_datenv", "rg_datede", "rg_datefi", "rg_typoc", "rg_orgpayeur", "rg_adr_3", "rg_notrel", "rg_comment", "rg_flpecdep", "rg_numcpt_a", "rg_flpav", "rg_reclam", "rg_trirel", "rg_notbord", "rg_flchorus", "rg_numsir", "rg_flliseng", "rg_modreg", "rg_numcpt_c", "rg_numcpt_c_ft" FROM "xplore2"."h_organ") as x) [numPartitions=1]  [codegen id : 2]
Output [50]: [rg_adr_1#700468, rg_adr_2#700469, rg_adr_3#700500, rg_cmpimp_f#700490, rg_cmpimp_h#700491, rg_codcai#700480, rg_codccp#700485, rg_codcen#700481, rg_codorg#700465, rg_codpos#700470, rg_codreg#700479, rg_coduti#700484, rg_comment#700502, rg_contac#700476, rg_datede#700496, rg_datefi#700497, rg_datenv#700495, rg_datmaj#700483, rg_e_mail#700474, rg_fax#700473, rg_flchorus#700509, rg_flliseng#700511, rg_flpav#700505, rg_flpecdep#700503, rg_fltele#700482, rg_fltopr#700488, rg_fltp#700486, rg_idmut#700487, rg_modreg#700512, rg_nomorg#700467, rg_notbord#700508, rg_notrel#700501, rg_numbor#700477, rg_numcpt#700489, rg_numcpt_a#700504, rg_numcpt_c#700513, rg_numcpt_c_ft#700514, rg_numsir#700510, rg_orgpayeur#700499, rg_prefix#700475, rg_reclam#700506, rg_relctx#700492, rg_relpage#700493, rg_relref#700494, rg_tauxre#700478, rg_telbur#700472, rg_trirel#700507, rg_typoc#700498, rg_typorg#700466, rg_ville#700471]
ReadSchema: struct<rg_adr_1:string,rg_adr_2:string,rg_adr_3:string,rg_cmpimp_f:string,rg_cmpimp_h:string,rg_codcai:string,rg_codccp:string,rg_codcen:string,rg_codorg:string,rg_codpos:string,rg_codreg:string,rg_coduti:string,rg_comment:string,rg_contac:string,rg_datede:string,rg_datefi:string,rg_datenv:string,rg_datmaj:string,rg_e_mail:string,rg_fax:string,rg_flchorus:string,rg_flliseng:string,rg_flpav:string,rg_flpecdep:string,rg_fltele:string,rg_fltopr:string,rg_fltp:string,rg_idmut:string,rg_modreg:string,rg_nomorg:string,rg_notbord:string,rg_notrel:string,rg_numbor:string,rg_numcpt:string,rg_numcpt_a:string,rg_numcpt_c:string,rg_numcpt_c_ft:string,rg_numsir:string,rg_orgpayeur:string,rg_prefix:string,rg_reclam:string,rg_relctx:string,rg_relpage:string,rg_relref:string,rg_tauxre:string,rg_telbur:string,rg_trirel:string,rg_typoc:string,rg_typorg:string,rg_ville:string>

(5) Filter [codegen id : 2]
Input [50]: [rg_adr_1#700468, rg_adr_2#700469, rg_adr_3#700500, rg_cmpimp_f#700490, rg_cmpimp_h#700491, rg_codcai#700480, rg_codccp#700485, rg_codcen#700481, rg_codorg#700465, rg_codpos#700470, rg_codreg#700479, rg_coduti#700484, rg_comment#700502, rg_contac#700476, rg_datede#700496, rg_datefi#700497, rg_datenv#700495, rg_datmaj#700483, rg_e_mail#700474, rg_fax#700473, rg_flchorus#700509, rg_flliseng#700511, rg_flpav#700505, rg_flpecdep#700503, rg_fltele#700482, rg_fltopr#700488, rg_fltp#700486, rg_idmut#700487, rg_modreg#700512, rg_nomorg#700467, rg_notbord#700508, rg_notrel#700501, rg_numbor#700477, rg_numcpt#700489, rg_numcpt_a#700504, rg_numcpt_c#700513, rg_numcpt_c_ft#700514, rg_numsir#700510, rg_orgpayeur#700499, rg_prefix#700475, rg_reclam#700506, rg_relctx#700492, rg_relpage#700493, rg_relref#700494, rg_tauxre#700478, rg_telbur#700472, rg_trirel#700507, rg_typoc#700498, rg_typorg#700466, rg_ville#700471]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codorg#700465)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codorg#700465)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typorg#700466)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_typorg#700466)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_nomorg#700467)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_nomorg#700467)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_1#700468)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_1#700468)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_2#700469)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_2#700469)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codpos#700470)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codpos#700470)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_ville#700471)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_ville#700471)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_telbur#700472)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_telbur#700472)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fax#700473)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fax#700473)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_e_mail#700474)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_e_mail#700474)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_prefix#700475)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_prefix#700475)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_contac#700476)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_contac#700476)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numbor#700477)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numbor#700477)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_tauxre#700478)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_tauxre#700478)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codreg#700479)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codreg#700479)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcai#700480)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcai#700480)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcen#700481)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcen#700481)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltele#700482)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltele#700482)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datmaj#700483)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datmaj#700483)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_coduti#700484)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_coduti#700484)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codccp#700485)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codccp#700485)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltp#700486)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltp#700486)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_idmut#700487)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_idmut#700487)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltopr#700488)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltopr#700488)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt#700489)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt#700489)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_f#700490)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_f#700490)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_h#700491)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_h#700491)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relctx#700492)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relctx#700492)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relpage#700493)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relpage#700493)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relref#700494)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relref#700494)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datenv#700495)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datenv#700495)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datede#700496)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datede#700496)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datefi#700497)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datefi#700497)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typoc#700498)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_typoc#700498)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_orgpayeur#700499)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_orgpayeur#700499)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_3#700500)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_3#700500)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notrel#700501)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_notrel#700501)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_comment#700502)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_comment#700502)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpecdep#700503)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpecdep#700503)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_a#700504)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_a#700504)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpav#700505)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpav#700505)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_reclam#700506)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_reclam#700506)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_trirel#700507)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_trirel#700507)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notbord#700508)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_notbord#700508)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flchorus#700509)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flchorus#700509)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numsir#700510)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numsir#700510)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flliseng#700511)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flliseng#700511)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_modreg#700512)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_modreg#700512)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c#700513)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c#700513)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c_ft#700514)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c_ft#700514)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(null), MAIN)) THEN false ELSE Contains(str_remove_accent(null), MAIN) END)

(6) Project [codegen id : 2]
Output [51]: [null AS ORIGINE_440148#700815, rg_adr_1#700468 AS RG_ADR_1_437974#700816, rg_adr_2#700469 AS RG_ADR_2_437975#700817, rg_adr_3#700500 AS RG_ADR_3_438006#700818, rg_cmpimp_f#700490 AS RG_CMPIMP_F_437996#700819, rg_cmpimp_h#700491 AS RG_CMPIMP_H_437997#700820, rg_codcai#700480 AS RG_CODCAI_437986#700821, rg_codccp#700485 AS RG_CODCCP_437991#700822, rg_codcen#700481 AS RG_CODCEN_437987#700823, rg_codorg#700465 AS RG_CODORG_437971#700824, rg_codpos#700470 AS RG_CODPOS_437976#700825, rg_codreg#700479 AS RG_CODREG_437985#700826, rg_coduti#700484 AS RG_CODUTI_437990#700827, rg_comment#700502 AS RG_COMMENT_438008#700828, rg_contac#700476 AS RG_CONTAC_437982#700829, rg_datede#700496 AS RG_DATEDE_438002#700830, rg_datefi#700497 AS RG_DATEFI_438003#700831, rg_datenv#700495 AS RG_DATENV_438001#700832, rg_datmaj#700483 AS RG_DATMAJ_437989#700833, rg_e_mail#700474 AS RG_E_MAIL_437980#700834, rg_fax#700473 AS RG_FAX_437979#700835, rg_flchorus#700509 AS RG_FLCHORUS_438015#700836, rg_flliseng#700511 AS RG_FLLISENG_438017#700837, rg_flpav#700505 AS RG_FLPAV_438011#700838, rg_flpecdep#700503 AS RG_FLPECDEP_438009#700839, rg_fltele#700482 AS RG_FLTELE_437988#700840, rg_fltopr#700488 AS RG_FLTOPR_437994#700841, rg_fltp#700486 AS RG_FLTP_437992#700842, rg_idmut#700487 AS RG_IDMUT_437993#700843, rg_modreg#700512 AS RG_MODREG_438018#700844, rg_nomorg#700467 AS RG_NOMORG_437973#700845, rg_notbord#700508 AS RG_NOTBORD_438014#700846, rg_notrel#700501 AS RG_NOTREL_438007#700847, rg_numbor#700477 AS RG_NUMBOR_437983#700848, rg_numcpt#700489 AS RG_NUMCPT_437995#700849, rg_numcpt_a#700504 AS RG_NUMCPT_A_438010#700850, rg_numcpt_c#700513 AS RG_NUMCPT_C_438019#700851, rg_numcpt_c_ft#700514 AS RG_NUMCPT_C_FT_438020#700852, rg_numsir#700510 AS RG_NUMSIR_438016#700853, rg_orgpayeur#700499 AS RG_ORGPAYEUR_438005#700854, rg_prefix#700475 AS RG_PREFIX_437981#700855, rg_reclam#700506 AS RG_RECLAM_438012#700856, rg_relctx#700492 AS RG_RELCTX_437998#700857, rg_relpage#700493 AS RG_RELPAGE_437999#700858, rg_relref#700494 AS RG_RELREF_438000#700859, rg_tauxre#700478 AS RG_TAUXRE_437984#700860, rg_telbur#700472 AS RG_TELBUR_437978#700861, rg_trirel#700507 AS RG_TRIREL_438013#700862, rg_typoc#700498 AS RG_TYPOC_438004#700863, rg_typorg#700466 AS RG_TYPORG_437972#700864, rg_ville#700471 AS RG_VILLE_437977#700865]
Input [50]: [rg_adr_1#700468, rg_adr_2#700469, rg_adr_3#700500, rg_cmpimp_f#700490, rg_cmpimp_h#700491, rg_codcai#700480, rg_codccp#700485, rg_codcen#700481, rg_codorg#700465, rg_codpos#700470, rg_codreg#700479, rg_coduti#700484, rg_comment#700502, rg_contac#700476, rg_datede#700496, rg_datefi#700497, rg_datenv#700495, rg_datmaj#700483, rg_e_mail#700474, rg_fax#700473, rg_flchorus#700509, rg_flliseng#700511, rg_flpav#700505, rg_flpecdep#700503, rg_fltele#700482, rg_fltopr#700488, rg_fltp#700486, rg_idmut#700487, rg_modreg#700512, rg_nomorg#700467, rg_notbord#700508, rg_notrel#700501, rg_numbor#700477, rg_numcpt#700489, rg_numcpt_a#700504, rg_numcpt_c#700513, rg_numcpt_c_ft#700514, rg_numsir#700510, rg_orgpayeur#700499, rg_prefix#700475, rg_reclam#700506, rg_relctx#700492, rg_relpage#700493, rg_relref#700494, rg_tauxre#700478, rg_telbur#700472, rg_trirel#700507, rg_typoc#700498, rg_typorg#700466, rg_ville#700471]

(7) Union

(8) HashAggregate [codegen id : 3]
Input [51]: [ORIGINE_440148#700363, RG_ADR_1_437974#700364, RG_ADR_2_437975#700365, RG_ADR_3_438006#700366, RG_CMPIMP_F_437996#700367, RG_CMPIMP_H_437997#700368, RG_CODCAI_437986#700369, RG_CODCCP_437991#700370, RG_CODCEN_437987#700371, RG_CODORG_437971#700372, RG_CODPOS_437976#700373, RG_CODREG_437985#700374, RG_CODUTI_437990#700375, RG_COMMENT_438008#700376, RG_CONTAC_437982#700377, RG_DATEDE_438002#700378, RG_DATEFI_438003#700379, RG_DATENV_438001#700380, RG_DATMAJ_437989#700381, RG_E_MAIL_437980#700382, RG_FAX_437979#700383, RG_FLCHORUS_438015#700384, RG_FLLISENG_438017#700385, RG_FLPAV_438011#700386, RG_FLPECDEP_438009#700387, RG_FLTELE_437988#700388, RG_FLTOPR_437994#700389, RG_FLTP_437992#700390, RG_IDMUT_437993#700391, RG_MODREG_438018#700392, RG_NOMORG_437973#700393, RG_NOTBORD_438014#700394, RG_NOTREL_438007#700395, RG_NUMBOR_437983#700396, RG_NUMCPT_437995#700397, RG_NUMCPT_A_438010#700398, RG_NUMCPT_C_438019#700399, RG_NUMCPT_C_FT_438020#700400, RG_NUMSIR_438016#700401, RG_ORGPAYEUR_438005#700402, RG_PREFIX_437981#700403, RG_RECLAM_438012#700404, RG_RELCTX_437998#700405, RG_RELPAGE_437999#700406, RG_RELREF_438000#700407, RG_TAUXRE_437984#700408, RG_TELBUR_437978#700409, RG_TRIREL_438013#700410, RG_TYPOC_438004#700411, RG_TYPORG_437972#700412, RG_VILLE_437977#700413]
Keys [51]: [ORIGINE_440148#700363, RG_ADR_1_437974#700364, RG_ADR_2_437975#700365, RG_ADR_3_438006#700366, RG_CMPIMP_F_437996#700367, RG_CMPIMP_H_437997#700368, RG_CODCAI_437986#700369, RG_CODCCP_437991#700370, RG_CODCEN_437987#700371, RG_CODORG_437971#700372, RG_CODPOS_437976#700373, RG_CODREG_437985#700374, RG_CODUTI_437990#700375, RG_COMMENT_438008#700376, RG_CONTAC_437982#700377, RG_DATEDE_438002#700378, RG_DATEFI_438003#700379, RG_DATENV_438001#700380, RG_DATMAJ_437989#700381, RG_E_MAIL_437980#700382, RG_FAX_437979#700383, RG_FLCHORUS_438015#700384, RG_FLLISENG_438017#700385, RG_FLPAV_438011#700386, RG_FLPECDEP_438009#700387, RG_FLTELE_437988#700388, RG_FLTOPR_437994#700389, RG_FLTP_437992#700390, RG_IDMUT_437993#700391, RG_MODREG_438018#700392, RG_NOMORG_437973#700393, RG_NOTBORD_438014#700394, RG_NOTREL_438007#700395, RG_NUMBOR_437983#700396, RG_NUMCPT_437995#700397, RG_NUMCPT_A_438010#700398, RG_NUMCPT_C_438019#700399, RG_NUMCPT_C_FT_438020#700400, RG_NUMSIR_438016#700401, RG_ORGPAYEUR_438005#700402, RG_PREFIX_437981#700403, RG_RECLAM_438012#700404, RG_RELCTX_437998#700405, RG_RELPAGE_437999#700406, RG_RELREF_438000#700407, RG_TAUXRE_437984#700408, RG_TELBUR_437978#700409, RG_TRIREL_438013#700410, RG_TYPOC_438004#700411, RG_TYPORG_437972#700412, RG_VILLE_437977#700413]
Functions: []
Aggregate Attributes: []
Results [51]: [ORIGINE_440148#700363, RG_ADR_1_437974#700364, RG_ADR_2_437975#700365, RG_ADR_3_438006#700366, RG_CMPIMP_F_437996#700367, RG_CMPIMP_H_437997#700368, RG_CODCAI_437986#700369, RG_CODCCP_437991#700370, RG_CODCEN_437987#700371, RG_CODORG_437971#700372, RG_CODPOS_437976#700373, RG_CODREG_437985#700374, RG_CODUTI_437990#700375, RG_COMMENT_438008#700376, RG_CONTAC_437982#700377, RG_DATEDE_438002#700378, RG_DATEFI_438003#700379, RG_DATENV_438001#700380, RG_DATMAJ_437989#700381, RG_E_MAIL_437980#700382, RG_FAX_437979#700383, RG_FLCHORUS_438015#700384, RG_FLLISENG_438017#700385, RG_FLPAV_438011#700386, RG_FLPECDEP_438009#700387, RG_FLTELE_437988#700388, RG_FLTOPR_437994#700389, RG_FLTP_437992#700390, RG_IDMUT_437993#700391, RG_MODREG_438018#700392, RG_NOMORG_437973#700393, RG_NOTBORD_438014#700394, RG_NOTREL_438007#700395, RG_NUMBOR_437983#700396, RG_NUMCPT_437995#700397, RG_NUMCPT_A_438010#700398, RG_NUMCPT_C_438019#700399, RG_NUMCPT_C_FT_438020#700400, RG_NUMSIR_438016#700401, RG_ORGPAYEUR_438005#700402, RG_PREFIX_437981#700403, RG_RECLAM_438012#700404, RG_RELCTX_437998#700405, RG_RELPAGE_437999#700406, RG_RELREF_438000#700407, RG_TAUXRE_437984#700408, RG_TELBUR_437978#700409, RG_TRIREL_438013#700410, RG_TYPOC_438004#700411, RG_TYPORG_437972#700412, RG_VILLE_437977#700413]

(9) Exchange
Input [51]: [ORIGINE_440148#700363, RG_ADR_1_437974#700364, RG_ADR_2_437975#700365, RG_ADR_3_438006#700366, RG_CMPIMP_F_437996#700367, RG_CMPIMP_H_437997#700368, RG_CODCAI_437986#700369, RG_CODCCP_437991#700370, RG_CODCEN_437987#700371, RG_CODORG_437971#700372, RG_CODPOS_437976#700373, RG_CODREG_437985#700374, RG_CODUTI_437990#700375, RG_COMMENT_438008#700376, RG_CONTAC_437982#700377, RG_DATEDE_438002#700378, RG_DATEFI_438003#700379, RG_DATENV_438001#700380, RG_DATMAJ_437989#700381, RG_E_MAIL_437980#700382, RG_FAX_437979#700383, RG_FLCHORUS_438015#700384, RG_FLLISENG_438017#700385, RG_FLPAV_438011#700386, RG_FLPECDEP_438009#700387, RG_FLTELE_437988#700388, RG_FLTOPR_437994#700389, RG_FLTP_437992#700390, RG_IDMUT_437993#700391, RG_MODREG_438018#700392, RG_NOMORG_437973#700393, RG_NOTBORD_438014#700394, RG_NOTREL_438007#700395, RG_NUMBOR_437983#700396, RG_NUMCPT_437995#700397, RG_NUMCPT_A_438010#700398, RG_NUMCPT_C_438019#700399, RG_NUMCPT_C_FT_438020#700400, RG_NUMSIR_438016#700401, RG_ORGPAYEUR_438005#700402, RG_PREFIX_437981#700403, RG_RECLAM_438012#700404, RG_RELCTX_437998#700405, RG_RELPAGE_437999#700406, RG_RELREF_438000#700407, RG_TAUXRE_437984#700408, RG_TELBUR_437978#700409, RG_TRIREL_438013#700410, RG_TYPOC_438004#700411, RG_TYPORG_437972#700412, RG_VILLE_437977#700413]
Arguments: hashpartitioning(ORIGINE_440148#700363, RG_ADR_1_437974#700364, RG_ADR_2_437975#700365, RG_ADR_3_438006#700366, RG_CMPIMP_F_437996#700367, RG_CMPIMP_H_437997#700368, RG_CODCAI_437986#700369, RG_CODCCP_437991#700370, RG_CODCEN_437987#700371, RG_CODORG_437971#700372, RG_CODPOS_437976#700373, RG_CODREG_437985#700374, RG_CODUTI_437990#700375, RG_COMMENT_438008#700376, RG_CONTAC_437982#700377, RG_DATEDE_438002#700378, RG_DATEFI_438003#700379, RG_DATENV_438001#700380, RG_DATMAJ_437989#700381, RG_E_MAIL_437980#700382, RG_FAX_437979#700383, RG_FLCHORUS_438015#700384, RG_FLLISENG_438017#700385, RG_FLPAV_438011#700386, ... 28 more fields), ENSURE_REQUIREMENTS, [plan_id=37464]

(10) ShuffleQueryStage
Output [51]: [ORIGINE_440148#700363, RG_ADR_1_437974#700364, RG_ADR_2_437975#700365, RG_ADR_3_438006#700366, RG_CMPIMP_F_437996#700367, RG_CMPIMP_H_437997#700368, RG_CODCAI_437986#700369, RG_CODCCP_437991#700370, RG_CODCEN_437987#700371, RG_CODORG_437971#700372, RG_CODPOS_437976#700373, RG_CODREG_437985#700374, RG_CODUTI_437990#700375, RG_COMMENT_438008#700376, RG_CONTAC_437982#700377, RG_DATEDE_438002#700378, RG_DATEFI_438003#700379, RG_DATENV_438001#700380, RG_DATMAJ_437989#700381, RG_E_MAIL_437980#700382, RG_FAX_437979#700383, RG_FLCHORUS_438015#700384, RG_FLLISENG_438017#700385, RG_FLPAV_438011#700386, RG_FLPECDEP_438009#700387, RG_FLTELE_437988#700388, RG_FLTOPR_437994#700389, RG_FLTP_437992#700390, RG_IDMUT_437993#700391, RG_MODREG_438018#700392, RG_NOMORG_437973#700393, RG_NOTBORD_438014#700394, RG_NOTREL_438007#700395, RG_NUMBOR_437983#700396, RG_NUMCPT_437995#700397, RG_NUMCPT_A_438010#700398, RG_NUMCPT_C_438019#700399, RG_NUMCPT_C_FT_438020#700400, RG_NUMSIR_438016#700401, RG_ORGPAYEUR_438005#700402, RG_PREFIX_437981#700403, RG_RECLAM_438012#700404, RG_RELCTX_437998#700405, RG_RELPAGE_437999#700406, RG_RELREF_438000#700407, RG_TAUXRE_437984#700408, RG_TELBUR_437978#700409, RG_TRIREL_438013#700410, RG_TYPOC_438004#700411, RG_TYPORG_437972#700412, RG_VILLE_437977#700413]
Arguments: 0

(11) AQEShuffleRead
Input [51]: [ORIGINE_440148#700363, RG_ADR_1_437974#700364, RG_ADR_2_437975#700365, RG_ADR_3_438006#700366, RG_CMPIMP_F_437996#700367, RG_CMPIMP_H_437997#700368, RG_CODCAI_437986#700369, RG_CODCCP_437991#700370, RG_CODCEN_437987#700371, RG_CODORG_437971#700372, RG_CODPOS_437976#700373, RG_CODREG_437985#700374, RG_CODUTI_437990#700375, RG_COMMENT_438008#700376, RG_CONTAC_437982#700377, RG_DATEDE_438002#700378, RG_DATEFI_438003#700379, RG_DATENV_438001#700380, RG_DATMAJ_437989#700381, RG_E_MAIL_437980#700382, RG_FAX_437979#700383, RG_FLCHORUS_438015#700384, RG_FLLISENG_438017#700385, RG_FLPAV_438011#700386, RG_FLPECDEP_438009#700387, RG_FLTELE_437988#700388, RG_FLTOPR_437994#700389, RG_FLTP_437992#700390, RG_IDMUT_437993#700391, RG_MODREG_438018#700392, RG_NOMORG_437973#700393, RG_NOTBORD_438014#700394, RG_NOTREL_438007#700395, RG_NUMBOR_437983#700396, RG_NUMCPT_437995#700397, RG_NUMCPT_A_438010#700398, RG_NUMCPT_C_438019#700399, RG_NUMCPT_C_FT_438020#700400, RG_NUMSIR_438016#700401, RG_ORGPAYEUR_438005#700402, RG_PREFIX_437981#700403, RG_RECLAM_438012#700404, RG_RELCTX_437998#700405, RG_RELPAGE_437999#700406, RG_RELREF_438000#700407, RG_TAUXRE_437984#700408, RG_TELBUR_437978#700409, RG_TRIREL_438013#700410, RG_TYPOC_438004#700411, RG_TYPORG_437972#700412, RG_VILLE_437977#700413]
Arguments: coalesced

(12) HashAggregate [codegen id : 4]
Input [51]: [ORIGINE_440148#700363, RG_ADR_1_437974#700364, RG_ADR_2_437975#700365, RG_ADR_3_438006#700366, RG_CMPIMP_F_437996#700367, RG_CMPIMP_H_437997#700368, RG_CODCAI_437986#700369, RG_CODCCP_437991#700370, RG_CODCEN_437987#700371, RG_CODORG_437971#700372, RG_CODPOS_437976#700373, RG_CODREG_437985#700374, RG_CODUTI_437990#700375, RG_COMMENT_438008#700376, RG_CONTAC_437982#700377, RG_DATEDE_438002#700378, RG_DATEFI_438003#700379, RG_DATENV_438001#700380, RG_DATMAJ_437989#700381, RG_E_MAIL_437980#700382, RG_FAX_437979#700383, RG_FLCHORUS_438015#700384, RG_FLLISENG_438017#700385, RG_FLPAV_438011#700386, RG_FLPECDEP_438009#700387, RG_FLTELE_437988#700388, RG_FLTOPR_437994#700389, RG_FLTP_437992#700390, RG_IDMUT_437993#700391, RG_MODREG_438018#700392, RG_NOMORG_437973#700393, RG_NOTBORD_438014#700394, RG_NOTREL_438007#700395, RG_NUMBOR_437983#700396, RG_NUMCPT_437995#700397, RG_NUMCPT_A_438010#700398, RG_NUMCPT_C_438019#700399, RG_NUMCPT_C_FT_438020#700400, RG_NUMSIR_438016#700401, RG_ORGPAYEUR_438005#700402, RG_PREFIX_437981#700403, RG_RECLAM_438012#700404, RG_RELCTX_437998#700405, RG_RELPAGE_437999#700406, RG_RELREF_438000#700407, RG_TAUXRE_437984#700408, RG_TELBUR_437978#700409, RG_TRIREL_438013#700410, RG_TYPOC_438004#700411, RG_TYPORG_437972#700412, RG_VILLE_437977#700413]
Keys [51]: [ORIGINE_440148#700363, RG_ADR_1_437974#700364, RG_ADR_2_437975#700365, RG_ADR_3_438006#700366, RG_CMPIMP_F_437996#700367, RG_CMPIMP_H_437997#700368, RG_CODCAI_437986#700369, RG_CODCCP_437991#700370, RG_CODCEN_437987#700371, RG_CODORG_437971#700372, RG_CODPOS_437976#700373, RG_CODREG_437985#700374, RG_CODUTI_437990#700375, RG_COMMENT_438008#700376, RG_CONTAC_437982#700377, RG_DATEDE_438002#700378, RG_DATEFI_438003#700379, RG_DATENV_438001#700380, RG_DATMAJ_437989#700381, RG_E_MAIL_437980#700382, RG_FAX_437979#700383, RG_FLCHORUS_438015#700384, RG_FLLISENG_438017#700385, RG_FLPAV_438011#700386, RG_FLPECDEP_438009#700387, RG_FLTELE_437988#700388, RG_FLTOPR_437994#700389, RG_FLTP_437992#700390, RG_IDMUT_437993#700391, RG_MODREG_438018#700392, RG_NOMORG_437973#700393, RG_NOTBORD_438014#700394, RG_NOTREL_438007#700395, RG_NUMBOR_437983#700396, RG_NUMCPT_437995#700397, RG_NUMCPT_A_438010#700398, RG_NUMCPT_C_438019#700399, RG_NUMCPT_C_FT_438020#700400, RG_NUMSIR_438016#700401, RG_ORGPAYEUR_438005#700402, RG_PREFIX_437981#700403, RG_RECLAM_438012#700404, RG_RELCTX_437998#700405, RG_RELPAGE_437999#700406, RG_RELREF_438000#700407, RG_TAUXRE_437984#700408, RG_TELBUR_437978#700409, RG_TRIREL_438013#700410, RG_TYPOC_438004#700411, RG_TYPORG_437972#700412, RG_VILLE_437977#700413]
Functions: []
Aggregate Attributes: []
Results [51]: [RG_CODORG_437971#700372 AS COL_2BEC929B_7245_4A99_B35B_1828410B4BF0#701427, RG_TYPORG_437972#700412 AS COL_2A283255_CC39_41B7_92F1_1047F45A0F3B#701428, RG_NOMORG_437973#700393 AS COL_F88B641A_2B7E_4E14_BEE7_AEF87202B8CB#701429, RG_ADR_1_437974#700364 AS COL_4A9B4D82_E445_4520_981F_889668A940FF#701430, RG_ADR_2_437975#700365 AS COL_C632350C_9430_4517_B278_5A8B79D71E66#701431, RG_CODPOS_437976#700373 AS COL_36B09FF4_7487_4F4A_B9D9_5FABB6FBDDF0#701432, RG_VILLE_437977#700413 AS COL_F85BA85B_A60F_4052_B747_21E05690611A#701433, RG_TELBUR_437978#700409 AS COL_24207A3C_0F3D_4862_80B7_E14C3AEB277F#701434, RG_FAX_437979#700383 AS COL_9144B6FF_C9D5_4D86_A012_83206F05D1F7#701435, RG_E_MAIL_437980#700382 AS COL_0F24FE2B_856C_424F_9EA6_F20265B657DD#701436, RG_PREFIX_437981#700403 AS COL_B0FCE3C3_C86F_4189_A862_516F5DBB65E3#701437, RG_CONTAC_437982#700377 AS COL_00F7CB07_9D06_4A80_A0A8_81C35DE10676#701438, RG_NUMBOR_437983#700396 AS COL_1C9724D1_030C_4B44_9E1F_D0683C3E87A8#701439, RG_TAUXRE_437984#700408 AS COL_1D368AEE_B86C_4AEE_A633_13BB7AB8F2C7#701440, RG_CODREG_437985#700374 AS COL_EA7B419A_3DA2_4415_AEF4_CA58F40EFA59#701441, RG_CODCAI_437986#700369 AS COL_285E7375_054D_4A04_B093_4452067A0238#701442, RG_CODCEN_437987#700371 AS COL_1DCA45AE_DA3F_4029_939D_3AF0F0622165#701443, RG_FLTELE_437988#700388 AS COL_90534AEC_906D_48D2_870E_D3069A8111FC#701444, RG_DATMAJ_437989#700381 AS COL_CA834DCD_842A_4A0B_903E_EEF17839C18D#701445, RG_CODUTI_437990#700375 AS COL_262A5830_607C_4AEB_A123_DF847D332979#701446, RG_CODCCP_437991#700370 AS COL_86A04A16_9404_4152_9333_A10664B7E03E#701447, RG_FLTP_437992#700390 AS COL_D36BFE90_7046_4DF7_A779_1A6C217FEA2F#701448, RG_IDMUT_437993#700391 AS COL_D1EFFEB2_6DED_47D9_9AE6_278DF0CC022D#701449, RG_FLTOPR_437994#700389 AS COL_FE17AF85_4178_42AA_84DA_456383471C71#701450, RG_NUMCPT_437995#700397 AS COL_DB9B6B77_1E55_452A_A88F_75E03A0BF30A#701451, RG_CMPIMP_F_437996#700367 AS COL_0D7BE518_0235_4959_B087_7FE87147B597#701452, RG_CMPIMP_H_437997#700368 AS COL_3F2E5E6F_DBBB_4C8B_8CD9_2F2100813AA0#701453, RG_RELCTX_437998#700405 AS COL_56EDADE7_D5B3_42F5_91EE_AD46305E393B#701454, RG_RELPAGE_437999#700406 AS COL_FED75FCC_310F_4299_9B4C_E0175FC502DD#701455, RG_RELREF_438000#700407 AS COL_3FC87295_FA16_45CD_98F5_5198B2107721#701456, RG_DATENV_438001#700380 AS COL_A491737C_8260_4458_B5AB_C62EB2F51AD3#701457, RG_DATEDE_438002#700378 AS COL_B5AB8C39_65AC_4D53_BAA5_DBBF3C8DB7C1#701458, RG_DATEFI_438003#700379 AS COL_7AA4C73A_DC6A_44CD_8C39_15AAB4C90543#701459, RG_TYPOC_438004#700411 AS COL_AA0C8437_CD05_4BF8_80C0_6439A67FF4FA#701460, RG_ORGPAYEUR_438005#700402 AS COL_46209826_F20C_4414_99DC_BA47030E8C3C#701461, RG_ADR_3_438006#700366 AS COL_6061C02E_9FBB_4C1B_8E43_6EF9A9E9E891#701462, RG_NOTREL_438007#700395 AS COL_D29A9789_8993_40FA_A98C_8454B85ED4FB#701463, RG_COMMENT_438008#700376 AS COL_7A9AFC29_9665_4D4A_B589_44F38E0A94F1#701464, RG_FLPECDEP_438009#700387 AS COL_ED52C6A8_23AC_43F2_B299_8867259DF026#701465, RG_NUMCPT_A_438010#700398 AS COL_4881A9D8_1329_4A4A_910E_59042B5CE932#701466, RG_FLPAV_438011#700386 AS COL_FF982E98_DCCD_4043_8435_DE530D020AA8#701467, RG_RECLAM_438012#700404 AS COL_1694BFB5_637A_4D5B_AA2D_334AC46C0443#701468, RG_TRIREL_438013#700410 AS COL_5224F32D_A010_4677_A17B_9AB686CA085C#701469, RG_NOTBORD_438014#700394 AS COL_FACC9EBD_FDC1_4DC5_824A_08A8AD104462#701470, RG_FLCHORUS_438015#700384 AS COL_69091089_94DB_4A90_BEF5_8FCFBE7C69C3#701471, RG_NUMSIR_438016#700401 AS COL_3E4925F2_5633_4861_8AFE_4F701F9A2EDB#701472, RG_FLLISENG_438017#700385 AS COL_9B448507_59EC_45F5_B6E1_38D40E28D215#701473, RG_MODREG_438018#700392 AS COL_B2698104_9168_4D05_957D_59E5B4FD3EF2#701474, RG_NUMCPT_C_438019#700399 AS COL_80EFE2D3_F6B6_4563_97D2_2A7B27F4F20D#701475, RG_NUMCPT_C_FT_438020#700400 AS COL_5D3F27F2_E23E_4F5E_9A87_75F0DFFBEEA6#701476, ORIGINE_440148#700363 AS COL_DFA2A30E_9E67_42B6_A44C_BE4AADB6195E#701477]

(13) Union

(14) HashAggregate
Input [51]: [ORIGINE_440148#700363, RG_ADR_1_437974#700364, RG_ADR_2_437975#700365, RG_ADR_3_438006#700366, RG_CMPIMP_F_437996#700367, RG_CMPIMP_H_437997#700368, RG_CODCAI_437986#700369, RG_CODCCP_437991#700370, RG_CODCEN_437987#700371, RG_CODORG_437971#700372, RG_CODPOS_437976#700373, RG_CODREG_437985#700374, RG_CODUTI_437990#700375, RG_COMMENT_438008#700376, RG_CONTAC_437982#700377, RG_DATEDE_438002#700378, RG_DATEFI_438003#700379, RG_DATENV_438001#700380, RG_DATMAJ_437989#700381, RG_E_MAIL_437980#700382, RG_FAX_437979#700383, RG_FLCHORUS_438015#700384, RG_FLLISENG_438017#700385, RG_FLPAV_438011#700386, RG_FLPECDEP_438009#700387, RG_FLTELE_437988#700388, RG_FLTOPR_437994#700389, RG_FLTP_437992#700390, RG_IDMUT_437993#700391, RG_MODREG_438018#700392, RG_NOMORG_437973#700393, RG_NOTBORD_438014#700394, RG_NOTREL_438007#700395, RG_NUMBOR_437983#700396, RG_NUMCPT_437995#700397, RG_NUMCPT_A_438010#700398, RG_NUMCPT_C_438019#700399, RG_NUMCPT_C_FT_438020#700400, RG_NUMSIR_438016#700401, RG_ORGPAYEUR_438005#700402, RG_PREFIX_437981#700403, RG_RECLAM_438012#700404, RG_RELCTX_437998#700405, RG_RELPAGE_437999#700406, RG_RELREF_438000#700407, RG_TAUXRE_437984#700408, RG_TELBUR_437978#700409, RG_TRIREL_438013#700410, RG_TYPOC_438004#700411, RG_TYPORG_437972#700412, RG_VILLE_437977#700413]
Keys [51]: [ORIGINE_440148#700363, RG_ADR_1_437974#700364, RG_ADR_2_437975#700365, RG_ADR_3_438006#700366, RG_CMPIMP_F_437996#700367, RG_CMPIMP_H_437997#700368, RG_CODCAI_437986#700369, RG_CODCCP_437991#700370, RG_CODCEN_437987#700371, RG_CODORG_437971#700372, RG_CODPOS_437976#700373, RG_CODREG_437985#700374, RG_CODUTI_437990#700375, RG_COMMENT_438008#700376, RG_CONTAC_437982#700377, RG_DATEDE_438002#700378, RG_DATEFI_438003#700379, RG_DATENV_438001#700380, RG_DATMAJ_437989#700381, RG_E_MAIL_437980#700382, RG_FAX_437979#700383, RG_FLCHORUS_438015#700384, RG_FLLISENG_438017#700385, RG_FLPAV_438011#700386, RG_FLPECDEP_438009#700387, RG_FLTELE_437988#700388, RG_FLTOPR_437994#700389, RG_FLTP_437992#700390, RG_IDMUT_437993#700391, RG_MODREG_438018#700392, RG_NOMORG_437973#700393, RG_NOTBORD_438014#700394, RG_NOTREL_438007#700395, RG_NUMBOR_437983#700396, RG_NUMCPT_437995#700397, RG_NUMCPT_A_438010#700398, RG_NUMCPT_C_438019#700399, RG_NUMCPT_C_FT_438020#700400, RG_NUMSIR_438016#700401, RG_ORGPAYEUR_438005#700402, RG_PREFIX_437981#700403, RG_RECLAM_438012#700404, RG_RELCTX_437998#700405, RG_RELPAGE_437999#700406, RG_RELREF_438000#700407, RG_TAUXRE_437984#700408, RG_TELBUR_437978#700409, RG_TRIREL_438013#700410, RG_TYPOC_438004#700411, RG_TYPORG_437972#700412, RG_VILLE_437977#700413]
Functions: []
Aggregate Attributes: []
Results [51]: [ORIGINE_440148#700363, RG_ADR_1_437974#700364, RG_ADR_2_437975#700365, RG_ADR_3_438006#700366, RG_CMPIMP_F_437996#700367, RG_CMPIMP_H_437997#700368, RG_CODCAI_437986#700369, RG_CODCCP_437991#700370, RG_CODCEN_437987#700371, RG_CODORG_437971#700372, RG_CODPOS_437976#700373, RG_CODREG_437985#700374, RG_CODUTI_437990#700375, RG_COMMENT_438008#700376, RG_CONTAC_437982#700377, RG_DATEDE_438002#700378, RG_DATEFI_438003#700379, RG_DATENV_438001#700380, RG_DATMAJ_437989#700381, RG_E_MAIL_437980#700382, RG_FAX_437979#700383, RG_FLCHORUS_438015#700384, RG_FLLISENG_438017#700385, RG_FLPAV_438011#700386, RG_FLPECDEP_438009#700387, RG_FLTELE_437988#700388, RG_FLTOPR_437994#700389, RG_FLTP_437992#700390, RG_IDMUT_437993#700391, RG_MODREG_438018#700392, RG_NOMORG_437973#700393, RG_NOTBORD_438014#700394, RG_NOTREL_438007#700395, RG_NUMBOR_437983#700396, RG_NUMCPT_437995#700397, RG_NUMCPT_A_438010#700398, RG_NUMCPT_C_438019#700399, RG_NUMCPT_C_FT_438020#700400, RG_NUMSIR_438016#700401, RG_ORGPAYEUR_438005#700402, RG_PREFIX_437981#700403, RG_RECLAM_438012#700404, RG_RELCTX_437998#700405, RG_RELPAGE_437999#700406, RG_RELREF_438000#700407, RG_TAUXRE_437984#700408, RG_TELBUR_437978#700409, RG_TRIREL_438013#700410, RG_TYPOC_438004#700411, RG_TYPORG_437972#700412, RG_VILLE_437977#700413]

(15) Exchange
Input [51]: [ORIGINE_440148#700363, RG_ADR_1_437974#700364, RG_ADR_2_437975#700365, RG_ADR_3_438006#700366, RG_CMPIMP_F_437996#700367, RG_CMPIMP_H_437997#700368, RG_CODCAI_437986#700369, RG_CODCCP_437991#700370, RG_CODCEN_437987#700371, RG_CODORG_437971#700372, RG_CODPOS_437976#700373, RG_CODREG_437985#700374, RG_CODUTI_437990#700375, RG_COMMENT_438008#700376, RG_CONTAC_437982#700377, RG_DATEDE_438002#700378, RG_DATEFI_438003#700379, RG_DATENV_438001#700380, RG_DATMAJ_437989#700381, RG_E_MAIL_437980#700382, RG_FAX_437979#700383, RG_FLCHORUS_438015#700384, RG_FLLISENG_438017#700385, RG_FLPAV_438011#700386, RG_FLPECDEP_438009#700387, RG_FLTELE_437988#700388, RG_FLTOPR_437994#700389, RG_FLTP_437992#700390, RG_IDMUT_437993#700391, RG_MODREG_438018#700392, RG_NOMORG_437973#700393, RG_NOTBORD_438014#700394, RG_NOTREL_438007#700395, RG_NUMBOR_437983#700396, RG_NUMCPT_437995#700397, RG_NUMCPT_A_438010#700398, RG_NUMCPT_C_438019#700399, RG_NUMCPT_C_FT_438020#700400, RG_NUMSIR_438016#700401, RG_ORGPAYEUR_438005#700402, RG_PREFIX_437981#700403, RG_RECLAM_438012#700404, RG_RELCTX_437998#700405, RG_RELPAGE_437999#700406, RG_RELREF_438000#700407, RG_TAUXRE_437984#700408, RG_TELBUR_437978#700409, RG_TRIREL_438013#700410, RG_TYPOC_438004#700411, RG_TYPORG_437972#700412, RG_VILLE_437977#700413]
Arguments: hashpartitioning(ORIGINE_440148#700363, RG_ADR_1_437974#700364, RG_ADR_2_437975#700365, RG_ADR_3_438006#700366, RG_CMPIMP_F_437996#700367, RG_CMPIMP_H_437997#700368, RG_CODCAI_437986#700369, RG_CODCCP_437991#700370, RG_CODCEN_437987#700371, RG_CODORG_437971#700372, RG_CODPOS_437976#700373, RG_CODREG_437985#700374, RG_CODUTI_437990#700375, RG_COMMENT_438008#700376, RG_CONTAC_437982#700377, RG_DATEDE_438002#700378, RG_DATEFI_438003#700379, RG_DATENV_438001#700380, RG_DATMAJ_437989#700381, RG_E_MAIL_437980#700382, RG_FAX_437979#700383, RG_FLCHORUS_438015#700384, RG_FLLISENG_438017#700385, RG_FLPAV_438011#700386, ... 28 more fields), ENSURE_REQUIREMENTS, [plan_id=37437]

(16) HashAggregate
Input [51]: [ORIGINE_440148#700363, RG_ADR_1_437974#700364, RG_ADR_2_437975#700365, RG_ADR_3_438006#700366, RG_CMPIMP_F_437996#700367, RG_CMPIMP_H_437997#700368, RG_CODCAI_437986#700369, RG_CODCCP_437991#700370, RG_CODCEN_437987#700371, RG_CODORG_437971#700372, RG_CODPOS_437976#700373, RG_CODREG_437985#700374, RG_CODUTI_437990#700375, RG_COMMENT_438008#700376, RG_CONTAC_437982#700377, RG_DATEDE_438002#700378, RG_DATEFI_438003#700379, RG_DATENV_438001#700380, RG_DATMAJ_437989#700381, RG_E_MAIL_437980#700382, RG_FAX_437979#700383, RG_FLCHORUS_438015#700384, RG_FLLISENG_438017#700385, RG_FLPAV_438011#700386, RG_FLPECDEP_438009#700387, RG_FLTELE_437988#700388, RG_FLTOPR_437994#700389, RG_FLTP_437992#700390, RG_IDMUT_437993#700391, RG_MODREG_438018#700392, RG_NOMORG_437973#700393, RG_NOTBORD_438014#700394, RG_NOTREL_438007#700395, RG_NUMBOR_437983#700396, RG_NUMCPT_437995#700397, RG_NUMCPT_A_438010#700398, RG_NUMCPT_C_438019#700399, RG_NUMCPT_C_FT_438020#700400, RG_NUMSIR_438016#700401, RG_ORGPAYEUR_438005#700402, RG_PREFIX_437981#700403, RG_RECLAM_438012#700404, RG_RELCTX_437998#700405, RG_RELPAGE_437999#700406, RG_RELREF_438000#700407, RG_TAUXRE_437984#700408, RG_TELBUR_437978#700409, RG_TRIREL_438013#700410, RG_TYPOC_438004#700411, RG_TYPORG_437972#700412, RG_VILLE_437977#700413]
Keys [51]: [ORIGINE_440148#700363, RG_ADR_1_437974#700364, RG_ADR_2_437975#700365, RG_ADR_3_438006#700366, RG_CMPIMP_F_437996#700367, RG_CMPIMP_H_437997#700368, RG_CODCAI_437986#700369, RG_CODCCP_437991#700370, RG_CODCEN_437987#700371, RG_CODORG_437971#700372, RG_CODPOS_437976#700373, RG_CODREG_437985#700374, RG_CODUTI_437990#700375, RG_COMMENT_438008#700376, RG_CONTAC_437982#700377, RG_DATEDE_438002#700378, RG_DATEFI_438003#700379, RG_DATENV_438001#700380, RG_DATMAJ_437989#700381, RG_E_MAIL_437980#700382, RG_FAX_437979#700383, RG_FLCHORUS_438015#700384, RG_FLLISENG_438017#700385, RG_FLPAV_438011#700386, RG_FLPECDEP_438009#700387, RG_FLTELE_437988#700388, RG_FLTOPR_437994#700389, RG_FLTP_437992#700390, RG_IDMUT_437993#700391, RG_MODREG_438018#700392, RG_NOMORG_437973#700393, RG_NOTBORD_438014#700394, RG_NOTREL_438007#700395, RG_NUMBOR_437983#700396, RG_NUMCPT_437995#700397, RG_NUMCPT_A_438010#700398, RG_NUMCPT_C_438019#700399, RG_NUMCPT_C_FT_438020#700400, RG_NUMSIR_438016#700401, RG_ORGPAYEUR_438005#700402, RG_PREFIX_437981#700403, RG_RECLAM_438012#700404, RG_RELCTX_437998#700405, RG_RELPAGE_437999#700406, RG_RELREF_438000#700407, RG_TAUXRE_437984#700408, RG_TELBUR_437978#700409, RG_TRIREL_438013#700410, RG_TYPOC_438004#700411, RG_TYPORG_437972#700412, RG_VILLE_437977#700413]
Functions: []
Aggregate Attributes: []
Results [51]: [RG_CODORG_437971#700372 AS COL_2BEC929B_7245_4A99_B35B_1828410B4BF0#701427, RG_TYPORG_437972#700412 AS COL_2A283255_CC39_41B7_92F1_1047F45A0F3B#701428, RG_NOMORG_437973#700393 AS COL_F88B641A_2B7E_4E14_BEE7_AEF87202B8CB#701429, RG_ADR_1_437974#700364 AS COL_4A9B4D82_E445_4520_981F_889668A940FF#701430, RG_ADR_2_437975#700365 AS COL_C632350C_9430_4517_B278_5A8B79D71E66#701431, RG_CODPOS_437976#700373 AS COL_36B09FF4_7487_4F4A_B9D9_5FABB6FBDDF0#701432, RG_VILLE_437977#700413 AS COL_F85BA85B_A60F_4052_B747_21E05690611A#701433, RG_TELBUR_437978#700409 AS COL_24207A3C_0F3D_4862_80B7_E14C3AEB277F#701434, RG_FAX_437979#700383 AS COL_9144B6FF_C9D5_4D86_A012_83206F05D1F7#701435, RG_E_MAIL_437980#700382 AS COL_0F24FE2B_856C_424F_9EA6_F20265B657DD#701436, RG_PREFIX_437981#700403 AS COL_B0FCE3C3_C86F_4189_A862_516F5DBB65E3#701437, RG_CONTAC_437982#700377 AS COL_00F7CB07_9D06_4A80_A0A8_81C35DE10676#701438, RG_NUMBOR_437983#700396 AS COL_1C9724D1_030C_4B44_9E1F_D0683C3E87A8#701439, RG_TAUXRE_437984#700408 AS COL_1D368AEE_B86C_4AEE_A633_13BB7AB8F2C7#701440, RG_CODREG_437985#700374 AS COL_EA7B419A_3DA2_4415_AEF4_CA58F40EFA59#701441, RG_CODCAI_437986#700369 AS COL_285E7375_054D_4A04_B093_4452067A0238#701442, RG_CODCEN_437987#700371 AS COL_1DCA45AE_DA3F_4029_939D_3AF0F0622165#701443, RG_FLTELE_437988#700388 AS COL_90534AEC_906D_48D2_870E_D3069A8111FC#701444, RG_DATMAJ_437989#700381 AS COL_CA834DCD_842A_4A0B_903E_EEF17839C18D#701445, RG_CODUTI_437990#700375 AS COL_262A5830_607C_4AEB_A123_DF847D332979#701446, RG_CODCCP_437991#700370 AS COL_86A04A16_9404_4152_9333_A10664B7E03E#701447, RG_FLTP_437992#700390 AS COL_D36BFE90_7046_4DF7_A779_1A6C217FEA2F#701448, RG_IDMUT_437993#700391 AS COL_D1EFFEB2_6DED_47D9_9AE6_278DF0CC022D#701449, RG_FLTOPR_437994#700389 AS COL_FE17AF85_4178_42AA_84DA_456383471C71#701450, RG_NUMCPT_437995#700397 AS COL_DB9B6B77_1E55_452A_A88F_75E03A0BF30A#701451, RG_CMPIMP_F_437996#700367 AS COL_0D7BE518_0235_4959_B087_7FE87147B597#701452, RG_CMPIMP_H_437997#700368 AS COL_3F2E5E6F_DBBB_4C8B_8CD9_2F2100813AA0#701453, RG_RELCTX_437998#700405 AS COL_56EDADE7_D5B3_42F5_91EE_AD46305E393B#701454, RG_RELPAGE_437999#700406 AS COL_FED75FCC_310F_4299_9B4C_E0175FC502DD#701455, RG_RELREF_438000#700407 AS COL_3FC87295_FA16_45CD_98F5_5198B2107721#701456, RG_DATENV_438001#700380 AS COL_A491737C_8260_4458_B5AB_C62EB2F51AD3#701457, RG_DATEDE_438002#700378 AS COL_B5AB8C39_65AC_4D53_BAA5_DBBF3C8DB7C1#701458, RG_DATEFI_438003#700379 AS COL_7AA4C73A_DC6A_44CD_8C39_15AAB4C90543#701459, RG_TYPOC_438004#700411 AS COL_AA0C8437_CD05_4BF8_80C0_6439A67FF4FA#701460, RG_ORGPAYEUR_438005#700402 AS COL_46209826_F20C_4414_99DC_BA47030E8C3C#701461, RG_ADR_3_438006#700366 AS COL_6061C02E_9FBB_4C1B_8E43_6EF9A9E9E891#701462, RG_NOTREL_438007#700395 AS COL_D29A9789_8993_40FA_A98C_8454B85ED4FB#701463, RG_COMMENT_438008#700376 AS COL_7A9AFC29_9665_4D4A_B589_44F38E0A94F1#701464, RG_FLPECDEP_438009#700387 AS COL_ED52C6A8_23AC_43F2_B299_8867259DF026#701465, RG_NUMCPT_A_438010#700398 AS COL_4881A9D8_1329_4A4A_910E_59042B5CE932#701466, RG_FLPAV_438011#700386 AS COL_FF982E98_DCCD_4043_8435_DE530D020AA8#701467, RG_RECLAM_438012#700404 AS COL_1694BFB5_637A_4D5B_AA2D_334AC46C0443#701468, RG_TRIREL_438013#700410 AS COL_5224F32D_A010_4677_A17B_9AB686CA085C#701469, RG_NOTBORD_438014#700394 AS COL_FACC9EBD_FDC1_4DC5_824A_08A8AD104462#701470, RG_FLCHORUS_438015#700384 AS COL_69091089_94DB_4A90_BEF5_8FCFBE7C69C3#701471, RG_NUMSIR_438016#700401 AS COL_3E4925F2_5633_4861_8AFE_4F701F9A2EDB#701472, RG_FLLISENG_438017#700385 AS COL_9B448507_59EC_45F5_B6E1_38D40E28D215#701473, RG_MODREG_438018#700392 AS COL_B2698104_9168_4D05_957D_59E5B4FD3EF2#701474, RG_NUMCPT_C_438019#700399 AS COL_80EFE2D3_F6B6_4563_97D2_2A7B27F4F20D#701475, RG_NUMCPT_C_FT_438020#700400 AS COL_5D3F27F2_E23E_4F5E_9A87_75F0DFFBEEA6#701476, ORIGINE_440148#700363 AS COL_DFA2A30E_9E67_42B6_A44C_BE4AADB6195E#701477]

(17) CollectLimit
Input [51]: [COL_2BEC929B_7245_4A99_B35B_1828410B4BF0#701427, COL_2A283255_CC39_41B7_92F1_1047F45A0F3B#701428, COL_F88B641A_2B7E_4E14_BEE7_AEF87202B8CB#701429, COL_4A9B4D82_E445_4520_981F_889668A940FF#701430, COL_C632350C_9430_4517_B278_5A8B79D71E66#701431, COL_36B09FF4_7487_4F4A_B9D9_5FABB6FBDDF0#701432, COL_F85BA85B_A60F_4052_B747_21E05690611A#701433, COL_24207A3C_0F3D_4862_80B7_E14C3AEB277F#701434, COL_9144B6FF_C9D5_4D86_A012_83206F05D1F7#701435, COL_0F24FE2B_856C_424F_9EA6_F20265B657DD#701436, COL_B0FCE3C3_C86F_4189_A862_516F5DBB65E3#701437, COL_00F7CB07_9D06_4A80_A0A8_81C35DE10676#701438, COL_1C9724D1_030C_4B44_9E1F_D0683C3E87A8#701439, COL_1D368AEE_B86C_4AEE_A633_13BB7AB8F2C7#701440, COL_EA7B419A_3DA2_4415_AEF4_CA58F40EFA59#701441, COL_285E7375_054D_4A04_B093_4452067A0238#701442, COL_1DCA45AE_DA3F_4029_939D_3AF0F0622165#701443, COL_90534AEC_906D_48D2_870E_D3069A8111FC#701444, COL_CA834DCD_842A_4A0B_903E_EEF17839C18D#701445, COL_262A5830_607C_4AEB_A123_DF847D332979#701446, COL_86A04A16_9404_4152_9333_A10664B7E03E#701447, COL_D36BFE90_7046_4DF7_A779_1A6C217FEA2F#701448, COL_D1EFFEB2_6DED_47D9_9AE6_278DF0CC022D#701449, COL_FE17AF85_4178_42AA_84DA_456383471C71#701450, COL_DB9B6B77_1E55_452A_A88F_75E03A0BF30A#701451, COL_0D7BE518_0235_4959_B087_7FE87147B597#701452, COL_3F2E5E6F_DBBB_4C8B_8CD9_2F2100813AA0#701453, COL_56EDADE7_D5B3_42F5_91EE_AD46305E393B#701454, COL_FED75FCC_310F_4299_9B4C_E0175FC502DD#701455, COL_3FC87295_FA16_45CD_98F5_5198B2107721#701456, COL_A491737C_8260_4458_B5AB_C62EB2F51AD3#701457, COL_B5AB8C39_65AC_4D53_BAA5_DBBF3C8DB7C1#701458, COL_7AA4C73A_DC6A_44CD_8C39_15AAB4C90543#701459, COL_AA0C8437_CD05_4BF8_80C0_6439A67FF4FA#701460, COL_46209826_F20C_4414_99DC_BA47030E8C3C#701461, COL_6061C02E_9FBB_4C1B_8E43_6EF9A9E9E891#701462, COL_D29A9789_8993_40FA_A98C_8454B85ED4FB#701463, COL_7A9AFC29_9665_4D4A_B589_44F38E0A94F1#701464, COL_ED52C6A8_23AC_43F2_B299_8867259DF026#701465, COL_4881A9D8_1329_4A4A_910E_59042B5CE932#701466, COL_FF982E98_DCCD_4043_8435_DE530D020AA8#701467, COL_1694BFB5_637A_4D5B_AA2D_334AC46C0443#701468, COL_5224F32D_A010_4677_A17B_9AB686CA085C#701469, COL_FACC9EBD_FDC1_4DC5_824A_08A8AD104462#701470, COL_69091089_94DB_4A90_BEF5_8FCFBE7C69C3#701471, COL_3E4925F2_5633_4861_8AFE_4F701F9A2EDB#701472, COL_9B448507_59EC_45F5_B6E1_38D40E28D215#701473, COL_B2698104_9168_4D05_957D_59E5B4FD3EF2#701474, COL_80EFE2D3_F6B6_4563_97D2_2A7B27F4F20D#701475, COL_5D3F27F2_E23E_4F5E_9A87_75F0DFFBEEA6#701476, COL_DFA2A30E_9E67_42B6_A44C_BE4AADB6195E#701477]
Arguments: 1500

(18) AdaptiveSparkPlan
Output [51]: [COL_2BEC929B_7245_4A99_B35B_1828410B4BF0#701427, COL_2A283255_CC39_41B7_92F1_1047F45A0F3B#701428, COL_F88B641A_2B7E_4E14_BEE7_AEF87202B8CB#701429, COL_4A9B4D82_E445_4520_981F_889668A940FF#701430, COL_C632350C_9430_4517_B278_5A8B79D71E66#701431, COL_36B09FF4_7487_4F4A_B9D9_5FABB6FBDDF0#701432, COL_F85BA85B_A60F_4052_B747_21E05690611A#701433, COL_24207A3C_0F3D_4862_80B7_E14C3AEB277F#701434, COL_9144B6FF_C9D5_4D86_A012_83206F05D1F7#701435, COL_0F24FE2B_856C_424F_9EA6_F20265B657DD#701436, COL_B0FCE3C3_C86F_4189_A862_516F5DBB65E3#701437, COL_00F7CB07_9D06_4A80_A0A8_81C35DE10676#701438, COL_1C9724D1_030C_4B44_9E1F_D0683C3E87A8#701439, COL_1D368AEE_B86C_4AEE_A633_13BB7AB8F2C7#701440, COL_EA7B419A_3DA2_4415_AEF4_CA58F40EFA59#701441, COL_285E7375_054D_4A04_B093_4452067A0238#701442, COL_1DCA45AE_DA3F_4029_939D_3AF0F0622165#701443, COL_90534AEC_906D_48D2_870E_D3069A8111FC#701444, COL_CA834DCD_842A_4A0B_903E_EEF17839C18D#701445, COL_262A5830_607C_4AEB_A123_DF847D332979#701446, COL_86A04A16_9404_4152_9333_A10664B7E03E#701447, COL_D36BFE90_7046_4DF7_A779_1A6C217FEA2F#701448, COL_D1EFFEB2_6DED_47D9_9AE6_278DF0CC022D#701449, COL_FE17AF85_4178_42AA_84DA_456383471C71#701450, COL_DB9B6B77_1E55_452A_A88F_75E03A0BF30A#701451, COL_0D7BE518_0235_4959_B087_7FE87147B597#701452, COL_3F2E5E6F_DBBB_4C8B_8CD9_2F2100813AA0#701453, COL_56EDADE7_D5B3_42F5_91EE_AD46305E393B#701454, COL_FED75FCC_310F_4299_9B4C_E0175FC502DD#701455, COL_3FC87295_FA16_45CD_98F5_5198B2107721#701456, COL_A491737C_8260_4458_B5AB_C62EB2F51AD3#701457, COL_B5AB8C39_65AC_4D53_BAA5_DBBF3C8DB7C1#701458, COL_7AA4C73A_DC6A_44CD_8C39_15AAB4C90543#701459, COL_AA0C8437_CD05_4BF8_80C0_6439A67FF4FA#701460, COL_46209826_F20C_4414_99DC_BA47030E8C3C#701461, COL_6061C02E_9FBB_4C1B_8E43_6EF9A9E9E891#701462, COL_D29A9789_8993_40FA_A98C_8454B85ED4FB#701463, COL_7A9AFC29_9665_4D4A_B589_44F38E0A94F1#701464, COL_ED52C6A8_23AC_43F2_B299_8867259DF026#701465, COL_4881A9D8_1329_4A4A_910E_59042B5CE932#701466, COL_FF982E98_DCCD_4043_8435_DE530D020AA8#701467, COL_1694BFB5_637A_4D5B_AA2D_334AC46C0443#701468, COL_5224F32D_A010_4677_A17B_9AB686CA085C#701469, COL_FACC9EBD_FDC1_4DC5_824A_08A8AD104462#701470, COL_69091089_94DB_4A90_BEF5_8FCFBE7C69C3#701471, COL_3E4925F2_5633_4861_8AFE_4F701F9A2EDB#701472, COL_9B448507_59EC_45F5_B6E1_38D40E28D215#701473, COL_B2698104_9168_4D05_957D_59E5B4FD3EF2#701474, COL_80EFE2D3_F6B6_4563_97D2_2A7B27F4F20D#701475, COL_5D3F27F2_E23E_4F5E_9A87_75F0DFFBEEA6#701476, COL_DFA2A30E_9E67_42B6_A44C_BE4AADB6195E#701477]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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