hdh-spark-job - Details for Query 1135

Submitted Time: 2026/10/23 08:37:32
Duration: 3 s
Succeeded Jobs: 1142 1144

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)) 1 ms (0 ms, 0 ms, 0 ms (stage 1565.0: task 1399)) 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 1565.0: task 1399)) 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 1565.0: task 1399))"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n4.9 s (2.4 s, 2.4 s, 2.4 s (stage 1565.0: task 1398))"; 5 [labelType="html" label="HashAggregate time in aggregation build total (min, med, max (stageId: taskId)) 4.9 s (2.4 s, 2.4 s, 2.4 s (stage 1565.0: task 1398)) number of output rows: 2"]; } 6 [labelType="html" label=" Union "]; 7 [labelType="html" label=" Project "]; 8 [labelType="html" label="Filter number of output rows: 3"]; 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: 3"]; 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=25738]

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

WholeStageCodegen (1)

Union

Project

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos#409708)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos#409708)), 0000000010) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stapat#409709)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_stapat#409709)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefix#409710)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_prefix#409710)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nompat#409711)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nompat#409711)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnopat#409712)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_pnopat#409712)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfpat#409713)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_njfpat#409713)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnai#409714)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datnai#409714)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnaiss#409715)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datnaiss#409715)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sexe#409716)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_sexe#409716)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper#409717)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper#409717)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sigma#409718)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_sigma#409718)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_verrou#409719)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_verrou#409719)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids#409720)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_poids#409720)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indcen#409721)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_indcen#409721)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numss#409722)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numss#409722)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_antece#409723)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_antece#409723)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1#409724)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1#409724)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2#409725)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2#409725)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpos#409726)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codpos#409726)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ville#409727)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ville#409727)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays#409728)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_pays#409728)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai#409729)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai#409729)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nummut#409730)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nummut#409730)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcha#409731)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numcha#409731)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpri#409732)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_telpri#409732)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telbur#409733)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_telbur#409733)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpor#409734)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_telpor#409734)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fax#409735)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_fax#409735)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefi2#409736)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_prefi2#409736)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomass#409737)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nomass#409737)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnoass#409738)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_pnoass#409738)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfass#409739)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_njfass#409739)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datass#409740)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datass#409740)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1a#409741)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1a#409741)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2a#409742)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2a#409742)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpoa#409743)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codpoa#409743)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villea#409744)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_villea#409744)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmed#409745)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codmed#409745)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datcss#409746)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datcss#409746)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_d#409747)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_d#409747)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat100#409748)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_dat100#409748)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numsir#409749)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numsir#409749)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numssa#409750)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numssa#409750)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codser#409751)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codser#409751)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_rngnai#409752)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_rngnai#409752)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_natass#409753)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_natass#409753)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numacc#409754)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numacc#409754)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datacc#409755)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datacc#409755)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typexo#409756)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_typexo#409756)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datmaj#409757)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datmaj#409757)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_coduti#409758)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_coduti#409758)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flcmu#409759)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_flcmu#409759)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_qualss#409760)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_qualss#409760)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codref#409761)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codref#409761)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codregat#409762)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codregat#409762)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codcaiat#409763)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codcaiat#409763)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indvital#409764)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_indvital#409764)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_conmut#409765)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_conmut#409765)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adhmut#409766)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adhmut#409766)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_garmut#409767)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_garmut#409767)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori#409768)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori#409768)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codrout#409769)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codrout#409769)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_domaine#409770)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_domaine#409770)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indtrai#409771)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_indtrai#409771)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_idhote#409772)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_idhote#409772)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsts#409773)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codsts#409773)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nirind#409774)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nirind#409774)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldcd#409775)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_fldcd#409775)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flphoto#409776)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_flphoto#409776)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmtr#409777)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codmtr#409777)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3#409778)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3#409778)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays_iso#409779)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_pays_iso#409779)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3a#409780)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3a#409780)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids_maj#409781)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_poids_maj#409781)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codgestion#409782)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codgestion#409782)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_art115#409783)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_art115#409783)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille#409784)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_taille#409784)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille_maj#409785)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_taille_maj#409785)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codetab_prod#409786)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codetab_prod#409786)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsit_prod#409787)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codsit_prod#409787)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_prod#409788)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_prod#409788)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_prod#409789)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_prod#409789)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_prod#409790)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_prod#409790)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins#409791)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ins#409791)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_type#409792)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_type#409792)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_date#409793)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_date#409793)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_source#409794)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_source#409794)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stadmp#409795)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_stadmp#409795)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdmp#409796)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datdmp#409796)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_alarmes#409797)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_alarmes#409797)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_email#409798)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_email#409798)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_consent_sms#409799)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_consent_sms#409799)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_consent_sms#409800)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_consent_sms#409800)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdcd#409801)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datdcd#409801)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flhlim#409802)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_flhlim#409802)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dathlim#409803)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_dathlim#409803)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpershlim#409804)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codpershlim#409804)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldiff#409805)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_fldiff#409805)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_lisdest#409806)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_lisdest#409806)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_langue#409807)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_langue#409807)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai_ft#409808)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai_ft#409808)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codtarifamc#409809)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codtarifamc#409809)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flgrve#409810)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_flgrve#409810)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fladri#409811)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_fladri#409811)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datadri#409812)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datadri#409812)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_mut#409813)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_mut#409813)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comfac#409814)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_comfac#409814)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_cloud#409815)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_cloud#409815)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nation#409816)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nation#409816)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre#409817)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_titre#409817)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre_ass#409818)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_titre_ass#409818)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_histoxml#409819)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_histoxml#409819)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_pnoliste#409820)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_pnoliste#409820)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codposnai#409821)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codposnai#409821)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi#409822)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_insi#409822)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi_oid#409823)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_insi_oid#409823)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typconv#409824)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_typconv#409824)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_crisec#409825)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_crisec#409825)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_opereg#409826)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_opereg#409826)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flannuamc#409827)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_flannuamc#409827)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_staipp#409828)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_staipp#409828)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnonai#409829)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_pnonai#409829)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codinseenai#409830)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codinseenai#409830)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villenai#409831)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_villenai#409831)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_piece_ident_pres#409832)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_piece_ident_pres#409832)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_staipp#409833)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_staipp#409833)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datapcv#409834)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datapcv#409834)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_num_apcv#409835)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_num_apcv#409835)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_heuapcv#409836)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_heuapcv#409836)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_sec#409837)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_sec#409837)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_heure#409838)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_heure#409838)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_persaprev#409839)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_persaprev#409839)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tarif#409840)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_tarif#409840)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomhl7#409841)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nomhl7#409841)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_oid#409842)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_oid#409842)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comment#409843)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_comment#409843)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_A))), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_A))), 0000000010) 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#409708,at_stapat#409709,at_prefix#409710,at_nompat#409711,at_pnopat#409712,at_njfpat#409713,at_datnai#409714,at_datnaiss#409715,at_sexe#409716,at_numper#409717,at_sigma#409718,at_verrou#409719,at_poids#409720,at_indcen#409721,at_numss#409722,at_antece#409723,at_adr_1#409724,at_adr_2#409725,at_codpos#409726,at_ville#409727,at_pays#409728,at_numcai#409729,at_nummut#409730,at_numcha#409731,... 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#410935)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos#410935)), 0000000010) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stapat#410936)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_stapat#410936)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefix#410937)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_prefix#410937)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nompat#410938)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nompat#410938)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnopat#410939)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_pnopat#410939)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfpat#410940)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_njfpat#410940)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnai#410941)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datnai#410941)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnaiss#410942)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datnaiss#410942)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sexe#410943)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_sexe#410943)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper#410944)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper#410944)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sigma#410945)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_sigma#410945)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_verrou#410946)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_verrou#410946)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids#410947)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_poids#410947)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indcen#410948)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_indcen#410948)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numss#410949)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numss#410949)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_antece#410950)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_antece#410950)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1#410951)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1#410951)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2#410952)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2#410952)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpos#410953)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codpos#410953)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ville#410954)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ville#410954)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays#410955)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_pays#410955)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai#410956)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai#410956)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nummut#410957)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nummut#410957)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcha#410958)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numcha#410958)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpri#410959)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_telpri#410959)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telbur#410960)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_telbur#410960)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpor#410961)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_telpor#410961)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fax#410962)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_fax#410962)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefi2#410963)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_prefi2#410963)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomass#410964)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nomass#410964)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnoass#410965)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_pnoass#410965)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfass#410966)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_njfass#410966)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datass#410967)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datass#410967)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1a#410968)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1a#410968)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2a#410969)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2a#410969)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpoa#410970)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codpoa#410970)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villea#410971)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_villea#410971)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmed#410972)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codmed#410972)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datcss#410973)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datcss#410973)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_d#410974)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_d#410974)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat100#410975)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_dat100#410975)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numsir#410976)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numsir#410976)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numssa#410977)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numssa#410977)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codser#410978)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codser#410978)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_rngnai#410979)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_rngnai#410979)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_natass#410980)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_natass#410980)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numacc#410981)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numacc#410981)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datacc#410982)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datacc#410982)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typexo#410983)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_typexo#410983)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datmaj#410984)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datmaj#410984)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_coduti#410985)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_coduti#410985)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flcmu#410986)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_flcmu#410986)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_qualss#410987)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_qualss#410987)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codref#410988)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codref#410988)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codregat#410989)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codregat#410989)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codcaiat#410990)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codcaiat#410990)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indvital#410991)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_indvital#410991)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_conmut#410992)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_conmut#410992)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adhmut#410993)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adhmut#410993)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_garmut#410994)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_garmut#410994)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori#410995)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori#410995)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codrout#410996)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codrout#410996)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_domaine#410997)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_domaine#410997)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indtrai#410998)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_indtrai#410998)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_idhote#410999)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_idhote#410999)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsts#411000)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codsts#411000)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nirind#411001)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nirind#411001)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldcd#411002)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_fldcd#411002)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flphoto#411003)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_flphoto#411003)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmtr#411004)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codmtr#411004)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3#411005)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3#411005)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays_iso#411006)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_pays_iso#411006)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3a#411007)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3a#411007)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids_maj#411008)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_poids_maj#411008)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codgestion#411009)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codgestion#411009)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_art115#411010)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_art115#411010)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille#411011)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_taille#411011)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille_maj#411012)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_taille_maj#411012)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codetab_prod#411013)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codetab_prod#411013)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsit_prod#411014)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codsit_prod#411014)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_prod#411015)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_prod#411015)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_prod#411016)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_prod#411016)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_prod#411017)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_prod#411017)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins#411018)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ins#411018)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_type#411019)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_type#411019)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_date#411020)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_date#411020)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_source#411021)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_source#411021)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stadmp#411022)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_stadmp#411022)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdmp#411023)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datdmp#411023)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_alarmes#411024)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_alarmes#411024)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_email#411025)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_email#411025)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_consent_sms#411026)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_consent_sms#411026)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_consent_sms#411027)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_consent_sms#411027)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdcd#411028)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datdcd#411028)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flhlim#411029)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_flhlim#411029)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dathlim#411030)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_dathlim#411030)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpershlim#411031)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codpershlim#411031)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldiff#411032)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_fldiff#411032)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_lisdest#411033)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_lisdest#411033)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_langue#411034)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_langue#411034)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai_ft#411035)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai_ft#411035)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codtarifamc#411036)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codtarifamc#411036)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flgrve#411037)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_flgrve#411037)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fladri#411038)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_fladri#411038)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datadri#411039)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datadri#411039)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_mut#411040)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_mut#411040)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comfac#411041)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_comfac#411041)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_cloud#411042)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_cloud#411042)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nation#411043)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nation#411043)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre#411044)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_titre#411044)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre_ass#411045)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_titre_ass#411045)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_histoxml#411046)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_histoxml#411046)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_pnoliste#411047)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_pnoliste#411047)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codposnai#411048)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codposnai#411048)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi#411049)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_insi#411049)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi_oid#411050)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_insi_oid#411050)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typconv#411051)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_typconv#411051)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_crisec#411052)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_crisec#411052)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_opereg#411053)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_opereg#411053)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flannuamc#411054)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_flannuamc#411054)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_staipp#411055)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_staipp#411055)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnonai#411056)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_pnonai#411056)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codinseenai#411057)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codinseenai#411057)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villenai#411058)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_villenai#411058)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_piece_ident_pres#411059)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_piece_ident_pres#411059)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_staipp#411060)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_staipp#411060)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datapcv#411061)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datapcv#411061)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_num_apcv#411062)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_num_apcv#411062)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_heuapcv#411063)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_heuapcv#411063)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_sec#411064)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_sec#411064)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_heure#411065)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_heure#411065)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_persaprev#411066)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_persaprev#411066)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tarif#411067)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_tarif#411067)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomhl7#411068)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nomhl7#411068)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_oid#411069)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_oid#411069)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comment#411070)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_comment#411070)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_B))), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_B))), 0000000010) 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#410935,at_stapat#410936,at_prefix#410937,at_nompat#410938,at_pnopat#410939,at_njfpat#410940,at_datnai#410941,at_datnaiss#410942,at_sexe#410943,at_numper#410944,at_sigma#410945,at_verrou#410946,at_poids#410947,at_indcen#410948,at_numss#410949,at_antece#410950,at_adr_1#410951,at_adr_2#410952,at_codpos#410953,at_ville#410954,at_pays#410955,at_numcai#410956,at_nummut#410957,at_numcha#410958,... 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#409708, at_stapat#409709, at_prefix#409710, at_nompat#409711, at_pnopat#409712, at_njfpat#409713, at_datnai#409714, at_datnaiss#409715, at_sexe#409716, at_numper#409717, at_sigma#409718, at_verrou#409719, at_poids#409720, at_indcen#409721, at_numss#409722, at_antece#409723, at_adr_1#409724, at_adr_2#409725, at_codpos#409726, at_ville#409727, at_pays#409728, at_numcai#409729, at_nummut#409730, at_numcha#409731, at_telpri#409732, at_telbur#409733, at_telpor#409734, at_fax#409735, at_prefi2#409736, at_nomass#409737, at_pnoass#409738, at_njfass#409739, at_datass#409740, at_adr_1a#409741, at_adr_2a#409742, at_codpoa#409743, at_villea#409744, at_codmed#409745, at_datcss#409746, at_datf_d#409747, at_dat100#409748, at_numsir#409749, at_numssa#409750, at_codser#409751, at_rngnai#409752, at_natass#409753, at_numacc#409754, at_datacc#409755, at_typexo#409756, at_datmaj#409757, at_coduti#409758, at_flcmu#409759, at_qualss#409760, at_codref#409761, at_codregat#409762, at_codcaiat#409763, at_indvital#409764, at_conmut#409765, at_adhmut#409766, at_garmut#409767, at_numper_ori#409768, at_codrout#409769, at_domaine#409770, at_indtrai#409771, at_idhote#409772, at_codsts#409773, at_nirind#409774, at_fldcd#409775, at_flphoto#409776, at_codmtr#409777, at_adr_3#409778, at_pays_iso#409779, at_adr_3a#409780, at_poids_maj#409781, at_codgestion#409782, at_art115#409783, at_taille#409784, at_taille_maj#409785, at_codetab_prod#409786, at_codsit_prod#409787, at_numdos_prod#409788, at_numper_prod#409789, at_numper_ori_prod#409790, at_ins#409791, at_ins_type#409792, at_ins_date#409793, at_ins_source#409794, at_stadmp#409795, at_datdmp#409796, at_alarmes#409797, at_email#409798, at_consent_sms#409799, at_dat_consent_sms#409800, at_datdcd#409801, at_flhlim#409802, at_dathlim#409803, at_codpershlim#409804, at_fldiff#409805, at_lisdest#409806, at_langue#409807, at_numcai_ft#409808, at_codtarifamc#409809, at_flgrve#409810, at_fladri#409811, at_datadri#409812, at_datf_mut#409813, at_comfac#409814, at_numdos_cloud#409815, at_nation#409816, at_titre#409817, at_titre_ass#409818, at_tiq_histoxml#409819, at_tiq_pnoliste#409820, at_codposnai#409821, at_insi#409822, at_insi_oid#409823, at_typconv#409824, at_crisec#409825, at_opereg#409826, at_flannuamc#409827, at_staipp#409828, at_pnonai#409829, at_codinseenai#409830, at_villenai#409831, at_piece_ident_pres#409832, at_dat_staipp#409833, at_datapcv#409834, at_num_apcv#409835, at_heuapcv#409836, at_numper_sec#409837, at_ins_heure#409838, at_persaprev#409839, at_tarif#409840, at_nomhl7#409841, at_numper_ori_oid#409842, at_comment#409843]
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#409708, at_stapat#409709, at_prefix#409710, at_nompat#409711, at_pnopat#409712, at_njfpat#409713, at_datnai#409714, at_datnaiss#409715, at_sexe#409716, at_numper#409717, at_sigma#409718, at_verrou#409719, at_poids#409720, at_indcen#409721, at_numss#409722, at_antece#409723, at_adr_1#409724, at_adr_2#409725, at_codpos#409726, at_ville#409727, at_pays#409728, at_numcai#409729, at_nummut#409730, at_numcha#409731, at_telpri#409732, at_telbur#409733, at_telpor#409734, at_fax#409735, at_prefi2#409736, at_nomass#409737, at_pnoass#409738, at_njfass#409739, at_datass#409740, at_adr_1a#409741, at_adr_2a#409742, at_codpoa#409743, at_villea#409744, at_codmed#409745, at_datcss#409746, at_datf_d#409747, at_dat100#409748, at_numsir#409749, at_numssa#409750, at_codser#409751, at_rngnai#409752, at_natass#409753, at_numacc#409754, at_datacc#409755, at_typexo#409756, at_datmaj#409757, at_coduti#409758, at_flcmu#409759, at_qualss#409760, at_codref#409761, at_codregat#409762, at_codcaiat#409763, at_indvital#409764, at_conmut#409765, at_adhmut#409766, at_garmut#409767, at_numper_ori#409768, at_codrout#409769, at_domaine#409770, at_indtrai#409771, at_idhote#409772, at_codsts#409773, at_nirind#409774, at_fldcd#409775, at_flphoto#409776, at_codmtr#409777, at_adr_3#409778, at_pays_iso#409779, at_adr_3a#409780, at_poids_maj#409781, at_codgestion#409782, at_art115#409783, at_taille#409784, at_taille_maj#409785, at_codetab_prod#409786, at_codsit_prod#409787, at_numdos_prod#409788, at_numper_prod#409789, at_numper_ori_prod#409790, at_ins#409791, at_ins_type#409792, at_ins_date#409793, at_ins_source#409794, at_stadmp#409795, at_datdmp#409796, at_alarmes#409797, at_email#409798, at_consent_sms#409799, at_dat_consent_sms#409800, at_datdcd#409801, at_flhlim#409802, at_dathlim#409803, at_codpershlim#409804, at_fldiff#409805, at_lisdest#409806, at_langue#409807, at_numcai_ft#409808, at_codtarifamc#409809, at_flgrve#409810, at_fladri#409811, at_datadri#409812, at_datf_mut#409813, at_comfac#409814, at_numdos_cloud#409815, at_nation#409816, at_titre#409817, at_titre_ass#409818, at_tiq_histoxml#409819, at_tiq_pnoliste#409820, at_codposnai#409821, at_insi#409822, at_insi_oid#409823, at_typconv#409824, at_crisec#409825, at_opereg#409826, at_flannuamc#409827, at_staipp#409828, at_pnonai#409829, at_codinseenai#409830, at_villenai#409831, at_piece_ident_pres#409832, at_dat_staipp#409833, at_datapcv#409834, at_num_apcv#409835, at_heuapcv#409836, at_numper_sec#409837, at_ins_heure#409838, at_persaprev#409839, at_tarif#409840, at_nomhl7#409841, at_numper_ori_oid#409842, at_comment#409843]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos#409708)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos#409708)), 0000000010) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stapat#409709)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_stapat#409709)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefix#409710)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_prefix#409710)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nompat#409711)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nompat#409711)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnopat#409712)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_pnopat#409712)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfpat#409713)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_njfpat#409713)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnai#409714)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datnai#409714)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnaiss#409715)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datnaiss#409715)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sexe#409716)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_sexe#409716)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper#409717)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper#409717)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sigma#409718)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_sigma#409718)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_verrou#409719)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_verrou#409719)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids#409720)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_poids#409720)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indcen#409721)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_indcen#409721)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numss#409722)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numss#409722)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_antece#409723)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_antece#409723)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1#409724)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1#409724)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2#409725)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2#409725)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpos#409726)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codpos#409726)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ville#409727)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ville#409727)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays#409728)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_pays#409728)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai#409729)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai#409729)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nummut#409730)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nummut#409730)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcha#409731)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numcha#409731)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpri#409732)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_telpri#409732)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telbur#409733)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_telbur#409733)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpor#409734)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_telpor#409734)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fax#409735)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_fax#409735)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefi2#409736)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_prefi2#409736)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomass#409737)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nomass#409737)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnoass#409738)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_pnoass#409738)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfass#409739)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_njfass#409739)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datass#409740)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datass#409740)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1a#409741)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1a#409741)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2a#409742)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2a#409742)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpoa#409743)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codpoa#409743)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villea#409744)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_villea#409744)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmed#409745)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codmed#409745)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datcss#409746)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datcss#409746)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_d#409747)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_d#409747)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat100#409748)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_dat100#409748)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numsir#409749)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numsir#409749)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numssa#409750)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numssa#409750)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codser#409751)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codser#409751)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_rngnai#409752)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_rngnai#409752)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_natass#409753)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_natass#409753)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numacc#409754)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numacc#409754)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datacc#409755)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datacc#409755)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typexo#409756)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_typexo#409756)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datmaj#409757)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datmaj#409757)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_coduti#409758)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_coduti#409758)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flcmu#409759)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_flcmu#409759)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_qualss#409760)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_qualss#409760)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codref#409761)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codref#409761)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codregat#409762)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codregat#409762)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codcaiat#409763)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codcaiat#409763)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indvital#409764)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_indvital#409764)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_conmut#409765)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_conmut#409765)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adhmut#409766)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adhmut#409766)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_garmut#409767)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_garmut#409767)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori#409768)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori#409768)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codrout#409769)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codrout#409769)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_domaine#409770)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_domaine#409770)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indtrai#409771)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_indtrai#409771)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_idhote#409772)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_idhote#409772)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsts#409773)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codsts#409773)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nirind#409774)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nirind#409774)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldcd#409775)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_fldcd#409775)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flphoto#409776)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_flphoto#409776)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmtr#409777)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codmtr#409777)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3#409778)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3#409778)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays_iso#409779)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_pays_iso#409779)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3a#409780)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3a#409780)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids_maj#409781)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_poids_maj#409781)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codgestion#409782)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codgestion#409782)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_art115#409783)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_art115#409783)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille#409784)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_taille#409784)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille_maj#409785)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_taille_maj#409785)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codetab_prod#409786)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codetab_prod#409786)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsit_prod#409787)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codsit_prod#409787)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_prod#409788)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_prod#409788)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_prod#409789)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_prod#409789)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_prod#409790)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_prod#409790)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins#409791)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ins#409791)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_type#409792)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_type#409792)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_date#409793)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_date#409793)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_source#409794)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_source#409794)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stadmp#409795)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_stadmp#409795)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdmp#409796)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datdmp#409796)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_alarmes#409797)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_alarmes#409797)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_email#409798)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_email#409798)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_consent_sms#409799)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_consent_sms#409799)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_consent_sms#409800)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_consent_sms#409800)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdcd#409801)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datdcd#409801)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flhlim#409802)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_flhlim#409802)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dathlim#409803)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_dathlim#409803)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpershlim#409804)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codpershlim#409804)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldiff#409805)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_fldiff#409805)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_lisdest#409806)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_lisdest#409806)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_langue#409807)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_langue#409807)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai_ft#409808)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai_ft#409808)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codtarifamc#409809)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codtarifamc#409809)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flgrve#409810)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_flgrve#409810)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fladri#409811)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_fladri#409811)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datadri#409812)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datadri#409812)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_mut#409813)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_mut#409813)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comfac#409814)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_comfac#409814)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_cloud#409815)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_cloud#409815)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nation#409816)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nation#409816)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre#409817)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_titre#409817)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre_ass#409818)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_titre_ass#409818)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_histoxml#409819)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_histoxml#409819)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_pnoliste#409820)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_pnoliste#409820)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codposnai#409821)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codposnai#409821)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi#409822)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_insi#409822)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi_oid#409823)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_insi_oid#409823)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typconv#409824)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_typconv#409824)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_crisec#409825)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_crisec#409825)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_opereg#409826)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_opereg#409826)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flannuamc#409827)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_flannuamc#409827)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_staipp#409828)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_staipp#409828)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnonai#409829)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_pnonai#409829)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codinseenai#409830)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codinseenai#409830)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villenai#409831)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_villenai#409831)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_piece_ident_pres#409832)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_piece_ident_pres#409832)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_staipp#409833)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_staipp#409833)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datapcv#409834)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datapcv#409834)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_num_apcv#409835)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_num_apcv#409835)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_heuapcv#409836)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_heuapcv#409836)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_sec#409837)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_sec#409837)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_heure#409838)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_heure#409838)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_persaprev#409839)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_persaprev#409839)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tarif#409840)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_tarif#409840)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomhl7#409841)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nomhl7#409841)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_oid#409842)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_oid#409842)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comment#409843)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_comment#409843)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_A))), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_A))), 0000000010) END)

