hdh-spark-job - Details for Query 1376

Submitted Time: 2026/10/23 13:28:12
Duration: 21 s
Succeeded Jobs: 1372 1377

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

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; subgraph cluster1 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 0 ms"; 2 [labelType="html" label="HashAggregate time in aggregation build: 0 ms number of output rows: 1"]; } 3 [labelType="html" label="Exchange shuffle records written: 2 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 1986.0: task 1732)) remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 2 local bytes read: 118.0 B fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 2 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 32.0 B (16.0 B, 16.0 B, 16.0 B (stage 1986.0: task 1732)) local merged bytes read: 0.0 B number of partitions: 1 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 118.0 B (59.0 B, 59.0 B, 59.0 B (stage 1986.0: task 1732))"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n3.4 s (1.6 s, 1.8 s, 1.8 s (stage 1986.0: task 1732))"; 5 [labelType="html" label="HashAggregate time in aggregation build total (min, med, max (stageId: taskId)) 3.4 s (1.6 s, 1.8 s, 1.8 s (stage 1986.0: task 1732)) number of output rows: 2"]; } 6 [labelType="html" label=" Union "]; 7 [labelType="html" label=" Project "]; 8 [labelType="html" label="Filter number of output rows: 163"]; 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 \"xplore\".\"h_patien\") as x) [numPartitions=1] number of output rows: 23,504"]; 10 [labelType="html" label=" Project "]; 11 [labelType="html" label="Filter number of output rows: 163"]; 12 [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"]; 2->0; 3->2; 5->3; 6->5; 7->6; 8->7; 9->8; 10->6; 11->10; 12->11; }

AdaptiveSparkPlan isFinalPlan=true

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

WholeStageCodegen (2)

Exchange SinglePartition, ENSURE_REQUIREMENTS, [plan_id=37126]

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

WholeStageCodegen (1)

Union

Project

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos#685804)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos#685804)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stapat#685805)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_stapat#685805)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefix#685806)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_prefix#685806)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nompat#685807)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nompat#685807)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnopat#685808)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pnopat#685808)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfpat#685809)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_njfpat#685809)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnai#685810)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datnai#685810)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnaiss#685811)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datnaiss#685811)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sexe#685812)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_sexe#685812)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper#685813)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper#685813)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sigma#685814)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_sigma#685814)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_verrou#685815)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_verrou#685815)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids#685816)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_poids#685816)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indcen#685817)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_indcen#685817)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numss#685818)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numss#685818)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_antece#685819)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_antece#685819)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1#685820)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1#685820)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2#685821)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2#685821)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpos#685822)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codpos#685822)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ville#685823)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ville#685823)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays#685824)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pays#685824)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai#685825)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai#685825)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nummut#685826)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nummut#685826)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcha#685827)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numcha#685827)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpri#685828)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_telpri#685828)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telbur#685829)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_telbur#685829)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpor#685830)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_telpor#685830)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fax#685831)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fax#685831)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefi2#685832)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_prefi2#685832)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomass#685833)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nomass#685833)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnoass#685834)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pnoass#685834)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfass#685835)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_njfass#685835)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datass#685836)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datass#685836)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1a#685837)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1a#685837)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2a#685838)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2a#685838)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpoa#685839)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codpoa#685839)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villea#685840)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_villea#685840)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmed#685841)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codmed#685841)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datcss#685842)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datcss#685842)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_d#685843)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_d#685843)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat100#685844)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dat100#685844)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numsir#685845)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numsir#685845)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numssa#685846)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numssa#685846)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codser#685847)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codser#685847)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_rngnai#685848)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_rngnai#685848)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_natass#685849)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_natass#685849)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numacc#685850)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numacc#685850)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datacc#685851)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datacc#685851)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typexo#685852)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_typexo#685852)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datmaj#685853)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datmaj#685853)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_coduti#685854)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_coduti#685854)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flcmu#685855)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flcmu#685855)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_qualss#685856)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_qualss#685856)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codref#685857)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codref#685857)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codregat#685858)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codregat#685858)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codcaiat#685859)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codcaiat#685859)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indvital#685860)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_indvital#685860)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_conmut#685861)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_conmut#685861)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adhmut#685862)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adhmut#685862)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_garmut#685863)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_garmut#685863)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori#685864)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori#685864)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codrout#685865)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codrout#685865)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_domaine#685866)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_domaine#685866)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indtrai#685867)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_indtrai#685867)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_idhote#685868)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_idhote#685868)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsts#685869)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codsts#685869)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nirind#685870)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nirind#685870)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldcd#685871)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fldcd#685871)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flphoto#685872)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flphoto#685872)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmtr#685873)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codmtr#685873)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3#685874)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3#685874)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays_iso#685875)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pays_iso#685875)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3a#685876)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3a#685876)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids_maj#685877)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_poids_maj#685877)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codgestion#685878)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codgestion#685878)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_art115#685879)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_art115#685879)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille#685880)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_taille#685880)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille_maj#685881)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_taille_maj#685881)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codetab_prod#685882)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codetab_prod#685882)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsit_prod#685883)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codsit_prod#685883)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_prod#685884)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_prod#685884)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_prod#685885)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_prod#685885)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_prod#685886)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_prod#685886)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins#685887)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins#685887)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_type#685888)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_type#685888)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_date#685889)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_date#685889)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_source#685890)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_source#685890)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stadmp#685891)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_stadmp#685891)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdmp#685892)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datdmp#685892)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_alarmes#685893)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_alarmes#685893)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_email#685894)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_email#685894)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_consent_sms#685895)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_consent_sms#685895)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_consent_sms#685896)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_consent_sms#685896)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdcd#685897)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datdcd#685897)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flhlim#685898)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flhlim#685898)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dathlim#685899)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dathlim#685899)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpershlim#685900)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codpershlim#685900)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldiff#685901)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fldiff#685901)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_lisdest#685902)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_lisdest#685902)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_langue#685903)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_langue#685903)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai_ft#685904)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai_ft#685904)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codtarifamc#685905)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codtarifamc#685905)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flgrve#685906)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flgrve#685906)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fladri#685907)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fladri#685907)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datadri#685908)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datadri#685908)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_mut#685909)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_mut#685909)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comfac#685910)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_comfac#685910)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_cloud#685911)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_cloud#685911)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nation#685912)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nation#685912)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre#685913)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_titre#685913)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre_ass#685914)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_titre_ass#685914)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_histoxml#685915)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_histoxml#685915)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_pnoliste#685916)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_pnoliste#685916)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codposnai#685917)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codposnai#685917)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi#685918)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_insi#685918)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi_oid#685919)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_insi_oid#685919)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typconv#685920)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_typconv#685920)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_crisec#685921)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_crisec#685921)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_opereg#685922)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_opereg#685922)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flannuamc#685923)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flannuamc#685923)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_staipp#685924)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_staipp#685924)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnonai#685925)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pnonai#685925)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codinseenai#685926)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codinseenai#685926)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villenai#685927)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_villenai#685927)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_piece_ident_pres#685928)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_piece_ident_pres#685928)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_staipp#685929)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_staipp#685929)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datapcv#685930)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datapcv#685930)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_num_apcv#685931)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_num_apcv#685931)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_heuapcv#685932)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_heuapcv#685932)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_sec#685933)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_sec#685933)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_heure#685934)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_heure#685934)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_persaprev#685935)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_persaprev#685935)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tarif#685936)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_tarif#685936)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomhl7#685937)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nomhl7#685937)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_oid#685938)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_oid#685938)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comment#685939)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_comment#685939)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_A))), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_A))), MAIN) 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#685804,at_stapat#685805,at_prefix#685806,at_nompat#685807,at_pnopat#685808,at_njfpat#685809,at_datnai#685810,at_datnaiss#685811,at_sexe#685812,at_numper#685813,at_sigma#685814,at_verrou#685815,at_poids#685816,at_indcen#685817,at_numss#685818,at_antece#685819,at_adr_1#685820,at_adr_2#685821,at_codpos#685822,at_ville#685823,at_pays#685824,at_numcai#685825,at_nummut#685826,at_numcha#685827,... 112 more fields] PushedFilters: [], ReadSchema: struct<at_numdos:string,at_stapat:string,at_prefix:string,at_nompat:string,at_pnopat:string,at_nj...

Project

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos#687031)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos#687031)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stapat#687032)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_stapat#687032)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefix#687033)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_prefix#687033)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nompat#687034)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nompat#687034)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnopat#687035)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pnopat#687035)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfpat#687036)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_njfpat#687036)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnai#687037)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datnai#687037)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnaiss#687038)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datnaiss#687038)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sexe#687039)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_sexe#687039)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper#687040)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper#687040)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sigma#687041)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_sigma#687041)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_verrou#687042)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_verrou#687042)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids#687043)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_poids#687043)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indcen#687044)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_indcen#687044)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numss#687045)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numss#687045)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_antece#687046)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_antece#687046)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1#687047)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1#687047)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2#687048)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2#687048)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpos#687049)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codpos#687049)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ville#687050)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ville#687050)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays#687051)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pays#687051)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai#687052)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai#687052)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nummut#687053)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nummut#687053)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcha#687054)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numcha#687054)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpri#687055)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_telpri#687055)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telbur#687056)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_telbur#687056)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpor#687057)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_telpor#687057)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fax#687058)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fax#687058)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefi2#687059)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_prefi2#687059)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomass#687060)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nomass#687060)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnoass#687061)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pnoass#687061)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfass#687062)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_njfass#687062)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datass#687063)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datass#687063)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1a#687064)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1a#687064)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2a#687065)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2a#687065)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpoa#687066)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codpoa#687066)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villea#687067)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_villea#687067)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmed#687068)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codmed#687068)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datcss#687069)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datcss#687069)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_d#687070)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_d#687070)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat100#687071)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dat100#687071)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numsir#687072)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numsir#687072)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numssa#687073)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numssa#687073)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codser#687074)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codser#687074)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_rngnai#687075)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_rngnai#687075)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_natass#687076)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_natass#687076)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numacc#687077)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numacc#687077)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datacc#687078)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datacc#687078)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typexo#687079)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_typexo#687079)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datmaj#687080)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datmaj#687080)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_coduti#687081)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_coduti#687081)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flcmu#687082)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flcmu#687082)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_qualss#687083)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_qualss#687083)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codref#687084)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codref#687084)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codregat#687085)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codregat#687085)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codcaiat#687086)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codcaiat#687086)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indvital#687087)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_indvital#687087)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_conmut#687088)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_conmut#687088)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adhmut#687089)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adhmut#687089)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_garmut#687090)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_garmut#687090)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori#687091)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori#687091)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codrout#687092)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codrout#687092)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_domaine#687093)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_domaine#687093)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indtrai#687094)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_indtrai#687094)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_idhote#687095)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_idhote#687095)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsts#687096)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codsts#687096)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nirind#687097)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nirind#687097)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldcd#687098)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fldcd#687098)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flphoto#687099)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flphoto#687099)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmtr#687100)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codmtr#687100)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3#687101)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3#687101)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays_iso#687102)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pays_iso#687102)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3a#687103)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3a#687103)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids_maj#687104)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_poids_maj#687104)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codgestion#687105)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codgestion#687105)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_art115#687106)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_art115#687106)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille#687107)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_taille#687107)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille_maj#687108)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_taille_maj#687108)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codetab_prod#687109)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codetab_prod#687109)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsit_prod#687110)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codsit_prod#687110)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_prod#687111)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_prod#687111)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_prod#687112)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_prod#687112)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_prod#687113)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_prod#687113)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins#687114)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins#687114)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_type#687115)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_type#687115)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_date#687116)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_date#687116)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_source#687117)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_source#687117)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stadmp#687118)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_stadmp#687118)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdmp#687119)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datdmp#687119)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_alarmes#687120)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_alarmes#687120)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_email#687121)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_email#687121)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_consent_sms#687122)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_consent_sms#687122)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_consent_sms#687123)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_consent_sms#687123)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdcd#687124)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datdcd#687124)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flhlim#687125)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flhlim#687125)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dathlim#687126)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dathlim#687126)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpershlim#687127)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codpershlim#687127)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldiff#687128)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fldiff#687128)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_lisdest#687129)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_lisdest#687129)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_langue#687130)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_langue#687130)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai_ft#687131)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai_ft#687131)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codtarifamc#687132)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codtarifamc#687132)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flgrve#687133)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flgrve#687133)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fladri#687134)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fladri#687134)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datadri#687135)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datadri#687135)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_mut#687136)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_mut#687136)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comfac#687137)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_comfac#687137)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_cloud#687138)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_cloud#687138)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nation#687139)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nation#687139)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre#687140)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_titre#687140)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre_ass#687141)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_titre_ass#687141)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_histoxml#687142)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_histoxml#687142)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_pnoliste#687143)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_pnoliste#687143)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codposnai#687144)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codposnai#687144)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi#687145)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_insi#687145)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi_oid#687146)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_insi_oid#687146)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typconv#687147)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_typconv#687147)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_crisec#687148)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_crisec#687148)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_opereg#687149)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_opereg#687149)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flannuamc#687150)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flannuamc#687150)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_staipp#687151)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_staipp#687151)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnonai#687152)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pnonai#687152)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codinseenai#687153)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codinseenai#687153)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villenai#687154)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_villenai#687154)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_piece_ident_pres#687155)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_piece_ident_pres#687155)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_staipp#687156)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_staipp#687156)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datapcv#687157)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datapcv#687157)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_num_apcv#687158)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_num_apcv#687158)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_heuapcv#687159)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_heuapcv#687159)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_sec#687160)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_sec#687160)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_heure#687161)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_heure#687161)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_persaprev#687162)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_persaprev#687162)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tarif#687163)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_tarif#687163)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomhl7#687164)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nomhl7#687164)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_oid#687165)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_oid#687165)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comment#687166)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_comment#687166)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_B))), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_B))), MAIN) 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#687031,at_stapat#687032,at_prefix#687033,at_nompat#687034,at_pnopat#687035,at_njfpat#687036,at_datnai#687037,at_datnaiss#687038,at_sexe#687039,at_numper#687040,at_sigma#687041,at_verrou#687042,at_poids#687043,at_indcen#687044,at_numss#687045,at_antece#687046,at_adr_1#687047,at_adr_2#687048,at_codpos#687049,at_ville#687050,at_pays#687051,at_numcai#687052,at_nummut#687053,at_numcha#687054,... 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 ==
AdaptiveSparkPlan (15)
+- == Final Plan ==
   * HashAggregate (11)
   +- ShuffleQueryStage (10), Statistics(sizeInBytes=32.0 B, rowCount=2)
      +- Exchange (9)
         +- * HashAggregate (8)
            +- Union (7)
               :- 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)
               +- Project (6)
                  +- Filter (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]  (4)
