hdh-spark-job - Details for Query 1332

Submitted Time: 2026/10/23 13:27:32
Duration: 0.8 s
Succeeded Jobs: 1332 1333 1334

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: 5 ms"; 5 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 5 ms peak memory: 0.0 B number of output rows: 1 number of sort fallback tasks: 0 avg hash probes per key: 0"]; 6 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 0 ms peak memory: 64.2 MiB number of output rows: 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 1920.0: task 1675)) 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 1920.0: task 1675)) 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 1920.0: task 1675))"]; subgraph cluster9 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n490 ms (244 ms, 246 ms, 246 ms (stage 1920.0: task 1674))"; 10 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 454 ms (226 ms, 228 ms, 228 ms (stage 1920.0: task 1674)) peak memory total (min, med, max (stageId: taskId)) 128.5 MiB (64.2 MiB, 64.2 MiB, 64.2 MiB (stage 1920.0: task 1675)) 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 1920.0: task 1675))"]; } 11 [labelType="html" label=" Union "]; subgraph cluster12 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 246 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: 244 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=35627]

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

HashAggregate(keys=[ORIGINE_440148#661847, RG_ADR_1_437974#661848, RG_ADR_2_437975#661849, RG_ADR_3_438006#661850, RG_CMPIMP_F_437996#661851, RG_CMPIMP_H_437997#661852, RG_CODCAI_437986#661853, RG_CODCCP_437991#661854, RG_CODCEN_437987#661855, RG_CODORG_437971#661856, RG_CODPOS_437976#661857, RG_CODREG_437985#661858, RG_CODUTI_437990#661859, RG_COMMENT_438008#661860, RG_CONTAC_437982#661861, RG_DATEDE_438002#661862, RG_DATEFI_438003#661863, RG_DATENV_438001#661864, RG_DATMAJ_437989#661865, RG_E_MAIL_437980#661866, RG_FAX_437979#661867, RG_FLCHORUS_438015#661868, RG_FLLISENG_438017#661869, RG_FLPAV_438011#661870, ... 27 more fields], functions=[])

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(ORIGINE_440148#661847, RG_ADR_1_437974#661848, RG_ADR_2_437975#661849, RG_ADR_3_438006#661850, RG_CMPIMP_F_437996#661851, RG_CMPIMP_H_437997#661852, RG_CODCAI_437986#661853, RG_CODCCP_437991#661854, RG_CODCEN_437987#661855, RG_CODORG_437971#661856, RG_CODPOS_437976#661857, RG_CODREG_437985#661858, RG_CODUTI_437990#661859, RG_COMMENT_438008#661860, RG_CONTAC_437982#661861, RG_DATEDE_438002#661862, RG_DATEFI_438003#661863, RG_DATENV_438001#661864, RG_DATMAJ_437989#661865, RG_E_MAIL_437980#661866, RG_FAX_437979#661867, RG_FLCHORUS_438015#661868, RG_FLLISENG_438017#661869, RG_FLPAV_438011#661870, ... 28 more fields), ENSURE_REQUIREMENTS, [plan_id=35591]

WholeStageCodegen (3)

Union

Project [null AS ORIGINE_440148#661847, rg_adr_1#661500 AS RG_ADR_1_437974#661848, rg_adr_2#661501 AS RG_ADR_2_437975#661849, rg_adr_3#661532 AS RG_ADR_3_438006#661850, rg_cmpimp_f#661522 AS RG_CMPIMP_F_437996#661851, rg_cmpimp_h#661523 AS RG_CMPIMP_H_437997#661852, rg_codcai#661512 AS RG_CODCAI_437986#661853, rg_codccp#661517 AS RG_CODCCP_437991#661854, rg_codcen#661513 AS RG_CODCEN_437987#661855, rg_codorg#661497 AS RG_CODORG_437971#661856, rg_codpos#661502 AS RG_CODPOS_437976#661857, rg_codreg#661511 AS RG_CODREG_437985#661858, rg_coduti#661516 AS RG_CODUTI_437990#661859, rg_comment#661534 AS RG_COMMENT_438008#661860, rg_contac#661508 AS RG_CONTAC_437982#661861, rg_datede#661528 AS RG_DATEDE_438002#661862, rg_datefi#661529 AS RG_DATEFI_438003#661863, rg_datenv#661527 AS RG_DATENV_438001#661864, rg_datmaj#661515 AS RG_DATMAJ_437989#661865, rg_e_mail#661506 AS RG_E_MAIL_437980#661866, rg_fax#661505 AS RG_FAX_437979#661867, rg_flchorus#661541 AS RG_FLCHORUS_438015#661868, rg_flliseng#661543 AS RG_FLLISENG_438017#661869, rg_flpav#661537 AS RG_FLPAV_438011#661870, ... 27 more fields]

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codorg#661497)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codorg#661497)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typorg#661498)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_typorg#661498)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_nomorg#661499)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_nomorg#661499)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_1#661500)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_1#661500)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_2#661501)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_2#661501)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codpos#661502)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codpos#661502)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_ville#661503)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_ville#661503)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_telbur#661504)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_telbur#661504)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fax#661505)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fax#661505)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_e_mail#661506)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_e_mail#661506)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_prefix#661507)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_prefix#661507)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_contac#661508)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_contac#661508)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numbor#661509)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numbor#661509)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_tauxre#661510)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_tauxre#661510)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codreg#661511)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codreg#661511)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcai#661512)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcai#661512)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcen#661513)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcen#661513)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltele#661514)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltele#661514)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datmaj#661515)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datmaj#661515)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_coduti#661516)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_coduti#661516)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codccp#661517)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codccp#661517)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltp#661518)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltp#661518)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_idmut#661519)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_idmut#661519)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltopr#661520)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltopr#661520)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt#661521)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt#661521)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_f#661522)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_f#661522)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_h#661523)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_h#661523)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relctx#661524)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_relctx#661524)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relpage#661525)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_relpage#661525)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relref#661526)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_relref#661526)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datenv#661527)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datenv#661527)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datede#661528)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datede#661528)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datefi#661529)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datefi#661529)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typoc#661530)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_typoc#661530)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_orgpayeur#661531)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_orgpayeur#661531)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_3#661532)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_3#661532)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notrel#661533)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_notrel#661533)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_comment#661534)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_comment#661534)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpecdep#661535)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpecdep#661535)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_a#661536)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_a#661536)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpav#661537)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpav#661537)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_reclam#661538)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_reclam#661538)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_trirel#661539)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_trirel#661539)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notbord#661540)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_notbord#661540)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flchorus#661541)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flchorus#661541)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numsir#661542)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numsir#661542)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flliseng#661543)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flliseng#661543)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_modreg#661544)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_modreg#661544)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c#661545)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c#661545)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c_ft#661546)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c_ft#661546)), 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#661500,rg_adr_2#661501,rg_adr_3#661532,rg_cmpimp_f#661522,rg_cmpimp_h#661523,rg_codcai#661512,rg_codccp#661517,rg_codcen#661513,rg_codorg#661497,rg_codpos#661502,rg_codreg#661511,rg_coduti#661516,rg_comment#661534,rg_contac#661508,rg_datede#661528,rg_datefi#661529,rg_datenv#661527,rg_datmaj#661515,rg_e_mail#661506,rg_fax#661505,rg_flchorus#661541,rg_flliseng#661543,rg_flpav#661537,rg_flpecdep#661535,... 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#662299, rg_adr_1#661952 AS RG_ADR_1_437974#662300, rg_adr_2#661953 AS RG_ADR_2_437975#662301, rg_adr_3#661984 AS RG_ADR_3_438006#662302, rg_cmpimp_f#661974 AS RG_CMPIMP_F_437996#662303, rg_cmpimp_h#661975 AS RG_CMPIMP_H_437997#662304, rg_codcai#661964 AS RG_CODCAI_437986#662305, rg_codccp#661969 AS RG_CODCCP_437991#662306, rg_codcen#661965 AS RG_CODCEN_437987#662307, rg_codorg#661949 AS RG_CODORG_437971#662308, rg_codpos#661954 AS RG_CODPOS_437976#662309, rg_codreg#661963 AS RG_CODREG_437985#662310, rg_coduti#661968 AS RG_CODUTI_437990#662311, rg_comment#661986 AS RG_COMMENT_438008#662312, rg_contac#661960 AS RG_CONTAC_437982#662313, rg_datede#661980 AS RG_DATEDE_438002#662314, rg_datefi#661981 AS RG_DATEFI_438003#662315, rg_datenv#661979 AS RG_DATENV_438001#662316, rg_datmaj#661967 AS RG_DATMAJ_437989#662317, rg_e_mail#661958 AS RG_E_MAIL_437980#662318, rg_fax#661957 AS RG_FAX_437979#662319, rg_flchorus#661993 AS RG_FLCHORUS_438015#662320, rg_flliseng#661995 AS RG_FLLISENG_438017#662321, rg_flpav#661989 AS RG_FLPAV_438011#662322, ... 27 more fields]

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codorg#661949)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codorg#661949)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typorg#661950)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_typorg#661950)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_nomorg#661951)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_nomorg#661951)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_1#661952)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_1#661952)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_2#661953)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_2#661953)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codpos#661954)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codpos#661954)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_ville#661955)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_ville#661955)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_telbur#661956)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_telbur#661956)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fax#661957)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fax#661957)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_e_mail#661958)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_e_mail#661958)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_prefix#661959)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_prefix#661959)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_contac#661960)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_contac#661960)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numbor#661961)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numbor#661961)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_tauxre#661962)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_tauxre#661962)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codreg#661963)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codreg#661963)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcai#661964)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcai#661964)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcen#661965)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcen#661965)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltele#661966)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltele#661966)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datmaj#661967)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datmaj#661967)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_coduti#661968)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_coduti#661968)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codccp#661969)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codccp#661969)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltp#661970)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltp#661970)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_idmut#661971)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_idmut#661971)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltopr#661972)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltopr#661972)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt#661973)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt#661973)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_f#661974)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_f#661974)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_h#661975)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_h#661975)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relctx#661976)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_relctx#661976)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relpage#661977)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_relpage#661977)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relref#661978)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_relref#661978)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datenv#661979)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datenv#661979)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datede#661980)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datede#661980)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datefi#661981)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datefi#661981)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typoc#661982)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_typoc#661982)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_orgpayeur#661983)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_orgpayeur#661983)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_3#661984)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_3#661984)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notrel#661985)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_notrel#661985)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_comment#661986)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_comment#661986)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpecdep#661987)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpecdep#661987)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_a#661988)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_a#661988)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpav#661989)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpav#661989)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_reclam#661990)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_reclam#661990)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_trirel#661991)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_trirel#661991)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notbord#661992)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_notbord#661992)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flchorus#661993)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flchorus#661993)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numsir#661994)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numsir#661994)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flliseng#661995)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flliseng#661995)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_modreg#661996)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_modreg#661996)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c#661997)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c#661997)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c_ft#661998)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c_ft#661998)), 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#661952,rg_adr_2#661953,rg_adr_3#661984,rg_cmpimp_f#661974,rg_cmpimp_h#661975,rg_codcai#661964,rg_codccp#661969,rg_codcen#661965,rg_codorg#661949,rg_codpos#661954,rg_codreg#661963,rg_coduti#661968,rg_comment#661986,rg_contac#661960,rg_datede#661980,rg_datefi#661981,rg_datenv#661979,rg_datmaj#661967,rg_e_mail#661958,rg_fax#661957,rg_flchorus#661993,rg_flliseng#661995,rg_flpav#661989,rg_flpecdep#661987,... 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#661500, rg_adr_2#661501, rg_adr_3#661532, rg_cmpimp_f#661522, rg_cmpimp_h#661523, rg_codcai#661512, rg_codccp#661517, rg_codcen#661513, rg_codorg#661497, rg_codpos#661502, rg_codreg#661511, rg_coduti#661516, rg_comment#661534, rg_contac#661508, rg_datede#661528, rg_datefi#661529, rg_datenv#661527, rg_datmaj#661515, rg_e_mail#661506, rg_fax#661505, rg_flchorus#661541, rg_flliseng#661543, rg_flpav#661537, rg_flpecdep#661535, rg_fltele#661514, rg_fltopr#661520, rg_fltp#661518, rg_idmut#661519, rg_modreg#661544, rg_nomorg#661499, rg_notbord#661540, rg_notrel#661533, rg_numbor#661509, rg_numcpt#661521, rg_numcpt_a#661536, rg_numcpt_c#661545, rg_numcpt_c_ft#661546, rg_numsir#661542, rg_orgpayeur#661531, rg_prefix#661507, rg_reclam#661538, rg_relctx#661524, rg_relpage#661525, rg_relref#661526, rg_tauxre#661510, rg_telbur#661504, rg_trirel#661539, rg_typoc#661530, rg_typorg#661498, rg_ville#661503]
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#661500, rg_adr_2#661501, rg_adr_3#661532, rg_cmpimp_f#661522, rg_cmpimp_h#661523, rg_codcai#661512, rg_codccp#661517, rg_codcen#661513, rg_codorg#661497, rg_codpos#661502, rg_codreg#661511, rg_coduti#661516, rg_comment#661534, rg_contac#661508, rg_datede#661528, rg_datefi#661529, rg_datenv#661527, rg_datmaj#661515, rg_e_mail#661506, rg_fax#661505, rg_flchorus#661541, rg_flliseng#661543, rg_flpav#661537, rg_flpecdep#661535, rg_fltele#661514, rg_fltopr#661520, rg_fltp#661518, rg_idmut#661519, rg_modreg#661544, rg_nomorg#661499, rg_notbord#661540, rg_notrel#661533, rg_numbor#661509, rg_numcpt#661521, rg_numcpt_a#661536, rg_numcpt_c#661545, rg_numcpt_c_ft#661546, rg_numsir#661542, rg_orgpayeur#661531, rg_prefix#661507, rg_reclam#661538, rg_relctx#661524, rg_relpage#661525, rg_relref#661526, rg_tauxre#661510, rg_telbur#661504, rg_trirel#661539, rg_typoc#661530, rg_typorg#661498, rg_ville#661503]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codorg#661497)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codorg#661497)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typorg#661498)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_typorg#661498)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_nomorg#661499)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_nomorg#661499)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_1#661500)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_1#661500)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_2#661501)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_2#661501)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codpos#661502)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codpos#661502)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_ville#661503)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_ville#661503)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_telbur#661504)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_telbur#661504)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fax#661505)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fax#661505)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_e_mail#661506)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_e_mail#661506)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_prefix#661507)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_prefix#661507)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_contac#661508)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_contac#661508)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numbor#661509)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numbor#661509)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_tauxre#661510)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_tauxre#661510)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codreg#661511)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codreg#661511)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcai#661512)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcai#661512)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcen#661513)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcen#661513)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltele#661514)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltele#661514)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datmaj#661515)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datmaj#661515)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_coduti#661516)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_coduti#661516)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codccp#661517)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codccp#661517)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltp#661518)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltp#661518)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_idmut#661519)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_idmut#661519)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltopr#661520)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltopr#661520)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt#661521)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt#661521)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_f#661522)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_f#661522)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_h#661523)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_h#661523)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relctx#661524)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_relctx#661524)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relpage#661525)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_relpage#661525)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relref#661526)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_relref#661526)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datenv#661527)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datenv#661527)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datede#661528)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datede#661528)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datefi#661529)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datefi#661529)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typoc#661530)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_typoc#661530)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_orgpayeur#661531)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_orgpayeur#661531)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_3#661532)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_3#661532)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notrel#661533)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_notrel#661533)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_comment#661534)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_comment#661534)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpecdep#661535)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpecdep#661535)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_a#661536)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_a#661536)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpav#661537)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpav#661537)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_reclam#661538)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_reclam#661538)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_trirel#661539)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_trirel#661539)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notbord#661540)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_notbord#661540)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flchorus#661541)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flchorus#661541)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numsir#661542)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numsir#661542)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flliseng#661543)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flliseng#661543)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_modreg#661544)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_modreg#661544)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c#661545)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c#661545)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c_ft#661546)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c_ft#661546)), 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#661847, rg_adr_1#661500 AS RG_ADR_1_437974#661848, rg_adr_2#661501 AS RG_ADR_2_437975#661849, rg_adr_3#661532 AS RG_ADR_3_438006#661850, rg_cmpimp_f#661522 AS RG_CMPIMP_F_437996#661851, rg_cmpimp_h#661523 AS RG_CMPIMP_H_437997#661852, rg_codcai#661512 AS RG_CODCAI_437986#661853, rg_codccp#661517 AS RG_CODCCP_437991#661854, rg_codcen#661513 AS RG_CODCEN_437987#661855, rg_codorg#661497 AS RG_CODORG_437971#661856, rg_codpos#661502 AS RG_CODPOS_437976#661857, rg_codreg#661511 AS RG_CODREG_437985#661858, rg_coduti#661516 AS RG_CODUTI_437990#661859, rg_comment#661534 AS RG_COMMENT_438008#661860, rg_contac#661508 AS RG_CONTAC_437982#661861, rg_datede#661528 AS RG_DATEDE_438002#661862, rg_datefi#661529 AS RG_DATEFI_438003#661863, rg_datenv#661527 AS RG_DATENV_438001#661864, rg_datmaj#661515 AS RG_DATMAJ_437989#661865, rg_e_mail#661506 AS RG_E_MAIL_437980#661866, rg_fax#661505 AS RG_FAX_437979#661867, rg_flchorus#661541 AS RG_FLCHORUS_438015#661868, rg_flliseng#661543 AS RG_FLLISENG_438017#661869, rg_flpav#661537 AS RG_FLPAV_438011#661870, rg_flpecdep#661535 AS RG_FLPECDEP_438009#661871, rg_fltele#661514 AS RG_FLTELE_437988#661872, rg_fltopr#661520 AS RG_FLTOPR_437994#661873, rg_fltp#661518 AS RG_FLTP_437992#661874, rg_idmut#661519 AS RG_IDMUT_437993#661875, rg_modreg#661544 AS RG_MODREG_438018#661876, rg_nomorg#661499 AS RG_NOMORG_437973#661877, rg_notbord#661540 AS RG_NOTBORD_438014#661878, rg_notrel#661533 AS RG_NOTREL_438007#661879, rg_numbor#661509 AS RG_NUMBOR_437983#661880, rg_numcpt#661521 AS RG_NUMCPT_437995#661881, rg_numcpt_a#661536 AS RG_NUMCPT_A_438010#661882, rg_numcpt_c#661545 AS RG_NUMCPT_C_438019#661883, rg_numcpt_c_ft#661546 AS RG_NUMCPT_C_FT_438020#661884, rg_numsir#661542 AS RG_NUMSIR_438016#661885, rg_orgpayeur#661531 AS RG_ORGPAYEUR_438005#661886, rg_prefix#661507 AS RG_PREFIX_437981#661887, rg_reclam#661538 AS RG_RECLAM_438012#661888, rg_relctx#661524 AS RG_RELCTX_437998#661889, rg_relpage#661525 AS RG_RELPAGE_437999#661890, rg_relref#661526 AS RG_RELREF_438000#661891, rg_tauxre#661510 AS RG_TAUXRE_437984#661892, rg_telbur#661504 AS RG_TELBUR_437978#661893, rg_trirel#661539 AS RG_TRIREL_438013#661894, rg_typoc#661530 AS RG_TYPOC_438004#661895, rg_typorg#661498 AS RG_TYPORG_437972#661896, rg_ville#661503 AS RG_VILLE_437977#661897]
Input [50]: [rg_adr_1#661500, rg_adr_2#661501, rg_adr_3#661532, rg_cmpimp_f#661522, rg_cmpimp_h#661523, rg_codcai#661512, rg_codccp#661517, rg_codcen#661513, rg_codorg#661497, rg_codpos#661502, rg_codreg#661511, rg_coduti#661516, rg_comment#661534, rg_contac#661508, rg_datede#661528, rg_datefi#661529, rg_datenv#661527, rg_datmaj#661515, rg_e_mail#661506, rg_fax#661505, rg_flchorus#661541, rg_flliseng#661543, rg_flpav#661537, rg_flpecdep#661535, rg_fltele#661514, rg_fltopr#661520, rg_fltp#661518, rg_idmut#661519, rg_modreg#661544, rg_nomorg#661499, rg_notbord#661540, rg_notrel#661533, rg_numbor#661509, rg_numcpt#661521, rg_numcpt_a#661536, rg_numcpt_c#661545, rg_numcpt_c_ft#661546, rg_numsir#661542, rg_orgpayeur#661531, rg_prefix#661507, rg_reclam#661538, rg_relctx#661524, rg_relpage#661525, rg_relref#661526, rg_tauxre#661510, rg_telbur#661504, rg_trirel#661539, rg_typoc#661530, rg_typorg#661498, rg_ville#661503]

(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#661952, rg_adr_2#661953, rg_adr_3#661984, rg_cmpimp_f#661974, rg_cmpimp_h#661975, rg_codcai#661964, rg_codccp#661969, rg_codcen#661965, rg_codorg#661949, rg_codpos#661954, rg_codreg#661963, rg_coduti#661968, rg_comment#661986, rg_contac#661960, rg_datede#661980, rg_datefi#661981, rg_datenv#661979, rg_datmaj#661967, rg_e_mail#661958, rg_fax#661957, rg_flchorus#661993, rg_flliseng#661995, rg_flpav#661989, rg_flpecdep#661987, rg_fltele#661966, rg_fltopr#661972, rg_fltp#661970, rg_idmut#661971, rg_modreg#661996, rg_nomorg#661951, rg_notbord#661992, rg_notrel#661985, rg_numbor#661961, rg_numcpt#661973, rg_numcpt_a#661988, rg_numcpt_c#661997, rg_numcpt_c_ft#661998, rg_numsir#661994, rg_orgpayeur#661983, rg_prefix#661959, rg_reclam#661990, rg_relctx#661976, rg_relpage#661977, rg_relref#661978, rg_tauxre#661962, rg_telbur#661956, rg_trirel#661991, rg_typoc#661982, rg_typorg#661950, rg_ville#661955]
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#661952, rg_adr_2#661953, rg_adr_3#661984, rg_cmpimp_f#661974, rg_cmpimp_h#661975, rg_codcai#661964, rg_codccp#661969, rg_codcen#661965, rg_codorg#661949, rg_codpos#661954, rg_codreg#661963, rg_coduti#661968, rg_comment#661986, rg_contac#661960, rg_datede#661980, rg_datefi#661981, rg_datenv#661979, rg_datmaj#661967, rg_e_mail#661958, rg_fax#661957, rg_flchorus#661993, rg_flliseng#661995, rg_flpav#661989, rg_flpecdep#661987, rg_fltele#661966, rg_fltopr#661972, rg_fltp#661970, rg_idmut#661971, rg_modreg#661996, rg_nomorg#661951, rg_notbord#661992, rg_notrel#661985, rg_numbor#661961, rg_numcpt#661973, rg_numcpt_a#661988, rg_numcpt_c#661997, rg_numcpt_c_ft#661998, rg_numsir#661994, rg_orgpayeur#661983, rg_prefix#661959, rg_reclam#661990, rg_relctx#661976, rg_relpage#661977, rg_relref#661978, rg_tauxre#661962, rg_telbur#661956, rg_trirel#661991, rg_typoc#661982, rg_typorg#661950, rg_ville#661955]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codorg#661949)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codorg#661949)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typorg#661950)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_typorg#661950)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_nomorg#661951)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_nomorg#661951)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_1#661952)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_1#661952)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_2#661953)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_2#661953)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codpos#661954)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codpos#661954)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_ville#661955)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_ville#661955)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_telbur#661956)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_telbur#661956)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fax#661957)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fax#661957)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_e_mail#661958)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_e_mail#661958)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_prefix#661959)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_prefix#661959)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_contac#661960)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_contac#661960)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numbor#661961)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numbor#661961)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_tauxre#661962)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_tauxre#661962)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codreg#661963)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codreg#661963)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcai#661964)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcai#661964)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcen#661965)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcen#661965)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltele#661966)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltele#661966)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datmaj#661967)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datmaj#661967)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_coduti#661968)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_coduti#661968)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codccp#661969)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codccp#661969)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltp#661970)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltp#661970)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_idmut#661971)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_idmut#661971)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltopr#661972)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltopr#661972)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt#661973)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt#661973)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_f#661974)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_f#661974)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_h#661975)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_h#661975)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relctx#661976)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_relctx#661976)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relpage#661977)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_relpage#661977)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relref#661978)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_relref#661978)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datenv#661979)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datenv#661979)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datede#661980)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datede#661980)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datefi#661981)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datefi#661981)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typoc#661982)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_typoc#661982)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_orgpayeur#661983)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_orgpayeur#661983)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_3#661984)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_3#661984)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notrel#661985)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_notrel#661985)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_comment#661986)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_comment#661986)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpecdep#661987)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpecdep#661987)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_a#661988)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_a#661988)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpav#661989)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpav#661989)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_reclam#661990)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_reclam#661990)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_trirel#661991)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_trirel#661991)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notbord#661992)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_notbord#661992)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flchorus#661993)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flchorus#661993)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numsir#661994)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numsir#661994)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flliseng#661995)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flliseng#661995)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_modreg#661996)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_modreg#661996)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c#661997)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c#661997)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c_ft#661998)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c_ft#661998)), 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#662299, rg_adr_1#661952 AS RG_ADR_1_437974#662300, rg_adr_2#661953 AS RG_ADR_2_437975#662301, rg_adr_3#661984 AS RG_ADR_3_438006#662302, rg_cmpimp_f#661974 AS RG_CMPIMP_F_437996#662303, rg_cmpimp_h#661975 AS RG_CMPIMP_H_437997#662304, rg_codcai#661964 AS RG_CODCAI_437986#662305, rg_codccp#661969 AS RG_CODCCP_437991#662306, rg_codcen#661965 AS RG_CODCEN_437987#662307, rg_codorg#661949 AS RG_CODORG_437971#662308, rg_codpos#661954 AS RG_CODPOS_437976#662309, rg_codreg#661963 AS RG_CODREG_437985#662310, rg_coduti#661968 AS RG_CODUTI_437990#662311, rg_comment#661986 AS RG_COMMENT_438008#662312, rg_contac#661960 AS RG_CONTAC_437982#662313, rg_datede#661980 AS RG_DATEDE_438002#662314, rg_datefi#661981 AS RG_DATEFI_438003#662315, rg_datenv#661979 AS RG_DATENV_438001#662316, rg_datmaj#661967 AS RG_DATMAJ_437989#662317, rg_e_mail#661958 AS RG_E_MAIL_437980#662318, rg_fax#661957 AS RG_FAX_437979#662319, rg_flchorus#661993 AS RG_FLCHORUS_438015#662320, rg_flliseng#661995 AS RG_FLLISENG_438017#662321, rg_flpav#661989 AS RG_FLPAV_438011#662322, rg_flpecdep#661987 AS RG_FLPECDEP_438009#662323, rg_fltele#661966 AS RG_FLTELE_437988#662324, rg_fltopr#661972 AS RG_FLTOPR_437994#662325, rg_fltp#661970 AS RG_FLTP_437992#662326, rg_idmut#661971 AS RG_IDMUT_437993#662327, rg_modreg#661996 AS RG_MODREG_438018#662328, rg_nomorg#661951 AS RG_NOMORG_437973#662329, rg_notbord#661992 AS RG_NOTBORD_438014#662330, rg_notrel#661985 AS RG_NOTREL_438007#662331, rg_numbor#661961 AS RG_NUMBOR_437983#662332, rg_numcpt#661973 AS RG_NUMCPT_437995#662333, rg_numcpt_a#661988 AS RG_NUMCPT_A_438010#662334, rg_numcpt_c#661997 AS RG_NUMCPT_C_438019#662335, rg_numcpt_c_ft#661998 AS RG_NUMCPT_C_FT_438020#662336, rg_numsir#661994 AS RG_NUMSIR_438016#662337, rg_orgpayeur#661983 AS RG_ORGPAYEUR_438005#662338, rg_prefix#661959 AS RG_PREFIX_437981#662339, rg_reclam#661990 AS RG_RECLAM_438012#662340, rg_relctx#661976 AS RG_RELCTX_437998#662341, rg_relpage#661977 AS RG_RELPAGE_437999#662342, rg_relref#661978 AS RG_RELREF_438000#662343, rg_tauxre#661962 AS RG_TAUXRE_437984#662344, rg_telbur#661956 AS RG_TELBUR_437978#662345, rg_trirel#661991 AS RG_TRIREL_438013#662346, rg_typoc#661982 AS RG_TYPOC_438004#662347, rg_typorg#661950 AS RG_TYPORG_437972#662348, rg_ville#661955 AS RG_VILLE_437977#662349]
Input [50]: [rg_adr_1#661952, rg_adr_2#661953, rg_adr_3#661984, rg_cmpimp_f#661974, rg_cmpimp_h#661975, rg_codcai#661964, rg_codccp#661969, rg_codcen#661965, rg_codorg#661949, rg_codpos#661954, rg_codreg#661963, rg_coduti#661968, rg_comment#661986, rg_contac#661960, rg_datede#661980, rg_datefi#661981, rg_datenv#661979, rg_datmaj#661967, rg_e_mail#661958, rg_fax#661957, rg_flchorus#661993, rg_flliseng#661995, rg_flpav#661989, rg_flpecdep#661987, rg_fltele#661966, rg_fltopr#661972, rg_fltp#661970, rg_idmut#661971, rg_modreg#661996, rg_nomorg#661951, rg_notbord#661992, rg_notrel#661985, rg_numbor#661961, rg_numcpt#661973, rg_numcpt_a#661988, rg_numcpt_c#661997, rg_numcpt_c_ft#661998, rg_numsir#661994, rg_orgpayeur#661983, rg_prefix#661959, rg_reclam#661990, rg_relctx#661976, rg_relpage#661977, rg_relref#661978, rg_tauxre#661962, rg_telbur#661956, rg_trirel#661991, rg_typoc#661982, rg_typorg#661950, rg_ville#661955]

(7) Union

(8) HashAggregate [codegen id : 3]
Input [51]: [ORIGINE_440148#661847, RG_ADR_1_437974#661848, RG_ADR_2_437975#661849, RG_ADR_3_438006#661850, RG_CMPIMP_F_437996#661851, RG_CMPIMP_H_437997#661852, RG_CODCAI_437986#661853, RG_CODCCP_437991#661854, RG_CODCEN_437987#661855, RG_CODORG_437971#661856, RG_CODPOS_437976#661857, RG_CODREG_437985#661858, RG_CODUTI_437990#661859, RG_COMMENT_438008#661860, RG_CONTAC_437982#661861, RG_DATEDE_438002#661862, RG_DATEFI_438003#661863, RG_DATENV_438001#661864, RG_DATMAJ_437989#661865, RG_E_MAIL_437980#661866, RG_FAX_437979#661867, RG_FLCHORUS_438015#661868, RG_FLLISENG_438017#661869, RG_FLPAV_438011#661870, RG_FLPECDEP_438009#661871, RG_FLTELE_437988#661872, RG_FLTOPR_437994#661873, RG_FLTP_437992#661874, RG_IDMUT_437993#661875, RG_MODREG_438018#661876, RG_NOMORG_437973#661877, RG_NOTBORD_438014#661878, RG_NOTREL_438007#661879, RG_NUMBOR_437983#661880, RG_NUMCPT_437995#661881, RG_NUMCPT_A_438010#661882, RG_NUMCPT_C_438019#661883, RG_NUMCPT_C_FT_438020#661884, RG_NUMSIR_438016#661885, RG_ORGPAYEUR_438005#661886, RG_PREFIX_437981#661887, RG_RECLAM_438012#661888, RG_RELCTX_437998#661889, RG_RELPAGE_437999#661890, RG_RELREF_438000#661891, RG_TAUXRE_437984#661892, RG_TELBUR_437978#661893, RG_TRIREL_438013#661894, RG_TYPOC_438004#661895, RG_TYPORG_437972#661896, RG_VILLE_437977#661897]
Keys [51]: [ORIGINE_440148#661847, RG_ADR_1_437974#661848, RG_ADR_2_437975#661849, RG_ADR_3_438006#661850, RG_CMPIMP_F_437996#661851, RG_CMPIMP_H_437997#661852, RG_CODCAI_437986#661853, RG_CODCCP_437991#661854, RG_CODCEN_437987#661855, RG_CODORG_437971#661856, RG_CODPOS_437976#661857, RG_CODREG_437985#661858, RG_CODUTI_437990#661859, RG_COMMENT_438008#661860, RG_CONTAC_437982#661861, RG_DATEDE_438002#661862, RG_DATEFI_438003#661863, RG_DATENV_438001#661864, RG_DATMAJ_437989#661865, RG_E_MAIL_437980#661866, RG_FAX_437979#661867, RG_FLCHORUS_438015#661868, RG_FLLISENG_438017#661869, RG_FLPAV_438011#661870, RG_FLPECDEP_438009#661871, RG_FLTELE_437988#661872, RG_FLTOPR_437994#661873, RG_FLTP_437992#661874, RG_IDMUT_437993#661875, RG_MODREG_438018#661876, RG_NOMORG_437973#661877, RG_NOTBORD_438014#661878, RG_NOTREL_438007#661879, RG_NUMBOR_437983#661880, RG_NUMCPT_437995#661881, RG_NUMCPT_A_438010#661882, RG_NUMCPT_C_438019#661883, RG_NUMCPT_C_FT_438020#661884, RG_NUMSIR_438016#661885, RG_ORGPAYEUR_438005#661886, RG_PREFIX_437981#661887, RG_RECLAM_438012#661888, RG_RELCTX_437998#661889, RG_RELPAGE_437999#661890, RG_RELREF_438000#661891, RG_TAUXRE_437984#661892, RG_TELBUR_437978#661893, RG_TRIREL_438013#661894, RG_TYPOC_438004#661895, RG_TYPORG_437972#661896, RG_VILLE_437977#661897]
Functions: []
Aggregate Attributes: []
Results [51]: [ORIGINE_440148#661847, RG_ADR_1_437974#661848, RG_ADR_2_437975#661849, RG_ADR_3_438006#661850, RG_CMPIMP_F_437996#661851, RG_CMPIMP_H_437997#661852, RG_CODCAI_437986#661853, RG_CODCCP_437991#661854, RG_CODCEN_437987#661855, RG_CODORG_437971#661856, RG_CODPOS_437976#661857, RG_CODREG_437985#661858, RG_CODUTI_437990#661859, RG_COMMENT_438008#661860, RG_CONTAC_437982#661861, RG_DATEDE_438002#661862, RG_DATEFI_438003#661863, RG_DATENV_438001#661864, RG_DATMAJ_437989#661865, RG_E_MAIL_437980#661866, RG_FAX_437979#661867, RG_FLCHORUS_438015#661868, RG_FLLISENG_438017#661869, RG_FLPAV_438011#661870, RG_FLPECDEP_438009#661871, RG_FLTELE_437988#661872, RG_FLTOPR_437994#661873, RG_FLTP_437992#661874, RG_IDMUT_437993#661875, RG_MODREG_438018#661876, RG_NOMORG_437973#661877, RG_NOTBORD_438014#661878, RG_NOTREL_438007#661879, RG_NUMBOR_437983#661880, RG_NUMCPT_437995#661881, RG_NUMCPT_A_438010#661882, RG_NUMCPT_C_438019#661883, RG_NUMCPT_C_FT_438020#661884, RG_NUMSIR_438016#661885, RG_ORGPAYEUR_438005#661886, RG_PREFIX_437981#661887, RG_RECLAM_438012#661888, RG_RELCTX_437998#661889, RG_RELPAGE_437999#661890, RG_RELREF_438000#661891, RG_TAUXRE_437984#661892, RG_TELBUR_437978#661893, RG_TRIREL_438013#661894, RG_TYPOC_438004#661895, RG_TYPORG_437972#661896, RG_VILLE_437977#661897]

(9) Exchange
Input [51]: [ORIGINE_440148#661847, RG_ADR_1_437974#661848, RG_ADR_2_437975#661849, RG_ADR_3_438006#661850, RG_CMPIMP_F_437996#661851, RG_CMPIMP_H_437997#661852, RG_CODCAI_437986#661853, RG_CODCCP_437991#661854, RG_CODCEN_437987#661855, RG_CODORG_437971#661856, RG_CODPOS_437976#661857, RG_CODREG_437985#661858, RG_CODUTI_437990#661859, RG_COMMENT_438008#661860, RG_CONTAC_437982#661861, RG_DATEDE_438002#661862, RG_DATEFI_438003#661863, RG_DATENV_438001#661864, RG_DATMAJ_437989#661865, RG_E_MAIL_437980#661866, RG_FAX_437979#661867, RG_FLCHORUS_438015#661868, RG_FLLISENG_438017#661869, RG_FLPAV_438011#661870, RG_FLPECDEP_438009#661871, RG_FLTELE_437988#661872, RG_FLTOPR_437994#661873, RG_FLTP_437992#661874, RG_IDMUT_437993#661875, RG_MODREG_438018#661876, RG_NOMORG_437973#661877, RG_NOTBORD_438014#661878, RG_NOTREL_438007#661879, RG_NUMBOR_437983#661880, RG_NUMCPT_437995#661881, RG_NUMCPT_A_438010#661882, RG_NUMCPT_C_438019#661883, RG_NUMCPT_C_FT_438020#661884, RG_NUMSIR_438016#661885, RG_ORGPAYEUR_438005#661886, RG_PREFIX_437981#661887, RG_RECLAM_438012#661888, RG_RELCTX_437998#661889, RG_RELPAGE_437999#661890, RG_RELREF_438000#661891, RG_TAUXRE_437984#661892, RG_TELBUR_437978#661893, RG_TRIREL_438013#661894, RG_TYPOC_438004#661895, RG_TYPORG_437972#661896, RG_VILLE_437977#661897]
Arguments: hashpartitioning(ORIGINE_440148#661847, RG_ADR_1_437974#661848, RG_ADR_2_437975#661849, RG_ADR_3_438006#661850, RG_CMPIMP_F_437996#661851, RG_CMPIMP_H_437997#661852, RG_CODCAI_437986#661853, RG_CODCCP_437991#661854, RG_CODCEN_437987#661855, RG_CODORG_437971#661856, RG_CODPOS_437976#661857, RG_CODREG_437985#661858, RG_CODUTI_437990#661859, RG_COMMENT_438008#661860, RG_CONTAC_437982#661861, RG_DATEDE_438002#661862, RG_DATEFI_438003#661863, RG_DATENV_438001#661864, RG_DATMAJ_437989#661865, RG_E_MAIL_437980#661866, RG_FAX_437979#661867, RG_FLCHORUS_438015#661868, RG_FLLISENG_438017#661869, RG_FLPAV_438011#661870, ... 28 more fields), ENSURE_REQUIREMENTS, [plan_id=35591]

(10) ShuffleQueryStage
Output [51]: [ORIGINE_440148#661847, RG_ADR_1_437974#661848, RG_ADR_2_437975#661849, RG_ADR_3_438006#661850, RG_CMPIMP_F_437996#661851, RG_CMPIMP_H_437997#661852, RG_CODCAI_437986#661853, RG_CODCCP_437991#661854, RG_CODCEN_437987#661855, RG_CODORG_437971#661856, RG_CODPOS_437976#661857, RG_CODREG_437985#661858, RG_CODUTI_437990#661859, RG_COMMENT_438008#661860, RG_CONTAC_437982#661861, RG_DATEDE_438002#661862, RG_DATEFI_438003#661863, RG_DATENV_438001#661864, RG_DATMAJ_437989#661865, RG_E_MAIL_437980#661866, RG_FAX_437979#661867, RG_FLCHORUS_438015#661868, RG_FLLISENG_438017#661869, RG_FLPAV_438011#661870, RG_FLPECDEP_438009#661871, RG_FLTELE_437988#661872, RG_FLTOPR_437994#661873, RG_FLTP_437992#661874, RG_IDMUT_437993#661875, RG_MODREG_438018#661876, RG_NOMORG_437973#661877, RG_NOTBORD_438014#661878, RG_NOTREL_438007#661879, RG_NUMBOR_437983#661880, RG_NUMCPT_437995#661881, RG_NUMCPT_A_438010#661882, RG_NUMCPT_C_438019#661883, RG_NUMCPT_C_FT_438020#661884, RG_NUMSIR_438016#661885, RG_ORGPAYEUR_438005#661886, RG_PREFIX_437981#661887, RG_RECLAM_438012#661888, RG_RELCTX_437998#661889, RG_RELPAGE_437999#661890, RG_RELREF_438000#661891, RG_TAUXRE_437984#661892, RG_TELBUR_437978#661893, RG_TRIREL_438013#661894, RG_TYPOC_438004#661895, RG_TYPORG_437972#661896, RG_VILLE_437977#661897]
Arguments: 0

(11) AQEShuffleRead
Input [51]: [ORIGINE_440148#661847, RG_ADR_1_437974#661848, RG_ADR_2_437975#661849, RG_ADR_3_438006#661850, RG_CMPIMP_F_437996#661851, RG_CMPIMP_H_437997#661852, RG_CODCAI_437986#661853, RG_CODCCP_437991#661854, RG_CODCEN_437987#661855, RG_CODORG_437971#661856, RG_CODPOS_437976#661857, RG_CODREG_437985#661858, RG_CODUTI_437990#661859, RG_COMMENT_438008#661860, RG_CONTAC_437982#661861, RG_DATEDE_438002#661862, RG_DATEFI_438003#661863, RG_DATENV_438001#661864, RG_DATMAJ_437989#661865, RG_E_MAIL_437980#661866, RG_FAX_437979#661867, RG_FLCHORUS_438015#661868, RG_FLLISENG_438017#661869, RG_FLPAV_438011#661870, RG_FLPECDEP_438009#661871, RG_FLTELE_437988#661872, RG_FLTOPR_437994#661873, RG_FLTP_437992#661874, RG_IDMUT_437993#661875, RG_MODREG_438018#661876, RG_NOMORG_437973#661877, RG_NOTBORD_438014#661878, RG_NOTREL_438007#661879, RG_NUMBOR_437983#661880, RG_NUMCPT_437995#661881, RG_NUMCPT_A_438010#661882, RG_NUMCPT_C_438019#661883, RG_NUMCPT_C_FT_438020#661884, RG_NUMSIR_438016#661885, RG_ORGPAYEUR_438005#661886, RG_PREFIX_437981#661887, RG_RECLAM_438012#661888, RG_RELCTX_437998#661889, RG_RELPAGE_437999#661890, RG_RELREF_438000#661891, RG_TAUXRE_437984#661892, RG_TELBUR_437978#661893, RG_TRIREL_438013#661894, RG_TYPOC_438004#661895, RG_TYPORG_437972#661896, RG_VILLE_437977#661897]
Arguments: coalesced

(12) HashAggregate [codegen id : 4]
Input [51]: [ORIGINE_440148#661847, RG_ADR_1_437974#661848, RG_ADR_2_437975#661849, RG_ADR_3_438006#661850, RG_CMPIMP_F_437996#661851, RG_CMPIMP_H_437997#661852, RG_CODCAI_437986#661853, RG_CODCCP_437991#661854, RG_CODCEN_437987#661855, RG_CODORG_437971#661856, RG_CODPOS_437976#661857, RG_CODREG_437985#661858, RG_CODUTI_437990#661859, RG_COMMENT_438008#661860, RG_CONTAC_437982#661861, RG_DATEDE_438002#661862, RG_DATEFI_438003#661863, RG_DATENV_438001#661864, RG_DATMAJ_437989#661865, RG_E_MAIL_437980#661866, RG_FAX_437979#661867, RG_FLCHORUS_438015#661868, RG_FLLISENG_438017#661869, RG_FLPAV_438011#661870, RG_FLPECDEP_438009#661871, RG_FLTELE_437988#661872, RG_FLTOPR_437994#661873, RG_FLTP_437992#661874, RG_IDMUT_437993#661875, RG_MODREG_438018#661876, RG_NOMORG_437973#661877, RG_NOTBORD_438014#661878, RG_NOTREL_438007#661879, RG_NUMBOR_437983#661880, RG_NUMCPT_437995#661881, RG_NUMCPT_A_438010#661882, RG_NUMCPT_C_438019#661883, RG_NUMCPT_C_FT_438020#661884, RG_NUMSIR_438016#661885, RG_ORGPAYEUR_438005#661886, RG_PREFIX_437981#661887, RG_RECLAM_438012#661888, RG_RELCTX_437998#661889, RG_RELPAGE_437999#661890, RG_RELREF_438000#661891, RG_TAUXRE_437984#661892, RG_TELBUR_437978#661893, RG_TRIREL_438013#661894, RG_TYPOC_438004#661895, RG_TYPORG_437972#661896, RG_VILLE_437977#661897]
Keys [51]: [ORIGINE_440148#661847, RG_ADR_1_437974#661848, RG_ADR_2_437975#661849, RG_ADR_3_438006#661850, RG_CMPIMP_F_437996#661851, RG_CMPIMP_H_437997#661852, RG_CODCAI_437986#661853, RG_CODCCP_437991#661854, RG_CODCEN_437987#661855, RG_CODORG_437971#661856, RG_CODPOS_437976#661857, RG_CODREG_437985#661858, RG_CODUTI_437990#661859, RG_COMMENT_438008#661860, RG_CONTAC_437982#661861, RG_DATEDE_438002#661862, RG_DATEFI_438003#661863, RG_DATENV_438001#661864, RG_DATMAJ_437989#661865, RG_E_MAIL_437980#661866, RG_FAX_437979#661867, RG_FLCHORUS_438015#661868, RG_FLLISENG_438017#661869, RG_FLPAV_438011#661870, RG_FLPECDEP_438009#661871, RG_FLTELE_437988#661872, RG_FLTOPR_437994#661873, RG_FLTP_437992#661874, RG_IDMUT_437993#661875, RG_MODREG_438018#661876, RG_NOMORG_437973#661877, RG_NOTBORD_438014#661878, RG_NOTREL_438007#661879, RG_NUMBOR_437983#661880, RG_NUMCPT_437995#661881, RG_NUMCPT_A_438010#661882, RG_NUMCPT_C_438019#661883, RG_NUMCPT_C_FT_438020#661884, RG_NUMSIR_438016#661885, RG_ORGPAYEUR_438005#661886, RG_PREFIX_437981#661887, RG_RECLAM_438012#661888, RG_RELCTX_437998#661889, RG_RELPAGE_437999#661890, RG_RELREF_438000#661891, RG_TAUXRE_437984#661892, RG_TELBUR_437978#661893, RG_TRIREL_438013#661894, RG_TYPOC_438004#661895, RG_TYPORG_437972#661896, RG_VILLE_437977#661897]
Functions: []
Aggregate Attributes: []
Results: []

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

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

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

(16) HashAggregate [codegen id : 5]
Input [1]: [count#663068L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#663064L]
Results [1]: [count(1)#663064L AS count#663065L]

(17) Union

(18) HashAggregate
Input [51]: [ORIGINE_440148#661847, RG_ADR_1_437974#661848, RG_ADR_2_437975#661849, RG_ADR_3_438006#661850, RG_CMPIMP_F_437996#661851, RG_CMPIMP_H_437997#661852, RG_CODCAI_437986#661853, RG_CODCCP_437991#661854, RG_CODCEN_437987#661855, RG_CODORG_437971#661856, RG_CODPOS_437976#661857, RG_CODREG_437985#661858, RG_CODUTI_437990#661859, RG_COMMENT_438008#661860, RG_CONTAC_437982#661861, RG_DATEDE_438002#661862, RG_DATEFI_438003#661863, RG_DATENV_438001#661864, RG_DATMAJ_437989#661865, RG_E_MAIL_437980#661866, RG_FAX_437979#661867, RG_FLCHORUS_438015#661868, RG_FLLISENG_438017#661869, RG_FLPAV_438011#661870, RG_FLPECDEP_438009#661871, RG_FLTELE_437988#661872, RG_FLTOPR_437994#661873, RG_FLTP_437992#661874, RG_IDMUT_437993#661875, RG_MODREG_438018#661876, RG_NOMORG_437973#661877, RG_NOTBORD_438014#661878, RG_NOTREL_438007#661879, RG_NUMBOR_437983#661880, RG_NUMCPT_437995#661881, RG_NUMCPT_A_438010#661882, RG_NUMCPT_C_438019#661883, RG_NUMCPT_C_FT_438020#661884, RG_NUMSIR_438016#661885, RG_ORGPAYEUR_438005#661886, RG_PREFIX_437981#661887, RG_RECLAM_438012#661888, RG_RELCTX_437998#661889, RG_RELPAGE_437999#661890, RG_RELREF_438000#661891, RG_TAUXRE_437984#661892, RG_TELBUR_437978#661893, RG_TRIREL_438013#661894, RG_TYPOC_438004#661895, RG_TYPORG_437972#661896, RG_VILLE_437977#661897]
Keys [51]: [ORIGINE_440148#661847, RG_ADR_1_437974#661848, RG_ADR_2_437975#661849, RG_ADR_3_438006#661850, RG_CMPIMP_F_437996#661851, RG_CMPIMP_H_437997#661852, RG_CODCAI_437986#661853, RG_CODCCP_437991#661854, RG_CODCEN_437987#661855, RG_CODORG_437971#661856, RG_CODPOS_437976#661857, RG_CODREG_437985#661858, RG_CODUTI_437990#661859, RG_COMMENT_438008#661860, RG_CONTAC_437982#661861, RG_DATEDE_438002#661862, RG_DATEFI_438003#661863, RG_DATENV_438001#661864, RG_DATMAJ_437989#661865, RG_E_MAIL_437980#661866, RG_FAX_437979#661867, RG_FLCHORUS_438015#661868, RG_FLLISENG_438017#661869, RG_FLPAV_438011#661870, RG_FLPECDEP_438009#661871, RG_FLTELE_437988#661872, RG_FLTOPR_437994#661873, RG_FLTP_437992#661874, RG_IDMUT_437993#661875, RG_MODREG_438018#661876, RG_NOMORG_437973#661877, RG_NOTBORD_438014#661878, RG_NOTREL_438007#661879, RG_NUMBOR_437983#661880, RG_NUMCPT_437995#661881, RG_NUMCPT_A_438010#661882, RG_NUMCPT_C_438019#661883, RG_NUMCPT_C_FT_438020#661884, RG_NUMSIR_438016#661885, RG_ORGPAYEUR_438005#661886, RG_PREFIX_437981#661887, RG_RECLAM_438012#661888, RG_RELCTX_437998#661889, RG_RELPAGE_437999#661890, RG_RELREF_438000#661891, RG_TAUXRE_437984#661892, RG_TELBUR_437978#661893, RG_TRIREL_438013#661894, RG_TYPOC_438004#661895, RG_TYPORG_437972#661896, RG_VILLE_437977#661897]
Functions: []
Aggregate Attributes: []
Results [51]: [ORIGINE_440148#661847, RG_ADR_1_437974#661848, RG_ADR_2_437975#661849, RG_ADR_3_438006#661850, RG_CMPIMP_F_437996#661851, RG_CMPIMP_H_437997#661852, RG_CODCAI_437986#661853, RG_CODCCP_437991#661854, RG_CODCEN_437987#661855, RG_CODORG_437971#661856, RG_CODPOS_437976#661857, RG_CODREG_437985#661858, RG_CODUTI_437990#661859, RG_COMMENT_438008#661860, RG_CONTAC_437982#661861, RG_DATEDE_438002#661862, RG_DATEFI_438003#661863, RG_DATENV_438001#661864, RG_DATMAJ_437989#661865, RG_E_MAIL_437980#661866, RG_FAX_437979#661867, RG_FLCHORUS_438015#661868, RG_FLLISENG_438017#661869, RG_FLPAV_438011#661870, RG_FLPECDEP_438009#661871, RG_FLTELE_437988#661872, RG_FLTOPR_437994#661873, RG_FLTP_437992#661874, RG_IDMUT_437993#661875, RG_MODREG_438018#661876, RG_NOMORG_437973#661877, RG_NOTBORD_438014#661878, RG_NOTREL_438007#661879, RG_NUMBOR_437983#661880, RG_NUMCPT_437995#661881, RG_NUMCPT_A_438010#661882, RG_NUMCPT_C_438019#661883, RG_NUMCPT_C_FT_438020#661884, RG_NUMSIR_438016#661885, RG_ORGPAYEUR_438005#661886, RG_PREFIX_437981#661887, RG_RECLAM_438012#661888, RG_RELCTX_437998#661889, RG_RELPAGE_437999#661890, RG_RELREF_438000#661891, RG_TAUXRE_437984#661892, RG_TELBUR_437978#661893, RG_TRIREL_438013#661894, RG_TYPOC_438004#661895, RG_TYPORG_437972#661896, RG_VILLE_437977#661897]

(19) Exchange
Input [51]: [ORIGINE_440148#661847, RG_ADR_1_437974#661848, RG_ADR_2_437975#661849, RG_ADR_3_438006#661850, RG_CMPIMP_F_437996#661851, RG_CMPIMP_H_437997#661852, RG_CODCAI_437986#661853, RG_CODCCP_437991#661854, RG_CODCEN_437987#661855, RG_CODORG_437971#661856, RG_CODPOS_437976#661857, RG_CODREG_437985#661858, RG_CODUTI_437990#661859, RG_COMMENT_438008#661860, RG_CONTAC_437982#661861, RG_DATEDE_438002#661862, RG_DATEFI_438003#661863, RG_DATENV_438001#661864, RG_DATMAJ_437989#661865, RG_E_MAIL_437980#661866, RG_FAX_437979#661867, RG_FLCHORUS_438015#661868, RG_FLLISENG_438017#661869, RG_FLPAV_438011#661870, RG_FLPECDEP_438009#661871, RG_FLTELE_437988#661872, RG_FLTOPR_437994#661873, RG_FLTP_437992#661874, RG_IDMUT_437993#661875, RG_MODREG_438018#661876, RG_NOMORG_437973#661877, RG_NOTBORD_438014#661878, RG_NOTREL_438007#661879, RG_NUMBOR_437983#661880, RG_NUMCPT_437995#661881, RG_NUMCPT_A_438010#661882, RG_NUMCPT_C_438019#661883, RG_NUMCPT_C_FT_438020#661884, RG_NUMSIR_438016#661885, RG_ORGPAYEUR_438005#661886, RG_PREFIX_437981#661887, RG_RECLAM_438012#661888, RG_RELCTX_437998#661889, RG_RELPAGE_437999#661890, RG_RELREF_438000#661891, RG_TAUXRE_437984#661892, RG_TELBUR_437978#661893, RG_TRIREL_438013#661894, RG_TYPOC_438004#661895, RG_TYPORG_437972#661896, RG_VILLE_437977#661897]
Arguments: hashpartitioning(ORIGINE_440148#661847, RG_ADR_1_437974#661848, RG_ADR_2_437975#661849, RG_ADR_3_438006#661850, RG_CMPIMP_F_437996#661851, RG_CMPIMP_H_437997#661852, RG_CODCAI_437986#661853, RG_CODCCP_437991#661854, RG_CODCEN_437987#661855, RG_CODORG_437971#661856, RG_CODPOS_437976#661857, RG_CODREG_437985#661858, RG_CODUTI_437990#661859, RG_COMMENT_438008#661860, RG_CONTAC_437982#661861, RG_DATEDE_438002#661862, RG_DATEFI_438003#661863, RG_DATENV_438001#661864, RG_DATMAJ_437989#661865, RG_E_MAIL_437980#661866, RG_FAX_437979#661867, RG_FLCHORUS_438015#661868, RG_FLLISENG_438017#661869, RG_FLPAV_438011#661870, ... 28 more fields), ENSURE_REQUIREMENTS, [plan_id=35559]

(20) HashAggregate
Input [51]: [ORIGINE_440148#661847, RG_ADR_1_437974#661848, RG_ADR_2_437975#661849, RG_ADR_3_438006#661850, RG_CMPIMP_F_437996#661851, RG_CMPIMP_H_437997#661852, RG_CODCAI_437986#661853, RG_CODCCP_437991#661854, RG_CODCEN_437987#661855, RG_CODORG_437971#661856, RG_CODPOS_437976#661857, RG_CODREG_437985#661858, RG_CODUTI_437990#661859, RG_COMMENT_438008#661860, RG_CONTAC_437982#661861, RG_DATEDE_438002#661862, RG_DATEFI_438003#661863, RG_DATENV_438001#661864, RG_DATMAJ_437989#661865, RG_E_MAIL_437980#661866, RG_FAX_437979#661867, RG_FLCHORUS_438015#661868, RG_FLLISENG_438017#661869, RG_FLPAV_438011#661870, RG_FLPECDEP_438009#661871, RG_FLTELE_437988#661872, RG_FLTOPR_437994#661873, RG_FLTP_437992#661874, RG_IDMUT_437993#661875, RG_MODREG_438018#661876, RG_NOMORG_437973#661877, RG_NOTBORD_438014#661878, RG_NOTREL_438007#661879, RG_NUMBOR_437983#661880, RG_NUMCPT_437995#661881, RG_NUMCPT_A_438010#661882, RG_NUMCPT_C_438019#661883, RG_NUMCPT_C_FT_438020#661884, RG_NUMSIR_438016#661885, RG_ORGPAYEUR_438005#661886, RG_PREFIX_437981#661887, RG_RECLAM_438012#661888, RG_RELCTX_437998#661889, RG_RELPAGE_437999#661890, RG_RELREF_438000#661891, RG_TAUXRE_437984#661892, RG_TELBUR_437978#661893, RG_TRIREL_438013#661894, RG_TYPOC_438004#661895, RG_TYPORG_437972#661896, RG_VILLE_437977#661897]
Keys [51]: [ORIGINE_440148#661847, RG_ADR_1_437974#661848, RG_ADR_2_437975#661849, RG_ADR_3_438006#661850, RG_CMPIMP_F_437996#661851, RG_CMPIMP_H_437997#661852, RG_CODCAI_437986#661853, RG_CODCCP_437991#661854, RG_CODCEN_437987#661855, RG_CODORG_437971#661856, RG_CODPOS_437976#661857, RG_CODREG_437985#661858, RG_CODUTI_437990#661859, RG_COMMENT_438008#661860, RG_CONTAC_437982#661861, RG_DATEDE_438002#661862, RG_DATEFI_438003#661863, RG_DATENV_438001#661864, RG_DATMAJ_437989#661865, RG_E_MAIL_437980#661866, RG_FAX_437979#661867, RG_FLCHORUS_438015#661868, RG_FLLISENG_438017#661869, RG_FLPAV_438011#661870, RG_FLPECDEP_438009#661871, RG_FLTELE_437988#661872, RG_FLTOPR_437994#661873, RG_FLTP_437992#661874, RG_IDMUT_437993#661875, RG_MODREG_438018#661876, RG_NOMORG_437973#661877, RG_NOTBORD_438014#661878, RG_NOTREL_438007#661879, RG_NUMBOR_437983#661880, RG_NUMCPT_437995#661881, RG_NUMCPT_A_438010#661882, RG_NUMCPT_C_438019#661883, RG_NUMCPT_C_FT_438020#661884, RG_NUMSIR_438016#661885, RG_ORGPAYEUR_438005#661886, RG_PREFIX_437981#661887, RG_RECLAM_438012#661888, RG_RELCTX_437998#661889, RG_RELPAGE_437999#661890, RG_RELREF_438000#661891, RG_TAUXRE_437984#661892, RG_TELBUR_437978#661893, RG_TRIREL_438013#661894, RG_TYPOC_438004#661895, RG_TYPORG_437972#661896, RG_VILLE_437977#661897]
Functions: []
Aggregate Attributes: []
Results: []

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

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

(23) HashAggregate
Input [1]: [count#663068L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#663064L]
Results [1]: [count(1)#663064L AS count#663065L]

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

SQL / DataFrame Properties

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