hdh-spark-job - Details for Query 1463

Submitted Time: 2026/10/23 13:29:39
Duration: 2 s
Succeeded Jobs: 1463 1464 1466

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: 7 ms"; 5 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 7 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: 1 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 2131.0: task 1861)) 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 2131.0: task 1861)) 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 2131.0: task 1861))"]; subgraph cluster9 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n407 ms (203 ms, 204 ms, 204 ms (stage 2131.0: task 1862))"; 10 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 366 ms (182 ms, 184 ms, 184 ms (stage 2131.0: task 1862)) peak memory total (min, med, max (stageId: taskId)) 128.5 MiB (64.2 MiB, 64.2 MiB, 64.2 MiB (stage 2131.0: task 1861)) 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 2131.0: task 1861))"]; } 11 [labelType="html" label=" Union "]; subgraph cluster12 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 229 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: 239 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=40282]

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

HashAggregate(keys=[ORIGINE_440148#747974, RG_ADR_1_437974#747975, RG_ADR_2_437975#747976, RG_ADR_3_438006#747977, RG_CMPIMP_F_437996#747978, RG_CMPIMP_H_437997#747979, RG_CODCAI_437986#747980, RG_CODCCP_437991#747981, RG_CODCEN_437987#747982, RG_CODORG_437971#747983, RG_CODPOS_437976#747984, RG_CODREG_437985#747985, RG_CODUTI_437990#747986, RG_COMMENT_438008#747987, RG_CONTAC_437982#747988, RG_DATEDE_438002#747989, RG_DATEFI_438003#747990, RG_DATENV_438001#747991, RG_DATMAJ_437989#747992, RG_E_MAIL_437980#747993, RG_FAX_437979#747994, RG_FLCHORUS_438015#747995, RG_FLLISENG_438017#747996, RG_FLPAV_438011#747997, ... 27 more fields], functions=[])

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(ORIGINE_440148#747974, RG_ADR_1_437974#747975, RG_ADR_2_437975#747976, RG_ADR_3_438006#747977, RG_CMPIMP_F_437996#747978, RG_CMPIMP_H_437997#747979, RG_CODCAI_437986#747980, RG_CODCCP_437991#747981, RG_CODCEN_437987#747982, RG_CODORG_437971#747983, RG_CODPOS_437976#747984, RG_CODREG_437985#747985, RG_CODUTI_437990#747986, RG_COMMENT_438008#747987, RG_CONTAC_437982#747988, RG_DATEDE_438002#747989, RG_DATEFI_438003#747990, RG_DATENV_438001#747991, RG_DATMAJ_437989#747992, RG_E_MAIL_437980#747993, RG_FAX_437979#747994, RG_FLCHORUS_438015#747995, RG_FLLISENG_438017#747996, RG_FLPAV_438011#747997, ... 28 more fields), ENSURE_REQUIREMENTS, [plan_id=40025]

WholeStageCodegen (3)

Union

Project [null AS ORIGINE_440148#747974, rg_adr_1#747627 AS RG_ADR_1_437974#747975, rg_adr_2#747628 AS RG_ADR_2_437975#747976, rg_adr_3#747659 AS RG_ADR_3_438006#747977, rg_cmpimp_f#747649 AS RG_CMPIMP_F_437996#747978, rg_cmpimp_h#747650 AS RG_CMPIMP_H_437997#747979, rg_codcai#747639 AS RG_CODCAI_437986#747980, rg_codccp#747644 AS RG_CODCCP_437991#747981, rg_codcen#747640 AS RG_CODCEN_437987#747982, rg_codorg#747624 AS RG_CODORG_437971#747983, rg_codpos#747629 AS RG_CODPOS_437976#747984, rg_codreg#747638 AS RG_CODREG_437985#747985, rg_coduti#747643 AS RG_CODUTI_437990#747986, rg_comment#747661 AS RG_COMMENT_438008#747987, rg_contac#747635 AS RG_CONTAC_437982#747988, rg_datede#747655 AS RG_DATEDE_438002#747989, rg_datefi#747656 AS RG_DATEFI_438003#747990, rg_datenv#747654 AS RG_DATENV_438001#747991, rg_datmaj#747642 AS RG_DATMAJ_437989#747992, rg_e_mail#747633 AS RG_E_MAIL_437980#747993, rg_fax#747632 AS RG_FAX_437979#747994, rg_flchorus#747668 AS RG_FLCHORUS_438015#747995, rg_flliseng#747670 AS RG_FLLISENG_438017#747996, rg_flpav#747664 AS RG_FLPAV_438011#747997, ... 27 more fields]

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codorg#747624)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codorg#747624)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typorg#747625)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_typorg#747625)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_nomorg#747626)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_nomorg#747626)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_1#747627)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_1#747627)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_2#747628)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_2#747628)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codpos#747629)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codpos#747629)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_ville#747630)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_ville#747630)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_telbur#747631)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_telbur#747631)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fax#747632)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fax#747632)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_e_mail#747633)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_e_mail#747633)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_prefix#747634)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_prefix#747634)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_contac#747635)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_contac#747635)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numbor#747636)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numbor#747636)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_tauxre#747637)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_tauxre#747637)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codreg#747638)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codreg#747638)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcai#747639)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcai#747639)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcen#747640)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcen#747640)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltele#747641)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltele#747641)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datmaj#747642)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datmaj#747642)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_coduti#747643)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_coduti#747643)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codccp#747644)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codccp#747644)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltp#747645)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltp#747645)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_idmut#747646)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_idmut#747646)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltopr#747647)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltopr#747647)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt#747648)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt#747648)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_f#747649)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_f#747649)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_h#747650)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_h#747650)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relctx#747651)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relctx#747651)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relpage#747652)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relpage#747652)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relref#747653)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relref#747653)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datenv#747654)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datenv#747654)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datede#747655)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datede#747655)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datefi#747656)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datefi#747656)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typoc#747657)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_typoc#747657)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_orgpayeur#747658)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_orgpayeur#747658)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_3#747659)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_3#747659)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notrel#747660)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_notrel#747660)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_comment#747661)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_comment#747661)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpecdep#747662)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpecdep#747662)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_a#747663)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_a#747663)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpav#747664)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpav#747664)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_reclam#747665)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_reclam#747665)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_trirel#747666)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_trirel#747666)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notbord#747667)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_notbord#747667)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flchorus#747668)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flchorus#747668)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numsir#747669)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numsir#747669)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flliseng#747670)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flliseng#747670)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_modreg#747671)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_modreg#747671)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c#747672)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c#747672)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c_ft#747673)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c_ft#747673)), 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#747627,rg_adr_2#747628,rg_adr_3#747659,rg_cmpimp_f#747649,rg_cmpimp_h#747650,rg_codcai#747639,rg_codccp#747644,rg_codcen#747640,rg_codorg#747624,rg_codpos#747629,rg_codreg#747638,rg_coduti#747643,rg_comment#747661,rg_contac#747635,rg_datede#747655,rg_datefi#747656,rg_datenv#747654,rg_datmaj#747642,rg_e_mail#747633,rg_fax#747632,rg_flchorus#747668,rg_flliseng#747670,rg_flpav#747664,rg_flpecdep#747662,... 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#748426, rg_adr_1#748079 AS RG_ADR_1_437974#748427, rg_adr_2#748080 AS RG_ADR_2_437975#748428, rg_adr_3#748111 AS RG_ADR_3_438006#748429, rg_cmpimp_f#748101 AS RG_CMPIMP_F_437996#748430, rg_cmpimp_h#748102 AS RG_CMPIMP_H_437997#748431, rg_codcai#748091 AS RG_CODCAI_437986#748432, rg_codccp#748096 AS RG_CODCCP_437991#748433, rg_codcen#748092 AS RG_CODCEN_437987#748434, rg_codorg#748076 AS RG_CODORG_437971#748435, rg_codpos#748081 AS RG_CODPOS_437976#748436, rg_codreg#748090 AS RG_CODREG_437985#748437, rg_coduti#748095 AS RG_CODUTI_437990#748438, rg_comment#748113 AS RG_COMMENT_438008#748439, rg_contac#748087 AS RG_CONTAC_437982#748440, rg_datede#748107 AS RG_DATEDE_438002#748441, rg_datefi#748108 AS RG_DATEFI_438003#748442, rg_datenv#748106 AS RG_DATENV_438001#748443, rg_datmaj#748094 AS RG_DATMAJ_437989#748444, rg_e_mail#748085 AS RG_E_MAIL_437980#748445, rg_fax#748084 AS RG_FAX_437979#748446, rg_flchorus#748120 AS RG_FLCHORUS_438015#748447, rg_flliseng#748122 AS RG_FLLISENG_438017#748448, rg_flpav#748116 AS RG_FLPAV_438011#748449, ... 27 more fields]

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codorg#748076)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codorg#748076)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typorg#748077)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_typorg#748077)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_nomorg#748078)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_nomorg#748078)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_1#748079)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_1#748079)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_2#748080)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_2#748080)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codpos#748081)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codpos#748081)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_ville#748082)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_ville#748082)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_telbur#748083)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_telbur#748083)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fax#748084)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fax#748084)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_e_mail#748085)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_e_mail#748085)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_prefix#748086)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_prefix#748086)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_contac#748087)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_contac#748087)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numbor#748088)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numbor#748088)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_tauxre#748089)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_tauxre#748089)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codreg#748090)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codreg#748090)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcai#748091)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcai#748091)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcen#748092)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcen#748092)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltele#748093)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltele#748093)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datmaj#748094)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datmaj#748094)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_coduti#748095)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_coduti#748095)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codccp#748096)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codccp#748096)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltp#748097)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltp#748097)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_idmut#748098)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_idmut#748098)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltopr#748099)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltopr#748099)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt#748100)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt#748100)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_f#748101)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_f#748101)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_h#748102)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_h#748102)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relctx#748103)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relctx#748103)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relpage#748104)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relpage#748104)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relref#748105)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relref#748105)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datenv#748106)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datenv#748106)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datede#748107)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datede#748107)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datefi#748108)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datefi#748108)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typoc#748109)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_typoc#748109)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_orgpayeur#748110)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_orgpayeur#748110)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_3#748111)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_3#748111)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notrel#748112)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_notrel#748112)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_comment#748113)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_comment#748113)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpecdep#748114)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpecdep#748114)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_a#748115)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_a#748115)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpav#748116)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpav#748116)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_reclam#748117)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_reclam#748117)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_trirel#748118)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_trirel#748118)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notbord#748119)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_notbord#748119)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flchorus#748120)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flchorus#748120)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numsir#748121)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numsir#748121)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flliseng#748122)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flliseng#748122)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_modreg#748123)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_modreg#748123)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c#748124)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c#748124)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c_ft#748125)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c_ft#748125)), 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#748079,rg_adr_2#748080,rg_adr_3#748111,rg_cmpimp_f#748101,rg_cmpimp_h#748102,rg_codcai#748091,rg_codccp#748096,rg_codcen#748092,rg_codorg#748076,rg_codpos#748081,rg_codreg#748090,rg_coduti#748095,rg_comment#748113,rg_contac#748087,rg_datede#748107,rg_datefi#748108,rg_datenv#748106,rg_datmaj#748094,rg_e_mail#748085,rg_fax#748084,rg_flchorus#748120,rg_flliseng#748122,rg_flpav#748116,rg_flpecdep#748114,... 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#747627, rg_adr_2#747628, rg_adr_3#747659, rg_cmpimp_f#747649, rg_cmpimp_h#747650, rg_codcai#747639, rg_codccp#747644, rg_codcen#747640, rg_codorg#747624, rg_codpos#747629, rg_codreg#747638, rg_coduti#747643, rg_comment#747661, rg_contac#747635, rg_datede#747655, rg_datefi#747656, rg_datenv#747654, rg_datmaj#747642, rg_e_mail#747633, rg_fax#747632, rg_flchorus#747668, rg_flliseng#747670, rg_flpav#747664, rg_flpecdep#747662, rg_fltele#747641, rg_fltopr#747647, rg_fltp#747645, rg_idmut#747646, rg_modreg#747671, rg_nomorg#747626, rg_notbord#747667, rg_notrel#747660, rg_numbor#747636, rg_numcpt#747648, rg_numcpt_a#747663, rg_numcpt_c#747672, rg_numcpt_c_ft#747673, rg_numsir#747669, rg_orgpayeur#747658, rg_prefix#747634, rg_reclam#747665, rg_relctx#747651, rg_relpage#747652, rg_relref#747653, rg_tauxre#747637, rg_telbur#747631, rg_trirel#747666, rg_typoc#747657, rg_typorg#747625, rg_ville#747630]
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#747627, rg_adr_2#747628, rg_adr_3#747659, rg_cmpimp_f#747649, rg_cmpimp_h#747650, rg_codcai#747639, rg_codccp#747644, rg_codcen#747640, rg_codorg#747624, rg_codpos#747629, rg_codreg#747638, rg_coduti#747643, rg_comment#747661, rg_contac#747635, rg_datede#747655, rg_datefi#747656, rg_datenv#747654, rg_datmaj#747642, rg_e_mail#747633, rg_fax#747632, rg_flchorus#747668, rg_flliseng#747670, rg_flpav#747664, rg_flpecdep#747662, rg_fltele#747641, rg_fltopr#747647, rg_fltp#747645, rg_idmut#747646, rg_modreg#747671, rg_nomorg#747626, rg_notbord#747667, rg_notrel#747660, rg_numbor#747636, rg_numcpt#747648, rg_numcpt_a#747663, rg_numcpt_c#747672, rg_numcpt_c_ft#747673, rg_numsir#747669, rg_orgpayeur#747658, rg_prefix#747634, rg_reclam#747665, rg_relctx#747651, rg_relpage#747652, rg_relref#747653, rg_tauxre#747637, rg_telbur#747631, rg_trirel#747666, rg_typoc#747657, rg_typorg#747625, rg_ville#747630]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codorg#747624)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codorg#747624)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typorg#747625)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_typorg#747625)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_nomorg#747626)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_nomorg#747626)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_1#747627)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_1#747627)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_2#747628)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_2#747628)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codpos#747629)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codpos#747629)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_ville#747630)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_ville#747630)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_telbur#747631)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_telbur#747631)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fax#747632)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fax#747632)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_e_mail#747633)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_e_mail#747633)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_prefix#747634)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_prefix#747634)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_contac#747635)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_contac#747635)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numbor#747636)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numbor#747636)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_tauxre#747637)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_tauxre#747637)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codreg#747638)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codreg#747638)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcai#747639)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcai#747639)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcen#747640)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcen#747640)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltele#747641)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltele#747641)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datmaj#747642)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datmaj#747642)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_coduti#747643)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_coduti#747643)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codccp#747644)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codccp#747644)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltp#747645)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltp#747645)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_idmut#747646)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_idmut#747646)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltopr#747647)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltopr#747647)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt#747648)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt#747648)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_f#747649)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_f#747649)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_h#747650)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_h#747650)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relctx#747651)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relctx#747651)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relpage#747652)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relpage#747652)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relref#747653)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relref#747653)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datenv#747654)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datenv#747654)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datede#747655)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datede#747655)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datefi#747656)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datefi#747656)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typoc#747657)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_typoc#747657)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_orgpayeur#747658)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_orgpayeur#747658)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_3#747659)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_3#747659)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notrel#747660)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_notrel#747660)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_comment#747661)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_comment#747661)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpecdep#747662)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpecdep#747662)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_a#747663)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_a#747663)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpav#747664)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpav#747664)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_reclam#747665)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_reclam#747665)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_trirel#747666)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_trirel#747666)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notbord#747667)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_notbord#747667)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flchorus#747668)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flchorus#747668)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numsir#747669)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numsir#747669)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flliseng#747670)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flliseng#747670)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_modreg#747671)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_modreg#747671)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c#747672)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c#747672)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c_ft#747673)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c_ft#747673)), 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#747974, rg_adr_1#747627 AS RG_ADR_1_437974#747975, rg_adr_2#747628 AS RG_ADR_2_437975#747976, rg_adr_3#747659 AS RG_ADR_3_438006#747977, rg_cmpimp_f#747649 AS RG_CMPIMP_F_437996#747978, rg_cmpimp_h#747650 AS RG_CMPIMP_H_437997#747979, rg_codcai#747639 AS RG_CODCAI_437986#747980, rg_codccp#747644 AS RG_CODCCP_437991#747981, rg_codcen#747640 AS RG_CODCEN_437987#747982, rg_codorg#747624 AS RG_CODORG_437971#747983, rg_codpos#747629 AS RG_CODPOS_437976#747984, rg_codreg#747638 AS RG_CODREG_437985#747985, rg_coduti#747643 AS RG_CODUTI_437990#747986, rg_comment#747661 AS RG_COMMENT_438008#747987, rg_contac#747635 AS RG_CONTAC_437982#747988, rg_datede#747655 AS RG_DATEDE_438002#747989, rg_datefi#747656 AS RG_DATEFI_438003#747990, rg_datenv#747654 AS RG_DATENV_438001#747991, rg_datmaj#747642 AS RG_DATMAJ_437989#747992, rg_e_mail#747633 AS RG_E_MAIL_437980#747993, rg_fax#747632 AS RG_FAX_437979#747994, rg_flchorus#747668 AS RG_FLCHORUS_438015#747995, rg_flliseng#747670 AS RG_FLLISENG_438017#747996, rg_flpav#747664 AS RG_FLPAV_438011#747997, rg_flpecdep#747662 AS RG_FLPECDEP_438009#747998, rg_fltele#747641 AS RG_FLTELE_437988#747999, rg_fltopr#747647 AS RG_FLTOPR_437994#748000, rg_fltp#747645 AS RG_FLTP_437992#748001, rg_idmut#747646 AS RG_IDMUT_437993#748002, rg_modreg#747671 AS RG_MODREG_438018#748003, rg_nomorg#747626 AS RG_NOMORG_437973#748004, rg_notbord#747667 AS RG_NOTBORD_438014#748005, rg_notrel#747660 AS RG_NOTREL_438007#748006, rg_numbor#747636 AS RG_NUMBOR_437983#748007, rg_numcpt#747648 AS RG_NUMCPT_437995#748008, rg_numcpt_a#747663 AS RG_NUMCPT_A_438010#748009, rg_numcpt_c#747672 AS RG_NUMCPT_C_438019#748010, rg_numcpt_c_ft#747673 AS RG_NUMCPT_C_FT_438020#748011, rg_numsir#747669 AS RG_NUMSIR_438016#748012, rg_orgpayeur#747658 AS RG_ORGPAYEUR_438005#748013, rg_prefix#747634 AS RG_PREFIX_437981#748014, rg_reclam#747665 AS RG_RECLAM_438012#748015, rg_relctx#747651 AS RG_RELCTX_437998#748016, rg_relpage#747652 AS RG_RELPAGE_437999#748017, rg_relref#747653 AS RG_RELREF_438000#748018, rg_tauxre#747637 AS RG_TAUXRE_437984#748019, rg_telbur#747631 AS RG_TELBUR_437978#748020, rg_trirel#747666 AS RG_TRIREL_438013#748021, rg_typoc#747657 AS RG_TYPOC_438004#748022, rg_typorg#747625 AS RG_TYPORG_437972#748023, rg_ville#747630 AS RG_VILLE_437977#748024]
Input [50]: [rg_adr_1#747627, rg_adr_2#747628, rg_adr_3#747659, rg_cmpimp_f#747649, rg_cmpimp_h#747650, rg_codcai#747639, rg_codccp#747644, rg_codcen#747640, rg_codorg#747624, rg_codpos#747629, rg_codreg#747638, rg_coduti#747643, rg_comment#747661, rg_contac#747635, rg_datede#747655, rg_datefi#747656, rg_datenv#747654, rg_datmaj#747642, rg_e_mail#747633, rg_fax#747632, rg_flchorus#747668, rg_flliseng#747670, rg_flpav#747664, rg_flpecdep#747662, rg_fltele#747641, rg_fltopr#747647, rg_fltp#747645, rg_idmut#747646, rg_modreg#747671, rg_nomorg#747626, rg_notbord#747667, rg_notrel#747660, rg_numbor#747636, rg_numcpt#747648, rg_numcpt_a#747663, rg_numcpt_c#747672, rg_numcpt_c_ft#747673, rg_numsir#747669, rg_orgpayeur#747658, rg_prefix#747634, rg_reclam#747665, rg_relctx#747651, rg_relpage#747652, rg_relref#747653, rg_tauxre#747637, rg_telbur#747631, rg_trirel#747666, rg_typoc#747657, rg_typorg#747625, rg_ville#747630]

(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#748079, rg_adr_2#748080, rg_adr_3#748111, rg_cmpimp_f#748101, rg_cmpimp_h#748102, rg_codcai#748091, rg_codccp#748096, rg_codcen#748092, rg_codorg#748076, rg_codpos#748081, rg_codreg#748090, rg_coduti#748095, rg_comment#748113, rg_contac#748087, rg_datede#748107, rg_datefi#748108, rg_datenv#748106, rg_datmaj#748094, rg_e_mail#748085, rg_fax#748084, rg_flchorus#748120, rg_flliseng#748122, rg_flpav#748116, rg_flpecdep#748114, rg_fltele#748093, rg_fltopr#748099, rg_fltp#748097, rg_idmut#748098, rg_modreg#748123, rg_nomorg#748078, rg_notbord#748119, rg_notrel#748112, rg_numbor#748088, rg_numcpt#748100, rg_numcpt_a#748115, rg_numcpt_c#748124, rg_numcpt_c_ft#748125, rg_numsir#748121, rg_orgpayeur#748110, rg_prefix#748086, rg_reclam#748117, rg_relctx#748103, rg_relpage#748104, rg_relref#748105, rg_tauxre#748089, rg_telbur#748083, rg_trirel#748118, rg_typoc#748109, rg_typorg#748077, rg_ville#748082]
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#748079, rg_adr_2#748080, rg_adr_3#748111, rg_cmpimp_f#748101, rg_cmpimp_h#748102, rg_codcai#748091, rg_codccp#748096, rg_codcen#748092, rg_codorg#748076, rg_codpos#748081, rg_codreg#748090, rg_coduti#748095, rg_comment#748113, rg_contac#748087, rg_datede#748107, rg_datefi#748108, rg_datenv#748106, rg_datmaj#748094, rg_e_mail#748085, rg_fax#748084, rg_flchorus#748120, rg_flliseng#748122, rg_flpav#748116, rg_flpecdep#748114, rg_fltele#748093, rg_fltopr#748099, rg_fltp#748097, rg_idmut#748098, rg_modreg#748123, rg_nomorg#748078, rg_notbord#748119, rg_notrel#748112, rg_numbor#748088, rg_numcpt#748100, rg_numcpt_a#748115, rg_numcpt_c#748124, rg_numcpt_c_ft#748125, rg_numsir#748121, rg_orgpayeur#748110, rg_prefix#748086, rg_reclam#748117, rg_relctx#748103, rg_relpage#748104, rg_relref#748105, rg_tauxre#748089, rg_telbur#748083, rg_trirel#748118, rg_typoc#748109, rg_typorg#748077, rg_ville#748082]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codorg#748076)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codorg#748076)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typorg#748077)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_typorg#748077)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_nomorg#748078)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_nomorg#748078)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_1#748079)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_1#748079)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_2#748080)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_2#748080)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codpos#748081)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codpos#748081)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_ville#748082)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_ville#748082)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_telbur#748083)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_telbur#748083)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fax#748084)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fax#748084)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_e_mail#748085)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_e_mail#748085)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_prefix#748086)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_prefix#748086)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_contac#748087)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_contac#748087)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numbor#748088)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numbor#748088)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_tauxre#748089)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_tauxre#748089)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codreg#748090)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codreg#748090)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcai#748091)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcai#748091)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcen#748092)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcen#748092)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltele#748093)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltele#748093)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datmaj#748094)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datmaj#748094)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_coduti#748095)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_coduti#748095)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codccp#748096)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_codccp#748096)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltp#748097)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltp#748097)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_idmut#748098)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_idmut#748098)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltopr#748099)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltopr#748099)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt#748100)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt#748100)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_f#748101)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_f#748101)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_h#748102)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_h#748102)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relctx#748103)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relctx#748103)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relpage#748104)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relpage#748104)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relref#748105)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_relref#748105)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datenv#748106)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datenv#748106)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datede#748107)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datede#748107)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datefi#748108)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_datefi#748108)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typoc#748109)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_typoc#748109)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_orgpayeur#748110)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_orgpayeur#748110)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_3#748111)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_3#748111)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notrel#748112)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_notrel#748112)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_comment#748113)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_comment#748113)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpecdep#748114)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpecdep#748114)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_a#748115)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_a#748115)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpav#748116)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpav#748116)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_reclam#748117)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_reclam#748117)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_trirel#748118)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_trirel#748118)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notbord#748119)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_notbord#748119)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flchorus#748120)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flchorus#748120)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numsir#748121)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numsir#748121)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flliseng#748122)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_flliseng#748122)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_modreg#748123)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_modreg#748123)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c#748124)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c#748124)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c_ft#748125)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c_ft#748125)), 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#748426, rg_adr_1#748079 AS RG_ADR_1_437974#748427, rg_adr_2#748080 AS RG_ADR_2_437975#748428, rg_adr_3#748111 AS RG_ADR_3_438006#748429, rg_cmpimp_f#748101 AS RG_CMPIMP_F_437996#748430, rg_cmpimp_h#748102 AS RG_CMPIMP_H_437997#748431, rg_codcai#748091 AS RG_CODCAI_437986#748432, rg_codccp#748096 AS RG_CODCCP_437991#748433, rg_codcen#748092 AS RG_CODCEN_437987#748434, rg_codorg#748076 AS RG_CODORG_437971#748435, rg_codpos#748081 AS RG_CODPOS_437976#748436, rg_codreg#748090 AS RG_CODREG_437985#748437, rg_coduti#748095 AS RG_CODUTI_437990#748438, rg_comment#748113 AS RG_COMMENT_438008#748439, rg_contac#748087 AS RG_CONTAC_437982#748440, rg_datede#748107 AS RG_DATEDE_438002#748441, rg_datefi#748108 AS RG_DATEFI_438003#748442, rg_datenv#748106 AS RG_DATENV_438001#748443, rg_datmaj#748094 AS RG_DATMAJ_437989#748444, rg_e_mail#748085 AS RG_E_MAIL_437980#748445, rg_fax#748084 AS RG_FAX_437979#748446, rg_flchorus#748120 AS RG_FLCHORUS_438015#748447, rg_flliseng#748122 AS RG_FLLISENG_438017#748448, rg_flpav#748116 AS RG_FLPAV_438011#748449, rg_flpecdep#748114 AS RG_FLPECDEP_438009#748450, rg_fltele#748093 AS RG_FLTELE_437988#748451, rg_fltopr#748099 AS RG_FLTOPR_437994#748452, rg_fltp#748097 AS RG_FLTP_437992#748453, rg_idmut#748098 AS RG_IDMUT_437993#748454, rg_modreg#748123 AS RG_MODREG_438018#748455, rg_nomorg#748078 AS RG_NOMORG_437973#748456, rg_notbord#748119 AS RG_NOTBORD_438014#748457, rg_notrel#748112 AS RG_NOTREL_438007#748458, rg_numbor#748088 AS RG_NUMBOR_437983#748459, rg_numcpt#748100 AS RG_NUMCPT_437995#748460, rg_numcpt_a#748115 AS RG_NUMCPT_A_438010#748461, rg_numcpt_c#748124 AS RG_NUMCPT_C_438019#748462, rg_numcpt_c_ft#748125 AS RG_NUMCPT_C_FT_438020#748463, rg_numsir#748121 AS RG_NUMSIR_438016#748464, rg_orgpayeur#748110 AS RG_ORGPAYEUR_438005#748465, rg_prefix#748086 AS RG_PREFIX_437981#748466, rg_reclam#748117 AS RG_RECLAM_438012#748467, rg_relctx#748103 AS RG_RELCTX_437998#748468, rg_relpage#748104 AS RG_RELPAGE_437999#748469, rg_relref#748105 AS RG_RELREF_438000#748470, rg_tauxre#748089 AS RG_TAUXRE_437984#748471, rg_telbur#748083 AS RG_TELBUR_437978#748472, rg_trirel#748118 AS RG_TRIREL_438013#748473, rg_typoc#748109 AS RG_TYPOC_438004#748474, rg_typorg#748077 AS RG_TYPORG_437972#748475, rg_ville#748082 AS RG_VILLE_437977#748476]
Input [50]: [rg_adr_1#748079, rg_adr_2#748080, rg_adr_3#748111, rg_cmpimp_f#748101, rg_cmpimp_h#748102, rg_codcai#748091, rg_codccp#748096, rg_codcen#748092, rg_codorg#748076, rg_codpos#748081, rg_codreg#748090, rg_coduti#748095, rg_comment#748113, rg_contac#748087, rg_datede#748107, rg_datefi#748108, rg_datenv#748106, rg_datmaj#748094, rg_e_mail#748085, rg_fax#748084, rg_flchorus#748120, rg_flliseng#748122, rg_flpav#748116, rg_flpecdep#748114, rg_fltele#748093, rg_fltopr#748099, rg_fltp#748097, rg_idmut#748098, rg_modreg#748123, rg_nomorg#748078, rg_notbord#748119, rg_notrel#748112, rg_numbor#748088, rg_numcpt#748100, rg_numcpt_a#748115, rg_numcpt_c#748124, rg_numcpt_c_ft#748125, rg_numsir#748121, rg_orgpayeur#748110, rg_prefix#748086, rg_reclam#748117, rg_relctx#748103, rg_relpage#748104, rg_relref#748105, rg_tauxre#748089, rg_telbur#748083, rg_trirel#748118, rg_typoc#748109, rg_typorg#748077, rg_ville#748082]

(7) Union

(8) HashAggregate [codegen id : 3]
Input [51]: [ORIGINE_440148#747974, RG_ADR_1_437974#747975, RG_ADR_2_437975#747976, RG_ADR_3_438006#747977, RG_CMPIMP_F_437996#747978, RG_CMPIMP_H_437997#747979, RG_CODCAI_437986#747980, RG_CODCCP_437991#747981, RG_CODCEN_437987#747982, RG_CODORG_437971#747983, RG_CODPOS_437976#747984, RG_CODREG_437985#747985, RG_CODUTI_437990#747986, RG_COMMENT_438008#747987, RG_CONTAC_437982#747988, RG_DATEDE_438002#747989, RG_DATEFI_438003#747990, RG_DATENV_438001#747991, RG_DATMAJ_437989#747992, RG_E_MAIL_437980#747993, RG_FAX_437979#747994, RG_FLCHORUS_438015#747995, RG_FLLISENG_438017#747996, RG_FLPAV_438011#747997, RG_FLPECDEP_438009#747998, RG_FLTELE_437988#747999, RG_FLTOPR_437994#748000, RG_FLTP_437992#748001, RG_IDMUT_437993#748002, RG_MODREG_438018#748003, RG_NOMORG_437973#748004, RG_NOTBORD_438014#748005, RG_NOTREL_438007#748006, RG_NUMBOR_437983#748007, RG_NUMCPT_437995#748008, RG_NUMCPT_A_438010#748009, RG_NUMCPT_C_438019#748010, RG_NUMCPT_C_FT_438020#748011, RG_NUMSIR_438016#748012, RG_ORGPAYEUR_438005#748013, RG_PREFIX_437981#748014, RG_RECLAM_438012#748015, RG_RELCTX_437998#748016, RG_RELPAGE_437999#748017, RG_RELREF_438000#748018, RG_TAUXRE_437984#748019, RG_TELBUR_437978#748020, RG_TRIREL_438013#748021, RG_TYPOC_438004#748022, RG_TYPORG_437972#748023, RG_VILLE_437977#748024]
Keys [51]: [ORIGINE_440148#747974, RG_ADR_1_437974#747975, RG_ADR_2_437975#747976, RG_ADR_3_438006#747977, RG_CMPIMP_F_437996#747978, RG_CMPIMP_H_437997#747979, RG_CODCAI_437986#747980, RG_CODCCP_437991#747981, RG_CODCEN_437987#747982, RG_CODORG_437971#747983, RG_CODPOS_437976#747984, RG_CODREG_437985#747985, RG_CODUTI_437990#747986, RG_COMMENT_438008#747987, RG_CONTAC_437982#747988, RG_DATEDE_438002#747989, RG_DATEFI_438003#747990, RG_DATENV_438001#747991, RG_DATMAJ_437989#747992, RG_E_MAIL_437980#747993, RG_FAX_437979#747994, RG_FLCHORUS_438015#747995, RG_FLLISENG_438017#747996, RG_FLPAV_438011#747997, RG_FLPECDEP_438009#747998, RG_FLTELE_437988#747999, RG_FLTOPR_437994#748000, RG_FLTP_437992#748001, RG_IDMUT_437993#748002, RG_MODREG_438018#748003, RG_NOMORG_437973#748004, RG_NOTBORD_438014#748005, RG_NOTREL_438007#748006, RG_NUMBOR_437983#748007, RG_NUMCPT_437995#748008, RG_NUMCPT_A_438010#748009, RG_NUMCPT_C_438019#748010, RG_NUMCPT_C_FT_438020#748011, RG_NUMSIR_438016#748012, RG_ORGPAYEUR_438005#748013, RG_PREFIX_437981#748014, RG_RECLAM_438012#748015, RG_RELCTX_437998#748016, RG_RELPAGE_437999#748017, RG_RELREF_438000#748018, RG_TAUXRE_437984#748019, RG_TELBUR_437978#748020, RG_TRIREL_438013#748021, RG_TYPOC_438004#748022, RG_TYPORG_437972#748023, RG_VILLE_437977#748024]
Functions: []
Aggregate Attributes: []
Results [51]: [ORIGINE_440148#747974, RG_ADR_1_437974#747975, RG_ADR_2_437975#747976, RG_ADR_3_438006#747977, RG_CMPIMP_F_437996#747978, RG_CMPIMP_H_437997#747979, RG_CODCAI_437986#747980, RG_CODCCP_437991#747981, RG_CODCEN_437987#747982, RG_CODORG_437971#747983, RG_CODPOS_437976#747984, RG_CODREG_437985#747985, RG_CODUTI_437990#747986, RG_COMMENT_438008#747987, RG_CONTAC_437982#747988, RG_DATEDE_438002#747989, RG_DATEFI_438003#747990, RG_DATENV_438001#747991, RG_DATMAJ_437989#747992, RG_E_MAIL_437980#747993, RG_FAX_437979#747994, RG_FLCHORUS_438015#747995, RG_FLLISENG_438017#747996, RG_FLPAV_438011#747997, RG_FLPECDEP_438009#747998, RG_FLTELE_437988#747999, RG_FLTOPR_437994#748000, RG_FLTP_437992#748001, RG_IDMUT_437993#748002, RG_MODREG_438018#748003, RG_NOMORG_437973#748004, RG_NOTBORD_438014#748005, RG_NOTREL_438007#748006, RG_NUMBOR_437983#748007, RG_NUMCPT_437995#748008, RG_NUMCPT_A_438010#748009, RG_NUMCPT_C_438019#748010, RG_NUMCPT_C_FT_438020#748011, RG_NUMSIR_438016#748012, RG_ORGPAYEUR_438005#748013, RG_PREFIX_437981#748014, RG_RECLAM_438012#748015, RG_RELCTX_437998#748016, RG_RELPAGE_437999#748017, RG_RELREF_438000#748018, RG_TAUXRE_437984#748019, RG_TELBUR_437978#748020, RG_TRIREL_438013#748021, RG_TYPOC_438004#748022, RG_TYPORG_437972#748023, RG_VILLE_437977#748024]

(9) Exchange
Input [51]: [ORIGINE_440148#747974, RG_ADR_1_437974#747975, RG_ADR_2_437975#747976, RG_ADR_3_438006#747977, RG_CMPIMP_F_437996#747978, RG_CMPIMP_H_437997#747979, RG_CODCAI_437986#747980, RG_CODCCP_437991#747981, RG_CODCEN_437987#747982, RG_CODORG_437971#747983, RG_CODPOS_437976#747984, RG_CODREG_437985#747985, RG_CODUTI_437990#747986, RG_COMMENT_438008#747987, RG_CONTAC_437982#747988, RG_DATEDE_438002#747989, RG_DATEFI_438003#747990, RG_DATENV_438001#747991, RG_DATMAJ_437989#747992, RG_E_MAIL_437980#747993, RG_FAX_437979#747994, RG_FLCHORUS_438015#747995, RG_FLLISENG_438017#747996, RG_FLPAV_438011#747997, RG_FLPECDEP_438009#747998, RG_FLTELE_437988#747999, RG_FLTOPR_437994#748000, RG_FLTP_437992#748001, RG_IDMUT_437993#748002, RG_MODREG_438018#748003, RG_NOMORG_437973#748004, RG_NOTBORD_438014#748005, RG_NOTREL_438007#748006, RG_NUMBOR_437983#748007, RG_NUMCPT_437995#748008, RG_NUMCPT_A_438010#748009, RG_NUMCPT_C_438019#748010, RG_NUMCPT_C_FT_438020#748011, RG_NUMSIR_438016#748012, RG_ORGPAYEUR_438005#748013, RG_PREFIX_437981#748014, RG_RECLAM_438012#748015, RG_RELCTX_437998#748016, RG_RELPAGE_437999#748017, RG_RELREF_438000#748018, RG_TAUXRE_437984#748019, RG_TELBUR_437978#748020, RG_TRIREL_438013#748021, RG_TYPOC_438004#748022, RG_TYPORG_437972#748023, RG_VILLE_437977#748024]
Arguments: hashpartitioning(ORIGINE_440148#747974, RG_ADR_1_437974#747975, RG_ADR_2_437975#747976, RG_ADR_3_438006#747977, RG_CMPIMP_F_437996#747978, RG_CMPIMP_H_437997#747979, RG_CODCAI_437986#747980, RG_CODCCP_437991#747981, RG_CODCEN_437987#747982, RG_CODORG_437971#747983, RG_CODPOS_437976#747984, RG_CODREG_437985#747985, RG_CODUTI_437990#747986, RG_COMMENT_438008#747987, RG_CONTAC_437982#747988, RG_DATEDE_438002#747989, RG_DATEFI_438003#747990, RG_DATENV_438001#747991, RG_DATMAJ_437989#747992, RG_E_MAIL_437980#747993, RG_FAX_437979#747994, RG_FLCHORUS_438015#747995, RG_FLLISENG_438017#747996, RG_FLPAV_438011#747997, ... 28 more fields), ENSURE_REQUIREMENTS, [plan_id=40025]

(10) ShuffleQueryStage
Output [51]: [ORIGINE_440148#747974, RG_ADR_1_437974#747975, RG_ADR_2_437975#747976, RG_ADR_3_438006#747977, RG_CMPIMP_F_437996#747978, RG_CMPIMP_H_437997#747979, RG_CODCAI_437986#747980, RG_CODCCP_437991#747981, RG_CODCEN_437987#747982, RG_CODORG_437971#747983, RG_CODPOS_437976#747984, RG_CODREG_437985#747985, RG_CODUTI_437990#747986, RG_COMMENT_438008#747987, RG_CONTAC_437982#747988, RG_DATEDE_438002#747989, RG_DATEFI_438003#747990, RG_DATENV_438001#747991, RG_DATMAJ_437989#747992, RG_E_MAIL_437980#747993, RG_FAX_437979#747994, RG_FLCHORUS_438015#747995, RG_FLLISENG_438017#747996, RG_FLPAV_438011#747997, RG_FLPECDEP_438009#747998, RG_FLTELE_437988#747999, RG_FLTOPR_437994#748000, RG_FLTP_437992#748001, RG_IDMUT_437993#748002, RG_MODREG_438018#748003, RG_NOMORG_437973#748004, RG_NOTBORD_438014#748005, RG_NOTREL_438007#748006, RG_NUMBOR_437983#748007, RG_NUMCPT_437995#748008, RG_NUMCPT_A_438010#748009, RG_NUMCPT_C_438019#748010, RG_NUMCPT_C_FT_438020#748011, RG_NUMSIR_438016#748012, RG_ORGPAYEUR_438005#748013, RG_PREFIX_437981#748014, RG_RECLAM_438012#748015, RG_RELCTX_437998#748016, RG_RELPAGE_437999#748017, RG_RELREF_438000#748018, RG_TAUXRE_437984#748019, RG_TELBUR_437978#748020, RG_TRIREL_438013#748021, RG_TYPOC_438004#748022, RG_TYPORG_437972#748023, RG_VILLE_437977#748024]
Arguments: 0

(11) AQEShuffleRead
Input [51]: [ORIGINE_440148#747974, RG_ADR_1_437974#747975, RG_ADR_2_437975#747976, RG_ADR_3_438006#747977, RG_CMPIMP_F_437996#747978, RG_CMPIMP_H_437997#747979, RG_CODCAI_437986#747980, RG_CODCCP_437991#747981, RG_CODCEN_437987#747982, RG_CODORG_437971#747983, RG_CODPOS_437976#747984, RG_CODREG_437985#747985, RG_CODUTI_437990#747986, RG_COMMENT_438008#747987, RG_CONTAC_437982#747988, RG_DATEDE_438002#747989, RG_DATEFI_438003#747990, RG_DATENV_438001#747991, RG_DATMAJ_437989#747992, RG_E_MAIL_437980#747993, RG_FAX_437979#747994, RG_FLCHORUS_438015#747995, RG_FLLISENG_438017#747996, RG_FLPAV_438011#747997, RG_FLPECDEP_438009#747998, RG_FLTELE_437988#747999, RG_FLTOPR_437994#748000, RG_FLTP_437992#748001, RG_IDMUT_437993#748002, RG_MODREG_438018#748003, RG_NOMORG_437973#748004, RG_NOTBORD_438014#748005, RG_NOTREL_438007#748006, RG_NUMBOR_437983#748007, RG_NUMCPT_437995#748008, RG_NUMCPT_A_438010#748009, RG_NUMCPT_C_438019#748010, RG_NUMCPT_C_FT_438020#748011, RG_NUMSIR_438016#748012, RG_ORGPAYEUR_438005#748013, RG_PREFIX_437981#748014, RG_RECLAM_438012#748015, RG_RELCTX_437998#748016, RG_RELPAGE_437999#748017, RG_RELREF_438000#748018, RG_TAUXRE_437984#748019, RG_TELBUR_437978#748020, RG_TRIREL_438013#748021, RG_TYPOC_438004#748022, RG_TYPORG_437972#748023, RG_VILLE_437977#748024]
Arguments: coalesced

(12) HashAggregate [codegen id : 4]
Input [51]: [ORIGINE_440148#747974, RG_ADR_1_437974#747975, RG_ADR_2_437975#747976, RG_ADR_3_438006#747977, RG_CMPIMP_F_437996#747978, RG_CMPIMP_H_437997#747979, RG_CODCAI_437986#747980, RG_CODCCP_437991#747981, RG_CODCEN_437987#747982, RG_CODORG_437971#747983, RG_CODPOS_437976#747984, RG_CODREG_437985#747985, RG_CODUTI_437990#747986, RG_COMMENT_438008#747987, RG_CONTAC_437982#747988, RG_DATEDE_438002#747989, RG_DATEFI_438003#747990, RG_DATENV_438001#747991, RG_DATMAJ_437989#747992, RG_E_MAIL_437980#747993, RG_FAX_437979#747994, RG_FLCHORUS_438015#747995, RG_FLLISENG_438017#747996, RG_FLPAV_438011#747997, RG_FLPECDEP_438009#747998, RG_FLTELE_437988#747999, RG_FLTOPR_437994#748000, RG_FLTP_437992#748001, RG_IDMUT_437993#748002, RG_MODREG_438018#748003, RG_NOMORG_437973#748004, RG_NOTBORD_438014#748005, RG_NOTREL_438007#748006, RG_NUMBOR_437983#748007, RG_NUMCPT_437995#748008, RG_NUMCPT_A_438010#748009, RG_NUMCPT_C_438019#748010, RG_NUMCPT_C_FT_438020#748011, RG_NUMSIR_438016#748012, RG_ORGPAYEUR_438005#748013, RG_PREFIX_437981#748014, RG_RECLAM_438012#748015, RG_RELCTX_437998#748016, RG_RELPAGE_437999#748017, RG_RELREF_438000#748018, RG_TAUXRE_437984#748019, RG_TELBUR_437978#748020, RG_TRIREL_438013#748021, RG_TYPOC_438004#748022, RG_TYPORG_437972#748023, RG_VILLE_437977#748024]
Keys [51]: [ORIGINE_440148#747974, RG_ADR_1_437974#747975, RG_ADR_2_437975#747976, RG_ADR_3_438006#747977, RG_CMPIMP_F_437996#747978, RG_CMPIMP_H_437997#747979, RG_CODCAI_437986#747980, RG_CODCCP_437991#747981, RG_CODCEN_437987#747982, RG_CODORG_437971#747983, RG_CODPOS_437976#747984, RG_CODREG_437985#747985, RG_CODUTI_437990#747986, RG_COMMENT_438008#747987, RG_CONTAC_437982#747988, RG_DATEDE_438002#747989, RG_DATEFI_438003#747990, RG_DATENV_438001#747991, RG_DATMAJ_437989#747992, RG_E_MAIL_437980#747993, RG_FAX_437979#747994, RG_FLCHORUS_438015#747995, RG_FLLISENG_438017#747996, RG_FLPAV_438011#747997, RG_FLPECDEP_438009#747998, RG_FLTELE_437988#747999, RG_FLTOPR_437994#748000, RG_FLTP_437992#748001, RG_IDMUT_437993#748002, RG_MODREG_438018#748003, RG_NOMORG_437973#748004, RG_NOTBORD_438014#748005, RG_NOTREL_438007#748006, RG_NUMBOR_437983#748007, RG_NUMCPT_437995#748008, RG_NUMCPT_A_438010#748009, RG_NUMCPT_C_438019#748010, RG_NUMCPT_C_FT_438020#748011, RG_NUMSIR_438016#748012, RG_ORGPAYEUR_438005#748013, RG_PREFIX_437981#748014, RG_RECLAM_438012#748015, RG_RELCTX_437998#748016, RG_RELPAGE_437999#748017, RG_RELREF_438000#748018, RG_TAUXRE_437984#748019, RG_TELBUR_437978#748020, RG_TRIREL_438013#748021, RG_TYPOC_438004#748022, RG_TYPORG_437972#748023, RG_VILLE_437977#748024]
Functions: []
Aggregate Attributes: []
Results: []

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

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

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

(16) HashAggregate [codegen id : 5]
Input [1]: [count#749199L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#749140L]
Results [1]: [count(1)#749140L AS COL_fd3f9f2b-14f6-47fe-b5de-521d7523b8a4#749142L]

(17) Union

(18) HashAggregate
Input [51]: [ORIGINE_440148#747974, RG_ADR_1_437974#747975, RG_ADR_2_437975#747976, RG_ADR_3_438006#747977, RG_CMPIMP_F_437996#747978, RG_CMPIMP_H_437997#747979, RG_CODCAI_437986#747980, RG_CODCCP_437991#747981, RG_CODCEN_437987#747982, RG_CODORG_437971#747983, RG_CODPOS_437976#747984, RG_CODREG_437985#747985, RG_CODUTI_437990#747986, RG_COMMENT_438008#747987, RG_CONTAC_437982#747988, RG_DATEDE_438002#747989, RG_DATEFI_438003#747990, RG_DATENV_438001#747991, RG_DATMAJ_437989#747992, RG_E_MAIL_437980#747993, RG_FAX_437979#747994, RG_FLCHORUS_438015#747995, RG_FLLISENG_438017#747996, RG_FLPAV_438011#747997, RG_FLPECDEP_438009#747998, RG_FLTELE_437988#747999, RG_FLTOPR_437994#748000, RG_FLTP_437992#748001, RG_IDMUT_437993#748002, RG_MODREG_438018#748003, RG_NOMORG_437973#748004, RG_NOTBORD_438014#748005, RG_NOTREL_438007#748006, RG_NUMBOR_437983#748007, RG_NUMCPT_437995#748008, RG_NUMCPT_A_438010#748009, RG_NUMCPT_C_438019#748010, RG_NUMCPT_C_FT_438020#748011, RG_NUMSIR_438016#748012, RG_ORGPAYEUR_438005#748013, RG_PREFIX_437981#748014, RG_RECLAM_438012#748015, RG_RELCTX_437998#748016, RG_RELPAGE_437999#748017, RG_RELREF_438000#748018, RG_TAUXRE_437984#748019, RG_TELBUR_437978#748020, RG_TRIREL_438013#748021, RG_TYPOC_438004#748022, RG_TYPORG_437972#748023, RG_VILLE_437977#748024]
Keys [51]: [ORIGINE_440148#747974, RG_ADR_1_437974#747975, RG_ADR_2_437975#747976, RG_ADR_3_438006#747977, RG_CMPIMP_F_437996#747978, RG_CMPIMP_H_437997#747979, RG_CODCAI_437986#747980, RG_CODCCP_437991#747981, RG_CODCEN_437987#747982, RG_CODORG_437971#747983, RG_CODPOS_437976#747984, RG_CODREG_437985#747985, RG_CODUTI_437990#747986, RG_COMMENT_438008#747987, RG_CONTAC_437982#747988, RG_DATEDE_438002#747989, RG_DATEFI_438003#747990, RG_DATENV_438001#747991, RG_DATMAJ_437989#747992, RG_E_MAIL_437980#747993, RG_FAX_437979#747994, RG_FLCHORUS_438015#747995, RG_FLLISENG_438017#747996, RG_FLPAV_438011#747997, RG_FLPECDEP_438009#747998, RG_FLTELE_437988#747999, RG_FLTOPR_437994#748000, RG_FLTP_437992#748001, RG_IDMUT_437993#748002, RG_MODREG_438018#748003, RG_NOMORG_437973#748004, RG_NOTBORD_438014#748005, RG_NOTREL_438007#748006, RG_NUMBOR_437983#748007, RG_NUMCPT_437995#748008, RG_NUMCPT_A_438010#748009, RG_NUMCPT_C_438019#748010, RG_NUMCPT_C_FT_438020#748011, RG_NUMSIR_438016#748012, RG_ORGPAYEUR_438005#748013, RG_PREFIX_437981#748014, RG_RECLAM_438012#748015, RG_RELCTX_437998#748016, RG_RELPAGE_437999#748017, RG_RELREF_438000#748018, RG_TAUXRE_437984#748019, RG_TELBUR_437978#748020, RG_TRIREL_438013#748021, RG_TYPOC_438004#748022, RG_TYPORG_437972#748023, RG_VILLE_437977#748024]
Functions: []
Aggregate Attributes: []
Results [51]: [ORIGINE_440148#747974, RG_ADR_1_437974#747975, RG_ADR_2_437975#747976, RG_ADR_3_438006#747977, RG_CMPIMP_F_437996#747978, RG_CMPIMP_H_437997#747979, RG_CODCAI_437986#747980, RG_CODCCP_437991#747981, RG_CODCEN_437987#747982, RG_CODORG_437971#747983, RG_CODPOS_437976#747984, RG_CODREG_437985#747985, RG_CODUTI_437990#747986, RG_COMMENT_438008#747987, RG_CONTAC_437982#747988, RG_DATEDE_438002#747989, RG_DATEFI_438003#747990, RG_DATENV_438001#747991, RG_DATMAJ_437989#747992, RG_E_MAIL_437980#747993, RG_FAX_437979#747994, RG_FLCHORUS_438015#747995, RG_FLLISENG_438017#747996, RG_FLPAV_438011#747997, RG_FLPECDEP_438009#747998, RG_FLTELE_437988#747999, RG_FLTOPR_437994#748000, RG_FLTP_437992#748001, RG_IDMUT_437993#748002, RG_MODREG_438018#748003, RG_NOMORG_437973#748004, RG_NOTBORD_438014#748005, RG_NOTREL_438007#748006, RG_NUMBOR_437983#748007, RG_NUMCPT_437995#748008, RG_NUMCPT_A_438010#748009, RG_NUMCPT_C_438019#748010, RG_NUMCPT_C_FT_438020#748011, RG_NUMSIR_438016#748012, RG_ORGPAYEUR_438005#748013, RG_PREFIX_437981#748014, RG_RECLAM_438012#748015, RG_RELCTX_437998#748016, RG_RELPAGE_437999#748017, RG_RELREF_438000#748018, RG_TAUXRE_437984#748019, RG_TELBUR_437978#748020, RG_TRIREL_438013#748021, RG_TYPOC_438004#748022, RG_TYPORG_437972#748023, RG_VILLE_437977#748024]

(19) Exchange
Input [51]: [ORIGINE_440148#747974, RG_ADR_1_437974#747975, RG_ADR_2_437975#747976, RG_ADR_3_438006#747977, RG_CMPIMP_F_437996#747978, RG_CMPIMP_H_437997#747979, RG_CODCAI_437986#747980, RG_CODCCP_437991#747981, RG_CODCEN_437987#747982, RG_CODORG_437971#747983, RG_CODPOS_437976#747984, RG_CODREG_437985#747985, RG_CODUTI_437990#747986, RG_COMMENT_438008#747987, RG_CONTAC_437982#747988, RG_DATEDE_438002#747989, RG_DATEFI_438003#747990, RG_DATENV_438001#747991, RG_DATMAJ_437989#747992, RG_E_MAIL_437980#747993, RG_FAX_437979#747994, RG_FLCHORUS_438015#747995, RG_FLLISENG_438017#747996, RG_FLPAV_438011#747997, RG_FLPECDEP_438009#747998, RG_FLTELE_437988#747999, RG_FLTOPR_437994#748000, RG_FLTP_437992#748001, RG_IDMUT_437993#748002, RG_MODREG_438018#748003, RG_NOMORG_437973#748004, RG_NOTBORD_438014#748005, RG_NOTREL_438007#748006, RG_NUMBOR_437983#748007, RG_NUMCPT_437995#748008, RG_NUMCPT_A_438010#748009, RG_NUMCPT_C_438019#748010, RG_NUMCPT_C_FT_438020#748011, RG_NUMSIR_438016#748012, RG_ORGPAYEUR_438005#748013, RG_PREFIX_437981#748014, RG_RECLAM_438012#748015, RG_RELCTX_437998#748016, RG_RELPAGE_437999#748017, RG_RELREF_438000#748018, RG_TAUXRE_437984#748019, RG_TELBUR_437978#748020, RG_TRIREL_438013#748021, RG_TYPOC_438004#748022, RG_TYPORG_437972#748023, RG_VILLE_437977#748024]
Arguments: hashpartitioning(ORIGINE_440148#747974, RG_ADR_1_437974#747975, RG_ADR_2_437975#747976, RG_ADR_3_438006#747977, RG_CMPIMP_F_437996#747978, RG_CMPIMP_H_437997#747979, RG_CODCAI_437986#747980, RG_CODCCP_437991#747981, RG_CODCEN_437987#747982, RG_CODORG_437971#747983, RG_CODPOS_437976#747984, RG_CODREG_437985#747985, RG_CODUTI_437990#747986, RG_COMMENT_438008#747987, RG_CONTAC_437982#747988, RG_DATEDE_438002#747989, RG_DATEFI_438003#747990, RG_DATENV_438001#747991, RG_DATMAJ_437989#747992, RG_E_MAIL_437980#747993, RG_FAX_437979#747994, RG_FLCHORUS_438015#747995, RG_FLLISENG_438017#747996, RG_FLPAV_438011#747997, ... 28 more fields), ENSURE_REQUIREMENTS, [plan_id=39993]

(20) HashAggregate
Input [51]: [ORIGINE_440148#747974, RG_ADR_1_437974#747975, RG_ADR_2_437975#747976, RG_ADR_3_438006#747977, RG_CMPIMP_F_437996#747978, RG_CMPIMP_H_437997#747979, RG_CODCAI_437986#747980, RG_CODCCP_437991#747981, RG_CODCEN_437987#747982, RG_CODORG_437971#747983, RG_CODPOS_437976#747984, RG_CODREG_437985#747985, RG_CODUTI_437990#747986, RG_COMMENT_438008#747987, RG_CONTAC_437982#747988, RG_DATEDE_438002#747989, RG_DATEFI_438003#747990, RG_DATENV_438001#747991, RG_DATMAJ_437989#747992, RG_E_MAIL_437980#747993, RG_FAX_437979#747994, RG_FLCHORUS_438015#747995, RG_FLLISENG_438017#747996, RG_FLPAV_438011#747997, RG_FLPECDEP_438009#747998, RG_FLTELE_437988#747999, RG_FLTOPR_437994#748000, RG_FLTP_437992#748001, RG_IDMUT_437993#748002, RG_MODREG_438018#748003, RG_NOMORG_437973#748004, RG_NOTBORD_438014#748005, RG_NOTREL_438007#748006, RG_NUMBOR_437983#748007, RG_NUMCPT_437995#748008, RG_NUMCPT_A_438010#748009, RG_NUMCPT_C_438019#748010, RG_NUMCPT_C_FT_438020#748011, RG_NUMSIR_438016#748012, RG_ORGPAYEUR_438005#748013, RG_PREFIX_437981#748014, RG_RECLAM_438012#748015, RG_RELCTX_437998#748016, RG_RELPAGE_437999#748017, RG_RELREF_438000#748018, RG_TAUXRE_437984#748019, RG_TELBUR_437978#748020, RG_TRIREL_438013#748021, RG_TYPOC_438004#748022, RG_TYPORG_437972#748023, RG_VILLE_437977#748024]
Keys [51]: [ORIGINE_440148#747974, RG_ADR_1_437974#747975, RG_ADR_2_437975#747976, RG_ADR_3_438006#747977, RG_CMPIMP_F_437996#747978, RG_CMPIMP_H_437997#747979, RG_CODCAI_437986#747980, RG_CODCCP_437991#747981, RG_CODCEN_437987#747982, RG_CODORG_437971#747983, RG_CODPOS_437976#747984, RG_CODREG_437985#747985, RG_CODUTI_437990#747986, RG_COMMENT_438008#747987, RG_CONTAC_437982#747988, RG_DATEDE_438002#747989, RG_DATEFI_438003#747990, RG_DATENV_438001#747991, RG_DATMAJ_437989#747992, RG_E_MAIL_437980#747993, RG_FAX_437979#747994, RG_FLCHORUS_438015#747995, RG_FLLISENG_438017#747996, RG_FLPAV_438011#747997, RG_FLPECDEP_438009#747998, RG_FLTELE_437988#747999, RG_FLTOPR_437994#748000, RG_FLTP_437992#748001, RG_IDMUT_437993#748002, RG_MODREG_438018#748003, RG_NOMORG_437973#748004, RG_NOTBORD_438014#748005, RG_NOTREL_438007#748006, RG_NUMBOR_437983#748007, RG_NUMCPT_437995#748008, RG_NUMCPT_A_438010#748009, RG_NUMCPT_C_438019#748010, RG_NUMCPT_C_FT_438020#748011, RG_NUMSIR_438016#748012, RG_ORGPAYEUR_438005#748013, RG_PREFIX_437981#748014, RG_RECLAM_438012#748015, RG_RELCTX_437998#748016, RG_RELPAGE_437999#748017, RG_RELREF_438000#748018, RG_TAUXRE_437984#748019, RG_TELBUR_437978#748020, RG_TRIREL_438013#748021, RG_TYPOC_438004#748022, RG_TYPORG_437972#748023, RG_VILLE_437977#748024]
Functions: []
Aggregate Attributes: []
Results: []

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

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

(23) HashAggregate
Input [1]: [count#749199L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#749140L]
Results [1]: [count(1)#749140L AS COL_fd3f9f2b-14f6-47fe-b5de-521d7523b8a4#749142L]

(24) AdaptiveSparkPlan
Output [1]: [COL_fd3f9f2b-14f6-47fe-b5de-521d7523b8a4#749142L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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