hdh-spark-job - Details for Query 741

Submitted Time: 2026/10/21 21:36:48
Duration: 1 s
Succeeded Jobs: 731 735

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: 951 ms"; 5 [labelType="html" label="HashAggregate time in aggregation build: 950 ms 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=15323]

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

WholeStageCodegen (1)

Project

Filter (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMDOS_438023#160592)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMDOS_438023#160592)), A63000893163) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_STAPAT_438024#160624)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_STAPAT_438024#160624)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PREFIX_438025#160617)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PREFIX_438025#160617)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NOMPAT_438026#160587)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NOMPAT_438026#160587)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PNOPAT_438027#160613)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PNOPAT_438027#160613)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NJFPAT_438028#160584)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NJFPAT_438028#160584)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATNAI_438029#160551)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATNAI_438029#160551)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATNAISS_438030#160550)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATNAISS_438030#160550)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_SEXE_438031#160620)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_SEXE_438031#160620)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_438032#160596)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_438032#160596)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_SIGMA_438033#160621)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_SIGMA_438033#160621)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VERROU_438034#160637)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_VERROU_438034#160637)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_POIDS_438035#160614)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_POIDS_438035#160614)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INDCEN_438036#160568)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INDCEN_438036#160568)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMSS_438037#160604)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMSS_438037#160604)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ANTECE_438038#160513)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ANTECE_438038#160513)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_1_438039#160507)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_1_438039#160507)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_2_438040#160509)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_2_438040#160509)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPOS_438041#160524)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPOS_438041#160524)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VILLE_438042#160640)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_VILLE_438042#160640)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PAYS_438043#160607)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PAYS_438043#160607)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMCAI_438044#160589)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMCAI_438044#160589)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMMUT_438045#160595)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMMUT_438045#160595)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMCHA_438046#160591)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMCHA_438046#160591)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TELPRI_438047#160630)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TELPRI_438047#160630)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TELBUR_438048#160628)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TELBUR_438048#160628)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TELPOR_438049#160629)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TELPOR_438049#160629)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FAX_438050#160556)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FAX_438050#160556)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PREFI2_438051#160616)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PREFI2_438051#160616)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NOMASS_438052#160585)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NOMASS_438052#160585)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PNOASS_438053#160611)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PNOASS_438053#160611)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NJFASS_438054#160583)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NJFASS_438054#160583)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATASS_438055#160542)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATASS_438055#160542)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_1A_438056#160506)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_1A_438056#160506)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_2A_438057#160508)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_2A_438057#160508)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPOA_438058#160522)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPOA_438058#160522)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VILLEA_438059#160638)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_VILLEA_438059#160638)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODMED_438060#160519)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODMED_438060#160519)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATCSS_438061#160543)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATCSS_438061#160543)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATF_D_438062#160546)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATF_D_438062#160546)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DAT100_438063#160538)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DAT100_438063#160538)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMSIR_438064#160602)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMSIR_438064#160602)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMSSA_438065#160603)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMSSA_438065#160603)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODSER_438066#160528)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODSER_438066#160528)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_RNGNAI_438067#160619)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_RNGNAI_438067#160619)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NATASS_438068#160580)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NATASS_438068#160580)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMACC_438069#160588)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMACC_438069#160588)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATACC_438070#160539)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATACC_438070#160539)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TYPEXO_438071#160636)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TYPEXO_438071#160636)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATMAJ_438072#160549)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATMAJ_438072#160549)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODUTI_438073#160532)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODUTI_438073#160532)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLCMU_438074#160559)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLCMU_438074#160559)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_QUALSS_438075#160618)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_QUALSS_438075#160618)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODREF_438076#160525)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODREF_438076#160525)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODREGAT_438077#160526)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODREGAT_438077#160526)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODCAIAT_438078#160515)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODCAIAT_438078#160515)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INDVITAL_438079#160570)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INDVITAL_438079#160570)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CONMUT_438080#160535)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CONMUT_438080#160535)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADHMUT_438081#160505)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADHMUT_438081#160505)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_GARMUT_438082#160565)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_GARMUT_438082#160565)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_ORI_438083#160597)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_ORI_438083#160597)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODROUT_438084#160527)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODROUT_438084#160527)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DOMAINE_438085#160554)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DOMAINE_438085#160554)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INDTRAI_438086#160569)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INDTRAI_438086#160569)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_IDHOTE_438087#160567)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_IDHOTE_438087#160567)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODSTS_438088#160530)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODSTS_438088#160530)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NIRIND_438089#160582)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NIRIND_438089#160582)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLDCD_438090#160560)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLDCD_438090#160560)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLPHOTO_438091#160564)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLPHOTO_438091#160564)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODMTR_438092#160520)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODMTR_438092#160520)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_3_438093#160511)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_3_438093#160511)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PAYS_ISO_438094#160608)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PAYS_ISO_438094#160608)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_3A_438095#160510)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_3A_438095#160510)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_POIDS_MAJ_438096#160615)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_POIDS_MAJ_438096#160615)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODGESTION_438097#160517)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODGESTION_438097#160517)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ART115_438098#160514)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ART115_438098#160514)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TAILLE_438099#160625)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TAILLE_438099#160625)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TAILLE_MAJ_438100#160626)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TAILLE_MAJ_438100#160626)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODETAB_PROD_438101#160516)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODETAB_PROD_438101#160516)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODSIT_PROD_438102#160529)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODSIT_PROD_438102#160529)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMDOS_PROD_438103#160594)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMDOS_PROD_438103#160594)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_PROD_438104#160600)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_PROD_438104#160600)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_ORI_P_438105#160599)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_ORI_P_438105#160599)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_438106#160573)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_438106#160573)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_TYPE_438107#160577)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_TYPE_438107#160577)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_DATE_438108#160574)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_DATE_438108#160574)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_SOURCE_438109#160576)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_SOURCE_438109#160576)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_STADMP_438110#160622)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_STADMP_438110#160622)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATDMP_438111#160545)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATDMP_438111#160545)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ALARMES_438112#160512)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ALARMES_438112#160512)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_EMAIL_438113#160555)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_EMAIL_438113#160555)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CONSENT_SMS_438114#160536)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CONSENT_SMS_438114#160536)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DAT_CONSENT__438115#160552)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DAT_CONSENT__438115#160552)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATDCD_438116#160544)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATDCD_438116#160544)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLHLIM_438117#160563)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLHLIM_438117#160563)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATHLIM_438118#160548)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATHLIM_438118#160548)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPERSHLIM_438119#160521)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPERSHLIM_438119#160521)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLDIFF_438120#160561)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLDIFF_438120#160561)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_LISDEST_438121#160579)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_LISDEST_438121#160579)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_LANGUE_438122#160578)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_LANGUE_438122#160578)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMCAI_FT_438123#160590)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMCAI_FT_438123#160590)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODTARIFAMC_438124#160531)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODTARIFAMC_438124#160531)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLGRVE_438125#160562)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLGRVE_438125#160562)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLADRI_438126#160557)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLADRI_438126#160557)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATADRI_438127#160540)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATADRI_438127#160540)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATF_MUT_438128#160547)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATF_MUT_438128#160547)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_COMFAC_438129#160533)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_COMFAC_438129#160533)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMDOS_CLOUD_438130#160593)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMDOS_CLOUD_438130#160593)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NATION_438131#160581)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NATION_438131#160581)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TITRE_438132#160633)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TITRE_438132#160633)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TITRE_ASS_438133#160634)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TITRE_ASS_438133#160634)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TIQ_HISTOXML_438134#160631)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TIQ_HISTOXML_438134#160631)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TIQ_PNOLISTE_438135#160632)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TIQ_PNOLISTE_438135#160632)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPOSNAI_438136#160523)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPOSNAI_438136#160523)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INSI_438137#160571)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INSI_438137#160571)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INSI_OID_438138#160572)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INSI_OID_438138#160572)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TYPCONV_438139#160635)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TYPCONV_438139#160635)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CRISEC_438140#160537)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CRISEC_438140#160537)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_OPEREG_438141#160606)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_OPEREG_438141#160606)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLANNUAMC_438142#160558)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLANNUAMC_438142#160558)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_STAIPP_438143#160623)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_STAIPP_438143#160623)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PNONAI_438144#160612)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PNONAI_438144#160612)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODINSEENAI_438145#160518)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODINSEENAI_438145#160518)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VILLENAI_438146#160639)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_VILLENAI_438146#160639)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PIECE_IDENT__438147#160610)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PIECE_IDENT__438147#160610)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DAT_STAIPP_438148#160553)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DAT_STAIPP_438148#160553)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATAPCV_438149#160541)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATAPCV_438149#160541)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUM_APCV_438150#160605)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUM_APCV_438150#160605)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_HEUAPCV_438151#160566)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_HEUAPCV_438151#160566)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_SEC_438152#160601)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_SEC_438152#160601)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_HEURE_438153#160575)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_HEURE_438153#160575)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PERSAPREV_438154#160609)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PERSAPREV_438154#160609)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TARIF_438155#160627)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TARIF_438155#160627)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NOMHL7_438156#160586)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NOMHL7_438156#160586)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_ORI_O_438157#160598)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_ORI_O_438157#160598)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_COMMENT_438158#160534)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_COMMENT_438158#160534)), A63000893163) END)

FileScan parquet [AT_ADHMUT_438081#160505,AT_ADR_1A_438056#160506,AT_ADR_1_438039#160507,AT_ADR_2A_438057#160508,AT_ADR_2_438040#160509,AT_ADR_3A_438095#160510,AT_ADR_3_438093#160511,AT_ALARMES_438112#160512,AT_ANTECE_438038#160513,AT_ART115_438098#160514,AT_CODCAIAT_438078#160515,AT_CODETAB_PROD_438101#160516,AT_CODGESTION_438097#160517,AT_CODINSEENAI_438145#160518,AT_CODMED_438060#160519,AT_CODMTR_438092#160520,AT_CODPERSHLIM_438119#160521,AT_CODPOA_438058#160522,AT_CODPOSNAI_438136#160523,AT_CODPOS_438041#160524,AT_CODREF_438076#160525,AT_CODREGAT_438077#160526,AT_CODROUT_438084#160527,AT_CODSER_438066#160528,... 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#160505, AT_ADR_1A_438056#160506, AT_ADR_1_438039#160507, AT_ADR_2A_438057#160508, AT_ADR_2_438040#160509, AT_ADR_3A_438095#160510, AT_ADR_3_438093#160511, AT_ALARMES_438112#160512, AT_ANTECE_438038#160513, AT_ART115_438098#160514, AT_CODCAIAT_438078#160515, AT_CODETAB_PROD_438101#160516, AT_CODGESTION_438097#160517, AT_CODINSEENAI_438145#160518, AT_CODMED_438060#160519, AT_CODMTR_438092#160520, AT_CODPERSHLIM_438119#160521, AT_CODPOA_438058#160522, AT_CODPOSNAI_438136#160523, AT_CODPOS_438041#160524, AT_CODREF_438076#160525, AT_CODREGAT_438077#160526, AT_CODROUT_438084#160527, AT_CODSER_438066#160528, AT_CODSIT_PROD_438102#160529, AT_CODSTS_438088#160530, AT_CODTARIFAMC_438124#160531, AT_CODUTI_438073#160532, AT_COMFAC_438129#160533, AT_COMMENT_438158#160534, AT_CONMUT_438080#160535, AT_CONSENT_SMS_438114#160536, AT_CRISEC_438140#160537, AT_DAT100_438063#160538, AT_DATACC_438070#160539, AT_DATADRI_438127#160540, AT_DATAPCV_438149#160541, AT_DATASS_438055#160542, AT_DATCSS_438061#160543, AT_DATDCD_438116#160544, AT_DATDMP_438111#160545, AT_DATF_D_438062#160546, AT_DATF_MUT_438128#160547, AT_DATHLIM_438118#160548, AT_DATMAJ_438072#160549, AT_DATNAISS_438030#160550, AT_DATNAI_438029#160551, AT_DAT_CONSENT__438115#160552, AT_DAT_STAIPP_438148#160553, AT_DOMAINE_438085#160554, AT_EMAIL_438113#160555, AT_FAX_438050#160556, AT_FLADRI_438126#160557, AT_FLANNUAMC_438142#160558, AT_FLCMU_438074#160559, AT_FLDCD_438090#160560, AT_FLDIFF_438120#160561, AT_FLGRVE_438125#160562, AT_FLHLIM_438117#160563, AT_FLPHOTO_438091#160564, AT_GARMUT_438082#160565, AT_HEUAPCV_438151#160566, AT_IDHOTE_438087#160567, AT_INDCEN_438036#160568, AT_INDTRAI_438086#160569, AT_INDVITAL_438079#160570, AT_INSI_438137#160571, AT_INSI_OID_438138#160572, AT_INS_438106#160573, AT_INS_DATE_438108#160574, AT_INS_HEURE_438153#160575, AT_INS_SOURCE_438109#160576, AT_INS_TYPE_438107#160577, AT_LANGUE_438122#160578, AT_LISDEST_438121#160579, AT_NATASS_438068#160580, AT_NATION_438131#160581, AT_NIRIND_438089#160582, AT_NJFASS_438054#160583, AT_NJFPAT_438028#160584, AT_NOMASS_438052#160585, AT_NOMHL7_438156#160586, AT_NOMPAT_438026#160587, AT_NUMACC_438069#160588, AT_NUMCAI_438044#160589, AT_NUMCAI_FT_438123#160590, AT_NUMCHA_438046#160591, AT_NUMDOS_438023#160592, AT_NUMDOS_CLOUD_438130#160593, AT_NUMDOS_PROD_438103#160594, AT_NUMMUT_438045#160595, AT_NUMPER_438032#160596, AT_NUMPER_ORI_438083#160597, AT_NUMPER_ORI_O_438157#160598, AT_NUMPER_ORI_P_438105#160599, AT_NUMPER_PROD_438104#160600, AT_NUMPER_SEC_438152#160601, AT_NUMSIR_438064#160602, AT_NUMSSA_438065#160603, AT_NUMSS_438037#160604, AT_NUM_APCV_438150#160605, AT_OPEREG_438141#160606, AT_PAYS_438043#160607, AT_PAYS_ISO_438094#160608, AT_PERSAPREV_438154#160609, AT_PIECE_IDENT__438147#160610, AT_PNOASS_438053#160611, AT_PNONAI_438144#160612, AT_PNOPAT_438027#160613, AT_POIDS_438035#160614, AT_POIDS_MAJ_438096#160615, AT_PREFI2_438051#160616, AT_PREFIX_438025#160617, AT_QUALSS_438075#160618, AT_RNGNAI_438067#160619, AT_SEXE_438031#160620, AT_SIGMA_438033#160621, AT_STADMP_438110#160622, AT_STAIPP_438143#160623, AT_STAPAT_438024#160624, AT_TAILLE_438099#160625, AT_TAILLE_MAJ_438100#160626, AT_TARIF_438155#160627, AT_TELBUR_438048#160628, AT_TELPOR_438049#160629, AT_TELPRI_438047#160630, AT_TIQ_HISTOXML_438134#160631, AT_TIQ_PNOLISTE_438135#160632, AT_TITRE_438132#160633, AT_TITRE_ASS_438133#160634, AT_TYPCONV_438139#160635, AT_TYPEXO_438071#160636, AT_VERROU_438034#160637, AT_VILLEA_438059#160638, AT_VILLENAI_438146#160639, AT_VILLE_438042#160640]
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#160505, AT_ADR_1A_438056#160506, AT_ADR_1_438039#160507, AT_ADR_2A_438057#160508, AT_ADR_2_438040#160509, AT_ADR_3A_438095#160510, AT_ADR_3_438093#160511, AT_ALARMES_438112#160512, AT_ANTECE_438038#160513, AT_ART115_438098#160514, AT_CODCAIAT_438078#160515, AT_CODETAB_PROD_438101#160516, AT_CODGESTION_438097#160517, AT_CODINSEENAI_438145#160518, AT_CODMED_438060#160519, AT_CODMTR_438092#160520, AT_CODPERSHLIM_438119#160521, AT_CODPOA_438058#160522, AT_CODPOSNAI_438136#160523, AT_CODPOS_438041#160524, AT_CODREF_438076#160525, AT_CODREGAT_438077#160526, AT_CODROUT_438084#160527, AT_CODSER_438066#160528, AT_CODSIT_PROD_438102#160529, AT_CODSTS_438088#160530, AT_CODTARIFAMC_438124#160531, AT_CODUTI_438073#160532, AT_COMFAC_438129#160533, AT_COMMENT_438158#160534, AT_CONMUT_438080#160535, AT_CONSENT_SMS_438114#160536, AT_CRISEC_438140#160537, AT_DAT100_438063#160538, AT_DATACC_438070#160539, AT_DATADRI_438127#160540, AT_DATAPCV_438149#160541, AT_DATASS_438055#160542, AT_DATCSS_438061#160543, AT_DATDCD_438116#160544, AT_DATDMP_438111#160545, AT_DATF_D_438062#160546, AT_DATF_MUT_438128#160547, AT_DATHLIM_438118#160548, AT_DATMAJ_438072#160549, AT_DATNAISS_438030#160550, AT_DATNAI_438029#160551, AT_DAT_CONSENT__438115#160552, AT_DAT_STAIPP_438148#160553, AT_DOMAINE_438085#160554, AT_EMAIL_438113#160555, AT_FAX_438050#160556, AT_FLADRI_438126#160557, AT_FLANNUAMC_438142#160558, AT_FLCMU_438074#160559, AT_FLDCD_438090#160560, AT_FLDIFF_438120#160561, AT_FLGRVE_438125#160562, AT_FLHLIM_438117#160563, AT_FLPHOTO_438091#160564, AT_GARMUT_438082#160565, AT_HEUAPCV_438151#160566, AT_IDHOTE_438087#160567, AT_INDCEN_438036#160568, AT_INDTRAI_438086#160569, AT_INDVITAL_438079#160570, AT_INSI_438137#160571, AT_INSI_OID_438138#160572, AT_INS_438106#160573, AT_INS_DATE_438108#160574, AT_INS_HEURE_438153#160575, AT_INS_SOURCE_438109#160576, AT_INS_TYPE_438107#160577, AT_LANGUE_438122#160578, AT_LISDEST_438121#160579, AT_NATASS_438068#160580, AT_NATION_438131#160581, AT_NIRIND_438089#160582, AT_NJFASS_438054#160583, AT_NJFPAT_438028#160584, AT_NOMASS_438052#160585, AT_NOMHL7_438156#160586, AT_NOMPAT_438026#160587, AT_NUMACC_438069#160588, AT_NUMCAI_438044#160589, AT_NUMCAI_FT_438123#160590, AT_NUMCHA_438046#160591, AT_NUMDOS_438023#160592, AT_NUMDOS_CLOUD_438130#160593, AT_NUMDOS_PROD_438103#160594, AT_NUMMUT_438045#160595, AT_NUMPER_438032#160596, AT_NUMPER_ORI_438083#160597, AT_NUMPER_ORI_O_438157#160598, AT_NUMPER_ORI_P_438105#160599, AT_NUMPER_PROD_438104#160600, AT_NUMPER_SEC_438152#160601, AT_NUMSIR_438064#160602, AT_NUMSSA_438065#160603, AT_NUMSS_438037#160604, AT_NUM_APCV_438150#160605, AT_OPEREG_438141#160606, AT_PAYS_438043#160607, AT_PAYS_ISO_438094#160608, AT_PERSAPREV_438154#160609, AT_PIECE_IDENT__438147#160610, AT_PNOASS_438053#160611, AT_PNONAI_438144#160612, AT_PNOPAT_438027#160613, AT_POIDS_438035#160614, AT_POIDS_MAJ_438096#160615, AT_PREFI2_438051#160616, AT_PREFIX_438025#160617, AT_QUALSS_438075#160618, AT_RNGNAI_438067#160619, AT_SEXE_438031#160620, AT_SIGMA_438033#160621, AT_STADMP_438110#160622, AT_STAIPP_438143#160623, AT_STAPAT_438024#160624, AT_TAILLE_438099#160625, AT_TAILLE_MAJ_438100#160626, AT_TARIF_438155#160627, AT_TELBUR_438048#160628, AT_TELPOR_438049#160629, AT_TELPRI_438047#160630, AT_TIQ_HISTOXML_438134#160631, AT_TIQ_PNOLISTE_438135#160632, AT_TITRE_438132#160633, AT_TITRE_ASS_438133#160634, AT_TYPCONV_438139#160635, AT_TYPEXO_438071#160636, AT_VERROU_438034#160637, AT_VILLEA_438059#160638, AT_VILLENAI_438146#160639, AT_VILLE_438042#160640]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMDOS_438023#160592)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMDOS_438023#160592)), A63000893163) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_STAPAT_438024#160624)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_STAPAT_438024#160624)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PREFIX_438025#160617)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PREFIX_438025#160617)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NOMPAT_438026#160587)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NOMPAT_438026#160587)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PNOPAT_438027#160613)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PNOPAT_438027#160613)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NJFPAT_438028#160584)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NJFPAT_438028#160584)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATNAI_438029#160551)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATNAI_438029#160551)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATNAISS_438030#160550)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATNAISS_438030#160550)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_SEXE_438031#160620)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_SEXE_438031#160620)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_438032#160596)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_438032#160596)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_SIGMA_438033#160621)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_SIGMA_438033#160621)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VERROU_438034#160637)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_VERROU_438034#160637)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_POIDS_438035#160614)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_POIDS_438035#160614)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INDCEN_438036#160568)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INDCEN_438036#160568)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMSS_438037#160604)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMSS_438037#160604)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ANTECE_438038#160513)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ANTECE_438038#160513)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_1_438039#160507)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_1_438039#160507)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_2_438040#160509)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_2_438040#160509)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPOS_438041#160524)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPOS_438041#160524)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VILLE_438042#160640)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_VILLE_438042#160640)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PAYS_438043#160607)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PAYS_438043#160607)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMCAI_438044#160589)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMCAI_438044#160589)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMMUT_438045#160595)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMMUT_438045#160595)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMCHA_438046#160591)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMCHA_438046#160591)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TELPRI_438047#160630)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TELPRI_438047#160630)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TELBUR_438048#160628)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TELBUR_438048#160628)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TELPOR_438049#160629)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TELPOR_438049#160629)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FAX_438050#160556)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FAX_438050#160556)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PREFI2_438051#160616)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PREFI2_438051#160616)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NOMASS_438052#160585)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NOMASS_438052#160585)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PNOASS_438053#160611)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PNOASS_438053#160611)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NJFASS_438054#160583)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NJFASS_438054#160583)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATASS_438055#160542)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATASS_438055#160542)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_1A_438056#160506)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_1A_438056#160506)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_2A_438057#160508)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_2A_438057#160508)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPOA_438058#160522)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPOA_438058#160522)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VILLEA_438059#160638)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_VILLEA_438059#160638)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODMED_438060#160519)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODMED_438060#160519)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATCSS_438061#160543)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATCSS_438061#160543)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATF_D_438062#160546)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATF_D_438062#160546)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DAT100_438063#160538)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DAT100_438063#160538)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMSIR_438064#160602)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMSIR_438064#160602)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMSSA_438065#160603)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMSSA_438065#160603)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODSER_438066#160528)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODSER_438066#160528)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_RNGNAI_438067#160619)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_RNGNAI_438067#160619)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NATASS_438068#160580)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NATASS_438068#160580)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMACC_438069#160588)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMACC_438069#160588)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATACC_438070#160539)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATACC_438070#160539)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TYPEXO_438071#160636)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TYPEXO_438071#160636)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATMAJ_438072#160549)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATMAJ_438072#160549)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODUTI_438073#160532)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODUTI_438073#160532)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLCMU_438074#160559)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLCMU_438074#160559)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_QUALSS_438075#160618)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_QUALSS_438075#160618)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODREF_438076#160525)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODREF_438076#160525)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODREGAT_438077#160526)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODREGAT_438077#160526)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODCAIAT_438078#160515)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODCAIAT_438078#160515)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INDVITAL_438079#160570)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INDVITAL_438079#160570)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CONMUT_438080#160535)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CONMUT_438080#160535)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADHMUT_438081#160505)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADHMUT_438081#160505)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_GARMUT_438082#160565)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_GARMUT_438082#160565)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_ORI_438083#160597)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_ORI_438083#160597)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODROUT_438084#160527)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODROUT_438084#160527)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DOMAINE_438085#160554)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DOMAINE_438085#160554)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INDTRAI_438086#160569)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INDTRAI_438086#160569)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_IDHOTE_438087#160567)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_IDHOTE_438087#160567)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODSTS_438088#160530)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODSTS_438088#160530)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NIRIND_438089#160582)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NIRIND_438089#160582)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLDCD_438090#160560)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLDCD_438090#160560)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLPHOTO_438091#160564)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLPHOTO_438091#160564)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODMTR_438092#160520)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODMTR_438092#160520)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_3_438093#160511)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_3_438093#160511)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PAYS_ISO_438094#160608)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PAYS_ISO_438094#160608)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_3A_438095#160510)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_3A_438095#160510)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_POIDS_MAJ_438096#160615)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_POIDS_MAJ_438096#160615)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODGESTION_438097#160517)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODGESTION_438097#160517)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ART115_438098#160514)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ART115_438098#160514)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TAILLE_438099#160625)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TAILLE_438099#160625)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TAILLE_MAJ_438100#160626)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TAILLE_MAJ_438100#160626)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODETAB_PROD_438101#160516)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODETAB_PROD_438101#160516)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODSIT_PROD_438102#160529)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODSIT_PROD_438102#160529)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMDOS_PROD_438103#160594)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMDOS_PROD_438103#160594)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_PROD_438104#160600)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_PROD_438104#160600)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_ORI_P_438105#160599)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_ORI_P_438105#160599)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_438106#160573)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_438106#160573)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_TYPE_438107#160577)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_TYPE_438107#160577)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_DATE_438108#160574)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_DATE_438108#160574)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_SOURCE_438109#160576)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_SOURCE_438109#160576)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_STADMP_438110#160622)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_STADMP_438110#160622)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATDMP_438111#160545)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATDMP_438111#160545)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ALARMES_438112#160512)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ALARMES_438112#160512)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_EMAIL_438113#160555)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_EMAIL_438113#160555)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CONSENT_SMS_438114#160536)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CONSENT_SMS_438114#160536)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DAT_CONSENT__438115#160552)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DAT_CONSENT__438115#160552)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATDCD_438116#160544)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATDCD_438116#160544)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLHLIM_438117#160563)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLHLIM_438117#160563)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATHLIM_438118#160548)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATHLIM_438118#160548)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPERSHLIM_438119#160521)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPERSHLIM_438119#160521)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLDIFF_438120#160561)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLDIFF_438120#160561)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_LISDEST_438121#160579)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_LISDEST_438121#160579)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_LANGUE_438122#160578)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_LANGUE_438122#160578)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMCAI_FT_438123#160590)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMCAI_FT_438123#160590)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODTARIFAMC_438124#160531)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODTARIFAMC_438124#160531)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLGRVE_438125#160562)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLGRVE_438125#160562)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLADRI_438126#160557)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLADRI_438126#160557)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATADRI_438127#160540)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATADRI_438127#160540)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATF_MUT_438128#160547)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATF_MUT_438128#160547)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_COMFAC_438129#160533)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_COMFAC_438129#160533)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMDOS_CLOUD_438130#160593)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMDOS_CLOUD_438130#160593)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NATION_438131#160581)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NATION_438131#160581)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TITRE_438132#160633)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TITRE_438132#160633)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TITRE_ASS_438133#160634)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TITRE_ASS_438133#160634)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TIQ_HISTOXML_438134#160631)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TIQ_HISTOXML_438134#160631)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TIQ_PNOLISTE_438135#160632)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TIQ_PNOLISTE_438135#160632)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPOSNAI_438136#160523)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPOSNAI_438136#160523)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INSI_438137#160571)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INSI_438137#160571)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INSI_OID_438138#160572)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INSI_OID_438138#160572)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TYPCONV_438139#160635)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TYPCONV_438139#160635)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CRISEC_438140#160537)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CRISEC_438140#160537)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_OPEREG_438141#160606)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_OPEREG_438141#160606)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLANNUAMC_438142#160558)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLANNUAMC_438142#160558)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_STAIPP_438143#160623)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_STAIPP_438143#160623)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PNONAI_438144#160612)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PNONAI_438144#160612)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODINSEENAI_438145#160518)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODINSEENAI_438145#160518)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VILLENAI_438146#160639)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_VILLENAI_438146#160639)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PIECE_IDENT__438147#160610)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PIECE_IDENT__438147#160610)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DAT_STAIPP_438148#160553)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DAT_STAIPP_438148#160553)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATAPCV_438149#160541)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATAPCV_438149#160541)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUM_APCV_438150#160605)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUM_APCV_438150#160605)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_HEUAPCV_438151#160566)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_HEUAPCV_438151#160566)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_SEC_438152#160601)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_SEC_438152#160601)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_HEURE_438153#160575)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_HEURE_438153#160575)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PERSAPREV_438154#160609)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PERSAPREV_438154#160609)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TARIF_438155#160627)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TARIF_438155#160627)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NOMHL7_438156#160586)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NOMHL7_438156#160586)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_ORI_O_438157#160598)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_ORI_O_438157#160598)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_COMMENT_438158#160534)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_COMMENT_438158#160534)), A63000893163) END)

(3) Project
Output: []
Input [136]: [AT_ADHMUT_438081#160505, AT_ADR_1A_438056#160506, AT_ADR_1_438039#160507, AT_ADR_2A_438057#160508, AT_ADR_2_438040#160509, AT_ADR_3A_438095#160510, AT_ADR_3_438093#160511, AT_ALARMES_438112#160512, AT_ANTECE_438038#160513, AT_ART115_438098#160514, AT_CODCAIAT_438078#160515, AT_CODETAB_PROD_438101#160516, AT_CODGESTION_438097#160517, AT_CODINSEENAI_438145#160518, AT_CODMED_438060#160519, AT_CODMTR_438092#160520, AT_CODPERSHLIM_438119#160521, AT_CODPOA_438058#160522, AT_CODPOSNAI_438136#160523, AT_CODPOS_438041#160524, AT_CODREF_438076#160525, AT_CODREGAT_438077#160526, AT_CODROUT_438084#160527, AT_CODSER_438066#160528, AT_CODSIT_PROD_438102#160529, AT_CODSTS_438088#160530, AT_CODTARIFAMC_438124#160531, AT_CODUTI_438073#160532, AT_COMFAC_438129#160533, AT_COMMENT_438158#160534, AT_CONMUT_438080#160535, AT_CONSENT_SMS_438114#160536, AT_CRISEC_438140#160537, AT_DAT100_438063#160538, AT_DATACC_438070#160539, AT_DATADRI_438127#160540, AT_DATAPCV_438149#160541, AT_DATASS_438055#160542, AT_DATCSS_438061#160543, AT_DATDCD_438116#160544, AT_DATDMP_438111#160545, AT_DATF_D_438062#160546, AT_DATF_MUT_438128#160547, AT_DATHLIM_438118#160548, AT_DATMAJ_438072#160549, AT_DATNAISS_438030#160550, AT_DATNAI_438029#160551, AT_DAT_CONSENT__438115#160552, AT_DAT_STAIPP_438148#160553, AT_DOMAINE_438085#160554, AT_EMAIL_438113#160555, AT_FAX_438050#160556, AT_FLADRI_438126#160557, AT_FLANNUAMC_438142#160558, AT_FLCMU_438074#160559, AT_FLDCD_438090#160560, AT_FLDIFF_438120#160561, AT_FLGRVE_438125#160562, AT_FLHLIM_438117#160563, AT_FLPHOTO_438091#160564, AT_GARMUT_438082#160565, AT_HEUAPCV_438151#160566, AT_IDHOTE_438087#160567, AT_INDCEN_438036#160568, AT_INDTRAI_438086#160569, AT_INDVITAL_438079#160570, AT_INSI_438137#160571, AT_INSI_OID_438138#160572, AT_INS_438106#160573, AT_INS_DATE_438108#160574, AT_INS_HEURE_438153#160575, AT_INS_SOURCE_438109#160576, AT_INS_TYPE_438107#160577, AT_LANGUE_438122#160578, AT_LISDEST_438121#160579, AT_NATASS_438068#160580, AT_NATION_438131#160581, AT_NIRIND_438089#160582, AT_NJFASS_438054#160583, AT_NJFPAT_438028#160584, AT_NOMASS_438052#160585, AT_NOMHL7_438156#160586, AT_NOMPAT_438026#160587, AT_NUMACC_438069#160588, AT_NUMCAI_438044#160589, AT_NUMCAI_FT_438123#160590, AT_NUMCHA_438046#160591, AT_NUMDOS_438023#160592, AT_NUMDOS_CLOUD_438130#160593, AT_NUMDOS_PROD_438103#160594, AT_NUMMUT_438045#160595, AT_NUMPER_438032#160596, AT_NUMPER_ORI_438083#160597, AT_NUMPER_ORI_O_438157#160598, AT_NUMPER_ORI_P_438105#160599, AT_NUMPER_PROD_438104#160600, AT_NUMPER_SEC_438152#160601, AT_NUMSIR_438064#160602, AT_NUMSSA_438065#160603, AT_NUMSS_438037#160604, AT_NUM_APCV_438150#160605, AT_OPEREG_438141#160606, AT_PAYS_438043#160607, AT_PAYS_ISO_438094#160608, AT_PERSAPREV_438154#160609, AT_PIECE_IDENT__438147#160610, AT_PNOASS_438053#160611, AT_PNONAI_438144#160612, AT_PNOPAT_438027#160613, AT_POIDS_438035#160614, AT_POIDS_MAJ_438096#160615, AT_PREFI2_438051#160616, AT_PREFIX_438025#160617, AT_QUALSS_438075#160618, AT_RNGNAI_438067#160619, AT_SEXE_438031#160620, AT_SIGMA_438033#160621, AT_STADMP_438110#160622, AT_STAIPP_438143#160623, AT_STAPAT_438024#160624, AT_TAILLE_438099#160625, AT_TAILLE_MAJ_438100#160626, AT_TARIF_438155#160627, AT_TELBUR_438048#160628, AT_TELPOR_438049#160629, AT_TELPRI_438047#160630, AT_TIQ_HISTOXML_438134#160631, AT_TIQ_PNOLISTE_438135#160632, AT_TITRE_438132#160633, AT_TITRE_ASS_438133#160634, AT_TYPCONV_438139#160635, AT_TYPEXO_438071#160636, AT_VERROU_438034#160637, AT_VILLEA_438059#160638, AT_VILLENAI_438146#160639, AT_VILLE_438042#160640]

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

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

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

(7) HashAggregate [codegen id : 2]
Input [1]: [count#163716L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#163553L]
Results [1]: [count(1)#163553L AS COL_1518a444-4d06-486c-b004-0ca72e00cfcc#163555L]

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

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

(10) HashAggregate
Input [1]: [count#163716L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#163553L]
Results [1]: [count(1)#163553L AS COL_1518a444-4d06-486c-b004-0ca72e00cfcc#163555L]

(11) AdaptiveSparkPlan
Output [1]: [COL_1518a444-4d06-486c-b004-0ca72e00cfcc#163555L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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