hdh-spark-job - Details for Query 1424

Submitted Time: 2026/10/23 13:29:11
Duration: 2 s
Succeeded Jobs: 1419 1422 1423

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: 9 ms"; 5 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 8 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: 2 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 2059.0: task 1799)) 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 2059.0: task 1798)) 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 2059.0: task 1798))"]; subgraph cluster9 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n434 ms (206 ms, 228 ms, 228 ms (stage 2059.0: task 1799))"; 10 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 389 ms (192 ms, 197 ms, 197 ms (stage 2059.0: task 1799)) peak memory total (min, med, max (stageId: taskId)) 128.5 MiB (64.2 MiB, 64.2 MiB, 64.2 MiB (stage 2059.0: task 1798)) 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 2059.0: task 1798))"]; } 11 [labelType="html" label=" Union "]; subgraph cluster12 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 203 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: 227 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=38861]

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

HashAggregate(keys=[ORIGINE_440148#715520, RG_ADR_1_437974#715521, RG_ADR_2_437975#715522, RG_ADR_3_438006#715523, RG_CMPIMP_F_437996#715524, RG_CMPIMP_H_437997#715525, RG_CODCAI_437986#715526, RG_CODCCP_437991#715527, RG_CODCEN_437987#715528, RG_CODORG_437971#715529, RG_CODPOS_437976#715530, RG_CODREG_437985#715531, RG_CODUTI_437990#715532, RG_COMMENT_438008#715533, RG_CONTAC_437982#715534, RG_DATEDE_438002#715535, RG_DATEFI_438003#715536, RG_DATENV_438001#715537, RG_DATMAJ_437989#715538, RG_E_MAIL_437980#715539, RG_FAX_437979#715540, RG_FLCHORUS_438015#715541, RG_FLLISENG_438017#715542, RG_FLPAV_438011#715543, ... 27 more fields], functions=[])

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(ORIGINE_440148#715520, RG_ADR_1_437974#715521, RG_ADR_2_437975#715522, RG_ADR_3_438006#715523, RG_CMPIMP_F_437996#715524, RG_CMPIMP_H_437997#715525, RG_CODCAI_437986#715526, RG_CODCCP_437991#715527, RG_CODCEN_437987#715528, RG_CODORG_437971#715529, RG_CODPOS_437976#715530, RG_CODREG_437985#715531, RG_CODUTI_437990#715532, RG_COMMENT_438008#715533, RG_CONTAC_437982#715534, RG_DATEDE_438002#715535, RG_DATEFI_438003#715536, RG_DATENV_438001#715537, RG_DATMAJ_437989#715538, RG_E_MAIL_437980#715539, RG_FAX_437979#715540, RG_FLCHORUS_438015#715541, RG_FLLISENG_438017#715542, RG_FLPAV_438011#715543, ... 28 more fields), ENSURE_REQUIREMENTS, [plan_id=38654]

WholeStageCodegen (3)

Union

Project [null AS ORIGINE_440148#715520, rg_adr_1#715098 AS RG_ADR_1_437974#715521, rg_adr_2#715099 AS RG_ADR_2_437975#715522, rg_adr_3#715130 AS RG_ADR_3_438006#715523, rg_cmpimp_f#715120 AS RG_CMPIMP_F_437996#715524, rg_cmpimp_h#715121 AS RG_CMPIMP_H_437997#715525, rg_codcai#715110 AS RG_CODCAI_437986#715526, rg_codccp#715115 AS RG_CODCCP_437991#715527, rg_codcen#715111 AS RG_CODCEN_437987#715528, rg_codorg#715095 AS RG_CODORG_437971#715529, rg_codpos#715100 AS RG_CODPOS_437976#715530, rg_codreg#715109 AS RG_CODREG_437985#715531, rg_coduti#715114 AS RG_CODUTI_437990#715532, rg_comment#715132 AS RG_COMMENT_438008#715533, rg_contac#715106 AS RG_CONTAC_437982#715534, rg_datede#715126 AS RG_DATEDE_438002#715535, rg_datefi#715127 AS RG_DATEFI_438003#715536, rg_datenv#715125 AS RG_DATENV_438001#715537, rg_datmaj#715113 AS RG_DATMAJ_437989#715538, rg_e_mail#715104 AS RG_E_MAIL_437980#715539, rg_fax#715103 AS RG_FAX_437979#715540, rg_flchorus#715139 AS RG_FLCHORUS_438015#715541, rg_flliseng#715141 AS RG_FLLISENG_438017#715542, rg_flpav#715135 AS RG_FLPAV_438011#715543, ... 27 more fields]

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codorg#715095)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codorg#715095)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typorg#715096)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_typorg#715096)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_nomorg#715097)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_nomorg#715097)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_1#715098)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_1#715098)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_2#715099)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_2#715099)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codpos#715100)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codpos#715100)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_ville#715101)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_ville#715101)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_telbur#715102)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_telbur#715102)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fax#715103)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fax#715103)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_e_mail#715104)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_e_mail#715104)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_prefix#715105)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_prefix#715105)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_contac#715106)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_contac#715106)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numbor#715107)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numbor#715107)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_tauxre#715108)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_tauxre#715108)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codreg#715109)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codreg#715109)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcai#715110)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcai#715110)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcen#715111)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcen#715111)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltele#715112)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltele#715112)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datmaj#715113)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datmaj#715113)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_coduti#715114)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_coduti#715114)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codccp#715115)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codccp#715115)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltp#715116)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltp#715116)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_idmut#715117)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_idmut#715117)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltopr#715118)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltopr#715118)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt#715119)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt#715119)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_f#715120)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_f#715120)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_h#715121)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_h#715121)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relctx#715122)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relctx#715122)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relpage#715123)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relpage#715123)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relref#715124)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relref#715124)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datenv#715125)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datenv#715125)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datede#715126)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datede#715126)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datefi#715127)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datefi#715127)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typoc#715128)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_typoc#715128)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_orgpayeur#715129)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_orgpayeur#715129)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_3#715130)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_3#715130)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notrel#715131)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_notrel#715131)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_comment#715132)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_comment#715132)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpecdep#715133)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpecdep#715133)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_a#715134)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_a#715134)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpav#715135)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpav#715135)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_reclam#715136)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_reclam#715136)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_trirel#715137)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_trirel#715137)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notbord#715138)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_notbord#715138)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flchorus#715139)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flchorus#715139)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numsir#715140)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numsir#715140)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flliseng#715141)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flliseng#715141)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_modreg#715142)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_modreg#715142)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c#715143)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c#715143)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c_ft#715144)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c_ft#715144)), 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#715098,rg_adr_2#715099,rg_adr_3#715130,rg_cmpimp_f#715120,rg_cmpimp_h#715121,rg_codcai#715110,rg_codccp#715115,rg_codcen#715111,rg_codorg#715095,rg_codpos#715100,rg_codreg#715109,rg_coduti#715114,rg_comment#715132,rg_contac#715106,rg_datede#715126,rg_datefi#715127,rg_datenv#715125,rg_datmaj#715113,rg_e_mail#715104,rg_fax#715103,rg_flchorus#715139,rg_flliseng#715141,rg_flpav#715135,rg_flpecdep#715133,... 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#716008, rg_adr_1#715659 AS RG_ADR_1_437974#716009, rg_adr_2#715660 AS RG_ADR_2_437975#716010, rg_adr_3#715691 AS RG_ADR_3_438006#716011, rg_cmpimp_f#715681 AS RG_CMPIMP_F_437996#716012, rg_cmpimp_h#715682 AS RG_CMPIMP_H_437997#716013, rg_codcai#715671 AS RG_CODCAI_437986#716014, rg_codccp#715676 AS RG_CODCCP_437991#716015, rg_codcen#715672 AS RG_CODCEN_437987#716016, rg_codorg#715656 AS RG_CODORG_437971#716017, rg_codpos#715661 AS RG_CODPOS_437976#716018, rg_codreg#715670 AS RG_CODREG_437985#716019, rg_coduti#715675 AS RG_CODUTI_437990#716020, rg_comment#715693 AS RG_COMMENT_438008#716021, rg_contac#715667 AS RG_CONTAC_437982#716022, rg_datede#715687 AS RG_DATEDE_438002#716023, rg_datefi#715688 AS RG_DATEFI_438003#716024, rg_datenv#715686 AS RG_DATENV_438001#716025, rg_datmaj#715674 AS RG_DATMAJ_437989#716026, rg_e_mail#715665 AS RG_E_MAIL_437980#716027, rg_fax#715664 AS RG_FAX_437979#716028, rg_flchorus#715700 AS RG_FLCHORUS_438015#716029, rg_flliseng#715702 AS RG_FLLISENG_438017#716030, rg_flpav#715696 AS RG_FLPAV_438011#716031, ... 27 more fields]

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codorg#715656)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codorg#715656)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typorg#715657)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_typorg#715657)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_nomorg#715658)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_nomorg#715658)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_1#715659)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_1#715659)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_2#715660)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_2#715660)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codpos#715661)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codpos#715661)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_ville#715662)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_ville#715662)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_telbur#715663)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_telbur#715663)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fax#715664)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fax#715664)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_e_mail#715665)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_e_mail#715665)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_prefix#715666)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_prefix#715666)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_contac#715667)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_contac#715667)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numbor#715668)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numbor#715668)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_tauxre#715669)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_tauxre#715669)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codreg#715670)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codreg#715670)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcai#715671)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcai#715671)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcen#715672)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcen#715672)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltele#715673)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltele#715673)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datmaj#715674)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datmaj#715674)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_coduti#715675)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_coduti#715675)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codccp#715676)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codccp#715676)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltp#715677)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltp#715677)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_idmut#715678)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_idmut#715678)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltopr#715679)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltopr#715679)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt#715680)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt#715680)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_f#715681)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_f#715681)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_h#715682)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_h#715682)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relctx#715683)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relctx#715683)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relpage#715684)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relpage#715684)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relref#715685)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relref#715685)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datenv#715686)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datenv#715686)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datede#715687)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datede#715687)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datefi#715688)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datefi#715688)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typoc#715689)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_typoc#715689)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_orgpayeur#715690)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_orgpayeur#715690)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_3#715691)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_3#715691)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notrel#715692)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_notrel#715692)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_comment#715693)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_comment#715693)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpecdep#715694)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpecdep#715694)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_a#715695)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_a#715695)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpav#715696)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpav#715696)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_reclam#715697)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_reclam#715697)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_trirel#715698)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_trirel#715698)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notbord#715699)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_notbord#715699)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flchorus#715700)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flchorus#715700)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numsir#715701)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numsir#715701)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flliseng#715702)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flliseng#715702)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_modreg#715703)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_modreg#715703)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c#715704)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c#715704)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c_ft#715705)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c_ft#715705)), 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#715659,rg_adr_2#715660,rg_adr_3#715691,rg_cmpimp_f#715681,rg_cmpimp_h#715682,rg_codcai#715671,rg_codccp#715676,rg_codcen#715672,rg_codorg#715656,rg_codpos#715661,rg_codreg#715670,rg_coduti#715675,rg_comment#715693,rg_contac#715667,rg_datede#715687,rg_datefi#715688,rg_datenv#715686,rg_datmaj#715674,rg_e_mail#715665,rg_fax#715664,rg_flchorus#715700,rg_flliseng#715702,rg_flpav#715696,rg_flpecdep#715694,... 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#715098, rg_adr_2#715099, rg_adr_3#715130, rg_cmpimp_f#715120, rg_cmpimp_h#715121, rg_codcai#715110, rg_codccp#715115, rg_codcen#715111, rg_codorg#715095, rg_codpos#715100, rg_codreg#715109, rg_coduti#715114, rg_comment#715132, rg_contac#715106, rg_datede#715126, rg_datefi#715127, rg_datenv#715125, rg_datmaj#715113, rg_e_mail#715104, rg_fax#715103, rg_flchorus#715139, rg_flliseng#715141, rg_flpav#715135, rg_flpecdep#715133, rg_fltele#715112, rg_fltopr#715118, rg_fltp#715116, rg_idmut#715117, rg_modreg#715142, rg_nomorg#715097, rg_notbord#715138, rg_notrel#715131, rg_numbor#715107, rg_numcpt#715119, rg_numcpt_a#715134, rg_numcpt_c#715143, rg_numcpt_c_ft#715144, rg_numsir#715140, rg_orgpayeur#715129, rg_prefix#715105, rg_reclam#715136, rg_relctx#715122, rg_relpage#715123, rg_relref#715124, rg_tauxre#715108, rg_telbur#715102, rg_trirel#715137, rg_typoc#715128, rg_typorg#715096, rg_ville#715101]
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#715098, rg_adr_2#715099, rg_adr_3#715130, rg_cmpimp_f#715120, rg_cmpimp_h#715121, rg_codcai#715110, rg_codccp#715115, rg_codcen#715111, rg_codorg#715095, rg_codpos#715100, rg_codreg#715109, rg_coduti#715114, rg_comment#715132, rg_contac#715106, rg_datede#715126, rg_datefi#715127, rg_datenv#715125, rg_datmaj#715113, rg_e_mail#715104, rg_fax#715103, rg_flchorus#715139, rg_flliseng#715141, rg_flpav#715135, rg_flpecdep#715133, rg_fltele#715112, rg_fltopr#715118, rg_fltp#715116, rg_idmut#715117, rg_modreg#715142, rg_nomorg#715097, rg_notbord#715138, rg_notrel#715131, rg_numbor#715107, rg_numcpt#715119, rg_numcpt_a#715134, rg_numcpt_c#715143, rg_numcpt_c_ft#715144, rg_numsir#715140, rg_orgpayeur#715129, rg_prefix#715105, rg_reclam#715136, rg_relctx#715122, rg_relpage#715123, rg_relref#715124, rg_tauxre#715108, rg_telbur#715102, rg_trirel#715137, rg_typoc#715128, rg_typorg#715096, rg_ville#715101]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codorg#715095)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codorg#715095)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typorg#715096)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_typorg#715096)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_nomorg#715097)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_nomorg#715097)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_1#715098)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_1#715098)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_2#715099)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_2#715099)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codpos#715100)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codpos#715100)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_ville#715101)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_ville#715101)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_telbur#715102)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_telbur#715102)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fax#715103)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fax#715103)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_e_mail#715104)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_e_mail#715104)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_prefix#715105)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_prefix#715105)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_contac#715106)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_contac#715106)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numbor#715107)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numbor#715107)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_tauxre#715108)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_tauxre#715108)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codreg#715109)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codreg#715109)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcai#715110)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcai#715110)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcen#715111)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcen#715111)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltele#715112)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltele#715112)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datmaj#715113)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datmaj#715113)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_coduti#715114)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_coduti#715114)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codccp#715115)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codccp#715115)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltp#715116)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltp#715116)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_idmut#715117)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_idmut#715117)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltopr#715118)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltopr#715118)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt#715119)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt#715119)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_f#715120)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_f#715120)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_h#715121)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_h#715121)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relctx#715122)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relctx#715122)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relpage#715123)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relpage#715123)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relref#715124)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relref#715124)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datenv#715125)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datenv#715125)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datede#715126)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datede#715126)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datefi#715127)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datefi#715127)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typoc#715128)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_typoc#715128)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_orgpayeur#715129)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_orgpayeur#715129)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_3#715130)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_3#715130)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notrel#715131)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_notrel#715131)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_comment#715132)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_comment#715132)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpecdep#715133)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpecdep#715133)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_a#715134)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_a#715134)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpav#715135)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpav#715135)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_reclam#715136)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_reclam#715136)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_trirel#715137)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_trirel#715137)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notbord#715138)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_notbord#715138)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flchorus#715139)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flchorus#715139)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numsir#715140)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numsir#715140)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flliseng#715141)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flliseng#715141)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_modreg#715142)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_modreg#715142)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c#715143)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c#715143)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c_ft#715144)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c_ft#715144)), 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#715520, rg_adr_1#715098 AS RG_ADR_1_437974#715521, rg_adr_2#715099 AS RG_ADR_2_437975#715522, rg_adr_3#715130 AS RG_ADR_3_438006#715523, rg_cmpimp_f#715120 AS RG_CMPIMP_F_437996#715524, rg_cmpimp_h#715121 AS RG_CMPIMP_H_437997#715525, rg_codcai#715110 AS RG_CODCAI_437986#715526, rg_codccp#715115 AS RG_CODCCP_437991#715527, rg_codcen#715111 AS RG_CODCEN_437987#715528, rg_codorg#715095 AS RG_CODORG_437971#715529, rg_codpos#715100 AS RG_CODPOS_437976#715530, rg_codreg#715109 AS RG_CODREG_437985#715531, rg_coduti#715114 AS RG_CODUTI_437990#715532, rg_comment#715132 AS RG_COMMENT_438008#715533, rg_contac#715106 AS RG_CONTAC_437982#715534, rg_datede#715126 AS RG_DATEDE_438002#715535, rg_datefi#715127 AS RG_DATEFI_438003#715536, rg_datenv#715125 AS RG_DATENV_438001#715537, rg_datmaj#715113 AS RG_DATMAJ_437989#715538, rg_e_mail#715104 AS RG_E_MAIL_437980#715539, rg_fax#715103 AS RG_FAX_437979#715540, rg_flchorus#715139 AS RG_FLCHORUS_438015#715541, rg_flliseng#715141 AS RG_FLLISENG_438017#715542, rg_flpav#715135 AS RG_FLPAV_438011#715543, rg_flpecdep#715133 AS RG_FLPECDEP_438009#715544, rg_fltele#715112 AS RG_FLTELE_437988#715545, rg_fltopr#715118 AS RG_FLTOPR_437994#715546, rg_fltp#715116 AS RG_FLTP_437992#715547, rg_idmut#715117 AS RG_IDMUT_437993#715548, rg_modreg#715142 AS RG_MODREG_438018#715549, rg_nomorg#715097 AS RG_NOMORG_437973#715550, rg_notbord#715138 AS RG_NOTBORD_438014#715551, rg_notrel#715131 AS RG_NOTREL_438007#715552, rg_numbor#715107 AS RG_NUMBOR_437983#715553, rg_numcpt#715119 AS RG_NUMCPT_437995#715554, rg_numcpt_a#715134 AS RG_NUMCPT_A_438010#715555, rg_numcpt_c#715143 AS RG_NUMCPT_C_438019#715556, rg_numcpt_c_ft#715144 AS RG_NUMCPT_C_FT_438020#715557, rg_numsir#715140 AS RG_NUMSIR_438016#715558, rg_orgpayeur#715129 AS RG_ORGPAYEUR_438005#715559, rg_prefix#715105 AS RG_PREFIX_437981#715560, rg_reclam#715136 AS RG_RECLAM_438012#715561, rg_relctx#715122 AS RG_RELCTX_437998#715562, rg_relpage#715123 AS RG_RELPAGE_437999#715563, rg_relref#715124 AS RG_RELREF_438000#715564, rg_tauxre#715108 AS RG_TAUXRE_437984#715565, rg_telbur#715102 AS RG_TELBUR_437978#715566, rg_trirel#715137 AS RG_TRIREL_438013#715567, rg_typoc#715128 AS RG_TYPOC_438004#715568, rg_typorg#715096 AS RG_TYPORG_437972#715569, rg_ville#715101 AS RG_VILLE_437977#715570]
Input [50]: [rg_adr_1#715098, rg_adr_2#715099, rg_adr_3#715130, rg_cmpimp_f#715120, rg_cmpimp_h#715121, rg_codcai#715110, rg_codccp#715115, rg_codcen#715111, rg_codorg#715095, rg_codpos#715100, rg_codreg#715109, rg_coduti#715114, rg_comment#715132, rg_contac#715106, rg_datede#715126, rg_datefi#715127, rg_datenv#715125, rg_datmaj#715113, rg_e_mail#715104, rg_fax#715103, rg_flchorus#715139, rg_flliseng#715141, rg_flpav#715135, rg_flpecdep#715133, rg_fltele#715112, rg_fltopr#715118, rg_fltp#715116, rg_idmut#715117, rg_modreg#715142, rg_nomorg#715097, rg_notbord#715138, rg_notrel#715131, rg_numbor#715107, rg_numcpt#715119, rg_numcpt_a#715134, rg_numcpt_c#715143, rg_numcpt_c_ft#715144, rg_numsir#715140, rg_orgpayeur#715129, rg_prefix#715105, rg_reclam#715136, rg_relctx#715122, rg_relpage#715123, rg_relref#715124, rg_tauxre#715108, rg_telbur#715102, rg_trirel#715137, rg_typoc#715128, rg_typorg#715096, rg_ville#715101]

(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#715659, rg_adr_2#715660, rg_adr_3#715691, rg_cmpimp_f#715681, rg_cmpimp_h#715682, rg_codcai#715671, rg_codccp#715676, rg_codcen#715672, rg_codorg#715656, rg_codpos#715661, rg_codreg#715670, rg_coduti#715675, rg_comment#715693, rg_contac#715667, rg_datede#715687, rg_datefi#715688, rg_datenv#715686, rg_datmaj#715674, rg_e_mail#715665, rg_fax#715664, rg_flchorus#715700, rg_flliseng#715702, rg_flpav#715696, rg_flpecdep#715694, rg_fltele#715673, rg_fltopr#715679, rg_fltp#715677, rg_idmut#715678, rg_modreg#715703, rg_nomorg#715658, rg_notbord#715699, rg_notrel#715692, rg_numbor#715668, rg_numcpt#715680, rg_numcpt_a#715695, rg_numcpt_c#715704, rg_numcpt_c_ft#715705, rg_numsir#715701, rg_orgpayeur#715690, rg_prefix#715666, rg_reclam#715697, rg_relctx#715683, rg_relpage#715684, rg_relref#715685, rg_tauxre#715669, rg_telbur#715663, rg_trirel#715698, rg_typoc#715689, rg_typorg#715657, rg_ville#715662]
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#715659, rg_adr_2#715660, rg_adr_3#715691, rg_cmpimp_f#715681, rg_cmpimp_h#715682, rg_codcai#715671, rg_codccp#715676, rg_codcen#715672, rg_codorg#715656, rg_codpos#715661, rg_codreg#715670, rg_coduti#715675, rg_comment#715693, rg_contac#715667, rg_datede#715687, rg_datefi#715688, rg_datenv#715686, rg_datmaj#715674, rg_e_mail#715665, rg_fax#715664, rg_flchorus#715700, rg_flliseng#715702, rg_flpav#715696, rg_flpecdep#715694, rg_fltele#715673, rg_fltopr#715679, rg_fltp#715677, rg_idmut#715678, rg_modreg#715703, rg_nomorg#715658, rg_notbord#715699, rg_notrel#715692, rg_numbor#715668, rg_numcpt#715680, rg_numcpt_a#715695, rg_numcpt_c#715704, rg_numcpt_c_ft#715705, rg_numsir#715701, rg_orgpayeur#715690, rg_prefix#715666, rg_reclam#715697, rg_relctx#715683, rg_relpage#715684, rg_relref#715685, rg_tauxre#715669, rg_telbur#715663, rg_trirel#715698, rg_typoc#715689, rg_typorg#715657, rg_ville#715662]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codorg#715656)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codorg#715656)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typorg#715657)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_typorg#715657)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_nomorg#715658)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_nomorg#715658)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_1#715659)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_1#715659)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_2#715660)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_2#715660)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codpos#715661)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codpos#715661)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_ville#715662)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_ville#715662)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_telbur#715663)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_telbur#715663)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fax#715664)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fax#715664)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_e_mail#715665)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_e_mail#715665)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_prefix#715666)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_prefix#715666)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_contac#715667)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_contac#715667)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numbor#715668)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numbor#715668)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_tauxre#715669)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_tauxre#715669)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codreg#715670)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codreg#715670)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcai#715671)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcai#715671)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcen#715672)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcen#715672)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltele#715673)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltele#715673)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datmaj#715674)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datmaj#715674)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_coduti#715675)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_coduti#715675)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codccp#715676)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codccp#715676)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltp#715677)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltp#715677)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_idmut#715678)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_idmut#715678)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltopr#715679)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltopr#715679)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt#715680)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt#715680)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_f#715681)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_f#715681)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_h#715682)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_h#715682)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relctx#715683)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relctx#715683)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relpage#715684)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relpage#715684)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relref#715685)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relref#715685)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datenv#715686)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datenv#715686)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datede#715687)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datede#715687)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datefi#715688)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datefi#715688)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typoc#715689)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_typoc#715689)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_orgpayeur#715690)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_orgpayeur#715690)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_3#715691)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_3#715691)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notrel#715692)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_notrel#715692)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_comment#715693)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_comment#715693)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpecdep#715694)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpecdep#715694)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_a#715695)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_a#715695)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpav#715696)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpav#715696)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_reclam#715697)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_reclam#715697)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_trirel#715698)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_trirel#715698)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notbord#715699)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_notbord#715699)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flchorus#715700)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flchorus#715700)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numsir#715701)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numsir#715701)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flliseng#715702)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flliseng#715702)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_modreg#715703)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_modreg#715703)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c#715704)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c#715704)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c_ft#715705)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c_ft#715705)), 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#716008, rg_adr_1#715659 AS RG_ADR_1_437974#716009, rg_adr_2#715660 AS RG_ADR_2_437975#716010, rg_adr_3#715691 AS RG_ADR_3_438006#716011, rg_cmpimp_f#715681 AS RG_CMPIMP_F_437996#716012, rg_cmpimp_h#715682 AS RG_CMPIMP_H_437997#716013, rg_codcai#715671 AS RG_CODCAI_437986#716014, rg_codccp#715676 AS RG_CODCCP_437991#716015, rg_codcen#715672 AS RG_CODCEN_437987#716016, rg_codorg#715656 AS RG_CODORG_437971#716017, rg_codpos#715661 AS RG_CODPOS_437976#716018, rg_codreg#715670 AS RG_CODREG_437985#716019, rg_coduti#715675 AS RG_CODUTI_437990#716020, rg_comment#715693 AS RG_COMMENT_438008#716021, rg_contac#715667 AS RG_CONTAC_437982#716022, rg_datede#715687 AS RG_DATEDE_438002#716023, rg_datefi#715688 AS RG_DATEFI_438003#716024, rg_datenv#715686 AS RG_DATENV_438001#716025, rg_datmaj#715674 AS RG_DATMAJ_437989#716026, rg_e_mail#715665 AS RG_E_MAIL_437980#716027, rg_fax#715664 AS RG_FAX_437979#716028, rg_flchorus#715700 AS RG_FLCHORUS_438015#716029, rg_flliseng#715702 AS RG_FLLISENG_438017#716030, rg_flpav#715696 AS RG_FLPAV_438011#716031, rg_flpecdep#715694 AS RG_FLPECDEP_438009#716032, rg_fltele#715673 AS RG_FLTELE_437988#716033, rg_fltopr#715679 AS RG_FLTOPR_437994#716034, rg_fltp#715677 AS RG_FLTP_437992#716035, rg_idmut#715678 AS RG_IDMUT_437993#716036, rg_modreg#715703 AS RG_MODREG_438018#716037, rg_nomorg#715658 AS RG_NOMORG_437973#716038, rg_notbord#715699 AS RG_NOTBORD_438014#716039, rg_notrel#715692 AS RG_NOTREL_438007#716040, rg_numbor#715668 AS RG_NUMBOR_437983#716041, rg_numcpt#715680 AS RG_NUMCPT_437995#716042, rg_numcpt_a#715695 AS RG_NUMCPT_A_438010#716043, rg_numcpt_c#715704 AS RG_NUMCPT_C_438019#716044, rg_numcpt_c_ft#715705 AS RG_NUMCPT_C_FT_438020#716045, rg_numsir#715701 AS RG_NUMSIR_438016#716046, rg_orgpayeur#715690 AS RG_ORGPAYEUR_438005#716047, rg_prefix#715666 AS RG_PREFIX_437981#716048, rg_reclam#715697 AS RG_RECLAM_438012#716049, rg_relctx#715683 AS RG_RELCTX_437998#716050, rg_relpage#715684 AS RG_RELPAGE_437999#716051, rg_relref#715685 AS RG_RELREF_438000#716052, rg_tauxre#715669 AS RG_TAUXRE_437984#716053, rg_telbur#715663 AS RG_TELBUR_437978#716054, rg_trirel#715698 AS RG_TRIREL_438013#716055, rg_typoc#715689 AS RG_TYPOC_438004#716056, rg_typorg#715657 AS RG_TYPORG_437972#716057, rg_ville#715662 AS RG_VILLE_437977#716058]
Input [50]: [rg_adr_1#715659, rg_adr_2#715660, rg_adr_3#715691, rg_cmpimp_f#715681, rg_cmpimp_h#715682, rg_codcai#715671, rg_codccp#715676, rg_codcen#715672, rg_codorg#715656, rg_codpos#715661, rg_codreg#715670, rg_coduti#715675, rg_comment#715693, rg_contac#715667, rg_datede#715687, rg_datefi#715688, rg_datenv#715686, rg_datmaj#715674, rg_e_mail#715665, rg_fax#715664, rg_flchorus#715700, rg_flliseng#715702, rg_flpav#715696, rg_flpecdep#715694, rg_fltele#715673, rg_fltopr#715679, rg_fltp#715677, rg_idmut#715678, rg_modreg#715703, rg_nomorg#715658, rg_notbord#715699, rg_notrel#715692, rg_numbor#715668, rg_numcpt#715680, rg_numcpt_a#715695, rg_numcpt_c#715704, rg_numcpt_c_ft#715705, rg_numsir#715701, rg_orgpayeur#715690, rg_prefix#715666, rg_reclam#715697, rg_relctx#715683, rg_relpage#715684, rg_relref#715685, rg_tauxre#715669, rg_telbur#715663, rg_trirel#715698, rg_typoc#715689, rg_typorg#715657, rg_ville#715662]

(7) Union

(8) HashAggregate [codegen id : 3]
Input [51]: [ORIGINE_440148#715520, RG_ADR_1_437974#715521, RG_ADR_2_437975#715522, RG_ADR_3_438006#715523, RG_CMPIMP_F_437996#715524, RG_CMPIMP_H_437997#715525, RG_CODCAI_437986#715526, RG_CODCCP_437991#715527, RG_CODCEN_437987#715528, RG_CODORG_437971#715529, RG_CODPOS_437976#715530, RG_CODREG_437985#715531, RG_CODUTI_437990#715532, RG_COMMENT_438008#715533, RG_CONTAC_437982#715534, RG_DATEDE_438002#715535, RG_DATEFI_438003#715536, RG_DATENV_438001#715537, RG_DATMAJ_437989#715538, RG_E_MAIL_437980#715539, RG_FAX_437979#715540, RG_FLCHORUS_438015#715541, RG_FLLISENG_438017#715542, RG_FLPAV_438011#715543, RG_FLPECDEP_438009#715544, RG_FLTELE_437988#715545, RG_FLTOPR_437994#715546, RG_FLTP_437992#715547, RG_IDMUT_437993#715548, RG_MODREG_438018#715549, RG_NOMORG_437973#715550, RG_NOTBORD_438014#715551, RG_NOTREL_438007#715552, RG_NUMBOR_437983#715553, RG_NUMCPT_437995#715554, RG_NUMCPT_A_438010#715555, RG_NUMCPT_C_438019#715556, RG_NUMCPT_C_FT_438020#715557, RG_NUMSIR_438016#715558, RG_ORGPAYEUR_438005#715559, RG_PREFIX_437981#715560, RG_RECLAM_438012#715561, RG_RELCTX_437998#715562, RG_RELPAGE_437999#715563, RG_RELREF_438000#715564, RG_TAUXRE_437984#715565, RG_TELBUR_437978#715566, RG_TRIREL_438013#715567, RG_TYPOC_438004#715568, RG_TYPORG_437972#715569, RG_VILLE_437977#715570]
Keys [51]: [ORIGINE_440148#715520, RG_ADR_1_437974#715521, RG_ADR_2_437975#715522, RG_ADR_3_438006#715523, RG_CMPIMP_F_437996#715524, RG_CMPIMP_H_437997#715525, RG_CODCAI_437986#715526, RG_CODCCP_437991#715527, RG_CODCEN_437987#715528, RG_CODORG_437971#715529, RG_CODPOS_437976#715530, RG_CODREG_437985#715531, RG_CODUTI_437990#715532, RG_COMMENT_438008#715533, RG_CONTAC_437982#715534, RG_DATEDE_438002#715535, RG_DATEFI_438003#715536, RG_DATENV_438001#715537, RG_DATMAJ_437989#715538, RG_E_MAIL_437980#715539, RG_FAX_437979#715540, RG_FLCHORUS_438015#715541, RG_FLLISENG_438017#715542, RG_FLPAV_438011#715543, RG_FLPECDEP_438009#715544, RG_FLTELE_437988#715545, RG_FLTOPR_437994#715546, RG_FLTP_437992#715547, RG_IDMUT_437993#715548, RG_MODREG_438018#715549, RG_NOMORG_437973#715550, RG_NOTBORD_438014#715551, RG_NOTREL_438007#715552, RG_NUMBOR_437983#715553, RG_NUMCPT_437995#715554, RG_NUMCPT_A_438010#715555, RG_NUMCPT_C_438019#715556, RG_NUMCPT_C_FT_438020#715557, RG_NUMSIR_438016#715558, RG_ORGPAYEUR_438005#715559, RG_PREFIX_437981#715560, RG_RECLAM_438012#715561, RG_RELCTX_437998#715562, RG_RELPAGE_437999#715563, RG_RELREF_438000#715564, RG_TAUXRE_437984#715565, RG_TELBUR_437978#715566, RG_TRIREL_438013#715567, RG_TYPOC_438004#715568, RG_TYPORG_437972#715569, RG_VILLE_437977#715570]
Functions: []
Aggregate Attributes: []
Results [51]: [ORIGINE_440148#715520, RG_ADR_1_437974#715521, RG_ADR_2_437975#715522, RG_ADR_3_438006#715523, RG_CMPIMP_F_437996#715524, RG_CMPIMP_H_437997#715525, RG_CODCAI_437986#715526, RG_CODCCP_437991#715527, RG_CODCEN_437987#715528, RG_CODORG_437971#715529, RG_CODPOS_437976#715530, RG_CODREG_437985#715531, RG_CODUTI_437990#715532, RG_COMMENT_438008#715533, RG_CONTAC_437982#715534, RG_DATEDE_438002#715535, RG_DATEFI_438003#715536, RG_DATENV_438001#715537, RG_DATMAJ_437989#715538, RG_E_MAIL_437980#715539, RG_FAX_437979#715540, RG_FLCHORUS_438015#715541, RG_FLLISENG_438017#715542, RG_FLPAV_438011#715543, RG_FLPECDEP_438009#715544, RG_FLTELE_437988#715545, RG_FLTOPR_437994#715546, RG_FLTP_437992#715547, RG_IDMUT_437993#715548, RG_MODREG_438018#715549, RG_NOMORG_437973#715550, RG_NOTBORD_438014#715551, RG_NOTREL_438007#715552, RG_NUMBOR_437983#715553, RG_NUMCPT_437995#715554, RG_NUMCPT_A_438010#715555, RG_NUMCPT_C_438019#715556, RG_NUMCPT_C_FT_438020#715557, RG_NUMSIR_438016#715558, RG_ORGPAYEUR_438005#715559, RG_PREFIX_437981#715560, RG_RECLAM_438012#715561, RG_RELCTX_437998#715562, RG_RELPAGE_437999#715563, RG_RELREF_438000#715564, RG_TAUXRE_437984#715565, RG_TELBUR_437978#715566, RG_TRIREL_438013#715567, RG_TYPOC_438004#715568, RG_TYPORG_437972#715569, RG_VILLE_437977#715570]

(9) Exchange
Input [51]: [ORIGINE_440148#715520, RG_ADR_1_437974#715521, RG_ADR_2_437975#715522, RG_ADR_3_438006#715523, RG_CMPIMP_F_437996#715524, RG_CMPIMP_H_437997#715525, RG_CODCAI_437986#715526, RG_CODCCP_437991#715527, RG_CODCEN_437987#715528, RG_CODORG_437971#715529, RG_CODPOS_437976#715530, RG_CODREG_437985#715531, RG_CODUTI_437990#715532, RG_COMMENT_438008#715533, RG_CONTAC_437982#715534, RG_DATEDE_438002#715535, RG_DATEFI_438003#715536, RG_DATENV_438001#715537, RG_DATMAJ_437989#715538, RG_E_MAIL_437980#715539, RG_FAX_437979#715540, RG_FLCHORUS_438015#715541, RG_FLLISENG_438017#715542, RG_FLPAV_438011#715543, RG_FLPECDEP_438009#715544, RG_FLTELE_437988#715545, RG_FLTOPR_437994#715546, RG_FLTP_437992#715547, RG_IDMUT_437993#715548, RG_MODREG_438018#715549, RG_NOMORG_437973#715550, RG_NOTBORD_438014#715551, RG_NOTREL_438007#715552, RG_NUMBOR_437983#715553, RG_NUMCPT_437995#715554, RG_NUMCPT_A_438010#715555, RG_NUMCPT_C_438019#715556, RG_NUMCPT_C_FT_438020#715557, RG_NUMSIR_438016#715558, RG_ORGPAYEUR_438005#715559, RG_PREFIX_437981#715560, RG_RECLAM_438012#715561, RG_RELCTX_437998#715562, RG_RELPAGE_437999#715563, RG_RELREF_438000#715564, RG_TAUXRE_437984#715565, RG_TELBUR_437978#715566, RG_TRIREL_438013#715567, RG_TYPOC_438004#715568, RG_TYPORG_437972#715569, RG_VILLE_437977#715570]
Arguments: hashpartitioning(ORIGINE_440148#715520, RG_ADR_1_437974#715521, RG_ADR_2_437975#715522, RG_ADR_3_438006#715523, RG_CMPIMP_F_437996#715524, RG_CMPIMP_H_437997#715525, RG_CODCAI_437986#715526, RG_CODCCP_437991#715527, RG_CODCEN_437987#715528, RG_CODORG_437971#715529, RG_CODPOS_437976#715530, RG_CODREG_437985#715531, RG_CODUTI_437990#715532, RG_COMMENT_438008#715533, RG_CONTAC_437982#715534, RG_DATEDE_438002#715535, RG_DATEFI_438003#715536, RG_DATENV_438001#715537, RG_DATMAJ_437989#715538, RG_E_MAIL_437980#715539, RG_FAX_437979#715540, RG_FLCHORUS_438015#715541, RG_FLLISENG_438017#715542, RG_FLPAV_438011#715543, ... 28 more fields), ENSURE_REQUIREMENTS, [plan_id=38654]

(10) ShuffleQueryStage
Output [51]: [ORIGINE_440148#715520, RG_ADR_1_437974#715521, RG_ADR_2_437975#715522, RG_ADR_3_438006#715523, RG_CMPIMP_F_437996#715524, RG_CMPIMP_H_437997#715525, RG_CODCAI_437986#715526, RG_CODCCP_437991#715527, RG_CODCEN_437987#715528, RG_CODORG_437971#715529, RG_CODPOS_437976#715530, RG_CODREG_437985#715531, RG_CODUTI_437990#715532, RG_COMMENT_438008#715533, RG_CONTAC_437982#715534, RG_DATEDE_438002#715535, RG_DATEFI_438003#715536, RG_DATENV_438001#715537, RG_DATMAJ_437989#715538, RG_E_MAIL_437980#715539, RG_FAX_437979#715540, RG_FLCHORUS_438015#715541, RG_FLLISENG_438017#715542, RG_FLPAV_438011#715543, RG_FLPECDEP_438009#715544, RG_FLTELE_437988#715545, RG_FLTOPR_437994#715546, RG_FLTP_437992#715547, RG_IDMUT_437993#715548, RG_MODREG_438018#715549, RG_NOMORG_437973#715550, RG_NOTBORD_438014#715551, RG_NOTREL_438007#715552, RG_NUMBOR_437983#715553, RG_NUMCPT_437995#715554, RG_NUMCPT_A_438010#715555, RG_NUMCPT_C_438019#715556, RG_NUMCPT_C_FT_438020#715557, RG_NUMSIR_438016#715558, RG_ORGPAYEUR_438005#715559, RG_PREFIX_437981#715560, RG_RECLAM_438012#715561, RG_RELCTX_437998#715562, RG_RELPAGE_437999#715563, RG_RELREF_438000#715564, RG_TAUXRE_437984#715565, RG_TELBUR_437978#715566, RG_TRIREL_438013#715567, RG_TYPOC_438004#715568, RG_TYPORG_437972#715569, RG_VILLE_437977#715570]
Arguments: 0

(11) AQEShuffleRead
Input [51]: [ORIGINE_440148#715520, RG_ADR_1_437974#715521, RG_ADR_2_437975#715522, RG_ADR_3_438006#715523, RG_CMPIMP_F_437996#715524, RG_CMPIMP_H_437997#715525, RG_CODCAI_437986#715526, RG_CODCCP_437991#715527, RG_CODCEN_437987#715528, RG_CODORG_437971#715529, RG_CODPOS_437976#715530, RG_CODREG_437985#715531, RG_CODUTI_437990#715532, RG_COMMENT_438008#715533, RG_CONTAC_437982#715534, RG_DATEDE_438002#715535, RG_DATEFI_438003#715536, RG_DATENV_438001#715537, RG_DATMAJ_437989#715538, RG_E_MAIL_437980#715539, RG_FAX_437979#715540, RG_FLCHORUS_438015#715541, RG_FLLISENG_438017#715542, RG_FLPAV_438011#715543, RG_FLPECDEP_438009#715544, RG_FLTELE_437988#715545, RG_FLTOPR_437994#715546, RG_FLTP_437992#715547, RG_IDMUT_437993#715548, RG_MODREG_438018#715549, RG_NOMORG_437973#715550, RG_NOTBORD_438014#715551, RG_NOTREL_438007#715552, RG_NUMBOR_437983#715553, RG_NUMCPT_437995#715554, RG_NUMCPT_A_438010#715555, RG_NUMCPT_C_438019#715556, RG_NUMCPT_C_FT_438020#715557, RG_NUMSIR_438016#715558, RG_ORGPAYEUR_438005#715559, RG_PREFIX_437981#715560, RG_RECLAM_438012#715561, RG_RELCTX_437998#715562, RG_RELPAGE_437999#715563, RG_RELREF_438000#715564, RG_TAUXRE_437984#715565, RG_TELBUR_437978#715566, RG_TRIREL_438013#715567, RG_TYPOC_438004#715568, RG_TYPORG_437972#715569, RG_VILLE_437977#715570]
Arguments: coalesced

(12) HashAggregate [codegen id : 4]
Input [51]: [ORIGINE_440148#715520, RG_ADR_1_437974#715521, RG_ADR_2_437975#715522, RG_ADR_3_438006#715523, RG_CMPIMP_F_437996#715524, RG_CMPIMP_H_437997#715525, RG_CODCAI_437986#715526, RG_CODCCP_437991#715527, RG_CODCEN_437987#715528, RG_CODORG_437971#715529, RG_CODPOS_437976#715530, RG_CODREG_437985#715531, RG_CODUTI_437990#715532, RG_COMMENT_438008#715533, RG_CONTAC_437982#715534, RG_DATEDE_438002#715535, RG_DATEFI_438003#715536, RG_DATENV_438001#715537, RG_DATMAJ_437989#715538, RG_E_MAIL_437980#715539, RG_FAX_437979#715540, RG_FLCHORUS_438015#715541, RG_FLLISENG_438017#715542, RG_FLPAV_438011#715543, RG_FLPECDEP_438009#715544, RG_FLTELE_437988#715545, RG_FLTOPR_437994#715546, RG_FLTP_437992#715547, RG_IDMUT_437993#715548, RG_MODREG_438018#715549, RG_NOMORG_437973#715550, RG_NOTBORD_438014#715551, RG_NOTREL_438007#715552, RG_NUMBOR_437983#715553, RG_NUMCPT_437995#715554, RG_NUMCPT_A_438010#715555, RG_NUMCPT_C_438019#715556, RG_NUMCPT_C_FT_438020#715557, RG_NUMSIR_438016#715558, RG_ORGPAYEUR_438005#715559, RG_PREFIX_437981#715560, RG_RECLAM_438012#715561, RG_RELCTX_437998#715562, RG_RELPAGE_437999#715563, RG_RELREF_438000#715564, RG_TAUXRE_437984#715565, RG_TELBUR_437978#715566, RG_TRIREL_438013#715567, RG_TYPOC_438004#715568, RG_TYPORG_437972#715569, RG_VILLE_437977#715570]
Keys [51]: [ORIGINE_440148#715520, RG_ADR_1_437974#715521, RG_ADR_2_437975#715522, RG_ADR_3_438006#715523, RG_CMPIMP_F_437996#715524, RG_CMPIMP_H_437997#715525, RG_CODCAI_437986#715526, RG_CODCCP_437991#715527, RG_CODCEN_437987#715528, RG_CODORG_437971#715529, RG_CODPOS_437976#715530, RG_CODREG_437985#715531, RG_CODUTI_437990#715532, RG_COMMENT_438008#715533, RG_CONTAC_437982#715534, RG_DATEDE_438002#715535, RG_DATEFI_438003#715536, RG_DATENV_438001#715537, RG_DATMAJ_437989#715538, RG_E_MAIL_437980#715539, RG_FAX_437979#715540, RG_FLCHORUS_438015#715541, RG_FLLISENG_438017#715542, RG_FLPAV_438011#715543, RG_FLPECDEP_438009#715544, RG_FLTELE_437988#715545, RG_FLTOPR_437994#715546, RG_FLTP_437992#715547, RG_IDMUT_437993#715548, RG_MODREG_438018#715549, RG_NOMORG_437973#715550, RG_NOTBORD_438014#715551, RG_NOTREL_438007#715552, RG_NUMBOR_437983#715553, RG_NUMCPT_437995#715554, RG_NUMCPT_A_438010#715555, RG_NUMCPT_C_438019#715556, RG_NUMCPT_C_FT_438020#715557, RG_NUMSIR_438016#715558, RG_ORGPAYEUR_438005#715559, RG_PREFIX_437981#715560, RG_RECLAM_438012#715561, RG_RELCTX_437998#715562, RG_RELPAGE_437999#715563, RG_RELREF_438000#715564, RG_TAUXRE_437984#715565, RG_TELBUR_437978#715566, RG_TRIREL_438013#715567, RG_TYPOC_438004#715568, RG_TYPORG_437972#715569, RG_VILLE_437977#715570]
Functions: []
Aggregate Attributes: []
Results: []

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

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

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

(16) HashAggregate [codegen id : 5]
Input [1]: [count#719770L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#718098L]
Results [1]: [count(1)#718098L AS COL_a340abc2-f12c-42ef-a751-1ae8f19ee428#718100L]

(17) Union

(18) HashAggregate
Input [51]: [ORIGINE_440148#715520, RG_ADR_1_437974#715521, RG_ADR_2_437975#715522, RG_ADR_3_438006#715523, RG_CMPIMP_F_437996#715524, RG_CMPIMP_H_437997#715525, RG_CODCAI_437986#715526, RG_CODCCP_437991#715527, RG_CODCEN_437987#715528, RG_CODORG_437971#715529, RG_CODPOS_437976#715530, RG_CODREG_437985#715531, RG_CODUTI_437990#715532, RG_COMMENT_438008#715533, RG_CONTAC_437982#715534, RG_DATEDE_438002#715535, RG_DATEFI_438003#715536, RG_DATENV_438001#715537, RG_DATMAJ_437989#715538, RG_E_MAIL_437980#715539, RG_FAX_437979#715540, RG_FLCHORUS_438015#715541, RG_FLLISENG_438017#715542, RG_FLPAV_438011#715543, RG_FLPECDEP_438009#715544, RG_FLTELE_437988#715545, RG_FLTOPR_437994#715546, RG_FLTP_437992#715547, RG_IDMUT_437993#715548, RG_MODREG_438018#715549, RG_NOMORG_437973#715550, RG_NOTBORD_438014#715551, RG_NOTREL_438007#715552, RG_NUMBOR_437983#715553, RG_NUMCPT_437995#715554, RG_NUMCPT_A_438010#715555, RG_NUMCPT_C_438019#715556, RG_NUMCPT_C_FT_438020#715557, RG_NUMSIR_438016#715558, RG_ORGPAYEUR_438005#715559, RG_PREFIX_437981#715560, RG_RECLAM_438012#715561, RG_RELCTX_437998#715562, RG_RELPAGE_437999#715563, RG_RELREF_438000#715564, RG_TAUXRE_437984#715565, RG_TELBUR_437978#715566, RG_TRIREL_438013#715567, RG_TYPOC_438004#715568, RG_TYPORG_437972#715569, RG_VILLE_437977#715570]
Keys [51]: [ORIGINE_440148#715520, RG_ADR_1_437974#715521, RG_ADR_2_437975#715522, RG_ADR_3_438006#715523, RG_CMPIMP_F_437996#715524, RG_CMPIMP_H_437997#715525, RG_CODCAI_437986#715526, RG_CODCCP_437991#715527, RG_CODCEN_437987#715528, RG_CODORG_437971#715529, RG_CODPOS_437976#715530, RG_CODREG_437985#715531, RG_CODUTI_437990#715532, RG_COMMENT_438008#715533, RG_CONTAC_437982#715534, RG_DATEDE_438002#715535, RG_DATEFI_438003#715536, RG_DATENV_438001#715537, RG_DATMAJ_437989#715538, RG_E_MAIL_437980#715539, RG_FAX_437979#715540, RG_FLCHORUS_438015#715541, RG_FLLISENG_438017#715542, RG_FLPAV_438011#715543, RG_FLPECDEP_438009#715544, RG_FLTELE_437988#715545, RG_FLTOPR_437994#715546, RG_FLTP_437992#715547, RG_IDMUT_437993#715548, RG_MODREG_438018#715549, RG_NOMORG_437973#715550, RG_NOTBORD_438014#715551, RG_NOTREL_438007#715552, RG_NUMBOR_437983#715553, RG_NUMCPT_437995#715554, RG_NUMCPT_A_438010#715555, RG_NUMCPT_C_438019#715556, RG_NUMCPT_C_FT_438020#715557, RG_NUMSIR_438016#715558, RG_ORGPAYEUR_438005#715559, RG_PREFIX_437981#715560, RG_RECLAM_438012#715561, RG_RELCTX_437998#715562, RG_RELPAGE_437999#715563, RG_RELREF_438000#715564, RG_TAUXRE_437984#715565, RG_TELBUR_437978#715566, RG_TRIREL_438013#715567, RG_TYPOC_438004#715568, RG_TYPORG_437972#715569, RG_VILLE_437977#715570]
Functions: []
Aggregate Attributes: []
Results [51]: [ORIGINE_440148#715520, RG_ADR_1_437974#715521, RG_ADR_2_437975#715522, RG_ADR_3_438006#715523, RG_CMPIMP_F_437996#715524, RG_CMPIMP_H_437997#715525, RG_CODCAI_437986#715526, RG_CODCCP_437991#715527, RG_CODCEN_437987#715528, RG_CODORG_437971#715529, RG_CODPOS_437976#715530, RG_CODREG_437985#715531, RG_CODUTI_437990#715532, RG_COMMENT_438008#715533, RG_CONTAC_437982#715534, RG_DATEDE_438002#715535, RG_DATEFI_438003#715536, RG_DATENV_438001#715537, RG_DATMAJ_437989#715538, RG_E_MAIL_437980#715539, RG_FAX_437979#715540, RG_FLCHORUS_438015#715541, RG_FLLISENG_438017#715542, RG_FLPAV_438011#715543, RG_FLPECDEP_438009#715544, RG_FLTELE_437988#715545, RG_FLTOPR_437994#715546, RG_FLTP_437992#715547, RG_IDMUT_437993#715548, RG_MODREG_438018#715549, RG_NOMORG_437973#715550, RG_NOTBORD_438014#715551, RG_NOTREL_438007#715552, RG_NUMBOR_437983#715553, RG_NUMCPT_437995#715554, RG_NUMCPT_A_438010#715555, RG_NUMCPT_C_438019#715556, RG_NUMCPT_C_FT_438020#715557, RG_NUMSIR_438016#715558, RG_ORGPAYEUR_438005#715559, RG_PREFIX_437981#715560, RG_RECLAM_438012#715561, RG_RELCTX_437998#715562, RG_RELPAGE_437999#715563, RG_RELREF_438000#715564, RG_TAUXRE_437984#715565, RG_TELBUR_437978#715566, RG_TRIREL_438013#715567, RG_TYPOC_438004#715568, RG_TYPORG_437972#715569, RG_VILLE_437977#715570]

(19) Exchange
Input [51]: [ORIGINE_440148#715520, RG_ADR_1_437974#715521, RG_ADR_2_437975#715522, RG_ADR_3_438006#715523, RG_CMPIMP_F_437996#715524, RG_CMPIMP_H_437997#715525, RG_CODCAI_437986#715526, RG_CODCCP_437991#715527, RG_CODCEN_437987#715528, RG_CODORG_437971#715529, RG_CODPOS_437976#715530, RG_CODREG_437985#715531, RG_CODUTI_437990#715532, RG_COMMENT_438008#715533, RG_CONTAC_437982#715534, RG_DATEDE_438002#715535, RG_DATEFI_438003#715536, RG_DATENV_438001#715537, RG_DATMAJ_437989#715538, RG_E_MAIL_437980#715539, RG_FAX_437979#715540, RG_FLCHORUS_438015#715541, RG_FLLISENG_438017#715542, RG_FLPAV_438011#715543, RG_FLPECDEP_438009#715544, RG_FLTELE_437988#715545, RG_FLTOPR_437994#715546, RG_FLTP_437992#715547, RG_IDMUT_437993#715548, RG_MODREG_438018#715549, RG_NOMORG_437973#715550, RG_NOTBORD_438014#715551, RG_NOTREL_438007#715552, RG_NUMBOR_437983#715553, RG_NUMCPT_437995#715554, RG_NUMCPT_A_438010#715555, RG_NUMCPT_C_438019#715556, RG_NUMCPT_C_FT_438020#715557, RG_NUMSIR_438016#715558, RG_ORGPAYEUR_438005#715559, RG_PREFIX_437981#715560, RG_RECLAM_438012#715561, RG_RELCTX_437998#715562, RG_RELPAGE_437999#715563, RG_RELREF_438000#715564, RG_TAUXRE_437984#715565, RG_TELBUR_437978#715566, RG_TRIREL_438013#715567, RG_TYPOC_438004#715568, RG_TYPORG_437972#715569, RG_VILLE_437977#715570]
Arguments: hashpartitioning(ORIGINE_440148#715520, RG_ADR_1_437974#715521, RG_ADR_2_437975#715522, RG_ADR_3_438006#715523, RG_CMPIMP_F_437996#715524, RG_CMPIMP_H_437997#715525, RG_CODCAI_437986#715526, RG_CODCCP_437991#715527, RG_CODCEN_437987#715528, RG_CODORG_437971#715529, RG_CODPOS_437976#715530, RG_CODREG_437985#715531, RG_CODUTI_437990#715532, RG_COMMENT_438008#715533, RG_CONTAC_437982#715534, RG_DATEDE_438002#715535, RG_DATEFI_438003#715536, RG_DATENV_438001#715537, RG_DATMAJ_437989#715538, RG_E_MAIL_437980#715539, RG_FAX_437979#715540, RG_FLCHORUS_438015#715541, RG_FLLISENG_438017#715542, RG_FLPAV_438011#715543, ... 28 more fields), ENSURE_REQUIREMENTS, [plan_id=38606]

(20) HashAggregate
Input [51]: [ORIGINE_440148#715520, RG_ADR_1_437974#715521, RG_ADR_2_437975#715522, RG_ADR_3_438006#715523, RG_CMPIMP_F_437996#715524, RG_CMPIMP_H_437997#715525, RG_CODCAI_437986#715526, RG_CODCCP_437991#715527, RG_CODCEN_437987#715528, RG_CODORG_437971#715529, RG_CODPOS_437976#715530, RG_CODREG_437985#715531, RG_CODUTI_437990#715532, RG_COMMENT_438008#715533, RG_CONTAC_437982#715534, RG_DATEDE_438002#715535, RG_DATEFI_438003#715536, RG_DATENV_438001#715537, RG_DATMAJ_437989#715538, RG_E_MAIL_437980#715539, RG_FAX_437979#715540, RG_FLCHORUS_438015#715541, RG_FLLISENG_438017#715542, RG_FLPAV_438011#715543, RG_FLPECDEP_438009#715544, RG_FLTELE_437988#715545, RG_FLTOPR_437994#715546, RG_FLTP_437992#715547, RG_IDMUT_437993#715548, RG_MODREG_438018#715549, RG_NOMORG_437973#715550, RG_NOTBORD_438014#715551, RG_NOTREL_438007#715552, RG_NUMBOR_437983#715553, RG_NUMCPT_437995#715554, RG_NUMCPT_A_438010#715555, RG_NUMCPT_C_438019#715556, RG_NUMCPT_C_FT_438020#715557, RG_NUMSIR_438016#715558, RG_ORGPAYEUR_438005#715559, RG_PREFIX_437981#715560, RG_RECLAM_438012#715561, RG_RELCTX_437998#715562, RG_RELPAGE_437999#715563, RG_RELREF_438000#715564, RG_TAUXRE_437984#715565, RG_TELBUR_437978#715566, RG_TRIREL_438013#715567, RG_TYPOC_438004#715568, RG_TYPORG_437972#715569, RG_VILLE_437977#715570]
Keys [51]: [ORIGINE_440148#715520, RG_ADR_1_437974#715521, RG_ADR_2_437975#715522, RG_ADR_3_438006#715523, RG_CMPIMP_F_437996#715524, RG_CMPIMP_H_437997#715525, RG_CODCAI_437986#715526, RG_CODCCP_437991#715527, RG_CODCEN_437987#715528, RG_CODORG_437971#715529, RG_CODPOS_437976#715530, RG_CODREG_437985#715531, RG_CODUTI_437990#715532, RG_COMMENT_438008#715533, RG_CONTAC_437982#715534, RG_DATEDE_438002#715535, RG_DATEFI_438003#715536, RG_DATENV_438001#715537, RG_DATMAJ_437989#715538, RG_E_MAIL_437980#715539, RG_FAX_437979#715540, RG_FLCHORUS_438015#715541, RG_FLLISENG_438017#715542, RG_FLPAV_438011#715543, RG_FLPECDEP_438009#715544, RG_FLTELE_437988#715545, RG_FLTOPR_437994#715546, RG_FLTP_437992#715547, RG_IDMUT_437993#715548, RG_MODREG_438018#715549, RG_NOMORG_437973#715550, RG_NOTBORD_438014#715551, RG_NOTREL_438007#715552, RG_NUMBOR_437983#715553, RG_NUMCPT_437995#715554, RG_NUMCPT_A_438010#715555, RG_NUMCPT_C_438019#715556, RG_NUMCPT_C_FT_438020#715557, RG_NUMSIR_438016#715558, RG_ORGPAYEUR_438005#715559, RG_PREFIX_437981#715560, RG_RECLAM_438012#715561, RG_RELCTX_437998#715562, RG_RELPAGE_437999#715563, RG_RELREF_438000#715564, RG_TAUXRE_437984#715565, RG_TELBUR_437978#715566, RG_TRIREL_438013#715567, RG_TYPOC_438004#715568, RG_TYPORG_437972#715569, RG_VILLE_437977#715570]
Functions: []
Aggregate Attributes: []
Results: []

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

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

(23) HashAggregate
Input [1]: [count#719770L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#718098L]
Results [1]: [count(1)#718098L AS COL_a340abc2-f12c-42ef-a751-1ae8f19ee428#718100L]

(24) AdaptiveSparkPlan
Output [1]: [COL_a340abc2-f12c-42ef-a751-1ae8f19ee428#718100L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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