hdh-spark-job - Details for Query 1137

Submitted Time: 2026/10/23 08:37:35
Duration: 3 s
Succeeded Jobs: 1143 1145

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

digraph G { 0 [labelType="html" label=" CollectLimit "]; 1 [labelType="html" label=" Union "]; 2 [labelType="html" label=" LocalLimit "]; 3 [labelType="html" label=" Project "]; 4 [labelType="html" label="Filter number of output rows: 3"]; 5 [labelType="html" label="Scan JDBCRelation((SELECT \"at_numdos\", \"at_stapat\", \"at_prefix\", \"at_nompat\", \"at_pnopat\", \"at_njfpat\", \"at_datnai\", \"at_datnaiss\", \"at_sexe\", \"at_numper\", \"at_sigma\", \"at_verrou\", \"at_poids\", \"at_indcen\", \"at_numss\", \"at_antece\", \"at_adr_1\", \"at_adr_2\", \"at_codpos\", \"at_ville\", \"at_pays\", \"at_numcai\", \"at_nummut\", \"at_numcha\", \"at_telpri\", \"at_telbur\", \"at_telpor\", \"at_fax\", \"at_prefi2\", \"at_nomass\", \"at_pnoass\", \"at_njfass\", \"at_datass\", \"at_adr_1a\", \"at_adr_2a\", \"at_codpoa\", \"at_villea\", \"at_codmed\", \"at_datcss\", \"at_datf_d\", \"at_dat100\", \"at_numsir\", \"at_numssa\", \"at_codser\", \"at_rngnai\", \"at_natass\", \"at_numacc\", \"at_datacc\", \"at_typexo\", \"at_datmaj\", \"at_coduti\", \"at_flcmu\", \"at_qualss\", \"at_codref\", \"at_codregat\", \"at_codcaiat\", \"at_indvital\", \"at_conmut\", \"at_adhmut\", \"at_garmut\", \"at_numper_ori\", \"at_codrout\", \"at_domaine\", \"at_indtrai\", \"at_idhote\", \"at_codsts\", \"at_nirind\", \"at_fldcd\", \"at_flphoto\", \"at_codmtr\", \"at_adr_3\", \"at_pays_iso\", \"at_adr_3a\", \"at_poids_maj\", \"at_codgestion\", \"at_art115\", \"at_taille\", \"at_taille_maj\", \"at_codetab_prod\", \"at_codsit_prod\", \"at_numdos_prod\", \"at_numper_prod\", \"at_numper_ori_prod\", \"at_ins\", \"at_ins_type\", \"at_ins_date\", \"at_ins_source\", \"at_stadmp\", \"at_datdmp\", \"at_alarmes\", \"at_email\", \"at_consent_sms\", \"at_dat_consent_sms\", \"at_datdcd\", \"at_flhlim\", \"at_dathlim\", \"at_codpershlim\", \"at_fldiff\", \"at_lisdest\", \"at_langue\", \"at_numcai_ft\", \"at_codtarifamc\", \"at_flgrve\", \"at_fladri\", \"at_datadri\", \"at_datf_mut\", \"at_comfac\", \"at_numdos_cloud\", \"at_nation\", \"at_titre\", \"at_titre_ass\", \"at_tiq_histoxml\", \"at_tiq_pnoliste\", \"at_codposnai\", \"at_insi\", \"at_insi_oid\", \"at_typconv\", \"at_crisec\", \"at_opereg\", \"at_flannuamc\", \"at_staipp\", \"at_pnonai\", \"at_codinseenai\", \"at_villenai\", \"at_piece_ident_pres\", \"at_dat_staipp\", \"at_datapcv\", \"at_num_apcv\", \"at_heuapcv\", \"at_numper_sec\", \"at_ins_heure\", \"at_persaprev\", \"at_tarif\", \"at_nomhl7\", \"at_numper_ori_oid\", \"at_comment\" FROM \"xplore\".\"h_patien\") as x) [numPartitions=1] number of output rows: 23,504"]; 6 [labelType="html" label=" LocalLimit "]; 7 [labelType="html" label=" Project "]; 8 [labelType="html" label="Filter number of output rows: 3"]; 9 [labelType="html" label="Scan JDBCRelation((SELECT \"at_numdos\", \"at_stapat\", \"at_prefix\", \"at_nompat\", \"at_pnopat\", \"at_njfpat\", \"at_datnai\", \"at_datnaiss\", \"at_sexe\", \"at_numper\", \"at_sigma\", \"at_verrou\", \"at_poids\", \"at_indcen\", \"at_numss\", \"at_antece\", \"at_adr_1\", \"at_adr_2\", \"at_codpos\", \"at_ville\", \"at_pays\", \"at_numcai\", \"at_nummut\", \"at_numcha\", \"at_telpri\", \"at_telbur\", \"at_telpor\", \"at_fax\", \"at_prefi2\", \"at_nomass\", \"at_pnoass\", \"at_njfass\", \"at_datass\", \"at_adr_1a\", \"at_adr_2a\", \"at_codpoa\", \"at_villea\", \"at_codmed\", \"at_datcss\", \"at_datf_d\", \"at_dat100\", \"at_numsir\", \"at_numssa\", \"at_codser\", \"at_rngnai\", \"at_natass\", \"at_numacc\", \"at_datacc\", \"at_typexo\", \"at_datmaj\", \"at_coduti\", \"at_flcmu\", \"at_qualss\", \"at_codref\", \"at_codregat\", \"at_codcaiat\", \"at_indvital\", \"at_conmut\", \"at_adhmut\", \"at_garmut\", \"at_numper_ori\", \"at_codrout\", \"at_domaine\", \"at_indtrai\", \"at_idhote\", \"at_codsts\", \"at_nirind\", \"at_fldcd\", \"at_flphoto\", \"at_codmtr\", \"at_adr_3\", \"at_pays_iso\", \"at_adr_3a\", \"at_poids_maj\", \"at_codgestion\", \"at_art115\", \"at_taille\", \"at_taille_maj\", \"at_codetab_prod\", \"at_codsit_prod\", \"at_numdos_prod\", \"at_numper_prod\", \"at_numper_ori_prod\", \"at_ins\", \"at_ins_type\", \"at_ins_date\", \"at_ins_source\", \"at_stadmp\", \"at_datdmp\", \"at_alarmes\", \"at_email\", \"at_consent_sms\", \"at_dat_consent_sms\", \"at_datdcd\", \"at_flhlim\", \"at_dathlim\", \"at_codpershlim\", \"at_fldiff\", \"at_lisdest\", \"at_langue\", \"at_numcai_ft\", \"at_codtarifamc\", \"at_flgrve\", \"at_fladri\", \"at_datadri\", \"at_datf_mut\", \"at_comfac\", \"at_numdos_cloud\", \"at_nation\", \"at_titre\", \"at_titre_ass\", \"at_tiq_histoxml\", \"at_tiq_pnoliste\", \"at_codposnai\", \"at_insi\", \"at_insi_oid\", \"at_typconv\", \"at_crisec\", \"at_opereg\", \"at_flannuamc\", \"at_staipp\", \"at_pnonai\", \"at_codinseenai\", \"at_villenai\", \"at_piece_ident_pres\", \"at_dat_staipp\", \"at_datapcv\", \"at_num_apcv\", \"at_heuapcv\", \"at_numper_sec\", \"at_ins_heure\", \"at_persaprev\", \"at_tarif\", \"at_nomhl7\", \"at_numper_ori_oid\", \"at_comment\" FROM \"xplore2\".\"h_patien\") as x) [numPartitions=1] number of output rows: 23,504"]; 1->0; 2->1; 3->2; 4->3; 5->4; 6->1; 7->6; 8->7; 9->8; }

CollectLimit 1500

Union

LocalLimit 1500