(3) Project
Output: []
Input [136]: [at_numdos#409708, at_stapat#409709, at_prefix#409710, at_nompat#409711, at_pnopat#409712, at_njfpat#409713, at_datnai#409714, at_datnaiss#409715, at_sexe#409716, at_numper#409717, at_sigma#409718, at_verrou#409719, at_poids#409720, at_indcen#409721, at_numss#409722, at_antece#409723, at_adr_1#409724, at_adr_2#409725, at_codpos#409726, at_ville#409727, at_pays#409728, at_numcai#409729, at_nummut#409730, at_numcha#409731, at_telpri#409732, at_telbur#409733, at_telpor#409734, at_fax#409735, at_prefi2#409736, at_nomass#409737, at_pnoass#409738, at_njfass#409739, at_datass#409740, at_adr_1a#409741, at_adr_2a#409742, at_codpoa#409743, at_villea#409744, at_codmed#409745, at_datcss#409746, at_datf_d#409747, at_dat100#409748, at_numsir#409749, at_numssa#409750, at_codser#409751, at_rngnai#409752, at_natass#409753, at_numacc#409754, at_datacc#409755, at_typexo#409756, at_datmaj#409757, at_coduti#409758, at_flcmu#409759, at_qualss#409760, at_codref#409761, at_codregat#409762, at_codcaiat#409763, at_indvital#409764, at_conmut#409765, at_adhmut#409766, at_garmut#409767, at_numper_ori#409768, at_codrout#409769, at_domaine#409770, at_indtrai#409771, at_idhote#409772, at_codsts#409773, at_nirind#409774, at_fldcd#409775, at_flphoto#409776, at_codmtr#409777, at_adr_3#409778, at_pays_iso#409779, at_adr_3a#409780, at_poids_maj#409781, at_codgestion#409782, at_art115#409783, at_taille#409784, at_taille_maj#409785, at_codetab_prod#409786, at_codsit_prod#409787, at_numdos_prod#409788, at_numper_prod#409789, at_numper_ori_prod#409790, at_ins#409791, at_ins_type#409792, at_ins_date#409793, at_ins_source#409794, at_stadmp#409795, at_datdmp#409796, at_alarmes#409797, at_email#409798, at_consent_sms#409799, at_dat_consent_sms#409800, at_datdcd#409801, at_flhlim#409802, at_dathlim#409803, at_codpershlim#409804, at_fldiff#409805, at_lisdest#409806, at_langue#409807, at_numcai_ft#409808, at_codtarifamc#409809, at_flgrve#409810, at_fladri#409811, at_datadri#409812, at_datf_mut#409813, at_comfac#409814, at_numdos_cloud#409815, at_nation#409816, at_titre#409817, at_titre_ass#409818, at_tiq_histoxml#409819, at_tiq_pnoliste#409820, at_codposnai#409821, at_insi#409822, at_insi_oid#409823, at_typconv#409824, at_crisec#409825, at_opereg#409826, at_flannuamc#409827, at_staipp#409828, at_pnonai#409829, at_codinseenai#409830, at_villenai#409831, at_piece_ident_pres#409832, at_dat_staipp#409833, at_datapcv#409834, at_num_apcv#409835, at_heuapcv#409836, at_numper_sec#409837, at_ins_heure#409838, at_persaprev#409839, at_tarif#409840, at_nomhl7#409841, at_numper_ori_oid#409842, at_comment#409843]

(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#410935, at_stapat#410936, at_prefix#410937, at_nompat#410938, at_pnopat#410939, at_njfpat#410940, at_datnai#410941, at_datnaiss#410942, at_sexe#410943, at_numper#410944, at_sigma#410945, at_verrou#410946, at_poids#410947, at_indcen#410948, at_numss#410949, at_antece#410950, at_adr_1#410951, at_adr_2#410952, at_codpos#410953, at_ville#410954, at_pays#410955, at_numcai#410956, at_nummut#410957, at_numcha#410958, at_telpri#410959, at_telbur#410960, at_telpor#410961, at_fax#410962, at_prefi2#410963, at_nomass#410964, at_pnoass#410965, at_njfass#410966, at_datass#410967, at_adr_1a#410968, at_adr_2a#410969, at_codpoa#410970, at_villea#410971, at_codmed#410972, at_datcss#410973, at_datf_d#410974, at_dat100#410975, at_numsir#410976, at_numssa#410977, at_codser#410978, at_rngnai#410979, at_natass#410980, at_numacc#410981, at_datacc#410982, at_typexo#410983, at_datmaj#410984, at_coduti#410985, at_flcmu#410986, at_qualss#410987, at_codref#410988, at_codregat#410989, at_codcaiat#410990, at_indvital#410991, at_conmut#410992, at_adhmut#410993, at_garmut#410994, at_numper_ori#410995, at_codrout#410996, at_domaine#410997, at_indtrai#410998, at_idhote#410999, at_codsts#411000, at_nirind#411001, at_fldcd#411002, at_flphoto#411003, at_codmtr#411004, at_adr_3#411005, at_pays_iso#411006, at_adr_3a#411007, at_poids_maj#411008, at_codgestion#411009, at_art115#411010, at_taille#411011, at_taille_maj#411012, at_codetab_prod#411013, at_codsit_prod#411014, at_numdos_prod#411015, at_numper_prod#411016, at_numper_ori_prod#411017, at_ins#411018, at_ins_type#411019, at_ins_date#411020, at_ins_source#411021, at_stadmp#411022, at_datdmp#411023, at_alarmes#411024, at_email#411025, at_consent_sms#411026, at_dat_consent_sms#411027, at_datdcd#411028, at_flhlim#411029, at_dathlim#411030, at_codpershlim#411031, at_fldiff#411032, at_lisdest#411033, at_langue#411034, at_numcai_ft#411035, at_codtarifamc#411036, at_flgrve#411037, at_fladri#411038, at_datadri#411039, at_datf_mut#411040, at_comfac#411041, at_numdos_cloud#411042, at_nation#411043, at_titre#411044, at_titre_ass#411045, at_tiq_histoxml#411046, at_tiq_pnoliste#411047, at_codposnai#411048, at_insi#411049, at_insi_oid#411050, at_typconv#411051, at_crisec#411052, at_opereg#411053, at_flannuamc#411054, at_staipp#411055, at_pnonai#411056, at_codinseenai#411057, at_villenai#411058, at_piece_ident_pres#411059, at_dat_staipp#411060, at_datapcv#411061, at_num_apcv#411062, at_heuapcv#411063, at_numper_sec#411064, at_ins_heure#411065, at_persaprev#411066, at_tarif#411067, at_nomhl7#411068, at_numper_ori_oid#411069, at_comment#411070]
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#410935, at_stapat#410936, at_prefix#410937, at_nompat#410938, at_pnopat#410939, at_njfpat#410940, at_datnai#410941, at_datnaiss#410942, at_sexe#410943, at_numper#410944, at_sigma#410945, at_verrou#410946, at_poids#410947, at_indcen#410948, at_numss#410949, at_antece#410950, at_adr_1#410951, at_adr_2#410952, at_codpos#410953, at_ville#410954, at_pays#410955, at_numcai#410956, at_nummut#410957, at_numcha#410958, at_telpri#410959, at_telbur#410960, at_telpor#410961, at_fax#410962, at_prefi2#410963, at_nomass#410964, at_pnoass#410965, at_njfass#410966, at_datass#410967, at_adr_1a#410968, at_adr_2a#410969, at_codpoa#410970, at_villea#410971, at_codmed#410972, at_datcss#410973, at_datf_d#410974, at_dat100#410975, at_numsir#410976, at_numssa#410977, at_codser#410978, at_rngnai#410979, at_natass#410980, at_numacc#410981, at_datacc#410982, at_typexo#410983, at_datmaj#410984, at_coduti#410985, at_flcmu#410986, at_qualss#410987, at_codref#410988, at_codregat#410989, at_codcaiat#410990, at_indvital#410991, at_conmut#410992, at_adhmut#410993, at_garmut#410994, at_numper_ori#410995, at_codrout#410996, at_domaine#410997, at_indtrai#410998, at_idhote#410999, at_codsts#411000, at_nirind#411001, at_fldcd#411002, at_flphoto#411003, at_codmtr#411004, at_adr_3#411005, at_pays_iso#411006, at_adr_3a#411007, at_poids_maj#411008, at_codgestion#411009, at_art115#411010, at_taille#411011, at_taille_maj#411012, at_codetab_prod#411013, at_codsit_prod#411014, at_numdos_prod#411015, at_numper_prod#411016, at_numper_ori_prod#411017, at_ins#411018, at_ins_type#411019, at_ins_date#411020, at_ins_source#411021, at_stadmp#411022, at_datdmp#411023, at_alarmes#411024, at_email#411025, at_consent_sms#411026, at_dat_consent_sms#411027, at_datdcd#411028, at_flhlim#411029, at_dathlim#411030, at_codpershlim#411031, at_fldiff#411032, at_lisdest#411033, at_langue#411034, at_numcai_ft#411035, at_codtarifamc#411036, at_flgrve#411037, at_fladri#411038, at_datadri#411039, at_datf_mut#411040, at_comfac#411041, at_numdos_cloud#411042, at_nation#411043, at_titre#411044, at_titre_ass#411045, at_tiq_histoxml#411046, at_tiq_pnoliste#411047, at_codposnai#411048, at_insi#411049, at_insi_oid#411050, at_typconv#411051, at_crisec#411052, at_opereg#411053, at_flannuamc#411054, at_staipp#411055, at_pnonai#411056, at_codinseenai#411057, at_villenai#411058, at_piece_ident_pres#411059, at_dat_staipp#411060, at_datapcv#411061, at_num_apcv#411062, at_heuapcv#411063, at_numper_sec#411064, at_ins_heure#411065, at_persaprev#411066, at_tarif#411067, at_nomhl7#411068, at_numper_ori_oid#411069, at_comment#411070]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos#410935)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos#410935)), 0000000010) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stapat#410936)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_stapat#410936)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefix#410937)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_prefix#410937)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nompat#410938)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nompat#410938)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnopat#410939)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_pnopat#410939)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfpat#410940)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_njfpat#410940)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnai#410941)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datnai#410941)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datnaiss#410942)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datnaiss#410942)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sexe#410943)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_sexe#410943)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper#410944)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper#410944)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_sigma#410945)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_sigma#410945)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_verrou#410946)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_verrou#410946)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids#410947)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_poids#410947)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indcen#410948)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_indcen#410948)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numss#410949)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numss#410949)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_antece#410950)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_antece#410950)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1#410951)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1#410951)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2#410952)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2#410952)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpos#410953)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codpos#410953)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ville#410954)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ville#410954)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays#410955)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_pays#410955)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai#410956)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai#410956)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nummut#410957)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nummut#410957)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcha#410958)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numcha#410958)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpri#410959)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_telpri#410959)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telbur#410960)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_telbur#410960)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_telpor#410961)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_telpor#410961)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fax#410962)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_fax#410962)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_prefi2#410963)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_prefi2#410963)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomass#410964)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nomass#410964)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnoass#410965)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_pnoass#410965)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_njfass#410966)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_njfass#410966)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datass#410967)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datass#410967)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_1a#410968)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_1a#410968)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_2a#410969)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_2a#410969)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpoa#410970)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codpoa#410970)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villea#410971)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_villea#410971)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmed#410972)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codmed#410972)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datcss#410973)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datcss#410973)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_d#410974)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_d#410974)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat100#410975)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_dat100#410975)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numsir#410976)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numsir#410976)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numssa#410977)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numssa#410977)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codser#410978)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codser#410978)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_rngnai#410979)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_rngnai#410979)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_natass#410980)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_natass#410980)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numacc#410981)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numacc#410981)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datacc#410982)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datacc#410982)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typexo#410983)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_typexo#410983)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datmaj#410984)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datmaj#410984)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_coduti#410985)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_coduti#410985)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flcmu#410986)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_flcmu#410986)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_qualss#410987)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_qualss#410987)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codref#410988)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codref#410988)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codregat#410989)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codregat#410989)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codcaiat#410990)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codcaiat#410990)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indvital#410991)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_indvital#410991)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_conmut#410992)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_conmut#410992)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adhmut#410993)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adhmut#410993)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_garmut#410994)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_garmut#410994)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori#410995)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori#410995)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codrout#410996)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codrout#410996)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_domaine#410997)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_domaine#410997)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_indtrai#410998)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_indtrai#410998)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_idhote#410999)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_idhote#410999)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsts#411000)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codsts#411000)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nirind#411001)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nirind#411001)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldcd#411002)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_fldcd#411002)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flphoto#411003)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_flphoto#411003)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codmtr#411004)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codmtr#411004)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3#411005)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3#411005)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pays_iso#411006)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_pays_iso#411006)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_adr_3a#411007)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_adr_3a#411007)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_poids_maj#411008)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_poids_maj#411008)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codgestion#411009)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codgestion#411009)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_art115#411010)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_art115#411010)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille#411011)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_taille#411011)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_taille_maj#411012)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_taille_maj#411012)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codetab_prod#411013)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codetab_prod#411013)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codsit_prod#411014)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codsit_prod#411014)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_prod#411015)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_prod#411015)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_prod#411016)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_prod#411016)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_prod#411017)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_prod#411017)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins#411018)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ins#411018)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_type#411019)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_type#411019)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_date#411020)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_date#411020)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_source#411021)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_source#411021)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_stadmp#411022)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_stadmp#411022)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdmp#411023)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datdmp#411023)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_alarmes#411024)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_alarmes#411024)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_email#411025)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_email#411025)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_consent_sms#411026)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_consent_sms#411026)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_consent_sms#411027)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_consent_sms#411027)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datdcd#411028)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datdcd#411028)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flhlim#411029)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_flhlim#411029)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dathlim#411030)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_dathlim#411030)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codpershlim#411031)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codpershlim#411031)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fldiff#411032)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_fldiff#411032)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_lisdest#411033)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_lisdest#411033)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_langue#411034)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_langue#411034)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numcai_ft#411035)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numcai_ft#411035)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codtarifamc#411036)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codtarifamc#411036)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flgrve#411037)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_flgrve#411037)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_fladri#411038)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_fladri#411038)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datadri#411039)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datadri#411039)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datf_mut#411040)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datf_mut#411040)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comfac#411041)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_comfac#411041)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numdos_cloud#411042)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numdos_cloud#411042)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nation#411043)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nation#411043)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre#411044)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_titre#411044)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_titre_ass#411045)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_titre_ass#411045)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_histoxml#411046)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_histoxml#411046)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tiq_pnoliste#411047)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_tiq_pnoliste#411047)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codposnai#411048)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codposnai#411048)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi#411049)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_insi#411049)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_insi_oid#411050)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_insi_oid#411050)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_typconv#411051)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_typconv#411051)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_crisec#411052)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_crisec#411052)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_opereg#411053)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_opereg#411053)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_flannuamc#411054)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_flannuamc#411054)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_staipp#411055)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_staipp#411055)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_pnonai#411056)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_pnonai#411056)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_codinseenai#411057)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_codinseenai#411057)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_villenai#411058)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_villenai#411058)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_piece_ident_pres#411059)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_piece_ident_pres#411059)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_dat_staipp#411060)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_dat_staipp#411060)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_datapcv#411061)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_datapcv#411061)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_num_apcv#411062)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_num_apcv#411062)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_heuapcv#411063)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_heuapcv#411063)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_sec#411064)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_sec#411064)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_ins_heure#411065)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_ins_heure#411065)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_persaprev#411066)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_persaprev#411066)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_tarif#411067)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_tarif#411067)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_nomhl7#411068)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_nomhl7#411068)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_numper_ori_oid#411069)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_numper_ori_oid#411069)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(at_comment#411070)), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(at_comment#411070)), 0000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_B))), 0000000010)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_B))), 0000000010) END)

(6) Project
Output: []
Input [136]: [at_numdos#410935, at_stapat#410936, at_prefix#410937, at_nompat#410938, at_pnopat#410939, at_njfpat#410940, at_datnai#410941, at_datnaiss#410942, at_sexe#410943, at_numper#410944, at_sigma#410945, at_verrou#410946, at_poids#410947, at_indcen#410948, at_numss#410949, at_antece#410950, at_adr_1#410951, at_adr_2#410952, at_codpos#410953, at_ville#410954, at_pays#410955, at_numcai#410956, at_nummut#410957, at_numcha#410958, at_telpri#410959, at_telbur#410960, at_telpor#410961, at_fax#410962, at_prefi2#410963, at_nomass#410964, at_pnoass#410965, at_njfass#410966, at_datass#410967, at_adr_1a#410968, at_adr_2a#410969, at_codpoa#410970, at_villea#410971, at_codmed#410972, at_datcss#410973, at_datf_d#410974, at_dat100#410975, at_numsir#410976, at_numssa#410977, at_codser#410978, at_rngnai#410979, at_natass#410980, at_numacc#410981, at_datacc#410982, at_typexo#410983, at_datmaj#410984, at_coduti#410985, at_flcmu#410986, at_qualss#410987, at_codref#410988, at_codregat#410989, at_codcaiat#410990, at_indvital#410991, at_conmut#410992, at_adhmut#410993, at_garmut#410994, at_numper_ori#410995, at_codrout#410996, at_domaine#410997, at_indtrai#410998, at_idhote#410999, at_codsts#411000, at_nirind#411001, at_fldcd#411002, at_flphoto#411003, at_codmtr#411004, at_adr_3#411005, at_pays_iso#411006, at_adr_3a#411007, at_poids_maj#411008, at_codgestion#411009, at_art115#411010, at_taille#411011, at_taille_maj#411012, at_codetab_prod#411013, at_codsit_prod#411014, at_numdos_prod#411015, at_numper_prod#411016, at_numper_ori_prod#411017, at_ins#411018, at_ins_type#411019, at_ins_date#411020, at_ins_source#411021, at_stadmp#411022, at_datdmp#411023, at_alarmes#411024, at_email#411025, at_consent_sms#411026, at_dat_consent_sms#411027, at_datdcd#411028, at_flhlim#411029, at_dathlim#411030, at_codpershlim#411031, at_fldiff#411032, at_lisdest#411033, at_langue#411034, at_numcai_ft#411035, at_codtarifamc#411036, at_flgrve#411037, at_fladri#411038, at_datadri#411039, at_datf_mut#411040, at_comfac#411041, at_numdos_cloud#411042, at_nation#411043, at_titre#411044, at_titre_ass#411045, at_tiq_histoxml#411046, at_tiq_pnoliste#411047, at_codposnai#411048, at_insi#411049, at_insi_oid#411050, at_typconv#411051, at_crisec#411052, at_opereg#411053, at_flannuamc#411054, at_staipp#411055, at_pnonai#411056, at_codinseenai#411057, at_villenai#411058, at_piece_ident_pres#411059, at_dat_staipp#411060, at_datapcv#411061, at_num_apcv#411062, at_heuapcv#411063, at_numper_sec#411064, at_ins_heure#411065, at_persaprev#411066, at_tarif#411067, at_nomhl7#411068, at_numper_ori_oid#411069, at_comment#411070]

(7) Union

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

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

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

(11) HashAggregate [codegen id : 2]
Input [1]: [count#414084L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#413806L]
Results [1]: [count(1)#413806L AS count#413807L]

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

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

(14) HashAggregate
Input [1]: [count#414084L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#413806L]
Results [1]: [count(1)#413806L AS count#413807L]

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

SQL / DataFrame Properties

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