hdh-spark-job - Details for Query 658

Submitted Time: 2026/10/21 21:34:19
Duration: 0.5 s
Succeeded Jobs: 615 619

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: 197 ms"; 5 [labelType="html" label="HashAggregate time in aggregation build: 196 ms number of output rows: 1"]; } 6 [labelType="html" label=" Project "]; 7 [labelType="html" label="Filter number of output rows: 23,504"]; 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=13282]

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

WholeStageCodegen (1)

Project

Filter (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMDOS_438023#137458)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMDOS_438023#137458)), ) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_STAPAT_438024#137490)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_STAPAT_438024#137490)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PREFIX_438025#137483)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_PREFIX_438025#137483)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NOMPAT_438026#137453)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NOMPAT_438026#137453)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PNOPAT_438027#137479)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_PNOPAT_438027#137479)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NJFPAT_438028#137450)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NJFPAT_438028#137450)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATNAI_438029#137417)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_DATNAI_438029#137417)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATNAISS_438030#137416)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_DATNAISS_438030#137416)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_SEXE_438031#137486)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_SEXE_438031#137486)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_438032#137462)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_438032#137462)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_SIGMA_438033#137487)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_SIGMA_438033#137487)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VERROU_438034#137503)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_VERROU_438034#137503)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_POIDS_438035#137480)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_POIDS_438035#137480)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INDCEN_438036#137434)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_INDCEN_438036#137434)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMSS_438037#137470)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMSS_438037#137470)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ANTECE_438038#137379)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_ANTECE_438038#137379)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_1_438039#137373)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_1_438039#137373)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_2_438040#137375)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_2_438040#137375)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPOS_438041#137390)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPOS_438041#137390)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VILLE_438042#137506)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_VILLE_438042#137506)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PAYS_438043#137473)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_PAYS_438043#137473)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMCAI_438044#137455)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMCAI_438044#137455)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMMUT_438045#137461)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMMUT_438045#137461)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMCHA_438046#137457)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMCHA_438046#137457)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TELPRI_438047#137496)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_TELPRI_438047#137496)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TELBUR_438048#137494)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_TELBUR_438048#137494)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TELPOR_438049#137495)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_TELPOR_438049#137495)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FAX_438050#137422)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_FAX_438050#137422)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PREFI2_438051#137482)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_PREFI2_438051#137482)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NOMASS_438052#137451)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NOMASS_438052#137451)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PNOASS_438053#137477)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_PNOASS_438053#137477)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NJFASS_438054#137449)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NJFASS_438054#137449)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATASS_438055#137408)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_DATASS_438055#137408)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_1A_438056#137372)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_1A_438056#137372)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_2A_438057#137374)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_2A_438057#137374)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPOA_438058#137388)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPOA_438058#137388)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VILLEA_438059#137504)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_VILLEA_438059#137504)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODMED_438060#137385)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_CODMED_438060#137385)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATCSS_438061#137409)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_DATCSS_438061#137409)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATF_D_438062#137412)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_DATF_D_438062#137412)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DAT100_438063#137404)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_DAT100_438063#137404)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMSIR_438064#137468)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMSIR_438064#137468)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMSSA_438065#137469)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMSSA_438065#137469)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODSER_438066#137394)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_CODSER_438066#137394)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_RNGNAI_438067#137485)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_RNGNAI_438067#137485)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NATASS_438068#137446)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NATASS_438068#137446)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMACC_438069#137454)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMACC_438069#137454)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATACC_438070#137405)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_DATACC_438070#137405)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TYPEXO_438071#137502)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_TYPEXO_438071#137502)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATMAJ_438072#137415)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_DATMAJ_438072#137415)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODUTI_438073#137398)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_CODUTI_438073#137398)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLCMU_438074#137425)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_FLCMU_438074#137425)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_QUALSS_438075#137484)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_QUALSS_438075#137484)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODREF_438076#137391)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_CODREF_438076#137391)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODREGAT_438077#137392)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_CODREGAT_438077#137392)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODCAIAT_438078#137381)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_CODCAIAT_438078#137381)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INDVITAL_438079#137436)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_INDVITAL_438079#137436)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CONMUT_438080#137401)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_CONMUT_438080#137401)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADHMUT_438081#137371)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_ADHMUT_438081#137371)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_GARMUT_438082#137431)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_GARMUT_438082#137431)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_ORI_438083#137463)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_ORI_438083#137463)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODROUT_438084#137393)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_CODROUT_438084#137393)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DOMAINE_438085#137420)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_DOMAINE_438085#137420)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INDTRAI_438086#137435)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_INDTRAI_438086#137435)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_IDHOTE_438087#137433)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_IDHOTE_438087#137433)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODSTS_438088#137396)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_CODSTS_438088#137396)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NIRIND_438089#137448)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NIRIND_438089#137448)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLDCD_438090#137426)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_FLDCD_438090#137426)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLPHOTO_438091#137430)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_FLPHOTO_438091#137430)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODMTR_438092#137386)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_CODMTR_438092#137386)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_3_438093#137377)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_3_438093#137377)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PAYS_ISO_438094#137474)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_PAYS_ISO_438094#137474)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_3A_438095#137376)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_3A_438095#137376)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_POIDS_MAJ_438096#137481)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_POIDS_MAJ_438096#137481)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODGESTION_438097#137383)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_CODGESTION_438097#137383)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ART115_438098#137380)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_ART115_438098#137380)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TAILLE_438099#137491)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_TAILLE_438099#137491)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TAILLE_MAJ_438100#137492)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_TAILLE_MAJ_438100#137492)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODETAB_PROD_438101#137382)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_CODETAB_PROD_438101#137382)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODSIT_PROD_438102#137395)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_CODSIT_PROD_438102#137395)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMDOS_PROD_438103#137460)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMDOS_PROD_438103#137460)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_PROD_438104#137466)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_PROD_438104#137466)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_ORI_P_438105#137465)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_ORI_P_438105#137465)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_438106#137439)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_438106#137439)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_TYPE_438107#137443)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_TYPE_438107#137443)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_DATE_438108#137440)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_DATE_438108#137440)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_SOURCE_438109#137442)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_SOURCE_438109#137442)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_STADMP_438110#137488)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_STADMP_438110#137488)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATDMP_438111#137411)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_DATDMP_438111#137411)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ALARMES_438112#137378)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_ALARMES_438112#137378)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_EMAIL_438113#137421)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_EMAIL_438113#137421)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CONSENT_SMS_438114#137402)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_CONSENT_SMS_438114#137402)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DAT_CONSENT__438115#137418)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_DAT_CONSENT__438115#137418)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATDCD_438116#137410)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_DATDCD_438116#137410)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLHLIM_438117#137429)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_FLHLIM_438117#137429)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATHLIM_438118#137414)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_DATHLIM_438118#137414)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPERSHLIM_438119#137387)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPERSHLIM_438119#137387)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLDIFF_438120#137427)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_FLDIFF_438120#137427)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_LISDEST_438121#137445)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_LISDEST_438121#137445)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_LANGUE_438122#137444)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_LANGUE_438122#137444)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMCAI_FT_438123#137456)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMCAI_FT_438123#137456)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODTARIFAMC_438124#137397)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_CODTARIFAMC_438124#137397)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLGRVE_438125#137428)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_FLGRVE_438125#137428)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLADRI_438126#137423)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_FLADRI_438126#137423)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATADRI_438127#137406)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_DATADRI_438127#137406)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATF_MUT_438128#137413)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_DATF_MUT_438128#137413)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_COMFAC_438129#137399)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_COMFAC_438129#137399)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMDOS_CLOUD_438130#137459)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMDOS_CLOUD_438130#137459)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NATION_438131#137447)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NATION_438131#137447)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TITRE_438132#137499)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_TITRE_438132#137499)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TITRE_ASS_438133#137500)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_TITRE_ASS_438133#137500)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TIQ_HISTOXML_438134#137497)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_TIQ_HISTOXML_438134#137497)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TIQ_PNOLISTE_438135#137498)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_TIQ_PNOLISTE_438135#137498)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPOSNAI_438136#137389)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPOSNAI_438136#137389)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INSI_438137#137437)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_INSI_438137#137437)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INSI_OID_438138#137438)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_INSI_OID_438138#137438)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TYPCONV_438139#137501)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_TYPCONV_438139#137501)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CRISEC_438140#137403)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_CRISEC_438140#137403)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_OPEREG_438141#137472)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_OPEREG_438141#137472)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLANNUAMC_438142#137424)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_FLANNUAMC_438142#137424)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_STAIPP_438143#137489)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_STAIPP_438143#137489)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PNONAI_438144#137478)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_PNONAI_438144#137478)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODINSEENAI_438145#137384)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_CODINSEENAI_438145#137384)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VILLENAI_438146#137505)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_VILLENAI_438146#137505)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PIECE_IDENT__438147#137476)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_PIECE_IDENT__438147#137476)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DAT_STAIPP_438148#137419)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_DAT_STAIPP_438148#137419)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATAPCV_438149#137407)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_DATAPCV_438149#137407)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUM_APCV_438150#137471)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NUM_APCV_438150#137471)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_HEUAPCV_438151#137432)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_HEUAPCV_438151#137432)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_SEC_438152#137467)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_SEC_438152#137467)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_HEURE_438153#137441)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_HEURE_438153#137441)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PERSAPREV_438154#137475)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_PERSAPREV_438154#137475)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TARIF_438155#137493)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_TARIF_438155#137493)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NOMHL7_438156#137452)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NOMHL7_438156#137452)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_ORI_O_438157#137464)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_ORI_O_438157#137464)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_COMMENT_438158#137400)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_COMMENT_438158#137400)), ) END)

FileScan parquet [AT_ADHMUT_438081#137371,AT_ADR_1A_438056#137372,AT_ADR_1_438039#137373,AT_ADR_2A_438057#137374,AT_ADR_2_438040#137375,AT_ADR_3A_438095#137376,AT_ADR_3_438093#137377,AT_ALARMES_438112#137378,AT_ANTECE_438038#137379,AT_ART115_438098#137380,AT_CODCAIAT_438078#137381,AT_CODETAB_PROD_438101#137382,AT_CODGESTION_438097#137383,AT_CODINSEENAI_438145#137384,AT_CODMED_438060#137385,AT_CODMTR_438092#137386,AT_CODPERSHLIM_438119#137387,AT_CODPOA_438058#137388,AT_CODPOSNAI_438136#137389,AT_CODPOS_438041#137390,AT_CODREF_438076#137391,AT_CODREGAT_438077#137392,AT_CODROUT_438084#137393,AT_CODSER_438066#137394,... 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#137371, AT_ADR_1A_438056#137372, AT_ADR_1_438039#137373, AT_ADR_2A_438057#137374, AT_ADR_2_438040#137375, AT_ADR_3A_438095#137376, AT_ADR_3_438093#137377, AT_ALARMES_438112#137378, AT_ANTECE_438038#137379, AT_ART115_438098#137380, AT_CODCAIAT_438078#137381, AT_CODETAB_PROD_438101#137382, AT_CODGESTION_438097#137383, AT_CODINSEENAI_438145#137384, AT_CODMED_438060#137385, AT_CODMTR_438092#137386, AT_CODPERSHLIM_438119#137387, AT_CODPOA_438058#137388, AT_CODPOSNAI_438136#137389, AT_CODPOS_438041#137390, AT_CODREF_438076#137391, AT_CODREGAT_438077#137392, AT_CODROUT_438084#137393, AT_CODSER_438066#137394, AT_CODSIT_PROD_438102#137395, AT_CODSTS_438088#137396, AT_CODTARIFAMC_438124#137397, AT_CODUTI_438073#137398, AT_COMFAC_438129#137399, AT_COMMENT_438158#137400, AT_CONMUT_438080#137401, AT_CONSENT_SMS_438114#137402, AT_CRISEC_438140#137403, AT_DAT100_438063#137404, AT_DATACC_438070#137405, AT_DATADRI_438127#137406, AT_DATAPCV_438149#137407, AT_DATASS_438055#137408, AT_DATCSS_438061#137409, AT_DATDCD_438116#137410, AT_DATDMP_438111#137411, AT_DATF_D_438062#137412, AT_DATF_MUT_438128#137413, AT_DATHLIM_438118#137414, AT_DATMAJ_438072#137415, AT_DATNAISS_438030#137416, AT_DATNAI_438029#137417, AT_DAT_CONSENT__438115#137418, AT_DAT_STAIPP_438148#137419, AT_DOMAINE_438085#137420, AT_EMAIL_438113#137421, AT_FAX_438050#137422, AT_FLADRI_438126#137423, AT_FLANNUAMC_438142#137424, AT_FLCMU_438074#137425, AT_FLDCD_438090#137426, AT_FLDIFF_438120#137427, AT_FLGRVE_438125#137428, AT_FLHLIM_438117#137429, AT_FLPHOTO_438091#137430, AT_GARMUT_438082#137431, AT_HEUAPCV_438151#137432, AT_IDHOTE_438087#137433, AT_INDCEN_438036#137434, AT_INDTRAI_438086#137435, AT_INDVITAL_438079#137436, AT_INSI_438137#137437, AT_INSI_OID_438138#137438, AT_INS_438106#137439, AT_INS_DATE_438108#137440, AT_INS_HEURE_438153#137441, AT_INS_SOURCE_438109#137442, AT_INS_TYPE_438107#137443, AT_LANGUE_438122#137444, AT_LISDEST_438121#137445, AT_NATASS_438068#137446, AT_NATION_438131#137447, AT_NIRIND_438089#137448, AT_NJFASS_438054#137449, AT_NJFPAT_438028#137450, AT_NOMASS_438052#137451, AT_NOMHL7_438156#137452, AT_NOMPAT_438026#137453, AT_NUMACC_438069#137454, AT_NUMCAI_438044#137455, AT_NUMCAI_FT_438123#137456, AT_NUMCHA_438046#137457, AT_NUMDOS_438023#137458, AT_NUMDOS_CLOUD_438130#137459, AT_NUMDOS_PROD_438103#137460, AT_NUMMUT_438045#137461, AT_NUMPER_438032#137462, AT_NUMPER_ORI_438083#137463, AT_NUMPER_ORI_O_438157#137464, AT_NUMPER_ORI_P_438105#137465, AT_NUMPER_PROD_438104#137466, AT_NUMPER_SEC_438152#137467, AT_NUMSIR_438064#137468, AT_NUMSSA_438065#137469, AT_NUMSS_438037#137470, AT_NUM_APCV_438150#137471, AT_OPEREG_438141#137472, AT_PAYS_438043#137473, AT_PAYS_ISO_438094#137474, AT_PERSAPREV_438154#137475, AT_PIECE_IDENT__438147#137476, AT_PNOASS_438053#137477, AT_PNONAI_438144#137478, AT_PNOPAT_438027#137479, AT_POIDS_438035#137480, AT_POIDS_MAJ_438096#137481, AT_PREFI2_438051#137482, AT_PREFIX_438025#137483, AT_QUALSS_438075#137484, AT_RNGNAI_438067#137485, AT_SEXE_438031#137486, AT_SIGMA_438033#137487, AT_STADMP_438110#137488, AT_STAIPP_438143#137489, AT_STAPAT_438024#137490, AT_TAILLE_438099#137491, AT_TAILLE_MAJ_438100#137492, AT_TARIF_438155#137493, AT_TELBUR_438048#137494, AT_TELPOR_438049#137495, AT_TELPRI_438047#137496, AT_TIQ_HISTOXML_438134#137497, AT_TIQ_PNOLISTE_438135#137498, AT_TITRE_438132#137499, AT_TITRE_ASS_438133#137500, AT_TYPCONV_438139#137501, AT_TYPEXO_438071#137502, AT_VERROU_438034#137503, AT_VILLEA_438059#137504, AT_VILLENAI_438146#137505, AT_VILLE_438042#137506]
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#137371, AT_ADR_1A_438056#137372, AT_ADR_1_438039#137373, AT_ADR_2A_438057#137374, AT_ADR_2_438040#137375, AT_ADR_3A_438095#137376, AT_ADR_3_438093#137377, AT_ALARMES_438112#137378, AT_ANTECE_438038#137379, AT_ART115_438098#137380, AT_CODCAIAT_438078#137381, AT_CODETAB_PROD_438101#137382, AT_CODGESTION_438097#137383, AT_CODINSEENAI_438145#137384, AT_CODMED_438060#137385, AT_CODMTR_438092#137386, AT_CODPERSHLIM_438119#137387, AT_CODPOA_438058#137388, AT_CODPOSNAI_438136#137389, AT_CODPOS_438041#137390, AT_CODREF_438076#137391, AT_CODREGAT_438077#137392, AT_CODROUT_438084#137393, AT_CODSER_438066#137394, AT_CODSIT_PROD_438102#137395, AT_CODSTS_438088#137396, AT_CODTARIFAMC_438124#137397, AT_CODUTI_438073#137398, AT_COMFAC_438129#137399, AT_COMMENT_438158#137400, AT_CONMUT_438080#137401, AT_CONSENT_SMS_438114#137402, AT_CRISEC_438140#137403, AT_DAT100_438063#137404, AT_DATACC_438070#137405, AT_DATADRI_438127#137406, AT_DATAPCV_438149#137407, AT_DATASS_438055#137408, AT_DATCSS_438061#137409, AT_DATDCD_438116#137410, AT_DATDMP_438111#137411, AT_DATF_D_438062#137412, AT_DATF_MUT_438128#137413, AT_DATHLIM_438118#137414, AT_DATMAJ_438072#137415, AT_DATNAISS_438030#137416, AT_DATNAI_438029#137417, AT_DAT_CONSENT__438115#137418, AT_DAT_STAIPP_438148#137419, AT_DOMAINE_438085#137420, AT_EMAIL_438113#137421, AT_FAX_438050#137422, AT_FLADRI_438126#137423, AT_FLANNUAMC_438142#137424, AT_FLCMU_438074#137425, AT_FLDCD_438090#137426, AT_FLDIFF_438120#137427, AT_FLGRVE_438125#137428, AT_FLHLIM_438117#137429, AT_FLPHOTO_438091#137430, AT_GARMUT_438082#137431, AT_HEUAPCV_438151#137432, AT_IDHOTE_438087#137433, AT_INDCEN_438036#137434, AT_INDTRAI_438086#137435, AT_INDVITAL_438079#137436, AT_INSI_438137#137437, AT_INSI_OID_438138#137438, AT_INS_438106#137439, AT_INS_DATE_438108#137440, AT_INS_HEURE_438153#137441, AT_INS_SOURCE_438109#137442, AT_INS_TYPE_438107#137443, AT_LANGUE_438122#137444, AT_LISDEST_438121#137445, AT_NATASS_438068#137446, AT_NATION_438131#137447, AT_NIRIND_438089#137448, AT_NJFASS_438054#137449, AT_NJFPAT_438028#137450, AT_NOMASS_438052#137451, AT_NOMHL7_438156#137452, AT_NOMPAT_438026#137453, AT_NUMACC_438069#137454, AT_NUMCAI_438044#137455, AT_NUMCAI_FT_438123#137456, AT_NUMCHA_438046#137457, AT_NUMDOS_438023#137458, AT_NUMDOS_CLOUD_438130#137459, AT_NUMDOS_PROD_438103#137460, AT_NUMMUT_438045#137461, AT_NUMPER_438032#137462, AT_NUMPER_ORI_438083#137463, AT_NUMPER_ORI_O_438157#137464, AT_NUMPER_ORI_P_438105#137465, AT_NUMPER_PROD_438104#137466, AT_NUMPER_SEC_438152#137467, AT_NUMSIR_438064#137468, AT_NUMSSA_438065#137469, AT_NUMSS_438037#137470, AT_NUM_APCV_438150#137471, AT_OPEREG_438141#137472, AT_PAYS_438043#137473, AT_PAYS_ISO_438094#137474, AT_PERSAPREV_438154#137475, AT_PIECE_IDENT__438147#137476, AT_PNOASS_438053#137477, AT_PNONAI_438144#137478, AT_PNOPAT_438027#137479, AT_POIDS_438035#137480, AT_POIDS_MAJ_438096#137481, AT_PREFI2_438051#137482, AT_PREFIX_438025#137483, AT_QUALSS_438075#137484, AT_RNGNAI_438067#137485, AT_SEXE_438031#137486, AT_SIGMA_438033#137487, AT_STADMP_438110#137488, AT_STAIPP_438143#137489, AT_STAPAT_438024#137490, AT_TAILLE_438099#137491, AT_TAILLE_MAJ_438100#137492, AT_TARIF_438155#137493, AT_TELBUR_438048#137494, AT_TELPOR_438049#137495, AT_TELPRI_438047#137496, AT_TIQ_HISTOXML_438134#137497, AT_TIQ_PNOLISTE_438135#137498, AT_TITRE_438132#137499, AT_TITRE_ASS_438133#137500, AT_TYPCONV_438139#137501, AT_TYPEXO_438071#137502, AT_VERROU_438034#137503, AT_VILLEA_438059#137504, AT_VILLENAI_438146#137505, AT_VILLE_438042#137506]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMDOS_438023#137458)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMDOS_438023#137458)), ) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_STAPAT_438024#137490)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_STAPAT_438024#137490)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PREFIX_438025#137483)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_PREFIX_438025#137483)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NOMPAT_438026#137453)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NOMPAT_438026#137453)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PNOPAT_438027#137479)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_PNOPAT_438027#137479)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NJFPAT_438028#137450)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NJFPAT_438028#137450)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATNAI_438029#137417)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_DATNAI_438029#137417)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATNAISS_438030#137416)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_DATNAISS_438030#137416)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_SEXE_438031#137486)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_SEXE_438031#137486)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_438032#137462)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_438032#137462)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_SIGMA_438033#137487)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_SIGMA_438033#137487)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VERROU_438034#137503)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_VERROU_438034#137503)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_POIDS_438035#137480)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_POIDS_438035#137480)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INDCEN_438036#137434)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_INDCEN_438036#137434)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMSS_438037#137470)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMSS_438037#137470)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ANTECE_438038#137379)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_ANTECE_438038#137379)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_1_438039#137373)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_1_438039#137373)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_2_438040#137375)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_2_438040#137375)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPOS_438041#137390)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPOS_438041#137390)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VILLE_438042#137506)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_VILLE_438042#137506)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PAYS_438043#137473)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_PAYS_438043#137473)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMCAI_438044#137455)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMCAI_438044#137455)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMMUT_438045#137461)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMMUT_438045#137461)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMCHA_438046#137457)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMCHA_438046#137457)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TELPRI_438047#137496)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_TELPRI_438047#137496)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TELBUR_438048#137494)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_TELBUR_438048#137494)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TELPOR_438049#137495)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_TELPOR_438049#137495)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FAX_438050#137422)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_FAX_438050#137422)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PREFI2_438051#137482)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_PREFI2_438051#137482)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NOMASS_438052#137451)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NOMASS_438052#137451)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PNOASS_438053#137477)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_PNOASS_438053#137477)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NJFASS_438054#137449)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NJFASS_438054#137449)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATASS_438055#137408)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_DATASS_438055#137408)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_1A_438056#137372)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_1A_438056#137372)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_2A_438057#137374)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_2A_438057#137374)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPOA_438058#137388)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPOA_438058#137388)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VILLEA_438059#137504)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_VILLEA_438059#137504)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODMED_438060#137385)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_CODMED_438060#137385)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATCSS_438061#137409)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_DATCSS_438061#137409)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATF_D_438062#137412)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_DATF_D_438062#137412)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DAT100_438063#137404)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_DAT100_438063#137404)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMSIR_438064#137468)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMSIR_438064#137468)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMSSA_438065#137469)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMSSA_438065#137469)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODSER_438066#137394)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_CODSER_438066#137394)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_RNGNAI_438067#137485)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_RNGNAI_438067#137485)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NATASS_438068#137446)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NATASS_438068#137446)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMACC_438069#137454)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMACC_438069#137454)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATACC_438070#137405)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_DATACC_438070#137405)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TYPEXO_438071#137502)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_TYPEXO_438071#137502)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATMAJ_438072#137415)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_DATMAJ_438072#137415)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODUTI_438073#137398)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_CODUTI_438073#137398)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLCMU_438074#137425)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_FLCMU_438074#137425)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_QUALSS_438075#137484)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_QUALSS_438075#137484)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODREF_438076#137391)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_CODREF_438076#137391)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODREGAT_438077#137392)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_CODREGAT_438077#137392)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODCAIAT_438078#137381)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_CODCAIAT_438078#137381)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INDVITAL_438079#137436)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_INDVITAL_438079#137436)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CONMUT_438080#137401)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_CONMUT_438080#137401)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADHMUT_438081#137371)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_ADHMUT_438081#137371)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_GARMUT_438082#137431)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_GARMUT_438082#137431)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_ORI_438083#137463)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_ORI_438083#137463)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODROUT_438084#137393)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_CODROUT_438084#137393)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DOMAINE_438085#137420)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_DOMAINE_438085#137420)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INDTRAI_438086#137435)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_INDTRAI_438086#137435)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_IDHOTE_438087#137433)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_IDHOTE_438087#137433)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODSTS_438088#137396)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_CODSTS_438088#137396)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NIRIND_438089#137448)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NIRIND_438089#137448)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLDCD_438090#137426)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_FLDCD_438090#137426)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLPHOTO_438091#137430)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_FLPHOTO_438091#137430)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODMTR_438092#137386)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_CODMTR_438092#137386)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_3_438093#137377)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_3_438093#137377)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PAYS_ISO_438094#137474)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_PAYS_ISO_438094#137474)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_3A_438095#137376)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_3A_438095#137376)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_POIDS_MAJ_438096#137481)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_POIDS_MAJ_438096#137481)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODGESTION_438097#137383)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_CODGESTION_438097#137383)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ART115_438098#137380)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_ART115_438098#137380)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TAILLE_438099#137491)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_TAILLE_438099#137491)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TAILLE_MAJ_438100#137492)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_TAILLE_MAJ_438100#137492)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODETAB_PROD_438101#137382)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_CODETAB_PROD_438101#137382)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODSIT_PROD_438102#137395)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_CODSIT_PROD_438102#137395)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMDOS_PROD_438103#137460)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMDOS_PROD_438103#137460)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_PROD_438104#137466)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_PROD_438104#137466)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_ORI_P_438105#137465)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_ORI_P_438105#137465)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_438106#137439)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_438106#137439)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_TYPE_438107#137443)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_TYPE_438107#137443)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_DATE_438108#137440)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_DATE_438108#137440)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_SOURCE_438109#137442)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_SOURCE_438109#137442)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_STADMP_438110#137488)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_STADMP_438110#137488)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATDMP_438111#137411)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_DATDMP_438111#137411)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ALARMES_438112#137378)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_ALARMES_438112#137378)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_EMAIL_438113#137421)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_EMAIL_438113#137421)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CONSENT_SMS_438114#137402)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_CONSENT_SMS_438114#137402)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DAT_CONSENT__438115#137418)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_DAT_CONSENT__438115#137418)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATDCD_438116#137410)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_DATDCD_438116#137410)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLHLIM_438117#137429)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_FLHLIM_438117#137429)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATHLIM_438118#137414)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_DATHLIM_438118#137414)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPERSHLIM_438119#137387)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPERSHLIM_438119#137387)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLDIFF_438120#137427)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_FLDIFF_438120#137427)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_LISDEST_438121#137445)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_LISDEST_438121#137445)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_LANGUE_438122#137444)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_LANGUE_438122#137444)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMCAI_FT_438123#137456)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMCAI_FT_438123#137456)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODTARIFAMC_438124#137397)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_CODTARIFAMC_438124#137397)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLGRVE_438125#137428)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_FLGRVE_438125#137428)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLADRI_438126#137423)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_FLADRI_438126#137423)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATADRI_438127#137406)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_DATADRI_438127#137406)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATF_MUT_438128#137413)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_DATF_MUT_438128#137413)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_COMFAC_438129#137399)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_COMFAC_438129#137399)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMDOS_CLOUD_438130#137459)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMDOS_CLOUD_438130#137459)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NATION_438131#137447)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NATION_438131#137447)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TITRE_438132#137499)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_TITRE_438132#137499)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TITRE_ASS_438133#137500)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_TITRE_ASS_438133#137500)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TIQ_HISTOXML_438134#137497)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_TIQ_HISTOXML_438134#137497)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TIQ_PNOLISTE_438135#137498)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_TIQ_PNOLISTE_438135#137498)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPOSNAI_438136#137389)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPOSNAI_438136#137389)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INSI_438137#137437)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_INSI_438137#137437)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INSI_OID_438138#137438)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_INSI_OID_438138#137438)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TYPCONV_438139#137501)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_TYPCONV_438139#137501)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CRISEC_438140#137403)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_CRISEC_438140#137403)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_OPEREG_438141#137472)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_OPEREG_438141#137472)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLANNUAMC_438142#137424)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_FLANNUAMC_438142#137424)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_STAIPP_438143#137489)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_STAIPP_438143#137489)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PNONAI_438144#137478)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_PNONAI_438144#137478)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODINSEENAI_438145#137384)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_CODINSEENAI_438145#137384)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VILLENAI_438146#137505)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_VILLENAI_438146#137505)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PIECE_IDENT__438147#137476)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_PIECE_IDENT__438147#137476)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DAT_STAIPP_438148#137419)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_DAT_STAIPP_438148#137419)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATAPCV_438149#137407)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_DATAPCV_438149#137407)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUM_APCV_438150#137471)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NUM_APCV_438150#137471)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_HEUAPCV_438151#137432)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_HEUAPCV_438151#137432)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_SEC_438152#137467)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_SEC_438152#137467)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_HEURE_438153#137441)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_HEURE_438153#137441)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PERSAPREV_438154#137475)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_PERSAPREV_438154#137475)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TARIF_438155#137493)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_TARIF_438155#137493)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NOMHL7_438156#137452)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NOMHL7_438156#137452)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_ORI_O_438157#137464)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_ORI_O_438157#137464)), ) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_COMMENT_438158#137400)), )) THEN false ELSE Contains(str_remove_accent(upper(AT_COMMENT_438158#137400)), ) END)

(3) Project
Output: []
Input [136]: [AT_ADHMUT_438081#137371, AT_ADR_1A_438056#137372, AT_ADR_1_438039#137373, AT_ADR_2A_438057#137374, AT_ADR_2_438040#137375, AT_ADR_3A_438095#137376, AT_ADR_3_438093#137377, AT_ALARMES_438112#137378, AT_ANTECE_438038#137379, AT_ART115_438098#137380, AT_CODCAIAT_438078#137381, AT_CODETAB_PROD_438101#137382, AT_CODGESTION_438097#137383, AT_CODINSEENAI_438145#137384, AT_CODMED_438060#137385, AT_CODMTR_438092#137386, AT_CODPERSHLIM_438119#137387, AT_CODPOA_438058#137388, AT_CODPOSNAI_438136#137389, AT_CODPOS_438041#137390, AT_CODREF_438076#137391, AT_CODREGAT_438077#137392, AT_CODROUT_438084#137393, AT_CODSER_438066#137394, AT_CODSIT_PROD_438102#137395, AT_CODSTS_438088#137396, AT_CODTARIFAMC_438124#137397, AT_CODUTI_438073#137398, AT_COMFAC_438129#137399, AT_COMMENT_438158#137400, AT_CONMUT_438080#137401, AT_CONSENT_SMS_438114#137402, AT_CRISEC_438140#137403, AT_DAT100_438063#137404, AT_DATACC_438070#137405, AT_DATADRI_438127#137406, AT_DATAPCV_438149#137407, AT_DATASS_438055#137408, AT_DATCSS_438061#137409, AT_DATDCD_438116#137410, AT_DATDMP_438111#137411, AT_DATF_D_438062#137412, AT_DATF_MUT_438128#137413, AT_DATHLIM_438118#137414, AT_DATMAJ_438072#137415, AT_DATNAISS_438030#137416, AT_DATNAI_438029#137417, AT_DAT_CONSENT__438115#137418, AT_DAT_STAIPP_438148#137419, AT_DOMAINE_438085#137420, AT_EMAIL_438113#137421, AT_FAX_438050#137422, AT_FLADRI_438126#137423, AT_FLANNUAMC_438142#137424, AT_FLCMU_438074#137425, AT_FLDCD_438090#137426, AT_FLDIFF_438120#137427, AT_FLGRVE_438125#137428, AT_FLHLIM_438117#137429, AT_FLPHOTO_438091#137430, AT_GARMUT_438082#137431, AT_HEUAPCV_438151#137432, AT_IDHOTE_438087#137433, AT_INDCEN_438036#137434, AT_INDTRAI_438086#137435, AT_INDVITAL_438079#137436, AT_INSI_438137#137437, AT_INSI_OID_438138#137438, AT_INS_438106#137439, AT_INS_DATE_438108#137440, AT_INS_HEURE_438153#137441, AT_INS_SOURCE_438109#137442, AT_INS_TYPE_438107#137443, AT_LANGUE_438122#137444, AT_LISDEST_438121#137445, AT_NATASS_438068#137446, AT_NATION_438131#137447, AT_NIRIND_438089#137448, AT_NJFASS_438054#137449, AT_NJFPAT_438028#137450, AT_NOMASS_438052#137451, AT_NOMHL7_438156#137452, AT_NOMPAT_438026#137453, AT_NUMACC_438069#137454, AT_NUMCAI_438044#137455, AT_NUMCAI_FT_438123#137456, AT_NUMCHA_438046#137457, AT_NUMDOS_438023#137458, AT_NUMDOS_CLOUD_438130#137459, AT_NUMDOS_PROD_438103#137460, AT_NUMMUT_438045#137461, AT_NUMPER_438032#137462, AT_NUMPER_ORI_438083#137463, AT_NUMPER_ORI_O_438157#137464, AT_NUMPER_ORI_P_438105#137465, AT_NUMPER_PROD_438104#137466, AT_NUMPER_SEC_438152#137467, AT_NUMSIR_438064#137468, AT_NUMSSA_438065#137469, AT_NUMSS_438037#137470, AT_NUM_APCV_438150#137471, AT_OPEREG_438141#137472, AT_PAYS_438043#137473, AT_PAYS_ISO_438094#137474, AT_PERSAPREV_438154#137475, AT_PIECE_IDENT__438147#137476, AT_PNOASS_438053#137477, AT_PNONAI_438144#137478, AT_PNOPAT_438027#137479, AT_POIDS_438035#137480, AT_POIDS_MAJ_438096#137481, AT_PREFI2_438051#137482, AT_PREFIX_438025#137483, AT_QUALSS_438075#137484, AT_RNGNAI_438067#137485, AT_SEXE_438031#137486, AT_SIGMA_438033#137487, AT_STADMP_438110#137488, AT_STAIPP_438143#137489, AT_STAPAT_438024#137490, AT_TAILLE_438099#137491, AT_TAILLE_MAJ_438100#137492, AT_TARIF_438155#137493, AT_TELBUR_438048#137494, AT_TELPOR_438049#137495, AT_TELPRI_438047#137496, AT_TIQ_HISTOXML_438134#137497, AT_TIQ_PNOLISTE_438135#137498, AT_TITRE_438132#137499, AT_TITRE_ASS_438133#137500, AT_TYPCONV_438139#137501, AT_TYPEXO_438071#137502, AT_VERROU_438034#137503, AT_VILLEA_438059#137504, AT_VILLENAI_438146#137505, AT_VILLE_438042#137506]

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

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

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

(7) HashAggregate [codegen id : 2]
Input [1]: [count#142528L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#139339L]
Results [1]: [count(1)#139339L AS COL_1a5c450f-6b78-4fe0-9df8-1f7b961cd545#139341L]

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

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

(10) HashAggregate
Input [1]: [count#142528L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#139339L]
Results [1]: [count(1)#139339L AS COL_1a5c450f-6b78-4fe0-9df8-1f7b961cd545#139341L]

(11) AdaptiveSparkPlan
Output [1]: [COL_1a5c450f-6b78-4fe0-9df8-1f7b961cd545#139341L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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