hdh-spark-job - Details for Query 684

Submitted Time: 2026/10/21 21:34:30
Duration: 0.2 s
Succeeded Jobs: 650 653

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

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

Project

Filter ((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMSTU_438219#146050)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMSTU_438219#146050)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMSER_438220#146049)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMSER_438220#146049)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SER_ID_438221#146058)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_SER_ID_438221#146058)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SOPUID_438222#146059)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_SOPUID_438222#146059)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_N_SER_438223#146051)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_N_SER_438223#146051)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TYPEXA_438224#146063)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_TYPEXA_438224#146063)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TYPPRS_438225#146064)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_TYPPRS_438225#146064)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TYPSER_438226#146065)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_TYPSER_438226#146065)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_PROTOC_438227#146052)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_PROTOC_438227#146052)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_DATSER_438228#146033)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_DATSER_438228#146033)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HEUSER_438229#146038)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_HEUSER_438229#146038)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_MODALI_438230#146043)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_MODALI_438230#146043)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NB_FIC_438231#146044)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_NB_FIC_438231#146044)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NB_IMA_438232#146045)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_NB_IMA_438232#146045)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TAIFIC_438233#146062)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_TAIFIC_438233#146062)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_LIEU_438234#146042)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_LIEU_438234#146042)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMCD_438235#146046)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMCD_438235#146046)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_STATUT_438236#146061)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_STATUT_438236#146061)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SEREFF_438237#146057)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_SEREFF_438237#146057)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_DATEFF_438238#146031)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_DATEFF_438238#146031)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HEUEFF_438239#146036)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_HEUEFF_438239#146036)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_COMM_1_438240#146030)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_COMM_1_438240#146030)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_RAPPRO_438241#146053)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_RAPPRO_438241#146053)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMDOS_438242#146048)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMDOS_438242#146048)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMDEM_438243#146047)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMDEM_438243#146047)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_DATMAJ_438244#146032)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_DATMAJ_438244#146032)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HEUMAJ_438245#146037)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_HEUMAJ_438245#146037)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_CODUTI_438246#146029)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_CODUTI_438246#146029)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SERDSC_438247#146056)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_SERDSC_438247#146056)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_REQ_PROC_ID_438248#146054)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_REQ_PROC_ID_438248#146054)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SCH_PROC_STE_438249#146055)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_SCH_PROC_STE_438249#146055)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_FLARCH_438250#146034)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_FLARCH_438250#146034)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_CODTS_438251#146028)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_CODTS_438251#146028)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_BODYPART_438252#146027)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_BODYPART_438252#146027)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SOURCE_438253#146060)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_SOURCE_438253#146060)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_FRAME_REF_438254#146035)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_FRAME_REF_438254#146035)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HIDE_438255#146040)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_HIDE_438255#146040)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_LATER_438256#146041)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_LATER_438256#146041)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HIDEXPL_438257#146039)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_HIDEXPL_438257#146039)), MARX) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [SE_BODYPART_438252#146027,SE_CODTS_438251#146028,SE_CODUTI_438246#146029,SE_COMM_1_438240#146030,SE_DATEFF_438238#146031,SE_DATMAJ_438244#146032,SE_DATSER_438228#146033,SE_FLARCH_438250#146034,SE_FRAME_REF_438254#146035,SE_HEUEFF_438239#146036,SE_HEUMAJ_438245#146037,SE_HEUSER_438229#146038,SE_HIDEXPL_438257#146039,SE_HIDE_438255#146040,SE_LATER_438256#146041,SE_LIEU_438234#146042,SE_MODALI_438230#146043,SE_NB_FIC_438231#146044,SE_NB_IMA_438232#146045,SE_NUMCD_438235#146046,SE_NUMDEM_438243#146047,SE_NUMDOS_438242#146048,SE_NUMSER_438220#146049,SE_NUMSTU_438219#146050,... 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#146027, SE_CODTS_438251#146028, SE_CODUTI_438246#146029, SE_COMM_1_438240#146030, SE_DATEFF_438238#146031, SE_DATMAJ_438244#146032, SE_DATSER_438228#146033, SE_FLARCH_438250#146034, SE_FRAME_REF_438254#146035, SE_HEUEFF_438239#146036, SE_HEUMAJ_438245#146037, SE_HEUSER_438229#146038, SE_HIDEXPL_438257#146039, SE_HIDE_438255#146040, SE_LATER_438256#146041, SE_LIEU_438234#146042, SE_MODALI_438230#146043, SE_NB_FIC_438231#146044, SE_NB_IMA_438232#146045, SE_NUMCD_438235#146046, SE_NUMDEM_438243#146047, SE_NUMDOS_438242#146048, SE_NUMSER_438220#146049, SE_NUMSTU_438219#146050, SE_N_SER_438223#146051, SE_PROTOC_438227#146052, SE_RAPPRO_438241#146053, SE_REQ_PROC_ID_438248#146054, SE_SCH_PROC_STE_438249#146055, SE_SERDSC_438247#146056, SE_SEREFF_438237#146057, SE_SER_ID_438221#146058, SE_SOPUID_438222#146059, SE_SOURCE_438253#146060, SE_STATUT_438236#146061, SE_TAIFIC_438233#146062, SE_TYPEXA_438224#146063, SE_TYPPRS_438225#146064, SE_TYPSER_438226#146065]
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#146027, SE_CODTS_438251#146028, SE_CODUTI_438246#146029, SE_COMM_1_438240#146030, SE_DATEFF_438238#146031, SE_DATMAJ_438244#146032, SE_DATSER_438228#146033, SE_FLARCH_438250#146034, SE_FRAME_REF_438254#146035, SE_HEUEFF_438239#146036, SE_HEUMAJ_438245#146037, SE_HEUSER_438229#146038, SE_HIDEXPL_438257#146039, SE_HIDE_438255#146040, SE_LATER_438256#146041, SE_LIEU_438234#146042, SE_MODALI_438230#146043, SE_NB_FIC_438231#146044, SE_NB_IMA_438232#146045, SE_NUMCD_438235#146046, SE_NUMDEM_438243#146047, SE_NUMDOS_438242#146048, SE_NUMSER_438220#146049, SE_NUMSTU_438219#146050, SE_N_SER_438223#146051, SE_PROTOC_438227#146052, SE_RAPPRO_438241#146053, SE_REQ_PROC_ID_438248#146054, SE_SCH_PROC_STE_438249#146055, SE_SERDSC_438247#146056, SE_SEREFF_438237#146057, SE_SER_ID_438221#146058, SE_SOPUID_438222#146059, SE_SOURCE_438253#146060, SE_STATUT_438236#146061, SE_TAIFIC_438233#146062, SE_TYPEXA_438224#146063, SE_TYPPRS_438225#146064, SE_TYPSER_438226#146065]

(3) Filter [codegen id : 1]
Input [39]: [SE_BODYPART_438252#146027, SE_CODTS_438251#146028, SE_CODUTI_438246#146029, SE_COMM_1_438240#146030, SE_DATEFF_438238#146031, SE_DATMAJ_438244#146032, SE_DATSER_438228#146033, SE_FLARCH_438250#146034, SE_FRAME_REF_438254#146035, SE_HEUEFF_438239#146036, SE_HEUMAJ_438245#146037, SE_HEUSER_438229#146038, SE_HIDEXPL_438257#146039, SE_HIDE_438255#146040, SE_LATER_438256#146041, SE_LIEU_438234#146042, SE_MODALI_438230#146043, SE_NB_FIC_438231#146044, SE_NB_IMA_438232#146045, SE_NUMCD_438235#146046, SE_NUMDEM_438243#146047, SE_NUMDOS_438242#146048, SE_NUMSER_438220#146049, SE_NUMSTU_438219#146050, SE_N_SER_438223#146051, SE_PROTOC_438227#146052, SE_RAPPRO_438241#146053, SE_REQ_PROC_ID_438248#146054, SE_SCH_PROC_STE_438249#146055, SE_SERDSC_438247#146056, SE_SEREFF_438237#146057, SE_SER_ID_438221#146058, SE_SOPUID_438222#146059, SE_SOURCE_438253#146060, SE_STATUT_438236#146061, SE_TAIFIC_438233#146062, SE_TYPEXA_438224#146063, SE_TYPPRS_438225#146064, SE_TYPSER_438226#146065]
Condition : ((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMSTU_438219#146050)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMSTU_438219#146050)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMSER_438220#146049)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMSER_438220#146049)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SER_ID_438221#146058)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_SER_ID_438221#146058)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SOPUID_438222#146059)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_SOPUID_438222#146059)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_N_SER_438223#146051)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_N_SER_438223#146051)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TYPEXA_438224#146063)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_TYPEXA_438224#146063)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TYPPRS_438225#146064)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_TYPPRS_438225#146064)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TYPSER_438226#146065)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_TYPSER_438226#146065)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_PROTOC_438227#146052)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_PROTOC_438227#146052)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_DATSER_438228#146033)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_DATSER_438228#146033)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HEUSER_438229#146038)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_HEUSER_438229#146038)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_MODALI_438230#146043)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_MODALI_438230#146043)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NB_FIC_438231#146044)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_NB_FIC_438231#146044)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NB_IMA_438232#146045)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_NB_IMA_438232#146045)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TAIFIC_438233#146062)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_TAIFIC_438233#146062)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_LIEU_438234#146042)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_LIEU_438234#146042)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMCD_438235#146046)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMCD_438235#146046)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_STATUT_438236#146061)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_STATUT_438236#146061)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SEREFF_438237#146057)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_SEREFF_438237#146057)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_DATEFF_438238#146031)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_DATEFF_438238#146031)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HEUEFF_438239#146036)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_HEUEFF_438239#146036)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_COMM_1_438240#146030)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_COMM_1_438240#146030)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_RAPPRO_438241#146053)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_RAPPRO_438241#146053)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMDOS_438242#146048)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMDOS_438242#146048)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMDEM_438243#146047)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMDEM_438243#146047)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_DATMAJ_438244#146032)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_DATMAJ_438244#146032)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HEUMAJ_438245#146037)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_HEUMAJ_438245#146037)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_CODUTI_438246#146029)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_CODUTI_438246#146029)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SERDSC_438247#146056)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_SERDSC_438247#146056)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_REQ_PROC_ID_438248#146054)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_REQ_PROC_ID_438248#146054)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SCH_PROC_STE_438249#146055)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_SCH_PROC_STE_438249#146055)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_FLARCH_438250#146034)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_FLARCH_438250#146034)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_CODTS_438251#146028)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_CODTS_438251#146028)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_BODYPART_438252#146027)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_BODYPART_438252#146027)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SOURCE_438253#146060)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_SOURCE_438253#146060)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_FRAME_REF_438254#146035)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_FRAME_REF_438254#146035)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HIDE_438255#146040)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_HIDE_438255#146040)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_LATER_438256#146041)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_LATER_438256#146041)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HIDEXPL_438257#146039)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_HIDEXPL_438257#146039)), MARX) END)

(4) Project [codegen id : 1]
Output: []
Input [39]: [SE_BODYPART_438252#146027, SE_CODTS_438251#146028, SE_CODUTI_438246#146029, SE_COMM_1_438240#146030, SE_DATEFF_438238#146031, SE_DATMAJ_438244#146032, SE_DATSER_438228#146033, SE_FLARCH_438250#146034, SE_FRAME_REF_438254#146035, SE_HEUEFF_438239#146036, SE_HEUMAJ_438245#146037, SE_HEUSER_438229#146038, SE_HIDEXPL_438257#146039, SE_HIDE_438255#146040, SE_LATER_438256#146041, SE_LIEU_438234#146042, SE_MODALI_438230#146043, SE_NB_FIC_438231#146044, SE_NB_IMA_438232#146045, SE_NUMCD_438235#146046, SE_NUMDEM_438243#146047, SE_NUMDOS_438242#146048, SE_NUMSER_438220#146049, SE_NUMSTU_438219#146050, SE_N_SER_438223#146051, SE_PROTOC_438227#146052, SE_RAPPRO_438241#146053, SE_REQ_PROC_ID_438248#146054, SE_SCH_PROC_STE_438249#146055, SE_SERDSC_438247#146056, SE_SEREFF_438237#146057, SE_SER_ID_438221#146058, SE_SOPUID_438222#146059, SE_SOURCE_438253#146060, SE_STATUT_438236#146061, SE_TAIFIC_438233#146062, SE_TYPEXA_438224#146063, SE_TYPPRS_438225#146064, SE_TYPSER_438226#146065]

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

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

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

(8) HashAggregate [codegen id : 2]
Input [1]: [count#148013L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#147915L]
Results [1]: [count(1)#147915L AS COL_a03957d0-d463-478b-b8f1-f1c8a23ad6dc#147917L]

(9) Filter
Input [39]: [SE_BODYPART_438252#146027, SE_CODTS_438251#146028, SE_CODUTI_438246#146029, SE_COMM_1_438240#146030, SE_DATEFF_438238#146031, SE_DATMAJ_438244#146032, SE_DATSER_438228#146033, SE_FLARCH_438250#146034, SE_FRAME_REF_438254#146035, SE_HEUEFF_438239#146036, SE_HEUMAJ_438245#146037, SE_HEUSER_438229#146038, SE_HIDEXPL_438257#146039, SE_HIDE_438255#146040, SE_LATER_438256#146041, SE_LIEU_438234#146042, SE_MODALI_438230#146043, SE_NB_FIC_438231#146044, SE_NB_IMA_438232#146045, SE_NUMCD_438235#146046, SE_NUMDEM_438243#146047, SE_NUMDOS_438242#146048, SE_NUMSER_438220#146049, SE_NUMSTU_438219#146050, SE_N_SER_438223#146051, SE_PROTOC_438227#146052, SE_RAPPRO_438241#146053, SE_REQ_PROC_ID_438248#146054, SE_SCH_PROC_STE_438249#146055, SE_SERDSC_438247#146056, SE_SEREFF_438237#146057, SE_SER_ID_438221#146058, SE_SOPUID_438222#146059, SE_SOURCE_438253#146060, SE_STATUT_438236#146061, SE_TAIFIC_438233#146062, SE_TYPEXA_438224#146063, SE_TYPPRS_438225#146064, SE_TYPSER_438226#146065]
Condition : ((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMSTU_438219#146050)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMSTU_438219#146050)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMSER_438220#146049)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMSER_438220#146049)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SER_ID_438221#146058)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_SER_ID_438221#146058)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SOPUID_438222#146059)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_SOPUID_438222#146059)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_N_SER_438223#146051)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_N_SER_438223#146051)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TYPEXA_438224#146063)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_TYPEXA_438224#146063)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TYPPRS_438225#146064)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_TYPPRS_438225#146064)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TYPSER_438226#146065)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_TYPSER_438226#146065)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_PROTOC_438227#146052)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_PROTOC_438227#146052)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_DATSER_438228#146033)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_DATSER_438228#146033)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HEUSER_438229#146038)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_HEUSER_438229#146038)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_MODALI_438230#146043)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_MODALI_438230#146043)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NB_FIC_438231#146044)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_NB_FIC_438231#146044)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NB_IMA_438232#146045)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_NB_IMA_438232#146045)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_TAIFIC_438233#146062)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_TAIFIC_438233#146062)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_LIEU_438234#146042)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_LIEU_438234#146042)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMCD_438235#146046)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMCD_438235#146046)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_STATUT_438236#146061)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_STATUT_438236#146061)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SEREFF_438237#146057)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_SEREFF_438237#146057)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_DATEFF_438238#146031)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_DATEFF_438238#146031)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HEUEFF_438239#146036)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_HEUEFF_438239#146036)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_COMM_1_438240#146030)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_COMM_1_438240#146030)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_RAPPRO_438241#146053)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_RAPPRO_438241#146053)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMDOS_438242#146048)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMDOS_438242#146048)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_NUMDEM_438243#146047)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_NUMDEM_438243#146047)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_DATMAJ_438244#146032)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_DATMAJ_438244#146032)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HEUMAJ_438245#146037)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_HEUMAJ_438245#146037)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_CODUTI_438246#146029)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_CODUTI_438246#146029)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SERDSC_438247#146056)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_SERDSC_438247#146056)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_REQ_PROC_ID_438248#146054)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_REQ_PROC_ID_438248#146054)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SCH_PROC_STE_438249#146055)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_SCH_PROC_STE_438249#146055)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_FLARCH_438250#146034)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_FLARCH_438250#146034)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_CODTS_438251#146028)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_CODTS_438251#146028)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_BODYPART_438252#146027)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_BODYPART_438252#146027)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_SOURCE_438253#146060)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_SOURCE_438253#146060)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_FRAME_REF_438254#146035)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_FRAME_REF_438254#146035)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HIDE_438255#146040)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_HIDE_438255#146040)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_LATER_438256#146041)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_LATER_438256#146041)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(SE_HIDEXPL_438257#146039)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(SE_HIDEXPL_438257#146039)), MARX) END)

(10) Project
Output: []
Input [39]: [SE_BODYPART_438252#146027, SE_CODTS_438251#146028, SE_CODUTI_438246#146029, SE_COMM_1_438240#146030, SE_DATEFF_438238#146031, SE_DATMAJ_438244#146032, SE_DATSER_438228#146033, SE_FLARCH_438250#146034, SE_FRAME_REF_438254#146035, SE_HEUEFF_438239#146036, SE_HEUMAJ_438245#146037, SE_HEUSER_438229#146038, SE_HIDEXPL_438257#146039, SE_HIDE_438255#146040, SE_LATER_438256#146041, SE_LIEU_438234#146042, SE_MODALI_438230#146043, SE_NB_FIC_438231#146044, SE_NB_IMA_438232#146045, SE_NUMCD_438235#146046, SE_NUMDEM_438243#146047, SE_NUMDOS_438242#146048, SE_NUMSER_438220#146049, SE_NUMSTU_438219#146050, SE_N_SER_438223#146051, SE_PROTOC_438227#146052, SE_RAPPRO_438241#146053, SE_REQ_PROC_ID_438248#146054, SE_SCH_PROC_STE_438249#146055, SE_SERDSC_438247#146056, SE_SEREFF_438237#146057, SE_SER_ID_438221#146058, SE_SOPUID_438222#146059, SE_SOURCE_438253#146060, SE_STATUT_438236#146061, SE_TAIFIC_438233#146062, SE_TYPEXA_438224#146063, SE_TYPPRS_438225#146064, SE_TYPSER_438226#146065]

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

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

(13) HashAggregate
Input [1]: [count#148013L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#147915L]
Results [1]: [count(1)#147915L AS COL_a03957d0-d463-478b-b8f1-f1c8a23ad6dc#147917L]

(14) AdaptiveSparkPlan
Output [1]: [COL_a03957d0-d463-478b-b8f1-f1c8a23ad6dc#147917L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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