hdh-spark-job - Details for Query 586

Submitted Time: 2026/10/21 21:31:44
Duration: 1 s
Succeeded Jobs: 511 514

Show the Stage ID and Task ID that corresponds to the max metric

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; subgraph cluster1 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 0 ms"; 2 [labelType="html" label="HashAggregate time in aggregation build: 0 ms number of output rows: 1"]; } 3 [labelType="html" label="Exchange shuffle records written: 1 local merged chunks fetched: 0 shuffle write time: 0 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 1 local bytes read: 56.0 B fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 16.0 B local merged bytes read: 0.0 B number of partitions: 1 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 56.0 B"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 8 ms"; 5 [labelType="html" label="HashAggregate time in aggregation build: 8 ms number of output rows: 1"]; 6 [labelType="html" label=" Project "]; 7 [labelType="html" label="Filter number of output rows: 0"]; 8 [labelType="html" label="ColumnarToRow number of output rows: 29 number of input batches: 1"]; } 9 [labelType="html" label="Scan parquet number of files read: 1 scan time: 6 ms metadata time: 0 ms size of files read: 15.7 KiB number of output rows: 29"]; 2->0; 3->2; 5->3; 6->5; 7->6; 8->7; 9->8; }

AdaptiveSparkPlan isFinalPlan=true

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

WholeStageCodegen (2)

Exchange SinglePartition, ENSURE_REQUIREMENTS, [plan_id=11438]

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

Project

