hdh-spark-job - Details for Query 1385

Submitted Time: 2026/10/23 13:28:34
Duration: 1 s
Succeeded Jobs: 1383 1387 1390

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 (5)\n \nduration: 0 ms"; 2 [labelType="html" label="HashAggregate time in aggregation build: 0 ms number of output rows: 1"]; } 3 [labelType="html" label="Exchange shuffle records written: 1 local merged chunks fetched: 0 shuffle write time: 0 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 1 local bytes read: 59.0 B fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 16.0 B local merged bytes read: 0.0 B number of partitions: 1 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 59.0 B"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 6 ms"; 5 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 5 ms peak memory: 0.0 B number of output rows: 1 number of sort fallback tasks: 0 avg hash probes per key: 0"]; 6 [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"]; } 7 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 13.8 KiB number of coalesced partitions: 1"]; 8 [labelType="html" label="Exchange shuffle records written: 92 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 3 ms (1 ms, 1 ms, 1 ms (stage 2003.0: task 1747)) 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 2003.0: task 1747)) 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 2003.0: task 1747))"]; subgraph cluster9 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n389 ms (193 ms, 196 ms, 196 ms (stage 2003.0: task 1747))"; 10 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 368 ms (183 ms, 185 ms, 185 ms (stage 2003.0: task 1747)) peak memory total (min, med, max (stageId: taskId)) 128.5 MiB (64.2 MiB, 64.2 MiB, 64.2 MiB (stage 2003.0: task 1747)) 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 2003.0: task 1747))"]; } 11 [labelType="html" label=" Union "]; subgraph cluster12 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 195 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 \"xplore\".\"h_organ\") as x) [numPartitions=1] number of output rows: 6,195"]; } subgraph cluster16 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 192 ms"; 17 [labelType="html" label=" Project "]; 18 [labelType="html" label="Filter number of output rows: 46"]; 19 [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; 5->3; 6->5; 7->6; 8->7; 10->8; 11->10; 13->11; 14->13; 15->14; 17->11; 18->17; 19->18; }

AdaptiveSparkPlan isFinalPlan=true

HashAggregate(keys=[], functions=[count(1)])

WholeStageCodegen (5)

Exchange SinglePartition, ENSURE_REQUIREMENTS, [plan_id=37590]

HashAggregate(keys=[], functions=[partial_count(1)])

