hdh-spark-job - Details for Query 1335

Submitted Time: 2026/10/23 13:27:33
Duration: 0.8 s
Succeeded Jobs: 1335 1336

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 (4)\n \nduration: 7 ms"; 2 [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"]; } 3 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 552.0 B number of coalesced partitions: 1"]; 4 [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 1926.0: task 1679)) 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 1926.0: task 1679)) 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 1926.0: task 1679))"]; subgraph cluster5 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n381 ms (189 ms, 192 ms, 192 ms (stage 1926.0: task 1679))"; 6 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 362 ms (180 ms, 182 ms, 182 ms (stage 1926.0: task 1679)) peak memory total (min, med, max (stageId: taskId)) 128.5 MiB (64.2 MiB, 64.2 MiB, 64.2 MiB (stage 1926.0: task 1679)) 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 1926.0: task 1679))"]; } 7 [labelType="html" label=" Union "]; subgraph cluster8 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 189 ms"; 9 [labelType="html" label=" Project "]; 10 [labelType="html" label="Filter number of output rows: 1"]; 11 [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 cluster12 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 191 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 \"xplore2\".\"h_organ\") as x) [numPartitions=1] number of output rows: 6,195"]; } 2->0; 3->2; 4->3; 6->4; 7->6; 9->7; 10->9; 11->10; 13->7; 14->13; 15->14; }

AdaptiveSparkPlan isFinalPlan=true

