hdh-spark-job - Details for Query 1314

Submitted Time: 2026/10/23 13:26:32
Duration: 14 s
Succeeded Jobs: 1313 1315 1320

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: 1 number of sort fallback tasks: 0 avg hash probes per key: 1"]; } 7 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 552.0 B number of coalesced partitions: 1"]; 8 [labelType="html" label="Exchange shuffle records written: 2 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 1 ms (0 ms, 0 ms, 0 ms (stage 1891.0: task 1647)) 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: 2 local bytes read: 520.0 B 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)) 1216.0 B (608.0 B, 608.0 B, 608.0 B (stage 1891.0: task 1648)) 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)) 520.0 B (260.0 B, 260.0 B, 260.0 B (stage 1891.0: task 1648))"]; subgraph cluster9 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n711 ms (348 ms, 363 ms, 363 ms (stage 1891.0: task 1647))"; 10 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 639 ms (312 ms, 327 ms, 327 ms (stage 1891.0: task 1647)) peak memory total (min, med, max (stageId: taskId)) 128.5 MiB (64.2 MiB, 64.2 MiB, 64.2 MiB (stage 1891.0: task 1648)) number of output rows: 2 number of sort fallback tasks: 0 avg hash probes per key (min, med, max (stageId: taskId)): (1, 1, 1 (stage 1891.0: task 1648))"]; } 11 [labelType="html" label=" Union "]; subgraph cluster12 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 404 ms"; 13 [labelType="html" label=" Project "]; 14 [labelType="html" label="Filter number of output rows: 1"]; 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: 382 ms"; 17 [labelType="html" label=" Project "]; 18 [labelType="html" label="Filter number of output rows: 1"]; 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=35250]

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

