hdh-spark-job - Details for Query 1323

Submitted Time: 2026/10/23 13:26:48
Duration: 9 s
Succeeded Jobs: 1324 1326

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 1909.0: task 1664)) 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 1909.0: task 1664)) 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 1909.0: task 1664))"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n2.3 s (1.1 s, 1.1 s, 1.1 s (stage 1909.0: task 1663))"; 5 [labelType="html" label="HashAggregate time in aggregation build total (min, med, max (stageId: taskId)) 2.3 s (1.1 s, 1.1 s, 1.1 s (stage 1909.0: task 1663)) number of output rows: 2"]; } 6 [labelType="html" label=" Union "]; 7 [labelType="html" label=" Project "]; 8 [labelType="html" label="Filter number of output rows: 8"]; 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: 8"]; 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=35349]

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

WholeStageCodegen (1)

Union

Project

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos#648860)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos#648860)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stapat#648861)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_stapat#648861)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefix#648862)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_prefix#648862)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nompat#648863)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nompat#648863)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnopat#648864)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pnopat#648864)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfpat#648865)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_njfpat#648865)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnai#648866)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datnai#648866)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnaiss#648867)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datnaiss#648867)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sexe#648868)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_sexe#648868)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper#648869)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper#648869)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sigma#648870)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_sigma#648870)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_verrou#648871)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_verrou#648871)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids#648872)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_poids#648872)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indcen#648873)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_indcen#648873)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numss#648874)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numss#648874)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_antece#648875)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_antece#648875)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1#648876)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1#648876)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2#648877)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2#648877)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpos#648878)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codpos#648878)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ville#648879)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ville#648879)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays#648880)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pays#648880)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai#648881)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai#648881)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nummut#648882)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nummut#648882)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcha#648883)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numcha#648883)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpri#648884)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_telpri#648884)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telbur#648885)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_telbur#648885)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpor#648886)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_telpor#648886)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fax#648887)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fax#648887)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefi2#648888)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_prefi2#648888)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomass#648889)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nomass#648889)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnoass#648890)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pnoass#648890)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfass#648891)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_njfass#648891)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datass#648892)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datass#648892)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1a#648893)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1a#648893)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2a#648894)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2a#648894)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpoa#648895)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codpoa#648895)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villea#648896)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_villea#648896)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmed#648897)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codmed#648897)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datcss#648898)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datcss#648898)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_d#648899)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_d#648899)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat100#648900)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dat100#648900)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numsir#648901)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numsir#648901)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numssa#648902)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numssa#648902)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codser#648903)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codser#648903)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_rngnai#648904)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_rngnai#648904)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_natass#648905)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_natass#648905)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numacc#648906)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numacc#648906)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datacc#648907)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datacc#648907)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typexo#648908)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_typexo#648908)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datmaj#648909)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datmaj#648909)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_coduti#648910)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_coduti#648910)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flcmu#648911)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flcmu#648911)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_qualss#648912)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_qualss#648912)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codref#648913)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codref#648913)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codregat#648914)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codregat#648914)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codcaiat#648915)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codcaiat#648915)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indvital#648916)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_indvital#648916)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_conmut#648917)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_conmut#648917)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adhmut#648918)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adhmut#648918)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_garmut#648919)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_garmut#648919)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori#648920)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori#648920)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codrout#648921)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codrout#648921)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_domaine#648922)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_domaine#648922)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indtrai#648923)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_indtrai#648923)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_idhote#648924)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_idhote#648924)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsts#648925)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codsts#648925)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nirind#648926)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nirind#648926)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldcd#648927)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fldcd#648927)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flphoto#648928)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flphoto#648928)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmtr#648929)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codmtr#648929)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3#648930)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3#648930)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays_iso#648931)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pays_iso#648931)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3a#648932)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3a#648932)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids_maj#648933)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_poids_maj#648933)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codgestion#648934)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codgestion#648934)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_art115#648935)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_art115#648935)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille#648936)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_taille#648936)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille_maj#648937)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_taille_maj#648937)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codetab_prod#648938)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codetab_prod#648938)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsit_prod#648939)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codsit_prod#648939)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_prod#648940)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_prod#648940)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_prod#648941)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_prod#648941)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_prod#648942)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_prod#648942)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins#648943)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins#648943)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_type#648944)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_type#648944)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_date#648945)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_date#648945)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_source#648946)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_source#648946)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stadmp#648947)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_stadmp#648947)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdmp#648948)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datdmp#648948)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_alarmes#648949)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_alarmes#648949)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_email#648950)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_email#648950)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_consent_sms#648951)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_consent_sms#648951)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_consent_sms#648952)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_consent_sms#648952)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdcd#648953)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datdcd#648953)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flhlim#648954)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flhlim#648954)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dathlim#648955)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dathlim#648955)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpershlim#648956)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codpershlim#648956)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldiff#648957)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fldiff#648957)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_lisdest#648958)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_lisdest#648958)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_langue#648959)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_langue#648959)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai_ft#648960)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai_ft#648960)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codtarifamc#648961)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codtarifamc#648961)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flgrve#648962)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flgrve#648962)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fladri#648963)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fladri#648963)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datadri#648964)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datadri#648964)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_mut#648965)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_mut#648965)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comfac#648966)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_comfac#648966)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_cloud#648967)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_cloud#648967)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nation#648968)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nation#648968)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre#648969)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_titre#648969)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre_ass#648970)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_titre_ass#648970)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_histoxml#648971)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_histoxml#648971)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_pnoliste#648972)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_pnoliste#648972)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codposnai#648973)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codposnai#648973)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi#648974)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_insi#648974)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi_oid#648975)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_insi_oid#648975)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typconv#648976)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_typconv#648976)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_crisec#648977)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_crisec#648977)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_opereg#648978)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_opereg#648978)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flannuamc#648979)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flannuamc#648979)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_staipp#648980)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_staipp#648980)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnonai#648981)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pnonai#648981)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codinseenai#648982)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codinseenai#648982)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villenai#648983)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_villenai#648983)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_piece_ident_pres#648984)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_piece_ident_pres#648984)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_staipp#648985)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_staipp#648985)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datapcv#648986)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datapcv#648986)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_num_apcv#648987)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_num_apcv#648987)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_heuapcv#648988)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_heuapcv#648988)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_sec#648989)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_sec#648989)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_heure#648990)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_heure#648990)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_persaprev#648991)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_persaprev#648991)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tarif#648992)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_tarif#648992)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomhl7#648993)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nomhl7#648993)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_oid#648994)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_oid#648994)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comment#648995)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_comment#648995)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_A))), MARX)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_A))), MARX) 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#648860,at_stapat#648861,at_prefix#648862,at_nompat#648863,at_pnopat#648864,at_njfpat#648865,at_datnai#648866,at_datnaiss#648867,at_sexe#648868,at_numper#648869,at_sigma#648870,at_verrou#648871,at_poids#648872,at_indcen#648873,at_numss#648874,at_antece#648875,at_adr_1#648876,at_adr_2#648877,at_codpos#648878,at_ville#648879,at_pays#648880,at_numcai#648881,at_nummut#648882,at_numcha#648883,... 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#651617)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos#651617)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stapat#651618)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_stapat#651618)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefix#651619)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_prefix#651619)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nompat#651620)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nompat#651620)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnopat#651621)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pnopat#651621)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfpat#651622)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_njfpat#651622)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnai#651623)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datnai#651623)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnaiss#651624)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datnaiss#651624)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sexe#651625)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_sexe#651625)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper#651626)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper#651626)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sigma#651627)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_sigma#651627)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_verrou#651628)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_verrou#651628)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids#651629)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_poids#651629)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indcen#651630)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_indcen#651630)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numss#651631)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numss#651631)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_antece#651632)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_antece#651632)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1#651633)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1#651633)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2#651634)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2#651634)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpos#651635)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codpos#651635)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ville#651636)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ville#651636)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays#651637)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pays#651637)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai#651638)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai#651638)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nummut#651639)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nummut#651639)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcha#651640)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numcha#651640)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpri#651641)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_telpri#651641)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telbur#651642)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_telbur#651642)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpor#651643)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_telpor#651643)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fax#651644)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fax#651644)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefi2#651645)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_prefi2#651645)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomass#651646)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nomass#651646)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnoass#651647)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pnoass#651647)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfass#651648)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_njfass#651648)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datass#651649)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datass#651649)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1a#651650)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1a#651650)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2a#651651)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2a#651651)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpoa#651652)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codpoa#651652)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villea#651653)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_villea#651653)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmed#651654)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codmed#651654)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datcss#651655)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datcss#651655)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_d#651656)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_d#651656)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat100#651657)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dat100#651657)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numsir#651658)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numsir#651658)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numssa#651659)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numssa#651659)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codser#651660)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codser#651660)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_rngnai#651661)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_rngnai#651661)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_natass#651662)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_natass#651662)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numacc#651663)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numacc#651663)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datacc#651664)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datacc#651664)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typexo#651665)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_typexo#651665)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datmaj#651666)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datmaj#651666)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_coduti#651667)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_coduti#651667)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flcmu#651668)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flcmu#651668)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_qualss#651669)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_qualss#651669)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codref#651670)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codref#651670)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codregat#651671)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codregat#651671)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codcaiat#651672)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codcaiat#651672)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indvital#651673)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_indvital#651673)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_conmut#651674)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_conmut#651674)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adhmut#651675)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adhmut#651675)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_garmut#651676)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_garmut#651676)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori#651677)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori#651677)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codrout#651678)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codrout#651678)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_domaine#651679)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_domaine#651679)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indtrai#651680)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_indtrai#651680)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_idhote#651681)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_idhote#651681)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsts#651682)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codsts#651682)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nirind#651683)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nirind#651683)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldcd#651684)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fldcd#651684)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flphoto#651685)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flphoto#651685)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmtr#651686)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codmtr#651686)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3#651687)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3#651687)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays_iso#651688)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pays_iso#651688)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3a#651689)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3a#651689)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids_maj#651690)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_poids_maj#651690)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codgestion#651691)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codgestion#651691)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_art115#651692)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_art115#651692)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille#651693)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_taille#651693)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille_maj#651694)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_taille_maj#651694)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codetab_prod#651695)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codetab_prod#651695)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsit_prod#651696)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codsit_prod#651696)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_prod#651697)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_prod#651697)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_prod#651698)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_prod#651698)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_prod#651699)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_prod#651699)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins#651700)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins#651700)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_type#651701)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_type#651701)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_date#651702)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_date#651702)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_source#651703)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_source#651703)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stadmp#651704)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_stadmp#651704)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdmp#651705)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datdmp#651705)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_alarmes#651706)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_alarmes#651706)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_email#651707)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_email#651707)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_consent_sms#651708)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_consent_sms#651708)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_consent_sms#651709)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_consent_sms#651709)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdcd#651710)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datdcd#651710)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flhlim#651711)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flhlim#651711)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dathlim#651712)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dathlim#651712)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpershlim#651713)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codpershlim#651713)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldiff#651714)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fldiff#651714)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_lisdest#651715)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_lisdest#651715)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_langue#651716)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_langue#651716)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai_ft#651717)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai_ft#651717)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codtarifamc#651718)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codtarifamc#651718)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flgrve#651719)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flgrve#651719)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fladri#651720)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fladri#651720)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datadri#651721)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datadri#651721)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_mut#651722)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_mut#651722)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comfac#651723)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_comfac#651723)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_cloud#651724)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_cloud#651724)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nation#651725)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nation#651725)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre#651726)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_titre#651726)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre_ass#651727)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_titre_ass#651727)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_histoxml#651728)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_histoxml#651728)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_pnoliste#651729)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_pnoliste#651729)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codposnai#651730)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codposnai#651730)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi#651731)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_insi#651731)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi_oid#651732)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_insi_oid#651732)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typconv#651733)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_typconv#651733)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_crisec#651734)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_crisec#651734)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_opereg#651735)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_opereg#651735)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flannuamc#651736)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flannuamc#651736)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_staipp#651737)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_staipp#651737)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnonai#651738)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pnonai#651738)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codinseenai#651739)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codinseenai#651739)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villenai#651740)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_villenai#651740)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_piece_ident_pres#651741)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_piece_ident_pres#651741)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_staipp#651742)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_staipp#651742)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datapcv#651743)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datapcv#651743)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_num_apcv#651744)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_num_apcv#651744)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_heuapcv#651745)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_heuapcv#651745)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_sec#651746)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_sec#651746)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_heure#651747)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_heure#651747)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_persaprev#651748)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_persaprev#651748)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tarif#651749)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_tarif#651749)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomhl7#651750)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nomhl7#651750)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_oid#651751)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_oid#651751)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comment#651752)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_comment#651752)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_B))), MARX)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_B))), MARX) 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#651617,at_stapat#651618,at_prefix#651619,at_nompat#651620,at_pnopat#651621,at_njfpat#651622,at_datnai#651623,at_datnaiss#651624,at_sexe#651625,at_numper#651626,at_sigma#651627,at_verrou#651628,at_poids#651629,at_indcen#651630,at_numss#651631,at_antece#651632,at_adr_1#651633,at_adr_2#651634,at_codpos#651635,at_ville#651636,at_pays#651637,at_numcai#651638,at_nummut#651639,at_numcha#651640,... 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#648860, at_stapat#648861, at_prefix#648862, at_nompat#648863, at_pnopat#648864, at_njfpat#648865, at_datnai#648866, at_datnaiss#648867, at_sexe#648868, at_numper#648869, at_sigma#648870, at_verrou#648871, at_poids#648872, at_indcen#648873, at_numss#648874, at_antece#648875, at_adr_1#648876, at_adr_2#648877, at_codpos#648878, at_ville#648879, at_pays#648880, at_numcai#648881, at_nummut#648882, at_numcha#648883, at_telpri#648884, at_telbur#648885, at_telpor#648886, at_fax#648887, at_prefi2#648888, at_nomass#648889, at_pnoass#648890, at_njfass#648891, at_datass#648892, at_adr_1a#648893, at_adr_2a#648894, at_codpoa#648895, at_villea#648896, at_codmed#648897, at_datcss#648898, at_datf_d#648899, at_dat100#648900, at_numsir#648901, at_numssa#648902, at_codser#648903, at_rngnai#648904, at_natass#648905, at_numacc#648906, at_datacc#648907, at_typexo#648908, at_datmaj#648909, at_coduti#648910, at_flcmu#648911, at_qualss#648912, at_codref#648913, at_codregat#648914, at_codcaiat#648915, at_indvital#648916, at_conmut#648917, at_adhmut#648918, at_garmut#648919, at_numper_ori#648920, at_codrout#648921, at_domaine#648922, at_indtrai#648923, at_idhote#648924, at_codsts#648925, at_nirind#648926, at_fldcd#648927, at_flphoto#648928, at_codmtr#648929, at_adr_3#648930, at_pays_iso#648931, at_adr_3a#648932, at_poids_maj#648933, at_codgestion#648934, at_art115#648935, at_taille#648936, at_taille_maj#648937, at_codetab_prod#648938, at_codsit_prod#648939, at_numdos_prod#648940, at_numper_prod#648941, at_numper_ori_prod#648942, at_ins#648943, at_ins_type#648944, at_ins_date#648945, at_ins_source#648946, at_stadmp#648947, at_datdmp#648948, at_alarmes#648949, at_email#648950, at_consent_sms#648951, at_dat_consent_sms#648952, at_datdcd#648953, at_flhlim#648954, at_dathlim#648955, at_codpershlim#648956, at_fldiff#648957, at_lisdest#648958, at_langue#648959, at_numcai_ft#648960, at_codtarifamc#648961, at_flgrve#648962, at_fladri#648963, at_datadri#648964, at_datf_mut#648965, at_comfac#648966, at_numdos_cloud#648967, at_nation#648968, at_titre#648969, at_titre_ass#648970, at_tiq_histoxml#648971, at_tiq_pnoliste#648972, at_codposnai#648973, at_insi#648974, at_insi_oid#648975, at_typconv#648976, at_crisec#648977, at_opereg#648978, at_flannuamc#648979, at_staipp#648980, at_pnonai#648981, at_codinseenai#648982, at_villenai#648983, at_piece_ident_pres#648984, at_dat_staipp#648985, at_datapcv#648986, at_num_apcv#648987, at_heuapcv#648988, at_numper_sec#648989, at_ins_heure#648990, at_persaprev#648991, at_tarif#648992, at_nomhl7#648993, at_numper_ori_oid#648994, at_comment#648995]
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#648860, at_stapat#648861, at_prefix#648862, at_nompat#648863, at_pnopat#648864, at_njfpat#648865, at_datnai#648866, at_datnaiss#648867, at_sexe#648868, at_numper#648869, at_sigma#648870, at_verrou#648871, at_poids#648872, at_indcen#648873, at_numss#648874, at_antece#648875, at_adr_1#648876, at_adr_2#648877, at_codpos#648878, at_ville#648879, at_pays#648880, at_numcai#648881, at_nummut#648882, at_numcha#648883, at_telpri#648884, at_telbur#648885, at_telpor#648886, at_fax#648887, at_prefi2#648888, at_nomass#648889, at_pnoass#648890, at_njfass#648891, at_datass#648892, at_adr_1a#648893, at_adr_2a#648894, at_codpoa#648895, at_villea#648896, at_codmed#648897, at_datcss#648898, at_datf_d#648899, at_dat100#648900, at_numsir#648901, at_numssa#648902, at_codser#648903, at_rngnai#648904, at_natass#648905, at_numacc#648906, at_datacc#648907, at_typexo#648908, at_datmaj#648909, at_coduti#648910, at_flcmu#648911, at_qualss#648912, at_codref#648913, at_codregat#648914, at_codcaiat#648915, at_indvital#648916, at_conmut#648917, at_adhmut#648918, at_garmut#648919, at_numper_ori#648920, at_codrout#648921, at_domaine#648922, at_indtrai#648923, at_idhote#648924, at_codsts#648925, at_nirind#648926, at_fldcd#648927, at_flphoto#648928, at_codmtr#648929, at_adr_3#648930, at_pays_iso#648931, at_adr_3a#648932, at_poids_maj#648933, at_codgestion#648934, at_art115#648935, at_taille#648936, at_taille_maj#648937, at_codetab_prod#648938, at_codsit_prod#648939, at_numdos_prod#648940, at_numper_prod#648941, at_numper_ori_prod#648942, at_ins#648943, at_ins_type#648944, at_ins_date#648945, at_ins_source#648946, at_stadmp#648947, at_datdmp#648948, at_alarmes#648949, at_email#648950, at_consent_sms#648951, at_dat_consent_sms#648952, at_datdcd#648953, at_flhlim#648954, at_dathlim#648955, at_codpershlim#648956, at_fldiff#648957, at_lisdest#648958, at_langue#648959, at_numcai_ft#648960, at_codtarifamc#648961, at_flgrve#648962, at_fladri#648963, at_datadri#648964, at_datf_mut#648965, at_comfac#648966, at_numdos_cloud#648967, at_nation#648968, at_titre#648969, at_titre_ass#648970, at_tiq_histoxml#648971, at_tiq_pnoliste#648972, at_codposnai#648973, at_insi#648974, at_insi_oid#648975, at_typconv#648976, at_crisec#648977, at_opereg#648978, at_flannuamc#648979, at_staipp#648980, at_pnonai#648981, at_codinseenai#648982, at_villenai#648983, at_piece_ident_pres#648984, at_dat_staipp#648985, at_datapcv#648986, at_num_apcv#648987, at_heuapcv#648988, at_numper_sec#648989, at_ins_heure#648990, at_persaprev#648991, at_tarif#648992, at_nomhl7#648993, at_numper_ori_oid#648994, at_comment#648995]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos#648860)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos#648860)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stapat#648861)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_stapat#648861)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefix#648862)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_prefix#648862)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nompat#648863)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nompat#648863)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnopat#648864)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pnopat#648864)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfpat#648865)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_njfpat#648865)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnai#648866)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datnai#648866)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnaiss#648867)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datnaiss#648867)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sexe#648868)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_sexe#648868)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper#648869)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper#648869)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sigma#648870)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_sigma#648870)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_verrou#648871)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_verrou#648871)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids#648872)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_poids#648872)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indcen#648873)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_indcen#648873)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numss#648874)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numss#648874)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_antece#648875)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_antece#648875)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1#648876)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1#648876)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2#648877)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2#648877)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpos#648878)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codpos#648878)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ville#648879)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ville#648879)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays#648880)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pays#648880)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai#648881)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai#648881)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nummut#648882)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nummut#648882)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcha#648883)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numcha#648883)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpri#648884)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_telpri#648884)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telbur#648885)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_telbur#648885)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpor#648886)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_telpor#648886)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fax#648887)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fax#648887)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefi2#648888)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_prefi2#648888)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomass#648889)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nomass#648889)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnoass#648890)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pnoass#648890)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfass#648891)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_njfass#648891)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datass#648892)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datass#648892)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1a#648893)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1a#648893)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2a#648894)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2a#648894)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpoa#648895)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codpoa#648895)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villea#648896)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_villea#648896)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmed#648897)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codmed#648897)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datcss#648898)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datcss#648898)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_d#648899)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_d#648899)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat100#648900)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dat100#648900)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numsir#648901)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numsir#648901)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numssa#648902)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numssa#648902)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codser#648903)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codser#648903)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_rngnai#648904)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_rngnai#648904)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_natass#648905)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_natass#648905)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numacc#648906)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numacc#648906)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datacc#648907)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datacc#648907)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typexo#648908)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_typexo#648908)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datmaj#648909)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datmaj#648909)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_coduti#648910)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_coduti#648910)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flcmu#648911)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flcmu#648911)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_qualss#648912)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_qualss#648912)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codref#648913)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codref#648913)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codregat#648914)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codregat#648914)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codcaiat#648915)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codcaiat#648915)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indvital#648916)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_indvital#648916)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_conmut#648917)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_conmut#648917)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adhmut#648918)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adhmut#648918)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_garmut#648919)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_garmut#648919)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori#648920)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori#648920)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codrout#648921)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codrout#648921)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_domaine#648922)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_domaine#648922)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indtrai#648923)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_indtrai#648923)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_idhote#648924)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_idhote#648924)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsts#648925)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codsts#648925)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nirind#648926)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nirind#648926)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldcd#648927)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fldcd#648927)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flphoto#648928)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flphoto#648928)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmtr#648929)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codmtr#648929)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3#648930)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3#648930)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays_iso#648931)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pays_iso#648931)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3a#648932)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3a#648932)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids_maj#648933)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_poids_maj#648933)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codgestion#648934)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codgestion#648934)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_art115#648935)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_art115#648935)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille#648936)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_taille#648936)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille_maj#648937)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_taille_maj#648937)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codetab_prod#648938)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codetab_prod#648938)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsit_prod#648939)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codsit_prod#648939)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_prod#648940)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_prod#648940)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_prod#648941)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_prod#648941)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_prod#648942)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_prod#648942)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins#648943)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins#648943)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_type#648944)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_type#648944)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_date#648945)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_date#648945)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_source#648946)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_source#648946)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stadmp#648947)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_stadmp#648947)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdmp#648948)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datdmp#648948)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_alarmes#648949)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_alarmes#648949)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_email#648950)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_email#648950)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_consent_sms#648951)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_consent_sms#648951)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_consent_sms#648952)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_consent_sms#648952)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdcd#648953)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datdcd#648953)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flhlim#648954)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flhlim#648954)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dathlim#648955)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dathlim#648955)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpershlim#648956)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codpershlim#648956)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldiff#648957)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fldiff#648957)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_lisdest#648958)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_lisdest#648958)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_langue#648959)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_langue#648959)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai_ft#648960)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai_ft#648960)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codtarifamc#648961)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codtarifamc#648961)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flgrve#648962)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flgrve#648962)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fladri#648963)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fladri#648963)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datadri#648964)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datadri#648964)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_mut#648965)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_mut#648965)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comfac#648966)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_comfac#648966)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_cloud#648967)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_cloud#648967)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nation#648968)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nation#648968)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre#648969)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_titre#648969)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre_ass#648970)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_titre_ass#648970)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_histoxml#648971)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_histoxml#648971)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_pnoliste#648972)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_pnoliste#648972)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codposnai#648973)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codposnai#648973)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi#648974)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_insi#648974)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi_oid#648975)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_insi_oid#648975)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typconv#648976)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_typconv#648976)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_crisec#648977)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_crisec#648977)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_opereg#648978)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_opereg#648978)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flannuamc#648979)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flannuamc#648979)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_staipp#648980)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_staipp#648980)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnonai#648981)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pnonai#648981)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codinseenai#648982)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codinseenai#648982)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villenai#648983)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_villenai#648983)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_piece_ident_pres#648984)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_piece_ident_pres#648984)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_staipp#648985)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_staipp#648985)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datapcv#648986)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datapcv#648986)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_num_apcv#648987)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_num_apcv#648987)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_heuapcv#648988)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_heuapcv#648988)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_sec#648989)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_sec#648989)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_heure#648990)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_heure#648990)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_persaprev#648991)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_persaprev#648991)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tarif#648992)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_tarif#648992)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomhl7#648993)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nomhl7#648993)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_oid#648994)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_oid#648994)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comment#648995)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_comment#648995)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_A))), MARX)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_A))), MARX) END)

