hdh-spark-job - Details for Query 1435

Submitted Time: 2026/10/23 13:29:16
Duration: 13 s
Succeeded Jobs: 1431 1436

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 2079.0: task 1816)) 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 2079.0: task 1816)) 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 2079.0: task 1816))"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n2.2 s (1.1 s, 1.1 s, 1.1 s (stage 2079.0: task 1816))"; 5 [labelType="html" label="HashAggregate time in aggregation build total (min, med, max (stageId: taskId)) 2.2 s (1.1 s, 1.1 s, 1.1 s (stage 2079.0: task 1816)) 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=39079]

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

WholeStageCodegen (1)

Union

Project

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos#728517)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos#728517)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stapat#728518)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_stapat#728518)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefix#728519)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_prefix#728519)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nompat#728520)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nompat#728520)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnopat#728521)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pnopat#728521)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfpat#728522)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_njfpat#728522)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnai#728523)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datnai#728523)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnaiss#728524)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datnaiss#728524)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sexe#728525)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_sexe#728525)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper#728526)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper#728526)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sigma#728527)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_sigma#728527)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_verrou#728528)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_verrou#728528)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids#728529)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_poids#728529)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indcen#728530)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_indcen#728530)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numss#728531)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numss#728531)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_antece#728532)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_antece#728532)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1#728533)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1#728533)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2#728534)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2#728534)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpos#728535)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codpos#728535)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ville#728536)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ville#728536)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays#728537)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pays#728537)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai#728538)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai#728538)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nummut#728539)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nummut#728539)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcha#728540)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numcha#728540)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpri#728541)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_telpri#728541)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telbur#728542)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_telbur#728542)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpor#728543)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_telpor#728543)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fax#728544)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fax#728544)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefi2#728545)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_prefi2#728545)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomass#728546)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nomass#728546)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnoass#728547)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pnoass#728547)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfass#728548)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_njfass#728548)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datass#728549)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datass#728549)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1a#728550)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1a#728550)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2a#728551)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2a#728551)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpoa#728552)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codpoa#728552)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villea#728553)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_villea#728553)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmed#728554)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codmed#728554)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datcss#728555)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datcss#728555)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_d#728556)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_d#728556)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat100#728557)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dat100#728557)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numsir#728558)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numsir#728558)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numssa#728559)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numssa#728559)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codser#728560)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codser#728560)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_rngnai#728561)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_rngnai#728561)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_natass#728562)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_natass#728562)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numacc#728563)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numacc#728563)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datacc#728564)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datacc#728564)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typexo#728565)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_typexo#728565)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datmaj#728566)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datmaj#728566)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_coduti#728567)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_coduti#728567)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flcmu#728568)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flcmu#728568)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_qualss#728569)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_qualss#728569)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codref#728570)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codref#728570)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codregat#728571)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codregat#728571)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codcaiat#728572)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codcaiat#728572)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indvital#728573)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_indvital#728573)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_conmut#728574)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_conmut#728574)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adhmut#728575)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adhmut#728575)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_garmut#728576)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_garmut#728576)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori#728577)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori#728577)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codrout#728578)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codrout#728578)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_domaine#728579)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_domaine#728579)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indtrai#728580)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_indtrai#728580)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_idhote#728581)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_idhote#728581)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsts#728582)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codsts#728582)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nirind#728583)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nirind#728583)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldcd#728584)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fldcd#728584)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flphoto#728585)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flphoto#728585)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmtr#728586)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codmtr#728586)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3#728587)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3#728587)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays_iso#728588)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pays_iso#728588)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3a#728589)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3a#728589)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids_maj#728590)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_poids_maj#728590)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codgestion#728591)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codgestion#728591)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_art115#728592)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_art115#728592)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille#728593)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_taille#728593)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille_maj#728594)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_taille_maj#728594)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codetab_prod#728595)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codetab_prod#728595)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsit_prod#728596)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codsit_prod#728596)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_prod#728597)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_prod#728597)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_prod#728598)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_prod#728598)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_prod#728599)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_prod#728599)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins#728600)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins#728600)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_type#728601)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_type#728601)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_date#728602)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_date#728602)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_source#728603)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_source#728603)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stadmp#728604)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_stadmp#728604)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdmp#728605)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datdmp#728605)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_alarmes#728606)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_alarmes#728606)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_email#728607)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_email#728607)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_consent_sms#728608)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_consent_sms#728608)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_consent_sms#728609)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_consent_sms#728609)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdcd#728610)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datdcd#728610)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flhlim#728611)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flhlim#728611)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dathlim#728612)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dathlim#728612)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpershlim#728613)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codpershlim#728613)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldiff#728614)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fldiff#728614)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_lisdest#728615)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_lisdest#728615)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_langue#728616)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_langue#728616)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai_ft#728617)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai_ft#728617)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codtarifamc#728618)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codtarifamc#728618)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flgrve#728619)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flgrve#728619)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fladri#728620)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fladri#728620)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datadri#728621)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datadri#728621)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_mut#728622)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_mut#728622)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comfac#728623)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_comfac#728623)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_cloud#728624)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_cloud#728624)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nation#728625)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nation#728625)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre#728626)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_titre#728626)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre_ass#728627)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_titre_ass#728627)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_histoxml#728628)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_histoxml#728628)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_pnoliste#728629)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_pnoliste#728629)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codposnai#728630)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codposnai#728630)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi#728631)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_insi#728631)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi_oid#728632)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_insi_oid#728632)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typconv#728633)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_typconv#728633)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_crisec#728634)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_crisec#728634)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_opereg#728635)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_opereg#728635)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flannuamc#728636)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flannuamc#728636)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_staipp#728637)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_staipp#728637)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnonai#728638)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pnonai#728638)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codinseenai#728639)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codinseenai#728639)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villenai#728640)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_villenai#728640)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_piece_ident_pres#728641)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_piece_ident_pres#728641)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_staipp#728642)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_staipp#728642)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datapcv#728643)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datapcv#728643)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_num_apcv#728644)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_num_apcv#728644)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_heuapcv#728645)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_heuapcv#728645)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_sec#728646)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_sec#728646)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_heure#728647)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_heure#728647)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_persaprev#728648)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_persaprev#728648)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tarif#728649)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_tarif#728649)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomhl7#728650)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nomhl7#728650)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_oid#728651)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_oid#728651)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comment#728652)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_comment#728652)), 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#728517,at_stapat#728518,at_prefix#728519,at_nompat#728520,at_pnopat#728521,at_njfpat#728522,at_datnai#728523,at_datnaiss#728524,at_sexe#728525,at_numper#728526,at_sigma#728527,at_verrou#728528,at_poids#728529,at_indcen#728530,at_numss#728531,at_antece#728532,at_adr_1#728533,at_adr_2#728534,at_codpos#728535,at_ville#728536,at_pays#728537,at_numcai#728538,at_nummut#728539,at_numcha#728540,... 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#729744)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos#729744)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stapat#729745)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_stapat#729745)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefix#729746)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_prefix#729746)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nompat#729747)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nompat#729747)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnopat#729748)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pnopat#729748)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfpat#729749)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_njfpat#729749)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnai#729750)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datnai#729750)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnaiss#729751)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datnaiss#729751)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sexe#729752)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_sexe#729752)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper#729753)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper#729753)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sigma#729754)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_sigma#729754)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_verrou#729755)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_verrou#729755)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids#729756)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_poids#729756)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indcen#729757)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_indcen#729757)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numss#729758)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numss#729758)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_antece#729759)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_antece#729759)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1#729760)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1#729760)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2#729761)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2#729761)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpos#729762)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codpos#729762)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ville#729763)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ville#729763)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays#729764)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pays#729764)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai#729765)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai#729765)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nummut#729766)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nummut#729766)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcha#729767)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numcha#729767)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpri#729768)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_telpri#729768)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telbur#729769)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_telbur#729769)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpor#729770)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_telpor#729770)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fax#729771)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fax#729771)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefi2#729772)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_prefi2#729772)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomass#729773)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nomass#729773)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnoass#729774)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pnoass#729774)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfass#729775)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_njfass#729775)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datass#729776)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datass#729776)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1a#729777)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1a#729777)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2a#729778)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2a#729778)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpoa#729779)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codpoa#729779)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villea#729780)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_villea#729780)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmed#729781)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codmed#729781)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datcss#729782)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datcss#729782)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_d#729783)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_d#729783)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat100#729784)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dat100#729784)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numsir#729785)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numsir#729785)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numssa#729786)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numssa#729786)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codser#729787)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codser#729787)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_rngnai#729788)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_rngnai#729788)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_natass#729789)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_natass#729789)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numacc#729790)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numacc#729790)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datacc#729791)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datacc#729791)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typexo#729792)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_typexo#729792)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datmaj#729793)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datmaj#729793)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_coduti#729794)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_coduti#729794)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flcmu#729795)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flcmu#729795)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_qualss#729796)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_qualss#729796)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codref#729797)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codref#729797)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codregat#729798)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codregat#729798)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codcaiat#729799)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codcaiat#729799)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indvital#729800)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_indvital#729800)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_conmut#729801)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_conmut#729801)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adhmut#729802)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adhmut#729802)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_garmut#729803)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_garmut#729803)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori#729804)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori#729804)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codrout#729805)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codrout#729805)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_domaine#729806)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_domaine#729806)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indtrai#729807)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_indtrai#729807)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_idhote#729808)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_idhote#729808)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsts#729809)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codsts#729809)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nirind#729810)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nirind#729810)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldcd#729811)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fldcd#729811)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flphoto#729812)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flphoto#729812)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmtr#729813)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codmtr#729813)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3#729814)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3#729814)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays_iso#729815)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pays_iso#729815)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3a#729816)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3a#729816)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids_maj#729817)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_poids_maj#729817)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codgestion#729818)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codgestion#729818)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_art115#729819)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_art115#729819)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille#729820)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_taille#729820)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille_maj#729821)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_taille_maj#729821)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codetab_prod#729822)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codetab_prod#729822)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsit_prod#729823)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codsit_prod#729823)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_prod#729824)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_prod#729824)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_prod#729825)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_prod#729825)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_prod#729826)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_prod#729826)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins#729827)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins#729827)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_type#729828)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_type#729828)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_date#729829)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_date#729829)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_source#729830)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_source#729830)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stadmp#729831)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_stadmp#729831)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdmp#729832)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datdmp#729832)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_alarmes#729833)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_alarmes#729833)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_email#729834)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_email#729834)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_consent_sms#729835)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_consent_sms#729835)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_consent_sms#729836)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_consent_sms#729836)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdcd#729837)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datdcd#729837)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flhlim#729838)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flhlim#729838)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dathlim#729839)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dathlim#729839)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpershlim#729840)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codpershlim#729840)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldiff#729841)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fldiff#729841)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_lisdest#729842)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_lisdest#729842)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_langue#729843)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_langue#729843)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai_ft#729844)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai_ft#729844)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codtarifamc#729845)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codtarifamc#729845)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flgrve#729846)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flgrve#729846)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fladri#729847)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fladri#729847)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datadri#729848)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datadri#729848)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_mut#729849)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_mut#729849)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comfac#729850)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_comfac#729850)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_cloud#729851)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_cloud#729851)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nation#729852)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nation#729852)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre#729853)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_titre#729853)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre_ass#729854)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_titre_ass#729854)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_histoxml#729855)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_histoxml#729855)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_pnoliste#729856)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_pnoliste#729856)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codposnai#729857)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codposnai#729857)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi#729858)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_insi#729858)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi_oid#729859)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_insi_oid#729859)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typconv#729860)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_typconv#729860)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_crisec#729861)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_crisec#729861)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_opereg#729862)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_opereg#729862)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flannuamc#729863)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flannuamc#729863)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_staipp#729864)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_staipp#729864)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnonai#729865)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pnonai#729865)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codinseenai#729866)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codinseenai#729866)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villenai#729867)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_villenai#729867)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_piece_ident_pres#729868)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_piece_ident_pres#729868)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_staipp#729869)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_staipp#729869)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datapcv#729870)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datapcv#729870)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_num_apcv#729871)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_num_apcv#729871)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_heuapcv#729872)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_heuapcv#729872)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_sec#729873)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_sec#729873)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_heure#729874)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_heure#729874)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_persaprev#729875)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_persaprev#729875)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tarif#729876)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_tarif#729876)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomhl7#729877)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nomhl7#729877)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_oid#729878)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_oid#729878)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comment#729879)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_comment#729879)), 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#729744,at_stapat#729745,at_prefix#729746,at_nompat#729747,at_pnopat#729748,at_njfpat#729749,at_datnai#729750,at_datnaiss#729751,at_sexe#729752,at_numper#729753,at_sigma#729754,at_verrou#729755,at_poids#729756,at_indcen#729757,at_numss#729758,at_antece#729759,at_adr_1#729760,at_adr_2#729761,at_codpos#729762,at_ville#729763,at_pays#729764,at_numcai#729765,at_nummut#729766,at_numcha#729767,... 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#728517, at_stapat#728518, at_prefix#728519, at_nompat#728520, at_pnopat#728521, at_njfpat#728522, at_datnai#728523, at_datnaiss#728524, at_sexe#728525, at_numper#728526, at_sigma#728527, at_verrou#728528, at_poids#728529, at_indcen#728530, at_numss#728531, at_antece#728532, at_adr_1#728533, at_adr_2#728534, at_codpos#728535, at_ville#728536, at_pays#728537, at_numcai#728538, at_nummut#728539, at_numcha#728540, at_telpri#728541, at_telbur#728542, at_telpor#728543, at_fax#728544, at_prefi2#728545, at_nomass#728546, at_pnoass#728547, at_njfass#728548, at_datass#728549, at_adr_1a#728550, at_adr_2a#728551, at_codpoa#728552, at_villea#728553, at_codmed#728554, at_datcss#728555, at_datf_d#728556, at_dat100#728557, at_numsir#728558, at_numssa#728559, at_codser#728560, at_rngnai#728561, at_natass#728562, at_numacc#728563, at_datacc#728564, at_typexo#728565, at_datmaj#728566, at_coduti#728567, at_flcmu#728568, at_qualss#728569, at_codref#728570, at_codregat#728571, at_codcaiat#728572, at_indvital#728573, at_conmut#728574, at_adhmut#728575, at_garmut#728576, at_numper_ori#728577, at_codrout#728578, at_domaine#728579, at_indtrai#728580, at_idhote#728581, at_codsts#728582, at_nirind#728583, at_fldcd#728584, at_flphoto#728585, at_codmtr#728586, at_adr_3#728587, at_pays_iso#728588, at_adr_3a#728589, at_poids_maj#728590, at_codgestion#728591, at_art115#728592, at_taille#728593, at_taille_maj#728594, at_codetab_prod#728595, at_codsit_prod#728596, at_numdos_prod#728597, at_numper_prod#728598, at_numper_ori_prod#728599, at_ins#728600, at_ins_type#728601, at_ins_date#728602, at_ins_source#728603, at_stadmp#728604, at_datdmp#728605, at_alarmes#728606, at_email#728607, at_consent_sms#728608, at_dat_consent_sms#728609, at_datdcd#728610, at_flhlim#728611, at_dathlim#728612, at_codpershlim#728613, at_fldiff#728614, at_lisdest#728615, at_langue#728616, at_numcai_ft#728617, at_codtarifamc#728618, at_flgrve#728619, at_fladri#728620, at_datadri#728621, at_datf_mut#728622, at_comfac#728623, at_numdos_cloud#728624, at_nation#728625, at_titre#728626, at_titre_ass#728627, at_tiq_histoxml#728628, at_tiq_pnoliste#728629, at_codposnai#728630, at_insi#728631, at_insi_oid#728632, at_typconv#728633, at_crisec#728634, at_opereg#728635, at_flannuamc#728636, at_staipp#728637, at_pnonai#728638, at_codinseenai#728639, at_villenai#728640, at_piece_ident_pres#728641, at_dat_staipp#728642, at_datapcv#728643, at_num_apcv#728644, at_heuapcv#728645, at_numper_sec#728646, at_ins_heure#728647, at_persaprev#728648, at_tarif#728649, at_nomhl7#728650, at_numper_ori_oid#728651, at_comment#728652]
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#728517, at_stapat#728518, at_prefix#728519, at_nompat#728520, at_pnopat#728521, at_njfpat#728522, at_datnai#728523, at_datnaiss#728524, at_sexe#728525, at_numper#728526, at_sigma#728527, at_verrou#728528, at_poids#728529, at_indcen#728530, at_numss#728531, at_antece#728532, at_adr_1#728533, at_adr_2#728534, at_codpos#728535, at_ville#728536, at_pays#728537, at_numcai#728538, at_nummut#728539, at_numcha#728540, at_telpri#728541, at_telbur#728542, at_telpor#728543, at_fax#728544, at_prefi2#728545, at_nomass#728546, at_pnoass#728547, at_njfass#728548, at_datass#728549, at_adr_1a#728550, at_adr_2a#728551, at_codpoa#728552, at_villea#728553, at_codmed#728554, at_datcss#728555, at_datf_d#728556, at_dat100#728557, at_numsir#728558, at_numssa#728559, at_codser#728560, at_rngnai#728561, at_natass#728562, at_numacc#728563, at_datacc#728564, at_typexo#728565, at_datmaj#728566, at_coduti#728567, at_flcmu#728568, at_qualss#728569, at_codref#728570, at_codregat#728571, at_codcaiat#728572, at_indvital#728573, at_conmut#728574, at_adhmut#728575, at_garmut#728576, at_numper_ori#728577, at_codrout#728578, at_domaine#728579, at_indtrai#728580, at_idhote#728581, at_codsts#728582, at_nirind#728583, at_fldcd#728584, at_flphoto#728585, at_codmtr#728586, at_adr_3#728587, at_pays_iso#728588, at_adr_3a#728589, at_poids_maj#728590, at_codgestion#728591, at_art115#728592, at_taille#728593, at_taille_maj#728594, at_codetab_prod#728595, at_codsit_prod#728596, at_numdos_prod#728597, at_numper_prod#728598, at_numper_ori_prod#728599, at_ins#728600, at_ins_type#728601, at_ins_date#728602, at_ins_source#728603, at_stadmp#728604, at_datdmp#728605, at_alarmes#728606, at_email#728607, at_consent_sms#728608, at_dat_consent_sms#728609, at_datdcd#728610, at_flhlim#728611, at_dathlim#728612, at_codpershlim#728613, at_fldiff#728614, at_lisdest#728615, at_langue#728616, at_numcai_ft#728617, at_codtarifamc#728618, at_flgrve#728619, at_fladri#728620, at_datadri#728621, at_datf_mut#728622, at_comfac#728623, at_numdos_cloud#728624, at_nation#728625, at_titre#728626, at_titre_ass#728627, at_tiq_histoxml#728628, at_tiq_pnoliste#728629, at_codposnai#728630, at_insi#728631, at_insi_oid#728632, at_typconv#728633, at_crisec#728634, at_opereg#728635, at_flannuamc#728636, at_staipp#728637, at_pnonai#728638, at_codinseenai#728639, at_villenai#728640, at_piece_ident_pres#728641, at_dat_staipp#728642, at_datapcv#728643, at_num_apcv#728644, at_heuapcv#728645, at_numper_sec#728646, at_ins_heure#728647, at_persaprev#728648, at_tarif#728649, at_nomhl7#728650, at_numper_ori_oid#728651, at_comment#728652]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos#728517)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos#728517)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stapat#728518)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_stapat#728518)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefix#728519)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_prefix#728519)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nompat#728520)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nompat#728520)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnopat#728521)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pnopat#728521)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfpat#728522)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_njfpat#728522)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnai#728523)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datnai#728523)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnaiss#728524)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datnaiss#728524)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sexe#728525)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_sexe#728525)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper#728526)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper#728526)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sigma#728527)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_sigma#728527)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_verrou#728528)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_verrou#728528)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids#728529)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_poids#728529)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indcen#728530)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_indcen#728530)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numss#728531)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numss#728531)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_antece#728532)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_antece#728532)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1#728533)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1#728533)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2#728534)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2#728534)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpos#728535)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codpos#728535)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ville#728536)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ville#728536)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays#728537)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pays#728537)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai#728538)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai#728538)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nummut#728539)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nummut#728539)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcha#728540)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numcha#728540)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpri#728541)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_telpri#728541)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telbur#728542)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_telbur#728542)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpor#728543)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_telpor#728543)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fax#728544)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fax#728544)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefi2#728545)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_prefi2#728545)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomass#728546)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nomass#728546)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnoass#728547)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pnoass#728547)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfass#728548)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_njfass#728548)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datass#728549)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datass#728549)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1a#728550)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1a#728550)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2a#728551)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2a#728551)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpoa#728552)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codpoa#728552)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villea#728553)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_villea#728553)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmed#728554)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codmed#728554)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datcss#728555)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datcss#728555)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_d#728556)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_d#728556)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat100#728557)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dat100#728557)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numsir#728558)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numsir#728558)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numssa#728559)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numssa#728559)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codser#728560)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codser#728560)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_rngnai#728561)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_rngnai#728561)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_natass#728562)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_natass#728562)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numacc#728563)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numacc#728563)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datacc#728564)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datacc#728564)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typexo#728565)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_typexo#728565)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datmaj#728566)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datmaj#728566)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_coduti#728567)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_coduti#728567)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flcmu#728568)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flcmu#728568)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_qualss#728569)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_qualss#728569)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codref#728570)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codref#728570)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codregat#728571)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codregat#728571)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codcaiat#728572)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codcaiat#728572)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indvital#728573)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_indvital#728573)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_conmut#728574)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_conmut#728574)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adhmut#728575)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adhmut#728575)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_garmut#728576)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_garmut#728576)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori#728577)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori#728577)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codrout#728578)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codrout#728578)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_domaine#728579)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_domaine#728579)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indtrai#728580)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_indtrai#728580)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_idhote#728581)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_idhote#728581)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsts#728582)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codsts#728582)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nirind#728583)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nirind#728583)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldcd#728584)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fldcd#728584)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flphoto#728585)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flphoto#728585)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmtr#728586)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codmtr#728586)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3#728587)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3#728587)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays_iso#728588)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pays_iso#728588)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3a#728589)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3a#728589)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids_maj#728590)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_poids_maj#728590)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codgestion#728591)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codgestion#728591)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_art115#728592)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_art115#728592)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille#728593)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_taille#728593)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille_maj#728594)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_taille_maj#728594)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codetab_prod#728595)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codetab_prod#728595)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsit_prod#728596)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codsit_prod#728596)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_prod#728597)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_prod#728597)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_prod#728598)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_prod#728598)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_prod#728599)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_prod#728599)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins#728600)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins#728600)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_type#728601)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_type#728601)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_date#728602)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_date#728602)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_source#728603)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_source#728603)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stadmp#728604)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_stadmp#728604)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdmp#728605)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datdmp#728605)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_alarmes#728606)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_alarmes#728606)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_email#728607)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_email#728607)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_consent_sms#728608)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_consent_sms#728608)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_consent_sms#728609)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_consent_sms#728609)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdcd#728610)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datdcd#728610)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flhlim#728611)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flhlim#728611)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dathlim#728612)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dathlim#728612)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpershlim#728613)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codpershlim#728613)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldiff#728614)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fldiff#728614)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_lisdest#728615)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_lisdest#728615)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_langue#728616)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_langue#728616)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai_ft#728617)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai_ft#728617)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codtarifamc#728618)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codtarifamc#728618)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flgrve#728619)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flgrve#728619)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fladri#728620)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fladri#728620)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datadri#728621)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datadri#728621)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_mut#728622)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_mut#728622)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comfac#728623)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_comfac#728623)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_cloud#728624)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_cloud#728624)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nation#728625)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nation#728625)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre#728626)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_titre#728626)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre_ass#728627)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_titre_ass#728627)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_histoxml#728628)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_histoxml#728628)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_pnoliste#728629)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_pnoliste#728629)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codposnai#728630)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codposnai#728630)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi#728631)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_insi#728631)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi_oid#728632)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_insi_oid#728632)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typconv#728633)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_typconv#728633)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_crisec#728634)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_crisec#728634)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_opereg#728635)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_opereg#728635)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flannuamc#728636)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flannuamc#728636)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_staipp#728637)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_staipp#728637)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnonai#728638)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pnonai#728638)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codinseenai#728639)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codinseenai#728639)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villenai#728640)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_villenai#728640)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_piece_ident_pres#728641)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_piece_ident_pres#728641)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_staipp#728642)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_staipp#728642)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datapcv#728643)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datapcv#728643)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_num_apcv#728644)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_num_apcv#728644)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_heuapcv#728645)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_heuapcv#728645)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_sec#728646)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_sec#728646)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_heure#728647)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_heure#728647)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_persaprev#728648)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_persaprev#728648)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tarif#728649)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_tarif#728649)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomhl7#728650)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nomhl7#728650)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_oid#728651)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_oid#728651)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comment#728652)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_comment#728652)), 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#728517, at_stapat#728518, at_prefix#728519, at_nompat#728520, at_pnopat#728521, at_njfpat#728522, at_datnai#728523, at_datnaiss#728524, at_sexe#728525, at_numper#728526, at_sigma#728527, at_verrou#728528, at_poids#728529, at_indcen#728530, at_numss#728531, at_antece#728532, at_adr_1#728533, at_adr_2#728534, at_codpos#728535, at_ville#728536, at_pays#728537, at_numcai#728538, at_nummut#728539, at_numcha#728540, at_telpri#728541, at_telbur#728542, at_telpor#728543, at_fax#728544, at_prefi2#728545, at_nomass#728546, at_pnoass#728547, at_njfass#728548, at_datass#728549, at_adr_1a#728550, at_adr_2a#728551, at_codpoa#728552, at_villea#728553, at_codmed#728554, at_datcss#728555, at_datf_d#728556, at_dat100#728557, at_numsir#728558, at_numssa#728559, at_codser#728560, at_rngnai#728561, at_natass#728562, at_numacc#728563, at_datacc#728564, at_typexo#728565, at_datmaj#728566, at_coduti#728567, at_flcmu#728568, at_qualss#728569, at_codref#728570, at_codregat#728571, at_codcaiat#728572, at_indvital#728573, at_conmut#728574, at_adhmut#728575, at_garmut#728576, at_numper_ori#728577, at_codrout#728578, at_domaine#728579, at_indtrai#728580, at_idhote#728581, at_codsts#728582, at_nirind#728583, at_fldcd#728584, at_flphoto#728585, at_codmtr#728586, at_adr_3#728587, at_pays_iso#728588, at_adr_3a#728589, at_poids_maj#728590, at_codgestion#728591, at_art115#728592, at_taille#728593, at_taille_maj#728594, at_codetab_prod#728595, at_codsit_prod#728596, at_numdos_prod#728597, at_numper_prod#728598, at_numper_ori_prod#728599, at_ins#728600, at_ins_type#728601, at_ins_date#728602, at_ins_source#728603, at_stadmp#728604, at_datdmp#728605, at_alarmes#728606, at_email#728607, at_consent_sms#728608, at_dat_consent_sms#728609, at_datdcd#728610, at_flhlim#728611, at_dathlim#728612, at_codpershlim#728613, at_fldiff#728614, at_lisdest#728615, at_langue#728616, at_numcai_ft#728617, at_codtarifamc#728618, at_flgrve#728619, at_fladri#728620, at_datadri#728621, at_datf_mut#728622, at_comfac#728623, at_numdos_cloud#728624, at_nation#728625, at_titre#728626, at_titre_ass#728627, at_tiq_histoxml#728628, at_tiq_pnoliste#728629, at_codposnai#728630, at_insi#728631, at_insi_oid#728632, at_typconv#728633, at_crisec#728634, at_opereg#728635, at_flannuamc#728636, at_staipp#728637, at_pnonai#728638, at_codinseenai#728639, at_villenai#728640, at_piece_ident_pres#728641, at_dat_staipp#728642, at_datapcv#728643, at_num_apcv#728644, at_heuapcv#728645, at_numper_sec#728646, at_ins_heure#728647, at_persaprev#728648, at_tarif#728649, at_nomhl7#728650, at_numper_ori_oid#728651, at_comment#728652]

(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#729744, at_stapat#729745, at_prefix#729746, at_nompat#729747, at_pnopat#729748, at_njfpat#729749, at_datnai#729750, at_datnaiss#729751, at_sexe#729752, at_numper#729753, at_sigma#729754, at_verrou#729755, at_poids#729756, at_indcen#729757, at_numss#729758, at_antece#729759, at_adr_1#729760, at_adr_2#729761, at_codpos#729762, at_ville#729763, at_pays#729764, at_numcai#729765, at_nummut#729766, at_numcha#729767, at_telpri#729768, at_telbur#729769, at_telpor#729770, at_fax#729771, at_prefi2#729772, at_nomass#729773, at_pnoass#729774, at_njfass#729775, at_datass#729776, at_adr_1a#729777, at_adr_2a#729778, at_codpoa#729779, at_villea#729780, at_codmed#729781, at_datcss#729782, at_datf_d#729783, at_dat100#729784, at_numsir#729785, at_numssa#729786, at_codser#729787, at_rngnai#729788, at_natass#729789, at_numacc#729790, at_datacc#729791, at_typexo#729792, at_datmaj#729793, at_coduti#729794, at_flcmu#729795, at_qualss#729796, at_codref#729797, at_codregat#729798, at_codcaiat#729799, at_indvital#729800, at_conmut#729801, at_adhmut#729802, at_garmut#729803, at_numper_ori#729804, at_codrout#729805, at_domaine#729806, at_indtrai#729807, at_idhote#729808, at_codsts#729809, at_nirind#729810, at_fldcd#729811, at_flphoto#729812, at_codmtr#729813, at_adr_3#729814, at_pays_iso#729815, at_adr_3a#729816, at_poids_maj#729817, at_codgestion#729818, at_art115#729819, at_taille#729820, at_taille_maj#729821, at_codetab_prod#729822, at_codsit_prod#729823, at_numdos_prod#729824, at_numper_prod#729825, at_numper_ori_prod#729826, at_ins#729827, at_ins_type#729828, at_ins_date#729829, at_ins_source#729830, at_stadmp#729831, at_datdmp#729832, at_alarmes#729833, at_email#729834, at_consent_sms#729835, at_dat_consent_sms#729836, at_datdcd#729837, at_flhlim#729838, at_dathlim#729839, at_codpershlim#729840, at_fldiff#729841, at_lisdest#729842, at_langue#729843, at_numcai_ft#729844, at_codtarifamc#729845, at_flgrve#729846, at_fladri#729847, at_datadri#729848, at_datf_mut#729849, at_comfac#729850, at_numdos_cloud#729851, at_nation#729852, at_titre#729853, at_titre_ass#729854, at_tiq_histoxml#729855, at_tiq_pnoliste#729856, at_codposnai#729857, at_insi#729858, at_insi_oid#729859, at_typconv#729860, at_crisec#729861, at_opereg#729862, at_flannuamc#729863, at_staipp#729864, at_pnonai#729865, at_codinseenai#729866, at_villenai#729867, at_piece_ident_pres#729868, at_dat_staipp#729869, at_datapcv#729870, at_num_apcv#729871, at_heuapcv#729872, at_numper_sec#729873, at_ins_heure#729874, at_persaprev#729875, at_tarif#729876, at_nomhl7#729877, at_numper_ori_oid#729878, at_comment#729879]
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#729744, at_stapat#729745, at_prefix#729746, at_nompat#729747, at_pnopat#729748, at_njfpat#729749, at_datnai#729750, at_datnaiss#729751, at_sexe#729752, at_numper#729753, at_sigma#729754, at_verrou#729755, at_poids#729756, at_indcen#729757, at_numss#729758, at_antece#729759, at_adr_1#729760, at_adr_2#729761, at_codpos#729762, at_ville#729763, at_pays#729764, at_numcai#729765, at_nummut#729766, at_numcha#729767, at_telpri#729768, at_telbur#729769, at_telpor#729770, at_fax#729771, at_prefi2#729772, at_nomass#729773, at_pnoass#729774, at_njfass#729775, at_datass#729776, at_adr_1a#729777, at_adr_2a#729778, at_codpoa#729779, at_villea#729780, at_codmed#729781, at_datcss#729782, at_datf_d#729783, at_dat100#729784, at_numsir#729785, at_numssa#729786, at_codser#729787, at_rngnai#729788, at_natass#729789, at_numacc#729790, at_datacc#729791, at_typexo#729792, at_datmaj#729793, at_coduti#729794, at_flcmu#729795, at_qualss#729796, at_codref#729797, at_codregat#729798, at_codcaiat#729799, at_indvital#729800, at_conmut#729801, at_adhmut#729802, at_garmut#729803, at_numper_ori#729804, at_codrout#729805, at_domaine#729806, at_indtrai#729807, at_idhote#729808, at_codsts#729809, at_nirind#729810, at_fldcd#729811, at_flphoto#729812, at_codmtr#729813, at_adr_3#729814, at_pays_iso#729815, at_adr_3a#729816, at_poids_maj#729817, at_codgestion#729818, at_art115#729819, at_taille#729820, at_taille_maj#729821, at_codetab_prod#729822, at_codsit_prod#729823, at_numdos_prod#729824, at_numper_prod#729825, at_numper_ori_prod#729826, at_ins#729827, at_ins_type#729828, at_ins_date#729829, at_ins_source#729830, at_stadmp#729831, at_datdmp#729832, at_alarmes#729833, at_email#729834, at_consent_sms#729835, at_dat_consent_sms#729836, at_datdcd#729837, at_flhlim#729838, at_dathlim#729839, at_codpershlim#729840, at_fldiff#729841, at_lisdest#729842, at_langue#729843, at_numcai_ft#729844, at_codtarifamc#729845, at_flgrve#729846, at_fladri#729847, at_datadri#729848, at_datf_mut#729849, at_comfac#729850, at_numdos_cloud#729851, at_nation#729852, at_titre#729853, at_titre_ass#729854, at_tiq_histoxml#729855, at_tiq_pnoliste#729856, at_codposnai#729857, at_insi#729858, at_insi_oid#729859, at_typconv#729860, at_crisec#729861, at_opereg#729862, at_flannuamc#729863, at_staipp#729864, at_pnonai#729865, at_codinseenai#729866, at_villenai#729867, at_piece_ident_pres#729868, at_dat_staipp#729869, at_datapcv#729870, at_num_apcv#729871, at_heuapcv#729872, at_numper_sec#729873, at_ins_heure#729874, at_persaprev#729875, at_tarif#729876, at_nomhl7#729877, at_numper_ori_oid#729878, at_comment#729879]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos#729744)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos#729744)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stapat#729745)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_stapat#729745)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefix#729746)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_prefix#729746)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nompat#729747)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nompat#729747)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnopat#729748)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pnopat#729748)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfpat#729749)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_njfpat#729749)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnai#729750)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datnai#729750)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnaiss#729751)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datnaiss#729751)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sexe#729752)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_sexe#729752)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper#729753)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper#729753)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sigma#729754)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_sigma#729754)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_verrou#729755)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_verrou#729755)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids#729756)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_poids#729756)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indcen#729757)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_indcen#729757)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numss#729758)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numss#729758)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_antece#729759)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_antece#729759)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1#729760)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1#729760)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2#729761)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2#729761)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpos#729762)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codpos#729762)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ville#729763)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ville#729763)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays#729764)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pays#729764)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai#729765)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai#729765)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nummut#729766)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nummut#729766)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcha#729767)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numcha#729767)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpri#729768)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_telpri#729768)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telbur#729769)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_telbur#729769)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpor#729770)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_telpor#729770)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fax#729771)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fax#729771)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefi2#729772)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_prefi2#729772)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomass#729773)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nomass#729773)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnoass#729774)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pnoass#729774)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfass#729775)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_njfass#729775)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datass#729776)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datass#729776)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1a#729777)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1a#729777)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2a#729778)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2a#729778)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpoa#729779)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codpoa#729779)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villea#729780)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_villea#729780)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmed#729781)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codmed#729781)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datcss#729782)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datcss#729782)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_d#729783)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_d#729783)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat100#729784)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dat100#729784)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numsir#729785)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numsir#729785)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numssa#729786)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numssa#729786)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codser#729787)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codser#729787)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_rngnai#729788)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_rngnai#729788)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_natass#729789)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_natass#729789)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numacc#729790)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numacc#729790)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datacc#729791)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datacc#729791)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typexo#729792)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_typexo#729792)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datmaj#729793)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datmaj#729793)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_coduti#729794)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_coduti#729794)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flcmu#729795)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flcmu#729795)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_qualss#729796)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_qualss#729796)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codref#729797)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codref#729797)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codregat#729798)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codregat#729798)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codcaiat#729799)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codcaiat#729799)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indvital#729800)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_indvital#729800)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_conmut#729801)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_conmut#729801)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adhmut#729802)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adhmut#729802)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_garmut#729803)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_garmut#729803)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori#729804)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori#729804)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codrout#729805)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codrout#729805)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_domaine#729806)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_domaine#729806)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indtrai#729807)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_indtrai#729807)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_idhote#729808)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_idhote#729808)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsts#729809)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codsts#729809)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nirind#729810)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nirind#729810)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldcd#729811)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fldcd#729811)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flphoto#729812)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flphoto#729812)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmtr#729813)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codmtr#729813)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3#729814)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3#729814)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays_iso#729815)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pays_iso#729815)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3a#729816)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3a#729816)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids_maj#729817)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_poids_maj#729817)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codgestion#729818)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codgestion#729818)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_art115#729819)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_art115#729819)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille#729820)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_taille#729820)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille_maj#729821)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_taille_maj#729821)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codetab_prod#729822)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codetab_prod#729822)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsit_prod#729823)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codsit_prod#729823)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_prod#729824)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_prod#729824)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_prod#729825)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_prod#729825)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_prod#729826)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_prod#729826)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins#729827)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins#729827)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_type#729828)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_type#729828)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_date#729829)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_date#729829)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_source#729830)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_source#729830)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stadmp#729831)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_stadmp#729831)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdmp#729832)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datdmp#729832)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_alarmes#729833)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_alarmes#729833)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_email#729834)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_email#729834)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_consent_sms#729835)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_consent_sms#729835)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_consent_sms#729836)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_consent_sms#729836)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdcd#729837)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datdcd#729837)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flhlim#729838)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flhlim#729838)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dathlim#729839)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dathlim#729839)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpershlim#729840)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codpershlim#729840)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldiff#729841)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fldiff#729841)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_lisdest#729842)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_lisdest#729842)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_langue#729843)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_langue#729843)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai_ft#729844)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai_ft#729844)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codtarifamc#729845)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codtarifamc#729845)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flgrve#729846)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flgrve#729846)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fladri#729847)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_fladri#729847)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datadri#729848)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datadri#729848)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_mut#729849)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_mut#729849)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comfac#729850)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_comfac#729850)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_cloud#729851)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_cloud#729851)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nation#729852)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nation#729852)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre#729853)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_titre#729853)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre_ass#729854)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_titre_ass#729854)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_histoxml#729855)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_histoxml#729855)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_pnoliste#729856)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_pnoliste#729856)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codposnai#729857)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codposnai#729857)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi#729858)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_insi#729858)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi_oid#729859)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_insi_oid#729859)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typconv#729860)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_typconv#729860)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_crisec#729861)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_crisec#729861)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_opereg#729862)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_opereg#729862)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flannuamc#729863)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_flannuamc#729863)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_staipp#729864)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_staipp#729864)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnonai#729865)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_pnonai#729865)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codinseenai#729866)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_codinseenai#729866)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villenai#729867)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_villenai#729867)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_piece_ident_pres#729868)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_piece_ident_pres#729868)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_staipp#729869)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_staipp#729869)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datapcv#729870)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_datapcv#729870)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_num_apcv#729871)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_num_apcv#729871)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_heuapcv#729872)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_heuapcv#729872)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_sec#729873)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_sec#729873)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_heure#729874)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_heure#729874)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_persaprev#729875)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_persaprev#729875)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tarif#729876)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_tarif#729876)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomhl7#729877)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_nomhl7#729877)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_oid#729878)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_oid#729878)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comment#729879)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(at_comment#729879)), 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#729744, at_stapat#729745, at_prefix#729746, at_nompat#729747, at_pnopat#729748, at_njfpat#729749, at_datnai#729750, at_datnaiss#729751, at_sexe#729752, at_numper#729753, at_sigma#729754, at_verrou#729755, at_poids#729756, at_indcen#729757, at_numss#729758, at_antece#729759, at_adr_1#729760, at_adr_2#729761, at_codpos#729762, at_ville#729763, at_pays#729764, at_numcai#729765, at_nummut#729766, at_numcha#729767, at_telpri#729768, at_telbur#729769, at_telpor#729770, at_fax#729771, at_prefi2#729772, at_nomass#729773, at_pnoass#729774, at_njfass#729775, at_datass#729776, at_adr_1a#729777, at_adr_2a#729778, at_codpoa#729779, at_villea#729780, at_codmed#729781, at_datcss#729782, at_datf_d#729783, at_dat100#729784, at_numsir#729785, at_numssa#729786, at_codser#729787, at_rngnai#729788, at_natass#729789, at_numacc#729790, at_datacc#729791, at_typexo#729792, at_datmaj#729793, at_coduti#729794, at_flcmu#729795, at_qualss#729796, at_codref#729797, at_codregat#729798, at_codcaiat#729799, at_indvital#729800, at_conmut#729801, at_adhmut#729802, at_garmut#729803, at_numper_ori#729804, at_codrout#729805, at_domaine#729806, at_indtrai#729807, at_idhote#729808, at_codsts#729809, at_nirind#729810, at_fldcd#729811, at_flphoto#729812, at_codmtr#729813, at_adr_3#729814, at_pays_iso#729815, at_adr_3a#729816, at_poids_maj#729817, at_codgestion#729818, at_art115#729819, at_taille#729820, at_taille_maj#729821, at_codetab_prod#729822, at_codsit_prod#729823, at_numdos_prod#729824, at_numper_prod#729825, at_numper_ori_prod#729826, at_ins#729827, at_ins_type#729828, at_ins_date#729829, at_ins_source#729830, at_stadmp#729831, at_datdmp#729832, at_alarmes#729833, at_email#729834, at_consent_sms#729835, at_dat_consent_sms#729836, at_datdcd#729837, at_flhlim#729838, at_dathlim#729839, at_codpershlim#729840, at_fldiff#729841, at_lisdest#729842, at_langue#729843, at_numcai_ft#729844, at_codtarifamc#729845, at_flgrve#729846, at_fladri#729847, at_datadri#729848, at_datf_mut#729849, at_comfac#729850, at_numdos_cloud#729851, at_nation#729852, at_titre#729853, at_titre_ass#729854, at_tiq_histoxml#729855, at_tiq_pnoliste#729856, at_codposnai#729857, at_insi#729858, at_insi_oid#729859, at_typconv#729860, at_crisec#729861, at_opereg#729862, at_flannuamc#729863, at_staipp#729864, at_pnonai#729865, at_codinseenai#729866, at_villenai#729867, at_piece_ident_pres#729868, at_dat_staipp#729869, at_datapcv#729870, at_num_apcv#729871, at_heuapcv#729872, at_numper_sec#729873, at_ins_heure#729874, at_persaprev#729875, at_tarif#729876, at_nomhl7#729877, at_numper_ori_oid#729878, at_comment#729879]

(7) Union

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

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

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

(11) HashAggregate [codegen id : 2]
Input [1]: [count#732349L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#732067L]
Results [1]: [count(1)#732067L AS COL_8f4b84d9-f42c-4af1-b0cd-bbdeab7201e3#732069L]

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

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

(14) HashAggregate
Input [1]: [count#732349L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#732067L]
Results [1]: [count(1)#732067L AS COL_8f4b84d9-f42c-4af1-b0cd-bbdeab7201e3#732069L]

(15) AdaptiveSparkPlan
Output [1]: [COL_8f4b84d9-f42c-4af1-b0cd-bbdeab7201e3#732069L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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