hdh-spark-job - Details for Query 686

Submitted Time: 2026/10/21 21:34:31
Duration: 1 s
Succeeded Jobs: 659 663

Show the Stage ID and Task ID that corresponds to the max metric

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; subgraph cluster1 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 0 ms"; 2 [labelType="html" label="HashAggregate time in aggregation build: 0 ms number of output rows: 1"]; } 3 [labelType="html" label="Exchange shuffle records written: 1 local merged chunks fetched: 0 shuffle write time: 0 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 1 local bytes read: 59.0 B fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 16.0 B local merged bytes read: 0.0 B number of partitions: 1 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 59.0 B"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 997 ms"; 5 [labelType="html" label="HashAggregate time in aggregation build: 997 ms number of output rows: 1"]; } 6 [labelType="html" label=" Project "]; 7 [labelType="html" label="Filter number of output rows: 8"]; 8 [labelType="html" label="Scan parquet number of output rows: 23,504 number of files read: 1 metadata time: 0 ms size of files read: 910.0 KiB"]; 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=13971]

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

WholeStageCodegen (1)

Project

Filter (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMDOS_438023#145978)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMDOS_438023#145978)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_STAPAT_438024#146010)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_STAPAT_438024#146010)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PREFIX_438025#146003)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_PREFIX_438025#146003)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NOMPAT_438026#145973)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NOMPAT_438026#145973)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PNOPAT_438027#145999)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_PNOPAT_438027#145999)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NJFPAT_438028#145970)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NJFPAT_438028#145970)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATNAI_438029#145937)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATNAI_438029#145937)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATNAISS_438030#145936)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATNAISS_438030#145936)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_SEXE_438031#146006)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_SEXE_438031#146006)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_438032#145982)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_438032#145982)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_SIGMA_438033#146007)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_SIGMA_438033#146007)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VERROU_438034#146023)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_VERROU_438034#146023)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_POIDS_438035#146000)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_POIDS_438035#146000)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INDCEN_438036#145954)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_INDCEN_438036#145954)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMSS_438037#145990)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMSS_438037#145990)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ANTECE_438038#145899)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_ANTECE_438038#145899)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_1_438039#145893)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_1_438039#145893)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_2_438040#145895)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_2_438040#145895)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPOS_438041#145910)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPOS_438041#145910)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VILLE_438042#146026)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_VILLE_438042#146026)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PAYS_438043#145993)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_PAYS_438043#145993)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMCAI_438044#145975)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMCAI_438044#145975)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMMUT_438045#145981)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMMUT_438045#145981)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMCHA_438046#145977)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMCHA_438046#145977)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TELPRI_438047#146016)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TELPRI_438047#146016)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TELBUR_438048#146014)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TELBUR_438048#146014)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TELPOR_438049#146015)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TELPOR_438049#146015)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FAX_438050#145942)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_FAX_438050#145942)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PREFI2_438051#146002)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_PREFI2_438051#146002)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NOMASS_438052#145971)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NOMASS_438052#145971)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PNOASS_438053#145997)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_PNOASS_438053#145997)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NJFASS_438054#145969)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NJFASS_438054#145969)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATASS_438055#145928)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATASS_438055#145928)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_1A_438056#145892)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_1A_438056#145892)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_2A_438057#145894)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_2A_438057#145894)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPOA_438058#145908)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPOA_438058#145908)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VILLEA_438059#146024)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_VILLEA_438059#146024)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODMED_438060#145905)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODMED_438060#145905)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATCSS_438061#145929)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATCSS_438061#145929)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATF_D_438062#145932)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATF_D_438062#145932)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DAT100_438063#145924)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DAT100_438063#145924)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMSIR_438064#145988)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMSIR_438064#145988)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMSSA_438065#145989)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMSSA_438065#145989)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODSER_438066#145914)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODSER_438066#145914)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_RNGNAI_438067#146005)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_RNGNAI_438067#146005)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NATASS_438068#145966)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NATASS_438068#145966)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMACC_438069#145974)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMACC_438069#145974)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATACC_438070#145925)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATACC_438070#145925)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TYPEXO_438071#146022)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TYPEXO_438071#146022)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATMAJ_438072#145935)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATMAJ_438072#145935)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODUTI_438073#145918)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODUTI_438073#145918)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLCMU_438074#145945)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLCMU_438074#145945)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_QUALSS_438075#146004)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_QUALSS_438075#146004)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODREF_438076#145911)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODREF_438076#145911)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODREGAT_438077#145912)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODREGAT_438077#145912)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODCAIAT_438078#145901)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODCAIAT_438078#145901)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INDVITAL_438079#145956)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_INDVITAL_438079#145956)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CONMUT_438080#145921)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CONMUT_438080#145921)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADHMUT_438081#145891)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADHMUT_438081#145891)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_GARMUT_438082#145951)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_GARMUT_438082#145951)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_ORI_438083#145983)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_ORI_438083#145983)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODROUT_438084#145913)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODROUT_438084#145913)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DOMAINE_438085#145940)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DOMAINE_438085#145940)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INDTRAI_438086#145955)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_INDTRAI_438086#145955)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_IDHOTE_438087#145953)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_IDHOTE_438087#145953)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODSTS_438088#145916)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODSTS_438088#145916)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NIRIND_438089#145968)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NIRIND_438089#145968)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLDCD_438090#145946)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLDCD_438090#145946)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLPHOTO_438091#145950)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLPHOTO_438091#145950)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODMTR_438092#145906)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODMTR_438092#145906)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_3_438093#145897)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_3_438093#145897)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PAYS_ISO_438094#145994)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_PAYS_ISO_438094#145994)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_3A_438095#145896)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_3A_438095#145896)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_POIDS_MAJ_438096#146001)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_POIDS_MAJ_438096#146001)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODGESTION_438097#145903)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODGESTION_438097#145903)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ART115_438098#145900)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_ART115_438098#145900)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TAILLE_438099#146011)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TAILLE_438099#146011)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TAILLE_MAJ_438100#146012)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TAILLE_MAJ_438100#146012)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODETAB_PROD_438101#145902)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODETAB_PROD_438101#145902)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODSIT_PROD_438102#145915)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODSIT_PROD_438102#145915)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMDOS_PROD_438103#145980)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMDOS_PROD_438103#145980)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_PROD_438104#145986)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_PROD_438104#145986)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_ORI_P_438105#145985)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_ORI_P_438105#145985)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_438106#145959)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_438106#145959)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_TYPE_438107#145963)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_TYPE_438107#145963)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_DATE_438108#145960)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_DATE_438108#145960)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_SOURCE_438109#145962)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_SOURCE_438109#145962)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_STADMP_438110#146008)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_STADMP_438110#146008)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATDMP_438111#145931)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATDMP_438111#145931)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ALARMES_438112#145898)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_ALARMES_438112#145898)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_EMAIL_438113#145941)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_EMAIL_438113#145941)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CONSENT_SMS_438114#145922)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CONSENT_SMS_438114#145922)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DAT_CONSENT__438115#145938)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DAT_CONSENT__438115#145938)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATDCD_438116#145930)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATDCD_438116#145930)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLHLIM_438117#145949)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLHLIM_438117#145949)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATHLIM_438118#145934)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATHLIM_438118#145934)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPERSHLIM_438119#145907)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPERSHLIM_438119#145907)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLDIFF_438120#145947)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLDIFF_438120#145947)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_LISDEST_438121#145965)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_LISDEST_438121#145965)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_LANGUE_438122#145964)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_LANGUE_438122#145964)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMCAI_FT_438123#145976)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMCAI_FT_438123#145976)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODTARIFAMC_438124#145917)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODTARIFAMC_438124#145917)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLGRVE_438125#145948)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLGRVE_438125#145948)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLADRI_438126#145943)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLADRI_438126#145943)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATADRI_438127#145926)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATADRI_438127#145926)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATF_MUT_438128#145933)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATF_MUT_438128#145933)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_COMFAC_438129#145919)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_COMFAC_438129#145919)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMDOS_CLOUD_438130#145979)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMDOS_CLOUD_438130#145979)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NATION_438131#145967)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NATION_438131#145967)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TITRE_438132#146019)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TITRE_438132#146019)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TITRE_ASS_438133#146020)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TITRE_ASS_438133#146020)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TIQ_HISTOXML_438134#146017)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TIQ_HISTOXML_438134#146017)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TIQ_PNOLISTE_438135#146018)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TIQ_PNOLISTE_438135#146018)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPOSNAI_438136#145909)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPOSNAI_438136#145909)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INSI_438137#145957)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_INSI_438137#145957)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INSI_OID_438138#145958)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_INSI_OID_438138#145958)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TYPCONV_438139#146021)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TYPCONV_438139#146021)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CRISEC_438140#145923)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CRISEC_438140#145923)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_OPEREG_438141#145992)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_OPEREG_438141#145992)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLANNUAMC_438142#145944)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLANNUAMC_438142#145944)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_STAIPP_438143#146009)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_STAIPP_438143#146009)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PNONAI_438144#145998)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_PNONAI_438144#145998)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODINSEENAI_438145#145904)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODINSEENAI_438145#145904)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VILLENAI_438146#146025)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_VILLENAI_438146#146025)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PIECE_IDENT__438147#145996)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_PIECE_IDENT__438147#145996)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DAT_STAIPP_438148#145939)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DAT_STAIPP_438148#145939)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATAPCV_438149#145927)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATAPCV_438149#145927)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUM_APCV_438150#145991)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUM_APCV_438150#145991)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_HEUAPCV_438151#145952)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_HEUAPCV_438151#145952)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_SEC_438152#145987)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_SEC_438152#145987)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_HEURE_438153#145961)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_HEURE_438153#145961)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PERSAPREV_438154#145995)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_PERSAPREV_438154#145995)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TARIF_438155#146013)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TARIF_438155#146013)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NOMHL7_438156#145972)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NOMHL7_438156#145972)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_ORI_O_438157#145984)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_ORI_O_438157#145984)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_COMMENT_438158#145920)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_COMMENT_438158#145920)), MARX) END)

FileScan parquet [AT_ADHMUT_438081#145891,AT_ADR_1A_438056#145892,AT_ADR_1_438039#145893,AT_ADR_2A_438057#145894,AT_ADR_2_438040#145895,AT_ADR_3A_438095#145896,AT_ADR_3_438093#145897,AT_ALARMES_438112#145898,AT_ANTECE_438038#145899,AT_ART115_438098#145900,AT_CODCAIAT_438078#145901,AT_CODETAB_PROD_438101#145902,AT_CODGESTION_438097#145903,AT_CODINSEENAI_438145#145904,AT_CODMED_438060#145905,AT_CODMTR_438092#145906,AT_CODPERSHLIM_438119#145907,AT_CODPOA_438058#145908,AT_CODPOSNAI_438136#145909,AT_CODPOS_438041#145910,AT_CODREF_438076#145911,AT_CODREGAT_438077#145912,AT_CODROUT_438084#145913,AT_CODSER_438066#145914,... 112 more fields] Batched: false, DataFilters: [((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/uet/H_PATIEN_438022], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<AT_ADHMUT_438081:string,AT_ADR_1A_438056:string,AT_ADR_1_438039:string,AT_ADR_2A_438057:st...

Details

== Physical Plan ==
AdaptiveSparkPlan (11)
+- == Final Plan ==
   * HashAggregate (7)
   +- ShuffleQueryStage (6), Statistics(sizeInBytes=16.0 B, rowCount=1)
      +- 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 [136]: [AT_ADHMUT_438081#145891, AT_ADR_1A_438056#145892, AT_ADR_1_438039#145893, AT_ADR_2A_438057#145894, AT_ADR_2_438040#145895, AT_ADR_3A_438095#145896, AT_ADR_3_438093#145897, AT_ALARMES_438112#145898, AT_ANTECE_438038#145899, AT_ART115_438098#145900, AT_CODCAIAT_438078#145901, AT_CODETAB_PROD_438101#145902, AT_CODGESTION_438097#145903, AT_CODINSEENAI_438145#145904, AT_CODMED_438060#145905, AT_CODMTR_438092#145906, AT_CODPERSHLIM_438119#145907, AT_CODPOA_438058#145908, AT_CODPOSNAI_438136#145909, AT_CODPOS_438041#145910, AT_CODREF_438076#145911, AT_CODREGAT_438077#145912, AT_CODROUT_438084#145913, AT_CODSER_438066#145914, AT_CODSIT_PROD_438102#145915, AT_CODSTS_438088#145916, AT_CODTARIFAMC_438124#145917, AT_CODUTI_438073#145918, AT_COMFAC_438129#145919, AT_COMMENT_438158#145920, AT_CONMUT_438080#145921, AT_CONSENT_SMS_438114#145922, AT_CRISEC_438140#145923, AT_DAT100_438063#145924, AT_DATACC_438070#145925, AT_DATADRI_438127#145926, AT_DATAPCV_438149#145927, AT_DATASS_438055#145928, AT_DATCSS_438061#145929, AT_DATDCD_438116#145930, AT_DATDMP_438111#145931, AT_DATF_D_438062#145932, AT_DATF_MUT_438128#145933, AT_DATHLIM_438118#145934, AT_DATMAJ_438072#145935, AT_DATNAISS_438030#145936, AT_DATNAI_438029#145937, AT_DAT_CONSENT__438115#145938, AT_DAT_STAIPP_438148#145939, AT_DOMAINE_438085#145940, AT_EMAIL_438113#145941, AT_FAX_438050#145942, AT_FLADRI_438126#145943, AT_FLANNUAMC_438142#145944, AT_FLCMU_438074#145945, AT_FLDCD_438090#145946, AT_FLDIFF_438120#145947, AT_FLGRVE_438125#145948, AT_FLHLIM_438117#145949, AT_FLPHOTO_438091#145950, AT_GARMUT_438082#145951, AT_HEUAPCV_438151#145952, AT_IDHOTE_438087#145953, AT_INDCEN_438036#145954, AT_INDTRAI_438086#145955, AT_INDVITAL_438079#145956, AT_INSI_438137#145957, AT_INSI_OID_438138#145958, AT_INS_438106#145959, AT_INS_DATE_438108#145960, AT_INS_HEURE_438153#145961, AT_INS_SOURCE_438109#145962, AT_INS_TYPE_438107#145963, AT_LANGUE_438122#145964, AT_LISDEST_438121#145965, AT_NATASS_438068#145966, AT_NATION_438131#145967, AT_NIRIND_438089#145968, AT_NJFASS_438054#145969, AT_NJFPAT_438028#145970, AT_NOMASS_438052#145971, AT_NOMHL7_438156#145972, AT_NOMPAT_438026#145973, AT_NUMACC_438069#145974, AT_NUMCAI_438044#145975, AT_NUMCAI_FT_438123#145976, AT_NUMCHA_438046#145977, AT_NUMDOS_438023#145978, AT_NUMDOS_CLOUD_438130#145979, AT_NUMDOS_PROD_438103#145980, AT_NUMMUT_438045#145981, AT_NUMPER_438032#145982, AT_NUMPER_ORI_438083#145983, AT_NUMPER_ORI_O_438157#145984, AT_NUMPER_ORI_P_438105#145985, AT_NUMPER_PROD_438104#145986, AT_NUMPER_SEC_438152#145987, AT_NUMSIR_438064#145988, AT_NUMSSA_438065#145989, AT_NUMSS_438037#145990, AT_NUM_APCV_438150#145991, AT_OPEREG_438141#145992, AT_PAYS_438043#145993, AT_PAYS_ISO_438094#145994, AT_PERSAPREV_438154#145995, AT_PIECE_IDENT__438147#145996, AT_PNOASS_438053#145997, AT_PNONAI_438144#145998, AT_PNOPAT_438027#145999, AT_POIDS_438035#146000, AT_POIDS_MAJ_438096#146001, AT_PREFI2_438051#146002, AT_PREFIX_438025#146003, AT_QUALSS_438075#146004, AT_RNGNAI_438067#146005, AT_SEXE_438031#146006, AT_SIGMA_438033#146007, AT_STADMP_438110#146008, AT_STAIPP_438143#146009, AT_STAPAT_438024#146010, AT_TAILLE_438099#146011, AT_TAILLE_MAJ_438100#146012, AT_TARIF_438155#146013, AT_TELBUR_438048#146014, AT_TELPOR_438049#146015, AT_TELPRI_438047#146016, AT_TIQ_HISTOXML_438134#146017, AT_TIQ_PNOLISTE_438135#146018, AT_TITRE_438132#146019, AT_TITRE_ASS_438133#146020, AT_TYPCONV_438139#146021, AT_TYPEXO_438071#146022, AT_VERROU_438034#146023, AT_VILLEA_438059#146024, AT_VILLENAI_438146#146025, AT_VILLE_438042#146026]
Batched: false
Location: InMemoryFileIndex [file:/data/output/cache/parquet/uet/H_PATIEN_438022]
ReadSchema: struct<AT_ADHMUT_438081:string,AT_ADR_1A_438056:string,AT_ADR_1_438039:string,AT_ADR_2A_438057:string,AT_ADR_2_438040:string,AT_ADR_3A_438095:string,AT_ADR_3_438093:string,AT_ALARMES_438112:string,AT_ANTECE_438038:string,AT_ART115_438098:string,AT_CODCAIAT_438078:string,AT_CODETAB_PROD_438101:string,AT_CODGESTION_438097:string,AT_CODINSEENAI_438145:string,AT_CODMED_438060:string,AT_CODMTR_438092:string,AT_CODPERSHLIM_438119:string,AT_CODPOA_438058:string,AT_CODPOSNAI_438136:string,AT_CODPOS_438041:string,AT_CODREF_438076:string,AT_CODREGAT_438077:string,AT_CODROUT_438084:string,AT_CODSER_438066:string,AT_CODSIT_PROD_438102:string,AT_CODSTS_438088:string,AT_CODTARIFAMC_438124:string,AT_CODUTI_438073:string,AT_COMFAC_438129:string,AT_COMMENT_438158:string,AT_CONMUT_438080:string,AT_CONSENT_SMS_438114:string,AT_CRISEC_438140:string,AT_DAT100_438063:string,AT_DATACC_438070:string,AT_DATADRI_438127:string,AT_DATAPCV_438149:string,AT_DATASS_438055:string,AT_DATCSS_438061:string,AT_DATDCD_438116:string,AT_DATDMP_438111:string,AT_DATF_D_438062:string,AT_DATF_MUT_438128:string,AT_DATHLIM_438118:string,AT_DATMAJ_438072:string,AT_DATNAISS_438030:string,AT_DATNAI_438029:string,AT_DAT_CONSENT__438115:string,AT_DAT_STAIPP_438148:string,AT_DOMAINE_438085:string,AT_EMAIL_438113:string,AT_FAX_438050:string,AT_FLADRI_438126:string,AT_FLANNUAMC_438142:string,AT_FLCMU_438074:string,AT_FLDCD_438090:string,AT_FLDIFF_438120:string,AT_FLGRVE_438125:string,AT_FLHLIM_438117:string,AT_FLPHOTO_438091:string,AT_GARMUT_438082:string,AT_HEUAPCV_438151:string,AT_IDHOTE_438087:string,AT_INDCEN_438036:string,AT_INDTRAI_438086:string,AT_INDVITAL_438079:string,AT_INSI_438137:string,AT_INSI_OID_438138:string,AT_INS_438106:string,AT_INS_DATE_438108:string,AT_INS_HEURE_438153:string,AT_INS_SOURCE_438109:string,AT_INS_TYPE_438107:string,AT_LANGUE_438122:string,AT_LISDEST_438121:string,AT_NATASS_438068:string,AT_NATION_438131:string,AT_NIRIND_438089:string,AT_NJFASS_438054:string,AT_NJFPAT_438028:string,AT_NOMASS_438052:string,AT_NOMHL7_438156:string,AT_NOMPAT_438026:string,AT_NUMACC_438069:string,AT_NUMCAI_438044:string,AT_NUMCAI_FT_438123:string,AT_NUMCHA_438046:string,AT_NUMDOS_438023:string,AT_NUMDOS_CLOUD_438130:string,AT_NUMDOS_PROD_438103:string,AT_NUMMUT_438045:string,AT_NUMPER_438032:string,AT_NUMPER_ORI_438083:string,AT_NUMPER_ORI_O_438157:string,AT_NUMPER_ORI_P_438105:string,AT_NUMPER_PROD_438104:string,AT_NUMPER_SEC_438152:string,AT_NUMSIR_438064:string,AT_NUMSSA_438065:string,AT_NUMSS_438037:string,AT_NUM_APCV_438150:string,AT_OPEREG_438141:string,AT_PAYS_438043:string,AT_PAYS_ISO_438094:string,AT_PERSAPREV_438154:string,AT_PIECE_IDENT__438147:string,AT_PNOASS_438053:string,AT_PNONAI_438144:string,AT_PNOPAT_438027:string,AT_POIDS_438035:string,AT_POIDS_MAJ_438096:string,AT_PREFI2_438051:string,AT_PREFIX_438025:string,AT_QUALSS_438075:string,AT_RNGNAI_438067:string,AT_SEXE_438031:string,AT_SIGMA_438033:string,AT_STADMP_438110:string,AT_STAIPP_438143:string,AT_STAPAT_438024:string,AT_TAILLE_438099:string,AT_TAILLE_MAJ_438100:string,AT_TARIF_438155:string,AT_TELBUR_438048:string,AT_TELPOR_438049:string,AT_TELPRI_438047:string,AT_TIQ_HISTOXML_438134:string,AT_TIQ_PNOLISTE_438135:string,AT_TITRE_438132:string,AT_TITRE_ASS_438133:string,AT_TYPCONV_438139:string,AT_TYPEXO_438071:string,AT_VERROU_438034:string,AT_VILLEA_438059:string,AT_VILLENAI_438146:string,AT_VILLE_438042:string>

(2) Filter
Input [136]: [AT_ADHMUT_438081#145891, AT_ADR_1A_438056#145892, AT_ADR_1_438039#145893, AT_ADR_2A_438057#145894, AT_ADR_2_438040#145895, AT_ADR_3A_438095#145896, AT_ADR_3_438093#145897, AT_ALARMES_438112#145898, AT_ANTECE_438038#145899, AT_ART115_438098#145900, AT_CODCAIAT_438078#145901, AT_CODETAB_PROD_438101#145902, AT_CODGESTION_438097#145903, AT_CODINSEENAI_438145#145904, AT_CODMED_438060#145905, AT_CODMTR_438092#145906, AT_CODPERSHLIM_438119#145907, AT_CODPOA_438058#145908, AT_CODPOSNAI_438136#145909, AT_CODPOS_438041#145910, AT_CODREF_438076#145911, AT_CODREGAT_438077#145912, AT_CODROUT_438084#145913, AT_CODSER_438066#145914, AT_CODSIT_PROD_438102#145915, AT_CODSTS_438088#145916, AT_CODTARIFAMC_438124#145917, AT_CODUTI_438073#145918, AT_COMFAC_438129#145919, AT_COMMENT_438158#145920, AT_CONMUT_438080#145921, AT_CONSENT_SMS_438114#145922, AT_CRISEC_438140#145923, AT_DAT100_438063#145924, AT_DATACC_438070#145925, AT_DATADRI_438127#145926, AT_DATAPCV_438149#145927, AT_DATASS_438055#145928, AT_DATCSS_438061#145929, AT_DATDCD_438116#145930, AT_DATDMP_438111#145931, AT_DATF_D_438062#145932, AT_DATF_MUT_438128#145933, AT_DATHLIM_438118#145934, AT_DATMAJ_438072#145935, AT_DATNAISS_438030#145936, AT_DATNAI_438029#145937, AT_DAT_CONSENT__438115#145938, AT_DAT_STAIPP_438148#145939, AT_DOMAINE_438085#145940, AT_EMAIL_438113#145941, AT_FAX_438050#145942, AT_FLADRI_438126#145943, AT_FLANNUAMC_438142#145944, AT_FLCMU_438074#145945, AT_FLDCD_438090#145946, AT_FLDIFF_438120#145947, AT_FLGRVE_438125#145948, AT_FLHLIM_438117#145949, AT_FLPHOTO_438091#145950, AT_GARMUT_438082#145951, AT_HEUAPCV_438151#145952, AT_IDHOTE_438087#145953, AT_INDCEN_438036#145954, AT_INDTRAI_438086#145955, AT_INDVITAL_438079#145956, AT_INSI_438137#145957, AT_INSI_OID_438138#145958, AT_INS_438106#145959, AT_INS_DATE_438108#145960, AT_INS_HEURE_438153#145961, AT_INS_SOURCE_438109#145962, AT_INS_TYPE_438107#145963, AT_LANGUE_438122#145964, AT_LISDEST_438121#145965, AT_NATASS_438068#145966, AT_NATION_438131#145967, AT_NIRIND_438089#145968, AT_NJFASS_438054#145969, AT_NJFPAT_438028#145970, AT_NOMASS_438052#145971, AT_NOMHL7_438156#145972, AT_NOMPAT_438026#145973, AT_NUMACC_438069#145974, AT_NUMCAI_438044#145975, AT_NUMCAI_FT_438123#145976, AT_NUMCHA_438046#145977, AT_NUMDOS_438023#145978, AT_NUMDOS_CLOUD_438130#145979, AT_NUMDOS_PROD_438103#145980, AT_NUMMUT_438045#145981, AT_NUMPER_438032#145982, AT_NUMPER_ORI_438083#145983, AT_NUMPER_ORI_O_438157#145984, AT_NUMPER_ORI_P_438105#145985, AT_NUMPER_PROD_438104#145986, AT_NUMPER_SEC_438152#145987, AT_NUMSIR_438064#145988, AT_NUMSSA_438065#145989, AT_NUMSS_438037#145990, AT_NUM_APCV_438150#145991, AT_OPEREG_438141#145992, AT_PAYS_438043#145993, AT_PAYS_ISO_438094#145994, AT_PERSAPREV_438154#145995, AT_PIECE_IDENT__438147#145996, AT_PNOASS_438053#145997, AT_PNONAI_438144#145998, AT_PNOPAT_438027#145999, AT_POIDS_438035#146000, AT_POIDS_MAJ_438096#146001, AT_PREFI2_438051#146002, AT_PREFIX_438025#146003, AT_QUALSS_438075#146004, AT_RNGNAI_438067#146005, AT_SEXE_438031#146006, AT_SIGMA_438033#146007, AT_STADMP_438110#146008, AT_STAIPP_438143#146009, AT_STAPAT_438024#146010, AT_TAILLE_438099#146011, AT_TAILLE_MAJ_438100#146012, AT_TARIF_438155#146013, AT_TELBUR_438048#146014, AT_TELPOR_438049#146015, AT_TELPRI_438047#146016, AT_TIQ_HISTOXML_438134#146017, AT_TIQ_PNOLISTE_438135#146018, AT_TITRE_438132#146019, AT_TITRE_ASS_438133#146020, AT_TYPCONV_438139#146021, AT_TYPEXO_438071#146022, AT_VERROU_438034#146023, AT_VILLEA_438059#146024, AT_VILLENAI_438146#146025, AT_VILLE_438042#146026]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMDOS_438023#145978)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMDOS_438023#145978)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_STAPAT_438024#146010)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_STAPAT_438024#146010)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PREFIX_438025#146003)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_PREFIX_438025#146003)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NOMPAT_438026#145973)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NOMPAT_438026#145973)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PNOPAT_438027#145999)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_PNOPAT_438027#145999)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NJFPAT_438028#145970)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NJFPAT_438028#145970)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATNAI_438029#145937)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATNAI_438029#145937)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATNAISS_438030#145936)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATNAISS_438030#145936)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_SEXE_438031#146006)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_SEXE_438031#146006)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_438032#145982)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_438032#145982)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_SIGMA_438033#146007)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_SIGMA_438033#146007)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VERROU_438034#146023)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_VERROU_438034#146023)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_POIDS_438035#146000)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_POIDS_438035#146000)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INDCEN_438036#145954)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_INDCEN_438036#145954)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMSS_438037#145990)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMSS_438037#145990)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ANTECE_438038#145899)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_ANTECE_438038#145899)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_1_438039#145893)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_1_438039#145893)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_2_438040#145895)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_2_438040#145895)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPOS_438041#145910)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPOS_438041#145910)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VILLE_438042#146026)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_VILLE_438042#146026)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PAYS_438043#145993)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_PAYS_438043#145993)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMCAI_438044#145975)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMCAI_438044#145975)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMMUT_438045#145981)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMMUT_438045#145981)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMCHA_438046#145977)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMCHA_438046#145977)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TELPRI_438047#146016)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TELPRI_438047#146016)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TELBUR_438048#146014)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TELBUR_438048#146014)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TELPOR_438049#146015)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TELPOR_438049#146015)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FAX_438050#145942)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_FAX_438050#145942)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PREFI2_438051#146002)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_PREFI2_438051#146002)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NOMASS_438052#145971)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NOMASS_438052#145971)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PNOASS_438053#145997)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_PNOASS_438053#145997)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NJFASS_438054#145969)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NJFASS_438054#145969)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATASS_438055#145928)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATASS_438055#145928)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_1A_438056#145892)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_1A_438056#145892)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_2A_438057#145894)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_2A_438057#145894)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPOA_438058#145908)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPOA_438058#145908)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VILLEA_438059#146024)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_VILLEA_438059#146024)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODMED_438060#145905)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODMED_438060#145905)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATCSS_438061#145929)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATCSS_438061#145929)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATF_D_438062#145932)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATF_D_438062#145932)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DAT100_438063#145924)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DAT100_438063#145924)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMSIR_438064#145988)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMSIR_438064#145988)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMSSA_438065#145989)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMSSA_438065#145989)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODSER_438066#145914)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODSER_438066#145914)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_RNGNAI_438067#146005)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_RNGNAI_438067#146005)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NATASS_438068#145966)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NATASS_438068#145966)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMACC_438069#145974)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMACC_438069#145974)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATACC_438070#145925)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATACC_438070#145925)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TYPEXO_438071#146022)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TYPEXO_438071#146022)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATMAJ_438072#145935)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATMAJ_438072#145935)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODUTI_438073#145918)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODUTI_438073#145918)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLCMU_438074#145945)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLCMU_438074#145945)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_QUALSS_438075#146004)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_QUALSS_438075#146004)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODREF_438076#145911)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODREF_438076#145911)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODREGAT_438077#145912)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODREGAT_438077#145912)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODCAIAT_438078#145901)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODCAIAT_438078#145901)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INDVITAL_438079#145956)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_INDVITAL_438079#145956)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CONMUT_438080#145921)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CONMUT_438080#145921)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADHMUT_438081#145891)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADHMUT_438081#145891)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_GARMUT_438082#145951)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_GARMUT_438082#145951)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_ORI_438083#145983)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_ORI_438083#145983)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODROUT_438084#145913)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODROUT_438084#145913)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DOMAINE_438085#145940)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DOMAINE_438085#145940)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INDTRAI_438086#145955)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_INDTRAI_438086#145955)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_IDHOTE_438087#145953)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_IDHOTE_438087#145953)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODSTS_438088#145916)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODSTS_438088#145916)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NIRIND_438089#145968)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NIRIND_438089#145968)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLDCD_438090#145946)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLDCD_438090#145946)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLPHOTO_438091#145950)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLPHOTO_438091#145950)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODMTR_438092#145906)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODMTR_438092#145906)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_3_438093#145897)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_3_438093#145897)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PAYS_ISO_438094#145994)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_PAYS_ISO_438094#145994)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_3A_438095#145896)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_3A_438095#145896)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_POIDS_MAJ_438096#146001)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_POIDS_MAJ_438096#146001)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODGESTION_438097#145903)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODGESTION_438097#145903)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ART115_438098#145900)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_ART115_438098#145900)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TAILLE_438099#146011)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TAILLE_438099#146011)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TAILLE_MAJ_438100#146012)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TAILLE_MAJ_438100#146012)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODETAB_PROD_438101#145902)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODETAB_PROD_438101#145902)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODSIT_PROD_438102#145915)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODSIT_PROD_438102#145915)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMDOS_PROD_438103#145980)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMDOS_PROD_438103#145980)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_PROD_438104#145986)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_PROD_438104#145986)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_ORI_P_438105#145985)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_ORI_P_438105#145985)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_438106#145959)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_438106#145959)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_TYPE_438107#145963)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_TYPE_438107#145963)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_DATE_438108#145960)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_DATE_438108#145960)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_SOURCE_438109#145962)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_SOURCE_438109#145962)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_STADMP_438110#146008)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_STADMP_438110#146008)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATDMP_438111#145931)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATDMP_438111#145931)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ALARMES_438112#145898)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_ALARMES_438112#145898)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_EMAIL_438113#145941)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_EMAIL_438113#145941)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CONSENT_SMS_438114#145922)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CONSENT_SMS_438114#145922)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DAT_CONSENT__438115#145938)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DAT_CONSENT__438115#145938)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATDCD_438116#145930)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATDCD_438116#145930)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLHLIM_438117#145949)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLHLIM_438117#145949)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATHLIM_438118#145934)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATHLIM_438118#145934)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPERSHLIM_438119#145907)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPERSHLIM_438119#145907)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLDIFF_438120#145947)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLDIFF_438120#145947)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_LISDEST_438121#145965)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_LISDEST_438121#145965)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_LANGUE_438122#145964)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_LANGUE_438122#145964)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMCAI_FT_438123#145976)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMCAI_FT_438123#145976)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODTARIFAMC_438124#145917)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODTARIFAMC_438124#145917)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLGRVE_438125#145948)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLGRVE_438125#145948)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLADRI_438126#145943)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLADRI_438126#145943)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATADRI_438127#145926)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATADRI_438127#145926)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATF_MUT_438128#145933)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATF_MUT_438128#145933)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_COMFAC_438129#145919)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_COMFAC_438129#145919)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMDOS_CLOUD_438130#145979)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMDOS_CLOUD_438130#145979)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NATION_438131#145967)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NATION_438131#145967)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TITRE_438132#146019)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TITRE_438132#146019)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TITRE_ASS_438133#146020)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TITRE_ASS_438133#146020)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TIQ_HISTOXML_438134#146017)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TIQ_HISTOXML_438134#146017)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TIQ_PNOLISTE_438135#146018)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TIQ_PNOLISTE_438135#146018)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPOSNAI_438136#145909)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPOSNAI_438136#145909)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INSI_438137#145957)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_INSI_438137#145957)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INSI_OID_438138#145958)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_INSI_OID_438138#145958)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TYPCONV_438139#146021)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TYPCONV_438139#146021)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CRISEC_438140#145923)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CRISEC_438140#145923)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_OPEREG_438141#145992)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_OPEREG_438141#145992)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLANNUAMC_438142#145944)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLANNUAMC_438142#145944)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_STAIPP_438143#146009)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_STAIPP_438143#146009)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PNONAI_438144#145998)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_PNONAI_438144#145998)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODINSEENAI_438145#145904)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODINSEENAI_438145#145904)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VILLENAI_438146#146025)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_VILLENAI_438146#146025)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PIECE_IDENT__438147#145996)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_PIECE_IDENT__438147#145996)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DAT_STAIPP_438148#145939)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DAT_STAIPP_438148#145939)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATAPCV_438149#145927)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATAPCV_438149#145927)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUM_APCV_438150#145991)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUM_APCV_438150#145991)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_HEUAPCV_438151#145952)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_HEUAPCV_438151#145952)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_SEC_438152#145987)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_SEC_438152#145987)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_HEURE_438153#145961)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_HEURE_438153#145961)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PERSAPREV_438154#145995)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_PERSAPREV_438154#145995)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TARIF_438155#146013)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TARIF_438155#146013)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NOMHL7_438156#145972)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NOMHL7_438156#145972)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_ORI_O_438157#145984)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_ORI_O_438157#145984)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_COMMENT_438158#145920)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_COMMENT_438158#145920)), MARX) END)

(3) Project
Output: []
Input [136]: [AT_ADHMUT_438081#145891, AT_ADR_1A_438056#145892, AT_ADR_1_438039#145893, AT_ADR_2A_438057#145894, AT_ADR_2_438040#145895, AT_ADR_3A_438095#145896, AT_ADR_3_438093#145897, AT_ALARMES_438112#145898, AT_ANTECE_438038#145899, AT_ART115_438098#145900, AT_CODCAIAT_438078#145901, AT_CODETAB_PROD_438101#145902, AT_CODGESTION_438097#145903, AT_CODINSEENAI_438145#145904, AT_CODMED_438060#145905, AT_CODMTR_438092#145906, AT_CODPERSHLIM_438119#145907, AT_CODPOA_438058#145908, AT_CODPOSNAI_438136#145909, AT_CODPOS_438041#145910, AT_CODREF_438076#145911, AT_CODREGAT_438077#145912, AT_CODROUT_438084#145913, AT_CODSER_438066#145914, AT_CODSIT_PROD_438102#145915, AT_CODSTS_438088#145916, AT_CODTARIFAMC_438124#145917, AT_CODUTI_438073#145918, AT_COMFAC_438129#145919, AT_COMMENT_438158#145920, AT_CONMUT_438080#145921, AT_CONSENT_SMS_438114#145922, AT_CRISEC_438140#145923, AT_DAT100_438063#145924, AT_DATACC_438070#145925, AT_DATADRI_438127#145926, AT_DATAPCV_438149#145927, AT_DATASS_438055#145928, AT_DATCSS_438061#145929, AT_DATDCD_438116#145930, AT_DATDMP_438111#145931, AT_DATF_D_438062#145932, AT_DATF_MUT_438128#145933, AT_DATHLIM_438118#145934, AT_DATMAJ_438072#145935, AT_DATNAISS_438030#145936, AT_DATNAI_438029#145937, AT_DAT_CONSENT__438115#145938, AT_DAT_STAIPP_438148#145939, AT_DOMAINE_438085#145940, AT_EMAIL_438113#145941, AT_FAX_438050#145942, AT_FLADRI_438126#145943, AT_FLANNUAMC_438142#145944, AT_FLCMU_438074#145945, AT_FLDCD_438090#145946, AT_FLDIFF_438120#145947, AT_FLGRVE_438125#145948, AT_FLHLIM_438117#145949, AT_FLPHOTO_438091#145950, AT_GARMUT_438082#145951, AT_HEUAPCV_438151#145952, AT_IDHOTE_438087#145953, AT_INDCEN_438036#145954, AT_INDTRAI_438086#145955, AT_INDVITAL_438079#145956, AT_INSI_438137#145957, AT_INSI_OID_438138#145958, AT_INS_438106#145959, AT_INS_DATE_438108#145960, AT_INS_HEURE_438153#145961, AT_INS_SOURCE_438109#145962, AT_INS_TYPE_438107#145963, AT_LANGUE_438122#145964, AT_LISDEST_438121#145965, AT_NATASS_438068#145966, AT_NATION_438131#145967, AT_NIRIND_438089#145968, AT_NJFASS_438054#145969, AT_NJFPAT_438028#145970, AT_NOMASS_438052#145971, AT_NOMHL7_438156#145972, AT_NOMPAT_438026#145973, AT_NUMACC_438069#145974, AT_NUMCAI_438044#145975, AT_NUMCAI_FT_438123#145976, AT_NUMCHA_438046#145977, AT_NUMDOS_438023#145978, AT_NUMDOS_CLOUD_438130#145979, AT_NUMDOS_PROD_438103#145980, AT_NUMMUT_438045#145981, AT_NUMPER_438032#145982, AT_NUMPER_ORI_438083#145983, AT_NUMPER_ORI_O_438157#145984, AT_NUMPER_ORI_P_438105#145985, AT_NUMPER_PROD_438104#145986, AT_NUMPER_SEC_438152#145987, AT_NUMSIR_438064#145988, AT_NUMSSA_438065#145989, AT_NUMSS_438037#145990, AT_NUM_APCV_438150#145991, AT_OPEREG_438141#145992, AT_PAYS_438043#145993, AT_PAYS_ISO_438094#145994, AT_PERSAPREV_438154#145995, AT_PIECE_IDENT__438147#145996, AT_PNOASS_438053#145997, AT_PNONAI_438144#145998, AT_PNOPAT_438027#145999, AT_POIDS_438035#146000, AT_POIDS_MAJ_438096#146001, AT_PREFI2_438051#146002, AT_PREFIX_438025#146003, AT_QUALSS_438075#146004, AT_RNGNAI_438067#146005, AT_SEXE_438031#146006, AT_SIGMA_438033#146007, AT_STADMP_438110#146008, AT_STAIPP_438143#146009, AT_STAPAT_438024#146010, AT_TAILLE_438099#146011, AT_TAILLE_MAJ_438100#146012, AT_TARIF_438155#146013, AT_TELBUR_438048#146014, AT_TELPOR_438049#146015, AT_TELPRI_438047#146016, AT_TIQ_HISTOXML_438134#146017, AT_TIQ_PNOLISTE_438135#146018, AT_TITRE_438132#146019, AT_TITRE_ASS_438133#146020, AT_TYPCONV_438139#146021, AT_TYPEXO_438071#146022, AT_VERROU_438034#146023, AT_VILLEA_438059#146024, AT_VILLENAI_438146#146025, AT_VILLE_438042#146026]

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

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

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

(7) HashAggregate [codegen id : 2]
Input [1]: [count#148164L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#148020L]
Results [1]: [count(1)#148020L AS COL_368db4b9-1d30-415b-91cc-74264031fde5#148022L]

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

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

(10) HashAggregate
Input [1]: [count#148164L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#148020L]
Results [1]: [count(1)#148020L AS COL_368db4b9-1d30-415b-91cc-74264031fde5#148022L]

(11) AdaptiveSparkPlan
Output [1]: [COL_368db4b9-1d30-415b-91cc-74264031fde5#148022L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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