hdh-spark-job - Details for Query 1364

Submitted Time: 2026/10/23 13:28:07
Duration: 1 s
Succeeded Jobs: 1361 1363 1365

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: 6 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 1967.0: task 1716)) 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 1967.0: task 1717)) 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 1967.0: task 1717))"]; subgraph cluster9 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n410 ms (203 ms, 207 ms, 207 ms (stage 1967.0: task 1717))"; 10 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 388 ms (191 ms, 197 ms, 197 ms (stage 1967.0: task 1717)) peak memory total (min, med, max (stageId: taskId)) 128.5 MiB (64.2 MiB, 64.2 MiB, 64.2 MiB (stage 1967.0: task 1717)) 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 1967.0: task 1717))"]; } 11 [labelType="html" label=" Union "]; subgraph cluster12 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 202 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: 206 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=36851]

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

HashAggregate(keys=[ORIGINE_440148#673708, RG_ADR_1_437974#673709, RG_ADR_2_437975#673710, RG_ADR_3_438006#673711, RG_CMPIMP_F_437996#673712, RG_CMPIMP_H_437997#673713, RG_CODCAI_437986#673714, RG_CODCCP_437991#673715, RG_CODCEN_437987#673716, RG_CODORG_437971#673717, RG_CODPOS_437976#673718, RG_CODREG_437985#673719, RG_CODUTI_437990#673720, RG_COMMENT_438008#673721, RG_CONTAC_437982#673722, RG_DATEDE_438002#673723, RG_DATEFI_438003#673724, RG_DATENV_438001#673725, RG_DATMAJ_437989#673726, RG_E_MAIL_437980#673727, RG_FAX_437979#673728, RG_FLCHORUS_438015#673729, RG_FLLISENG_438017#673730, RG_FLPAV_438011#673731, ... 27 more fields], functions=[])

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(ORIGINE_440148#673708, RG_ADR_1_437974#673709, RG_ADR_2_437975#673710, RG_ADR_3_438006#673711, RG_CMPIMP_F_437996#673712, RG_CMPIMP_H_437997#673713, RG_CODCAI_437986#673714, RG_CODCCP_437991#673715, RG_CODCEN_437987#673716, RG_CODORG_437971#673717, RG_CODPOS_437976#673718, RG_CODREG_437985#673719, RG_CODUTI_437990#673720, RG_COMMENT_438008#673721, RG_CONTAC_437982#673722, RG_DATEDE_438002#673723, RG_DATEFI_438003#673724, RG_DATENV_438001#673725, RG_DATMAJ_437989#673726, RG_E_MAIL_437980#673727, RG_FAX_437979#673728, RG_FLCHORUS_438015#673729, RG_FLLISENG_438017#673730, RG_FLPAV_438011#673731, ... 28 more fields), ENSURE_REQUIREMENTS, [plan_id=36637]

WholeStageCodegen (3)

Union

Project [null AS ORIGINE_440148#673708, rg_adr_1#673201 AS RG_ADR_1_437974#673709, rg_adr_2#673202 AS RG_ADR_2_437975#673710, rg_adr_3#673233 AS RG_ADR_3_438006#673711, rg_cmpimp_f#673223 AS RG_CMPIMP_F_437996#673712, rg_cmpimp_h#673224 AS RG_CMPIMP_H_437997#673713, rg_codcai#673213 AS RG_CODCAI_437986#673714, rg_codccp#673218 AS RG_CODCCP_437991#673715, rg_codcen#673214 AS RG_CODCEN_437987#673716, rg_codorg#673198 AS RG_CODORG_437971#673717, rg_codpos#673203 AS RG_CODPOS_437976#673718, rg_codreg#673212 AS RG_CODREG_437985#673719, rg_coduti#673217 AS RG_CODUTI_437990#673720, rg_comment#673235 AS RG_COMMENT_438008#673721, rg_contac#673209 AS RG_CONTAC_437982#673722, rg_datede#673229 AS RG_DATEDE_438002#673723, rg_datefi#673230 AS RG_DATEFI_438003#673724, rg_datenv#673228 AS RG_DATENV_438001#673725, rg_datmaj#673216 AS RG_DATMAJ_437989#673726, rg_e_mail#673207 AS RG_E_MAIL_437980#673727, rg_fax#673206 AS RG_FAX_437979#673728, rg_flchorus#673242 AS RG_FLCHORUS_438015#673729, rg_flliseng#673244 AS RG_FLLISENG_438017#673730, rg_flpav#673238 AS RG_FLPAV_438011#673731, ... 27 more fields]

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codorg#673198)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codorg#673198)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typorg#673199)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_typorg#673199)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_nomorg#673200)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_nomorg#673200)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_1#673201)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_1#673201)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_2#673202)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_2#673202)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codpos#673203)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codpos#673203)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_ville#673204)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_ville#673204)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_telbur#673205)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_telbur#673205)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fax#673206)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fax#673206)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_e_mail#673207)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_e_mail#673207)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_prefix#673208)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_prefix#673208)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_contac#673209)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_contac#673209)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numbor#673210)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numbor#673210)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_tauxre#673211)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_tauxre#673211)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codreg#673212)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codreg#673212)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcai#673213)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcai#673213)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcen#673214)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcen#673214)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltele#673215)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltele#673215)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datmaj#673216)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datmaj#673216)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_coduti#673217)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_coduti#673217)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codccp#673218)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codccp#673218)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltp#673219)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltp#673219)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_idmut#673220)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_idmut#673220)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltopr#673221)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltopr#673221)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt#673222)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt#673222)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_f#673223)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_f#673223)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_h#673224)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_h#673224)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relctx#673225)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relctx#673225)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relpage#673226)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relpage#673226)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relref#673227)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relref#673227)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datenv#673228)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datenv#673228)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datede#673229)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datede#673229)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datefi#673230)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datefi#673230)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typoc#673231)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_typoc#673231)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_orgpayeur#673232)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_orgpayeur#673232)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_3#673233)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_3#673233)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notrel#673234)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_notrel#673234)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_comment#673235)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_comment#673235)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpecdep#673236)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpecdep#673236)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_a#673237)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_a#673237)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpav#673238)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpav#673238)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_reclam#673239)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_reclam#673239)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_trirel#673240)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_trirel#673240)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notbord#673241)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_notbord#673241)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flchorus#673242)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flchorus#673242)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numsir#673243)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numsir#673243)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flliseng#673244)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flliseng#673244)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_modreg#673245)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_modreg#673245)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c#673246)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c#673246)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c_ft#673247)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c_ft#673247)), 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#673201,rg_adr_2#673202,rg_adr_3#673233,rg_cmpimp_f#673223,rg_cmpimp_h#673224,rg_codcai#673213,rg_codccp#673218,rg_codcen#673214,rg_codorg#673198,rg_codpos#673203,rg_codreg#673212,rg_coduti#673217,rg_comment#673235,rg_contac#673209,rg_datede#673229,rg_datefi#673230,rg_datenv#673228,rg_datmaj#673216,rg_e_mail#673207,rg_fax#673206,rg_flchorus#673242,rg_flliseng#673244,rg_flpav#673238,rg_flpecdep#673236,... 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#674444, rg_adr_1#674000 AS RG_ADR_1_437974#674445, rg_adr_2#674001 AS RG_ADR_2_437975#674446, rg_adr_3#674033 AS RG_ADR_3_438006#674447, rg_cmpimp_f#674023 AS RG_CMPIMP_F_437996#674448, rg_cmpimp_h#674024 AS RG_CMPIMP_H_437997#674449, rg_codcai#674012 AS RG_CODCAI_437986#674450, rg_codccp#674018 AS RG_CODCCP_437991#674451, rg_codcen#674013 AS RG_CODCEN_437987#674452, rg_codorg#673997 AS RG_CODORG_437971#674453, rg_codpos#674002 AS RG_CODPOS_437976#674454, rg_codreg#674011 AS RG_CODREG_437985#674455, rg_coduti#674016 AS RG_CODUTI_437990#674456, rg_comment#674035 AS RG_COMMENT_438008#674457, rg_contac#674008 AS RG_CONTAC_437982#674458, rg_datede#674029 AS RG_DATEDE_438002#674459, rg_datefi#674030 AS RG_DATEFI_438003#674460, rg_datenv#674028 AS RG_DATENV_438001#674461, rg_datmaj#674015 AS RG_DATMAJ_437989#674462, rg_e_mail#674006 AS RG_E_MAIL_437980#674463, rg_fax#674005 AS RG_FAX_437979#674464, rg_flchorus#674042 AS RG_FLCHORUS_438015#674465, rg_flliseng#674044 AS RG_FLLISENG_438017#674466, rg_flpav#674038 AS RG_FLPAV_438011#674467, ... 27 more fields]

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codorg#673997)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codorg#673997)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typorg#673998)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_typorg#673998)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_nomorg#673999)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_nomorg#673999)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_1#674000)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_1#674000)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_2#674001)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_2#674001)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codpos#674002)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codpos#674002)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_ville#674003)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_ville#674003)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_telbur#674004)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_telbur#674004)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fax#674005)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fax#674005)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_e_mail#674006)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_e_mail#674006)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_prefix#674007)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_prefix#674007)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_contac#674008)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_contac#674008)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numbor#674009)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numbor#674009)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_tauxre#674010)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_tauxre#674010)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codreg#674011)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codreg#674011)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcai#674012)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcai#674012)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcen#674013)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcen#674013)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltele#674014)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltele#674014)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datmaj#674015)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datmaj#674015)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_coduti#674016)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_coduti#674016)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codccp#674018)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codccp#674018)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltp#674019)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltp#674019)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_idmut#674020)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_idmut#674020)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltopr#674021)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltopr#674021)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt#674022)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt#674022)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_f#674023)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_f#674023)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_h#674024)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_h#674024)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relctx#674025)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relctx#674025)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relpage#674026)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relpage#674026)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relref#674027)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relref#674027)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datenv#674028)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datenv#674028)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datede#674029)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datede#674029)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datefi#674030)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datefi#674030)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typoc#674031)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_typoc#674031)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_orgpayeur#674032)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_orgpayeur#674032)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_3#674033)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_3#674033)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notrel#674034)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_notrel#674034)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_comment#674035)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_comment#674035)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpecdep#674036)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpecdep#674036)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_a#674037)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_a#674037)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpav#674038)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpav#674038)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_reclam#674039)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_reclam#674039)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_trirel#674040)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_trirel#674040)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notbord#674041)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_notbord#674041)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flchorus#674042)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flchorus#674042)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numsir#674043)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numsir#674043)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flliseng#674044)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flliseng#674044)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_modreg#674045)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_modreg#674045)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c#674046)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c#674046)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c_ft#674047)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c_ft#674047)), 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#674000,rg_adr_2#674001,rg_adr_3#674033,rg_cmpimp_f#674023,rg_cmpimp_h#674024,rg_codcai#674012,rg_codccp#674018,rg_codcen#674013,rg_codorg#673997,rg_codpos#674002,rg_codreg#674011,rg_coduti#674016,rg_comment#674035,rg_contac#674008,rg_datede#674029,rg_datefi#674030,rg_datenv#674028,rg_datmaj#674015,rg_e_mail#674006,rg_fax#674005,rg_flchorus#674042,rg_flliseng#674044,rg_flpav#674038,rg_flpecdep#674036,... 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#673201, rg_adr_2#673202, rg_adr_3#673233, rg_cmpimp_f#673223, rg_cmpimp_h#673224, rg_codcai#673213, rg_codccp#673218, rg_codcen#673214, rg_codorg#673198, rg_codpos#673203, rg_codreg#673212, rg_coduti#673217, rg_comment#673235, rg_contac#673209, rg_datede#673229, rg_datefi#673230, rg_datenv#673228, rg_datmaj#673216, rg_e_mail#673207, rg_fax#673206, rg_flchorus#673242, rg_flliseng#673244, rg_flpav#673238, rg_flpecdep#673236, rg_fltele#673215, rg_fltopr#673221, rg_fltp#673219, rg_idmut#673220, rg_modreg#673245, rg_nomorg#673200, rg_notbord#673241, rg_notrel#673234, rg_numbor#673210, rg_numcpt#673222, rg_numcpt_a#673237, rg_numcpt_c#673246, rg_numcpt_c_ft#673247, rg_numsir#673243, rg_orgpayeur#673232, rg_prefix#673208, rg_reclam#673239, rg_relctx#673225, rg_relpage#673226, rg_relref#673227, rg_tauxre#673211, rg_telbur#673205, rg_trirel#673240, rg_typoc#673231, rg_typorg#673199, rg_ville#673204]
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#673201, rg_adr_2#673202, rg_adr_3#673233, rg_cmpimp_f#673223, rg_cmpimp_h#673224, rg_codcai#673213, rg_codccp#673218, rg_codcen#673214, rg_codorg#673198, rg_codpos#673203, rg_codreg#673212, rg_coduti#673217, rg_comment#673235, rg_contac#673209, rg_datede#673229, rg_datefi#673230, rg_datenv#673228, rg_datmaj#673216, rg_e_mail#673207, rg_fax#673206, rg_flchorus#673242, rg_flliseng#673244, rg_flpav#673238, rg_flpecdep#673236, rg_fltele#673215, rg_fltopr#673221, rg_fltp#673219, rg_idmut#673220, rg_modreg#673245, rg_nomorg#673200, rg_notbord#673241, rg_notrel#673234, rg_numbor#673210, rg_numcpt#673222, rg_numcpt_a#673237, rg_numcpt_c#673246, rg_numcpt_c_ft#673247, rg_numsir#673243, rg_orgpayeur#673232, rg_prefix#673208, rg_reclam#673239, rg_relctx#673225, rg_relpage#673226, rg_relref#673227, rg_tauxre#673211, rg_telbur#673205, rg_trirel#673240, rg_typoc#673231, rg_typorg#673199, rg_ville#673204]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codorg#673198)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codorg#673198)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typorg#673199)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_typorg#673199)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_nomorg#673200)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_nomorg#673200)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_1#673201)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_1#673201)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_2#673202)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_2#673202)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codpos#673203)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codpos#673203)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_ville#673204)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_ville#673204)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_telbur#673205)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_telbur#673205)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fax#673206)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fax#673206)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_e_mail#673207)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_e_mail#673207)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_prefix#673208)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_prefix#673208)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_contac#673209)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_contac#673209)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numbor#673210)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numbor#673210)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_tauxre#673211)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_tauxre#673211)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codreg#673212)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codreg#673212)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcai#673213)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcai#673213)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcen#673214)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcen#673214)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltele#673215)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltele#673215)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datmaj#673216)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datmaj#673216)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_coduti#673217)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_coduti#673217)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codccp#673218)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codccp#673218)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltp#673219)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltp#673219)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_idmut#673220)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_idmut#673220)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltopr#673221)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltopr#673221)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt#673222)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt#673222)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_f#673223)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_f#673223)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_h#673224)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_h#673224)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relctx#673225)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relctx#673225)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relpage#673226)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relpage#673226)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relref#673227)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relref#673227)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datenv#673228)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datenv#673228)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datede#673229)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datede#673229)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datefi#673230)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datefi#673230)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typoc#673231)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_typoc#673231)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_orgpayeur#673232)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_orgpayeur#673232)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_3#673233)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_3#673233)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notrel#673234)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_notrel#673234)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_comment#673235)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_comment#673235)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpecdep#673236)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpecdep#673236)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_a#673237)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_a#673237)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpav#673238)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpav#673238)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_reclam#673239)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_reclam#673239)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_trirel#673240)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_trirel#673240)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notbord#673241)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_notbord#673241)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flchorus#673242)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flchorus#673242)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numsir#673243)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numsir#673243)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flliseng#673244)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flliseng#673244)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_modreg#673245)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_modreg#673245)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c#673246)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c#673246)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c_ft#673247)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c_ft#673247)), 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#673708, rg_adr_1#673201 AS RG_ADR_1_437974#673709, rg_adr_2#673202 AS RG_ADR_2_437975#673710, rg_adr_3#673233 AS RG_ADR_3_438006#673711, rg_cmpimp_f#673223 AS RG_CMPIMP_F_437996#673712, rg_cmpimp_h#673224 AS RG_CMPIMP_H_437997#673713, rg_codcai#673213 AS RG_CODCAI_437986#673714, rg_codccp#673218 AS RG_CODCCP_437991#673715, rg_codcen#673214 AS RG_CODCEN_437987#673716, rg_codorg#673198 AS RG_CODORG_437971#673717, rg_codpos#673203 AS RG_CODPOS_437976#673718, rg_codreg#673212 AS RG_CODREG_437985#673719, rg_coduti#673217 AS RG_CODUTI_437990#673720, rg_comment#673235 AS RG_COMMENT_438008#673721, rg_contac#673209 AS RG_CONTAC_437982#673722, rg_datede#673229 AS RG_DATEDE_438002#673723, rg_datefi#673230 AS RG_DATEFI_438003#673724, rg_datenv#673228 AS RG_DATENV_438001#673725, rg_datmaj#673216 AS RG_DATMAJ_437989#673726, rg_e_mail#673207 AS RG_E_MAIL_437980#673727, rg_fax#673206 AS RG_FAX_437979#673728, rg_flchorus#673242 AS RG_FLCHORUS_438015#673729, rg_flliseng#673244 AS RG_FLLISENG_438017#673730, rg_flpav#673238 AS RG_FLPAV_438011#673731, rg_flpecdep#673236 AS RG_FLPECDEP_438009#673732, rg_fltele#673215 AS RG_FLTELE_437988#673733, rg_fltopr#673221 AS RG_FLTOPR_437994#673734, rg_fltp#673219 AS RG_FLTP_437992#673735, rg_idmut#673220 AS RG_IDMUT_437993#673736, rg_modreg#673245 AS RG_MODREG_438018#673737, rg_nomorg#673200 AS RG_NOMORG_437973#673738, rg_notbord#673241 AS RG_NOTBORD_438014#673739, rg_notrel#673234 AS RG_NOTREL_438007#673740, rg_numbor#673210 AS RG_NUMBOR_437983#673741, rg_numcpt#673222 AS RG_NUMCPT_437995#673742, rg_numcpt_a#673237 AS RG_NUMCPT_A_438010#673743, rg_numcpt_c#673246 AS RG_NUMCPT_C_438019#673744, rg_numcpt_c_ft#673247 AS RG_NUMCPT_C_FT_438020#673745, rg_numsir#673243 AS RG_NUMSIR_438016#673746, rg_orgpayeur#673232 AS RG_ORGPAYEUR_438005#673747, rg_prefix#673208 AS RG_PREFIX_437981#673748, rg_reclam#673239 AS RG_RECLAM_438012#673749, rg_relctx#673225 AS RG_RELCTX_437998#673750, rg_relpage#673226 AS RG_RELPAGE_437999#673751, rg_relref#673227 AS RG_RELREF_438000#673752, rg_tauxre#673211 AS RG_TAUXRE_437984#673753, rg_telbur#673205 AS RG_TELBUR_437978#673754, rg_trirel#673240 AS RG_TRIREL_438013#673755, rg_typoc#673231 AS RG_TYPOC_438004#673756, rg_typorg#673199 AS RG_TYPORG_437972#673757, rg_ville#673204 AS RG_VILLE_437977#673758]
Input [50]: [rg_adr_1#673201, rg_adr_2#673202, rg_adr_3#673233, rg_cmpimp_f#673223, rg_cmpimp_h#673224, rg_codcai#673213, rg_codccp#673218, rg_codcen#673214, rg_codorg#673198, rg_codpos#673203, rg_codreg#673212, rg_coduti#673217, rg_comment#673235, rg_contac#673209, rg_datede#673229, rg_datefi#673230, rg_datenv#673228, rg_datmaj#673216, rg_e_mail#673207, rg_fax#673206, rg_flchorus#673242, rg_flliseng#673244, rg_flpav#673238, rg_flpecdep#673236, rg_fltele#673215, rg_fltopr#673221, rg_fltp#673219, rg_idmut#673220, rg_modreg#673245, rg_nomorg#673200, rg_notbord#673241, rg_notrel#673234, rg_numbor#673210, rg_numcpt#673222, rg_numcpt_a#673237, rg_numcpt_c#673246, rg_numcpt_c_ft#673247, rg_numsir#673243, rg_orgpayeur#673232, rg_prefix#673208, rg_reclam#673239, rg_relctx#673225, rg_relpage#673226, rg_relref#673227, rg_tauxre#673211, rg_telbur#673205, rg_trirel#673240, rg_typoc#673231, rg_typorg#673199, rg_ville#673204]

(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#674000, rg_adr_2#674001, rg_adr_3#674033, rg_cmpimp_f#674023, rg_cmpimp_h#674024, rg_codcai#674012, rg_codccp#674018, rg_codcen#674013, rg_codorg#673997, rg_codpos#674002, rg_codreg#674011, rg_coduti#674016, rg_comment#674035, rg_contac#674008, rg_datede#674029, rg_datefi#674030, rg_datenv#674028, rg_datmaj#674015, rg_e_mail#674006, rg_fax#674005, rg_flchorus#674042, rg_flliseng#674044, rg_flpav#674038, rg_flpecdep#674036, rg_fltele#674014, rg_fltopr#674021, rg_fltp#674019, rg_idmut#674020, rg_modreg#674045, rg_nomorg#673999, rg_notbord#674041, rg_notrel#674034, rg_numbor#674009, rg_numcpt#674022, rg_numcpt_a#674037, rg_numcpt_c#674046, rg_numcpt_c_ft#674047, rg_numsir#674043, rg_orgpayeur#674032, rg_prefix#674007, rg_reclam#674039, rg_relctx#674025, rg_relpage#674026, rg_relref#674027, rg_tauxre#674010, rg_telbur#674004, rg_trirel#674040, rg_typoc#674031, rg_typorg#673998, rg_ville#674003]
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#674000, rg_adr_2#674001, rg_adr_3#674033, rg_cmpimp_f#674023, rg_cmpimp_h#674024, rg_codcai#674012, rg_codccp#674018, rg_codcen#674013, rg_codorg#673997, rg_codpos#674002, rg_codreg#674011, rg_coduti#674016, rg_comment#674035, rg_contac#674008, rg_datede#674029, rg_datefi#674030, rg_datenv#674028, rg_datmaj#674015, rg_e_mail#674006, rg_fax#674005, rg_flchorus#674042, rg_flliseng#674044, rg_flpav#674038, rg_flpecdep#674036, rg_fltele#674014, rg_fltopr#674021, rg_fltp#674019, rg_idmut#674020, rg_modreg#674045, rg_nomorg#673999, rg_notbord#674041, rg_notrel#674034, rg_numbor#674009, rg_numcpt#674022, rg_numcpt_a#674037, rg_numcpt_c#674046, rg_numcpt_c_ft#674047, rg_numsir#674043, rg_orgpayeur#674032, rg_prefix#674007, rg_reclam#674039, rg_relctx#674025, rg_relpage#674026, rg_relref#674027, rg_tauxre#674010, rg_telbur#674004, rg_trirel#674040, rg_typoc#674031, rg_typorg#673998, rg_ville#674003]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codorg#673997)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codorg#673997)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typorg#673998)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_typorg#673998)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_nomorg#673999)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_nomorg#673999)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_1#674000)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_1#674000)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_2#674001)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_2#674001)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codpos#674002)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codpos#674002)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_ville#674003)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_ville#674003)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_telbur#674004)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_telbur#674004)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fax#674005)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fax#674005)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_e_mail#674006)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_e_mail#674006)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_prefix#674007)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_prefix#674007)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_contac#674008)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_contac#674008)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numbor#674009)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numbor#674009)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_tauxre#674010)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_tauxre#674010)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codreg#674011)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codreg#674011)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcai#674012)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcai#674012)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcen#674013)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcen#674013)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltele#674014)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltele#674014)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datmaj#674015)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datmaj#674015)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_coduti#674016)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_coduti#674016)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codccp#674018)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codccp#674018)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltp#674019)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltp#674019)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_idmut#674020)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_idmut#674020)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltopr#674021)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltopr#674021)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt#674022)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt#674022)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_f#674023)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_f#674023)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_h#674024)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_h#674024)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relctx#674025)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relctx#674025)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relpage#674026)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relpage#674026)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relref#674027)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relref#674027)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datenv#674028)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datenv#674028)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datede#674029)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datede#674029)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datefi#674030)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datefi#674030)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typoc#674031)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_typoc#674031)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_orgpayeur#674032)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_orgpayeur#674032)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_3#674033)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_3#674033)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notrel#674034)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_notrel#674034)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_comment#674035)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_comment#674035)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpecdep#674036)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpecdep#674036)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_a#674037)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_a#674037)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpav#674038)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpav#674038)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_reclam#674039)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_reclam#674039)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_trirel#674040)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_trirel#674040)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notbord#674041)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_notbord#674041)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flchorus#674042)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flchorus#674042)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numsir#674043)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numsir#674043)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flliseng#674044)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flliseng#674044)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_modreg#674045)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_modreg#674045)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c#674046)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c#674046)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c_ft#674047)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c_ft#674047)), 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#674444, rg_adr_1#674000 AS RG_ADR_1_437974#674445, rg_adr_2#674001 AS RG_ADR_2_437975#674446, rg_adr_3#674033 AS RG_ADR_3_438006#674447, rg_cmpimp_f#674023 AS RG_CMPIMP_F_437996#674448, rg_cmpimp_h#674024 AS RG_CMPIMP_H_437997#674449, rg_codcai#674012 AS RG_CODCAI_437986#674450, rg_codccp#674018 AS RG_CODCCP_437991#674451, rg_codcen#674013 AS RG_CODCEN_437987#674452, rg_codorg#673997 AS RG_CODORG_437971#674453, rg_codpos#674002 AS RG_CODPOS_437976#674454, rg_codreg#674011 AS RG_CODREG_437985#674455, rg_coduti#674016 AS RG_CODUTI_437990#674456, rg_comment#674035 AS RG_COMMENT_438008#674457, rg_contac#674008 AS RG_CONTAC_437982#674458, rg_datede#674029 AS RG_DATEDE_438002#674459, rg_datefi#674030 AS RG_DATEFI_438003#674460, rg_datenv#674028 AS RG_DATENV_438001#674461, rg_datmaj#674015 AS RG_DATMAJ_437989#674462, rg_e_mail#674006 AS RG_E_MAIL_437980#674463, rg_fax#674005 AS RG_FAX_437979#674464, rg_flchorus#674042 AS RG_FLCHORUS_438015#674465, rg_flliseng#674044 AS RG_FLLISENG_438017#674466, rg_flpav#674038 AS RG_FLPAV_438011#674467, rg_flpecdep#674036 AS RG_FLPECDEP_438009#674468, rg_fltele#674014 AS RG_FLTELE_437988#674469, rg_fltopr#674021 AS RG_FLTOPR_437994#674470, rg_fltp#674019 AS RG_FLTP_437992#674471, rg_idmut#674020 AS RG_IDMUT_437993#674472, rg_modreg#674045 AS RG_MODREG_438018#674473, rg_nomorg#673999 AS RG_NOMORG_437973#674474, rg_notbord#674041 AS RG_NOTBORD_438014#674475, rg_notrel#674034 AS RG_NOTREL_438007#674476, rg_numbor#674009 AS RG_NUMBOR_437983#674477, rg_numcpt#674022 AS RG_NUMCPT_437995#674478, rg_numcpt_a#674037 AS RG_NUMCPT_A_438010#674479, rg_numcpt_c#674046 AS RG_NUMCPT_C_438019#674480, rg_numcpt_c_ft#674047 AS RG_NUMCPT_C_FT_438020#674481, rg_numsir#674043 AS RG_NUMSIR_438016#674482, rg_orgpayeur#674032 AS RG_ORGPAYEUR_438005#674483, rg_prefix#674007 AS RG_PREFIX_437981#674484, rg_reclam#674039 AS RG_RECLAM_438012#674485, rg_relctx#674025 AS RG_RELCTX_437998#674486, rg_relpage#674026 AS RG_RELPAGE_437999#674487, rg_relref#674027 AS RG_RELREF_438000#674488, rg_tauxre#674010 AS RG_TAUXRE_437984#674489, rg_telbur#674004 AS RG_TELBUR_437978#674490, rg_trirel#674040 AS RG_TRIREL_438013#674491, rg_typoc#674031 AS RG_TYPOC_438004#674492, rg_typorg#673998 AS RG_TYPORG_437972#674493, rg_ville#674003 AS RG_VILLE_437977#674494]
Input [50]: [rg_adr_1#674000, rg_adr_2#674001, rg_adr_3#674033, rg_cmpimp_f#674023, rg_cmpimp_h#674024, rg_codcai#674012, rg_codccp#674018, rg_codcen#674013, rg_codorg#673997, rg_codpos#674002, rg_codreg#674011, rg_coduti#674016, rg_comment#674035, rg_contac#674008, rg_datede#674029, rg_datefi#674030, rg_datenv#674028, rg_datmaj#674015, rg_e_mail#674006, rg_fax#674005, rg_flchorus#674042, rg_flliseng#674044, rg_flpav#674038, rg_flpecdep#674036, rg_fltele#674014, rg_fltopr#674021, rg_fltp#674019, rg_idmut#674020, rg_modreg#674045, rg_nomorg#673999, rg_notbord#674041, rg_notrel#674034, rg_numbor#674009, rg_numcpt#674022, rg_numcpt_a#674037, rg_numcpt_c#674046, rg_numcpt_c_ft#674047, rg_numsir#674043, rg_orgpayeur#674032, rg_prefix#674007, rg_reclam#674039, rg_relctx#674025, rg_relpage#674026, rg_relref#674027, rg_tauxre#674010, rg_telbur#674004, rg_trirel#674040, rg_typoc#674031, rg_typorg#673998, rg_ville#674003]

(7) Union

(8) HashAggregate [codegen id : 3]
Input [51]: [ORIGINE_440148#673708, RG_ADR_1_437974#673709, RG_ADR_2_437975#673710, RG_ADR_3_438006#673711, RG_CMPIMP_F_437996#673712, RG_CMPIMP_H_437997#673713, RG_CODCAI_437986#673714, RG_CODCCP_437991#673715, RG_CODCEN_437987#673716, RG_CODORG_437971#673717, RG_CODPOS_437976#673718, RG_CODREG_437985#673719, RG_CODUTI_437990#673720, RG_COMMENT_438008#673721, RG_CONTAC_437982#673722, RG_DATEDE_438002#673723, RG_DATEFI_438003#673724, RG_DATENV_438001#673725, RG_DATMAJ_437989#673726, RG_E_MAIL_437980#673727, RG_FAX_437979#673728, RG_FLCHORUS_438015#673729, RG_FLLISENG_438017#673730, RG_FLPAV_438011#673731, RG_FLPECDEP_438009#673732, RG_FLTELE_437988#673733, RG_FLTOPR_437994#673734, RG_FLTP_437992#673735, RG_IDMUT_437993#673736, RG_MODREG_438018#673737, RG_NOMORG_437973#673738, RG_NOTBORD_438014#673739, RG_NOTREL_438007#673740, RG_NUMBOR_437983#673741, RG_NUMCPT_437995#673742, RG_NUMCPT_A_438010#673743, RG_NUMCPT_C_438019#673744, RG_NUMCPT_C_FT_438020#673745, RG_NUMSIR_438016#673746, RG_ORGPAYEUR_438005#673747, RG_PREFIX_437981#673748, RG_RECLAM_438012#673749, RG_RELCTX_437998#673750, RG_RELPAGE_437999#673751, RG_RELREF_438000#673752, RG_TAUXRE_437984#673753, RG_TELBUR_437978#673754, RG_TRIREL_438013#673755, RG_TYPOC_438004#673756, RG_TYPORG_437972#673757, RG_VILLE_437977#673758]
Keys [51]: [ORIGINE_440148#673708, RG_ADR_1_437974#673709, RG_ADR_2_437975#673710, RG_ADR_3_438006#673711, RG_CMPIMP_F_437996#673712, RG_CMPIMP_H_437997#673713, RG_CODCAI_437986#673714, RG_CODCCP_437991#673715, RG_CODCEN_437987#673716, RG_CODORG_437971#673717, RG_CODPOS_437976#673718, RG_CODREG_437985#673719, RG_CODUTI_437990#673720, RG_COMMENT_438008#673721, RG_CONTAC_437982#673722, RG_DATEDE_438002#673723, RG_DATEFI_438003#673724, RG_DATENV_438001#673725, RG_DATMAJ_437989#673726, RG_E_MAIL_437980#673727, RG_FAX_437979#673728, RG_FLCHORUS_438015#673729, RG_FLLISENG_438017#673730, RG_FLPAV_438011#673731, RG_FLPECDEP_438009#673732, RG_FLTELE_437988#673733, RG_FLTOPR_437994#673734, RG_FLTP_437992#673735, RG_IDMUT_437993#673736, RG_MODREG_438018#673737, RG_NOMORG_437973#673738, RG_NOTBORD_438014#673739, RG_NOTREL_438007#673740, RG_NUMBOR_437983#673741, RG_NUMCPT_437995#673742, RG_NUMCPT_A_438010#673743, RG_NUMCPT_C_438019#673744, RG_NUMCPT_C_FT_438020#673745, RG_NUMSIR_438016#673746, RG_ORGPAYEUR_438005#673747, RG_PREFIX_437981#673748, RG_RECLAM_438012#673749, RG_RELCTX_437998#673750, RG_RELPAGE_437999#673751, RG_RELREF_438000#673752, RG_TAUXRE_437984#673753, RG_TELBUR_437978#673754, RG_TRIREL_438013#673755, RG_TYPOC_438004#673756, RG_TYPORG_437972#673757, RG_VILLE_437977#673758]
Functions: []
Aggregate Attributes: []
Results [51]: [ORIGINE_440148#673708, RG_ADR_1_437974#673709, RG_ADR_2_437975#673710, RG_ADR_3_438006#673711, RG_CMPIMP_F_437996#673712, RG_CMPIMP_H_437997#673713, RG_CODCAI_437986#673714, RG_CODCCP_437991#673715, RG_CODCEN_437987#673716, RG_CODORG_437971#673717, RG_CODPOS_437976#673718, RG_CODREG_437985#673719, RG_CODUTI_437990#673720, RG_COMMENT_438008#673721, RG_CONTAC_437982#673722, RG_DATEDE_438002#673723, RG_DATEFI_438003#673724, RG_DATENV_438001#673725, RG_DATMAJ_437989#673726, RG_E_MAIL_437980#673727, RG_FAX_437979#673728, RG_FLCHORUS_438015#673729, RG_FLLISENG_438017#673730, RG_FLPAV_438011#673731, RG_FLPECDEP_438009#673732, RG_FLTELE_437988#673733, RG_FLTOPR_437994#673734, RG_FLTP_437992#673735, RG_IDMUT_437993#673736, RG_MODREG_438018#673737, RG_NOMORG_437973#673738, RG_NOTBORD_438014#673739, RG_NOTREL_438007#673740, RG_NUMBOR_437983#673741, RG_NUMCPT_437995#673742, RG_NUMCPT_A_438010#673743, RG_NUMCPT_C_438019#673744, RG_NUMCPT_C_FT_438020#673745, RG_NUMSIR_438016#673746, RG_ORGPAYEUR_438005#673747, RG_PREFIX_437981#673748, RG_RECLAM_438012#673749, RG_RELCTX_437998#673750, RG_RELPAGE_437999#673751, RG_RELREF_438000#673752, RG_TAUXRE_437984#673753, RG_TELBUR_437978#673754, RG_TRIREL_438013#673755, RG_TYPOC_438004#673756, RG_TYPORG_437972#673757, RG_VILLE_437977#673758]

(9) Exchange
Input [51]: [ORIGINE_440148#673708, RG_ADR_1_437974#673709, RG_ADR_2_437975#673710, RG_ADR_3_438006#673711, RG_CMPIMP_F_437996#673712, RG_CMPIMP_H_437997#673713, RG_CODCAI_437986#673714, RG_CODCCP_437991#673715, RG_CODCEN_437987#673716, RG_CODORG_437971#673717, RG_CODPOS_437976#673718, RG_CODREG_437985#673719, RG_CODUTI_437990#673720, RG_COMMENT_438008#673721, RG_CONTAC_437982#673722, RG_DATEDE_438002#673723, RG_DATEFI_438003#673724, RG_DATENV_438001#673725, RG_DATMAJ_437989#673726, RG_E_MAIL_437980#673727, RG_FAX_437979#673728, RG_FLCHORUS_438015#673729, RG_FLLISENG_438017#673730, RG_FLPAV_438011#673731, RG_FLPECDEP_438009#673732, RG_FLTELE_437988#673733, RG_FLTOPR_437994#673734, RG_FLTP_437992#673735, RG_IDMUT_437993#673736, RG_MODREG_438018#673737, RG_NOMORG_437973#673738, RG_NOTBORD_438014#673739, RG_NOTREL_438007#673740, RG_NUMBOR_437983#673741, RG_NUMCPT_437995#673742, RG_NUMCPT_A_438010#673743, RG_NUMCPT_C_438019#673744, RG_NUMCPT_C_FT_438020#673745, RG_NUMSIR_438016#673746, RG_ORGPAYEUR_438005#673747, RG_PREFIX_437981#673748, RG_RECLAM_438012#673749, RG_RELCTX_437998#673750, RG_RELPAGE_437999#673751, RG_RELREF_438000#673752, RG_TAUXRE_437984#673753, RG_TELBUR_437978#673754, RG_TRIREL_438013#673755, RG_TYPOC_438004#673756, RG_TYPORG_437972#673757, RG_VILLE_437977#673758]
Arguments: hashpartitioning(ORIGINE_440148#673708, RG_ADR_1_437974#673709, RG_ADR_2_437975#673710, RG_ADR_3_438006#673711, RG_CMPIMP_F_437996#673712, RG_CMPIMP_H_437997#673713, RG_CODCAI_437986#673714, RG_CODCCP_437991#673715, RG_CODCEN_437987#673716, RG_CODORG_437971#673717, RG_CODPOS_437976#673718, RG_CODREG_437985#673719, RG_CODUTI_437990#673720, RG_COMMENT_438008#673721, RG_CONTAC_437982#673722, RG_DATEDE_438002#673723, RG_DATEFI_438003#673724, RG_DATENV_438001#673725, RG_DATMAJ_437989#673726, RG_E_MAIL_437980#673727, RG_FAX_437979#673728, RG_FLCHORUS_438015#673729, RG_FLLISENG_438017#673730, RG_FLPAV_438011#673731, ... 28 more fields), ENSURE_REQUIREMENTS, [plan_id=36637]

(10) ShuffleQueryStage
Output [51]: [ORIGINE_440148#673708, RG_ADR_1_437974#673709, RG_ADR_2_437975#673710, RG_ADR_3_438006#673711, RG_CMPIMP_F_437996#673712, RG_CMPIMP_H_437997#673713, RG_CODCAI_437986#673714, RG_CODCCP_437991#673715, RG_CODCEN_437987#673716, RG_CODORG_437971#673717, RG_CODPOS_437976#673718, RG_CODREG_437985#673719, RG_CODUTI_437990#673720, RG_COMMENT_438008#673721, RG_CONTAC_437982#673722, RG_DATEDE_438002#673723, RG_DATEFI_438003#673724, RG_DATENV_438001#673725, RG_DATMAJ_437989#673726, RG_E_MAIL_437980#673727, RG_FAX_437979#673728, RG_FLCHORUS_438015#673729, RG_FLLISENG_438017#673730, RG_FLPAV_438011#673731, RG_FLPECDEP_438009#673732, RG_FLTELE_437988#673733, RG_FLTOPR_437994#673734, RG_FLTP_437992#673735, RG_IDMUT_437993#673736, RG_MODREG_438018#673737, RG_NOMORG_437973#673738, RG_NOTBORD_438014#673739, RG_NOTREL_438007#673740, RG_NUMBOR_437983#673741, RG_NUMCPT_437995#673742, RG_NUMCPT_A_438010#673743, RG_NUMCPT_C_438019#673744, RG_NUMCPT_C_FT_438020#673745, RG_NUMSIR_438016#673746, RG_ORGPAYEUR_438005#673747, RG_PREFIX_437981#673748, RG_RECLAM_438012#673749, RG_RELCTX_437998#673750, RG_RELPAGE_437999#673751, RG_RELREF_438000#673752, RG_TAUXRE_437984#673753, RG_TELBUR_437978#673754, RG_TRIREL_438013#673755, RG_TYPOC_438004#673756, RG_TYPORG_437972#673757, RG_VILLE_437977#673758]
Arguments: 0

(11) AQEShuffleRead
Input [51]: [ORIGINE_440148#673708, RG_ADR_1_437974#673709, RG_ADR_2_437975#673710, RG_ADR_3_438006#673711, RG_CMPIMP_F_437996#673712, RG_CMPIMP_H_437997#673713, RG_CODCAI_437986#673714, RG_CODCCP_437991#673715, RG_CODCEN_437987#673716, RG_CODORG_437971#673717, RG_CODPOS_437976#673718, RG_CODREG_437985#673719, RG_CODUTI_437990#673720, RG_COMMENT_438008#673721, RG_CONTAC_437982#673722, RG_DATEDE_438002#673723, RG_DATEFI_438003#673724, RG_DATENV_438001#673725, RG_DATMAJ_437989#673726, RG_E_MAIL_437980#673727, RG_FAX_437979#673728, RG_FLCHORUS_438015#673729, RG_FLLISENG_438017#673730, RG_FLPAV_438011#673731, RG_FLPECDEP_438009#673732, RG_FLTELE_437988#673733, RG_FLTOPR_437994#673734, RG_FLTP_437992#673735, RG_IDMUT_437993#673736, RG_MODREG_438018#673737, RG_NOMORG_437973#673738, RG_NOTBORD_438014#673739, RG_NOTREL_438007#673740, RG_NUMBOR_437983#673741, RG_NUMCPT_437995#673742, RG_NUMCPT_A_438010#673743, RG_NUMCPT_C_438019#673744, RG_NUMCPT_C_FT_438020#673745, RG_NUMSIR_438016#673746, RG_ORGPAYEUR_438005#673747, RG_PREFIX_437981#673748, RG_RECLAM_438012#673749, RG_RELCTX_437998#673750, RG_RELPAGE_437999#673751, RG_RELREF_438000#673752, RG_TAUXRE_437984#673753, RG_TELBUR_437978#673754, RG_TRIREL_438013#673755, RG_TYPOC_438004#673756, RG_TYPORG_437972#673757, RG_VILLE_437977#673758]
Arguments: coalesced

(12) HashAggregate [codegen id : 4]
Input [51]: [ORIGINE_440148#673708, RG_ADR_1_437974#673709, RG_ADR_2_437975#673710, RG_ADR_3_438006#673711, RG_CMPIMP_F_437996#673712, RG_CMPIMP_H_437997#673713, RG_CODCAI_437986#673714, RG_CODCCP_437991#673715, RG_CODCEN_437987#673716, RG_CODORG_437971#673717, RG_CODPOS_437976#673718, RG_CODREG_437985#673719, RG_CODUTI_437990#673720, RG_COMMENT_438008#673721, RG_CONTAC_437982#673722, RG_DATEDE_438002#673723, RG_DATEFI_438003#673724, RG_DATENV_438001#673725, RG_DATMAJ_437989#673726, RG_E_MAIL_437980#673727, RG_FAX_437979#673728, RG_FLCHORUS_438015#673729, RG_FLLISENG_438017#673730, RG_FLPAV_438011#673731, RG_FLPECDEP_438009#673732, RG_FLTELE_437988#673733, RG_FLTOPR_437994#673734, RG_FLTP_437992#673735, RG_IDMUT_437993#673736, RG_MODREG_438018#673737, RG_NOMORG_437973#673738, RG_NOTBORD_438014#673739, RG_NOTREL_438007#673740, RG_NUMBOR_437983#673741, RG_NUMCPT_437995#673742, RG_NUMCPT_A_438010#673743, RG_NUMCPT_C_438019#673744, RG_NUMCPT_C_FT_438020#673745, RG_NUMSIR_438016#673746, RG_ORGPAYEUR_438005#673747, RG_PREFIX_437981#673748, RG_RECLAM_438012#673749, RG_RELCTX_437998#673750, RG_RELPAGE_437999#673751, RG_RELREF_438000#673752, RG_TAUXRE_437984#673753, RG_TELBUR_437978#673754, RG_TRIREL_438013#673755, RG_TYPOC_438004#673756, RG_TYPORG_437972#673757, RG_VILLE_437977#673758]
Keys [51]: [ORIGINE_440148#673708, RG_ADR_1_437974#673709, RG_ADR_2_437975#673710, RG_ADR_3_438006#673711, RG_CMPIMP_F_437996#673712, RG_CMPIMP_H_437997#673713, RG_CODCAI_437986#673714, RG_CODCCP_437991#673715, RG_CODCEN_437987#673716, RG_CODORG_437971#673717, RG_CODPOS_437976#673718, RG_CODREG_437985#673719, RG_CODUTI_437990#673720, RG_COMMENT_438008#673721, RG_CONTAC_437982#673722, RG_DATEDE_438002#673723, RG_DATEFI_438003#673724, RG_DATENV_438001#673725, RG_DATMAJ_437989#673726, RG_E_MAIL_437980#673727, RG_FAX_437979#673728, RG_FLCHORUS_438015#673729, RG_FLLISENG_438017#673730, RG_FLPAV_438011#673731, RG_FLPECDEP_438009#673732, RG_FLTELE_437988#673733, RG_FLTOPR_437994#673734, RG_FLTP_437992#673735, RG_IDMUT_437993#673736, RG_MODREG_438018#673737, RG_NOMORG_437973#673738, RG_NOTBORD_438014#673739, RG_NOTREL_438007#673740, RG_NUMBOR_437983#673741, RG_NUMCPT_437995#673742, RG_NUMCPT_A_438010#673743, RG_NUMCPT_C_438019#673744, RG_NUMCPT_C_FT_438020#673745, RG_NUMSIR_438016#673746, RG_ORGPAYEUR_438005#673747, RG_PREFIX_437981#673748, RG_RECLAM_438012#673749, RG_RELCTX_437998#673750, RG_RELPAGE_437999#673751, RG_RELREF_438000#673752, RG_TAUXRE_437984#673753, RG_TELBUR_437978#673754, RG_TRIREL_438013#673755, RG_TYPOC_438004#673756, RG_TYPORG_437972#673757, RG_VILLE_437977#673758]
Functions: []
Aggregate Attributes: []
Results: []

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

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

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

(16) HashAggregate [codegen id : 5]
Input [1]: [count#677121L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#676393L]
Results [1]: [count(1)#676393L AS COL_11a2b182-db18-4704-9a77-bf067239450d#676395L]

(17) Union

(18) HashAggregate
Input [51]: [ORIGINE_440148#673708, RG_ADR_1_437974#673709, RG_ADR_2_437975#673710, RG_ADR_3_438006#673711, RG_CMPIMP_F_437996#673712, RG_CMPIMP_H_437997#673713, RG_CODCAI_437986#673714, RG_CODCCP_437991#673715, RG_CODCEN_437987#673716, RG_CODORG_437971#673717, RG_CODPOS_437976#673718, RG_CODREG_437985#673719, RG_CODUTI_437990#673720, RG_COMMENT_438008#673721, RG_CONTAC_437982#673722, RG_DATEDE_438002#673723, RG_DATEFI_438003#673724, RG_DATENV_438001#673725, RG_DATMAJ_437989#673726, RG_E_MAIL_437980#673727, RG_FAX_437979#673728, RG_FLCHORUS_438015#673729, RG_FLLISENG_438017#673730, RG_FLPAV_438011#673731, RG_FLPECDEP_438009#673732, RG_FLTELE_437988#673733, RG_FLTOPR_437994#673734, RG_FLTP_437992#673735, RG_IDMUT_437993#673736, RG_MODREG_438018#673737, RG_NOMORG_437973#673738, RG_NOTBORD_438014#673739, RG_NOTREL_438007#673740, RG_NUMBOR_437983#673741, RG_NUMCPT_437995#673742, RG_NUMCPT_A_438010#673743, RG_NUMCPT_C_438019#673744, RG_NUMCPT_C_FT_438020#673745, RG_NUMSIR_438016#673746, RG_ORGPAYEUR_438005#673747, RG_PREFIX_437981#673748, RG_RECLAM_438012#673749, RG_RELCTX_437998#673750, RG_RELPAGE_437999#673751, RG_RELREF_438000#673752, RG_TAUXRE_437984#673753, RG_TELBUR_437978#673754, RG_TRIREL_438013#673755, RG_TYPOC_438004#673756, RG_TYPORG_437972#673757, RG_VILLE_437977#673758]
Keys [51]: [ORIGINE_440148#673708, RG_ADR_1_437974#673709, RG_ADR_2_437975#673710, RG_ADR_3_438006#673711, RG_CMPIMP_F_437996#673712, RG_CMPIMP_H_437997#673713, RG_CODCAI_437986#673714, RG_CODCCP_437991#673715, RG_CODCEN_437987#673716, RG_CODORG_437971#673717, RG_CODPOS_437976#673718, RG_CODREG_437985#673719, RG_CODUTI_437990#673720, RG_COMMENT_438008#673721, RG_CONTAC_437982#673722, RG_DATEDE_438002#673723, RG_DATEFI_438003#673724, RG_DATENV_438001#673725, RG_DATMAJ_437989#673726, RG_E_MAIL_437980#673727, RG_FAX_437979#673728, RG_FLCHORUS_438015#673729, RG_FLLISENG_438017#673730, RG_FLPAV_438011#673731, RG_FLPECDEP_438009#673732, RG_FLTELE_437988#673733, RG_FLTOPR_437994#673734, RG_FLTP_437992#673735, RG_IDMUT_437993#673736, RG_MODREG_438018#673737, RG_NOMORG_437973#673738, RG_NOTBORD_438014#673739, RG_NOTREL_438007#673740, RG_NUMBOR_437983#673741, RG_NUMCPT_437995#673742, RG_NUMCPT_A_438010#673743, RG_NUMCPT_C_438019#673744, RG_NUMCPT_C_FT_438020#673745, RG_NUMSIR_438016#673746, RG_ORGPAYEUR_438005#673747, RG_PREFIX_437981#673748, RG_RECLAM_438012#673749, RG_RELCTX_437998#673750, RG_RELPAGE_437999#673751, RG_RELREF_438000#673752, RG_TAUXRE_437984#673753, RG_TELBUR_437978#673754, RG_TRIREL_438013#673755, RG_TYPOC_438004#673756, RG_TYPORG_437972#673757, RG_VILLE_437977#673758]
Functions: []
Aggregate Attributes: []
Results [51]: [ORIGINE_440148#673708, RG_ADR_1_437974#673709, RG_ADR_2_437975#673710, RG_ADR_3_438006#673711, RG_CMPIMP_F_437996#673712, RG_CMPIMP_H_437997#673713, RG_CODCAI_437986#673714, RG_CODCCP_437991#673715, RG_CODCEN_437987#673716, RG_CODORG_437971#673717, RG_CODPOS_437976#673718, RG_CODREG_437985#673719, RG_CODUTI_437990#673720, RG_COMMENT_438008#673721, RG_CONTAC_437982#673722, RG_DATEDE_438002#673723, RG_DATEFI_438003#673724, RG_DATENV_438001#673725, RG_DATMAJ_437989#673726, RG_E_MAIL_437980#673727, RG_FAX_437979#673728, RG_FLCHORUS_438015#673729, RG_FLLISENG_438017#673730, RG_FLPAV_438011#673731, RG_FLPECDEP_438009#673732, RG_FLTELE_437988#673733, RG_FLTOPR_437994#673734, RG_FLTP_437992#673735, RG_IDMUT_437993#673736, RG_MODREG_438018#673737, RG_NOMORG_437973#673738, RG_NOTBORD_438014#673739, RG_NOTREL_438007#673740, RG_NUMBOR_437983#673741, RG_NUMCPT_437995#673742, RG_NUMCPT_A_438010#673743, RG_NUMCPT_C_438019#673744, RG_NUMCPT_C_FT_438020#673745, RG_NUMSIR_438016#673746, RG_ORGPAYEUR_438005#673747, RG_PREFIX_437981#673748, RG_RECLAM_438012#673749, RG_RELCTX_437998#673750, RG_RELPAGE_437999#673751, RG_RELREF_438000#673752, RG_TAUXRE_437984#673753, RG_TELBUR_437978#673754, RG_TRIREL_438013#673755, RG_TYPOC_438004#673756, RG_TYPORG_437972#673757, RG_VILLE_437977#673758]

(19) Exchange
Input [51]: [ORIGINE_440148#673708, RG_ADR_1_437974#673709, RG_ADR_2_437975#673710, RG_ADR_3_438006#673711, RG_CMPIMP_F_437996#673712, RG_CMPIMP_H_437997#673713, RG_CODCAI_437986#673714, RG_CODCCP_437991#673715, RG_CODCEN_437987#673716, RG_CODORG_437971#673717, RG_CODPOS_437976#673718, RG_CODREG_437985#673719, RG_CODUTI_437990#673720, RG_COMMENT_438008#673721, RG_CONTAC_437982#673722, RG_DATEDE_438002#673723, RG_DATEFI_438003#673724, RG_DATENV_438001#673725, RG_DATMAJ_437989#673726, RG_E_MAIL_437980#673727, RG_FAX_437979#673728, RG_FLCHORUS_438015#673729, RG_FLLISENG_438017#673730, RG_FLPAV_438011#673731, RG_FLPECDEP_438009#673732, RG_FLTELE_437988#673733, RG_FLTOPR_437994#673734, RG_FLTP_437992#673735, RG_IDMUT_437993#673736, RG_MODREG_438018#673737, RG_NOMORG_437973#673738, RG_NOTBORD_438014#673739, RG_NOTREL_438007#673740, RG_NUMBOR_437983#673741, RG_NUMCPT_437995#673742, RG_NUMCPT_A_438010#673743, RG_NUMCPT_C_438019#673744, RG_NUMCPT_C_FT_438020#673745, RG_NUMSIR_438016#673746, RG_ORGPAYEUR_438005#673747, RG_PREFIX_437981#673748, RG_RECLAM_438012#673749, RG_RELCTX_437998#673750, RG_RELPAGE_437999#673751, RG_RELREF_438000#673752, RG_TAUXRE_437984#673753, RG_TELBUR_437978#673754, RG_TRIREL_438013#673755, RG_TYPOC_438004#673756, RG_TYPORG_437972#673757, RG_VILLE_437977#673758]
Arguments: hashpartitioning(ORIGINE_440148#673708, RG_ADR_1_437974#673709, RG_ADR_2_437975#673710, RG_ADR_3_438006#673711, RG_CMPIMP_F_437996#673712, RG_CMPIMP_H_437997#673713, RG_CODCAI_437986#673714, RG_CODCCP_437991#673715, RG_CODCEN_437987#673716, RG_CODORG_437971#673717, RG_CODPOS_437976#673718, RG_CODREG_437985#673719, RG_CODUTI_437990#673720, RG_COMMENT_438008#673721, RG_CONTAC_437982#673722, RG_DATEDE_438002#673723, RG_DATEFI_438003#673724, RG_DATENV_438001#673725, RG_DATMAJ_437989#673726, RG_E_MAIL_437980#673727, RG_FAX_437979#673728, RG_FLCHORUS_438015#673729, RG_FLLISENG_438017#673730, RG_FLPAV_438011#673731, ... 28 more fields), ENSURE_REQUIREMENTS, [plan_id=36605]

(20) HashAggregate
Input [51]: [ORIGINE_440148#673708, RG_ADR_1_437974#673709, RG_ADR_2_437975#673710, RG_ADR_3_438006#673711, RG_CMPIMP_F_437996#673712, RG_CMPIMP_H_437997#673713, RG_CODCAI_437986#673714, RG_CODCCP_437991#673715, RG_CODCEN_437987#673716, RG_CODORG_437971#673717, RG_CODPOS_437976#673718, RG_CODREG_437985#673719, RG_CODUTI_437990#673720, RG_COMMENT_438008#673721, RG_CONTAC_437982#673722, RG_DATEDE_438002#673723, RG_DATEFI_438003#673724, RG_DATENV_438001#673725, RG_DATMAJ_437989#673726, RG_E_MAIL_437980#673727, RG_FAX_437979#673728, RG_FLCHORUS_438015#673729, RG_FLLISENG_438017#673730, RG_FLPAV_438011#673731, RG_FLPECDEP_438009#673732, RG_FLTELE_437988#673733, RG_FLTOPR_437994#673734, RG_FLTP_437992#673735, RG_IDMUT_437993#673736, RG_MODREG_438018#673737, RG_NOMORG_437973#673738, RG_NOTBORD_438014#673739, RG_NOTREL_438007#673740, RG_NUMBOR_437983#673741, RG_NUMCPT_437995#673742, RG_NUMCPT_A_438010#673743, RG_NUMCPT_C_438019#673744, RG_NUMCPT_C_FT_438020#673745, RG_NUMSIR_438016#673746, RG_ORGPAYEUR_438005#673747, RG_PREFIX_437981#673748, RG_RECLAM_438012#673749, RG_RELCTX_437998#673750, RG_RELPAGE_437999#673751, RG_RELREF_438000#673752, RG_TAUXRE_437984#673753, RG_TELBUR_437978#673754, RG_TRIREL_438013#673755, RG_TYPOC_438004#673756, RG_TYPORG_437972#673757, RG_VILLE_437977#673758]
Keys [51]: [ORIGINE_440148#673708, RG_ADR_1_437974#673709, RG_ADR_2_437975#673710, RG_ADR_3_438006#673711, RG_CMPIMP_F_437996#673712, RG_CMPIMP_H_437997#673713, RG_CODCAI_437986#673714, RG_CODCCP_437991#673715, RG_CODCEN_437987#673716, RG_CODORG_437971#673717, RG_CODPOS_437976#673718, RG_CODREG_437985#673719, RG_CODUTI_437990#673720, RG_COMMENT_438008#673721, RG_CONTAC_437982#673722, RG_DATEDE_438002#673723, RG_DATEFI_438003#673724, RG_DATENV_438001#673725, RG_DATMAJ_437989#673726, RG_E_MAIL_437980#673727, RG_FAX_437979#673728, RG_FLCHORUS_438015#673729, RG_FLLISENG_438017#673730, RG_FLPAV_438011#673731, RG_FLPECDEP_438009#673732, RG_FLTELE_437988#673733, RG_FLTOPR_437994#673734, RG_FLTP_437992#673735, RG_IDMUT_437993#673736, RG_MODREG_438018#673737, RG_NOMORG_437973#673738, RG_NOTBORD_438014#673739, RG_NOTREL_438007#673740, RG_NUMBOR_437983#673741, RG_NUMCPT_437995#673742, RG_NUMCPT_A_438010#673743, RG_NUMCPT_C_438019#673744, RG_NUMCPT_C_FT_438020#673745, RG_NUMSIR_438016#673746, RG_ORGPAYEUR_438005#673747, RG_PREFIX_437981#673748, RG_RECLAM_438012#673749, RG_RELCTX_437998#673750, RG_RELPAGE_437999#673751, RG_RELREF_438000#673752, RG_TAUXRE_437984#673753, RG_TELBUR_437978#673754, RG_TRIREL_438013#673755, RG_TYPOC_438004#673756, RG_TYPORG_437972#673757, RG_VILLE_437977#673758]
Functions: []
Aggregate Attributes: []
Results: []

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

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

(23) HashAggregate
Input [1]: [count#677121L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#676393L]
Results [1]: [count(1)#676393L AS COL_11a2b182-db18-4704-9a77-bf067239450d#676395L]

(24) AdaptiveSparkPlan
Output [1]: [COL_11a2b182-db18-4704-9a77-bf067239450d#676395L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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