Filter ((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMSTU_438219#119327)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMSTU_438219#119327)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMSER_438220#119326)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMSER_438220#119326)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SER_ID_438221#119335)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_SER_ID_438221#119335)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SOPUID_438222#119336)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_SOPUID_438222#119336)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_N_SER_438223#119328)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_N_SER_438223#119328)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TYPEXA_438224#119340)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_TYPEXA_438224#119340)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TYPPRS_438225#119341)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_TYPPRS_438225#119341)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TYPSER_438226#119342)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_TYPSER_438226#119342)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_PROTOC_438227#119329)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_PROTOC_438227#119329)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_DATSER_438228#119310)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_DATSER_438228#119310)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HEUSER_438229#119315)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_HEUSER_438229#119315)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_MODALI_438230#119320)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_MODALI_438230#119320)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NB_FIC_438231#119321)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_NB_FIC_438231#119321)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NB_IMA_438232#119322)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_NB_IMA_438232#119322)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TAIFIC_438233#119339)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_TAIFIC_438233#119339)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_LIEU_438234#119319)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_LIEU_438234#119319)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMCD_438235#119323)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMCD_438235#119323)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_STATUT_438236#119338)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_STATUT_438236#119338)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SEREFF_438237#119334)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_SEREFF_438237#119334)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_DATEFF_438238#119308)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_DATEFF_438238#119308)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HEUEFF_438239#119313)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_HEUEFF_438239#119313)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_COMM_1_438240#119307)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_COMM_1_438240#119307)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_RAPPRO_438241#119330)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_RAPPRO_438241#119330)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMDOS_438242#119325)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMDOS_438242#119325)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMDEM_438243#119324)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMDEM_438243#119324)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_DATMAJ_438244#119309)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_DATMAJ_438244#119309)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HEUMAJ_438245#119314)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_HEUMAJ_438245#119314)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_CODUTI_438246#119306)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_CODUTI_438246#119306)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SERDSC_438247#119333)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_SERDSC_438247#119333)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_REQ_PROC_ID_438248#119331)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_REQ_PROC_ID_438248#119331)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SCH_PROC_STE_438249#119332)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_SCH_PROC_STE_438249#119332)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_FLARCH_438250#119311)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_FLARCH_438250#119311)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_CODTS_438251#119305)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_CODTS_438251#119305)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_BODYPART_438252#119304)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_BODYPART_438252#119304)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SOURCE_438253#119337)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_SOURCE_438253#119337)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_FRAME_REF_438254#119312)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_FRAME_REF_438254#119312)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HIDE_438255#119317)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_HIDE_438255#119317)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_LATER_438256#119318)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_LATER_438256#119318)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HIDEXPL_438257#119316)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_HIDEXPL_438257#119316)), MARX) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [SE_BODYPART_438252#119304,SE_CODTS_438251#119305,SE_CODUTI_438246#119306,SE_COMM_1_438240#119307,SE_DATEFF_438238#119308,SE_DATMAJ_438244#119309,SE_DATSER_438228#119310,SE_FLARCH_438250#119311,SE_FRAME_REF_438254#119312,SE_HEUEFF_438239#119313,SE_HEUMAJ_438245#119314,SE_HEUSER_438229#119315,SE_HIDEXPL_438257#119316,SE_HIDE_438255#119317,SE_LATER_438256#119318,SE_LIEU_438234#119319,SE_MODALI_438230#119320,SE_NB_FIC_438231#119321,SE_NB_IMA_438232#119322,SE_NUMCD_438235#119323,SE_NUMDEM_438243#119324,SE_NUMDOS_438242#119325,SE_NUMSER_438220#119326,SE_NUMSTU_438219#119327,... 15 more fields] Batched: true, DataFilters: [((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMST..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/uet/H_SERIE_438218], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<SE_BODYPART_438252:string,SE_CODTS_438251:string,SE_CODUTI_438246:string,SE_COMM_1_438240:...

Details

== Physical Plan ==
AdaptiveSparkPlan (14)
+- == Final Plan ==
   * HashAggregate (8)
   +- ShuffleQueryStage (7), Statistics(sizeInBytes=16.0 B, rowCount=1)
      +- Exchange (6)
         +- * HashAggregate (5)
            +- * Project (4)
               +- * Filter (3)
                  +- * ColumnarToRow (2)
                     +- Scan parquet  (1)
+- == Initial Plan ==
   HashAggregate (13)
   +- Exchange (12)
      +- HashAggregate (11)
         +- Project (10)
            +- Filter (9)
               +- Scan parquet  (1)


(1) Scan parquet 
Output [39]: [SE_BODYPART_438252#119304, SE_CODTS_438251#119305, SE_CODUTI_438246#119306, SE_COMM_1_438240#119307, SE_DATEFF_438238#119308, SE_DATMAJ_438244#119309, SE_DATSER_438228#119310, SE_FLARCH_438250#119311, SE_FRAME_REF_438254#119312, SE_HEUEFF_438239#119313, SE_HEUMAJ_438245#119314, SE_HEUSER_438229#119315, SE_HIDEXPL_438257#119316, SE_HIDE_438255#119317, SE_LATER_438256#119318, SE_LIEU_438234#119319, SE_MODALI_438230#119320, SE_NB_FIC_438231#119321, SE_NB_IMA_438232#119322, SE_NUMCD_438235#119323, SE_NUMDEM_438243#119324, SE_NUMDOS_438242#119325, SE_NUMSER_438220#119326, SE_NUMSTU_438219#119327, SE_N_SER_438223#119328, SE_PROTOC_438227#119329, SE_RAPPRO_438241#119330, SE_REQ_PROC_ID_438248#119331, SE_SCH_PROC_STE_438249#119332, SE_SERDSC_438247#119333, SE_SEREFF_438237#119334, SE_SER_ID_438221#119335, SE_SOPUID_438222#119336, SE_SOURCE_438253#119337, SE_STATUT_438236#119338, SE_TAIFIC_438233#119339, SE_TYPEXA_438224#119340, SE_TYPPRS_438225#119341, SE_TYPSER_438226#119342]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/uet/H_SERIE_438218]
ReadSchema: struct<SE_BODYPART_438252:string,SE_CODTS_438251:string,SE_CODUTI_438246:string,SE_COMM_1_438240:string,SE_DATEFF_438238:string,SE_DATMAJ_438244:string,SE_DATSER_438228:string,SE_FLARCH_438250:string,SE_FRAME_REF_438254:string,SE_HEUEFF_438239:string,SE_HEUMAJ_438245:string,SE_HEUSER_438229:string,SE_HIDEXPL_438257:string,SE_HIDE_438255:string,SE_LATER_438256:string,SE_LIEU_438234:string,SE_MODALI_438230:string,SE_NB_FIC_438231:string,SE_NB_IMA_438232:string,SE_NUMCD_438235:string,SE_NUMDEM_438243:string,SE_NUMDOS_438242:string,SE_NUMSER_438220:string,SE_NUMSTU_438219:string,SE_N_SER_438223:string,SE_PROTOC_438227:string,SE_RAPPRO_438241:string,SE_REQ_PROC_ID_438248:string,SE_SCH_PROC_STE_438249:string,SE_SERDSC_438247:string,SE_SEREFF_438237:string,SE_SER_ID_438221:string,SE_SOPUID_438222:string,SE_SOURCE_438253:string,SE_STATUT_438236:string,SE_TAIFIC_438233:string,SE_TYPEXA_438224:string,SE_TYPPRS_438225:string,SE_TYPSER_438226:string>

(2) ColumnarToRow [codegen id : 1]
Input [39]: [SE_BODYPART_438252#119304, SE_CODTS_438251#119305, SE_CODUTI_438246#119306, SE_COMM_1_438240#119307, SE_DATEFF_438238#119308, SE_DATMAJ_438244#119309, SE_DATSER_438228#119310, SE_FLARCH_438250#119311, SE_FRAME_REF_438254#119312, SE_HEUEFF_438239#119313, SE_HEUMAJ_438245#119314, SE_HEUSER_438229#119315, SE_HIDEXPL_438257#119316, SE_HIDE_438255#119317, SE_LATER_438256#119318, SE_LIEU_438234#119319, SE_MODALI_438230#119320, SE_NB_FIC_438231#119321, SE_NB_IMA_438232#119322, SE_NUMCD_438235#119323, SE_NUMDEM_438243#119324, SE_NUMDOS_438242#119325, SE_NUMSER_438220#119326, SE_NUMSTU_438219#119327, SE_N_SER_438223#119328, SE_PROTOC_438227#119329, SE_RAPPRO_438241#119330, SE_REQ_PROC_ID_438248#119331, SE_SCH_PROC_STE_438249#119332, SE_SERDSC_438247#119333, SE_SEREFF_438237#119334, SE_SER_ID_438221#119335, SE_SOPUID_438222#119336, SE_SOURCE_438253#119337, SE_STATUT_438236#119338, SE_TAIFIC_438233#119339, SE_TYPEXA_438224#119340, SE_TYPPRS_438225#119341, SE_TYPSER_438226#119342]

(3) Filter [codegen id : 1]
Input [39]: [SE_BODYPART_438252#119304, SE_CODTS_438251#119305, SE_CODUTI_438246#119306, SE_COMM_1_438240#119307, SE_DATEFF_438238#119308, SE_DATMAJ_438244#119309, SE_DATSER_438228#119310, SE_FLARCH_438250#119311, SE_FRAME_REF_438254#119312, SE_HEUEFF_438239#119313, SE_HEUMAJ_438245#119314, SE_HEUSER_438229#119315, SE_HIDEXPL_438257#119316, SE_HIDE_438255#119317, SE_LATER_438256#119318, SE_LIEU_438234#119319, SE_MODALI_438230#119320, SE_NB_FIC_438231#119321, SE_NB_IMA_438232#119322, SE_NUMCD_438235#119323, SE_NUMDEM_438243#119324, SE_NUMDOS_438242#119325, SE_NUMSER_438220#119326, SE_NUMSTU_438219#119327, SE_N_SER_438223#119328, SE_PROTOC_438227#119329, SE_RAPPRO_438241#119330, SE_REQ_PROC_ID_438248#119331, SE_SCH_PROC_STE_438249#119332, SE_SERDSC_438247#119333, SE_SEREFF_438237#119334, SE_SER_ID_438221#119335, SE_SOPUID_438222#119336, SE_SOURCE_438253#119337, SE_STATUT_438236#119338, SE_TAIFIC_438233#119339, SE_TYPEXA_438224#119340, SE_TYPPRS_438225#119341, SE_TYPSER_438226#119342]
Condition : ((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMSTU_438219#119327)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMSTU_438219#119327)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMSER_438220#119326)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMSER_438220#119326)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SER_ID_438221#119335)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_SER_ID_438221#119335)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SOPUID_438222#119336)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_SOPUID_438222#119336)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_N_SER_438223#119328)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_N_SER_438223#119328)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TYPEXA_438224#119340)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_TYPEXA_438224#119340)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TYPPRS_438225#119341)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_TYPPRS_438225#119341)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TYPSER_438226#119342)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_TYPSER_438226#119342)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_PROTOC_438227#119329)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_PROTOC_438227#119329)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_DATSER_438228#119310)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_DATSER_438228#119310)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HEUSER_438229#119315)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_HEUSER_438229#119315)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_MODALI_438230#119320)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_MODALI_438230#119320)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NB_FIC_438231#119321)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_NB_FIC_438231#119321)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NB_IMA_438232#119322)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_NB_IMA_438232#119322)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TAIFIC_438233#119339)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_TAIFIC_438233#119339)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_LIEU_438234#119319)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_LIEU_438234#119319)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMCD_438235#119323)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMCD_438235#119323)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_STATUT_438236#119338)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_STATUT_438236#119338)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SEREFF_438237#119334)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_SEREFF_438237#119334)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_DATEFF_438238#119308)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_DATEFF_438238#119308)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HEUEFF_438239#119313)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_HEUEFF_438239#119313)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_COMM_1_438240#119307)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_COMM_1_438240#119307)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_RAPPRO_438241#119330)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_RAPPRO_438241#119330)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMDOS_438242#119325)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMDOS_438242#119325)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMDEM_438243#119324)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMDEM_438243#119324)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_DATMAJ_438244#119309)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_DATMAJ_438244#119309)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HEUMAJ_438245#119314)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_HEUMAJ_438245#119314)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_CODUTI_438246#119306)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_CODUTI_438246#119306)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SERDSC_438247#119333)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_SERDSC_438247#119333)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_REQ_PROC_ID_438248#119331)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_REQ_PROC_ID_438248#119331)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SCH_PROC_STE_438249#119332)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_SCH_PROC_STE_438249#119332)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_FLARCH_438250#119311)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_FLARCH_438250#119311)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_CODTS_438251#119305)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_CODTS_438251#119305)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_BODYPART_438252#119304)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_BODYPART_438252#119304)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SOURCE_438253#119337)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_SOURCE_438253#119337)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_FRAME_REF_438254#119312)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_FRAME_REF_438254#119312)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HIDE_438255#119317)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_HIDE_438255#119317)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_LATER_438256#119318)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_LATER_438256#119318)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HIDEXPL_438257#119316)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_HIDEXPL_438257#119316)), MARX) END)

(4) Project [codegen id : 1]
Output: []
Input [39]: [SE_BODYPART_438252#119304, SE_CODTS_438251#119305, SE_CODUTI_438246#119306, SE_COMM_1_438240#119307, SE_DATEFF_438238#119308, SE_DATMAJ_438244#119309, SE_DATSER_438228#119310, SE_FLARCH_438250#119311, SE_FRAME_REF_438254#119312, SE_HEUEFF_438239#119313, SE_HEUMAJ_438245#119314, SE_HEUSER_438229#119315, SE_HIDEXPL_438257#119316, SE_HIDE_438255#119317, SE_LATER_438256#119318, SE_LIEU_438234#119319, SE_MODALI_438230#119320, SE_NB_FIC_438231#119321, SE_NB_IMA_438232#119322, SE_NUMCD_438235#119323, SE_NUMDEM_438243#119324, SE_NUMDOS_438242#119325, SE_NUMSER_438220#119326, SE_NUMSTU_438219#119327, SE_N_SER_438223#119328, SE_PROTOC_438227#119329, SE_RAPPRO_438241#119330, SE_REQ_PROC_ID_438248#119331, SE_SCH_PROC_STE_438249#119332, SE_SERDSC_438247#119333, SE_SEREFF_438237#119334, SE_SER_ID_438221#119335, SE_SOPUID_438222#119336, SE_SOURCE_438253#119337, SE_STATUT_438236#119338, SE_TAIFIC_438233#119339, SE_TYPEXA_438224#119340, SE_TYPPRS_438225#119341, SE_TYPSER_438226#119342]

(5) HashAggregate [codegen id : 1]
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#120486L]
Results [1]: [count#120487L]

(6) Exchange
Input [1]: [count#120487L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=11438]

(7) ShuffleQueryStage
Output [1]: [count#120487L]
Arguments: 0

(8) HashAggregate [codegen id : 2]
Input [1]: [count#120487L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#120264L]
Results [1]: [count(1)#120264L AS COL_c9025539-9e17-48d0-b9a2-741f3c1e0fd6#120266L]

(9) Filter
Input [39]: [SE_BODYPART_438252#119304, SE_CODTS_438251#119305, SE_CODUTI_438246#119306, SE_COMM_1_438240#119307, SE_DATEFF_438238#119308, SE_DATMAJ_438244#119309, SE_DATSER_438228#119310, SE_FLARCH_438250#119311, SE_FRAME_REF_438254#119312, SE_HEUEFF_438239#119313, SE_HEUMAJ_438245#119314, SE_HEUSER_438229#119315, SE_HIDEXPL_438257#119316, SE_HIDE_438255#119317, SE_LATER_438256#119318, SE_LIEU_438234#119319, SE_MODALI_438230#119320, SE_NB_FIC_438231#119321, SE_NB_IMA_438232#119322, SE_NUMCD_438235#119323, SE_NUMDEM_438243#119324, SE_NUMDOS_438242#119325, SE_NUMSER_438220#119326, SE_NUMSTU_438219#119327, SE_N_SER_438223#119328, SE_PROTOC_438227#119329, SE_RAPPRO_438241#119330, SE_REQ_PROC_ID_438248#119331, SE_SCH_PROC_STE_438249#119332, SE_SERDSC_438247#119333, SE_SEREFF_438237#119334, SE_SER_ID_438221#119335, SE_SOPUID_438222#119336, SE_SOURCE_438253#119337, SE_STATUT_438236#119338, SE_TAIFIC_438233#119339, SE_TYPEXA_438224#119340, SE_TYPPRS_438225#119341, SE_TYPSER_438226#119342]
Condition : ((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMSTU_438219#119327)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMSTU_438219#119327)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMSER_438220#119326)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMSER_438220#119326)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SER_ID_438221#119335)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_SER_ID_438221#119335)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SOPUID_438222#119336)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_SOPUID_438222#119336)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_N_SER_438223#119328)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_N_SER_438223#119328)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TYPEXA_438224#119340)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_TYPEXA_438224#119340)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TYPPRS_438225#119341)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_TYPPRS_438225#119341)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TYPSER_438226#119342)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_TYPSER_438226#119342)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_PROTOC_438227#119329)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_PROTOC_438227#119329)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_DATSER_438228#119310)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_DATSER_438228#119310)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HEUSER_438229#119315)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_HEUSER_438229#119315)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_MODALI_438230#119320)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_MODALI_438230#119320)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NB_FIC_438231#119321)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_NB_FIC_438231#119321)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NB_IMA_438232#119322)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_NB_IMA_438232#119322)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TAIFIC_438233#119339)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_TAIFIC_438233#119339)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_LIEU_438234#119319)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_LIEU_438234#119319)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMCD_438235#119323)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMCD_438235#119323)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_STATUT_438236#119338)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_STATUT_438236#119338)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SEREFF_438237#119334)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_SEREFF_438237#119334)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_DATEFF_438238#119308)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_DATEFF_438238#119308)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HEUEFF_438239#119313)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_HEUEFF_438239#119313)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_COMM_1_438240#119307)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_COMM_1_438240#119307)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_RAPPRO_438241#119330)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_RAPPRO_438241#119330)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMDOS_438242#119325)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMDOS_438242#119325)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMDEM_438243#119324)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMDEM_438243#119324)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_DATMAJ_438244#119309)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_DATMAJ_438244#119309)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HEUMAJ_438245#119314)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_HEUMAJ_438245#119314)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_CODUTI_438246#119306)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_CODUTI_438246#119306)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SERDSC_438247#119333)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_SERDSC_438247#119333)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_REQ_PROC_ID_438248#119331)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_REQ_PROC_ID_438248#119331)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SCH_PROC_STE_438249#119332)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_SCH_PROC_STE_438249#119332)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_FLARCH_438250#119311)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_FLARCH_438250#119311)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_CODTS_438251#119305)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_CODTS_438251#119305)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_BODYPART_438252#119304)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_BODYPART_438252#119304)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SOURCE_438253#119337)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_SOURCE_438253#119337)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_FRAME_REF_438254#119312)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_FRAME_REF_438254#119312)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HIDE_438255#119317)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_HIDE_438255#119317)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_LATER_438256#119318)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_LATER_438256#119318)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HIDEXPL_438257#119316)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_HIDEXPL_438257#119316)), MARX) END)

(10) Project
Output: []
Input [39]: [SE_BODYPART_438252#119304, SE_CODTS_438251#119305, SE_CODUTI_438246#119306, SE_COMM_1_438240#119307, SE_DATEFF_438238#119308, SE_DATMAJ_438244#119309, SE_DATSER_438228#119310, SE_FLARCH_438250#119311, SE_FRAME_REF_438254#119312, SE_HEUEFF_438239#119313, SE_HEUMAJ_438245#119314, SE_HEUSER_438229#119315, SE_HIDEXPL_438257#119316, SE_HIDE_438255#119317, SE_LATER_438256#119318, SE_LIEU_438234#119319, SE_MODALI_438230#119320, SE_NB_FIC_438231#119321, SE_NB_IMA_438232#119322, SE_NUMCD_438235#119323, SE_NUMDEM_438243#119324, SE_NUMDOS_438242#119325, SE_NUMSER_438220#119326, SE_NUMSTU_438219#119327, SE_N_SER_438223#119328, SE_PROTOC_438227#119329, SE_RAPPRO_438241#119330, SE_REQ_PROC_ID_438248#119331, SE_SCH_PROC_STE_438249#119332, SE_SERDSC_438247#119333, SE_SEREFF_438237#119334, SE_SER_ID_438221#119335, SE_SOPUID_438222#119336, SE_SOURCE_438253#119337, SE_STATUT_438236#119338, SE_TAIFIC_438233#119339, SE_TYPEXA_438224#119340, SE_TYPPRS_438225#119341, SE_TYPSER_438226#119342]

(11) HashAggregate
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#120486L]
Results [1]: [count#120487L]

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

(13) HashAggregate
Input [1]: [count#120487L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#120264L]
Results [1]: [count(1)#120264L AS COL_c9025539-9e17-48d0-b9a2-741f3c1e0fd6#120266L]

(14) AdaptiveSparkPlan
Output [1]: [COL_c9025539-9e17-48d0-b9a2-741f3c1e0fd6#120266L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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