hdh-spark-job - Details for Query 1084

Submitted Time: 2026/10/23 08:14:43
Duration: 0.7 s
Succeeded Jobs: 1091 1092 1093

Show the Stage ID and Task ID that corresponds to the max metric

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; subgraph cluster1 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 0 ms"; 2 [labelType="html" label="HashAggregate time in aggregation build: 0 ms number of output rows: 1"]; } 3 [labelType="html" label="Exchange shuffle records written: 1 local merged chunks fetched: 0 shuffle write time: 0 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 1 local bytes read: 59.0 B fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 16.0 B local merged bytes read: 0.0 B number of partitions: 1 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 59.0 B"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 70 ms"; 5 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 70 ms peak memory: 0.0 B number of output rows: 1 number of sort fallback tasks: 0 avg hash probes per key: 0"]; 6 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 62 ms peak memory: 64.2 MiB number of output rows: 6,195 number of sort fallback tasks: 0 avg hash probes per key: 1.2"]; } 7 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 1073.2 KiB number of coalesced partitions: 1"]; 8 [labelType="html" label="Exchange shuffle records written: 12,390 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 5 ms (2 ms, 3 ms, 3 ms (stage 1474.0: task 1327)) 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: 12,390 local bytes read: 1021.2 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 2 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 7.1 MiB (3.6 MiB, 3.6 MiB, 3.6 MiB (stage 1474.0: task 1327)) 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)) 1021.2 KiB (510.6 KiB, 510.6 KiB, 510.6 KiB (stage 1474.0: task 1327))"]; subgraph cluster9 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n453 ms (224 ms, 229 ms, 229 ms (stage 1474.0: task 1326))"; 10 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 152 ms (72 ms, 80 ms, 80 ms (stage 1474.0: task 1327)) peak memory total (min, med, max (stageId: taskId)) 128.5 MiB (64.2 MiB, 64.2 MiB, 64.2 MiB (stage 1474.0: task 1327)) number of output rows: 12,390 number of sort fallback tasks: 0 avg hash probes per key (min, med, max (stageId: taskId)): (1.2, 1.2, 1.2 (stage 1474.0: task 1327))"]; } 11 [labelType="html" label=" Union "]; subgraph cluster12 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 190 ms"; 13 [labelType="html" label=" Project "]; 14 [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 cluster15 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 187 ms"; 16 [labelType="html" label=" Project "]; 17 [labelType="html" label="Scan JDBCRelation((SELECT \"rg_codorg\", \"rg_typorg\", \"rg_nomorg\", \"rg_adr_1\", \"rg_adr_2\", \"rg_codpos\", \"rg_ville\", \"rg_telbur\", \"rg_fax\", \"rg_e_mail\", \"rg_prefix\", \"rg_contac\", \"rg_numbor\", \"rg_tauxre\", \"rg_codreg\", \"rg_codcai\", \"rg_codcen\", \"rg_fltele\", \"rg_datmaj\", \"rg_coduti\", \"rg_codccp\", \"rg_fltp\", \"rg_idmut\", \"rg_fltopr\", \"rg_numcpt\", \"rg_cmpimp_f\", \"rg_cmpimp_h\", \"rg_relctx\", \"rg_relpage\", \"rg_relref\", \"rg_datenv\", \"rg_datede\", \"rg_datefi\", \"rg_typoc\", \"rg_orgpayeur\", \"rg_adr_3\", \"rg_notrel\", \"rg_comment\", \"rg_flpecdep\", \"rg_numcpt_a\", \"rg_flpav\", \"rg_reclam\", \"rg_trirel\", \"rg_notbord\", \"rg_flchorus\", \"rg_numsir\", \"rg_flliseng\", \"rg_modreg\", \"rg_numcpt_c\", \"rg_numcpt_c_ft\" FROM \"xplore2\".\"h_organ\") as x) [numPartitions=1] number of output rows: 6,195"]; } 2->0; 3->2; 5->3; 6->5; 7->6; 8->7; 10->8; 11->10; 13->11; 14->13; 16->11; 17->16; }

AdaptiveSparkPlan isFinalPlan=true

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

WholeStageCodegen (5)

Exchange SinglePartition, ENSURE_REQUIREMENTS, [plan_id=23583]

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

