hdh-spark-job - Details for Query 715

Submitted Time: 2026/10/21 21:36:19
Duration: 1 s
Succeeded Jobs: 696

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: 8"]; 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#157063 AS COL_906FFCAC_28FB_4AF5_8A40_FA2E0ADB48D0#157792, AT_STAPAT_438024#157095 AS COL_AF7163BC_112C_4118_AC07_C25B8DD02C5C#157793, AT_PREFIX_438025#157088 AS COL_6BCF01B9_EEAC_44BC_9ABE_F9A47B0FF0EC#157794, AT_NOMPAT_438026#157058 AS COL_84FBD601_2E72_457B_905D_C80C8FAA2257#157795, AT_PNOPAT_438027#157084 AS COL_7C081758_9AE8_4D43_B249_7A3E6043FC22#157796, AT_NJFPAT_438028#157055 AS COL_D01238FB_A545_440E_97F7_312B85808E7C#157797, AT_DATNAI_438029#157022 AS COL_F996254B_D9DC_4C0A_9DD9_68BA2547B465#157798, AT_DATNAISS_438030#157021 AS COL_7D384105_A968_40D5_BF9C_4AAEACE72F75#157799, AT_SEXE_438031#157091 AS COL_C66F8C84_F2F0_40EA_9198_18867C16097C#157800, AT_NUMPER_438032#157067 AS COL_82E82ED3_0457_43E2_9856_B8F0AABC06FC#157801, AT_SIGMA_438033#157092 AS COL_C38053BD_111C_48FC_BB99_634D02020D60#157802, AT_VERROU_438034#157108 AS COL_4B1A77C7_90E2_4595_A649_7BEE426027DA#157803, AT_POIDS_438035#157085 AS COL_FC90D543_DC69_403C_95BB_69A661B66829#157804, AT_INDCEN_438036#157039 AS COL_1C6D3A39_B5DA_4F71_A95A_70889566840F#157805, AT_NUMSS_438037#157075 AS COL_8C572EF3_AACA_4F30_93E5_5F93351C915D#157806, AT_ANTECE_438038#156984 AS COL_85992C0B_96B7_40A0_8BCD_7032F939CC45#157807, AT_ADR_1_438039#156978 AS COL_99A9F6CB_7CDB_4283_9EA9_3B59266D1825#157808, AT_ADR_2_438040#156980 AS COL_B9366DC5_32A5_437C_8127_C6CDF8505705#157809, AT_CODPOS_438041#156995 AS COL_B2F92CF3_40E6_4734_81B9_E28B54867795#157810, AT_VILLE_438042#157111 AS COL_41F1EB02_EDC5_4945_800E_70F44E6C75C8#157811, AT_PAYS_438043#157078 AS COL_A4FB5F42_1464_4933_B95D_1116377A0260#157812, AT_NUMCAI_438044#157060 AS COL_09DA39AF_E548_418F_AF81_2A103081BDE5#157813, AT_NUMMUT_438045#157066 AS COL_6EE5FB06_5AE3_43DB_B5AD_DB30319C004E#157814, AT_NUMCHA_438046#157062 AS COL_ACD91A48_6196_46C1_A8FF_92E31806A574#157815, ... 112 more fields]