HashAggregate(keys=[ORIGINE_440148#663419, RG_ADR_1_437974#663420, RG_ADR_2_437975#663421, RG_ADR_3_438006#663422, RG_CMPIMP_F_437996#663423, RG_CMPIMP_H_437997#663424, RG_CODCAI_437986#663425, RG_CODCCP_437991#663426, RG_CODCEN_437987#663427, RG_CODORG_437971#663428, RG_CODPOS_437976#663429, RG_CODREG_437985#663430, RG_CODUTI_437990#663431, RG_COMMENT_438008#663432, RG_CONTAC_437982#663433, RG_DATEDE_438002#663434, RG_DATEFI_438003#663435, RG_DATENV_438001#663436, RG_DATMAJ_437989#663437, RG_E_MAIL_437980#663438, RG_FAX_437979#663439, RG_FLCHORUS_438015#663440, RG_FLLISENG_438017#663441, RG_FLPAV_438011#663442, ... 27 more fields], functions=[])

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(ORIGINE_440148#663419, RG_ADR_1_437974#663420, RG_ADR_2_437975#663421, RG_ADR_3_438006#663422, RG_CMPIMP_F_437996#663423, RG_CMPIMP_H_437997#663424, RG_CODCAI_437986#663425, RG_CODCCP_437991#663426, RG_CODCEN_437987#663427, RG_CODORG_437971#663428, RG_CODPOS_437976#663429, RG_CODREG_437985#663430, RG_CODUTI_437990#663431, RG_COMMENT_438008#663432, RG_CONTAC_437982#663433, RG_DATEDE_438002#663434, RG_DATEFI_438003#663435, RG_DATENV_438001#663436, RG_DATMAJ_437989#663437, RG_E_MAIL_437980#663438, RG_FAX_437979#663439, RG_FLCHORUS_438015#663440, RG_FLLISENG_438017#663441, RG_FLPAV_438011#663442, ... 28 more fields), ENSURE_REQUIREMENTS, [plan_id=35702]

WholeStageCodegen (3)

Union

Project [null AS ORIGINE_440148#663419, rg_adr_1#663072 AS RG_ADR_1_437974#663420, rg_adr_2#663073 AS RG_ADR_2_437975#663421, rg_adr_3#663104 AS RG_ADR_3_438006#663422, rg_cmpimp_f#663094 AS RG_CMPIMP_F_437996#663423, rg_cmpimp_h#663095 AS RG_CMPIMP_H_437997#663424, rg_codcai#663084 AS RG_CODCAI_437986#663425, rg_codccp#663089 AS RG_CODCCP_437991#663426, rg_codcen#663085 AS RG_CODCEN_437987#663427, rg_codorg#663069 AS RG_CODORG_437971#663428, rg_codpos#663074 AS RG_CODPOS_437976#663429, rg_codreg#663083 AS RG_CODREG_437985#663430, rg_coduti#663088 AS RG_CODUTI_437990#663431, rg_comment#663106 AS RG_COMMENT_438008#663432, rg_contac#663080 AS RG_CONTAC_437982#663433, rg_datede#663100 AS RG_DATEDE_438002#663434, rg_datefi#663101 AS RG_DATEFI_438003#663435, rg_datenv#663099 AS RG_DATENV_438001#663436, rg_datmaj#663087 AS RG_DATMAJ_437989#663437, rg_e_mail#663078 AS RG_E_MAIL_437980#663438, rg_fax#663077 AS RG_FAX_437979#663439, rg_flchorus#663113 AS RG_FLCHORUS_438015#663440, rg_flliseng#663115 AS RG_FLLISENG_438017#663441, rg_flpav#663109 AS RG_FLPAV_438011#663442, ... 27 more fields]

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codorg#663069)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codorg#663069)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typorg#663070)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_typorg#663070)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_nomorg#663071)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_nomorg#663071)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_1#663072)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_1#663072)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_2#663073)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_2#663073)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codpos#663074)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codpos#663074)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_ville#663075)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_ville#663075)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_telbur#663076)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_telbur#663076)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fax#663077)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fax#663077)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_e_mail#663078)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_e_mail#663078)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_prefix#663079)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_prefix#663079)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_contac#663080)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_contac#663080)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numbor#663081)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numbor#663081)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_tauxre#663082)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_tauxre#663082)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codreg#663083)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codreg#663083)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcai#663084)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcai#663084)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcen#663085)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcen#663085)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltele#663086)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltele#663086)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datmaj#663087)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datmaj#663087)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_coduti#663088)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_coduti#663088)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codccp#663089)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codccp#663089)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltp#663090)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltp#663090)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_idmut#663091)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_idmut#663091)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltopr#663092)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltopr#663092)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt#663093)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt#663093)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_f#663094)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_f#663094)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_h#663095)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_h#663095)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relctx#663096)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_relctx#663096)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relpage#663097)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_relpage#663097)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relref#663098)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_relref#663098)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datenv#663099)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datenv#663099)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datede#663100)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datede#663100)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datefi#663101)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datefi#663101)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typoc#663102)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_typoc#663102)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_orgpayeur#663103)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_orgpayeur#663103)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_3#663104)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_3#663104)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notrel#663105)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_notrel#663105)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_comment#663106)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_comment#663106)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpecdep#663107)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpecdep#663107)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_a#663108)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_a#663108)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpav#663109)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpav#663109)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_reclam#663110)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_reclam#663110)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_trirel#663111)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_trirel#663111)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notbord#663112)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_notbord#663112)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flchorus#663113)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flchorus#663113)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numsir#663114)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numsir#663114)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flliseng#663115)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flliseng#663115)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_modreg#663116)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_modreg#663116)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c#663117)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c#663117)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c_ft#663118)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c_ft#663118)), 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#663072,rg_adr_2#663073,rg_adr_3#663104,rg_cmpimp_f#663094,rg_cmpimp_h#663095,rg_codcai#663084,rg_codccp#663089,rg_codcen#663085,rg_codorg#663069,rg_codpos#663074,rg_codreg#663083,rg_coduti#663088,rg_comment#663106,rg_contac#663080,rg_datede#663100,rg_datefi#663101,rg_datenv#663099,rg_datmaj#663087,rg_e_mail#663078,rg_fax#663077,rg_flchorus#663113,rg_flliseng#663115,rg_flpav#663109,rg_flpecdep#663107,... 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#663871, rg_adr_1#663524 AS RG_ADR_1_437974#663872, rg_adr_2#663525 AS RG_ADR_2_437975#663873, rg_adr_3#663556 AS RG_ADR_3_438006#663874, rg_cmpimp_f#663546 AS RG_CMPIMP_F_437996#663875, rg_cmpimp_h#663547 AS RG_CMPIMP_H_437997#663876, rg_codcai#663536 AS RG_CODCAI_437986#663877, rg_codccp#663541 AS RG_CODCCP_437991#663878, rg_codcen#663537 AS RG_CODCEN_437987#663879, rg_codorg#663521 AS RG_CODORG_437971#663880, rg_codpos#663526 AS RG_CODPOS_437976#663881, rg_codreg#663535 AS RG_CODREG_437985#663882, rg_coduti#663540 AS RG_CODUTI_437990#663883, rg_comment#663558 AS RG_COMMENT_438008#663884, rg_contac#663532 AS RG_CONTAC_437982#663885, rg_datede#663552 AS RG_DATEDE_438002#663886, rg_datefi#663553 AS RG_DATEFI_438003#663887, rg_datenv#663551 AS RG_DATENV_438001#663888, rg_datmaj#663539 AS RG_DATMAJ_437989#663889, rg_e_mail#663530 AS RG_E_MAIL_437980#663890, rg_fax#663529 AS RG_FAX_437979#663891, rg_flchorus#663565 AS RG_FLCHORUS_438015#663892, rg_flliseng#663567 AS RG_FLLISENG_438017#663893, rg_flpav#663561 AS RG_FLPAV_438011#663894, ... 27 more fields]

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codorg#663521)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codorg#663521)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typorg#663522)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_typorg#663522)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_nomorg#663523)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_nomorg#663523)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_1#663524)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_1#663524)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_2#663525)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_2#663525)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codpos#663526)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codpos#663526)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_ville#663527)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_ville#663527)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_telbur#663528)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_telbur#663528)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fax#663529)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fax#663529)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_e_mail#663530)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_e_mail#663530)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_prefix#663531)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_prefix#663531)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_contac#663532)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_contac#663532)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numbor#663533)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numbor#663533)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_tauxre#663534)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_tauxre#663534)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codreg#663535)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codreg#663535)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcai#663536)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcai#663536)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcen#663537)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcen#663537)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltele#663538)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltele#663538)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datmaj#663539)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datmaj#663539)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_coduti#663540)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_coduti#663540)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codccp#663541)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codccp#663541)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltp#663542)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltp#663542)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_idmut#663543)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_idmut#663543)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltopr#663544)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltopr#663544)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt#663545)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt#663545)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_f#663546)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_f#663546)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_h#663547)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_h#663547)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relctx#663548)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_relctx#663548)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relpage#663549)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_relpage#663549)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relref#663550)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_relref#663550)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datenv#663551)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datenv#663551)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datede#663552)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datede#663552)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datefi#663553)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datefi#663553)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typoc#663554)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_typoc#663554)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_orgpayeur#663555)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_orgpayeur#663555)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_3#663556)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_3#663556)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notrel#663557)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_notrel#663557)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_comment#663558)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_comment#663558)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpecdep#663559)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpecdep#663559)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_a#663560)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_a#663560)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpav#663561)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpav#663561)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_reclam#663562)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_reclam#663562)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_trirel#663563)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_trirel#663563)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notbord#663564)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_notbord#663564)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flchorus#663565)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flchorus#663565)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numsir#663566)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numsir#663566)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flliseng#663567)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flliseng#663567)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_modreg#663568)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_modreg#663568)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c#663569)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c#663569)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c_ft#663570)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c_ft#663570)), 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#663524,rg_adr_2#663525,rg_adr_3#663556,rg_cmpimp_f#663546,rg_cmpimp_h#663547,rg_codcai#663536,rg_codccp#663541,rg_codcen#663537,rg_codorg#663521,rg_codpos#663526,rg_codreg#663535,rg_coduti#663540,rg_comment#663558,rg_contac#663532,rg_datede#663552,rg_datefi#663553,rg_datenv#663551,rg_datmaj#663539,rg_e_mail#663530,rg_fax#663529,rg_flchorus#663565,rg_flliseng#663567,rg_flpav#663561,rg_flpecdep#663559,... 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 (18)
+- == Final Plan ==
   * 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 ==
   CollectLimit (17)
   +- HashAggregate (16)
      +- Exchange (15)
         +- HashAggregate (14)
            +- Union (13)
               :- 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#663072, rg_adr_2#663073, rg_adr_3#663104, rg_cmpimp_f#663094, rg_cmpimp_h#663095, rg_codcai#663084, rg_codccp#663089, rg_codcen#663085, rg_codorg#663069, rg_codpos#663074, rg_codreg#663083, rg_coduti#663088, rg_comment#663106, rg_contac#663080, rg_datede#663100, rg_datefi#663101, rg_datenv#663099, rg_datmaj#663087, rg_e_mail#663078, rg_fax#663077, rg_flchorus#663113, rg_flliseng#663115, rg_flpav#663109, rg_flpecdep#663107, rg_fltele#663086, rg_fltopr#663092, rg_fltp#663090, rg_idmut#663091, rg_modreg#663116, rg_nomorg#663071, rg_notbord#663112, rg_notrel#663105, rg_numbor#663081, rg_numcpt#663093, rg_numcpt_a#663108, rg_numcpt_c#663117, rg_numcpt_c_ft#663118, rg_numsir#663114, rg_orgpayeur#663103, rg_prefix#663079, rg_reclam#663110, rg_relctx#663096, rg_relpage#663097, rg_relref#663098, rg_tauxre#663082, rg_telbur#663076, rg_trirel#663111, rg_typoc#663102, rg_typorg#663070, rg_ville#663075]
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#663072, rg_adr_2#663073, rg_adr_3#663104, rg_cmpimp_f#663094, rg_cmpimp_h#663095, rg_codcai#663084, rg_codccp#663089, rg_codcen#663085, rg_codorg#663069, rg_codpos#663074, rg_codreg#663083, rg_coduti#663088, rg_comment#663106, rg_contac#663080, rg_datede#663100, rg_datefi#663101, rg_datenv#663099, rg_datmaj#663087, rg_e_mail#663078, rg_fax#663077, rg_flchorus#663113, rg_flliseng#663115, rg_flpav#663109, rg_flpecdep#663107, rg_fltele#663086, rg_fltopr#663092, rg_fltp#663090, rg_idmut#663091, rg_modreg#663116, rg_nomorg#663071, rg_notbord#663112, rg_notrel#663105, rg_numbor#663081, rg_numcpt#663093, rg_numcpt_a#663108, rg_numcpt_c#663117, rg_numcpt_c_ft#663118, rg_numsir#663114, rg_orgpayeur#663103, rg_prefix#663079, rg_reclam#663110, rg_relctx#663096, rg_relpage#663097, rg_relref#663098, rg_tauxre#663082, rg_telbur#663076, rg_trirel#663111, rg_typoc#663102, rg_typorg#663070, rg_ville#663075]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codorg#663069)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codorg#663069)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typorg#663070)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_typorg#663070)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_nomorg#663071)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_nomorg#663071)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_1#663072)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_1#663072)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_2#663073)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_2#663073)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codpos#663074)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codpos#663074)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_ville#663075)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_ville#663075)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_telbur#663076)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_telbur#663076)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fax#663077)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fax#663077)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_e_mail#663078)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_e_mail#663078)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_prefix#663079)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_prefix#663079)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_contac#663080)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_contac#663080)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numbor#663081)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numbor#663081)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_tauxre#663082)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_tauxre#663082)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codreg#663083)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codreg#663083)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcai#663084)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcai#663084)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcen#663085)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcen#663085)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltele#663086)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltele#663086)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datmaj#663087)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datmaj#663087)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_coduti#663088)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_coduti#663088)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codccp#663089)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codccp#663089)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltp#663090)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltp#663090)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_idmut#663091)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_idmut#663091)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltopr#663092)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltopr#663092)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt#663093)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt#663093)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_f#663094)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_f#663094)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_h#663095)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_h#663095)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relctx#663096)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_relctx#663096)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relpage#663097)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_relpage#663097)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relref#663098)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_relref#663098)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datenv#663099)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datenv#663099)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datede#663100)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datede#663100)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datefi#663101)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datefi#663101)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typoc#663102)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_typoc#663102)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_orgpayeur#663103)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_orgpayeur#663103)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_3#663104)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_3#663104)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notrel#663105)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_notrel#663105)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_comment#663106)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_comment#663106)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpecdep#663107)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpecdep#663107)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_a#663108)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_a#663108)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpav#663109)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpav#663109)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_reclam#663110)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_reclam#663110)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_trirel#663111)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_trirel#663111)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notbord#663112)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_notbord#663112)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flchorus#663113)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flchorus#663113)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numsir#663114)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numsir#663114)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flliseng#663115)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flliseng#663115)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_modreg#663116)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_modreg#663116)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c#663117)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c#663117)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c_ft#663118)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c_ft#663118)), 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#663419, rg_adr_1#663072 AS RG_ADR_1_437974#663420, rg_adr_2#663073 AS RG_ADR_2_437975#663421, rg_adr_3#663104 AS RG_ADR_3_438006#663422, rg_cmpimp_f#663094 AS RG_CMPIMP_F_437996#663423, rg_cmpimp_h#663095 AS RG_CMPIMP_H_437997#663424, rg_codcai#663084 AS RG_CODCAI_437986#663425, rg_codccp#663089 AS RG_CODCCP_437991#663426, rg_codcen#663085 AS RG_CODCEN_437987#663427, rg_codorg#663069 AS RG_CODORG_437971#663428, rg_codpos#663074 AS RG_CODPOS_437976#663429, rg_codreg#663083 AS RG_CODREG_437985#663430, rg_coduti#663088 AS RG_CODUTI_437990#663431, rg_comment#663106 AS RG_COMMENT_438008#663432, rg_contac#663080 AS RG_CONTAC_437982#663433, rg_datede#663100 AS RG_DATEDE_438002#663434, rg_datefi#663101 AS RG_DATEFI_438003#663435, rg_datenv#663099 AS RG_DATENV_438001#663436, rg_datmaj#663087 AS RG_DATMAJ_437989#663437, rg_e_mail#663078 AS RG_E_MAIL_437980#663438, rg_fax#663077 AS RG_FAX_437979#663439, rg_flchorus#663113 AS RG_FLCHORUS_438015#663440, rg_flliseng#663115 AS RG_FLLISENG_438017#663441, rg_flpav#663109 AS RG_FLPAV_438011#663442, rg_flpecdep#663107 AS RG_FLPECDEP_438009#663443, rg_fltele#663086 AS RG_FLTELE_437988#663444, rg_fltopr#663092 AS RG_FLTOPR_437994#663445, rg_fltp#663090 AS RG_FLTP_437992#663446, rg_idmut#663091 AS RG_IDMUT_437993#663447, rg_modreg#663116 AS RG_MODREG_438018#663448, rg_nomorg#663071 AS RG_NOMORG_437973#663449, rg_notbord#663112 AS RG_NOTBORD_438014#663450, rg_notrel#663105 AS RG_NOTREL_438007#663451, rg_numbor#663081 AS RG_NUMBOR_437983#663452, rg_numcpt#663093 AS RG_NUMCPT_437995#663453, rg_numcpt_a#663108 AS RG_NUMCPT_A_438010#663454, rg_numcpt_c#663117 AS RG_NUMCPT_C_438019#663455, rg_numcpt_c_ft#663118 AS RG_NUMCPT_C_FT_438020#663456, rg_numsir#663114 AS RG_NUMSIR_438016#663457, rg_orgpayeur#663103 AS RG_ORGPAYEUR_438005#663458, rg_prefix#663079 AS RG_PREFIX_437981#663459, rg_reclam#663110 AS RG_RECLAM_438012#663460, rg_relctx#663096 AS RG_RELCTX_437998#663461, rg_relpage#663097 AS RG_RELPAGE_437999#663462, rg_relref#663098 AS RG_RELREF_438000#663463, rg_tauxre#663082 AS RG_TAUXRE_437984#663464, rg_telbur#663076 AS RG_TELBUR_437978#663465, rg_trirel#663111 AS RG_TRIREL_438013#663466, rg_typoc#663102 AS RG_TYPOC_438004#663467, rg_typorg#663070 AS RG_TYPORG_437972#663468, rg_ville#663075 AS RG_VILLE_437977#663469]
Input [50]: [rg_adr_1#663072, rg_adr_2#663073, rg_adr_3#663104, rg_cmpimp_f#663094, rg_cmpimp_h#663095, rg_codcai#663084, rg_codccp#663089, rg_codcen#663085, rg_codorg#663069, rg_codpos#663074, rg_codreg#663083, rg_coduti#663088, rg_comment#663106, rg_contac#663080, rg_datede#663100, rg_datefi#663101, rg_datenv#663099, rg_datmaj#663087, rg_e_mail#663078, rg_fax#663077, rg_flchorus#663113, rg_flliseng#663115, rg_flpav#663109, rg_flpecdep#663107, rg_fltele#663086, rg_fltopr#663092, rg_fltp#663090, rg_idmut#663091, rg_modreg#663116, rg_nomorg#663071, rg_notbord#663112, rg_notrel#663105, rg_numbor#663081, rg_numcpt#663093, rg_numcpt_a#663108, rg_numcpt_c#663117, rg_numcpt_c_ft#663118, rg_numsir#663114, rg_orgpayeur#663103, rg_prefix#663079, rg_reclam#663110, rg_relctx#663096, rg_relpage#663097, rg_relref#663098, rg_tauxre#663082, rg_telbur#663076, rg_trirel#663111, rg_typoc#663102, rg_typorg#663070, rg_ville#663075]

(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#663524, rg_adr_2#663525, rg_adr_3#663556, rg_cmpimp_f#663546, rg_cmpimp_h#663547, rg_codcai#663536, rg_codccp#663541, rg_codcen#663537, rg_codorg#663521, rg_codpos#663526, rg_codreg#663535, rg_coduti#663540, rg_comment#663558, rg_contac#663532, rg_datede#663552, rg_datefi#663553, rg_datenv#663551, rg_datmaj#663539, rg_e_mail#663530, rg_fax#663529, rg_flchorus#663565, rg_flliseng#663567, rg_flpav#663561, rg_flpecdep#663559, rg_fltele#663538, rg_fltopr#663544, rg_fltp#663542, rg_idmut#663543, rg_modreg#663568, rg_nomorg#663523, rg_notbord#663564, rg_notrel#663557, rg_numbor#663533, rg_numcpt#663545, rg_numcpt_a#663560, rg_numcpt_c#663569, rg_numcpt_c_ft#663570, rg_numsir#663566, rg_orgpayeur#663555, rg_prefix#663531, rg_reclam#663562, rg_relctx#663548, rg_relpage#663549, rg_relref#663550, rg_tauxre#663534, rg_telbur#663528, rg_trirel#663563, rg_typoc#663554, rg_typorg#663522, rg_ville#663527]
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#663524, rg_adr_2#663525, rg_adr_3#663556, rg_cmpimp_f#663546, rg_cmpimp_h#663547, rg_codcai#663536, rg_codccp#663541, rg_codcen#663537, rg_codorg#663521, rg_codpos#663526, rg_codreg#663535, rg_coduti#663540, rg_comment#663558, rg_contac#663532, rg_datede#663552, rg_datefi#663553, rg_datenv#663551, rg_datmaj#663539, rg_e_mail#663530, rg_fax#663529, rg_flchorus#663565, rg_flliseng#663567, rg_flpav#663561, rg_flpecdep#663559, rg_fltele#663538, rg_fltopr#663544, rg_fltp#663542, rg_idmut#663543, rg_modreg#663568, rg_nomorg#663523, rg_notbord#663564, rg_notrel#663557, rg_numbor#663533, rg_numcpt#663545, rg_numcpt_a#663560, rg_numcpt_c#663569, rg_numcpt_c_ft#663570, rg_numsir#663566, rg_orgpayeur#663555, rg_prefix#663531, rg_reclam#663562, rg_relctx#663548, rg_relpage#663549, rg_relref#663550, rg_tauxre#663534, rg_telbur#663528, rg_trirel#663563, rg_typoc#663554, rg_typorg#663522, rg_ville#663527]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codorg#663521)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codorg#663521)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typorg#663522)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_typorg#663522)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_nomorg#663523)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_nomorg#663523)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_1#663524)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_1#663524)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_2#663525)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_2#663525)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codpos#663526)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codpos#663526)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_ville#663527)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_ville#663527)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_telbur#663528)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_telbur#663528)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fax#663529)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fax#663529)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_e_mail#663530)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_e_mail#663530)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_prefix#663531)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_prefix#663531)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_contac#663532)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_contac#663532)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numbor#663533)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numbor#663533)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_tauxre#663534)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_tauxre#663534)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codreg#663535)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codreg#663535)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcai#663536)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcai#663536)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codcen#663537)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codcen#663537)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltele#663538)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltele#663538)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datmaj#663539)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datmaj#663539)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_coduti#663540)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_coduti#663540)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_codccp#663541)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_codccp#663541)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltp#663542)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltp#663542)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_idmut#663543)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_idmut#663543)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_fltopr#663544)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_fltopr#663544)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt#663545)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt#663545)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_f#663546)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_f#663546)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_cmpimp_h#663547)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_cmpimp_h#663547)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relctx#663548)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_relctx#663548)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relpage#663549)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_relpage#663549)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_relref#663550)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_relref#663550)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datenv#663551)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datenv#663551)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datede#663552)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datede#663552)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_datefi#663553)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_datefi#663553)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_typoc#663554)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_typoc#663554)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_orgpayeur#663555)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_orgpayeur#663555)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_adr_3#663556)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_adr_3#663556)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notrel#663557)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_notrel#663557)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_comment#663558)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_comment#663558)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpecdep#663559)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpecdep#663559)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_a#663560)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_a#663560)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flpav#663561)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flpav#663561)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_reclam#663562)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_reclam#663562)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_trirel#663563)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_trirel#663563)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_notbord#663564)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_notbord#663564)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flchorus#663565)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flchorus#663565)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numsir#663566)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numsir#663566)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_flliseng#663567)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_flliseng#663567)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_modreg#663568)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_modreg#663568)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c#663569)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c#663569)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(rg_numcpt_c_ft#663570)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(rg_numcpt_c_ft#663570)), 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#663871, rg_adr_1#663524 AS RG_ADR_1_437974#663872, rg_adr_2#663525 AS RG_ADR_2_437975#663873, rg_adr_3#663556 AS RG_ADR_3_438006#663874, rg_cmpimp_f#663546 AS RG_CMPIMP_F_437996#663875, rg_cmpimp_h#663547 AS RG_CMPIMP_H_437997#663876, rg_codcai#663536 AS RG_CODCAI_437986#663877, rg_codccp#663541 AS RG_CODCCP_437991#663878, rg_codcen#663537 AS RG_CODCEN_437987#663879, rg_codorg#663521 AS RG_CODORG_437971#663880, rg_codpos#663526 AS RG_CODPOS_437976#663881, rg_codreg#663535 AS RG_CODREG_437985#663882, rg_coduti#663540 AS RG_CODUTI_437990#663883, rg_comment#663558 AS RG_COMMENT_438008#663884, rg_contac#663532 AS RG_CONTAC_437982#663885, rg_datede#663552 AS RG_DATEDE_438002#663886, rg_datefi#663553 AS RG_DATEFI_438003#663887, rg_datenv#663551 AS RG_DATENV_438001#663888, rg_datmaj#663539 AS RG_DATMAJ_437989#663889, rg_e_mail#663530 AS RG_E_MAIL_437980#663890, rg_fax#663529 AS RG_FAX_437979#663891, rg_flchorus#663565 AS RG_FLCHORUS_438015#663892, rg_flliseng#663567 AS RG_FLLISENG_438017#663893, rg_flpav#663561 AS RG_FLPAV_438011#663894, rg_flpecdep#663559 AS RG_FLPECDEP_438009#663895, rg_fltele#663538 AS RG_FLTELE_437988#663896, rg_fltopr#663544 AS RG_FLTOPR_437994#663897, rg_fltp#663542 AS RG_FLTP_437992#663898, rg_idmut#663543 AS RG_IDMUT_437993#663899, rg_modreg#663568 AS RG_MODREG_438018#663900, rg_nomorg#663523 AS RG_NOMORG_437973#663901, rg_notbord#663564 AS RG_NOTBORD_438014#663902, rg_notrel#663557 AS RG_NOTREL_438007#663903, rg_numbor#663533 AS RG_NUMBOR_437983#663904, rg_numcpt#663545 AS RG_NUMCPT_437995#663905, rg_numcpt_a#663560 AS RG_NUMCPT_A_438010#663906, rg_numcpt_c#663569 AS RG_NUMCPT_C_438019#663907, rg_numcpt_c_ft#663570 AS RG_NUMCPT_C_FT_438020#663908, rg_numsir#663566 AS RG_NUMSIR_438016#663909, rg_orgpayeur#663555 AS RG_ORGPAYEUR_438005#663910, rg_prefix#663531 AS RG_PREFIX_437981#663911, rg_reclam#663562 AS RG_RECLAM_438012#663912, rg_relctx#663548 AS RG_RELCTX_437998#663913, rg_relpage#663549 AS RG_RELPAGE_437999#663914, rg_relref#663550 AS RG_RELREF_438000#663915, rg_tauxre#663534 AS RG_TAUXRE_437984#663916, rg_telbur#663528 AS RG_TELBUR_437978#663917, rg_trirel#663563 AS RG_TRIREL_438013#663918, rg_typoc#663554 AS RG_TYPOC_438004#663919, rg_typorg#663522 AS RG_TYPORG_437972#663920, rg_ville#663527 AS RG_VILLE_437977#663921]
Input [50]: [rg_adr_1#663524, rg_adr_2#663525, rg_adr_3#663556, rg_cmpimp_f#663546, rg_cmpimp_h#663547, rg_codcai#663536, rg_codccp#663541, rg_codcen#663537, rg_codorg#663521, rg_codpos#663526, rg_codreg#663535, rg_coduti#663540, rg_comment#663558, rg_contac#663532, rg_datede#663552, rg_datefi#663553, rg_datenv#663551, rg_datmaj#663539, rg_e_mail#663530, rg_fax#663529, rg_flchorus#663565, rg_flliseng#663567, rg_flpav#663561, rg_flpecdep#663559, rg_fltele#663538, rg_fltopr#663544, rg_fltp#663542, rg_idmut#663543, rg_modreg#663568, rg_nomorg#663523, rg_notbord#663564, rg_notrel#663557, rg_numbor#663533, rg_numcpt#663545, rg_numcpt_a#663560, rg_numcpt_c#663569, rg_numcpt_c_ft#663570, rg_numsir#663566, rg_orgpayeur#663555, rg_prefix#663531, rg_reclam#663562, rg_relctx#663548, rg_relpage#663549, rg_relref#663550, rg_tauxre#663534, rg_telbur#663528, rg_trirel#663563, rg_typoc#663554, rg_typorg#663522, rg_ville#663527]

(7) Union

(8) HashAggregate [codegen id : 3]
Input [51]: [ORIGINE_440148#663419, RG_ADR_1_437974#663420, RG_ADR_2_437975#663421, RG_ADR_3_438006#663422, RG_CMPIMP_F_437996#663423, RG_CMPIMP_H_437997#663424, RG_CODCAI_437986#663425, RG_CODCCP_437991#663426, RG_CODCEN_437987#663427, RG_CODORG_437971#663428, RG_CODPOS_437976#663429, RG_CODREG_437985#663430, RG_CODUTI_437990#663431, RG_COMMENT_438008#663432, RG_CONTAC_437982#663433, RG_DATEDE_438002#663434, RG_DATEFI_438003#663435, RG_DATENV_438001#663436, RG_DATMAJ_437989#663437, RG_E_MAIL_437980#663438, RG_FAX_437979#663439, RG_FLCHORUS_438015#663440, RG_FLLISENG_438017#663441, RG_FLPAV_438011#663442, RG_FLPECDEP_438009#663443, RG_FLTELE_437988#663444, RG_FLTOPR_437994#663445, RG_FLTP_437992#663446, RG_IDMUT_437993#663447, RG_MODREG_438018#663448, RG_NOMORG_437973#663449, RG_NOTBORD_438014#663450, RG_NOTREL_438007#663451, RG_NUMBOR_437983#663452, RG_NUMCPT_437995#663453, RG_NUMCPT_A_438010#663454, RG_NUMCPT_C_438019#663455, RG_NUMCPT_C_FT_438020#663456, RG_NUMSIR_438016#663457, RG_ORGPAYEUR_438005#663458, RG_PREFIX_437981#663459, RG_RECLAM_438012#663460, RG_RELCTX_437998#663461, RG_RELPAGE_437999#663462, RG_RELREF_438000#663463, RG_TAUXRE_437984#663464, RG_TELBUR_437978#663465, RG_TRIREL_438013#663466, RG_TYPOC_438004#663467, RG_TYPORG_437972#663468, RG_VILLE_437977#663469]
Keys [51]: [ORIGINE_440148#663419, RG_ADR_1_437974#663420, RG_ADR_2_437975#663421, RG_ADR_3_438006#663422, RG_CMPIMP_F_437996#663423, RG_CMPIMP_H_437997#663424, RG_CODCAI_437986#663425, RG_CODCCP_437991#663426, RG_CODCEN_437987#663427, RG_CODORG_437971#663428, RG_CODPOS_437976#663429, RG_CODREG_437985#663430, RG_CODUTI_437990#663431, RG_COMMENT_438008#663432, RG_CONTAC_437982#663433, RG_DATEDE_438002#663434, RG_DATEFI_438003#663435, RG_DATENV_438001#663436, RG_DATMAJ_437989#663437, RG_E_MAIL_437980#663438, RG_FAX_437979#663439, RG_FLCHORUS_438015#663440, RG_FLLISENG_438017#663441, RG_FLPAV_438011#663442, RG_FLPECDEP_438009#663443, RG_FLTELE_437988#663444, RG_FLTOPR_437994#663445, RG_FLTP_437992#663446, RG_IDMUT_437993#663447, RG_MODREG_438018#663448, RG_NOMORG_437973#663449, RG_NOTBORD_438014#663450, RG_NOTREL_438007#663451, RG_NUMBOR_437983#663452, RG_NUMCPT_437995#663453, RG_NUMCPT_A_438010#663454, RG_NUMCPT_C_438019#663455, RG_NUMCPT_C_FT_438020#663456, RG_NUMSIR_438016#663457, RG_ORGPAYEUR_438005#663458, RG_PREFIX_437981#663459, RG_RECLAM_438012#663460, RG_RELCTX_437998#663461, RG_RELPAGE_437999#663462, RG_RELREF_438000#663463, RG_TAUXRE_437984#663464, RG_TELBUR_437978#663465, RG_TRIREL_438013#663466, RG_TYPOC_438004#663467, RG_TYPORG_437972#663468, RG_VILLE_437977#663469]
Functions: []
Aggregate Attributes: []
Results [51]: [ORIGINE_440148#663419, RG_ADR_1_437974#663420, RG_ADR_2_437975#663421, RG_ADR_3_438006#663422, RG_CMPIMP_F_437996#663423, RG_CMPIMP_H_437997#663424, RG_CODCAI_437986#663425, RG_CODCCP_437991#663426, RG_CODCEN_437987#663427, RG_CODORG_437971#663428, RG_CODPOS_437976#663429, RG_CODREG_437985#663430, RG_CODUTI_437990#663431, RG_COMMENT_438008#663432, RG_CONTAC_437982#663433, RG_DATEDE_438002#663434, RG_DATEFI_438003#663435, RG_DATENV_438001#663436, RG_DATMAJ_437989#663437, RG_E_MAIL_437980#663438, RG_FAX_437979#663439, RG_FLCHORUS_438015#663440, RG_FLLISENG_438017#663441, RG_FLPAV_438011#663442, RG_FLPECDEP_438009#663443, RG_FLTELE_437988#663444, RG_FLTOPR_437994#663445, RG_FLTP_437992#663446, RG_IDMUT_437993#663447, RG_MODREG_438018#663448, RG_NOMORG_437973#663449, RG_NOTBORD_438014#663450, RG_NOTREL_438007#663451, RG_NUMBOR_437983#663452, RG_NUMCPT_437995#663453, RG_NUMCPT_A_438010#663454, RG_NUMCPT_C_438019#663455, RG_NUMCPT_C_FT_438020#663456, RG_NUMSIR_438016#663457, RG_ORGPAYEUR_438005#663458, RG_PREFIX_437981#663459, RG_RECLAM_438012#663460, RG_RELCTX_437998#663461, RG_RELPAGE_437999#663462, RG_RELREF_438000#663463, RG_TAUXRE_437984#663464, RG_TELBUR_437978#663465, RG_TRIREL_438013#663466, RG_TYPOC_438004#663467, RG_TYPORG_437972#663468, RG_VILLE_437977#663469]

(9) Exchange
Input [51]: [ORIGINE_440148#663419, RG_ADR_1_437974#663420, RG_ADR_2_437975#663421, RG_ADR_3_438006#663422, RG_CMPIMP_F_437996#663423, RG_CMPIMP_H_437997#663424, RG_CODCAI_437986#663425, RG_CODCCP_437991#663426, RG_CODCEN_437987#663427, RG_CODORG_437971#663428, RG_CODPOS_437976#663429, RG_CODREG_437985#663430, RG_CODUTI_437990#663431, RG_COMMENT_438008#663432, RG_CONTAC_437982#663433, RG_DATEDE_438002#663434, RG_DATEFI_438003#663435, RG_DATENV_438001#663436, RG_DATMAJ_437989#663437, RG_E_MAIL_437980#663438, RG_FAX_437979#663439, RG_FLCHORUS_438015#663440, RG_FLLISENG_438017#663441, RG_FLPAV_438011#663442, RG_FLPECDEP_438009#663443, RG_FLTELE_437988#663444, RG_FLTOPR_437994#663445, RG_FLTP_437992#663446, RG_IDMUT_437993#663447, RG_MODREG_438018#663448, RG_NOMORG_437973#663449, RG_NOTBORD_438014#663450, RG_NOTREL_438007#663451, RG_NUMBOR_437983#663452, RG_NUMCPT_437995#663453, RG_NUMCPT_A_438010#663454, RG_NUMCPT_C_438019#663455, RG_NUMCPT_C_FT_438020#663456, RG_NUMSIR_438016#663457, RG_ORGPAYEUR_438005#663458, RG_PREFIX_437981#663459, RG_RECLAM_438012#663460, RG_RELCTX_437998#663461, RG_RELPAGE_437999#663462, RG_RELREF_438000#663463, RG_TAUXRE_437984#663464, RG_TELBUR_437978#663465, RG_TRIREL_438013#663466, RG_TYPOC_438004#663467, RG_TYPORG_437972#663468, RG_VILLE_437977#663469]
Arguments: hashpartitioning(ORIGINE_440148#663419, RG_ADR_1_437974#663420, RG_ADR_2_437975#663421, RG_ADR_3_438006#663422, RG_CMPIMP_F_437996#663423, RG_CMPIMP_H_437997#663424, RG_CODCAI_437986#663425, RG_CODCCP_437991#663426, RG_CODCEN_437987#663427, RG_CODORG_437971#663428, RG_CODPOS_437976#663429, RG_CODREG_437985#663430, RG_CODUTI_437990#663431, RG_COMMENT_438008#663432, RG_CONTAC_437982#663433, RG_DATEDE_438002#663434, RG_DATEFI_438003#663435, RG_DATENV_438001#663436, RG_DATMAJ_437989#663437, RG_E_MAIL_437980#663438, RG_FAX_437979#663439, RG_FLCHORUS_438015#663440, RG_FLLISENG_438017#663441, RG_FLPAV_438011#663442, ... 28 more fields), ENSURE_REQUIREMENTS, [plan_id=35702]

(10) ShuffleQueryStage
Output [51]: [ORIGINE_440148#663419, RG_ADR_1_437974#663420, RG_ADR_2_437975#663421, RG_ADR_3_438006#663422, RG_CMPIMP_F_437996#663423, RG_CMPIMP_H_437997#663424, RG_CODCAI_437986#663425, RG_CODCCP_437991#663426, RG_CODCEN_437987#663427, RG_CODORG_437971#663428, RG_CODPOS_437976#663429, RG_CODREG_437985#663430, RG_CODUTI_437990#663431, RG_COMMENT_438008#663432, RG_CONTAC_437982#663433, RG_DATEDE_438002#663434, RG_DATEFI_438003#663435, RG_DATENV_438001#663436, RG_DATMAJ_437989#663437, RG_E_MAIL_437980#663438, RG_FAX_437979#663439, RG_FLCHORUS_438015#663440, RG_FLLISENG_438017#663441, RG_FLPAV_438011#663442, RG_FLPECDEP_438009#663443, RG_FLTELE_437988#663444, RG_FLTOPR_437994#663445, RG_FLTP_437992#663446, RG_IDMUT_437993#663447, RG_MODREG_438018#663448, RG_NOMORG_437973#663449, RG_NOTBORD_438014#663450, RG_NOTREL_438007#663451, RG_NUMBOR_437983#663452, RG_NUMCPT_437995#663453, RG_NUMCPT_A_438010#663454, RG_NUMCPT_C_438019#663455, RG_NUMCPT_C_FT_438020#663456, RG_NUMSIR_438016#663457, RG_ORGPAYEUR_438005#663458, RG_PREFIX_437981#663459, RG_RECLAM_438012#663460, RG_RELCTX_437998#663461, RG_RELPAGE_437999#663462, RG_RELREF_438000#663463, RG_TAUXRE_437984#663464, RG_TELBUR_437978#663465, RG_TRIREL_438013#663466, RG_TYPOC_438004#663467, RG_TYPORG_437972#663468, RG_VILLE_437977#663469]
Arguments: 0

(11) AQEShuffleRead
Input [51]: [ORIGINE_440148#663419, RG_ADR_1_437974#663420, RG_ADR_2_437975#663421, RG_ADR_3_438006#663422, RG_CMPIMP_F_437996#663423, RG_CMPIMP_H_437997#663424, RG_CODCAI_437986#663425, RG_CODCCP_437991#663426, RG_CODCEN_437987#663427, RG_CODORG_437971#663428, RG_CODPOS_437976#663429, RG_CODREG_437985#663430, RG_CODUTI_437990#663431, RG_COMMENT_438008#663432, RG_CONTAC_437982#663433, RG_DATEDE_438002#663434, RG_DATEFI_438003#663435, RG_DATENV_438001#663436, RG_DATMAJ_437989#663437, RG_E_MAIL_437980#663438, RG_FAX_437979#663439, RG_FLCHORUS_438015#663440, RG_FLLISENG_438017#663441, RG_FLPAV_438011#663442, RG_FLPECDEP_438009#663443, RG_FLTELE_437988#663444, RG_FLTOPR_437994#663445, RG_FLTP_437992#663446, RG_IDMUT_437993#663447, RG_MODREG_438018#663448, RG_NOMORG_437973#663449, RG_NOTBORD_438014#663450, RG_NOTREL_438007#663451, RG_NUMBOR_437983#663452, RG_NUMCPT_437995#663453, RG_NUMCPT_A_438010#663454, RG_NUMCPT_C_438019#663455, RG_NUMCPT_C_FT_438020#663456, RG_NUMSIR_438016#663457, RG_ORGPAYEUR_438005#663458, RG_PREFIX_437981#663459, RG_RECLAM_438012#663460, RG_RELCTX_437998#663461, RG_RELPAGE_437999#663462, RG_RELREF_438000#663463, RG_TAUXRE_437984#663464, RG_TELBUR_437978#663465, RG_TRIREL_438013#663466, RG_TYPOC_438004#663467, RG_TYPORG_437972#663468, RG_VILLE_437977#663469]
Arguments: coalesced

(12) HashAggregate [codegen id : 4]
Input [51]: [ORIGINE_440148#663419, RG_ADR_1_437974#663420, RG_ADR_2_437975#663421, RG_ADR_3_438006#663422, RG_CMPIMP_F_437996#663423, RG_CMPIMP_H_437997#663424, RG_CODCAI_437986#663425, RG_CODCCP_437991#663426, RG_CODCEN_437987#663427, RG_CODORG_437971#663428, RG_CODPOS_437976#663429, RG_CODREG_437985#663430, RG_CODUTI_437990#663431, RG_COMMENT_438008#663432, RG_CONTAC_437982#663433, RG_DATEDE_438002#663434, RG_DATEFI_438003#663435, RG_DATENV_438001#663436, RG_DATMAJ_437989#663437, RG_E_MAIL_437980#663438, RG_FAX_437979#663439, RG_FLCHORUS_438015#663440, RG_FLLISENG_438017#663441, RG_FLPAV_438011#663442, RG_FLPECDEP_438009#663443, RG_FLTELE_437988#663444, RG_FLTOPR_437994#663445, RG_FLTP_437992#663446, RG_IDMUT_437993#663447, RG_MODREG_438018#663448, RG_NOMORG_437973#663449, RG_NOTBORD_438014#663450, RG_NOTREL_438007#663451, RG_NUMBOR_437983#663452, RG_NUMCPT_437995#663453, RG_NUMCPT_A_438010#663454, RG_NUMCPT_C_438019#663455, RG_NUMCPT_C_FT_438020#663456, RG_NUMSIR_438016#663457, RG_ORGPAYEUR_438005#663458, RG_PREFIX_437981#663459, RG_RECLAM_438012#663460, RG_RELCTX_437998#663461, RG_RELPAGE_437999#663462, RG_RELREF_438000#663463, RG_TAUXRE_437984#663464, RG_TELBUR_437978#663465, RG_TRIREL_438013#663466, RG_TYPOC_438004#663467, RG_TYPORG_437972#663468, RG_VILLE_437977#663469]
Keys [51]: [ORIGINE_440148#663419, RG_ADR_1_437974#663420, RG_ADR_2_437975#663421, RG_ADR_3_438006#663422, RG_CMPIMP_F_437996#663423, RG_CMPIMP_H_437997#663424, RG_CODCAI_437986#663425, RG_CODCCP_437991#663426, RG_CODCEN_437987#663427, RG_CODORG_437971#663428, RG_CODPOS_437976#663429, RG_CODREG_437985#663430, RG_CODUTI_437990#663431, RG_COMMENT_438008#663432, RG_CONTAC_437982#663433, RG_DATEDE_438002#663434, RG_DATEFI_438003#663435, RG_DATENV_438001#663436, RG_DATMAJ_437989#663437, RG_E_MAIL_437980#663438, RG_FAX_437979#663439, RG_FLCHORUS_438015#663440, RG_FLLISENG_438017#663441, RG_FLPAV_438011#663442, RG_FLPECDEP_438009#663443, RG_FLTELE_437988#663444, RG_FLTOPR_437994#663445, RG_FLTP_437992#663446, RG_IDMUT_437993#663447, RG_MODREG_438018#663448, RG_NOMORG_437973#663449, RG_NOTBORD_438014#663450, RG_NOTREL_438007#663451, RG_NUMBOR_437983#663452, RG_NUMCPT_437995#663453, RG_NUMCPT_A_438010#663454, RG_NUMCPT_C_438019#663455, RG_NUMCPT_C_FT_438020#663456, RG_NUMSIR_438016#663457, RG_ORGPAYEUR_438005#663458, RG_PREFIX_437981#663459, RG_RECLAM_438012#663460, RG_RELCTX_437998#663461, RG_RELPAGE_437999#663462, RG_RELREF_438000#663463, RG_TAUXRE_437984#663464, RG_TELBUR_437978#663465, RG_TRIREL_438013#663466, RG_TYPOC_438004#663467, RG_TYPORG_437972#663468, RG_VILLE_437977#663469]
Functions: []
Aggregate Attributes: []
Results [51]: [RG_CODORG_437971#663428 AS COL_C00E8183_111C_40A4_B015_A94FB1A5395C#664483, RG_TYPORG_437972#663468 AS COL_69CDA2D0_D16C_4EC7_ABFF_28F9139D4F4A#664484, RG_NOMORG_437973#663449 AS COL_E38AFC5D_A2F9_4FD1_BD59_8B1F390527FF#664485, RG_ADR_1_437974#663420 AS COL_F97FE22E_0D69_46E9_97AC_EAFBBF424C71#664486, RG_ADR_2_437975#663421 AS COL_8C6519CD_44AE_40D8_A409_1A0E0CF4C924#664487, RG_CODPOS_437976#663429 AS COL_0A9A7CE6_75A6_4B0C_8F5C_A8AC2DB31448#664488, RG_VILLE_437977#663469 AS COL_FFE40BF9_CC2B_4F68_9D79_CC9EE3CF8948#664489, RG_TELBUR_437978#663465 AS COL_4ADE8D65_D56B_486C_B021_FE9EC88EF95A#664490, RG_FAX_437979#663439 AS COL_08E106B4_2940_42E3_B942_790C51B65F65#664491, RG_E_MAIL_437980#663438 AS COL_8A99378A_F04C_4BDC_BA06_A36F8EAC2EE0#664492, RG_PREFIX_437981#663459 AS COL_20676C18_9FB8_4A9E_B3F4_C4FEE63DFE47#664493, RG_CONTAC_437982#663433 AS COL_74EFC0BE_0F68_46EE_80E6_AF31BA246AC4#664494, RG_NUMBOR_437983#663452 AS COL_201B86EF_98F5_4ED9_9E23_776366005F48#664495, RG_TAUXRE_437984#663464 AS COL_B91F808E_261A_4308_A49B_F2752A149576#664496, RG_CODREG_437985#663430 AS COL_B3036F04_5F35_48EE_9089_E619CAD154C6#664497, RG_CODCAI_437986#663425 AS COL_9F21A599_53EC_4CE7_A883_7A51D7E4301D#664498, RG_CODCEN_437987#663427 AS COL_33096F15_B762_46DD_A25B_670513ACE3C5#664499, RG_FLTELE_437988#663444 AS COL_C9BBEB2E_F118_452D_869B_02CAD7743F0D#664500, RG_DATMAJ_437989#663437 AS COL_F87A4E1A_2F19_4C35_AC13_2568026403E1#664501, RG_CODUTI_437990#663431 AS COL_539F4C9A_E116_4977_8B76_62FB615C947C#664502, RG_CODCCP_437991#663426 AS COL_79855230_B1E0_491F_A45A_F37ECBF41242#664503, RG_FLTP_437992#663446 AS COL_10DBAD46_E273_4929_8A69_4E1E99069790#664504, RG_IDMUT_437993#663447 AS COL_E78A5682_3177_48E0_8A77_8A15285BB20C#664505, RG_FLTOPR_437994#663445 AS COL_7048CAAD_E972_4F65_AC27_B4393C25D498#664506, RG_NUMCPT_437995#663453 AS COL_22773230_8570_4A72_BAC5_49FFB68200F2#664507, RG_CMPIMP_F_437996#663423 AS COL_3948AC99_E60F_4A25_A40A_E794678761FF#664508, RG_CMPIMP_H_437997#663424 AS COL_56B779CD_3414_4AEA_BD6A_B42C7E475239#664509, RG_RELCTX_437998#663461 AS COL_BEB1DB1C_8059_4CE0_972C_40125139A79D#664510, RG_RELPAGE_437999#663462 AS COL_9585C1E0_177F_43B8_A2C0_9A80C017C190#664511, RG_RELREF_438000#663463 AS COL_50DC0C78_DBF2_432F_812B_4D0FFA58736D#664512, RG_DATENV_438001#663436 AS COL_3CCDFDA8_299D_47C5_95CD_1E8CF4CE6C13#664513, RG_DATEDE_438002#663434 AS COL_8A9C2666_5BE3_42D2_BF11_4F49B9EFA565#664514, RG_DATEFI_438003#663435 AS COL_17D848AF_8CFA_4999_B5E0_6245E7AAD448#664515, RG_TYPOC_438004#663467 AS COL_C3C71073_DF13_418C_9A86_BACD8BB200B6#664516, RG_ORGPAYEUR_438005#663458 AS COL_FB2B43B3_6905_4FE0_A887_88F8D18038FA#664517, RG_ADR_3_438006#663422 AS COL_FD45FEAD_FD95_425C_A586_5065ECDF27B4#664518, RG_NOTREL_438007#663451 AS COL_22DF0050_26F2_4150_AF52_D90995353F29#664519, RG_COMMENT_438008#663432 AS COL_A76F2BD9_F3BD_4289_A618_986758A05F0A#664520, RG_FLPECDEP_438009#663443 AS COL_54295B2F_FC39_45D7_8519_CC66F3C14F0D#664521, RG_NUMCPT_A_438010#663454 AS COL_290767AD_A425_41EC_A3C2_480CF9583A13#664522, RG_FLPAV_438011#663442 AS COL_0C8E0A48_0B78_4B6B_B14A_970509B53157#664523, RG_RECLAM_438012#663460 AS COL_89187499_B5E5_4203_BF6D_92E098A2C555#664524, RG_TRIREL_438013#663466 AS COL_0CBE6A73_01E6_4926_90E0_27EF8A2874E9#664525, RG_NOTBORD_438014#663450 AS COL_A60EB66A_CAD1_4A45_AA61_7BF7D8C7A250#664526, RG_FLCHORUS_438015#663440 AS COL_E1C72EB5_CD33_4C3B_9A0B_5570CE608E3B#664527, RG_NUMSIR_438016#663457 AS COL_222A6BE2_A286_4856_9E3A_49F4FB7DF7AC#664528, RG_FLLISENG_438017#663441 AS COL_5723FB1D_B73B_4F09_ABC8_D901C3DC3F7D#664529, RG_MODREG_438018#663448 AS COL_206C5765_CA0D_4FA2_B228_47A5CBB59C35#664530, RG_NUMCPT_C_438019#663455 AS COL_D3D15F9C_21DB_4652_BF9C_9849FD1CCB20#664531, RG_NUMCPT_C_FT_438020#663456 AS COL_A4E578BB_9B61_4B86_9430_A4B545D39EB6#664532, ORIGINE_440148#663419 AS COL_46E43C71_3FF1_4308_AC89_2DD0FA18B7FA#664533]

(13) Union

(14) HashAggregate
Input [51]: [ORIGINE_440148#663419, RG_ADR_1_437974#663420, RG_ADR_2_437975#663421, RG_ADR_3_438006#663422, RG_CMPIMP_F_437996#663423, RG_CMPIMP_H_437997#663424, RG_CODCAI_437986#663425, RG_CODCCP_437991#663426, RG_CODCEN_437987#663427, RG_CODORG_437971#663428, RG_CODPOS_437976#663429, RG_CODREG_437985#663430, RG_CODUTI_437990#663431, RG_COMMENT_438008#663432, RG_CONTAC_437982#663433, RG_DATEDE_438002#663434, RG_DATEFI_438003#663435, RG_DATENV_438001#663436, RG_DATMAJ_437989#663437, RG_E_MAIL_437980#663438, RG_FAX_437979#663439, RG_FLCHORUS_438015#663440, RG_FLLISENG_438017#663441, RG_FLPAV_438011#663442, RG_FLPECDEP_438009#663443, RG_FLTELE_437988#663444, RG_FLTOPR_437994#663445, RG_FLTP_437992#663446, RG_IDMUT_437993#663447, RG_MODREG_438018#663448, RG_NOMORG_437973#663449, RG_NOTBORD_438014#663450, RG_NOTREL_438007#663451, RG_NUMBOR_437983#663452, RG_NUMCPT_437995#663453, RG_NUMCPT_A_438010#663454, RG_NUMCPT_C_438019#663455, RG_NUMCPT_C_FT_438020#663456, RG_NUMSIR_438016#663457, RG_ORGPAYEUR_438005#663458, RG_PREFIX_437981#663459, RG_RECLAM_438012#663460, RG_RELCTX_437998#663461, RG_RELPAGE_437999#663462, RG_RELREF_438000#663463, RG_TAUXRE_437984#663464, RG_TELBUR_437978#663465, RG_TRIREL_438013#663466, RG_TYPOC_438004#663467, RG_TYPORG_437972#663468, RG_VILLE_437977#663469]
Keys [51]: [ORIGINE_440148#663419, RG_ADR_1_437974#663420, RG_ADR_2_437975#663421, RG_ADR_3_438006#663422, RG_CMPIMP_F_437996#663423, RG_CMPIMP_H_437997#663424, RG_CODCAI_437986#663425, RG_CODCCP_437991#663426, RG_CODCEN_437987#663427, RG_CODORG_437971#663428, RG_CODPOS_437976#663429, RG_CODREG_437985#663430, RG_CODUTI_437990#663431, RG_COMMENT_438008#663432, RG_CONTAC_437982#663433, RG_DATEDE_438002#663434, RG_DATEFI_438003#663435, RG_DATENV_438001#663436, RG_DATMAJ_437989#663437, RG_E_MAIL_437980#663438, RG_FAX_437979#663439, RG_FLCHORUS_438015#663440, RG_FLLISENG_438017#663441, RG_FLPAV_438011#663442, RG_FLPECDEP_438009#663443, RG_FLTELE_437988#663444, RG_FLTOPR_437994#663445, RG_FLTP_437992#663446, RG_IDMUT_437993#663447, RG_MODREG_438018#663448, RG_NOMORG_437973#663449, RG_NOTBORD_438014#663450, RG_NOTREL_438007#663451, RG_NUMBOR_437983#663452, RG_NUMCPT_437995#663453, RG_NUMCPT_A_438010#663454, RG_NUMCPT_C_438019#663455, RG_NUMCPT_C_FT_438020#663456, RG_NUMSIR_438016#663457, RG_ORGPAYEUR_438005#663458, RG_PREFIX_437981#663459, RG_RECLAM_438012#663460, RG_RELCTX_437998#663461, RG_RELPAGE_437999#663462, RG_RELREF_438000#663463, RG_TAUXRE_437984#663464, RG_TELBUR_437978#663465, RG_TRIREL_438013#663466, RG_TYPOC_438004#663467, RG_TYPORG_437972#663468, RG_VILLE_437977#663469]
Functions: []
Aggregate Attributes: []
Results [51]: [ORIGINE_440148#663419, RG_ADR_1_437974#663420, RG_ADR_2_437975#663421, RG_ADR_3_438006#663422, RG_CMPIMP_F_437996#663423, RG_CMPIMP_H_437997#663424, RG_CODCAI_437986#663425, RG_CODCCP_437991#663426, RG_CODCEN_437987#663427, RG_CODORG_437971#663428, RG_CODPOS_437976#663429, RG_CODREG_437985#663430, RG_CODUTI_437990#663431, RG_COMMENT_438008#663432, RG_CONTAC_437982#663433, RG_DATEDE_438002#663434, RG_DATEFI_438003#663435, RG_DATENV_438001#663436, RG_DATMAJ_437989#663437, RG_E_MAIL_437980#663438, RG_FAX_437979#663439, RG_FLCHORUS_438015#663440, RG_FLLISENG_438017#663441, RG_FLPAV_438011#663442, RG_FLPECDEP_438009#663443, RG_FLTELE_437988#663444, RG_FLTOPR_437994#663445, RG_FLTP_437992#663446, RG_IDMUT_437993#663447, RG_MODREG_438018#663448, RG_NOMORG_437973#663449, RG_NOTBORD_438014#663450, RG_NOTREL_438007#663451, RG_NUMBOR_437983#663452, RG_NUMCPT_437995#663453, RG_NUMCPT_A_438010#663454, RG_NUMCPT_C_438019#663455, RG_NUMCPT_C_FT_438020#663456, RG_NUMSIR_438016#663457, RG_ORGPAYEUR_438005#663458, RG_PREFIX_437981#663459, RG_RECLAM_438012#663460, RG_RELCTX_437998#663461, RG_RELPAGE_437999#663462, RG_RELREF_438000#663463, RG_TAUXRE_437984#663464, RG_TELBUR_437978#663465, RG_TRIREL_438013#663466, RG_TYPOC_438004#663467, RG_TYPORG_437972#663468, RG_VILLE_437977#663469]

(15) Exchange
Input [51]: [ORIGINE_440148#663419, RG_ADR_1_437974#663420, RG_ADR_2_437975#663421, RG_ADR_3_438006#663422, RG_CMPIMP_F_437996#663423, RG_CMPIMP_H_437997#663424, RG_CODCAI_437986#663425, RG_CODCCP_437991#663426, RG_CODCEN_437987#663427, RG_CODORG_437971#663428, RG_CODPOS_437976#663429, RG_CODREG_437985#663430, RG_CODUTI_437990#663431, RG_COMMENT_438008#663432, RG_CONTAC_437982#663433, RG_DATEDE_438002#663434, RG_DATEFI_438003#663435, RG_DATENV_438001#663436, RG_DATMAJ_437989#663437, RG_E_MAIL_437980#663438, RG_FAX_437979#663439, RG_FLCHORUS_438015#663440, RG_FLLISENG_438017#663441, RG_FLPAV_438011#663442, RG_FLPECDEP_438009#663443, RG_FLTELE_437988#663444, RG_FLTOPR_437994#663445, RG_FLTP_437992#663446, RG_IDMUT_437993#663447, RG_MODREG_438018#663448, RG_NOMORG_437973#663449, RG_NOTBORD_438014#663450, RG_NOTREL_438007#663451, RG_NUMBOR_437983#663452, RG_NUMCPT_437995#663453, RG_NUMCPT_A_438010#663454, RG_NUMCPT_C_438019#663455, RG_NUMCPT_C_FT_438020#663456, RG_NUMSIR_438016#663457, RG_ORGPAYEUR_438005#663458, RG_PREFIX_437981#663459, RG_RECLAM_438012#663460, RG_RELCTX_437998#663461, RG_RELPAGE_437999#663462, RG_RELREF_438000#663463, RG_TAUXRE_437984#663464, RG_TELBUR_437978#663465, RG_TRIREL_438013#663466, RG_TYPOC_438004#663467, RG_TYPORG_437972#663468, RG_VILLE_437977#663469]
Arguments: hashpartitioning(ORIGINE_440148#663419, RG_ADR_1_437974#663420, RG_ADR_2_437975#663421, RG_ADR_3_438006#663422, RG_CMPIMP_F_437996#663423, RG_CMPIMP_H_437997#663424, RG_CODCAI_437986#663425, RG_CODCCP_437991#663426, RG_CODCEN_437987#663427, RG_CODORG_437971#663428, RG_CODPOS_437976#663429, RG_CODREG_437985#663430, RG_CODUTI_437990#663431, RG_COMMENT_438008#663432, RG_CONTAC_437982#663433, RG_DATEDE_438002#663434, RG_DATEFI_438003#663435, RG_DATENV_438001#663436, RG_DATMAJ_437989#663437, RG_E_MAIL_437980#663438, RG_FAX_437979#663439, RG_FLCHORUS_438015#663440, RG_FLLISENG_438017#663441, RG_FLPAV_438011#663442, ... 28 more fields), ENSURE_REQUIREMENTS, [plan_id=35678]

(16) HashAggregate
Input [51]: [ORIGINE_440148#663419, RG_ADR_1_437974#663420, RG_ADR_2_437975#663421, RG_ADR_3_438006#663422, RG_CMPIMP_F_437996#663423, RG_CMPIMP_H_437997#663424, RG_CODCAI_437986#663425, RG_CODCCP_437991#663426, RG_CODCEN_437987#663427, RG_CODORG_437971#663428, RG_CODPOS_437976#663429, RG_CODREG_437985#663430, RG_CODUTI_437990#663431, RG_COMMENT_438008#663432, RG_CONTAC_437982#663433, RG_DATEDE_438002#663434, RG_DATEFI_438003#663435, RG_DATENV_438001#663436, RG_DATMAJ_437989#663437, RG_E_MAIL_437980#663438, RG_FAX_437979#663439, RG_FLCHORUS_438015#663440, RG_FLLISENG_438017#663441, RG_FLPAV_438011#663442, RG_FLPECDEP_438009#663443, RG_FLTELE_437988#663444, RG_FLTOPR_437994#663445, RG_FLTP_437992#663446, RG_IDMUT_437993#663447, RG_MODREG_438018#663448, RG_NOMORG_437973#663449, RG_NOTBORD_438014#663450, RG_NOTREL_438007#663451, RG_NUMBOR_437983#663452, RG_NUMCPT_437995#663453, RG_NUMCPT_A_438010#663454, RG_NUMCPT_C_438019#663455, RG_NUMCPT_C_FT_438020#663456, RG_NUMSIR_438016#663457, RG_ORGPAYEUR_438005#663458, RG_PREFIX_437981#663459, RG_RECLAM_438012#663460, RG_RELCTX_437998#663461, RG_RELPAGE_437999#663462, RG_RELREF_438000#663463, RG_TAUXRE_437984#663464, RG_TELBUR_437978#663465, RG_TRIREL_438013#663466, RG_TYPOC_438004#663467, RG_TYPORG_437972#663468, RG_VILLE_437977#663469]
Keys [51]: [ORIGINE_440148#663419, RG_ADR_1_437974#663420, RG_ADR_2_437975#663421, RG_ADR_3_438006#663422, RG_CMPIMP_F_437996#663423, RG_CMPIMP_H_437997#663424, RG_CODCAI_437986#663425, RG_CODCCP_437991#663426, RG_CODCEN_437987#663427, RG_CODORG_437971#663428, RG_CODPOS_437976#663429, RG_CODREG_437985#663430, RG_CODUTI_437990#663431, RG_COMMENT_438008#663432, RG_CONTAC_437982#663433, RG_DATEDE_438002#663434, RG_DATEFI_438003#663435, RG_DATENV_438001#663436, RG_DATMAJ_437989#663437, RG_E_MAIL_437980#663438, RG_FAX_437979#663439, RG_FLCHORUS_438015#663440, RG_FLLISENG_438017#663441, RG_FLPAV_438011#663442, RG_FLPECDEP_438009#663443, RG_FLTELE_437988#663444, RG_FLTOPR_437994#663445, RG_FLTP_437992#663446, RG_IDMUT_437993#663447, RG_MODREG_438018#663448, RG_NOMORG_437973#663449, RG_NOTBORD_438014#663450, RG_NOTREL_438007#663451, RG_NUMBOR_437983#663452, RG_NUMCPT_437995#663453, RG_NUMCPT_A_438010#663454, RG_NUMCPT_C_438019#663455, RG_NUMCPT_C_FT_438020#663456, RG_NUMSIR_438016#663457, RG_ORGPAYEUR_438005#663458, RG_PREFIX_437981#663459, RG_RECLAM_438012#663460, RG_RELCTX_437998#663461, RG_RELPAGE_437999#663462, RG_RELREF_438000#663463, RG_TAUXRE_437984#663464, RG_TELBUR_437978#663465, RG_TRIREL_438013#663466, RG_TYPOC_438004#663467, RG_TYPORG_437972#663468, RG_VILLE_437977#663469]
Functions: []
Aggregate Attributes: []
Results [51]: [RG_CODORG_437971#663428 AS COL_C00E8183_111C_40A4_B015_A94FB1A5395C#664483, RG_TYPORG_437972#663468 AS COL_69CDA2D0_D16C_4EC7_ABFF_28F9139D4F4A#664484, RG_NOMORG_437973#663449 AS COL_E38AFC5D_A2F9_4FD1_BD59_8B1F390527FF#664485, RG_ADR_1_437974#663420 AS COL_F97FE22E_0D69_46E9_97AC_EAFBBF424C71#664486, RG_ADR_2_437975#663421 AS COL_8C6519CD_44AE_40D8_A409_1A0E0CF4C924#664487, RG_CODPOS_437976#663429 AS COL_0A9A7CE6_75A6_4B0C_8F5C_A8AC2DB31448#664488, RG_VILLE_437977#663469 AS COL_FFE40BF9_CC2B_4F68_9D79_CC9EE3CF8948#664489, RG_TELBUR_437978#663465 AS COL_4ADE8D65_D56B_486C_B021_FE9EC88EF95A#664490, RG_FAX_437979#663439 AS COL_08E106B4_2940_42E3_B942_790C51B65F65#664491, RG_E_MAIL_437980#663438 AS COL_8A99378A_F04C_4BDC_BA06_A36F8EAC2EE0#664492, RG_PREFIX_437981#663459 AS COL_20676C18_9FB8_4A9E_B3F4_C4FEE63DFE47#664493, RG_CONTAC_437982#663433 AS COL_74EFC0BE_0F68_46EE_80E6_AF31BA246AC4#664494, RG_NUMBOR_437983#663452 AS COL_201B86EF_98F5_4ED9_9E23_776366005F48#664495, RG_TAUXRE_437984#663464 AS COL_B91F808E_261A_4308_A49B_F2752A149576#664496, RG_CODREG_437985#663430 AS COL_B3036F04_5F35_48EE_9089_E619CAD154C6#664497, RG_CODCAI_437986#663425 AS COL_9F21A599_53EC_4CE7_A883_7A51D7E4301D#664498, RG_CODCEN_437987#663427 AS COL_33096F15_B762_46DD_A25B_670513ACE3C5#664499, RG_FLTELE_437988#663444 AS COL_C9BBEB2E_F118_452D_869B_02CAD7743F0D#664500, RG_DATMAJ_437989#663437 AS COL_F87A4E1A_2F19_4C35_AC13_2568026403E1#664501, RG_CODUTI_437990#663431 AS COL_539F4C9A_E116_4977_8B76_62FB615C947C#664502, RG_CODCCP_437991#663426 AS COL_79855230_B1E0_491F_A45A_F37ECBF41242#664503, RG_FLTP_437992#663446 AS COL_10DBAD46_E273_4929_8A69_4E1E99069790#664504, RG_IDMUT_437993#663447 AS COL_E78A5682_3177_48E0_8A77_8A15285BB20C#664505, RG_FLTOPR_437994#663445 AS COL_7048CAAD_E972_4F65_AC27_B4393C25D498#664506, RG_NUMCPT_437995#663453 AS COL_22773230_8570_4A72_BAC5_49FFB68200F2#664507, RG_CMPIMP_F_437996#663423 AS COL_3948AC99_E60F_4A25_A40A_E794678761FF#664508, RG_CMPIMP_H_437997#663424 AS COL_56B779CD_3414_4AEA_BD6A_B42C7E475239#664509, RG_RELCTX_437998#663461 AS COL_BEB1DB1C_8059_4CE0_972C_40125139A79D#664510, RG_RELPAGE_437999#663462 AS COL_9585C1E0_177F_43B8_A2C0_9A80C017C190#664511, RG_RELREF_438000#663463 AS COL_50DC0C78_DBF2_432F_812B_4D0FFA58736D#664512, RG_DATENV_438001#663436 AS COL_3CCDFDA8_299D_47C5_95CD_1E8CF4CE6C13#664513, RG_DATEDE_438002#663434 AS COL_8A9C2666_5BE3_42D2_BF11_4F49B9EFA565#664514, RG_DATEFI_438003#663435 AS COL_17D848AF_8CFA_4999_B5E0_6245E7AAD448#664515, RG_TYPOC_438004#663467 AS COL_C3C71073_DF13_418C_9A86_BACD8BB200B6#664516, RG_ORGPAYEUR_438005#663458 AS COL_FB2B43B3_6905_4FE0_A887_88F8D18038FA#664517, RG_ADR_3_438006#663422 AS COL_FD45FEAD_FD95_425C_A586_5065ECDF27B4#664518, RG_NOTREL_438007#663451 AS COL_22DF0050_26F2_4150_AF52_D90995353F29#664519, RG_COMMENT_438008#663432 AS COL_A76F2BD9_F3BD_4289_A618_986758A05F0A#664520, RG_FLPECDEP_438009#663443 AS COL_54295B2F_FC39_45D7_8519_CC66F3C14F0D#664521, RG_NUMCPT_A_438010#663454 AS COL_290767AD_A425_41EC_A3C2_480CF9583A13#664522, RG_FLPAV_438011#663442 AS COL_0C8E0A48_0B78_4B6B_B14A_970509B53157#664523, RG_RECLAM_438012#663460 AS COL_89187499_B5E5_4203_BF6D_92E098A2C555#664524, RG_TRIREL_438013#663466 AS COL_0CBE6A73_01E6_4926_90E0_27EF8A2874E9#664525, RG_NOTBORD_438014#663450 AS COL_A60EB66A_CAD1_4A45_AA61_7BF7D8C7A250#664526, RG_FLCHORUS_438015#663440 AS COL_E1C72EB5_CD33_4C3B_9A0B_5570CE608E3B#664527, RG_NUMSIR_438016#663457 AS COL_222A6BE2_A286_4856_9E3A_49F4FB7DF7AC#664528, RG_FLLISENG_438017#663441 AS COL_5723FB1D_B73B_4F09_ABC8_D901C3DC3F7D#664529, RG_MODREG_438018#663448 AS COL_206C5765_CA0D_4FA2_B228_47A5CBB59C35#664530, RG_NUMCPT_C_438019#663455 AS COL_D3D15F9C_21DB_4652_BF9C_9849FD1CCB20#664531, RG_NUMCPT_C_FT_438020#663456 AS COL_A4E578BB_9B61_4B86_9430_A4B545D39EB6#664532, ORIGINE_440148#663419 AS COL_46E43C71_3FF1_4308_AC89_2DD0FA18B7FA#664533]

(17) CollectLimit
Input [51]: [COL_C00E8183_111C_40A4_B015_A94FB1A5395C#664483, COL_69CDA2D0_D16C_4EC7_ABFF_28F9139D4F4A#664484, COL_E38AFC5D_A2F9_4FD1_BD59_8B1F390527FF#664485, COL_F97FE22E_0D69_46E9_97AC_EAFBBF424C71#664486, COL_8C6519CD_44AE_40D8_A409_1A0E0CF4C924#664487, COL_0A9A7CE6_75A6_4B0C_8F5C_A8AC2DB31448#664488, COL_FFE40BF9_CC2B_4F68_9D79_CC9EE3CF8948#664489, COL_4ADE8D65_D56B_486C_B021_FE9EC88EF95A#664490, COL_08E106B4_2940_42E3_B942_790C51B65F65#664491, COL_8A99378A_F04C_4BDC_BA06_A36F8EAC2EE0#664492, COL_20676C18_9FB8_4A9E_B3F4_C4FEE63DFE47#664493, COL_74EFC0BE_0F68_46EE_80E6_AF31BA246AC4#664494, COL_201B86EF_98F5_4ED9_9E23_776366005F48#664495, COL_B91F808E_261A_4308_A49B_F2752A149576#664496, COL_B3036F04_5F35_48EE_9089_E619CAD154C6#664497, COL_9F21A599_53EC_4CE7_A883_7A51D7E4301D#664498, COL_33096F15_B762_46DD_A25B_670513ACE3C5#664499, COL_C9BBEB2E_F118_452D_869B_02CAD7743F0D#664500, COL_F87A4E1A_2F19_4C35_AC13_2568026403E1#664501, COL_539F4C9A_E116_4977_8B76_62FB615C947C#664502, COL_79855230_B1E0_491F_A45A_F37ECBF41242#664503, COL_10DBAD46_E273_4929_8A69_4E1E99069790#664504, COL_E78A5682_3177_48E0_8A77_8A15285BB20C#664505, COL_7048CAAD_E972_4F65_AC27_B4393C25D498#664506, COL_22773230_8570_4A72_BAC5_49FFB68200F2#664507, COL_3948AC99_E60F_4A25_A40A_E794678761FF#664508, COL_56B779CD_3414_4AEA_BD6A_B42C7E475239#664509, COL_BEB1DB1C_8059_4CE0_972C_40125139A79D#664510, COL_9585C1E0_177F_43B8_A2C0_9A80C017C190#664511, COL_50DC0C78_DBF2_432F_812B_4D0FFA58736D#664512, COL_3CCDFDA8_299D_47C5_95CD_1E8CF4CE6C13#664513, COL_8A9C2666_5BE3_42D2_BF11_4F49B9EFA565#664514, COL_17D848AF_8CFA_4999_B5E0_6245E7AAD448#664515, COL_C3C71073_DF13_418C_9A86_BACD8BB200B6#664516, COL_FB2B43B3_6905_4FE0_A887_88F8D18038FA#664517, COL_FD45FEAD_FD95_425C_A586_5065ECDF27B4#664518, COL_22DF0050_26F2_4150_AF52_D90995353F29#664519, COL_A76F2BD9_F3BD_4289_A618_986758A05F0A#664520, COL_54295B2F_FC39_45D7_8519_CC66F3C14F0D#664521, COL_290767AD_A425_41EC_A3C2_480CF9583A13#664522, COL_0C8E0A48_0B78_4B6B_B14A_970509B53157#664523, COL_89187499_B5E5_4203_BF6D_92E098A2C555#664524, COL_0CBE6A73_01E6_4926_90E0_27EF8A2874E9#664525, COL_A60EB66A_CAD1_4A45_AA61_7BF7D8C7A250#664526, COL_E1C72EB5_CD33_4C3B_9A0B_5570CE608E3B#664527, COL_222A6BE2_A286_4856_9E3A_49F4FB7DF7AC#664528, COL_5723FB1D_B73B_4F09_ABC8_D901C3DC3F7D#664529, COL_206C5765_CA0D_4FA2_B228_47A5CBB59C35#664530, COL_D3D15F9C_21DB_4652_BF9C_9849FD1CCB20#664531, COL_A4E578BB_9B61_4B86_9430_A4B545D39EB6#664532, COL_46E43C71_3FF1_4308_AC89_2DD0FA18B7FA#664533]
Arguments: 1500

(18) AdaptiveSparkPlan
Output [51]: [COL_C00E8183_111C_40A4_B015_A94FB1A5395C#664483, COL_69CDA2D0_D16C_4EC7_ABFF_28F9139D4F4A#664484, COL_E38AFC5D_A2F9_4FD1_BD59_8B1F390527FF#664485, COL_F97FE22E_0D69_46E9_97AC_EAFBBF424C71#664486, COL_8C6519CD_44AE_40D8_A409_1A0E0CF4C924#664487, COL_0A9A7CE6_75A6_4B0C_8F5C_A8AC2DB31448#664488, COL_FFE40BF9_CC2B_4F68_9D79_CC9EE3CF8948#664489, COL_4ADE8D65_D56B_486C_B021_FE9EC88EF95A#664490, COL_08E106B4_2940_42E3_B942_790C51B65F65#664491, COL_8A99378A_F04C_4BDC_BA06_A36F8EAC2EE0#664492, COL_20676C18_9FB8_4A9E_B3F4_C4FEE63DFE47#664493, COL_74EFC0BE_0F68_46EE_80E6_AF31BA246AC4#664494, COL_201B86EF_98F5_4ED9_9E23_776366005F48#664495, COL_B91F808E_261A_4308_A49B_F2752A149576#664496, COL_B3036F04_5F35_48EE_9089_E619CAD154C6#664497, COL_9F21A599_53EC_4CE7_A883_7A51D7E4301D#664498, COL_33096F15_B762_46DD_A25B_670513ACE3C5#664499, COL_C9BBEB2E_F118_452D_869B_02CAD7743F0D#664500, COL_F87A4E1A_2F19_4C35_AC13_2568026403E1#664501, COL_539F4C9A_E116_4977_8B76_62FB615C947C#664502, COL_79855230_B1E0_491F_A45A_F37ECBF41242#664503, COL_10DBAD46_E273_4929_8A69_4E1E99069790#664504, COL_E78A5682_3177_48E0_8A77_8A15285BB20C#664505, COL_7048CAAD_E972_4F65_AC27_B4393C25D498#664506, COL_22773230_8570_4A72_BAC5_49FFB68200F2#664507, COL_3948AC99_E60F_4A25_A40A_E794678761FF#664508, COL_56B779CD_3414_4AEA_BD6A_B42C7E475239#664509, COL_BEB1DB1C_8059_4CE0_972C_40125139A79D#664510, COL_9585C1E0_177F_43B8_A2C0_9A80C017C190#664511, COL_50DC0C78_DBF2_432F_812B_4D0FFA58736D#664512, COL_3CCDFDA8_299D_47C5_95CD_1E8CF4CE6C13#664513, COL_8A9C2666_5BE3_42D2_BF11_4F49B9EFA565#664514, COL_17D848AF_8CFA_4999_B5E0_6245E7AAD448#664515, COL_C3C71073_DF13_418C_9A86_BACD8BB200B6#664516, COL_FB2B43B3_6905_4FE0_A887_88F8D18038FA#664517, COL_FD45FEAD_FD95_425C_A586_5065ECDF27B4#664518, COL_22DF0050_26F2_4150_AF52_D90995353F29#664519, COL_A76F2BD9_F3BD_4289_A618_986758A05F0A#664520, COL_54295B2F_FC39_45D7_8519_CC66F3C14F0D#664521, COL_290767AD_A425_41EC_A3C2_480CF9583A13#664522, COL_0C8E0A48_0B78_4B6B_B14A_970509B53157#664523, COL_89187499_B5E5_4203_BF6D_92E098A2C555#664524, COL_0CBE6A73_01E6_4926_90E0_27EF8A2874E9#664525, COL_A60EB66A_CAD1_4A45_AA61_7BF7D8C7A250#664526, COL_E1C72EB5_CD33_4C3B_9A0B_5570CE608E3B#664527, COL_222A6BE2_A286_4856_9E3A_49F4FB7DF7AC#664528, COL_5723FB1D_B73B_4F09_ABC8_D901C3DC3F7D#664529, COL_206C5765_CA0D_4FA2_B228_47A5CBB59C35#664530, COL_D3D15F9C_21DB_4652_BF9C_9849FD1CCB20#664531, COL_A4E578BB_9B61_4B86_9430_A4B545D39EB6#664532, COL_46E43C71_3FF1_4308_AC89_2DD0FA18B7FA#664533]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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