hdh-spark-job - Details for Query 619

Submitted Time: 2026/10/21 21:33:38
Duration: 3 s
Succeeded Jobs: 558 560

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 744.0: task 741)) 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 744.0: task 742)) 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 744.0: task 741))"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n2.3 s (7 ms, 2.3 s, 2.3 s (stage 744.0: task 741))"; 5 [labelType="html" label="HashAggregate time in aggregation build total (min, med, max (stageId: taskId)) 2.3 s (6 ms, 2.3 s, 2.3 s (stage 744.0: task 741)) 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=12260]

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

WholeStageCodegen (1)

Project

Filter (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMCR_437325#129029)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMCR_437325#129029)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMDOS_437326#129032)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMDOS_437326#129032)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NOMDIC_437327#129026)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NOMDIC_437327#129026)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMDEM_437328#129031)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMDEM_437328#129031)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMEXA_437329#129034)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMEXA_437329#129034)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_TYPDOC_437330#129069)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_TYPDOC_437330#129069)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_PRIOR_437331#129043)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_PRIOR_437331#129043)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NOMDCR_437332#129025)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NOMDCR_437332#129025)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_TAIDCR_437333#129065)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_TAIDCR_437333#129065)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DURDCR_437334#128996)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DURDCR_437334#128996)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_POSDCR_437335#129042)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_POSDCR_437335#129042)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NOMDOS_437336#129027)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NOMDOS_437336#129027)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_FOR_CR_437337#129003)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_FOR_CR_437337#129003)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CR_437338#128979)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CR_437338#128979)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STATDIC_437339#129053)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STATDIC_437339#129053)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STATSM_437340#129054)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STATSM_437340#129054)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STATCR_437341#129052)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STATCR_437341#129052)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODDIC_437342#128968)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODDIC_437342#128968)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CONTEXT_437343#128978)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CONTEXT_437343#128978)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATDIC_437344#128982)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATDIC_437344#128982)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUDIC_437345#129006)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUDIC_437345#129006)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUI_D_437346#129008)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUI_D_437346#129008)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUI_F_437347#129009)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUI_F_437347#129009)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODSEC_437348#128973)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODSEC_437348#128973)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATSEC_437349#128988)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATSEC_437349#128988)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUSEC_437350#129012)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUSEC_437350#129012)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODVCR_437351#128977)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODVCR_437351#128977)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATVCR_437352#128990)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATVCR_437352#128990)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUVCR_437353#129014)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUVCR_437353#129014)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODDCR_437354#128967)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODDCR_437354#128967)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATDCR_437355#128981)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATDCR_437355#128981)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUDCR_437356#129005)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUDCR_437356#129005)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DAT_EFF_D_437357#128993)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DAT_EFF_D_437357#128993)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DAT_EFF_W_437358#128994)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DAT_EFF_W_437358#128994)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODUTI_437359#128976)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODUTI_437359#128976)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATMAJ_437360#128985)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATMAJ_437360#128985)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODSIT_437361#128974)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODSIT_437361#128974)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_SECTRA_437362#129048)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_SECTRA_437362#129048)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_TYPCR_437363#129067)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_TYPCR_437363#129067)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODSUP_437364#128975)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODSUP_437364#128975)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NIVVCR_437365#129024)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NIVVCR_437365#129024)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMVCR_437366#129037)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMVCR_437366#129037)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NB_COR_437367#129022)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NB_COR_437367#129022)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATSUP_437368#128989)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATSUP_437368#128989)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUSUP_437369#129013)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUSUP_437369#129013)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_FLARCH_437370#128997)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_FLARCH_437370#128997)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STAEXT_437371#129051)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STAEXT_437371#129051)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_FLIMPR_437372#128999)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_FLIMPR_437372#128999)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_LOCKCR_437373#129019)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_LOCKCR_437373#129019)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODMCR_437374#128972)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODMCR_437374#128972)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATMCR_437375#128986)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATMCR_437375#128986)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUMCR_437376#129011)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUMCR_437376#129011)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODACC_437377#128965)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODACC_437377#128965)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_MOTPAS_437378#129020)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_MOTPAS_437378#129020)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_LIBCO_437379#129018)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_LIBCO_437379#129018)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_SUBDIC_437380#129062)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_SUBDIC_437380#129062)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_SUBDIR_437381#129063)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_SUBDIR_437381#129063)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMPRT_437382#129036)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMPRT_437382#129036)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STA_ENV_PRT_437383#129058)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STA_ENV_PRT_437383#129058)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STA_RET_PRO_437384#129061)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STA_RET_PRO_437384#129061)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STA_ENV_FRA_437385#129057)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STA_ENV_FRA_437385#129057)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STA_RET_FRA_437386#129060)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STA_RET_FRA_437386#129060)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODCLI_437387#128966)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODCLI_437387#128966)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_PRI_DIC_437388#129044)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_PRI_DIC_437388#129044)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DAT_DIC_TRA_437389#128992)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DAT_DIC_TRA_437389#128992)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEU_DIC_TRA_437390#129016)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEU_DIC_TRA_437390#129016)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODFRA_437391#128970)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODFRA_437391#128970)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_SECEXT_437392#129047)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_SECEXT_437392#129047)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STATUT_EXT_437393#129055)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STATUT_EXT_437393#129055)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_SIMP_JOB_ID_437394#129049)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_SIMP_JOB_ID_437394#129049)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DAT_CR_INT_437395#128991)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DAT_CR_INT_437395#128991)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEU_CR_INT_437396#129015)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEU_CR_INT_437396#129015)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DELAI_TOTAL_437397#128995)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DELAI_TOTAL_437397#128995)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NB_LIGNE_EXT_437398#129023)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NB_LIGNE_EXT_437398#129023)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NB_CAR_EXT_437399#129021)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NB_CAR_EXT_437399#129021)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NOMEXT_437400#129028)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NOMEXT_437400#129028)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_SUBEXT_437401#129064)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_SUBEXT_437401#129064)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_FLTBDI_437402#129001)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_FLTBDI_437402#129001)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_TYPDIC_437403#129068)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_TYPDIC_437403#129068)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STA_ENV_ACK_437404#129056)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STA_ENV_ACK_437404#129056)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STA_RET_ACK_437405#129059)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STA_RET_ACK_437405#129059)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_TAILLE_DIC_437406#129066)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_TAILLE_DIC_437406#129066)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CHKSUM_DIC_437407#128964)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CHKSUM_DIC_437407#128964)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATMAIL_437408#128984)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATMAIL_437408#128984)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUMAIL_437409#129010)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUMAIL_437409#129010)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODMAIL_437410#128971)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODMAIL_437410#128971)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STADMP_437411#129050)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STADMP_437411#129050)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODDMP_437412#128969)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODDMP_437412#128969)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATDMP_437413#128983)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATDMP_437413#128983)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUDMP_437414#129007)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUDMP_437414#129007)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_OIDDMP_437415#129038)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_OIDDMP_437415#129038)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_VISDMP_437416#129070)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_VISDMP_437416#129070)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_SCNPAT_437417#129046)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_SCNPAT_437417#129046)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATSCN_437418#128987)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATSCN_437418#128987)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMMCR_437419#129035)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMMCR_437419#129035)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMCR_CLOUD_437420#129030)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMCR_CLOUD_437420#129030)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMDRV_437421#129033)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMDRV_437421#129033)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_FLARCH_D_437422#128998)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_FLARCH_D_437422#128998)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_REFEXT_437423#129045)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_REFEXT_437423#129045)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_ANNONCE_437424#128963)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_ANNONCE_437424#128963)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_PERIPH_437425#129041)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_PERIPH_437425#129041)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATCRE_437426#128980)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATCRE_437426#128980)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUCRE_437427#129004)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUCRE_437427#129004)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_ORIGINE_437428#129040)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_ORIGINE_437428#129040)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_OID_437429#129039)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_OID_437429#129039)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_FLORDO_437430#129000)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_FLORDO_437430#129000)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_IDCDA_437431#129017)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_IDCDA_437431#129017)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_FLTR_437432#129002)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_FLTR_437432#129002)), MARX) END)

FileScan parquet [CR_ANNONCE_437424#128963,CR_CHKSUM_DIC_437407#128964,CR_CODACC_437377#128965,CR_CODCLI_437387#128966,CR_CODDCR_437354#128967,CR_CODDIC_437342#128968,CR_CODDMP_437412#128969,CR_CODFRA_437391#128970,CR_CODMAIL_437410#128971,CR_CODMCR_437374#128972,CR_CODSEC_437348#128973,CR_CODSIT_437361#128974,CR_CODSUP_437364#128975,CR_CODUTI_437359#128976,CR_CODVCR_437351#128977,CR_CONTEXT_437343#128978,CR_CR_437338#128979,CR_DATCRE_437426#128980,CR_DATDCR_437355#128981,CR_DATDIC_437344#128982,CR_DATDMP_437413#128983,CR_DATMAIL_437408#128984,CR_DATMAJ_437360#128985,CR_DATMCR_437375#128986,... 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#128963, CR_CHKSUM_DIC_437407#128964, CR_CODACC_437377#128965, CR_CODCLI_437387#128966, CR_CODDCR_437354#128967, CR_CODDIC_437342#128968, CR_CODDMP_437412#128969, CR_CODFRA_437391#128970, CR_CODMAIL_437410#128971, CR_CODMCR_437374#128972, CR_CODSEC_437348#128973, CR_CODSIT_437361#128974, CR_CODSUP_437364#128975, CR_CODUTI_437359#128976, CR_CODVCR_437351#128977, CR_CONTEXT_437343#128978, CR_CR_437338#128979, CR_DATCRE_437426#128980, CR_DATDCR_437355#128981, CR_DATDIC_437344#128982, CR_DATDMP_437413#128983, CR_DATMAIL_437408#128984, CR_DATMAJ_437360#128985, CR_DATMCR_437375#128986, CR_DATSCN_437418#128987, CR_DATSEC_437349#128988, CR_DATSUP_437368#128989, CR_DATVCR_437352#128990, CR_DAT_CR_INT_437395#128991, CR_DAT_DIC_TRA_437389#128992, CR_DAT_EFF_D_437357#128993, CR_DAT_EFF_W_437358#128994, CR_DELAI_TOTAL_437397#128995, CR_DURDCR_437334#128996, CR_FLARCH_437370#128997, CR_FLARCH_D_437422#128998, CR_FLIMPR_437372#128999, CR_FLORDO_437430#129000, CR_FLTBDI_437402#129001, CR_FLTR_437432#129002, CR_FOR_CR_437337#129003, CR_HEUCRE_437427#129004, CR_HEUDCR_437356#129005, CR_HEUDIC_437345#129006, CR_HEUDMP_437414#129007, CR_HEUI_D_437346#129008, CR_HEUI_F_437347#129009, CR_HEUMAIL_437409#129010, CR_HEUMCR_437376#129011, CR_HEUSEC_437350#129012, CR_HEUSUP_437369#129013, CR_HEUVCR_437353#129014, CR_HEU_CR_INT_437396#129015, CR_HEU_DIC_TRA_437390#129016, CR_IDCDA_437431#129017, CR_LIBCO_437379#129018, CR_LOCKCR_437373#129019, CR_MOTPAS_437378#129020, CR_NB_CAR_EXT_437399#129021, CR_NB_COR_437367#129022, CR_NB_LIGNE_EXT_437398#129023, CR_NIVVCR_437365#129024, CR_NOMDCR_437332#129025, CR_NOMDIC_437327#129026, CR_NOMDOS_437336#129027, CR_NOMEXT_437400#129028, CR_NUMCR_437325#129029, CR_NUMCR_CLOUD_437420#129030, CR_NUMDEM_437328#129031, CR_NUMDOS_437326#129032, CR_NUMDRV_437421#129033, CR_NUMEXA_437329#129034, CR_NUMMCR_437419#129035, CR_NUMPRT_437382#129036, CR_NUMVCR_437366#129037, CR_OIDDMP_437415#129038, CR_OID_437429#129039, CR_ORIGINE_437428#129040, CR_PERIPH_437425#129041, CR_POSDCR_437335#129042, CR_PRIOR_437331#129043, CR_PRI_DIC_437388#129044, CR_REFEXT_437423#129045, CR_SCNPAT_437417#129046, CR_SECEXT_437392#129047, CR_SECTRA_437362#129048, CR_SIMP_JOB_ID_437394#129049, CR_STADMP_437411#129050, CR_STAEXT_437371#129051, CR_STATCR_437341#129052, CR_STATDIC_437339#129053, CR_STATSM_437340#129054, CR_STATUT_EXT_437393#129055, CR_STA_ENV_ACK_437404#129056, CR_STA_ENV_FRA_437385#129057, CR_STA_ENV_PRT_437383#129058, CR_STA_RET_ACK_437405#129059, CR_STA_RET_FRA_437386#129060, CR_STA_RET_PRO_437384#129061, CR_SUBDIC_437380#129062, CR_SUBDIR_437381#129063, CR_SUBEXT_437401#129064, CR_TAIDCR_437333#129065, CR_TAILLE_DIC_437406#129066, CR_TYPCR_437363#129067, CR_TYPDIC_437403#129068, CR_TYPDOC_437330#129069, CR_VISDMP_437416#129070]
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#128963, CR_CHKSUM_DIC_437407#128964, CR_CODACC_437377#128965, CR_CODCLI_437387#128966, CR_CODDCR_437354#128967, CR_CODDIC_437342#128968, CR_CODDMP_437412#128969, CR_CODFRA_437391#128970, CR_CODMAIL_437410#128971, CR_CODMCR_437374#128972, CR_CODSEC_437348#128973, CR_CODSIT_437361#128974, CR_CODSUP_437364#128975, CR_CODUTI_437359#128976, CR_CODVCR_437351#128977, CR_CONTEXT_437343#128978, CR_CR_437338#128979, CR_DATCRE_437426#128980, CR_DATDCR_437355#128981, CR_DATDIC_437344#128982, CR_DATDMP_437413#128983, CR_DATMAIL_437408#128984, CR_DATMAJ_437360#128985, CR_DATMCR_437375#128986, CR_DATSCN_437418#128987, CR_DATSEC_437349#128988, CR_DATSUP_437368#128989, CR_DATVCR_437352#128990, CR_DAT_CR_INT_437395#128991, CR_DAT_DIC_TRA_437389#128992, CR_DAT_EFF_D_437357#128993, CR_DAT_EFF_W_437358#128994, CR_DELAI_TOTAL_437397#128995, CR_DURDCR_437334#128996, CR_FLARCH_437370#128997, CR_FLARCH_D_437422#128998, CR_FLIMPR_437372#128999, CR_FLORDO_437430#129000, CR_FLTBDI_437402#129001, CR_FLTR_437432#129002, CR_FOR_CR_437337#129003, CR_HEUCRE_437427#129004, CR_HEUDCR_437356#129005, CR_HEUDIC_437345#129006, CR_HEUDMP_437414#129007, CR_HEUI_D_437346#129008, CR_HEUI_F_437347#129009, CR_HEUMAIL_437409#129010, CR_HEUMCR_437376#129011, CR_HEUSEC_437350#129012, CR_HEUSUP_437369#129013, CR_HEUVCR_437353#129014, CR_HEU_CR_INT_437396#129015, CR_HEU_DIC_TRA_437390#129016, CR_IDCDA_437431#129017, CR_LIBCO_437379#129018, CR_LOCKCR_437373#129019, CR_MOTPAS_437378#129020, CR_NB_CAR_EXT_437399#129021, CR_NB_COR_437367#129022, CR_NB_LIGNE_EXT_437398#129023, CR_NIVVCR_437365#129024, CR_NOMDCR_437332#129025, CR_NOMDIC_437327#129026, CR_NOMDOS_437336#129027, CR_NOMEXT_437400#129028, CR_NUMCR_437325#129029, CR_NUMCR_CLOUD_437420#129030, CR_NUMDEM_437328#129031, CR_NUMDOS_437326#129032, CR_NUMDRV_437421#129033, CR_NUMEXA_437329#129034, CR_NUMMCR_437419#129035, CR_NUMPRT_437382#129036, CR_NUMVCR_437366#129037, CR_OIDDMP_437415#129038, CR_OID_437429#129039, CR_ORIGINE_437428#129040, CR_PERIPH_437425#129041, CR_POSDCR_437335#129042, CR_PRIOR_437331#129043, CR_PRI_DIC_437388#129044, CR_REFEXT_437423#129045, CR_SCNPAT_437417#129046, CR_SECEXT_437392#129047, CR_SECTRA_437362#129048, CR_SIMP_JOB_ID_437394#129049, CR_STADMP_437411#129050, CR_STAEXT_437371#129051, CR_STATCR_437341#129052, CR_STATDIC_437339#129053, CR_STATSM_437340#129054, CR_STATUT_EXT_437393#129055, CR_STA_ENV_ACK_437404#129056, CR_STA_ENV_FRA_437385#129057, CR_STA_ENV_PRT_437383#129058, CR_STA_RET_ACK_437405#129059, CR_STA_RET_FRA_437386#129060, CR_STA_RET_PRO_437384#129061, CR_SUBDIC_437380#129062, CR_SUBDIR_437381#129063, CR_SUBEXT_437401#129064, CR_TAIDCR_437333#129065, CR_TAILLE_DIC_437406#129066, CR_TYPCR_437363#129067, CR_TYPDIC_437403#129068, CR_TYPDOC_437330#129069, CR_VISDMP_437416#129070]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMCR_437325#129029)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMCR_437325#129029)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMDOS_437326#129032)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMDOS_437326#129032)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NOMDIC_437327#129026)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NOMDIC_437327#129026)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMDEM_437328#129031)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMDEM_437328#129031)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMEXA_437329#129034)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMEXA_437329#129034)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_TYPDOC_437330#129069)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_TYPDOC_437330#129069)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_PRIOR_437331#129043)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_PRIOR_437331#129043)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NOMDCR_437332#129025)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NOMDCR_437332#129025)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_TAIDCR_437333#129065)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_TAIDCR_437333#129065)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DURDCR_437334#128996)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DURDCR_437334#128996)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_POSDCR_437335#129042)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_POSDCR_437335#129042)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NOMDOS_437336#129027)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NOMDOS_437336#129027)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_FOR_CR_437337#129003)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_FOR_CR_437337#129003)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CR_437338#128979)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CR_437338#128979)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STATDIC_437339#129053)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STATDIC_437339#129053)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STATSM_437340#129054)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STATSM_437340#129054)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STATCR_437341#129052)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STATCR_437341#129052)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODDIC_437342#128968)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODDIC_437342#128968)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CONTEXT_437343#128978)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CONTEXT_437343#128978)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATDIC_437344#128982)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATDIC_437344#128982)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUDIC_437345#129006)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUDIC_437345#129006)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUI_D_437346#129008)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUI_D_437346#129008)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUI_F_437347#129009)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUI_F_437347#129009)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODSEC_437348#128973)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODSEC_437348#128973)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATSEC_437349#128988)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATSEC_437349#128988)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUSEC_437350#129012)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUSEC_437350#129012)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODVCR_437351#128977)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODVCR_437351#128977)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATVCR_437352#128990)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATVCR_437352#128990)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUVCR_437353#129014)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUVCR_437353#129014)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODDCR_437354#128967)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODDCR_437354#128967)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATDCR_437355#128981)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATDCR_437355#128981)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUDCR_437356#129005)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUDCR_437356#129005)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DAT_EFF_D_437357#128993)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DAT_EFF_D_437357#128993)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DAT_EFF_W_437358#128994)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DAT_EFF_W_437358#128994)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODUTI_437359#128976)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODUTI_437359#128976)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATMAJ_437360#128985)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATMAJ_437360#128985)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODSIT_437361#128974)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODSIT_437361#128974)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_SECTRA_437362#129048)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_SECTRA_437362#129048)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_TYPCR_437363#129067)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_TYPCR_437363#129067)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODSUP_437364#128975)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODSUP_437364#128975)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NIVVCR_437365#129024)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NIVVCR_437365#129024)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMVCR_437366#129037)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMVCR_437366#129037)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NB_COR_437367#129022)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NB_COR_437367#129022)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATSUP_437368#128989)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATSUP_437368#128989)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUSUP_437369#129013)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUSUP_437369#129013)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_FLARCH_437370#128997)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_FLARCH_437370#128997)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STAEXT_437371#129051)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STAEXT_437371#129051)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_FLIMPR_437372#128999)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_FLIMPR_437372#128999)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_LOCKCR_437373#129019)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_LOCKCR_437373#129019)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODMCR_437374#128972)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODMCR_437374#128972)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATMCR_437375#128986)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATMCR_437375#128986)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUMCR_437376#129011)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUMCR_437376#129011)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODACC_437377#128965)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODACC_437377#128965)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_MOTPAS_437378#129020)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_MOTPAS_437378#129020)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_LIBCO_437379#129018)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_LIBCO_437379#129018)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_SUBDIC_437380#129062)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_SUBDIC_437380#129062)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_SUBDIR_437381#129063)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_SUBDIR_437381#129063)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMPRT_437382#129036)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMPRT_437382#129036)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STA_ENV_PRT_437383#129058)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STA_ENV_PRT_437383#129058)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STA_RET_PRO_437384#129061)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STA_RET_PRO_437384#129061)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STA_ENV_FRA_437385#129057)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STA_ENV_FRA_437385#129057)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STA_RET_FRA_437386#129060)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STA_RET_FRA_437386#129060)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODCLI_437387#128966)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODCLI_437387#128966)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_PRI_DIC_437388#129044)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_PRI_DIC_437388#129044)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DAT_DIC_TRA_437389#128992)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DAT_DIC_TRA_437389#128992)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEU_DIC_TRA_437390#129016)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEU_DIC_TRA_437390#129016)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODFRA_437391#128970)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODFRA_437391#128970)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_SECEXT_437392#129047)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_SECEXT_437392#129047)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STATUT_EXT_437393#129055)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STATUT_EXT_437393#129055)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_SIMP_JOB_ID_437394#129049)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_SIMP_JOB_ID_437394#129049)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DAT_CR_INT_437395#128991)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DAT_CR_INT_437395#128991)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEU_CR_INT_437396#129015)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEU_CR_INT_437396#129015)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DELAI_TOTAL_437397#128995)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DELAI_TOTAL_437397#128995)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NB_LIGNE_EXT_437398#129023)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NB_LIGNE_EXT_437398#129023)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NB_CAR_EXT_437399#129021)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NB_CAR_EXT_437399#129021)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NOMEXT_437400#129028)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NOMEXT_437400#129028)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_SUBEXT_437401#129064)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_SUBEXT_437401#129064)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_FLTBDI_437402#129001)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_FLTBDI_437402#129001)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_TYPDIC_437403#129068)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_TYPDIC_437403#129068)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STA_ENV_ACK_437404#129056)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STA_ENV_ACK_437404#129056)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STA_RET_ACK_437405#129059)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STA_RET_ACK_437405#129059)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_TAILLE_DIC_437406#129066)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_TAILLE_DIC_437406#129066)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CHKSUM_DIC_437407#128964)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CHKSUM_DIC_437407#128964)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATMAIL_437408#128984)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATMAIL_437408#128984)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUMAIL_437409#129010)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUMAIL_437409#129010)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODMAIL_437410#128971)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODMAIL_437410#128971)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_STADMP_437411#129050)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_STADMP_437411#129050)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_CODDMP_437412#128969)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_CODDMP_437412#128969)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATDMP_437413#128983)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATDMP_437413#128983)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUDMP_437414#129007)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUDMP_437414#129007)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_OIDDMP_437415#129038)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_OIDDMP_437415#129038)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_VISDMP_437416#129070)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_VISDMP_437416#129070)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_SCNPAT_437417#129046)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_SCNPAT_437417#129046)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATSCN_437418#128987)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATSCN_437418#128987)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMMCR_437419#129035)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMMCR_437419#129035)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMCR_CLOUD_437420#129030)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMCR_CLOUD_437420#129030)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_NUMDRV_437421#129033)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_NUMDRV_437421#129033)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_FLARCH_D_437422#128998)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_FLARCH_D_437422#128998)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_REFEXT_437423#129045)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_REFEXT_437423#129045)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_ANNONCE_437424#128963)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_ANNONCE_437424#128963)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_PERIPH_437425#129041)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_PERIPH_437425#129041)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_DATCRE_437426#128980)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_DATCRE_437426#128980)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_HEUCRE_437427#129004)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_HEUCRE_437427#129004)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_ORIGINE_437428#129040)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_ORIGINE_437428#129040)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_OID_437429#129039)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_OID_437429#129039)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_FLORDO_437430#129000)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_FLORDO_437430#129000)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_IDCDA_437431#129017)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_IDCDA_437431#129017)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(CR_FLTR_437432#129002)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(CR_FLTR_437432#129002)), MARX) END)

(3) Project
Output: []
Input [108]: [CR_ANNONCE_437424#128963, CR_CHKSUM_DIC_437407#128964, CR_CODACC_437377#128965, CR_CODCLI_437387#128966, CR_CODDCR_437354#128967, CR_CODDIC_437342#128968, CR_CODDMP_437412#128969, CR_CODFRA_437391#128970, CR_CODMAIL_437410#128971, CR_CODMCR_437374#128972, CR_CODSEC_437348#128973, CR_CODSIT_437361#128974, CR_CODSUP_437364#128975, CR_CODUTI_437359#128976, CR_CODVCR_437351#128977, CR_CONTEXT_437343#128978, CR_CR_437338#128979, CR_DATCRE_437426#128980, CR_DATDCR_437355#128981, CR_DATDIC_437344#128982, CR_DATDMP_437413#128983, CR_DATMAIL_437408#128984, CR_DATMAJ_437360#128985, CR_DATMCR_437375#128986, CR_DATSCN_437418#128987, CR_DATSEC_437349#128988, CR_DATSUP_437368#128989, CR_DATVCR_437352#128990, CR_DAT_CR_INT_437395#128991, CR_DAT_DIC_TRA_437389#128992, CR_DAT_EFF_D_437357#128993, CR_DAT_EFF_W_437358#128994, CR_DELAI_TOTAL_437397#128995, CR_DURDCR_437334#128996, CR_FLARCH_437370#128997, CR_FLARCH_D_437422#128998, CR_FLIMPR_437372#128999, CR_FLORDO_437430#129000, CR_FLTBDI_437402#129001, CR_FLTR_437432#129002, CR_FOR_CR_437337#129003, CR_HEUCRE_437427#129004, CR_HEUDCR_437356#129005, CR_HEUDIC_437345#129006, CR_HEUDMP_437414#129007, CR_HEUI_D_437346#129008, CR_HEUI_F_437347#129009, CR_HEUMAIL_437409#129010, CR_HEUMCR_437376#129011, CR_HEUSEC_437350#129012, CR_HEUSUP_437369#129013, CR_HEUVCR_437353#129014, CR_HEU_CR_INT_437396#129015, CR_HEU_DIC_TRA_437390#129016, CR_IDCDA_437431#129017, CR_LIBCO_437379#129018, CR_LOCKCR_437373#129019, CR_MOTPAS_437378#129020, CR_NB_CAR_EXT_437399#129021, CR_NB_COR_437367#129022, CR_NB_LIGNE_EXT_437398#129023, CR_NIVVCR_437365#129024, CR_NOMDCR_437332#129025, CR_NOMDIC_437327#129026, CR_NOMDOS_437336#129027, CR_NOMEXT_437400#129028, CR_NUMCR_437325#129029, CR_NUMCR_CLOUD_437420#129030, CR_NUMDEM_437328#129031, CR_NUMDOS_437326#129032, CR_NUMDRV_437421#129033, CR_NUMEXA_437329#129034, CR_NUMMCR_437419#129035, CR_NUMPRT_437382#129036, CR_NUMVCR_437366#129037, CR_OIDDMP_437415#129038, CR_OID_437429#129039, CR_ORIGINE_437428#129040, CR_PERIPH_437425#129041, CR_POSDCR_437335#129042, CR_PRIOR_437331#129043, CR_PRI_DIC_437388#129044, CR_REFEXT_437423#129045, CR_SCNPAT_437417#129046, CR_SECEXT_437392#129047, CR_SECTRA_437362#129048, CR_SIMP_JOB_ID_437394#129049, CR_STADMP_437411#129050, CR_STAEXT_437371#129051, CR_STATCR_437341#129052, CR_STATDIC_437339#129053, CR_STATSM_437340#129054, CR_STATUT_EXT_437393#129055, CR_STA_ENV_ACK_437404#129056, CR_STA_ENV_FRA_437385#129057, CR_STA_ENV_PRT_437383#129058, CR_STA_RET_ACK_437405#129059, CR_STA_RET_FRA_437386#129060, CR_STA_RET_PRO_437384#129061, CR_SUBDIC_437380#129062, CR_SUBDIR_437381#129063, CR_SUBEXT_437401#129064, CR_TAIDCR_437333#129065, CR_TAILLE_DIC_437406#129066, CR_TYPCR_437363#129067, CR_TYPDIC_437403#129068, CR_TYPDOC_437330#129069, CR_VISDMP_437416#129070]

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

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

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

(7) HashAggregate [codegen id : 2]
Input [1]: [count#130803L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#129935L]
Results [1]: [count(1)#129935L AS count#129936L]

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

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

(10) HashAggregate
Input [1]: [count#130803L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#129935L]
Results [1]: [count(1)#129935L AS count#129936L]

(11) AdaptiveSparkPlan
Output [1]: [count#129936L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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