hdh-spark-job - Details for Query 589

Submitted Time: 2026/10/21 21:31:44
Duration: 3 s
Succeeded Jobs: 510 519

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: 2 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 680.0: task 693)) 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: 2 local bytes read: 115.0 B fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 2 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 32.0 B (16.0 B, 16.0 B, 16.0 B (stage 680.0: task 693)) 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 total (min, med, max (stageId: taskId)) 115.0 B (56.0 B, 59.0 B, 59.0 B (stage 680.0: task 692))"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n2.5 s (7 ms, 2.5 s, 2.5 s (stage 680.0: task 692))"; 5 [labelType="html" label="HashAggregate time in aggregation build total (min, med, max (stageId: taskId)) 2.5 s (7 ms, 2.5 s, 2.5 s (stage 680.0: task 692)) number of output rows: 2"]; } 6 [labelType="html" label=" Project "]; 7 [labelType="html" label="Filter number of output rows: 5"]; 8 [labelType="html" label="Scan parquet number of output rows: 17,658 number of files read: 1 metadata time: 0 ms size of files read: 4.5 MiB"]; 2->0; 3->2; 5->3; 6->5; 7->6; 8->7; }

AdaptiveSparkPlan isFinalPlan=true

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

WholeStageCodegen (2)

Exchange SinglePartition, ENSURE_REQUIREMENTS, [plan_id=11541]

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

WholeStageCodegen (1)

Project

