hdh-spark-job - Details for Query 1090

Submitted Time: 2026/10/23 08:18:32
Duration: 0.3 s
Succeeded Jobs: 1096 1097 1098

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: 6 ms"; 5 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 6 ms peak memory: 0.0 B number of output rows: 1 number of sort fallback tasks: 0 avg hash probes per key: 0"]; 6 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 0 ms peak memory: 64.2 MiB number of output rows: 29 number of sort fallback tasks: 0 avg hash probes per key: 1"]; } 7 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 20.3 KiB number of coalesced partitions: 1"]; 8 [labelType="html" label="Exchange shuffle records written: 58 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 3 ms (1 ms, 2 ms, 2 ms (stage 1483.0: task 1333)) 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: 58 local bytes read: 19.5 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)) 39.7 KiB (19.8 KiB, 19.8 KiB, 19.8 KiB (stage 1483.0: task 1334)) 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)) 19.5 KiB (9.8 KiB, 9.8 KiB, 9.8 KiB (stage 1483.0: task 1334))"]; subgraph cluster9 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n54 ms (27 ms, 27 ms, 27 ms (stage 1483.0: task 1334))"; 10 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 4 ms (2 ms, 2 ms, 2 ms (stage 1483.0: task 1334)) peak memory total (min, med, max (stageId: taskId)) 128.5 MiB (64.2 MiB, 64.2 MiB, 64.2 MiB (stage 1483.0: task 1334)) number of output rows: 58 number of sort fallback tasks: 0 avg hash probes per key (min, med, max (stageId: taskId)): (1, 1, 1 (stage 1483.0: task 1334))"]; } 11 [labelType="html" label=" Union "]; subgraph cluster12 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 56 ms"; 13 [labelType="html" label=" Project "]; 14 [labelType="html" label="Scan JDBCRelation((SELECT \"se_numstu\", \"se_numser\", \"se_ser_id\", \"se_sopuid\", \"se_n_ser\", \"se_typexa\", \"se_typprs\", \"se_typser\", \"se_protoc\", \"se_datser\", \"se_heuser\", \"se_modali\", \"se_nb_fic\", \"se_nb_ima\", \"se_taific\", \"se_lieu\", \"se_numcd\", \"se_statut\", \"se_sereff\", \"se_dateff\", \"se_heueff\", \"se_comm_1\", \"se_rappro\", \"se_numdos\", \"se_numdem\", \"se_datmaj\", \"se_heumaj\", \"se_coduti\", \"se_serdsc\", \"se_req_proc_id\", \"se_sch_proc_step_id\", \"se_flarch\", \"se_codts\", \"se_bodypart\", \"se_source\", \"se_frame_ref\", \"se_hide\", \"se_later\", \"se_hidexpl\" FROM \"xplore\".\"h_serie\") as x) [numPartitions=1] number of output rows: 29"]; } subgraph cluster15 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 56 ms"; 16 [labelType="html" label=" Project "]; 17 [labelType="html" label="Scan JDBCRelation((SELECT \"se_numstu\", \"se_numser\", \"se_ser_id\", \"se_sopuid\", \"se_n_ser\", \"se_typexa\", \"se_typprs\", \"se_typser\", \"se_protoc\", \"se_datser\", \"se_heuser\", \"se_modali\", \"se_nb_fic\", \"se_nb_ima\", \"se_taific\", \"se_lieu\", \"se_numcd\", \"se_statut\", \"se_sereff\", \"se_dateff\", \"se_heueff\", \"se_comm_1\", \"se_rappro\", \"se_numdos\", \"se_numdem\", \"se_datmaj\", \"se_heumaj\", \"se_coduti\", \"se_serdsc\", \"se_req_proc_id\", \"se_sch_proc_step_id\", \"se_flarch\", \"se_codts\", \"se_bodypart\", \"se_source\", \"se_frame_ref\", \"se_hide\", \"se_later\", \"se_hidexpl\" FROM \"xplore2\".\"h_serie\") as x) [numPartitions=1] number of output rows: 29"]; } 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=23773]

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