+- == Initial Plan ==
   HashAggregate (14)
   +- Exchange (13)
      +- HashAggregate (12)
         +- Union (7)
            :- 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)
            +- Project (6)
               +- Filter (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]  (4)


(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#685804, at_stapat#685805, at_prefix#685806, at_nompat#685807, at_pnopat#685808, at_njfpat#685809, at_datnai#685810, at_datnaiss#685811, at_sexe#685812, at_numper#685813, at_sigma#685814, at_verrou#685815, at_poids#685816, at_indcen#685817, at_numss#685818, at_antece#685819, at_adr_1#685820, at_adr_2#685821, at_codpos#685822, at_ville#685823, at_pays#685824, at_numcai#685825, at_nummut#685826, at_numcha#685827, at_telpri#685828, at_telbur#685829, at_telpor#685830, at_fax#685831, at_prefi2#685832, at_nomass#685833, at_pnoass#685834, at_njfass#685835, at_datass#685836, at_adr_1a#685837, at_adr_2a#685838, at_codpoa#685839, at_villea#685840, at_codmed#685841, at_datcss#685842, at_datf_d#685843, at_dat100#685844, at_numsir#685845, at_numssa#685846, at_codser#685847, at_rngnai#685848, at_natass#685849, at_numacc#685850, at_datacc#685851, at_typexo#685852, at_datmaj#685853, at_coduti#685854, at_flcmu#685855, at_qualss#685856, at_codref#685857, at_codregat#685858, at_codcaiat#685859, at_indvital#685860, at_conmut#685861, at_adhmut#685862, at_garmut#685863, at_numper_ori#685864, at_codrout#685865, at_domaine#685866, at_indtrai#685867, at_idhote#685868, at_codsts#685869, at_nirind#685870, at_fldcd#685871, at_flphoto#685872, at_codmtr#685873, at_adr_3#685874, at_pays_iso#685875, at_adr_3a#685876, at_poids_maj#685877, at_codgestion#685878, at_art115#685879, at_taille#685880, at_taille_maj#685881, at_codetab_prod#685882, at_codsit_prod#685883, at_numdos_prod#685884, at_numper_prod#685885, at_numper_ori_prod#685886, at_ins#685887, at_ins_type#685888, at_ins_date#685889, at_ins_source#685890, at_stadmp#685891, at_datdmp#685892, at_alarmes#685893, at_email#685894, at_consent_sms#685895, at_dat_consent_sms#685896, at_datdcd#685897, at_flhlim#685898, at_dathlim#685899, at_codpershlim#685900, at_fldiff#685901, at_lisdest#685902, at_langue#685903, at_numcai_ft#685904, at_codtarifamc#685905, at_flgrve#685906, at_fladri#685907, at_datadri#685908, at_datf_mut#685909, at_comfac#685910, at_numdos_cloud#685911, at_nation#685912, at_titre#685913, at_titre_ass#685914, at_tiq_histoxml#685915, at_tiq_pnoliste#685916, at_codposnai#685917, at_insi#685918, at_insi_oid#685919, at_typconv#685920, at_crisec#685921, at_opereg#685922, at_flannuamc#685923, at_staipp#685924, at_pnonai#685925, at_codinseenai#685926, at_villenai#685927, at_piece_ident_pres#685928, at_dat_staipp#685929, at_datapcv#685930, at_num_apcv#685931, at_heuapcv#685932, at_numper_sec#685933, at_ins_heure#685934, at_persaprev#685935, at_tarif#685936, at_nomhl7#685937, at_numper_ori_oid#685938, at_comment#685939]
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#685804, at_stapat#685805, at_prefix#685806, at_nompat#685807, at_pnopat#685808, at_njfpat#685809, at_datnai#685810, at_datnaiss#685811, at_sexe#685812, at_numper#685813, at_sigma#685814, at_verrou#685815, at_poids#685816, at_indcen#685817, at_numss#685818, at_antece#685819, at_adr_1#685820, at_adr_2#685821, at_codpos#685822, at_ville#685823, at_pays#685824, at_numcai#685825, at_nummut#685826, at_numcha#685827, at_telpri#685828, at_telbur#685829, at_telpor#685830, at_fax#685831, at_prefi2#685832, at_nomass#685833, at_pnoass#685834, at_njfass#685835, at_datass#685836, at_adr_1a#685837, at_adr_2a#685838, at_codpoa#685839, at_villea#685840, at_codmed#685841, at_datcss#685842, at_datf_d#685843, at_dat100#685844, at_numsir#685845, at_numssa#685846, at_codser#685847, at_rngnai#685848, at_natass#685849, at_numacc#685850, at_datacc#685851, at_typexo#685852, at_datmaj#685853, at_coduti#685854, at_flcmu#685855, at_qualss#685856, at_codref#685857, at_codregat#685858, at_codcaiat#685859, at_indvital#685860, at_conmut#685861, at_adhmut#685862, at_garmut#685863, at_numper_ori#685864, at_codrout#685865, at_domaine#685866, at_indtrai#685867, at_idhote#685868, at_codsts#685869, at_nirind#685870, at_fldcd#685871, at_flphoto#685872, at_codmtr#685873, at_adr_3#685874, at_pays_iso#685875, at_adr_3a#685876, at_poids_maj#685877, at_codgestion#685878, at_art115#685879, at_taille#685880, at_taille_maj#685881, at_codetab_prod#685882, at_codsit_prod#685883, at_numdos_prod#685884, at_numper_prod#685885, at_numper_ori_prod#685886, at_ins#685887, at_ins_type#685888, at_ins_date#685889, at_ins_source#685890, at_stadmp#685891, at_datdmp#685892, at_alarmes#685893, at_email#685894, at_consent_sms#685895, at_dat_consent_sms#685896, at_datdcd#685897, at_flhlim#685898, at_dathlim#685899, at_codpershlim#685900, at_fldiff#685901, at_lisdest#685902, at_langue#685903, at_numcai_ft#685904, at_codtarifamc#685905, at_flgrve#685906, at_fladri#685907, at_datadri#685908, at_datf_mut#685909, at_comfac#685910, at_numdos_cloud#685911, at_nation#685912, at_titre#685913, at_titre_ass#685914, at_tiq_histoxml#685915, at_tiq_pnoliste#685916, at_codposnai#685917, at_insi#685918, at_insi_oid#685919, at_typconv#685920, at_crisec#685921, at_opereg#685922, at_flannuamc#685923, at_staipp#685924, at_pnonai#685925, at_codinseenai#685926, at_villenai#685927, at_piece_ident_pres#685928, at_dat_staipp#685929, at_datapcv#685930, at_num_apcv#685931, at_heuapcv#685932, at_numper_sec#685933, at_ins_heure#685934, at_persaprev#685935, at_tarif#685936, at_nomhl7#685937, at_numper_ori_oid#685938, at_comment#685939]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos#685804)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos#685804)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stapat#685805)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_stapat#685805)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefix#685806)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_prefix#685806)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nompat#685807)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nompat#685807)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnopat#685808)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pnopat#685808)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfpat#685809)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_njfpat#685809)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnai#685810)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datnai#685810)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnaiss#685811)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datnaiss#685811)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sexe#685812)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_sexe#685812)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper#685813)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper#685813)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sigma#685814)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_sigma#685814)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_verrou#685815)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_verrou#685815)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids#685816)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_poids#685816)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indcen#685817)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_indcen#685817)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numss#685818)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numss#685818)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_antece#685819)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_antece#685819)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1#685820)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1#685820)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2#685821)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2#685821)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpos#685822)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codpos#685822)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ville#685823)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ville#685823)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays#685824)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pays#685824)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai#685825)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai#685825)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nummut#685826)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nummut#685826)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcha#685827)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numcha#685827)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpri#685828)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_telpri#685828)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telbur#685829)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_telbur#685829)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpor#685830)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_telpor#685830)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fax#685831)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fax#685831)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefi2#685832)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_prefi2#685832)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomass#685833)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nomass#685833)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnoass#685834)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pnoass#685834)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfass#685835)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_njfass#685835)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datass#685836)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datass#685836)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1a#685837)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1a#685837)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2a#685838)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2a#685838)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpoa#685839)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codpoa#685839)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villea#685840)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_villea#685840)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmed#685841)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codmed#685841)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datcss#685842)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datcss#685842)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_d#685843)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_d#685843)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat100#685844)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dat100#685844)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numsir#685845)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numsir#685845)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numssa#685846)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numssa#685846)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codser#685847)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codser#685847)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_rngnai#685848)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_rngnai#685848)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_natass#685849)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_natass#685849)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numacc#685850)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numacc#685850)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datacc#685851)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datacc#685851)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typexo#685852)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_typexo#685852)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datmaj#685853)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datmaj#685853)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_coduti#685854)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_coduti#685854)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flcmu#685855)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flcmu#685855)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_qualss#685856)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_qualss#685856)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codref#685857)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codref#685857)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codregat#685858)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codregat#685858)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codcaiat#685859)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codcaiat#685859)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indvital#685860)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_indvital#685860)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_conmut#685861)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_conmut#685861)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adhmut#685862)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adhmut#685862)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_garmut#685863)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_garmut#685863)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori#685864)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori#685864)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codrout#685865)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codrout#685865)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_domaine#685866)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_domaine#685866)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indtrai#685867)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_indtrai#685867)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_idhote#685868)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_idhote#685868)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsts#685869)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codsts#685869)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nirind#685870)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nirind#685870)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldcd#685871)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fldcd#685871)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flphoto#685872)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flphoto#685872)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmtr#685873)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codmtr#685873)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3#685874)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3#685874)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays_iso#685875)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pays_iso#685875)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3a#685876)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3a#685876)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids_maj#685877)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_poids_maj#685877)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codgestion#685878)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codgestion#685878)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_art115#685879)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_art115#685879)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille#685880)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_taille#685880)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille_maj#685881)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_taille_maj#685881)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codetab_prod#685882)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codetab_prod#685882)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsit_prod#685883)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codsit_prod#685883)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_prod#685884)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_prod#685884)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_prod#685885)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_prod#685885)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_prod#685886)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_prod#685886)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins#685887)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins#685887)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_type#685888)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_type#685888)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_date#685889)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_date#685889)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_source#685890)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_source#685890)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stadmp#685891)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_stadmp#685891)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdmp#685892)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datdmp#685892)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_alarmes#685893)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_alarmes#685893)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_email#685894)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_email#685894)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_consent_sms#685895)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_consent_sms#685895)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_consent_sms#685896)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_consent_sms#685896)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdcd#685897)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datdcd#685897)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flhlim#685898)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flhlim#685898)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dathlim#685899)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dathlim#685899)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpershlim#685900)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codpershlim#685900)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldiff#685901)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fldiff#685901)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_lisdest#685902)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_lisdest#685902)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_langue#685903)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_langue#685903)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai_ft#685904)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai_ft#685904)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codtarifamc#685905)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codtarifamc#685905)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flgrve#685906)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flgrve#685906)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fladri#685907)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fladri#685907)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datadri#685908)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datadri#685908)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_mut#685909)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_mut#685909)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comfac#685910)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_comfac#685910)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_cloud#685911)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_cloud#685911)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nation#685912)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nation#685912)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre#685913)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_titre#685913)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre_ass#685914)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_titre_ass#685914)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_histoxml#685915)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_histoxml#685915)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_pnoliste#685916)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_pnoliste#685916)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codposnai#685917)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codposnai#685917)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi#685918)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_insi#685918)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi_oid#685919)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_insi_oid#685919)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typconv#685920)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_typconv#685920)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_crisec#685921)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_crisec#685921)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_opereg#685922)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_opereg#685922)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flannuamc#685923)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flannuamc#685923)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_staipp#685924)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_staipp#685924)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnonai#685925)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pnonai#685925)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codinseenai#685926)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codinseenai#685926)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villenai#685927)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_villenai#685927)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_piece_ident_pres#685928)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_piece_ident_pres#685928)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_staipp#685929)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_staipp#685929)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datapcv#685930)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datapcv#685930)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_num_apcv#685931)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_num_apcv#685931)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_heuapcv#685932)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_heuapcv#685932)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_sec#685933)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_sec#685933)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_heure#685934)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_heure#685934)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_persaprev#685935)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_persaprev#685935)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tarif#685936)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_tarif#685936)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomhl7#685937)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nomhl7#685937)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_oid#685938)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_oid#685938)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comment#685939)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_comment#685939)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_A))), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_A))), MAIN) END)

(3) Project
Output: []
Input [136]: [at_numdos#685804, at_stapat#685805, at_prefix#685806, at_nompat#685807, at_pnopat#685808, at_njfpat#685809, at_datnai#685810, at_datnaiss#685811, at_sexe#685812, at_numper#685813, at_sigma#685814, at_verrou#685815, at_poids#685816, at_indcen#685817, at_numss#685818, at_antece#685819, at_adr_1#685820, at_adr_2#685821, at_codpos#685822, at_ville#685823, at_pays#685824, at_numcai#685825, at_nummut#685826, at_numcha#685827, at_telpri#685828, at_telbur#685829, at_telpor#685830, at_fax#685831, at_prefi2#685832, at_nomass#685833, at_pnoass#685834, at_njfass#685835, at_datass#685836, at_adr_1a#685837, at_adr_2a#685838, at_codpoa#685839, at_villea#685840, at_codmed#685841, at_datcss#685842, at_datf_d#685843, at_dat100#685844, at_numsir#685845, at_numssa#685846, at_codser#685847, at_rngnai#685848, at_natass#685849, at_numacc#685850, at_datacc#685851, at_typexo#685852, at_datmaj#685853, at_coduti#685854, at_flcmu#685855, at_qualss#685856, at_codref#685857, at_codregat#685858, at_codcaiat#685859, at_indvital#685860, at_conmut#685861, at_adhmut#685862, at_garmut#685863, at_numper_ori#685864, at_codrout#685865, at_domaine#685866, at_indtrai#685867, at_idhote#685868, at_codsts#685869, at_nirind#685870, at_fldcd#685871, at_flphoto#685872, at_codmtr#685873, at_adr_3#685874, at_pays_iso#685875, at_adr_3a#685876, at_poids_maj#685877, at_codgestion#685878, at_art115#685879, at_taille#685880, at_taille_maj#685881, at_codetab_prod#685882, at_codsit_prod#685883, at_numdos_prod#685884, at_numper_prod#685885, at_numper_ori_prod#685886, at_ins#685887, at_ins_type#685888, at_ins_date#685889, at_ins_source#685890, at_stadmp#685891, at_datdmp#685892, at_alarmes#685893, at_email#685894, at_consent_sms#685895, at_dat_consent_sms#685896, at_datdcd#685897, at_flhlim#685898, at_dathlim#685899, at_codpershlim#685900, at_fldiff#685901, at_lisdest#685902, at_langue#685903, at_numcai_ft#685904, at_codtarifamc#685905, at_flgrve#685906, at_fladri#685907, at_datadri#685908, at_datf_mut#685909, at_comfac#685910, at_numdos_cloud#685911, at_nation#685912, at_titre#685913, at_titre_ass#685914, at_tiq_histoxml#685915, at_tiq_pnoliste#685916, at_codposnai#685917, at_insi#685918, at_insi_oid#685919, at_typconv#685920, at_crisec#685921, at_opereg#685922, at_flannuamc#685923, at_staipp#685924, at_pnonai#685925, at_codinseenai#685926, at_villenai#685927, at_piece_ident_pres#685928, at_dat_staipp#685929, at_datapcv#685930, at_num_apcv#685931, at_heuapcv#685932, at_numper_sec#685933, at_ins_heure#685934, at_persaprev#685935, at_tarif#685936, at_nomhl7#685937, at_numper_ori_oid#685938, at_comment#685939]

(4) 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#687031, at_stapat#687032, at_prefix#687033, at_nompat#687034, at_pnopat#687035, at_njfpat#687036, at_datnai#687037, at_datnaiss#687038, at_sexe#687039, at_numper#687040, at_sigma#687041, at_verrou#687042, at_poids#687043, at_indcen#687044, at_numss#687045, at_antece#687046, at_adr_1#687047, at_adr_2#687048, at_codpos#687049, at_ville#687050, at_pays#687051, at_numcai#687052, at_nummut#687053, at_numcha#687054, at_telpri#687055, at_telbur#687056, at_telpor#687057, at_fax#687058, at_prefi2#687059, at_nomass#687060, at_pnoass#687061, at_njfass#687062, at_datass#687063, at_adr_1a#687064, at_adr_2a#687065, at_codpoa#687066, at_villea#687067, at_codmed#687068, at_datcss#687069, at_datf_d#687070, at_dat100#687071, at_numsir#687072, at_numssa#687073, at_codser#687074, at_rngnai#687075, at_natass#687076, at_numacc#687077, at_datacc#687078, at_typexo#687079, at_datmaj#687080, at_coduti#687081, at_flcmu#687082, at_qualss#687083, at_codref#687084, at_codregat#687085, at_codcaiat#687086, at_indvital#687087, at_conmut#687088, at_adhmut#687089, at_garmut#687090, at_numper_ori#687091, at_codrout#687092, at_domaine#687093, at_indtrai#687094, at_idhote#687095, at_codsts#687096, at_nirind#687097, at_fldcd#687098, at_flphoto#687099, at_codmtr#687100, at_adr_3#687101, at_pays_iso#687102, at_adr_3a#687103, at_poids_maj#687104, at_codgestion#687105, at_art115#687106, at_taille#687107, at_taille_maj#687108, at_codetab_prod#687109, at_codsit_prod#687110, at_numdos_prod#687111, at_numper_prod#687112, at_numper_ori_prod#687113, at_ins#687114, at_ins_type#687115, at_ins_date#687116, at_ins_source#687117, at_stadmp#687118, at_datdmp#687119, at_alarmes#687120, at_email#687121, at_consent_sms#687122, at_dat_consent_sms#687123, at_datdcd#687124, at_flhlim#687125, at_dathlim#687126, at_codpershlim#687127, at_fldiff#687128, at_lisdest#687129, at_langue#687130, at_numcai_ft#687131, at_codtarifamc#687132, at_flgrve#687133, at_fladri#687134, at_datadri#687135, at_datf_mut#687136, at_comfac#687137, at_numdos_cloud#687138, at_nation#687139, at_titre#687140, at_titre_ass#687141, at_tiq_histoxml#687142, at_tiq_pnoliste#687143, at_codposnai#687144, at_insi#687145, at_insi_oid#687146, at_typconv#687147, at_crisec#687148, at_opereg#687149, at_flannuamc#687150, at_staipp#687151, at_pnonai#687152, at_codinseenai#687153, at_villenai#687154, at_piece_ident_pres#687155, at_dat_staipp#687156, at_datapcv#687157, at_num_apcv#687158, at_heuapcv#687159, at_numper_sec#687160, at_ins_heure#687161, at_persaprev#687162, at_tarif#687163, at_nomhl7#687164, at_numper_ori_oid#687165, at_comment#687166]
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>

(5) Filter
Input [136]: [at_numdos#687031, at_stapat#687032, at_prefix#687033, at_nompat#687034, at_pnopat#687035, at_njfpat#687036, at_datnai#687037, at_datnaiss#687038, at_sexe#687039, at_numper#687040, at_sigma#687041, at_verrou#687042, at_poids#687043, at_indcen#687044, at_numss#687045, at_antece#687046, at_adr_1#687047, at_adr_2#687048, at_codpos#687049, at_ville#687050, at_pays#687051, at_numcai#687052, at_nummut#687053, at_numcha#687054, at_telpri#687055, at_telbur#687056, at_telpor#687057, at_fax#687058, at_prefi2#687059, at_nomass#687060, at_pnoass#687061, at_njfass#687062, at_datass#687063, at_adr_1a#687064, at_adr_2a#687065, at_codpoa#687066, at_villea#687067, at_codmed#687068, at_datcss#687069, at_datf_d#687070, at_dat100#687071, at_numsir#687072, at_numssa#687073, at_codser#687074, at_rngnai#687075, at_natass#687076, at_numacc#687077, at_datacc#687078, at_typexo#687079, at_datmaj#687080, at_coduti#687081, at_flcmu#687082, at_qualss#687083, at_codref#687084, at_codregat#687085, at_codcaiat#687086, at_indvital#687087, at_conmut#687088, at_adhmut#687089, at_garmut#687090, at_numper_ori#687091, at_codrout#687092, at_domaine#687093, at_indtrai#687094, at_idhote#687095, at_codsts#687096, at_nirind#687097, at_fldcd#687098, at_flphoto#687099, at_codmtr#687100, at_adr_3#687101, at_pays_iso#687102, at_adr_3a#687103, at_poids_maj#687104, at_codgestion#687105, at_art115#687106, at_taille#687107, at_taille_maj#687108, at_codetab_prod#687109, at_codsit_prod#687110, at_numdos_prod#687111, at_numper_prod#687112, at_numper_ori_prod#687113, at_ins#687114, at_ins_type#687115, at_ins_date#687116, at_ins_source#687117, at_stadmp#687118, at_datdmp#687119, at_alarmes#687120, at_email#687121, at_consent_sms#687122, at_dat_consent_sms#687123, at_datdcd#687124, at_flhlim#687125, at_dathlim#687126, at_codpershlim#687127, at_fldiff#687128, at_lisdest#687129, at_langue#687130, at_numcai_ft#687131, at_codtarifamc#687132, at_flgrve#687133, at_fladri#687134, at_datadri#687135, at_datf_mut#687136, at_comfac#687137, at_numdos_cloud#687138, at_nation#687139, at_titre#687140, at_titre_ass#687141, at_tiq_histoxml#687142, at_tiq_pnoliste#687143, at_codposnai#687144, at_insi#687145, at_insi_oid#687146, at_typconv#687147, at_crisec#687148, at_opereg#687149, at_flannuamc#687150, at_staipp#687151, at_pnonai#687152, at_codinseenai#687153, at_villenai#687154, at_piece_ident_pres#687155, at_dat_staipp#687156, at_datapcv#687157, at_num_apcv#687158, at_heuapcv#687159, at_numper_sec#687160, at_ins_heure#687161, at_persaprev#687162, at_tarif#687163, at_nomhl7#687164, at_numper_ori_oid#687165, at_comment#687166]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos#687031)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos#687031)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stapat#687032)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_stapat#687032)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefix#687033)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_prefix#687033)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nompat#687034)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nompat#687034)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnopat#687035)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pnopat#687035)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfpat#687036)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_njfpat#687036)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnai#687037)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datnai#687037)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnaiss#687038)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datnaiss#687038)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sexe#687039)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_sexe#687039)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper#687040)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper#687040)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sigma#687041)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_sigma#687041)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_verrou#687042)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_verrou#687042)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids#687043)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_poids#687043)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indcen#687044)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_indcen#687044)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numss#687045)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numss#687045)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_antece#687046)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_antece#687046)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1#687047)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1#687047)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2#687048)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2#687048)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpos#687049)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codpos#687049)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ville#687050)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ville#687050)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays#687051)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pays#687051)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai#687052)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai#687052)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nummut#687053)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nummut#687053)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcha#687054)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numcha#687054)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpri#687055)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_telpri#687055)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telbur#687056)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_telbur#687056)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpor#687057)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_telpor#687057)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fax#687058)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fax#687058)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefi2#687059)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_prefi2#687059)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomass#687060)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nomass#687060)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnoass#687061)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pnoass#687061)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfass#687062)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_njfass#687062)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datass#687063)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datass#687063)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1a#687064)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1a#687064)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2a#687065)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2a#687065)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpoa#687066)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codpoa#687066)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villea#687067)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_villea#687067)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmed#687068)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codmed#687068)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datcss#687069)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datcss#687069)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_d#687070)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_d#687070)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat100#687071)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dat100#687071)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numsir#687072)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numsir#687072)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numssa#687073)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numssa#687073)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codser#687074)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codser#687074)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_rngnai#687075)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_rngnai#687075)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_natass#687076)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_natass#687076)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numacc#687077)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numacc#687077)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datacc#687078)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datacc#687078)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typexo#687079)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_typexo#687079)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datmaj#687080)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datmaj#687080)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_coduti#687081)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_coduti#687081)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flcmu#687082)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flcmu#687082)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_qualss#687083)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_qualss#687083)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codref#687084)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codref#687084)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codregat#687085)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codregat#687085)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codcaiat#687086)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codcaiat#687086)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indvital#687087)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_indvital#687087)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_conmut#687088)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_conmut#687088)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adhmut#687089)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adhmut#687089)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_garmut#687090)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_garmut#687090)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori#687091)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori#687091)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codrout#687092)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codrout#687092)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_domaine#687093)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_domaine#687093)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indtrai#687094)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_indtrai#687094)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_idhote#687095)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_idhote#687095)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsts#687096)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codsts#687096)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nirind#687097)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nirind#687097)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldcd#687098)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fldcd#687098)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flphoto#687099)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flphoto#687099)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmtr#687100)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codmtr#687100)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3#687101)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3#687101)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays_iso#687102)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pays_iso#687102)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3a#687103)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3a#687103)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids_maj#687104)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_poids_maj#687104)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codgestion#687105)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codgestion#687105)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_art115#687106)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_art115#687106)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille#687107)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_taille#687107)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille_maj#687108)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_taille_maj#687108)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codetab_prod#687109)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codetab_prod#687109)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsit_prod#687110)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codsit_prod#687110)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_prod#687111)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_prod#687111)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_prod#687112)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_prod#687112)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_prod#687113)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_prod#687113)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins#687114)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins#687114)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_type#687115)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_type#687115)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_date#687116)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_date#687116)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_source#687117)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_source#687117)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stadmp#687118)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_stadmp#687118)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdmp#687119)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datdmp#687119)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_alarmes#687120)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_alarmes#687120)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_email#687121)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_email#687121)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_consent_sms#687122)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_consent_sms#687122)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_consent_sms#687123)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_consent_sms#687123)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdcd#687124)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datdcd#687124)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flhlim#687125)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flhlim#687125)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dathlim#687126)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dathlim#687126)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpershlim#687127)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codpershlim#687127)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldiff#687128)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fldiff#687128)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_lisdest#687129)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_lisdest#687129)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_langue#687130)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_langue#687130)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai_ft#687131)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai_ft#687131)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codtarifamc#687132)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codtarifamc#687132)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flgrve#687133)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flgrve#687133)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fladri#687134)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fladri#687134)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datadri#687135)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datadri#687135)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_mut#687136)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_mut#687136)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comfac#687137)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_comfac#687137)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_cloud#687138)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_cloud#687138)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nation#687139)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nation#687139)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre#687140)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_titre#687140)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre_ass#687141)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_titre_ass#687141)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_histoxml#687142)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_histoxml#687142)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_pnoliste#687143)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_pnoliste#687143)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codposnai#687144)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codposnai#687144)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi#687145)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_insi#687145)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi_oid#687146)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_insi_oid#687146)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typconv#687147)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_typconv#687147)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_crisec#687148)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_crisec#687148)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_opereg#687149)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_opereg#687149)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flannuamc#687150)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flannuamc#687150)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_staipp#687151)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_staipp#687151)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnonai#687152)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pnonai#687152)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codinseenai#687153)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codinseenai#687153)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villenai#687154)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_villenai#687154)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_piece_ident_pres#687155)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_piece_ident_pres#687155)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_staipp#687156)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_staipp#687156)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datapcv#687157)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datapcv#687157)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_num_apcv#687158)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_num_apcv#687158)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_heuapcv#687159)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_heuapcv#687159)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_sec#687160)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_sec#687160)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_heure#687161)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_heure#687161)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_persaprev#687162)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_persaprev#687162)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tarif#687163)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_tarif#687163)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomhl7#687164)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nomhl7#687164)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_oid#687165)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_oid#687165)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comment#687166)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_comment#687166)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_B))), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_B))), MAIN) END)

(6) Project
Output: []
Input [136]: [at_numdos#687031, at_stapat#687032, at_prefix#687033, at_nompat#687034, at_pnopat#687035, at_njfpat#687036, at_datnai#687037, at_datnaiss#687038, at_sexe#687039, at_numper#687040, at_sigma#687041, at_verrou#687042, at_poids#687043, at_indcen#687044, at_numss#687045, at_antece#687046, at_adr_1#687047, at_adr_2#687048, at_codpos#687049, at_ville#687050, at_pays#687051, at_numcai#687052, at_nummut#687053, at_numcha#687054, at_telpri#687055, at_telbur#687056, at_telpor#687057, at_fax#687058, at_prefi2#687059, at_nomass#687060, at_pnoass#687061, at_njfass#687062, at_datass#687063, at_adr_1a#687064, at_adr_2a#687065, at_codpoa#687066, at_villea#687067, at_codmed#687068, at_datcss#687069, at_datf_d#687070, at_dat100#687071, at_numsir#687072, at_numssa#687073, at_codser#687074, at_rngnai#687075, at_natass#687076, at_numacc#687077, at_datacc#687078, at_typexo#687079, at_datmaj#687080, at_coduti#687081, at_flcmu#687082, at_qualss#687083, at_codref#687084, at_codregat#687085, at_codcaiat#687086, at_indvital#687087, at_conmut#687088, at_adhmut#687089, at_garmut#687090, at_numper_ori#687091, at_codrout#687092, at_domaine#687093, at_indtrai#687094, at_idhote#687095, at_codsts#687096, at_nirind#687097, at_fldcd#687098, at_flphoto#687099, at_codmtr#687100, at_adr_3#687101, at_pays_iso#687102, at_adr_3a#687103, at_poids_maj#687104, at_codgestion#687105, at_art115#687106, at_taille#687107, at_taille_maj#687108, at_codetab_prod#687109, at_codsit_prod#687110, at_numdos_prod#687111, at_numper_prod#687112, at_numper_ori_prod#687113, at_ins#687114, at_ins_type#687115, at_ins_date#687116, at_ins_source#687117, at_stadmp#687118, at_datdmp#687119, at_alarmes#687120, at_email#687121, at_consent_sms#687122, at_dat_consent_sms#687123, at_datdcd#687124, at_flhlim#687125, at_dathlim#687126, at_codpershlim#687127, at_fldiff#687128, at_lisdest#687129, at_langue#687130, at_numcai_ft#687131, at_codtarifamc#687132, at_flgrve#687133, at_fladri#687134, at_datadri#687135, at_datf_mut#687136, at_comfac#687137, at_numdos_cloud#687138, at_nation#687139, at_titre#687140, at_titre_ass#687141, at_tiq_histoxml#687142, at_tiq_pnoliste#687143, at_codposnai#687144, at_insi#687145, at_insi_oid#687146, at_typconv#687147, at_crisec#687148, at_opereg#687149, at_flannuamc#687150, at_staipp#687151, at_pnonai#687152, at_codinseenai#687153, at_villenai#687154, at_piece_ident_pres#687155, at_dat_staipp#687156, at_datapcv#687157, at_num_apcv#687158, at_heuapcv#687159, at_numper_sec#687160, at_ins_heure#687161, at_persaprev#687162, at_tarif#687163, at_nomhl7#687164, at_numper_ori_oid#687165, at_comment#687166]

(7) Union

(8) HashAggregate [codegen id : 1]
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#689635L]
Results [1]: [count#689636L]

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

(10) ShuffleQueryStage
Output [1]: [count#689636L]
Arguments: 0

(11) HashAggregate [codegen id : 2]
Input [1]: [count#689636L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#689354L]
Results [1]: [count(1)#689354L AS COL_206db152-7e31-4631-8bb8-c567cb86ba26#689356L]

(12) HashAggregate
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#689635L]
Results [1]: [count#689636L]

(13) Exchange
Input [1]: [count#689636L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=37109]

(14) HashAggregate
Input [1]: [count#689636L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#689354L]
Results [1]: [count(1)#689354L AS COL_206db152-7e31-4631-8bb8-c567cb86ba26#689356L]

(15) AdaptiveSparkPlan
Output [1]: [COL_206db152-7e31-4631-8bb8-c567cb86ba26#689356L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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