Project [at_numdos#414085 AS COL_AT_NUMDOS_438023#417361, at_stapat#414086 AS COL_AT_STAPAT_438024#417362, at_prefix#414087 AS COL_AT_PREFIX_438025#417363, at_nompat#414088 AS COL_AT_NOMPAT_438026#417364, at_pnopat#414089 AS COL_AT_PNOPAT_438027#417365, at_njfpat#414090 AS COL_AT_NJFPAT_438028#417366, at_datnai#414091 AS COL_AT_DATNAI_438029#417367, at_datnaiss#414092 AS COL_AT_DATNAISS_438030#417368, at_sexe#414093 AS COL_AT_SEXE_438031#417369, at_numper#414094 AS COL_AT_NUMPER_438032#417370, at_sigma#414095 AS COL_AT_SIGMA_438033#417371, at_verrou#414096 AS COL_AT_VERROU_438034#417372, at_poids#414097 AS COL_AT_POIDS_438035#417373, at_indcen#414098 AS COL_AT_INDCEN_438036#417374, at_numss#414099 AS COL_AT_NUMSS_438037#417375, at_antece#414100 AS COL_AT_ANTECE_438038#417376, at_adr_1#414101 AS COL_AT_ADR_1_438039#417377, at_adr_2#414102 AS COL_AT_ADR_2_438040#417378, at_codpos#414103 AS COL_AT_CODPOS_438041#417379, at_ville#414104 AS COL_AT_VILLE_438042#417380, at_pays#414105 AS COL_AT_PAYS_438043#417381, at_numcai#414106 AS COL_AT_NUMCAI_438044#417382, at_nummut#414107 AS COL_AT_NUMMUT_438045#417383, at_numcha#414108 AS COL_AT_NUMCHA_438046#417384, ... 113 more fields]

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos#414085)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos#414085)), 0000000010) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stapat#414086)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_stapat#414086)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefix#414087)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_prefix#414087)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nompat#414088)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nompat#414088)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnopat#414089)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_pnopat#414089)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfpat#414090)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_njfpat#414090)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnai#414091)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datnai#414091)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnaiss#414092)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datnaiss#414092)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sexe#414093)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_sexe#414093)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper#414094)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper#414094)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sigma#414095)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_sigma#414095)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_verrou#414096)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_verrou#414096)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids#414097)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_poids#414097)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indcen#414098)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_indcen#414098)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numss#414099)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numss#414099)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_antece#414100)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_antece#414100)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1#414101)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1#414101)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2#414102)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2#414102)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpos#414103)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codpos#414103)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ville#414104)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ville#414104)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays#414105)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_pays#414105)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai#414106)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai#414106)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nummut#414107)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nummut#414107)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcha#414108)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numcha#414108)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpri#414109)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_telpri#414109)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telbur#414110)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_telbur#414110)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpor#414111)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_telpor#414111)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fax#414112)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_fax#414112)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefi2#414113)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_prefi2#414113)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomass#414114)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nomass#414114)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnoass#414115)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_pnoass#414115)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfass#414116)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_njfass#414116)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datass#414117)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datass#414117)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1a#414118)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1a#414118)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2a#414119)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2a#414119)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpoa#414120)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codpoa#414120)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villea#414121)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_villea#414121)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmed#414122)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codmed#414122)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datcss#414123)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datcss#414123)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_d#414124)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_d#414124)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat100#414125)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_dat100#414125)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numsir#414126)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numsir#414126)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numssa#414127)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numssa#414127)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codser#414128)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codser#414128)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_rngnai#414129)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_rngnai#414129)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_natass#414130)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_natass#414130)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numacc#414131)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numacc#414131)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datacc#414132)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datacc#414132)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typexo#414133)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_typexo#414133)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datmaj#414134)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datmaj#414134)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_coduti#414135)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_coduti#414135)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flcmu#414136)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_flcmu#414136)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_qualss#414137)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_qualss#414137)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codref#414138)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codref#414138)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codregat#414139)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codregat#414139)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codcaiat#414140)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codcaiat#414140)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indvital#414141)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_indvital#414141)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_conmut#414142)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_conmut#414142)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adhmut#414143)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adhmut#414143)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_garmut#414144)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_garmut#414144)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori#414145)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori#414145)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codrout#414146)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codrout#414146)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_domaine#414147)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_domaine#414147)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indtrai#414148)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_indtrai#414148)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_idhote#414149)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_idhote#414149)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsts#414150)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codsts#414150)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nirind#414151)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nirind#414151)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldcd#414152)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_fldcd#414152)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flphoto#414153)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_flphoto#414153)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmtr#414154)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codmtr#414154)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3#414155)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3#414155)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays_iso#414156)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_pays_iso#414156)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3a#414157)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3a#414157)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids_maj#414158)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_poids_maj#414158)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codgestion#414159)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codgestion#414159)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_art115#414160)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_art115#414160)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille#414161)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_taille#414161)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille_maj#414162)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_taille_maj#414162)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codetab_prod#414163)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codetab_prod#414163)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsit_prod#414164)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codsit_prod#414164)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_prod#414165)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_prod#414165)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_prod#414166)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_prod#414166)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_prod#414167)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_prod#414167)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins#414168)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ins#414168)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_type#414169)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_type#414169)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_date#414170)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_date#414170)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_source#414171)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_source#414171)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stadmp#414172)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_stadmp#414172)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdmp#414173)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datdmp#414173)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_alarmes#414174)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_alarmes#414174)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_email#414175)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_email#414175)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_consent_sms#414176)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_consent_sms#414176)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_consent_sms#414177)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_consent_sms#414177)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdcd#414178)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datdcd#414178)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flhlim#414179)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_flhlim#414179)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dathlim#414180)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_dathlim#414180)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpershlim#414181)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codpershlim#414181)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldiff#414182)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_fldiff#414182)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_lisdest#414183)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_lisdest#414183)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_langue#414184)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_langue#414184)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai_ft#414185)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai_ft#414185)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codtarifamc#414186)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codtarifamc#414186)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flgrve#414187)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_flgrve#414187)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fladri#414188)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_fladri#414188)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datadri#414189)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datadri#414189)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_mut#414190)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_mut#414190)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comfac#414191)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_comfac#414191)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_cloud#414192)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_cloud#414192)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nation#414193)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nation#414193)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre#414194)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_titre#414194)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre_ass#414195)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_titre_ass#414195)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_histoxml#414196)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_histoxml#414196)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_pnoliste#414197)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_pnoliste#414197)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codposnai#414198)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codposnai#414198)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi#414199)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_insi#414199)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi_oid#414200)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_insi_oid#414200)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typconv#414201)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_typconv#414201)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_crisec#414202)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_crisec#414202)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_opereg#414203)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_opereg#414203)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flannuamc#414204)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_flannuamc#414204)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_staipp#414205)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_staipp#414205)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnonai#414206)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_pnonai#414206)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codinseenai#414207)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codinseenai#414207)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villenai#414208)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_villenai#414208)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_piece_ident_pres#414209)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_piece_ident_pres#414209)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_staipp#414210)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_staipp#414210)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datapcv#414211)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datapcv#414211)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_num_apcv#414212)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_num_apcv#414212)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_heuapcv#414213)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_heuapcv#414213)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_sec#414214)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_sec#414214)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_heure#414215)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_heure#414215)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_persaprev#414216)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_persaprev#414216)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tarif#414217)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_tarif#414217)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomhl7#414218)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nomhl7#414218)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_oid#414219)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_oid#414219)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comment#414220)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_comment#414220)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_A))), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_A))), 0000000010) END)

Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore"."h_patien") as x) [numPartitions=1] [at_numdos#414085,at_stapat#414086,at_prefix#414087,at_nompat#414088,at_pnopat#414089,at_njfpat#414090,at_datnai#414091,at_datnaiss#414092,at_sexe#414093,at_numper#414094,at_sigma#414095,at_verrou#414096,at_poids#414097,at_indcen#414098,at_numss#414099,at_antece#414100,at_adr_1#414101,at_adr_2#414102,at_codpos#414103,at_ville#414104,at_pays#414105,at_numcai#414106,at_nummut#414107,at_numcha#414108,... 112 more fields] PushedFilters: [], ReadSchema: struct<at_numdos:string,at_stapat:string,at_prefix:string,at_nompat:string,at_pnopat:string,at_nj...

LocalLimit 1500

Project [at_numdos#415312 AS COL_AT_NUMDOS_438023#418183, at_stapat#415313 AS COL_AT_STAPAT_438024#418184, at_prefix#415314 AS COL_AT_PREFIX_438025#418185, at_nompat#415315 AS COL_AT_NOMPAT_438026#418186, at_pnopat#415316 AS COL_AT_PNOPAT_438027#418187, at_njfpat#415317 AS COL_AT_NJFPAT_438028#418188, at_datnai#415318 AS COL_AT_DATNAI_438029#418189, at_datnaiss#415319 AS COL_AT_DATNAISS_438030#418190, at_sexe#415320 AS COL_AT_SEXE_438031#418191, at_numper#415321 AS COL_AT_NUMPER_438032#418192, at_sigma#415322 AS COL_AT_SIGMA_438033#418193, at_verrou#415323 AS COL_AT_VERROU_438034#418194, at_poids#415324 AS COL_AT_POIDS_438035#418195, at_indcen#415325 AS COL_AT_INDCEN_438036#418196, at_numss#415326 AS COL_AT_NUMSS_438037#418197, at_antece#415327 AS COL_AT_ANTECE_438038#418198, at_adr_1#415328 AS COL_AT_ADR_1_438039#418199, at_adr_2#415329 AS COL_AT_ADR_2_438040#418200, at_codpos#415330 AS COL_AT_CODPOS_438041#418201, at_ville#415331 AS COL_AT_VILLE_438042#418202, at_pays#415332 AS COL_AT_PAYS_438043#418203, at_numcai#415333 AS COL_AT_NUMCAI_438044#418204, at_nummut#415334 AS COL_AT_NUMMUT_438045#418205, at_numcha#415335 AS COL_AT_NUMCHA_438046#418206, ... 113 more fields]

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos#415312)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos#415312)), 0000000010) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stapat#415313)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_stapat#415313)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefix#415314)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_prefix#415314)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nompat#415315)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nompat#415315)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnopat#415316)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_pnopat#415316)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfpat#415317)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_njfpat#415317)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnai#415318)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datnai#415318)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnaiss#415319)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datnaiss#415319)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sexe#415320)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_sexe#415320)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper#415321)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper#415321)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sigma#415322)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_sigma#415322)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_verrou#415323)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_verrou#415323)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids#415324)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_poids#415324)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indcen#415325)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_indcen#415325)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numss#415326)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numss#415326)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_antece#415327)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_antece#415327)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1#415328)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1#415328)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2#415329)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2#415329)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpos#415330)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codpos#415330)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ville#415331)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ville#415331)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays#415332)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_pays#415332)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai#415333)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai#415333)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nummut#415334)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nummut#415334)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcha#415335)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numcha#415335)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpri#415336)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_telpri#415336)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telbur#415337)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_telbur#415337)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpor#415338)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_telpor#415338)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fax#415339)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_fax#415339)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefi2#415340)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_prefi2#415340)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomass#415341)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nomass#415341)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnoass#415342)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_pnoass#415342)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfass#415343)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_njfass#415343)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datass#415344)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datass#415344)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1a#415345)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1a#415345)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2a#415346)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2a#415346)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpoa#415347)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codpoa#415347)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villea#415348)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_villea#415348)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmed#415349)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codmed#415349)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datcss#415350)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datcss#415350)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_d#415351)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_d#415351)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat100#415352)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_dat100#415352)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numsir#415353)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numsir#415353)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numssa#415354)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numssa#415354)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codser#415355)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codser#415355)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_rngnai#415356)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_rngnai#415356)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_natass#415357)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_natass#415357)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numacc#415358)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numacc#415358)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datacc#415359)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datacc#415359)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typexo#415360)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_typexo#415360)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datmaj#415361)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datmaj#415361)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_coduti#415362)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_coduti#415362)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flcmu#415363)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_flcmu#415363)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_qualss#415364)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_qualss#415364)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codref#415365)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codref#415365)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codregat#415366)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codregat#415366)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codcaiat#415367)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codcaiat#415367)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indvital#415368)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_indvital#415368)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_conmut#415369)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_conmut#415369)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adhmut#415370)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adhmut#415370)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_garmut#415371)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_garmut#415371)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori#415372)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori#415372)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codrout#415373)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codrout#415373)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_domaine#415374)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_domaine#415374)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indtrai#415375)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_indtrai#415375)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_idhote#415376)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_idhote#415376)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsts#415377)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codsts#415377)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nirind#415378)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nirind#415378)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldcd#415379)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_fldcd#415379)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flphoto#415380)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_flphoto#415380)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmtr#415381)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codmtr#415381)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3#415382)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3#415382)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays_iso#415383)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_pays_iso#415383)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3a#415384)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3a#415384)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids_maj#415385)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_poids_maj#415385)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codgestion#415386)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codgestion#415386)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_art115#415387)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_art115#415387)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille#415388)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_taille#415388)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille_maj#415389)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_taille_maj#415389)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codetab_prod#415390)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codetab_prod#415390)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsit_prod#415391)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codsit_prod#415391)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_prod#415392)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_prod#415392)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_prod#415393)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_prod#415393)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_prod#415394)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_prod#415394)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins#415395)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ins#415395)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_type#415396)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_type#415396)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_date#415397)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_date#415397)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_source#415398)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_source#415398)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stadmp#415399)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_stadmp#415399)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdmp#415400)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datdmp#415400)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_alarmes#415401)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_alarmes#415401)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_email#415402)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_email#415402)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_consent_sms#415403)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_consent_sms#415403)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_consent_sms#415404)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_consent_sms#415404)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdcd#415405)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datdcd#415405)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flhlim#415406)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_flhlim#415406)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dathlim#415407)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_dathlim#415407)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpershlim#415408)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codpershlim#415408)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldiff#415409)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_fldiff#415409)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_lisdest#415410)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_lisdest#415410)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_langue#415411)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_langue#415411)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai_ft#415412)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai_ft#415412)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codtarifamc#415413)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codtarifamc#415413)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flgrve#415414)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_flgrve#415414)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fladri#415415)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_fladri#415415)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datadri#415416)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datadri#415416)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_mut#415417)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_mut#415417)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comfac#415418)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_comfac#415418)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_cloud#415419)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_cloud#415419)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nation#415420)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nation#415420)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre#415421)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_titre#415421)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre_ass#415422)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_titre_ass#415422)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_histoxml#415423)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_histoxml#415423)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_pnoliste#415424)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_pnoliste#415424)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codposnai#415425)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codposnai#415425)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi#415426)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_insi#415426)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi_oid#415427)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_insi_oid#415427)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typconv#415428)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_typconv#415428)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_crisec#415429)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_crisec#415429)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_opereg#415430)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_opereg#415430)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flannuamc#415431)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_flannuamc#415431)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_staipp#415432)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_staipp#415432)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnonai#415433)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_pnonai#415433)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codinseenai#415434)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codinseenai#415434)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villenai#415435)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_villenai#415435)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_piece_ident_pres#415436)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_piece_ident_pres#415436)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_staipp#415437)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_staipp#415437)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datapcv#415438)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datapcv#415438)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_num_apcv#415439)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_num_apcv#415439)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_heuapcv#415440)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_heuapcv#415440)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_sec#415441)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_sec#415441)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_heure#415442)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_heure#415442)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_persaprev#415443)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_persaprev#415443)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tarif#415444)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_tarif#415444)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomhl7#415445)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nomhl7#415445)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_oid#415446)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_oid#415446)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comment#415447)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_comment#415447)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_B))), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_B))), 0000000010) END)

Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore2"."h_patien") as x) [numPartitions=1] [at_numdos#415312,at_stapat#415313,at_prefix#415314,at_nompat#415315,at_pnopat#415316,at_njfpat#415317,at_datnai#415318,at_datnaiss#415319,at_sexe#415320,at_numper#415321,at_sigma#415322,at_verrou#415323,at_poids#415324,at_indcen#415325,at_numss#415326,at_antece#415327,at_adr_1#415328,at_adr_2#415329,at_codpos#415330,at_ville#415331,at_pays#415332,at_numcai#415333,at_nummut#415334,at_numcha#415335,... 112 more fields] PushedFilters: [], ReadSchema: struct<at_numdos:string,at_stapat:string,at_prefix:string,at_nompat:string,at_pnopat:string,at_nj...

Details

== Physical Plan ==
CollectLimit (10)
+- Union (9)
   :- LocalLimit (4)
   :  +- Project (3)
   :     +- Filter (2)
   :        +- Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore"."h_patien") as x) [numPartitions=1]  (1)
   +- LocalLimit (8)
      +- Project (7)
         +- Filter (6)
            +- Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore2"."h_patien") as x) [numPartitions=1]  (5)


(1) Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore"."h_patien") as x) [numPartitions=1] 
Output [136]: [at_numdos#414085, at_stapat#414086, at_prefix#414087, at_nompat#414088, at_pnopat#414089, at_njfpat#414090, at_datnai#414091, at_datnaiss#414092, at_sexe#414093, at_numper#414094, at_sigma#414095, at_verrou#414096, at_poids#414097, at_indcen#414098, at_numss#414099, at_antece#414100, at_adr_1#414101, at_adr_2#414102, at_codpos#414103, at_ville#414104, at_pays#414105, at_numcai#414106, at_nummut#414107, at_numcha#414108, at_telpri#414109, at_telbur#414110, at_telpor#414111, at_fax#414112, at_prefi2#414113, at_nomass#414114, at_pnoass#414115, at_njfass#414116, at_datass#414117, at_adr_1a#414118, at_adr_2a#414119, at_codpoa#414120, at_villea#414121, at_codmed#414122, at_datcss#414123, at_datf_d#414124, at_dat100#414125, at_numsir#414126, at_numssa#414127, at_codser#414128, at_rngnai#414129, at_natass#414130, at_numacc#414131, at_datacc#414132, at_typexo#414133, at_datmaj#414134, at_coduti#414135, at_flcmu#414136, at_qualss#414137, at_codref#414138, at_codregat#414139, at_codcaiat#414140, at_indvital#414141, at_conmut#414142, at_adhmut#414143, at_garmut#414144, at_numper_ori#414145, at_codrout#414146, at_domaine#414147, at_indtrai#414148, at_idhote#414149, at_codsts#414150, at_nirind#414151, at_fldcd#414152, at_flphoto#414153, at_codmtr#414154, at_adr_3#414155, at_pays_iso#414156, at_adr_3a#414157, at_poids_maj#414158, at_codgestion#414159, at_art115#414160, at_taille#414161, at_taille_maj#414162, at_codetab_prod#414163, at_codsit_prod#414164, at_numdos_prod#414165, at_numper_prod#414166, at_numper_ori_prod#414167, at_ins#414168, at_ins_type#414169, at_ins_date#414170, at_ins_source#414171, at_stadmp#414172, at_datdmp#414173, at_alarmes#414174, at_email#414175, at_consent_sms#414176, at_dat_consent_sms#414177, at_datdcd#414178, at_flhlim#414179, at_dathlim#414180, at_codpershlim#414181, at_fldiff#414182, at_lisdest#414183, at_langue#414184, at_numcai_ft#414185, at_codtarifamc#414186, at_flgrve#414187, at_fladri#414188, at_datadri#414189, at_datf_mut#414190, at_comfac#414191, at_numdos_cloud#414192, at_nation#414193, at_titre#414194, at_titre_ass#414195, at_tiq_histoxml#414196, at_tiq_pnoliste#414197, at_codposnai#414198, at_insi#414199, at_insi_oid#414200, at_typconv#414201, at_crisec#414202, at_opereg#414203, at_flannuamc#414204, at_staipp#414205, at_pnonai#414206, at_codinseenai#414207, at_villenai#414208, at_piece_ident_pres#414209, at_dat_staipp#414210, at_datapcv#414211, at_num_apcv#414212, at_heuapcv#414213, at_numper_sec#414214, at_ins_heure#414215, at_persaprev#414216, at_tarif#414217, at_nomhl7#414218, at_numper_ori_oid#414219, at_comment#414220]
ReadSchema: struct<at_numdos:string,at_stapat:string,at_prefix:string,at_nompat:string,at_pnopat:string,at_njfpat:string,at_datnai:string,at_datnaiss:string,at_sexe:string,at_numper:string,at_sigma:string,at_verrou:string,at_poids:string,at_indcen:string,at_numss:string,at_antece:string,at_adr_1:string,at_adr_2:string,at_codpos:string,at_ville:string,at_pays:string,at_numcai:string,at_nummut:string,at_numcha:string,at_telpri:string,at_telbur:string,at_telpor:string,at_fax:string,at_prefi2:string,at_nomass:string,at_pnoass:string,at_njfass:string,at_datass:string,at_adr_1a:string,at_adr_2a:string,at_codpoa:string,at_villea:string,at_codmed:string,at_datcss:string,at_datf_d:string,at_dat100:string,at_numsir:string,at_numssa:string,at_codser:string,at_rngnai:string,at_natass:string,at_numacc:string,at_datacc:string,at_typexo:string,at_datmaj:string,at_coduti:string,at_flcmu:string,at_qualss:string,at_codref:string,at_codregat:string,at_codcaiat:string,at_indvital:string,at_conmut:string,at_adhmut:string,at_garmut:string,at_numper_ori:string,at_codrout:string,at_domaine:string,at_indtrai:string,at_idhote:string,at_codsts:string,at_nirind:string,at_fldcd:string,at_flphoto:string,at_codmtr:string,at_adr_3:string,at_pays_iso:string,at_adr_3a:string,at_poids_maj:string,at_codgestion:string,at_art115:string,at_taille:string,at_taille_maj:string,at_codetab_prod:string,at_codsit_prod:string,at_numdos_prod:string,at_numper_prod:string,at_numper_ori_prod:string,at_ins:string,at_ins_type:string,at_ins_date:string,at_ins_source:string,at_stadmp:string,at_datdmp:string,at_alarmes:string,at_email:string,at_consent_sms:string,at_dat_consent_sms:string,at_datdcd:string,at_flhlim:string,at_dathlim:string,at_codpershlim:string,at_fldiff:string,at_lisdest:string,at_langue:string,at_numcai_ft:string,at_codtarifamc:string,at_flgrve:string,at_fladri:string,at_datadri:string,at_datf_mut:string,at_comfac:string,at_numdos_cloud:string,at_nation:string,at_titre:string,at_titre_ass:string,at_tiq_histoxml:string,at_tiq_pnoliste:string,at_codposnai:string,at_insi:string,at_insi_oid:string,at_typconv:string,at_crisec:string,at_opereg:string,at_flannuamc:string,at_staipp:string,at_pnonai:string,at_codinseenai:string,at_villenai:string,at_piece_ident_pres:string,at_dat_staipp:string,at_datapcv:string,at_num_apcv:string,at_heuapcv:string,at_numper_sec:string,at_ins_heure:string,at_persaprev:string,at_tarif:string,at_nomhl7:string,at_numper_ori_oid:string,at_comment:string>

(2) Filter
Input [136]: [at_numdos#414085, at_stapat#414086, at_prefix#414087, at_nompat#414088, at_pnopat#414089, at_njfpat#414090, at_datnai#414091, at_datnaiss#414092, at_sexe#414093, at_numper#414094, at_sigma#414095, at_verrou#414096, at_poids#414097, at_indcen#414098, at_numss#414099, at_antece#414100, at_adr_1#414101, at_adr_2#414102, at_codpos#414103, at_ville#414104, at_pays#414105, at_numcai#414106, at_nummut#414107, at_numcha#414108, at_telpri#414109, at_telbur#414110, at_telpor#414111, at_fax#414112, at_prefi2#414113, at_nomass#414114, at_pnoass#414115, at_njfass#414116, at_datass#414117, at_adr_1a#414118, at_adr_2a#414119, at_codpoa#414120, at_villea#414121, at_codmed#414122, at_datcss#414123, at_datf_d#414124, at_dat100#414125, at_numsir#414126, at_numssa#414127, at_codser#414128, at_rngnai#414129, at_natass#414130, at_numacc#414131, at_datacc#414132, at_typexo#414133, at_datmaj#414134, at_coduti#414135, at_flcmu#414136, at_qualss#414137, at_codref#414138, at_codregat#414139, at_codcaiat#414140, at_indvital#414141, at_conmut#414142, at_adhmut#414143, at_garmut#414144, at_numper_ori#414145, at_codrout#414146, at_domaine#414147, at_indtrai#414148, at_idhote#414149, at_codsts#414150, at_nirind#414151, at_fldcd#414152, at_flphoto#414153, at_codmtr#414154, at_adr_3#414155, at_pays_iso#414156, at_adr_3a#414157, at_poids_maj#414158, at_codgestion#414159, at_art115#414160, at_taille#414161, at_taille_maj#414162, at_codetab_prod#414163, at_codsit_prod#414164, at_numdos_prod#414165, at_numper_prod#414166, at_numper_ori_prod#414167, at_ins#414168, at_ins_type#414169, at_ins_date#414170, at_ins_source#414171, at_stadmp#414172, at_datdmp#414173, at_alarmes#414174, at_email#414175, at_consent_sms#414176, at_dat_consent_sms#414177, at_datdcd#414178, at_flhlim#414179, at_dathlim#414180, at_codpershlim#414181, at_fldiff#414182, at_lisdest#414183, at_langue#414184, at_numcai_ft#414185, at_codtarifamc#414186, at_flgrve#414187, at_fladri#414188, at_datadri#414189, at_datf_mut#414190, at_comfac#414191, at_numdos_cloud#414192, at_nation#414193, at_titre#414194, at_titre_ass#414195, at_tiq_histoxml#414196, at_tiq_pnoliste#414197, at_codposnai#414198, at_insi#414199, at_insi_oid#414200, at_typconv#414201, at_crisec#414202, at_opereg#414203, at_flannuamc#414204, at_staipp#414205, at_pnonai#414206, at_codinseenai#414207, at_villenai#414208, at_piece_ident_pres#414209, at_dat_staipp#414210, at_datapcv#414211, at_num_apcv#414212, at_heuapcv#414213, at_numper_sec#414214, at_ins_heure#414215, at_persaprev#414216, at_tarif#414217, at_nomhl7#414218, at_numper_ori_oid#414219, at_comment#414220]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos#414085)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos#414085)), 0000000010) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stapat#414086)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_stapat#414086)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefix#414087)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_prefix#414087)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nompat#414088)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nompat#414088)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnopat#414089)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_pnopat#414089)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfpat#414090)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_njfpat#414090)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnai#414091)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datnai#414091)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnaiss#414092)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datnaiss#414092)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sexe#414093)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_sexe#414093)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper#414094)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper#414094)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sigma#414095)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_sigma#414095)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_verrou#414096)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_verrou#414096)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids#414097)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_poids#414097)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indcen#414098)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_indcen#414098)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numss#414099)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numss#414099)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_antece#414100)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_antece#414100)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1#414101)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1#414101)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2#414102)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2#414102)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpos#414103)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codpos#414103)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ville#414104)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ville#414104)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays#414105)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_pays#414105)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai#414106)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai#414106)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nummut#414107)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nummut#414107)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcha#414108)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numcha#414108)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpri#414109)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_telpri#414109)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telbur#414110)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_telbur#414110)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpor#414111)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_telpor#414111)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fax#414112)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_fax#414112)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefi2#414113)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_prefi2#414113)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomass#414114)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nomass#414114)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnoass#414115)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_pnoass#414115)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfass#414116)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_njfass#414116)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datass#414117)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datass#414117)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1a#414118)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1a#414118)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2a#414119)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2a#414119)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpoa#414120)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codpoa#414120)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villea#414121)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_villea#414121)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmed#414122)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codmed#414122)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datcss#414123)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datcss#414123)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_d#414124)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_d#414124)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat100#414125)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_dat100#414125)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numsir#414126)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numsir#414126)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numssa#414127)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numssa#414127)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codser#414128)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codser#414128)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_rngnai#414129)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_rngnai#414129)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_natass#414130)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_natass#414130)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numacc#414131)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numacc#414131)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datacc#414132)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datacc#414132)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typexo#414133)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_typexo#414133)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datmaj#414134)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datmaj#414134)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_coduti#414135)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_coduti#414135)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flcmu#414136)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_flcmu#414136)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_qualss#414137)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_qualss#414137)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codref#414138)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codref#414138)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codregat#414139)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codregat#414139)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codcaiat#414140)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codcaiat#414140)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indvital#414141)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_indvital#414141)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_conmut#414142)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_conmut#414142)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adhmut#414143)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adhmut#414143)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_garmut#414144)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_garmut#414144)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori#414145)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori#414145)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codrout#414146)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codrout#414146)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_domaine#414147)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_domaine#414147)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indtrai#414148)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_indtrai#414148)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_idhote#414149)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_idhote#414149)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsts#414150)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codsts#414150)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nirind#414151)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nirind#414151)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldcd#414152)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_fldcd#414152)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flphoto#414153)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_flphoto#414153)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmtr#414154)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codmtr#414154)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3#414155)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3#414155)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays_iso#414156)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_pays_iso#414156)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3a#414157)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3a#414157)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids_maj#414158)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_poids_maj#414158)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codgestion#414159)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codgestion#414159)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_art115#414160)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_art115#414160)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille#414161)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_taille#414161)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille_maj#414162)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_taille_maj#414162)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codetab_prod#414163)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codetab_prod#414163)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsit_prod#414164)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codsit_prod#414164)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_prod#414165)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_prod#414165)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_prod#414166)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_prod#414166)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_prod#414167)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_prod#414167)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins#414168)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ins#414168)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_type#414169)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_type#414169)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_date#414170)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_date#414170)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_source#414171)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_source#414171)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stadmp#414172)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_stadmp#414172)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdmp#414173)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datdmp#414173)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_alarmes#414174)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_alarmes#414174)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_email#414175)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_email#414175)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_consent_sms#414176)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_consent_sms#414176)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_consent_sms#414177)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_consent_sms#414177)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdcd#414178)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datdcd#414178)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flhlim#414179)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_flhlim#414179)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dathlim#414180)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_dathlim#414180)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpershlim#414181)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codpershlim#414181)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldiff#414182)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_fldiff#414182)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_lisdest#414183)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_lisdest#414183)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_langue#414184)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_langue#414184)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai_ft#414185)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai_ft#414185)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codtarifamc#414186)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codtarifamc#414186)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flgrve#414187)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_flgrve#414187)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fladri#414188)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_fladri#414188)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datadri#414189)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datadri#414189)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_mut#414190)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_mut#414190)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comfac#414191)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_comfac#414191)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_cloud#414192)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_cloud#414192)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nation#414193)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nation#414193)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre#414194)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_titre#414194)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre_ass#414195)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_titre_ass#414195)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_histoxml#414196)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_histoxml#414196)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_pnoliste#414197)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_pnoliste#414197)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codposnai#414198)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codposnai#414198)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi#414199)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_insi#414199)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi_oid#414200)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_insi_oid#414200)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typconv#414201)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_typconv#414201)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_crisec#414202)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_crisec#414202)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_opereg#414203)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_opereg#414203)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flannuamc#414204)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_flannuamc#414204)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_staipp#414205)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_staipp#414205)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnonai#414206)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_pnonai#414206)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codinseenai#414207)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codinseenai#414207)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villenai#414208)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_villenai#414208)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_piece_ident_pres#414209)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_piece_ident_pres#414209)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_staipp#414210)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_staipp#414210)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datapcv#414211)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datapcv#414211)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_num_apcv#414212)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_num_apcv#414212)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_heuapcv#414213)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_heuapcv#414213)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_sec#414214)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_sec#414214)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_heure#414215)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_heure#414215)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_persaprev#414216)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_persaprev#414216)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tarif#414217)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_tarif#414217)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomhl7#414218)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nomhl7#414218)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_oid#414219)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_oid#414219)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comment#414220)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_comment#414220)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_A))), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_A))), 0000000010) END)

(3) Project
Output [137]: [at_numdos#414085 AS COL_AT_NUMDOS_438023#417361, at_stapat#414086 AS COL_AT_STAPAT_438024#417362, at_prefix#414087 AS COL_AT_PREFIX_438025#417363, at_nompat#414088 AS COL_AT_NOMPAT_438026#417364, at_pnopat#414089 AS COL_AT_PNOPAT_438027#417365, at_njfpat#414090 AS COL_AT_NJFPAT_438028#417366, at_datnai#414091 AS COL_AT_DATNAI_438029#417367, at_datnaiss#414092 AS COL_AT_DATNAISS_438030#417368, at_sexe#414093 AS COL_AT_SEXE_438031#417369, at_numper#414094 AS COL_AT_NUMPER_438032#417370, at_sigma#414095 AS COL_AT_SIGMA_438033#417371, at_verrou#414096 AS COL_AT_VERROU_438034#417372, at_poids#414097 AS COL_AT_POIDS_438035#417373, at_indcen#414098 AS COL_AT_INDCEN_438036#417374, at_numss#414099 AS COL_AT_NUMSS_438037#417375, at_antece#414100 AS COL_AT_ANTECE_438038#417376, at_adr_1#414101 AS COL_AT_ADR_1_438039#417377, at_adr_2#414102 AS COL_AT_ADR_2_438040#417378, at_codpos#414103 AS COL_AT_CODPOS_438041#417379, at_ville#414104 AS COL_AT_VILLE_438042#417380, at_pays#414105 AS COL_AT_PAYS_438043#417381, at_numcai#414106 AS COL_AT_NUMCAI_438044#417382, at_nummut#414107 AS COL_AT_NUMMUT_438045#417383, at_numcha#414108 AS COL_AT_NUMCHA_438046#417384, at_telpri#414109 AS COL_AT_TELPRI_438047#417385, at_telbur#414110 AS COL_AT_TELBUR_438048#417386, at_telpor#414111 AS COL_AT_TELPOR_438049#417387, at_fax#414112 AS COL_AT_FAX_438050#417388, at_prefi2#414113 AS COL_AT_PREFI2_438051#417389, at_nomass#414114 AS COL_AT_NOMASS_438052#417390, at_pnoass#414115 AS COL_AT_PNOASS_438053#417391, at_njfass#414116 AS COL_AT_NJFASS_438054#417392, at_datass#414117 AS COL_AT_DATASS_438055#417393, at_adr_1a#414118 AS COL_AT_ADR_1A_438056#417394, at_adr_2a#414119 AS COL_AT_ADR_2A_438057#417395, at_codpoa#414120 AS COL_AT_CODPOA_438058#417396, at_villea#414121 AS COL_AT_VILLEA_438059#417397, at_codmed#414122 AS COL_AT_CODMED_438060#417398, at_datcss#414123 AS COL_AT_DATCSS_438061#417399, at_datf_d#414124 AS COL_AT_DATF_D_438062#417400, at_dat100#414125 AS COL_AT_DAT100_438063#417401, at_numsir#414126 AS COL_AT_NUMSIR_438064#417402, at_numssa#414127 AS COL_AT_NUMSSA_438065#417403, at_codser#414128 AS COL_AT_CODSER_438066#417404, at_rngnai#414129 AS COL_AT_RNGNAI_438067#417405, at_natass#414130 AS COL_AT_NATASS_438068#417406, at_numacc#414131 AS COL_AT_NUMACC_438069#417407, at_datacc#414132 AS COL_AT_DATACC_438070#417408, at_typexo#414133 AS COL_AT_TYPEXO_438071#417409, at_datmaj#414134 AS COL_AT_DATMAJ_438072#417410, at_coduti#414135 AS COL_AT_CODUTI_438073#417411, at_flcmu#414136 AS COL_AT_FLCMU_438074#417412, at_qualss#414137 AS COL_AT_QUALSS_438075#417413, at_codref#414138 AS COL_AT_CODREF_438076#417414, at_codregat#414139 AS COL_AT_CODREGAT_438077#417415, at_codcaiat#414140 AS COL_AT_CODCAIAT_438078#417416, at_indvital#414141 AS COL_AT_INDVITAL_438079#417417, at_conmut#414142 AS COL_AT_CONMUT_438080#417418, at_adhmut#414143 AS COL_AT_ADHMUT_438081#417419, at_garmut#414144 AS COL_AT_GARMUT_438082#417420, at_numper_ori#414145 AS COL_AT_NUMPER_ORI_438083#417421, at_codrout#414146 AS COL_AT_CODROUT_438084#417422, at_domaine#414147 AS COL_AT_DOMAINE_438085#417423, at_indtrai#414148 AS COL_AT_INDTRAI_438086#417424, at_idhote#414149 AS COL_AT_IDHOTE_438087#417425, at_codsts#414150 AS COL_AT_CODSTS_438088#417426, at_nirind#414151 AS COL_AT_NIRIND_438089#417427, at_fldcd#414152 AS COL_AT_FLDCD_438090#417428, at_flphoto#414153 AS COL_AT_FLPHOTO_438091#417429, at_codmtr#414154 AS COL_AT_CODMTR_438092#417430, at_adr_3#414155 AS COL_AT_ADR_3_438093#417431, at_pays_iso#414156 AS COL_AT_PAYS_ISO_438094#417432, at_adr_3a#414157 AS COL_AT_ADR_3A_438095#417433, at_poids_maj#414158 AS COL_AT_POIDS_MAJ_438096#417434, at_codgestion#414159 AS COL_AT_CODGESTION_438097#417435, at_art115#414160 AS COL_AT_ART115_438098#417436, at_taille#414161 AS COL_AT_TAILLE_438099#417437, at_taille_maj#414162 AS COL_AT_TAILLE_MAJ_438100#417438, at_codetab_prod#414163 AS COL_AT_CODETAB_PROD_438101#417439, at_codsit_prod#414164 AS COL_AT_CODSIT_PROD_438102#417440, at_numdos_prod#414165 AS COL_AT_NUMDOS_PROD_438103#417441, at_numper_prod#414166 AS COL_AT_NUMPER_PROD_438104#417442, at_numper_ori_prod#414167 AS COL_AT_NUMPER_ORI_P_438105#417443, at_ins#414168 AS COL_AT_INS_438106#417444, at_ins_type#414169 AS COL_AT_INS_TYPE_438107#417445, at_ins_date#414170 AS COL_AT_INS_DATE_438108#417446, at_ins_source#414171 AS COL_AT_INS_SOURCE_438109#417447, at_stadmp#414172 AS COL_AT_STADMP_438110#417448, at_datdmp#414173 AS COL_AT_DATDMP_438111#417449, at_alarmes#414174 AS COL_AT_ALARMES_438112#417450, at_email#414175 AS COL_AT_EMAIL_438113#417451, at_consent_sms#414176 AS COL_AT_CONSENT_SMS_438114#417452, at_dat_consent_sms#414177 AS COL_AT_DAT_CONSENT__438115#417453, at_datdcd#414178 AS COL_AT_DATDCD_438116#417454, at_flhlim#414179 AS COL_AT_FLHLIM_438117#417455, at_dathlim#414180 AS COL_AT_DATHLIM_438118#417456, at_codpershlim#414181 AS COL_AT_CODPERSHLIM_438119#417457, at_fldiff#414182 AS COL_AT_FLDIFF_438120#417458, at_lisdest#414183 AS COL_AT_LISDEST_438121#417459, at_langue#414184 AS COL_AT_LANGUE_438122#417460, at_numcai_ft#414185 AS COL_AT_NUMCAI_FT_438123#417461, at_codtarifamc#414186 AS COL_AT_CODTARIFAMC_438124#417462, at_flgrve#414187 AS COL_AT_FLGRVE_438125#417463, at_fladri#414188 AS COL_AT_FLADRI_438126#417464, at_datadri#414189 AS COL_AT_DATADRI_438127#417465, at_datf_mut#414190 AS COL_AT_DATF_MUT_438128#417466, at_comfac#414191 AS COL_AT_COMFAC_438129#417467, at_numdos_cloud#414192 AS COL_AT_NUMDOS_CLOUD_438130#417468, at_nation#414193 AS COL_AT_NATION_438131#417469, at_titre#414194 AS COL_AT_TITRE_438132#417470, at_titre_ass#414195 AS COL_AT_TITRE_ASS_438133#417471, at_tiq_histoxml#414196 AS COL_AT_TIQ_HISTOXML_438134#417472, at_tiq_pnoliste#414197 AS COL_AT_TIQ_PNOLISTE_438135#417473, at_codposnai#414198 AS COL_AT_CODPOSNAI_438136#417474, at_insi#414199 AS COL_AT_INSI_438137#417475, at_insi_oid#414200 AS COL_AT_INSI_OID_438138#417476, at_typconv#414201 AS COL_AT_TYPCONV_438139#417477, at_crisec#414202 AS COL_AT_CRISEC_438140#417478, at_opereg#414203 AS COL_AT_OPEREG_438141#417479, at_flannuamc#414204 AS COL_AT_FLANNUAMC_438142#417480, at_staipp#414205 AS COL_AT_STAIPP_438143#417481, at_pnonai#414206 AS COL_AT_PNONAI_438144#417482, at_codinseenai#414207 AS COL_AT_CODINSEENAI_438145#417483, at_villenai#414208 AS COL_AT_VILLENAI_438146#417484, at_piece_ident_pres#414209 AS COL_AT_PIECE_IDENT__438147#417485, at_dat_staipp#414210 AS COL_AT_DAT_STAIPP_438148#417486, at_datapcv#414211 AS COL_AT_DATAPCV_438149#417487, at_num_apcv#414212 AS COL_AT_NUM_APCV_438150#417488, at_heuapcv#414213 AS COL_AT_HEUAPCV_438151#417489, at_numper_sec#414214 AS COL_AT_NUMPER_SEC_438152#417490, at_ins_heure#414215 AS COL_AT_INS_HEURE_438153#417491, at_persaprev#414216 AS COL_AT_PERSAPREV_438154#417492, at_tarif#414217 AS COL_AT_TARIF_438155#417493, at_nomhl7#414218 AS COL_AT_NOMHL7_438156#417494, at_numper_ori_oid#414219 AS COL_AT_NUMPER_ORI_O_438157#417495, at_comment#414220 AS COL_AT_COMMENT_438158#417496, str_create(Cab_A) AS COL_ORIGINE_440149#417497]
Input [136]: [at_numdos#414085, at_stapat#414086, at_prefix#414087, at_nompat#414088, at_pnopat#414089, at_njfpat#414090, at_datnai#414091, at_datnaiss#414092, at_sexe#414093, at_numper#414094, at_sigma#414095, at_verrou#414096, at_poids#414097, at_indcen#414098, at_numss#414099, at_antece#414100, at_adr_1#414101, at_adr_2#414102, at_codpos#414103, at_ville#414104, at_pays#414105, at_numcai#414106, at_nummut#414107, at_numcha#414108, at_telpri#414109, at_telbur#414110, at_telpor#414111, at_fax#414112, at_prefi2#414113, at_nomass#414114, at_pnoass#414115, at_njfass#414116, at_datass#414117, at_adr_1a#414118, at_adr_2a#414119, at_codpoa#414120, at_villea#414121, at_codmed#414122, at_datcss#414123, at_datf_d#414124, at_dat100#414125, at_numsir#414126, at_numssa#414127, at_codser#414128, at_rngnai#414129, at_natass#414130, at_numacc#414131, at_datacc#414132, at_typexo#414133, at_datmaj#414134, at_coduti#414135, at_flcmu#414136, at_qualss#414137, at_codref#414138, at_codregat#414139, at_codcaiat#414140, at_indvital#414141, at_conmut#414142, at_adhmut#414143, at_garmut#414144, at_numper_ori#414145, at_codrout#414146, at_domaine#414147, at_indtrai#414148, at_idhote#414149, at_codsts#414150, at_nirind#414151, at_fldcd#414152, at_flphoto#414153, at_codmtr#414154, at_adr_3#414155, at_pays_iso#414156, at_adr_3a#414157, at_poids_maj#414158, at_codgestion#414159, at_art115#414160, at_taille#414161, at_taille_maj#414162, at_codetab_prod#414163, at_codsit_prod#414164, at_numdos_prod#414165, at_numper_prod#414166, at_numper_ori_prod#414167, at_ins#414168, at_ins_type#414169, at_ins_date#414170, at_ins_source#414171, at_stadmp#414172, at_datdmp#414173, at_alarmes#414174, at_email#414175, at_consent_sms#414176, at_dat_consent_sms#414177, at_datdcd#414178, at_flhlim#414179, at_dathlim#414180, at_codpershlim#414181, at_fldiff#414182, at_lisdest#414183, at_langue#414184, at_numcai_ft#414185, at_codtarifamc#414186, at_flgrve#414187, at_fladri#414188, at_datadri#414189, at_datf_mut#414190, at_comfac#414191, at_numdos_cloud#414192, at_nation#414193, at_titre#414194, at_titre_ass#414195, at_tiq_histoxml#414196, at_tiq_pnoliste#414197, at_codposnai#414198, at_insi#414199, at_insi_oid#414200, at_typconv#414201, at_crisec#414202, at_opereg#414203, at_flannuamc#414204, at_staipp#414205, at_pnonai#414206, at_codinseenai#414207, at_villenai#414208, at_piece_ident_pres#414209, at_dat_staipp#414210, at_datapcv#414211, at_num_apcv#414212, at_heuapcv#414213, at_numper_sec#414214, at_ins_heure#414215, at_persaprev#414216, at_tarif#414217, at_nomhl7#414218, at_numper_ori_oid#414219, at_comment#414220]

(4) LocalLimit
Input [137]: [COL_AT_NUMDOS_438023#417361, COL_AT_STAPAT_438024#417362, COL_AT_PREFIX_438025#417363, COL_AT_NOMPAT_438026#417364, COL_AT_PNOPAT_438027#417365, COL_AT_NJFPAT_438028#417366, COL_AT_DATNAI_438029#417367, COL_AT_DATNAISS_438030#417368, COL_AT_SEXE_438031#417369, COL_AT_NUMPER_438032#417370, COL_AT_SIGMA_438033#417371, COL_AT_VERROU_438034#417372, COL_AT_POIDS_438035#417373, COL_AT_INDCEN_438036#417374, COL_AT_NUMSS_438037#417375, COL_AT_ANTECE_438038#417376, COL_AT_ADR_1_438039#417377, COL_AT_ADR_2_438040#417378, COL_AT_CODPOS_438041#417379, COL_AT_VILLE_438042#417380, COL_AT_PAYS_438043#417381, COL_AT_NUMCAI_438044#417382, COL_AT_NUMMUT_438045#417383, COL_AT_NUMCHA_438046#417384, COL_AT_TELPRI_438047#417385, COL_AT_TELBUR_438048#417386, COL_AT_TELPOR_438049#417387, COL_AT_FAX_438050#417388, COL_AT_PREFI2_438051#417389, COL_AT_NOMASS_438052#417390, COL_AT_PNOASS_438053#417391, COL_AT_NJFASS_438054#417392, COL_AT_DATASS_438055#417393, COL_AT_ADR_1A_438056#417394, COL_AT_ADR_2A_438057#417395, COL_AT_CODPOA_438058#417396, COL_AT_VILLEA_438059#417397, COL_AT_CODMED_438060#417398, COL_AT_DATCSS_438061#417399, COL_AT_DATF_D_438062#417400, COL_AT_DAT100_438063#417401, COL_AT_NUMSIR_438064#417402, COL_AT_NUMSSA_438065#417403, COL_AT_CODSER_438066#417404, COL_AT_RNGNAI_438067#417405, COL_AT_NATASS_438068#417406, COL_AT_NUMACC_438069#417407, COL_AT_DATACC_438070#417408, COL_AT_TYPEXO_438071#417409, COL_AT_DATMAJ_438072#417410, COL_AT_CODUTI_438073#417411, COL_AT_FLCMU_438074#417412, COL_AT_QUALSS_438075#417413, COL_AT_CODREF_438076#417414, COL_AT_CODREGAT_438077#417415, COL_AT_CODCAIAT_438078#417416, COL_AT_INDVITAL_438079#417417, COL_AT_CONMUT_438080#417418, COL_AT_ADHMUT_438081#417419, COL_AT_GARMUT_438082#417420, COL_AT_NUMPER_ORI_438083#417421, COL_AT_CODROUT_438084#417422, COL_AT_DOMAINE_438085#417423, COL_AT_INDTRAI_438086#417424, COL_AT_IDHOTE_438087#417425, COL_AT_CODSTS_438088#417426, COL_AT_NIRIND_438089#417427, COL_AT_FLDCD_438090#417428, COL_AT_FLPHOTO_438091#417429, COL_AT_CODMTR_438092#417430, COL_AT_ADR_3_438093#417431, COL_AT_PAYS_ISO_438094#417432, COL_AT_ADR_3A_438095#417433, COL_AT_POIDS_MAJ_438096#417434, COL_AT_CODGESTION_438097#417435, COL_AT_ART115_438098#417436, COL_AT_TAILLE_438099#417437, COL_AT_TAILLE_MAJ_438100#417438, COL_AT_CODETAB_PROD_438101#417439, COL_AT_CODSIT_PROD_438102#417440, COL_AT_NUMDOS_PROD_438103#417441, COL_AT_NUMPER_PROD_438104#417442, COL_AT_NUMPER_ORI_P_438105#417443, COL_AT_INS_438106#417444, COL_AT_INS_TYPE_438107#417445, COL_AT_INS_DATE_438108#417446, COL_AT_INS_SOURCE_438109#417447, COL_AT_STADMP_438110#417448, COL_AT_DATDMP_438111#417449, COL_AT_ALARMES_438112#417450, COL_AT_EMAIL_438113#417451, COL_AT_CONSENT_SMS_438114#417452, COL_AT_DAT_CONSENT__438115#417453, COL_AT_DATDCD_438116#417454, COL_AT_FLHLIM_438117#417455, COL_AT_DATHLIM_438118#417456, COL_AT_CODPERSHLIM_438119#417457, COL_AT_FLDIFF_438120#417458, COL_AT_LISDEST_438121#417459, COL_AT_LANGUE_438122#417460, COL_AT_NUMCAI_FT_438123#417461, COL_AT_CODTARIFAMC_438124#417462, COL_AT_FLGRVE_438125#417463, COL_AT_FLADRI_438126#417464, COL_AT_DATADRI_438127#417465, COL_AT_DATF_MUT_438128#417466, COL_AT_COMFAC_438129#417467, COL_AT_NUMDOS_CLOUD_438130#417468, COL_AT_NATION_438131#417469, COL_AT_TITRE_438132#417470, COL_AT_TITRE_ASS_438133#417471, COL_AT_TIQ_HISTOXML_438134#417472, COL_AT_TIQ_PNOLISTE_438135#417473, COL_AT_CODPOSNAI_438136#417474, COL_AT_INSI_438137#417475, COL_AT_INSI_OID_438138#417476, COL_AT_TYPCONV_438139#417477, COL_AT_CRISEC_438140#417478, COL_AT_OPEREG_438141#417479, COL_AT_FLANNUAMC_438142#417480, COL_AT_STAIPP_438143#417481, COL_AT_PNONAI_438144#417482, COL_AT_CODINSEENAI_438145#417483, COL_AT_VILLENAI_438146#417484, COL_AT_PIECE_IDENT__438147#417485, COL_AT_DAT_STAIPP_438148#417486, COL_AT_DATAPCV_438149#417487, COL_AT_NUM_APCV_438150#417488, COL_AT_HEUAPCV_438151#417489, COL_AT_NUMPER_SEC_438152#417490, COL_AT_INS_HEURE_438153#417491, COL_AT_PERSAPREV_438154#417492, COL_AT_TARIF_438155#417493, COL_AT_NOMHL7_438156#417494, COL_AT_NUMPER_ORI_O_438157#417495, COL_AT_COMMENT_438158#417496, COL_ORIGINE_440149#417497]
Arguments: 1500

(5) Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore2"."h_patien") as x) [numPartitions=1] 
Output [136]: [at_numdos#415312, at_stapat#415313, at_prefix#415314, at_nompat#415315, at_pnopat#415316, at_njfpat#415317, at_datnai#415318, at_datnaiss#415319, at_sexe#415320, at_numper#415321, at_sigma#415322, at_verrou#415323, at_poids#415324, at_indcen#415325, at_numss#415326, at_antece#415327, at_adr_1#415328, at_adr_2#415329, at_codpos#415330, at_ville#415331, at_pays#415332, at_numcai#415333, at_nummut#415334, at_numcha#415335, at_telpri#415336, at_telbur#415337, at_telpor#415338, at_fax#415339, at_prefi2#415340, at_nomass#415341, at_pnoass#415342, at_njfass#415343, at_datass#415344, at_adr_1a#415345, at_adr_2a#415346, at_codpoa#415347, at_villea#415348, at_codmed#415349, at_datcss#415350, at_datf_d#415351, at_dat100#415352, at_numsir#415353, at_numssa#415354, at_codser#415355, at_rngnai#415356, at_natass#415357, at_numacc#415358, at_datacc#415359, at_typexo#415360, at_datmaj#415361, at_coduti#415362, at_flcmu#415363, at_qualss#415364, at_codref#415365, at_codregat#415366, at_codcaiat#415367, at_indvital#415368, at_conmut#415369, at_adhmut#415370, at_garmut#415371, at_numper_ori#415372, at_codrout#415373, at_domaine#415374, at_indtrai#415375, at_idhote#415376, at_codsts#415377, at_nirind#415378, at_fldcd#415379, at_flphoto#415380, at_codmtr#415381, at_adr_3#415382, at_pays_iso#415383, at_adr_3a#415384, at_poids_maj#415385, at_codgestion#415386, at_art115#415387, at_taille#415388, at_taille_maj#415389, at_codetab_prod#415390, at_codsit_prod#415391, at_numdos_prod#415392, at_numper_prod#415393, at_numper_ori_prod#415394, at_ins#415395, at_ins_type#415396, at_ins_date#415397, at_ins_source#415398, at_stadmp#415399, at_datdmp#415400, at_alarmes#415401, at_email#415402, at_consent_sms#415403, at_dat_consent_sms#415404, at_datdcd#415405, at_flhlim#415406, at_dathlim#415407, at_codpershlim#415408, at_fldiff#415409, at_lisdest#415410, at_langue#415411, at_numcai_ft#415412, at_codtarifamc#415413, at_flgrve#415414, at_fladri#415415, at_datadri#415416, at_datf_mut#415417, at_comfac#415418, at_numdos_cloud#415419, at_nation#415420, at_titre#415421, at_titre_ass#415422, at_tiq_histoxml#415423, at_tiq_pnoliste#415424, at_codposnai#415425, at_insi#415426, at_insi_oid#415427, at_typconv#415428, at_crisec#415429, at_opereg#415430, at_flannuamc#415431, at_staipp#415432, at_pnonai#415433, at_codinseenai#415434, at_villenai#415435, at_piece_ident_pres#415436, at_dat_staipp#415437, at_datapcv#415438, at_num_apcv#415439, at_heuapcv#415440, at_numper_sec#415441, at_ins_heure#415442, at_persaprev#415443, at_tarif#415444, at_nomhl7#415445, at_numper_ori_oid#415446, at_comment#415447]
ReadSchema: struct<at_numdos:string,at_stapat:string,at_prefix:string,at_nompat:string,at_pnopat:string,at_njfpat:string,at_datnai:string,at_datnaiss:string,at_sexe:string,at_numper:string,at_sigma:string,at_verrou:string,at_poids:string,at_indcen:string,at_numss:string,at_antece:string,at_adr_1:string,at_adr_2:string,at_codpos:string,at_ville:string,at_pays:string,at_numcai:string,at_nummut:string,at_numcha:string,at_telpri:string,at_telbur:string,at_telpor:string,at_fax:string,at_prefi2:string,at_nomass:string,at_pnoass:string,at_njfass:string,at_datass:string,at_adr_1a:string,at_adr_2a:string,at_codpoa:string,at_villea:string,at_codmed:string,at_datcss:string,at_datf_d:string,at_dat100:string,at_numsir:string,at_numssa:string,at_codser:string,at_rngnai:string,at_natass:string,at_numacc:string,at_datacc:string,at_typexo:string,at_datmaj:string,at_coduti:string,at_flcmu:string,at_qualss:string,at_codref:string,at_codregat:string,at_codcaiat:string,at_indvital:string,at_conmut:string,at_adhmut:string,at_garmut:string,at_numper_ori:string,at_codrout:string,at_domaine:string,at_indtrai:string,at_idhote:string,at_codsts:string,at_nirind:string,at_fldcd:string,at_flphoto:string,at_codmtr:string,at_adr_3:string,at_pays_iso:string,at_adr_3a:string,at_poids_maj:string,at_codgestion:string,at_art115:string,at_taille:string,at_taille_maj:string,at_codetab_prod:string,at_codsit_prod:string,at_numdos_prod:string,at_numper_prod:string,at_numper_ori_prod:string,at_ins:string,at_ins_type:string,at_ins_date:string,at_ins_source:string,at_stadmp:string,at_datdmp:string,at_alarmes:string,at_email:string,at_consent_sms:string,at_dat_consent_sms:string,at_datdcd:string,at_flhlim:string,at_dathlim:string,at_codpershlim:string,at_fldiff:string,at_lisdest:string,at_langue:string,at_numcai_ft:string,at_codtarifamc:string,at_flgrve:string,at_fladri:string,at_datadri:string,at_datf_mut:string,at_comfac:string,at_numdos_cloud:string,at_nation:string,at_titre:string,at_titre_ass:string,at_tiq_histoxml:string,at_tiq_pnoliste:string,at_codposnai:string,at_insi:string,at_insi_oid:string,at_typconv:string,at_crisec:string,at_opereg:string,at_flannuamc:string,at_staipp:string,at_pnonai:string,at_codinseenai:string,at_villenai:string,at_piece_ident_pres:string,at_dat_staipp:string,at_datapcv:string,at_num_apcv:string,at_heuapcv:string,at_numper_sec:string,at_ins_heure:string,at_persaprev:string,at_tarif:string,at_nomhl7:string,at_numper_ori_oid:string,at_comment:string>

(6) Filter
Input [136]: [at_numdos#415312, at_stapat#415313, at_prefix#415314, at_nompat#415315, at_pnopat#415316, at_njfpat#415317, at_datnai#415318, at_datnaiss#415319, at_sexe#415320, at_numper#415321, at_sigma#415322, at_verrou#415323, at_poids#415324, at_indcen#415325, at_numss#415326, at_antece#415327, at_adr_1#415328, at_adr_2#415329, at_codpos#415330, at_ville#415331, at_pays#415332, at_numcai#415333, at_nummut#415334, at_numcha#415335, at_telpri#415336, at_telbur#415337, at_telpor#415338, at_fax#415339, at_prefi2#415340, at_nomass#415341, at_pnoass#415342, at_njfass#415343, at_datass#415344, at_adr_1a#415345, at_adr_2a#415346, at_codpoa#415347, at_villea#415348, at_codmed#415349, at_datcss#415350, at_datf_d#415351, at_dat100#415352, at_numsir#415353, at_numssa#415354, at_codser#415355, at_rngnai#415356, at_natass#415357, at_numacc#415358, at_datacc#415359, at_typexo#415360, at_datmaj#415361, at_coduti#415362, at_flcmu#415363, at_qualss#415364, at_codref#415365, at_codregat#415366, at_codcaiat#415367, at_indvital#415368, at_conmut#415369, at_adhmut#415370, at_garmut#415371, at_numper_ori#415372, at_codrout#415373, at_domaine#415374, at_indtrai#415375, at_idhote#415376, at_codsts#415377, at_nirind#415378, at_fldcd#415379, at_flphoto#415380, at_codmtr#415381, at_adr_3#415382, at_pays_iso#415383, at_adr_3a#415384, at_poids_maj#415385, at_codgestion#415386, at_art115#415387, at_taille#415388, at_taille_maj#415389, at_codetab_prod#415390, at_codsit_prod#415391, at_numdos_prod#415392, at_numper_prod#415393, at_numper_ori_prod#415394, at_ins#415395, at_ins_type#415396, at_ins_date#415397, at_ins_source#415398, at_stadmp#415399, at_datdmp#415400, at_alarmes#415401, at_email#415402, at_consent_sms#415403, at_dat_consent_sms#415404, at_datdcd#415405, at_flhlim#415406, at_dathlim#415407, at_codpershlim#415408, at_fldiff#415409, at_lisdest#415410, at_langue#415411, at_numcai_ft#415412, at_codtarifamc#415413, at_flgrve#415414, at_fladri#415415, at_datadri#415416, at_datf_mut#415417, at_comfac#415418, at_numdos_cloud#415419, at_nation#415420, at_titre#415421, at_titre_ass#415422, at_tiq_histoxml#415423, at_tiq_pnoliste#415424, at_codposnai#415425, at_insi#415426, at_insi_oid#415427, at_typconv#415428, at_crisec#415429, at_opereg#415430, at_flannuamc#415431, at_staipp#415432, at_pnonai#415433, at_codinseenai#415434, at_villenai#415435, at_piece_ident_pres#415436, at_dat_staipp#415437, at_datapcv#415438, at_num_apcv#415439, at_heuapcv#415440, at_numper_sec#415441, at_ins_heure#415442, at_persaprev#415443, at_tarif#415444, at_nomhl7#415445, at_numper_ori_oid#415446, at_comment#415447]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos#415312)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos#415312)), 0000000010) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stapat#415313)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_stapat#415313)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefix#415314)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_prefix#415314)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nompat#415315)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nompat#415315)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnopat#415316)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_pnopat#415316)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfpat#415317)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_njfpat#415317)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnai#415318)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datnai#415318)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnaiss#415319)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datnaiss#415319)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sexe#415320)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_sexe#415320)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper#415321)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper#415321)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sigma#415322)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_sigma#415322)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_verrou#415323)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_verrou#415323)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids#415324)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_poids#415324)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indcen#415325)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_indcen#415325)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numss#415326)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numss#415326)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_antece#415327)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_antece#415327)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1#415328)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1#415328)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2#415329)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2#415329)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpos#415330)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codpos#415330)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ville#415331)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ville#415331)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays#415332)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_pays#415332)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai#415333)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai#415333)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nummut#415334)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nummut#415334)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcha#415335)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numcha#415335)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpri#415336)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_telpri#415336)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telbur#415337)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_telbur#415337)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpor#415338)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_telpor#415338)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fax#415339)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_fax#415339)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefi2#415340)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_prefi2#415340)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomass#415341)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nomass#415341)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnoass#415342)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_pnoass#415342)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfass#415343)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_njfass#415343)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datass#415344)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datass#415344)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1a#415345)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1a#415345)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2a#415346)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2a#415346)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpoa#415347)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codpoa#415347)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villea#415348)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_villea#415348)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmed#415349)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codmed#415349)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datcss#415350)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datcss#415350)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_d#415351)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_d#415351)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat100#415352)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_dat100#415352)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numsir#415353)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numsir#415353)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numssa#415354)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numssa#415354)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codser#415355)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codser#415355)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_rngnai#415356)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_rngnai#415356)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_natass#415357)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_natass#415357)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numacc#415358)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numacc#415358)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datacc#415359)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datacc#415359)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typexo#415360)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_typexo#415360)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datmaj#415361)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datmaj#415361)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_coduti#415362)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_coduti#415362)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flcmu#415363)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_flcmu#415363)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_qualss#415364)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_qualss#415364)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codref#415365)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codref#415365)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codregat#415366)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codregat#415366)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codcaiat#415367)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codcaiat#415367)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indvital#415368)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_indvital#415368)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_conmut#415369)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_conmut#415369)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adhmut#415370)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adhmut#415370)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_garmut#415371)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_garmut#415371)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori#415372)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori#415372)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codrout#415373)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codrout#415373)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_domaine#415374)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_domaine#415374)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indtrai#415375)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_indtrai#415375)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_idhote#415376)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_idhote#415376)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsts#415377)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codsts#415377)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nirind#415378)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nirind#415378)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldcd#415379)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_fldcd#415379)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flphoto#415380)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_flphoto#415380)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmtr#415381)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codmtr#415381)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3#415382)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3#415382)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays_iso#415383)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_pays_iso#415383)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3a#415384)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3a#415384)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids_maj#415385)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_poids_maj#415385)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codgestion#415386)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codgestion#415386)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_art115#415387)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_art115#415387)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille#415388)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_taille#415388)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille_maj#415389)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_taille_maj#415389)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codetab_prod#415390)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codetab_prod#415390)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsit_prod#415391)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codsit_prod#415391)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_prod#415392)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_prod#415392)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_prod#415393)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_prod#415393)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_prod#415394)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_prod#415394)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins#415395)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ins#415395)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_type#415396)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_type#415396)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_date#415397)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_date#415397)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_source#415398)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_source#415398)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stadmp#415399)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_stadmp#415399)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdmp#415400)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datdmp#415400)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_alarmes#415401)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_alarmes#415401)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_email#415402)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_email#415402)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_consent_sms#415403)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_consent_sms#415403)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_consent_sms#415404)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_consent_sms#415404)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdcd#415405)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datdcd#415405)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flhlim#415406)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_flhlim#415406)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dathlim#415407)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_dathlim#415407)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpershlim#415408)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codpershlim#415408)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldiff#415409)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_fldiff#415409)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_lisdest#415410)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_lisdest#415410)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_langue#415411)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_langue#415411)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai_ft#415412)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai_ft#415412)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codtarifamc#415413)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codtarifamc#415413)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flgrve#415414)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_flgrve#415414)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fladri#415415)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_fladri#415415)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datadri#415416)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datadri#415416)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_mut#415417)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_mut#415417)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comfac#415418)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_comfac#415418)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_cloud#415419)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_cloud#415419)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nation#415420)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nation#415420)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre#415421)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_titre#415421)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre_ass#415422)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_titre_ass#415422)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_histoxml#415423)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_histoxml#415423)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_pnoliste#415424)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_pnoliste#415424)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codposnai#415425)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codposnai#415425)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi#415426)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_insi#415426)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi_oid#415427)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_insi_oid#415427)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typconv#415428)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_typconv#415428)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_crisec#415429)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_crisec#415429)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_opereg#415430)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_opereg#415430)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flannuamc#415431)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_flannuamc#415431)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_staipp#415432)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_staipp#415432)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnonai#415433)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_pnonai#415433)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codinseenai#415434)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codinseenai#415434)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villenai#415435)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_villenai#415435)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_piece_ident_pres#415436)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_piece_ident_pres#415436)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_staipp#415437)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_staipp#415437)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datapcv#415438)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datapcv#415438)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_num_apcv#415439)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_num_apcv#415439)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_heuapcv#415440)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_heuapcv#415440)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_sec#415441)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_sec#415441)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_heure#415442)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_heure#415442)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_persaprev#415443)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_persaprev#415443)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tarif#415444)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_tarif#415444)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomhl7#415445)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nomhl7#415445)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_oid#415446)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_oid#415446)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comment#415447)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_comment#415447)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_B))), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_B))), 0000000010) END)

(7) Project
Output [137]: [at_numdos#415312 AS COL_AT_NUMDOS_438023#418183, at_stapat#415313 AS COL_AT_STAPAT_438024#418184, at_prefix#415314 AS COL_AT_PREFIX_438025#418185, at_nompat#415315 AS COL_AT_NOMPAT_438026#418186, at_pnopat#415316 AS COL_AT_PNOPAT_438027#418187, at_njfpat#415317 AS COL_AT_NJFPAT_438028#418188, at_datnai#415318 AS COL_AT_DATNAI_438029#418189, at_datnaiss#415319 AS COL_AT_DATNAISS_438030#418190, at_sexe#415320 AS COL_AT_SEXE_438031#418191, at_numper#415321 AS COL_AT_NUMPER_438032#418192, at_sigma#415322 AS COL_AT_SIGMA_438033#418193, at_verrou#415323 AS COL_AT_VERROU_438034#418194, at_poids#415324 AS COL_AT_POIDS_438035#418195, at_indcen#415325 AS COL_AT_INDCEN_438036#418196, at_numss#415326 AS COL_AT_NUMSS_438037#418197, at_antece#415327 AS COL_AT_ANTECE_438038#418198, at_adr_1#415328 AS COL_AT_ADR_1_438039#418199, at_adr_2#415329 AS COL_AT_ADR_2_438040#418200, at_codpos#415330 AS COL_AT_CODPOS_438041#418201, at_ville#415331 AS COL_AT_VILLE_438042#418202, at_pays#415332 AS COL_AT_PAYS_438043#418203, at_numcai#415333 AS COL_AT_NUMCAI_438044#418204, at_nummut#415334 AS COL_AT_NUMMUT_438045#418205, at_numcha#415335 AS COL_AT_NUMCHA_438046#418206, at_telpri#415336 AS COL_AT_TELPRI_438047#418207, at_telbur#415337 AS COL_AT_TELBUR_438048#418208, at_telpor#415338 AS COL_AT_TELPOR_438049#418209, at_fax#415339 AS COL_AT_FAX_438050#418210, at_prefi2#415340 AS COL_AT_PREFI2_438051#418211, at_nomass#415341 AS COL_AT_NOMASS_438052#418212, at_pnoass#415342 AS COL_AT_PNOASS_438053#418213, at_njfass#415343 AS COL_AT_NJFASS_438054#418214, at_datass#415344 AS COL_AT_DATASS_438055#418215, at_adr_1a#415345 AS COL_AT_ADR_1A_438056#418216, at_adr_2a#415346 AS COL_AT_ADR_2A_438057#418217, at_codpoa#415347 AS COL_AT_CODPOA_438058#418218, at_villea#415348 AS COL_AT_VILLEA_438059#418219, at_codmed#415349 AS COL_AT_CODMED_438060#418220, at_datcss#415350 AS COL_AT_DATCSS_438061#418221, at_datf_d#415351 AS COL_AT_DATF_D_438062#418222, at_dat100#415352 AS COL_AT_DAT100_438063#418223, at_numsir#415353 AS COL_AT_NUMSIR_438064#418224, at_numssa#415354 AS COL_AT_NUMSSA_438065#418225, at_codser#415355 AS COL_AT_CODSER_438066#418226, at_rngnai#415356 AS COL_AT_RNGNAI_438067#418227, at_natass#415357 AS COL_AT_NATASS_438068#418228, at_numacc#415358 AS COL_AT_NUMACC_438069#418229, at_datacc#415359 AS COL_AT_DATACC_438070#418230, at_typexo#415360 AS COL_AT_TYPEXO_438071#418231, at_datmaj#415361 AS COL_AT_DATMAJ_438072#418232, at_coduti#415362 AS COL_AT_CODUTI_438073#418233, at_flcmu#415363 AS COL_AT_FLCMU_438074#418234, at_qualss#415364 AS COL_AT_QUALSS_438075#418235, at_codref#415365 AS COL_AT_CODREF_438076#418236, at_codregat#415366 AS COL_AT_CODREGAT_438077#418237, at_codcaiat#415367 AS COL_AT_CODCAIAT_438078#418238, at_indvital#415368 AS COL_AT_INDVITAL_438079#418239, at_conmut#415369 AS COL_AT_CONMUT_438080#418240, at_adhmut#415370 AS COL_AT_ADHMUT_438081#418241, at_garmut#415371 AS COL_AT_GARMUT_438082#418242, at_numper_ori#415372 AS COL_AT_NUMPER_ORI_438083#418243, at_codrout#415373 AS COL_AT_CODROUT_438084#418244, at_domaine#415374 AS COL_AT_DOMAINE_438085#418245, at_indtrai#415375 AS COL_AT_INDTRAI_438086#418246, at_idhote#415376 AS COL_AT_IDHOTE_438087#418247, at_codsts#415377 AS COL_AT_CODSTS_438088#418248, at_nirind#415378 AS COL_AT_NIRIND_438089#418249, at_fldcd#415379 AS COL_AT_FLDCD_438090#418250, at_flphoto#415380 AS COL_AT_FLPHOTO_438091#418251, at_codmtr#415381 AS COL_AT_CODMTR_438092#418252, at_adr_3#415382 AS COL_AT_ADR_3_438093#418253, at_pays_iso#415383 AS COL_AT_PAYS_ISO_438094#418254, at_adr_3a#415384 AS COL_AT_ADR_3A_438095#418255, at_poids_maj#415385 AS COL_AT_POIDS_MAJ_438096#418256, at_codgestion#415386 AS COL_AT_CODGESTION_438097#418257, at_art115#415387 AS COL_AT_ART115_438098#418258, at_taille#415388 AS COL_AT_TAILLE_438099#418259, at_taille_maj#415389 AS COL_AT_TAILLE_MAJ_438100#418260, at_codetab_prod#415390 AS COL_AT_CODETAB_PROD_438101#418261, at_codsit_prod#415391 AS COL_AT_CODSIT_PROD_438102#418262, at_numdos_prod#415392 AS COL_AT_NUMDOS_PROD_438103#418263, at_numper_prod#415393 AS COL_AT_NUMPER_PROD_438104#418264, at_numper_ori_prod#415394 AS COL_AT_NUMPER_ORI_P_438105#418265, at_ins#415395 AS COL_AT_INS_438106#418266, at_ins_type#415396 AS COL_AT_INS_TYPE_438107#418267, at_ins_date#415397 AS COL_AT_INS_DATE_438108#418268, at_ins_source#415398 AS COL_AT_INS_SOURCE_438109#418269, at_stadmp#415399 AS COL_AT_STADMP_438110#418270, at_datdmp#415400 AS COL_AT_DATDMP_438111#418271, at_alarmes#415401 AS COL_AT_ALARMES_438112#418272, at_email#415402 AS COL_AT_EMAIL_438113#418273, at_consent_sms#415403 AS COL_AT_CONSENT_SMS_438114#418274, at_dat_consent_sms#415404 AS COL_AT_DAT_CONSENT__438115#418275, at_datdcd#415405 AS COL_AT_DATDCD_438116#418276, at_flhlim#415406 AS COL_AT_FLHLIM_438117#418277, at_dathlim#415407 AS COL_AT_DATHLIM_438118#418278, at_codpershlim#415408 AS COL_AT_CODPERSHLIM_438119#418279, at_fldiff#415409 AS COL_AT_FLDIFF_438120#418280, at_lisdest#415410 AS COL_AT_LISDEST_438121#418281, at_langue#415411 AS COL_AT_LANGUE_438122#418282, at_numcai_ft#415412 AS COL_AT_NUMCAI_FT_438123#418283, at_codtarifamc#415413 AS COL_AT_CODTARIFAMC_438124#418284, at_flgrve#415414 AS COL_AT_FLGRVE_438125#418285, at_fladri#415415 AS COL_AT_FLADRI_438126#418286, at_datadri#415416 AS COL_AT_DATADRI_438127#418287, at_datf_mut#415417 AS COL_AT_DATF_MUT_438128#418288, at_comfac#415418 AS COL_AT_COMFAC_438129#418289, at_numdos_cloud#415419 AS COL_AT_NUMDOS_CLOUD_438130#418290, at_nation#415420 AS COL_AT_NATION_438131#418291, at_titre#415421 AS COL_AT_TITRE_438132#418292, at_titre_ass#415422 AS COL_AT_TITRE_ASS_438133#418293, at_tiq_histoxml#415423 AS COL_AT_TIQ_HISTOXML_438134#418294, at_tiq_pnoliste#415424 AS COL_AT_TIQ_PNOLISTE_438135#418295, at_codposnai#415425 AS COL_AT_CODPOSNAI_438136#418296, at_insi#415426 AS COL_AT_INSI_438137#418297, at_insi_oid#415427 AS COL_AT_INSI_OID_438138#418298, at_typconv#415428 AS COL_AT_TYPCONV_438139#418299, at_crisec#415429 AS COL_AT_CRISEC_438140#418300, at_opereg#415430 AS COL_AT_OPEREG_438141#418301, at_flannuamc#415431 AS COL_AT_FLANNUAMC_438142#418302, at_staipp#415432 AS COL_AT_STAIPP_438143#418303, at_pnonai#415433 AS COL_AT_PNONAI_438144#418304, at_codinseenai#415434 AS COL_AT_CODINSEENAI_438145#418305, at_villenai#415435 AS COL_AT_VILLENAI_438146#418306, at_piece_ident_pres#415436 AS COL_AT_PIECE_IDENT__438147#418307, at_dat_staipp#415437 AS COL_AT_DAT_STAIPP_438148#418308, at_datapcv#415438 AS COL_AT_DATAPCV_438149#418309, at_num_apcv#415439 AS COL_AT_NUM_APCV_438150#418310, at_heuapcv#415440 AS COL_AT_HEUAPCV_438151#418311, at_numper_sec#415441 AS COL_AT_NUMPER_SEC_438152#418312, at_ins_heure#415442 AS COL_AT_INS_HEURE_438153#418313, at_persaprev#415443 AS COL_AT_PERSAPREV_438154#418314, at_tarif#415444 AS COL_AT_TARIF_438155#418315, at_nomhl7#415445 AS COL_AT_NOMHL7_438156#418316, at_numper_ori_oid#415446 AS COL_AT_NUMPER_ORI_O_438157#418317, at_comment#415447 AS COL_AT_COMMENT_438158#418318, str_create(Cab_B) AS COL_ORIGINE_440149#418319]
Input [136]: [at_numdos#415312, at_stapat#415313, at_prefix#415314, at_nompat#415315, at_pnopat#415316, at_njfpat#415317, at_datnai#415318, at_datnaiss#415319, at_sexe#415320, at_numper#415321, at_sigma#415322, at_verrou#415323, at_poids#415324, at_indcen#415325, at_numss#415326, at_antece#415327, at_adr_1#415328, at_adr_2#415329, at_codpos#415330, at_ville#415331, at_pays#415332, at_numcai#415333, at_nummut#415334, at_numcha#415335, at_telpri#415336, at_telbur#415337, at_telpor#415338, at_fax#415339, at_prefi2#415340, at_nomass#415341, at_pnoass#415342, at_njfass#415343, at_datass#415344, at_adr_1a#415345, at_adr_2a#415346, at_codpoa#415347, at_villea#415348, at_codmed#415349, at_datcss#415350, at_datf_d#415351, at_dat100#415352, at_numsir#415353, at_numssa#415354, at_codser#415355, at_rngnai#415356, at_natass#415357, at_numacc#415358, at_datacc#415359, at_typexo#415360, at_datmaj#415361, at_coduti#415362, at_flcmu#415363, at_qualss#415364, at_codref#415365, at_codregat#415366, at_codcaiat#415367, at_indvital#415368, at_conmut#415369, at_adhmut#415370, at_garmut#415371, at_numper_ori#415372, at_codrout#415373, at_domaine#415374, at_indtrai#415375, at_idhote#415376, at_codsts#415377, at_nirind#415378, at_fldcd#415379, at_flphoto#415380, at_codmtr#415381, at_adr_3#415382, at_pays_iso#415383, at_adr_3a#415384, at_poids_maj#415385, at_codgestion#415386, at_art115#415387, at_taille#415388, at_taille_maj#415389, at_codetab_prod#415390, at_codsit_prod#415391, at_numdos_prod#415392, at_numper_prod#415393, at_numper_ori_prod#415394, at_ins#415395, at_ins_type#415396, at_ins_date#415397, at_ins_source#415398, at_stadmp#415399, at_datdmp#415400, at_alarmes#415401, at_email#415402, at_consent_sms#415403, at_dat_consent_sms#415404, at_datdcd#415405, at_flhlim#415406, at_dathlim#415407, at_codpershlim#415408, at_fldiff#415409, at_lisdest#415410, at_langue#415411, at_numcai_ft#415412, at_codtarifamc#415413, at_flgrve#415414, at_fladri#415415, at_datadri#415416, at_datf_mut#415417, at_comfac#415418, at_numdos_cloud#415419, at_nation#415420, at_titre#415421, at_titre_ass#415422, at_tiq_histoxml#415423, at_tiq_pnoliste#415424, at_codposnai#415425, at_insi#415426, at_insi_oid#415427, at_typconv#415428, at_crisec#415429, at_opereg#415430, at_flannuamc#415431, at_staipp#415432, at_pnonai#415433, at_codinseenai#415434, at_villenai#415435, at_piece_ident_pres#415436, at_dat_staipp#415437, at_datapcv#415438, at_num_apcv#415439, at_heuapcv#415440, at_numper_sec#415441, at_ins_heure#415442, at_persaprev#415443, at_tarif#415444, at_nomhl7#415445, at_numper_ori_oid#415446, at_comment#415447]

(8) LocalLimit
Input [137]: [COL_AT_NUMDOS_438023#418183, COL_AT_STAPAT_438024#418184, COL_AT_PREFIX_438025#418185, COL_AT_NOMPAT_438026#418186, COL_AT_PNOPAT_438027#418187, COL_AT_NJFPAT_438028#418188, COL_AT_DATNAI_438029#418189, COL_AT_DATNAISS_438030#418190, COL_AT_SEXE_438031#418191, COL_AT_NUMPER_438032#418192, COL_AT_SIGMA_438033#418193, COL_AT_VERROU_438034#418194, COL_AT_POIDS_438035#418195, COL_AT_INDCEN_438036#418196, COL_AT_NUMSS_438037#418197, COL_AT_ANTECE_438038#418198, COL_AT_ADR_1_438039#418199, COL_AT_ADR_2_438040#418200, COL_AT_CODPOS_438041#418201, COL_AT_VILLE_438042#418202, COL_AT_PAYS_438043#418203, COL_AT_NUMCAI_438044#418204, COL_AT_NUMMUT_438045#418205, COL_AT_NUMCHA_438046#418206, COL_AT_TELPRI_438047#418207, COL_AT_TELBUR_438048#418208, COL_AT_TELPOR_438049#418209, COL_AT_FAX_438050#418210, COL_AT_PREFI2_438051#418211, COL_AT_NOMASS_438052#418212, COL_AT_PNOASS_438053#418213, COL_AT_NJFASS_438054#418214, COL_AT_DATASS_438055#418215, COL_AT_ADR_1A_438056#418216, COL_AT_ADR_2A_438057#418217, COL_AT_CODPOA_438058#418218, COL_AT_VILLEA_438059#418219, COL_AT_CODMED_438060#418220, COL_AT_DATCSS_438061#418221, COL_AT_DATF_D_438062#418222, COL_AT_DAT100_438063#418223, COL_AT_NUMSIR_438064#418224, COL_AT_NUMSSA_438065#418225, COL_AT_CODSER_438066#418226, COL_AT_RNGNAI_438067#418227, COL_AT_NATASS_438068#418228, COL_AT_NUMACC_438069#418229, COL_AT_DATACC_438070#418230, COL_AT_TYPEXO_438071#418231, COL_AT_DATMAJ_438072#418232, COL_AT_CODUTI_438073#418233, COL_AT_FLCMU_438074#418234, COL_AT_QUALSS_438075#418235, COL_AT_CODREF_438076#418236, COL_AT_CODREGAT_438077#418237, COL_AT_CODCAIAT_438078#418238, COL_AT_INDVITAL_438079#418239, COL_AT_CONMUT_438080#418240, COL_AT_ADHMUT_438081#418241, COL_AT_GARMUT_438082#418242, COL_AT_NUMPER_ORI_438083#418243, COL_AT_CODROUT_438084#418244, COL_AT_DOMAINE_438085#418245, COL_AT_INDTRAI_438086#418246, COL_AT_IDHOTE_438087#418247, COL_AT_CODSTS_438088#418248, COL_AT_NIRIND_438089#418249, COL_AT_FLDCD_438090#418250, COL_AT_FLPHOTO_438091#418251, COL_AT_CODMTR_438092#418252, COL_AT_ADR_3_438093#418253, COL_AT_PAYS_ISO_438094#418254, COL_AT_ADR_3A_438095#418255, COL_AT_POIDS_MAJ_438096#418256, COL_AT_CODGESTION_438097#418257, COL_AT_ART115_438098#418258, COL_AT_TAILLE_438099#418259, COL_AT_TAILLE_MAJ_438100#418260, COL_AT_CODETAB_PROD_438101#418261, COL_AT_CODSIT_PROD_438102#418262, COL_AT_NUMDOS_PROD_438103#418263, COL_AT_NUMPER_PROD_438104#418264, COL_AT_NUMPER_ORI_P_438105#418265, COL_AT_INS_438106#418266, COL_AT_INS_TYPE_438107#418267, COL_AT_INS_DATE_438108#418268, COL_AT_INS_SOURCE_438109#418269, COL_AT_STADMP_438110#418270, COL_AT_DATDMP_438111#418271, COL_AT_ALARMES_438112#418272, COL_AT_EMAIL_438113#418273, COL_AT_CONSENT_SMS_438114#418274, COL_AT_DAT_CONSENT__438115#418275, COL_AT_DATDCD_438116#418276, COL_AT_FLHLIM_438117#418277, COL_AT_DATHLIM_438118#418278, COL_AT_CODPERSHLIM_438119#418279, COL_AT_FLDIFF_438120#418280, COL_AT_LISDEST_438121#418281, COL_AT_LANGUE_438122#418282, COL_AT_NUMCAI_FT_438123#418283, COL_AT_CODTARIFAMC_438124#418284, COL_AT_FLGRVE_438125#418285, COL_AT_FLADRI_438126#418286, COL_AT_DATADRI_438127#418287, COL_AT_DATF_MUT_438128#418288, COL_AT_COMFAC_438129#418289, COL_AT_NUMDOS_CLOUD_438130#418290, COL_AT_NATION_438131#418291, COL_AT_TITRE_438132#418292, COL_AT_TITRE_ASS_438133#418293, COL_AT_TIQ_HISTOXML_438134#418294, COL_AT_TIQ_PNOLISTE_438135#418295, COL_AT_CODPOSNAI_438136#418296, COL_AT_INSI_438137#418297, COL_AT_INSI_OID_438138#418298, COL_AT_TYPCONV_438139#418299, COL_AT_CRISEC_438140#418300, COL_AT_OPEREG_438141#418301, COL_AT_FLANNUAMC_438142#418302, COL_AT_STAIPP_438143#418303, COL_AT_PNONAI_438144#418304, COL_AT_CODINSEENAI_438145#418305, COL_AT_VILLENAI_438146#418306, COL_AT_PIECE_IDENT__438147#418307, COL_AT_DAT_STAIPP_438148#418308, COL_AT_DATAPCV_438149#418309, COL_AT_NUM_APCV_438150#418310, COL_AT_HEUAPCV_438151#418311, COL_AT_NUMPER_SEC_438152#418312, COL_AT_INS_HEURE_438153#418313, COL_AT_PERSAPREV_438154#418314, COL_AT_TARIF_438155#418315, COL_AT_NOMHL7_438156#418316, COL_AT_NUMPER_ORI_O_438157#418317, COL_AT_COMMENT_438158#418318, COL_ORIGINE_440149#418319]
Arguments: 1500

(9) Union

(10) CollectLimit
Input [137]: [COL_AT_NUMDOS_438023#417361, COL_AT_STAPAT_438024#417362, COL_AT_PREFIX_438025#417363, COL_AT_NOMPAT_438026#417364, COL_AT_PNOPAT_438027#417365, COL_AT_NJFPAT_438028#417366, COL_AT_DATNAI_438029#417367, COL_AT_DATNAISS_438030#417368, COL_AT_SEXE_438031#417369, COL_AT_NUMPER_438032#417370, COL_AT_SIGMA_438033#417371, COL_AT_VERROU_438034#417372, COL_AT_POIDS_438035#417373, COL_AT_INDCEN_438036#417374, COL_AT_NUMSS_438037#417375, COL_AT_ANTECE_438038#417376, COL_AT_ADR_1_438039#417377, COL_AT_ADR_2_438040#417378, COL_AT_CODPOS_438041#417379, COL_AT_VILLE_438042#417380, COL_AT_PAYS_438043#417381, COL_AT_NUMCAI_438044#417382, COL_AT_NUMMUT_438045#417383, COL_AT_NUMCHA_438046#417384, COL_AT_TELPRI_438047#417385, COL_AT_TELBUR_438048#417386, COL_AT_TELPOR_438049#417387, COL_AT_FAX_438050#417388, COL_AT_PREFI2_438051#417389, COL_AT_NOMASS_438052#417390, COL_AT_PNOASS_438053#417391, COL_AT_NJFASS_438054#417392, COL_AT_DATASS_438055#417393, COL_AT_ADR_1A_438056#417394, COL_AT_ADR_2A_438057#417395, COL_AT_CODPOA_438058#417396, COL_AT_VILLEA_438059#417397, COL_AT_CODMED_438060#417398, COL_AT_DATCSS_438061#417399, COL_AT_DATF_D_438062#417400, COL_AT_DAT100_438063#417401, COL_AT_NUMSIR_438064#417402, COL_AT_NUMSSA_438065#417403, COL_AT_CODSER_438066#417404, COL_AT_RNGNAI_438067#417405, COL_AT_NATASS_438068#417406, COL_AT_NUMACC_438069#417407, COL_AT_DATACC_438070#417408, COL_AT_TYPEXO_438071#417409, COL_AT_DATMAJ_438072#417410, COL_AT_CODUTI_438073#417411, COL_AT_FLCMU_438074#417412, COL_AT_QUALSS_438075#417413, COL_AT_CODREF_438076#417414, COL_AT_CODREGAT_438077#417415, COL_AT_CODCAIAT_438078#417416, COL_AT_INDVITAL_438079#417417, COL_AT_CONMUT_438080#417418, COL_AT_ADHMUT_438081#417419, COL_AT_GARMUT_438082#417420, COL_AT_NUMPER_ORI_438083#417421, COL_AT_CODROUT_438084#417422, COL_AT_DOMAINE_438085#417423, COL_AT_INDTRAI_438086#417424, COL_AT_IDHOTE_438087#417425, COL_AT_CODSTS_438088#417426, COL_AT_NIRIND_438089#417427, COL_AT_FLDCD_438090#417428, COL_AT_FLPHOTO_438091#417429, COL_AT_CODMTR_438092#417430, COL_AT_ADR_3_438093#417431, COL_AT_PAYS_ISO_438094#417432, COL_AT_ADR_3A_438095#417433, COL_AT_POIDS_MAJ_438096#417434, COL_AT_CODGESTION_438097#417435, COL_AT_ART115_438098#417436, COL_AT_TAILLE_438099#417437, COL_AT_TAILLE_MAJ_438100#417438, COL_AT_CODETAB_PROD_438101#417439, COL_AT_CODSIT_PROD_438102#417440, COL_AT_NUMDOS_PROD_438103#417441, COL_AT_NUMPER_PROD_438104#417442, COL_AT_NUMPER_ORI_P_438105#417443, COL_AT_INS_438106#417444, COL_AT_INS_TYPE_438107#417445, COL_AT_INS_DATE_438108#417446, COL_AT_INS_SOURCE_438109#417447, COL_AT_STADMP_438110#417448, COL_AT_DATDMP_438111#417449, COL_AT_ALARMES_438112#417450, COL_AT_EMAIL_438113#417451, COL_AT_CONSENT_SMS_438114#417452, COL_AT_DAT_CONSENT__438115#417453, COL_AT_DATDCD_438116#417454, COL_AT_FLHLIM_438117#417455, COL_AT_DATHLIM_438118#417456, COL_AT_CODPERSHLIM_438119#417457, COL_AT_FLDIFF_438120#417458, COL_AT_LISDEST_438121#417459, COL_AT_LANGUE_438122#417460, COL_AT_NUMCAI_FT_438123#417461, COL_AT_CODTARIFAMC_438124#417462, COL_AT_FLGRVE_438125#417463, COL_AT_FLADRI_438126#417464, COL_AT_DATADRI_438127#417465, COL_AT_DATF_MUT_438128#417466, COL_AT_COMFAC_438129#417467, COL_AT_NUMDOS_CLOUD_438130#417468, COL_AT_NATION_438131#417469, COL_AT_TITRE_438132#417470, COL_AT_TITRE_ASS_438133#417471, COL_AT_TIQ_HISTOXML_438134#417472, COL_AT_TIQ_PNOLISTE_438135#417473, COL_AT_CODPOSNAI_438136#417474, COL_AT_INSI_438137#417475, COL_AT_INSI_OID_438138#417476, COL_AT_TYPCONV_438139#417477, COL_AT_CRISEC_438140#417478, COL_AT_OPEREG_438141#417479, COL_AT_FLANNUAMC_438142#417480, COL_AT_STAIPP_438143#417481, COL_AT_PNONAI_438144#417482, COL_AT_CODINSEENAI_438145#417483, COL_AT_VILLENAI_438146#417484, COL_AT_PIECE_IDENT__438147#417485, COL_AT_DAT_STAIPP_438148#417486, COL_AT_DATAPCV_438149#417487, COL_AT_NUM_APCV_438150#417488, COL_AT_HEUAPCV_438151#417489, COL_AT_NUMPER_SEC_438152#417490, COL_AT_INS_HEURE_438153#417491, COL_AT_PERSAPREV_438154#417492, COL_AT_TARIF_438155#417493, COL_AT_NOMHL7_438156#417494, COL_AT_NUMPER_ORI_O_438157#417495, COL_AT_COMMENT_438158#417496, COL_ORIGINE_440149#417497]
Arguments: 1500

SQL / DataFrame Properties

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