hdh-spark-job - Details for Query 1413

Submitted Time: 2026/10/23 13:29:09
Duration: 0.6 s
Succeeded Jobs: 1410 1413
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#711253L]
Results [1]: [count#711254L]

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

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

(5) HashAggregate [codegen id : 5]
Input [1]: [count#711254L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#711206L]
Results [1]: [count(1)#711206L AS COL_4629cafa-26ae-4318-a888-a42b048b7a66#711208L]

(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#710008, se_codts#710007, se_coduti#710002, se_comm_1#709996, se_dateff#709994, se_datmaj#710000, se_datser#709984, se_flarch#710006, se_frame_ref#710010, se_heueff#709995, se_heumaj#710001, se_heuser#709985, se_hidexpl#710013, se_hide#710011, se_later#710012, se_lieu#709990, se_modali#709986, se_nb_fic#709987, se_nb_ima#709988, se_numcd#709991, se_numdem#709999, se_numdos#709998, se_numser#709976, se_numstu#709975, se_n_ser#709979, se_protoc#709983, se_rappro#709997, se_req_proc_id#710004, se_sch_proc_step_id#710005, se_serdsc#710003, se_sereff#709993, se_ser_id#709977, se_sopuid#709978, se_source#710009, se_statut#709992, se_taific#709989, se_typexa#709980, se_typprs#709981, se_typser#709982]
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#710008, se_codts#710007, se_coduti#710002, se_comm_1#709996, se_dateff#709994, se_datmaj#710000, se_datser#709984, se_flarch#710006, se_frame_ref#710010, se_heueff#709995, se_heumaj#710001, se_heuser#709985, se_hidexpl#710013, se_hide#710011, se_later#710012, se_lieu#709990, se_modali#709986, se_nb_fic#709987, se_nb_ima#709988, se_numcd#709991, se_numdem#709999, se_numdos#709998, se_numser#709976, se_numstu#709975, se_n_ser#709979, se_protoc#709983, se_rappro#709997, se_req_proc_id#710004, se_sch_proc_step_id#710005, se_serdsc#710003, se_sereff#709993, se_ser_id#709977, se_sopuid#709978, se_source#710009, se_statut#709992, se_taific#709989, se_typexa#709980, se_typprs#709981, se_typser#709982]
Condition : (((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(se_numstu#709975)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_numstu#709975)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_numser#709976)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_numser#709976)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_ser_id#709977)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_ser_id#709977)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_sopuid#709978)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_sopuid#709978)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_n_ser#709979)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_n_ser#709979)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_typexa#709980)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_typexa#709980)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_typprs#709981)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_typprs#709981)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_typser#709982)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_typser#709982)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_protoc#709983)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_protoc#709983)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_datser#709984)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_datser#709984)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_heuser#709985)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_heuser#709985)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_modali#709986)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_modali#709986)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_nb_fic#709987)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_nb_fic#709987)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_nb_ima#709988)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_nb_ima#709988)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_taific#709989)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_taific#709989)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_lieu#709990)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_lieu#709990)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_numcd#709991)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_numcd#709991)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_statut#709992)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_statut#709992)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_sereff#709993)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_sereff#709993)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_dateff#709994)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_dateff#709994)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_heueff#709995)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_heueff#709995)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_comm_1#709996)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_comm_1#709996)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_rappro#709997)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_rappro#709997)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_numdos#709998)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_numdos#709998)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_numdem#709999)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_numdem#709999)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_datmaj#710000)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_datmaj#710000)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_heumaj#710001)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_heumaj#710001)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_coduti#710002)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_coduti#710002)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_serdsc#710003)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_serdsc#710003)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_req_proc_id#710004)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_req_proc_id#710004)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_sch_proc_step_id#710005)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_sch_proc_step_id#710005)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_flarch#710006)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_flarch#710006)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_codts#710007)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_codts#710007)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_bodypart#710008)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_bodypart#710008)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_source#710009)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_source#710009)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_frame_ref#710010)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_frame_ref#710010)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_hide#710011)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_hide#710011)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_later#710012)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_later#710012)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_hidexpl#710013)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_hidexpl#710013)), 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#710325, se_bodypart#710008 AS SE_BODYPART_438252#710284, se_codts#710007 AS SE_CODTS_438251#710285, se_coduti#710002 AS SE_CODUTI_438246#710286, se_comm_1#709996 AS SE_COMM_1_438240#710287, se_dateff#709994 AS SE_DATEFF_438238#710288, se_datmaj#710000 AS SE_DATMAJ_438244#710289, se_datser#709984 AS SE_DATSER_438228#710290, se_flarch#710006 AS SE_FLARCH_438250#710291, se_frame_ref#710010 AS SE_FRAME_REF_438254#710292, se_heueff#709995 AS SE_HEUEFF_438239#710293, se_heumaj#710001 AS SE_HEUMAJ_438245#710294, se_heuser#709985 AS SE_HEUSER_438229#710295, se_hidexpl#710013 AS SE_HIDEXPL_438257#710296, se_hide#710011 AS SE_HIDE_438255#710297, se_later#710012 AS SE_LATER_438256#710298, se_lieu#709990 AS SE_LIEU_438234#710299, se_modali#709986 AS SE_MODALI_438230#710300, se_nb_fic#709987 AS SE_NB_FIC_438231#710301, se_nb_ima#709988 AS SE_NB_IMA_438232#710302, se_numcd#709991 AS SE_NUMCD_438235#710303, se_numdem#709999 AS SE_NUMDEM_438243#710304, se_numdos#709998 AS SE_NUMDOS_438242#710305, se_numser#709976 AS SE_NUMSER_438220#710306, se_numstu#709975 AS SE_NUMSTU_438219#710307, se_n_ser#709979 AS SE_N_SER_438223#710308, se_protoc#709983 AS SE_PROTOC_438227#710309, se_rappro#709997 AS SE_RAPPRO_438241#710310, se_req_proc_id#710004 AS SE_REQ_PROC_ID_438248#710311, se_sch_proc_step_id#710005 AS SE_SCH_PROC_STE_438249#710312, se_serdsc#710003 AS SE_SERDSC_438247#710313, se_sereff#709993 AS SE_SEREFF_438237#710314, se_ser_id#709977 AS SE_SER_ID_438221#710315, se_sopuid#709978 AS SE_SOPUID_438222#710316, se_source#710009 AS SE_SOURCE_438253#710317, se_statut#709992 AS SE_STATUT_438236#710318, se_taific#709989 AS SE_TAIFIC_438233#710319, se_typexa#709980 AS SE_TYPEXA_438224#710320, se_typprs#709981 AS SE_TYPPRS_438225#710321, se_typser#709982 AS SE_TYPSER_438226#710322]
Input [39]: [se_bodypart#710008, se_codts#710007, se_coduti#710002, se_comm_1#709996, se_dateff#709994, se_datmaj#710000, se_datser#709984, se_flarch#710006, se_frame_ref#710010, se_heueff#709995, se_heumaj#710001, se_heuser#709985, se_hidexpl#710013, se_hide#710011, se_later#710012, se_lieu#709990, se_modali#709986, se_nb_fic#709987, se_nb_ima#709988, se_numcd#709991, se_numdem#709999, se_numdos#709998, se_numser#709976, se_numstu#709975, se_n_ser#709979, se_protoc#709983, se_rappro#709997, se_req_proc_id#710004, se_sch_proc_step_id#710005, se_serdsc#710003, se_sereff#709993, se_ser_id#709977, se_sopuid#709978, se_source#710009, se_statut#709992, se_taific#709989, se_typexa#709980, se_typprs#709981, se_typser#709982]

(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#710401, se_codts#710400, se_coduti#710395, se_comm_1#710389, se_dateff#710387, se_datmaj#710393, se_datser#710377, se_flarch#710399, se_frame_ref#710403, se_heueff#710388, se_heumaj#710394, se_heuser#710378, se_hidexpl#710406, se_hide#710404, se_later#710405, se_lieu#710383, se_modali#710379, se_nb_fic#710380, se_nb_ima#710381, se_numcd#710384, se_numdem#710392, se_numdos#710391, se_numser#710369, se_numstu#710368, se_n_ser#710372, se_protoc#710376, se_rappro#710390, se_req_proc_id#710397, se_sch_proc_step_id#710398, se_serdsc#710396, se_sereff#710386, se_ser_id#710370, se_sopuid#710371, se_source#710402, se_statut#710385, se_taific#710382, se_typexa#710373, se_typprs#710374, se_typser#710375]
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#710401, se_codts#710400, se_coduti#710395, se_comm_1#710389, se_dateff#710387, se_datmaj#710393, se_datser#710377, se_flarch#710399, se_frame_ref#710403, se_heueff#710388, se_heumaj#710394, se_heuser#710378, se_hidexpl#710406, se_hide#710404, se_later#710405, se_lieu#710383, se_modali#710379, se_nb_fic#710380, se_nb_ima#710381, se_numcd#710384, se_numdem#710392, se_numdos#710391, se_numser#710369, se_numstu#710368, se_n_ser#710372, se_protoc#710376, se_rappro#710390, se_req_proc_id#710397, se_sch_proc_step_id#710398, se_serdsc#710396, se_sereff#710386, se_ser_id#710370, se_sopuid#710371, se_source#710402, se_statut#710385, se_taific#710382, se_typexa#710373, se_typprs#710374, se_typser#710375]
Condition : (((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(se_numstu#710368)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_numstu#710368)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_numser#710369)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_numser#710369)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_ser_id#710370)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_ser_id#710370)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_sopuid#710371)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_sopuid#710371)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_n_ser#710372)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_n_ser#710372)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_typexa#710373)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_typexa#710373)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_typprs#710374)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_typprs#710374)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_typser#710375)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_typser#710375)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_protoc#710376)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_protoc#710376)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_datser#710377)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_datser#710377)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_heuser#710378)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_heuser#710378)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_modali#710379)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_modali#710379)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_nb_fic#710380)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_nb_fic#710380)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_nb_ima#710381)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_nb_ima#710381)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_taific#710382)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_taific#710382)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_lieu#710383)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_lieu#710383)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_numcd#710384)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_numcd#710384)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_statut#710385)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_statut#710385)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_sereff#710386)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_sereff#710386)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_dateff#710387)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_dateff#710387)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_heueff#710388)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_heueff#710388)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_comm_1#710389)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_comm_1#710389)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_rappro#710390)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_rappro#710390)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_numdos#710391)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_numdos#710391)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_numdem#710392)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_numdem#710392)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_datmaj#710393)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_datmaj#710393)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_heumaj#710394)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_heumaj#710394)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_coduti#710395)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_coduti#710395)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_serdsc#710396)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_serdsc#710396)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_req_proc_id#710397)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_req_proc_id#710397)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_sch_proc_step_id#710398)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_sch_proc_step_id#710398)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_flarch#710399)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_flarch#710399)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_codts#710400)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_codts#710400)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_bodypart#710401)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_bodypart#710401)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_source#710402)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_source#710402)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_frame_ref#710403)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_frame_ref#710403)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_hide#710404)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_hide#710404)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_later#710405)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_later#710405)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(se_hidexpl#710406)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(se_hidexpl#710406)), 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#710681, se_bodypart#710401 AS SE_BODYPART_438252#710642, se_codts#710400 AS SE_CODTS_438251#710643, se_coduti#710395 AS SE_CODUTI_438246#710644, se_comm_1#710389 AS SE_COMM_1_438240#710645, se_dateff#710387 AS SE_DATEFF_438238#710646, se_datmaj#710393 AS SE_DATMAJ_438244#710647, se_datser#710377 AS SE_DATSER_438228#710648, se_flarch#710399 AS SE_FLARCH_438250#710649, se_frame_ref#710403 AS SE_FRAME_REF_438254#710650, se_heueff#710388 AS SE_HEUEFF_438239#710651, se_heumaj#710394 AS SE_HEUMAJ_438245#710652, se_heuser#710378 AS SE_HEUSER_438229#710653, se_hidexpl#710406 AS SE_HIDEXPL_438257#710654, se_hide#710404 AS SE_HIDE_438255#710655, se_later#710405 AS SE_LATER_438256#710656, se_lieu#710383 AS SE_LIEU_438234#710657, se_modali#710379 AS SE_MODALI_438230#710658, se_nb_fic#710380 AS SE_NB_FIC_438231#710659, se_nb_ima#710381 AS SE_NB_IMA_438232#710660, se_numcd#710384 AS SE_NUMCD_438235#710661, se_numdem#710392 AS SE_NUMDEM_438243#710662, se_numdos#710391 AS SE_NUMDOS_438242#710663, se_numser#710369 AS SE_NUMSER_438220#710664, se_numstu#710368 AS SE_NUMSTU_438219#710665, se_n_ser#710372 AS SE_N_SER_438223#710666, se_protoc#710376 AS SE_PROTOC_438227#710667, se_rappro#710390 AS SE_RAPPRO_438241#710668, se_req_proc_id#710397 AS SE_REQ_PROC_ID_438248#710669, se_sch_proc_step_id#710398 AS SE_SCH_PROC_STE_438249#710670, se_serdsc#710396 AS SE_SERDSC_438247#710671, se_sereff#710386 AS SE_SEREFF_438237#710672, se_ser_id#710370 AS SE_SER_ID_438221#710673, se_sopuid#710371 AS SE_SOPUID_438222#710674, se_source#710402 AS SE_SOURCE_438253#710675, se_statut#710385 AS SE_STATUT_438236#710676, se_taific#710382 AS SE_TAIFIC_438233#710677, se_typexa#710373 AS SE_TYPEXA_438224#710678, se_typprs#710374 AS SE_TYPPRS_438225#710679, se_typser#710375 AS SE_TYPSER_438226#710680]
Input [39]: [se_bodypart#710401, se_codts#710400, se_coduti#710395, se_comm_1#710389, se_dateff#710387, se_datmaj#710393, se_datser#710377, se_flarch#710399, se_frame_ref#710403, se_heueff#710388, se_heumaj#710394, se_heuser#710378, se_hidexpl#710406, se_hide#710404, se_later#710405, se_lieu#710383, se_modali#710379, se_nb_fic#710380, se_nb_ima#710381, se_numcd#710384, se_numdem#710392, se_numdos#710391, se_numser#710369, se_numstu#710368, se_n_ser#710372, se_protoc#710376, se_rappro#710390, se_req_proc_id#710397, se_sch_proc_step_id#710398, se_serdsc#710396, se_sereff#710386, se_ser_id#710370, se_sopuid#710371, se_source#710402, se_statut#710385, se_taific#710382, se_typexa#710373, se_typprs#710374, se_typser#710375]

(12) Union

(13) HashAggregate
Input [40]: [ORIGINE_440152#710325, SE_BODYPART_438252#710284, SE_CODTS_438251#710285, SE_CODUTI_438246#710286, SE_COMM_1_438240#710287, SE_DATEFF_438238#710288, SE_DATMAJ_438244#710289, SE_DATSER_438228#710290, SE_FLARCH_438250#710291, SE_FRAME_REF_438254#710292, SE_HEUEFF_438239#710293, SE_HEUMAJ_438245#710294, SE_HEUSER_438229#710295, SE_HIDEXPL_438257#710296, SE_HIDE_438255#710297, SE_LATER_438256#710298, SE_LIEU_438234#710299, SE_MODALI_438230#710300, SE_NB_FIC_438231#710301, SE_NB_IMA_438232#710302, SE_NUMCD_438235#710303, SE_NUMDEM_438243#710304, SE_NUMDOS_438242#710305, SE_NUMSER_438220#710306, SE_NUMSTU_438219#710307, SE_N_SER_438223#710308, SE_PROTOC_438227#710309, SE_RAPPRO_438241#710310, SE_REQ_PROC_ID_438248#710311, SE_SCH_PROC_STE_438249#710312, SE_SERDSC_438247#710313, SE_SEREFF_438237#710314, SE_SER_ID_438221#710315, SE_SOPUID_438222#710316, SE_SOURCE_438253#710317, SE_STATUT_438236#710318, SE_TAIFIC_438233#710319, SE_TYPEXA_438224#710320, SE_TYPPRS_438225#710321, SE_TYPSER_438226#710322]
Keys [40]: [ORIGINE_440152#710325, SE_BODYPART_438252#710284, SE_CODTS_438251#710285, SE_CODUTI_438246#710286, SE_COMM_1_438240#710287, SE_DATEFF_438238#710288, SE_DATMAJ_438244#710289, SE_DATSER_438228#710290, SE_FLARCH_438250#710291, SE_FRAME_REF_438254#710292, SE_HEUEFF_438239#710293, SE_HEUMAJ_438245#710294, SE_HEUSER_438229#710295, SE_HIDEXPL_438257#710296, SE_HIDE_438255#710297, SE_LATER_438256#710298, SE_LIEU_438234#710299, SE_MODALI_438230#710300, SE_NB_FIC_438231#710301, SE_NB_IMA_438232#710302, SE_NUMCD_438235#710303, SE_NUMDEM_438243#710304, SE_NUMDOS_438242#710305, SE_NUMSER_438220#710306, SE_NUMSTU_438219#710307, SE_N_SER_438223#710308, SE_PROTOC_438227#710309, SE_RAPPRO_438241#710310, SE_REQ_PROC_ID_438248#710311, SE_SCH_PROC_STE_438249#710312, SE_SERDSC_438247#710313, SE_SEREFF_438237#710314, SE_SER_ID_438221#710315, SE_SOPUID_438222#710316, SE_SOURCE_438253#710317, SE_STATUT_438236#710318, SE_TAIFIC_438233#710319, SE_TYPEXA_438224#710320, SE_TYPPRS_438225#710321, SE_TYPSER_438226#710322]
Functions: []
Aggregate Attributes: []
Results [40]: [ORIGINE_440152#710325, SE_BODYPART_438252#710284, SE_CODTS_438251#710285, SE_CODUTI_438246#710286, SE_COMM_1_438240#710287, SE_DATEFF_438238#710288, SE_DATMAJ_438244#710289, SE_DATSER_438228#710290, SE_FLARCH_438250#710291, SE_FRAME_REF_438254#710292, SE_HEUEFF_438239#710293, SE_HEUMAJ_438245#710294, SE_HEUSER_438229#710295, SE_HIDEXPL_438257#710296, SE_HIDE_438255#710297, SE_LATER_438256#710298, SE_LIEU_438234#710299, SE_MODALI_438230#710300, SE_NB_FIC_438231#710301, SE_NB_IMA_438232#710302, SE_NUMCD_438235#710303, SE_NUMDEM_438243#710304, SE_NUMDOS_438242#710305, SE_NUMSER_438220#710306, SE_NUMSTU_438219#710307, SE_N_SER_438223#710308, SE_PROTOC_438227#710309, SE_RAPPRO_438241#710310, SE_REQ_PROC_ID_438248#710311, SE_SCH_PROC_STE_438249#710312, SE_SERDSC_438247#710313, SE_SEREFF_438237#710314, SE_SER_ID_438221#710315, SE_SOPUID_438222#710316, SE_SOURCE_438253#710317, SE_STATUT_438236#710318, SE_TAIFIC_438233#710319, SE_TYPEXA_438224#710320, SE_TYPPRS_438225#710321, SE_TYPSER_438226#710322]

(14) Exchange
Input [40]: [ORIGINE_440152#710325, SE_BODYPART_438252#710284, SE_CODTS_438251#710285, SE_CODUTI_438246#710286, SE_COMM_1_438240#710287, SE_DATEFF_438238#710288, SE_DATMAJ_438244#710289, SE_DATSER_438228#710290, SE_FLARCH_438250#710291, SE_FRAME_REF_438254#710292, SE_HEUEFF_438239#710293, SE_HEUMAJ_438245#710294, SE_HEUSER_438229#710295, SE_HIDEXPL_438257#710296, SE_HIDE_438255#710297, SE_LATER_438256#710298, SE_LIEU_438234#710299, SE_MODALI_438230#710300, SE_NB_FIC_438231#710301, SE_NB_IMA_438232#710302, SE_NUMCD_438235#710303, SE_NUMDEM_438243#710304, SE_NUMDOS_438242#710305, SE_NUMSER_438220#710306, SE_NUMSTU_438219#710307, SE_N_SER_438223#710308, SE_PROTOC_438227#710309, SE_RAPPRO_438241#710310, SE_REQ_PROC_ID_438248#710311, SE_SCH_PROC_STE_438249#710312, SE_SERDSC_438247#710313, SE_SEREFF_438237#710314, SE_SER_ID_438221#710315, SE_SOPUID_438222#710316, SE_SOURCE_438253#710317, SE_STATUT_438236#710318, SE_TAIFIC_438233#710319, SE_TYPEXA_438224#710320, SE_TYPPRS_438225#710321, SE_TYPSER_438226#710322]
Arguments: hashpartitioning(ORIGINE_440152#710325, SE_BODYPART_438252#710284, SE_CODTS_438251#710285, SE_CODUTI_438246#710286, SE_COMM_1_438240#710287, SE_DATEFF_438238#710288, SE_DATMAJ_438244#710289, SE_DATSER_438228#710290, SE_FLARCH_438250#710291, SE_FRAME_REF_438254#710292, SE_HEUEFF_438239#710293, SE_HEUMAJ_438245#710294, SE_HEUSER_438229#710295, SE_HIDEXPL_438257#710296, SE_HIDE_438255#710297, SE_LATER_438256#710298, SE_LIEU_438234#710299, SE_MODALI_438230#710300, SE_NB_FIC_438231#710301, SE_NB_IMA_438232#710302, SE_NUMCD_438235#710303, SE_NUMDEM_438243#710304, SE_NUMDOS_438242#710305, SE_NUMSER_438220#710306, ... 17 more fields), ENSURE_REQUIREMENTS, [plan_id=38272]

(15) HashAggregate
Input [40]: [ORIGINE_440152#710325, SE_BODYPART_438252#710284, SE_CODTS_438251#710285, SE_CODUTI_438246#710286, SE_COMM_1_438240#710287, SE_DATEFF_438238#710288, SE_DATMAJ_438244#710289, SE_DATSER_438228#710290, SE_FLARCH_438250#710291, SE_FRAME_REF_438254#710292, SE_HEUEFF_438239#710293, SE_HEUMAJ_438245#710294, SE_HEUSER_438229#710295, SE_HIDEXPL_438257#710296, SE_HIDE_438255#710297, SE_LATER_438256#710298, SE_LIEU_438234#710299, SE_MODALI_438230#710300, SE_NB_FIC_438231#710301, SE_NB_IMA_438232#710302, SE_NUMCD_438235#710303, SE_NUMDEM_438243#710304, SE_NUMDOS_438242#710305, SE_NUMSER_438220#710306, SE_NUMSTU_438219#710307, SE_N_SER_438223#710308, SE_PROTOC_438227#710309, SE_RAPPRO_438241#710310, SE_REQ_PROC_ID_438248#710311, SE_SCH_PROC_STE_438249#710312, SE_SERDSC_438247#710313, SE_SEREFF_438237#710314, SE_SER_ID_438221#710315, SE_SOPUID_438222#710316, SE_SOURCE_438253#710317, SE_STATUT_438236#710318, SE_TAIFIC_438233#710319, SE_TYPEXA_438224#710320, SE_TYPPRS_438225#710321, SE_TYPSER_438226#710322]
Keys [40]: [ORIGINE_440152#710325, SE_BODYPART_438252#710284, SE_CODTS_438251#710285, SE_CODUTI_438246#710286, SE_COMM_1_438240#710287, SE_DATEFF_438238#710288, SE_DATMAJ_438244#710289, SE_DATSER_438228#710290, SE_FLARCH_438250#710291, SE_FRAME_REF_438254#710292, SE_HEUEFF_438239#710293, SE_HEUMAJ_438245#710294, SE_HEUSER_438229#710295, SE_HIDEXPL_438257#710296, SE_HIDE_438255#710297, SE_LATER_438256#710298, SE_LIEU_438234#710299, SE_MODALI_438230#710300, SE_NB_FIC_438231#710301, SE_NB_IMA_438232#710302, SE_NUMCD_438235#710303, SE_NUMDEM_438243#710304, SE_NUMDOS_438242#710305, SE_NUMSER_438220#710306, SE_NUMSTU_438219#710307, SE_N_SER_438223#710308, SE_PROTOC_438227#710309, SE_RAPPRO_438241#710310, SE_REQ_PROC_ID_438248#710311, SE_SCH_PROC_STE_438249#710312, SE_SERDSC_438247#710313, SE_SEREFF_438237#710314, SE_SER_ID_438221#710315, SE_SOPUID_438222#710316, SE_SOURCE_438253#710317, SE_STATUT_438236#710318, SE_TAIFIC_438233#710319, SE_TYPEXA_438224#710320, SE_TYPPRS_438225#710321, SE_TYPSER_438226#710322]
Functions: []
Aggregate Attributes: []
Results: []

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

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

(18) HashAggregate
Input [1]: [count#711254L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#711206L]
Results [1]: [count(1)#711206L AS COL_4629cafa-26ae-4318-a888-a42b048b7a66#711208L]

(19) AdaptiveSparkPlan
Output [1]: [COL_4629cafa-26ae-4318-a888-a42b048b7a66#711208L]
Arguments: isFinalPlan=true
SQL / DataFrame Properties
Name	Value
spark.sql.optimizer.nestedPredicatePushdown.supportedFileSources	parquet,orc,geoparquet