hdh-spark-job - Details for Query 764

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

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

digraph G { 0 [labelType="html" label=" CollectLimit "]; 1 [labelType="html" label=" Project "]; 2 [labelType="html" label="Filter number of output rows: 1"]; 3 [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"]; 1->0; 2->1; 3->2; }

CollectLimit 1500

Project [AT_NUMDOS_438023#170927 AS COL_231C73C2_D552_4C60_81A1_6B39AB67A51E#172473, AT_STAPAT_438024#170959 AS COL_92D66B92_7938_4381_95A5_D80807212FC2#172474, AT_PREFIX_438025#170952 AS COL_7A7BE1B5_C954_4EC0_AEF9_B548737B2AFA#172475, AT_NOMPAT_438026#170922 AS COL_3B17EF5A_612E_4403_9084_D5AF69B87C24#172476, AT_PNOPAT_438027#170948 AS COL_5D75CDFD_F515_4E57_95F5_5F9E1FF52A5A#172477, AT_NJFPAT_438028#170919 AS COL_605691D0_DCE9_4B1C_B944_7EB499EF6729#172478, AT_DATNAI_438029#170886 AS COL_E95015FD_0630_4EBD_AF3F_5869F1601C32#172479, AT_DATNAISS_438030#170885 AS COL_411716DF_F45B_438E_A14F_180272B0D615#172480, AT_SEXE_438031#170955 AS COL_AE39C784_DD2A_4724_93C9_CDA7ADFB830D#172481, AT_NUMPER_438032#170931 AS COL_C969F886_23DB_4A96_9039_1A7D54E08535#172482, AT_SIGMA_438033#170956 AS COL_D94DEB75_3F68_4356_A301_82CFEDF43323#172483, AT_VERROU_438034#170972 AS COL_402039BA_7B82_4E02_80AA_79F6E9F1EFC1#172484, AT_POIDS_438035#170949 AS COL_B01B7647_8C03_4C2D_9A2A_CD4080D312D9#172485, AT_INDCEN_438036#170903 AS COL_FBD80108_3704_4DF1_8181_82D54513D5DF#172486, AT_NUMSS_438037#170939 AS COL_D60C55D7_8343_461B_94E5_F18AFC9194BC#172487, AT_ANTECE_438038#170848 AS COL_B555865E_ACD9_4381_8D1B_FA28430B0C99#172488, AT_ADR_1_438039#170842 AS COL_C7B2166F_BD47_4020_A9CB_392BBFEA3539#172489, AT_ADR_2_438040#170844 AS COL_7DE3EEC8_7854_48DE_8F8A_43B512AB5E4F#172490, AT_CODPOS_438041#170859 AS COL_7304AE52_3973_4FCC_B6F0_1B8DFB73D569#172491, AT_VILLE_438042#170975 AS COL_E9FA1403_8F0C_4637_8945_C0158E993FB0#172492, AT_PAYS_438043#170942 AS COL_508E9673_DB7F_413E_90C2_E4F25201D187#172493, AT_NUMCAI_438044#170924 AS COL_BC9B6B26_43C2_4EE7_AE87_7E8A947BFB46#172494, AT_NUMMUT_438045#170930 AS COL_8CC094F4_721A_4650_A83A_06557D8D89B0#172495, AT_NUMCHA_438046#170926 AS COL_97A0A39F_E2C3_4042_ACDC_4D206C5DA4A2#172496, ... 112 more fields]

Filter (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMDOS_438023#170927)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMDOS_438023#170927)), A63000893163) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_STAPAT_438024#170959)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_STAPAT_438024#170959)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PREFIX_438025#170952)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PREFIX_438025#170952)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NOMPAT_438026#170922)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NOMPAT_438026#170922)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PNOPAT_438027#170948)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PNOPAT_438027#170948)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NJFPAT_438028#170919)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NJFPAT_438028#170919)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATNAI_438029#170886)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATNAI_438029#170886)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATNAISS_438030#170885)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATNAISS_438030#170885)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_SEXE_438031#170955)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_SEXE_438031#170955)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_438032#170931)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_438032#170931)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_SIGMA_438033#170956)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_SIGMA_438033#170956)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VERROU_438034#170972)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_VERROU_438034#170972)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_POIDS_438035#170949)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_POIDS_438035#170949)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INDCEN_438036#170903)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INDCEN_438036#170903)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMSS_438037#170939)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMSS_438037#170939)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ANTECE_438038#170848)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ANTECE_438038#170848)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_1_438039#170842)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_1_438039#170842)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_2_438040#170844)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_2_438040#170844)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPOS_438041#170859)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPOS_438041#170859)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VILLE_438042#170975)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_VILLE_438042#170975)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PAYS_438043#170942)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PAYS_438043#170942)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMCAI_438044#170924)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMCAI_438044#170924)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMMUT_438045#170930)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMMUT_438045#170930)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMCHA_438046#170926)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMCHA_438046#170926)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TELPRI_438047#170965)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TELPRI_438047#170965)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TELBUR_438048#170963)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TELBUR_438048#170963)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TELPOR_438049#170964)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TELPOR_438049#170964)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FAX_438050#170891)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FAX_438050#170891)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PREFI2_438051#170951)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PREFI2_438051#170951)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NOMASS_438052#170920)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NOMASS_438052#170920)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PNOASS_438053#170946)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PNOASS_438053#170946)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NJFASS_438054#170918)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NJFASS_438054#170918)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATASS_438055#170877)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATASS_438055#170877)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_1A_438056#170841)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_1A_438056#170841)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_2A_438057#170843)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_2A_438057#170843)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPOA_438058#170857)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPOA_438058#170857)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VILLEA_438059#170973)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_VILLEA_438059#170973)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODMED_438060#170854)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODMED_438060#170854)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATCSS_438061#170878)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATCSS_438061#170878)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATF_D_438062#170881)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATF_D_438062#170881)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DAT100_438063#170873)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DAT100_438063#170873)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMSIR_438064#170937)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMSIR_438064#170937)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMSSA_438065#170938)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMSSA_438065#170938)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODSER_438066#170863)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODSER_438066#170863)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_RNGNAI_438067#170954)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_RNGNAI_438067#170954)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NATASS_438068#170915)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NATASS_438068#170915)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMACC_438069#170923)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMACC_438069#170923)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATACC_438070#170874)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATACC_438070#170874)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TYPEXO_438071#170971)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TYPEXO_438071#170971)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATMAJ_438072#170884)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATMAJ_438072#170884)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODUTI_438073#170867)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODUTI_438073#170867)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLCMU_438074#170894)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLCMU_438074#170894)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_QUALSS_438075#170953)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_QUALSS_438075#170953)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODREF_438076#170860)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODREF_438076#170860)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODREGAT_438077#170861)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODREGAT_438077#170861)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODCAIAT_438078#170850)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODCAIAT_438078#170850)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INDVITAL_438079#170905)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INDVITAL_438079#170905)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CONMUT_438080#170870)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CONMUT_438080#170870)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADHMUT_438081#170840)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADHMUT_438081#170840)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_GARMUT_438082#170900)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_GARMUT_438082#170900)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_ORI_438083#170932)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_ORI_438083#170932)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODROUT_438084#170862)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODROUT_438084#170862)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DOMAINE_438085#170889)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DOMAINE_438085#170889)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INDTRAI_438086#170904)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INDTRAI_438086#170904)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_IDHOTE_438087#170902)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_IDHOTE_438087#170902)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODSTS_438088#170865)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODSTS_438088#170865)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NIRIND_438089#170917)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NIRIND_438089#170917)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLDCD_438090#170895)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLDCD_438090#170895)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLPHOTO_438091#170899)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLPHOTO_438091#170899)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODMTR_438092#170855)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODMTR_438092#170855)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_3_438093#170846)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_3_438093#170846)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PAYS_ISO_438094#170943)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PAYS_ISO_438094#170943)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_3A_438095#170845)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_3A_438095#170845)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_POIDS_MAJ_438096#170950)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_POIDS_MAJ_438096#170950)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODGESTION_438097#170852)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODGESTION_438097#170852)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ART115_438098#170849)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ART115_438098#170849)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TAILLE_438099#170960)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TAILLE_438099#170960)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TAILLE_MAJ_438100#170961)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TAILLE_MAJ_438100#170961)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODETAB_PROD_438101#170851)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODETAB_PROD_438101#170851)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODSIT_PROD_438102#170864)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODSIT_PROD_438102#170864)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMDOS_PROD_438103#170929)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMDOS_PROD_438103#170929)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_PROD_438104#170935)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_PROD_438104#170935)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_ORI_P_438105#170934)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_ORI_P_438105#170934)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_438106#170908)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_438106#170908)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_TYPE_438107#170912)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_TYPE_438107#170912)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_DATE_438108#170909)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_DATE_438108#170909)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_SOURCE_438109#170911)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_SOURCE_438109#170911)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_STADMP_438110#170957)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_STADMP_438110#170957)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATDMP_438111#170880)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATDMP_438111#170880)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ALARMES_438112#170847)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ALARMES_438112#170847)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_EMAIL_438113#170890)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_EMAIL_438113#170890)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CONSENT_SMS_438114#170871)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CONSENT_SMS_438114#170871)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DAT_CONSENT__438115#170887)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DAT_CONSENT__438115#170887)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATDCD_438116#170879)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATDCD_438116#170879)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLHLIM_438117#170898)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLHLIM_438117#170898)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATHLIM_438118#170883)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATHLIM_438118#170883)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPERSHLIM_438119#170856)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPERSHLIM_438119#170856)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLDIFF_438120#170896)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLDIFF_438120#170896)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_LISDEST_438121#170914)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_LISDEST_438121#170914)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_LANGUE_438122#170913)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_LANGUE_438122#170913)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMCAI_FT_438123#170925)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMCAI_FT_438123#170925)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODTARIFAMC_438124#170866)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODTARIFAMC_438124#170866)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLGRVE_438125#170897)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLGRVE_438125#170897)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLADRI_438126#170892)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLADRI_438126#170892)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATADRI_438127#170875)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATADRI_438127#170875)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATF_MUT_438128#170882)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATF_MUT_438128#170882)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_COMFAC_438129#170868)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_COMFAC_438129#170868)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMDOS_CLOUD_438130#170928)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMDOS_CLOUD_438130#170928)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NATION_438131#170916)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NATION_438131#170916)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TITRE_438132#170968)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TITRE_438132#170968)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TITRE_ASS_438133#170969)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TITRE_ASS_438133#170969)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TIQ_HISTOXML_438134#170966)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TIQ_HISTOXML_438134#170966)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TIQ_PNOLISTE_438135#170967)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TIQ_PNOLISTE_438135#170967)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPOSNAI_438136#170858)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPOSNAI_438136#170858)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INSI_438137#170906)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INSI_438137#170906)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INSI_OID_438138#170907)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INSI_OID_438138#170907)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TYPCONV_438139#170970)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TYPCONV_438139#170970)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CRISEC_438140#170872)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CRISEC_438140#170872)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_OPEREG_438141#170941)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_OPEREG_438141#170941)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLANNUAMC_438142#170893)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLANNUAMC_438142#170893)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_STAIPP_438143#170958)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_STAIPP_438143#170958)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PNONAI_438144#170947)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PNONAI_438144#170947)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODINSEENAI_438145#170853)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODINSEENAI_438145#170853)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VILLENAI_438146#170974)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_VILLENAI_438146#170974)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PIECE_IDENT__438147#170945)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PIECE_IDENT__438147#170945)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DAT_STAIPP_438148#170888)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DAT_STAIPP_438148#170888)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATAPCV_438149#170876)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATAPCV_438149#170876)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUM_APCV_438150#170940)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUM_APCV_438150#170940)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_HEUAPCV_438151#170901)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_HEUAPCV_438151#170901)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_SEC_438152#170936)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_SEC_438152#170936)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_HEURE_438153#170910)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_HEURE_438153#170910)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PERSAPREV_438154#170944)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PERSAPREV_438154#170944)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TARIF_438155#170962)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TARIF_438155#170962)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NOMHL7_438156#170921)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NOMHL7_438156#170921)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_ORI_O_438157#170933)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_ORI_O_438157#170933)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_COMMENT_438158#170869)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_COMMENT_438158#170869)), A63000893163) END)

FileScan parquet [AT_ADHMUT_438081#170840,AT_ADR_1A_438056#170841,AT_ADR_1_438039#170842,AT_ADR_2A_438057#170843,AT_ADR_2_438040#170844,AT_ADR_3A_438095#170845,AT_ADR_3_438093#170846,AT_ALARMES_438112#170847,AT_ANTECE_438038#170848,AT_ART115_438098#170849,AT_CODCAIAT_438078#170850,AT_CODETAB_PROD_438101#170851,AT_CODGESTION_438097#170852,AT_CODINSEENAI_438145#170853,AT_CODMED_438060#170854,AT_CODMTR_438092#170855,AT_CODPERSHLIM_438119#170856,AT_CODPOA_438058#170857,AT_CODPOSNAI_438136#170858,AT_CODPOS_438041#170859,AT_CODREF_438076#170860,AT_CODREGAT_438077#170861,AT_CODROUT_438084#170862,AT_CODSER_438066#170863,... 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 ==
CollectLimit (4)
+- Project (3)
   +- Filter (2)
      +- Scan parquet  (1)


(1) Scan parquet 
Output [136]: [AT_ADHMUT_438081#170840, AT_ADR_1A_438056#170841, AT_ADR_1_438039#170842, AT_ADR_2A_438057#170843, AT_ADR_2_438040#170844, AT_ADR_3A_438095#170845, AT_ADR_3_438093#170846, AT_ALARMES_438112#170847, AT_ANTECE_438038#170848, AT_ART115_438098#170849, AT_CODCAIAT_438078#170850, AT_CODETAB_PROD_438101#170851, AT_CODGESTION_438097#170852, AT_CODINSEENAI_438145#170853, AT_CODMED_438060#170854, AT_CODMTR_438092#170855, AT_CODPERSHLIM_438119#170856, AT_CODPOA_438058#170857, AT_CODPOSNAI_438136#170858, AT_CODPOS_438041#170859, AT_CODREF_438076#170860, AT_CODREGAT_438077#170861, AT_CODROUT_438084#170862, AT_CODSER_438066#170863, AT_CODSIT_PROD_438102#170864, AT_CODSTS_438088#170865, AT_CODTARIFAMC_438124#170866, AT_CODUTI_438073#170867, AT_COMFAC_438129#170868, AT_COMMENT_438158#170869, AT_CONMUT_438080#170870, AT_CONSENT_SMS_438114#170871, AT_CRISEC_438140#170872, AT_DAT100_438063#170873, AT_DATACC_438070#170874, AT_DATADRI_438127#170875, AT_DATAPCV_438149#170876, AT_DATASS_438055#170877, AT_DATCSS_438061#170878, AT_DATDCD_438116#170879, AT_DATDMP_438111#170880, AT_DATF_D_438062#170881, AT_DATF_MUT_438128#170882, AT_DATHLIM_438118#170883, AT_DATMAJ_438072#170884, AT_DATNAISS_438030#170885, AT_DATNAI_438029#170886, AT_DAT_CONSENT__438115#170887, AT_DAT_STAIPP_438148#170888, AT_DOMAINE_438085#170889, AT_EMAIL_438113#170890, AT_FAX_438050#170891, AT_FLADRI_438126#170892, AT_FLANNUAMC_438142#170893, AT_FLCMU_438074#170894, AT_FLDCD_438090#170895, AT_FLDIFF_438120#170896, AT_FLGRVE_438125#170897, AT_FLHLIM_438117#170898, AT_FLPHOTO_438091#170899, AT_GARMUT_438082#170900, AT_HEUAPCV_438151#170901, AT_IDHOTE_438087#170902, AT_INDCEN_438036#170903, AT_INDTRAI_438086#170904, AT_INDVITAL_438079#170905, AT_INSI_438137#170906, AT_INSI_OID_438138#170907, AT_INS_438106#170908, AT_INS_DATE_438108#170909, AT_INS_HEURE_438153#170910, AT_INS_SOURCE_438109#170911, AT_INS_TYPE_438107#170912, AT_LANGUE_438122#170913, AT_LISDEST_438121#170914, AT_NATASS_438068#170915, AT_NATION_438131#170916, AT_NIRIND_438089#170917, AT_NJFASS_438054#170918, AT_NJFPAT_438028#170919, AT_NOMASS_438052#170920, AT_NOMHL7_438156#170921, AT_NOMPAT_438026#170922, AT_NUMACC_438069#170923, AT_NUMCAI_438044#170924, AT_NUMCAI_FT_438123#170925, AT_NUMCHA_438046#170926, AT_NUMDOS_438023#170927, AT_NUMDOS_CLOUD_438130#170928, AT_NUMDOS_PROD_438103#170929, AT_NUMMUT_438045#170930, AT_NUMPER_438032#170931, AT_NUMPER_ORI_438083#170932, AT_NUMPER_ORI_O_438157#170933, AT_NUMPER_ORI_P_438105#170934, AT_NUMPER_PROD_438104#170935, AT_NUMPER_SEC_438152#170936, AT_NUMSIR_438064#170937, AT_NUMSSA_438065#170938, AT_NUMSS_438037#170939, AT_NUM_APCV_438150#170940, AT_OPEREG_438141#170941, AT_PAYS_438043#170942, AT_PAYS_ISO_438094#170943, AT_PERSAPREV_438154#170944, AT_PIECE_IDENT__438147#170945, AT_PNOASS_438053#170946, AT_PNONAI_438144#170947, AT_PNOPAT_438027#170948, AT_POIDS_438035#170949, AT_POIDS_MAJ_438096#170950, AT_PREFI2_438051#170951, AT_PREFIX_438025#170952, AT_QUALSS_438075#170953, AT_RNGNAI_438067#170954, AT_SEXE_438031#170955, AT_SIGMA_438033#170956, AT_STADMP_438110#170957, AT_STAIPP_438143#170958, AT_STAPAT_438024#170959, AT_TAILLE_438099#170960, AT_TAILLE_MAJ_438100#170961, AT_TARIF_438155#170962, AT_TELBUR_438048#170963, AT_TELPOR_438049#170964, AT_TELPRI_438047#170965, AT_TIQ_HISTOXML_438134#170966, AT_TIQ_PNOLISTE_438135#170967, AT_TITRE_438132#170968, AT_TITRE_ASS_438133#170969, AT_TYPCONV_438139#170970, AT_TYPEXO_438071#170971, AT_VERROU_438034#170972, AT_VILLEA_438059#170973, AT_VILLENAI_438146#170974, AT_VILLE_438042#170975]
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#170840, AT_ADR_1A_438056#170841, AT_ADR_1_438039#170842, AT_ADR_2A_438057#170843, AT_ADR_2_438040#170844, AT_ADR_3A_438095#170845, AT_ADR_3_438093#170846, AT_ALARMES_438112#170847, AT_ANTECE_438038#170848, AT_ART115_438098#170849, AT_CODCAIAT_438078#170850, AT_CODETAB_PROD_438101#170851, AT_CODGESTION_438097#170852, AT_CODINSEENAI_438145#170853, AT_CODMED_438060#170854, AT_CODMTR_438092#170855, AT_CODPERSHLIM_438119#170856, AT_CODPOA_438058#170857, AT_CODPOSNAI_438136#170858, AT_CODPOS_438041#170859, AT_CODREF_438076#170860, AT_CODREGAT_438077#170861, AT_CODROUT_438084#170862, AT_CODSER_438066#170863, AT_CODSIT_PROD_438102#170864, AT_CODSTS_438088#170865, AT_CODTARIFAMC_438124#170866, AT_CODUTI_438073#170867, AT_COMFAC_438129#170868, AT_COMMENT_438158#170869, AT_CONMUT_438080#170870, AT_CONSENT_SMS_438114#170871, AT_CRISEC_438140#170872, AT_DAT100_438063#170873, AT_DATACC_438070#170874, AT_DATADRI_438127#170875, AT_DATAPCV_438149#170876, AT_DATASS_438055#170877, AT_DATCSS_438061#170878, AT_DATDCD_438116#170879, AT_DATDMP_438111#170880, AT_DATF_D_438062#170881, AT_DATF_MUT_438128#170882, AT_DATHLIM_438118#170883, AT_DATMAJ_438072#170884, AT_DATNAISS_438030#170885, AT_DATNAI_438029#170886, AT_DAT_CONSENT__438115#170887, AT_DAT_STAIPP_438148#170888, AT_DOMAINE_438085#170889, AT_EMAIL_438113#170890, AT_FAX_438050#170891, AT_FLADRI_438126#170892, AT_FLANNUAMC_438142#170893, AT_FLCMU_438074#170894, AT_FLDCD_438090#170895, AT_FLDIFF_438120#170896, AT_FLGRVE_438125#170897, AT_FLHLIM_438117#170898, AT_FLPHOTO_438091#170899, AT_GARMUT_438082#170900, AT_HEUAPCV_438151#170901, AT_IDHOTE_438087#170902, AT_INDCEN_438036#170903, AT_INDTRAI_438086#170904, AT_INDVITAL_438079#170905, AT_INSI_438137#170906, AT_INSI_OID_438138#170907, AT_INS_438106#170908, AT_INS_DATE_438108#170909, AT_INS_HEURE_438153#170910, AT_INS_SOURCE_438109#170911, AT_INS_TYPE_438107#170912, AT_LANGUE_438122#170913, AT_LISDEST_438121#170914, AT_NATASS_438068#170915, AT_NATION_438131#170916, AT_NIRIND_438089#170917, AT_NJFASS_438054#170918, AT_NJFPAT_438028#170919, AT_NOMASS_438052#170920, AT_NOMHL7_438156#170921, AT_NOMPAT_438026#170922, AT_NUMACC_438069#170923, AT_NUMCAI_438044#170924, AT_NUMCAI_FT_438123#170925, AT_NUMCHA_438046#170926, AT_NUMDOS_438023#170927, AT_NUMDOS_CLOUD_438130#170928, AT_NUMDOS_PROD_438103#170929, AT_NUMMUT_438045#170930, AT_NUMPER_438032#170931, AT_NUMPER_ORI_438083#170932, AT_NUMPER_ORI_O_438157#170933, AT_NUMPER_ORI_P_438105#170934, AT_NUMPER_PROD_438104#170935, AT_NUMPER_SEC_438152#170936, AT_NUMSIR_438064#170937, AT_NUMSSA_438065#170938, AT_NUMSS_438037#170939, AT_NUM_APCV_438150#170940, AT_OPEREG_438141#170941, AT_PAYS_438043#170942, AT_PAYS_ISO_438094#170943, AT_PERSAPREV_438154#170944, AT_PIECE_IDENT__438147#170945, AT_PNOASS_438053#170946, AT_PNONAI_438144#170947, AT_PNOPAT_438027#170948, AT_POIDS_438035#170949, AT_POIDS_MAJ_438096#170950, AT_PREFI2_438051#170951, AT_PREFIX_438025#170952, AT_QUALSS_438075#170953, AT_RNGNAI_438067#170954, AT_SEXE_438031#170955, AT_SIGMA_438033#170956, AT_STADMP_438110#170957, AT_STAIPP_438143#170958, AT_STAPAT_438024#170959, AT_TAILLE_438099#170960, AT_TAILLE_MAJ_438100#170961, AT_TARIF_438155#170962, AT_TELBUR_438048#170963, AT_TELPOR_438049#170964, AT_TELPRI_438047#170965, AT_TIQ_HISTOXML_438134#170966, AT_TIQ_PNOLISTE_438135#170967, AT_TITRE_438132#170968, AT_TITRE_ASS_438133#170969, AT_TYPCONV_438139#170970, AT_TYPEXO_438071#170971, AT_VERROU_438034#170972, AT_VILLEA_438059#170973, AT_VILLENAI_438146#170974, AT_VILLE_438042#170975]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMDOS_438023#170927)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMDOS_438023#170927)), A63000893163) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_STAPAT_438024#170959)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_STAPAT_438024#170959)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PREFIX_438025#170952)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PREFIX_438025#170952)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NOMPAT_438026#170922)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NOMPAT_438026#170922)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PNOPAT_438027#170948)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PNOPAT_438027#170948)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NJFPAT_438028#170919)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NJFPAT_438028#170919)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATNAI_438029#170886)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATNAI_438029#170886)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATNAISS_438030#170885)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATNAISS_438030#170885)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_SEXE_438031#170955)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_SEXE_438031#170955)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_438032#170931)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_438032#170931)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_SIGMA_438033#170956)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_SIGMA_438033#170956)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VERROU_438034#170972)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_VERROU_438034#170972)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_POIDS_438035#170949)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_POIDS_438035#170949)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INDCEN_438036#170903)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INDCEN_438036#170903)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMSS_438037#170939)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMSS_438037#170939)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ANTECE_438038#170848)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ANTECE_438038#170848)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_1_438039#170842)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_1_438039#170842)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_2_438040#170844)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_2_438040#170844)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPOS_438041#170859)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPOS_438041#170859)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VILLE_438042#170975)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_VILLE_438042#170975)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PAYS_438043#170942)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PAYS_438043#170942)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMCAI_438044#170924)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMCAI_438044#170924)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMMUT_438045#170930)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMMUT_438045#170930)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMCHA_438046#170926)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMCHA_438046#170926)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TELPRI_438047#170965)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TELPRI_438047#170965)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TELBUR_438048#170963)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TELBUR_438048#170963)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TELPOR_438049#170964)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TELPOR_438049#170964)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FAX_438050#170891)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FAX_438050#170891)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PREFI2_438051#170951)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PREFI2_438051#170951)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NOMASS_438052#170920)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NOMASS_438052#170920)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PNOASS_438053#170946)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PNOASS_438053#170946)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NJFASS_438054#170918)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NJFASS_438054#170918)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATASS_438055#170877)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATASS_438055#170877)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_1A_438056#170841)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_1A_438056#170841)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_2A_438057#170843)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_2A_438057#170843)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPOA_438058#170857)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPOA_438058#170857)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VILLEA_438059#170973)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_VILLEA_438059#170973)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODMED_438060#170854)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODMED_438060#170854)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATCSS_438061#170878)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATCSS_438061#170878)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATF_D_438062#170881)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATF_D_438062#170881)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DAT100_438063#170873)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DAT100_438063#170873)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMSIR_438064#170937)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMSIR_438064#170937)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMSSA_438065#170938)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMSSA_438065#170938)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODSER_438066#170863)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODSER_438066#170863)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_RNGNAI_438067#170954)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_RNGNAI_438067#170954)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NATASS_438068#170915)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NATASS_438068#170915)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMACC_438069#170923)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMACC_438069#170923)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATACC_438070#170874)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATACC_438070#170874)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TYPEXO_438071#170971)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TYPEXO_438071#170971)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATMAJ_438072#170884)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATMAJ_438072#170884)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODUTI_438073#170867)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODUTI_438073#170867)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLCMU_438074#170894)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLCMU_438074#170894)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_QUALSS_438075#170953)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_QUALSS_438075#170953)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODREF_438076#170860)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODREF_438076#170860)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODREGAT_438077#170861)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODREGAT_438077#170861)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODCAIAT_438078#170850)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODCAIAT_438078#170850)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INDVITAL_438079#170905)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INDVITAL_438079#170905)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CONMUT_438080#170870)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CONMUT_438080#170870)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADHMUT_438081#170840)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADHMUT_438081#170840)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_GARMUT_438082#170900)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_GARMUT_438082#170900)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_ORI_438083#170932)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_ORI_438083#170932)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODROUT_438084#170862)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODROUT_438084#170862)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DOMAINE_438085#170889)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DOMAINE_438085#170889)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INDTRAI_438086#170904)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INDTRAI_438086#170904)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_IDHOTE_438087#170902)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_IDHOTE_438087#170902)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODSTS_438088#170865)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODSTS_438088#170865)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NIRIND_438089#170917)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NIRIND_438089#170917)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLDCD_438090#170895)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLDCD_438090#170895)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLPHOTO_438091#170899)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLPHOTO_438091#170899)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODMTR_438092#170855)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODMTR_438092#170855)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_3_438093#170846)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_3_438093#170846)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PAYS_ISO_438094#170943)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PAYS_ISO_438094#170943)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_3A_438095#170845)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_3A_438095#170845)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_POIDS_MAJ_438096#170950)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_POIDS_MAJ_438096#170950)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODGESTION_438097#170852)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODGESTION_438097#170852)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ART115_438098#170849)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ART115_438098#170849)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TAILLE_438099#170960)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TAILLE_438099#170960)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TAILLE_MAJ_438100#170961)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TAILLE_MAJ_438100#170961)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODETAB_PROD_438101#170851)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODETAB_PROD_438101#170851)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODSIT_PROD_438102#170864)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODSIT_PROD_438102#170864)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMDOS_PROD_438103#170929)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMDOS_PROD_438103#170929)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_PROD_438104#170935)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_PROD_438104#170935)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_ORI_P_438105#170934)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_ORI_P_438105#170934)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_438106#170908)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_438106#170908)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_TYPE_438107#170912)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_TYPE_438107#170912)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_DATE_438108#170909)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_DATE_438108#170909)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_SOURCE_438109#170911)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_SOURCE_438109#170911)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_STADMP_438110#170957)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_STADMP_438110#170957)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATDMP_438111#170880)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATDMP_438111#170880)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ALARMES_438112#170847)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_ALARMES_438112#170847)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_EMAIL_438113#170890)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_EMAIL_438113#170890)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CONSENT_SMS_438114#170871)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CONSENT_SMS_438114#170871)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DAT_CONSENT__438115#170887)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DAT_CONSENT__438115#170887)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATDCD_438116#170879)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATDCD_438116#170879)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLHLIM_438117#170898)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLHLIM_438117#170898)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATHLIM_438118#170883)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATHLIM_438118#170883)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPERSHLIM_438119#170856)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPERSHLIM_438119#170856)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLDIFF_438120#170896)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLDIFF_438120#170896)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_LISDEST_438121#170914)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_LISDEST_438121#170914)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_LANGUE_438122#170913)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_LANGUE_438122#170913)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMCAI_FT_438123#170925)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMCAI_FT_438123#170925)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODTARIFAMC_438124#170866)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODTARIFAMC_438124#170866)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLGRVE_438125#170897)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLGRVE_438125#170897)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLADRI_438126#170892)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLADRI_438126#170892)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATADRI_438127#170875)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATADRI_438127#170875)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATF_MUT_438128#170882)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATF_MUT_438128#170882)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_COMFAC_438129#170868)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_COMFAC_438129#170868)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMDOS_CLOUD_438130#170928)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMDOS_CLOUD_438130#170928)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NATION_438131#170916)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NATION_438131#170916)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TITRE_438132#170968)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TITRE_438132#170968)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TITRE_ASS_438133#170969)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TITRE_ASS_438133#170969)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TIQ_HISTOXML_438134#170966)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TIQ_HISTOXML_438134#170966)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TIQ_PNOLISTE_438135#170967)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TIQ_PNOLISTE_438135#170967)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPOSNAI_438136#170858)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPOSNAI_438136#170858)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INSI_438137#170906)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INSI_438137#170906)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INSI_OID_438138#170907)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INSI_OID_438138#170907)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TYPCONV_438139#170970)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TYPCONV_438139#170970)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CRISEC_438140#170872)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CRISEC_438140#170872)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_OPEREG_438141#170941)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_OPEREG_438141#170941)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLANNUAMC_438142#170893)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLANNUAMC_438142#170893)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_STAIPP_438143#170958)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_STAIPP_438143#170958)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PNONAI_438144#170947)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PNONAI_438144#170947)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODINSEENAI_438145#170853)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODINSEENAI_438145#170853)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VILLENAI_438146#170974)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_VILLENAI_438146#170974)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PIECE_IDENT__438147#170945)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PIECE_IDENT__438147#170945)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DAT_STAIPP_438148#170888)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DAT_STAIPP_438148#170888)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATAPCV_438149#170876)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATAPCV_438149#170876)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUM_APCV_438150#170940)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUM_APCV_438150#170940)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_HEUAPCV_438151#170901)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_HEUAPCV_438151#170901)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_SEC_438152#170936)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_SEC_438152#170936)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_HEURE_438153#170910)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_HEURE_438153#170910)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PERSAPREV_438154#170944)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_PERSAPREV_438154#170944)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TARIF_438155#170962)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_TARIF_438155#170962)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NOMHL7_438156#170921)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NOMHL7_438156#170921)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_ORI_O_438157#170933)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_ORI_O_438157#170933)), A63000893163) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_COMMENT_438158#170869)), A63000893163)) THEN false ELSE Contains(str_remove_accent(upper(AT_COMMENT_438158#170869)), A63000893163) END)

(3) Project
Output [136]: [AT_NUMDOS_438023#170927 AS COL_231C73C2_D552_4C60_81A1_6B39AB67A51E#172473, AT_STAPAT_438024#170959 AS COL_92D66B92_7938_4381_95A5_D80807212FC2#172474, AT_PREFIX_438025#170952 AS COL_7A7BE1B5_C954_4EC0_AEF9_B548737B2AFA#172475, AT_NOMPAT_438026#170922 AS COL_3B17EF5A_612E_4403_9084_D5AF69B87C24#172476, AT_PNOPAT_438027#170948 AS COL_5D75CDFD_F515_4E57_95F5_5F9E1FF52A5A#172477, AT_NJFPAT_438028#170919 AS COL_605691D0_DCE9_4B1C_B944_7EB499EF6729#172478, AT_DATNAI_438029#170886 AS COL_E95015FD_0630_4EBD_AF3F_5869F1601C32#172479, AT_DATNAISS_438030#170885 AS COL_411716DF_F45B_438E_A14F_180272B0D615#172480, AT_SEXE_438031#170955 AS COL_AE39C784_DD2A_4724_93C9_CDA7ADFB830D#172481, AT_NUMPER_438032#170931 AS COL_C969F886_23DB_4A96_9039_1A7D54E08535#172482, AT_SIGMA_438033#170956 AS COL_D94DEB75_3F68_4356_A301_82CFEDF43323#172483, AT_VERROU_438034#170972 AS COL_402039BA_7B82_4E02_80AA_79F6E9F1EFC1#172484, AT_POIDS_438035#170949 AS COL_B01B7647_8C03_4C2D_9A2A_CD4080D312D9#172485, AT_INDCEN_438036#170903 AS COL_FBD80108_3704_4DF1_8181_82D54513D5DF#172486, AT_NUMSS_438037#170939 AS COL_D60C55D7_8343_461B_94E5_F18AFC9194BC#172487, AT_ANTECE_438038#170848 AS COL_B555865E_ACD9_4381_8D1B_FA28430B0C99#172488, AT_ADR_1_438039#170842 AS COL_C7B2166F_BD47_4020_A9CB_392BBFEA3539#172489, AT_ADR_2_438040#170844 AS COL_7DE3EEC8_7854_48DE_8F8A_43B512AB5E4F#172490, AT_CODPOS_438041#170859 AS COL_7304AE52_3973_4FCC_B6F0_1B8DFB73D569#172491, AT_VILLE_438042#170975 AS COL_E9FA1403_8F0C_4637_8945_C0158E993FB0#172492, AT_PAYS_438043#170942 AS COL_508E9673_DB7F_413E_90C2_E4F25201D187#172493, AT_NUMCAI_438044#170924 AS COL_BC9B6B26_43C2_4EE7_AE87_7E8A947BFB46#172494, AT_NUMMUT_438045#170930 AS COL_8CC094F4_721A_4650_A83A_06557D8D89B0#172495, AT_NUMCHA_438046#170926 AS COL_97A0A39F_E2C3_4042_ACDC_4D206C5DA4A2#172496, AT_TELPRI_438047#170965 AS COL_DA50E158_AB6D_4FB3_86CE_8DB895E12A59#172497, AT_TELBUR_438048#170963 AS COL_93927CF3_EE68_49E8_BCF9_5E5FA9F1D1D6#172498, AT_TELPOR_438049#170964 AS COL_B02841BC_F91E_4BD1_B400_AAC63AFFA8E6#172499, AT_FAX_438050#170891 AS COL_8492442C_78A3_4742_8546_7FC37C829E5C#172500, AT_PREFI2_438051#170951 AS COL_95E62A14_95D4_483F_8464_8117BF42E088#172501, AT_NOMASS_438052#170920 AS COL_7C45062E_CB84_4F09_BBFA_BA9BA31E1498#172502, AT_PNOASS_438053#170946 AS COL_8C77CDED_7BAD_457B_9B4C_EE19165948E9#172503, AT_NJFASS_438054#170918 AS COL_C9E4E06F_EDFB_4A20_B544_2AF3254DCD8B#172504, AT_DATASS_438055#170877 AS COL_9B38FDA3_7F51_47D7_829C_7A9E26C65C88#172505, AT_ADR_1A_438056#170841 AS COL_C182E00E_57DE_48A9_AB78_AF7FC027B302#172506, AT_ADR_2A_438057#170843 AS COL_7D327D07_958B_4018_A015_70C461A450D3#172507, AT_CODPOA_438058#170857 AS COL_2007D63D_354A_4D89_A57E_26DC2AD86A4B#172508, AT_VILLEA_438059#170973 AS COL_3F01083A_064F_4567_AB47_6D0C86F893A1#172509, AT_CODMED_438060#170854 AS COL_A2A4A2F8_8760_4952_830B_E022777453F4#172510, AT_DATCSS_438061#170878 AS COL_7ABE4839_F857_4B55_A49D_D7D3130C3A63#172511, AT_DATF_D_438062#170881 AS COL_902BA45F_17FE_4A3D_BBCD_924762FFF2C3#172512, AT_DAT100_438063#170873 AS COL_A46729DA_E346_4924_9C28_4E265C5CC4FE#172513, AT_NUMSIR_438064#170937 AS COL_44786A96_359A_4C6A_A102_E7CFC0C4A23F#172514, AT_NUMSSA_438065#170938 AS COL_7C564C88_2520_46B1_9486_7FE9D3CF2006#172515, AT_CODSER_438066#170863 AS COL_031F3C16_DF0E_4175_8195_1647375C7F9C#172516, AT_RNGNAI_438067#170954 AS COL_B1AB2A3F_048F_413B_B867_1F355ED05825#172517, AT_NATASS_438068#170915 AS COL_0ADCAC56_246E_4781_B8FE_4EB18B519A91#172518, AT_NUMACC_438069#170923 AS COL_2B4C9605_8291_47E6_8AC6_AA669C8B91C1#172519, AT_DATACC_438070#170874 AS COL_60ADAA43_2892_4F4A_B76E_92192FC9F4F4#172520, AT_TYPEXO_438071#170971 AS COL_2633F9C5_25A1_4E06_B255_F27C2D982BFC#172521, AT_DATMAJ_438072#170884 AS COL_5EE96FC0_26F7_4DF6_A31F_AB498AB038E8#172522, AT_CODUTI_438073#170867 AS COL_D5807696_FF1F_4AB4_886D_B177B8822E14#172523, AT_FLCMU_438074#170894 AS COL_8F86ED24_3B75_4F28_A9B2_1AC9F071550F#172524, AT_QUALSS_438075#170953 AS COL_01ABEA4E_847C_46EC_930C_D4ADF2D95236#172525, AT_CODREF_438076#170860 AS COL_53498B58_D672_4E84_B55E_E4C0C4EC400F#172526, AT_CODREGAT_438077#170861 AS COL_829A0FC2_33A8_482A_90FD_14F33D0CDE73#172527, AT_CODCAIAT_438078#170850 AS COL_F319A732_B2DE_4DCB_A892_53BD53E4439A#172528, AT_INDVITAL_438079#170905 AS COL_1943AC6F_3356_4654_BB0C_52B49363942B#172529, AT_CONMUT_438080#170870 AS COL_4C22186F_879B_49B2_899C_A5ED1C24233E#172530, AT_ADHMUT_438081#170840 AS COL_75780C99_5B6D_45E0_A72E_268683BB4F29#172531, AT_GARMUT_438082#170900 AS COL_9333FF25_D79B_4779_B1FC_F861CE1017FA#172532, AT_NUMPER_ORI_438083#170932 AS COL_CF81CB2B_87C5_4E21_B9CF_E2620F3BCA91#172533, AT_CODROUT_438084#170862 AS COL_8D03625D_470A_489A_9EAE_4D4734BAFC3F#172534, AT_DOMAINE_438085#170889 AS COL_2C4D361D_5A69_4F34_A40A_18F695B0B3E6#172535, AT_INDTRAI_438086#170904 AS COL_762FABCF_C609_4E9A_B6D0_7542FA48CB2D#172536, AT_IDHOTE_438087#170902 AS COL_B93D2808_1E51_4A5C_AA9E_76459B22CF09#172537, AT_CODSTS_438088#170865 AS COL_FAFF07D9_FFD4_4C1C_9AA1_16D3E8703C4A#172538, AT_NIRIND_438089#170917 AS COL_990EEB6A_395E_4577_8CEC_DAA833014D6E#172539, AT_FLDCD_438090#170895 AS COL_E820DEF9_0E54_46D2_8082_6F2C06347149#172540, AT_FLPHOTO_438091#170899 AS COL_587FC0FF_8CFF_4E3A_B3F8_1566BAE71A82#172541, AT_CODMTR_438092#170855 AS COL_EE38FFC5_7F5C_4833_A7AA_1990194CE5FB#172542, AT_ADR_3_438093#170846 AS COL_B506CA5D_EFF7_475D_9D68_C0A05AE72BEB#172543, AT_PAYS_ISO_438094#170943 AS COL_FB5AE401_7D5A_4984_A204_76B231C6ED44#172544, AT_ADR_3A_438095#170845 AS COL_244B00A9_E19A_41CE_A8BB_32C2490FC3E4#172545, AT_POIDS_MAJ_438096#170950 AS COL_AE6E1346_9AE4_457D_BD0F_DC4C301CDEBC#172546, AT_CODGESTION_438097#170852 AS COL_D0981A75_3F24_4E17_B3B4_0ADEFA62609C#172547, AT_ART115_438098#170849 AS COL_EAC822AB_8FCF_4827_803E_AEF5D7530E8E#172548, AT_TAILLE_438099#170960 AS COL_06479129_3755_4E09_9944_C41420ADD74C#172549, AT_TAILLE_MAJ_438100#170961 AS COL_4E062F34_3162_43B9_87EC_DF959FA5202F#172550, AT_CODETAB_PROD_438101#170851 AS COL_16D016D1_F313_427A_B095_E1F9E666F369#172551, AT_CODSIT_PROD_438102#170864 AS COL_D7E49C4E_C783_437E_A425_EBFF6894691D#172552, AT_NUMDOS_PROD_438103#170929 AS COL_397DDA4A_183A_4147_8C25_87AC3BF9F28A#172553, AT_NUMPER_PROD_438104#170935 AS COL_2EA4A85B_0961_45EC_9925_2D600C30E367#172554, AT_NUMPER_ORI_P_438105#170934 AS COL_A0982D80_4122_4104_814A_F73E99B7D9D5#172555, AT_INS_438106#170908 AS COL_6A348269_8706_43AB_87F7_D25920B0BDB5#172556, AT_INS_TYPE_438107#170912 AS COL_6135E107_20ED_4F74_9F58_47DF0206D1DD#172557, AT_INS_DATE_438108#170909 AS COL_A198E6F5_EDBA_4F83_8E2F_D92589FC6BC3#172558, AT_INS_SOURCE_438109#170911 AS COL_3467C977_07D1_4872_8B95_914EFDEF350C#172559, AT_STADMP_438110#170957 AS COL_3FB6CB7E_D9DA_4DE1_BFC0_B0915F99A4E3#172560, AT_DATDMP_438111#170880 AS COL_78F76C2C_6AC6_4B2A_B92C_B647C09427CA#172561, AT_ALARMES_438112#170847 AS COL_082CFE0C_9DF8_4CEB_A31D_DA6B6F3FC494#172562, AT_EMAIL_438113#170890 AS COL_DAAD9F6E_52EC_4D56_9773_B072001FEF30#172563, AT_CONSENT_SMS_438114#170871 AS COL_5F269F82_8BBE_4207_9838_55271435E5A6#172564, AT_DAT_CONSENT__438115#170887 AS COL_94AAC26E_2222_46F4_ADBD_7B7179297824#172565, AT_DATDCD_438116#170879 AS COL_2D0A67DF_57B7_44B2_A1E7_FA33E6DAF908#172566, AT_FLHLIM_438117#170898 AS COL_C8BE04CC_6D54_4E30_A42F_005D66564272#172567, AT_DATHLIM_438118#170883 AS COL_560FED10_8118_4AFF_8B3E_F1125F9D9B78#172568, AT_CODPERSHLIM_438119#170856 AS COL_C0366D85_50D9_43DE_8411_7D986AB68969#172569, AT_FLDIFF_438120#170896 AS COL_88FF6CA4_DBE2_482E_9B32_F9D400D7257F#172570, AT_LISDEST_438121#170914 AS COL_33564596_8504_402C_9E27_BECE4714F940#172571, AT_LANGUE_438122#170913 AS COL_C1859865_4401_4CFB_8EF5_B74C3C4B50FB#172572, AT_NUMCAI_FT_438123#170925 AS COL_2FB77A07_E200_456B_99ED_2FF7778E8A7B#172573, AT_CODTARIFAMC_438124#170866 AS COL_26B4322E_FC2E_437C_BB97_9194AE662176#172574, AT_FLGRVE_438125#170897 AS COL_B0F12CCE_8B40_4C47_B066_A5D0EFB91592#172575, AT_FLADRI_438126#170892 AS COL_597D1779_DE2B_4ED7_B226_3117E5BD0D00#172576, AT_DATADRI_438127#170875 AS COL_92CC6D4D_76DA_45B5_8614_F36B6663E69E#172577, AT_DATF_MUT_438128#170882 AS COL_AAD16561_C6F4_4295_9E75_9612345DD119#172578, AT_COMFAC_438129#170868 AS COL_4B061F43_B4EE_435C_8F6A_25B546783F6C#172579, AT_NUMDOS_CLOUD_438130#170928 AS COL_E298EC5E_DA56_41FC_B42D_C34C115F3F38#172580, AT_NATION_438131#170916 AS COL_ACCC5951_E807_491A_8D62_D022BBE5F33D#172581, AT_TITRE_438132#170968 AS COL_D4104EDA_F832_4106_B60B_26152C25DC87#172582, AT_TITRE_ASS_438133#170969 AS COL_E17749AE_4A11_4225_BF44_7F432FEFF425#172583, AT_TIQ_HISTOXML_438134#170966 AS COL_F4671924_CF70_4C2A_B03E_7DB7868271BE#172584, AT_TIQ_PNOLISTE_438135#170967 AS COL_FCD43125_303C_4BF6_B652_2DA0B8CBDCA3#172585, AT_CODPOSNAI_438136#170858 AS COL_5E9F318F_D7C4_4A28_BB25_7D209BCCDE4E#172586, AT_INSI_438137#170906 AS COL_C3BD24D4_6FDB_41D3_B2F6_33D464DC5314#172587, AT_INSI_OID_438138#170907 AS COL_BCA5E207_3247_4AA4_9D8D_CF273B675F7A#172588, AT_TYPCONV_438139#170970 AS COL_DFB5C567_D9FE_4898_BF2A_05A24362D4F0#172589, AT_CRISEC_438140#170872 AS COL_9C8B79D1_710F_4CA3_BF2E_EFF059B20969#172590, AT_OPEREG_438141#170941 AS COL_05948411_14A5_403B_9EA6_26BA2940003E#172591, AT_FLANNUAMC_438142#170893 AS COL_42CF0969_4EAC_4193_8834_9137C2E0EA55#172592, AT_STAIPP_438143#170958 AS COL_366D91BF_01BD_41F4_8E40_1E58B4B65874#172593, AT_PNONAI_438144#170947 AS COL_8C68BCC7_4908_4666_9984_652C1B606E0B#172594, AT_CODINSEENAI_438145#170853 AS COL_506120B5_121A_4524_A6D2_57D8F9F78E02#172595, AT_VILLENAI_438146#170974 AS COL_F55C732E_83B4_4CE0_9DBA_00E7B8EB4607#172596, AT_PIECE_IDENT__438147#170945 AS COL_9EB81437_4C5E_4717_A877_2516377424D8#172597, AT_DAT_STAIPP_438148#170888 AS COL_A11B6CEE_08EB_49DE_B1BB_BEC4D468932F#172598, AT_DATAPCV_438149#170876 AS COL_1CAC883F_3A8E_4281_B8C3_CEB46235A699#172599, AT_NUM_APCV_438150#170940 AS COL_4D264F38_02A0_4233_9EB4_BF4493FB9444#172600, AT_HEUAPCV_438151#170901 AS COL_3C216D30_ED6F_47FA_BC90_7B2852780CAD#172601, AT_NUMPER_SEC_438152#170936 AS COL_742FA038_ED41_4170_AAD2_4A18E8858D32#172602, AT_INS_HEURE_438153#170910 AS COL_152D81B7_4A32_4287_B435_7EB6783C9796#172603, AT_PERSAPREV_438154#170944 AS COL_1EF31DC2_8E46_449D_9270_02DAF037E43F#172604, AT_TARIF_438155#170962 AS COL_1DCC3E19_4C1D_4639_833A_077B0172DD3C#172605, AT_NOMHL7_438156#170921 AS COL_98C265AF_D9E2_4487_BDE1_5D13B6A82A4A#172606, AT_NUMPER_ORI_O_438157#170933 AS COL_02CF8E88_89B7_49A7_8A22_F71565648269#172607, AT_COMMENT_438158#170869 AS COL_914C151D_F4E4_4252_9C31_EF4A0935999D#172608]
Input [136]: [AT_ADHMUT_438081#170840, AT_ADR_1A_438056#170841, AT_ADR_1_438039#170842, AT_ADR_2A_438057#170843, AT_ADR_2_438040#170844, AT_ADR_3A_438095#170845, AT_ADR_3_438093#170846, AT_ALARMES_438112#170847, AT_ANTECE_438038#170848, AT_ART115_438098#170849, AT_CODCAIAT_438078#170850, AT_CODETAB_PROD_438101#170851, AT_CODGESTION_438097#170852, AT_CODINSEENAI_438145#170853, AT_CODMED_438060#170854, AT_CODMTR_438092#170855, AT_CODPERSHLIM_438119#170856, AT_CODPOA_438058#170857, AT_CODPOSNAI_438136#170858, AT_CODPOS_438041#170859, AT_CODREF_438076#170860, AT_CODREGAT_438077#170861, AT_CODROUT_438084#170862, AT_CODSER_438066#170863, AT_CODSIT_PROD_438102#170864, AT_CODSTS_438088#170865, AT_CODTARIFAMC_438124#170866, AT_CODUTI_438073#170867, AT_COMFAC_438129#170868, AT_COMMENT_438158#170869, AT_CONMUT_438080#170870, AT_CONSENT_SMS_438114#170871, AT_CRISEC_438140#170872, AT_DAT100_438063#170873, AT_DATACC_438070#170874, AT_DATADRI_438127#170875, AT_DATAPCV_438149#170876, AT_DATASS_438055#170877, AT_DATCSS_438061#170878, AT_DATDCD_438116#170879, AT_DATDMP_438111#170880, AT_DATF_D_438062#170881, AT_DATF_MUT_438128#170882, AT_DATHLIM_438118#170883, AT_DATMAJ_438072#170884, AT_DATNAISS_438030#170885, AT_DATNAI_438029#170886, AT_DAT_CONSENT__438115#170887, AT_DAT_STAIPP_438148#170888, AT_DOMAINE_438085#170889, AT_EMAIL_438113#170890, AT_FAX_438050#170891, AT_FLADRI_438126#170892, AT_FLANNUAMC_438142#170893, AT_FLCMU_438074#170894, AT_FLDCD_438090#170895, AT_FLDIFF_438120#170896, AT_FLGRVE_438125#170897, AT_FLHLIM_438117#170898, AT_FLPHOTO_438091#170899, AT_GARMUT_438082#170900, AT_HEUAPCV_438151#170901, AT_IDHOTE_438087#170902, AT_INDCEN_438036#170903, AT_INDTRAI_438086#170904, AT_INDVITAL_438079#170905, AT_INSI_438137#170906, AT_INSI_OID_438138#170907, AT_INS_438106#170908, AT_INS_DATE_438108#170909, AT_INS_HEURE_438153#170910, AT_INS_SOURCE_438109#170911, AT_INS_TYPE_438107#170912, AT_LANGUE_438122#170913, AT_LISDEST_438121#170914, AT_NATASS_438068#170915, AT_NATION_438131#170916, AT_NIRIND_438089#170917, AT_NJFASS_438054#170918, AT_NJFPAT_438028#170919, AT_NOMASS_438052#170920, AT_NOMHL7_438156#170921, AT_NOMPAT_438026#170922, AT_NUMACC_438069#170923, AT_NUMCAI_438044#170924, AT_NUMCAI_FT_438123#170925, AT_NUMCHA_438046#170926, AT_NUMDOS_438023#170927, AT_NUMDOS_CLOUD_438130#170928, AT_NUMDOS_PROD_438103#170929, AT_NUMMUT_438045#170930, AT_NUMPER_438032#170931, AT_NUMPER_ORI_438083#170932, AT_NUMPER_ORI_O_438157#170933, AT_NUMPER_ORI_P_438105#170934, AT_NUMPER_PROD_438104#170935, AT_NUMPER_SEC_438152#170936, AT_NUMSIR_438064#170937, AT_NUMSSA_438065#170938, AT_NUMSS_438037#170939, AT_NUM_APCV_438150#170940, AT_OPEREG_438141#170941, AT_PAYS_438043#170942, AT_PAYS_ISO_438094#170943, AT_PERSAPREV_438154#170944, AT_PIECE_IDENT__438147#170945, AT_PNOASS_438053#170946, AT_PNONAI_438144#170947, AT_PNOPAT_438027#170948, AT_POIDS_438035#170949, AT_POIDS_MAJ_438096#170950, AT_PREFI2_438051#170951, AT_PREFIX_438025#170952, AT_QUALSS_438075#170953, AT_RNGNAI_438067#170954, AT_SEXE_438031#170955, AT_SIGMA_438033#170956, AT_STADMP_438110#170957, AT_STAIPP_438143#170958, AT_STAPAT_438024#170959, AT_TAILLE_438099#170960, AT_TAILLE_MAJ_438100#170961, AT_TARIF_438155#170962, AT_TELBUR_438048#170963, AT_TELPOR_438049#170964, AT_TELPRI_438047#170965, AT_TIQ_HISTOXML_438134#170966, AT_TIQ_PNOLISTE_438135#170967, AT_TITRE_438132#170968, AT_TITRE_ASS_438133#170969, AT_TYPCONV_438139#170970, AT_TYPEXO_438071#170971, AT_VERROU_438034#170972, AT_VILLEA_438059#170973, AT_VILLENAI_438146#170974, AT_VILLE_438042#170975]

(4) CollectLimit
Input [136]: [COL_231C73C2_D552_4C60_81A1_6B39AB67A51E#172473, COL_92D66B92_7938_4381_95A5_D80807212FC2#172474, COL_7A7BE1B5_C954_4EC0_AEF9_B548737B2AFA#172475, COL_3B17EF5A_612E_4403_9084_D5AF69B87C24#172476, COL_5D75CDFD_F515_4E57_95F5_5F9E1FF52A5A#172477, COL_605691D0_DCE9_4B1C_B944_7EB499EF6729#172478, COL_E95015FD_0630_4EBD_AF3F_5869F1601C32#172479, COL_411716DF_F45B_438E_A14F_180272B0D615#172480, COL_AE39C784_DD2A_4724_93C9_CDA7ADFB830D#172481, COL_C969F886_23DB_4A96_9039_1A7D54E08535#172482, COL_D94DEB75_3F68_4356_A301_82CFEDF43323#172483, COL_402039BA_7B82_4E02_80AA_79F6E9F1EFC1#172484, COL_B01B7647_8C03_4C2D_9A2A_CD4080D312D9#172485, COL_FBD80108_3704_4DF1_8181_82D54513D5DF#172486, COL_D60C55D7_8343_461B_94E5_F18AFC9194BC#172487, COL_B555865E_ACD9_4381_8D1B_FA28430B0C99#172488, COL_C7B2166F_BD47_4020_A9CB_392BBFEA3539#172489, COL_7DE3EEC8_7854_48DE_8F8A_43B512AB5E4F#172490, COL_7304AE52_3973_4FCC_B6F0_1B8DFB73D569#172491, COL_E9FA1403_8F0C_4637_8945_C0158E993FB0#172492, COL_508E9673_DB7F_413E_90C2_E4F25201D187#172493, COL_BC9B6B26_43C2_4EE7_AE87_7E8A947BFB46#172494, COL_8CC094F4_721A_4650_A83A_06557D8D89B0#172495, COL_97A0A39F_E2C3_4042_ACDC_4D206C5DA4A2#172496, COL_DA50E158_AB6D_4FB3_86CE_8DB895E12A59#172497, COL_93927CF3_EE68_49E8_BCF9_5E5FA9F1D1D6#172498, COL_B02841BC_F91E_4BD1_B400_AAC63AFFA8E6#172499, COL_8492442C_78A3_4742_8546_7FC37C829E5C#172500, COL_95E62A14_95D4_483F_8464_8117BF42E088#172501, COL_7C45062E_CB84_4F09_BBFA_BA9BA31E1498#172502, COL_8C77CDED_7BAD_457B_9B4C_EE19165948E9#172503, COL_C9E4E06F_EDFB_4A20_B544_2AF3254DCD8B#172504, COL_9B38FDA3_7F51_47D7_829C_7A9E26C65C88#172505, COL_C182E00E_57DE_48A9_AB78_AF7FC027B302#172506, COL_7D327D07_958B_4018_A015_70C461A450D3#172507, COL_2007D63D_354A_4D89_A57E_26DC2AD86A4B#172508, COL_3F01083A_064F_4567_AB47_6D0C86F893A1#172509, COL_A2A4A2F8_8760_4952_830B_E022777453F4#172510, COL_7ABE4839_F857_4B55_A49D_D7D3130C3A63#172511, COL_902BA45F_17FE_4A3D_BBCD_924762FFF2C3#172512, COL_A46729DA_E346_4924_9C28_4E265C5CC4FE#172513, COL_44786A96_359A_4C6A_A102_E7CFC0C4A23F#172514, COL_7C564C88_2520_46B1_9486_7FE9D3CF2006#172515, COL_031F3C16_DF0E_4175_8195_1647375C7F9C#172516, COL_B1AB2A3F_048F_413B_B867_1F355ED05825#172517, COL_0ADCAC56_246E_4781_B8FE_4EB18B519A91#172518, COL_2B4C9605_8291_47E6_8AC6_AA669C8B91C1#172519, COL_60ADAA43_2892_4F4A_B76E_92192FC9F4F4#172520, COL_2633F9C5_25A1_4E06_B255_F27C2D982BFC#172521, COL_5EE96FC0_26F7_4DF6_A31F_AB498AB038E8#172522, COL_D5807696_FF1F_4AB4_886D_B177B8822E14#172523, COL_8F86ED24_3B75_4F28_A9B2_1AC9F071550F#172524, COL_01ABEA4E_847C_46EC_930C_D4ADF2D95236#172525, COL_53498B58_D672_4E84_B55E_E4C0C4EC400F#172526, COL_829A0FC2_33A8_482A_90FD_14F33D0CDE73#172527, COL_F319A732_B2DE_4DCB_A892_53BD53E4439A#172528, COL_1943AC6F_3356_4654_BB0C_52B49363942B#172529, COL_4C22186F_879B_49B2_899C_A5ED1C24233E#172530, COL_75780C99_5B6D_45E0_A72E_268683BB4F29#172531, COL_9333FF25_D79B_4779_B1FC_F861CE1017FA#172532, COL_CF81CB2B_87C5_4E21_B9CF_E2620F3BCA91#172533, COL_8D03625D_470A_489A_9EAE_4D4734BAFC3F#172534, COL_2C4D361D_5A69_4F34_A40A_18F695B0B3E6#172535, COL_762FABCF_C609_4E9A_B6D0_7542FA48CB2D#172536, COL_B93D2808_1E51_4A5C_AA9E_76459B22CF09#172537, COL_FAFF07D9_FFD4_4C1C_9AA1_16D3E8703C4A#172538, COL_990EEB6A_395E_4577_8CEC_DAA833014D6E#172539, COL_E820DEF9_0E54_46D2_8082_6F2C06347149#172540, COL_587FC0FF_8CFF_4E3A_B3F8_1566BAE71A82#172541, COL_EE38FFC5_7F5C_4833_A7AA_1990194CE5FB#172542, COL_B506CA5D_EFF7_475D_9D68_C0A05AE72BEB#172543, COL_FB5AE401_7D5A_4984_A204_76B231C6ED44#172544, COL_244B00A9_E19A_41CE_A8BB_32C2490FC3E4#172545, COL_AE6E1346_9AE4_457D_BD0F_DC4C301CDEBC#172546, COL_D0981A75_3F24_4E17_B3B4_0ADEFA62609C#172547, COL_EAC822AB_8FCF_4827_803E_AEF5D7530E8E#172548, COL_06479129_3755_4E09_9944_C41420ADD74C#172549, COL_4E062F34_3162_43B9_87EC_DF959FA5202F#172550, COL_16D016D1_F313_427A_B095_E1F9E666F369#172551, COL_D7E49C4E_C783_437E_A425_EBFF6894691D#172552, COL_397DDA4A_183A_4147_8C25_87AC3BF9F28A#172553, COL_2EA4A85B_0961_45EC_9925_2D600C30E367#172554, COL_A0982D80_4122_4104_814A_F73E99B7D9D5#172555, COL_6A348269_8706_43AB_87F7_D25920B0BDB5#172556, COL_6135E107_20ED_4F74_9F58_47DF0206D1DD#172557, COL_A198E6F5_EDBA_4F83_8E2F_D92589FC6BC3#172558, COL_3467C977_07D1_4872_8B95_914EFDEF350C#172559, COL_3FB6CB7E_D9DA_4DE1_BFC0_B0915F99A4E3#172560, COL_78F76C2C_6AC6_4B2A_B92C_B647C09427CA#172561, COL_082CFE0C_9DF8_4CEB_A31D_DA6B6F3FC494#172562, COL_DAAD9F6E_52EC_4D56_9773_B072001FEF30#172563, COL_5F269F82_8BBE_4207_9838_55271435E5A6#172564, COL_94AAC26E_2222_46F4_ADBD_7B7179297824#172565, COL_2D0A67DF_57B7_44B2_A1E7_FA33E6DAF908#172566, COL_C8BE04CC_6D54_4E30_A42F_005D66564272#172567, COL_560FED10_8118_4AFF_8B3E_F1125F9D9B78#172568, COL_C0366D85_50D9_43DE_8411_7D986AB68969#172569, COL_88FF6CA4_DBE2_482E_9B32_F9D400D7257F#172570, COL_33564596_8504_402C_9E27_BECE4714F940#172571, COL_C1859865_4401_4CFB_8EF5_B74C3C4B50FB#172572, COL_2FB77A07_E200_456B_99ED_2FF7778E8A7B#172573, COL_26B4322E_FC2E_437C_BB97_9194AE662176#172574, COL_B0F12CCE_8B40_4C47_B066_A5D0EFB91592#172575, COL_597D1779_DE2B_4ED7_B226_3117E5BD0D00#172576, COL_92CC6D4D_76DA_45B5_8614_F36B6663E69E#172577, COL_AAD16561_C6F4_4295_9E75_9612345DD119#172578, COL_4B061F43_B4EE_435C_8F6A_25B546783F6C#172579, COL_E298EC5E_DA56_41FC_B42D_C34C115F3F38#172580, COL_ACCC5951_E807_491A_8D62_D022BBE5F33D#172581, COL_D4104EDA_F832_4106_B60B_26152C25DC87#172582, COL_E17749AE_4A11_4225_BF44_7F432FEFF425#172583, COL_F4671924_CF70_4C2A_B03E_7DB7868271BE#172584, COL_FCD43125_303C_4BF6_B652_2DA0B8CBDCA3#172585, COL_5E9F318F_D7C4_4A28_BB25_7D209BCCDE4E#172586, COL_C3BD24D4_6FDB_41D3_B2F6_33D464DC5314#172587, COL_BCA5E207_3247_4AA4_9D8D_CF273B675F7A#172588, COL_DFB5C567_D9FE_4898_BF2A_05A24362D4F0#172589, COL_9C8B79D1_710F_4CA3_BF2E_EFF059B20969#172590, COL_05948411_14A5_403B_9EA6_26BA2940003E#172591, COL_42CF0969_4EAC_4193_8834_9137C2E0EA55#172592, COL_366D91BF_01BD_41F4_8E40_1E58B4B65874#172593, COL_8C68BCC7_4908_4666_9984_652C1B606E0B#172594, COL_506120B5_121A_4524_A6D2_57D8F9F78E02#172595, COL_F55C732E_83B4_4CE0_9DBA_00E7B8EB4607#172596, COL_9EB81437_4C5E_4717_A877_2516377424D8#172597, COL_A11B6CEE_08EB_49DE_B1BB_BEC4D468932F#172598, COL_1CAC883F_3A8E_4281_B8C3_CEB46235A699#172599, COL_4D264F38_02A0_4233_9EB4_BF4493FB9444#172600, COL_3C216D30_ED6F_47FA_BC90_7B2852780CAD#172601, COL_742FA038_ED41_4170_AAD2_4A18E8858D32#172602, COL_152D81B7_4A32_4287_B435_7EB6783C9796#172603, COL_1EF31DC2_8E46_449D_9270_02DAF037E43F#172604, COL_1DCC3E19_4C1D_4639_833A_077B0172DD3C#172605, COL_98C265AF_D9E2_4487_BDE1_5D13B6A82A4A#172606, COL_02CF8E88_89B7_49A7_8A22_F71565648269#172607, COL_914C151D_F4E4_4252_9C31_EF4A0935999D#172608]
Arguments: 1500

SQL / DataFrame Properties

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