digraph G {
0 [labelType="html" label="<br><b>AdaptiveSparkPlan</b><br><br>"];
subgraph cluster1 {
isCluster="true";
label="WholeStageCodegen (5)\n \nduration: 0 ms";
2 [labelType="html" label="<b>HashAggregate</b><br><br>time in aggregation build: 0 ms<br>number of output rows: 1"];
}
3 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 1<br>local merged chunks fetched: 0<br>shuffle write time: 0 ms<br>remote merged bytes read: 0.0 B<br>local merged blocks fetched: 0<br>corrupt merged block chunks: 0<br>remote merged reqs duration: 0 ms<br>remote merged blocks fetched: 0<br>records read: 1<br>local bytes read: 59.0 B<br>fetch wait time: 0 ms<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 1<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size: 16.0 B<br>local merged bytes read: 0.0 B<br>number of partitions: 1<br>remote reqs duration: 0 ms<br>remote bytes read to disk: 0.0 B<br>shuffle bytes written: 59.0 B"];
subgraph cluster4 {
isCluster="true";
label="WholeStageCodegen (4)\n \nduration: 4 ms";
5 [labelType="html" label="<b>HashAggregate</b><br><br>spill size: 0.0 B<br>time in aggregation build: 4 ms<br>peak memory: 0.0 B<br>number of output rows: 1<br>number of sort fallback tasks: 0<br>avg hash probes per key: 0"];
6 [labelType="html" label="<b>HashAggregate</b><br><br>spill size: 0.0 B<br>time in aggregation build: 1 ms<br>peak memory: 64.2 MiB<br>number of output rows: 255<br>number of sort fallback tasks: 0<br>avg hash probes per key: 1"];
}
7 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 1<br>partition data size: 14.5 KiB<br>number of coalesced partitions: 1"];
8 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 510<br>local merged chunks fetched: 0<br>shuffle write time total (min, med, max (stageId: taskId))<br>3 ms (1 ms, 1 ms, 1 ms (stage 2019.0: task 1761))<br>remote merged bytes read: 0.0 B<br>local merged blocks fetched: 0<br>corrupt merged block chunks: 0<br>remote merged reqs duration: 0 ms<br>remote merged blocks fetched: 0<br>records read: 510<br>local bytes read: 14.3 KiB<br>fetch wait time: 0 ms<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 2<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size total (min, med, max (stageId: taskId))<br>46.2 KiB (23.1 KiB, 23.1 KiB, 23.1 KiB (stage 2019.0: task 1761))<br>local merged bytes read: 0.0 B<br>number of partitions: 10<br>remote reqs duration: 0 ms<br>remote bytes read to disk: 0.0 B<br>shuffle bytes written total (min, med, max (stageId: taskId))<br>14.3 KiB (7.1 KiB, 7.1 KiB, 7.1 KiB (stage 2019.0: task 1761))"];
subgraph cluster9 {
isCluster="true";
label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n433 ms (212 ms, 221 ms, 221 ms (stage 2019.0: task 1761))";
10 [labelType="html" label="<b>HashAggregate</b><br><br>spill size: 0.0 B<br>time in aggregation build total (min, med, max (stageId: taskId))<br>398 ms (198 ms, 200 ms, 200 ms (stage 2019.0: task 1762))<br>peak memory total (min, med, max (stageId: taskId))<br>128.5 MiB (64.2 MiB, 64.2 MiB, 64.2 MiB (stage 2019.0: task 1761))<br>number of output rows: 510<br>number of sort fallback tasks: 0<br>avg hash probes per key (min, med, max (stageId: taskId)):<br>(1, 1, 1 (stage 2019.0: task 1761))"];
}
11 [labelType="html" label="<br><b>Union</b><br><br>"];
subgraph cluster12 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 219 ms";
13 [labelType="html" label="<br><b>Project</b><br><br>"];
14 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 255"];
15 [labelType="html" label="<b>Scan JDBCRelation((SELECT \"cp_codpos\", \"cp_burdis\", \"cp_codpays\", \"cp_coduti\", \"cp_datmaj\", \"cp_codinsee\" FROM \"xplore\".\"h_codpos\") as x) [numPartitions=1] </b><br><br>number of output rows: 39,005"];
}
subgraph cluster16 {
isCluster="true";
label="WholeStageCodegen (2)\n \nduration: 210 ms";
17 [labelType="html" label="<br><b>Project</b><br><br>"];
18 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 255"];
19 [labelType="html" label="<b>Scan JDBCRelation((SELECT \"cp_codpos\", \"cp_burdis\", \"cp_codpays\", \"cp_coduti\", \"cp_datmaj\", \"cp_codinsee\" FROM \"xplore2\".\"h_codpos\") as x) [numPartitions=1] </b><br><br>number of output rows: 39,005"];
}
2->0;
3->2;
5->3;
6->5;
7->6;
8->7;
10->8;
11->10;
13->11;
14->13;
15->14;
17->11;
18->17;
19->18;
}
20
AdaptiveSparkPlan isFinalPlan=true
HashAggregate(keys=[], functions=[count(1)])
WholeStageCodegen (5)
Exchange SinglePartition, ENSURE_REQUIREMENTS, [plan_id=37921]
HashAggregate(keys=[], functions=[partial_count(1)])
HashAggregate(keys=[CP_BURDIS_437228#705018, CP_CODINSEE_437232#705019, CP_CODPAYS_437229#705020, CP_CODPOS_437227#705021, CP_CODUTI_437230#705022, CP_DATMAJ_437231#705023, ORIGINE_440138#705024], functions=[])
WholeStageCodegen (4)
AQEShuffleRead coalesced
Exchange hashpartitioning(CP_BURDIS_437228#705018, CP_CODINSEE_437232#705019, CP_CODPAYS_437229#705020, CP_CODPOS_437227#705021, CP_CODUTI_437230#705022, CP_DATMAJ_437231#705023, ORIGINE_440138#705024, 10), ENSURE_REQUIREMENTS, [plan_id=37737]
HashAggregate(keys=[CP_BURDIS_437228#705018, CP_CODINSEE_437232#705019, CP_CODPAYS_437229#705020, CP_CODPOS_437227#705021, CP_CODUTI_437230#705022, CP_DATMAJ_437231#705023, ORIGINE_440138#705024], functions=[])
WholeStageCodegen (3)
Union
Project [cp_burdis#704977 AS CP_BURDIS_437228#705018, cp_codinsee#704981 AS CP_CODINSEE_437232#705019, cp_codpays#704978 AS CP_CODPAYS_437229#705020, cp_codpos#704976 AS CP_CODPOS_437227#705021, cp_coduti#704979 AS CP_CODUTI_437230#705022, cp_datmaj#704980 AS CP_DATMAJ_437231#705023, null AS ORIGINE_440138#705024]
Filter ((((((CASE WHEN isnull(Contains(str_remove_accent(upper(cp_codpos#704976)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cp_codpos#704976)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(cp_burdis#704977)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cp_burdis#704977)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cp_codpays#704978)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cp_codpays#704978)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cp_coduti#704979)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cp_coduti#704979)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cp_datmaj#704980)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cp_datmaj#704980)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cp_codinsee#704981)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cp_codinsee#704981)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(null), MAIN)) THEN false ELSE Contains(str_remove_accent(null), MAIN) END)
Scan JDBCRelation((SELECT "cp_codpos", "cp_burdis", "cp_codpays", "cp_coduti", "cp_datmaj", "cp_codinsee" FROM "xplore"."h_codpos") as x) [numPartitions=1] [cp_burdis#704977,cp_codinsee#704981,cp_codpays#704978,cp_codpos#704976,cp_coduti#704979,cp_datmaj#704980] PushedFilters: [], ReadSchema: struct<cp_burdis:string,cp_codinsee:string,cp_codpays:string,cp_codpos:string,cp_coduti:string,cp...
WholeStageCodegen (1)
Project [cp_burdis#705033 AS CP_BURDIS_437228#705074, cp_codinsee#705037 AS CP_CODINSEE_437232#705075, cp_codpays#705034 AS CP_CODPAYS_437229#705076, cp_codpos#705032 AS CP_CODPOS_437227#705077, cp_coduti#705035 AS CP_CODUTI_437230#705078, cp_datmaj#705036 AS CP_DATMAJ_437231#705079, null AS ORIGINE_440138#705080]
Filter ((((((CASE WHEN isnull(Contains(str_remove_accent(upper(cp_codpos#705032)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cp_codpos#705032)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(cp_burdis#705033)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cp_burdis#705033)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cp_codpays#705034)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cp_codpays#705034)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cp_coduti#705035)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cp_coduti#705035)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cp_datmaj#705036)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cp_datmaj#705036)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cp_codinsee#705037)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cp_codinsee#705037)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(null), MAIN)) THEN false ELSE Contains(str_remove_accent(null), MAIN) END)
Scan JDBCRelation((SELECT "cp_codpos", "cp_burdis", "cp_codpays", "cp_coduti", "cp_datmaj", "cp_codinsee" FROM "xplore2"."h_codpos") as x) [numPartitions=1] [cp_burdis#705033,cp_codinsee#705037,cp_codpays#705034,cp_codpos#705032,cp_coduti#705035,cp_datmaj#705036] PushedFilters: [], ReadSchema: struct<cp_burdis:string,cp_codinsee:string,cp_codpays:string,cp_codpos:string,cp_coduti:string,cp...
WholeStageCodegen (2)
== Physical Plan ==
AdaptiveSparkPlan (24)
+- == Final Plan ==
* HashAggregate (16)
+- ShuffleQueryStage (15), Statistics(sizeInBytes=16.0 B, rowCount=1)
+- Exchange (14)
+- * HashAggregate (13)
+- * HashAggregate (12)
+- AQEShuffleRead (11)
+- ShuffleQueryStage (10), Statistics(sizeInBytes=46.2 KiB, rowCount=510)
+- Exchange (9)
+- * HashAggregate (8)
+- Union (7)
:- * Project (3)
: +- * Filter (2)
: +- * Scan JDBCRelation((SELECT "cp_codpos", "cp_burdis", "cp_codpays", "cp_coduti", "cp_datmaj", "cp_codinsee" FROM "xplore"."h_codpos") as x) [numPartitions=1] (1)
+- * Project (6)
+- * Filter (5)
+- * Scan JDBCRelation((SELECT "cp_codpos", "cp_burdis", "cp_codpays", "cp_coduti", "cp_datmaj", "cp_codinsee" FROM "xplore2"."h_codpos") as x) [numPartitions=1] (4)
+- == Initial Plan ==
HashAggregate (23)
+- Exchange (22)
+- HashAggregate (21)
+- HashAggregate (20)
+- Exchange (19)
+- HashAggregate (18)
+- Union (17)
:- Project (3)
: +- Filter (2)
: +- Scan JDBCRelation((SELECT "cp_codpos", "cp_burdis", "cp_codpays", "cp_coduti", "cp_datmaj", "cp_codinsee" FROM "xplore"."h_codpos") as x) [numPartitions=1] (1)
+- Project (6)
+- Filter (5)
+- Scan JDBCRelation((SELECT "cp_codpos", "cp_burdis", "cp_codpays", "cp_coduti", "cp_datmaj", "cp_codinsee" FROM "xplore2"."h_codpos") as x) [numPartitions=1] (4)
(1) Scan JDBCRelation((SELECT "cp_codpos", "cp_burdis", "cp_codpays", "cp_coduti", "cp_datmaj", "cp_codinsee" FROM "xplore"."h_codpos") as x) [numPartitions=1] [codegen id : 1]
Output [6]: [cp_burdis#704977, cp_codinsee#704981, cp_codpays#704978, cp_codpos#704976, cp_coduti#704979, cp_datmaj#704980]
ReadSchema: struct<cp_burdis:string,cp_codinsee:string,cp_codpays:string,cp_codpos:string,cp_coduti:string,cp_datmaj:string>
(2) Filter [codegen id : 1]
Input [6]: [cp_burdis#704977, cp_codinsee#704981, cp_codpays#704978, cp_codpos#704976, cp_coduti#704979, cp_datmaj#704980]
Condition : ((((((CASE WHEN isnull(Contains(str_remove_accent(upper(cp_codpos#704976)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cp_codpos#704976)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(cp_burdis#704977)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cp_burdis#704977)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cp_codpays#704978)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cp_codpays#704978)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cp_coduti#704979)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cp_coduti#704979)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cp_datmaj#704980)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cp_datmaj#704980)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cp_codinsee#704981)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cp_codinsee#704981)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(null), MAIN)) THEN false ELSE Contains(str_remove_accent(null), MAIN) END)
(3) Project [codegen id : 1]
Output [7]: [cp_burdis#704977 AS CP_BURDIS_437228#705018, cp_codinsee#704981 AS CP_CODINSEE_437232#705019, cp_codpays#704978 AS CP_CODPAYS_437229#705020, cp_codpos#704976 AS CP_CODPOS_437227#705021, cp_coduti#704979 AS CP_CODUTI_437230#705022, cp_datmaj#704980 AS CP_DATMAJ_437231#705023, null AS ORIGINE_440138#705024]
Input [6]: [cp_burdis#704977, cp_codinsee#704981, cp_codpays#704978, cp_codpos#704976, cp_coduti#704979, cp_datmaj#704980]
(4) Scan JDBCRelation((SELECT "cp_codpos", "cp_burdis", "cp_codpays", "cp_coduti", "cp_datmaj", "cp_codinsee" FROM "xplore2"."h_codpos") as x) [numPartitions=1] [codegen id : 2]
Output [6]: [cp_burdis#705033, cp_codinsee#705037, cp_codpays#705034, cp_codpos#705032, cp_coduti#705035, cp_datmaj#705036]
ReadSchema: struct<cp_burdis:string,cp_codinsee:string,cp_codpays:string,cp_codpos:string,cp_coduti:string,cp_datmaj:string>
(5) Filter [codegen id : 2]
Input [6]: [cp_burdis#705033, cp_codinsee#705037, cp_codpays#705034, cp_codpos#705032, cp_coduti#705035, cp_datmaj#705036]
Condition : ((((((CASE WHEN isnull(Contains(str_remove_accent(upper(cp_codpos#705032)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cp_codpos#705032)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(cp_burdis#705033)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cp_burdis#705033)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cp_codpays#705034)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cp_codpays#705034)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cp_coduti#705035)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cp_coduti#705035)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cp_datmaj#705036)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cp_datmaj#705036)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cp_codinsee#705037)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cp_codinsee#705037)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(null), MAIN)) THEN false ELSE Contains(str_remove_accent(null), MAIN) END)
(6) Project [codegen id : 2]
Output [7]: [cp_burdis#705033 AS CP_BURDIS_437228#705074, cp_codinsee#705037 AS CP_CODINSEE_437232#705075, cp_codpays#705034 AS CP_CODPAYS_437229#705076, cp_codpos#705032 AS CP_CODPOS_437227#705077, cp_coduti#705035 AS CP_CODUTI_437230#705078, cp_datmaj#705036 AS CP_DATMAJ_437231#705079, null AS ORIGINE_440138#705080]
Input [6]: [cp_burdis#705033, cp_codinsee#705037, cp_codpays#705034, cp_codpos#705032, cp_coduti#705035, cp_datmaj#705036]
(7) Union
(8) HashAggregate [codegen id : 3]
Input [7]: [CP_BURDIS_437228#705018, CP_CODINSEE_437232#705019, CP_CODPAYS_437229#705020, CP_CODPOS_437227#705021, CP_CODUTI_437230#705022, CP_DATMAJ_437231#705023, ORIGINE_440138#705024]
Keys [7]: [CP_BURDIS_437228#705018, CP_CODINSEE_437232#705019, CP_CODPAYS_437229#705020, CP_CODPOS_437227#705021, CP_CODUTI_437230#705022, CP_DATMAJ_437231#705023, ORIGINE_440138#705024]
Functions: []
Aggregate Attributes: []
Results [7]: [CP_BURDIS_437228#705018, CP_CODINSEE_437232#705019, CP_CODPAYS_437229#705020, CP_CODPOS_437227#705021, CP_CODUTI_437230#705022, CP_DATMAJ_437231#705023, ORIGINE_440138#705024]
(9) Exchange
Input [7]: [CP_BURDIS_437228#705018, CP_CODINSEE_437232#705019, CP_CODPAYS_437229#705020, CP_CODPOS_437227#705021, CP_CODUTI_437230#705022, CP_DATMAJ_437231#705023, ORIGINE_440138#705024]
Arguments: hashpartitioning(CP_BURDIS_437228#705018, CP_CODINSEE_437232#705019, CP_CODPAYS_437229#705020, CP_CODPOS_437227#705021, CP_CODUTI_437230#705022, CP_DATMAJ_437231#705023, ORIGINE_440138#705024, 10), ENSURE_REQUIREMENTS, [plan_id=37737]
(10) ShuffleQueryStage
Output [7]: [CP_BURDIS_437228#705018, CP_CODINSEE_437232#705019, CP_CODPAYS_437229#705020, CP_CODPOS_437227#705021, CP_CODUTI_437230#705022, CP_DATMAJ_437231#705023, ORIGINE_440138#705024]
Arguments: 0
(11) AQEShuffleRead
Input [7]: [CP_BURDIS_437228#705018, CP_CODINSEE_437232#705019, CP_CODPAYS_437229#705020, CP_CODPOS_437227#705021, CP_CODUTI_437230#705022, CP_DATMAJ_437231#705023, ORIGINE_440138#705024]
Arguments: coalesced
(12) HashAggregate [codegen id : 4]
Input [7]: [CP_BURDIS_437228#705018, CP_CODINSEE_437232#705019, CP_CODPAYS_437229#705020, CP_CODPOS_437227#705021, CP_CODUTI_437230#705022, CP_DATMAJ_437231#705023, ORIGINE_440138#705024]
Keys [7]: [CP_BURDIS_437228#705018, CP_CODINSEE_437232#705019, CP_CODPAYS_437229#705020, CP_CODPOS_437227#705021, CP_CODUTI_437230#705022, CP_DATMAJ_437231#705023, ORIGINE_440138#705024]
Functions: []
Aggregate Attributes: []
Results: []
(13) HashAggregate [codegen id : 4]
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#705186L]
Results [1]: [count#705187L]
(14) Exchange
Input [1]: [count#705187L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=37921]
(15) ShuffleQueryStage
Output [1]: [count#705187L]
Arguments: 1
(16) HashAggregate [codegen id : 5]
Input [1]: [count#705187L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#705172L]
Results [1]: [count(1)#705172L AS COL_d7f08735-d2f4-4bd8-b2b0-1c93bc9c2267#705174L]
(17) Union
(18) HashAggregate
Input [7]: [CP_BURDIS_437228#705018, CP_CODINSEE_437232#705019, CP_CODPAYS_437229#705020, CP_CODPOS_437227#705021, CP_CODUTI_437230#705022, CP_DATMAJ_437231#705023, ORIGINE_440138#705024]
Keys [7]: [CP_BURDIS_437228#705018, CP_CODINSEE_437232#705019, CP_CODPAYS_437229#705020, CP_CODPOS_437227#705021, CP_CODUTI_437230#705022, CP_DATMAJ_437231#705023, ORIGINE_440138#705024]
Functions: []
Aggregate Attributes: []
Results [7]: [CP_BURDIS_437228#705018, CP_CODINSEE_437232#705019, CP_CODPAYS_437229#705020, CP_CODPOS_437227#705021, CP_CODUTI_437230#705022, CP_DATMAJ_437231#705023, ORIGINE_440138#705024]
(19) Exchange
Input [7]: [CP_BURDIS_437228#705018, CP_CODINSEE_437232#705019, CP_CODPAYS_437229#705020, CP_CODPOS_437227#705021, CP_CODUTI_437230#705022, CP_DATMAJ_437231#705023, ORIGINE_440138#705024]
Arguments: hashpartitioning(CP_BURDIS_437228#705018, CP_CODINSEE_437232#705019, CP_CODPAYS_437229#705020, CP_CODPOS_437227#705021, CP_CODUTI_437230#705022, CP_DATMAJ_437231#705023, ORIGINE_440138#705024, 10), ENSURE_REQUIREMENTS, [plan_id=37705]
(20) HashAggregate
Input [7]: [CP_BURDIS_437228#705018, CP_CODINSEE_437232#705019, CP_CODPAYS_437229#705020, CP_CODPOS_437227#705021, CP_CODUTI_437230#705022, CP_DATMAJ_437231#705023, ORIGINE_440138#705024]
Keys [7]: [CP_BURDIS_437228#705018, CP_CODINSEE_437232#705019, CP_CODPAYS_437229#705020, CP_CODPOS_437227#705021, CP_CODUTI_437230#705022, CP_DATMAJ_437231#705023, ORIGINE_440138#705024]
Functions: []
Aggregate Attributes: []
Results: []
(21) HashAggregate
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#705186L]
Results [1]: [count#705187L]
(22) Exchange
Input [1]: [count#705187L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=37709]
(23) HashAggregate
Input [1]: [count#705187L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#705172L]
Results [1]: [count(1)#705172L AS COL_d7f08735-d2f4-4bd8-b2b0-1c93bc9c2267#705174L]
(24) AdaptiveSparkPlan
Output [1]: [COL_d7f08735-d2f4-4bd8-b2b0-1c93bc9c2267#705174L]
Arguments: isFinalPlan=true