HashAggregate(keys=[ORIGINE_440148#333351, RG_ADR_1_437974#333352, RG_ADR_2_437975#333353, RG_ADR_3_438006#333354, RG_CMPIMP_F_437996#333355, RG_CMPIMP_H_437997#333356, RG_CODCAI_437986#333357, RG_CODCCP_437991#333358, RG_CODCEN_437987#333359, RG_CODORG_437971#333360, RG_CODPOS_437976#333361, RG_CODREG_437985#333362, RG_CODUTI_437990#333363, RG_COMMENT_438008#333364, RG_CONTAC_437982#333365, RG_DATEDE_438002#333366, RG_DATEFI_438003#333367, RG_DATENV_438001#333368, RG_DATMAJ_437989#333369, RG_E_MAIL_437980#333370, RG_FAX_437979#333371, RG_FLCHORUS_438015#333372, RG_FLLISENG_438017#333373, RG_FLPAV_438011#333374, ... 27 more fields], functions=[])

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(ORIGINE_440148#333351, RG_ADR_1_437974#333352, RG_ADR_2_437975#333353, RG_ADR_3_438006#333354, RG_CMPIMP_F_437996#333355, RG_CMPIMP_H_437997#333356, RG_CODCAI_437986#333357, RG_CODCCP_437991#333358, RG_CODCEN_437987#333359, RG_CODORG_437971#333360, RG_CODPOS_437976#333361, RG_CODREG_437985#333362, RG_CODUTI_437990#333363, RG_COMMENT_438008#333364, RG_CONTAC_437982#333365, RG_DATEDE_438002#333366, RG_DATEFI_438003#333367, RG_DATENV_438001#333368, RG_DATMAJ_437989#333369, RG_E_MAIL_437980#333370, RG_FAX_437979#333371, RG_FLCHORUS_438015#333372, RG_FLLISENG_438017#333373, RG_FLPAV_438011#333374, ... 28 more fields), ENSURE_REQUIREMENTS, [plan_id=23547]

WholeStageCodegen (3)

Union

Project [null AS ORIGINE_440148#333351, rg_adr_1#333004 AS RG_ADR_1_437974#333352, rg_adr_2#333005 AS RG_ADR_2_437975#333353, rg_adr_3#333036 AS RG_ADR_3_438006#333354, rg_cmpimp_f#333026 AS RG_CMPIMP_F_437996#333355, rg_cmpimp_h#333027 AS RG_CMPIMP_H_437997#333356, rg_codcai#333016 AS RG_CODCAI_437986#333357, rg_codccp#333021 AS RG_CODCCP_437991#333358, rg_codcen#333017 AS RG_CODCEN_437987#333359, rg_codorg#333001 AS RG_CODORG_437971#333360, rg_codpos#333006 AS RG_CODPOS_437976#333361, rg_codreg#333015 AS RG_CODREG_437985#333362, rg_coduti#333020 AS RG_CODUTI_437990#333363, rg_comment#333038 AS RG_COMMENT_438008#333364, rg_contac#333012 AS RG_CONTAC_437982#333365, rg_datede#333032 AS RG_DATEDE_438002#333366, rg_datefi#333033 AS RG_DATEFI_438003#333367, rg_datenv#333031 AS RG_DATENV_438001#333368, rg_datmaj#333019 AS RG_DATMAJ_437989#333369, rg_e_mail#333010 AS RG_E_MAIL_437980#333370, rg_fax#333009 AS RG_FAX_437979#333371, rg_flchorus#333045 AS RG_FLCHORUS_438015#333372, rg_flliseng#333047 AS RG_FLLISENG_438017#333373, rg_flpav#333041 AS RG_FLPAV_438011#333374, ... 27 more fields]

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#333004,rg_adr_2#333005,rg_adr_3#333036,rg_cmpimp_f#333026,rg_cmpimp_h#333027,rg_codcai#333016,rg_codccp#333021,rg_codcen#333017,rg_codorg#333001,rg_codpos#333006,rg_codreg#333015,rg_coduti#333020,rg_comment#333038,rg_contac#333012,rg_datede#333032,rg_datefi#333033,rg_datenv#333031,rg_datmaj#333019,rg_e_mail#333010,rg_fax#333009,rg_flchorus#333045,rg_flliseng#333047,rg_flpav#333041,rg_flpecdep#333039,... 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#333803, rg_adr_1#333456 AS RG_ADR_1_437974#333804, rg_adr_2#333457 AS RG_ADR_2_437975#333805, rg_adr_3#333488 AS RG_ADR_3_438006#333806, rg_cmpimp_f#333478 AS RG_CMPIMP_F_437996#333807, rg_cmpimp_h#333479 AS RG_CMPIMP_H_437997#333808, rg_codcai#333468 AS RG_CODCAI_437986#333809, rg_codccp#333473 AS RG_CODCCP_437991#333810, rg_codcen#333469 AS RG_CODCEN_437987#333811, rg_codorg#333453 AS RG_CODORG_437971#333812, rg_codpos#333458 AS RG_CODPOS_437976#333813, rg_codreg#333467 AS RG_CODREG_437985#333814, rg_coduti#333472 AS RG_CODUTI_437990#333815, rg_comment#333490 AS RG_COMMENT_438008#333816, rg_contac#333464 AS RG_CONTAC_437982#333817, rg_datede#333484 AS RG_DATEDE_438002#333818, rg_datefi#333485 AS RG_DATEFI_438003#333819, rg_datenv#333483 AS RG_DATENV_438001#333820, rg_datmaj#333471 AS RG_DATMAJ_437989#333821, rg_e_mail#333462 AS RG_E_MAIL_437980#333822, rg_fax#333461 AS RG_FAX_437979#333823, rg_flchorus#333497 AS RG_FLCHORUS_438015#333824, rg_flliseng#333499 AS RG_FLLISENG_438017#333825, rg_flpav#333493 AS RG_FLPAV_438011#333826, ... 27 more fields]

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#333456,rg_adr_2#333457,rg_adr_3#333488,rg_cmpimp_f#333478,rg_cmpimp_h#333479,rg_codcai#333468,rg_codccp#333473,rg_codcen#333469,rg_codorg#333453,rg_codpos#333458,rg_codreg#333467,rg_coduti#333472,rg_comment#333490,rg_contac#333464,rg_datede#333484,rg_datefi#333485,rg_datenv#333483,rg_datmaj#333471,rg_e_mail#333462,rg_fax#333461,rg_flchorus#333497,rg_flliseng#333499,rg_flpav#333493,rg_flpecdep#333491,... 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 (22)
+- == Final Plan ==
   * HashAggregate (14)
   +- ShuffleQueryStage (13), Statistics(sizeInBytes=16.0 B, rowCount=1)
      +- Exchange (12)
         +- * HashAggregate (11)
            +- * HashAggregate (10)
               +- AQEShuffleRead (9)
                  +- ShuffleQueryStage (8), Statistics(sizeInBytes=7.1 MiB, rowCount=1.24E+4)
                     +- Exchange (7)
                        +- * HashAggregate (6)
                           +- Union (5)
                              :- * Project (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 (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]  (3)
+- == Initial Plan ==
   HashAggregate (21)
   +- Exchange (20)
      +- HashAggregate (19)
         +- HashAggregate (18)
            +- Exchange (17)
               +- HashAggregate (16)
                  +- Union (15)
                     :- Project (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 (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]  (3)


(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#333004, rg_adr_2#333005, rg_adr_3#333036, rg_cmpimp_f#333026, rg_cmpimp_h#333027, rg_codcai#333016, rg_codccp#333021, rg_codcen#333017, rg_codorg#333001, rg_codpos#333006, rg_codreg#333015, rg_coduti#333020, rg_comment#333038, rg_contac#333012, rg_datede#333032, rg_datefi#333033, rg_datenv#333031, rg_datmaj#333019, rg_e_mail#333010, rg_fax#333009, rg_flchorus#333045, rg_flliseng#333047, rg_flpav#333041, rg_flpecdep#333039, rg_fltele#333018, rg_fltopr#333024, rg_fltp#333022, rg_idmut#333023, rg_modreg#333048, rg_nomorg#333003, rg_notbord#333044, rg_notrel#333037, rg_numbor#333013, rg_numcpt#333025, rg_numcpt_a#333040, rg_numcpt_c#333049, rg_numcpt_c_ft#333050, rg_numsir#333046, rg_orgpayeur#333035, rg_prefix#333011, rg_reclam#333042, rg_relctx#333028, rg_relpage#333029, rg_relref#333030, rg_tauxre#333014, rg_telbur#333008, rg_trirel#333043, rg_typoc#333034, rg_typorg#333002, rg_ville#333007]
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) Project [codegen id : 1]
Output [51]: [null AS ORIGINE_440148#333351, rg_adr_1#333004 AS RG_ADR_1_437974#333352, rg_adr_2#333005 AS RG_ADR_2_437975#333353, rg_adr_3#333036 AS RG_ADR_3_438006#333354, rg_cmpimp_f#333026 AS RG_CMPIMP_F_437996#333355, rg_cmpimp_h#333027 AS RG_CMPIMP_H_437997#333356, rg_codcai#333016 AS RG_CODCAI_437986#333357, rg_codccp#333021 AS RG_CODCCP_437991#333358, rg_codcen#333017 AS RG_CODCEN_437987#333359, rg_codorg#333001 AS RG_CODORG_437971#333360, rg_codpos#333006 AS RG_CODPOS_437976#333361, rg_codreg#333015 AS RG_CODREG_437985#333362, rg_coduti#333020 AS RG_CODUTI_437990#333363, rg_comment#333038 AS RG_COMMENT_438008#333364, rg_contac#333012 AS RG_CONTAC_437982#333365, rg_datede#333032 AS RG_DATEDE_438002#333366, rg_datefi#333033 AS RG_DATEFI_438003#333367, rg_datenv#333031 AS RG_DATENV_438001#333368, rg_datmaj#333019 AS RG_DATMAJ_437989#333369, rg_e_mail#333010 AS RG_E_MAIL_437980#333370, rg_fax#333009 AS RG_FAX_437979#333371, rg_flchorus#333045 AS RG_FLCHORUS_438015#333372, rg_flliseng#333047 AS RG_FLLISENG_438017#333373, rg_flpav#333041 AS RG_FLPAV_438011#333374, rg_flpecdep#333039 AS RG_FLPECDEP_438009#333375, rg_fltele#333018 AS RG_FLTELE_437988#333376, rg_fltopr#333024 AS RG_FLTOPR_437994#333377, rg_fltp#333022 AS RG_FLTP_437992#333378, rg_idmut#333023 AS RG_IDMUT_437993#333379, rg_modreg#333048 AS RG_MODREG_438018#333380, rg_nomorg#333003 AS RG_NOMORG_437973#333381, rg_notbord#333044 AS RG_NOTBORD_438014#333382, rg_notrel#333037 AS RG_NOTREL_438007#333383, rg_numbor#333013 AS RG_NUMBOR_437983#333384, rg_numcpt#333025 AS RG_NUMCPT_437995#333385, rg_numcpt_a#333040 AS RG_NUMCPT_A_438010#333386, rg_numcpt_c#333049 AS RG_NUMCPT_C_438019#333387, rg_numcpt_c_ft#333050 AS RG_NUMCPT_C_FT_438020#333388, rg_numsir#333046 AS RG_NUMSIR_438016#333389, rg_orgpayeur#333035 AS RG_ORGPAYEUR_438005#333390, rg_prefix#333011 AS RG_PREFIX_437981#333391, rg_reclam#333042 AS RG_RECLAM_438012#333392, rg_relctx#333028 AS RG_RELCTX_437998#333393, rg_relpage#333029 AS RG_RELPAGE_437999#333394, rg_relref#333030 AS RG_RELREF_438000#333395, rg_tauxre#333014 AS RG_TAUXRE_437984#333396, rg_telbur#333008 AS RG_TELBUR_437978#333397, rg_trirel#333043 AS RG_TRIREL_438013#333398, rg_typoc#333034 AS RG_TYPOC_438004#333399, rg_typorg#333002 AS RG_TYPORG_437972#333400, rg_ville#333007 AS RG_VILLE_437977#333401]
Input [50]: [rg_adr_1#333004, rg_adr_2#333005, rg_adr_3#333036, rg_cmpimp_f#333026, rg_cmpimp_h#333027, rg_codcai#333016, rg_codccp#333021, rg_codcen#333017, rg_codorg#333001, rg_codpos#333006, rg_codreg#333015, rg_coduti#333020, rg_comment#333038, rg_contac#333012, rg_datede#333032, rg_datefi#333033, rg_datenv#333031, rg_datmaj#333019, rg_e_mail#333010, rg_fax#333009, rg_flchorus#333045, rg_flliseng#333047, rg_flpav#333041, rg_flpecdep#333039, rg_fltele#333018, rg_fltopr#333024, rg_fltp#333022, rg_idmut#333023, rg_modreg#333048, rg_nomorg#333003, rg_notbord#333044, rg_notrel#333037, rg_numbor#333013, rg_numcpt#333025, rg_numcpt_a#333040, rg_numcpt_c#333049, rg_numcpt_c_ft#333050, rg_numsir#333046, rg_orgpayeur#333035, rg_prefix#333011, rg_reclam#333042, rg_relctx#333028, rg_relpage#333029, rg_relref#333030, rg_tauxre#333014, rg_telbur#333008, rg_trirel#333043, rg_typoc#333034, rg_typorg#333002, rg_ville#333007]

(3) 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#333456, rg_adr_2#333457, rg_adr_3#333488, rg_cmpimp_f#333478, rg_cmpimp_h#333479, rg_codcai#333468, rg_codccp#333473, rg_codcen#333469, rg_codorg#333453, rg_codpos#333458, rg_codreg#333467, rg_coduti#333472, rg_comment#333490, rg_contac#333464, rg_datede#333484, rg_datefi#333485, rg_datenv#333483, rg_datmaj#333471, rg_e_mail#333462, rg_fax#333461, rg_flchorus#333497, rg_flliseng#333499, rg_flpav#333493, rg_flpecdep#333491, rg_fltele#333470, rg_fltopr#333476, rg_fltp#333474, rg_idmut#333475, rg_modreg#333500, rg_nomorg#333455, rg_notbord#333496, rg_notrel#333489, rg_numbor#333465, rg_numcpt#333477, rg_numcpt_a#333492, rg_numcpt_c#333501, rg_numcpt_c_ft#333502, rg_numsir#333498, rg_orgpayeur#333487, rg_prefix#333463, rg_reclam#333494, rg_relctx#333480, rg_relpage#333481, rg_relref#333482, rg_tauxre#333466, rg_telbur#333460, rg_trirel#333495, rg_typoc#333486, rg_typorg#333454, rg_ville#333459]
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>

(4) Project [codegen id : 2]
Output [51]: [null AS ORIGINE_440148#333803, rg_adr_1#333456 AS RG_ADR_1_437974#333804, rg_adr_2#333457 AS RG_ADR_2_437975#333805, rg_adr_3#333488 AS RG_ADR_3_438006#333806, rg_cmpimp_f#333478 AS RG_CMPIMP_F_437996#333807, rg_cmpimp_h#333479 AS RG_CMPIMP_H_437997#333808, rg_codcai#333468 AS RG_CODCAI_437986#333809, rg_codccp#333473 AS RG_CODCCP_437991#333810, rg_codcen#333469 AS RG_CODCEN_437987#333811, rg_codorg#333453 AS RG_CODORG_437971#333812, rg_codpos#333458 AS RG_CODPOS_437976#333813, rg_codreg#333467 AS RG_CODREG_437985#333814, rg_coduti#333472 AS RG_CODUTI_437990#333815, rg_comment#333490 AS RG_COMMENT_438008#333816, rg_contac#333464 AS RG_CONTAC_437982#333817, rg_datede#333484 AS RG_DATEDE_438002#333818, rg_datefi#333485 AS RG_DATEFI_438003#333819, rg_datenv#333483 AS RG_DATENV_438001#333820, rg_datmaj#333471 AS RG_DATMAJ_437989#333821, rg_e_mail#333462 AS RG_E_MAIL_437980#333822, rg_fax#333461 AS RG_FAX_437979#333823, rg_flchorus#333497 AS RG_FLCHORUS_438015#333824, rg_flliseng#333499 AS RG_FLLISENG_438017#333825, rg_flpav#333493 AS RG_FLPAV_438011#333826, rg_flpecdep#333491 AS RG_FLPECDEP_438009#333827, rg_fltele#333470 AS RG_FLTELE_437988#333828, rg_fltopr#333476 AS RG_FLTOPR_437994#333829, rg_fltp#333474 AS RG_FLTP_437992#333830, rg_idmut#333475 AS RG_IDMUT_437993#333831, rg_modreg#333500 AS RG_MODREG_438018#333832, rg_nomorg#333455 AS RG_NOMORG_437973#333833, rg_notbord#333496 AS RG_NOTBORD_438014#333834, rg_notrel#333489 AS RG_NOTREL_438007#333835, rg_numbor#333465 AS RG_NUMBOR_437983#333836, rg_numcpt#333477 AS RG_NUMCPT_437995#333837, rg_numcpt_a#333492 AS RG_NUMCPT_A_438010#333838, rg_numcpt_c#333501 AS RG_NUMCPT_C_438019#333839, rg_numcpt_c_ft#333502 AS RG_NUMCPT_C_FT_438020#333840, rg_numsir#333498 AS RG_NUMSIR_438016#333841, rg_orgpayeur#333487 AS RG_ORGPAYEUR_438005#333842, rg_prefix#333463 AS RG_PREFIX_437981#333843, rg_reclam#333494 AS RG_RECLAM_438012#333844, rg_relctx#333480 AS RG_RELCTX_437998#333845, rg_relpage#333481 AS RG_RELPAGE_437999#333846, rg_relref#333482 AS RG_RELREF_438000#333847, rg_tauxre#333466 AS RG_TAUXRE_437984#333848, rg_telbur#333460 AS RG_TELBUR_437978#333849, rg_trirel#333495 AS RG_TRIREL_438013#333850, rg_typoc#333486 AS RG_TYPOC_438004#333851, rg_typorg#333454 AS RG_TYPORG_437972#333852, rg_ville#333459 AS RG_VILLE_437977#333853]
Input [50]: [rg_adr_1#333456, rg_adr_2#333457, rg_adr_3#333488, rg_cmpimp_f#333478, rg_cmpimp_h#333479, rg_codcai#333468, rg_codccp#333473, rg_codcen#333469, rg_codorg#333453, rg_codpos#333458, rg_codreg#333467, rg_coduti#333472, rg_comment#333490, rg_contac#333464, rg_datede#333484, rg_datefi#333485, rg_datenv#333483, rg_datmaj#333471, rg_e_mail#333462, rg_fax#333461, rg_flchorus#333497, rg_flliseng#333499, rg_flpav#333493, rg_flpecdep#333491, rg_fltele#333470, rg_fltopr#333476, rg_fltp#333474, rg_idmut#333475, rg_modreg#333500, rg_nomorg#333455, rg_notbord#333496, rg_notrel#333489, rg_numbor#333465, rg_numcpt#333477, rg_numcpt_a#333492, rg_numcpt_c#333501, rg_numcpt_c_ft#333502, rg_numsir#333498, rg_orgpayeur#333487, rg_prefix#333463, rg_reclam#333494, rg_relctx#333480, rg_relpage#333481, rg_relref#333482, rg_tauxre#333466, rg_telbur#333460, rg_trirel#333495, rg_typoc#333486, rg_typorg#333454, rg_ville#333459]

(5) Union

(6) HashAggregate [codegen id : 3]
Input [51]: [ORIGINE_440148#333351, RG_ADR_1_437974#333352, RG_ADR_2_437975#333353, RG_ADR_3_438006#333354, RG_CMPIMP_F_437996#333355, RG_CMPIMP_H_437997#333356, RG_CODCAI_437986#333357, RG_CODCCP_437991#333358, RG_CODCEN_437987#333359, RG_CODORG_437971#333360, RG_CODPOS_437976#333361, RG_CODREG_437985#333362, RG_CODUTI_437990#333363, RG_COMMENT_438008#333364, RG_CONTAC_437982#333365, RG_DATEDE_438002#333366, RG_DATEFI_438003#333367, RG_DATENV_438001#333368, RG_DATMAJ_437989#333369, RG_E_MAIL_437980#333370, RG_FAX_437979#333371, RG_FLCHORUS_438015#333372, RG_FLLISENG_438017#333373, RG_FLPAV_438011#333374, RG_FLPECDEP_438009#333375, RG_FLTELE_437988#333376, RG_FLTOPR_437994#333377, RG_FLTP_437992#333378, RG_IDMUT_437993#333379, RG_MODREG_438018#333380, RG_NOMORG_437973#333381, RG_NOTBORD_438014#333382, RG_NOTREL_438007#333383, RG_NUMBOR_437983#333384, RG_NUMCPT_437995#333385, RG_NUMCPT_A_438010#333386, RG_NUMCPT_C_438019#333387, RG_NUMCPT_C_FT_438020#333388, RG_NUMSIR_438016#333389, RG_ORGPAYEUR_438005#333390, RG_PREFIX_437981#333391, RG_RECLAM_438012#333392, RG_RELCTX_437998#333393, RG_RELPAGE_437999#333394, RG_RELREF_438000#333395, RG_TAUXRE_437984#333396, RG_TELBUR_437978#333397, RG_TRIREL_438013#333398, RG_TYPOC_438004#333399, RG_TYPORG_437972#333400, RG_VILLE_437977#333401]
Keys [51]: [ORIGINE_440148#333351, RG_ADR_1_437974#333352, RG_ADR_2_437975#333353, RG_ADR_3_438006#333354, RG_CMPIMP_F_437996#333355, RG_CMPIMP_H_437997#333356, RG_CODCAI_437986#333357, RG_CODCCP_437991#333358, RG_CODCEN_437987#333359, RG_CODORG_437971#333360, RG_CODPOS_437976#333361, RG_CODREG_437985#333362, RG_CODUTI_437990#333363, RG_COMMENT_438008#333364, RG_CONTAC_437982#333365, RG_DATEDE_438002#333366, RG_DATEFI_438003#333367, RG_DATENV_438001#333368, RG_DATMAJ_437989#333369, RG_E_MAIL_437980#333370, RG_FAX_437979#333371, RG_FLCHORUS_438015#333372, RG_FLLISENG_438017#333373, RG_FLPAV_438011#333374, RG_FLPECDEP_438009#333375, RG_FLTELE_437988#333376, RG_FLTOPR_437994#333377, RG_FLTP_437992#333378, RG_IDMUT_437993#333379, RG_MODREG_438018#333380, RG_NOMORG_437973#333381, RG_NOTBORD_438014#333382, RG_NOTREL_438007#333383, RG_NUMBOR_437983#333384, RG_NUMCPT_437995#333385, RG_NUMCPT_A_438010#333386, RG_NUMCPT_C_438019#333387, RG_NUMCPT_C_FT_438020#333388, RG_NUMSIR_438016#333389, RG_ORGPAYEUR_438005#333390, RG_PREFIX_437981#333391, RG_RECLAM_438012#333392, RG_RELCTX_437998#333393, RG_RELPAGE_437999#333394, RG_RELREF_438000#333395, RG_TAUXRE_437984#333396, RG_TELBUR_437978#333397, RG_TRIREL_438013#333398, RG_TYPOC_438004#333399, RG_TYPORG_437972#333400, RG_VILLE_437977#333401]
Functions: []
Aggregate Attributes: []
Results [51]: [ORIGINE_440148#333351, RG_ADR_1_437974#333352, RG_ADR_2_437975#333353, RG_ADR_3_438006#333354, RG_CMPIMP_F_437996#333355, RG_CMPIMP_H_437997#333356, RG_CODCAI_437986#333357, RG_CODCCP_437991#333358, RG_CODCEN_437987#333359, RG_CODORG_437971#333360, RG_CODPOS_437976#333361, RG_CODREG_437985#333362, RG_CODUTI_437990#333363, RG_COMMENT_438008#333364, RG_CONTAC_437982#333365, RG_DATEDE_438002#333366, RG_DATEFI_438003#333367, RG_DATENV_438001#333368, RG_DATMAJ_437989#333369, RG_E_MAIL_437980#333370, RG_FAX_437979#333371, RG_FLCHORUS_438015#333372, RG_FLLISENG_438017#333373, RG_FLPAV_438011#333374, RG_FLPECDEP_438009#333375, RG_FLTELE_437988#333376, RG_FLTOPR_437994#333377, RG_FLTP_437992#333378, RG_IDMUT_437993#333379, RG_MODREG_438018#333380, RG_NOMORG_437973#333381, RG_NOTBORD_438014#333382, RG_NOTREL_438007#333383, RG_NUMBOR_437983#333384, RG_NUMCPT_437995#333385, RG_NUMCPT_A_438010#333386, RG_NUMCPT_C_438019#333387, RG_NUMCPT_C_FT_438020#333388, RG_NUMSIR_438016#333389, RG_ORGPAYEUR_438005#333390, RG_PREFIX_437981#333391, RG_RECLAM_438012#333392, RG_RELCTX_437998#333393, RG_RELPAGE_437999#333394, RG_RELREF_438000#333395, RG_TAUXRE_437984#333396, RG_TELBUR_437978#333397, RG_TRIREL_438013#333398, RG_TYPOC_438004#333399, RG_TYPORG_437972#333400, RG_VILLE_437977#333401]

(7) Exchange
Input [51]: [ORIGINE_440148#333351, RG_ADR_1_437974#333352, RG_ADR_2_437975#333353, RG_ADR_3_438006#333354, RG_CMPIMP_F_437996#333355, RG_CMPIMP_H_437997#333356, RG_CODCAI_437986#333357, RG_CODCCP_437991#333358, RG_CODCEN_437987#333359, RG_CODORG_437971#333360, RG_CODPOS_437976#333361, RG_CODREG_437985#333362, RG_CODUTI_437990#333363, RG_COMMENT_438008#333364, RG_CONTAC_437982#333365, RG_DATEDE_438002#333366, RG_DATEFI_438003#333367, RG_DATENV_438001#333368, RG_DATMAJ_437989#333369, RG_E_MAIL_437980#333370, RG_FAX_437979#333371, RG_FLCHORUS_438015#333372, RG_FLLISENG_438017#333373, RG_FLPAV_438011#333374, RG_FLPECDEP_438009#333375, RG_FLTELE_437988#333376, RG_FLTOPR_437994#333377, RG_FLTP_437992#333378, RG_IDMUT_437993#333379, RG_MODREG_438018#333380, RG_NOMORG_437973#333381, RG_NOTBORD_438014#333382, RG_NOTREL_438007#333383, RG_NUMBOR_437983#333384, RG_NUMCPT_437995#333385, RG_NUMCPT_A_438010#333386, RG_NUMCPT_C_438019#333387, RG_NUMCPT_C_FT_438020#333388, RG_NUMSIR_438016#333389, RG_ORGPAYEUR_438005#333390, RG_PREFIX_437981#333391, RG_RECLAM_438012#333392, RG_RELCTX_437998#333393, RG_RELPAGE_437999#333394, RG_RELREF_438000#333395, RG_TAUXRE_437984#333396, RG_TELBUR_437978#333397, RG_TRIREL_438013#333398, RG_TYPOC_438004#333399, RG_TYPORG_437972#333400, RG_VILLE_437977#333401]
Arguments: hashpartitioning(ORIGINE_440148#333351, RG_ADR_1_437974#333352, RG_ADR_2_437975#333353, RG_ADR_3_438006#333354, RG_CMPIMP_F_437996#333355, RG_CMPIMP_H_437997#333356, RG_CODCAI_437986#333357, RG_CODCCP_437991#333358, RG_CODCEN_437987#333359, RG_CODORG_437971#333360, RG_CODPOS_437976#333361, RG_CODREG_437985#333362, RG_CODUTI_437990#333363, RG_COMMENT_438008#333364, RG_CONTAC_437982#333365, RG_DATEDE_438002#333366, RG_DATEFI_438003#333367, RG_DATENV_438001#333368, RG_DATMAJ_437989#333369, RG_E_MAIL_437980#333370, RG_FAX_437979#333371, RG_FLCHORUS_438015#333372, RG_FLLISENG_438017#333373, RG_FLPAV_438011#333374, ... 28 more fields), ENSURE_REQUIREMENTS, [plan_id=23547]

(8) ShuffleQueryStage
Output [51]: [ORIGINE_440148#333351, RG_ADR_1_437974#333352, RG_ADR_2_437975#333353, RG_ADR_3_438006#333354, RG_CMPIMP_F_437996#333355, RG_CMPIMP_H_437997#333356, RG_CODCAI_437986#333357, RG_CODCCP_437991#333358, RG_CODCEN_437987#333359, RG_CODORG_437971#333360, RG_CODPOS_437976#333361, RG_CODREG_437985#333362, RG_CODUTI_437990#333363, RG_COMMENT_438008#333364, RG_CONTAC_437982#333365, RG_DATEDE_438002#333366, RG_DATEFI_438003#333367, RG_DATENV_438001#333368, RG_DATMAJ_437989#333369, RG_E_MAIL_437980#333370, RG_FAX_437979#333371, RG_FLCHORUS_438015#333372, RG_FLLISENG_438017#333373, RG_FLPAV_438011#333374, RG_FLPECDEP_438009#333375, RG_FLTELE_437988#333376, RG_FLTOPR_437994#333377, RG_FLTP_437992#333378, RG_IDMUT_437993#333379, RG_MODREG_438018#333380, RG_NOMORG_437973#333381, RG_NOTBORD_438014#333382, RG_NOTREL_438007#333383, RG_NUMBOR_437983#333384, RG_NUMCPT_437995#333385, RG_NUMCPT_A_438010#333386, RG_NUMCPT_C_438019#333387, RG_NUMCPT_C_FT_438020#333388, RG_NUMSIR_438016#333389, RG_ORGPAYEUR_438005#333390, RG_PREFIX_437981#333391, RG_RECLAM_438012#333392, RG_RELCTX_437998#333393, RG_RELPAGE_437999#333394, RG_RELREF_438000#333395, RG_TAUXRE_437984#333396, RG_TELBUR_437978#333397, RG_TRIREL_438013#333398, RG_TYPOC_438004#333399, RG_TYPORG_437972#333400, RG_VILLE_437977#333401]
Arguments: 0

(9) AQEShuffleRead
Input [51]: [ORIGINE_440148#333351, RG_ADR_1_437974#333352, RG_ADR_2_437975#333353, RG_ADR_3_438006#333354, RG_CMPIMP_F_437996#333355, RG_CMPIMP_H_437997#333356, RG_CODCAI_437986#333357, RG_CODCCP_437991#333358, RG_CODCEN_437987#333359, RG_CODORG_437971#333360, RG_CODPOS_437976#333361, RG_CODREG_437985#333362, RG_CODUTI_437990#333363, RG_COMMENT_438008#333364, RG_CONTAC_437982#333365, RG_DATEDE_438002#333366, RG_DATEFI_438003#333367, RG_DATENV_438001#333368, RG_DATMAJ_437989#333369, RG_E_MAIL_437980#333370, RG_FAX_437979#333371, RG_FLCHORUS_438015#333372, RG_FLLISENG_438017#333373, RG_FLPAV_438011#333374, RG_FLPECDEP_438009#333375, RG_FLTELE_437988#333376, RG_FLTOPR_437994#333377, RG_FLTP_437992#333378, RG_IDMUT_437993#333379, RG_MODREG_438018#333380, RG_NOMORG_437973#333381, RG_NOTBORD_438014#333382, RG_NOTREL_438007#333383, RG_NUMBOR_437983#333384, RG_NUMCPT_437995#333385, RG_NUMCPT_A_438010#333386, RG_NUMCPT_C_438019#333387, RG_NUMCPT_C_FT_438020#333388, RG_NUMSIR_438016#333389, RG_ORGPAYEUR_438005#333390, RG_PREFIX_437981#333391, RG_RECLAM_438012#333392, RG_RELCTX_437998#333393, RG_RELPAGE_437999#333394, RG_RELREF_438000#333395, RG_TAUXRE_437984#333396, RG_TELBUR_437978#333397, RG_TRIREL_438013#333398, RG_TYPOC_438004#333399, RG_TYPORG_437972#333400, RG_VILLE_437977#333401]
Arguments: coalesced

(10) HashAggregate [codegen id : 4]
Input [51]: [ORIGINE_440148#333351, RG_ADR_1_437974#333352, RG_ADR_2_437975#333353, RG_ADR_3_438006#333354, RG_CMPIMP_F_437996#333355, RG_CMPIMP_H_437997#333356, RG_CODCAI_437986#333357, RG_CODCCP_437991#333358, RG_CODCEN_437987#333359, RG_CODORG_437971#333360, RG_CODPOS_437976#333361, RG_CODREG_437985#333362, RG_CODUTI_437990#333363, RG_COMMENT_438008#333364, RG_CONTAC_437982#333365, RG_DATEDE_438002#333366, RG_DATEFI_438003#333367, RG_DATENV_438001#333368, RG_DATMAJ_437989#333369, RG_E_MAIL_437980#333370, RG_FAX_437979#333371, RG_FLCHORUS_438015#333372, RG_FLLISENG_438017#333373, RG_FLPAV_438011#333374, RG_FLPECDEP_438009#333375, RG_FLTELE_437988#333376, RG_FLTOPR_437994#333377, RG_FLTP_437992#333378, RG_IDMUT_437993#333379, RG_MODREG_438018#333380, RG_NOMORG_437973#333381, RG_NOTBORD_438014#333382, RG_NOTREL_438007#333383, RG_NUMBOR_437983#333384, RG_NUMCPT_437995#333385, RG_NUMCPT_A_438010#333386, RG_NUMCPT_C_438019#333387, RG_NUMCPT_C_FT_438020#333388, RG_NUMSIR_438016#333389, RG_ORGPAYEUR_438005#333390, RG_PREFIX_437981#333391, RG_RECLAM_438012#333392, RG_RELCTX_437998#333393, RG_RELPAGE_437999#333394, RG_RELREF_438000#333395, RG_TAUXRE_437984#333396, RG_TELBUR_437978#333397, RG_TRIREL_438013#333398, RG_TYPOC_438004#333399, RG_TYPORG_437972#333400, RG_VILLE_437977#333401]
Keys [51]: [ORIGINE_440148#333351, RG_ADR_1_437974#333352, RG_ADR_2_437975#333353, RG_ADR_3_438006#333354, RG_CMPIMP_F_437996#333355, RG_CMPIMP_H_437997#333356, RG_CODCAI_437986#333357, RG_CODCCP_437991#333358, RG_CODCEN_437987#333359, RG_CODORG_437971#333360, RG_CODPOS_437976#333361, RG_CODREG_437985#333362, RG_CODUTI_437990#333363, RG_COMMENT_438008#333364, RG_CONTAC_437982#333365, RG_DATEDE_438002#333366, RG_DATEFI_438003#333367, RG_DATENV_438001#333368, RG_DATMAJ_437989#333369, RG_E_MAIL_437980#333370, RG_FAX_437979#333371, RG_FLCHORUS_438015#333372, RG_FLLISENG_438017#333373, RG_FLPAV_438011#333374, RG_FLPECDEP_438009#333375, RG_FLTELE_437988#333376, RG_FLTOPR_437994#333377, RG_FLTP_437992#333378, RG_IDMUT_437993#333379, RG_MODREG_438018#333380, RG_NOMORG_437973#333381, RG_NOTBORD_438014#333382, RG_NOTREL_438007#333383, RG_NUMBOR_437983#333384, RG_NUMCPT_437995#333385, RG_NUMCPT_A_438010#333386, RG_NUMCPT_C_438019#333387, RG_NUMCPT_C_FT_438020#333388, RG_NUMSIR_438016#333389, RG_ORGPAYEUR_438005#333390, RG_PREFIX_437981#333391, RG_RECLAM_438012#333392, RG_RELCTX_437998#333393, RG_RELPAGE_437999#333394, RG_RELREF_438000#333395, RG_TAUXRE_437984#333396, RG_TELBUR_437978#333397, RG_TRIREL_438013#333398, RG_TYPOC_438004#333399, RG_TYPORG_437972#333400, RG_VILLE_437977#333401]
Functions: []
Aggregate Attributes: []
Results: []

(11) HashAggregate [codegen id : 4]
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#334724L]
Results [1]: [count#334725L]

(12) Exchange
Input [1]: [count#334725L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=23583]

(13) ShuffleQueryStage
Output [1]: [count#334725L]
Arguments: 1

(14) HashAggregate [codegen id : 5]
Input [1]: [count#334725L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#334721L]
Results [1]: [count(1)#334721L AS count#334722L]

(15) Union

(16) HashAggregate
Input [51]: [ORIGINE_440148#333351, RG_ADR_1_437974#333352, RG_ADR_2_437975#333353, RG_ADR_3_438006#333354, RG_CMPIMP_F_437996#333355, RG_CMPIMP_H_437997#333356, RG_CODCAI_437986#333357, RG_CODCCP_437991#333358, RG_CODCEN_437987#333359, RG_CODORG_437971#333360, RG_CODPOS_437976#333361, RG_CODREG_437985#333362, RG_CODUTI_437990#333363, RG_COMMENT_438008#333364, RG_CONTAC_437982#333365, RG_DATEDE_438002#333366, RG_DATEFI_438003#333367, RG_DATENV_438001#333368, RG_DATMAJ_437989#333369, RG_E_MAIL_437980#333370, RG_FAX_437979#333371, RG_FLCHORUS_438015#333372, RG_FLLISENG_438017#333373, RG_FLPAV_438011#333374, RG_FLPECDEP_438009#333375, RG_FLTELE_437988#333376, RG_FLTOPR_437994#333377, RG_FLTP_437992#333378, RG_IDMUT_437993#333379, RG_MODREG_438018#333380, RG_NOMORG_437973#333381, RG_NOTBORD_438014#333382, RG_NOTREL_438007#333383, RG_NUMBOR_437983#333384, RG_NUMCPT_437995#333385, RG_NUMCPT_A_438010#333386, RG_NUMCPT_C_438019#333387, RG_NUMCPT_C_FT_438020#333388, RG_NUMSIR_438016#333389, RG_ORGPAYEUR_438005#333390, RG_PREFIX_437981#333391, RG_RECLAM_438012#333392, RG_RELCTX_437998#333393, RG_RELPAGE_437999#333394, RG_RELREF_438000#333395, RG_TAUXRE_437984#333396, RG_TELBUR_437978#333397, RG_TRIREL_438013#333398, RG_TYPOC_438004#333399, RG_TYPORG_437972#333400, RG_VILLE_437977#333401]
Keys [51]: [ORIGINE_440148#333351, RG_ADR_1_437974#333352, RG_ADR_2_437975#333353, RG_ADR_3_438006#333354, RG_CMPIMP_F_437996#333355, RG_CMPIMP_H_437997#333356, RG_CODCAI_437986#333357, RG_CODCCP_437991#333358, RG_CODCEN_437987#333359, RG_CODORG_437971#333360, RG_CODPOS_437976#333361, RG_CODREG_437985#333362, RG_CODUTI_437990#333363, RG_COMMENT_438008#333364, RG_CONTAC_437982#333365, RG_DATEDE_438002#333366, RG_DATEFI_438003#333367, RG_DATENV_438001#333368, RG_DATMAJ_437989#333369, RG_E_MAIL_437980#333370, RG_FAX_437979#333371, RG_FLCHORUS_438015#333372, RG_FLLISENG_438017#333373, RG_FLPAV_438011#333374, RG_FLPECDEP_438009#333375, RG_FLTELE_437988#333376, RG_FLTOPR_437994#333377, RG_FLTP_437992#333378, RG_IDMUT_437993#333379, RG_MODREG_438018#333380, RG_NOMORG_437973#333381, RG_NOTBORD_438014#333382, RG_NOTREL_438007#333383, RG_NUMBOR_437983#333384, RG_NUMCPT_437995#333385, RG_NUMCPT_A_438010#333386, RG_NUMCPT_C_438019#333387, RG_NUMCPT_C_FT_438020#333388, RG_NUMSIR_438016#333389, RG_ORGPAYEUR_438005#333390, RG_PREFIX_437981#333391, RG_RECLAM_438012#333392, RG_RELCTX_437998#333393, RG_RELPAGE_437999#333394, RG_RELREF_438000#333395, RG_TAUXRE_437984#333396, RG_TELBUR_437978#333397, RG_TRIREL_438013#333398, RG_TYPOC_438004#333399, RG_TYPORG_437972#333400, RG_VILLE_437977#333401]
Functions: []
Aggregate Attributes: []
Results [51]: [ORIGINE_440148#333351, RG_ADR_1_437974#333352, RG_ADR_2_437975#333353, RG_ADR_3_438006#333354, RG_CMPIMP_F_437996#333355, RG_CMPIMP_H_437997#333356, RG_CODCAI_437986#333357, RG_CODCCP_437991#333358, RG_CODCEN_437987#333359, RG_CODORG_437971#333360, RG_CODPOS_437976#333361, RG_CODREG_437985#333362, RG_CODUTI_437990#333363, RG_COMMENT_438008#333364, RG_CONTAC_437982#333365, RG_DATEDE_438002#333366, RG_DATEFI_438003#333367, RG_DATENV_438001#333368, RG_DATMAJ_437989#333369, RG_E_MAIL_437980#333370, RG_FAX_437979#333371, RG_FLCHORUS_438015#333372, RG_FLLISENG_438017#333373, RG_FLPAV_438011#333374, RG_FLPECDEP_438009#333375, RG_FLTELE_437988#333376, RG_FLTOPR_437994#333377, RG_FLTP_437992#333378, RG_IDMUT_437993#333379, RG_MODREG_438018#333380, RG_NOMORG_437973#333381, RG_NOTBORD_438014#333382, RG_NOTREL_438007#333383, RG_NUMBOR_437983#333384, RG_NUMCPT_437995#333385, RG_NUMCPT_A_438010#333386, RG_NUMCPT_C_438019#333387, RG_NUMCPT_C_FT_438020#333388, RG_NUMSIR_438016#333389, RG_ORGPAYEUR_438005#333390, RG_PREFIX_437981#333391, RG_RECLAM_438012#333392, RG_RELCTX_437998#333393, RG_RELPAGE_437999#333394, RG_RELREF_438000#333395, RG_TAUXRE_437984#333396, RG_TELBUR_437978#333397, RG_TRIREL_438013#333398, RG_TYPOC_438004#333399, RG_TYPORG_437972#333400, RG_VILLE_437977#333401]

(17) Exchange
Input [51]: [ORIGINE_440148#333351, RG_ADR_1_437974#333352, RG_ADR_2_437975#333353, RG_ADR_3_438006#333354, RG_CMPIMP_F_437996#333355, RG_CMPIMP_H_437997#333356, RG_CODCAI_437986#333357, RG_CODCCP_437991#333358, RG_CODCEN_437987#333359, RG_CODORG_437971#333360, RG_CODPOS_437976#333361, RG_CODREG_437985#333362, RG_CODUTI_437990#333363, RG_COMMENT_438008#333364, RG_CONTAC_437982#333365, RG_DATEDE_438002#333366, RG_DATEFI_438003#333367, RG_DATENV_438001#333368, RG_DATMAJ_437989#333369, RG_E_MAIL_437980#333370, RG_FAX_437979#333371, RG_FLCHORUS_438015#333372, RG_FLLISENG_438017#333373, RG_FLPAV_438011#333374, RG_FLPECDEP_438009#333375, RG_FLTELE_437988#333376, RG_FLTOPR_437994#333377, RG_FLTP_437992#333378, RG_IDMUT_437993#333379, RG_MODREG_438018#333380, RG_NOMORG_437973#333381, RG_NOTBORD_438014#333382, RG_NOTREL_438007#333383, RG_NUMBOR_437983#333384, RG_NUMCPT_437995#333385, RG_NUMCPT_A_438010#333386, RG_NUMCPT_C_438019#333387, RG_NUMCPT_C_FT_438020#333388, RG_NUMSIR_438016#333389, RG_ORGPAYEUR_438005#333390, RG_PREFIX_437981#333391, RG_RECLAM_438012#333392, RG_RELCTX_437998#333393, RG_RELPAGE_437999#333394, RG_RELREF_438000#333395, RG_TAUXRE_437984#333396, RG_TELBUR_437978#333397, RG_TRIREL_438013#333398, RG_TYPOC_438004#333399, RG_TYPORG_437972#333400, RG_VILLE_437977#333401]
Arguments: hashpartitioning(ORIGINE_440148#333351, RG_ADR_1_437974#333352, RG_ADR_2_437975#333353, RG_ADR_3_438006#333354, RG_CMPIMP_F_437996#333355, RG_CMPIMP_H_437997#333356, RG_CODCAI_437986#333357, RG_CODCCP_437991#333358, RG_CODCEN_437987#333359, RG_CODORG_437971#333360, RG_CODPOS_437976#333361, RG_CODREG_437985#333362, RG_CODUTI_437990#333363, RG_COMMENT_438008#333364, RG_CONTAC_437982#333365, RG_DATEDE_438002#333366, RG_DATEFI_438003#333367, RG_DATENV_438001#333368, RG_DATMAJ_437989#333369, RG_E_MAIL_437980#333370, RG_FAX_437979#333371, RG_FLCHORUS_438015#333372, RG_FLLISENG_438017#333373, RG_FLPAV_438011#333374, ... 28 more fields), ENSURE_REQUIREMENTS, [plan_id=23519]

(18) HashAggregate
Input [51]: [ORIGINE_440148#333351, RG_ADR_1_437974#333352, RG_ADR_2_437975#333353, RG_ADR_3_438006#333354, RG_CMPIMP_F_437996#333355, RG_CMPIMP_H_437997#333356, RG_CODCAI_437986#333357, RG_CODCCP_437991#333358, RG_CODCEN_437987#333359, RG_CODORG_437971#333360, RG_CODPOS_437976#333361, RG_CODREG_437985#333362, RG_CODUTI_437990#333363, RG_COMMENT_438008#333364, RG_CONTAC_437982#333365, RG_DATEDE_438002#333366, RG_DATEFI_438003#333367, RG_DATENV_438001#333368, RG_DATMAJ_437989#333369, RG_E_MAIL_437980#333370, RG_FAX_437979#333371, RG_FLCHORUS_438015#333372, RG_FLLISENG_438017#333373, RG_FLPAV_438011#333374, RG_FLPECDEP_438009#333375, RG_FLTELE_437988#333376, RG_FLTOPR_437994#333377, RG_FLTP_437992#333378, RG_IDMUT_437993#333379, RG_MODREG_438018#333380, RG_NOMORG_437973#333381, RG_NOTBORD_438014#333382, RG_NOTREL_438007#333383, RG_NUMBOR_437983#333384, RG_NUMCPT_437995#333385, RG_NUMCPT_A_438010#333386, RG_NUMCPT_C_438019#333387, RG_NUMCPT_C_FT_438020#333388, RG_NUMSIR_438016#333389, RG_ORGPAYEUR_438005#333390, RG_PREFIX_437981#333391, RG_RECLAM_438012#333392, RG_RELCTX_437998#333393, RG_RELPAGE_437999#333394, RG_RELREF_438000#333395, RG_TAUXRE_437984#333396, RG_TELBUR_437978#333397, RG_TRIREL_438013#333398, RG_TYPOC_438004#333399, RG_TYPORG_437972#333400, RG_VILLE_437977#333401]
Keys [51]: [ORIGINE_440148#333351, RG_ADR_1_437974#333352, RG_ADR_2_437975#333353, RG_ADR_3_438006#333354, RG_CMPIMP_F_437996#333355, RG_CMPIMP_H_437997#333356, RG_CODCAI_437986#333357, RG_CODCCP_437991#333358, RG_CODCEN_437987#333359, RG_CODORG_437971#333360, RG_CODPOS_437976#333361, RG_CODREG_437985#333362, RG_CODUTI_437990#333363, RG_COMMENT_438008#333364, RG_CONTAC_437982#333365, RG_DATEDE_438002#333366, RG_DATEFI_438003#333367, RG_DATENV_438001#333368, RG_DATMAJ_437989#333369, RG_E_MAIL_437980#333370, RG_FAX_437979#333371, RG_FLCHORUS_438015#333372, RG_FLLISENG_438017#333373, RG_FLPAV_438011#333374, RG_FLPECDEP_438009#333375, RG_FLTELE_437988#333376, RG_FLTOPR_437994#333377, RG_FLTP_437992#333378, RG_IDMUT_437993#333379, RG_MODREG_438018#333380, RG_NOMORG_437973#333381, RG_NOTBORD_438014#333382, RG_NOTREL_438007#333383, RG_NUMBOR_437983#333384, RG_NUMCPT_437995#333385, RG_NUMCPT_A_438010#333386, RG_NUMCPT_C_438019#333387, RG_NUMCPT_C_FT_438020#333388, RG_NUMSIR_438016#333389, RG_ORGPAYEUR_438005#333390, RG_PREFIX_437981#333391, RG_RECLAM_438012#333392, RG_RELCTX_437998#333393, RG_RELPAGE_437999#333394, RG_RELREF_438000#333395, RG_TAUXRE_437984#333396, RG_TELBUR_437978#333397, RG_TRIREL_438013#333398, RG_TYPOC_438004#333399, RG_TYPORG_437972#333400, RG_VILLE_437977#333401]
Functions: []
Aggregate Attributes: []
Results: []

(19) HashAggregate
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#334724L]
Results [1]: [count#334725L]

(20) Exchange
Input [1]: [count#334725L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=23523]

(21) HashAggregate
Input [1]: [count#334725L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#334721L]
Results [1]: [count(1)#334721L AS count#334722L]

(22) AdaptiveSparkPlan
Output [1]: [count#334722L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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