HashAggregate(keys=[ORIGINE_440148#698791, RG_ADR_1_437974#698792, RG_ADR_2_437975#698793, RG_ADR_3_438006#698794, RG_CMPIMP_F_437996#698795, RG_CMPIMP_H_437997#698796, RG_CODCAI_437986#698797, RG_CODCCP_437991#698798, RG_CODCEN_437987#698799, RG_CODORG_437971#698800, RG_CODPOS_437976#698801, RG_CODREG_437985#698802, RG_CODUTI_437990#698803, RG_COMMENT_438008#698804, RG_CONTAC_437982#698805, RG_DATEDE_438002#698806, RG_DATEFI_438003#698807, RG_DATENV_438001#698808, RG_DATMAJ_437989#698809, RG_E_MAIL_437980#698810, RG_FAX_437979#698811, RG_FLCHORUS_438015#698812, RG_FLLISENG_438017#698813, RG_FLPAV_438011#698814, ... 27 more fields], functions=[])

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(ORIGINE_440148#698791, RG_ADR_1_437974#698792, RG_ADR_2_437975#698793, RG_ADR_3_438006#698794, RG_CMPIMP_F_437996#698795, RG_CMPIMP_H_437997#698796, RG_CODCAI_437986#698797, RG_CODCCP_437991#698798, RG_CODCEN_437987#698799, RG_CODORG_437971#698800, RG_CODPOS_437976#698801, RG_CODREG_437985#698802, RG_CODUTI_437990#698803, RG_COMMENT_438008#698804, RG_CONTAC_437982#698805, RG_DATEDE_438002#698806, RG_DATEFI_438003#698807, RG_DATENV_438001#698808, RG_DATMAJ_437989#698809, RG_E_MAIL_437980#698810, RG_FAX_437979#698811, RG_FLCHORUS_438015#698812, RG_FLLISENG_438017#698813, RG_FLPAV_438011#698814, ... 28 more fields), ENSURE_REQUIREMENTS, [plan_id=37379]

WholeStageCodegen (3)

Union

Project [null AS ORIGINE_440148#698791, rg_adr_1#698444 AS RG_ADR_1_437974#698792, rg_adr_2#698445 AS RG_ADR_2_437975#698793, rg_adr_3#698476 AS RG_ADR_3_438006#698794, rg_cmpimp_f#698466 AS RG_CMPIMP_F_437996#698795, rg_cmpimp_h#698467 AS RG_CMPIMP_H_437997#698796, rg_codcai#698456 AS RG_CODCAI_437986#698797, rg_codccp#698461 AS RG_CODCCP_437991#698798, rg_codcen#698457 AS RG_CODCEN_437987#698799, rg_codorg#698441 AS RG_CODORG_437971#698800, rg_codpos#698446 AS RG_CODPOS_437976#698801, rg_codreg#698455 AS RG_CODREG_437985#698802, rg_coduti#698460 AS RG_CODUTI_437990#698803, rg_comment#698478 AS RG_COMMENT_438008#698804, rg_contac#698452 AS RG_CONTAC_437982#698805, rg_datede#698472 AS RG_DATEDE_438002#698806, rg_datefi#698473 AS RG_DATEFI_438003#698807, rg_datenv#698471 AS RG_DATENV_438001#698808, rg_datmaj#698459 AS RG_DATMAJ_437989#698809, rg_e_mail#698450 AS RG_E_MAIL_437980#698810, rg_fax#698449 AS RG_FAX_437979#698811, rg_flchorus#698485 AS RG_FLCHORUS_438015#698812, rg_flliseng#698487 AS RG_FLLISENG_438017#698813, rg_flpav#698481 AS RG_FLPAV_438011#698814, ... 27 more fields]

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codorg#698441)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codorg#698441)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typorg#698442)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_typorg#698442)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_nomorg#698443)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_nomorg#698443)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_1#698444)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_1#698444)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_2#698445)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_2#698445)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codpos#698446)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codpos#698446)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_ville#698447)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_ville#698447)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_telbur#698448)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_telbur#698448)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fax#698449)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fax#698449)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_e_mail#698450)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_e_mail#698450)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_prefix#698451)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_prefix#698451)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_contac#698452)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_contac#698452)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numbor#698453)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numbor#698453)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_tauxre#698454)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_tauxre#698454)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codreg#698455)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codreg#698455)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcai#698456)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcai#698456)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcen#698457)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcen#698457)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltele#698458)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltele#698458)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datmaj#698459)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datmaj#698459)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_coduti#698460)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_coduti#698460)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codccp#698461)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codccp#698461)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltp#698462)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltp#698462)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_idmut#698463)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_idmut#698463)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltopr#698464)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltopr#698464)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt#698465)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt#698465)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_f#698466)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_f#698466)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_h#698467)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_h#698467)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relctx#698468)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relctx#698468)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relpage#698469)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relpage#698469)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relref#698470)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relref#698470)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datenv#698471)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datenv#698471)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datede#698472)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datede#698472)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datefi#698473)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datefi#698473)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typoc#698474)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_typoc#698474)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_orgpayeur#698475)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_orgpayeur#698475)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_3#698476)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_3#698476)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notrel#698477)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_notrel#698477)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_comment#698478)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_comment#698478)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpecdep#698479)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpecdep#698479)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_a#698480)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_a#698480)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpav#698481)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpav#698481)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_reclam#698482)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_reclam#698482)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_trirel#698483)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_trirel#698483)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notbord#698484)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_notbord#698484)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flchorus#698485)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flchorus#698485)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numsir#698486)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numsir#698486)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flliseng#698487)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flliseng#698487)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_modreg#698488)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_modreg#698488)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c#698489)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c#698489)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c_ft#698490)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c_ft#698490)), 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#698444,rg_adr_2#698445,rg_adr_3#698476,rg_cmpimp_f#698466,rg_cmpimp_h#698467,rg_codcai#698456,rg_codccp#698461,rg_codcen#698457,rg_codorg#698441,rg_codpos#698446,rg_codreg#698455,rg_coduti#698460,rg_comment#698478,rg_contac#698452,rg_datede#698472,rg_datefi#698473,rg_datenv#698471,rg_datmaj#698459,rg_e_mail#698450,rg_fax#698449,rg_flchorus#698485,rg_flliseng#698487,rg_flpav#698481,rg_flpecdep#698479,... 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#699243, rg_adr_1#698896 AS RG_ADR_1_437974#699244, rg_adr_2#698897 AS RG_ADR_2_437975#699245, rg_adr_3#698928 AS RG_ADR_3_438006#699246, rg_cmpimp_f#698918 AS RG_CMPIMP_F_437996#699247, rg_cmpimp_h#698919 AS RG_CMPIMP_H_437997#699248, rg_codcai#698908 AS RG_CODCAI_437986#699249, rg_codccp#698913 AS RG_CODCCP_437991#699250, rg_codcen#698909 AS RG_CODCEN_437987#699251, rg_codorg#698893 AS RG_CODORG_437971#699252, rg_codpos#698898 AS RG_CODPOS_437976#699253, rg_codreg#698907 AS RG_CODREG_437985#699254, rg_coduti#698912 AS RG_CODUTI_437990#699255, rg_comment#698930 AS RG_COMMENT_438008#699256, rg_contac#698904 AS RG_CONTAC_437982#699257, rg_datede#698924 AS RG_DATEDE_438002#699258, rg_datefi#698925 AS RG_DATEFI_438003#699259, rg_datenv#698923 AS RG_DATENV_438001#699260, rg_datmaj#698911 AS RG_DATMAJ_437989#699261, rg_e_mail#698902 AS RG_E_MAIL_437980#699262, rg_fax#698901 AS RG_FAX_437979#699263, rg_flchorus#698937 AS RG_FLCHORUS_438015#699264, rg_flliseng#698939 AS RG_FLLISENG_438017#699265, rg_flpav#698933 AS RG_FLPAV_438011#699266, ... 27 more fields]

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codorg#698893)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codorg#698893)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typorg#698894)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_typorg#698894)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_nomorg#698895)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_nomorg#698895)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_1#698896)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_1#698896)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_2#698897)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_2#698897)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codpos#698898)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codpos#698898)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_ville#698899)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_ville#698899)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_telbur#698900)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_telbur#698900)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fax#698901)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fax#698901)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_e_mail#698902)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_e_mail#698902)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_prefix#698903)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_prefix#698903)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_contac#698904)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_contac#698904)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numbor#698905)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numbor#698905)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_tauxre#698906)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_tauxre#698906)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codreg#698907)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codreg#698907)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcai#698908)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcai#698908)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcen#698909)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcen#698909)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltele#698910)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltele#698910)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datmaj#698911)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datmaj#698911)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_coduti#698912)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_coduti#698912)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codccp#698913)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codccp#698913)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltp#698914)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltp#698914)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_idmut#698915)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_idmut#698915)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltopr#698916)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltopr#698916)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt#698917)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt#698917)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_f#698918)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_f#698918)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_h#698919)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_h#698919)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relctx#698920)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relctx#698920)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relpage#698921)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relpage#698921)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relref#698922)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relref#698922)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datenv#698923)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datenv#698923)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datede#698924)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datede#698924)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datefi#698925)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datefi#698925)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typoc#698926)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_typoc#698926)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_orgpayeur#698927)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_orgpayeur#698927)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_3#698928)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_3#698928)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notrel#698929)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_notrel#698929)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_comment#698930)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_comment#698930)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpecdep#698931)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpecdep#698931)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_a#698932)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_a#698932)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpav#698933)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpav#698933)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_reclam#698934)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_reclam#698934)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_trirel#698935)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_trirel#698935)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notbord#698936)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_notbord#698936)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flchorus#698937)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flchorus#698937)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numsir#698938)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numsir#698938)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flliseng#698939)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flliseng#698939)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_modreg#698940)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_modreg#698940)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c#698941)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c#698941)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c_ft#698942)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c_ft#698942)), 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#698896,rg_adr_2#698897,rg_adr_3#698928,rg_cmpimp_f#698918,rg_cmpimp_h#698919,rg_codcai#698908,rg_codccp#698913,rg_codcen#698909,rg_codorg#698893,rg_codpos#698898,rg_codreg#698907,rg_coduti#698912,rg_comment#698930,rg_contac#698904,rg_datede#698924,rg_datefi#698925,rg_datenv#698923,rg_datmaj#698911,rg_e_mail#698902,rg_fax#698901,rg_flchorus#698937,rg_flliseng#698939,rg_flpav#698933,rg_flpecdep#698931,... 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 (24)
+- == Final Plan ==
   * HashAggregate (16)
   +- ShuffleQueryStage (15), Statistics(sizeInBytes=16.0 B, rowCount=1)
      +- Exchange (14)
         +- * HashAggregate (13)
            +- * 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 ==
   HashAggregate (23)
   +- Exchange (22)
      +- HashAggregate (21)
         +- HashAggregate (20)
            +- Exchange (19)
               +- HashAggregate (18)
                  +- Union (17)
                     :- 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#698444, rg_adr_2#698445, rg_adr_3#698476, rg_cmpimp_f#698466, rg_cmpimp_h#698467, rg_codcai#698456, rg_codccp#698461, rg_codcen#698457, rg_codorg#698441, rg_codpos#698446, rg_codreg#698455, rg_coduti#698460, rg_comment#698478, rg_contac#698452, rg_datede#698472, rg_datefi#698473, rg_datenv#698471, rg_datmaj#698459, rg_e_mail#698450, rg_fax#698449, rg_flchorus#698485, rg_flliseng#698487, rg_flpav#698481, rg_flpecdep#698479, rg_fltele#698458, rg_fltopr#698464, rg_fltp#698462, rg_idmut#698463, rg_modreg#698488, rg_nomorg#698443, rg_notbord#698484, rg_notrel#698477, rg_numbor#698453, rg_numcpt#698465, rg_numcpt_a#698480, rg_numcpt_c#698489, rg_numcpt_c_ft#698490, rg_numsir#698486, rg_orgpayeur#698475, rg_prefix#698451, rg_reclam#698482, rg_relctx#698468, rg_relpage#698469, rg_relref#698470, rg_tauxre#698454, rg_telbur#698448, rg_trirel#698483, rg_typoc#698474, rg_typorg#698442, rg_ville#698447]
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#698444, rg_adr_2#698445, rg_adr_3#698476, rg_cmpimp_f#698466, rg_cmpimp_h#698467, rg_codcai#698456, rg_codccp#698461, rg_codcen#698457, rg_codorg#698441, rg_codpos#698446, rg_codreg#698455, rg_coduti#698460, rg_comment#698478, rg_contac#698452, rg_datede#698472, rg_datefi#698473, rg_datenv#698471, rg_datmaj#698459, rg_e_mail#698450, rg_fax#698449, rg_flchorus#698485, rg_flliseng#698487, rg_flpav#698481, rg_flpecdep#698479, rg_fltele#698458, rg_fltopr#698464, rg_fltp#698462, rg_idmut#698463, rg_modreg#698488, rg_nomorg#698443, rg_notbord#698484, rg_notrel#698477, rg_numbor#698453, rg_numcpt#698465, rg_numcpt_a#698480, rg_numcpt_c#698489, rg_numcpt_c_ft#698490, rg_numsir#698486, rg_orgpayeur#698475, rg_prefix#698451, rg_reclam#698482, rg_relctx#698468, rg_relpage#698469, rg_relref#698470, rg_tauxre#698454, rg_telbur#698448, rg_trirel#698483, rg_typoc#698474, rg_typorg#698442, rg_ville#698447]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codorg#698441)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codorg#698441)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typorg#698442)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_typorg#698442)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_nomorg#698443)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_nomorg#698443)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_1#698444)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_1#698444)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_2#698445)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_2#698445)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codpos#698446)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codpos#698446)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_ville#698447)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_ville#698447)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_telbur#698448)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_telbur#698448)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fax#698449)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fax#698449)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_e_mail#698450)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_e_mail#698450)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_prefix#698451)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_prefix#698451)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_contac#698452)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_contac#698452)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numbor#698453)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numbor#698453)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_tauxre#698454)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_tauxre#698454)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codreg#698455)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codreg#698455)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcai#698456)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcai#698456)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcen#698457)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcen#698457)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltele#698458)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltele#698458)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datmaj#698459)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datmaj#698459)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_coduti#698460)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_coduti#698460)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codccp#698461)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codccp#698461)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltp#698462)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltp#698462)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_idmut#698463)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_idmut#698463)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltopr#698464)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltopr#698464)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt#698465)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt#698465)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_f#698466)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_f#698466)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_h#698467)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_h#698467)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relctx#698468)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relctx#698468)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relpage#698469)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relpage#698469)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relref#698470)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relref#698470)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datenv#698471)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datenv#698471)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datede#698472)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datede#698472)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datefi#698473)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datefi#698473)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typoc#698474)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_typoc#698474)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_orgpayeur#698475)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_orgpayeur#698475)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_3#698476)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_3#698476)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notrel#698477)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_notrel#698477)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_comment#698478)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_comment#698478)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpecdep#698479)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpecdep#698479)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_a#698480)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_a#698480)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpav#698481)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpav#698481)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_reclam#698482)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_reclam#698482)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_trirel#698483)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_trirel#698483)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notbord#698484)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_notbord#698484)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flchorus#698485)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flchorus#698485)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numsir#698486)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numsir#698486)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flliseng#698487)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flliseng#698487)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_modreg#698488)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_modreg#698488)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c#698489)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c#698489)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c_ft#698490)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c_ft#698490)), 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#698791, rg_adr_1#698444 AS RG_ADR_1_437974#698792, rg_adr_2#698445 AS RG_ADR_2_437975#698793, rg_adr_3#698476 AS RG_ADR_3_438006#698794, rg_cmpimp_f#698466 AS RG_CMPIMP_F_437996#698795, rg_cmpimp_h#698467 AS RG_CMPIMP_H_437997#698796, rg_codcai#698456 AS RG_CODCAI_437986#698797, rg_codccp#698461 AS RG_CODCCP_437991#698798, rg_codcen#698457 AS RG_CODCEN_437987#698799, rg_codorg#698441 AS RG_CODORG_437971#698800, rg_codpos#698446 AS RG_CODPOS_437976#698801, rg_codreg#698455 AS RG_CODREG_437985#698802, rg_coduti#698460 AS RG_CODUTI_437990#698803, rg_comment#698478 AS RG_COMMENT_438008#698804, rg_contac#698452 AS RG_CONTAC_437982#698805, rg_datede#698472 AS RG_DATEDE_438002#698806, rg_datefi#698473 AS RG_DATEFI_438003#698807, rg_datenv#698471 AS RG_DATENV_438001#698808, rg_datmaj#698459 AS RG_DATMAJ_437989#698809, rg_e_mail#698450 AS RG_E_MAIL_437980#698810, rg_fax#698449 AS RG_FAX_437979#698811, rg_flchorus#698485 AS RG_FLCHORUS_438015#698812, rg_flliseng#698487 AS RG_FLLISENG_438017#698813, rg_flpav#698481 AS RG_FLPAV_438011#698814, rg_flpecdep#698479 AS RG_FLPECDEP_438009#698815, rg_fltele#698458 AS RG_FLTELE_437988#698816, rg_fltopr#698464 AS RG_FLTOPR_437994#698817, rg_fltp#698462 AS RG_FLTP_437992#698818, rg_idmut#698463 AS RG_IDMUT_437993#698819, rg_modreg#698488 AS RG_MODREG_438018#698820, rg_nomorg#698443 AS RG_NOMORG_437973#698821, rg_notbord#698484 AS RG_NOTBORD_438014#698822, rg_notrel#698477 AS RG_NOTREL_438007#698823, rg_numbor#698453 AS RG_NUMBOR_437983#698824, rg_numcpt#698465 AS RG_NUMCPT_437995#698825, rg_numcpt_a#698480 AS RG_NUMCPT_A_438010#698826, rg_numcpt_c#698489 AS RG_NUMCPT_C_438019#698827, rg_numcpt_c_ft#698490 AS RG_NUMCPT_C_FT_438020#698828, rg_numsir#698486 AS RG_NUMSIR_438016#698829, rg_orgpayeur#698475 AS RG_ORGPAYEUR_438005#698830, rg_prefix#698451 AS RG_PREFIX_437981#698831, rg_reclam#698482 AS RG_RECLAM_438012#698832, rg_relctx#698468 AS RG_RELCTX_437998#698833, rg_relpage#698469 AS RG_RELPAGE_437999#698834, rg_relref#698470 AS RG_RELREF_438000#698835, rg_tauxre#698454 AS RG_TAUXRE_437984#698836, rg_telbur#698448 AS RG_TELBUR_437978#698837, rg_trirel#698483 AS RG_TRIREL_438013#698838, rg_typoc#698474 AS RG_TYPOC_438004#698839, rg_typorg#698442 AS RG_TYPORG_437972#698840, rg_ville#698447 AS RG_VILLE_437977#698841]
Input [50]: [rg_adr_1#698444, rg_adr_2#698445, rg_adr_3#698476, rg_cmpimp_f#698466, rg_cmpimp_h#698467, rg_codcai#698456, rg_codccp#698461, rg_codcen#698457, rg_codorg#698441, rg_codpos#698446, rg_codreg#698455, rg_coduti#698460, rg_comment#698478, rg_contac#698452, rg_datede#698472, rg_datefi#698473, rg_datenv#698471, rg_datmaj#698459, rg_e_mail#698450, rg_fax#698449, rg_flchorus#698485, rg_flliseng#698487, rg_flpav#698481, rg_flpecdep#698479, rg_fltele#698458, rg_fltopr#698464, rg_fltp#698462, rg_idmut#698463, rg_modreg#698488, rg_nomorg#698443, rg_notbord#698484, rg_notrel#698477, rg_numbor#698453, rg_numcpt#698465, rg_numcpt_a#698480, rg_numcpt_c#698489, rg_numcpt_c_ft#698490, rg_numsir#698486, rg_orgpayeur#698475, rg_prefix#698451, rg_reclam#698482, rg_relctx#698468, rg_relpage#698469, rg_relref#698470, rg_tauxre#698454, rg_telbur#698448, rg_trirel#698483, rg_typoc#698474, rg_typorg#698442, rg_ville#698447]

(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#698896, rg_adr_2#698897, rg_adr_3#698928, rg_cmpimp_f#698918, rg_cmpimp_h#698919, rg_codcai#698908, rg_codccp#698913, rg_codcen#698909, rg_codorg#698893, rg_codpos#698898, rg_codreg#698907, rg_coduti#698912, rg_comment#698930, rg_contac#698904, rg_datede#698924, rg_datefi#698925, rg_datenv#698923, rg_datmaj#698911, rg_e_mail#698902, rg_fax#698901, rg_flchorus#698937, rg_flliseng#698939, rg_flpav#698933, rg_flpecdep#698931, rg_fltele#698910, rg_fltopr#698916, rg_fltp#698914, rg_idmut#698915, rg_modreg#698940, rg_nomorg#698895, rg_notbord#698936, rg_notrel#698929, rg_numbor#698905, rg_numcpt#698917, rg_numcpt_a#698932, rg_numcpt_c#698941, rg_numcpt_c_ft#698942, rg_numsir#698938, rg_orgpayeur#698927, rg_prefix#698903, rg_reclam#698934, rg_relctx#698920, rg_relpage#698921, rg_relref#698922, rg_tauxre#698906, rg_telbur#698900, rg_trirel#698935, rg_typoc#698926, rg_typorg#698894, rg_ville#698899]
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#698896, rg_adr_2#698897, rg_adr_3#698928, rg_cmpimp_f#698918, rg_cmpimp_h#698919, rg_codcai#698908, rg_codccp#698913, rg_codcen#698909, rg_codorg#698893, rg_codpos#698898, rg_codreg#698907, rg_coduti#698912, rg_comment#698930, rg_contac#698904, rg_datede#698924, rg_datefi#698925, rg_datenv#698923, rg_datmaj#698911, rg_e_mail#698902, rg_fax#698901, rg_flchorus#698937, rg_flliseng#698939, rg_flpav#698933, rg_flpecdep#698931, rg_fltele#698910, rg_fltopr#698916, rg_fltp#698914, rg_idmut#698915, rg_modreg#698940, rg_nomorg#698895, rg_notbord#698936, rg_notrel#698929, rg_numbor#698905, rg_numcpt#698917, rg_numcpt_a#698932, rg_numcpt_c#698941, rg_numcpt_c_ft#698942, rg_numsir#698938, rg_orgpayeur#698927, rg_prefix#698903, rg_reclam#698934, rg_relctx#698920, rg_relpage#698921, rg_relref#698922, rg_tauxre#698906, rg_telbur#698900, rg_trirel#698935, rg_typoc#698926, rg_typorg#698894, rg_ville#698899]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codorg#698893)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codorg#698893)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typorg#698894)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_typorg#698894)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_nomorg#698895)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_nomorg#698895)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_1#698896)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_1#698896)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_2#698897)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_2#698897)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codpos#698898)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codpos#698898)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_ville#698899)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_ville#698899)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_telbur#698900)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_telbur#698900)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fax#698901)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fax#698901)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_e_mail#698902)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_e_mail#698902)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_prefix#698903)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_prefix#698903)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_contac#698904)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_contac#698904)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numbor#698905)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numbor#698905)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_tauxre#698906)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_tauxre#698906)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codreg#698907)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codreg#698907)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcai#698908)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcai#698908)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcen#698909)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcen#698909)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltele#698910)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltele#698910)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datmaj#698911)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datmaj#698911)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_coduti#698912)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_coduti#698912)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codccp#698913)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codccp#698913)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltp#698914)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltp#698914)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_idmut#698915)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_idmut#698915)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltopr#698916)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltopr#698916)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt#698917)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt#698917)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_f#698918)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_f#698918)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_h#698919)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_h#698919)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relctx#698920)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relctx#698920)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relpage#698921)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relpage#698921)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relref#698922)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relref#698922)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datenv#698923)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datenv#698923)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datede#698924)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datede#698924)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datefi#698925)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datefi#698925)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typoc#698926)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_typoc#698926)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_orgpayeur#698927)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_orgpayeur#698927)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_3#698928)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_3#698928)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notrel#698929)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_notrel#698929)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_comment#698930)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_comment#698930)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpecdep#698931)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpecdep#698931)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_a#698932)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_a#698932)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpav#698933)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpav#698933)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_reclam#698934)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_reclam#698934)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_trirel#698935)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_trirel#698935)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notbord#698936)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_notbord#698936)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flchorus#698937)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flchorus#698937)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numsir#698938)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numsir#698938)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flliseng#698939)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flliseng#698939)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_modreg#698940)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_modreg#698940)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c#698941)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c#698941)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c_ft#698942)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c_ft#698942)), 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#699243, rg_adr_1#698896 AS RG_ADR_1_437974#699244, rg_adr_2#698897 AS RG_ADR_2_437975#699245, rg_adr_3#698928 AS RG_ADR_3_438006#699246, rg_cmpimp_f#698918 AS RG_CMPIMP_F_437996#699247, rg_cmpimp_h#698919 AS RG_CMPIMP_H_437997#699248, rg_codcai#698908 AS RG_CODCAI_437986#699249, rg_codccp#698913 AS RG_CODCCP_437991#699250, rg_codcen#698909 AS RG_CODCEN_437987#699251, rg_codorg#698893 AS RG_CODORG_437971#699252, rg_codpos#698898 AS RG_CODPOS_437976#699253, rg_codreg#698907 AS RG_CODREG_437985#699254, rg_coduti#698912 AS RG_CODUTI_437990#699255, rg_comment#698930 AS RG_COMMENT_438008#699256, rg_contac#698904 AS RG_CONTAC_437982#699257, rg_datede#698924 AS RG_DATEDE_438002#699258, rg_datefi#698925 AS RG_DATEFI_438003#699259, rg_datenv#698923 AS RG_DATENV_438001#699260, rg_datmaj#698911 AS RG_DATMAJ_437989#699261, rg_e_mail#698902 AS RG_E_MAIL_437980#699262, rg_fax#698901 AS RG_FAX_437979#699263, rg_flchorus#698937 AS RG_FLCHORUS_438015#699264, rg_flliseng#698939 AS RG_FLLISENG_438017#699265, rg_flpav#698933 AS RG_FLPAV_438011#699266, rg_flpecdep#698931 AS RG_FLPECDEP_438009#699267, rg_fltele#698910 AS RG_FLTELE_437988#699268, rg_fltopr#698916 AS RG_FLTOPR_437994#699269, rg_fltp#698914 AS RG_FLTP_437992#699270, rg_idmut#698915 AS RG_IDMUT_437993#699271, rg_modreg#698940 AS RG_MODREG_438018#699272, rg_nomorg#698895 AS RG_NOMORG_437973#699273, rg_notbord#698936 AS RG_NOTBORD_438014#699274, rg_notrel#698929 AS RG_NOTREL_438007#699275, rg_numbor#698905 AS RG_NUMBOR_437983#699276, rg_numcpt#698917 AS RG_NUMCPT_437995#699277, rg_numcpt_a#698932 AS RG_NUMCPT_A_438010#699278, rg_numcpt_c#698941 AS RG_NUMCPT_C_438019#699279, rg_numcpt_c_ft#698942 AS RG_NUMCPT_C_FT_438020#699280, rg_numsir#698938 AS RG_NUMSIR_438016#699281, rg_orgpayeur#698927 AS RG_ORGPAYEUR_438005#699282, rg_prefix#698903 AS RG_PREFIX_437981#699283, rg_reclam#698934 AS RG_RECLAM_438012#699284, rg_relctx#698920 AS RG_RELCTX_437998#699285, rg_relpage#698921 AS RG_RELPAGE_437999#699286, rg_relref#698922 AS RG_RELREF_438000#699287, rg_tauxre#698906 AS RG_TAUXRE_437984#699288, rg_telbur#698900 AS RG_TELBUR_437978#699289, rg_trirel#698935 AS RG_TRIREL_438013#699290, rg_typoc#698926 AS RG_TYPOC_438004#699291, rg_typorg#698894 AS RG_TYPORG_437972#699292, rg_ville#698899 AS RG_VILLE_437977#699293]
Input [50]: [rg_adr_1#698896, rg_adr_2#698897, rg_adr_3#698928, rg_cmpimp_f#698918, rg_cmpimp_h#698919, rg_codcai#698908, rg_codccp#698913, rg_codcen#698909, rg_codorg#698893, rg_codpos#698898, rg_codreg#698907, rg_coduti#698912, rg_comment#698930, rg_contac#698904, rg_datede#698924, rg_datefi#698925, rg_datenv#698923, rg_datmaj#698911, rg_e_mail#698902, rg_fax#698901, rg_flchorus#698937, rg_flliseng#698939, rg_flpav#698933, rg_flpecdep#698931, rg_fltele#698910, rg_fltopr#698916, rg_fltp#698914, rg_idmut#698915, rg_modreg#698940, rg_nomorg#698895, rg_notbord#698936, rg_notrel#698929, rg_numbor#698905, rg_numcpt#698917, rg_numcpt_a#698932, rg_numcpt_c#698941, rg_numcpt_c_ft#698942, rg_numsir#698938, rg_orgpayeur#698927, rg_prefix#698903, rg_reclam#698934, rg_relctx#698920, rg_relpage#698921, rg_relref#698922, rg_tauxre#698906, rg_telbur#698900, rg_trirel#698935, rg_typoc#698926, rg_typorg#698894, rg_ville#698899]

(7) Union

(8) HashAggregate [codegen id : 3]
Input [51]: [ORIGINE_440148#698791, RG_ADR_1_437974#698792, RG_ADR_2_437975#698793, RG_ADR_3_438006#698794, RG_CMPIMP_F_437996#698795, RG_CMPIMP_H_437997#698796, RG_CODCAI_437986#698797, RG_CODCCP_437991#698798, RG_CODCEN_437987#698799, RG_CODORG_437971#698800, RG_CODPOS_437976#698801, RG_CODREG_437985#698802, RG_CODUTI_437990#698803, RG_COMMENT_438008#698804, RG_CONTAC_437982#698805, RG_DATEDE_438002#698806, RG_DATEFI_438003#698807, RG_DATENV_438001#698808, RG_DATMAJ_437989#698809, RG_E_MAIL_437980#698810, RG_FAX_437979#698811, RG_FLCHORUS_438015#698812, RG_FLLISENG_438017#698813, RG_FLPAV_438011#698814, RG_FLPECDEP_438009#698815, RG_FLTELE_437988#698816, RG_FLTOPR_437994#698817, RG_FLTP_437992#698818, RG_IDMUT_437993#698819, RG_MODREG_438018#698820, RG_NOMORG_437973#698821, RG_NOTBORD_438014#698822, RG_NOTREL_438007#698823, RG_NUMBOR_437983#698824, RG_NUMCPT_437995#698825, RG_NUMCPT_A_438010#698826, RG_NUMCPT_C_438019#698827, RG_NUMCPT_C_FT_438020#698828, RG_NUMSIR_438016#698829, RG_ORGPAYEUR_438005#698830, RG_PREFIX_437981#698831, RG_RECLAM_438012#698832, RG_RELCTX_437998#698833, RG_RELPAGE_437999#698834, RG_RELREF_438000#698835, RG_TAUXRE_437984#698836, RG_TELBUR_437978#698837, RG_TRIREL_438013#698838, RG_TYPOC_438004#698839, RG_TYPORG_437972#698840, RG_VILLE_437977#698841]
Keys [51]: [ORIGINE_440148#698791, RG_ADR_1_437974#698792, RG_ADR_2_437975#698793, RG_ADR_3_438006#698794, RG_CMPIMP_F_437996#698795, RG_CMPIMP_H_437997#698796, RG_CODCAI_437986#698797, RG_CODCCP_437991#698798, RG_CODCEN_437987#698799, RG_CODORG_437971#698800, RG_CODPOS_437976#698801, RG_CODREG_437985#698802, RG_CODUTI_437990#698803, RG_COMMENT_438008#698804, RG_CONTAC_437982#698805, RG_DATEDE_438002#698806, RG_DATEFI_438003#698807, RG_DATENV_438001#698808, RG_DATMAJ_437989#698809, RG_E_MAIL_437980#698810, RG_FAX_437979#698811, RG_FLCHORUS_438015#698812, RG_FLLISENG_438017#698813, RG_FLPAV_438011#698814, RG_FLPECDEP_438009#698815, RG_FLTELE_437988#698816, RG_FLTOPR_437994#698817, RG_FLTP_437992#698818, RG_IDMUT_437993#698819, RG_MODREG_438018#698820, RG_NOMORG_437973#698821, RG_NOTBORD_438014#698822, RG_NOTREL_438007#698823, RG_NUMBOR_437983#698824, RG_NUMCPT_437995#698825, RG_NUMCPT_A_438010#698826, RG_NUMCPT_C_438019#698827, RG_NUMCPT_C_FT_438020#698828, RG_NUMSIR_438016#698829, RG_ORGPAYEUR_438005#698830, RG_PREFIX_437981#698831, RG_RECLAM_438012#698832, RG_RELCTX_437998#698833, RG_RELPAGE_437999#698834, RG_RELREF_438000#698835, RG_TAUXRE_437984#698836, RG_TELBUR_437978#698837, RG_TRIREL_438013#698838, RG_TYPOC_438004#698839, RG_TYPORG_437972#698840, RG_VILLE_437977#698841]
Functions: []
Aggregate Attributes: []
Results [51]: [ORIGINE_440148#698791, RG_ADR_1_437974#698792, RG_ADR_2_437975#698793, RG_ADR_3_438006#698794, RG_CMPIMP_F_437996#698795, RG_CMPIMP_H_437997#698796, RG_CODCAI_437986#698797, RG_CODCCP_437991#698798, RG_CODCEN_437987#698799, RG_CODORG_437971#698800, RG_CODPOS_437976#698801, RG_CODREG_437985#698802, RG_CODUTI_437990#698803, RG_COMMENT_438008#698804, RG_CONTAC_437982#698805, RG_DATEDE_438002#698806, RG_DATEFI_438003#698807, RG_DATENV_438001#698808, RG_DATMAJ_437989#698809, RG_E_MAIL_437980#698810, RG_FAX_437979#698811, RG_FLCHORUS_438015#698812, RG_FLLISENG_438017#698813, RG_FLPAV_438011#698814, RG_FLPECDEP_438009#698815, RG_FLTELE_437988#698816, RG_FLTOPR_437994#698817, RG_FLTP_437992#698818, RG_IDMUT_437993#698819, RG_MODREG_438018#698820, RG_NOMORG_437973#698821, RG_NOTBORD_438014#698822, RG_NOTREL_438007#698823, RG_NUMBOR_437983#698824, RG_NUMCPT_437995#698825, RG_NUMCPT_A_438010#698826, RG_NUMCPT_C_438019#698827, RG_NUMCPT_C_FT_438020#698828, RG_NUMSIR_438016#698829, RG_ORGPAYEUR_438005#698830, RG_PREFIX_437981#698831, RG_RECLAM_438012#698832, RG_RELCTX_437998#698833, RG_RELPAGE_437999#698834, RG_RELREF_438000#698835, RG_TAUXRE_437984#698836, RG_TELBUR_437978#698837, RG_TRIREL_438013#698838, RG_TYPOC_438004#698839, RG_TYPORG_437972#698840, RG_VILLE_437977#698841]

(9) Exchange
Input [51]: [ORIGINE_440148#698791, RG_ADR_1_437974#698792, RG_ADR_2_437975#698793, RG_ADR_3_438006#698794, RG_CMPIMP_F_437996#698795, RG_CMPIMP_H_437997#698796, RG_CODCAI_437986#698797, RG_CODCCP_437991#698798, RG_CODCEN_437987#698799, RG_CODORG_437971#698800, RG_CODPOS_437976#698801, RG_CODREG_437985#698802, RG_CODUTI_437990#698803, RG_COMMENT_438008#698804, RG_CONTAC_437982#698805, RG_DATEDE_438002#698806, RG_DATEFI_438003#698807, RG_DATENV_438001#698808, RG_DATMAJ_437989#698809, RG_E_MAIL_437980#698810, RG_FAX_437979#698811, RG_FLCHORUS_438015#698812, RG_FLLISENG_438017#698813, RG_FLPAV_438011#698814, RG_FLPECDEP_438009#698815, RG_FLTELE_437988#698816, RG_FLTOPR_437994#698817, RG_FLTP_437992#698818, RG_IDMUT_437993#698819, RG_MODREG_438018#698820, RG_NOMORG_437973#698821, RG_NOTBORD_438014#698822, RG_NOTREL_438007#698823, RG_NUMBOR_437983#698824, RG_NUMCPT_437995#698825, RG_NUMCPT_A_438010#698826, RG_NUMCPT_C_438019#698827, RG_NUMCPT_C_FT_438020#698828, RG_NUMSIR_438016#698829, RG_ORGPAYEUR_438005#698830, RG_PREFIX_437981#698831, RG_RECLAM_438012#698832, RG_RELCTX_437998#698833, RG_RELPAGE_437999#698834, RG_RELREF_438000#698835, RG_TAUXRE_437984#698836, RG_TELBUR_437978#698837, RG_TRIREL_438013#698838, RG_TYPOC_438004#698839, RG_TYPORG_437972#698840, RG_VILLE_437977#698841]
Arguments: hashpartitioning(ORIGINE_440148#698791, RG_ADR_1_437974#698792, RG_ADR_2_437975#698793, RG_ADR_3_438006#698794, RG_CMPIMP_F_437996#698795, RG_CMPIMP_H_437997#698796, RG_CODCAI_437986#698797, RG_CODCCP_437991#698798, RG_CODCEN_437987#698799, RG_CODORG_437971#698800, RG_CODPOS_437976#698801, RG_CODREG_437985#698802, RG_CODUTI_437990#698803, RG_COMMENT_438008#698804, RG_CONTAC_437982#698805, RG_DATEDE_438002#698806, RG_DATEFI_438003#698807, RG_DATENV_438001#698808, RG_DATMAJ_437989#698809, RG_E_MAIL_437980#698810, RG_FAX_437979#698811, RG_FLCHORUS_438015#698812, RG_FLLISENG_438017#698813, RG_FLPAV_438011#698814, ... 28 more fields), ENSURE_REQUIREMENTS, [plan_id=37379]

(10) ShuffleQueryStage
Output [51]: [ORIGINE_440148#698791, RG_ADR_1_437974#698792, RG_ADR_2_437975#698793, RG_ADR_3_438006#698794, RG_CMPIMP_F_437996#698795, RG_CMPIMP_H_437997#698796, RG_CODCAI_437986#698797, RG_CODCCP_437991#698798, RG_CODCEN_437987#698799, RG_CODORG_437971#698800, RG_CODPOS_437976#698801, RG_CODREG_437985#698802, RG_CODUTI_437990#698803, RG_COMMENT_438008#698804, RG_CONTAC_437982#698805, RG_DATEDE_438002#698806, RG_DATEFI_438003#698807, RG_DATENV_438001#698808, RG_DATMAJ_437989#698809, RG_E_MAIL_437980#698810, RG_FAX_437979#698811, RG_FLCHORUS_438015#698812, RG_FLLISENG_438017#698813, RG_FLPAV_438011#698814, RG_FLPECDEP_438009#698815, RG_FLTELE_437988#698816, RG_FLTOPR_437994#698817, RG_FLTP_437992#698818, RG_IDMUT_437993#698819, RG_MODREG_438018#698820, RG_NOMORG_437973#698821, RG_NOTBORD_438014#698822, RG_NOTREL_438007#698823, RG_NUMBOR_437983#698824, RG_NUMCPT_437995#698825, RG_NUMCPT_A_438010#698826, RG_NUMCPT_C_438019#698827, RG_NUMCPT_C_FT_438020#698828, RG_NUMSIR_438016#698829, RG_ORGPAYEUR_438005#698830, RG_PREFIX_437981#698831, RG_RECLAM_438012#698832, RG_RELCTX_437998#698833, RG_RELPAGE_437999#698834, RG_RELREF_438000#698835, RG_TAUXRE_437984#698836, RG_TELBUR_437978#698837, RG_TRIREL_438013#698838, RG_TYPOC_438004#698839, RG_TYPORG_437972#698840, RG_VILLE_437977#698841]
Arguments: 0

(11) AQEShuffleRead
Input [51]: [ORIGINE_440148#698791, RG_ADR_1_437974#698792, RG_ADR_2_437975#698793, RG_ADR_3_438006#698794, RG_CMPIMP_F_437996#698795, RG_CMPIMP_H_437997#698796, RG_CODCAI_437986#698797, RG_CODCCP_437991#698798, RG_CODCEN_437987#698799, RG_CODORG_437971#698800, RG_CODPOS_437976#698801, RG_CODREG_437985#698802, RG_CODUTI_437990#698803, RG_COMMENT_438008#698804, RG_CONTAC_437982#698805, RG_DATEDE_438002#698806, RG_DATEFI_438003#698807, RG_DATENV_438001#698808, RG_DATMAJ_437989#698809, RG_E_MAIL_437980#698810, RG_FAX_437979#698811, RG_FLCHORUS_438015#698812, RG_FLLISENG_438017#698813, RG_FLPAV_438011#698814, RG_FLPECDEP_438009#698815, RG_FLTELE_437988#698816, RG_FLTOPR_437994#698817, RG_FLTP_437992#698818, RG_IDMUT_437993#698819, RG_MODREG_438018#698820, RG_NOMORG_437973#698821, RG_NOTBORD_438014#698822, RG_NOTREL_438007#698823, RG_NUMBOR_437983#698824, RG_NUMCPT_437995#698825, RG_NUMCPT_A_438010#698826, RG_NUMCPT_C_438019#698827, RG_NUMCPT_C_FT_438020#698828, RG_NUMSIR_438016#698829, RG_ORGPAYEUR_438005#698830, RG_PREFIX_437981#698831, RG_RECLAM_438012#698832, RG_RELCTX_437998#698833, RG_RELPAGE_437999#698834, RG_RELREF_438000#698835, RG_TAUXRE_437984#698836, RG_TELBUR_437978#698837, RG_TRIREL_438013#698838, RG_TYPOC_438004#698839, RG_TYPORG_437972#698840, RG_VILLE_437977#698841]
Arguments: coalesced

(12) HashAggregate [codegen id : 4]
Input [51]: [ORIGINE_440148#698791, RG_ADR_1_437974#698792, RG_ADR_2_437975#698793, RG_ADR_3_438006#698794, RG_CMPIMP_F_437996#698795, RG_CMPIMP_H_437997#698796, RG_CODCAI_437986#698797, RG_CODCCP_437991#698798, RG_CODCEN_437987#698799, RG_CODORG_437971#698800, RG_CODPOS_437976#698801, RG_CODREG_437985#698802, RG_CODUTI_437990#698803, RG_COMMENT_438008#698804, RG_CONTAC_437982#698805, RG_DATEDE_438002#698806, RG_DATEFI_438003#698807, RG_DATENV_438001#698808, RG_DATMAJ_437989#698809, RG_E_MAIL_437980#698810, RG_FAX_437979#698811, RG_FLCHORUS_438015#698812, RG_FLLISENG_438017#698813, RG_FLPAV_438011#698814, RG_FLPECDEP_438009#698815, RG_FLTELE_437988#698816, RG_FLTOPR_437994#698817, RG_FLTP_437992#698818, RG_IDMUT_437993#698819, RG_MODREG_438018#698820, RG_NOMORG_437973#698821, RG_NOTBORD_438014#698822, RG_NOTREL_438007#698823, RG_NUMBOR_437983#698824, RG_NUMCPT_437995#698825, RG_NUMCPT_A_438010#698826, RG_NUMCPT_C_438019#698827, RG_NUMCPT_C_FT_438020#698828, RG_NUMSIR_438016#698829, RG_ORGPAYEUR_438005#698830, RG_PREFIX_437981#698831, RG_RECLAM_438012#698832, RG_RELCTX_437998#698833, RG_RELPAGE_437999#698834, RG_RELREF_438000#698835, RG_TAUXRE_437984#698836, RG_TELBUR_437978#698837, RG_TRIREL_438013#698838, RG_TYPOC_438004#698839, RG_TYPORG_437972#698840, RG_VILLE_437977#698841]
Keys [51]: [ORIGINE_440148#698791, RG_ADR_1_437974#698792, RG_ADR_2_437975#698793, RG_ADR_3_438006#698794, RG_CMPIMP_F_437996#698795, RG_CMPIMP_H_437997#698796, RG_CODCAI_437986#698797, RG_CODCCP_437991#698798, RG_CODCEN_437987#698799, RG_CODORG_437971#698800, RG_CODPOS_437976#698801, RG_CODREG_437985#698802, RG_CODUTI_437990#698803, RG_COMMENT_438008#698804, RG_CONTAC_437982#698805, RG_DATEDE_438002#698806, RG_DATEFI_438003#698807, RG_DATENV_438001#698808, RG_DATMAJ_437989#698809, RG_E_MAIL_437980#698810, RG_FAX_437979#698811, RG_FLCHORUS_438015#698812, RG_FLLISENG_438017#698813, RG_FLPAV_438011#698814, RG_FLPECDEP_438009#698815, RG_FLTELE_437988#698816, RG_FLTOPR_437994#698817, RG_FLTP_437992#698818, RG_IDMUT_437993#698819, RG_MODREG_438018#698820, RG_NOMORG_437973#698821, RG_NOTBORD_438014#698822, RG_NOTREL_438007#698823, RG_NUMBOR_437983#698824, RG_NUMCPT_437995#698825, RG_NUMCPT_A_438010#698826, RG_NUMCPT_C_438019#698827, RG_NUMCPT_C_FT_438020#698828, RG_NUMSIR_438016#698829, RG_ORGPAYEUR_438005#698830, RG_PREFIX_437981#698831, RG_RECLAM_438012#698832, RG_RELCTX_437998#698833, RG_RELPAGE_437999#698834, RG_RELREF_438000#698835, RG_TAUXRE_437984#698836, RG_TELBUR_437978#698837, RG_TRIREL_438013#698838, RG_TYPOC_438004#698839, RG_TYPORG_437972#698840, RG_VILLE_437977#698841]
Functions: []
Aggregate Attributes: []
Results: []

(13) HashAggregate [codegen id : 4]
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#700011L]
Results [1]: [count#700012L]

(14) Exchange
Input [1]: [count#700012L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=37590]

(15) ShuffleQueryStage
Output [1]: [count#700012L]
Arguments: 1

(16) HashAggregate [codegen id : 5]
Input [1]: [count#700012L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#700008L]
Results [1]: [count(1)#700008L AS count#700009L]

(17) Union

(18) HashAggregate
Input [51]: [ORIGINE_440148#698791, RG_ADR_1_437974#698792, RG_ADR_2_437975#698793, RG_ADR_3_438006#698794, RG_CMPIMP_F_437996#698795, RG_CMPIMP_H_437997#698796, RG_CODCAI_437986#698797, RG_CODCCP_437991#698798, RG_CODCEN_437987#698799, RG_CODORG_437971#698800, RG_CODPOS_437976#698801, RG_CODREG_437985#698802, RG_CODUTI_437990#698803, RG_COMMENT_438008#698804, RG_CONTAC_437982#698805, RG_DATEDE_438002#698806, RG_DATEFI_438003#698807, RG_DATENV_438001#698808, RG_DATMAJ_437989#698809, RG_E_MAIL_437980#698810, RG_FAX_437979#698811, RG_FLCHORUS_438015#698812, RG_FLLISENG_438017#698813, RG_FLPAV_438011#698814, RG_FLPECDEP_438009#698815, RG_FLTELE_437988#698816, RG_FLTOPR_437994#698817, RG_FLTP_437992#698818, RG_IDMUT_437993#698819, RG_MODREG_438018#698820, RG_NOMORG_437973#698821, RG_NOTBORD_438014#698822, RG_NOTREL_438007#698823, RG_NUMBOR_437983#698824, RG_NUMCPT_437995#698825, RG_NUMCPT_A_438010#698826, RG_NUMCPT_C_438019#698827, RG_NUMCPT_C_FT_438020#698828, RG_NUMSIR_438016#698829, RG_ORGPAYEUR_438005#698830, RG_PREFIX_437981#698831, RG_RECLAM_438012#698832, RG_RELCTX_437998#698833, RG_RELPAGE_437999#698834, RG_RELREF_438000#698835, RG_TAUXRE_437984#698836, RG_TELBUR_437978#698837, RG_TRIREL_438013#698838, RG_TYPOC_438004#698839, RG_TYPORG_437972#698840, RG_VILLE_437977#698841]
Keys [51]: [ORIGINE_440148#698791, RG_ADR_1_437974#698792, RG_ADR_2_437975#698793, RG_ADR_3_438006#698794, RG_CMPIMP_F_437996#698795, RG_CMPIMP_H_437997#698796, RG_CODCAI_437986#698797, RG_CODCCP_437991#698798, RG_CODCEN_437987#698799, RG_CODORG_437971#698800, RG_CODPOS_437976#698801, RG_CODREG_437985#698802, RG_CODUTI_437990#698803, RG_COMMENT_438008#698804, RG_CONTAC_437982#698805, RG_DATEDE_438002#698806, RG_DATEFI_438003#698807, RG_DATENV_438001#698808, RG_DATMAJ_437989#698809, RG_E_MAIL_437980#698810, RG_FAX_437979#698811, RG_FLCHORUS_438015#698812, RG_FLLISENG_438017#698813, RG_FLPAV_438011#698814, RG_FLPECDEP_438009#698815, RG_FLTELE_437988#698816, RG_FLTOPR_437994#698817, RG_FLTP_437992#698818, RG_IDMUT_437993#698819, RG_MODREG_438018#698820, RG_NOMORG_437973#698821, RG_NOTBORD_438014#698822, RG_NOTREL_438007#698823, RG_NUMBOR_437983#698824, RG_NUMCPT_437995#698825, RG_NUMCPT_A_438010#698826, RG_NUMCPT_C_438019#698827, RG_NUMCPT_C_FT_438020#698828, RG_NUMSIR_438016#698829, RG_ORGPAYEUR_438005#698830, RG_PREFIX_437981#698831, RG_RECLAM_438012#698832, RG_RELCTX_437998#698833, RG_RELPAGE_437999#698834, RG_RELREF_438000#698835, RG_TAUXRE_437984#698836, RG_TELBUR_437978#698837, RG_TRIREL_438013#698838, RG_TYPOC_438004#698839, RG_TYPORG_437972#698840, RG_VILLE_437977#698841]
Functions: []
Aggregate Attributes: []
Results [51]: [ORIGINE_440148#698791, RG_ADR_1_437974#698792, RG_ADR_2_437975#698793, RG_ADR_3_438006#698794, RG_CMPIMP_F_437996#698795, RG_CMPIMP_H_437997#698796, RG_CODCAI_437986#698797, RG_CODCCP_437991#698798, RG_CODCEN_437987#698799, RG_CODORG_437971#698800, RG_CODPOS_437976#698801, RG_CODREG_437985#698802, RG_CODUTI_437990#698803, RG_COMMENT_438008#698804, RG_CONTAC_437982#698805, RG_DATEDE_438002#698806, RG_DATEFI_438003#698807, RG_DATENV_438001#698808, RG_DATMAJ_437989#698809, RG_E_MAIL_437980#698810, RG_FAX_437979#698811, RG_FLCHORUS_438015#698812, RG_FLLISENG_438017#698813, RG_FLPAV_438011#698814, RG_FLPECDEP_438009#698815, RG_FLTELE_437988#698816, RG_FLTOPR_437994#698817, RG_FLTP_437992#698818, RG_IDMUT_437993#698819, RG_MODREG_438018#698820, RG_NOMORG_437973#698821, RG_NOTBORD_438014#698822, RG_NOTREL_438007#698823, RG_NUMBOR_437983#698824, RG_NUMCPT_437995#698825, RG_NUMCPT_A_438010#698826, RG_NUMCPT_C_438019#698827, RG_NUMCPT_C_FT_438020#698828, RG_NUMSIR_438016#698829, RG_ORGPAYEUR_438005#698830, RG_PREFIX_437981#698831, RG_RECLAM_438012#698832, RG_RELCTX_437998#698833, RG_RELPAGE_437999#698834, RG_RELREF_438000#698835, RG_TAUXRE_437984#698836, RG_TELBUR_437978#698837, RG_TRIREL_438013#698838, RG_TYPOC_438004#698839, RG_TYPORG_437972#698840, RG_VILLE_437977#698841]

(19) Exchange
Input [51]: [ORIGINE_440148#698791, RG_ADR_1_437974#698792, RG_ADR_2_437975#698793, RG_ADR_3_438006#698794, RG_CMPIMP_F_437996#698795, RG_CMPIMP_H_437997#698796, RG_CODCAI_437986#698797, RG_CODCCP_437991#698798, RG_CODCEN_437987#698799, RG_CODORG_437971#698800, RG_CODPOS_437976#698801, RG_CODREG_437985#698802, RG_CODUTI_437990#698803, RG_COMMENT_438008#698804, RG_CONTAC_437982#698805, RG_DATEDE_438002#698806, RG_DATEFI_438003#698807, RG_DATENV_438001#698808, RG_DATMAJ_437989#698809, RG_E_MAIL_437980#698810, RG_FAX_437979#698811, RG_FLCHORUS_438015#698812, RG_FLLISENG_438017#698813, RG_FLPAV_438011#698814, RG_FLPECDEP_438009#698815, RG_FLTELE_437988#698816, RG_FLTOPR_437994#698817, RG_FLTP_437992#698818, RG_IDMUT_437993#698819, RG_MODREG_438018#698820, RG_NOMORG_437973#698821, RG_NOTBORD_438014#698822, RG_NOTREL_438007#698823, RG_NUMBOR_437983#698824, RG_NUMCPT_437995#698825, RG_NUMCPT_A_438010#698826, RG_NUMCPT_C_438019#698827, RG_NUMCPT_C_FT_438020#698828, RG_NUMSIR_438016#698829, RG_ORGPAYEUR_438005#698830, RG_PREFIX_437981#698831, RG_RECLAM_438012#698832, RG_RELCTX_437998#698833, RG_RELPAGE_437999#698834, RG_RELREF_438000#698835, RG_TAUXRE_437984#698836, RG_TELBUR_437978#698837, RG_TRIREL_438013#698838, RG_TYPOC_438004#698839, RG_TYPORG_437972#698840, RG_VILLE_437977#698841]
Arguments: hashpartitioning(ORIGINE_440148#698791, RG_ADR_1_437974#698792, RG_ADR_2_437975#698793, RG_ADR_3_438006#698794, RG_CMPIMP_F_437996#698795, RG_CMPIMP_H_437997#698796, RG_CODCAI_437986#698797, RG_CODCCP_437991#698798, RG_CODCEN_437987#698799, RG_CODORG_437971#698800, RG_CODPOS_437976#698801, RG_CODREG_437985#698802, RG_CODUTI_437990#698803, RG_COMMENT_438008#698804, RG_CONTAC_437982#698805, RG_DATEDE_438002#698806, RG_DATEFI_438003#698807, RG_DATENV_438001#698808, RG_DATMAJ_437989#698809, RG_E_MAIL_437980#698810, RG_FAX_437979#698811, RG_FLCHORUS_438015#698812, RG_FLLISENG_438017#698813, RG_FLPAV_438011#698814, ... 28 more fields), ENSURE_REQUIREMENTS, [plan_id=37347]

(20) HashAggregate
Input [51]: [ORIGINE_440148#698791, RG_ADR_1_437974#698792, RG_ADR_2_437975#698793, RG_ADR_3_438006#698794, RG_CMPIMP_F_437996#698795, RG_CMPIMP_H_437997#698796, RG_CODCAI_437986#698797, RG_CODCCP_437991#698798, RG_CODCEN_437987#698799, RG_CODORG_437971#698800, RG_CODPOS_437976#698801, RG_CODREG_437985#698802, RG_CODUTI_437990#698803, RG_COMMENT_438008#698804, RG_CONTAC_437982#698805, RG_DATEDE_438002#698806, RG_DATEFI_438003#698807, RG_DATENV_438001#698808, RG_DATMAJ_437989#698809, RG_E_MAIL_437980#698810, RG_FAX_437979#698811, RG_FLCHORUS_438015#698812, RG_FLLISENG_438017#698813, RG_FLPAV_438011#698814, RG_FLPECDEP_438009#698815, RG_FLTELE_437988#698816, RG_FLTOPR_437994#698817, RG_FLTP_437992#698818, RG_IDMUT_437993#698819, RG_MODREG_438018#698820, RG_NOMORG_437973#698821, RG_NOTBORD_438014#698822, RG_NOTREL_438007#698823, RG_NUMBOR_437983#698824, RG_NUMCPT_437995#698825, RG_NUMCPT_A_438010#698826, RG_NUMCPT_C_438019#698827, RG_NUMCPT_C_FT_438020#698828, RG_NUMSIR_438016#698829, RG_ORGPAYEUR_438005#698830, RG_PREFIX_437981#698831, RG_RECLAM_438012#698832, RG_RELCTX_437998#698833, RG_RELPAGE_437999#698834, RG_RELREF_438000#698835, RG_TAUXRE_437984#698836, RG_TELBUR_437978#698837, RG_TRIREL_438013#698838, RG_TYPOC_438004#698839, RG_TYPORG_437972#698840, RG_VILLE_437977#698841]
Keys [51]: [ORIGINE_440148#698791, RG_ADR_1_437974#698792, RG_ADR_2_437975#698793, RG_ADR_3_438006#698794, RG_CMPIMP_F_437996#698795, RG_CMPIMP_H_437997#698796, RG_CODCAI_437986#698797, RG_CODCCP_437991#698798, RG_CODCEN_437987#698799, RG_CODORG_437971#698800, RG_CODPOS_437976#698801, RG_CODREG_437985#698802, RG_CODUTI_437990#698803, RG_COMMENT_438008#698804, RG_CONTAC_437982#698805, RG_DATEDE_438002#698806, RG_DATEFI_438003#698807, RG_DATENV_438001#698808, RG_DATMAJ_437989#698809, RG_E_MAIL_437980#698810, RG_FAX_437979#698811, RG_FLCHORUS_438015#698812, RG_FLLISENG_438017#698813, RG_FLPAV_438011#698814, RG_FLPECDEP_438009#698815, RG_FLTELE_437988#698816, RG_FLTOPR_437994#698817, RG_FLTP_437992#698818, RG_IDMUT_437993#698819, RG_MODREG_438018#698820, RG_NOMORG_437973#698821, RG_NOTBORD_438014#698822, RG_NOTREL_438007#698823, RG_NUMBOR_437983#698824, RG_NUMCPT_437995#698825, RG_NUMCPT_A_438010#698826, RG_NUMCPT_C_438019#698827, RG_NUMCPT_C_FT_438020#698828, RG_NUMSIR_438016#698829, RG_ORGPAYEUR_438005#698830, RG_PREFIX_437981#698831, RG_RECLAM_438012#698832, RG_RELCTX_437998#698833, RG_RELPAGE_437999#698834, RG_RELREF_438000#698835, RG_TAUXRE_437984#698836, RG_TELBUR_437978#698837, RG_TRIREL_438013#698838, RG_TYPOC_438004#698839, RG_TYPORG_437972#698840, RG_VILLE_437977#698841]
Functions: []
Aggregate Attributes: []
Results: []

(21) HashAggregate
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#700011L]
Results [1]: [count#700012L]

(22) Exchange
Input [1]: [count#700012L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=37351]

(23) HashAggregate
Input [1]: [count#700012L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#700008L]
Results [1]: [count(1)#700008L AS count#700009L]

(24) AdaptiveSparkPlan
Output [1]: [count#700009L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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