hdh-spark-job - Details for Query 723

Submitted Time: 2026/10/21 21:36:45
Duration: 0.2 s
Succeeded Jobs: 706 707

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: 7 ms"; 5 [labelType="html" label="HashAggregate time in aggregation build: 6 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: 5 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=14801]

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

Project

Filter ((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMSTU_438219#158426)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMSTU_438219#158426)), A63000893163) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMSER_438220#158425)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMSER_438220#158425)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SER_ID_438221#158434)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_SER_ID_438221#158434)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SOPUID_438222#158435)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_SOPUID_438222#158435)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_N_SER_438223#158427)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_N_SER_438223#158427)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TYPEXA_438224#158439)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_TYPEXA_438224#158439)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TYPPRS_438225#158440)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_TYPPRS_438225#158440)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TYPSER_438226#158441)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_TYPSER_438226#158441)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_PROTOC_438227#158428)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_PROTOC_438227#158428)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_DATSER_438228#158409)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_DATSER_438228#158409)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HEUSER_438229#158414)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_HEUSER_438229#158414)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_MODALI_438230#158419)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_MODALI_438230#158419)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NB_FIC_438231#158420)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_NB_FIC_438231#158420)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NB_IMA_438232#158421)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_NB_IMA_438232#158421)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TAIFIC_438233#158438)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_TAIFIC_438233#158438)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_LIEU_438234#158418)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_LIEU_438234#158418)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMCD_438235#158422)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMCD_438235#158422)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_STATUT_438236#158437)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_STATUT_438236#158437)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SEREFF_438237#158433)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_SEREFF_438237#158433)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_DATEFF_438238#158407)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_DATEFF_438238#158407)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HEUEFF_438239#158412)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_HEUEFF_438239#158412)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_COMM_1_438240#158406)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_COMM_1_438240#158406)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_RAPPRO_438241#158429)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_RAPPRO_438241#158429)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMDOS_438242#158424)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMDOS_438242#158424)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMDEM_438243#158423)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMDEM_438243#158423)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_DATMAJ_438244#158408)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_DATMAJ_438244#158408)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HEUMAJ_438245#158413)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_HEUMAJ_438245#158413)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_CODUTI_438246#158405)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_CODUTI_438246#158405)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SERDSC_438247#158432)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_SERDSC_438247#158432)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_REQ_PROC_ID_438248#158430)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_REQ_PROC_ID_438248#158430)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SCH_PROC_STE_438249#158431)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_SCH_PROC_STE_438249#158431)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_FLARCH_438250#158410)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_FLARCH_438250#158410)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_CODTS_438251#158404)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_CODTS_438251#158404)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_BODYPART_438252#158403)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_BODYPART_438252#158403)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SOURCE_438253#158436)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_SOURCE_438253#158436)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_FRAME_REF_438254#158411)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_FRAME_REF_438254#158411)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HIDE_438255#158416)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_HIDE_438255#158416)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_LATER_438256#158417)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_LATER_438256#158417)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HIDEXPL_438257#158415)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_HIDEXPL_438257#158415)), A63000893163) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [SE_BODYPART_438252#158403,SE_CODTS_438251#158404,SE_CODUTI_438246#158405,SE_COMM_1_438240#158406,SE_DATEFF_438238#158407,SE_DATMAJ_438244#158408,SE_DATSER_438228#158409,SE_FLARCH_438250#158410,SE_FRAME_REF_438254#158411,SE_HEUEFF_438239#158412,SE_HEUMAJ_438245#158413,SE_HEUSER_438229#158414,SE_HIDEXPL_438257#158415,SE_HIDE_438255#158416,SE_LATER_438256#158417,SE_LIEU_438234#158418,SE_MODALI_438230#158419,SE_NB_FIC_438231#158420,SE_NB_IMA_438232#158421,SE_NUMCD_438235#158422,SE_NUMDEM_438243#158423,SE_NUMDOS_438242#158424,SE_NUMSER_438220#158425,SE_NUMSTU_438219#158426,... 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#158403, SE_CODTS_438251#158404, SE_CODUTI_438246#158405, SE_COMM_1_438240#158406, SE_DATEFF_438238#158407, SE_DATMAJ_438244#158408, SE_DATSER_438228#158409, SE_FLARCH_438250#158410, SE_FRAME_REF_438254#158411, SE_HEUEFF_438239#158412, SE_HEUMAJ_438245#158413, SE_HEUSER_438229#158414, SE_HIDEXPL_438257#158415, SE_HIDE_438255#158416, SE_LATER_438256#158417, SE_LIEU_438234#158418, SE_MODALI_438230#158419, SE_NB_FIC_438231#158420, SE_NB_IMA_438232#158421, SE_NUMCD_438235#158422, SE_NUMDEM_438243#158423, SE_NUMDOS_438242#158424, SE_NUMSER_438220#158425, SE_NUMSTU_438219#158426, SE_N_SER_438223#158427, SE_PROTOC_438227#158428, SE_RAPPRO_438241#158429, SE_REQ_PROC_ID_438248#158430, SE_SCH_PROC_STE_438249#158431, SE_SERDSC_438247#158432, SE_SEREFF_438237#158433, SE_SER_ID_438221#158434, SE_SOPUID_438222#158435, SE_SOURCE_438253#158436, SE_STATUT_438236#158437, SE_TAIFIC_438233#158438, SE_TYPEXA_438224#158439, SE_TYPPRS_438225#158440, SE_TYPSER_438226#158441]
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#158403, SE_CODTS_438251#158404, SE_CODUTI_438246#158405, SE_COMM_1_438240#158406, SE_DATEFF_438238#158407, SE_DATMAJ_438244#158408, SE_DATSER_438228#158409, SE_FLARCH_438250#158410, SE_FRAME_REF_438254#158411, SE_HEUEFF_438239#158412, SE_HEUMAJ_438245#158413, SE_HEUSER_438229#158414, SE_HIDEXPL_438257#158415, SE_HIDE_438255#158416, SE_LATER_438256#158417, SE_LIEU_438234#158418, SE_MODALI_438230#158419, SE_NB_FIC_438231#158420, SE_NB_IMA_438232#158421, SE_NUMCD_438235#158422, SE_NUMDEM_438243#158423, SE_NUMDOS_438242#158424, SE_NUMSER_438220#158425, SE_NUMSTU_438219#158426, SE_N_SER_438223#158427, SE_PROTOC_438227#158428, SE_RAPPRO_438241#158429, SE_REQ_PROC_ID_438248#158430, SE_SCH_PROC_STE_438249#158431, SE_SERDSC_438247#158432, SE_SEREFF_438237#158433, SE_SER_ID_438221#158434, SE_SOPUID_438222#158435, SE_SOURCE_438253#158436, SE_STATUT_438236#158437, SE_TAIFIC_438233#158438, SE_TYPEXA_438224#158439, SE_TYPPRS_438225#158440, SE_TYPSER_438226#158441]

(3) Filter [codegen id : 1]
Input [39]: [SE_BODYPART_438252#158403, SE_CODTS_438251#158404, SE_CODUTI_438246#158405, SE_COMM_1_438240#158406, SE_DATEFF_438238#158407, SE_DATMAJ_438244#158408, SE_DATSER_438228#158409, SE_FLARCH_438250#158410, SE_FRAME_REF_438254#158411, SE_HEUEFF_438239#158412, SE_HEUMAJ_438245#158413, SE_HEUSER_438229#158414, SE_HIDEXPL_438257#158415, SE_HIDE_438255#158416, SE_LATER_438256#158417, SE_LIEU_438234#158418, SE_MODALI_438230#158419, SE_NB_FIC_438231#158420, SE_NB_IMA_438232#158421, SE_NUMCD_438235#158422, SE_NUMDEM_438243#158423, SE_NUMDOS_438242#158424, SE_NUMSER_438220#158425, SE_NUMSTU_438219#158426, SE_N_SER_438223#158427, SE_PROTOC_438227#158428, SE_RAPPRO_438241#158429, SE_REQ_PROC_ID_438248#158430, SE_SCH_PROC_STE_438249#158431, SE_SERDSC_438247#158432, SE_SEREFF_438237#158433, SE_SER_ID_438221#158434, SE_SOPUID_438222#158435, SE_SOURCE_438253#158436, SE_STATUT_438236#158437, SE_TAIFIC_438233#158438, SE_TYPEXA_438224#158439, SE_TYPPRS_438225#158440, SE_TYPSER_438226#158441]
Condition : ((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMSTU_438219#158426)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMSTU_438219#158426)), A63000893163) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMSER_438220#158425)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMSER_438220#158425)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SER_ID_438221#158434)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_SER_ID_438221#158434)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SOPUID_438222#158435)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_SOPUID_438222#158435)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_N_SER_438223#158427)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_N_SER_438223#158427)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TYPEXA_438224#158439)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_TYPEXA_438224#158439)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TYPPRS_438225#158440)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_TYPPRS_438225#158440)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TYPSER_438226#158441)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_TYPSER_438226#158441)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_PROTOC_438227#158428)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_PROTOC_438227#158428)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_DATSER_438228#158409)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_DATSER_438228#158409)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HEUSER_438229#158414)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_HEUSER_438229#158414)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_MODALI_438230#158419)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_MODALI_438230#158419)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NB_FIC_438231#158420)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_NB_FIC_438231#158420)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NB_IMA_438232#158421)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_NB_IMA_438232#158421)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TAIFIC_438233#158438)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_TAIFIC_438233#158438)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_LIEU_438234#158418)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_LIEU_438234#158418)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMCD_438235#158422)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMCD_438235#158422)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_STATUT_438236#158437)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_STATUT_438236#158437)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SEREFF_438237#158433)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_SEREFF_438237#158433)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_DATEFF_438238#158407)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_DATEFF_438238#158407)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HEUEFF_438239#158412)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_HEUEFF_438239#158412)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_COMM_1_438240#158406)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_COMM_1_438240#158406)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_RAPPRO_438241#158429)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_RAPPRO_438241#158429)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMDOS_438242#158424)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMDOS_438242#158424)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMDEM_438243#158423)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMDEM_438243#158423)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_DATMAJ_438244#158408)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_DATMAJ_438244#158408)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HEUMAJ_438245#158413)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_HEUMAJ_438245#158413)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_CODUTI_438246#158405)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_CODUTI_438246#158405)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SERDSC_438247#158432)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_SERDSC_438247#158432)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_REQ_PROC_ID_438248#158430)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_REQ_PROC_ID_438248#158430)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SCH_PROC_STE_438249#158431)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_SCH_PROC_STE_438249#158431)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_FLARCH_438250#158410)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_FLARCH_438250#158410)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_CODTS_438251#158404)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_CODTS_438251#158404)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_BODYPART_438252#158403)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_BODYPART_438252#158403)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SOURCE_438253#158436)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_SOURCE_438253#158436)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_FRAME_REF_438254#158411)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_FRAME_REF_438254#158411)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HIDE_438255#158416)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_HIDE_438255#158416)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_LATER_438256#158417)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_LATER_438256#158417)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HIDEXPL_438257#158415)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_HIDEXPL_438257#158415)), A63000893163) END)

(4) Project [codegen id : 1]
Output: []
Input [39]: [SE_BODYPART_438252#158403, SE_CODTS_438251#158404, SE_CODUTI_438246#158405, SE_COMM_1_438240#158406, SE_DATEFF_438238#158407, SE_DATMAJ_438244#158408, SE_DATSER_438228#158409, SE_FLARCH_438250#158410, SE_FRAME_REF_438254#158411, SE_HEUEFF_438239#158412, SE_HEUMAJ_438245#158413, SE_HEUSER_438229#158414, SE_HIDEXPL_438257#158415, SE_HIDE_438255#158416, SE_LATER_438256#158417, SE_LIEU_438234#158418, SE_MODALI_438230#158419, SE_NB_FIC_438231#158420, SE_NB_IMA_438232#158421, SE_NUMCD_438235#158422, SE_NUMDEM_438243#158423, SE_NUMDOS_438242#158424, SE_NUMSER_438220#158425, SE_NUMSTU_438219#158426, SE_N_SER_438223#158427, SE_PROTOC_438227#158428, SE_RAPPRO_438241#158429, SE_REQ_PROC_ID_438248#158430, SE_SCH_PROC_STE_438249#158431, SE_SERDSC_438247#158432, SE_SEREFF_438237#158433, SE_SER_ID_438221#158434, SE_SOPUID_438222#158435, SE_SOURCE_438253#158436, SE_STATUT_438236#158437, SE_TAIFIC_438233#158438, SE_TYPEXA_438224#158439, SE_TYPPRS_438225#158440, SE_TYPSER_438226#158441]

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

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

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

(8) HashAggregate [codegen id : 2]
Input [1]: [count#159714L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#159505L]
Results [1]: [count(1)#159505L AS COL_bc973c3b-9ce9-46ae-a8fb-a9ddcf5acaa2#159507L]

(9) Filter
Input [39]: [SE_BODYPART_438252#158403, SE_CODTS_438251#158404, SE_CODUTI_438246#158405, SE_COMM_1_438240#158406, SE_DATEFF_438238#158407, SE_DATMAJ_438244#158408, SE_DATSER_438228#158409, SE_FLARCH_438250#158410, SE_FRAME_REF_438254#158411, SE_HEUEFF_438239#158412, SE_HEUMAJ_438245#158413, SE_HEUSER_438229#158414, SE_HIDEXPL_438257#158415, SE_HIDE_438255#158416, SE_LATER_438256#158417, SE_LIEU_438234#158418, SE_MODALI_438230#158419, SE_NB_FIC_438231#158420, SE_NB_IMA_438232#158421, SE_NUMCD_438235#158422, SE_NUMDEM_438243#158423, SE_NUMDOS_438242#158424, SE_NUMSER_438220#158425, SE_NUMSTU_438219#158426, SE_N_SER_438223#158427, SE_PROTOC_438227#158428, SE_RAPPRO_438241#158429, SE_REQ_PROC_ID_438248#158430, SE_SCH_PROC_STE_438249#158431, SE_SERDSC_438247#158432, SE_SEREFF_438237#158433, SE_SER_ID_438221#158434, SE_SOPUID_438222#158435, SE_SOURCE_438253#158436, SE_STATUT_438236#158437, SE_TAIFIC_438233#158438, SE_TYPEXA_438224#158439, SE_TYPPRS_438225#158440, SE_TYPSER_438226#158441]
Condition : ((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMSTU_438219#158426)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMSTU_438219#158426)), A63000893163) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMSER_438220#158425)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMSER_438220#158425)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SER_ID_438221#158434)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_SER_ID_438221#158434)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SOPUID_438222#158435)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_SOPUID_438222#158435)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_N_SER_438223#158427)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_N_SER_438223#158427)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TYPEXA_438224#158439)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_TYPEXA_438224#158439)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TYPPRS_438225#158440)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_TYPPRS_438225#158440)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TYPSER_438226#158441)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_TYPSER_438226#158441)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_PROTOC_438227#158428)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_PROTOC_438227#158428)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_DATSER_438228#158409)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_DATSER_438228#158409)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HEUSER_438229#158414)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_HEUSER_438229#158414)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_MODALI_438230#158419)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_MODALI_438230#158419)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NB_FIC_438231#158420)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_NB_FIC_438231#158420)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NB_IMA_438232#158421)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_NB_IMA_438232#158421)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TAIFIC_438233#158438)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_TAIFIC_438233#158438)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_LIEU_438234#158418)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_LIEU_438234#158418)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMCD_438235#158422)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMCD_438235#158422)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_STATUT_438236#158437)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_STATUT_438236#158437)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SEREFF_438237#158433)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_SEREFF_438237#158433)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_DATEFF_438238#158407)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_DATEFF_438238#158407)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HEUEFF_438239#158412)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_HEUEFF_438239#158412)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_COMM_1_438240#158406)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_COMM_1_438240#158406)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_RAPPRO_438241#158429)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_RAPPRO_438241#158429)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMDOS_438242#158424)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMDOS_438242#158424)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMDEM_438243#158423)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMDEM_438243#158423)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_DATMAJ_438244#158408)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_DATMAJ_438244#158408)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HEUMAJ_438245#158413)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_HEUMAJ_438245#158413)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_CODUTI_438246#158405)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_CODUTI_438246#158405)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SERDSC_438247#158432)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_SERDSC_438247#158432)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_REQ_PROC_ID_438248#158430)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_REQ_PROC_ID_438248#158430)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SCH_PROC_STE_438249#158431)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_SCH_PROC_STE_438249#158431)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_FLARCH_438250#158410)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_FLARCH_438250#158410)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_CODTS_438251#158404)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_CODTS_438251#158404)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_BODYPART_438252#158403)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_BODYPART_438252#158403)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SOURCE_438253#158436)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_SOURCE_438253#158436)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_FRAME_REF_438254#158411)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_FRAME_REF_438254#158411)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HIDE_438255#158416)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_HIDE_438255#158416)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_LATER_438256#158417)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_LATER_438256#158417)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HIDEXPL_438257#158415)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(SE_HIDEXPL_438257#158415)), A63000893163) END)

(10) Project
Output: []
Input [39]: [SE_BODYPART_438252#158403, SE_CODTS_438251#158404, SE_CODUTI_438246#158405, SE_COMM_1_438240#158406, SE_DATEFF_438238#158407, SE_DATMAJ_438244#158408, SE_DATSER_438228#158409, SE_FLARCH_438250#158410, SE_FRAME_REF_438254#158411, SE_HEUEFF_438239#158412, SE_HEUMAJ_438245#158413, SE_HEUSER_438229#158414, SE_HIDEXPL_438257#158415, SE_HIDE_438255#158416, SE_LATER_438256#158417, SE_LIEU_438234#158418, SE_MODALI_438230#158419, SE_NB_FIC_438231#158420, SE_NB_IMA_438232#158421, SE_NUMCD_438235#158422, SE_NUMDEM_438243#158423, SE_NUMDOS_438242#158424, SE_NUMSER_438220#158425, SE_NUMSTU_438219#158426, SE_N_SER_438223#158427, SE_PROTOC_438227#158428, SE_RAPPRO_438241#158429, SE_REQ_PROC_ID_438248#158430, SE_SCH_PROC_STE_438249#158431, SE_SERDSC_438247#158432, SE_SEREFF_438237#158433, SE_SER_ID_438221#158434, SE_SOPUID_438222#158435, SE_SOURCE_438253#158436, SE_STATUT_438236#158437, SE_TAIFIC_438233#158438, SE_TYPEXA_438224#158439, SE_TYPPRS_438225#158440, SE_TYPSER_438226#158441]

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

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

(13) HashAggregate
Input [1]: [count#159714L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#159505L]
Results [1]: [count(1)#159505L AS COL_bc973c3b-9ce9-46ae-a8fb-a9ddcf5acaa2#159507L]

(14) AdaptiveSparkPlan
Output [1]: [COL_bc973c3b-9ce9-46ae-a8fb-a9ddcf5acaa2#159507L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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