hdh-spark-job - Details for Query 1480

Submitted Time: 2026/10/23 13:29:43
Duration: 15 s
Succeeded Jobs: 1474 1479

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

AdaptiveSparkPlan isFinalPlan=true

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

WholeStageCodegen (2)

Exchange SinglePartition, ENSURE_REQUIREMENTS, [plan_id=40622]

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

WholeStageCodegen (1)

Union

Project

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos#761784)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos#761784)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stapat#761785)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_stapat#761785)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefix#761786)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_prefix#761786)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nompat#761787)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nompat#761787)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnopat#761788)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pnopat#761788)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfpat#761789)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_njfpat#761789)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnai#761790)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datnai#761790)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnaiss#761791)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datnaiss#761791)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sexe#761792)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_sexe#761792)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper#761793)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper#761793)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sigma#761794)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_sigma#761794)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_verrou#761795)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_verrou#761795)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids#761796)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_poids#761796)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indcen#761797)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_indcen#761797)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numss#761798)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numss#761798)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_antece#761799)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_antece#761799)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1#761800)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1#761800)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2#761801)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2#761801)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpos#761802)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codpos#761802)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ville#761803)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ville#761803)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays#761804)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pays#761804)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai#761805)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai#761805)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nummut#761806)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nummut#761806)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcha#761807)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numcha#761807)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpri#761808)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_telpri#761808)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telbur#761809)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_telbur#761809)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpor#761810)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_telpor#761810)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fax#761811)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fax#761811)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefi2#761812)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_prefi2#761812)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomass#761813)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nomass#761813)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnoass#761814)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pnoass#761814)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfass#761815)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_njfass#761815)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datass#761816)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datass#761816)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1a#761817)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1a#761817)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2a#761818)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2a#761818)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpoa#761819)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codpoa#761819)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villea#761820)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_villea#761820)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmed#761821)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codmed#761821)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datcss#761822)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datcss#761822)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_d#761823)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_d#761823)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat100#761824)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dat100#761824)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numsir#761825)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numsir#761825)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numssa#761826)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numssa#761826)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codser#761827)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codser#761827)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_rngnai#761828)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_rngnai#761828)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_natass#761829)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_natass#761829)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numacc#761830)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numacc#761830)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datacc#761831)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datacc#761831)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typexo#761832)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_typexo#761832)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datmaj#761833)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datmaj#761833)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_coduti#761834)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_coduti#761834)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flcmu#761835)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flcmu#761835)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_qualss#761836)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_qualss#761836)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codref#761837)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codref#761837)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codregat#761838)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codregat#761838)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codcaiat#761839)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codcaiat#761839)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indvital#761840)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_indvital#761840)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_conmut#761841)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_conmut#761841)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adhmut#761842)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adhmut#761842)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_garmut#761843)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_garmut#761843)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori#761844)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori#761844)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codrout#761845)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codrout#761845)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_domaine#761846)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_domaine#761846)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indtrai#761847)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_indtrai#761847)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_idhote#761848)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_idhote#761848)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsts#761849)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codsts#761849)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nirind#761850)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nirind#761850)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldcd#761851)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fldcd#761851)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flphoto#761852)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flphoto#761852)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmtr#761853)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codmtr#761853)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3#761854)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3#761854)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays_iso#761855)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pays_iso#761855)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3a#761856)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3a#761856)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids_maj#761857)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_poids_maj#761857)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codgestion#761858)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codgestion#761858)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_art115#761859)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_art115#761859)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille#761860)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_taille#761860)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille_maj#761861)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_taille_maj#761861)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codetab_prod#761862)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codetab_prod#761862)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsit_prod#761863)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codsit_prod#761863)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_prod#761864)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_prod#761864)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_prod#761865)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_prod#761865)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_prod#761866)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_prod#761866)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins#761867)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins#761867)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_type#761868)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_type#761868)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_date#761869)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_date#761869)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_source#761870)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_source#761870)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stadmp#761871)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_stadmp#761871)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdmp#761872)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datdmp#761872)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_alarmes#761873)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_alarmes#761873)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_email#761874)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_email#761874)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_consent_sms#761875)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_consent_sms#761875)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_consent_sms#761876)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_consent_sms#761876)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdcd#761877)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datdcd#761877)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flhlim#761878)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flhlim#761878)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dathlim#761879)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dathlim#761879)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpershlim#761880)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codpershlim#761880)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldiff#761881)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fldiff#761881)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_lisdest#761882)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_lisdest#761882)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_langue#761883)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_langue#761883)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai_ft#761884)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai_ft#761884)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codtarifamc#761885)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codtarifamc#761885)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flgrve#761886)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flgrve#761886)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fladri#761887)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fladri#761887)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datadri#761888)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datadri#761888)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_mut#761889)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_mut#761889)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comfac#761890)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_comfac#761890)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_cloud#761891)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_cloud#761891)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nation#761892)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nation#761892)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre#761893)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_titre#761893)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre_ass#761894)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_titre_ass#761894)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_histoxml#761895)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_histoxml#761895)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_pnoliste#761896)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_pnoliste#761896)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codposnai#761897)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codposnai#761897)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi#761898)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_insi#761898)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi_oid#761899)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_insi_oid#761899)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typconv#761900)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_typconv#761900)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_crisec#761901)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_crisec#761901)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_opereg#761902)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_opereg#761902)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flannuamc#761903)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flannuamc#761903)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_staipp#761904)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_staipp#761904)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnonai#761905)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pnonai#761905)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codinseenai#761906)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codinseenai#761906)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villenai#761907)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_villenai#761907)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_piece_ident_pres#761908)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_piece_ident_pres#761908)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_staipp#761909)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_staipp#761909)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datapcv#761910)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datapcv#761910)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_num_apcv#761911)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_num_apcv#761911)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_heuapcv#761912)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_heuapcv#761912)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_sec#761913)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_sec#761913)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_heure#761914)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_heure#761914)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_persaprev#761915)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_persaprev#761915)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tarif#761916)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_tarif#761916)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomhl7#761917)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nomhl7#761917)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_oid#761918)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_oid#761918)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comment#761919)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_comment#761919)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_A))), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_A))), MAIN) END)

Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore"."h_patien") as x) [numPartitions=1] [at_numdos#761784,at_stapat#761785,at_prefix#761786,at_nompat#761787,at_pnopat#761788,at_njfpat#761789,at_datnai#761790,at_datnaiss#761791,at_sexe#761792,at_numper#761793,at_sigma#761794,at_verrou#761795,at_poids#761796,at_indcen#761797,at_numss#761798,at_antece#761799,at_adr_1#761800,at_adr_2#761801,at_codpos#761802,at_ville#761803,at_pays#761804,at_numcai#761805,at_nummut#761806,at_numcha#761807,... 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#764077)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos#764077)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stapat#764078)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_stapat#764078)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefix#764079)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_prefix#764079)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nompat#764080)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nompat#764080)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnopat#764081)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pnopat#764081)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfpat#764082)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_njfpat#764082)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnai#764083)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datnai#764083)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnaiss#764084)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datnaiss#764084)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sexe#764085)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_sexe#764085)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper#764086)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper#764086)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sigma#764087)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_sigma#764087)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_verrou#764088)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_verrou#764088)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids#764089)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_poids#764089)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indcen#764090)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_indcen#764090)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numss#764091)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numss#764091)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_antece#764092)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_antece#764092)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1#764093)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1#764093)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2#764094)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2#764094)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpos#764095)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codpos#764095)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ville#764096)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ville#764096)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays#764097)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pays#764097)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai#764098)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai#764098)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nummut#764099)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nummut#764099)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcha#764100)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numcha#764100)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpri#764101)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_telpri#764101)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telbur#764102)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_telbur#764102)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpor#764103)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_telpor#764103)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fax#764104)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fax#764104)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefi2#764105)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_prefi2#764105)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomass#764106)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nomass#764106)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnoass#764107)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pnoass#764107)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfass#764108)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_njfass#764108)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datass#764109)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datass#764109)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1a#764110)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1a#764110)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2a#764111)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2a#764111)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpoa#764112)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codpoa#764112)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villea#764113)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_villea#764113)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmed#764114)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codmed#764114)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datcss#764115)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datcss#764115)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_d#764116)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_d#764116)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat100#764117)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dat100#764117)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numsir#764118)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numsir#764118)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numssa#764119)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numssa#764119)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codser#764120)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codser#764120)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_rngnai#764121)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_rngnai#764121)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_natass#764122)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_natass#764122)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numacc#764123)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numacc#764123)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datacc#764124)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datacc#764124)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typexo#764125)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_typexo#764125)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datmaj#764126)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datmaj#764126)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_coduti#764127)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_coduti#764127)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flcmu#764128)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flcmu#764128)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_qualss#764129)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_qualss#764129)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codref#764130)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codref#764130)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codregat#764131)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codregat#764131)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codcaiat#764132)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codcaiat#764132)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indvital#764133)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_indvital#764133)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_conmut#764134)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_conmut#764134)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adhmut#764135)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adhmut#764135)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_garmut#764136)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_garmut#764136)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori#764137)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori#764137)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codrout#764138)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codrout#764138)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_domaine#764139)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_domaine#764139)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indtrai#764140)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_indtrai#764140)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_idhote#764141)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_idhote#764141)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsts#764142)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codsts#764142)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nirind#764143)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nirind#764143)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldcd#764144)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fldcd#764144)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flphoto#764145)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flphoto#764145)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmtr#764146)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codmtr#764146)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3#764147)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3#764147)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays_iso#764148)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pays_iso#764148)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3a#764149)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3a#764149)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids_maj#764150)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_poids_maj#764150)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codgestion#764151)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codgestion#764151)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_art115#764152)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_art115#764152)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille#764153)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_taille#764153)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille_maj#764154)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_taille_maj#764154)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codetab_prod#764155)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codetab_prod#764155)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsit_prod#764156)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codsit_prod#764156)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_prod#764157)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_prod#764157)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_prod#764158)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_prod#764158)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_prod#764159)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_prod#764159)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins#764160)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins#764160)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_type#764161)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_type#764161)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_date#764162)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_date#764162)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_source#764163)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_source#764163)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stadmp#764164)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_stadmp#764164)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdmp#764165)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datdmp#764165)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_alarmes#764166)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_alarmes#764166)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_email#764167)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_email#764167)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_consent_sms#764168)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_consent_sms#764168)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_consent_sms#764169)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_consent_sms#764169)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdcd#764170)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datdcd#764170)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flhlim#764171)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flhlim#764171)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dathlim#764172)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dathlim#764172)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpershlim#764173)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codpershlim#764173)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldiff#764174)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fldiff#764174)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_lisdest#764175)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_lisdest#764175)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_langue#764176)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_langue#764176)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai_ft#764177)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai_ft#764177)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codtarifamc#764178)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codtarifamc#764178)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flgrve#764179)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flgrve#764179)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fladri#764180)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fladri#764180)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datadri#764181)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datadri#764181)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_mut#764182)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_mut#764182)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comfac#764183)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_comfac#764183)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_cloud#764184)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_cloud#764184)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nation#764185)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nation#764185)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre#764186)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_titre#764186)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre_ass#764187)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_titre_ass#764187)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_histoxml#764188)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_histoxml#764188)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_pnoliste#764189)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_pnoliste#764189)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codposnai#764190)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codposnai#764190)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi#764191)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_insi#764191)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi_oid#764192)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_insi_oid#764192)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typconv#764193)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_typconv#764193)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_crisec#764194)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_crisec#764194)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_opereg#764195)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_opereg#764195)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flannuamc#764196)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flannuamc#764196)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_staipp#764197)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_staipp#764197)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnonai#764198)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pnonai#764198)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codinseenai#764199)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codinseenai#764199)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villenai#764200)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_villenai#764200)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_piece_ident_pres#764201)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_piece_ident_pres#764201)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_staipp#764202)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_staipp#764202)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datapcv#764203)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datapcv#764203)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_num_apcv#764204)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_num_apcv#764204)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_heuapcv#764205)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_heuapcv#764205)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_sec#764206)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_sec#764206)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_heure#764207)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_heure#764207)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_persaprev#764208)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_persaprev#764208)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tarif#764209)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_tarif#764209)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomhl7#764210)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nomhl7#764210)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_oid#764211)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_oid#764211)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comment#764212)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_comment#764212)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_B))), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_B))), MAIN) END)

Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore2"."h_patien") as x) [numPartitions=1] [at_numdos#764077,at_stapat#764078,at_prefix#764079,at_nompat#764080,at_pnopat#764081,at_njfpat#764082,at_datnai#764083,at_datnaiss#764084,at_sexe#764085,at_numper#764086,at_sigma#764087,at_verrou#764088,at_poids#764089,at_indcen#764090,at_numss#764091,at_antece#764092,at_adr_1#764093,at_adr_2#764094,at_codpos#764095,at_ville#764096,at_pays#764097,at_numcai#764098,at_nummut#764099,at_numcha#764100,... 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#761784, at_stapat#761785, at_prefix#761786, at_nompat#761787, at_pnopat#761788, at_njfpat#761789, at_datnai#761790, at_datnaiss#761791, at_sexe#761792, at_numper#761793, at_sigma#761794, at_verrou#761795, at_poids#761796, at_indcen#761797, at_numss#761798, at_antece#761799, at_adr_1#761800, at_adr_2#761801, at_codpos#761802, at_ville#761803, at_pays#761804, at_numcai#761805, at_nummut#761806, at_numcha#761807, at_telpri#761808, at_telbur#761809, at_telpor#761810, at_fax#761811, at_prefi2#761812, at_nomass#761813, at_pnoass#761814, at_njfass#761815, at_datass#761816, at_adr_1a#761817, at_adr_2a#761818, at_codpoa#761819, at_villea#761820, at_codmed#761821, at_datcss#761822, at_datf_d#761823, at_dat100#761824, at_numsir#761825, at_numssa#761826, at_codser#761827, at_rngnai#761828, at_natass#761829, at_numacc#761830, at_datacc#761831, at_typexo#761832, at_datmaj#761833, at_coduti#761834, at_flcmu#761835, at_qualss#761836, at_codref#761837, at_codregat#761838, at_codcaiat#761839, at_indvital#761840, at_conmut#761841, at_adhmut#761842, at_garmut#761843, at_numper_ori#761844, at_codrout#761845, at_domaine#761846, at_indtrai#761847, at_idhote#761848, at_codsts#761849, at_nirind#761850, at_fldcd#761851, at_flphoto#761852, at_codmtr#761853, at_adr_3#761854, at_pays_iso#761855, at_adr_3a#761856, at_poids_maj#761857, at_codgestion#761858, at_art115#761859, at_taille#761860, at_taille_maj#761861, at_codetab_prod#761862, at_codsit_prod#761863, at_numdos_prod#761864, at_numper_prod#761865, at_numper_ori_prod#761866, at_ins#761867, at_ins_type#761868, at_ins_date#761869, at_ins_source#761870, at_stadmp#761871, at_datdmp#761872, at_alarmes#761873, at_email#761874, at_consent_sms#761875, at_dat_consent_sms#761876, at_datdcd#761877, at_flhlim#761878, at_dathlim#761879, at_codpershlim#761880, at_fldiff#761881, at_lisdest#761882, at_langue#761883, at_numcai_ft#761884, at_codtarifamc#761885, at_flgrve#761886, at_fladri#761887, at_datadri#761888, at_datf_mut#761889, at_comfac#761890, at_numdos_cloud#761891, at_nation#761892, at_titre#761893, at_titre_ass#761894, at_tiq_histoxml#761895, at_tiq_pnoliste#761896, at_codposnai#761897, at_insi#761898, at_insi_oid#761899, at_typconv#761900, at_crisec#761901, at_opereg#761902, at_flannuamc#761903, at_staipp#761904, at_pnonai#761905, at_codinseenai#761906, at_villenai#761907, at_piece_ident_pres#761908, at_dat_staipp#761909, at_datapcv#761910, at_num_apcv#761911, at_heuapcv#761912, at_numper_sec#761913, at_ins_heure#761914, at_persaprev#761915, at_tarif#761916, at_nomhl7#761917, at_numper_ori_oid#761918, at_comment#761919]
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#761784, at_stapat#761785, at_prefix#761786, at_nompat#761787, at_pnopat#761788, at_njfpat#761789, at_datnai#761790, at_datnaiss#761791, at_sexe#761792, at_numper#761793, at_sigma#761794, at_verrou#761795, at_poids#761796, at_indcen#761797, at_numss#761798, at_antece#761799, at_adr_1#761800, at_adr_2#761801, at_codpos#761802, at_ville#761803, at_pays#761804, at_numcai#761805, at_nummut#761806, at_numcha#761807, at_telpri#761808, at_telbur#761809, at_telpor#761810, at_fax#761811, at_prefi2#761812, at_nomass#761813, at_pnoass#761814, at_njfass#761815, at_datass#761816, at_adr_1a#761817, at_adr_2a#761818, at_codpoa#761819, at_villea#761820, at_codmed#761821, at_datcss#761822, at_datf_d#761823, at_dat100#761824, at_numsir#761825, at_numssa#761826, at_codser#761827, at_rngnai#761828, at_natass#761829, at_numacc#761830, at_datacc#761831, at_typexo#761832, at_datmaj#761833, at_coduti#761834, at_flcmu#761835, at_qualss#761836, at_codref#761837, at_codregat#761838, at_codcaiat#761839, at_indvital#761840, at_conmut#761841, at_adhmut#761842, at_garmut#761843, at_numper_ori#761844, at_codrout#761845, at_domaine#761846, at_indtrai#761847, at_idhote#761848, at_codsts#761849, at_nirind#761850, at_fldcd#761851, at_flphoto#761852, at_codmtr#761853, at_adr_3#761854, at_pays_iso#761855, at_adr_3a#761856, at_poids_maj#761857, at_codgestion#761858, at_art115#761859, at_taille#761860, at_taille_maj#761861, at_codetab_prod#761862, at_codsit_prod#761863, at_numdos_prod#761864, at_numper_prod#761865, at_numper_ori_prod#761866, at_ins#761867, at_ins_type#761868, at_ins_date#761869, at_ins_source#761870, at_stadmp#761871, at_datdmp#761872, at_alarmes#761873, at_email#761874, at_consent_sms#761875, at_dat_consent_sms#761876, at_datdcd#761877, at_flhlim#761878, at_dathlim#761879, at_codpershlim#761880, at_fldiff#761881, at_lisdest#761882, at_langue#761883, at_numcai_ft#761884, at_codtarifamc#761885, at_flgrve#761886, at_fladri#761887, at_datadri#761888, at_datf_mut#761889, at_comfac#761890, at_numdos_cloud#761891, at_nation#761892, at_titre#761893, at_titre_ass#761894, at_tiq_histoxml#761895, at_tiq_pnoliste#761896, at_codposnai#761897, at_insi#761898, at_insi_oid#761899, at_typconv#761900, at_crisec#761901, at_opereg#761902, at_flannuamc#761903, at_staipp#761904, at_pnonai#761905, at_codinseenai#761906, at_villenai#761907, at_piece_ident_pres#761908, at_dat_staipp#761909, at_datapcv#761910, at_num_apcv#761911, at_heuapcv#761912, at_numper_sec#761913, at_ins_heure#761914, at_persaprev#761915, at_tarif#761916, at_nomhl7#761917, at_numper_ori_oid#761918, at_comment#761919]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos#761784)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos#761784)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stapat#761785)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_stapat#761785)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefix#761786)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_prefix#761786)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nompat#761787)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nompat#761787)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnopat#761788)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pnopat#761788)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfpat#761789)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_njfpat#761789)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnai#761790)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datnai#761790)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnaiss#761791)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datnaiss#761791)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sexe#761792)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_sexe#761792)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper#761793)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper#761793)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sigma#761794)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_sigma#761794)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_verrou#761795)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_verrou#761795)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids#761796)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_poids#761796)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indcen#761797)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_indcen#761797)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numss#761798)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numss#761798)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_antece#761799)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_antece#761799)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1#761800)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1#761800)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2#761801)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2#761801)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpos#761802)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codpos#761802)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ville#761803)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ville#761803)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays#761804)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pays#761804)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai#761805)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai#761805)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nummut#761806)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nummut#761806)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcha#761807)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numcha#761807)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpri#761808)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_telpri#761808)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telbur#761809)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_telbur#761809)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpor#761810)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_telpor#761810)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fax#761811)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fax#761811)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefi2#761812)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_prefi2#761812)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomass#761813)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nomass#761813)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnoass#761814)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pnoass#761814)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfass#761815)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_njfass#761815)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datass#761816)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datass#761816)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1a#761817)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1a#761817)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2a#761818)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2a#761818)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpoa#761819)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codpoa#761819)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villea#761820)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_villea#761820)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmed#761821)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codmed#761821)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datcss#761822)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datcss#761822)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_d#761823)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_d#761823)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat100#761824)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dat100#761824)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numsir#761825)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numsir#761825)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numssa#761826)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numssa#761826)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codser#761827)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codser#761827)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_rngnai#761828)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_rngnai#761828)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_natass#761829)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_natass#761829)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numacc#761830)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numacc#761830)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datacc#761831)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datacc#761831)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typexo#761832)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_typexo#761832)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datmaj#761833)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datmaj#761833)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_coduti#761834)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_coduti#761834)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flcmu#761835)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flcmu#761835)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_qualss#761836)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_qualss#761836)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codref#761837)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codref#761837)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codregat#761838)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codregat#761838)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codcaiat#761839)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codcaiat#761839)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indvital#761840)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_indvital#761840)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_conmut#761841)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_conmut#761841)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adhmut#761842)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adhmut#761842)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_garmut#761843)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_garmut#761843)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori#761844)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori#761844)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codrout#761845)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codrout#761845)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_domaine#761846)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_domaine#761846)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indtrai#761847)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_indtrai#761847)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_idhote#761848)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_idhote#761848)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsts#761849)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codsts#761849)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nirind#761850)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nirind#761850)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldcd#761851)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fldcd#761851)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flphoto#761852)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flphoto#761852)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmtr#761853)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codmtr#761853)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3#761854)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3#761854)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays_iso#761855)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pays_iso#761855)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3a#761856)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3a#761856)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids_maj#761857)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_poids_maj#761857)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codgestion#761858)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codgestion#761858)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_art115#761859)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_art115#761859)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille#761860)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_taille#761860)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille_maj#761861)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_taille_maj#761861)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codetab_prod#761862)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codetab_prod#761862)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsit_prod#761863)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codsit_prod#761863)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_prod#761864)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_prod#761864)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_prod#761865)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_prod#761865)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_prod#761866)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_prod#761866)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins#761867)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins#761867)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_type#761868)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_type#761868)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_date#761869)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_date#761869)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_source#761870)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_source#761870)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stadmp#761871)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_stadmp#761871)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdmp#761872)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datdmp#761872)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_alarmes#761873)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_alarmes#761873)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_email#761874)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_email#761874)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_consent_sms#761875)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_consent_sms#761875)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_consent_sms#761876)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_consent_sms#761876)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdcd#761877)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datdcd#761877)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flhlim#761878)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flhlim#761878)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dathlim#761879)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dathlim#761879)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpershlim#761880)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codpershlim#761880)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldiff#761881)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fldiff#761881)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_lisdest#761882)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_lisdest#761882)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_langue#761883)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_langue#761883)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai_ft#761884)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai_ft#761884)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codtarifamc#761885)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codtarifamc#761885)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flgrve#761886)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flgrve#761886)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fladri#761887)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fladri#761887)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datadri#761888)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datadri#761888)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_mut#761889)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_mut#761889)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comfac#761890)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_comfac#761890)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_cloud#761891)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_cloud#761891)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nation#761892)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nation#761892)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre#761893)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_titre#761893)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre_ass#761894)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_titre_ass#761894)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_histoxml#761895)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_histoxml#761895)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_pnoliste#761896)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_pnoliste#761896)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codposnai#761897)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codposnai#761897)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi#761898)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_insi#761898)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi_oid#761899)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_insi_oid#761899)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typconv#761900)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_typconv#761900)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_crisec#761901)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_crisec#761901)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_opereg#761902)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_opereg#761902)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flannuamc#761903)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flannuamc#761903)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_staipp#761904)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_staipp#761904)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnonai#761905)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pnonai#761905)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codinseenai#761906)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codinseenai#761906)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villenai#761907)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_villenai#761907)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_piece_ident_pres#761908)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_piece_ident_pres#761908)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_staipp#761909)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_staipp#761909)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datapcv#761910)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datapcv#761910)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_num_apcv#761911)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_num_apcv#761911)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_heuapcv#761912)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_heuapcv#761912)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_sec#761913)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_sec#761913)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_heure#761914)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_heure#761914)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_persaprev#761915)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_persaprev#761915)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tarif#761916)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_tarif#761916)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomhl7#761917)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nomhl7#761917)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_oid#761918)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_oid#761918)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comment#761919)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_comment#761919)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_A))), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_A))), MAIN) END)

