hdh-spark-job - Details for Query 1280

Submitted Time: 2026/10/23 13:25:23
Duration: 3 s
Succeeded Jobs: 1284 1286

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 1849.0: task 1605)) 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 1849.0: task 1606)) 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 1849.0: task 1606))"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n4.4 s (2.2 s, 2.3 s, 2.3 s (stage 1849.0: task 1605))"; 5 [labelType="html" label="HashAggregate time in aggregation build total (min, med, max (stageId: taskId)) 4.4 s (2.2 s, 2.3 s, 2.3 s (stage 1849.0: task 1605)) 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=33926]

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

WholeStageCodegen (1)

Union

Project

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos#618943)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos#618943)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stapat#618944)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_stapat#618944)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefix#618945)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_prefix#618945)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nompat#618946)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nompat#618946)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnopat#618947)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pnopat#618947)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfpat#618948)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_njfpat#618948)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnai#618949)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datnai#618949)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnaiss#618950)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datnaiss#618950)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sexe#618951)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_sexe#618951)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper#618952)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper#618952)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sigma#618953)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_sigma#618953)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_verrou#618954)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_verrou#618954)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids#618955)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_poids#618955)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indcen#618956)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_indcen#618956)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numss#618957)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numss#618957)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_antece#618958)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_antece#618958)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1#618959)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1#618959)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2#618960)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2#618960)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpos#618961)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codpos#618961)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ville#618962)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ville#618962)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays#618963)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pays#618963)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai#618964)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai#618964)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nummut#618965)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nummut#618965)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcha#618966)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numcha#618966)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpri#618967)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_telpri#618967)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telbur#618968)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_telbur#618968)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpor#618969)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_telpor#618969)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fax#618970)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fax#618970)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefi2#618971)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_prefi2#618971)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomass#618972)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nomass#618972)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnoass#618973)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pnoass#618973)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfass#618974)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_njfass#618974)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datass#618975)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datass#618975)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1a#618976)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1a#618976)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2a#618977)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2a#618977)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpoa#618978)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codpoa#618978)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villea#618979)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_villea#618979)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmed#618980)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codmed#618980)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datcss#618981)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datcss#618981)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_d#618982)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_d#618982)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat100#618983)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dat100#618983)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numsir#618984)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numsir#618984)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numssa#618985)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numssa#618985)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codser#618986)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codser#618986)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_rngnai#618987)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_rngnai#618987)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_natass#618988)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_natass#618988)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numacc#618989)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numacc#618989)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datacc#618990)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datacc#618990)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typexo#618991)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_typexo#618991)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datmaj#618992)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datmaj#618992)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_coduti#618993)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_coduti#618993)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flcmu#618994)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flcmu#618994)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_qualss#618995)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_qualss#618995)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codref#618996)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codref#618996)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codregat#618997)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codregat#618997)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codcaiat#618998)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codcaiat#618998)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indvital#618999)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_indvital#618999)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_conmut#619000)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_conmut#619000)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adhmut#619001)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adhmut#619001)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_garmut#619002)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_garmut#619002)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori#619003)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori#619003)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codrout#619004)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codrout#619004)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_domaine#619005)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_domaine#619005)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indtrai#619006)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_indtrai#619006)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_idhote#619007)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_idhote#619007)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsts#619008)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codsts#619008)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nirind#619009)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nirind#619009)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldcd#619010)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fldcd#619010)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flphoto#619011)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flphoto#619011)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmtr#619012)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codmtr#619012)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3#619013)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3#619013)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays_iso#619014)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pays_iso#619014)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3a#619015)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3a#619015)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids_maj#619016)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_poids_maj#619016)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codgestion#619017)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codgestion#619017)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_art115#619018)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_art115#619018)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille#619019)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_taille#619019)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille_maj#619020)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_taille_maj#619020)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codetab_prod#619021)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codetab_prod#619021)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsit_prod#619022)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codsit_prod#619022)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_prod#619023)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_prod#619023)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_prod#619024)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_prod#619024)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_prod#619025)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_prod#619025)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins#619026)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins#619026)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_type#619027)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_type#619027)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_date#619028)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_date#619028)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_source#619029)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_source#619029)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stadmp#619030)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_stadmp#619030)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdmp#619031)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datdmp#619031)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_alarmes#619032)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_alarmes#619032)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_email#619033)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_email#619033)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_consent_sms#619034)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_consent_sms#619034)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_consent_sms#619035)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_consent_sms#619035)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdcd#619036)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datdcd#619036)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flhlim#619037)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flhlim#619037)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dathlim#619038)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dathlim#619038)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpershlim#619039)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codpershlim#619039)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldiff#619040)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fldiff#619040)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_lisdest#619041)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_lisdest#619041)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_langue#619042)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_langue#619042)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai_ft#619043)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai_ft#619043)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codtarifamc#619044)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codtarifamc#619044)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flgrve#619045)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flgrve#619045)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fladri#619046)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fladri#619046)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datadri#619047)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datadri#619047)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_mut#619048)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_mut#619048)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comfac#619049)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_comfac#619049)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_cloud#619050)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_cloud#619050)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nation#619051)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nation#619051)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre#619052)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_titre#619052)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre_ass#619053)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_titre_ass#619053)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_histoxml#619054)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_histoxml#619054)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_pnoliste#619055)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_pnoliste#619055)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codposnai#619056)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codposnai#619056)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi#619057)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_insi#619057)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi_oid#619058)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_insi_oid#619058)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typconv#619059)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_typconv#619059)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_crisec#619060)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_crisec#619060)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_opereg#619061)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_opereg#619061)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flannuamc#619062)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flannuamc#619062)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_staipp#619063)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_staipp#619063)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnonai#619064)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pnonai#619064)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codinseenai#619065)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codinseenai#619065)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villenai#619066)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_villenai#619066)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_piece_ident_pres#619067)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_piece_ident_pres#619067)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_staipp#619068)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_staipp#619068)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datapcv#619069)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datapcv#619069)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_num_apcv#619070)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_num_apcv#619070)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_heuapcv#619071)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_heuapcv#619071)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_sec#619072)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_sec#619072)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_heure#619073)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_heure#619073)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_persaprev#619074)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_persaprev#619074)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tarif#619075)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_tarif#619075)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomhl7#619076)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nomhl7#619076)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_oid#619077)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_oid#619077)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comment#619078)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_comment#619078)), 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#618943,at_stapat#618944,at_prefix#618945,at_nompat#618946,at_pnopat#618947,at_njfpat#618948,at_datnai#618949,at_datnaiss#618950,at_sexe#618951,at_numper#618952,at_sigma#618953,at_verrou#618954,at_poids#618955,at_indcen#618956,at_numss#618957,at_antece#618958,at_adr_1#618959,at_adr_2#618960,at_codpos#618961,at_ville#618962,at_pays#618963,at_numcai#618964,at_nummut#618965,at_numcha#618966,... 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#620170)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos#620170)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stapat#620171)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_stapat#620171)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefix#620172)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_prefix#620172)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nompat#620173)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nompat#620173)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnopat#620174)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pnopat#620174)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfpat#620175)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_njfpat#620175)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnai#620176)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datnai#620176)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnaiss#620177)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datnaiss#620177)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sexe#620178)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_sexe#620178)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper#620179)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper#620179)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sigma#620180)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_sigma#620180)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_verrou#620181)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_verrou#620181)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids#620182)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_poids#620182)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indcen#620183)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_indcen#620183)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numss#620184)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numss#620184)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_antece#620185)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_antece#620185)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1#620186)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1#620186)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2#620187)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2#620187)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpos#620188)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codpos#620188)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ville#620189)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ville#620189)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays#620190)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pays#620190)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai#620191)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai#620191)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nummut#620192)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nummut#620192)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcha#620193)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numcha#620193)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpri#620194)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_telpri#620194)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telbur#620195)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_telbur#620195)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpor#620196)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_telpor#620196)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fax#620197)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fax#620197)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefi2#620198)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_prefi2#620198)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomass#620199)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nomass#620199)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnoass#620200)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pnoass#620200)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfass#620201)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_njfass#620201)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datass#620202)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datass#620202)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1a#620203)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1a#620203)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2a#620204)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2a#620204)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpoa#620205)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codpoa#620205)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villea#620206)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_villea#620206)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmed#620207)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codmed#620207)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datcss#620208)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datcss#620208)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_d#620209)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_d#620209)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat100#620210)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dat100#620210)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numsir#620211)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numsir#620211)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numssa#620212)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numssa#620212)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codser#620213)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codser#620213)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_rngnai#620214)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_rngnai#620214)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_natass#620215)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_natass#620215)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numacc#620216)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numacc#620216)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datacc#620217)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datacc#620217)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typexo#620218)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_typexo#620218)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datmaj#620219)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datmaj#620219)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_coduti#620220)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_coduti#620220)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flcmu#620221)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flcmu#620221)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_qualss#620222)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_qualss#620222)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codref#620223)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codref#620223)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codregat#620224)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codregat#620224)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codcaiat#620225)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codcaiat#620225)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indvital#620226)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_indvital#620226)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_conmut#620227)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_conmut#620227)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adhmut#620228)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adhmut#620228)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_garmut#620229)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_garmut#620229)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori#620230)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori#620230)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codrout#620231)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codrout#620231)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_domaine#620232)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_domaine#620232)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indtrai#620233)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_indtrai#620233)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_idhote#620234)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_idhote#620234)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsts#620235)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codsts#620235)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nirind#620236)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nirind#620236)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldcd#620237)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fldcd#620237)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flphoto#620238)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flphoto#620238)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmtr#620239)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codmtr#620239)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3#620240)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3#620240)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays_iso#620241)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pays_iso#620241)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3a#620242)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3a#620242)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids_maj#620243)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_poids_maj#620243)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codgestion#620244)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codgestion#620244)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_art115#620245)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_art115#620245)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille#620246)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_taille#620246)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille_maj#620247)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_taille_maj#620247)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codetab_prod#620248)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codetab_prod#620248)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsit_prod#620249)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codsit_prod#620249)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_prod#620250)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_prod#620250)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_prod#620251)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_prod#620251)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_prod#620252)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_prod#620252)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins#620253)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins#620253)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_type#620254)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_type#620254)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_date#620255)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_date#620255)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_source#620256)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_source#620256)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stadmp#620257)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_stadmp#620257)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdmp#620258)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datdmp#620258)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_alarmes#620259)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_alarmes#620259)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_email#620260)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_email#620260)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_consent_sms#620261)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_consent_sms#620261)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_consent_sms#620262)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_consent_sms#620262)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdcd#620263)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datdcd#620263)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flhlim#620264)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flhlim#620264)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dathlim#620265)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dathlim#620265)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpershlim#620266)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codpershlim#620266)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldiff#620267)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fldiff#620267)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_lisdest#620268)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_lisdest#620268)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_langue#620269)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_langue#620269)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai_ft#620270)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai_ft#620270)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codtarifamc#620271)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codtarifamc#620271)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flgrve#620272)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flgrve#620272)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fladri#620273)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fladri#620273)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datadri#620274)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datadri#620274)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_mut#620275)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_mut#620275)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comfac#620276)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_comfac#620276)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_cloud#620277)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_cloud#620277)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nation#620278)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nation#620278)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre#620279)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_titre#620279)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre_ass#620280)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_titre_ass#620280)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_histoxml#620281)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_histoxml#620281)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_pnoliste#620282)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_pnoliste#620282)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codposnai#620283)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codposnai#620283)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi#620284)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_insi#620284)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi_oid#620285)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_insi_oid#620285)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typconv#620286)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_typconv#620286)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_crisec#620287)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_crisec#620287)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_opereg#620288)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_opereg#620288)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flannuamc#620289)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flannuamc#620289)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_staipp#620290)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_staipp#620290)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnonai#620291)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pnonai#620291)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codinseenai#620292)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codinseenai#620292)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villenai#620293)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_villenai#620293)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_piece_ident_pres#620294)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_piece_ident_pres#620294)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_staipp#620295)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_staipp#620295)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datapcv#620296)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datapcv#620296)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_num_apcv#620297)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_num_apcv#620297)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_heuapcv#620298)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_heuapcv#620298)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_sec#620299)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_sec#620299)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_heure#620300)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_heure#620300)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_persaprev#620301)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_persaprev#620301)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tarif#620302)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_tarif#620302)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomhl7#620303)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nomhl7#620303)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_oid#620304)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_oid#620304)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comment#620305)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_comment#620305)), 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#620170,at_stapat#620171,at_prefix#620172,at_nompat#620173,at_pnopat#620174,at_njfpat#620175,at_datnai#620176,at_datnaiss#620177,at_sexe#620178,at_numper#620179,at_sigma#620180,at_verrou#620181,at_poids#620182,at_indcen#620183,at_numss#620184,at_antece#620185,at_adr_1#620186,at_adr_2#620187,at_codpos#620188,at_ville#620189,at_pays#620190,at_numcai#620191,at_nummut#620192,at_numcha#620193,... 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#618943, at_stapat#618944, at_prefix#618945, at_nompat#618946, at_pnopat#618947, at_njfpat#618948, at_datnai#618949, at_datnaiss#618950, at_sexe#618951, at_numper#618952, at_sigma#618953, at_verrou#618954, at_poids#618955, at_indcen#618956, at_numss#618957, at_antece#618958, at_adr_1#618959, at_adr_2#618960, at_codpos#618961, at_ville#618962, at_pays#618963, at_numcai#618964, at_nummut#618965, at_numcha#618966, at_telpri#618967, at_telbur#618968, at_telpor#618969, at_fax#618970, at_prefi2#618971, at_nomass#618972, at_pnoass#618973, at_njfass#618974, at_datass#618975, at_adr_1a#618976, at_adr_2a#618977, at_codpoa#618978, at_villea#618979, at_codmed#618980, at_datcss#618981, at_datf_d#618982, at_dat100#618983, at_numsir#618984, at_numssa#618985, at_codser#618986, at_rngnai#618987, at_natass#618988, at_numacc#618989, at_datacc#618990, at_typexo#618991, at_datmaj#618992, at_coduti#618993, at_flcmu#618994, at_qualss#618995, at_codref#618996, at_codregat#618997, at_codcaiat#618998, at_indvital#618999, at_conmut#619000, at_adhmut#619001, at_garmut#619002, at_numper_ori#619003, at_codrout#619004, at_domaine#619005, at_indtrai#619006, at_idhote#619007, at_codsts#619008, at_nirind#619009, at_fldcd#619010, at_flphoto#619011, at_codmtr#619012, at_adr_3#619013, at_pays_iso#619014, at_adr_3a#619015, at_poids_maj#619016, at_codgestion#619017, at_art115#619018, at_taille#619019, at_taille_maj#619020, at_codetab_prod#619021, at_codsit_prod#619022, at_numdos_prod#619023, at_numper_prod#619024, at_numper_ori_prod#619025, at_ins#619026, at_ins_type#619027, at_ins_date#619028, at_ins_source#619029, at_stadmp#619030, at_datdmp#619031, at_alarmes#619032, at_email#619033, at_consent_sms#619034, at_dat_consent_sms#619035, at_datdcd#619036, at_flhlim#619037, at_dathlim#619038, at_codpershlim#619039, at_fldiff#619040, at_lisdest#619041, at_langue#619042, at_numcai_ft#619043, at_codtarifamc#619044, at_flgrve#619045, at_fladri#619046, at_datadri#619047, at_datf_mut#619048, at_comfac#619049, at_numdos_cloud#619050, at_nation#619051, at_titre#619052, at_titre_ass#619053, at_tiq_histoxml#619054, at_tiq_pnoliste#619055, at_codposnai#619056, at_insi#619057, at_insi_oid#619058, at_typconv#619059, at_crisec#619060, at_opereg#619061, at_flannuamc#619062, at_staipp#619063, at_pnonai#619064, at_codinseenai#619065, at_villenai#619066, at_piece_ident_pres#619067, at_dat_staipp#619068, at_datapcv#619069, at_num_apcv#619070, at_heuapcv#619071, at_numper_sec#619072, at_ins_heure#619073, at_persaprev#619074, at_tarif#619075, at_nomhl7#619076, at_numper_ori_oid#619077, at_comment#619078]
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#618943, at_stapat#618944, at_prefix#618945, at_nompat#618946, at_pnopat#618947, at_njfpat#618948, at_datnai#618949, at_datnaiss#618950, at_sexe#618951, at_numper#618952, at_sigma#618953, at_verrou#618954, at_poids#618955, at_indcen#618956, at_numss#618957, at_antece#618958, at_adr_1#618959, at_adr_2#618960, at_codpos#618961, at_ville#618962, at_pays#618963, at_numcai#618964, at_nummut#618965, at_numcha#618966, at_telpri#618967, at_telbur#618968, at_telpor#618969, at_fax#618970, at_prefi2#618971, at_nomass#618972, at_pnoass#618973, at_njfass#618974, at_datass#618975, at_adr_1a#618976, at_adr_2a#618977, at_codpoa#618978, at_villea#618979, at_codmed#618980, at_datcss#618981, at_datf_d#618982, at_dat100#618983, at_numsir#618984, at_numssa#618985, at_codser#618986, at_rngnai#618987, at_natass#618988, at_numacc#618989, at_datacc#618990, at_typexo#618991, at_datmaj#618992, at_coduti#618993, at_flcmu#618994, at_qualss#618995, at_codref#618996, at_codregat#618997, at_codcaiat#618998, at_indvital#618999, at_conmut#619000, at_adhmut#619001, at_garmut#619002, at_numper_ori#619003, at_codrout#619004, at_domaine#619005, at_indtrai#619006, at_idhote#619007, at_codsts#619008, at_nirind#619009, at_fldcd#619010, at_flphoto#619011, at_codmtr#619012, at_adr_3#619013, at_pays_iso#619014, at_adr_3a#619015, at_poids_maj#619016, at_codgestion#619017, at_art115#619018, at_taille#619019, at_taille_maj#619020, at_codetab_prod#619021, at_codsit_prod#619022, at_numdos_prod#619023, at_numper_prod#619024, at_numper_ori_prod#619025, at_ins#619026, at_ins_type#619027, at_ins_date#619028, at_ins_source#619029, at_stadmp#619030, at_datdmp#619031, at_alarmes#619032, at_email#619033, at_consent_sms#619034, at_dat_consent_sms#619035, at_datdcd#619036, at_flhlim#619037, at_dathlim#619038, at_codpershlim#619039, at_fldiff#619040, at_lisdest#619041, at_langue#619042, at_numcai_ft#619043, at_codtarifamc#619044, at_flgrve#619045, at_fladri#619046, at_datadri#619047, at_datf_mut#619048, at_comfac#619049, at_numdos_cloud#619050, at_nation#619051, at_titre#619052, at_titre_ass#619053, at_tiq_histoxml#619054, at_tiq_pnoliste#619055, at_codposnai#619056, at_insi#619057, at_insi_oid#619058, at_typconv#619059, at_crisec#619060, at_opereg#619061, at_flannuamc#619062, at_staipp#619063, at_pnonai#619064, at_codinseenai#619065, at_villenai#619066, at_piece_ident_pres#619067, at_dat_staipp#619068, at_datapcv#619069, at_num_apcv#619070, at_heuapcv#619071, at_numper_sec#619072, at_ins_heure#619073, at_persaprev#619074, at_tarif#619075, at_nomhl7#619076, at_numper_ori_oid#619077, at_comment#619078]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos#618943)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos#618943)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stapat#618944)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_stapat#618944)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefix#618945)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_prefix#618945)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nompat#618946)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nompat#618946)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnopat#618947)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pnopat#618947)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfpat#618948)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_njfpat#618948)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnai#618949)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datnai#618949)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnaiss#618950)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datnaiss#618950)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sexe#618951)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_sexe#618951)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper#618952)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper#618952)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sigma#618953)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_sigma#618953)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_verrou#618954)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_verrou#618954)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids#618955)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_poids#618955)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indcen#618956)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_indcen#618956)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numss#618957)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numss#618957)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_antece#618958)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_antece#618958)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1#618959)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1#618959)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2#618960)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2#618960)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpos#618961)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codpos#618961)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ville#618962)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ville#618962)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays#618963)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pays#618963)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai#618964)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai#618964)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nummut#618965)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nummut#618965)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcha#618966)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numcha#618966)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpri#618967)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_telpri#618967)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telbur#618968)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_telbur#618968)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpor#618969)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_telpor#618969)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fax#618970)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fax#618970)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefi2#618971)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_prefi2#618971)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomass#618972)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nomass#618972)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnoass#618973)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pnoass#618973)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfass#618974)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_njfass#618974)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datass#618975)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datass#618975)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1a#618976)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1a#618976)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2a#618977)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2a#618977)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpoa#618978)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codpoa#618978)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villea#618979)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_villea#618979)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmed#618980)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codmed#618980)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datcss#618981)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datcss#618981)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_d#618982)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_d#618982)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat100#618983)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dat100#618983)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numsir#618984)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numsir#618984)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numssa#618985)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numssa#618985)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codser#618986)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codser#618986)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_rngnai#618987)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_rngnai#618987)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_natass#618988)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_natass#618988)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numacc#618989)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numacc#618989)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datacc#618990)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datacc#618990)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typexo#618991)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_typexo#618991)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datmaj#618992)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datmaj#618992)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_coduti#618993)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_coduti#618993)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flcmu#618994)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flcmu#618994)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_qualss#618995)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_qualss#618995)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codref#618996)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codref#618996)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codregat#618997)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codregat#618997)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codcaiat#618998)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codcaiat#618998)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indvital#618999)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_indvital#618999)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_conmut#619000)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_conmut#619000)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adhmut#619001)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adhmut#619001)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_garmut#619002)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_garmut#619002)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori#619003)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori#619003)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codrout#619004)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codrout#619004)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_domaine#619005)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_domaine#619005)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indtrai#619006)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_indtrai#619006)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_idhote#619007)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_idhote#619007)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsts#619008)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codsts#619008)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nirind#619009)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nirind#619009)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldcd#619010)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fldcd#619010)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flphoto#619011)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flphoto#619011)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmtr#619012)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codmtr#619012)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3#619013)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3#619013)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays_iso#619014)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pays_iso#619014)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3a#619015)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3a#619015)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids_maj#619016)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_poids_maj#619016)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codgestion#619017)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codgestion#619017)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_art115#619018)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_art115#619018)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille#619019)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_taille#619019)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille_maj#619020)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_taille_maj#619020)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codetab_prod#619021)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codetab_prod#619021)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsit_prod#619022)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codsit_prod#619022)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_prod#619023)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_prod#619023)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_prod#619024)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_prod#619024)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_prod#619025)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_prod#619025)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins#619026)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins#619026)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_type#619027)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_type#619027)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_date#619028)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_date#619028)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_source#619029)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_source#619029)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stadmp#619030)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_stadmp#619030)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdmp#619031)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datdmp#619031)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_alarmes#619032)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_alarmes#619032)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_email#619033)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_email#619033)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_consent_sms#619034)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_consent_sms#619034)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_consent_sms#619035)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_consent_sms#619035)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdcd#619036)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datdcd#619036)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flhlim#619037)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flhlim#619037)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dathlim#619038)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dathlim#619038)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpershlim#619039)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codpershlim#619039)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldiff#619040)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fldiff#619040)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_lisdest#619041)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_lisdest#619041)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_langue#619042)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_langue#619042)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai_ft#619043)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai_ft#619043)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codtarifamc#619044)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codtarifamc#619044)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flgrve#619045)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flgrve#619045)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fladri#619046)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fladri#619046)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datadri#619047)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datadri#619047)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_mut#619048)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_mut#619048)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comfac#619049)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_comfac#619049)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_cloud#619050)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_cloud#619050)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nation#619051)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nation#619051)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre#619052)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_titre#619052)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre_ass#619053)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_titre_ass#619053)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_histoxml#619054)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_histoxml#619054)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_pnoliste#619055)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_pnoliste#619055)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codposnai#619056)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codposnai#619056)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi#619057)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_insi#619057)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi_oid#619058)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_insi_oid#619058)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typconv#619059)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_typconv#619059)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_crisec#619060)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_crisec#619060)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_opereg#619061)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_opereg#619061)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flannuamc#619062)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flannuamc#619062)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_staipp#619063)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_staipp#619063)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnonai#619064)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pnonai#619064)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codinseenai#619065)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codinseenai#619065)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villenai#619066)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_villenai#619066)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_piece_ident_pres#619067)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_piece_ident_pres#619067)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_staipp#619068)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_staipp#619068)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datapcv#619069)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datapcv#619069)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_num_apcv#619070)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_num_apcv#619070)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_heuapcv#619071)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_heuapcv#619071)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_sec#619072)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_sec#619072)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_heure#619073)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_heure#619073)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_persaprev#619074)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_persaprev#619074)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tarif#619075)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_tarif#619075)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomhl7#619076)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nomhl7#619076)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_oid#619077)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_oid#619077)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comment#619078)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_comment#619078)), 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#618943, at_stapat#618944, at_prefix#618945, at_nompat#618946, at_pnopat#618947, at_njfpat#618948, at_datnai#618949, at_datnaiss#618950, at_sexe#618951, at_numper#618952, at_sigma#618953, at_verrou#618954, at_poids#618955, at_indcen#618956, at_numss#618957, at_antece#618958, at_adr_1#618959, at_adr_2#618960, at_codpos#618961, at_ville#618962, at_pays#618963, at_numcai#618964, at_nummut#618965, at_numcha#618966, at_telpri#618967, at_telbur#618968, at_telpor#618969, at_fax#618970, at_prefi2#618971, at_nomass#618972, at_pnoass#618973, at_njfass#618974, at_datass#618975, at_adr_1a#618976, at_adr_2a#618977, at_codpoa#618978, at_villea#618979, at_codmed#618980, at_datcss#618981, at_datf_d#618982, at_dat100#618983, at_numsir#618984, at_numssa#618985, at_codser#618986, at_rngnai#618987, at_natass#618988, at_numacc#618989, at_datacc#618990, at_typexo#618991, at_datmaj#618992, at_coduti#618993, at_flcmu#618994, at_qualss#618995, at_codref#618996, at_codregat#618997, at_codcaiat#618998, at_indvital#618999, at_conmut#619000, at_adhmut#619001, at_garmut#619002, at_numper_ori#619003, at_codrout#619004, at_domaine#619005, at_indtrai#619006, at_idhote#619007, at_codsts#619008, at_nirind#619009, at_fldcd#619010, at_flphoto#619011, at_codmtr#619012, at_adr_3#619013, at_pays_iso#619014, at_adr_3a#619015, at_poids_maj#619016, at_codgestion#619017, at_art115#619018, at_taille#619019, at_taille_maj#619020, at_codetab_prod#619021, at_codsit_prod#619022, at_numdos_prod#619023, at_numper_prod#619024, at_numper_ori_prod#619025, at_ins#619026, at_ins_type#619027, at_ins_date#619028, at_ins_source#619029, at_stadmp#619030, at_datdmp#619031, at_alarmes#619032, at_email#619033, at_consent_sms#619034, at_dat_consent_sms#619035, at_datdcd#619036, at_flhlim#619037, at_dathlim#619038, at_codpershlim#619039, at_fldiff#619040, at_lisdest#619041, at_langue#619042, at_numcai_ft#619043, at_codtarifamc#619044, at_flgrve#619045, at_fladri#619046, at_datadri#619047, at_datf_mut#619048, at_comfac#619049, at_numdos_cloud#619050, at_nation#619051, at_titre#619052, at_titre_ass#619053, at_tiq_histoxml#619054, at_tiq_pnoliste#619055, at_codposnai#619056, at_insi#619057, at_insi_oid#619058, at_typconv#619059, at_crisec#619060, at_opereg#619061, at_flannuamc#619062, at_staipp#619063, at_pnonai#619064, at_codinseenai#619065, at_villenai#619066, at_piece_ident_pres#619067, at_dat_staipp#619068, at_datapcv#619069, at_num_apcv#619070, at_heuapcv#619071, at_numper_sec#619072, at_ins_heure#619073, at_persaprev#619074, at_tarif#619075, at_nomhl7#619076, at_numper_ori_oid#619077, at_comment#619078]

(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#620170, at_stapat#620171, at_prefix#620172, at_nompat#620173, at_pnopat#620174, at_njfpat#620175, at_datnai#620176, at_datnaiss#620177, at_sexe#620178, at_numper#620179, at_sigma#620180, at_verrou#620181, at_poids#620182, at_indcen#620183, at_numss#620184, at_antece#620185, at_adr_1#620186, at_adr_2#620187, at_codpos#620188, at_ville#620189, at_pays#620190, at_numcai#620191, at_nummut#620192, at_numcha#620193, at_telpri#620194, at_telbur#620195, at_telpor#620196, at_fax#620197, at_prefi2#620198, at_nomass#620199, at_pnoass#620200, at_njfass#620201, at_datass#620202, at_adr_1a#620203, at_adr_2a#620204, at_codpoa#620205, at_villea#620206, at_codmed#620207, at_datcss#620208, at_datf_d#620209, at_dat100#620210, at_numsir#620211, at_numssa#620212, at_codser#620213, at_rngnai#620214, at_natass#620215, at_numacc#620216, at_datacc#620217, at_typexo#620218, at_datmaj#620219, at_coduti#620220, at_flcmu#620221, at_qualss#620222, at_codref#620223, at_codregat#620224, at_codcaiat#620225, at_indvital#620226, at_conmut#620227, at_adhmut#620228, at_garmut#620229, at_numper_ori#620230, at_codrout#620231, at_domaine#620232, at_indtrai#620233, at_idhote#620234, at_codsts#620235, at_nirind#620236, at_fldcd#620237, at_flphoto#620238, at_codmtr#620239, at_adr_3#620240, at_pays_iso#620241, at_adr_3a#620242, at_poids_maj#620243, at_codgestion#620244, at_art115#620245, at_taille#620246, at_taille_maj#620247, at_codetab_prod#620248, at_codsit_prod#620249, at_numdos_prod#620250, at_numper_prod#620251, at_numper_ori_prod#620252, at_ins#620253, at_ins_type#620254, at_ins_date#620255, at_ins_source#620256, at_stadmp#620257, at_datdmp#620258, at_alarmes#620259, at_email#620260, at_consent_sms#620261, at_dat_consent_sms#620262, at_datdcd#620263, at_flhlim#620264, at_dathlim#620265, at_codpershlim#620266, at_fldiff#620267, at_lisdest#620268, at_langue#620269, at_numcai_ft#620270, at_codtarifamc#620271, at_flgrve#620272, at_fladri#620273, at_datadri#620274, at_datf_mut#620275, at_comfac#620276, at_numdos_cloud#620277, at_nation#620278, at_titre#620279, at_titre_ass#620280, at_tiq_histoxml#620281, at_tiq_pnoliste#620282, at_codposnai#620283, at_insi#620284, at_insi_oid#620285, at_typconv#620286, at_crisec#620287, at_opereg#620288, at_flannuamc#620289, at_staipp#620290, at_pnonai#620291, at_codinseenai#620292, at_villenai#620293, at_piece_ident_pres#620294, at_dat_staipp#620295, at_datapcv#620296, at_num_apcv#620297, at_heuapcv#620298, at_numper_sec#620299, at_ins_heure#620300, at_persaprev#620301, at_tarif#620302, at_nomhl7#620303, at_numper_ori_oid#620304, at_comment#620305]
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#620170, at_stapat#620171, at_prefix#620172, at_nompat#620173, at_pnopat#620174, at_njfpat#620175, at_datnai#620176, at_datnaiss#620177, at_sexe#620178, at_numper#620179, at_sigma#620180, at_verrou#620181, at_poids#620182, at_indcen#620183, at_numss#620184, at_antece#620185, at_adr_1#620186, at_adr_2#620187, at_codpos#620188, at_ville#620189, at_pays#620190, at_numcai#620191, at_nummut#620192, at_numcha#620193, at_telpri#620194, at_telbur#620195, at_telpor#620196, at_fax#620197, at_prefi2#620198, at_nomass#620199, at_pnoass#620200, at_njfass#620201, at_datass#620202, at_adr_1a#620203, at_adr_2a#620204, at_codpoa#620205, at_villea#620206, at_codmed#620207, at_datcss#620208, at_datf_d#620209, at_dat100#620210, at_numsir#620211, at_numssa#620212, at_codser#620213, at_rngnai#620214, at_natass#620215, at_numacc#620216, at_datacc#620217, at_typexo#620218, at_datmaj#620219, at_coduti#620220, at_flcmu#620221, at_qualss#620222, at_codref#620223, at_codregat#620224, at_codcaiat#620225, at_indvital#620226, at_conmut#620227, at_adhmut#620228, at_garmut#620229, at_numper_ori#620230, at_codrout#620231, at_domaine#620232, at_indtrai#620233, at_idhote#620234, at_codsts#620235, at_nirind#620236, at_fldcd#620237, at_flphoto#620238, at_codmtr#620239, at_adr_3#620240, at_pays_iso#620241, at_adr_3a#620242, at_poids_maj#620243, at_codgestion#620244, at_art115#620245, at_taille#620246, at_taille_maj#620247, at_codetab_prod#620248, at_codsit_prod#620249, at_numdos_prod#620250, at_numper_prod#620251, at_numper_ori_prod#620252, at_ins#620253, at_ins_type#620254, at_ins_date#620255, at_ins_source#620256, at_stadmp#620257, at_datdmp#620258, at_alarmes#620259, at_email#620260, at_consent_sms#620261, at_dat_consent_sms#620262, at_datdcd#620263, at_flhlim#620264, at_dathlim#620265, at_codpershlim#620266, at_fldiff#620267, at_lisdest#620268, at_langue#620269, at_numcai_ft#620270, at_codtarifamc#620271, at_flgrve#620272, at_fladri#620273, at_datadri#620274, at_datf_mut#620275, at_comfac#620276, at_numdos_cloud#620277, at_nation#620278, at_titre#620279, at_titre_ass#620280, at_tiq_histoxml#620281, at_tiq_pnoliste#620282, at_codposnai#620283, at_insi#620284, at_insi_oid#620285, at_typconv#620286, at_crisec#620287, at_opereg#620288, at_flannuamc#620289, at_staipp#620290, at_pnonai#620291, at_codinseenai#620292, at_villenai#620293, at_piece_ident_pres#620294, at_dat_staipp#620295, at_datapcv#620296, at_num_apcv#620297, at_heuapcv#620298, at_numper_sec#620299, at_ins_heure#620300, at_persaprev#620301, at_tarif#620302, at_nomhl7#620303, at_numper_ori_oid#620304, at_comment#620305]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos#620170)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos#620170)), MARX) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stapat#620171)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_stapat#620171)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefix#620172)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_prefix#620172)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nompat#620173)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nompat#620173)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnopat#620174)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pnopat#620174)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfpat#620175)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_njfpat#620175)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnai#620176)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datnai#620176)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnaiss#620177)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datnaiss#620177)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sexe#620178)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_sexe#620178)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper#620179)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper#620179)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sigma#620180)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_sigma#620180)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_verrou#620181)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_verrou#620181)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids#620182)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_poids#620182)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indcen#620183)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_indcen#620183)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numss#620184)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numss#620184)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_antece#620185)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_antece#620185)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1#620186)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1#620186)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2#620187)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2#620187)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpos#620188)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codpos#620188)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ville#620189)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ville#620189)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays#620190)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pays#620190)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai#620191)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai#620191)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nummut#620192)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nummut#620192)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcha#620193)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numcha#620193)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpri#620194)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_telpri#620194)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telbur#620195)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_telbur#620195)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpor#620196)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_telpor#620196)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fax#620197)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fax#620197)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefi2#620198)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_prefi2#620198)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomass#620199)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nomass#620199)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnoass#620200)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pnoass#620200)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfass#620201)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_njfass#620201)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datass#620202)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datass#620202)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1a#620203)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1a#620203)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2a#620204)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2a#620204)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpoa#620205)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codpoa#620205)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villea#620206)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_villea#620206)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmed#620207)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codmed#620207)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datcss#620208)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datcss#620208)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_d#620209)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_d#620209)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat100#620210)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dat100#620210)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numsir#620211)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numsir#620211)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numssa#620212)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numssa#620212)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codser#620213)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codser#620213)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_rngnai#620214)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_rngnai#620214)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_natass#620215)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_natass#620215)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numacc#620216)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numacc#620216)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datacc#620217)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datacc#620217)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typexo#620218)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_typexo#620218)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datmaj#620219)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datmaj#620219)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_coduti#620220)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_coduti#620220)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flcmu#620221)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flcmu#620221)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_qualss#620222)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_qualss#620222)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codref#620223)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codref#620223)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codregat#620224)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codregat#620224)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codcaiat#620225)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codcaiat#620225)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indvital#620226)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_indvital#620226)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_conmut#620227)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_conmut#620227)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adhmut#620228)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adhmut#620228)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_garmut#620229)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_garmut#620229)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori#620230)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori#620230)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codrout#620231)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codrout#620231)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_domaine#620232)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_domaine#620232)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indtrai#620233)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_indtrai#620233)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_idhote#620234)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_idhote#620234)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsts#620235)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codsts#620235)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nirind#620236)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nirind#620236)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldcd#620237)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fldcd#620237)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flphoto#620238)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flphoto#620238)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmtr#620239)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codmtr#620239)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3#620240)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3#620240)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays_iso#620241)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pays_iso#620241)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3a#620242)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3a#620242)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids_maj#620243)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_poids_maj#620243)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codgestion#620244)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codgestion#620244)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_art115#620245)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_art115#620245)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille#620246)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_taille#620246)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille_maj#620247)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_taille_maj#620247)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codetab_prod#620248)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codetab_prod#620248)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsit_prod#620249)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codsit_prod#620249)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_prod#620250)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_prod#620250)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_prod#620251)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_prod#620251)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_prod#620252)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_prod#620252)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins#620253)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins#620253)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_type#620254)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_type#620254)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_date#620255)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_date#620255)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_source#620256)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_source#620256)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stadmp#620257)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_stadmp#620257)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdmp#620258)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datdmp#620258)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_alarmes#620259)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_alarmes#620259)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_email#620260)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_email#620260)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_consent_sms#620261)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_consent_sms#620261)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_consent_sms#620262)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_consent_sms#620262)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdcd#620263)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datdcd#620263)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flhlim#620264)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flhlim#620264)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dathlim#620265)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dathlim#620265)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpershlim#620266)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codpershlim#620266)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldiff#620267)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fldiff#620267)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_lisdest#620268)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_lisdest#620268)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_langue#620269)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_langue#620269)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai_ft#620270)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai_ft#620270)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codtarifamc#620271)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codtarifamc#620271)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flgrve#620272)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flgrve#620272)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fladri#620273)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_fladri#620273)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datadri#620274)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datadri#620274)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_mut#620275)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_mut#620275)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comfac#620276)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_comfac#620276)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_cloud#620277)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_cloud#620277)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nation#620278)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nation#620278)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre#620279)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_titre#620279)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre_ass#620280)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_titre_ass#620280)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_histoxml#620281)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_histoxml#620281)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_pnoliste#620282)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_pnoliste#620282)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codposnai#620283)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codposnai#620283)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi#620284)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_insi#620284)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi_oid#620285)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_insi_oid#620285)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typconv#620286)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_typconv#620286)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_crisec#620287)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_crisec#620287)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_opereg#620288)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_opereg#620288)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flannuamc#620289)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_flannuamc#620289)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_staipp#620290)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_staipp#620290)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnonai#620291)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_pnonai#620291)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codinseenai#620292)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_codinseenai#620292)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villenai#620293)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_villenai#620293)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_piece_ident_pres#620294)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_piece_ident_pres#620294)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_staipp#620295)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_staipp#620295)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datapcv#620296)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_datapcv#620296)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_num_apcv#620297)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_num_apcv#620297)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_heuapcv#620298)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_heuapcv#620298)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_sec#620299)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_sec#620299)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_heure#620300)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_heure#620300)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_persaprev#620301)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_persaprev#620301)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tarif#620302)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_tarif#620302)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomhl7#620303)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_nomhl7#620303)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_oid#620304)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_oid#620304)), MARX) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comment#620305)), MARX)) THEN false ELSE Contains(str_remove_accent(upper(at_comment#620305)), 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#620170, at_stapat#620171, at_prefix#620172, at_nompat#620173, at_pnopat#620174, at_njfpat#620175, at_datnai#620176, at_datnaiss#620177, at_sexe#620178, at_numper#620179, at_sigma#620180, at_verrou#620181, at_poids#620182, at_indcen#620183, at_numss#620184, at_antece#620185, at_adr_1#620186, at_adr_2#620187, at_codpos#620188, at_ville#620189, at_pays#620190, at_numcai#620191, at_nummut#620192, at_numcha#620193, at_telpri#620194, at_telbur#620195, at_telpor#620196, at_fax#620197, at_prefi2#620198, at_nomass#620199, at_pnoass#620200, at_njfass#620201, at_datass#620202, at_adr_1a#620203, at_adr_2a#620204, at_codpoa#620205, at_villea#620206, at_codmed#620207, at_datcss#620208, at_datf_d#620209, at_dat100#620210, at_numsir#620211, at_numssa#620212, at_codser#620213, at_rngnai#620214, at_natass#620215, at_numacc#620216, at_datacc#620217, at_typexo#620218, at_datmaj#620219, at_coduti#620220, at_flcmu#620221, at_qualss#620222, at_codref#620223, at_codregat#620224, at_codcaiat#620225, at_indvital#620226, at_conmut#620227, at_adhmut#620228, at_garmut#620229, at_numper_ori#620230, at_codrout#620231, at_domaine#620232, at_indtrai#620233, at_idhote#620234, at_codsts#620235, at_nirind#620236, at_fldcd#620237, at_flphoto#620238, at_codmtr#620239, at_adr_3#620240, at_pays_iso#620241, at_adr_3a#620242, at_poids_maj#620243, at_codgestion#620244, at_art115#620245, at_taille#620246, at_taille_maj#620247, at_codetab_prod#620248, at_codsit_prod#620249, at_numdos_prod#620250, at_numper_prod#620251, at_numper_ori_prod#620252, at_ins#620253, at_ins_type#620254, at_ins_date#620255, at_ins_source#620256, at_stadmp#620257, at_datdmp#620258, at_alarmes#620259, at_email#620260, at_consent_sms#620261, at_dat_consent_sms#620262, at_datdcd#620263, at_flhlim#620264, at_dathlim#620265, at_codpershlim#620266, at_fldiff#620267, at_lisdest#620268, at_langue#620269, at_numcai_ft#620270, at_codtarifamc#620271, at_flgrve#620272, at_fladri#620273, at_datadri#620274, at_datf_mut#620275, at_comfac#620276, at_numdos_cloud#620277, at_nation#620278, at_titre#620279, at_titre_ass#620280, at_tiq_histoxml#620281, at_tiq_pnoliste#620282, at_codposnai#620283, at_insi#620284, at_insi_oid#620285, at_typconv#620286, at_crisec#620287, at_opereg#620288, at_flannuamc#620289, at_staipp#620290, at_pnonai#620291, at_codinseenai#620292, at_villenai#620293, at_piece_ident_pres#620294, at_dat_staipp#620295, at_datapcv#620296, at_num_apcv#620297, at_heuapcv#620298, at_numper_sec#620299, at_ins_heure#620300, at_persaprev#620301, at_tarif#620302, at_nomhl7#620303, at_numper_ori_oid#620304, at_comment#620305]

(7) Union

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

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

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

(11) HashAggregate [codegen id : 2]
Input [1]: [count#623319L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#623041L]
Results [1]: [count(1)#623041L AS count#623042L]

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

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

(14) HashAggregate
Input [1]: [count#623319L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#623041L]
Results [1]: [count(1)#623041L AS count#623042L]

(15) AdaptiveSparkPlan
Output [1]: [count#623042L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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