hdh-spark-job - Details for Query 1307

Submitted Time: 2026/10/23 13:26:31
Duration: 0.7 s
Succeeded Jobs: 1309 1310
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#636745L]
Results [1]: [count#636746L]

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

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

(5) HashAggregate [codegen id : 5]
Input [1]: [count#636746L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#636698L]
Results [1]: [count(1)#636698L AS COL_f2ab49d8-6f11-46ff-bce9-7086b219376a#636700L]

(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#635543, se_codts#635542, se_coduti#635537, se_comm_1#635531, se_dateff#635529, se_datmaj#635535, se_datser#635519, se_flarch#635541, se_frame_ref#635545, se_heueff#635530, se_heumaj#635536, se_heuser#635520, se_hidexpl#635548, se_hide#635546, se_later#635547, se_lieu#635525, se_modali#635521, se_nb_fic#635522, se_nb_ima#635523, se_numcd#635526, se_numdem#635534, se_numdos#635533, se_numser#635511, se_numstu#635510, se_n_ser#635514, se_protoc#635518, se_rappro#635532, se_req_proc_id#635539, se_sch_proc_step_id#635540, se_serdsc#635538, se_sereff#635528, se_ser_id#635512, se_sopuid#635513, se_source#635544, se_statut#635527, se_taific#635524, se_typexa#635515, se_typprs#635516, se_typser#635517]
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#635543, se_codts#635542, se_coduti#635537, se_comm_1#635531, se_dateff#635529, se_datmaj#635535, se_datser#635519, se_flarch#635541, se_frame_ref#635545, se_heueff#635530, se_heumaj#635536, se_heuser#635520, se_hidexpl#635548, se_hide#635546, se_later#635547, se_lieu#635525, se_modali#635521, se_nb_fic#635522, se_nb_ima#635523, se_numcd#635526, se_numdem#635534, se_numdos#635533, se_numser#635511, se_numstu#635510, se_n_ser#635514, se_protoc#635518, se_rappro#635532, se_req_proc_id#635539, se_sch_proc_step_id#635540, se_serdsc#635538, se_sereff#635528, se_ser_id#635512, se_sopuid#635513, se_source#635544, se_statut#635527, se_taific#635524, se_typexa#635515, se_typprs#635516, se_typser#635517]
Condition : (((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(se_numstu#635510)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_numstu#635510)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_numser#635511)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_numser#635511)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_ser_id#635512)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_ser_id#635512)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_sopuid#635513)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_sopuid#635513)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_n_ser#635514)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_n_ser#635514)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_typexa#635515)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_typexa#635515)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_typprs#635516)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_typprs#635516)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_typser#635517)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_typser#635517)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_protoc#635518)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_protoc#635518)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_datser#635519)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_datser#635519)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_heuser#635520)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_heuser#635520)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_modali#635521)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_modali#635521)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_nb_fic#635522)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_nb_fic#635522)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_nb_ima#635523)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_nb_ima#635523)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_taific#635524)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_taific#635524)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_lieu#635525)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_lieu#635525)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_numcd#635526)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_numcd#635526)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_statut#635527)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_statut#635527)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_sereff#635528)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_sereff#635528)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_dateff#635529)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_dateff#635529)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_heueff#635530)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_heueff#635530)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_comm_1#635531)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_comm_1#635531)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_rappro#635532)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_rappro#635532)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_numdos#635533)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_numdos#635533)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_numdem#635534)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_numdem#635534)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_datmaj#635535)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_datmaj#635535)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_heumaj#635536)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_heumaj#635536)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_coduti#635537)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_coduti#635537)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_serdsc#635538)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_serdsc#635538)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_req_proc_id#635539)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_req_proc_id#635539)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_sch_proc_step_id#635540)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_sch_proc_step_id#635540)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_flarch#635541)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_flarch#635541)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_codts#635542)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_codts#635542)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_bodypart#635543)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_bodypart#635543)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_source#635544)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_source#635544)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_frame_ref#635545)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_frame_ref#635545)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_hide#635546)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_hide#635546)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_later#635547)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_later#635547)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_hidexpl#635548)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_hidexpl#635548)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_A))), MARX)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_A))), MARX) END)

(8) Project [codegen id : 1]
Output [40]: [str_create(Cab_A) AS ORIGINE_440152#635823, se_bodypart#635543 AS SE_BODYPART_438252#635784, se_codts#635542 AS SE_CODTS_438251#635785, se_coduti#635537 AS SE_CODUTI_438246#635786, se_comm_1#635531 AS SE_COMM_1_438240#635787, se_dateff#635529 AS SE_DATEFF_438238#635788, se_datmaj#635535 AS SE_DATMAJ_438244#635789, se_datser#635519 AS SE_DATSER_438228#635790, se_flarch#635541 AS SE_FLARCH_438250#635791, se_frame_ref#635545 AS SE_FRAME_REF_438254#635792, se_heueff#635530 AS SE_HEUEFF_438239#635793, se_heumaj#635536 AS SE_HEUMAJ_438245#635794, se_heuser#635520 AS SE_HEUSER_438229#635795, se_hidexpl#635548 AS SE_HIDEXPL_438257#635796, se_hide#635546 AS SE_HIDE_438255#635797, se_later#635547 AS SE_LATER_438256#635798, se_lieu#635525 AS SE_LIEU_438234#635799, se_modali#635521 AS SE_MODALI_438230#635800, se_nb_fic#635522 AS SE_NB_FIC_438231#635801, se_nb_ima#635523 AS SE_NB_IMA_438232#635802, se_numcd#635526 AS SE_NUMCD_438235#635803, se_numdem#635534 AS SE_NUMDEM_438243#635804, se_numdos#635533 AS SE_NUMDOS_438242#635805, se_numser#635511 AS SE_NUMSER_438220#635806, se_numstu#635510 AS SE_NUMSTU_438219#635807, se_n_ser#635514 AS SE_N_SER_438223#635808, se_protoc#635518 AS SE_PROTOC_438227#635809, se_rappro#635532 AS SE_RAPPRO_438241#635810, se_req_proc_id#635539 AS SE_REQ_PROC_ID_438248#635811, se_sch_proc_step_id#635540 AS SE_SCH_PROC_STE_438249#635812, se_serdsc#635538 AS SE_SERDSC_438247#635813, se_sereff#635528 AS SE_SEREFF_438237#635814, se_ser_id#635512 AS SE_SER_ID_438221#635815, se_sopuid#635513 AS SE_SOPUID_438222#635816, se_source#635544 AS SE_SOURCE_438253#635817, se_statut#635527 AS SE_STATUT_438236#635818, se_taific#635524 AS SE_TAIFIC_438233#635819, se_typexa#635515 AS SE_TYPEXA_438224#635820, se_typprs#635516 AS SE_TYPPRS_438225#635821, se_typser#635517 AS SE_TYPSER_438226#635822]
Input [39]: [se_bodypart#635543, se_codts#635542, se_coduti#635537, se_comm_1#635531, se_dateff#635529, se_datmaj#635535, se_datser#635519, se_flarch#635541, se_frame_ref#635545, se_heueff#635530, se_heumaj#635536, se_heuser#635520, se_hidexpl#635548, se_hide#635546, se_later#635547, se_lieu#635525, se_modali#635521, se_nb_fic#635522, se_nb_ima#635523, se_numcd#635526, se_numdem#635534, se_numdos#635533, se_numser#635511, se_numstu#635510, se_n_ser#635514, se_protoc#635518, se_rappro#635532, se_req_proc_id#635539, se_sch_proc_step_id#635540, se_serdsc#635538, se_sereff#635528, se_ser_id#635512, se_sopuid#635513, se_source#635544, se_statut#635527, se_taific#635524, se_typexa#635515, se_typprs#635516, se_typser#635517]

(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#635897, se_codts#635896, se_coduti#635891, se_comm_1#635885, se_dateff#635883, se_datmaj#635889, se_datser#635873, se_flarch#635895, se_frame_ref#635899, se_heueff#635884, se_heumaj#635890, se_heuser#635874, se_hidexpl#635902, se_hide#635900, se_later#635901, se_lieu#635879, se_modali#635875, se_nb_fic#635876, se_nb_ima#635877, se_numcd#635880, se_numdem#635888, se_numdos#635887, se_numser#635865, se_numstu#635864, se_n_ser#635868, se_protoc#635872, se_rappro#635886, se_req_proc_id#635893, se_sch_proc_step_id#635894, se_serdsc#635892, se_sereff#635882, se_ser_id#635866, se_sopuid#635867, se_source#635898, se_statut#635881, se_taific#635878, se_typexa#635869, se_typprs#635870, se_typser#635871]
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#635897, se_codts#635896, se_coduti#635891, se_comm_1#635885, se_dateff#635883, se_datmaj#635889, se_datser#635873, se_flarch#635895, se_frame_ref#635899, se_heueff#635884, se_heumaj#635890, se_heuser#635874, se_hidexpl#635902, se_hide#635900, se_later#635901, se_lieu#635879, se_modali#635875, se_nb_fic#635876, se_nb_ima#635877, se_numcd#635880, se_numdem#635888, se_numdos#635887, se_numser#635865, se_numstu#635864, se_n_ser#635868, se_protoc#635872, se_rappro#635886, se_req_proc_id#635893, se_sch_proc_step_id#635894, se_serdsc#635892, se_sereff#635882, se_ser_id#635866, se_sopuid#635867, se_source#635898, se_statut#635881, se_taific#635878, se_typexa#635869, se_typprs#635870, se_typser#635871]
Condition : (((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(se_numstu#635864)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_numstu#635864)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_numser#635865)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_numser#635865)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_ser_id#635866)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_ser_id#635866)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_sopuid#635867)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_sopuid#635867)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_n_ser#635868)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_n_ser#635868)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_typexa#635869)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_typexa#635869)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_typprs#635870)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_typprs#635870)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_typser#635871)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_typser#635871)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_protoc#635872)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_protoc#635872)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_datser#635873)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_datser#635873)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_heuser#635874)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_heuser#635874)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_modali#635875)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_modali#635875)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_nb_fic#635876)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_nb_fic#635876)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_nb_ima#635877)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_nb_ima#635877)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_taific#635878)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_taific#635878)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_lieu#635879)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_lieu#635879)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_numcd#635880)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_numcd#635880)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_statut#635881)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_statut#635881)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_sereff#635882)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_sereff#635882)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_dateff#635883)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_dateff#635883)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_heueff#635884)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_heueff#635884)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_comm_1#635885)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_comm_1#635885)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_rappro#635886)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_rappro#635886)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_numdos#635887)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_numdos#635887)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_numdem#635888)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_numdem#635888)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_datmaj#635889)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_datmaj#635889)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_heumaj#635890)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_heumaj#635890)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_coduti#635891)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_coduti#635891)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_serdsc#635892)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_serdsc#635892)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_req_proc_id#635893)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_req_proc_id#635893)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_sch_proc_step_id#635894)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_sch_proc_step_id#635894)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_flarch#635895)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_flarch#635895)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_codts#635896)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_codts#635896)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_bodypart#635897)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_bodypart#635897)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_source#635898)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_source#635898)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_frame_ref#635899)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_frame_ref#635899)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_hide#635900)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_hide#635900)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_later#635901)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_later#635901)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_hidexpl#635902)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(se_hidexpl#635902)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_B))), MARX)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_B))), MARX) END)

(11) Project [codegen id : 2]
Output [40]: [str_create(Cab_B) AS ORIGINE_440152#636177, se_bodypart#635897 AS SE_BODYPART_438252#636138, se_codts#635896 AS SE_CODTS_438251#636139, se_coduti#635891 AS SE_CODUTI_438246#636140, se_comm_1#635885 AS SE_COMM_1_438240#636141, se_dateff#635883 AS SE_DATEFF_438238#636142, se_datmaj#635889 AS SE_DATMAJ_438244#636143, se_datser#635873 AS SE_DATSER_438228#636144, se_flarch#635895 AS SE_FLARCH_438250#636145, se_frame_ref#635899 AS SE_FRAME_REF_438254#636146, se_heueff#635884 AS SE_HEUEFF_438239#636147, se_heumaj#635890 AS SE_HEUMAJ_438245#636148, se_heuser#635874 AS SE_HEUSER_438229#636149, se_hidexpl#635902 AS SE_HIDEXPL_438257#636150, se_hide#635900 AS SE_HIDE_438255#636151, se_later#635901 AS SE_LATER_438256#636152, se_lieu#635879 AS SE_LIEU_438234#636153, se_modali#635875 AS SE_MODALI_438230#636154, se_nb_fic#635876 AS SE_NB_FIC_438231#636155, se_nb_ima#635877 AS SE_NB_IMA_438232#636156, se_numcd#635880 AS SE_NUMCD_438235#636157, se_numdem#635888 AS SE_NUMDEM_438243#636158, se_numdos#635887 AS SE_NUMDOS_438242#636159, se_numser#635865 AS SE_NUMSER_438220#636160, se_numstu#635864 AS SE_NUMSTU_438219#636161, se_n_ser#635868 AS SE_N_SER_438223#636162, se_protoc#635872 AS SE_PROTOC_438227#636163, se_rappro#635886 AS SE_RAPPRO_438241#636164, se_req_proc_id#635893 AS SE_REQ_PROC_ID_438248#636165, se_sch_proc_step_id#635894 AS SE_SCH_PROC_STE_438249#636166, se_serdsc#635892 AS SE_SERDSC_438247#636167, se_sereff#635882 AS SE_SEREFF_438237#636168, se_ser_id#635866 AS SE_SER_ID_438221#636169, se_sopuid#635867 AS SE_SOPUID_438222#636170, se_source#635898 AS SE_SOURCE_438253#636171, se_statut#635881 AS SE_STATUT_438236#636172, se_taific#635878 AS SE_TAIFIC_438233#636173, se_typexa#635869 AS SE_TYPEXA_438224#636174, se_typprs#635870 AS SE_TYPPRS_438225#636175, se_typser#635871 AS SE_TYPSER_438226#636176]
Input [39]: [se_bodypart#635897, se_codts#635896, se_coduti#635891, se_comm_1#635885, se_dateff#635883, se_datmaj#635889, se_datser#635873, se_flarch#635895, se_frame_ref#635899, se_heueff#635884, se_heumaj#635890, se_heuser#635874, se_hidexpl#635902, se_hide#635900, se_later#635901, se_lieu#635879, se_modali#635875, se_nb_fic#635876, se_nb_ima#635877, se_numcd#635880, se_numdem#635888, se_numdos#635887, se_numser#635865, se_numstu#635864, se_n_ser#635868, se_protoc#635872, se_rappro#635886, se_req_proc_id#635893, se_sch_proc_step_id#635894, se_serdsc#635892, se_sereff#635882, se_ser_id#635866, se_sopuid#635867, se_source#635898, se_statut#635881, se_taific#635878, se_typexa#635869, se_typprs#635870, se_typser#635871]

(12) Union

(13) HashAggregate
Input [40]: [ORIGINE_440152#635823, SE_BODYPART_438252#635784, SE_CODTS_438251#635785, SE_CODUTI_438246#635786, SE_COMM_1_438240#635787, SE_DATEFF_438238#635788, SE_DATMAJ_438244#635789, SE_DATSER_438228#635790, SE_FLARCH_438250#635791, SE_FRAME_REF_438254#635792, SE_HEUEFF_438239#635793, SE_HEUMAJ_438245#635794, SE_HEUSER_438229#635795, SE_HIDEXPL_438257#635796, SE_HIDE_438255#635797, SE_LATER_438256#635798, SE_LIEU_438234#635799, SE_MODALI_438230#635800, SE_NB_FIC_438231#635801, SE_NB_IMA_438232#635802, SE_NUMCD_438235#635803, SE_NUMDEM_438243#635804, SE_NUMDOS_438242#635805, SE_NUMSER_438220#635806, SE_NUMSTU_438219#635807, SE_N_SER_438223#635808, SE_PROTOC_438227#635809, SE_RAPPRO_438241#635810, SE_REQ_PROC_ID_438248#635811, SE_SCH_PROC_STE_438249#635812, SE_SERDSC_438247#635813, SE_SEREFF_438237#635814, SE_SER_ID_438221#635815, SE_SOPUID_438222#635816, SE_SOURCE_438253#635817, SE_STATUT_438236#635818, SE_TAIFIC_438233#635819, SE_TYPEXA_438224#635820, SE_TYPPRS_438225#635821, SE_TYPSER_438226#635822]
Keys [40]: [ORIGINE_440152#635823, SE_BODYPART_438252#635784, SE_CODTS_438251#635785, SE_CODUTI_438246#635786, SE_COMM_1_438240#635787, SE_DATEFF_438238#635788, SE_DATMAJ_438244#635789, SE_DATSER_438228#635790, SE_FLARCH_438250#635791, SE_FRAME_REF_438254#635792, SE_HEUEFF_438239#635793, SE_HEUMAJ_438245#635794, SE_HEUSER_438229#635795, SE_HIDEXPL_438257#635796, SE_HIDE_438255#635797, SE_LATER_438256#635798, SE_LIEU_438234#635799, SE_MODALI_438230#635800, SE_NB_FIC_438231#635801, SE_NB_IMA_438232#635802, SE_NUMCD_438235#635803, SE_NUMDEM_438243#635804, SE_NUMDOS_438242#635805, SE_NUMSER_438220#635806, SE_NUMSTU_438219#635807, SE_N_SER_438223#635808, SE_PROTOC_438227#635809, SE_RAPPRO_438241#635810, SE_REQ_PROC_ID_438248#635811, SE_SCH_PROC_STE_438249#635812, SE_SERDSC_438247#635813, SE_SEREFF_438237#635814, SE_SER_ID_438221#635815, SE_SOPUID_438222#635816, SE_SOURCE_438253#635817, SE_STATUT_438236#635818, SE_TAIFIC_438233#635819, SE_TYPEXA_438224#635820, SE_TYPPRS_438225#635821, SE_TYPSER_438226#635822]
Functions: []
Aggregate Attributes: []
Results [40]: [ORIGINE_440152#635823, SE_BODYPART_438252#635784, SE_CODTS_438251#635785, SE_CODUTI_438246#635786, SE_COMM_1_438240#635787, SE_DATEFF_438238#635788, SE_DATMAJ_438244#635789, SE_DATSER_438228#635790, SE_FLARCH_438250#635791, SE_FRAME_REF_438254#635792, SE_HEUEFF_438239#635793, SE_HEUMAJ_438245#635794, SE_HEUSER_438229#635795, SE_HIDEXPL_438257#635796, SE_HIDE_438255#635797, SE_LATER_438256#635798, SE_LIEU_438234#635799, SE_MODALI_438230#635800, SE_NB_FIC_438231#635801, SE_NB_IMA_438232#635802, SE_NUMCD_438235#635803, SE_NUMDEM_438243#635804, SE_NUMDOS_438242#635805, SE_NUMSER_438220#635806, SE_NUMSTU_438219#635807, SE_N_SER_438223#635808, SE_PROTOC_438227#635809, SE_RAPPRO_438241#635810, SE_REQ_PROC_ID_438248#635811, SE_SCH_PROC_STE_438249#635812, SE_SERDSC_438247#635813, SE_SEREFF_438237#635814, SE_SER_ID_438221#635815, SE_SOPUID_438222#635816, SE_SOURCE_438253#635817, SE_STATUT_438236#635818, SE_TAIFIC_438233#635819, SE_TYPEXA_438224#635820, SE_TYPPRS_438225#635821, SE_TYPSER_438226#635822]

(14) Exchange
Input [40]: [ORIGINE_440152#635823, SE_BODYPART_438252#635784, SE_CODTS_438251#635785, SE_CODUTI_438246#635786, SE_COMM_1_438240#635787, SE_DATEFF_438238#635788, SE_DATMAJ_438244#635789, SE_DATSER_438228#635790, SE_FLARCH_438250#635791, SE_FRAME_REF_438254#635792, SE_HEUEFF_438239#635793, SE_HEUMAJ_438245#635794, SE_HEUSER_438229#635795, SE_HIDEXPL_438257#635796, SE_HIDE_438255#635797, SE_LATER_438256#635798, SE_LIEU_438234#635799, SE_MODALI_438230#635800, SE_NB_FIC_438231#635801, SE_NB_IMA_438232#635802, SE_NUMCD_438235#635803, SE_NUMDEM_438243#635804, SE_NUMDOS_438242#635805, SE_NUMSER_438220#635806, SE_NUMSTU_438219#635807, SE_N_SER_438223#635808, SE_PROTOC_438227#635809, SE_RAPPRO_438241#635810, SE_REQ_PROC_ID_438248#635811, SE_SCH_PROC_STE_438249#635812, SE_SERDSC_438247#635813, SE_SEREFF_438237#635814, SE_SER_ID_438221#635815, SE_SOPUID_438222#635816, SE_SOURCE_438253#635817, SE_STATUT_438236#635818, SE_TAIFIC_438233#635819, SE_TYPEXA_438224#635820, SE_TYPPRS_438225#635821, SE_TYPSER_438226#635822]
Arguments: hashpartitioning(ORIGINE_440152#635823, SE_BODYPART_438252#635784, SE_CODTS_438251#635785, SE_CODUTI_438246#635786, SE_COMM_1_438240#635787, SE_DATEFF_438238#635788, SE_DATMAJ_438244#635789, SE_DATSER_438228#635790, SE_FLARCH_438250#635791, SE_FRAME_REF_438254#635792, SE_HEUEFF_438239#635793, SE_HEUMAJ_438245#635794, SE_HEUSER_438229#635795, SE_HIDEXPL_438257#635796, SE_HIDE_438255#635797, SE_LATER_438256#635798, SE_LIEU_438234#635799, SE_MODALI_438230#635800, SE_NB_FIC_438231#635801, SE_NB_IMA_438232#635802, SE_NUMCD_438235#635803, SE_NUMDEM_438243#635804, SE_NUMDOS_438242#635805, SE_NUMSER_438220#635806, ... 17 more fields), ENSURE_REQUIREMENTS, [plan_id=34734]

(15) HashAggregate
Input [40]: [ORIGINE_440152#635823, SE_BODYPART_438252#635784, SE_CODTS_438251#635785, SE_CODUTI_438246#635786, SE_COMM_1_438240#635787, SE_DATEFF_438238#635788, SE_DATMAJ_438244#635789, SE_DATSER_438228#635790, SE_FLARCH_438250#635791, SE_FRAME_REF_438254#635792, SE_HEUEFF_438239#635793, SE_HEUMAJ_438245#635794, SE_HEUSER_438229#635795, SE_HIDEXPL_438257#635796, SE_HIDE_438255#635797, SE_LATER_438256#635798, SE_LIEU_438234#635799, SE_MODALI_438230#635800, SE_NB_FIC_438231#635801, SE_NB_IMA_438232#635802, SE_NUMCD_438235#635803, SE_NUMDEM_438243#635804, SE_NUMDOS_438242#635805, SE_NUMSER_438220#635806, SE_NUMSTU_438219#635807, SE_N_SER_438223#635808, SE_PROTOC_438227#635809, SE_RAPPRO_438241#635810, SE_REQ_PROC_ID_438248#635811, SE_SCH_PROC_STE_438249#635812, SE_SERDSC_438247#635813, SE_SEREFF_438237#635814, SE_SER_ID_438221#635815, SE_SOPUID_438222#635816, SE_SOURCE_438253#635817, SE_STATUT_438236#635818, SE_TAIFIC_438233#635819, SE_TYPEXA_438224#635820, SE_TYPPRS_438225#635821, SE_TYPSER_438226#635822]
Keys [40]: [ORIGINE_440152#635823, SE_BODYPART_438252#635784, SE_CODTS_438251#635785, SE_CODUTI_438246#635786, SE_COMM_1_438240#635787, SE_DATEFF_438238#635788, SE_DATMAJ_438244#635789, SE_DATSER_438228#635790, SE_FLARCH_438250#635791, SE_FRAME_REF_438254#635792, SE_HEUEFF_438239#635793, SE_HEUMAJ_438245#635794, SE_HEUSER_438229#635795, SE_HIDEXPL_438257#635796, SE_HIDE_438255#635797, SE_LATER_438256#635798, SE_LIEU_438234#635799, SE_MODALI_438230#635800, SE_NB_FIC_438231#635801, SE_NB_IMA_438232#635802, SE_NUMCD_438235#635803, SE_NUMDEM_438243#635804, SE_NUMDOS_438242#635805, SE_NUMSER_438220#635806, SE_NUMSTU_438219#635807, SE_N_SER_438223#635808, SE_PROTOC_438227#635809, SE_RAPPRO_438241#635810, SE_REQ_PROC_ID_438248#635811, SE_SCH_PROC_STE_438249#635812, SE_SERDSC_438247#635813, SE_SEREFF_438237#635814, SE_SER_ID_438221#635815, SE_SOPUID_438222#635816, SE_SOURCE_438253#635817, SE_STATUT_438236#635818, SE_TAIFIC_438233#635819, SE_TYPEXA_438224#635820, SE_TYPPRS_438225#635821, SE_TYPSER_438226#635822]
Functions: []
Aggregate Attributes: []
Results: []

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

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

(18) HashAggregate
Input [1]: [count#636746L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#636698L]
Results [1]: [count(1)#636698L AS COL_f2ab49d8-6f11-46ff-bce9-7086b219376a#636700L]

(19) AdaptiveSparkPlan
Output [1]: [COL_f2ab49d8-6f11-46ff-bce9-7086b219376a#636700L]
Arguments: isFinalPlan=true
SQL / DataFrame Properties
Name	Value
spark.sql.optimizer.nestedPredicatePushdown.supportedFileSources	parquet,orc,geoparquet