(3) Project
Output: []
Input [136]: [at_numdos#761784, at_stapat#761785, at_prefix#761786, at_nompat#761787, at_pnopat#761788, at_njfpat#761789, at_datnai#761790, at_datnaiss#761791, at_sexe#761792, at_numper#761793, at_sigma#761794, at_verrou#761795, at_poids#761796, at_indcen#761797, at_numss#761798, at_antece#761799, at_adr_1#761800, at_adr_2#761801, at_codpos#761802, at_ville#761803, at_pays#761804, at_numcai#761805, at_nummut#761806, at_numcha#761807, at_telpri#761808, at_telbur#761809, at_telpor#761810, at_fax#761811, at_prefi2#761812, at_nomass#761813, at_pnoass#761814, at_njfass#761815, at_datass#761816, at_adr_1a#761817, at_adr_2a#761818, at_codpoa#761819, at_villea#761820, at_codmed#761821, at_datcss#761822, at_datf_d#761823, at_dat100#761824, at_numsir#761825, at_numssa#761826, at_codser#761827, at_rngnai#761828, at_natass#761829, at_numacc#761830, at_datacc#761831, at_typexo#761832, at_datmaj#761833, at_coduti#761834, at_flcmu#761835, at_qualss#761836, at_codref#761837, at_codregat#761838, at_codcaiat#761839, at_indvital#761840, at_conmut#761841, at_adhmut#761842, at_garmut#761843, at_numper_ori#761844, at_codrout#761845, at_domaine#761846, at_indtrai#761847, at_idhote#761848, at_codsts#761849, at_nirind#761850, at_fldcd#761851, at_flphoto#761852, at_codmtr#761853, at_adr_3#761854, at_pays_iso#761855, at_adr_3a#761856, at_poids_maj#761857, at_codgestion#761858, at_art115#761859, at_taille#761860, at_taille_maj#761861, at_codetab_prod#761862, at_codsit_prod#761863, at_numdos_prod#761864, at_numper_prod#761865, at_numper_ori_prod#761866, at_ins#761867, at_ins_type#761868, at_ins_date#761869, at_ins_source#761870, at_stadmp#761871, at_datdmp#761872, at_alarmes#761873, at_email#761874, at_consent_sms#761875, at_dat_consent_sms#761876, at_datdcd#761877, at_flhlim#761878, at_dathlim#761879, at_codpershlim#761880, at_fldiff#761881, at_lisdest#761882, at_langue#761883, at_numcai_ft#761884, at_codtarifamc#761885, at_flgrve#761886, at_fladri#761887, at_datadri#761888, at_datf_mut#761889, at_comfac#761890, at_numdos_cloud#761891, at_nation#761892, at_titre#761893, at_titre_ass#761894, at_tiq_histoxml#761895, at_tiq_pnoliste#761896, at_codposnai#761897, at_insi#761898, at_insi_oid#761899, at_typconv#761900, at_crisec#761901, at_opereg#761902, at_flannuamc#761903, at_staipp#761904, at_pnonai#761905, at_codinseenai#761906, at_villenai#761907, at_piece_ident_pres#761908, at_dat_staipp#761909, at_datapcv#761910, at_num_apcv#761911, at_heuapcv#761912, at_numper_sec#761913, at_ins_heure#761914, at_persaprev#761915, at_tarif#761916, at_nomhl7#761917, at_numper_ori_oid#761918, at_comment#761919]

(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#764077, at_stapat#764078, at_prefix#764079, at_nompat#764080, at_pnopat#764081, at_njfpat#764082, at_datnai#764083, at_datnaiss#764084, at_sexe#764085, at_numper#764086, at_sigma#764087, at_verrou#764088, at_poids#764089, at_indcen#764090, at_numss#764091, at_antece#764092, at_adr_1#764093, at_adr_2#764094, at_codpos#764095, at_ville#764096, at_pays#764097, at_numcai#764098, at_nummut#764099, at_numcha#764100, at_telpri#764101, at_telbur#764102, at_telpor#764103, at_fax#764104, at_prefi2#764105, at_nomass#764106, at_pnoass#764107, at_njfass#764108, at_datass#764109, at_adr_1a#764110, at_adr_2a#764111, at_codpoa#764112, at_villea#764113, at_codmed#764114, at_datcss#764115, at_datf_d#764116, at_dat100#764117, at_numsir#764118, at_numssa#764119, at_codser#764120, at_rngnai#764121, at_natass#764122, at_numacc#764123, at_datacc#764124, at_typexo#764125, at_datmaj#764126, at_coduti#764127, at_flcmu#764128, at_qualss#764129, at_codref#764130, at_codregat#764131, at_codcaiat#764132, at_indvital#764133, at_conmut#764134, at_adhmut#764135, at_garmut#764136, at_numper_ori#764137, at_codrout#764138, at_domaine#764139, at_indtrai#764140, at_idhote#764141, at_codsts#764142, at_nirind#764143, at_fldcd#764144, at_flphoto#764145, at_codmtr#764146, at_adr_3#764147, at_pays_iso#764148, at_adr_3a#764149, at_poids_maj#764150, at_codgestion#764151, at_art115#764152, at_taille#764153, at_taille_maj#764154, at_codetab_prod#764155, at_codsit_prod#764156, at_numdos_prod#764157, at_numper_prod#764158, at_numper_ori_prod#764159, at_ins#764160, at_ins_type#764161, at_ins_date#764162, at_ins_source#764163, at_stadmp#764164, at_datdmp#764165, at_alarmes#764166, at_email#764167, at_consent_sms#764168, at_dat_consent_sms#764169, at_datdcd#764170, at_flhlim#764171, at_dathlim#764172, at_codpershlim#764173, at_fldiff#764174, at_lisdest#764175, at_langue#764176, at_numcai_ft#764177, at_codtarifamc#764178, at_flgrve#764179, at_fladri#764180, at_datadri#764181, at_datf_mut#764182, at_comfac#764183, at_numdos_cloud#764184, at_nation#764185, at_titre#764186, at_titre_ass#764187, at_tiq_histoxml#764188, at_tiq_pnoliste#764189, at_codposnai#764190, at_insi#764191, at_insi_oid#764192, at_typconv#764193, at_crisec#764194, at_opereg#764195, at_flannuamc#764196, at_staipp#764197, at_pnonai#764198, at_codinseenai#764199, at_villenai#764200, at_piece_ident_pres#764201, at_dat_staipp#764202, at_datapcv#764203, at_num_apcv#764204, at_heuapcv#764205, at_numper_sec#764206, at_ins_heure#764207, at_persaprev#764208, at_tarif#764209, at_nomhl7#764210, at_numper_ori_oid#764211, at_comment#764212]
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#764077, at_stapat#764078, at_prefix#764079, at_nompat#764080, at_pnopat#764081, at_njfpat#764082, at_datnai#764083, at_datnaiss#764084, at_sexe#764085, at_numper#764086, at_sigma#764087, at_verrou#764088, at_poids#764089, at_indcen#764090, at_numss#764091, at_antece#764092, at_adr_1#764093, at_adr_2#764094, at_codpos#764095, at_ville#764096, at_pays#764097, at_numcai#764098, at_nummut#764099, at_numcha#764100, at_telpri#764101, at_telbur#764102, at_telpor#764103, at_fax#764104, at_prefi2#764105, at_nomass#764106, at_pnoass#764107, at_njfass#764108, at_datass#764109, at_adr_1a#764110, at_adr_2a#764111, at_codpoa#764112, at_villea#764113, at_codmed#764114, at_datcss#764115, at_datf_d#764116, at_dat100#764117, at_numsir#764118, at_numssa#764119, at_codser#764120, at_rngnai#764121, at_natass#764122, at_numacc#764123, at_datacc#764124, at_typexo#764125, at_datmaj#764126, at_coduti#764127, at_flcmu#764128, at_qualss#764129, at_codref#764130, at_codregat#764131, at_codcaiat#764132, at_indvital#764133, at_conmut#764134, at_adhmut#764135, at_garmut#764136, at_numper_ori#764137, at_codrout#764138, at_domaine#764139, at_indtrai#764140, at_idhote#764141, at_codsts#764142, at_nirind#764143, at_fldcd#764144, at_flphoto#764145, at_codmtr#764146, at_adr_3#764147, at_pays_iso#764148, at_adr_3a#764149, at_poids_maj#764150, at_codgestion#764151, at_art115#764152, at_taille#764153, at_taille_maj#764154, at_codetab_prod#764155, at_codsit_prod#764156, at_numdos_prod#764157, at_numper_prod#764158, at_numper_ori_prod#764159, at_ins#764160, at_ins_type#764161, at_ins_date#764162, at_ins_source#764163, at_stadmp#764164, at_datdmp#764165, at_alarmes#764166, at_email#764167, at_consent_sms#764168, at_dat_consent_sms#764169, at_datdcd#764170, at_flhlim#764171, at_dathlim#764172, at_codpershlim#764173, at_fldiff#764174, at_lisdest#764175, at_langue#764176, at_numcai_ft#764177, at_codtarifamc#764178, at_flgrve#764179, at_fladri#764180, at_datadri#764181, at_datf_mut#764182, at_comfac#764183, at_numdos_cloud#764184, at_nation#764185, at_titre#764186, at_titre_ass#764187, at_tiq_histoxml#764188, at_tiq_pnoliste#764189, at_codposnai#764190, at_insi#764191, at_insi_oid#764192, at_typconv#764193, at_crisec#764194, at_opereg#764195, at_flannuamc#764196, at_staipp#764197, at_pnonai#764198, at_codinseenai#764199, at_villenai#764200, at_piece_ident_pres#764201, at_dat_staipp#764202, at_datapcv#764203, at_num_apcv#764204, at_heuapcv#764205, at_numper_sec#764206, at_ins_heure#764207, at_persaprev#764208, at_tarif#764209, at_nomhl7#764210, at_numper_ori_oid#764211, at_comment#764212]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos#764077)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos#764077)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stapat#764078)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_stapat#764078)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefix#764079)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_prefix#764079)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nompat#764080)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nompat#764080)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnopat#764081)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pnopat#764081)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfpat#764082)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_njfpat#764082)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnai#764083)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datnai#764083)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnaiss#764084)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datnaiss#764084)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sexe#764085)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_sexe#764085)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper#764086)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper#764086)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sigma#764087)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_sigma#764087)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_verrou#764088)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_verrou#764088)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids#764089)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_poids#764089)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indcen#764090)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_indcen#764090)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numss#764091)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numss#764091)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_antece#764092)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_antece#764092)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1#764093)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1#764093)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2#764094)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2#764094)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpos#764095)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codpos#764095)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ville#764096)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ville#764096)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays#764097)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pays#764097)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai#764098)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai#764098)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nummut#764099)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nummut#764099)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcha#764100)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numcha#764100)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpri#764101)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_telpri#764101)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telbur#764102)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_telbur#764102)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpor#764103)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_telpor#764103)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fax#764104)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fax#764104)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefi2#764105)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_prefi2#764105)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomass#764106)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nomass#764106)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnoass#764107)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pnoass#764107)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfass#764108)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_njfass#764108)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datass#764109)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datass#764109)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1a#764110)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1a#764110)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2a#764111)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2a#764111)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpoa#764112)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codpoa#764112)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villea#764113)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_villea#764113)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmed#764114)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codmed#764114)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datcss#764115)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datcss#764115)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_d#764116)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_d#764116)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat100#764117)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dat100#764117)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numsir#764118)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numsir#764118)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numssa#764119)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numssa#764119)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codser#764120)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codser#764120)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_rngnai#764121)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_rngnai#764121)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_natass#764122)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_natass#764122)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numacc#764123)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numacc#764123)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datacc#764124)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datacc#764124)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typexo#764125)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_typexo#764125)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datmaj#764126)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datmaj#764126)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_coduti#764127)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_coduti#764127)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flcmu#764128)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flcmu#764128)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_qualss#764129)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_qualss#764129)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codref#764130)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codref#764130)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codregat#764131)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codregat#764131)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codcaiat#764132)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codcaiat#764132)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indvital#764133)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_indvital#764133)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_conmut#764134)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_conmut#764134)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adhmut#764135)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adhmut#764135)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_garmut#764136)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_garmut#764136)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori#764137)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori#764137)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codrout#764138)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codrout#764138)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_domaine#764139)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_domaine#764139)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indtrai#764140)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_indtrai#764140)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_idhote#764141)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_idhote#764141)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsts#764142)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codsts#764142)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nirind#764143)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nirind#764143)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldcd#764144)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fldcd#764144)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flphoto#764145)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flphoto#764145)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmtr#764146)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codmtr#764146)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3#764147)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3#764147)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays_iso#764148)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pays_iso#764148)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3a#764149)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3a#764149)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids_maj#764150)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_poids_maj#764150)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codgestion#764151)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codgestion#764151)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_art115#764152)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_art115#764152)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille#764153)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_taille#764153)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille_maj#764154)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_taille_maj#764154)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codetab_prod#764155)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codetab_prod#764155)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsit_prod#764156)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codsit_prod#764156)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_prod#764157)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_prod#764157)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_prod#764158)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_prod#764158)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_prod#764159)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_prod#764159)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins#764160)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins#764160)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_type#764161)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_type#764161)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_date#764162)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_date#764162)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_source#764163)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_source#764163)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stadmp#764164)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_stadmp#764164)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdmp#764165)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datdmp#764165)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_alarmes#764166)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_alarmes#764166)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_email#764167)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_email#764167)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_consent_sms#764168)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_consent_sms#764168)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_consent_sms#764169)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_consent_sms#764169)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdcd#764170)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datdcd#764170)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flhlim#764171)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flhlim#764171)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dathlim#764172)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dathlim#764172)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpershlim#764173)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codpershlim#764173)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldiff#764174)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fldiff#764174)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_lisdest#764175)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_lisdest#764175)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_langue#764176)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_langue#764176)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai_ft#764177)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai_ft#764177)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codtarifamc#764178)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codtarifamc#764178)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flgrve#764179)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flgrve#764179)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fladri#764180)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fladri#764180)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datadri#764181)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datadri#764181)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_mut#764182)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_mut#764182)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comfac#764183)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_comfac#764183)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_cloud#764184)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_cloud#764184)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nation#764185)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nation#764185)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre#764186)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_titre#764186)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre_ass#764187)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_titre_ass#764187)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_histoxml#764188)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_histoxml#764188)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_pnoliste#764189)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_pnoliste#764189)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codposnai#764190)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codposnai#764190)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi#764191)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_insi#764191)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi_oid#764192)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_insi_oid#764192)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typconv#764193)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_typconv#764193)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_crisec#764194)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_crisec#764194)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_opereg#764195)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_opereg#764195)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flannuamc#764196)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flannuamc#764196)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_staipp#764197)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_staipp#764197)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnonai#764198)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pnonai#764198)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codinseenai#764199)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codinseenai#764199)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villenai#764200)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_villenai#764200)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_piece_ident_pres#764201)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_piece_ident_pres#764201)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_staipp#764202)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_staipp#764202)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datapcv#764203)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datapcv#764203)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_num_apcv#764204)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_num_apcv#764204)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_heuapcv#764205)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_heuapcv#764205)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_sec#764206)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_sec#764206)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_heure#764207)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_heure#764207)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_persaprev#764208)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_persaprev#764208)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tarif#764209)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_tarif#764209)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomhl7#764210)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nomhl7#764210)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_oid#764211)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_oid#764211)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comment#764212)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_comment#764212)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_B))), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_B))), MAIN) END)

(6) Project
Output: []
Input [136]: [at_numdos#764077, at_stapat#764078, at_prefix#764079, at_nompat#764080, at_pnopat#764081, at_njfpat#764082, at_datnai#764083, at_datnaiss#764084, at_sexe#764085, at_numper#764086, at_sigma#764087, at_verrou#764088, at_poids#764089, at_indcen#764090, at_numss#764091, at_antece#764092, at_adr_1#764093, at_adr_2#764094, at_codpos#764095, at_ville#764096, at_pays#764097, at_numcai#764098, at_nummut#764099, at_numcha#764100, at_telpri#764101, at_telbur#764102, at_telpor#764103, at_fax#764104, at_prefi2#764105, at_nomass#764106, at_pnoass#764107, at_njfass#764108, at_datass#764109, at_adr_1a#764110, at_adr_2a#764111, at_codpoa#764112, at_villea#764113, at_codmed#764114, at_datcss#764115, at_datf_d#764116, at_dat100#764117, at_numsir#764118, at_numssa#764119, at_codser#764120, at_rngnai#764121, at_natass#764122, at_numacc#764123, at_datacc#764124, at_typexo#764125, at_datmaj#764126, at_coduti#764127, at_flcmu#764128, at_qualss#764129, at_codref#764130, at_codregat#764131, at_codcaiat#764132, at_indvital#764133, at_conmut#764134, at_adhmut#764135, at_garmut#764136, at_numper_ori#764137, at_codrout#764138, at_domaine#764139, at_indtrai#764140, at_idhote#764141, at_codsts#764142, at_nirind#764143, at_fldcd#764144, at_flphoto#764145, at_codmtr#764146, at_adr_3#764147, at_pays_iso#764148, at_adr_3a#764149, at_poids_maj#764150, at_codgestion#764151, at_art115#764152, at_taille#764153, at_taille_maj#764154, at_codetab_prod#764155, at_codsit_prod#764156, at_numdos_prod#764157, at_numper_prod#764158, at_numper_ori_prod#764159, at_ins#764160, at_ins_type#764161, at_ins_date#764162, at_ins_source#764163, at_stadmp#764164, at_datdmp#764165, at_alarmes#764166, at_email#764167, at_consent_sms#764168, at_dat_consent_sms#764169, at_datdcd#764170, at_flhlim#764171, at_dathlim#764172, at_codpershlim#764173, at_fldiff#764174, at_lisdest#764175, at_langue#764176, at_numcai_ft#764177, at_codtarifamc#764178, at_flgrve#764179, at_fladri#764180, at_datadri#764181, at_datf_mut#764182, at_comfac#764183, at_numdos_cloud#764184, at_nation#764185, at_titre#764186, at_titre_ass#764187, at_tiq_histoxml#764188, at_tiq_pnoliste#764189, at_codposnai#764190, at_insi#764191, at_insi_oid#764192, at_typconv#764193, at_crisec#764194, at_opereg#764195, at_flannuamc#764196, at_staipp#764197, at_pnonai#764198, at_codinseenai#764199, at_villenai#764200, at_piece_ident_pres#764201, at_dat_staipp#764202, at_datapcv#764203, at_num_apcv#764204, at_heuapcv#764205, at_numper_sec#764206, at_ins_heure#764207, at_persaprev#764208, at_tarif#764209, at_nomhl7#764210, at_numper_ori_oid#764211, at_comment#764212]

(7) Union

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

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

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

(11) HashAggregate [codegen id : 2]
Input [1]: [count#767569L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#767283L]
Results [1]: [count(1)#767283L AS COL_7971e4d6-0abe-44fe-b7c8-5c7a3440ef31#767285L]

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

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

(14) HashAggregate
Input [1]: [count#767569L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#767283L]
Results [1]: [count(1)#767283L AS COL_7971e4d6-0abe-44fe-b7c8-5c7a3440ef31#767285L]

(15) AdaptiveSparkPlan
Output [1]: [COL_7971e4d6-0abe-44fe-b7c8-5c7a3440ef31#767285L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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