(3) Project
Output: []
Input [136]: [at_numdos#648860, at_stapat#648861, at_prefix#648862, at_nompat#648863, at_pnopat#648864, at_njfpat#648865, at_datnai#648866, at_datnaiss#648867, at_sexe#648868, at_numper#648869, at_sigma#648870, at_verrou#648871, at_poids#648872, at_indcen#648873, at_numss#648874, at_antece#648875, at_adr_1#648876, at_adr_2#648877, at_codpos#648878, at_ville#648879, at_pays#648880, at_numcai#648881, at_nummut#648882, at_numcha#648883, at_telpri#648884, at_telbur#648885, at_telpor#648886, at_fax#648887, at_prefi2#648888, at_nomass#648889, at_pnoass#648890, at_njfass#648891, at_datass#648892, at_adr_1a#648893, at_adr_2a#648894, at_codpoa#648895, at_villea#648896, at_codmed#648897, at_datcss#648898, at_datf_d#648899, at_dat100#648900, at_numsir#648901, at_numssa#648902, at_codser#648903, at_rngnai#648904, at_natass#648905, at_numacc#648906, at_datacc#648907, at_typexo#648908, at_datmaj#648909, at_coduti#648910, at_flcmu#648911, at_qualss#648912, at_codref#648913, at_codregat#648914, at_codcaiat#648915, at_indvital#648916, at_conmut#648917, at_adhmut#648918, at_garmut#648919, at_numper_ori#648920, at_codrout#648921, at_domaine#648922, at_indtrai#648923, at_idhote#648924, at_codsts#648925, at_nirind#648926, at_fldcd#648927, at_flphoto#648928, at_codmtr#648929, at_adr_3#648930, at_pays_iso#648931, at_adr_3a#648932, at_poids_maj#648933, at_codgestion#648934, at_art115#648935, at_taille#648936, at_taille_maj#648937, at_codetab_prod#648938, at_codsit_prod#648939, at_numdos_prod#648940, at_numper_prod#648941, at_numper_ori_prod#648942, at_ins#648943, at_ins_type#648944, at_ins_date#648945, at_ins_source#648946, at_stadmp#648947, at_datdmp#648948, at_alarmes#648949, at_email#648950, at_consent_sms#648951, at_dat_consent_sms#648952, at_datdcd#648953, at_flhlim#648954, at_dathlim#648955, at_codpershlim#648956, at_fldiff#648957, at_lisdest#648958, at_langue#648959, at_numcai_ft#648960, at_codtarifamc#648961, at_flgrve#648962, at_fladri#648963, at_datadri#648964, at_datf_mut#648965, at_comfac#648966, at_numdos_cloud#648967, at_nation#648968, at_titre#648969, at_titre_ass#648970, at_tiq_histoxml#648971, at_tiq_pnoliste#648972, at_codposnai#648973, at_insi#648974, at_insi_oid#648975, at_typconv#648976, at_crisec#648977, at_opereg#648978, at_flannuamc#648979, at_staipp#648980, at_pnonai#648981, at_codinseenai#648982, at_villenai#648983, at_piece_ident_pres#648984, at_dat_staipp#648985, at_datapcv#648986, at_num_apcv#648987, at_heuapcv#648988, at_numper_sec#648989, at_ins_heure#648990, at_persaprev#648991, at_tarif#648992, at_nomhl7#648993, at_numper_ori_oid#648994, at_comment#648995]

(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#651617, at_stapat#651618, at_prefix#651619, at_nompat#651620, at_pnopat#651621, at_njfpat#651622, at_datnai#651623, at_datnaiss#651624, at_sexe#651625, at_numper#651626, at_sigma#651627, at_verrou#651628, at_poids#651629, at_indcen#651630, at_numss#651631, at_antece#651632, at_adr_1#651633, at_adr_2#651634, at_codpos#651635, at_ville#651636, at_pays#651637, at_numcai#651638, at_nummut#651639, at_numcha#651640, at_telpri#651641, at_telbur#651642, at_telpor#651643, at_fax#651644, at_prefi2#651645, at_nomass#651646, at_pnoass#651647, at_njfass#651648, at_datass#651649, at_adr_1a#651650, at_adr_2a#651651, at_codpoa#651652, at_villea#651653, at_codmed#651654, at_datcss#651655, at_datf_d#651656, at_dat100#651657, at_numsir#651658, at_numssa#651659, at_codser#651660, at_rngnai#651661, at_natass#651662, at_numacc#651663, at_datacc#651664, at_typexo#651665, at_datmaj#651666, at_coduti#651667, at_flcmu#651668, at_qualss#651669, at_codref#651670, at_codregat#651671, at_codcaiat#651672, at_indvital#651673, at_conmut#651674, at_adhmut#651675, at_garmut#651676, at_numper_ori#651677, at_codrout#651678, at_domaine#651679, at_indtrai#651680, at_idhote#651681, at_codsts#651682, at_nirind#651683, at_fldcd#651684, at_flphoto#651685, at_codmtr#651686, at_adr_3#651687, at_pays_iso#651688, at_adr_3a#651689, at_poids_maj#651690, at_codgestion#651691, at_art115#651692, at_taille#651693, at_taille_maj#651694, at_codetab_prod#651695, at_codsit_prod#651696, at_numdos_prod#651697, at_numper_prod#651698, at_numper_ori_prod#651699, at_ins#651700, at_ins_type#651701, at_ins_date#651702, at_ins_source#651703, at_stadmp#651704, at_datdmp#651705, at_alarmes#651706, at_email#651707, at_consent_sms#651708, at_dat_consent_sms#651709, at_datdcd#651710, at_flhlim#651711, at_dathlim#651712, at_codpershlim#651713, at_fldiff#651714, at_lisdest#651715, at_langue#651716, at_numcai_ft#651717, at_codtarifamc#651718, at_flgrve#651719, at_fladri#651720, at_datadri#651721, at_datf_mut#651722, at_comfac#651723, at_numdos_cloud#651724, at_nation#651725, at_titre#651726, at_titre_ass#651727, at_tiq_histoxml#651728, at_tiq_pnoliste#651729, at_codposnai#651730, at_insi#651731, at_insi_oid#651732, at_typconv#651733, at_crisec#651734, at_opereg#651735, at_flannuamc#651736, at_staipp#651737, at_pnonai#651738, at_codinseenai#651739, at_villenai#651740, at_piece_ident_pres#651741, at_dat_staipp#651742, at_datapcv#651743, at_num_apcv#651744, at_heuapcv#651745, at_numper_sec#651746, at_ins_heure#651747, at_persaprev#651748, at_tarif#651749, at_nomhl7#651750, at_numper_ori_oid#651751, at_comment#651752]
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#651617, at_stapat#651618, at_prefix#651619, at_nompat#651620, at_pnopat#651621, at_njfpat#651622, at_datnai#651623, at_datnaiss#651624, at_sexe#651625, at_numper#651626, at_sigma#651627, at_verrou#651628, at_poids#651629, at_indcen#651630, at_numss#651631, at_antece#651632, at_adr_1#651633, at_adr_2#651634, at_codpos#651635, at_ville#651636, at_pays#651637, at_numcai#651638, at_nummut#651639, at_numcha#651640, at_telpri#651641, at_telbur#651642, at_telpor#651643, at_fax#651644, at_prefi2#651645, at_nomass#651646, at_pnoass#651647, at_njfass#651648, at_datass#651649, at_adr_1a#651650, at_adr_2a#651651, at_codpoa#651652, at_villea#651653, at_codmed#651654, at_datcss#651655, at_datf_d#651656, at_dat100#651657, at_numsir#651658, at_numssa#651659, at_codser#651660, at_rngnai#651661, at_natass#651662, at_numacc#651663, at_datacc#651664, at_typexo#651665, at_datmaj#651666, at_coduti#651667, at_flcmu#651668, at_qualss#651669, at_codref#651670, at_codregat#651671, at_codcaiat#651672, at_indvital#651673, at_conmut#651674, at_adhmut#651675, at_garmut#651676, at_numper_ori#651677, at_codrout#651678, at_domaine#651679, at_indtrai#651680, at_idhote#651681, at_codsts#651682, at_nirind#651683, at_fldcd#651684, at_flphoto#651685, at_codmtr#651686, at_adr_3#651687, at_pays_iso#651688, at_adr_3a#651689, at_poids_maj#651690, at_codgestion#651691, at_art115#651692, at_taille#651693, at_taille_maj#651694, at_codetab_prod#651695, at_codsit_prod#651696, at_numdos_prod#651697, at_numper_prod#651698, at_numper_ori_prod#651699, at_ins#651700, at_ins_type#651701, at_ins_date#651702, at_ins_source#651703, at_stadmp#651704, at_datdmp#651705, at_alarmes#651706, at_email#651707, at_consent_sms#651708, at_dat_consent_sms#651709, at_datdcd#651710, at_flhlim#651711, at_dathlim#651712, at_codpershlim#651713, at_fldiff#651714, at_lisdest#651715, at_langue#651716, at_numcai_ft#651717, at_codtarifamc#651718, at_flgrve#651719, at_fladri#651720, at_datadri#651721, at_datf_mut#651722, at_comfac#651723, at_numdos_cloud#651724, at_nation#651725, at_titre#651726, at_titre_ass#651727, at_tiq_histoxml#651728, at_tiq_pnoliste#651729, at_codposnai#651730, at_insi#651731, at_insi_oid#651732, at_typconv#651733, at_crisec#651734, at_opereg#651735, at_flannuamc#651736, at_staipp#651737, at_pnonai#651738, at_codinseenai#651739, at_villenai#651740, at_piece_ident_pres#651741, at_dat_staipp#651742, at_datapcv#651743, at_num_apcv#651744, at_heuapcv#651745, at_numper_sec#651746, at_ins_heure#651747, at_persaprev#651748, at_tarif#651749, at_nomhl7#651750, at_numper_ori_oid#651751, at_comment#651752]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos#651617)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos#651617)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stapat#651618)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_stapat#651618)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefix#651619)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_prefix#651619)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nompat#651620)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nompat#651620)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnopat#651621)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pnopat#651621)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfpat#651622)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_njfpat#651622)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnai#651623)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datnai#651623)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnaiss#651624)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datnaiss#651624)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sexe#651625)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_sexe#651625)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper#651626)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper#651626)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sigma#651627)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_sigma#651627)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_verrou#651628)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_verrou#651628)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids#651629)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_poids#651629)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indcen#651630)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_indcen#651630)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numss#651631)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numss#651631)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_antece#651632)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_antece#651632)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1#651633)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1#651633)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2#651634)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2#651634)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpos#651635)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codpos#651635)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ville#651636)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ville#651636)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays#651637)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pays#651637)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai#651638)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai#651638)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nummut#651639)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nummut#651639)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcha#651640)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numcha#651640)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpri#651641)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_telpri#651641)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telbur#651642)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_telbur#651642)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpor#651643)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_telpor#651643)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fax#651644)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fax#651644)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefi2#651645)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_prefi2#651645)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomass#651646)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nomass#651646)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnoass#651647)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pnoass#651647)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfass#651648)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_njfass#651648)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datass#651649)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datass#651649)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1a#651650)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1a#651650)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2a#651651)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2a#651651)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpoa#651652)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codpoa#651652)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villea#651653)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_villea#651653)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmed#651654)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codmed#651654)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datcss#651655)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datcss#651655)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_d#651656)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_d#651656)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat100#651657)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dat100#651657)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numsir#651658)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numsir#651658)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numssa#651659)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numssa#651659)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codser#651660)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codser#651660)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_rngnai#651661)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_rngnai#651661)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_natass#651662)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_natass#651662)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numacc#651663)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numacc#651663)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datacc#651664)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datacc#651664)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typexo#651665)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_typexo#651665)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datmaj#651666)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datmaj#651666)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_coduti#651667)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_coduti#651667)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flcmu#651668)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flcmu#651668)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_qualss#651669)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_qualss#651669)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codref#651670)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codref#651670)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codregat#651671)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codregat#651671)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codcaiat#651672)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codcaiat#651672)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indvital#651673)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_indvital#651673)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_conmut#651674)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_conmut#651674)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adhmut#651675)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adhmut#651675)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_garmut#651676)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_garmut#651676)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori#651677)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori#651677)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codrout#651678)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codrout#651678)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_domaine#651679)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_domaine#651679)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indtrai#651680)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_indtrai#651680)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_idhote#651681)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_idhote#651681)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsts#651682)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codsts#651682)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nirind#651683)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nirind#651683)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldcd#651684)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fldcd#651684)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flphoto#651685)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flphoto#651685)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmtr#651686)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codmtr#651686)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3#651687)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3#651687)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays_iso#651688)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pays_iso#651688)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3a#651689)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3a#651689)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids_maj#651690)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_poids_maj#651690)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codgestion#651691)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codgestion#651691)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_art115#651692)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_art115#651692)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille#651693)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_taille#651693)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille_maj#651694)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_taille_maj#651694)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codetab_prod#651695)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codetab_prod#651695)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsit_prod#651696)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codsit_prod#651696)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_prod#651697)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_prod#651697)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_prod#651698)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_prod#651698)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_prod#651699)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_prod#651699)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins#651700)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins#651700)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_type#651701)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_type#651701)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_date#651702)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_date#651702)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_source#651703)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_source#651703)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stadmp#651704)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_stadmp#651704)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdmp#651705)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datdmp#651705)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_alarmes#651706)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_alarmes#651706)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_email#651707)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_email#651707)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_consent_sms#651708)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_consent_sms#651708)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_consent_sms#651709)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_consent_sms#651709)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdcd#651710)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datdcd#651710)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flhlim#651711)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flhlim#651711)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dathlim#651712)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dathlim#651712)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpershlim#651713)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codpershlim#651713)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldiff#651714)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fldiff#651714)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_lisdest#651715)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_lisdest#651715)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_langue#651716)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_langue#651716)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai_ft#651717)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai_ft#651717)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codtarifamc#651718)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codtarifamc#651718)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flgrve#651719)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flgrve#651719)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fladri#651720)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fladri#651720)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datadri#651721)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datadri#651721)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_mut#651722)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_mut#651722)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comfac#651723)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_comfac#651723)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_cloud#651724)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_cloud#651724)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nation#651725)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nation#651725)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre#651726)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_titre#651726)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre_ass#651727)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_titre_ass#651727)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_histoxml#651728)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_histoxml#651728)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_pnoliste#651729)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_pnoliste#651729)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codposnai#651730)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codposnai#651730)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi#651731)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_insi#651731)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi_oid#651732)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_insi_oid#651732)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typconv#651733)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_typconv#651733)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_crisec#651734)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_crisec#651734)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_opereg#651735)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_opereg#651735)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flannuamc#651736)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flannuamc#651736)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_staipp#651737)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_staipp#651737)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnonai#651738)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pnonai#651738)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codinseenai#651739)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codinseenai#651739)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villenai#651740)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_villenai#651740)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_piece_ident_pres#651741)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_piece_ident_pres#651741)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_staipp#651742)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_staipp#651742)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datapcv#651743)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datapcv#651743)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_num_apcv#651744)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_num_apcv#651744)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_heuapcv#651745)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_heuapcv#651745)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_sec#651746)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_sec#651746)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_heure#651747)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_heure#651747)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_persaprev#651748)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_persaprev#651748)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tarif#651749)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_tarif#651749)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomhl7#651750)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nomhl7#651750)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_oid#651751)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_oid#651751)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comment#651752)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_comment#651752)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_B))), MARX)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_B))), MARX) END)

(6) Project
Output: []
Input [136]: [at_numdos#651617, at_stapat#651618, at_prefix#651619, at_nompat#651620, at_pnopat#651621, at_njfpat#651622, at_datnai#651623, at_datnaiss#651624, at_sexe#651625, at_numper#651626, at_sigma#651627, at_verrou#651628, at_poids#651629, at_indcen#651630, at_numss#651631, at_antece#651632, at_adr_1#651633, at_adr_2#651634, at_codpos#651635, at_ville#651636, at_pays#651637, at_numcai#651638, at_nummut#651639, at_numcha#651640, at_telpri#651641, at_telbur#651642, at_telpor#651643, at_fax#651644, at_prefi2#651645, at_nomass#651646, at_pnoass#651647, at_njfass#651648, at_datass#651649, at_adr_1a#651650, at_adr_2a#651651, at_codpoa#651652, at_villea#651653, at_codmed#651654, at_datcss#651655, at_datf_d#651656, at_dat100#651657, at_numsir#651658, at_numssa#651659, at_codser#651660, at_rngnai#651661, at_natass#651662, at_numacc#651663, at_datacc#651664, at_typexo#651665, at_datmaj#651666, at_coduti#651667, at_flcmu#651668, at_qualss#651669, at_codref#651670, at_codregat#651671, at_codcaiat#651672, at_indvital#651673, at_conmut#651674, at_adhmut#651675, at_garmut#651676, at_numper_ori#651677, at_codrout#651678, at_domaine#651679, at_indtrai#651680, at_idhote#651681, at_codsts#651682, at_nirind#651683, at_fldcd#651684, at_flphoto#651685, at_codmtr#651686, at_adr_3#651687, at_pays_iso#651688, at_adr_3a#651689, at_poids_maj#651690, at_codgestion#651691, at_art115#651692, at_taille#651693, at_taille_maj#651694, at_codetab_prod#651695, at_codsit_prod#651696, at_numdos_prod#651697, at_numper_prod#651698, at_numper_ori_prod#651699, at_ins#651700, at_ins_type#651701, at_ins_date#651702, at_ins_source#651703, at_stadmp#651704, at_datdmp#651705, at_alarmes#651706, at_email#651707, at_consent_sms#651708, at_dat_consent_sms#651709, at_datdcd#651710, at_flhlim#651711, at_dathlim#651712, at_codpershlim#651713, at_fldiff#651714, at_lisdest#651715, at_langue#651716, at_numcai_ft#651717, at_codtarifamc#651718, at_flgrve#651719, at_fladri#651720, at_datadri#651721, at_datf_mut#651722, at_comfac#651723, at_numdos_cloud#651724, at_nation#651725, at_titre#651726, at_titre_ass#651727, at_tiq_histoxml#651728, at_tiq_pnoliste#651729, at_codposnai#651730, at_insi#651731, at_insi_oid#651732, at_typconv#651733, at_crisec#651734, at_opereg#651735, at_flannuamc#651736, at_staipp#651737, at_pnonai#651738, at_codinseenai#651739, at_villenai#651740, at_piece_ident_pres#651741, at_dat_staipp#651742, at_datapcv#651743, at_num_apcv#651744, at_heuapcv#651745, at_numper_sec#651746, at_ins_heure#651747, at_persaprev#651748, at_tarif#651749, at_nomhl7#651750, at_numper_ori_oid#651751, at_comment#651752]

(7) Union

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

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

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

(11) HashAggregate [codegen id : 2]
Input [1]: [count#659855L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#657262L]
Results [1]: [count(1)#657262L AS COL_e017511f-8108-489c-85a6-a3f9da8583d3#657264L]

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

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

(14) HashAggregate
Input [1]: [count#659855L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#657262L]
Results [1]: [count(1)#657262L AS COL_e017511f-8108-489c-85a6-a3f9da8583d3#657264L]

(15) AdaptiveSparkPlan
Output [1]: [COL_e017511f-8108-489c-85a6-a3f9da8583d3#657264L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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