HashAggregate(keys=[ORIGINE_440152#336720, SE_BODYPART_438252#336721, SE_CODTS_438251#336722, SE_CODUTI_438246#336723, SE_COMM_1_438240#336724, SE_DATEFF_438238#336725, SE_DATMAJ_438244#336726, SE_DATSER_438228#336727, SE_FLARCH_438250#336728, SE_FRAME_REF_438254#336729, SE_HEUEFF_438239#336730, SE_HEUMAJ_438245#336731, SE_HEUSER_438229#336732, SE_HIDEXPL_438257#336733, SE_HIDE_438255#336734, SE_LATER_438256#336735, SE_LIEU_438234#336736, SE_MODALI_438230#336737, SE_NB_FIC_438231#336738, SE_NB_IMA_438232#336739, SE_NUMCD_438235#336740, SE_NUMDEM_438243#336741, SE_NUMDOS_438242#336742, SE_NUMSER_438220#336743, ... 16 more fields], functions=[])

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(ORIGINE_440152#336720, SE_BODYPART_438252#336721, SE_CODTS_438251#336722, SE_CODUTI_438246#336723, SE_COMM_1_438240#336724, SE_DATEFF_438238#336725, SE_DATMAJ_438244#336726, SE_DATSER_438228#336727, SE_FLARCH_438250#336728, SE_FRAME_REF_438254#336729, SE_HEUEFF_438239#336730, SE_HEUMAJ_438245#336731, SE_HEUSER_438229#336732, SE_HIDEXPL_438257#336733, SE_HIDE_438255#336734, SE_LATER_438256#336735, SE_LIEU_438234#336736, SE_MODALI_438230#336737, SE_NB_FIC_438231#336738, SE_NB_IMA_438232#336739, SE_NUMCD_438235#336740, SE_NUMDEM_438243#336741, SE_NUMDOS_438242#336742, SE_NUMSER_438220#336743, ... 17 more fields), ENSURE_REQUIREMENTS, [plan_id=23737]

WholeStageCodegen (3)

Union

Project [null AS ORIGINE_440152#336720, se_bodypart#336480 AS SE_BODYPART_438252#336721, se_codts#336479 AS SE_CODTS_438251#336722, se_coduti#336474 AS SE_CODUTI_438246#336723, se_comm_1#336468 AS SE_COMM_1_438240#336724, se_dateff#336466 AS SE_DATEFF_438238#336725, se_datmaj#336472 AS SE_DATMAJ_438244#336726, se_datser#336456 AS SE_DATSER_438228#336727, se_flarch#336478 AS SE_FLARCH_438250#336728, se_frame_ref#336482 AS SE_FRAME_REF_438254#336729, se_heueff#336467 AS SE_HEUEFF_438239#336730, se_heumaj#336473 AS SE_HEUMAJ_438245#336731, se_heuser#336457 AS SE_HEUSER_438229#336732, se_hidexpl#336485 AS SE_HIDEXPL_438257#336733, se_hide#336483 AS SE_HIDE_438255#336734, se_later#336484 AS SE_LATER_438256#336735, se_lieu#336462 AS SE_LIEU_438234#336736, se_modali#336458 AS SE_MODALI_438230#336737, se_nb_fic#336459 AS SE_NB_FIC_438231#336738, se_nb_ima#336460 AS SE_NB_IMA_438232#336739, se_numcd#336463 AS SE_NUMCD_438235#336740, se_numdem#336471 AS SE_NUMDEM_438243#336741, se_numdos#336470 AS SE_NUMDOS_438242#336742, se_numser#336448 AS SE_NUMSER_438220#336743, ... 16 more fields]

Scan JDBCRelation((SELECT "se_numstu", "se_numser", "se_ser_id", "se_sopuid", "se_n_ser", "se_typexa", "se_typprs", "se_typser", "se_protoc", "se_datser", "se_heuser", "se_modali", "se_nb_fic", "se_nb_ima", "se_taific", "se_lieu", "se_numcd", "se_statut", "se_sereff", "se_dateff", "se_heueff", "se_comm_1", "se_rappro", "se_numdos", "se_numdem", "se_datmaj", "se_heumaj", "se_coduti", "se_serdsc", "se_req_proc_id", "se_sch_proc_step_id", "se_flarch", "se_codts", "se_bodypart", "se_source", "se_frame_ref", "se_hide", "se_later", "se_hidexpl" FROM "xplore"."h_serie") as x) [numPartitions=1] [se_bodypart#336480,se_codts#336479,se_coduti#336474,se_comm_1#336468,se_dateff#336466,se_datmaj#336472,se_datser#336456,se_flarch#336478,se_frame_ref#336482,se_heueff#336467,se_heumaj#336473,se_heuser#336457,se_hidexpl#336485,se_hide#336483,se_later#336484,se_lieu#336462,se_modali#336458,se_nb_fic#336459,se_nb_ima#336460,se_numcd#336463,se_numdem#336471,se_numdos#336470,se_numser#336448,se_numstu#336447,... 15 more fields] PushedFilters: [], ReadSchema: struct<se_bodypart:string,se_codts:string,se_coduti:string,se_comm_1:string,se_dateff:string,se_d...

WholeStageCodegen (1)

Project [null AS ORIGINE_440152#337073, se_bodypart#336833 AS SE_BODYPART_438252#337074, se_codts#336832 AS SE_CODTS_438251#337075, se_coduti#336827 AS SE_CODUTI_438246#337076, se_comm_1#336821 AS SE_COMM_1_438240#337077, se_dateff#336819 AS SE_DATEFF_438238#337078, se_datmaj#336825 AS SE_DATMAJ_438244#337079, se_datser#336809 AS SE_DATSER_438228#337080, se_flarch#336831 AS SE_FLARCH_438250#337081, se_frame_ref#336835 AS SE_FRAME_REF_438254#337082, se_heueff#336820 AS SE_HEUEFF_438239#337083, se_heumaj#336826 AS SE_HEUMAJ_438245#337084, se_heuser#336810 AS SE_HEUSER_438229#337085, se_hidexpl#336838 AS SE_HIDEXPL_438257#337086, se_hide#336836 AS SE_HIDE_438255#337087, se_later#336837 AS SE_LATER_438256#337088, se_lieu#336815 AS SE_LIEU_438234#337089, se_modali#336811 AS SE_MODALI_438230#337090, se_nb_fic#336812 AS SE_NB_FIC_438231#337091, se_nb_ima#336813 AS SE_NB_IMA_438232#337092, se_numcd#336816 AS SE_NUMCD_438235#337093, se_numdem#336824 AS SE_NUMDEM_438243#337094, se_numdos#336823 AS SE_NUMDOS_438242#337095, se_numser#336801 AS SE_NUMSER_438220#337096, ... 16 more fields]

Scan JDBCRelation((SELECT "se_numstu", "se_numser", "se_ser_id", "se_sopuid", "se_n_ser", "se_typexa", "se_typprs", "se_typser", "se_protoc", "se_datser", "se_heuser", "se_modali", "se_nb_fic", "se_nb_ima", "se_taific", "se_lieu", "se_numcd", "se_statut", "se_sereff", "se_dateff", "se_heueff", "se_comm_1", "se_rappro", "se_numdos", "se_numdem", "se_datmaj", "se_heumaj", "se_coduti", "se_serdsc", "se_req_proc_id", "se_sch_proc_step_id", "se_flarch", "se_codts", "se_bodypart", "se_source", "se_frame_ref", "se_hide", "se_later", "se_hidexpl" FROM "xplore2"."h_serie") as x) [numPartitions=1] [se_bodypart#336833,se_codts#336832,se_coduti#336827,se_comm_1#336821,se_dateff#336819,se_datmaj#336825,se_datser#336809,se_flarch#336831,se_frame_ref#336835,se_heueff#336820,se_heumaj#336826,se_heuser#336810,se_hidexpl#336838,se_hide#336836,se_later#336837,se_lieu#336815,se_modali#336811,se_nb_fic#336812,se_nb_ima#336813,se_numcd#336816,se_numdem#336824,se_numdos#336823,se_numser#336801,se_numstu#336800,... 15 more fields] PushedFilters: [], ReadSchema: struct<se_bodypart:string,se_codts:string,se_coduti:string,se_comm_1:string,se_dateff:string,se_d...

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=39.7 KiB, rowCount=58)
                     +- Exchange (7)
                        +- * HashAggregate (6)
                           +- Union (5)
                              :- * Project (2)
                              :  +- * Scan JDBCRelation((SELECT "se_numstu", "se_numser", "se_ser_id", "se_sopuid", "se_n_ser", "se_typexa", "se_typprs", "se_typser", "se_protoc", "se_datser", "se_heuser", "se_modali", "se_nb_fic", "se_nb_ima", "se_taific", "se_lieu", "se_numcd", "se_statut", "se_sereff", "se_dateff", "se_heueff", "se_comm_1", "se_rappro", "se_numdos", "se_numdem", "se_datmaj", "se_heumaj", "se_coduti", "se_serdsc", "se_req_proc_id", "se_sch_proc_step_id", "se_flarch", "se_codts", "se_bodypart", "se_source", "se_frame_ref", "se_hide", "se_later", "se_hidexpl" FROM "xplore"."h_serie") as x) [numPartitions=1]  (1)
                              +- * Project (4)
                                 +- * Scan JDBCRelation((SELECT "se_numstu", "se_numser", "se_ser_id", "se_sopuid", "se_n_ser", "se_typexa", "se_typprs", "se_typser", "se_protoc", "se_datser", "se_heuser", "se_modali", "se_nb_fic", "se_nb_ima", "se_taific", "se_lieu", "se_numcd", "se_statut", "se_sereff", "se_dateff", "se_heueff", "se_comm_1", "se_rappro", "se_numdos", "se_numdem", "se_datmaj", "se_heumaj", "se_coduti", "se_serdsc", "se_req_proc_id", "se_sch_proc_step_id", "se_flarch", "se_codts", "se_bodypart", "se_source", "se_frame_ref", "se_hide", "se_later", "se_hidexpl" FROM "xplore2"."h_serie") 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 "se_numstu", "se_numser", "se_ser_id", "se_sopuid", "se_n_ser", "se_typexa", "se_typprs", "se_typser", "se_protoc", "se_datser", "se_heuser", "se_modali", "se_nb_fic", "se_nb_ima", "se_taific", "se_lieu", "se_numcd", "se_statut", "se_sereff", "se_dateff", "se_heueff", "se_comm_1", "se_rappro", "se_numdos", "se_numdem", "se_datmaj", "se_heumaj", "se_coduti", "se_serdsc", "se_req_proc_id", "se_sch_proc_step_id", "se_flarch", "se_codts", "se_bodypart", "se_source", "se_frame_ref", "se_hide", "se_later", "se_hidexpl" FROM "xplore"."h_serie") as x) [numPartitions=1]  (1)
                     +- Project (4)
                        +- Scan JDBCRelation((SELECT "se_numstu", "se_numser", "se_ser_id", "se_sopuid", "se_n_ser", "se_typexa", "se_typprs", "se_typser", "se_protoc", "se_datser", "se_heuser", "se_modali", "se_nb_fic", "se_nb_ima", "se_taific", "se_lieu", "se_numcd", "se_statut", "se_sereff", "se_dateff", "se_heueff", "se_comm_1", "se_rappro", "se_numdos", "se_numdem", "se_datmaj", "se_heumaj", "se_coduti", "se_serdsc", "se_req_proc_id", "se_sch_proc_step_id", "se_flarch", "se_codts", "se_bodypart", "se_source", "se_frame_ref", "se_hide", "se_later", "se_hidexpl" FROM "xplore2"."h_serie") as x) [numPartitions=1]  (3)


(1) Scan JDBCRelation((SELECT "se_numstu", "se_numser", "se_ser_id", "se_sopuid", "se_n_ser", "se_typexa", "se_typprs", "se_typser", "se_protoc", "se_datser", "se_heuser", "se_modali", "se_nb_fic", "se_nb_ima", "se_taific", "se_lieu", "se_numcd", "se_statut", "se_sereff", "se_dateff", "se_heueff", "se_comm_1", "se_rappro", "se_numdos", "se_numdem", "se_datmaj", "se_heumaj", "se_coduti", "se_serdsc", "se_req_proc_id", "se_sch_proc_step_id", "se_flarch", "se_codts", "se_bodypart", "se_source", "se_frame_ref", "se_hide", "se_later", "se_hidexpl" FROM "xplore"."h_serie") as x) [numPartitions=1]  [codegen id : 1]
Output [39]: [se_bodypart#336480, se_codts#336479, se_coduti#336474, se_comm_1#336468, se_dateff#336466, se_datmaj#336472, se_datser#336456, se_flarch#336478, se_frame_ref#336482, se_heueff#336467, se_heumaj#336473, se_heuser#336457, se_hidexpl#336485, se_hide#336483, se_later#336484, se_lieu#336462, se_modali#336458, se_nb_fic#336459, se_nb_ima#336460, se_numcd#336463, se_numdem#336471, se_numdos#336470, se_numser#336448, se_numstu#336447, se_n_ser#336451, se_protoc#336455, se_rappro#336469, se_req_proc_id#336476, se_sch_proc_step_id#336477, se_serdsc#336475, se_sereff#336465, se_ser_id#336449, se_sopuid#336450, se_source#336481, se_statut#336464, se_taific#336461, se_typexa#336452, se_typprs#336453, se_typser#336454]
ReadSchema: struct<se_bodypart:string,se_codts:string,se_coduti:string,se_comm_1:string,se_dateff:string,se_datmaj:string,se_datser:string,se_flarch:string,se_frame_ref:string,se_heueff:string,se_heumaj:string,se_heuser:string,se_hidexpl:string,se_hide:string,se_later:string,se_lieu:string,se_modali:string,se_nb_fic:string,se_nb_ima:string,se_numcd:string,se_numdem:string,se_numdos:string,se_numser:string,se_numstu:string,se_n_ser:string,se_protoc:string,se_rappro:string,se_req_proc_id:string,se_sch_proc_step_id:string,se_serdsc:string,se_sereff:string,se_ser_id:string,se_sopuid:string,se_source:string,se_statut:string,se_taific:string,se_typexa:string,se_typprs:string,se_typser:string>

(2) Project [codegen id : 1]
Output [40]: [null AS ORIGINE_440152#336720, se_bodypart#336480 AS SE_BODYPART_438252#336721, se_codts#336479 AS SE_CODTS_438251#336722, se_coduti#336474 AS SE_CODUTI_438246#336723, se_comm_1#336468 AS SE_COMM_1_438240#336724, se_dateff#336466 AS SE_DATEFF_438238#336725, se_datmaj#336472 AS SE_DATMAJ_438244#336726, se_datser#336456 AS SE_DATSER_438228#336727, se_flarch#336478 AS SE_FLARCH_438250#336728, se_frame_ref#336482 AS SE_FRAME_REF_438254#336729, se_heueff#336467 AS SE_HEUEFF_438239#336730, se_heumaj#336473 AS SE_HEUMAJ_438245#336731, se_heuser#336457 AS SE_HEUSER_438229#336732, se_hidexpl#336485 AS SE_HIDEXPL_438257#336733, se_hide#336483 AS SE_HIDE_438255#336734, se_later#336484 AS SE_LATER_438256#336735, se_lieu#336462 AS SE_LIEU_438234#336736, se_modali#336458 AS SE_MODALI_438230#336737, se_nb_fic#336459 AS SE_NB_FIC_438231#336738, se_nb_ima#336460 AS SE_NB_IMA_438232#336739, se_numcd#336463 AS SE_NUMCD_438235#336740, se_numdem#336471 AS SE_NUMDEM_438243#336741, se_numdos#336470 AS SE_NUMDOS_438242#336742, se_numser#336448 AS SE_NUMSER_438220#336743, se_numstu#336447 AS SE_NUMSTU_438219#336744, se_n_ser#336451 AS SE_N_SER_438223#336745, se_protoc#336455 AS SE_PROTOC_438227#336746, se_rappro#336469 AS SE_RAPPRO_438241#336747, se_req_proc_id#336476 AS SE_REQ_PROC_ID_438248#336748, se_sch_proc_step_id#336477 AS SE_SCH_PROC_STE_438249#336749, se_serdsc#336475 AS SE_SERDSC_438247#336750, se_sereff#336465 AS SE_SEREFF_438237#336751, se_ser_id#336449 AS SE_SER_ID_438221#336752, se_sopuid#336450 AS SE_SOPUID_438222#336753, se_source#336481 AS SE_SOURCE_438253#336754, se_statut#336464 AS SE_STATUT_438236#336755, se_taific#336461 AS SE_TAIFIC_438233#336756, se_typexa#336452 AS SE_TYPEXA_438224#336757, se_typprs#336453 AS SE_TYPPRS_438225#336758, se_typser#336454 AS SE_TYPSER_438226#336759]
Input [39]: [se_bodypart#336480, se_codts#336479, se_coduti#336474, se_comm_1#336468, se_dateff#336466, se_datmaj#336472, se_datser#336456, se_flarch#336478, se_frame_ref#336482, se_heueff#336467, se_heumaj#336473, se_heuser#336457, se_hidexpl#336485, se_hide#336483, se_later#336484, se_lieu#336462, se_modali#336458, se_nb_fic#336459, se_nb_ima#336460, se_numcd#336463, se_numdem#336471, se_numdos#336470, se_numser#336448, se_numstu#336447, se_n_ser#336451, se_protoc#336455, se_rappro#336469, se_req_proc_id#336476, se_sch_proc_step_id#336477, se_serdsc#336475, se_sereff#336465, se_ser_id#336449, se_sopuid#336450, se_source#336481, se_statut#336464, se_taific#336461, se_typexa#336452, se_typprs#336453, se_typser#336454]

(3) Scan JDBCRelation((SELECT "se_numstu", "se_numser", "se_ser_id", "se_sopuid", "se_n_ser", "se_typexa", "se_typprs", "se_typser", "se_protoc", "se_datser", "se_heuser", "se_modali", "se_nb_fic", "se_nb_ima", "se_taific", "se_lieu", "se_numcd", "se_statut", "se_sereff", "se_dateff", "se_heueff", "se_comm_1", "se_rappro", "se_numdos", "se_numdem", "se_datmaj", "se_heumaj", "se_coduti", "se_serdsc", "se_req_proc_id", "se_sch_proc_step_id", "se_flarch", "se_codts", "se_bodypart", "se_source", "se_frame_ref", "se_hide", "se_later", "se_hidexpl" FROM "xplore2"."h_serie") as x) [numPartitions=1]  [codegen id : 2]
Output [39]: [se_bodypart#336833, se_codts#336832, se_coduti#336827, se_comm_1#336821, se_dateff#336819, se_datmaj#336825, se_datser#336809, se_flarch#336831, se_frame_ref#336835, se_heueff#336820, se_heumaj#336826, se_heuser#336810, se_hidexpl#336838, se_hide#336836, se_later#336837, se_lieu#336815, se_modali#336811, se_nb_fic#336812, se_nb_ima#336813, se_numcd#336816, se_numdem#336824, se_numdos#336823, se_numser#336801, se_numstu#336800, se_n_ser#336804, se_protoc#336808, se_rappro#336822, se_req_proc_id#336829, se_sch_proc_step_id#336830, se_serdsc#336828, se_sereff#336818, se_ser_id#336802, se_sopuid#336803, se_source#336834, se_statut#336817, se_taific#336814, se_typexa#336805, se_typprs#336806, se_typser#336807]
ReadSchema: struct<se_bodypart:string,se_codts:string,se_coduti:string,se_comm_1:string,se_dateff:string,se_datmaj:string,se_datser:string,se_flarch:string,se_frame_ref:string,se_heueff:string,se_heumaj:string,se_heuser:string,se_hidexpl:string,se_hide:string,se_later:string,se_lieu:string,se_modali:string,se_nb_fic:string,se_nb_ima:string,se_numcd:string,se_numdem:string,se_numdos:string,se_numser:string,se_numstu:string,se_n_ser:string,se_protoc:string,se_rappro:string,se_req_proc_id:string,se_sch_proc_step_id:string,se_serdsc:string,se_sereff:string,se_ser_id:string,se_sopuid:string,se_source:string,se_statut:string,se_taific:string,se_typexa:string,se_typprs:string,se_typser:string>

(4) Project [codegen id : 2]
Output [40]: [null AS ORIGINE_440152#337073, se_bodypart#336833 AS SE_BODYPART_438252#337074, se_codts#336832 AS SE_CODTS_438251#337075, se_coduti#336827 AS SE_CODUTI_438246#337076, se_comm_1#336821 AS SE_COMM_1_438240#337077, se_dateff#336819 AS SE_DATEFF_438238#337078, se_datmaj#336825 AS SE_DATMAJ_438244#337079, se_datser#336809 AS SE_DATSER_438228#337080, se_flarch#336831 AS SE_FLARCH_438250#337081, se_frame_ref#336835 AS SE_FRAME_REF_438254#337082, se_heueff#336820 AS SE_HEUEFF_438239#337083, se_heumaj#336826 AS SE_HEUMAJ_438245#337084, se_heuser#336810 AS SE_HEUSER_438229#337085, se_hidexpl#336838 AS SE_HIDEXPL_438257#337086, se_hide#336836 AS SE_HIDE_438255#337087, se_later#336837 AS SE_LATER_438256#337088, se_lieu#336815 AS SE_LIEU_438234#337089, se_modali#336811 AS SE_MODALI_438230#337090, se_nb_fic#336812 AS SE_NB_FIC_438231#337091, se_nb_ima#336813 AS SE_NB_IMA_438232#337092, se_numcd#336816 AS SE_NUMCD_438235#337093, se_numdem#336824 AS SE_NUMDEM_438243#337094, se_numdos#336823 AS SE_NUMDOS_438242#337095, se_numser#336801 AS SE_NUMSER_438220#337096, se_numstu#336800 AS SE_NUMSTU_438219#337097, se_n_ser#336804 AS SE_N_SER_438223#337098, se_protoc#336808 AS SE_PROTOC_438227#337099, se_rappro#336822 AS SE_RAPPRO_438241#337100, se_req_proc_id#336829 AS SE_REQ_PROC_ID_438248#337101, se_sch_proc_step_id#336830 AS SE_SCH_PROC_STE_438249#337102, se_serdsc#336828 AS SE_SERDSC_438247#337103, se_sereff#336818 AS SE_SEREFF_438237#337104, se_ser_id#336802 AS SE_SER_ID_438221#337105, se_sopuid#336803 AS SE_SOPUID_438222#337106, se_source#336834 AS SE_SOURCE_438253#337107, se_statut#336817 AS SE_STATUT_438236#337108, se_taific#336814 AS SE_TAIFIC_438233#337109, se_typexa#336805 AS SE_TYPEXA_438224#337110, se_typprs#336806 AS SE_TYPPRS_438225#337111, se_typser#336807 AS SE_TYPSER_438226#337112]
Input [39]: [se_bodypart#336833, se_codts#336832, se_coduti#336827, se_comm_1#336821, se_dateff#336819, se_datmaj#336825, se_datser#336809, se_flarch#336831, se_frame_ref#336835, se_heueff#336820, se_heumaj#336826, se_heuser#336810, se_hidexpl#336838, se_hide#336836, se_later#336837, se_lieu#336815, se_modali#336811, se_nb_fic#336812, se_nb_ima#336813, se_numcd#336816, se_numdem#336824, se_numdos#336823, se_numser#336801, se_numstu#336800, se_n_ser#336804, se_protoc#336808, se_rappro#336822, se_req_proc_id#336829, se_sch_proc_step_id#336830, se_serdsc#336828, se_sereff#336818, se_ser_id#336802, se_sopuid#336803, se_source#336834, se_statut#336817, se_taific#336814, se_typexa#336805, se_typprs#336806, se_typser#336807]

(5) Union

(6) HashAggregate [codegen id : 3]
Input [40]: [ORIGINE_440152#336720, SE_BODYPART_438252#336721, SE_CODTS_438251#336722, SE_CODUTI_438246#336723, SE_COMM_1_438240#336724, SE_DATEFF_438238#336725, SE_DATMAJ_438244#336726, SE_DATSER_438228#336727, SE_FLARCH_438250#336728, SE_FRAME_REF_438254#336729, SE_HEUEFF_438239#336730, SE_HEUMAJ_438245#336731, SE_HEUSER_438229#336732, SE_HIDEXPL_438257#336733, SE_HIDE_438255#336734, SE_LATER_438256#336735, SE_LIEU_438234#336736, SE_MODALI_438230#336737, SE_NB_FIC_438231#336738, SE_NB_IMA_438232#336739, SE_NUMCD_438235#336740, SE_NUMDEM_438243#336741, SE_NUMDOS_438242#336742, SE_NUMSER_438220#336743, SE_NUMSTU_438219#336744, SE_N_SER_438223#336745, SE_PROTOC_438227#336746, SE_RAPPRO_438241#336747, SE_REQ_PROC_ID_438248#336748, SE_SCH_PROC_STE_438249#336749, SE_SERDSC_438247#336750, SE_SEREFF_438237#336751, SE_SER_ID_438221#336752, SE_SOPUID_438222#336753, SE_SOURCE_438253#336754, SE_STATUT_438236#336755, SE_TAIFIC_438233#336756, SE_TYPEXA_438224#336757, SE_TYPPRS_438225#336758, SE_TYPSER_438226#336759]
Keys [40]: [ORIGINE_440152#336720, SE_BODYPART_438252#336721, SE_CODTS_438251#336722, SE_CODUTI_438246#336723, SE_COMM_1_438240#336724, SE_DATEFF_438238#336725, SE_DATMAJ_438244#336726, SE_DATSER_438228#336727, SE_FLARCH_438250#336728, SE_FRAME_REF_438254#336729, SE_HEUEFF_438239#336730, SE_HEUMAJ_438245#336731, SE_HEUSER_438229#336732, SE_HIDEXPL_438257#336733, SE_HIDE_438255#336734, SE_LATER_438256#336735, SE_LIEU_438234#336736, SE_MODALI_438230#336737, SE_NB_FIC_438231#336738, SE_NB_IMA_438232#336739, SE_NUMCD_438235#336740, SE_NUMDEM_438243#336741, SE_NUMDOS_438242#336742, SE_NUMSER_438220#336743, SE_NUMSTU_438219#336744, SE_N_SER_438223#336745, SE_PROTOC_438227#336746, SE_RAPPRO_438241#336747, SE_REQ_PROC_ID_438248#336748, SE_SCH_PROC_STE_438249#336749, SE_SERDSC_438247#336750, SE_SEREFF_438237#336751, SE_SER_ID_438221#336752, SE_SOPUID_438222#336753, SE_SOURCE_438253#336754, SE_STATUT_438236#336755, SE_TAIFIC_438233#336756, SE_TYPEXA_438224#336757, SE_TYPPRS_438225#336758, SE_TYPSER_438226#336759]
Functions: []
Aggregate Attributes: []
Results [40]: [ORIGINE_440152#336720, SE_BODYPART_438252#336721, SE_CODTS_438251#336722, SE_CODUTI_438246#336723, SE_COMM_1_438240#336724, SE_DATEFF_438238#336725, SE_DATMAJ_438244#336726, SE_DATSER_438228#336727, SE_FLARCH_438250#336728, SE_FRAME_REF_438254#336729, SE_HEUEFF_438239#336730, SE_HEUMAJ_438245#336731, SE_HEUSER_438229#336732, SE_HIDEXPL_438257#336733, SE_HIDE_438255#336734, SE_LATER_438256#336735, SE_LIEU_438234#336736, SE_MODALI_438230#336737, SE_NB_FIC_438231#336738, SE_NB_IMA_438232#336739, SE_NUMCD_438235#336740, SE_NUMDEM_438243#336741, SE_NUMDOS_438242#336742, SE_NUMSER_438220#336743, SE_NUMSTU_438219#336744, SE_N_SER_438223#336745, SE_PROTOC_438227#336746, SE_RAPPRO_438241#336747, SE_REQ_PROC_ID_438248#336748, SE_SCH_PROC_STE_438249#336749, SE_SERDSC_438247#336750, SE_SEREFF_438237#336751, SE_SER_ID_438221#336752, SE_SOPUID_438222#336753, SE_SOURCE_438253#336754, SE_STATUT_438236#336755, SE_TAIFIC_438233#336756, SE_TYPEXA_438224#336757, SE_TYPPRS_438225#336758, SE_TYPSER_438226#336759]

(7) Exchange
Input [40]: [ORIGINE_440152#336720, SE_BODYPART_438252#336721, SE_CODTS_438251#336722, SE_CODUTI_438246#336723, SE_COMM_1_438240#336724, SE_DATEFF_438238#336725, SE_DATMAJ_438244#336726, SE_DATSER_438228#336727, SE_FLARCH_438250#336728, SE_FRAME_REF_438254#336729, SE_HEUEFF_438239#336730, SE_HEUMAJ_438245#336731, SE_HEUSER_438229#336732, SE_HIDEXPL_438257#336733, SE_HIDE_438255#336734, SE_LATER_438256#336735, SE_LIEU_438234#336736, SE_MODALI_438230#336737, SE_NB_FIC_438231#336738, SE_NB_IMA_438232#336739, SE_NUMCD_438235#336740, SE_NUMDEM_438243#336741, SE_NUMDOS_438242#336742, SE_NUMSER_438220#336743, SE_NUMSTU_438219#336744, SE_N_SER_438223#336745, SE_PROTOC_438227#336746, SE_RAPPRO_438241#336747, SE_REQ_PROC_ID_438248#336748, SE_SCH_PROC_STE_438249#336749, SE_SERDSC_438247#336750, SE_SEREFF_438237#336751, SE_SER_ID_438221#336752, SE_SOPUID_438222#336753, SE_SOURCE_438253#336754, SE_STATUT_438236#336755, SE_TAIFIC_438233#336756, SE_TYPEXA_438224#336757, SE_TYPPRS_438225#336758, SE_TYPSER_438226#336759]
Arguments: hashpartitioning(ORIGINE_440152#336720, SE_BODYPART_438252#336721, SE_CODTS_438251#336722, SE_CODUTI_438246#336723, SE_COMM_1_438240#336724, SE_DATEFF_438238#336725, SE_DATMAJ_438244#336726, SE_DATSER_438228#336727, SE_FLARCH_438250#336728, SE_FRAME_REF_438254#336729, SE_HEUEFF_438239#336730, SE_HEUMAJ_438245#336731, SE_HEUSER_438229#336732, SE_HIDEXPL_438257#336733, SE_HIDE_438255#336734, SE_LATER_438256#336735, SE_LIEU_438234#336736, SE_MODALI_438230#336737, SE_NB_FIC_438231#336738, SE_NB_IMA_438232#336739, SE_NUMCD_438235#336740, SE_NUMDEM_438243#336741, SE_NUMDOS_438242#336742, SE_NUMSER_438220#336743, ... 17 more fields), ENSURE_REQUIREMENTS, [plan_id=23737]

(8) ShuffleQueryStage
Output [40]: [ORIGINE_440152#336720, SE_BODYPART_438252#336721, SE_CODTS_438251#336722, SE_CODUTI_438246#336723, SE_COMM_1_438240#336724, SE_DATEFF_438238#336725, SE_DATMAJ_438244#336726, SE_DATSER_438228#336727, SE_FLARCH_438250#336728, SE_FRAME_REF_438254#336729, SE_HEUEFF_438239#336730, SE_HEUMAJ_438245#336731, SE_HEUSER_438229#336732, SE_HIDEXPL_438257#336733, SE_HIDE_438255#336734, SE_LATER_438256#336735, SE_LIEU_438234#336736, SE_MODALI_438230#336737, SE_NB_FIC_438231#336738, SE_NB_IMA_438232#336739, SE_NUMCD_438235#336740, SE_NUMDEM_438243#336741, SE_NUMDOS_438242#336742, SE_NUMSER_438220#336743, SE_NUMSTU_438219#336744, SE_N_SER_438223#336745, SE_PROTOC_438227#336746, SE_RAPPRO_438241#336747, SE_REQ_PROC_ID_438248#336748, SE_SCH_PROC_STE_438249#336749, SE_SERDSC_438247#336750, SE_SEREFF_438237#336751, SE_SER_ID_438221#336752, SE_SOPUID_438222#336753, SE_SOURCE_438253#336754, SE_STATUT_438236#336755, SE_TAIFIC_438233#336756, SE_TYPEXA_438224#336757, SE_TYPPRS_438225#336758, SE_TYPSER_438226#336759]
Arguments: 0

(9) AQEShuffleRead
Input [40]: [ORIGINE_440152#336720, SE_BODYPART_438252#336721, SE_CODTS_438251#336722, SE_CODUTI_438246#336723, SE_COMM_1_438240#336724, SE_DATEFF_438238#336725, SE_DATMAJ_438244#336726, SE_DATSER_438228#336727, SE_FLARCH_438250#336728, SE_FRAME_REF_438254#336729, SE_HEUEFF_438239#336730, SE_HEUMAJ_438245#336731, SE_HEUSER_438229#336732, SE_HIDEXPL_438257#336733, SE_HIDE_438255#336734, SE_LATER_438256#336735, SE_LIEU_438234#336736, SE_MODALI_438230#336737, SE_NB_FIC_438231#336738, SE_NB_IMA_438232#336739, SE_NUMCD_438235#336740, SE_NUMDEM_438243#336741, SE_NUMDOS_438242#336742, SE_NUMSER_438220#336743, SE_NUMSTU_438219#336744, SE_N_SER_438223#336745, SE_PROTOC_438227#336746, SE_RAPPRO_438241#336747, SE_REQ_PROC_ID_438248#336748, SE_SCH_PROC_STE_438249#336749, SE_SERDSC_438247#336750, SE_SEREFF_438237#336751, SE_SER_ID_438221#336752, SE_SOPUID_438222#336753, SE_SOURCE_438253#336754, SE_STATUT_438236#336755, SE_TAIFIC_438233#336756, SE_TYPEXA_438224#336757, SE_TYPPRS_438225#336758, SE_TYPSER_438226#336759]
Arguments: coalesced

(10) HashAggregate [codegen id : 4]
Input [40]: [ORIGINE_440152#336720, SE_BODYPART_438252#336721, SE_CODTS_438251#336722, SE_CODUTI_438246#336723, SE_COMM_1_438240#336724, SE_DATEFF_438238#336725, SE_DATMAJ_438244#336726, SE_DATSER_438228#336727, SE_FLARCH_438250#336728, SE_FRAME_REF_438254#336729, SE_HEUEFF_438239#336730, SE_HEUMAJ_438245#336731, SE_HEUSER_438229#336732, SE_HIDEXPL_438257#336733, SE_HIDE_438255#336734, SE_LATER_438256#336735, SE_LIEU_438234#336736, SE_MODALI_438230#336737, SE_NB_FIC_438231#336738, SE_NB_IMA_438232#336739, SE_NUMCD_438235#336740, SE_NUMDEM_438243#336741, SE_NUMDOS_438242#336742, SE_NUMSER_438220#336743, SE_NUMSTU_438219#336744, SE_N_SER_438223#336745, SE_PROTOC_438227#336746, SE_RAPPRO_438241#336747, SE_REQ_PROC_ID_438248#336748, SE_SCH_PROC_STE_438249#336749, SE_SERDSC_438247#336750, SE_SEREFF_438237#336751, SE_SER_ID_438221#336752, SE_SOPUID_438222#336753, SE_SOURCE_438253#336754, SE_STATUT_438236#336755, SE_TAIFIC_438233#336756, SE_TYPEXA_438224#336757, SE_TYPPRS_438225#336758, SE_TYPSER_438226#336759]
Keys [40]: [ORIGINE_440152#336720, SE_BODYPART_438252#336721, SE_CODTS_438251#336722, SE_CODUTI_438246#336723, SE_COMM_1_438240#336724, SE_DATEFF_438238#336725, SE_DATMAJ_438244#336726, SE_DATSER_438228#336727, SE_FLARCH_438250#336728, SE_FRAME_REF_438254#336729, SE_HEUEFF_438239#336730, SE_HEUMAJ_438245#336731, SE_HEUSER_438229#336732, SE_HIDEXPL_438257#336733, SE_HIDE_438255#336734, SE_LATER_438256#336735, SE_LIEU_438234#336736, SE_MODALI_438230#336737, SE_NB_FIC_438231#336738, SE_NB_IMA_438232#336739, SE_NUMCD_438235#336740, SE_NUMDEM_438243#336741, SE_NUMDOS_438242#336742, SE_NUMSER_438220#336743, SE_NUMSTU_438219#336744, SE_N_SER_438223#336745, SE_PROTOC_438227#336746, SE_RAPPRO_438241#336747, SE_REQ_PROC_ID_438248#336748, SE_SCH_PROC_STE_438249#336749, SE_SERDSC_438247#336750, SE_SEREFF_438237#336751, SE_SER_ID_438221#336752, SE_SOPUID_438222#336753, SE_SOURCE_438253#336754, SE_STATUT_438236#336755, SE_TAIFIC_438233#336756, SE_TYPEXA_438224#336757, SE_TYPPRS_438225#336758, SE_TYPSER_438226#336759]
Functions: []
Aggregate Attributes: []
Results: []

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

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

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

(14) HashAggregate [codegen id : 5]
Input [1]: [count#337797L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#337793L]
Results [1]: [count(1)#337793L AS count#337794L]

(15) Union

(16) HashAggregate
Input [40]: [ORIGINE_440152#336720, SE_BODYPART_438252#336721, SE_CODTS_438251#336722, SE_CODUTI_438246#336723, SE_COMM_1_438240#336724, SE_DATEFF_438238#336725, SE_DATMAJ_438244#336726, SE_DATSER_438228#336727, SE_FLARCH_438250#336728, SE_FRAME_REF_438254#336729, SE_HEUEFF_438239#336730, SE_HEUMAJ_438245#336731, SE_HEUSER_438229#336732, SE_HIDEXPL_438257#336733, SE_HIDE_438255#336734, SE_LATER_438256#336735, SE_LIEU_438234#336736, SE_MODALI_438230#336737, SE_NB_FIC_438231#336738, SE_NB_IMA_438232#336739, SE_NUMCD_438235#336740, SE_NUMDEM_438243#336741, SE_NUMDOS_438242#336742, SE_NUMSER_438220#336743, SE_NUMSTU_438219#336744, SE_N_SER_438223#336745, SE_PROTOC_438227#336746, SE_RAPPRO_438241#336747, SE_REQ_PROC_ID_438248#336748, SE_SCH_PROC_STE_438249#336749, SE_SERDSC_438247#336750, SE_SEREFF_438237#336751, SE_SER_ID_438221#336752, SE_SOPUID_438222#336753, SE_SOURCE_438253#336754, SE_STATUT_438236#336755, SE_TAIFIC_438233#336756, SE_TYPEXA_438224#336757, SE_TYPPRS_438225#336758, SE_TYPSER_438226#336759]
Keys [40]: [ORIGINE_440152#336720, SE_BODYPART_438252#336721, SE_CODTS_438251#336722, SE_CODUTI_438246#336723, SE_COMM_1_438240#336724, SE_DATEFF_438238#336725, SE_DATMAJ_438244#336726, SE_DATSER_438228#336727, SE_FLARCH_438250#336728, SE_FRAME_REF_438254#336729, SE_HEUEFF_438239#336730, SE_HEUMAJ_438245#336731, SE_HEUSER_438229#336732, SE_HIDEXPL_438257#336733, SE_HIDE_438255#336734, SE_LATER_438256#336735, SE_LIEU_438234#336736, SE_MODALI_438230#336737, SE_NB_FIC_438231#336738, SE_NB_IMA_438232#336739, SE_NUMCD_438235#336740, SE_NUMDEM_438243#336741, SE_NUMDOS_438242#336742, SE_NUMSER_438220#336743, SE_NUMSTU_438219#336744, SE_N_SER_438223#336745, SE_PROTOC_438227#336746, SE_RAPPRO_438241#336747, SE_REQ_PROC_ID_438248#336748, SE_SCH_PROC_STE_438249#336749, SE_SERDSC_438247#336750, SE_SEREFF_438237#336751, SE_SER_ID_438221#336752, SE_SOPUID_438222#336753, SE_SOURCE_438253#336754, SE_STATUT_438236#336755, SE_TAIFIC_438233#336756, SE_TYPEXA_438224#336757, SE_TYPPRS_438225#336758, SE_TYPSER_438226#336759]
Functions: []
Aggregate Attributes: []
Results [40]: [ORIGINE_440152#336720, SE_BODYPART_438252#336721, SE_CODTS_438251#336722, SE_CODUTI_438246#336723, SE_COMM_1_438240#336724, SE_DATEFF_438238#336725, SE_DATMAJ_438244#336726, SE_DATSER_438228#336727, SE_FLARCH_438250#336728, SE_FRAME_REF_438254#336729, SE_HEUEFF_438239#336730, SE_HEUMAJ_438245#336731, SE_HEUSER_438229#336732, SE_HIDEXPL_438257#336733, SE_HIDE_438255#336734, SE_LATER_438256#336735, SE_LIEU_438234#336736, SE_MODALI_438230#336737, SE_NB_FIC_438231#336738, SE_NB_IMA_438232#336739, SE_NUMCD_438235#336740, SE_NUMDEM_438243#336741, SE_NUMDOS_438242#336742, SE_NUMSER_438220#336743, SE_NUMSTU_438219#336744, SE_N_SER_438223#336745, SE_PROTOC_438227#336746, SE_RAPPRO_438241#336747, SE_REQ_PROC_ID_438248#336748, SE_SCH_PROC_STE_438249#336749, SE_SERDSC_438247#336750, SE_SEREFF_438237#336751, SE_SER_ID_438221#336752, SE_SOPUID_438222#336753, SE_SOURCE_438253#336754, SE_STATUT_438236#336755, SE_TAIFIC_438233#336756, SE_TYPEXA_438224#336757, SE_TYPPRS_438225#336758, SE_TYPSER_438226#336759]

(17) Exchange
Input [40]: [ORIGINE_440152#336720, SE_BODYPART_438252#336721, SE_CODTS_438251#336722, SE_CODUTI_438246#336723, SE_COMM_1_438240#336724, SE_DATEFF_438238#336725, SE_DATMAJ_438244#336726, SE_DATSER_438228#336727, SE_FLARCH_438250#336728, SE_FRAME_REF_438254#336729, SE_HEUEFF_438239#336730, SE_HEUMAJ_438245#336731, SE_HEUSER_438229#336732, SE_HIDEXPL_438257#336733, SE_HIDE_438255#336734, SE_LATER_438256#336735, SE_LIEU_438234#336736, SE_MODALI_438230#336737, SE_NB_FIC_438231#336738, SE_NB_IMA_438232#336739, SE_NUMCD_438235#336740, SE_NUMDEM_438243#336741, SE_NUMDOS_438242#336742, SE_NUMSER_438220#336743, SE_NUMSTU_438219#336744, SE_N_SER_438223#336745, SE_PROTOC_438227#336746, SE_RAPPRO_438241#336747, SE_REQ_PROC_ID_438248#336748, SE_SCH_PROC_STE_438249#336749, SE_SERDSC_438247#336750, SE_SEREFF_438237#336751, SE_SER_ID_438221#336752, SE_SOPUID_438222#336753, SE_SOURCE_438253#336754, SE_STATUT_438236#336755, SE_TAIFIC_438233#336756, SE_TYPEXA_438224#336757, SE_TYPPRS_438225#336758, SE_TYPSER_438226#336759]
Arguments: hashpartitioning(ORIGINE_440152#336720, SE_BODYPART_438252#336721, SE_CODTS_438251#336722, SE_CODUTI_438246#336723, SE_COMM_1_438240#336724, SE_DATEFF_438238#336725, SE_DATMAJ_438244#336726, SE_DATSER_438228#336727, SE_FLARCH_438250#336728, SE_FRAME_REF_438254#336729, SE_HEUEFF_438239#336730, SE_HEUMAJ_438245#336731, SE_HEUSER_438229#336732, SE_HIDEXPL_438257#336733, SE_HIDE_438255#336734, SE_LATER_438256#336735, SE_LIEU_438234#336736, SE_MODALI_438230#336737, SE_NB_FIC_438231#336738, SE_NB_IMA_438232#336739, SE_NUMCD_438235#336740, SE_NUMDEM_438243#336741, SE_NUMDOS_438242#336742, SE_NUMSER_438220#336743, ... 17 more fields), ENSURE_REQUIREMENTS, [plan_id=23709]

(18) HashAggregate
Input [40]: [ORIGINE_440152#336720, SE_BODYPART_438252#336721, SE_CODTS_438251#336722, SE_CODUTI_438246#336723, SE_COMM_1_438240#336724, SE_DATEFF_438238#336725, SE_DATMAJ_438244#336726, SE_DATSER_438228#336727, SE_FLARCH_438250#336728, SE_FRAME_REF_438254#336729, SE_HEUEFF_438239#336730, SE_HEUMAJ_438245#336731, SE_HEUSER_438229#336732, SE_HIDEXPL_438257#336733, SE_HIDE_438255#336734, SE_LATER_438256#336735, SE_LIEU_438234#336736, SE_MODALI_438230#336737, SE_NB_FIC_438231#336738, SE_NB_IMA_438232#336739, SE_NUMCD_438235#336740, SE_NUMDEM_438243#336741, SE_NUMDOS_438242#336742, SE_NUMSER_438220#336743, SE_NUMSTU_438219#336744, SE_N_SER_438223#336745, SE_PROTOC_438227#336746, SE_RAPPRO_438241#336747, SE_REQ_PROC_ID_438248#336748, SE_SCH_PROC_STE_438249#336749, SE_SERDSC_438247#336750, SE_SEREFF_438237#336751, SE_SER_ID_438221#336752, SE_SOPUID_438222#336753, SE_SOURCE_438253#336754, SE_STATUT_438236#336755, SE_TAIFIC_438233#336756, SE_TYPEXA_438224#336757, SE_TYPPRS_438225#336758, SE_TYPSER_438226#336759]
Keys [40]: [ORIGINE_440152#336720, SE_BODYPART_438252#336721, SE_CODTS_438251#336722, SE_CODUTI_438246#336723, SE_COMM_1_438240#336724, SE_DATEFF_438238#336725, SE_DATMAJ_438244#336726, SE_DATSER_438228#336727, SE_FLARCH_438250#336728, SE_FRAME_REF_438254#336729, SE_HEUEFF_438239#336730, SE_HEUMAJ_438245#336731, SE_HEUSER_438229#336732, SE_HIDEXPL_438257#336733, SE_HIDE_438255#336734, SE_LATER_438256#336735, SE_LIEU_438234#336736, SE_MODALI_438230#336737, SE_NB_FIC_438231#336738, SE_NB_IMA_438232#336739, SE_NUMCD_438235#336740, SE_NUMDEM_438243#336741, SE_NUMDOS_438242#336742, SE_NUMSER_438220#336743, SE_NUMSTU_438219#336744, SE_N_SER_438223#336745, SE_PROTOC_438227#336746, SE_RAPPRO_438241#336747, SE_REQ_PROC_ID_438248#336748, SE_SCH_PROC_STE_438249#336749, SE_SERDSC_438247#336750, SE_SEREFF_438237#336751, SE_SER_ID_438221#336752, SE_SOPUID_438222#336753, SE_SOURCE_438253#336754, SE_STATUT_438236#336755, SE_TAIFIC_438233#336756, SE_TYPEXA_438224#336757, SE_TYPPRS_438225#336758, SE_TYPSER_438226#336759]
Functions: []
Aggregate Attributes: []
Results: []

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

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

(21) HashAggregate
Input [1]: [count#337797L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#337793L]
Results [1]: [count(1)#337793L AS count#337794L]

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

SQL / DataFrame Properties

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