HashAggregate(keys=[ORIGINE_440148#638737, RG_ADR_1_437974#638738, RG_ADR_2_437975#638739, RG_ADR_3_438006#638740, RG_CMPIMP_F_437996#638741, RG_CMPIMP_H_437997#638742, RG_CODCAI_437986#638743, RG_CODCCP_437991#638744, RG_CODCEN_437987#638745, RG_CODORG_437971#638746, RG_CODPOS_437976#638747, RG_CODREG_437985#638748, RG_CODUTI_437990#638749, RG_COMMENT_438008#638750, RG_CONTAC_437982#638751, RG_DATEDE_438002#638752, RG_DATEFI_438003#638753, RG_DATENV_438001#638754, RG_DATMAJ_437989#638755, RG_E_MAIL_437980#638756, RG_FAX_437979#638757, RG_FLCHORUS_438015#638758, RG_FLLISENG_438017#638759, RG_FLPAV_438011#638760, ... 27 more fields], functions=[])

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(ORIGINE_440148#638737, RG_ADR_1_437974#638738, RG_ADR_2_437975#638739, RG_ADR_3_438006#638740, RG_CMPIMP_F_437996#638741, RG_CMPIMP_H_437997#638742, RG_CODCAI_437986#638743, RG_CODCCP_437991#638744, RG_CODCEN_437987#638745, RG_CODORG_437971#638746, RG_CODPOS_437976#638747, RG_CODREG_437985#638748, RG_CODUTI_437990#638749, RG_COMMENT_438008#638750, RG_CONTAC_437982#638751, RG_DATEDE_438002#638752, RG_DATEFI_438003#638753, RG_DATENV_438001#638754, RG_DATMAJ_437989#638755, RG_E_MAIL_437980#638756, RG_FAX_437979#638757, RG_FLCHORUS_438015#638758, RG_FLLISENG_438017#638759, RG_FLPAV_438011#638760, ... 28 more fields), ENSURE_REQUIREMENTS, [plan_id=34952]

WholeStageCodegen (3)

Union

Project [null AS ORIGINE_440148#638737, rg_adr_1#638095 AS RG_ADR_1_437974#638738, rg_adr_2#638096 AS RG_ADR_2_437975#638739, rg_adr_3#638127 AS RG_ADR_3_438006#638740, rg_cmpimp_f#638117 AS RG_CMPIMP_F_437996#638741, rg_cmpimp_h#638118 AS RG_CMPIMP_H_437997#638742, rg_codcai#638107 AS RG_CODCAI_437986#638743, rg_codccp#638112 AS RG_CODCCP_437991#638744, rg_codcen#638108 AS RG_CODCEN_437987#638745, rg_codorg#638092 AS RG_CODORG_437971#638746, rg_codpos#638097 AS RG_CODPOS_437976#638747, rg_codreg#638106 AS RG_CODREG_437985#638748, rg_coduti#638111 AS RG_CODUTI_437990#638749, rg_comment#638129 AS RG_COMMENT_438008#638750, rg_contac#638103 AS RG_CONTAC_437982#638751, rg_datede#638123 AS RG_DATEDE_438002#638752, rg_datefi#638124 AS RG_DATEFI_438003#638753, rg_datenv#638122 AS RG_DATENV_438001#638754, rg_datmaj#638110 AS RG_DATMAJ_437989#638755, rg_e_mail#638101 AS RG_E_MAIL_437980#638756, rg_fax#638100 AS RG_FAX_437979#638757, rg_flchorus#638136 AS RG_FLCHORUS_438015#638758, rg_flliseng#638138 AS RG_FLLISENG_438017#638759, rg_flpav#638132 AS RG_FLPAV_438011#638760, ... 27 more fields]

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codorg#638092)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codorg#638092)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typorg#638093)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_typorg#638093)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_nomorg#638094)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_nomorg#638094)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_1#638095)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_1#638095)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_2#638096)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_2#638096)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codpos#638097)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codpos#638097)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_ville#638098)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_ville#638098)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_telbur#638099)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_telbur#638099)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fax#638100)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fax#638100)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_e_mail#638101)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_e_mail#638101)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_prefix#638102)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_prefix#638102)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_contac#638103)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_contac#638103)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numbor#638104)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numbor#638104)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_tauxre#638105)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_tauxre#638105)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codreg#638106)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codreg#638106)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcai#638107)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcai#638107)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcen#638108)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcen#638108)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltele#638109)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltele#638109)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datmaj#638110)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datmaj#638110)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_coduti#638111)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_coduti#638111)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codccp#638112)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codccp#638112)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltp#638113)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltp#638113)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_idmut#638114)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_idmut#638114)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltopr#638115)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltopr#638115)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt#638116)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt#638116)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_f#638117)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_f#638117)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_h#638118)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_h#638118)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relctx#638119)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_relctx#638119)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relpage#638120)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_relpage#638120)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relref#638121)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_relref#638121)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datenv#638122)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datenv#638122)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datede#638123)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datede#638123)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datefi#638124)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datefi#638124)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typoc#638125)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_typoc#638125)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_orgpayeur#638126)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_orgpayeur#638126)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_3#638127)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_3#638127)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notrel#638128)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_notrel#638128)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_comment#638129)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_comment#638129)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpecdep#638130)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpecdep#638130)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_a#638131)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_a#638131)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpav#638132)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpav#638132)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_reclam#638133)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_reclam#638133)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_trirel#638134)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_trirel#638134)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notbord#638135)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_notbord#638135)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flchorus#638136)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flchorus#638136)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numsir#638137)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numsir#638137)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flliseng#638138)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flliseng#638138)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_modreg#638139)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_modreg#638139)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c#638140)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c#638140)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c_ft#638141)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c_ft#638141)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(null), MARX)) THEN false ELSE Contains(str_remove_accent(null), MARX) 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#638095,rg_adr_2#638096,rg_adr_3#638127,rg_cmpimp_f#638117,rg_cmpimp_h#638118,rg_codcai#638107,rg_codccp#638112,rg_codcen#638108,rg_codorg#638092,rg_codpos#638097,rg_codreg#638106,rg_coduti#638111,rg_comment#638129,rg_contac#638103,rg_datede#638123,rg_datefi#638124,rg_datenv#638122,rg_datmaj#638110,rg_e_mail#638101,rg_fax#638100,rg_flchorus#638136,rg_flliseng#638138,rg_flpav#638132,rg_flpecdep#638130,... 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#639545, rg_adr_1#639080 AS RG_ADR_1_437974#639546, rg_adr_2#639081 AS RG_ADR_2_437975#639547, rg_adr_3#639112 AS RG_ADR_3_438006#639548, rg_cmpimp_f#639102 AS RG_CMPIMP_F_437996#639549, rg_cmpimp_h#639103 AS RG_CMPIMP_H_437997#639550, rg_codcai#639092 AS RG_CODCAI_437986#639551, rg_codccp#639097 AS RG_CODCCP_437991#639552, rg_codcen#639093 AS RG_CODCEN_437987#639553, rg_codorg#639077 AS RG_CODORG_437971#639554, rg_codpos#639082 AS RG_CODPOS_437976#639555, rg_codreg#639091 AS RG_CODREG_437985#639556, rg_coduti#639096 AS RG_CODUTI_437990#639557, rg_comment#639114 AS RG_COMMENT_438008#639558, rg_contac#639088 AS RG_CONTAC_437982#639559, rg_datede#639108 AS RG_DATEDE_438002#639560, rg_datefi#639109 AS RG_DATEFI_438003#639561, rg_datenv#639107 AS RG_DATENV_438001#639562, rg_datmaj#639095 AS RG_DATMAJ_437989#639563, rg_e_mail#639086 AS RG_E_MAIL_437980#639564, rg_fax#639085 AS RG_FAX_437979#639565, rg_flchorus#639121 AS RG_FLCHORUS_438015#639566, rg_flliseng#639123 AS RG_FLLISENG_438017#639567, rg_flpav#639117 AS RG_FLPAV_438011#639568, ... 27 more fields]

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codorg#639077)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codorg#639077)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typorg#639078)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_typorg#639078)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_nomorg#639079)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_nomorg#639079)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_1#639080)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_1#639080)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_2#639081)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_2#639081)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codpos#639082)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codpos#639082)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_ville#639083)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_ville#639083)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_telbur#639084)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_telbur#639084)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fax#639085)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fax#639085)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_e_mail#639086)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_e_mail#639086)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_prefix#639087)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_prefix#639087)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_contac#639088)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_contac#639088)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numbor#639089)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numbor#639089)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_tauxre#639090)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_tauxre#639090)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codreg#639091)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codreg#639091)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcai#639092)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcai#639092)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcen#639093)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcen#639093)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltele#639094)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltele#639094)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datmaj#639095)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datmaj#639095)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_coduti#639096)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_coduti#639096)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codccp#639097)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codccp#639097)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltp#639098)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltp#639098)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_idmut#639099)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_idmut#639099)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltopr#639100)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltopr#639100)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt#639101)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt#639101)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_f#639102)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_f#639102)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_h#639103)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_h#639103)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relctx#639104)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_relctx#639104)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relpage#639105)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_relpage#639105)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relref#639106)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_relref#639106)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datenv#639107)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datenv#639107)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datede#639108)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datede#639108)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datefi#639109)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datefi#639109)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typoc#639110)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_typoc#639110)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_orgpayeur#639111)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_orgpayeur#639111)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_3#639112)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_3#639112)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notrel#639113)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_notrel#639113)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_comment#639114)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_comment#639114)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpecdep#639115)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpecdep#639115)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_a#639116)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_a#639116)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpav#639117)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpav#639117)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_reclam#639118)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_reclam#639118)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_trirel#639119)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_trirel#639119)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notbord#639120)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_notbord#639120)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flchorus#639121)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flchorus#639121)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numsir#639122)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numsir#639122)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flliseng#639123)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flliseng#639123)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_modreg#639124)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_modreg#639124)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c#639125)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c#639125)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c_ft#639126)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c_ft#639126)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(null), MARX)) THEN false ELSE Contains(str_remove_accent(null), MARX) 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#639080,rg_adr_2#639081,rg_adr_3#639112,rg_cmpimp_f#639102,rg_cmpimp_h#639103,rg_codcai#639092,rg_codccp#639097,rg_codcen#639093,rg_codorg#639077,rg_codpos#639082,rg_codreg#639091,rg_coduti#639096,rg_comment#639114,rg_contac#639088,rg_datede#639108,rg_datefi#639109,rg_datenv#639107,rg_datmaj#639095,rg_e_mail#639086,rg_fax#639085,rg_flchorus#639121,rg_flliseng#639123,rg_flpav#639117,rg_flpecdep#639115,... 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=1216.0 B, rowCount=2)
                     +- 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#638095, rg_adr_2#638096, rg_adr_3#638127, rg_cmpimp_f#638117, rg_cmpimp_h#638118, rg_codcai#638107, rg_codccp#638112, rg_codcen#638108, rg_codorg#638092, rg_codpos#638097, rg_codreg#638106, rg_coduti#638111, rg_comment#638129, rg_contac#638103, rg_datede#638123, rg_datefi#638124, rg_datenv#638122, rg_datmaj#638110, rg_e_mail#638101, rg_fax#638100, rg_flchorus#638136, rg_flliseng#638138, rg_flpav#638132, rg_flpecdep#638130, rg_fltele#638109, rg_fltopr#638115, rg_fltp#638113, rg_idmut#638114, rg_modreg#638139, rg_nomorg#638094, rg_notbord#638135, rg_notrel#638128, rg_numbor#638104, rg_numcpt#638116, rg_numcpt_a#638131, rg_numcpt_c#638140, rg_numcpt_c_ft#638141, rg_numsir#638137, rg_orgpayeur#638126, rg_prefix#638102, rg_reclam#638133, rg_relctx#638119, rg_relpage#638120, rg_relref#638121, rg_tauxre#638105, rg_telbur#638099, rg_trirel#638134, rg_typoc#638125, rg_typorg#638093, rg_ville#638098]
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#638095, rg_adr_2#638096, rg_adr_3#638127, rg_cmpimp_f#638117, rg_cmpimp_h#638118, rg_codcai#638107, rg_codccp#638112, rg_codcen#638108, rg_codorg#638092, rg_codpos#638097, rg_codreg#638106, rg_coduti#638111, rg_comment#638129, rg_contac#638103, rg_datede#638123, rg_datefi#638124, rg_datenv#638122, rg_datmaj#638110, rg_e_mail#638101, rg_fax#638100, rg_flchorus#638136, rg_flliseng#638138, rg_flpav#638132, rg_flpecdep#638130, rg_fltele#638109, rg_fltopr#638115, rg_fltp#638113, rg_idmut#638114, rg_modreg#638139, rg_nomorg#638094, rg_notbord#638135, rg_notrel#638128, rg_numbor#638104, rg_numcpt#638116, rg_numcpt_a#638131, rg_numcpt_c#638140, rg_numcpt_c_ft#638141, rg_numsir#638137, rg_orgpayeur#638126, rg_prefix#638102, rg_reclam#638133, rg_relctx#638119, rg_relpage#638120, rg_relref#638121, rg_tauxre#638105, rg_telbur#638099, rg_trirel#638134, rg_typoc#638125, rg_typorg#638093, rg_ville#638098]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codorg#638092)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codorg#638092)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typorg#638093)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_typorg#638093)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_nomorg#638094)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_nomorg#638094)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_1#638095)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_1#638095)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_2#638096)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_2#638096)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codpos#638097)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codpos#638097)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_ville#638098)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_ville#638098)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_telbur#638099)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_telbur#638099)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fax#638100)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fax#638100)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_e_mail#638101)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_e_mail#638101)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_prefix#638102)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_prefix#638102)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_contac#638103)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_contac#638103)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numbor#638104)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numbor#638104)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_tauxre#638105)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_tauxre#638105)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codreg#638106)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codreg#638106)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcai#638107)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcai#638107)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcen#638108)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcen#638108)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltele#638109)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltele#638109)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datmaj#638110)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datmaj#638110)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_coduti#638111)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_coduti#638111)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codccp#638112)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codccp#638112)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltp#638113)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltp#638113)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_idmut#638114)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_idmut#638114)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltopr#638115)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltopr#638115)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt#638116)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt#638116)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_f#638117)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_f#638117)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_h#638118)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_h#638118)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relctx#638119)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_relctx#638119)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relpage#638120)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_relpage#638120)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relref#638121)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_relref#638121)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datenv#638122)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datenv#638122)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datede#638123)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datede#638123)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datefi#638124)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datefi#638124)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typoc#638125)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_typoc#638125)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_orgpayeur#638126)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_orgpayeur#638126)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_3#638127)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_3#638127)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notrel#638128)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_notrel#638128)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_comment#638129)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_comment#638129)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpecdep#638130)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpecdep#638130)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_a#638131)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_a#638131)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpav#638132)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpav#638132)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_reclam#638133)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_reclam#638133)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_trirel#638134)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_trirel#638134)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notbord#638135)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_notbord#638135)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flchorus#638136)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flchorus#638136)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numsir#638137)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numsir#638137)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flliseng#638138)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flliseng#638138)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_modreg#638139)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_modreg#638139)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c#638140)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c#638140)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c_ft#638141)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c_ft#638141)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(null), MARX)) THEN false ELSE Contains(str_remove_accent(null), MARX) END)

(3) Project [codegen id : 1]
Output [51]: [null AS ORIGINE_440148#638737, rg_adr_1#638095 AS RG_ADR_1_437974#638738, rg_adr_2#638096 AS RG_ADR_2_437975#638739, rg_adr_3#638127 AS RG_ADR_3_438006#638740, rg_cmpimp_f#638117 AS RG_CMPIMP_F_437996#638741, rg_cmpimp_h#638118 AS RG_CMPIMP_H_437997#638742, rg_codcai#638107 AS RG_CODCAI_437986#638743, rg_codccp#638112 AS RG_CODCCP_437991#638744, rg_codcen#638108 AS RG_CODCEN_437987#638745, rg_codorg#638092 AS RG_CODORG_437971#638746, rg_codpos#638097 AS RG_CODPOS_437976#638747, rg_codreg#638106 AS RG_CODREG_437985#638748, rg_coduti#638111 AS RG_CODUTI_437990#638749, rg_comment#638129 AS RG_COMMENT_438008#638750, rg_contac#638103 AS RG_CONTAC_437982#638751, rg_datede#638123 AS RG_DATEDE_438002#638752, rg_datefi#638124 AS RG_DATEFI_438003#638753, rg_datenv#638122 AS RG_DATENV_438001#638754, rg_datmaj#638110 AS RG_DATMAJ_437989#638755, rg_e_mail#638101 AS RG_E_MAIL_437980#638756, rg_fax#638100 AS RG_FAX_437979#638757, rg_flchorus#638136 AS RG_FLCHORUS_438015#638758, rg_flliseng#638138 AS RG_FLLISENG_438017#638759, rg_flpav#638132 AS RG_FLPAV_438011#638760, rg_flpecdep#638130 AS RG_FLPECDEP_438009#638761, rg_fltele#638109 AS RG_FLTELE_437988#638762, rg_fltopr#638115 AS RG_FLTOPR_437994#638763, rg_fltp#638113 AS RG_FLTP_437992#638764, rg_idmut#638114 AS RG_IDMUT_437993#638765, rg_modreg#638139 AS RG_MODREG_438018#638766, rg_nomorg#638094 AS RG_NOMORG_437973#638767, rg_notbord#638135 AS RG_NOTBORD_438014#638768, rg_notrel#638128 AS RG_NOTREL_438007#638769, rg_numbor#638104 AS RG_NUMBOR_437983#638770, rg_numcpt#638116 AS RG_NUMCPT_437995#638771, rg_numcpt_a#638131 AS RG_NUMCPT_A_438010#638772, rg_numcpt_c#638140 AS RG_NUMCPT_C_438019#638773, rg_numcpt_c_ft#638141 AS RG_NUMCPT_C_FT_438020#638774, rg_numsir#638137 AS RG_NUMSIR_438016#638775, rg_orgpayeur#638126 AS RG_ORGPAYEUR_438005#638776, rg_prefix#638102 AS RG_PREFIX_437981#638777, rg_reclam#638133 AS RG_RECLAM_438012#638778, rg_relctx#638119 AS RG_RELCTX_437998#638779, rg_relpage#638120 AS RG_RELPAGE_437999#638780, rg_relref#638121 AS RG_RELREF_438000#638781, rg_tauxre#638105 AS RG_TAUXRE_437984#638782, rg_telbur#638099 AS RG_TELBUR_437978#638783, rg_trirel#638134 AS RG_TRIREL_438013#638784, rg_typoc#638125 AS RG_TYPOC_438004#638785, rg_typorg#638093 AS RG_TYPORG_437972#638786, rg_ville#638098 AS RG_VILLE_437977#638787]
Input [50]: [rg_adr_1#638095, rg_adr_2#638096, rg_adr_3#638127, rg_cmpimp_f#638117, rg_cmpimp_h#638118, rg_codcai#638107, rg_codccp#638112, rg_codcen#638108, rg_codorg#638092, rg_codpos#638097, rg_codreg#638106, rg_coduti#638111, rg_comment#638129, rg_contac#638103, rg_datede#638123, rg_datefi#638124, rg_datenv#638122, rg_datmaj#638110, rg_e_mail#638101, rg_fax#638100, rg_flchorus#638136, rg_flliseng#638138, rg_flpav#638132, rg_flpecdep#638130, rg_fltele#638109, rg_fltopr#638115, rg_fltp#638113, rg_idmut#638114, rg_modreg#638139, rg_nomorg#638094, rg_notbord#638135, rg_notrel#638128, rg_numbor#638104, rg_numcpt#638116, rg_numcpt_a#638131, rg_numcpt_c#638140, rg_numcpt_c_ft#638141, rg_numsir#638137, rg_orgpayeur#638126, rg_prefix#638102, rg_reclam#638133, rg_relctx#638119, rg_relpage#638120, rg_relref#638121, rg_tauxre#638105, rg_telbur#638099, rg_trirel#638134, rg_typoc#638125, rg_typorg#638093, rg_ville#638098]

(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#639080, rg_adr_2#639081, rg_adr_3#639112, rg_cmpimp_f#639102, rg_cmpimp_h#639103, rg_codcai#639092, rg_codccp#639097, rg_codcen#639093, rg_codorg#639077, rg_codpos#639082, rg_codreg#639091, rg_coduti#639096, rg_comment#639114, rg_contac#639088, rg_datede#639108, rg_datefi#639109, rg_datenv#639107, rg_datmaj#639095, rg_e_mail#639086, rg_fax#639085, rg_flchorus#639121, rg_flliseng#639123, rg_flpav#639117, rg_flpecdep#639115, rg_fltele#639094, rg_fltopr#639100, rg_fltp#639098, rg_idmut#639099, rg_modreg#639124, rg_nomorg#639079, rg_notbord#639120, rg_notrel#639113, rg_numbor#639089, rg_numcpt#639101, rg_numcpt_a#639116, rg_numcpt_c#639125, rg_numcpt_c_ft#639126, rg_numsir#639122, rg_orgpayeur#639111, rg_prefix#639087, rg_reclam#639118, rg_relctx#639104, rg_relpage#639105, rg_relref#639106, rg_tauxre#639090, rg_telbur#639084, rg_trirel#639119, rg_typoc#639110, rg_typorg#639078, rg_ville#639083]
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#639080, rg_adr_2#639081, rg_adr_3#639112, rg_cmpimp_f#639102, rg_cmpimp_h#639103, rg_codcai#639092, rg_codccp#639097, rg_codcen#639093, rg_codorg#639077, rg_codpos#639082, rg_codreg#639091, rg_coduti#639096, rg_comment#639114, rg_contac#639088, rg_datede#639108, rg_datefi#639109, rg_datenv#639107, rg_datmaj#639095, rg_e_mail#639086, rg_fax#639085, rg_flchorus#639121, rg_flliseng#639123, rg_flpav#639117, rg_flpecdep#639115, rg_fltele#639094, rg_fltopr#639100, rg_fltp#639098, rg_idmut#639099, rg_modreg#639124, rg_nomorg#639079, rg_notbord#639120, rg_notrel#639113, rg_numbor#639089, rg_numcpt#639101, rg_numcpt_a#639116, rg_numcpt_c#639125, rg_numcpt_c_ft#639126, rg_numsir#639122, rg_orgpayeur#639111, rg_prefix#639087, rg_reclam#639118, rg_relctx#639104, rg_relpage#639105, rg_relref#639106, rg_tauxre#639090, rg_telbur#639084, rg_trirel#639119, rg_typoc#639110, rg_typorg#639078, rg_ville#639083]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codorg#639077)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codorg#639077)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typorg#639078)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_typorg#639078)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_nomorg#639079)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_nomorg#639079)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_1#639080)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_1#639080)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_2#639081)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_2#639081)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codpos#639082)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codpos#639082)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_ville#639083)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_ville#639083)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_telbur#639084)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_telbur#639084)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fax#639085)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fax#639085)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_e_mail#639086)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_e_mail#639086)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_prefix#639087)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_prefix#639087)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_contac#639088)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_contac#639088)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numbor#639089)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numbor#639089)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_tauxre#639090)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_tauxre#639090)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codreg#639091)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codreg#639091)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcai#639092)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcai#639092)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcen#639093)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcen#639093)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltele#639094)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltele#639094)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datmaj#639095)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datmaj#639095)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_coduti#639096)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_coduti#639096)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codccp#639097)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codccp#639097)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltp#639098)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltp#639098)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_idmut#639099)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_idmut#639099)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltopr#639100)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltopr#639100)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt#639101)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt#639101)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_f#639102)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_f#639102)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_h#639103)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_h#639103)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relctx#639104)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_relctx#639104)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relpage#639105)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_relpage#639105)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relref#639106)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_relref#639106)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datenv#639107)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datenv#639107)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datede#639108)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datede#639108)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datefi#639109)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datefi#639109)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typoc#639110)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_typoc#639110)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_orgpayeur#639111)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_orgpayeur#639111)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_3#639112)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_3#639112)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notrel#639113)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_notrel#639113)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_comment#639114)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_comment#639114)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpecdep#639115)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpecdep#639115)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_a#639116)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_a#639116)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpav#639117)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpav#639117)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_reclam#639118)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_reclam#639118)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_trirel#639119)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_trirel#639119)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notbord#639120)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_notbord#639120)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flchorus#639121)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flchorus#639121)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numsir#639122)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numsir#639122)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flliseng#639123)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flliseng#639123)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_modreg#639124)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_modreg#639124)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c#639125)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c#639125)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c_ft#639126)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c_ft#639126)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(null), MARX)) THEN false ELSE Contains(str_remove_accent(null), MARX) END)

(6) Project [codegen id : 2]
Output [51]: [null AS ORIGINE_440148#639545, rg_adr_1#639080 AS RG_ADR_1_437974#639546, rg_adr_2#639081 AS RG_ADR_2_437975#639547, rg_adr_3#639112 AS RG_ADR_3_438006#639548, rg_cmpimp_f#639102 AS RG_CMPIMP_F_437996#639549, rg_cmpimp_h#639103 AS RG_CMPIMP_H_437997#639550, rg_codcai#639092 AS RG_CODCAI_437986#639551, rg_codccp#639097 AS RG_CODCCP_437991#639552, rg_codcen#639093 AS RG_CODCEN_437987#639553, rg_codorg#639077 AS RG_CODORG_437971#639554, rg_codpos#639082 AS RG_CODPOS_437976#639555, rg_codreg#639091 AS RG_CODREG_437985#639556, rg_coduti#639096 AS RG_CODUTI_437990#639557, rg_comment#639114 AS RG_COMMENT_438008#639558, rg_contac#639088 AS RG_CONTAC_437982#639559, rg_datede#639108 AS RG_DATEDE_438002#639560, rg_datefi#639109 AS RG_DATEFI_438003#639561, rg_datenv#639107 AS RG_DATENV_438001#639562, rg_datmaj#639095 AS RG_DATMAJ_437989#639563, rg_e_mail#639086 AS RG_E_MAIL_437980#639564, rg_fax#639085 AS RG_FAX_437979#639565, rg_flchorus#639121 AS RG_FLCHORUS_438015#639566, rg_flliseng#639123 AS RG_FLLISENG_438017#639567, rg_flpav#639117 AS RG_FLPAV_438011#639568, rg_flpecdep#639115 AS RG_FLPECDEP_438009#639569, rg_fltele#639094 AS RG_FLTELE_437988#639570, rg_fltopr#639100 AS RG_FLTOPR_437994#639571, rg_fltp#639098 AS RG_FLTP_437992#639572, rg_idmut#639099 AS RG_IDMUT_437993#639573, rg_modreg#639124 AS RG_MODREG_438018#639574, rg_nomorg#639079 AS RG_NOMORG_437973#639575, rg_notbord#639120 AS RG_NOTBORD_438014#639576, rg_notrel#639113 AS RG_NOTREL_438007#639577, rg_numbor#639089 AS RG_NUMBOR_437983#639578, rg_numcpt#639101 AS RG_NUMCPT_437995#639579, rg_numcpt_a#639116 AS RG_NUMCPT_A_438010#639580, rg_numcpt_c#639125 AS RG_NUMCPT_C_438019#639581, rg_numcpt_c_ft#639126 AS RG_NUMCPT_C_FT_438020#639582, rg_numsir#639122 AS RG_NUMSIR_438016#639583, rg_orgpayeur#639111 AS RG_ORGPAYEUR_438005#639584, rg_prefix#639087 AS RG_PREFIX_437981#639585, rg_reclam#639118 AS RG_RECLAM_438012#639586, rg_relctx#639104 AS RG_RELCTX_437998#639587, rg_relpage#639105 AS RG_RELPAGE_437999#639588, rg_relref#639106 AS RG_RELREF_438000#639589, rg_tauxre#639090 AS RG_TAUXRE_437984#639590, rg_telbur#639084 AS RG_TELBUR_437978#639591, rg_trirel#639119 AS RG_TRIREL_438013#639592, rg_typoc#639110 AS RG_TYPOC_438004#639593, rg_typorg#639078 AS RG_TYPORG_437972#639594, rg_ville#639083 AS RG_VILLE_437977#639595]
Input [50]: [rg_adr_1#639080, rg_adr_2#639081, rg_adr_3#639112, rg_cmpimp_f#639102, rg_cmpimp_h#639103, rg_codcai#639092, rg_codccp#639097, rg_codcen#639093, rg_codorg#639077, rg_codpos#639082, rg_codreg#639091, rg_coduti#639096, rg_comment#639114, rg_contac#639088, rg_datede#639108, rg_datefi#639109, rg_datenv#639107, rg_datmaj#639095, rg_e_mail#639086, rg_fax#639085, rg_flchorus#639121, rg_flliseng#639123, rg_flpav#639117, rg_flpecdep#639115, rg_fltele#639094, rg_fltopr#639100, rg_fltp#639098, rg_idmut#639099, rg_modreg#639124, rg_nomorg#639079, rg_notbord#639120, rg_notrel#639113, rg_numbor#639089, rg_numcpt#639101, rg_numcpt_a#639116, rg_numcpt_c#639125, rg_numcpt_c_ft#639126, rg_numsir#639122, rg_orgpayeur#639111, rg_prefix#639087, rg_reclam#639118, rg_relctx#639104, rg_relpage#639105, rg_relref#639106, rg_tauxre#639090, rg_telbur#639084, rg_trirel#639119, rg_typoc#639110, rg_typorg#639078, rg_ville#639083]

(7) Union

(8) HashAggregate [codegen id : 3]
Input [51]: [ORIGINE_440148#638737, RG_ADR_1_437974#638738, RG_ADR_2_437975#638739, RG_ADR_3_438006#638740, RG_CMPIMP_F_437996#638741, RG_CMPIMP_H_437997#638742, RG_CODCAI_437986#638743, RG_CODCCP_437991#638744, RG_CODCEN_437987#638745, RG_CODORG_437971#638746, RG_CODPOS_437976#638747, RG_CODREG_437985#638748, RG_CODUTI_437990#638749, RG_COMMENT_438008#638750, RG_CONTAC_437982#638751, RG_DATEDE_438002#638752, RG_DATEFI_438003#638753, RG_DATENV_438001#638754, RG_DATMAJ_437989#638755, RG_E_MAIL_437980#638756, RG_FAX_437979#638757, RG_FLCHORUS_438015#638758, RG_FLLISENG_438017#638759, RG_FLPAV_438011#638760, RG_FLPECDEP_438009#638761, RG_FLTELE_437988#638762, RG_FLTOPR_437994#638763, RG_FLTP_437992#638764, RG_IDMUT_437993#638765, RG_MODREG_438018#638766, RG_NOMORG_437973#638767, RG_NOTBORD_438014#638768, RG_NOTREL_438007#638769, RG_NUMBOR_437983#638770, RG_NUMCPT_437995#638771, RG_NUMCPT_A_438010#638772, RG_NUMCPT_C_438019#638773, RG_NUMCPT_C_FT_438020#638774, RG_NUMSIR_438016#638775, RG_ORGPAYEUR_438005#638776, RG_PREFIX_437981#638777, RG_RECLAM_438012#638778, RG_RELCTX_437998#638779, RG_RELPAGE_437999#638780, RG_RELREF_438000#638781, RG_TAUXRE_437984#638782, RG_TELBUR_437978#638783, RG_TRIREL_438013#638784, RG_TYPOC_438004#638785, RG_TYPORG_437972#638786, RG_VILLE_437977#638787]
Keys [51]: [ORIGINE_440148#638737, RG_ADR_1_437974#638738, RG_ADR_2_437975#638739, RG_ADR_3_438006#638740, RG_CMPIMP_F_437996#638741, RG_CMPIMP_H_437997#638742, RG_CODCAI_437986#638743, RG_CODCCP_437991#638744, RG_CODCEN_437987#638745, RG_CODORG_437971#638746, RG_CODPOS_437976#638747, RG_CODREG_437985#638748, RG_CODUTI_437990#638749, RG_COMMENT_438008#638750, RG_CONTAC_437982#638751, RG_DATEDE_438002#638752, RG_DATEFI_438003#638753, RG_DATENV_438001#638754, RG_DATMAJ_437989#638755, RG_E_MAIL_437980#638756, RG_FAX_437979#638757, RG_FLCHORUS_438015#638758, RG_FLLISENG_438017#638759, RG_FLPAV_438011#638760, RG_FLPECDEP_438009#638761, RG_FLTELE_437988#638762, RG_FLTOPR_437994#638763, RG_FLTP_437992#638764, RG_IDMUT_437993#638765, RG_MODREG_438018#638766, RG_NOMORG_437973#638767, RG_NOTBORD_438014#638768, RG_NOTREL_438007#638769, RG_NUMBOR_437983#638770, RG_NUMCPT_437995#638771, RG_NUMCPT_A_438010#638772, RG_NUMCPT_C_438019#638773, RG_NUMCPT_C_FT_438020#638774, RG_NUMSIR_438016#638775, RG_ORGPAYEUR_438005#638776, RG_PREFIX_437981#638777, RG_RECLAM_438012#638778, RG_RELCTX_437998#638779, RG_RELPAGE_437999#638780, RG_RELREF_438000#638781, RG_TAUXRE_437984#638782, RG_TELBUR_437978#638783, RG_TRIREL_438013#638784, RG_TYPOC_438004#638785, RG_TYPORG_437972#638786, RG_VILLE_437977#638787]
Functions: []
Aggregate Attributes: []
Results [51]: [ORIGINE_440148#638737, RG_ADR_1_437974#638738, RG_ADR_2_437975#638739, RG_ADR_3_438006#638740, RG_CMPIMP_F_437996#638741, RG_CMPIMP_H_437997#638742, RG_CODCAI_437986#638743, RG_CODCCP_437991#638744, RG_CODCEN_437987#638745, RG_CODORG_437971#638746, RG_CODPOS_437976#638747, RG_CODREG_437985#638748, RG_CODUTI_437990#638749, RG_COMMENT_438008#638750, RG_CONTAC_437982#638751, RG_DATEDE_438002#638752, RG_DATEFI_438003#638753, RG_DATENV_438001#638754, RG_DATMAJ_437989#638755, RG_E_MAIL_437980#638756, RG_FAX_437979#638757, RG_FLCHORUS_438015#638758, RG_FLLISENG_438017#638759, RG_FLPAV_438011#638760, RG_FLPECDEP_438009#638761, RG_FLTELE_437988#638762, RG_FLTOPR_437994#638763, RG_FLTP_437992#638764, RG_IDMUT_437993#638765, RG_MODREG_438018#638766, RG_NOMORG_437973#638767, RG_NOTBORD_438014#638768, RG_NOTREL_438007#638769, RG_NUMBOR_437983#638770, RG_NUMCPT_437995#638771, RG_NUMCPT_A_438010#638772, RG_NUMCPT_C_438019#638773, RG_NUMCPT_C_FT_438020#638774, RG_NUMSIR_438016#638775, RG_ORGPAYEUR_438005#638776, RG_PREFIX_437981#638777, RG_RECLAM_438012#638778, RG_RELCTX_437998#638779, RG_RELPAGE_437999#638780, RG_RELREF_438000#638781, RG_TAUXRE_437984#638782, RG_TELBUR_437978#638783, RG_TRIREL_438013#638784, RG_TYPOC_438004#638785, RG_TYPORG_437972#638786, RG_VILLE_437977#638787]

(9) Exchange
Input [51]: [ORIGINE_440148#638737, RG_ADR_1_437974#638738, RG_ADR_2_437975#638739, RG_ADR_3_438006#638740, RG_CMPIMP_F_437996#638741, RG_CMPIMP_H_437997#638742, RG_CODCAI_437986#638743, RG_CODCCP_437991#638744, RG_CODCEN_437987#638745, RG_CODORG_437971#638746, RG_CODPOS_437976#638747, RG_CODREG_437985#638748, RG_CODUTI_437990#638749, RG_COMMENT_438008#638750, RG_CONTAC_437982#638751, RG_DATEDE_438002#638752, RG_DATEFI_438003#638753, RG_DATENV_438001#638754, RG_DATMAJ_437989#638755, RG_E_MAIL_437980#638756, RG_FAX_437979#638757, RG_FLCHORUS_438015#638758, RG_FLLISENG_438017#638759, RG_FLPAV_438011#638760, RG_FLPECDEP_438009#638761, RG_FLTELE_437988#638762, RG_FLTOPR_437994#638763, RG_FLTP_437992#638764, RG_IDMUT_437993#638765, RG_MODREG_438018#638766, RG_NOMORG_437973#638767, RG_NOTBORD_438014#638768, RG_NOTREL_438007#638769, RG_NUMBOR_437983#638770, RG_NUMCPT_437995#638771, RG_NUMCPT_A_438010#638772, RG_NUMCPT_C_438019#638773, RG_NUMCPT_C_FT_438020#638774, RG_NUMSIR_438016#638775, RG_ORGPAYEUR_438005#638776, RG_PREFIX_437981#638777, RG_RECLAM_438012#638778, RG_RELCTX_437998#638779, RG_RELPAGE_437999#638780, RG_RELREF_438000#638781, RG_TAUXRE_437984#638782, RG_TELBUR_437978#638783, RG_TRIREL_438013#638784, RG_TYPOC_438004#638785, RG_TYPORG_437972#638786, RG_VILLE_437977#638787]
Arguments: hashpartitioning(ORIGINE_440148#638737, RG_ADR_1_437974#638738, RG_ADR_2_437975#638739, RG_ADR_3_438006#638740, RG_CMPIMP_F_437996#638741, RG_CMPIMP_H_437997#638742, RG_CODCAI_437986#638743, RG_CODCCP_437991#638744, RG_CODCEN_437987#638745, RG_CODORG_437971#638746, RG_CODPOS_437976#638747, RG_CODREG_437985#638748, RG_CODUTI_437990#638749, RG_COMMENT_438008#638750, RG_CONTAC_437982#638751, RG_DATEDE_438002#638752, RG_DATEFI_438003#638753, RG_DATENV_438001#638754, RG_DATMAJ_437989#638755, RG_E_MAIL_437980#638756, RG_FAX_437979#638757, RG_FLCHORUS_438015#638758, RG_FLLISENG_438017#638759, RG_FLPAV_438011#638760, ... 28 more fields), ENSURE_REQUIREMENTS, [plan_id=34952]

(10) ShuffleQueryStage
Output [51]: [ORIGINE_440148#638737, RG_ADR_1_437974#638738, RG_ADR_2_437975#638739, RG_ADR_3_438006#638740, RG_CMPIMP_F_437996#638741, RG_CMPIMP_H_437997#638742, RG_CODCAI_437986#638743, RG_CODCCP_437991#638744, RG_CODCEN_437987#638745, RG_CODORG_437971#638746, RG_CODPOS_437976#638747, RG_CODREG_437985#638748, RG_CODUTI_437990#638749, RG_COMMENT_438008#638750, RG_CONTAC_437982#638751, RG_DATEDE_438002#638752, RG_DATEFI_438003#638753, RG_DATENV_438001#638754, RG_DATMAJ_437989#638755, RG_E_MAIL_437980#638756, RG_FAX_437979#638757, RG_FLCHORUS_438015#638758, RG_FLLISENG_438017#638759, RG_FLPAV_438011#638760, RG_FLPECDEP_438009#638761, RG_FLTELE_437988#638762, RG_FLTOPR_437994#638763, RG_FLTP_437992#638764, RG_IDMUT_437993#638765, RG_MODREG_438018#638766, RG_NOMORG_437973#638767, RG_NOTBORD_438014#638768, RG_NOTREL_438007#638769, RG_NUMBOR_437983#638770, RG_NUMCPT_437995#638771, RG_NUMCPT_A_438010#638772, RG_NUMCPT_C_438019#638773, RG_NUMCPT_C_FT_438020#638774, RG_NUMSIR_438016#638775, RG_ORGPAYEUR_438005#638776, RG_PREFIX_437981#638777, RG_RECLAM_438012#638778, RG_RELCTX_437998#638779, RG_RELPAGE_437999#638780, RG_RELREF_438000#638781, RG_TAUXRE_437984#638782, RG_TELBUR_437978#638783, RG_TRIREL_438013#638784, RG_TYPOC_438004#638785, RG_TYPORG_437972#638786, RG_VILLE_437977#638787]
Arguments: 0

(11) AQEShuffleRead
Input [51]: [ORIGINE_440148#638737, RG_ADR_1_437974#638738, RG_ADR_2_437975#638739, RG_ADR_3_438006#638740, RG_CMPIMP_F_437996#638741, RG_CMPIMP_H_437997#638742, RG_CODCAI_437986#638743, RG_CODCCP_437991#638744, RG_CODCEN_437987#638745, RG_CODORG_437971#638746, RG_CODPOS_437976#638747, RG_CODREG_437985#638748, RG_CODUTI_437990#638749, RG_COMMENT_438008#638750, RG_CONTAC_437982#638751, RG_DATEDE_438002#638752, RG_DATEFI_438003#638753, RG_DATENV_438001#638754, RG_DATMAJ_437989#638755, RG_E_MAIL_437980#638756, RG_FAX_437979#638757, RG_FLCHORUS_438015#638758, RG_FLLISENG_438017#638759, RG_FLPAV_438011#638760, RG_FLPECDEP_438009#638761, RG_FLTELE_437988#638762, RG_FLTOPR_437994#638763, RG_FLTP_437992#638764, RG_IDMUT_437993#638765, RG_MODREG_438018#638766, RG_NOMORG_437973#638767, RG_NOTBORD_438014#638768, RG_NOTREL_438007#638769, RG_NUMBOR_437983#638770, RG_NUMCPT_437995#638771, RG_NUMCPT_A_438010#638772, RG_NUMCPT_C_438019#638773, RG_NUMCPT_C_FT_438020#638774, RG_NUMSIR_438016#638775, RG_ORGPAYEUR_438005#638776, RG_PREFIX_437981#638777, RG_RECLAM_438012#638778, RG_RELCTX_437998#638779, RG_RELPAGE_437999#638780, RG_RELREF_438000#638781, RG_TAUXRE_437984#638782, RG_TELBUR_437978#638783, RG_TRIREL_438013#638784, RG_TYPOC_438004#638785, RG_TYPORG_437972#638786, RG_VILLE_437977#638787]
Arguments: coalesced

(12) HashAggregate [codegen id : 4]
Input [51]: [ORIGINE_440148#638737, RG_ADR_1_437974#638738, RG_ADR_2_437975#638739, RG_ADR_3_438006#638740, RG_CMPIMP_F_437996#638741, RG_CMPIMP_H_437997#638742, RG_CODCAI_437986#638743, RG_CODCCP_437991#638744, RG_CODCEN_437987#638745, RG_CODORG_437971#638746, RG_CODPOS_437976#638747, RG_CODREG_437985#638748, RG_CODUTI_437990#638749, RG_COMMENT_438008#638750, RG_CONTAC_437982#638751, RG_DATEDE_438002#638752, RG_DATEFI_438003#638753, RG_DATENV_438001#638754, RG_DATMAJ_437989#638755, RG_E_MAIL_437980#638756, RG_FAX_437979#638757, RG_FLCHORUS_438015#638758, RG_FLLISENG_438017#638759, RG_FLPAV_438011#638760, RG_FLPECDEP_438009#638761, RG_FLTELE_437988#638762, RG_FLTOPR_437994#638763, RG_FLTP_437992#638764, RG_IDMUT_437993#638765, RG_MODREG_438018#638766, RG_NOMORG_437973#638767, RG_NOTBORD_438014#638768, RG_NOTREL_438007#638769, RG_NUMBOR_437983#638770, RG_NUMCPT_437995#638771, RG_NUMCPT_A_438010#638772, RG_NUMCPT_C_438019#638773, RG_NUMCPT_C_FT_438020#638774, RG_NUMSIR_438016#638775, RG_ORGPAYEUR_438005#638776, RG_PREFIX_437981#638777, RG_RECLAM_438012#638778, RG_RELCTX_437998#638779, RG_RELPAGE_437999#638780, RG_RELREF_438000#638781, RG_TAUXRE_437984#638782, RG_TELBUR_437978#638783, RG_TRIREL_438013#638784, RG_TYPOC_438004#638785, RG_TYPORG_437972#638786, RG_VILLE_437977#638787]
Keys [51]: [ORIGINE_440148#638737, RG_ADR_1_437974#638738, RG_ADR_2_437975#638739, RG_ADR_3_438006#638740, RG_CMPIMP_F_437996#638741, RG_CMPIMP_H_437997#638742, RG_CODCAI_437986#638743, RG_CODCCP_437991#638744, RG_CODCEN_437987#638745, RG_CODORG_437971#638746, RG_CODPOS_437976#638747, RG_CODREG_437985#638748, RG_CODUTI_437990#638749, RG_COMMENT_438008#638750, RG_CONTAC_437982#638751, RG_DATEDE_438002#638752, RG_DATEFI_438003#638753, RG_DATENV_438001#638754, RG_DATMAJ_437989#638755, RG_E_MAIL_437980#638756, RG_FAX_437979#638757, RG_FLCHORUS_438015#638758, RG_FLLISENG_438017#638759, RG_FLPAV_438011#638760, RG_FLPECDEP_438009#638761, RG_FLTELE_437988#638762, RG_FLTOPR_437994#638763, RG_FLTP_437992#638764, RG_IDMUT_437993#638765, RG_MODREG_438018#638766, RG_NOMORG_437973#638767, RG_NOTBORD_438014#638768, RG_NOTREL_438007#638769, RG_NUMBOR_437983#638770, RG_NUMCPT_437995#638771, RG_NUMCPT_A_438010#638772, RG_NUMCPT_C_438019#638773, RG_NUMCPT_C_FT_438020#638774, RG_NUMSIR_438016#638775, RG_ORGPAYEUR_438005#638776, RG_PREFIX_437981#638777, RG_RECLAM_438012#638778, RG_RELCTX_437998#638779, RG_RELPAGE_437999#638780, RG_RELREF_438000#638781, RG_TAUXRE_437984#638782, RG_TELBUR_437978#638783, RG_TRIREL_438013#638784, RG_TYPOC_438004#638785, RG_TYPORG_437972#638786, RG_VILLE_437977#638787]
Functions: []
Aggregate Attributes: []
Results: []

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

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

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

(16) HashAggregate [codegen id : 5]
Input [1]: [count#645350L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#642430L]
Results [1]: [count(1)#642430L AS COL_9be9b666-e62e-424d-9cdf-b00a3cb5bcf8#642432L]

(17) Union

(18) HashAggregate
Input [51]: [ORIGINE_440148#638737, RG_ADR_1_437974#638738, RG_ADR_2_437975#638739, RG_ADR_3_438006#638740, RG_CMPIMP_F_437996#638741, RG_CMPIMP_H_437997#638742, RG_CODCAI_437986#638743, RG_CODCCP_437991#638744, RG_CODCEN_437987#638745, RG_CODORG_437971#638746, RG_CODPOS_437976#638747, RG_CODREG_437985#638748, RG_CODUTI_437990#638749, RG_COMMENT_438008#638750, RG_CONTAC_437982#638751, RG_DATEDE_438002#638752, RG_DATEFI_438003#638753, RG_DATENV_438001#638754, RG_DATMAJ_437989#638755, RG_E_MAIL_437980#638756, RG_FAX_437979#638757, RG_FLCHORUS_438015#638758, RG_FLLISENG_438017#638759, RG_FLPAV_438011#638760, RG_FLPECDEP_438009#638761, RG_FLTELE_437988#638762, RG_FLTOPR_437994#638763, RG_FLTP_437992#638764, RG_IDMUT_437993#638765, RG_MODREG_438018#638766, RG_NOMORG_437973#638767, RG_NOTBORD_438014#638768, RG_NOTREL_438007#638769, RG_NUMBOR_437983#638770, RG_NUMCPT_437995#638771, RG_NUMCPT_A_438010#638772, RG_NUMCPT_C_438019#638773, RG_NUMCPT_C_FT_438020#638774, RG_NUMSIR_438016#638775, RG_ORGPAYEUR_438005#638776, RG_PREFIX_437981#638777, RG_RECLAM_438012#638778, RG_RELCTX_437998#638779, RG_RELPAGE_437999#638780, RG_RELREF_438000#638781, RG_TAUXRE_437984#638782, RG_TELBUR_437978#638783, RG_TRIREL_438013#638784, RG_TYPOC_438004#638785, RG_TYPORG_437972#638786, RG_VILLE_437977#638787]
Keys [51]: [ORIGINE_440148#638737, RG_ADR_1_437974#638738, RG_ADR_2_437975#638739, RG_ADR_3_438006#638740, RG_CMPIMP_F_437996#638741, RG_CMPIMP_H_437997#638742, RG_CODCAI_437986#638743, RG_CODCCP_437991#638744, RG_CODCEN_437987#638745, RG_CODORG_437971#638746, RG_CODPOS_437976#638747, RG_CODREG_437985#638748, RG_CODUTI_437990#638749, RG_COMMENT_438008#638750, RG_CONTAC_437982#638751, RG_DATEDE_438002#638752, RG_DATEFI_438003#638753, RG_DATENV_438001#638754, RG_DATMAJ_437989#638755, RG_E_MAIL_437980#638756, RG_FAX_437979#638757, RG_FLCHORUS_438015#638758, RG_FLLISENG_438017#638759, RG_FLPAV_438011#638760, RG_FLPECDEP_438009#638761, RG_FLTELE_437988#638762, RG_FLTOPR_437994#638763, RG_FLTP_437992#638764, RG_IDMUT_437993#638765, RG_MODREG_438018#638766, RG_NOMORG_437973#638767, RG_NOTBORD_438014#638768, RG_NOTREL_438007#638769, RG_NUMBOR_437983#638770, RG_NUMCPT_437995#638771, RG_NUMCPT_A_438010#638772, RG_NUMCPT_C_438019#638773, RG_NUMCPT_C_FT_438020#638774, RG_NUMSIR_438016#638775, RG_ORGPAYEUR_438005#638776, RG_PREFIX_437981#638777, RG_RECLAM_438012#638778, RG_RELCTX_437998#638779, RG_RELPAGE_437999#638780, RG_RELREF_438000#638781, RG_TAUXRE_437984#638782, RG_TELBUR_437978#638783, RG_TRIREL_438013#638784, RG_TYPOC_438004#638785, RG_TYPORG_437972#638786, RG_VILLE_437977#638787]
Functions: []
Aggregate Attributes: []
Results [51]: [ORIGINE_440148#638737, RG_ADR_1_437974#638738, RG_ADR_2_437975#638739, RG_ADR_3_438006#638740, RG_CMPIMP_F_437996#638741, RG_CMPIMP_H_437997#638742, RG_CODCAI_437986#638743, RG_CODCCP_437991#638744, RG_CODCEN_437987#638745, RG_CODORG_437971#638746, RG_CODPOS_437976#638747, RG_CODREG_437985#638748, RG_CODUTI_437990#638749, RG_COMMENT_438008#638750, RG_CONTAC_437982#638751, RG_DATEDE_438002#638752, RG_DATEFI_438003#638753, RG_DATENV_438001#638754, RG_DATMAJ_437989#638755, RG_E_MAIL_437980#638756, RG_FAX_437979#638757, RG_FLCHORUS_438015#638758, RG_FLLISENG_438017#638759, RG_FLPAV_438011#638760, RG_FLPECDEP_438009#638761, RG_FLTELE_437988#638762, RG_FLTOPR_437994#638763, RG_FLTP_437992#638764, RG_IDMUT_437993#638765, RG_MODREG_438018#638766, RG_NOMORG_437973#638767, RG_NOTBORD_438014#638768, RG_NOTREL_438007#638769, RG_NUMBOR_437983#638770, RG_NUMCPT_437995#638771, RG_NUMCPT_A_438010#638772, RG_NUMCPT_C_438019#638773, RG_NUMCPT_C_FT_438020#638774, RG_NUMSIR_438016#638775, RG_ORGPAYEUR_438005#638776, RG_PREFIX_437981#638777, RG_RECLAM_438012#638778, RG_RELCTX_437998#638779, RG_RELPAGE_437999#638780, RG_RELREF_438000#638781, RG_TAUXRE_437984#638782, RG_TELBUR_437978#638783, RG_TRIREL_438013#638784, RG_TYPOC_438004#638785, RG_TYPORG_437972#638786, RG_VILLE_437977#638787]

(19) Exchange
Input [51]: [ORIGINE_440148#638737, RG_ADR_1_437974#638738, RG_ADR_2_437975#638739, RG_ADR_3_438006#638740, RG_CMPIMP_F_437996#638741, RG_CMPIMP_H_437997#638742, RG_CODCAI_437986#638743, RG_CODCCP_437991#638744, RG_CODCEN_437987#638745, RG_CODORG_437971#638746, RG_CODPOS_437976#638747, RG_CODREG_437985#638748, RG_CODUTI_437990#638749, RG_COMMENT_438008#638750, RG_CONTAC_437982#638751, RG_DATEDE_438002#638752, RG_DATEFI_438003#638753, RG_DATENV_438001#638754, RG_DATMAJ_437989#638755, RG_E_MAIL_437980#638756, RG_FAX_437979#638757, RG_FLCHORUS_438015#638758, RG_FLLISENG_438017#638759, RG_FLPAV_438011#638760, RG_FLPECDEP_438009#638761, RG_FLTELE_437988#638762, RG_FLTOPR_437994#638763, RG_FLTP_437992#638764, RG_IDMUT_437993#638765, RG_MODREG_438018#638766, RG_NOMORG_437973#638767, RG_NOTBORD_438014#638768, RG_NOTREL_438007#638769, RG_NUMBOR_437983#638770, RG_NUMCPT_437995#638771, RG_NUMCPT_A_438010#638772, RG_NUMCPT_C_438019#638773, RG_NUMCPT_C_FT_438020#638774, RG_NUMSIR_438016#638775, RG_ORGPAYEUR_438005#638776, RG_PREFIX_437981#638777, RG_RECLAM_438012#638778, RG_RELCTX_437998#638779, RG_RELPAGE_437999#638780, RG_RELREF_438000#638781, RG_TAUXRE_437984#638782, RG_TELBUR_437978#638783, RG_TRIREL_438013#638784, RG_TYPOC_438004#638785, RG_TYPORG_437972#638786, RG_VILLE_437977#638787]
Arguments: hashpartitioning(ORIGINE_440148#638737, RG_ADR_1_437974#638738, RG_ADR_2_437975#638739, RG_ADR_3_438006#638740, RG_CMPIMP_F_437996#638741, RG_CMPIMP_H_437997#638742, RG_CODCAI_437986#638743, RG_CODCCP_437991#638744, RG_CODCEN_437987#638745, RG_CODORG_437971#638746, RG_CODPOS_437976#638747, RG_CODREG_437985#638748, RG_CODUTI_437990#638749, RG_COMMENT_438008#638750, RG_CONTAC_437982#638751, RG_DATEDE_438002#638752, RG_DATEFI_438003#638753, RG_DATENV_438001#638754, RG_DATMAJ_437989#638755, RG_E_MAIL_437980#638756, RG_FAX_437979#638757, RG_FLCHORUS_438015#638758, RG_FLLISENG_438017#638759, RG_FLPAV_438011#638760, ... 28 more fields), ENSURE_REQUIREMENTS, [plan_id=34920]

(20) HashAggregate
Input [51]: [ORIGINE_440148#638737, RG_ADR_1_437974#638738, RG_ADR_2_437975#638739, RG_ADR_3_438006#638740, RG_CMPIMP_F_437996#638741, RG_CMPIMP_H_437997#638742, RG_CODCAI_437986#638743, RG_CODCCP_437991#638744, RG_CODCEN_437987#638745, RG_CODORG_437971#638746, RG_CODPOS_437976#638747, RG_CODREG_437985#638748, RG_CODUTI_437990#638749, RG_COMMENT_438008#638750, RG_CONTAC_437982#638751, RG_DATEDE_438002#638752, RG_DATEFI_438003#638753, RG_DATENV_438001#638754, RG_DATMAJ_437989#638755, RG_E_MAIL_437980#638756, RG_FAX_437979#638757, RG_FLCHORUS_438015#638758, RG_FLLISENG_438017#638759, RG_FLPAV_438011#638760, RG_FLPECDEP_438009#638761, RG_FLTELE_437988#638762, RG_FLTOPR_437994#638763, RG_FLTP_437992#638764, RG_IDMUT_437993#638765, RG_MODREG_438018#638766, RG_NOMORG_437973#638767, RG_NOTBORD_438014#638768, RG_NOTREL_438007#638769, RG_NUMBOR_437983#638770, RG_NUMCPT_437995#638771, RG_NUMCPT_A_438010#638772, RG_NUMCPT_C_438019#638773, RG_NUMCPT_C_FT_438020#638774, RG_NUMSIR_438016#638775, RG_ORGPAYEUR_438005#638776, RG_PREFIX_437981#638777, RG_RECLAM_438012#638778, RG_RELCTX_437998#638779, RG_RELPAGE_437999#638780, RG_RELREF_438000#638781, RG_TAUXRE_437984#638782, RG_TELBUR_437978#638783, RG_TRIREL_438013#638784, RG_TYPOC_438004#638785, RG_TYPORG_437972#638786, RG_VILLE_437977#638787]
Keys [51]: [ORIGINE_440148#638737, RG_ADR_1_437974#638738, RG_ADR_2_437975#638739, RG_ADR_3_438006#638740, RG_CMPIMP_F_437996#638741, RG_CMPIMP_H_437997#638742, RG_CODCAI_437986#638743, RG_CODCCP_437991#638744, RG_CODCEN_437987#638745, RG_CODORG_437971#638746, RG_CODPOS_437976#638747, RG_CODREG_437985#638748, RG_CODUTI_437990#638749, RG_COMMENT_438008#638750, RG_CONTAC_437982#638751, RG_DATEDE_438002#638752, RG_DATEFI_438003#638753, RG_DATENV_438001#638754, RG_DATMAJ_437989#638755, RG_E_MAIL_437980#638756, RG_FAX_437979#638757, RG_FLCHORUS_438015#638758, RG_FLLISENG_438017#638759, RG_FLPAV_438011#638760, RG_FLPECDEP_438009#638761, RG_FLTELE_437988#638762, RG_FLTOPR_437994#638763, RG_FLTP_437992#638764, RG_IDMUT_437993#638765, RG_MODREG_438018#638766, RG_NOMORG_437973#638767, RG_NOTBORD_438014#638768, RG_NOTREL_438007#638769, RG_NUMBOR_437983#638770, RG_NUMCPT_437995#638771, RG_NUMCPT_A_438010#638772, RG_NUMCPT_C_438019#638773, RG_NUMCPT_C_FT_438020#638774, RG_NUMSIR_438016#638775, RG_ORGPAYEUR_438005#638776, RG_PREFIX_437981#638777, RG_RECLAM_438012#638778, RG_RELCTX_437998#638779, RG_RELPAGE_437999#638780, RG_RELREF_438000#638781, RG_TAUXRE_437984#638782, RG_TELBUR_437978#638783, RG_TRIREL_438013#638784, RG_TYPOC_438004#638785, RG_TYPORG_437972#638786, RG_VILLE_437977#638787]
Functions: []
Aggregate Attributes: []
Results: []

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

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

(23) HashAggregate
Input [1]: [count#645350L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#642430L]
Results [1]: [count(1)#642430L AS COL_9be9b666-e62e-424d-9cdf-b00a3cb5bcf8#642432L]

(24) AdaptiveSparkPlan
Output [1]: [COL_9be9b666-e62e-424d-9cdf-b00a3cb5bcf8#642432L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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