Filter (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMCR_437325#119154)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMCR_437325#119154)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMDOS_437326#119157)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMDOS_437326#119157)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NOMDIC_437327#119151)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NOMDIC_437327#119151)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMDEM_437328#119156)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMDEM_437328#119156)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMEXA_437329#119159)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMEXA_437329#119159)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_TYPDOC_437330#119194)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_TYPDOC_437330#119194)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_PRIOR_437331#119168)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_PRIOR_437331#119168)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NOMDCR_437332#119150)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NOMDCR_437332#119150)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_TAIDCR_437333#119190)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_TAIDCR_437333#119190)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DURDCR_437334#119121)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DURDCR_437334#119121)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_POSDCR_437335#119167)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_POSDCR_437335#119167)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NOMDOS_437336#119152)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NOMDOS_437336#119152)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_FOR_CR_437337#119128)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_FOR_CR_437337#119128)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CR_437338#119104)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CR_437338#119104)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STATDIC_437339#119178)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STATDIC_437339#119178)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STATSM_437340#119179)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STATSM_437340#119179)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STATCR_437341#119177)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STATCR_437341#119177)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODDIC_437342#119093)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODDIC_437342#119093)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CONTEXT_437343#119103)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CONTEXT_437343#119103)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATDIC_437344#119107)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATDIC_437344#119107)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUDIC_437345#119131)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUDIC_437345#119131)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUI_D_437346#119133)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUI_D_437346#119133)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUI_F_437347#119134)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUI_F_437347#119134)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODSEC_437348#119098)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODSEC_437348#119098)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATSEC_437349#119113)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATSEC_437349#119113)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUSEC_437350#119137)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUSEC_437350#119137)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODVCR_437351#119102)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODVCR_437351#119102)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATVCR_437352#119115)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATVCR_437352#119115)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUVCR_437353#119139)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUVCR_437353#119139)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODDCR_437354#119092)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODDCR_437354#119092)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATDCR_437355#119106)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATDCR_437355#119106)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUDCR_437356#119130)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUDCR_437356#119130)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DAT_EFF_D_437357#119118)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DAT_EFF_D_437357#119118)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DAT_EFF_W_437358#119119)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DAT_EFF_W_437358#119119)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODUTI_437359#119101)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODUTI_437359#119101)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATMAJ_437360#119110)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATMAJ_437360#119110)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODSIT_437361#119099)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODSIT_437361#119099)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_SECTRA_437362#119173)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_SECTRA_437362#119173)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_TYPCR_437363#119192)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_TYPCR_437363#119192)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODSUP_437364#119100)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODSUP_437364#119100)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NIVVCR_437365#119149)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NIVVCR_437365#119149)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMVCR_437366#119162)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMVCR_437366#119162)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NB_COR_437367#119147)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NB_COR_437367#119147)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATSUP_437368#119114)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATSUP_437368#119114)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUSUP_437369#119138)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUSUP_437369#119138)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_FLARCH_437370#119122)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_FLARCH_437370#119122)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STAEXT_437371#119176)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STAEXT_437371#119176)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_FLIMPR_437372#119124)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_FLIMPR_437372#119124)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_LOCKCR_437373#119144)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_LOCKCR_437373#119144)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODMCR_437374#119097)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODMCR_437374#119097)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATMCR_437375#119111)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATMCR_437375#119111)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUMCR_437376#119136)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUMCR_437376#119136)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODACC_437377#119090)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODACC_437377#119090)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_MOTPAS_437378#119145)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_MOTPAS_437378#119145)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_LIBCO_437379#119143)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_LIBCO_437379#119143)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_SUBDIC_437380#119187)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_SUBDIC_437380#119187)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_SUBDIR_437381#119188)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_SUBDIR_437381#119188)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMPRT_437382#119161)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMPRT_437382#119161)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STA_ENV_PRT_437383#119183)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STA_ENV_PRT_437383#119183)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STA_RET_PRO_437384#119186)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STA_RET_PRO_437384#119186)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STA_ENV_FRA_437385#119182)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STA_ENV_FRA_437385#119182)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STA_RET_FRA_437386#119185)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STA_RET_FRA_437386#119185)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODCLI_437387#119091)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODCLI_437387#119091)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_PRI_DIC_437388#119169)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_PRI_DIC_437388#119169)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DAT_DIC_TRA_437389#119117)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DAT_DIC_TRA_437389#119117)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEU_DIC_TRA_437390#119141)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEU_DIC_TRA_437390#119141)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODFRA_437391#119095)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODFRA_437391#119095)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_SECEXT_437392#119172)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_SECEXT_437392#119172)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STATUT_EXT_437393#119180)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STATUT_EXT_437393#119180)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_SIMP_JOB_ID_437394#119174)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_SIMP_JOB_ID_437394#119174)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DAT_CR_INT_437395#119116)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DAT_CR_INT_437395#119116)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEU_CR_INT_437396#119140)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEU_CR_INT_437396#119140)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DELAI_TOTAL_437397#119120)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DELAI_TOTAL_437397#119120)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NB_LIGNE_EXT_437398#119148)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NB_LIGNE_EXT_437398#119148)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NB_CAR_EXT_437399#119146)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NB_CAR_EXT_437399#119146)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NOMEXT_437400#119153)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NOMEXT_437400#119153)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_SUBEXT_437401#119189)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_SUBEXT_437401#119189)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_FLTBDI_437402#119126)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_FLTBDI_437402#119126)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_TYPDIC_437403#119193)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_TYPDIC_437403#119193)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STA_ENV_ACK_437404#119181)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STA_ENV_ACK_437404#119181)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STA_RET_ACK_437405#119184)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STA_RET_ACK_437405#119184)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_TAILLE_DIC_437406#119191)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_TAILLE_DIC_437406#119191)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CHKSUM_DIC_437407#119089)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CHKSUM_DIC_437407#119089)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATMAIL_437408#119109)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATMAIL_437408#119109)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUMAIL_437409#119135)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUMAIL_437409#119135)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODMAIL_437410#119096)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODMAIL_437410#119096)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STADMP_437411#119175)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STADMP_437411#119175)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODDMP_437412#119094)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODDMP_437412#119094)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATDMP_437413#119108)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATDMP_437413#119108)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUDMP_437414#119132)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUDMP_437414#119132)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_OIDDMP_437415#119163)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_OIDDMP_437415#119163)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_VISDMP_437416#119195)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_VISDMP_437416#119195)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_SCNPAT_437417#119171)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_SCNPAT_437417#119171)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATSCN_437418#119112)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATSCN_437418#119112)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMMCR_437419#119160)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMMCR_437419#119160)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMCR_CLOUD_437420#119155)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMCR_CLOUD_437420#119155)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMDRV_437421#119158)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMDRV_437421#119158)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_FLARCH_D_437422#119123)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_FLARCH_D_437422#119123)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_REFEXT_437423#119170)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_REFEXT_437423#119170)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_ANNONCE_437424#119088)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_ANNONCE_437424#119088)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_PERIPH_437425#119166)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_PERIPH_437425#119166)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATCRE_437426#119105)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATCRE_437426#119105)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUCRE_437427#119129)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUCRE_437427#119129)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_ORIGINE_437428#119165)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_ORIGINE_437428#119165)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_OID_437429#119164)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_OID_437429#119164)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_FLORDO_437430#119125)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_FLORDO_437430#119125)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_IDCDA_437431#119142)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_IDCDA_437431#119142)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_FLTR_437432#119127)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_FLTR_437432#119127)), MARX) END)

FileScan parquet [CR_ANNONCE_437424#119088,CR_CHKSUM_DIC_437407#119089,CR_CODACC_437377#119090,CR_CODCLI_437387#119091,CR_CODDCR_437354#119092,CR_CODDIC_437342#119093,CR_CODDMP_437412#119094,CR_CODFRA_437391#119095,CR_CODMAIL_437410#119096,CR_CODMCR_437374#119097,CR_CODSEC_437348#119098,CR_CODSIT_437361#119099,CR_CODSUP_437364#119100,CR_CODUTI_437359#119101,CR_CODVCR_437351#119102,CR_CONTEXT_437343#119103,CR_CR_437338#119104,CR_DATCRE_437426#119105,CR_DATDCR_437355#119106,CR_DATDIC_437344#119107,CR_DATDMP_437413#119108,CR_DATMAIL_437408#119109,CR_DATMAJ_437360#119110,CR_DATMCR_437375#119111,... 84 more fields] Batched: false, DataFilters: [((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/uet/H_CR_437324], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<CR_ANNONCE_437424:string,CR_CHKSUM_DIC_437407:string,CR_CODACC_437377:string,CR_CODCLI_437...

Details

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


(1) Scan parquet 
Output [108]: [CR_ANNONCE_437424#119088, CR_CHKSUM_DIC_437407#119089, CR_CODACC_437377#119090, CR_CODCLI_437387#119091, CR_CODDCR_437354#119092, CR_CODDIC_437342#119093, CR_CODDMP_437412#119094, CR_CODFRA_437391#119095, CR_CODMAIL_437410#119096, CR_CODMCR_437374#119097, CR_CODSEC_437348#119098, CR_CODSIT_437361#119099, CR_CODSUP_437364#119100, CR_CODUTI_437359#119101, CR_CODVCR_437351#119102, CR_CONTEXT_437343#119103, CR_CR_437338#119104, CR_DATCRE_437426#119105, CR_DATDCR_437355#119106, CR_DATDIC_437344#119107, CR_DATDMP_437413#119108, CR_DATMAIL_437408#119109, CR_DATMAJ_437360#119110, CR_DATMCR_437375#119111, CR_DATSCN_437418#119112, CR_DATSEC_437349#119113, CR_DATSUP_437368#119114, CR_DATVCR_437352#119115, CR_DAT_CR_INT_437395#119116, CR_DAT_DIC_TRA_437389#119117, CR_DAT_EFF_D_437357#119118, CR_DAT_EFF_W_437358#119119, CR_DELAI_TOTAL_437397#119120, CR_DURDCR_437334#119121, CR_FLARCH_437370#119122, CR_FLARCH_D_437422#119123, CR_FLIMPR_437372#119124, CR_FLORDO_437430#119125, CR_FLTBDI_437402#119126, CR_FLTR_437432#119127, CR_FOR_CR_437337#119128, CR_HEUCRE_437427#119129, CR_HEUDCR_437356#119130, CR_HEUDIC_437345#119131, CR_HEUDMP_437414#119132, CR_HEUI_D_437346#119133, CR_HEUI_F_437347#119134, CR_HEUMAIL_437409#119135, CR_HEUMCR_437376#119136, CR_HEUSEC_437350#119137, CR_HEUSUP_437369#119138, CR_HEUVCR_437353#119139, CR_HEU_CR_INT_437396#119140, CR_HEU_DIC_TRA_437390#119141, CR_IDCDA_437431#119142, CR_LIBCO_437379#119143, CR_LOCKCR_437373#119144, CR_MOTPAS_437378#119145, CR_NB_CAR_EXT_437399#119146, CR_NB_COR_437367#119147, CR_NB_LIGNE_EXT_437398#119148, CR_NIVVCR_437365#119149, CR_NOMDCR_437332#119150, CR_NOMDIC_437327#119151, CR_NOMDOS_437336#119152, CR_NOMEXT_437400#119153, CR_NUMCR_437325#119154, CR_NUMCR_CLOUD_437420#119155, CR_NUMDEM_437328#119156, CR_NUMDOS_437326#119157, CR_NUMDRV_437421#119158, CR_NUMEXA_437329#119159, CR_NUMMCR_437419#119160, CR_NUMPRT_437382#119161, CR_NUMVCR_437366#119162, CR_OIDDMP_437415#119163, CR_OID_437429#119164, CR_ORIGINE_437428#119165, CR_PERIPH_437425#119166, CR_POSDCR_437335#119167, CR_PRIOR_437331#119168, CR_PRI_DIC_437388#119169, CR_REFEXT_437423#119170, CR_SCNPAT_437417#119171, CR_SECEXT_437392#119172, CR_SECTRA_437362#119173, CR_SIMP_JOB_ID_437394#119174, CR_STADMP_437411#119175, CR_STAEXT_437371#119176, CR_STATCR_437341#119177, CR_STATDIC_437339#119178, CR_STATSM_437340#119179, CR_STATUT_EXT_437393#119180, CR_STA_ENV_ACK_437404#119181, CR_STA_ENV_FRA_437385#119182, CR_STA_ENV_PRT_437383#119183, CR_STA_RET_ACK_437405#119184, CR_STA_RET_FRA_437386#119185, CR_STA_RET_PRO_437384#119186, CR_SUBDIC_437380#119187, CR_SUBDIR_437381#119188, CR_SUBEXT_437401#119189, CR_TAIDCR_437333#119190, CR_TAILLE_DIC_437406#119191, CR_TYPCR_437363#119192, CR_TYPDIC_437403#119193, CR_TYPDOC_437330#119194, CR_VISDMP_437416#119195]
Batched: false
Location: InMemoryFileIndex [file:/data/output/cache/parquet/uet/H_CR_437324]
ReadSchema: struct<CR_ANNONCE_437424:string,CR_CHKSUM_DIC_437407:string,CR_CODACC_437377:string,CR_CODCLI_437387:string,CR_CODDCR_437354:string,CR_CODDIC_437342:string,CR_CODDMP_437412:string,CR_CODFRA_437391:string,CR_CODMAIL_437410:string,CR_CODMCR_437374:string,CR_CODSEC_437348:string,CR_CODSIT_437361:string,CR_CODSUP_437364:string,CR_CODUTI_437359:string,CR_CODVCR_437351:string,CR_CONTEXT_437343:string,CR_CR_437338:string,CR_DATCRE_437426:string,CR_DATDCR_437355:string,CR_DATDIC_437344:string,CR_DATDMP_437413:string,CR_DATMAIL_437408:string,CR_DATMAJ_437360:string,CR_DATMCR_437375:string,CR_DATSCN_437418:string,CR_DATSEC_437349:string,CR_DATSUP_437368:string,CR_DATVCR_437352:string,CR_DAT_CR_INT_437395:string,CR_DAT_DIC_TRA_437389:string,CR_DAT_EFF_D_437357:string,CR_DAT_EFF_W_437358:string,CR_DELAI_TOTAL_437397:string,CR_DURDCR_437334:string,CR_FLARCH_437370:string,CR_FLARCH_D_437422:string,CR_FLIMPR_437372:string,CR_FLORDO_437430:string,CR_FLTBDI_437402:string,CR_FLTR_437432:string,CR_FOR_CR_437337:string,CR_HEUCRE_437427:string,CR_HEUDCR_437356:string,CR_HEUDIC_437345:string,CR_HEUDMP_437414:string,CR_HEUI_D_437346:string,CR_HEUI_F_437347:string,CR_HEUMAIL_437409:string,CR_HEUMCR_437376:string,CR_HEUSEC_437350:string,CR_HEUSUP_437369:string,CR_HEUVCR_437353:string,CR_HEU_CR_INT_437396:string,CR_HEU_DIC_TRA_437390:string,CR_IDCDA_437431:string,CR_LIBCO_437379:string,CR_LOCKCR_437373:string,CR_MOTPAS_437378:string,CR_NB_CAR_EXT_437399:string,CR_NB_COR_437367:string,CR_NB_LIGNE_EXT_437398:string,CR_NIVVCR_437365:string,CR_NOMDCR_437332:string,CR_NOMDIC_437327:string,CR_NOMDOS_437336:string,CR_NOMEXT_437400:string,CR_NUMCR_437325:string,CR_NUMCR_CLOUD_437420:string,CR_NUMDEM_437328:string,CR_NUMDOS_437326:string,CR_NUMDRV_437421:string,CR_NUMEXA_437329:string,CR_NUMMCR_437419:string,CR_NUMPRT_437382:string,CR_NUMVCR_437366:string,CR_OIDDMP_437415:string,CR_OID_437429:string,CR_ORIGINE_437428:string,CR_PERIPH_437425:string,CR_POSDCR_437335:string,CR_PRIOR_437331:string,CR_PRI_DIC_437388:string,CR_REFEXT_437423:string,CR_SCNPAT_437417:string,CR_SECEXT_437392:string,CR_SECTRA_437362:string,CR_SIMP_JOB_ID_437394:string,CR_STADMP_437411:string,CR_STAEXT_437371:string,CR_STATCR_437341:string,CR_STATDIC_437339:string,CR_STATSM_437340:string,CR_STATUT_EXT_437393:string,CR_STA_ENV_ACK_437404:string,CR_STA_ENV_FRA_437385:string,CR_STA_ENV_PRT_437383:string,CR_STA_RET_ACK_437405:string,CR_STA_RET_FRA_437386:string,CR_STA_RET_PRO_437384:string,CR_SUBDIC_437380:string,CR_SUBDIR_437381:string,CR_SUBEXT_437401:string,CR_TAIDCR_437333:string,CR_TAILLE_DIC_437406:string,CR_TYPCR_437363:string,CR_TYPDIC_437403:string,CR_TYPDOC_437330:string,CR_VISDMP_437416:string>

(2) Filter
Input [108]: [CR_ANNONCE_437424#119088, CR_CHKSUM_DIC_437407#119089, CR_CODACC_437377#119090, CR_CODCLI_437387#119091, CR_CODDCR_437354#119092, CR_CODDIC_437342#119093, CR_CODDMP_437412#119094, CR_CODFRA_437391#119095, CR_CODMAIL_437410#119096, CR_CODMCR_437374#119097, CR_CODSEC_437348#119098, CR_CODSIT_437361#119099, CR_CODSUP_437364#119100, CR_CODUTI_437359#119101, CR_CODVCR_437351#119102, CR_CONTEXT_437343#119103, CR_CR_437338#119104, CR_DATCRE_437426#119105, CR_DATDCR_437355#119106, CR_DATDIC_437344#119107, CR_DATDMP_437413#119108, CR_DATMAIL_437408#119109, CR_DATMAJ_437360#119110, CR_DATMCR_437375#119111, CR_DATSCN_437418#119112, CR_DATSEC_437349#119113, CR_DATSUP_437368#119114, CR_DATVCR_437352#119115, CR_DAT_CR_INT_437395#119116, CR_DAT_DIC_TRA_437389#119117, CR_DAT_EFF_D_437357#119118, CR_DAT_EFF_W_437358#119119, CR_DELAI_TOTAL_437397#119120, CR_DURDCR_437334#119121, CR_FLARCH_437370#119122, CR_FLARCH_D_437422#119123, CR_FLIMPR_437372#119124, CR_FLORDO_437430#119125, CR_FLTBDI_437402#119126, CR_FLTR_437432#119127, CR_FOR_CR_437337#119128, CR_HEUCRE_437427#119129, CR_HEUDCR_437356#119130, CR_HEUDIC_437345#119131, CR_HEUDMP_437414#119132, CR_HEUI_D_437346#119133, CR_HEUI_F_437347#119134, CR_HEUMAIL_437409#119135, CR_HEUMCR_437376#119136, CR_HEUSEC_437350#119137, CR_HEUSUP_437369#119138, CR_HEUVCR_437353#119139, CR_HEU_CR_INT_437396#119140, CR_HEU_DIC_TRA_437390#119141, CR_IDCDA_437431#119142, CR_LIBCO_437379#119143, CR_LOCKCR_437373#119144, CR_MOTPAS_437378#119145, CR_NB_CAR_EXT_437399#119146, CR_NB_COR_437367#119147, CR_NB_LIGNE_EXT_437398#119148, CR_NIVVCR_437365#119149, CR_NOMDCR_437332#119150, CR_NOMDIC_437327#119151, CR_NOMDOS_437336#119152, CR_NOMEXT_437400#119153, CR_NUMCR_437325#119154, CR_NUMCR_CLOUD_437420#119155, CR_NUMDEM_437328#119156, CR_NUMDOS_437326#119157, CR_NUMDRV_437421#119158, CR_NUMEXA_437329#119159, CR_NUMMCR_437419#119160, CR_NUMPRT_437382#119161, CR_NUMVCR_437366#119162, CR_OIDDMP_437415#119163, CR_OID_437429#119164, CR_ORIGINE_437428#119165, CR_PERIPH_437425#119166, CR_POSDCR_437335#119167, CR_PRIOR_437331#119168, CR_PRI_DIC_437388#119169, CR_REFEXT_437423#119170, CR_SCNPAT_437417#119171, CR_SECEXT_437392#119172, CR_SECTRA_437362#119173, CR_SIMP_JOB_ID_437394#119174, CR_STADMP_437411#119175, CR_STAEXT_437371#119176, CR_STATCR_437341#119177, CR_STATDIC_437339#119178, CR_STATSM_437340#119179, CR_STATUT_EXT_437393#119180, CR_STA_ENV_ACK_437404#119181, CR_STA_ENV_FRA_437385#119182, CR_STA_ENV_PRT_437383#119183, CR_STA_RET_ACK_437405#119184, CR_STA_RET_FRA_437386#119185, CR_STA_RET_PRO_437384#119186, CR_SUBDIC_437380#119187, CR_SUBDIR_437381#119188, CR_SUBEXT_437401#119189, CR_TAIDCR_437333#119190, CR_TAILLE_DIC_437406#119191, CR_TYPCR_437363#119192, CR_TYPDIC_437403#119193, CR_TYPDOC_437330#119194, CR_VISDMP_437416#119195]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMCR_437325#119154)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMCR_437325#119154)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMDOS_437326#119157)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMDOS_437326#119157)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NOMDIC_437327#119151)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NOMDIC_437327#119151)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMDEM_437328#119156)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMDEM_437328#119156)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMEXA_437329#119159)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMEXA_437329#119159)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_TYPDOC_437330#119194)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_TYPDOC_437330#119194)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_PRIOR_437331#119168)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_PRIOR_437331#119168)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NOMDCR_437332#119150)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NOMDCR_437332#119150)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_TAIDCR_437333#119190)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_TAIDCR_437333#119190)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DURDCR_437334#119121)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DURDCR_437334#119121)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_POSDCR_437335#119167)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_POSDCR_437335#119167)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NOMDOS_437336#119152)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NOMDOS_437336#119152)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_FOR_CR_437337#119128)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_FOR_CR_437337#119128)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CR_437338#119104)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CR_437338#119104)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STATDIC_437339#119178)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STATDIC_437339#119178)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STATSM_437340#119179)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STATSM_437340#119179)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STATCR_437341#119177)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STATCR_437341#119177)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODDIC_437342#119093)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODDIC_437342#119093)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CONTEXT_437343#119103)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CONTEXT_437343#119103)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATDIC_437344#119107)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATDIC_437344#119107)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUDIC_437345#119131)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUDIC_437345#119131)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUI_D_437346#119133)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUI_D_437346#119133)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUI_F_437347#119134)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUI_F_437347#119134)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODSEC_437348#119098)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODSEC_437348#119098)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATSEC_437349#119113)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATSEC_437349#119113)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUSEC_437350#119137)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUSEC_437350#119137)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODVCR_437351#119102)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODVCR_437351#119102)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATVCR_437352#119115)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATVCR_437352#119115)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUVCR_437353#119139)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUVCR_437353#119139)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODDCR_437354#119092)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODDCR_437354#119092)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATDCR_437355#119106)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATDCR_437355#119106)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUDCR_437356#119130)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUDCR_437356#119130)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DAT_EFF_D_437357#119118)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DAT_EFF_D_437357#119118)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DAT_EFF_W_437358#119119)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DAT_EFF_W_437358#119119)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODUTI_437359#119101)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODUTI_437359#119101)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATMAJ_437360#119110)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATMAJ_437360#119110)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODSIT_437361#119099)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODSIT_437361#119099)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_SECTRA_437362#119173)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_SECTRA_437362#119173)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_TYPCR_437363#119192)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_TYPCR_437363#119192)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODSUP_437364#119100)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODSUP_437364#119100)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NIVVCR_437365#119149)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NIVVCR_437365#119149)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMVCR_437366#119162)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMVCR_437366#119162)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NB_COR_437367#119147)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NB_COR_437367#119147)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATSUP_437368#119114)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATSUP_437368#119114)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUSUP_437369#119138)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUSUP_437369#119138)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_FLARCH_437370#119122)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_FLARCH_437370#119122)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STAEXT_437371#119176)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STAEXT_437371#119176)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_FLIMPR_437372#119124)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_FLIMPR_437372#119124)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_LOCKCR_437373#119144)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_LOCKCR_437373#119144)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODMCR_437374#119097)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODMCR_437374#119097)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATMCR_437375#119111)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATMCR_437375#119111)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUMCR_437376#119136)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUMCR_437376#119136)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODACC_437377#119090)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODACC_437377#119090)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_MOTPAS_437378#119145)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_MOTPAS_437378#119145)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_LIBCO_437379#119143)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_LIBCO_437379#119143)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_SUBDIC_437380#119187)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_SUBDIC_437380#119187)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_SUBDIR_437381#119188)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_SUBDIR_437381#119188)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMPRT_437382#119161)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMPRT_437382#119161)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STA_ENV_PRT_437383#119183)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STA_ENV_PRT_437383#119183)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STA_RET_PRO_437384#119186)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STA_RET_PRO_437384#119186)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STA_ENV_FRA_437385#119182)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STA_ENV_FRA_437385#119182)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STA_RET_FRA_437386#119185)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STA_RET_FRA_437386#119185)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODCLI_437387#119091)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODCLI_437387#119091)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_PRI_DIC_437388#119169)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_PRI_DIC_437388#119169)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DAT_DIC_TRA_437389#119117)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DAT_DIC_TRA_437389#119117)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEU_DIC_TRA_437390#119141)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEU_DIC_TRA_437390#119141)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODFRA_437391#119095)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODFRA_437391#119095)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_SECEXT_437392#119172)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_SECEXT_437392#119172)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STATUT_EXT_437393#119180)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STATUT_EXT_437393#119180)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_SIMP_JOB_ID_437394#119174)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_SIMP_JOB_ID_437394#119174)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DAT_CR_INT_437395#119116)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DAT_CR_INT_437395#119116)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEU_CR_INT_437396#119140)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEU_CR_INT_437396#119140)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DELAI_TOTAL_437397#119120)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DELAI_TOTAL_437397#119120)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NB_LIGNE_EXT_437398#119148)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NB_LIGNE_EXT_437398#119148)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NB_CAR_EXT_437399#119146)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NB_CAR_EXT_437399#119146)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NOMEXT_437400#119153)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NOMEXT_437400#119153)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_SUBEXT_437401#119189)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_SUBEXT_437401#119189)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_FLTBDI_437402#119126)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_FLTBDI_437402#119126)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_TYPDIC_437403#119193)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_TYPDIC_437403#119193)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STA_ENV_ACK_437404#119181)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STA_ENV_ACK_437404#119181)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STA_RET_ACK_437405#119184)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STA_RET_ACK_437405#119184)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_TAILLE_DIC_437406#119191)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_TAILLE_DIC_437406#119191)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CHKSUM_DIC_437407#119089)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CHKSUM_DIC_437407#119089)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATMAIL_437408#119109)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATMAIL_437408#119109)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUMAIL_437409#119135)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUMAIL_437409#119135)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODMAIL_437410#119096)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODMAIL_437410#119096)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STADMP_437411#119175)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STADMP_437411#119175)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODDMP_437412#119094)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODDMP_437412#119094)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATDMP_437413#119108)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATDMP_437413#119108)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUDMP_437414#119132)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUDMP_437414#119132)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_OIDDMP_437415#119163)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_OIDDMP_437415#119163)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_VISDMP_437416#119195)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_VISDMP_437416#119195)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_SCNPAT_437417#119171)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_SCNPAT_437417#119171)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATSCN_437418#119112)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATSCN_437418#119112)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMMCR_437419#119160)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMMCR_437419#119160)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMCR_CLOUD_437420#119155)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMCR_CLOUD_437420#119155)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMDRV_437421#119158)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMDRV_437421#119158)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_FLARCH_D_437422#119123)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_FLARCH_D_437422#119123)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_REFEXT_437423#119170)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_REFEXT_437423#119170)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_ANNONCE_437424#119088)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_ANNONCE_437424#119088)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_PERIPH_437425#119166)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_PERIPH_437425#119166)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATCRE_437426#119105)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATCRE_437426#119105)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUCRE_437427#119129)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUCRE_437427#119129)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_ORIGINE_437428#119165)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_ORIGINE_437428#119165)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_OID_437429#119164)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_OID_437429#119164)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_FLORDO_437430#119125)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_FLORDO_437430#119125)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_IDCDA_437431#119142)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_IDCDA_437431#119142)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_FLTR_437432#119127)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_FLTR_437432#119127)), MARX) END)

(3) Project
Output: []
Input [108]: [CR_ANNONCE_437424#119088, CR_CHKSUM_DIC_437407#119089, CR_CODACC_437377#119090, CR_CODCLI_437387#119091, CR_CODDCR_437354#119092, CR_CODDIC_437342#119093, CR_CODDMP_437412#119094, CR_CODFRA_437391#119095, CR_CODMAIL_437410#119096, CR_CODMCR_437374#119097, CR_CODSEC_437348#119098, CR_CODSIT_437361#119099, CR_CODSUP_437364#119100, CR_CODUTI_437359#119101, CR_CODVCR_437351#119102, CR_CONTEXT_437343#119103, CR_CR_437338#119104, CR_DATCRE_437426#119105, CR_DATDCR_437355#119106, CR_DATDIC_437344#119107, CR_DATDMP_437413#119108, CR_DATMAIL_437408#119109, CR_DATMAJ_437360#119110, CR_DATMCR_437375#119111, CR_DATSCN_437418#119112, CR_DATSEC_437349#119113, CR_DATSUP_437368#119114, CR_DATVCR_437352#119115, CR_DAT_CR_INT_437395#119116, CR_DAT_DIC_TRA_437389#119117, CR_DAT_EFF_D_437357#119118, CR_DAT_EFF_W_437358#119119, CR_DELAI_TOTAL_437397#119120, CR_DURDCR_437334#119121, CR_FLARCH_437370#119122, CR_FLARCH_D_437422#119123, CR_FLIMPR_437372#119124, CR_FLORDO_437430#119125, CR_FLTBDI_437402#119126, CR_FLTR_437432#119127, CR_FOR_CR_437337#119128, CR_HEUCRE_437427#119129, CR_HEUDCR_437356#119130, CR_HEUDIC_437345#119131, CR_HEUDMP_437414#119132, CR_HEUI_D_437346#119133, CR_HEUI_F_437347#119134, CR_HEUMAIL_437409#119135, CR_HEUMCR_437376#119136, CR_HEUSEC_437350#119137, CR_HEUSUP_437369#119138, CR_HEUVCR_437353#119139, CR_HEU_CR_INT_437396#119140, CR_HEU_DIC_TRA_437390#119141, CR_IDCDA_437431#119142, CR_LIBCO_437379#119143, CR_LOCKCR_437373#119144, CR_MOTPAS_437378#119145, CR_NB_CAR_EXT_437399#119146, CR_NB_COR_437367#119147, CR_NB_LIGNE_EXT_437398#119148, CR_NIVVCR_437365#119149, CR_NOMDCR_437332#119150, CR_NOMDIC_437327#119151, CR_NOMDOS_437336#119152, CR_NOMEXT_437400#119153, CR_NUMCR_437325#119154, CR_NUMCR_CLOUD_437420#119155, CR_NUMDEM_437328#119156, CR_NUMDOS_437326#119157, CR_NUMDRV_437421#119158, CR_NUMEXA_437329#119159, CR_NUMMCR_437419#119160, CR_NUMPRT_437382#119161, CR_NUMVCR_437366#119162, CR_OIDDMP_437415#119163, CR_OID_437429#119164, CR_ORIGINE_437428#119165, CR_PERIPH_437425#119166, CR_POSDCR_437335#119167, CR_PRIOR_437331#119168, CR_PRI_DIC_437388#119169, CR_REFEXT_437423#119170, CR_SCNPAT_437417#119171, CR_SECEXT_437392#119172, CR_SECTRA_437362#119173, CR_SIMP_JOB_ID_437394#119174, CR_STADMP_437411#119175, CR_STAEXT_437371#119176, CR_STATCR_437341#119177, CR_STATDIC_437339#119178, CR_STATSM_437340#119179, CR_STATUT_EXT_437393#119180, CR_STA_ENV_ACK_437404#119181, CR_STA_ENV_FRA_437385#119182, CR_STA_ENV_PRT_437383#119183, CR_STA_RET_ACK_437405#119184, CR_STA_RET_FRA_437386#119185, CR_STA_RET_PRO_437384#119186, CR_SUBDIC_437380#119187, CR_SUBDIR_437381#119188, CR_SUBEXT_437401#119189, CR_TAIDCR_437333#119190, CR_TAILLE_DIC_437406#119191, CR_TYPCR_437363#119192, CR_TYPDIC_437403#119193, CR_TYPDOC_437330#119194, CR_VISDMP_437416#119195]

(4) HashAggregate [codegen id : 1]
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#121662L]
Results [1]: [count#121663L]

(5) Exchange
Input [1]: [count#121663L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=11541]

(6) ShuffleQueryStage
Output [1]: [count#121663L]
Arguments: 0

(7) HashAggregate [codegen id : 2]
Input [1]: [count#121663L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#120758L]
Results [1]: [count(1)#120758L AS COL_08cd3bfc-8750-4b79-855d-33e6be8dd3d5#120760L]

(8) HashAggregate
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#121662L]
Results [1]: [count#121663L]

(9) Exchange
Input [1]: [count#121663L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=11512]

(10) HashAggregate
Input [1]: [count#121663L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#120758L]
Results [1]: [count(1)#120758L AS COL_08cd3bfc-8750-4b79-855d-33e6be8dd3d5#120760L]

(11) AdaptiveSparkPlan
Output [1]: [COL_08cd3bfc-8750-4b79-855d-33e6be8dd3d5#120760L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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