hdh-spark-job - Details for Query 629

Submitted Time: 2026/10/21 21:34:13
Duration: 0.2 s
Succeeded Jobs: 572 574

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: 59.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: 59.0 B"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 5 ms"; 5 [labelType="html" label="HashAggregate time in aggregation build: 5 ms number of output rows: 1"]; 6 [labelType="html" label=" Project "]; 7 [labelType="html" label="Filter number of output rows: 29"]; 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=12444]

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

Project

Filter ((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMSTU_438219#130957)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMSTU_438219#130957)), ) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMSER_438220#130956)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMSER_438220#130956)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SER_ID_438221#130965)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_SER_ID_438221#130965)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SOPUID_438222#130966)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_SOPUID_438222#130966)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_N_SER_438223#130958)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_N_SER_438223#130958)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TYPEXA_438224#130970)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_TYPEXA_438224#130970)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TYPPRS_438225#130971)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_TYPPRS_438225#130971)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TYPSER_438226#130972)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_TYPSER_438226#130972)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_PROTOC_438227#130959)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_PROTOC_438227#130959)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_DATSER_438228#130940)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_DATSER_438228#130940)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HEUSER_438229#130945)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_HEUSER_438229#130945)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_MODALI_438230#130950)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_MODALI_438230#130950)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NB_FIC_438231#130951)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_NB_FIC_438231#130951)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NB_IMA_438232#130952)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_NB_IMA_438232#130952)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TAIFIC_438233#130969)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_TAIFIC_438233#130969)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_LIEU_438234#130949)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_LIEU_438234#130949)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMCD_438235#130953)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMCD_438235#130953)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_STATUT_438236#130968)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_STATUT_438236#130968)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SEREFF_438237#130964)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_SEREFF_438237#130964)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_DATEFF_438238#130938)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_DATEFF_438238#130938)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HEUEFF_438239#130943)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_HEUEFF_438239#130943)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_COMM_1_438240#130937)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_COMM_1_438240#130937)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_RAPPRO_438241#130960)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_RAPPRO_438241#130960)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMDOS_438242#130955)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMDOS_438242#130955)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMDEM_438243#130954)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMDEM_438243#130954)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_DATMAJ_438244#130939)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_DATMAJ_438244#130939)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HEUMAJ_438245#130944)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_HEUMAJ_438245#130944)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_CODUTI_438246#130936)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_CODUTI_438246#130936)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SERDSC_438247#130963)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_SERDSC_438247#130963)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_REQ_PROC_ID_438248#130961)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_REQ_PROC_ID_438248#130961)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SCH_PROC_STE_438249#130962)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_SCH_PROC_STE_438249#130962)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_FLARCH_438250#130941)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_FLARCH_438250#130941)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_CODTS_438251#130935)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_CODTS_438251#130935)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_BODYPART_438252#130934)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_BODYPART_438252#130934)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SOURCE_438253#130967)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_SOURCE_438253#130967)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_FRAME_REF_438254#130942)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_FRAME_REF_438254#130942)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HIDE_438255#130947)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_HIDE_438255#130947)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_LATER_438256#130948)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_LATER_438256#130948)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HIDEXPL_438257#130946)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_HIDEXPL_438257#130946)), ) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [SE_BODYPART_438252#130934,SE_CODTS_438251#130935,SE_CODUTI_438246#130936,SE_COMM_1_438240#130937,SE_DATEFF_438238#130938,SE_DATMAJ_438244#130939,SE_DATSER_438228#130940,SE_FLARCH_438250#130941,SE_FRAME_REF_438254#130942,SE_HEUEFF_438239#130943,SE_HEUMAJ_438245#130944,SE_HEUSER_438229#130945,SE_HIDEXPL_438257#130946,SE_HIDE_438255#130947,SE_LATER_438256#130948,SE_LIEU_438234#130949,SE_MODALI_438230#130950,SE_NB_FIC_438231#130951,SE_NB_IMA_438232#130952,SE_NUMCD_438235#130953,SE_NUMDEM_438243#130954,SE_NUMDOS_438242#130955,SE_NUMSER_438220#130956,SE_NUMSTU_438219#130957,... 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#130934, SE_CODTS_438251#130935, SE_CODUTI_438246#130936, SE_COMM_1_438240#130937, SE_DATEFF_438238#130938, SE_DATMAJ_438244#130939, SE_DATSER_438228#130940, SE_FLARCH_438250#130941, SE_FRAME_REF_438254#130942, SE_HEUEFF_438239#130943, SE_HEUMAJ_438245#130944, SE_HEUSER_438229#130945, SE_HIDEXPL_438257#130946, SE_HIDE_438255#130947, SE_LATER_438256#130948, SE_LIEU_438234#130949, SE_MODALI_438230#130950, SE_NB_FIC_438231#130951, SE_NB_IMA_438232#130952, SE_NUMCD_438235#130953, SE_NUMDEM_438243#130954, SE_NUMDOS_438242#130955, SE_NUMSER_438220#130956, SE_NUMSTU_438219#130957, SE_N_SER_438223#130958, SE_PROTOC_438227#130959, SE_RAPPRO_438241#130960, SE_REQ_PROC_ID_438248#130961, SE_SCH_PROC_STE_438249#130962, SE_SERDSC_438247#130963, SE_SEREFF_438237#130964, SE_SER_ID_438221#130965, SE_SOPUID_438222#130966, SE_SOURCE_438253#130967, SE_STATUT_438236#130968, SE_TAIFIC_438233#130969, SE_TYPEXA_438224#130970, SE_TYPPRS_438225#130971, SE_TYPSER_438226#130972]
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#130934, SE_CODTS_438251#130935, SE_CODUTI_438246#130936, SE_COMM_1_438240#130937, SE_DATEFF_438238#130938, SE_DATMAJ_438244#130939, SE_DATSER_438228#130940, SE_FLARCH_438250#130941, SE_FRAME_REF_438254#130942, SE_HEUEFF_438239#130943, SE_HEUMAJ_438245#130944, SE_HEUSER_438229#130945, SE_HIDEXPL_438257#130946, SE_HIDE_438255#130947, SE_LATER_438256#130948, SE_LIEU_438234#130949, SE_MODALI_438230#130950, SE_NB_FIC_438231#130951, SE_NB_IMA_438232#130952, SE_NUMCD_438235#130953, SE_NUMDEM_438243#130954, SE_NUMDOS_438242#130955, SE_NUMSER_438220#130956, SE_NUMSTU_438219#130957, SE_N_SER_438223#130958, SE_PROTOC_438227#130959, SE_RAPPRO_438241#130960, SE_REQ_PROC_ID_438248#130961, SE_SCH_PROC_STE_438249#130962, SE_SERDSC_438247#130963, SE_SEREFF_438237#130964, SE_SER_ID_438221#130965, SE_SOPUID_438222#130966, SE_SOURCE_438253#130967, SE_STATUT_438236#130968, SE_TAIFIC_438233#130969, SE_TYPEXA_438224#130970, SE_TYPPRS_438225#130971, SE_TYPSER_438226#130972]

(3) Filter [codegen id : 1]
Input [39]: [SE_BODYPART_438252#130934, SE_CODTS_438251#130935, SE_CODUTI_438246#130936, SE_COMM_1_438240#130937, SE_DATEFF_438238#130938, SE_DATMAJ_438244#130939, SE_DATSER_438228#130940, SE_FLARCH_438250#130941, SE_FRAME_REF_438254#130942, SE_HEUEFF_438239#130943, SE_HEUMAJ_438245#130944, SE_HEUSER_438229#130945, SE_HIDEXPL_438257#130946, SE_HIDE_438255#130947, SE_LATER_438256#130948, SE_LIEU_438234#130949, SE_MODALI_438230#130950, SE_NB_FIC_438231#130951, SE_NB_IMA_438232#130952, SE_NUMCD_438235#130953, SE_NUMDEM_438243#130954, SE_NUMDOS_438242#130955, SE_NUMSER_438220#130956, SE_NUMSTU_438219#130957, SE_N_SER_438223#130958, SE_PROTOC_438227#130959, SE_RAPPRO_438241#130960, SE_REQ_PROC_ID_438248#130961, SE_SCH_PROC_STE_438249#130962, SE_SERDSC_438247#130963, SE_SEREFF_438237#130964, SE_SER_ID_438221#130965, SE_SOPUID_438222#130966, SE_SOURCE_438253#130967, SE_STATUT_438236#130968, SE_TAIFIC_438233#130969, SE_TYPEXA_438224#130970, SE_TYPPRS_438225#130971, SE_TYPSER_438226#130972]
Condition : ((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMSTU_438219#130957)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMSTU_438219#130957)), ) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMSER_438220#130956)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMSER_438220#130956)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SER_ID_438221#130965)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_SER_ID_438221#130965)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SOPUID_438222#130966)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_SOPUID_438222#130966)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_N_SER_438223#130958)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_N_SER_438223#130958)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TYPEXA_438224#130970)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_TYPEXA_438224#130970)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TYPPRS_438225#130971)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_TYPPRS_438225#130971)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TYPSER_438226#130972)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_TYPSER_438226#130972)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_PROTOC_438227#130959)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_PROTOC_438227#130959)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_DATSER_438228#130940)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_DATSER_438228#130940)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HEUSER_438229#130945)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_HEUSER_438229#130945)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_MODALI_438230#130950)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_MODALI_438230#130950)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NB_FIC_438231#130951)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_NB_FIC_438231#130951)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NB_IMA_438232#130952)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_NB_IMA_438232#130952)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TAIFIC_438233#130969)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_TAIFIC_438233#130969)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_LIEU_438234#130949)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_LIEU_438234#130949)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMCD_438235#130953)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMCD_438235#130953)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_STATUT_438236#130968)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_STATUT_438236#130968)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SEREFF_438237#130964)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_SEREFF_438237#130964)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_DATEFF_438238#130938)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_DATEFF_438238#130938)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HEUEFF_438239#130943)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_HEUEFF_438239#130943)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_COMM_1_438240#130937)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_COMM_1_438240#130937)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_RAPPRO_438241#130960)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_RAPPRO_438241#130960)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMDOS_438242#130955)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMDOS_438242#130955)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMDEM_438243#130954)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMDEM_438243#130954)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_DATMAJ_438244#130939)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_DATMAJ_438244#130939)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HEUMAJ_438245#130944)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_HEUMAJ_438245#130944)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_CODUTI_438246#130936)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_CODUTI_438246#130936)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SERDSC_438247#130963)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_SERDSC_438247#130963)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_REQ_PROC_ID_438248#130961)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_REQ_PROC_ID_438248#130961)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SCH_PROC_STE_438249#130962)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_SCH_PROC_STE_438249#130962)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_FLARCH_438250#130941)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_FLARCH_438250#130941)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_CODTS_438251#130935)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_CODTS_438251#130935)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_BODYPART_438252#130934)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_BODYPART_438252#130934)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SOURCE_438253#130967)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_SOURCE_438253#130967)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_FRAME_REF_438254#130942)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_FRAME_REF_438254#130942)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HIDE_438255#130947)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_HIDE_438255#130947)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_LATER_438256#130948)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_LATER_438256#130948)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HIDEXPL_438257#130946)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_HIDEXPL_438257#130946)), ) END)

(4) Project [codegen id : 1]
Output: []
Input [39]: [SE_BODYPART_438252#130934, SE_CODTS_438251#130935, SE_CODUTI_438246#130936, SE_COMM_1_438240#130937, SE_DATEFF_438238#130938, SE_DATMAJ_438244#130939, SE_DATSER_438228#130940, SE_FLARCH_438250#130941, SE_FRAME_REF_438254#130942, SE_HEUEFF_438239#130943, SE_HEUMAJ_438245#130944, SE_HEUSER_438229#130945, SE_HIDEXPL_438257#130946, SE_HIDE_438255#130947, SE_LATER_438256#130948, SE_LIEU_438234#130949, SE_MODALI_438230#130950, SE_NB_FIC_438231#130951, SE_NB_IMA_438232#130952, SE_NUMCD_438235#130953, SE_NUMDEM_438243#130954, SE_NUMDOS_438242#130955, SE_NUMSER_438220#130956, SE_NUMSTU_438219#130957, SE_N_SER_438223#130958, SE_PROTOC_438227#130959, SE_RAPPRO_438241#130960, SE_REQ_PROC_ID_438248#130961, SE_SCH_PROC_STE_438249#130962, SE_SERDSC_438247#130963, SE_SEREFF_438237#130964, SE_SER_ID_438221#130965, SE_SOPUID_438222#130966, SE_SOURCE_438253#130967, SE_STATUT_438236#130968, SE_TAIFIC_438233#130969, SE_TYPEXA_438224#130970, SE_TYPPRS_438225#130971, SE_TYPSER_438226#130972]

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

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

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

(8) HashAggregate [codegen id : 2]
Input [1]: [count#132334L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#132154L]
Results [1]: [count(1)#132154L AS COL_8d5072df-2c58-4c28-a808-a71c2590cab7#132184L]

(9) Filter
Input [39]: [SE_BODYPART_438252#130934, SE_CODTS_438251#130935, SE_CODUTI_438246#130936, SE_COMM_1_438240#130937, SE_DATEFF_438238#130938, SE_DATMAJ_438244#130939, SE_DATSER_438228#130940, SE_FLARCH_438250#130941, SE_FRAME_REF_438254#130942, SE_HEUEFF_438239#130943, SE_HEUMAJ_438245#130944, SE_HEUSER_438229#130945, SE_HIDEXPL_438257#130946, SE_HIDE_438255#130947, SE_LATER_438256#130948, SE_LIEU_438234#130949, SE_MODALI_438230#130950, SE_NB_FIC_438231#130951, SE_NB_IMA_438232#130952, SE_NUMCD_438235#130953, SE_NUMDEM_438243#130954, SE_NUMDOS_438242#130955, SE_NUMSER_438220#130956, SE_NUMSTU_438219#130957, SE_N_SER_438223#130958, SE_PROTOC_438227#130959, SE_RAPPRO_438241#130960, SE_REQ_PROC_ID_438248#130961, SE_SCH_PROC_STE_438249#130962, SE_SERDSC_438247#130963, SE_SEREFF_438237#130964, SE_SER_ID_438221#130965, SE_SOPUID_438222#130966, SE_SOURCE_438253#130967, SE_STATUT_438236#130968, SE_TAIFIC_438233#130969, SE_TYPEXA_438224#130970, SE_TYPPRS_438225#130971, SE_TYPSER_438226#130972]
Condition : ((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMSTU_438219#130957)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMSTU_438219#130957)), ) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMSER_438220#130956)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMSER_438220#130956)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SER_ID_438221#130965)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_SER_ID_438221#130965)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SOPUID_438222#130966)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_SOPUID_438222#130966)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_N_SER_438223#130958)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_N_SER_438223#130958)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TYPEXA_438224#130970)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_TYPEXA_438224#130970)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TYPPRS_438225#130971)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_TYPPRS_438225#130971)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TYPSER_438226#130972)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_TYPSER_438226#130972)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_PROTOC_438227#130959)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_PROTOC_438227#130959)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_DATSER_438228#130940)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_DATSER_438228#130940)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HEUSER_438229#130945)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_HEUSER_438229#130945)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_MODALI_438230#130950)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_MODALI_438230#130950)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NB_FIC_438231#130951)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_NB_FIC_438231#130951)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NB_IMA_438232#130952)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_NB_IMA_438232#130952)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TAIFIC_438233#130969)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_TAIFIC_438233#130969)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_LIEU_438234#130949)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_LIEU_438234#130949)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMCD_438235#130953)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMCD_438235#130953)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_STATUT_438236#130968)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_STATUT_438236#130968)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SEREFF_438237#130964)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_SEREFF_438237#130964)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_DATEFF_438238#130938)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_DATEFF_438238#130938)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HEUEFF_438239#130943)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_HEUEFF_438239#130943)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_COMM_1_438240#130937)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_COMM_1_438240#130937)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_RAPPRO_438241#130960)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_RAPPRO_438241#130960)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMDOS_438242#130955)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMDOS_438242#130955)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMDEM_438243#130954)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMDEM_438243#130954)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_DATMAJ_438244#130939)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_DATMAJ_438244#130939)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HEUMAJ_438245#130944)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_HEUMAJ_438245#130944)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_CODUTI_438246#130936)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_CODUTI_438246#130936)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SERDSC_438247#130963)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_SERDSC_438247#130963)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_REQ_PROC_ID_438248#130961)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_REQ_PROC_ID_438248#130961)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SCH_PROC_STE_438249#130962)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_SCH_PROC_STE_438249#130962)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_FLARCH_438250#130941)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_FLARCH_438250#130941)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_CODTS_438251#130935)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_CODTS_438251#130935)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_BODYPART_438252#130934)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_BODYPART_438252#130934)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SOURCE_438253#130967)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_SOURCE_438253#130967)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_FRAME_REF_438254#130942)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_FRAME_REF_438254#130942)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HIDE_438255#130947)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_HIDE_438255#130947)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_LATER_438256#130948)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_LATER_438256#130948)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HIDEXPL_438257#130946)), )) THEN false ELSE Contains(str_remove_accent(upper(SE_HIDEXPL_438257#130946)), ) END)

(10) Project
Output: []
Input [39]: [SE_BODYPART_438252#130934, SE_CODTS_438251#130935, SE_CODUTI_438246#130936, SE_COMM_1_438240#130937, SE_DATEFF_438238#130938, SE_DATMAJ_438244#130939, SE_DATSER_438228#130940, SE_FLARCH_438250#130941, SE_FRAME_REF_438254#130942, SE_HEUEFF_438239#130943, SE_HEUMAJ_438245#130944, SE_HEUSER_438229#130945, SE_HIDEXPL_438257#130946, SE_HIDE_438255#130947, SE_LATER_438256#130948, SE_LIEU_438234#130949, SE_MODALI_438230#130950, SE_NB_FIC_438231#130951, SE_NB_IMA_438232#130952, SE_NUMCD_438235#130953, SE_NUMDEM_438243#130954, SE_NUMDOS_438242#130955, SE_NUMSER_438220#130956, SE_NUMSTU_438219#130957, SE_N_SER_438223#130958, SE_PROTOC_438227#130959, SE_RAPPRO_438241#130960, SE_REQ_PROC_ID_438248#130961, SE_SCH_PROC_STE_438249#130962, SE_SERDSC_438247#130963, SE_SEREFF_438237#130964, SE_SER_ID_438221#130965, SE_SOPUID_438222#130966, SE_SOURCE_438253#130967, SE_STATUT_438236#130968, SE_TAIFIC_438233#130969, SE_TYPEXA_438224#130970, SE_TYPPRS_438225#130971, SE_TYPSER_438226#130972]

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

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

(13) HashAggregate
Input [1]: [count#132334L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#132154L]
Results [1]: [count(1)#132154L AS COL_8d5072df-2c58-4c28-a808-a71c2590cab7#132184L]

(14) AdaptiveSparkPlan
Output [1]: [COL_8d5072df-2c58-4c28-a808-a71c2590cab7#132184L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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