Filter (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMDOS_438023#157063)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMDOS_438023#157063)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_STAPAT_438024#157095)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_STAPAT_438024#157095)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PREFIX_438025#157088)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_PREFIX_438025#157088)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NOMPAT_438026#157058)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NOMPAT_438026#157058)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PNOPAT_438027#157084)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_PNOPAT_438027#157084)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NJFPAT_438028#157055)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NJFPAT_438028#157055)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATNAI_438029#157022)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATNAI_438029#157022)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATNAISS_438030#157021)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATNAISS_438030#157021)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_SEXE_438031#157091)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_SEXE_438031#157091)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_438032#157067)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_438032#157067)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_SIGMA_438033#157092)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_SIGMA_438033#157092)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VERROU_438034#157108)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_VERROU_438034#157108)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_POIDS_438035#157085)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_POIDS_438035#157085)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INDCEN_438036#157039)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_INDCEN_438036#157039)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMSS_438037#157075)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMSS_438037#157075)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ANTECE_438038#156984)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_ANTECE_438038#156984)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_1_438039#156978)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_1_438039#156978)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_2_438040#156980)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_2_438040#156980)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPOS_438041#156995)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPOS_438041#156995)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VILLE_438042#157111)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_VILLE_438042#157111)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PAYS_438043#157078)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_PAYS_438043#157078)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMCAI_438044#157060)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMCAI_438044#157060)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMMUT_438045#157066)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMMUT_438045#157066)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMCHA_438046#157062)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMCHA_438046#157062)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TELPRI_438047#157101)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TELPRI_438047#157101)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TELBUR_438048#157099)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TELBUR_438048#157099)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TELPOR_438049#157100)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TELPOR_438049#157100)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FAX_438050#157027)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_FAX_438050#157027)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PREFI2_438051#157087)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_PREFI2_438051#157087)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NOMASS_438052#157056)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NOMASS_438052#157056)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PNOASS_438053#157082)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_PNOASS_438053#157082)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NJFASS_438054#157054)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NJFASS_438054#157054)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATASS_438055#157013)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATASS_438055#157013)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_1A_438056#156977)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_1A_438056#156977)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_2A_438057#156979)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_2A_438057#156979)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPOA_438058#156993)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPOA_438058#156993)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VILLEA_438059#157109)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_VILLEA_438059#157109)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODMED_438060#156990)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODMED_438060#156990)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATCSS_438061#157014)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATCSS_438061#157014)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATF_D_438062#157017)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATF_D_438062#157017)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DAT100_438063#157009)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DAT100_438063#157009)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMSIR_438064#157073)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMSIR_438064#157073)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMSSA_438065#157074)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMSSA_438065#157074)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODSER_438066#156999)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODSER_438066#156999)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_RNGNAI_438067#157090)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_RNGNAI_438067#157090)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NATASS_438068#157051)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NATASS_438068#157051)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMACC_438069#157059)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMACC_438069#157059)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATACC_438070#157010)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATACC_438070#157010)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TYPEXO_438071#157107)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TYPEXO_438071#157107)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATMAJ_438072#157020)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATMAJ_438072#157020)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODUTI_438073#157003)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODUTI_438073#157003)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLCMU_438074#157030)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLCMU_438074#157030)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_QUALSS_438075#157089)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_QUALSS_438075#157089)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODREF_438076#156996)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODREF_438076#156996)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODREGAT_438077#156997)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODREGAT_438077#156997)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODCAIAT_438078#156986)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODCAIAT_438078#156986)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INDVITAL_438079#157041)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_INDVITAL_438079#157041)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CONMUT_438080#157006)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CONMUT_438080#157006)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADHMUT_438081#156976)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADHMUT_438081#156976)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_GARMUT_438082#157036)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_GARMUT_438082#157036)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_ORI_438083#157068)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_ORI_438083#157068)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODROUT_438084#156998)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODROUT_438084#156998)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DOMAINE_438085#157025)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DOMAINE_438085#157025)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INDTRAI_438086#157040)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_INDTRAI_438086#157040)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_IDHOTE_438087#157038)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_IDHOTE_438087#157038)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODSTS_438088#157001)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODSTS_438088#157001)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NIRIND_438089#157053)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NIRIND_438089#157053)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLDCD_438090#157031)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLDCD_438090#157031)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLPHOTO_438091#157035)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLPHOTO_438091#157035)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODMTR_438092#156991)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODMTR_438092#156991)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_3_438093#156982)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_3_438093#156982)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PAYS_ISO_438094#157079)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_PAYS_ISO_438094#157079)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_3A_438095#156981)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_3A_438095#156981)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_POIDS_MAJ_438096#157086)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_POIDS_MAJ_438096#157086)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODGESTION_438097#156988)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODGESTION_438097#156988)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ART115_438098#156985)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_ART115_438098#156985)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TAILLE_438099#157096)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TAILLE_438099#157096)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TAILLE_MAJ_438100#157097)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TAILLE_MAJ_438100#157097)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODETAB_PROD_438101#156987)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODETAB_PROD_438101#156987)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODSIT_PROD_438102#157000)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODSIT_PROD_438102#157000)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMDOS_PROD_438103#157065)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMDOS_PROD_438103#157065)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_PROD_438104#157071)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_PROD_438104#157071)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_ORI_P_438105#157070)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_ORI_P_438105#157070)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_438106#157044)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_438106#157044)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_TYPE_438107#157048)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_TYPE_438107#157048)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_DATE_438108#157045)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_DATE_438108#157045)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_SOURCE_438109#157047)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_SOURCE_438109#157047)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_STADMP_438110#157093)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_STADMP_438110#157093)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATDMP_438111#157016)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATDMP_438111#157016)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ALARMES_438112#156983)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_ALARMES_438112#156983)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_EMAIL_438113#157026)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_EMAIL_438113#157026)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CONSENT_SMS_438114#157007)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CONSENT_SMS_438114#157007)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DAT_CONSENT__438115#157023)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DAT_CONSENT__438115#157023)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATDCD_438116#157015)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATDCD_438116#157015)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLHLIM_438117#157034)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLHLIM_438117#157034)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATHLIM_438118#157019)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATHLIM_438118#157019)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPERSHLIM_438119#156992)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPERSHLIM_438119#156992)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLDIFF_438120#157032)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLDIFF_438120#157032)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_LISDEST_438121#157050)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_LISDEST_438121#157050)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_LANGUE_438122#157049)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_LANGUE_438122#157049)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMCAI_FT_438123#157061)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMCAI_FT_438123#157061)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODTARIFAMC_438124#157002)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODTARIFAMC_438124#157002)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLGRVE_438125#157033)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLGRVE_438125#157033)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLADRI_438126#157028)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLADRI_438126#157028)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATADRI_438127#157011)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATADRI_438127#157011)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATF_MUT_438128#157018)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATF_MUT_438128#157018)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_COMFAC_438129#157004)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_COMFAC_438129#157004)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMDOS_CLOUD_438130#157064)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMDOS_CLOUD_438130#157064)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NATION_438131#157052)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NATION_438131#157052)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TITRE_438132#157104)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TITRE_438132#157104)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TITRE_ASS_438133#157105)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TITRE_ASS_438133#157105)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TIQ_HISTOXML_438134#157102)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TIQ_HISTOXML_438134#157102)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TIQ_PNOLISTE_438135#157103)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TIQ_PNOLISTE_438135#157103)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPOSNAI_438136#156994)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPOSNAI_438136#156994)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INSI_438137#157042)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_INSI_438137#157042)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INSI_OID_438138#157043)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_INSI_OID_438138#157043)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TYPCONV_438139#157106)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TYPCONV_438139#157106)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CRISEC_438140#157008)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CRISEC_438140#157008)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_OPEREG_438141#157077)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_OPEREG_438141#157077)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLANNUAMC_438142#157029)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLANNUAMC_438142#157029)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_STAIPP_438143#157094)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_STAIPP_438143#157094)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PNONAI_438144#157083)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_PNONAI_438144#157083)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODINSEENAI_438145#156989)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODINSEENAI_438145#156989)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VILLENAI_438146#157110)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_VILLENAI_438146#157110)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PIECE_IDENT__438147#157081)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_PIECE_IDENT__438147#157081)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DAT_STAIPP_438148#157024)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DAT_STAIPP_438148#157024)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATAPCV_438149#157012)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATAPCV_438149#157012)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUM_APCV_438150#157076)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUM_APCV_438150#157076)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_HEUAPCV_438151#157037)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_HEUAPCV_438151#157037)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_SEC_438152#157072)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_SEC_438152#157072)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_HEURE_438153#157046)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_HEURE_438153#157046)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PERSAPREV_438154#157080)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_PERSAPREV_438154#157080)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TARIF_438155#157098)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TARIF_438155#157098)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NOMHL7_438156#157057)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NOMHL7_438156#157057)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_ORI_O_438157#157069)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_ORI_O_438157#157069)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_COMMENT_438158#157005)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_COMMENT_438158#157005)), MARX) END)

FileScan parquet [AT_ADHMUT_438081#156976,AT_ADR_1A_438056#156977,AT_ADR_1_438039#156978,AT_ADR_2A_438057#156979,AT_ADR_2_438040#156980,AT_ADR_3A_438095#156981,AT_ADR_3_438093#156982,AT_ALARMES_438112#156983,AT_ANTECE_438038#156984,AT_ART115_438098#156985,AT_CODCAIAT_438078#156986,AT_CODETAB_PROD_438101#156987,AT_CODGESTION_438097#156988,AT_CODINSEENAI_438145#156989,AT_CODMED_438060#156990,AT_CODMTR_438092#156991,AT_CODPERSHLIM_438119#156992,AT_CODPOA_438058#156993,AT_CODPOSNAI_438136#156994,AT_CODPOS_438041#156995,AT_CODREF_438076#156996,AT_CODREGAT_438077#156997,AT_CODROUT_438084#156998,AT_CODSER_438066#156999,... 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#156976, AT_ADR_1A_438056#156977, AT_ADR_1_438039#156978, AT_ADR_2A_438057#156979, AT_ADR_2_438040#156980, AT_ADR_3A_438095#156981, AT_ADR_3_438093#156982, AT_ALARMES_438112#156983, AT_ANTECE_438038#156984, AT_ART115_438098#156985, AT_CODCAIAT_438078#156986, AT_CODETAB_PROD_438101#156987, AT_CODGESTION_438097#156988, AT_CODINSEENAI_438145#156989, AT_CODMED_438060#156990, AT_CODMTR_438092#156991, AT_CODPERSHLIM_438119#156992, AT_CODPOA_438058#156993, AT_CODPOSNAI_438136#156994, AT_CODPOS_438041#156995, AT_CODREF_438076#156996, AT_CODREGAT_438077#156997, AT_CODROUT_438084#156998, AT_CODSER_438066#156999, AT_CODSIT_PROD_438102#157000, AT_CODSTS_438088#157001, AT_CODTARIFAMC_438124#157002, AT_CODUTI_438073#157003, AT_COMFAC_438129#157004, AT_COMMENT_438158#157005, AT_CONMUT_438080#157006, AT_CONSENT_SMS_438114#157007, AT_CRISEC_438140#157008, AT_DAT100_438063#157009, AT_DATACC_438070#157010, AT_DATADRI_438127#157011, AT_DATAPCV_438149#157012, AT_DATASS_438055#157013, AT_DATCSS_438061#157014, AT_DATDCD_438116#157015, AT_DATDMP_438111#157016, AT_DATF_D_438062#157017, AT_DATF_MUT_438128#157018, AT_DATHLIM_438118#157019, AT_DATMAJ_438072#157020, AT_DATNAISS_438030#157021, AT_DATNAI_438029#157022, AT_DAT_CONSENT__438115#157023, AT_DAT_STAIPP_438148#157024, AT_DOMAINE_438085#157025, AT_EMAIL_438113#157026, AT_FAX_438050#157027, AT_FLADRI_438126#157028, AT_FLANNUAMC_438142#157029, AT_FLCMU_438074#157030, AT_FLDCD_438090#157031, AT_FLDIFF_438120#157032, AT_FLGRVE_438125#157033, AT_FLHLIM_438117#157034, AT_FLPHOTO_438091#157035, AT_GARMUT_438082#157036, AT_HEUAPCV_438151#157037, AT_IDHOTE_438087#157038, AT_INDCEN_438036#157039, AT_INDTRAI_438086#157040, AT_INDVITAL_438079#157041, AT_INSI_438137#157042, AT_INSI_OID_438138#157043, AT_INS_438106#157044, AT_INS_DATE_438108#157045, AT_INS_HEURE_438153#157046, AT_INS_SOURCE_438109#157047, AT_INS_TYPE_438107#157048, AT_LANGUE_438122#157049, AT_LISDEST_438121#157050, AT_NATASS_438068#157051, AT_NATION_438131#157052, AT_NIRIND_438089#157053, AT_NJFASS_438054#157054, AT_NJFPAT_438028#157055, AT_NOMASS_438052#157056, AT_NOMHL7_438156#157057, AT_NOMPAT_438026#157058, AT_NUMACC_438069#157059, AT_NUMCAI_438044#157060, AT_NUMCAI_FT_438123#157061, AT_NUMCHA_438046#157062, AT_NUMDOS_438023#157063, AT_NUMDOS_CLOUD_438130#157064, AT_NUMDOS_PROD_438103#157065, AT_NUMMUT_438045#157066, AT_NUMPER_438032#157067, AT_NUMPER_ORI_438083#157068, AT_NUMPER_ORI_O_438157#157069, AT_NUMPER_ORI_P_438105#157070, AT_NUMPER_PROD_438104#157071, AT_NUMPER_SEC_438152#157072, AT_NUMSIR_438064#157073, AT_NUMSSA_438065#157074, AT_NUMSS_438037#157075, AT_NUM_APCV_438150#157076, AT_OPEREG_438141#157077, AT_PAYS_438043#157078, AT_PAYS_ISO_438094#157079, AT_PERSAPREV_438154#157080, AT_PIECE_IDENT__438147#157081, AT_PNOASS_438053#157082, AT_PNONAI_438144#157083, AT_PNOPAT_438027#157084, AT_POIDS_438035#157085, AT_POIDS_MAJ_438096#157086, AT_PREFI2_438051#157087, AT_PREFIX_438025#157088, AT_QUALSS_438075#157089, AT_RNGNAI_438067#157090, AT_SEXE_438031#157091, AT_SIGMA_438033#157092, AT_STADMP_438110#157093, AT_STAIPP_438143#157094, AT_STAPAT_438024#157095, AT_TAILLE_438099#157096, AT_TAILLE_MAJ_438100#157097, AT_TARIF_438155#157098, AT_TELBUR_438048#157099, AT_TELPOR_438049#157100, AT_TELPRI_438047#157101, AT_TIQ_HISTOXML_438134#157102, AT_TIQ_PNOLISTE_438135#157103, AT_TITRE_438132#157104, AT_TITRE_ASS_438133#157105, AT_TYPCONV_438139#157106, AT_TYPEXO_438071#157107, AT_VERROU_438034#157108, AT_VILLEA_438059#157109, AT_VILLENAI_438146#157110, AT_VILLE_438042#157111]
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#156976, AT_ADR_1A_438056#156977, AT_ADR_1_438039#156978, AT_ADR_2A_438057#156979, AT_ADR_2_438040#156980, AT_ADR_3A_438095#156981, AT_ADR_3_438093#156982, AT_ALARMES_438112#156983, AT_ANTECE_438038#156984, AT_ART115_438098#156985, AT_CODCAIAT_438078#156986, AT_CODETAB_PROD_438101#156987, AT_CODGESTION_438097#156988, AT_CODINSEENAI_438145#156989, AT_CODMED_438060#156990, AT_CODMTR_438092#156991, AT_CODPERSHLIM_438119#156992, AT_CODPOA_438058#156993, AT_CODPOSNAI_438136#156994, AT_CODPOS_438041#156995, AT_CODREF_438076#156996, AT_CODREGAT_438077#156997, AT_CODROUT_438084#156998, AT_CODSER_438066#156999, AT_CODSIT_PROD_438102#157000, AT_CODSTS_438088#157001, AT_CODTARIFAMC_438124#157002, AT_CODUTI_438073#157003, AT_COMFAC_438129#157004, AT_COMMENT_438158#157005, AT_CONMUT_438080#157006, AT_CONSENT_SMS_438114#157007, AT_CRISEC_438140#157008, AT_DAT100_438063#157009, AT_DATACC_438070#157010, AT_DATADRI_438127#157011, AT_DATAPCV_438149#157012, AT_DATASS_438055#157013, AT_DATCSS_438061#157014, AT_DATDCD_438116#157015, AT_DATDMP_438111#157016, AT_DATF_D_438062#157017, AT_DATF_MUT_438128#157018, AT_DATHLIM_438118#157019, AT_DATMAJ_438072#157020, AT_DATNAISS_438030#157021, AT_DATNAI_438029#157022, AT_DAT_CONSENT__438115#157023, AT_DAT_STAIPP_438148#157024, AT_DOMAINE_438085#157025, AT_EMAIL_438113#157026, AT_FAX_438050#157027, AT_FLADRI_438126#157028, AT_FLANNUAMC_438142#157029, AT_FLCMU_438074#157030, AT_FLDCD_438090#157031, AT_FLDIFF_438120#157032, AT_FLGRVE_438125#157033, AT_FLHLIM_438117#157034, AT_FLPHOTO_438091#157035, AT_GARMUT_438082#157036, AT_HEUAPCV_438151#157037, AT_IDHOTE_438087#157038, AT_INDCEN_438036#157039, AT_INDTRAI_438086#157040, AT_INDVITAL_438079#157041, AT_INSI_438137#157042, AT_INSI_OID_438138#157043, AT_INS_438106#157044, AT_INS_DATE_438108#157045, AT_INS_HEURE_438153#157046, AT_INS_SOURCE_438109#157047, AT_INS_TYPE_438107#157048, AT_LANGUE_438122#157049, AT_LISDEST_438121#157050, AT_NATASS_438068#157051, AT_NATION_438131#157052, AT_NIRIND_438089#157053, AT_NJFASS_438054#157054, AT_NJFPAT_438028#157055, AT_NOMASS_438052#157056, AT_NOMHL7_438156#157057, AT_NOMPAT_438026#157058, AT_NUMACC_438069#157059, AT_NUMCAI_438044#157060, AT_NUMCAI_FT_438123#157061, AT_NUMCHA_438046#157062, AT_NUMDOS_438023#157063, AT_NUMDOS_CLOUD_438130#157064, AT_NUMDOS_PROD_438103#157065, AT_NUMMUT_438045#157066, AT_NUMPER_438032#157067, AT_NUMPER_ORI_438083#157068, AT_NUMPER_ORI_O_438157#157069, AT_NUMPER_ORI_P_438105#157070, AT_NUMPER_PROD_438104#157071, AT_NUMPER_SEC_438152#157072, AT_NUMSIR_438064#157073, AT_NUMSSA_438065#157074, AT_NUMSS_438037#157075, AT_NUM_APCV_438150#157076, AT_OPEREG_438141#157077, AT_PAYS_438043#157078, AT_PAYS_ISO_438094#157079, AT_PERSAPREV_438154#157080, AT_PIECE_IDENT__438147#157081, AT_PNOASS_438053#157082, AT_PNONAI_438144#157083, AT_PNOPAT_438027#157084, AT_POIDS_438035#157085, AT_POIDS_MAJ_438096#157086, AT_PREFI2_438051#157087, AT_PREFIX_438025#157088, AT_QUALSS_438075#157089, AT_RNGNAI_438067#157090, AT_SEXE_438031#157091, AT_SIGMA_438033#157092, AT_STADMP_438110#157093, AT_STAIPP_438143#157094, AT_STAPAT_438024#157095, AT_TAILLE_438099#157096, AT_TAILLE_MAJ_438100#157097, AT_TARIF_438155#157098, AT_TELBUR_438048#157099, AT_TELPOR_438049#157100, AT_TELPRI_438047#157101, AT_TIQ_HISTOXML_438134#157102, AT_TIQ_PNOLISTE_438135#157103, AT_TITRE_438132#157104, AT_TITRE_ASS_438133#157105, AT_TYPCONV_438139#157106, AT_TYPEXO_438071#157107, AT_VERROU_438034#157108, AT_VILLEA_438059#157109, AT_VILLENAI_438146#157110, AT_VILLE_438042#157111]
Condition : (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMDOS_438023#157063)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMDOS_438023#157063)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_STAPAT_438024#157095)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_STAPAT_438024#157095)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PREFIX_438025#157088)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_PREFIX_438025#157088)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NOMPAT_438026#157058)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NOMPAT_438026#157058)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PNOPAT_438027#157084)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_PNOPAT_438027#157084)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NJFPAT_438028#157055)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NJFPAT_438028#157055)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATNAI_438029#157022)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATNAI_438029#157022)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATNAISS_438030#157021)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATNAISS_438030#157021)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_SEXE_438031#157091)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_SEXE_438031#157091)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_438032#157067)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_438032#157067)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_SIGMA_438033#157092)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_SIGMA_438033#157092)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VERROU_438034#157108)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_VERROU_438034#157108)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_POIDS_438035#157085)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_POIDS_438035#157085)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INDCEN_438036#157039)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_INDCEN_438036#157039)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMSS_438037#157075)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMSS_438037#157075)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ANTECE_438038#156984)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_ANTECE_438038#156984)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_1_438039#156978)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_1_438039#156978)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_2_438040#156980)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_2_438040#156980)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPOS_438041#156995)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPOS_438041#156995)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VILLE_438042#157111)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_VILLE_438042#157111)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PAYS_438043#157078)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_PAYS_438043#157078)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMCAI_438044#157060)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMCAI_438044#157060)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMMUT_438045#157066)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMMUT_438045#157066)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMCHA_438046#157062)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMCHA_438046#157062)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TELPRI_438047#157101)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TELPRI_438047#157101)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TELBUR_438048#157099)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TELBUR_438048#157099)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TELPOR_438049#157100)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TELPOR_438049#157100)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FAX_438050#157027)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_FAX_438050#157027)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PREFI2_438051#157087)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_PREFI2_438051#157087)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NOMASS_438052#157056)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NOMASS_438052#157056)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PNOASS_438053#157082)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_PNOASS_438053#157082)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NJFASS_438054#157054)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NJFASS_438054#157054)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATASS_438055#157013)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATASS_438055#157013)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_1A_438056#156977)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_1A_438056#156977)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_2A_438057#156979)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_2A_438057#156979)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPOA_438058#156993)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPOA_438058#156993)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VILLEA_438059#157109)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_VILLEA_438059#157109)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODMED_438060#156990)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODMED_438060#156990)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATCSS_438061#157014)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATCSS_438061#157014)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATF_D_438062#157017)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATF_D_438062#157017)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DAT100_438063#157009)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DAT100_438063#157009)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMSIR_438064#157073)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMSIR_438064#157073)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMSSA_438065#157074)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMSSA_438065#157074)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODSER_438066#156999)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODSER_438066#156999)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_RNGNAI_438067#157090)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_RNGNAI_438067#157090)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NATASS_438068#157051)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NATASS_438068#157051)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMACC_438069#157059)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMACC_438069#157059)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATACC_438070#157010)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATACC_438070#157010)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TYPEXO_438071#157107)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TYPEXO_438071#157107)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATMAJ_438072#157020)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATMAJ_438072#157020)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODUTI_438073#157003)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODUTI_438073#157003)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLCMU_438074#157030)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLCMU_438074#157030)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_QUALSS_438075#157089)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_QUALSS_438075#157089)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODREF_438076#156996)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODREF_438076#156996)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODREGAT_438077#156997)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODREGAT_438077#156997)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODCAIAT_438078#156986)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODCAIAT_438078#156986)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INDVITAL_438079#157041)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_INDVITAL_438079#157041)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CONMUT_438080#157006)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CONMUT_438080#157006)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADHMUT_438081#156976)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADHMUT_438081#156976)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_GARMUT_438082#157036)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_GARMUT_438082#157036)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_ORI_438083#157068)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_ORI_438083#157068)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODROUT_438084#156998)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODROUT_438084#156998)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DOMAINE_438085#157025)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DOMAINE_438085#157025)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INDTRAI_438086#157040)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_INDTRAI_438086#157040)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_IDHOTE_438087#157038)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_IDHOTE_438087#157038)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODSTS_438088#157001)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODSTS_438088#157001)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NIRIND_438089#157053)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NIRIND_438089#157053)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLDCD_438090#157031)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLDCD_438090#157031)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLPHOTO_438091#157035)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLPHOTO_438091#157035)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODMTR_438092#156991)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODMTR_438092#156991)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_3_438093#156982)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_3_438093#156982)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PAYS_ISO_438094#157079)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_PAYS_ISO_438094#157079)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ADR_3A_438095#156981)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_ADR_3A_438095#156981)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_POIDS_MAJ_438096#157086)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_POIDS_MAJ_438096#157086)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODGESTION_438097#156988)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODGESTION_438097#156988)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ART115_438098#156985)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_ART115_438098#156985)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TAILLE_438099#157096)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TAILLE_438099#157096)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TAILLE_MAJ_438100#157097)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TAILLE_MAJ_438100#157097)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODETAB_PROD_438101#156987)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODETAB_PROD_438101#156987)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODSIT_PROD_438102#157000)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODSIT_PROD_438102#157000)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMDOS_PROD_438103#157065)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMDOS_PROD_438103#157065)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_PROD_438104#157071)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_PROD_438104#157071)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_ORI_P_438105#157070)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_ORI_P_438105#157070)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_438106#157044)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_438106#157044)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_TYPE_438107#157048)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_TYPE_438107#157048)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_DATE_438108#157045)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_DATE_438108#157045)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_SOURCE_438109#157047)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_SOURCE_438109#157047)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_STADMP_438110#157093)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_STADMP_438110#157093)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATDMP_438111#157016)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATDMP_438111#157016)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_ALARMES_438112#156983)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_ALARMES_438112#156983)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_EMAIL_438113#157026)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_EMAIL_438113#157026)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CONSENT_SMS_438114#157007)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CONSENT_SMS_438114#157007)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DAT_CONSENT__438115#157023)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DAT_CONSENT__438115#157023)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATDCD_438116#157015)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATDCD_438116#157015)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLHLIM_438117#157034)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLHLIM_438117#157034)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATHLIM_438118#157019)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATHLIM_438118#157019)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPERSHLIM_438119#156992)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPERSHLIM_438119#156992)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLDIFF_438120#157032)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLDIFF_438120#157032)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_LISDEST_438121#157050)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_LISDEST_438121#157050)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_LANGUE_438122#157049)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_LANGUE_438122#157049)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMCAI_FT_438123#157061)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMCAI_FT_438123#157061)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODTARIFAMC_438124#157002)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODTARIFAMC_438124#157002)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLGRVE_438125#157033)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLGRVE_438125#157033)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLADRI_438126#157028)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLADRI_438126#157028)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATADRI_438127#157011)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATADRI_438127#157011)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATF_MUT_438128#157018)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATF_MUT_438128#157018)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_COMFAC_438129#157004)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_COMFAC_438129#157004)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMDOS_CLOUD_438130#157064)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMDOS_CLOUD_438130#157064)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NATION_438131#157052)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NATION_438131#157052)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TITRE_438132#157104)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TITRE_438132#157104)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TITRE_ASS_438133#157105)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TITRE_ASS_438133#157105)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TIQ_HISTOXML_438134#157102)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TIQ_HISTOXML_438134#157102)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TIQ_PNOLISTE_438135#157103)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TIQ_PNOLISTE_438135#157103)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODPOSNAI_438136#156994)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODPOSNAI_438136#156994)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INSI_438137#157042)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_INSI_438137#157042)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INSI_OID_438138#157043)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_INSI_OID_438138#157043)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TYPCONV_438139#157106)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TYPCONV_438139#157106)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CRISEC_438140#157008)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CRISEC_438140#157008)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_OPEREG_438141#157077)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_OPEREG_438141#157077)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_FLANNUAMC_438142#157029)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_FLANNUAMC_438142#157029)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_STAIPP_438143#157094)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_STAIPP_438143#157094)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PNONAI_438144#157083)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_PNONAI_438144#157083)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_CODINSEENAI_438145#156989)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_CODINSEENAI_438145#156989)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_VILLENAI_438146#157110)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_VILLENAI_438146#157110)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PIECE_IDENT__438147#157081)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_PIECE_IDENT__438147#157081)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DAT_STAIPP_438148#157024)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DAT_STAIPP_438148#157024)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_DATAPCV_438149#157012)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_DATAPCV_438149#157012)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUM_APCV_438150#157076)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUM_APCV_438150#157076)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_HEUAPCV_438151#157037)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_HEUAPCV_438151#157037)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_SEC_438152#157072)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_SEC_438152#157072)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_INS_HEURE_438153#157046)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_INS_HEURE_438153#157046)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_PERSAPREV_438154#157080)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_PERSAPREV_438154#157080)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_TARIF_438155#157098)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_TARIF_438155#157098)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NOMHL7_438156#157057)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NOMHL7_438156#157057)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_NUMPER_ORI_O_438157#157069)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_NUMPER_ORI_O_438157#157069)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(AT_COMMENT_438158#157005)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(AT_COMMENT_438158#157005)), MARX) END)

(3) Project
Output [136]: [AT_NUMDOS_438023#157063 AS COL_906FFCAC_28FB_4AF5_8A40_FA2E0ADB48D0#157792, AT_STAPAT_438024#157095 AS COL_AF7163BC_112C_4118_AC07_C25B8DD02C5C#157793, AT_PREFIX_438025#157088 AS COL_6BCF01B9_EEAC_44BC_9ABE_F9A47B0FF0EC#157794, AT_NOMPAT_438026#157058 AS COL_84FBD601_2E72_457B_905D_C80C8FAA2257#157795, AT_PNOPAT_438027#157084 AS COL_7C081758_9AE8_4D43_B249_7A3E6043FC22#157796, AT_NJFPAT_438028#157055 AS COL_D01238FB_A545_440E_97F7_312B85808E7C#157797, AT_DATNAI_438029#157022 AS COL_F996254B_D9DC_4C0A_9DD9_68BA2547B465#157798, AT_DATNAISS_438030#157021 AS COL_7D384105_A968_40D5_BF9C_4AAEACE72F75#157799, AT_SEXE_438031#157091 AS COL_C66F8C84_F2F0_40EA_9198_18867C16097C#157800, AT_NUMPER_438032#157067 AS COL_82E82ED3_0457_43E2_9856_B8F0AABC06FC#157801, AT_SIGMA_438033#157092 AS COL_C38053BD_111C_48FC_BB99_634D02020D60#157802, AT_VERROU_438034#157108 AS COL_4B1A77C7_90E2_4595_A649_7BEE426027DA#157803, AT_POIDS_438035#157085 AS COL_FC90D543_DC69_403C_95BB_69A661B66829#157804, AT_INDCEN_438036#157039 AS COL_1C6D3A39_B5DA_4F71_A95A_70889566840F#157805, AT_NUMSS_438037#157075 AS COL_8C572EF3_AACA_4F30_93E5_5F93351C915D#157806, AT_ANTECE_438038#156984 AS COL_85992C0B_96B7_40A0_8BCD_7032F939CC45#157807, AT_ADR_1_438039#156978 AS COL_99A9F6CB_7CDB_4283_9EA9_3B59266D1825#157808, AT_ADR_2_438040#156980 AS COL_B9366DC5_32A5_437C_8127_C6CDF8505705#157809, AT_CODPOS_438041#156995 AS COL_B2F92CF3_40E6_4734_81B9_E28B54867795#157810, AT_VILLE_438042#157111 AS COL_41F1EB02_EDC5_4945_800E_70F44E6C75C8#157811, AT_PAYS_438043#157078 AS COL_A4FB5F42_1464_4933_B95D_1116377A0260#157812, AT_NUMCAI_438044#157060 AS COL_09DA39AF_E548_418F_AF81_2A103081BDE5#157813, AT_NUMMUT_438045#157066 AS COL_6EE5FB06_5AE3_43DB_B5AD_DB30319C004E#157814, AT_NUMCHA_438046#157062 AS COL_ACD91A48_6196_46C1_A8FF_92E31806A574#157815, AT_TELPRI_438047#157101 AS COL_F96C5BD3_3034_4B9C_896E_CCE42665C224#157816, AT_TELBUR_438048#157099 AS COL_B86C8EFB_8AB3_4738_AA8F_C9F866F85211#157817, AT_TELPOR_438049#157100 AS COL_59330B73_9E62_4E78_92EF_F521FB99B7B7#157818, AT_FAX_438050#157027 AS COL_C77F7648_2D97_4C98_B3A5_41B35F30F1EC#157819, AT_PREFI2_438051#157087 AS COL_6FE6C7F5_BE1D_4FE0_8CA8_0FE94F9F42CD#157820, AT_NOMASS_438052#157056 AS COL_9C262048_4CA3_4AD8_B61D_F23FA6DB009F#157821, AT_PNOASS_438053#157082 AS COL_75CB20B6_611B_40D0_8A2F_DD1326DD5570#157822, AT_NJFASS_438054#157054 AS COL_EA6A16CD_9BEF_409F_AB54_5F5B30597825#157823, AT_DATASS_438055#157013 AS COL_266CB719_3E4E_4070_8347_6374DCF3E1E8#157824, AT_ADR_1A_438056#156977 AS COL_CC05DE5C_AD1E_4191_BB72_61DE83B0E095#157825, AT_ADR_2A_438057#156979 AS COL_5521C813_FA3C_4DBC_9A96_38AB2239BA7F#157826, AT_CODPOA_438058#156993 AS COL_C5685592_9A0A_473B_98BF_B076635D0A97#157827, AT_VILLEA_438059#157109 AS COL_3F348C2B_334F_4A9C_B033_F60B71B4F29B#157828, AT_CODMED_438060#156990 AS COL_F78783D6_8004_4D0C_94AC_8A78B39771F2#157829, AT_DATCSS_438061#157014 AS COL_5841249B_1421_4729_B5E9_F4F224D00319#157830, AT_DATF_D_438062#157017 AS COL_36A7A003_E1A8_4978_8F55_989DF4682427#157831, AT_DAT100_438063#157009 AS COL_59958381_9426_408C_9F3E_8B1480D10FDA#157832, AT_NUMSIR_438064#157073 AS COL_1585BDAA_CA08_4B1E_9FB2_F26812D2CFAF#157833, AT_NUMSSA_438065#157074 AS COL_B39BB748_084E_4A4A_9F90_C775349879AE#157834, AT_CODSER_438066#156999 AS COL_BE5BCD1D_2F62_4B8C_8DB2_309AF54927BD#157835, AT_RNGNAI_438067#157090 AS COL_311F84A4_548D_4D54_9781_04264AB895F7#157836, AT_NATASS_438068#157051 AS COL_E3197756_8062_41C5_A99B_DC53A37D8F52#157837, AT_NUMACC_438069#157059 AS COL_F2B96635_0A73_45F2_80FD_7E6DCE85CF59#157838, AT_DATACC_438070#157010 AS COL_37A9821A_3561_440F_B57C_D4244C85AE8E#157839, AT_TYPEXO_438071#157107 AS COL_A846C64C_ECBF_450E_BC09_27A72C877F14#157840, AT_DATMAJ_438072#157020 AS COL_AD7CA9DF_CBB8_4A6D_9FAD_60F70D35A807#157841, AT_CODUTI_438073#157003 AS COL_1CA90B84_14F3_4684_8F0D_4E51F4DFE8FD#157842, AT_FLCMU_438074#157030 AS COL_19273F34_9FFE_4FEE_A42A_6CD6C4DDD42A#157843, AT_QUALSS_438075#157089 AS COL_C52BC17D_E97D_4E61_B1ED_E321E11DC3C1#157844, AT_CODREF_438076#156996 AS COL_C1DFB517_7A21_4901_B9AF_743D28473167#157845, AT_CODREGAT_438077#156997 AS COL_18A83621_A8F5_4561_8063_55A35ABCE00B#157846, AT_CODCAIAT_438078#156986 AS COL_27127769_B336_40C8_A359_22733BAB60A2#157847, AT_INDVITAL_438079#157041 AS COL_4DCE723A_4A78_4D7A_A06A_0A512F89B082#157848, AT_CONMUT_438080#157006 AS COL_5AC6FFE9_23BD_4A6F_B6C6_554C2C6F10B8#157849, AT_ADHMUT_438081#156976 AS COL_30A3B2EC_1F7B_4CA4_8C25_AC063D3E440A#157850, AT_GARMUT_438082#157036 AS COL_A24870AB_A6B8_47A4_B6D0_67493D4209CE#157851, AT_NUMPER_ORI_438083#157068 AS COL_65939AC3_96BD_4B9A_8A1F_4EC13E90AEF1#157852, AT_CODROUT_438084#156998 AS COL_94FBB6D9_9E80_4C42_BB32_46D771F654B7#157853, AT_DOMAINE_438085#157025 AS COL_AAA3C84D_AA91_4E69_9B24_1EA974EF8BE3#157854, AT_INDTRAI_438086#157040 AS COL_9272EFC7_B3C0_4249_9B0F_AB15051B5B84#157855, AT_IDHOTE_438087#157038 AS COL_D7B24A12_BD5E_4C80_938A_CBCF14622C87#157856, AT_CODSTS_438088#157001 AS COL_0BEB3C6F_4845_449A_AC10_E97B1C7DD847#157857, AT_NIRIND_438089#157053 AS COL_57CA7526_DBC8_4166_82B3_0158D6C6E088#157858, AT_FLDCD_438090#157031 AS COL_7E1A6B10_EB29_4FD8_90C6_2D5973140B79#157859, AT_FLPHOTO_438091#157035 AS COL_8B801653_58ED_40BC_BC98_19B56D496F9A#157860, AT_CODMTR_438092#156991 AS COL_CBBE7DA0_51BE_44EB_B2A7_B076FB7FEB39#157861, AT_ADR_3_438093#156982 AS COL_7D2ECEA0_48BC_4A6E_91DA_8255B7BE168D#157862, AT_PAYS_ISO_438094#157079 AS COL_BE7FA851_69AB_489E_A1C6_B408C2D8A8BE#157863, AT_ADR_3A_438095#156981 AS COL_59874B90_6EA0_4D62_AD0D_E6C3B36B8386#157864, AT_POIDS_MAJ_438096#157086 AS COL_477A364D_FE8A_4B56_B09A_992145143069#157865, AT_CODGESTION_438097#156988 AS COL_D941E4DF_23C6_4BA5_BCF6_0244734E85E3#157866, AT_ART115_438098#156985 AS COL_CF6F03EA_ECEA_43D7_9DF3_0EE1BD611034#157867, AT_TAILLE_438099#157096 AS COL_C8B4B4A4_92BA_4B01_B0F3_FE08084F70A0#157868, AT_TAILLE_MAJ_438100#157097 AS COL_73813DD3_DC5D_47CC_BC4F_A20ED9DEE13B#157869, AT_CODETAB_PROD_438101#156987 AS COL_5FF3005B_8526_49A3_8F7D_96D4181C9598#157870, AT_CODSIT_PROD_438102#157000 AS COL_410EF636_9400_4754_94AF_C8ADBA94C618#157871, AT_NUMDOS_PROD_438103#157065 AS COL_A19D03AD_AC45_49E4_A958_7E1BCA9E4EDC#157872, AT_NUMPER_PROD_438104#157071 AS COL_9935D351_0A91_424B_AFB1_4120C6C96D97#157873, AT_NUMPER_ORI_P_438105#157070 AS COL_A50ADE9A_2311_4B6D_AEC8_90F3C5202FB8#157874, AT_INS_438106#157044 AS COL_CD4D7100_F05D_4088_A293_286F5F3F51B7#157875, AT_INS_TYPE_438107#157048 AS COL_FD2B3E63_A4FE_44B4_A401_1ADE36AE8F13#157876, AT_INS_DATE_438108#157045 AS COL_C046C43E_2BC4_4A2B_824D_441B5CD9A271#157877, AT_INS_SOURCE_438109#157047 AS COL_B25FA5DE_FDE1_4791_8014_6058510508DC#157878, AT_STADMP_438110#157093 AS COL_4223EAC5_121F_4E3D_B81E_434B8842E436#157879, AT_DATDMP_438111#157016 AS COL_331437BF_70FC_4702_A134_388048A3F31C#157880, AT_ALARMES_438112#156983 AS COL_4929EDBF_6219_4B11_868C_C0FCA6994CE3#157881, AT_EMAIL_438113#157026 AS COL_34A94C2C_7542_4234_BDE7_C206BA6185AD#157882, AT_CONSENT_SMS_438114#157007 AS COL_6FA1BA25_2C34_4F42_802D_009B3F695073#157883, AT_DAT_CONSENT__438115#157023 AS COL_13AA37E8_D11E_4B19_ABD6_59EEFC502D81#157884, AT_DATDCD_438116#157015 AS COL_96A5675F_2EFD_4586_8721_F78FBC79F22F#157885, AT_FLHLIM_438117#157034 AS COL_0761E2A8_F7AC_46DF_BE75_2A0B4D0113B6#157886, AT_DATHLIM_438118#157019 AS COL_6D8A59D1_AFCE_41C0_8D32_BDA41BB8CA5E#157887, AT_CODPERSHLIM_438119#156992 AS COL_44B0483F_1195_41A8_A6EB_1BE7AAB1D35D#157888, AT_FLDIFF_438120#157032 AS COL_5BED7059_6B19_48FA_818D_90A039B1C963#157889, AT_LISDEST_438121#157050 AS COL_A344119C_9542_4595_B481_61DEB7E19F31#157890, AT_LANGUE_438122#157049 AS COL_7E18EC72_C8C0_4BDB_BAEF_E99C3E4B6BB0#157891, AT_NUMCAI_FT_438123#157061 AS COL_2DD4AC57_925C_4479_B703_8D4550E70B08#157892, AT_CODTARIFAMC_438124#157002 AS COL_19E46871_BA7B_49A2_872F_16C637044EFD#157893, AT_FLGRVE_438125#157033 AS COL_3087450F_1C85_47C5_88D7_56E50774E65C#157894, AT_FLADRI_438126#157028 AS COL_BD23F51D_D745_4F78_9291_A52C2DD2D0F9#157895, AT_DATADRI_438127#157011 AS COL_1822DAEA_0FA1_4E78_AB99_D65BD675D176#157896, AT_DATF_MUT_438128#157018 AS COL_953E80BC_BB14_4548_BCD7_77CAB30299C6#157897, AT_COMFAC_438129#157004 AS COL_44C6C7A8_8951_43C0_8D75_E4E53E29E08A#157898, AT_NUMDOS_CLOUD_438130#157064 AS COL_1697896D_EEFF_4537_967A_A61ED9CC1373#157899, AT_NATION_438131#157052 AS COL_E4D462E4_4514_48AA_A6FA_EF33200BD333#157900, AT_TITRE_438132#157104 AS COL_06D70268_9083_4C86_91BE_D66C83DDB34E#157901, AT_TITRE_ASS_438133#157105 AS COL_2DC3C227_A30C_4D1E_80D9_81B9E8A284AC#157902, AT_TIQ_HISTOXML_438134#157102 AS COL_ADB0BF2D_8A7E_4286_9FE0_BBC74B1FA2A3#157903, AT_TIQ_PNOLISTE_438135#157103 AS COL_B067C171_7ABF_46AE_ABFB_635D944A168B#157904, AT_CODPOSNAI_438136#156994 AS COL_E48E7713_469E_4C38_A290_474E8F93676B#157905, AT_INSI_438137#157042 AS COL_EA5B2000_1F90_4325_AFA6_124F4FED7296#157906, AT_INSI_OID_438138#157043 AS COL_32EA797E_38E9_42AB_ADCC_116BC747D720#157907, AT_TYPCONV_438139#157106 AS COL_70E67801_334B_4C5E_BA26_41844AB50342#157908, AT_CRISEC_438140#157008 AS COL_88371930_8F54_45ED_9BCF_23907B6D2F34#157909, AT_OPEREG_438141#157077 AS COL_A64896AA_5D64_4D2B_9D24_725DEC7C3038#157910, AT_FLANNUAMC_438142#157029 AS COL_BD5000D3_285B_49F2_83CC_B4E59D8A751D#157911, AT_STAIPP_438143#157094 AS COL_59372E1A_138A_4DD5_8108_E96E5822370E#157912, AT_PNONAI_438144#157083 AS COL_71774A6D_B1E3_4DD0_B2A6_E595C351EC84#157913, AT_CODINSEENAI_438145#156989 AS COL_3102588B_AE53_43A1_A9FD_B439FDDB9794#157914, AT_VILLENAI_438146#157110 AS COL_12339819_5F67_4094_82C3_BC87AAC485B3#157915, AT_PIECE_IDENT__438147#157081 AS COL_D28039F0_A317_45F3_9E04_ADB5D4110669#157916, AT_DAT_STAIPP_438148#157024 AS COL_9FCC827E_F70A_4DE5_8920_CAA94DAF6B52#157917, AT_DATAPCV_438149#157012 AS COL_51829760_0B75_4DC7_B5E7_AFCC86D575BC#157918, AT_NUM_APCV_438150#157076 AS COL_5AA58226_D459_471C_B1D9_EEA800E53F47#157919, AT_HEUAPCV_438151#157037 AS COL_044D19AD_A125_478C_9607_E8C55A82B982#157920, AT_NUMPER_SEC_438152#157072 AS COL_1B6133B7_D2FD_4BB5_8D2E_E1EB96895E75#157921, AT_INS_HEURE_438153#157046 AS COL_CB16144A_777E_4779_A0A4_8958713F376A#157922, AT_PERSAPREV_438154#157080 AS COL_B98BE990_BF40_4862_8DCF_7D664C858254#157923, AT_TARIF_438155#157098 AS COL_D81CDEDD_D745_44AF_B984_361321C6DAE5#157924, AT_NOMHL7_438156#157057 AS COL_E5E3DFC4_9736_4FBE_85D0_EFB20EEB6B0F#157925, AT_NUMPER_ORI_O_438157#157069 AS COL_4D92C747_708B_41B5_B42D_D88047FF1A9D#157926, AT_COMMENT_438158#157005 AS COL_C8B640A8_C2E2_473C_A096_AE2AEE7CC54B#157927]
Input [136]: [AT_ADHMUT_438081#156976, AT_ADR_1A_438056#156977, AT_ADR_1_438039#156978, AT_ADR_2A_438057#156979, AT_ADR_2_438040#156980, AT_ADR_3A_438095#156981, AT_ADR_3_438093#156982, AT_ALARMES_438112#156983, AT_ANTECE_438038#156984, AT_ART115_438098#156985, AT_CODCAIAT_438078#156986, AT_CODETAB_PROD_438101#156987, AT_CODGESTION_438097#156988, AT_CODINSEENAI_438145#156989, AT_CODMED_438060#156990, AT_CODMTR_438092#156991, AT_CODPERSHLIM_438119#156992, AT_CODPOA_438058#156993, AT_CODPOSNAI_438136#156994, AT_CODPOS_438041#156995, AT_CODREF_438076#156996, AT_CODREGAT_438077#156997, AT_CODROUT_438084#156998, AT_CODSER_438066#156999, AT_CODSIT_PROD_438102#157000, AT_CODSTS_438088#157001, AT_CODTARIFAMC_438124#157002, AT_CODUTI_438073#157003, AT_COMFAC_438129#157004, AT_COMMENT_438158#157005, AT_CONMUT_438080#157006, AT_CONSENT_SMS_438114#157007, AT_CRISEC_438140#157008, AT_DAT100_438063#157009, AT_DATACC_438070#157010, AT_DATADRI_438127#157011, AT_DATAPCV_438149#157012, AT_DATASS_438055#157013, AT_DATCSS_438061#157014, AT_DATDCD_438116#157015, AT_DATDMP_438111#157016, AT_DATF_D_438062#157017, AT_DATF_MUT_438128#157018, AT_DATHLIM_438118#157019, AT_DATMAJ_438072#157020, AT_DATNAISS_438030#157021, AT_DATNAI_438029#157022, AT_DAT_CONSENT__438115#157023, AT_DAT_STAIPP_438148#157024, AT_DOMAINE_438085#157025, AT_EMAIL_438113#157026, AT_FAX_438050#157027, AT_FLADRI_438126#157028, AT_FLANNUAMC_438142#157029, AT_FLCMU_438074#157030, AT_FLDCD_438090#157031, AT_FLDIFF_438120#157032, AT_FLGRVE_438125#157033, AT_FLHLIM_438117#157034, AT_FLPHOTO_438091#157035, AT_GARMUT_438082#157036, AT_HEUAPCV_438151#157037, AT_IDHOTE_438087#157038, AT_INDCEN_438036#157039, AT_INDTRAI_438086#157040, AT_INDVITAL_438079#157041, AT_INSI_438137#157042, AT_INSI_OID_438138#157043, AT_INS_438106#157044, AT_INS_DATE_438108#157045, AT_INS_HEURE_438153#157046, AT_INS_SOURCE_438109#157047, AT_INS_TYPE_438107#157048, AT_LANGUE_438122#157049, AT_LISDEST_438121#157050, AT_NATASS_438068#157051, AT_NATION_438131#157052, AT_NIRIND_438089#157053, AT_NJFASS_438054#157054, AT_NJFPAT_438028#157055, AT_NOMASS_438052#157056, AT_NOMHL7_438156#157057, AT_NOMPAT_438026#157058, AT_NUMACC_438069#157059, AT_NUMCAI_438044#157060, AT_NUMCAI_FT_438123#157061, AT_NUMCHA_438046#157062, AT_NUMDOS_438023#157063, AT_NUMDOS_CLOUD_438130#157064, AT_NUMDOS_PROD_438103#157065, AT_NUMMUT_438045#157066, AT_NUMPER_438032#157067, AT_NUMPER_ORI_438083#157068, AT_NUMPER_ORI_O_438157#157069, AT_NUMPER_ORI_P_438105#157070, AT_NUMPER_PROD_438104#157071, AT_NUMPER_SEC_438152#157072, AT_NUMSIR_438064#157073, AT_NUMSSA_438065#157074, AT_NUMSS_438037#157075, AT_NUM_APCV_438150#157076, AT_OPEREG_438141#157077, AT_PAYS_438043#157078, AT_PAYS_ISO_438094#157079, AT_PERSAPREV_438154#157080, AT_PIECE_IDENT__438147#157081, AT_PNOASS_438053#157082, AT_PNONAI_438144#157083, AT_PNOPAT_438027#157084, AT_POIDS_438035#157085, AT_POIDS_MAJ_438096#157086, AT_PREFI2_438051#157087, AT_PREFIX_438025#157088, AT_QUALSS_438075#157089, AT_RNGNAI_438067#157090, AT_SEXE_438031#157091, AT_SIGMA_438033#157092, AT_STADMP_438110#157093, AT_STAIPP_438143#157094, AT_STAPAT_438024#157095, AT_TAILLE_438099#157096, AT_TAILLE_MAJ_438100#157097, AT_TARIF_438155#157098, AT_TELBUR_438048#157099, AT_TELPOR_438049#157100, AT_TELPRI_438047#157101, AT_TIQ_HISTOXML_438134#157102, AT_TIQ_PNOLISTE_438135#157103, AT_TITRE_438132#157104, AT_TITRE_ASS_438133#157105, AT_TYPCONV_438139#157106, AT_TYPEXO_438071#157107, AT_VERROU_438034#157108, AT_VILLEA_438059#157109, AT_VILLENAI_438146#157110, AT_VILLE_438042#157111]

(4) CollectLimit
Input [136]: [COL_906FFCAC_28FB_4AF5_8A40_FA2E0ADB48D0#157792, COL_AF7163BC_112C_4118_AC07_C25B8DD02C5C#157793, COL_6BCF01B9_EEAC_44BC_9ABE_F9A47B0FF0EC#157794, COL_84FBD601_2E72_457B_905D_C80C8FAA2257#157795, COL_7C081758_9AE8_4D43_B249_7A3E6043FC22#157796, COL_D01238FB_A545_440E_97F7_312B85808E7C#157797, COL_F996254B_D9DC_4C0A_9DD9_68BA2547B465#157798, COL_7D384105_A968_40D5_BF9C_4AAEACE72F75#157799, COL_C66F8C84_F2F0_40EA_9198_18867C16097C#157800, COL_82E82ED3_0457_43E2_9856_B8F0AABC06FC#157801, COL_C38053BD_111C_48FC_BB99_634D02020D60#157802, COL_4B1A77C7_90E2_4595_A649_7BEE426027DA#157803, COL_FC90D543_DC69_403C_95BB_69A661B66829#157804, COL_1C6D3A39_B5DA_4F71_A95A_70889566840F#157805, COL_8C572EF3_AACA_4F30_93E5_5F93351C915D#157806, COL_85992C0B_96B7_40A0_8BCD_7032F939CC45#157807, COL_99A9F6CB_7CDB_4283_9EA9_3B59266D1825#157808, COL_B9366DC5_32A5_437C_8127_C6CDF8505705#157809, COL_B2F92CF3_40E6_4734_81B9_E28B54867795#157810, COL_41F1EB02_EDC5_4945_800E_70F44E6C75C8#157811, COL_A4FB5F42_1464_4933_B95D_1116377A0260#157812, COL_09DA39AF_E548_418F_AF81_2A103081BDE5#157813, COL_6EE5FB06_5AE3_43DB_B5AD_DB30319C004E#157814, COL_ACD91A48_6196_46C1_A8FF_92E31806A574#157815, COL_F96C5BD3_3034_4B9C_896E_CCE42665C224#157816, COL_B86C8EFB_8AB3_4738_AA8F_C9F866F85211#157817, COL_59330B73_9E62_4E78_92EF_F521FB99B7B7#157818, COL_C77F7648_2D97_4C98_B3A5_41B35F30F1EC#157819, COL_6FE6C7F5_BE1D_4FE0_8CA8_0FE94F9F42CD#157820, COL_9C262048_4CA3_4AD8_B61D_F23FA6DB009F#157821, COL_75CB20B6_611B_40D0_8A2F_DD1326DD5570#157822, COL_EA6A16CD_9BEF_409F_AB54_5F5B30597825#157823, COL_266CB719_3E4E_4070_8347_6374DCF3E1E8#157824, COL_CC05DE5C_AD1E_4191_BB72_61DE83B0E095#157825, COL_5521C813_FA3C_4DBC_9A96_38AB2239BA7F#157826, COL_C5685592_9A0A_473B_98BF_B076635D0A97#157827, COL_3F348C2B_334F_4A9C_B033_F60B71B4F29B#157828, COL_F78783D6_8004_4D0C_94AC_8A78B39771F2#157829, COL_5841249B_1421_4729_B5E9_F4F224D00319#157830, COL_36A7A003_E1A8_4978_8F55_989DF4682427#157831, COL_59958381_9426_408C_9F3E_8B1480D10FDA#157832, COL_1585BDAA_CA08_4B1E_9FB2_F26812D2CFAF#157833, COL_B39BB748_084E_4A4A_9F90_C775349879AE#157834, COL_BE5BCD1D_2F62_4B8C_8DB2_309AF54927BD#157835, COL_311F84A4_548D_4D54_9781_04264AB895F7#157836, COL_E3197756_8062_41C5_A99B_DC53A37D8F52#157837, COL_F2B96635_0A73_45F2_80FD_7E6DCE85CF59#157838, COL_37A9821A_3561_440F_B57C_D4244C85AE8E#157839, COL_A846C64C_ECBF_450E_BC09_27A72C877F14#157840, COL_AD7CA9DF_CBB8_4A6D_9FAD_60F70D35A807#157841, COL_1CA90B84_14F3_4684_8F0D_4E51F4DFE8FD#157842, COL_19273F34_9FFE_4FEE_A42A_6CD6C4DDD42A#157843, COL_C52BC17D_E97D_4E61_B1ED_E321E11DC3C1#157844, COL_C1DFB517_7A21_4901_B9AF_743D28473167#157845, COL_18A83621_A8F5_4561_8063_55A35ABCE00B#157846, COL_27127769_B336_40C8_A359_22733BAB60A2#157847, COL_4DCE723A_4A78_4D7A_A06A_0A512F89B082#157848, COL_5AC6FFE9_23BD_4A6F_B6C6_554C2C6F10B8#157849, COL_30A3B2EC_1F7B_4CA4_8C25_AC063D3E440A#157850, COL_A24870AB_A6B8_47A4_B6D0_67493D4209CE#157851, COL_65939AC3_96BD_4B9A_8A1F_4EC13E90AEF1#157852, COL_94FBB6D9_9E80_4C42_BB32_46D771F654B7#157853, COL_AAA3C84D_AA91_4E69_9B24_1EA974EF8BE3#157854, COL_9272EFC7_B3C0_4249_9B0F_AB15051B5B84#157855, COL_D7B24A12_BD5E_4C80_938A_CBCF14622C87#157856, COL_0BEB3C6F_4845_449A_AC10_E97B1C7DD847#157857, COL_57CA7526_DBC8_4166_82B3_0158D6C6E088#157858, COL_7E1A6B10_EB29_4FD8_90C6_2D5973140B79#157859, COL_8B801653_58ED_40BC_BC98_19B56D496F9A#157860, COL_CBBE7DA0_51BE_44EB_B2A7_B076FB7FEB39#157861, COL_7D2ECEA0_48BC_4A6E_91DA_8255B7BE168D#157862, COL_BE7FA851_69AB_489E_A1C6_B408C2D8A8BE#157863, COL_59874B90_6EA0_4D62_AD0D_E6C3B36B8386#157864, COL_477A364D_FE8A_4B56_B09A_992145143069#157865, COL_D941E4DF_23C6_4BA5_BCF6_0244734E85E3#157866, COL_CF6F03EA_ECEA_43D7_9DF3_0EE1BD611034#157867, COL_C8B4B4A4_92BA_4B01_B0F3_FE08084F70A0#157868, COL_73813DD3_DC5D_47CC_BC4F_A20ED9DEE13B#157869, COL_5FF3005B_8526_49A3_8F7D_96D4181C9598#157870, COL_410EF636_9400_4754_94AF_C8ADBA94C618#157871, COL_A19D03AD_AC45_49E4_A958_7E1BCA9E4EDC#157872, COL_9935D351_0A91_424B_AFB1_4120C6C96D97#157873, COL_A50ADE9A_2311_4B6D_AEC8_90F3C5202FB8#157874, COL_CD4D7100_F05D_4088_A293_286F5F3F51B7#157875, COL_FD2B3E63_A4FE_44B4_A401_1ADE36AE8F13#157876, COL_C046C43E_2BC4_4A2B_824D_441B5CD9A271#157877, COL_B25FA5DE_FDE1_4791_8014_6058510508DC#157878, COL_4223EAC5_121F_4E3D_B81E_434B8842E436#157879, COL_331437BF_70FC_4702_A134_388048A3F31C#157880, COL_4929EDBF_6219_4B11_868C_C0FCA6994CE3#157881, COL_34A94C2C_7542_4234_BDE7_C206BA6185AD#157882, COL_6FA1BA25_2C34_4F42_802D_009B3F695073#157883, COL_13AA37E8_D11E_4B19_ABD6_59EEFC502D81#157884, COL_96A5675F_2EFD_4586_8721_F78FBC79F22F#157885, COL_0761E2A8_F7AC_46DF_BE75_2A0B4D0113B6#157886, COL_6D8A59D1_AFCE_41C0_8D32_BDA41BB8CA5E#157887, COL_44B0483F_1195_41A8_A6EB_1BE7AAB1D35D#157888, COL_5BED7059_6B19_48FA_818D_90A039B1C963#157889, COL_A344119C_9542_4595_B481_61DEB7E19F31#157890, COL_7E18EC72_C8C0_4BDB_BAEF_E99C3E4B6BB0#157891, COL_2DD4AC57_925C_4479_B703_8D4550E70B08#157892, COL_19E46871_BA7B_49A2_872F_16C637044EFD#157893, COL_3087450F_1C85_47C5_88D7_56E50774E65C#157894, COL_BD23F51D_D745_4F78_9291_A52C2DD2D0F9#157895, COL_1822DAEA_0FA1_4E78_AB99_D65BD675D176#157896, COL_953E80BC_BB14_4548_BCD7_77CAB30299C6#157897, COL_44C6C7A8_8951_43C0_8D75_E4E53E29E08A#157898, COL_1697896D_EEFF_4537_967A_A61ED9CC1373#157899, COL_E4D462E4_4514_48AA_A6FA_EF33200BD333#157900, COL_06D70268_9083_4C86_91BE_D66C83DDB34E#157901, COL_2DC3C227_A30C_4D1E_80D9_81B9E8A284AC#157902, COL_ADB0BF2D_8A7E_4286_9FE0_BBC74B1FA2A3#157903, COL_B067C171_7ABF_46AE_ABFB_635D944A168B#157904, COL_E48E7713_469E_4C38_A290_474E8F93676B#157905, COL_EA5B2000_1F90_4325_AFA6_124F4FED7296#157906, COL_32EA797E_38E9_42AB_ADCC_116BC747D720#157907, COL_70E67801_334B_4C5E_BA26_41844AB50342#157908, COL_88371930_8F54_45ED_9BCF_23907B6D2F34#157909, COL_A64896AA_5D64_4D2B_9D24_725DEC7C3038#157910, COL_BD5000D3_285B_49F2_83CC_B4E59D8A751D#157911, COL_59372E1A_138A_4DD5_8108_E96E5822370E#157912, COL_71774A6D_B1E3_4DD0_B2A6_E595C351EC84#157913, COL_3102588B_AE53_43A1_A9FD_B439FDDB9794#157914, COL_12339819_5F67_4094_82C3_BC87AAC485B3#157915, COL_D28039F0_A317_45F3_9E04_ADB5D4110669#157916, COL_9FCC827E_F70A_4DE5_8920_CAA94DAF6B52#157917, COL_51829760_0B75_4DC7_B5E7_AFCC86D575BC#157918, COL_5AA58226_D459_471C_B1D9_EEA800E53F47#157919, COL_044D19AD_A125_478C_9607_E8C55A82B982#157920, COL_1B6133B7_D2FD_4BB5_8D2E_E1EB96895E75#157921, COL_CB16144A_777E_4779_A0A4_8958713F376A#157922, COL_B98BE990_BF40_4862_8DCF_7D664C858254#157923, COL_D81CDEDD_D745_44AF_B984_361321C6DAE5#157924, COL_E5E3DFC4_9736_4FBE_85D0_EFB20EEB6B0F#157925, COL_4D92C747_708B_41B5_B42D_D88047FF1A9D#157926, COL_C8B640A8_C2E2_473C_A096_AE2AEE7CC54B#157927]
Arguments: 1500

SQL / DataFrame Properties

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