hdh-spark-job - Details for Query 1456

Submitted Time: 2026/10/23 13:29:37
Duration: 2 s
Succeeded Jobs: 1454 1458
Show the Stage ID and Task ID that corresponds to the max metric
Details
== Physical Plan ==
AdaptiveSparkPlan (19)
+- == Final Plan ==
   * HashAggregate (5)
   +- ShuffleQueryStage (4), Statistics(sizeInBytes=0.0 B, rowCount=0)
      +- Exchange (3)
         +- * HashAggregate (2)
            +- * LocalTableScan (1)
+- == Initial Plan ==
   HashAggregate (18)
   +- Exchange (17)
      +- HashAggregate (16)
         +- HashAggregate (15)
            +- Exchange (14)
               +- HashAggregate (13)
                  +- Union (12)
                     :- Project (8)
                     :  +- Filter (7)
                     :     +- 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]  (6)
                     +- Project (11)
                        +- Filter (10)
                           +- 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]  (9)


(1) LocalTableScan [codegen id : 4]
Output: []
Arguments: <empty>

(2) HashAggregate [codegen id : 4]
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#745354L]
Results [1]: [count#745355L]

(3) Exchange
Input [1]: [count#745355L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=39950]

(4) ShuffleQueryStage
Output [1]: [count#745355L]
Arguments: 1

(5) HashAggregate [codegen id : 5]
Input [1]: [count#745355L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#745299L]
Results [1]: [count(1)#745299L AS COL_3b2c9031-bf6b-4130-acbc-382f2caab4e4#745301L]

(6) 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#742486, se_codts#742485, se_coduti#742480, se_comm_1#742474, se_dateff#742472, se_datmaj#742478, se_datser#742462, se_flarch#742484, se_frame_ref#742488, se_heueff#742473, se_heumaj#742479, se_heuser#742463, se_hidexpl#742491, se_hide#742489, se_later#742490, se_lieu#742468, se_modali#742464, se_nb_fic#742465, se_nb_ima#742466, se_numcd#742469, se_numdem#742477, se_numdos#742476, se_numser#742454, se_numstu#742453, se_n_ser#742457, se_protoc#742461, se_rappro#742475, se_req_proc_id#742482, se_sch_proc_step_id#742483, se_serdsc#742481, se_sereff#742471, se_ser_id#742455, se_sopuid#742456, se_source#742487, se_statut#742470, se_taific#742467, se_typexa#742458, se_typprs#742459, se_typser#742460]
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>

(7) Filter [codegen id : 1]
Input [39]: [se_bodypart#742486, se_codts#742485, se_coduti#742480, se_comm_1#742474, se_dateff#742472, se_datmaj#742478, se_datser#742462, se_flarch#742484, se_frame_ref#742488, se_heueff#742473, se_heumaj#742479, se_heuser#742463, se_hidexpl#742491, se_hide#742489, se_later#742490, se_lieu#742468, se_modali#742464, se_nb_fic#742465, se_nb_ima#742466, se_numcd#742469, se_numdem#742477, se_numdos#742476, se_numser#742454, se_numstu#742453, se_n_ser#742457, se_protoc#742461, se_rappro#742475, se_req_proc_id#742482, se_sch_proc_step_id#742483, se_serdsc#742481, se_sereff#742471, se_ser_id#742455, se_sopuid#742456, se_source#742487, se_statut#742470, se_taific#742467, se_typexa#742458, se_typprs#742459, se_typser#742460]
Condition : (((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(se_numstu#742453)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_numstu#742453)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_numser#742454)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_numser#742454)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_ser_id#742455)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_ser_id#742455)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_sopuid#742456)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_sopuid#742456)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_n_ser#742457)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_n_ser#742457)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_typexa#742458)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_typexa#742458)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_typprs#742459)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_typprs#742459)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_typser#742460)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_typser#742460)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_protoc#742461)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_protoc#742461)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_datser#742462)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_datser#742462)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_heuser#742463)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_heuser#742463)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_modali#742464)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_modali#742464)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_nb_fic#742465)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_nb_fic#742465)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_nb_ima#742466)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_nb_ima#742466)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_taific#742467)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_taific#742467)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_lieu#742468)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_lieu#742468)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_numcd#742469)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_numcd#742469)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_statut#742470)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_statut#742470)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_sereff#742471)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_sereff#742471)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_dateff#742472)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_dateff#742472)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_heueff#742473)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_heueff#742473)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_comm_1#742474)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_comm_1#742474)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_rappro#742475)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_rappro#742475)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_numdos#742476)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_numdos#742476)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_numdem#742477)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_numdem#742477)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_datmaj#742478)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_datmaj#742478)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_heumaj#742479)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_heumaj#742479)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_coduti#742480)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_coduti#742480)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_serdsc#742481)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_serdsc#742481)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_req_proc_id#742482)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_req_proc_id#742482)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_sch_proc_step_id#742483)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_sch_proc_step_id#742483)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_flarch#742484)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_flarch#742484)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_codts#742485)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_codts#742485)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_bodypart#742486)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_bodypart#742486)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_source#742487)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_source#742487)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_frame_ref#742488)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_frame_ref#742488)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_hide#742489)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_hide#742489)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_later#742490)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_later#742490)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_hidexpl#742491)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_hidexpl#742491)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_A))), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_A))), MAIN) END)

(8) Project [codegen id : 1]
Output [40]: [str_create(Cab_A) AS ORIGINE_440152#743206, se_bodypart#742486 AS SE_BODYPART_438252#743167, se_codts#742485 AS SE_CODTS_438251#743168, se_coduti#742480 AS SE_CODUTI_438246#743169, se_comm_1#742474 AS SE_COMM_1_438240#743170, se_dateff#742472 AS SE_DATEFF_438238#743171, se_datmaj#742478 AS SE_DATMAJ_438244#743172, se_datser#742462 AS SE_DATSER_438228#743173, se_flarch#742484 AS SE_FLARCH_438250#743174, se_frame_ref#742488 AS SE_FRAME_REF_438254#743175, se_heueff#742473 AS SE_HEUEFF_438239#743176, se_heumaj#742479 AS SE_HEUMAJ_438245#743177, se_heuser#742463 AS SE_HEUSER_438229#743178, se_hidexpl#742491 AS SE_HIDEXPL_438257#743179, se_hide#742489 AS SE_HIDE_438255#743180, se_later#742490 AS SE_LATER_438256#743181, se_lieu#742468 AS SE_LIEU_438234#743182, se_modali#742464 AS SE_MODALI_438230#743183, se_nb_fic#742465 AS SE_NB_FIC_438231#743184, se_nb_ima#742466 AS SE_NB_IMA_438232#743185, se_numcd#742469 AS SE_NUMCD_438235#743186, se_numdem#742477 AS SE_NUMDEM_438243#743187, se_numdos#742476 AS SE_NUMDOS_438242#743188, se_numser#742454 AS SE_NUMSER_438220#743189, se_numstu#742453 AS SE_NUMSTU_438219#743190, se_n_ser#742457 AS SE_N_SER_438223#743191, se_protoc#742461 AS SE_PROTOC_438227#743192, se_rappro#742475 AS SE_RAPPRO_438241#743193, se_req_proc_id#742482 AS SE_REQ_PROC_ID_438248#743194, se_sch_proc_step_id#742483 AS SE_SCH_PROC_STE_438249#743195, se_serdsc#742481 AS SE_SERDSC_438247#743196, se_sereff#742471 AS SE_SEREFF_438237#743197, se_ser_id#742455 AS SE_SER_ID_438221#743198, se_sopuid#742456 AS SE_SOPUID_438222#743199, se_source#742487 AS SE_SOURCE_438253#743200, se_statut#742470 AS SE_STATUT_438236#743201, se_taific#742467 AS SE_TAIFIC_438233#743202, se_typexa#742458 AS SE_TYPEXA_438224#743203, se_typprs#742459 AS SE_TYPPRS_438225#743204, se_typser#742460 AS SE_TYPSER_438226#743205]
Input [39]: [se_bodypart#742486, se_codts#742485, se_coduti#742480, se_comm_1#742474, se_dateff#742472, se_datmaj#742478, se_datser#742462, se_flarch#742484, se_frame_ref#742488, se_heueff#742473, se_heumaj#742479, se_heuser#742463, se_hidexpl#742491, se_hide#742489, se_later#742490, se_lieu#742468, se_modali#742464, se_nb_fic#742465, se_nb_ima#742466, se_numcd#742469, se_numdem#742477, se_numdos#742476, se_numser#742454, se_numstu#742453, se_n_ser#742457, se_protoc#742461, se_rappro#742475, se_req_proc_id#742482, se_sch_proc_step_id#742483, se_serdsc#742481, se_sereff#742471, se_ser_id#742455, se_sopuid#742456, se_source#742487, se_statut#742470, se_taific#742467, se_typexa#742458, se_typprs#742459, se_typser#742460]

(9) 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#743495, se_codts#743494, se_coduti#743489, se_comm_1#743483, se_dateff#743481, se_datmaj#743487, se_datser#743471, se_flarch#743493, se_frame_ref#743497, se_heueff#743482, se_heumaj#743488, se_heuser#743472, se_hidexpl#743500, se_hide#743498, se_later#743499, se_lieu#743477, se_modali#743473, se_nb_fic#743474, se_nb_ima#743475, se_numcd#743478, se_numdem#743486, se_numdos#743485, se_numser#743463, se_numstu#743462, se_n_ser#743466, se_protoc#743470, se_rappro#743484, se_req_proc_id#743491, se_sch_proc_step_id#743492, se_serdsc#743490, se_sereff#743480, se_ser_id#743464, se_sopuid#743465, se_source#743496, se_statut#743479, se_taific#743476, se_typexa#743467, se_typprs#743468, se_typser#743469]
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>

(10) Filter [codegen id : 2]
Input [39]: [se_bodypart#743495, se_codts#743494, se_coduti#743489, se_comm_1#743483, se_dateff#743481, se_datmaj#743487, se_datser#743471, se_flarch#743493, se_frame_ref#743497, se_heueff#743482, se_heumaj#743488, se_heuser#743472, se_hidexpl#743500, se_hide#743498, se_later#743499, se_lieu#743477, se_modali#743473, se_nb_fic#743474, se_nb_ima#743475, se_numcd#743478, se_numdem#743486, se_numdos#743485, se_numser#743463, se_numstu#743462, se_n_ser#743466, se_protoc#743470, se_rappro#743484, se_req_proc_id#743491, se_sch_proc_step_id#743492, se_serdsc#743490, se_sereff#743480, se_ser_id#743464, se_sopuid#743465, se_source#743496, se_statut#743479, se_taific#743476, se_typexa#743467, se_typprs#743468, se_typser#743469]
Condition : (((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(se_numstu#743462)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_numstu#743462)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_numser#743463)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_numser#743463)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_ser_id#743464)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_ser_id#743464)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_sopuid#743465)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_sopuid#743465)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_n_ser#743466)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_n_ser#743466)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_typexa#743467)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_typexa#743467)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_typprs#743468)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_typprs#743468)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_typser#743469)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_typser#743469)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_protoc#743470)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_protoc#743470)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_datser#743471)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_datser#743471)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_heuser#743472)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_heuser#743472)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_modali#743473)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_modali#743473)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_nb_fic#743474)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_nb_fic#743474)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_nb_ima#743475)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_nb_ima#743475)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_taific#743476)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_taific#743476)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_lieu#743477)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_lieu#743477)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_numcd#743478)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_numcd#743478)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_statut#743479)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_statut#743479)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_sereff#743480)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_sereff#743480)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_dateff#743481)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_dateff#743481)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_heueff#743482)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_heueff#743482)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_comm_1#743483)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_comm_1#743483)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_rappro#743484)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_rappro#743484)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_numdos#743485)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_numdos#743485)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_numdem#743486)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_numdem#743486)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_datmaj#743487)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_datmaj#743487)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_heumaj#743488)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_heumaj#743488)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_coduti#743489)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_coduti#743489)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_serdsc#743490)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_serdsc#743490)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_req_proc_id#743491)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_req_proc_id#743491)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_sch_proc_step_id#743492)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_sch_proc_step_id#743492)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_flarch#743493)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_flarch#743493)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_codts#743494)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_codts#743494)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_bodypart#743495)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_bodypart#743495)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_source#743496)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_source#743496)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_frame_ref#743497)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_frame_ref#743497)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_hide#743498)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_hide#743498)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_later#743499)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_later#743499)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_hidexpl#743500)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_hidexpl#743500)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_B))), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_B))), MAIN) END)

(11) Project [codegen id : 2]
Output [40]: [str_create(Cab_B) AS ORIGINE_440152#744252, se_bodypart#743495 AS SE_BODYPART_438252#744179, se_codts#743494 AS SE_CODTS_438251#744180, se_coduti#743489 AS SE_CODUTI_438246#744181, se_comm_1#743483 AS SE_COMM_1_438240#744182, se_dateff#743481 AS SE_DATEFF_438238#744183, se_datmaj#743487 AS SE_DATMAJ_438244#744184, se_datser#743471 AS SE_DATSER_438228#744185, se_flarch#743493 AS SE_FLARCH_438250#744186, se_frame_ref#743497 AS SE_FRAME_REF_438254#744187, se_heueff#743482 AS SE_HEUEFF_438239#744188, se_heumaj#743488 AS SE_HEUMAJ_438245#744189, se_heuser#743472 AS SE_HEUSER_438229#744190, se_hidexpl#743500 AS SE_HIDEXPL_438257#744191, se_hide#743498 AS SE_HIDE_438255#744192, se_later#743499 AS SE_LATER_438256#744193, se_lieu#743477 AS SE_LIEU_438234#744194, se_modali#743473 AS SE_MODALI_438230#744195, se_nb_fic#743474 AS SE_NB_FIC_438231#744196, se_nb_ima#743475 AS SE_NB_IMA_438232#744197, se_numcd#743478 AS SE_NUMCD_438235#744198, se_numdem#743486 AS SE_NUMDEM_438243#744199, se_numdos#743485 AS SE_NUMDOS_438242#744200, se_numser#743463 AS SE_NUMSER_438220#744201, se_numstu#743462 AS SE_NUMSTU_438219#744202, se_n_ser#743466 AS SE_N_SER_438223#744203, se_protoc#743470 AS SE_PROTOC_438227#744204, se_rappro#743484 AS SE_RAPPRO_438241#744205, se_req_proc_id#743491 AS SE_REQ_PROC_ID_438248#744206, se_sch_proc_step_id#743492 AS SE_SCH_PROC_STE_438249#744207, se_serdsc#743490 AS SE_SERDSC_438247#744208, se_sereff#743480 AS SE_SEREFF_438237#744209, se_ser_id#743464 AS SE_SER_ID_438221#744210, se_sopuid#743465 AS SE_SOPUID_438222#744211, se_source#743496 AS SE_SOURCE_438253#744212, se_statut#743479 AS SE_STATUT_438236#744213, se_taific#743476 AS SE_TAIFIC_438233#744214, se_typexa#743467 AS SE_TYPEXA_438224#744215, se_typprs#743468 AS SE_TYPPRS_438225#744216, se_typser#743469 AS SE_TYPSER_438226#744217]
Input [39]: [se_bodypart#743495, se_codts#743494, se_coduti#743489, se_comm_1#743483, se_dateff#743481, se_datmaj#743487, se_datser#743471, se_flarch#743493, se_frame_ref#743497, se_heueff#743482, se_heumaj#743488, se_heuser#743472, se_hidexpl#743500, se_hide#743498, se_later#743499, se_lieu#743477, se_modali#743473, se_nb_fic#743474, se_nb_ima#743475, se_numcd#743478, se_numdem#743486, se_numdos#743485, se_numser#743463, se_numstu#743462, se_n_ser#743466, se_protoc#743470, se_rappro#743484, se_req_proc_id#743491, se_sch_proc_step_id#743492, se_serdsc#743490, se_sereff#743480, se_ser_id#743464, se_sopuid#743465, se_source#743496, se_statut#743479, se_taific#743476, se_typexa#743467, se_typprs#743468, se_typser#743469]

(12) Union

(13) HashAggregate
Input [40]: [ORIGINE_440152#743206, SE_BODYPART_438252#743167, SE_CODTS_438251#743168, SE_CODUTI_438246#743169, SE_COMM_1_438240#743170, SE_DATEFF_438238#743171, SE_DATMAJ_438244#743172, SE_DATSER_438228#743173, SE_FLARCH_438250#743174, SE_FRAME_REF_438254#743175, SE_HEUEFF_438239#743176, SE_HEUMAJ_438245#743177, SE_HEUSER_438229#743178, SE_HIDEXPL_438257#743179, SE_HIDE_438255#743180, SE_LATER_438256#743181, SE_LIEU_438234#743182, SE_MODALI_438230#743183, SE_NB_FIC_438231#743184, SE_NB_IMA_438232#743185, SE_NUMCD_438235#743186, SE_NUMDEM_438243#743187, SE_NUMDOS_438242#743188, SE_NUMSER_438220#743189, SE_NUMSTU_438219#743190, SE_N_SER_438223#743191, SE_PROTOC_438227#743192, SE_RAPPRO_438241#743193, SE_REQ_PROC_ID_438248#743194, SE_SCH_PROC_STE_438249#743195, SE_SERDSC_438247#743196, SE_SEREFF_438237#743197, SE_SER_ID_438221#743198, SE_SOPUID_438222#743199, SE_SOURCE_438253#743200, SE_STATUT_438236#743201, SE_TAIFIC_438233#743202, SE_TYPEXA_438224#743203, SE_TYPPRS_438225#743204, SE_TYPSER_438226#743205]
Keys [40]: [ORIGINE_440152#743206, SE_BODYPART_438252#743167, SE_CODTS_438251#743168, SE_CODUTI_438246#743169, SE_COMM_1_438240#743170, SE_DATEFF_438238#743171, SE_DATMAJ_438244#743172, SE_DATSER_438228#743173, SE_FLARCH_438250#743174, SE_FRAME_REF_438254#743175, SE_HEUEFF_438239#743176, SE_HEUMAJ_438245#743177, SE_HEUSER_438229#743178, SE_HIDEXPL_438257#743179, SE_HIDE_438255#743180, SE_LATER_438256#743181, SE_LIEU_438234#743182, SE_MODALI_438230#743183, SE_NB_FIC_438231#743184, SE_NB_IMA_438232#743185, SE_NUMCD_438235#743186, SE_NUMDEM_438243#743187, SE_NUMDOS_438242#743188, SE_NUMSER_438220#743189, SE_NUMSTU_438219#743190, SE_N_SER_438223#743191, SE_PROTOC_438227#743192, SE_RAPPRO_438241#743193, SE_REQ_PROC_ID_438248#743194, SE_SCH_PROC_STE_438249#743195, SE_SERDSC_438247#743196, SE_SEREFF_438237#743197, SE_SER_ID_438221#743198, SE_SOPUID_438222#743199, SE_SOURCE_438253#743200, SE_STATUT_438236#743201, SE_TAIFIC_438233#743202, SE_TYPEXA_438224#743203, SE_TYPPRS_438225#743204, SE_TYPSER_438226#743205]
Functions: []
Aggregate Attributes: []
Results [40]: [ORIGINE_440152#743206, SE_BODYPART_438252#743167, SE_CODTS_438251#743168, SE_CODUTI_438246#743169, SE_COMM_1_438240#743170, SE_DATEFF_438238#743171, SE_DATMAJ_438244#743172, SE_DATSER_438228#743173, SE_FLARCH_438250#743174, SE_FRAME_REF_438254#743175, SE_HEUEFF_438239#743176, SE_HEUMAJ_438245#743177, SE_HEUSER_438229#743178, SE_HIDEXPL_438257#743179, SE_HIDE_438255#743180, SE_LATER_438256#743181, SE_LIEU_438234#743182, SE_MODALI_438230#743183, SE_NB_FIC_438231#743184, SE_NB_IMA_438232#743185, SE_NUMCD_438235#743186, SE_NUMDEM_438243#743187, SE_NUMDOS_438242#743188, SE_NUMSER_438220#743189, SE_NUMSTU_438219#743190, SE_N_SER_438223#743191, SE_PROTOC_438227#743192, SE_RAPPRO_438241#743193, SE_REQ_PROC_ID_438248#743194, SE_SCH_PROC_STE_438249#743195, SE_SERDSC_438247#743196, SE_SEREFF_438237#743197, SE_SER_ID_438221#743198, SE_SOPUID_438222#743199, SE_SOURCE_438253#743200, SE_STATUT_438236#743201, SE_TAIFIC_438233#743202, SE_TYPEXA_438224#743203, SE_TYPPRS_438225#743204, SE_TYPSER_438226#743205]

(14) Exchange
Input [40]: [ORIGINE_440152#743206, SE_BODYPART_438252#743167, SE_CODTS_438251#743168, SE_CODUTI_438246#743169, SE_COMM_1_438240#743170, SE_DATEFF_438238#743171, SE_DATMAJ_438244#743172, SE_DATSER_438228#743173, SE_FLARCH_438250#743174, SE_FRAME_REF_438254#743175, SE_HEUEFF_438239#743176, SE_HEUMAJ_438245#743177, SE_HEUSER_438229#743178, SE_HIDEXPL_438257#743179, SE_HIDE_438255#743180, SE_LATER_438256#743181, SE_LIEU_438234#743182, SE_MODALI_438230#743183, SE_NB_FIC_438231#743184, SE_NB_IMA_438232#743185, SE_NUMCD_438235#743186, SE_NUMDEM_438243#743187, SE_NUMDOS_438242#743188, SE_NUMSER_438220#743189, SE_NUMSTU_438219#743190, SE_N_SER_438223#743191, SE_PROTOC_438227#743192, SE_RAPPRO_438241#743193, SE_REQ_PROC_ID_438248#743194, SE_SCH_PROC_STE_438249#743195, SE_SERDSC_438247#743196, SE_SEREFF_438237#743197, SE_SER_ID_438221#743198, SE_SOPUID_438222#743199, SE_SOURCE_438253#743200, SE_STATUT_438236#743201, SE_TAIFIC_438233#743202, SE_TYPEXA_438224#743203, SE_TYPPRS_438225#743204, SE_TYPSER_438226#743205]
Arguments: hashpartitioning(ORIGINE_440152#743206, SE_BODYPART_438252#743167, SE_CODTS_438251#743168, SE_CODUTI_438246#743169, SE_COMM_1_438240#743170, SE_DATEFF_438238#743171, SE_DATMAJ_438244#743172, SE_DATSER_438228#743173, SE_FLARCH_438250#743174, SE_FRAME_REF_438254#743175, SE_HEUEFF_438239#743176, SE_HEUMAJ_438245#743177, SE_HEUSER_438229#743178, SE_HIDEXPL_438257#743179, SE_HIDE_438255#743180, SE_LATER_438256#743181, SE_LIEU_438234#743182, SE_MODALI_438230#743183, SE_NB_FIC_438231#743184, SE_NB_IMA_438232#743185, SE_NUMCD_438235#743186, SE_NUMDEM_438243#743187, SE_NUMDOS_438242#743188, SE_NUMSER_438220#743189, ... 17 more fields), ENSURE_REQUIREMENTS, [plan_id=39754]

(15) HashAggregate
Input [40]: [ORIGINE_440152#743206, SE_BODYPART_438252#743167, SE_CODTS_438251#743168, SE_CODUTI_438246#743169, SE_COMM_1_438240#743170, SE_DATEFF_438238#743171, SE_DATMAJ_438244#743172, SE_DATSER_438228#743173, SE_FLARCH_438250#743174, SE_FRAME_REF_438254#743175, SE_HEUEFF_438239#743176, SE_HEUMAJ_438245#743177, SE_HEUSER_438229#743178, SE_HIDEXPL_438257#743179, SE_HIDE_438255#743180, SE_LATER_438256#743181, SE_LIEU_438234#743182, SE_MODALI_438230#743183, SE_NB_FIC_438231#743184, SE_NB_IMA_438232#743185, SE_NUMCD_438235#743186, SE_NUMDEM_438243#743187, SE_NUMDOS_438242#743188, SE_NUMSER_438220#743189, SE_NUMSTU_438219#743190, SE_N_SER_438223#743191, SE_PROTOC_438227#743192, SE_RAPPRO_438241#743193, SE_REQ_PROC_ID_438248#743194, SE_SCH_PROC_STE_438249#743195, SE_SERDSC_438247#743196, SE_SEREFF_438237#743197, SE_SER_ID_438221#743198, SE_SOPUID_438222#743199, SE_SOURCE_438253#743200, SE_STATUT_438236#743201, SE_TAIFIC_438233#743202, SE_TYPEXA_438224#743203, SE_TYPPRS_438225#743204, SE_TYPSER_438226#743205]
Keys [40]: [ORIGINE_440152#743206, SE_BODYPART_438252#743167, SE_CODTS_438251#743168, SE_CODUTI_438246#743169, SE_COMM_1_438240#743170, SE_DATEFF_438238#743171, SE_DATMAJ_438244#743172, SE_DATSER_438228#743173, SE_FLARCH_438250#743174, SE_FRAME_REF_438254#743175, SE_HEUEFF_438239#743176, SE_HEUMAJ_438245#743177, SE_HEUSER_438229#743178, SE_HIDEXPL_438257#743179, SE_HIDE_438255#743180, SE_LATER_438256#743181, SE_LIEU_438234#743182, SE_MODALI_438230#743183, SE_NB_FIC_438231#743184, SE_NB_IMA_438232#743185, SE_NUMCD_438235#743186, SE_NUMDEM_438243#743187, SE_NUMDOS_438242#743188, SE_NUMSER_438220#743189, SE_NUMSTU_438219#743190, SE_N_SER_438223#743191, SE_PROTOC_438227#743192, SE_RAPPRO_438241#743193, SE_REQ_PROC_ID_438248#743194, SE_SCH_PROC_STE_438249#743195, SE_SERDSC_438247#743196, SE_SEREFF_438237#743197, SE_SER_ID_438221#743198, SE_SOPUID_438222#743199, SE_SOURCE_438253#743200, SE_STATUT_438236#743201, SE_TAIFIC_438233#743202, SE_TYPEXA_438224#743203, SE_TYPPRS_438225#743204, SE_TYPSER_438226#743205]
Functions: []
Aggregate Attributes: []
Results: []

(16) HashAggregate
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#745354L]
Results [1]: [count#745355L]

(17) Exchange
Input [1]: [count#745355L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=39758]

(18) HashAggregate
Input [1]: [count#745355L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#745299L]
Results [1]: [count(1)#745299L AS COL_3b2c9031-bf6b-4130-acbc-382f2caab4e4#745301L]

(19) AdaptiveSparkPlan
Output [1]: [COL_3b2c9031-bf6b-4130-acbc-382f2caab4e4#745301L]
Arguments: isFinalPlan=true
SQL / DataFrame Properties
Name	Value
spark.sql.optimizer.nestedPredicatePushdown.supportedFileSources	parquet,orc,geoparquet