hdh-spark-job - Details for Query 763

Submitted Time: 2026/10/21 21:36:59
Duration: 1 s
Succeeded Jobs: 764 767

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: 1.0 s"; 5 [labelType="html" label="HashAggregate time in aggregation build: 1.0 s number of output rows: 1"]; } 6 [labelType="html" label=" Project "]; 7 [labelType="html" label="Filter number of output rows: 1"]; 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=15822]

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

WholeStageCodegen (1)

Project

Filter (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMDOS_438023#170543)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMDOS_438023#170543)), A63000893163) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_STAPAT_438024#170575)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_STAPAT_438024#170575)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PREFIX_438025#170568)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PREFIX_438025#170568)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NOMPAT_438026#170538)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NOMPAT_438026#170538)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PNOPAT_438027#170564)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PNOPAT_438027#170564)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NJFPAT_438028#170535)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NJFPAT_438028#170535)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATNAI_438029#170502)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATNAI_438029#170502)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATNAISS_438030#170501)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATNAISS_438030#170501)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_SEXE_438031#170571)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_SEXE_438031#170571)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_438032#170547)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_438032#170547)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_SIGMA_438033#170572)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_SIGMA_438033#170572)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VERROU_438034#170588)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_VERROU_438034#170588)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_POIDS_438035#170565)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_POIDS_438035#170565)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INDCEN_438036#170519)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INDCEN_438036#170519)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMSS_438037#170555)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMSS_438037#170555)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ANTECE_438038#170464)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ANTECE_438038#170464)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_1_438039#170458)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_1_438039#170458)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_2_438040#170460)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_2_438040#170460)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPOS_438041#170475)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPOS_438041#170475)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VILLE_438042#170591)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_VILLE_438042#170591)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PAYS_438043#170558)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PAYS_438043#170558)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMCAI_438044#170540)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMCAI_438044#170540)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMMUT_438045#170546)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMMUT_438045#170546)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMCHA_438046#170542)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMCHA_438046#170542)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TELPRI_438047#170581)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TELPRI_438047#170581)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TELBUR_438048#170579)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TELBUR_438048#170579)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TELPOR_438049#170580)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TELPOR_438049#170580)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FAX_438050#170507)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FAX_438050#170507)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PREFI2_438051#170567)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PREFI2_438051#170567)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NOMASS_438052#170536)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NOMASS_438052#170536)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PNOASS_438053#170562)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PNOASS_438053#170562)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NJFASS_438054#170534)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NJFASS_438054#170534)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATASS_438055#170493)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATASS_438055#170493)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_1A_438056#170457)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_1A_438056#170457)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_2A_438057#170459)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_2A_438057#170459)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPOA_438058#170473)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPOA_438058#170473)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VILLEA_438059#170589)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_VILLEA_438059#170589)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODMED_438060#170470)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODMED_438060#170470)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATCSS_438061#170494)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATCSS_438061#170494)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATF_D_438062#170497)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATF_D_438062#170497)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DAT100_438063#170489)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DAT100_438063#170489)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMSIR_438064#170553)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMSIR_438064#170553)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMSSA_438065#170554)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMSSA_438065#170554)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODSER_438066#170479)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODSER_438066#170479)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_RNGNAI_438067#170570)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_RNGNAI_438067#170570)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NATASS_438068#170531)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NATASS_438068#170531)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMACC_438069#170539)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMACC_438069#170539)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATACC_438070#170490)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATACC_438070#170490)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TYPEXO_438071#170587)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TYPEXO_438071#170587)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATMAJ_438072#170500)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATMAJ_438072#170500)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODUTI_438073#170483)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODUTI_438073#170483)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLCMU_438074#170510)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLCMU_438074#170510)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_QUALSS_438075#170569)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_QUALSS_438075#170569)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODREF_438076#170476)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODREF_438076#170476)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODREGAT_438077#170477)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODREGAT_438077#170477)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODCAIAT_438078#170466)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODCAIAT_438078#170466)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INDVITAL_438079#170521)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INDVITAL_438079#170521)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CONMUT_438080#170486)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CONMUT_438080#170486)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADHMUT_438081#170456)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADHMUT_438081#170456)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_GARMUT_438082#170516)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_GARMUT_438082#170516)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_ORI_438083#170548)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_ORI_438083#170548)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODROUT_438084#170478)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODROUT_438084#170478)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DOMAINE_438085#170505)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DOMAINE_438085#170505)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INDTRAI_438086#170520)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INDTRAI_438086#170520)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_IDHOTE_438087#170518)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_IDHOTE_438087#170518)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODSTS_438088#170481)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODSTS_438088#170481)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NIRIND_438089#170533)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NIRIND_438089#170533)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLDCD_438090#170511)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLDCD_438090#170511)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLPHOTO_438091#170515)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLPHOTO_438091#170515)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODMTR_438092#170471)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODMTR_438092#170471)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_3_438093#170462)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_3_438093#170462)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PAYS_ISO_438094#170559)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PAYS_ISO_438094#170559)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_3A_438095#170461)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_3A_438095#170461)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_POIDS_MAJ_438096#170566)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_POIDS_MAJ_438096#170566)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODGESTION_438097#170468)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODGESTION_438097#170468)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ART115_438098#170465)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ART115_438098#170465)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TAILLE_438099#170576)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TAILLE_438099#170576)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TAILLE_MAJ_438100#170577)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TAILLE_MAJ_438100#170577)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODETAB_PROD_438101#170467)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODETAB_PROD_438101#170467)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODSIT_PROD_438102#170480)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODSIT_PROD_438102#170480)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMDOS_PROD_438103#170545)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMDOS_PROD_438103#170545)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_PROD_438104#170551)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_PROD_438104#170551)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_ORI_P_438105#170550)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_ORI_P_438105#170550)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_438106#170524)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_438106#170524)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_TYPE_438107#170528)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_TYPE_438107#170528)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_DATE_438108#170525)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_DATE_438108#170525)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_SOURCE_438109#170527)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_SOURCE_438109#170527)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_STADMP_438110#170573)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_STADMP_438110#170573)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATDMP_438111#170496)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATDMP_438111#170496)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ALARMES_438112#170463)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ALARMES_438112#170463)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_EMAIL_438113#170506)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_EMAIL_438113#170506)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CONSENT_SMS_438114#170487)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CONSENT_SMS_438114#170487)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DAT_CONSENT__438115#170503)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DAT_CONSENT__438115#170503)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATDCD_438116#170495)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATDCD_438116#170495)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLHLIM_438117#170514)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLHLIM_438117#170514)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATHLIM_438118#170499)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATHLIM_438118#170499)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPERSHLIM_438119#170472)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPERSHLIM_438119#170472)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLDIFF_438120#170512)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLDIFF_438120#170512)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_LISDEST_438121#170530)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_LISDEST_438121#170530)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_LANGUE_438122#170529)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_LANGUE_438122#170529)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMCAI_FT_438123#170541)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMCAI_FT_438123#170541)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODTARIFAMC_438124#170482)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODTARIFAMC_438124#170482)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLGRVE_438125#170513)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLGRVE_438125#170513)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLADRI_438126#170508)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLADRI_438126#170508)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATADRI_438127#170491)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATADRI_438127#170491)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATF_MUT_438128#170498)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATF_MUT_438128#170498)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_COMFAC_438129#170484)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_COMFAC_438129#170484)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMDOS_CLOUD_438130#170544)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMDOS_CLOUD_438130#170544)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NATION_438131#170532)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NATION_438131#170532)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TITRE_438132#170584)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TITRE_438132#170584)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TITRE_ASS_438133#170585)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TITRE_ASS_438133#170585)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TIQ_HISTOXML_438134#170582)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TIQ_HISTOXML_438134#170582)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TIQ_PNOLISTE_438135#170583)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TIQ_PNOLISTE_438135#170583)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPOSNAI_438136#170474)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPOSNAI_438136#170474)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INSI_438137#170522)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INSI_438137#170522)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INSI_OID_438138#170523)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INSI_OID_438138#170523)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TYPCONV_438139#170586)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TYPCONV_438139#170586)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CRISEC_438140#170488)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CRISEC_438140#170488)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_OPEREG_438141#170557)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_OPEREG_438141#170557)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLANNUAMC_438142#170509)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLANNUAMC_438142#170509)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_STAIPP_438143#170574)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_STAIPP_438143#170574)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PNONAI_438144#170563)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PNONAI_438144#170563)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODINSEENAI_438145#170469)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODINSEENAI_438145#170469)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VILLENAI_438146#170590)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_VILLENAI_438146#170590)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PIECE_IDENT__438147#170561)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PIECE_IDENT__438147#170561)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DAT_STAIPP_438148#170504)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DAT_STAIPP_438148#170504)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATAPCV_438149#170492)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATAPCV_438149#170492)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUM_APCV_438150#170556)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUM_APCV_438150#170556)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_HEUAPCV_438151#170517)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_HEUAPCV_438151#170517)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_SEC_438152#170552)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_SEC_438152#170552)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_HEURE_438153#170526)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_HEURE_438153#170526)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PERSAPREV_438154#170560)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PERSAPREV_438154#170560)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TARIF_438155#170578)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TARIF_438155#170578)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NOMHL7_438156#170537)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NOMHL7_438156#170537)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_ORI_O_438157#170549)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_ORI_O_438157#170549)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_COMMENT_438158#170485)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_COMMENT_438158#170485)), A63000893163) END)

FileScan parquet [AT_ADHMUT_438081#170456,AT_ADR_1A_438056#170457,AT_ADR_1_438039#170458,AT_ADR_2A_438057#170459,AT_ADR_2_438040#170460,AT_ADR_3A_438095#170461,AT_ADR_3_438093#170462,AT_ALARMES_438112#170463,AT_ANTECE_438038#170464,AT_ART115_438098#170465,AT_CODCAIAT_438078#170466,AT_CODETAB_PROD_438101#170467,AT_CODGESTION_438097#170468,AT_CODINSEENAI_438145#170469,AT_CODMED_438060#170470,AT_CODMTR_438092#170471,AT_CODPERSHLIM_438119#170472,AT_CODPOA_438058#170473,AT_CODPOSNAI_438136#170474,AT_CODPOS_438041#170475,AT_CODREF_438076#170476,AT_CODREGAT_438077#170477,AT_CODROUT_438084#170478,AT_CODSER_438066#170479,... 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#170456, AT_ADR_1A_438056#170457, AT_ADR_1_438039#170458, AT_ADR_2A_438057#170459, AT_ADR_2_438040#170460, AT_ADR_3A_438095#170461, AT_ADR_3_438093#170462, AT_ALARMES_438112#170463, AT_ANTECE_438038#170464, AT_ART115_438098#170465, AT_CODCAIAT_438078#170466, AT_CODETAB_PROD_438101#170467, AT_CODGESTION_438097#170468, AT_CODINSEENAI_438145#170469, AT_CODMED_438060#170470, AT_CODMTR_438092#170471, AT_CODPERSHLIM_438119#170472, AT_CODPOA_438058#170473, AT_CODPOSNAI_438136#170474, AT_CODPOS_438041#170475, AT_CODREF_438076#170476, AT_CODREGAT_438077#170477, AT_CODROUT_438084#170478, AT_CODSER_438066#170479, AT_CODSIT_PROD_438102#170480, AT_CODSTS_438088#170481, AT_CODTARIFAMC_438124#170482, AT_CODUTI_438073#170483, AT_COMFAC_438129#170484, AT_COMMENT_438158#170485, AT_CONMUT_438080#170486, AT_CONSENT_SMS_438114#170487, AT_CRISEC_438140#170488, AT_DAT100_438063#170489, AT_DATACC_438070#170490, AT_DATADRI_438127#170491, AT_DATAPCV_438149#170492, AT_DATASS_438055#170493, AT_DATCSS_438061#170494, AT_DATDCD_438116#170495, AT_DATDMP_438111#170496, AT_DATF_D_438062#170497, AT_DATF_MUT_438128#170498, AT_DATHLIM_438118#170499, AT_DATMAJ_438072#170500, AT_DATNAISS_438030#170501, AT_DATNAI_438029#170502, AT_DAT_CONSENT__438115#170503, AT_DAT_STAIPP_438148#170504, AT_DOMAINE_438085#170505, AT_EMAIL_438113#170506, AT_FAX_438050#170507, AT_FLADRI_438126#170508, AT_FLANNUAMC_438142#170509, AT_FLCMU_438074#170510, AT_FLDCD_438090#170511, AT_FLDIFF_438120#170512, AT_FLGRVE_438125#170513, AT_FLHLIM_438117#170514, AT_FLPHOTO_438091#170515, AT_GARMUT_438082#170516, AT_HEUAPCV_438151#170517, AT_IDHOTE_438087#170518, AT_INDCEN_438036#170519, AT_INDTRAI_438086#170520, AT_INDVITAL_438079#170521, AT_INSI_438137#170522, AT_INSI_OID_438138#170523, AT_INS_438106#170524, AT_INS_DATE_438108#170525, AT_INS_HEURE_438153#170526, AT_INS_SOURCE_438109#170527, AT_INS_TYPE_438107#170528, AT_LANGUE_438122#170529, AT_LISDEST_438121#170530, AT_NATASS_438068#170531, AT_NATION_438131#170532, AT_NIRIND_438089#170533, AT_NJFASS_438054#170534, AT_NJFPAT_438028#170535, AT_NOMASS_438052#170536, AT_NOMHL7_438156#170537, AT_NOMPAT_438026#170538, AT_NUMACC_438069#170539, AT_NUMCAI_438044#170540, AT_NUMCAI_FT_438123#170541, AT_NUMCHA_438046#170542, AT_NUMDOS_438023#170543, AT_NUMDOS_CLOUD_438130#170544, AT_NUMDOS_PROD_438103#170545, AT_NUMMUT_438045#170546, AT_NUMPER_438032#170547, AT_NUMPER_ORI_438083#170548, AT_NUMPER_ORI_O_438157#170549, AT_NUMPER_ORI_P_438105#170550, AT_NUMPER_PROD_438104#170551, AT_NUMPER_SEC_438152#170552, AT_NUMSIR_438064#170553, AT_NUMSSA_438065#170554, AT_NUMSS_438037#170555, AT_NUM_APCV_438150#170556, AT_OPEREG_438141#170557, AT_PAYS_438043#170558, AT_PAYS_ISO_438094#170559, AT_PERSAPREV_438154#170560, AT_PIECE_IDENT__438147#170561, AT_PNOASS_438053#170562, AT_PNONAI_438144#170563, AT_PNOPAT_438027#170564, AT_POIDS_438035#170565, AT_POIDS_MAJ_438096#170566, AT_PREFI2_438051#170567, AT_PREFIX_438025#170568, AT_QUALSS_438075#170569, AT_RNGNAI_438067#170570, AT_SEXE_438031#170571, AT_SIGMA_438033#170572, AT_STADMP_438110#170573, AT_STAIPP_438143#170574, AT_STAPAT_438024#170575, AT_TAILLE_438099#170576, AT_TAILLE_MAJ_438100#170577, AT_TARIF_438155#170578, AT_TELBUR_438048#170579, AT_TELPOR_438049#170580, AT_TELPRI_438047#170581, AT_TIQ_HISTOXML_438134#170582, AT_TIQ_PNOLISTE_438135#170583, AT_TITRE_438132#170584, AT_TITRE_ASS_438133#170585, AT_TYPCONV_438139#170586, AT_TYPEXO_438071#170587, AT_VERROU_438034#170588, AT_VILLEA_438059#170589, AT_VILLENAI_438146#170590, AT_VILLE_438042#170591]
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#170456, AT_ADR_1A_438056#170457, AT_ADR_1_438039#170458, AT_ADR_2A_438057#170459, AT_ADR_2_438040#170460, AT_ADR_3A_438095#170461, AT_ADR_3_438093#170462, AT_ALARMES_438112#170463, AT_ANTECE_438038#170464, AT_ART115_438098#170465, AT_CODCAIAT_438078#170466, AT_CODETAB_PROD_438101#170467, AT_CODGESTION_438097#170468, AT_CODINSEENAI_438145#170469, AT_CODMED_438060#170470, AT_CODMTR_438092#170471, AT_CODPERSHLIM_438119#170472, AT_CODPOA_438058#170473, AT_CODPOSNAI_438136#170474, AT_CODPOS_438041#170475, AT_CODREF_438076#170476, AT_CODREGAT_438077#170477, AT_CODROUT_438084#170478, AT_CODSER_438066#170479, AT_CODSIT_PROD_438102#170480, AT_CODSTS_438088#170481, AT_CODTARIFAMC_438124#170482, AT_CODUTI_438073#170483, AT_COMFAC_438129#170484, AT_COMMENT_438158#170485, AT_CONMUT_438080#170486, AT_CONSENT_SMS_438114#170487, AT_CRISEC_438140#170488, AT_DAT100_438063#170489, AT_DATACC_438070#170490, AT_DATADRI_438127#170491, AT_DATAPCV_438149#170492, AT_DATASS_438055#170493, AT_DATCSS_438061#170494, AT_DATDCD_438116#170495, AT_DATDMP_438111#170496, AT_DATF_D_438062#170497, AT_DATF_MUT_438128#170498, AT_DATHLIM_438118#170499, AT_DATMAJ_438072#170500, AT_DATNAISS_438030#170501, AT_DATNAI_438029#170502, AT_DAT_CONSENT__438115#170503, AT_DAT_STAIPP_438148#170504, AT_DOMAINE_438085#170505, AT_EMAIL_438113#170506, AT_FAX_438050#170507, AT_FLADRI_438126#170508, AT_FLANNUAMC_438142#170509, AT_FLCMU_438074#170510, AT_FLDCD_438090#170511, AT_FLDIFF_438120#170512, AT_FLGRVE_438125#170513, AT_FLHLIM_438117#170514, AT_FLPHOTO_438091#170515, AT_GARMUT_438082#170516, AT_HEUAPCV_438151#170517, AT_IDHOTE_438087#170518, AT_INDCEN_438036#170519, AT_INDTRAI_438086#170520, AT_INDVITAL_438079#170521, AT_INSI_438137#170522, AT_INSI_OID_438138#170523, AT_INS_438106#170524, AT_INS_DATE_438108#170525, AT_INS_HEURE_438153#170526, AT_INS_SOURCE_438109#170527, AT_INS_TYPE_438107#170528, AT_LANGUE_438122#170529, AT_LISDEST_438121#170530, AT_NATASS_438068#170531, AT_NATION_438131#170532, AT_NIRIND_438089#170533, AT_NJFASS_438054#170534, AT_NJFPAT_438028#170535, AT_NOMASS_438052#170536, AT_NOMHL7_438156#170537, AT_NOMPAT_438026#170538, AT_NUMACC_438069#170539, AT_NUMCAI_438044#170540, AT_NUMCAI_FT_438123#170541, AT_NUMCHA_438046#170542, AT_NUMDOS_438023#170543, AT_NUMDOS_CLOUD_438130#170544, AT_NUMDOS_PROD_438103#170545, AT_NUMMUT_438045#170546, AT_NUMPER_438032#170547, AT_NUMPER_ORI_438083#170548, AT_NUMPER_ORI_O_438157#170549, AT_NUMPER_ORI_P_438105#170550, AT_NUMPER_PROD_438104#170551, AT_NUMPER_SEC_438152#170552, AT_NUMSIR_438064#170553, AT_NUMSSA_438065#170554, AT_NUMSS_438037#170555, AT_NUM_APCV_438150#170556, AT_OPEREG_438141#170557, AT_PAYS_438043#170558, AT_PAYS_ISO_438094#170559, AT_PERSAPREV_438154#170560, AT_PIECE_IDENT__438147#170561, AT_PNOASS_438053#170562, AT_PNONAI_438144#170563, AT_PNOPAT_438027#170564, AT_POIDS_438035#170565, AT_POIDS_MAJ_438096#170566, AT_PREFI2_438051#170567, AT_PREFIX_438025#170568, AT_QUALSS_438075#170569, AT_RNGNAI_438067#170570, AT_SEXE_438031#170571, AT_SIGMA_438033#170572, AT_STADMP_438110#170573, AT_STAIPP_438143#170574, AT_STAPAT_438024#170575, AT_TAILLE_438099#170576, AT_TAILLE_MAJ_438100#170577, AT_TARIF_438155#170578, AT_TELBUR_438048#170579, AT_TELPOR_438049#170580, AT_TELPRI_438047#170581, AT_TIQ_HISTOXML_438134#170582, AT_TIQ_PNOLISTE_438135#170583, AT_TITRE_438132#170584, AT_TITRE_ASS_438133#170585, AT_TYPCONV_438139#170586, AT_TYPEXO_438071#170587, AT_VERROU_438034#170588, AT_VILLEA_438059#170589, AT_VILLENAI_438146#170590, AT_VILLE_438042#170591]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMDOS_438023#170543)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMDOS_438023#170543)), A63000893163) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_STAPAT_438024#170575)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_STAPAT_438024#170575)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PREFIX_438025#170568)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PREFIX_438025#170568)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NOMPAT_438026#170538)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NOMPAT_438026#170538)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PNOPAT_438027#170564)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PNOPAT_438027#170564)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NJFPAT_438028#170535)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NJFPAT_438028#170535)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATNAI_438029#170502)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATNAI_438029#170502)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATNAISS_438030#170501)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATNAISS_438030#170501)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_SEXE_438031#170571)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_SEXE_438031#170571)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_438032#170547)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_438032#170547)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_SIGMA_438033#170572)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_SIGMA_438033#170572)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VERROU_438034#170588)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_VERROU_438034#170588)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_POIDS_438035#170565)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_POIDS_438035#170565)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INDCEN_438036#170519)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INDCEN_438036#170519)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMSS_438037#170555)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMSS_438037#170555)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ANTECE_438038#170464)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ANTECE_438038#170464)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_1_438039#170458)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_1_438039#170458)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_2_438040#170460)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_2_438040#170460)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPOS_438041#170475)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPOS_438041#170475)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VILLE_438042#170591)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_VILLE_438042#170591)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PAYS_438043#170558)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PAYS_438043#170558)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMCAI_438044#170540)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMCAI_438044#170540)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMMUT_438045#170546)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMMUT_438045#170546)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMCHA_438046#170542)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMCHA_438046#170542)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TELPRI_438047#170581)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TELPRI_438047#170581)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TELBUR_438048#170579)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TELBUR_438048#170579)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TELPOR_438049#170580)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TELPOR_438049#170580)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FAX_438050#170507)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FAX_438050#170507)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PREFI2_438051#170567)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PREFI2_438051#170567)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NOMASS_438052#170536)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NOMASS_438052#170536)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PNOASS_438053#170562)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PNOASS_438053#170562)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NJFASS_438054#170534)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NJFASS_438054#170534)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATASS_438055#170493)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATASS_438055#170493)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_1A_438056#170457)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_1A_438056#170457)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_2A_438057#170459)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_2A_438057#170459)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPOA_438058#170473)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPOA_438058#170473)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VILLEA_438059#170589)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_VILLEA_438059#170589)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODMED_438060#170470)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODMED_438060#170470)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATCSS_438061#170494)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATCSS_438061#170494)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATF_D_438062#170497)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATF_D_438062#170497)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DAT100_438063#170489)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DAT100_438063#170489)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMSIR_438064#170553)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMSIR_438064#170553)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMSSA_438065#170554)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMSSA_438065#170554)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODSER_438066#170479)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODSER_438066#170479)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_RNGNAI_438067#170570)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_RNGNAI_438067#170570)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NATASS_438068#170531)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NATASS_438068#170531)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMACC_438069#170539)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMACC_438069#170539)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATACC_438070#170490)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATACC_438070#170490)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TYPEXO_438071#170587)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TYPEXO_438071#170587)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATMAJ_438072#170500)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATMAJ_438072#170500)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODUTI_438073#170483)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODUTI_438073#170483)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLCMU_438074#170510)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLCMU_438074#170510)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_QUALSS_438075#170569)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_QUALSS_438075#170569)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODREF_438076#170476)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODREF_438076#170476)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODREGAT_438077#170477)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODREGAT_438077#170477)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODCAIAT_438078#170466)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODCAIAT_438078#170466)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INDVITAL_438079#170521)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INDVITAL_438079#170521)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CONMUT_438080#170486)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CONMUT_438080#170486)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADHMUT_438081#170456)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADHMUT_438081#170456)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_GARMUT_438082#170516)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_GARMUT_438082#170516)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_ORI_438083#170548)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_ORI_438083#170548)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODROUT_438084#170478)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODROUT_438084#170478)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DOMAINE_438085#170505)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DOMAINE_438085#170505)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INDTRAI_438086#170520)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INDTRAI_438086#170520)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_IDHOTE_438087#170518)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_IDHOTE_438087#170518)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODSTS_438088#170481)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODSTS_438088#170481)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NIRIND_438089#170533)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NIRIND_438089#170533)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLDCD_438090#170511)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLDCD_438090#170511)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLPHOTO_438091#170515)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLPHOTO_438091#170515)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODMTR_438092#170471)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODMTR_438092#170471)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_3_438093#170462)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_3_438093#170462)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PAYS_ISO_438094#170559)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PAYS_ISO_438094#170559)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_3A_438095#170461)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_3A_438095#170461)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_POIDS_MAJ_438096#170566)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_POIDS_MAJ_438096#170566)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODGESTION_438097#170468)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODGESTION_438097#170468)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ART115_438098#170465)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ART115_438098#170465)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TAILLE_438099#170576)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TAILLE_438099#170576)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TAILLE_MAJ_438100#170577)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TAILLE_MAJ_438100#170577)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODETAB_PROD_438101#170467)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODETAB_PROD_438101#170467)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODSIT_PROD_438102#170480)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODSIT_PROD_438102#170480)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMDOS_PROD_438103#170545)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMDOS_PROD_438103#170545)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_PROD_438104#170551)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_PROD_438104#170551)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_ORI_P_438105#170550)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_ORI_P_438105#170550)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_438106#170524)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_438106#170524)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_TYPE_438107#170528)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_TYPE_438107#170528)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_DATE_438108#170525)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_DATE_438108#170525)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_SOURCE_438109#170527)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_SOURCE_438109#170527)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_STADMP_438110#170573)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_STADMP_438110#170573)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATDMP_438111#170496)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATDMP_438111#170496)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ALARMES_438112#170463)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ALARMES_438112#170463)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_EMAIL_438113#170506)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_EMAIL_438113#170506)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CONSENT_SMS_438114#170487)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CONSENT_SMS_438114#170487)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DAT_CONSENT__438115#170503)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DAT_CONSENT__438115#170503)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATDCD_438116#170495)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATDCD_438116#170495)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLHLIM_438117#170514)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLHLIM_438117#170514)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATHLIM_438118#170499)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATHLIM_438118#170499)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPERSHLIM_438119#170472)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPERSHLIM_438119#170472)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLDIFF_438120#170512)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLDIFF_438120#170512)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_LISDEST_438121#170530)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_LISDEST_438121#170530)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_LANGUE_438122#170529)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_LANGUE_438122#170529)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMCAI_FT_438123#170541)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMCAI_FT_438123#170541)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODTARIFAMC_438124#170482)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODTARIFAMC_438124#170482)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLGRVE_438125#170513)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLGRVE_438125#170513)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLADRI_438126#170508)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLADRI_438126#170508)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATADRI_438127#170491)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATADRI_438127#170491)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATF_MUT_438128#170498)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATF_MUT_438128#170498)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_COMFAC_438129#170484)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_COMFAC_438129#170484)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMDOS_CLOUD_438130#170544)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMDOS_CLOUD_438130#170544)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NATION_438131#170532)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NATION_438131#170532)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TITRE_438132#170584)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TITRE_438132#170584)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TITRE_ASS_438133#170585)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TITRE_ASS_438133#170585)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TIQ_HISTOXML_438134#170582)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TIQ_HISTOXML_438134#170582)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TIQ_PNOLISTE_438135#170583)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TIQ_PNOLISTE_438135#170583)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPOSNAI_438136#170474)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPOSNAI_438136#170474)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INSI_438137#170522)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INSI_438137#170522)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INSI_OID_438138#170523)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INSI_OID_438138#170523)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TYPCONV_438139#170586)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TYPCONV_438139#170586)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CRISEC_438140#170488)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CRISEC_438140#170488)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_OPEREG_438141#170557)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_OPEREG_438141#170557)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLANNUAMC_438142#170509)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLANNUAMC_438142#170509)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_STAIPP_438143#170574)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_STAIPP_438143#170574)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PNONAI_438144#170563)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PNONAI_438144#170563)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODINSEENAI_438145#170469)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODINSEENAI_438145#170469)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VILLENAI_438146#170590)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_VILLENAI_438146#170590)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PIECE_IDENT__438147#170561)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PIECE_IDENT__438147#170561)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DAT_STAIPP_438148#170504)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DAT_STAIPP_438148#170504)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATAPCV_438149#170492)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATAPCV_438149#170492)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUM_APCV_438150#170556)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUM_APCV_438150#170556)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_HEUAPCV_438151#170517)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_HEUAPCV_438151#170517)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_SEC_438152#170552)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_SEC_438152#170552)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_HEURE_438153#170526)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_HEURE_438153#170526)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PERSAPREV_438154#170560)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PERSAPREV_438154#170560)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TARIF_438155#170578)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TARIF_438155#170578)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NOMHL7_438156#170537)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NOMHL7_438156#170537)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_ORI_O_438157#170549)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_ORI_O_438157#170549)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_COMMENT_438158#170485)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_COMMENT_438158#170485)), A63000893163) END)

(3) Project
Output: []
Input [136]: [AT_ADHMUT_438081#170456, AT_ADR_1A_438056#170457, AT_ADR_1_438039#170458, AT_ADR_2A_438057#170459, AT_ADR_2_438040#170460, AT_ADR_3A_438095#170461, AT_ADR_3_438093#170462, AT_ALARMES_438112#170463, AT_ANTECE_438038#170464, AT_ART115_438098#170465, AT_CODCAIAT_438078#170466, AT_CODETAB_PROD_438101#170467, AT_CODGESTION_438097#170468, AT_CODINSEENAI_438145#170469, AT_CODMED_438060#170470, AT_CODMTR_438092#170471, AT_CODPERSHLIM_438119#170472, AT_CODPOA_438058#170473, AT_CODPOSNAI_438136#170474, AT_CODPOS_438041#170475, AT_CODREF_438076#170476, AT_CODREGAT_438077#170477, AT_CODROUT_438084#170478, AT_CODSER_438066#170479, AT_CODSIT_PROD_438102#170480, AT_CODSTS_438088#170481, AT_CODTARIFAMC_438124#170482, AT_CODUTI_438073#170483, AT_COMFAC_438129#170484, AT_COMMENT_438158#170485, AT_CONMUT_438080#170486, AT_CONSENT_SMS_438114#170487, AT_CRISEC_438140#170488, AT_DAT100_438063#170489, AT_DATACC_438070#170490, AT_DATADRI_438127#170491, AT_DATAPCV_438149#170492, AT_DATASS_438055#170493, AT_DATCSS_438061#170494, AT_DATDCD_438116#170495, AT_DATDMP_438111#170496, AT_DATF_D_438062#170497, AT_DATF_MUT_438128#170498, AT_DATHLIM_438118#170499, AT_DATMAJ_438072#170500, AT_DATNAISS_438030#170501, AT_DATNAI_438029#170502, AT_DAT_CONSENT__438115#170503, AT_DAT_STAIPP_438148#170504, AT_DOMAINE_438085#170505, AT_EMAIL_438113#170506, AT_FAX_438050#170507, AT_FLADRI_438126#170508, AT_FLANNUAMC_438142#170509, AT_FLCMU_438074#170510, AT_FLDCD_438090#170511, AT_FLDIFF_438120#170512, AT_FLGRVE_438125#170513, AT_FLHLIM_438117#170514, AT_FLPHOTO_438091#170515, AT_GARMUT_438082#170516, AT_HEUAPCV_438151#170517, AT_IDHOTE_438087#170518, AT_INDCEN_438036#170519, AT_INDTRAI_438086#170520, AT_INDVITAL_438079#170521, AT_INSI_438137#170522, AT_INSI_OID_438138#170523, AT_INS_438106#170524, AT_INS_DATE_438108#170525, AT_INS_HEURE_438153#170526, AT_INS_SOURCE_438109#170527, AT_INS_TYPE_438107#170528, AT_LANGUE_438122#170529, AT_LISDEST_438121#170530, AT_NATASS_438068#170531, AT_NATION_438131#170532, AT_NIRIND_438089#170533, AT_NJFASS_438054#170534, AT_NJFPAT_438028#170535, AT_NOMASS_438052#170536, AT_NOMHL7_438156#170537, AT_NOMPAT_438026#170538, AT_NUMACC_438069#170539, AT_NUMCAI_438044#170540, AT_NUMCAI_FT_438123#170541, AT_NUMCHA_438046#170542, AT_NUMDOS_438023#170543, AT_NUMDOS_CLOUD_438130#170544, AT_NUMDOS_PROD_438103#170545, AT_NUMMUT_438045#170546, AT_NUMPER_438032#170547, AT_NUMPER_ORI_438083#170548, AT_NUMPER_ORI_O_438157#170549, AT_NUMPER_ORI_P_438105#170550, AT_NUMPER_PROD_438104#170551, AT_NUMPER_SEC_438152#170552, AT_NUMSIR_438064#170553, AT_NUMSSA_438065#170554, AT_NUMSS_438037#170555, AT_NUM_APCV_438150#170556, AT_OPEREG_438141#170557, AT_PAYS_438043#170558, AT_PAYS_ISO_438094#170559, AT_PERSAPREV_438154#170560, AT_PIECE_IDENT__438147#170561, AT_PNOASS_438053#170562, AT_PNONAI_438144#170563, AT_PNOPAT_438027#170564, AT_POIDS_438035#170565, AT_POIDS_MAJ_438096#170566, AT_PREFI2_438051#170567, AT_PREFIX_438025#170568, AT_QUALSS_438075#170569, AT_RNGNAI_438067#170570, AT_SEXE_438031#170571, AT_SIGMA_438033#170572, AT_STADMP_438110#170573, AT_STAIPP_438143#170574, AT_STAPAT_438024#170575, AT_TAILLE_438099#170576, AT_TAILLE_MAJ_438100#170577, AT_TARIF_438155#170578, AT_TELBUR_438048#170579, AT_TELPOR_438049#170580, AT_TELPRI_438047#170581, AT_TIQ_HISTOXML_438134#170582, AT_TIQ_PNOLISTE_438135#170583, AT_TITRE_438132#170584, AT_TITRE_ASS_438133#170585, AT_TYPCONV_438139#170586, AT_TYPEXO_438071#170587, AT_VERROU_438034#170588, AT_VILLEA_438059#170589, AT_VILLENAI_438146#170590, AT_VILLE_438042#170591]

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

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

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

(7) HashAggregate [codegen id : 2]
Input [1]: [count#172913L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#172909L]
Results [1]: [count(1)#172909L AS count#172910L]

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

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

(10) HashAggregate
Input [1]: [count#172913L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#172909L]
Results [1]: [count(1)#172909L AS count#172910L]

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

SQL / DataFrame Properties

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