hdh-spark-job - Details for Query 1484

Submitted Time: 2026/10/23 13:32:15
Duration: 3 s
Succeeded Jobs: 1483 1485

Show the Stage ID and Task ID that corresponds to the max metric

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; subgraph cluster1 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 0 ms"; 2 [labelType="html" label="HashAggregate time in aggregation build: 0 ms number of output rows: 1"]; } 3 [labelType="html" label="Exchange shuffle records written: 2 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 2164.0: task 1891)) 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 2164.0: task 1890)) 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 2164.0: task 1890))"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n4.6 s (2.3 s, 2.3 s, 2.3 s (stage 2164.0: task 1891))"; 5 [labelType="html" label="HashAggregate time in aggregation build total (min, med, max (stageId: taskId)) 4.6 s (2.3 s, 2.3 s, 2.3 s (stage 2164.0: task 1891)) number of output rows: 2"]; } 6 [labelType="html" label=" Union "]; 7 [labelType="html" label=" Project "]; 8 [labelType="html" label="Filter number of output rows: 456"]; 9 [labelType="html" label="Scan JDBCRelation((SELECT \"cr_numcr\", \"cr_numdos\", \"cr_nomdic\", \"cr_numdem\", \"cr_numexa\", \"cr_typdoc\", \"cr_prior\", \"cr_nomdcr\", \"cr_taidcr\", \"cr_durdcr\", \"cr_posdcr\", \"cr_nomdos\", \"cr_for_cr\", \"cr_cr\", \"cr_statdic\", \"cr_statsm\", \"cr_statcr\", \"cr_coddic\", \"cr_context\", \"cr_datdic\", \"cr_heudic\", \"cr_heui_d\", \"cr_heui_f\", \"cr_codsec\", \"cr_datsec\", \"cr_heusec\", \"cr_codvcr\", \"cr_datvcr\", \"cr_heuvcr\", \"cr_coddcr\", \"cr_datdcr\", \"cr_heudcr\", \"cr_dat_eff_d\", \"cr_dat_eff_w\", \"cr_coduti\", \"cr_datmaj\", \"cr_codsit\", \"cr_sectra\", \"cr_typcr\", \"cr_codsup\", \"cr_nivvcr\", \"cr_numvcr\", \"cr_nb_cor\", \"cr_datsup\", \"cr_heusup\", \"cr_flarch\", \"cr_staext\", \"cr_flimpr\", \"cr_lockcr\", \"cr_codmcr\", \"cr_datmcr\", \"cr_heumcr\", \"cr_codacc\", \"cr_motpas\", \"cr_libco\", \"cr_subdic\", \"cr_subdir\", \"cr_numprt\", \"cr_sta_env_prt\", \"cr_sta_ret_pro\", \"cr_sta_env_fra\", \"cr_sta_ret_fra\", \"cr_codcli\", \"cr_pri_dic\", \"cr_dat_dic_tra\", \"cr_heu_dic_tra\", \"cr_codfra\", \"cr_secext\", \"cr_statut_ext\", \"cr_simp_job_id\", \"cr_dat_cr_int\", \"cr_heu_cr_int\", \"cr_delai_total\", \"cr_nb_ligne_ext\", \"cr_nb_car_ext\", \"cr_nomext\", \"cr_subext\", \"cr_fltbdi\", \"cr_typdic\", \"cr_sta_env_ack\", \"cr_sta_ret_ack\", \"cr_taille_dic\", \"cr_chksum_dic\", \"cr_datmail\", \"cr_heumail\", \"cr_codmail\", \"cr_stadmp\", \"cr_coddmp\", \"cr_datdmp\", \"cr_heudmp\", \"cr_oiddmp\", \"cr_visdmp\", \"cr_scnpat\", \"cr_datscn\", \"cr_nummcr\", \"cr_numcr_cloud\", \"cr_numdrv\", \"cr_flarch_d\", \"cr_refext\", \"cr_annonce\", \"cr_periph\", \"cr_datcre\", \"cr_heucre\", \"cr_origine\", \"cr_oid\", \"cr_flordo\", \"cr_idcda\", \"cr_fltr\" FROM \"xplore\".\"h_cr\") as x) [numPartitions=1] number of output rows: 17,658"]; 10 [labelType="html" label=" Project "]; 11 [labelType="html" label="Filter number of output rows: 456"]; 12 [labelType="html" label="Scan JDBCRelation((SELECT \"cr_numcr\", \"cr_numdos\", \"cr_nomdic\", \"cr_numdem\", \"cr_numexa\", \"cr_typdoc\", \"cr_prior\", \"cr_nomdcr\", \"cr_taidcr\", \"cr_durdcr\", \"cr_posdcr\", \"cr_nomdos\", \"cr_for_cr\", \"cr_cr\", \"cr_statdic\", \"cr_statsm\", \"cr_statcr\", \"cr_coddic\", \"cr_context\", \"cr_datdic\", \"cr_heudic\", \"cr_heui_d\", \"cr_heui_f\", \"cr_codsec\", \"cr_datsec\", \"cr_heusec\", \"cr_codvcr\", \"cr_datvcr\", \"cr_heuvcr\", \"cr_coddcr\", \"cr_datdcr\", \"cr_heudcr\", \"cr_dat_eff_d\", \"cr_dat_eff_w\", \"cr_coduti\", \"cr_datmaj\", \"cr_codsit\", \"cr_sectra\", \"cr_typcr\", \"cr_codsup\", \"cr_nivvcr\", \"cr_numvcr\", \"cr_nb_cor\", \"cr_datsup\", \"cr_heusup\", \"cr_flarch\", \"cr_staext\", \"cr_flimpr\", \"cr_lockcr\", \"cr_codmcr\", \"cr_datmcr\", \"cr_heumcr\", \"cr_codacc\", \"cr_motpas\", \"cr_libco\", \"cr_subdic\", \"cr_subdir\", \"cr_numprt\", \"cr_sta_env_prt\", \"cr_sta_ret_pro\", \"cr_sta_env_fra\", \"cr_sta_ret_fra\", \"cr_codcli\", \"cr_pri_dic\", \"cr_dat_dic_tra\", \"cr_heu_dic_tra\", \"cr_codfra\", \"cr_secext\", \"cr_statut_ext\", \"cr_simp_job_id\", \"cr_dat_cr_int\", \"cr_heu_cr_int\", \"cr_delai_total\", \"cr_nb_ligne_ext\", \"cr_nb_car_ext\", \"cr_nomext\", \"cr_subext\", \"cr_fltbdi\", \"cr_typdic\", \"cr_sta_env_ack\", \"cr_sta_ret_ack\", \"cr_taille_dic\", \"cr_chksum_dic\", \"cr_datmail\", \"cr_heumail\", \"cr_codmail\", \"cr_stadmp\", \"cr_coddmp\", \"cr_datdmp\", \"cr_heudmp\", \"cr_oiddmp\", \"cr_visdmp\", \"cr_scnpat\", \"cr_datscn\", \"cr_nummcr\", \"cr_numcr_cloud\", \"cr_numdrv\", \"cr_flarch_d\", \"cr_refext\", \"cr_annonce\", \"cr_periph\", \"cr_datcre\", \"cr_heucre\", \"cr_origine\", \"cr_oid\", \"cr_flordo\", \"cr_idcda\", \"cr_fltr\" FROM \"xplore2\".\"h_cr\") as x) [numPartitions=1] number of output rows: 17,658"]; 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=40756]

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

WholeStageCodegen (1)

Union

Project

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numcr#774739)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numcr#774739)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdos#774740)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdos#774740)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdic#774741)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdic#774741)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdem#774742)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdem#774742)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numexa#774743)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numexa#774743)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typdoc#774744)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typdoc#774744)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_prior#774745)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_prior#774745)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdcr#774746)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdcr#774746)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_taidcr#774747)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_taidcr#774747)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_durdcr#774748)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_durdcr#774748)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_posdcr#774749)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_posdcr#774749)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdos#774750)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdos#774750)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_for_cr#774751)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_for_cr#774751)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_cr#774752)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_cr#774752)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statdic#774753)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statdic#774753)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statsm#774754)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statsm#774754)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statcr#774755)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statcr#774755)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddic#774756)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddic#774756)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_context#774757)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_context#774757)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdic#774758)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdic#774758)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudic#774759)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudic#774759)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heui_d#774760)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heui_d#774760)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heui_f#774761)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heui_f#774761)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsec#774762)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsec#774762)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datsec#774763)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datsec#774763)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heusec#774764)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heusec#774764)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codvcr#774765)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codvcr#774765)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datvcr#774766)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datvcr#774766)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heuvcr#774767)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heuvcr#774767)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddcr#774768)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddcr#774768)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdcr#774769)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdcr#774769)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudcr#774770)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudcr#774770)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_eff_d#774771)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_eff_d#774771)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_eff_w#774772)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_eff_w#774772)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coduti#774773)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coduti#774773)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmaj#774774)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmaj#774774)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsit#774775)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsit#774775)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sectra#774776)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sectra#774776)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typcr#774777)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typcr#774777)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsup#774778)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsup#774778)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nivvcr#774779)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nivvcr#774779)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numvcr#774780)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numvcr#774780)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_cor#774781)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_cor#774781)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datsup#774782)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datsup#774782)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heusup#774783)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heusup#774783)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flarch#774784)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flarch#774784)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_staext#774785)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_staext#774785)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flimpr#774786)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flimpr#774786)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_lockcr#774787)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_lockcr#774787)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codmcr#774788)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codmcr#774788)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmcr#774789)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmcr#774789)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heumcr#774790)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heumcr#774790)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codacc#774791)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codacc#774791)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_motpas#774792)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_motpas#774792)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_libco#774793)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_libco#774793)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subdic#774794)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subdic#774794)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subdir#774795)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subdir#774795)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numprt#774796)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numprt#774796)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_prt#774797)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_prt#774797)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_pro#774798)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_pro#774798)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_fra#774799)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_fra#774799)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_fra#774800)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_fra#774800)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codcli#774801)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codcli#774801)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_pri_dic#774802)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_pri_dic#774802)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_dic_tra#774803)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_dic_tra#774803)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heu_dic_tra#774804)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heu_dic_tra#774804)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codfra#774805)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codfra#774805)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_secext#774806)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_secext#774806)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statut_ext#774807)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statut_ext#774807)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_simp_job_id#774808)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_simp_job_id#774808)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_cr_int#774809)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_cr_int#774809)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heu_cr_int#774810)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heu_cr_int#774810)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_delai_total#774811)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_delai_total#774811)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_ligne_ext#774812)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_ligne_ext#774812)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_car_ext#774813)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_car_ext#774813)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomext#774814)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomext#774814)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subext#774815)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subext#774815)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_fltbdi#774816)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_fltbdi#774816)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typdic#774817)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typdic#774817)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_ack#774818)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_ack#774818)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_ack#774819)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_ack#774819)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_taille_dic#774820)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_taille_dic#774820)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_chksum_dic#774821)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_chksum_dic#774821)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmail#774822)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmail#774822)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heumail#774823)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heumail#774823)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codmail#774824)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codmail#774824)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_stadmp#774825)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_stadmp#774825)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddmp#774826)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddmp#774826)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdmp#774827)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdmp#774827)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudmp#774828)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudmp#774828)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_oiddmp#774829)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_oiddmp#774829)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_visdmp#774830)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_visdmp#774830)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_scnpat#774831)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_scnpat#774831)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datscn#774832)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datscn#774832)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nummcr#774833)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nummcr#774833)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numcr_cloud#774834)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numcr_cloud#774834)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdrv#774835)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdrv#774835)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flarch_d#774836)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flarch_d#774836)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_refext#774837)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_refext#774837)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_annonce#774838)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_annonce#774838)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_periph#774839)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_periph#774839)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datcre#774840)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datcre#774840)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heucre#774841)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heucre#774841)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_origine#774842)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_origine#774842)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_oid#774843)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_oid#774843)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flordo#774844)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flordo#774844)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_idcda#774845)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_idcda#774845)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_fltr#774846)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_fltr#774846)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_A))), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_A))), MAIN) END)

Scan JDBCRelation((SELECT "cr_numcr", "cr_numdos", "cr_nomdic", "cr_numdem", "cr_numexa", "cr_typdoc", "cr_prior", "cr_nomdcr", "cr_taidcr", "cr_durdcr", "cr_posdcr", "cr_nomdos", "cr_for_cr", "cr_cr", "cr_statdic", "cr_statsm", "cr_statcr", "cr_coddic", "cr_context", "cr_datdic", "cr_heudic", "cr_heui_d", "cr_heui_f", "cr_codsec", "cr_datsec", "cr_heusec", "cr_codvcr", "cr_datvcr", "cr_heuvcr", "cr_coddcr", "cr_datdcr", "cr_heudcr", "cr_dat_eff_d", "cr_dat_eff_w", "cr_coduti", "cr_datmaj", "cr_codsit", "cr_sectra", "cr_typcr", "cr_codsup", "cr_nivvcr", "cr_numvcr", "cr_nb_cor", "cr_datsup", "cr_heusup", "cr_flarch", "cr_staext", "cr_flimpr", "cr_lockcr", "cr_codmcr", "cr_datmcr", "cr_heumcr", "cr_codacc", "cr_motpas", "cr_libco", "cr_subdic", "cr_subdir", "cr_numprt", "cr_sta_env_prt", "cr_sta_ret_pro", "cr_sta_env_fra", "cr_sta_ret_fra", "cr_codcli", "cr_pri_dic", "cr_dat_dic_tra", "cr_heu_dic_tra", "cr_codfra", "cr_secext", "cr_statut_ext", "cr_simp_job_id", "cr_dat_cr_int", "cr_heu_cr_int", "cr_delai_total", "cr_nb_ligne_ext", "cr_nb_car_ext", "cr_nomext", "cr_subext", "cr_fltbdi", "cr_typdic", "cr_sta_env_ack", "cr_sta_ret_ack", "cr_taille_dic", "cr_chksum_dic", "cr_datmail", "cr_heumail", "cr_codmail", "cr_stadmp", "cr_coddmp", "cr_datdmp", "cr_heudmp", "cr_oiddmp", "cr_visdmp", "cr_scnpat", "cr_datscn", "cr_nummcr", "cr_numcr_cloud", "cr_numdrv", "cr_flarch_d", "cr_refext", "cr_annonce", "cr_periph", "cr_datcre", "cr_heucre", "cr_origine", "cr_oid", "cr_flordo", "cr_idcda", "cr_fltr" FROM "xplore"."h_cr") as x) [numPartitions=1] [cr_numcr#774739,cr_numdos#774740,cr_nomdic#774741,cr_numdem#774742,cr_numexa#774743,cr_typdoc#774744,cr_prior#774745,cr_nomdcr#774746,cr_taidcr#774747,cr_durdcr#774748,cr_posdcr#774749,cr_nomdos#774750,cr_for_cr#774751,cr_cr#774752,cr_statdic#774753,cr_statsm#774754,cr_statcr#774755,cr_coddic#774756,cr_context#774757,cr_datdic#774758,cr_heudic#774759,cr_heui_d#774760,cr_heui_f#774761,cr_codsec#774762,... 84 more fields] PushedFilters: [], ReadSchema: struct<cr_numcr:string,cr_numdos:string,cr_nomdic:string,cr_numdem:string,cr_numexa:string,cr_typ...

Project

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numcr#775714)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numcr#775714)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdos#775715)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdos#775715)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdic#775716)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdic#775716)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdem#775717)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdem#775717)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numexa#775718)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numexa#775718)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typdoc#775719)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typdoc#775719)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_prior#775720)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_prior#775720)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdcr#775721)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdcr#775721)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_taidcr#775722)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_taidcr#775722)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_durdcr#775723)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_durdcr#775723)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_posdcr#775724)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_posdcr#775724)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdos#775725)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdos#775725)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_for_cr#775726)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_for_cr#775726)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_cr#775727)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_cr#775727)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statdic#775728)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statdic#775728)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statsm#775729)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statsm#775729)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statcr#775730)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statcr#775730)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddic#775731)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddic#775731)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_context#775732)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_context#775732)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdic#775733)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdic#775733)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudic#775734)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudic#775734)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heui_d#775735)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heui_d#775735)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heui_f#775736)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heui_f#775736)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsec#775737)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsec#775737)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datsec#775738)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datsec#775738)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heusec#775739)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heusec#775739)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codvcr#775740)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codvcr#775740)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datvcr#775741)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datvcr#775741)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heuvcr#775742)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heuvcr#775742)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddcr#775743)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddcr#775743)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdcr#775744)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdcr#775744)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudcr#775745)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudcr#775745)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_eff_d#775746)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_eff_d#775746)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_eff_w#775747)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_eff_w#775747)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coduti#775748)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coduti#775748)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmaj#775749)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmaj#775749)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsit#775750)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsit#775750)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sectra#775751)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sectra#775751)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typcr#775752)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typcr#775752)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsup#775753)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsup#775753)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nivvcr#775754)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nivvcr#775754)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numvcr#775755)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numvcr#775755)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_cor#775756)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_cor#775756)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datsup#775757)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datsup#775757)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heusup#775758)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heusup#775758)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flarch#775759)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flarch#775759)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_staext#775760)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_staext#775760)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flimpr#775761)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flimpr#775761)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_lockcr#775762)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_lockcr#775762)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codmcr#775763)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codmcr#775763)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmcr#775764)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmcr#775764)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heumcr#775765)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heumcr#775765)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codacc#775766)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codacc#775766)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_motpas#775767)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_motpas#775767)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_libco#775768)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_libco#775768)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subdic#775769)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subdic#775769)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subdir#775770)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subdir#775770)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numprt#775771)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numprt#775771)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_prt#775772)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_prt#775772)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_pro#775773)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_pro#775773)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_fra#775774)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_fra#775774)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_fra#775775)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_fra#775775)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codcli#775776)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codcli#775776)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_pri_dic#775777)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_pri_dic#775777)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_dic_tra#775778)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_dic_tra#775778)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heu_dic_tra#775779)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heu_dic_tra#775779)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codfra#775780)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codfra#775780)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_secext#775781)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_secext#775781)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statut_ext#775782)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statut_ext#775782)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_simp_job_id#775783)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_simp_job_id#775783)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_cr_int#775784)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_cr_int#775784)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heu_cr_int#775785)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heu_cr_int#775785)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_delai_total#775786)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_delai_total#775786)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_ligne_ext#775787)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_ligne_ext#775787)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_car_ext#775788)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_car_ext#775788)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomext#775789)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomext#775789)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subext#775790)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subext#775790)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_fltbdi#775791)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_fltbdi#775791)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typdic#775792)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typdic#775792)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_ack#775793)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_ack#775793)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_ack#775794)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_ack#775794)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_taille_dic#775795)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_taille_dic#775795)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_chksum_dic#775796)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_chksum_dic#775796)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmail#775797)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmail#775797)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heumail#775798)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heumail#775798)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codmail#775799)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codmail#775799)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_stadmp#775800)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_stadmp#775800)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddmp#775801)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddmp#775801)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdmp#775802)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdmp#775802)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudmp#775803)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudmp#775803)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_oiddmp#775804)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_oiddmp#775804)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_visdmp#775805)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_visdmp#775805)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_scnpat#775806)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_scnpat#775806)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datscn#775807)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datscn#775807)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nummcr#775808)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nummcr#775808)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numcr_cloud#775809)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numcr_cloud#775809)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdrv#775810)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdrv#775810)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flarch_d#775811)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flarch_d#775811)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_refext#775812)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_refext#775812)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_annonce#775813)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_annonce#775813)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_periph#775814)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_periph#775814)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datcre#775815)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datcre#775815)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heucre#775816)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heucre#775816)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_origine#775817)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_origine#775817)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_oid#775818)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_oid#775818)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flordo#775819)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flordo#775819)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_idcda#775820)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_idcda#775820)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_fltr#775821)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_fltr#775821)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_B))), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_B))), MAIN) END)

Scan JDBCRelation((SELECT "cr_numcr", "cr_numdos", "cr_nomdic", "cr_numdem", "cr_numexa", "cr_typdoc", "cr_prior", "cr_nomdcr", "cr_taidcr", "cr_durdcr", "cr_posdcr", "cr_nomdos", "cr_for_cr", "cr_cr", "cr_statdic", "cr_statsm", "cr_statcr", "cr_coddic", "cr_context", "cr_datdic", "cr_heudic", "cr_heui_d", "cr_heui_f", "cr_codsec", "cr_datsec", "cr_heusec", "cr_codvcr", "cr_datvcr", "cr_heuvcr", "cr_coddcr", "cr_datdcr", "cr_heudcr", "cr_dat_eff_d", "cr_dat_eff_w", "cr_coduti", "cr_datmaj", "cr_codsit", "cr_sectra", "cr_typcr", "cr_codsup", "cr_nivvcr", "cr_numvcr", "cr_nb_cor", "cr_datsup", "cr_heusup", "cr_flarch", "cr_staext", "cr_flimpr", "cr_lockcr", "cr_codmcr", "cr_datmcr", "cr_heumcr", "cr_codacc", "cr_motpas", "cr_libco", "cr_subdic", "cr_subdir", "cr_numprt", "cr_sta_env_prt", "cr_sta_ret_pro", "cr_sta_env_fra", "cr_sta_ret_fra", "cr_codcli", "cr_pri_dic", "cr_dat_dic_tra", "cr_heu_dic_tra", "cr_codfra", "cr_secext", "cr_statut_ext", "cr_simp_job_id", "cr_dat_cr_int", "cr_heu_cr_int", "cr_delai_total", "cr_nb_ligne_ext", "cr_nb_car_ext", "cr_nomext", "cr_subext", "cr_fltbdi", "cr_typdic", "cr_sta_env_ack", "cr_sta_ret_ack", "cr_taille_dic", "cr_chksum_dic", "cr_datmail", "cr_heumail", "cr_codmail", "cr_stadmp", "cr_coddmp", "cr_datdmp", "cr_heudmp", "cr_oiddmp", "cr_visdmp", "cr_scnpat", "cr_datscn", "cr_nummcr", "cr_numcr_cloud", "cr_numdrv", "cr_flarch_d", "cr_refext", "cr_annonce", "cr_periph", "cr_datcre", "cr_heucre", "cr_origine", "cr_oid", "cr_flordo", "cr_idcda", "cr_fltr" FROM "xplore2"."h_cr") as x) [numPartitions=1] [cr_numcr#775714,cr_numdos#775715,cr_nomdic#775716,cr_numdem#775717,cr_numexa#775718,cr_typdoc#775719,cr_prior#775720,cr_nomdcr#775721,cr_taidcr#775722,cr_durdcr#775723,cr_posdcr#775724,cr_nomdos#775725,cr_for_cr#775726,cr_cr#775727,cr_statdic#775728,cr_statsm#775729,cr_statcr#775730,cr_coddic#775731,cr_context#775732,cr_datdic#775733,cr_heudic#775734,cr_heui_d#775735,cr_heui_f#775736,cr_codsec#775737,... 84 more fields] PushedFilters: [], ReadSchema: struct<cr_numcr:string,cr_numdos:string,cr_nomdic:string,cr_numdem:string,cr_numexa:string,cr_typ...

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 "cr_numcr", "cr_numdos", "cr_nomdic", "cr_numdem", "cr_numexa", "cr_typdoc", "cr_prior", "cr_nomdcr", "cr_taidcr", "cr_durdcr", "cr_posdcr", "cr_nomdos", "cr_for_cr", "cr_cr", "cr_statdic", "cr_statsm", "cr_statcr", "cr_coddic", "cr_context", "cr_datdic", "cr_heudic", "cr_heui_d", "cr_heui_f", "cr_codsec", "cr_datsec", "cr_heusec", "cr_codvcr", "cr_datvcr", "cr_heuvcr", "cr_coddcr", "cr_datdcr", "cr_heudcr", "cr_dat_eff_d", "cr_dat_eff_w", "cr_coduti", "cr_datmaj", "cr_codsit", "cr_sectra", "cr_typcr", "cr_codsup", "cr_nivvcr", "cr_numvcr", "cr_nb_cor", "cr_datsup", "cr_heusup", "cr_flarch", "cr_staext", "cr_flimpr", "cr_lockcr", "cr_codmcr", "cr_datmcr", "cr_heumcr", "cr_codacc", "cr_motpas", "cr_libco", "cr_subdic", "cr_subdir", "cr_numprt", "cr_sta_env_prt", "cr_sta_ret_pro", "cr_sta_env_fra", "cr_sta_ret_fra", "cr_codcli", "cr_pri_dic", "cr_dat_dic_tra", "cr_heu_dic_tra", "cr_codfra", "cr_secext", "cr_statut_ext", "cr_simp_job_id", "cr_dat_cr_int", "cr_heu_cr_int", "cr_delai_total", "cr_nb_ligne_ext", "cr_nb_car_ext", "cr_nomext", "cr_subext", "cr_fltbdi", "cr_typdic", "cr_sta_env_ack", "cr_sta_ret_ack", "cr_taille_dic", "cr_chksum_dic", "cr_datmail", "cr_heumail", "cr_codmail", "cr_stadmp", "cr_coddmp", "cr_datdmp", "cr_heudmp", "cr_oiddmp", "cr_visdmp", "cr_scnpat", "cr_datscn", "cr_nummcr", "cr_numcr_cloud", "cr_numdrv", "cr_flarch_d", "cr_refext", "cr_annonce", "cr_periph", "cr_datcre", "cr_heucre", "cr_origine", "cr_oid", "cr_flordo", "cr_idcda", "cr_fltr" FROM "xplore"."h_cr") as x) [numPartitions=1]  (1)
               +- Project (6)
                  +- Filter (5)
                     +- Scan JDBCRelation((SELECT "cr_numcr", "cr_numdos", "cr_nomdic", "cr_numdem", "cr_numexa", "cr_typdoc", "cr_prior", "cr_nomdcr", "cr_taidcr", "cr_durdcr", "cr_posdcr", "cr_nomdos", "cr_for_cr", "cr_cr", "cr_statdic", "cr_statsm", "cr_statcr", "cr_coddic", "cr_context", "cr_datdic", "cr_heudic", "cr_heui_d", "cr_heui_f", "cr_codsec", "cr_datsec", "cr_heusec", "cr_codvcr", "cr_datvcr", "cr_heuvcr", "cr_coddcr", "cr_datdcr", "cr_heudcr", "cr_dat_eff_d", "cr_dat_eff_w", "cr_coduti", "cr_datmaj", "cr_codsit", "cr_sectra", "cr_typcr", "cr_codsup", "cr_nivvcr", "cr_numvcr", "cr_nb_cor", "cr_datsup", "cr_heusup", "cr_flarch", "cr_staext", "cr_flimpr", "cr_lockcr", "cr_codmcr", "cr_datmcr", "cr_heumcr", "cr_codacc", "cr_motpas", "cr_libco", "cr_subdic", "cr_subdir", "cr_numprt", "cr_sta_env_prt", "cr_sta_ret_pro", "cr_sta_env_fra", "cr_sta_ret_fra", "cr_codcli", "cr_pri_dic", "cr_dat_dic_tra", "cr_heu_dic_tra", "cr_codfra", "cr_secext", "cr_statut_ext", "cr_simp_job_id", "cr_dat_cr_int", "cr_heu_cr_int", "cr_delai_total", "cr_nb_ligne_ext", "cr_nb_car_ext", "cr_nomext", "cr_subext", "cr_fltbdi", "cr_typdic", "cr_sta_env_ack", "cr_sta_ret_ack", "cr_taille_dic", "cr_chksum_dic", "cr_datmail", "cr_heumail", "cr_codmail", "cr_stadmp", "cr_coddmp", "cr_datdmp", "cr_heudmp", "cr_oiddmp", "cr_visdmp", "cr_scnpat", "cr_datscn", "cr_nummcr", "cr_numcr_cloud", "cr_numdrv", "cr_flarch_d", "cr_refext", "cr_annonce", "cr_periph", "cr_datcre", "cr_heucre", "cr_origine", "cr_oid", "cr_flordo", "cr_idcda", "cr_fltr" FROM "xplore2"."h_cr") as x) [numPartitions=1]  (4)
+- == Initial Plan ==
   HashAggregate (14)
   +- Exchange (13)
      +- HashAggregate (12)
         +- Union (7)
            :- Project (3)
            :  +- Filter (2)
            :     +- Scan JDBCRelation((SELECT "cr_numcr", "cr_numdos", "cr_nomdic", "cr_numdem", "cr_numexa", "cr_typdoc", "cr_prior", "cr_nomdcr", "cr_taidcr", "cr_durdcr", "cr_posdcr", "cr_nomdos", "cr_for_cr", "cr_cr", "cr_statdic", "cr_statsm", "cr_statcr", "cr_coddic", "cr_context", "cr_datdic", "cr_heudic", "cr_heui_d", "cr_heui_f", "cr_codsec", "cr_datsec", "cr_heusec", "cr_codvcr", "cr_datvcr", "cr_heuvcr", "cr_coddcr", "cr_datdcr", "cr_heudcr", "cr_dat_eff_d", "cr_dat_eff_w", "cr_coduti", "cr_datmaj", "cr_codsit", "cr_sectra", "cr_typcr", "cr_codsup", "cr_nivvcr", "cr_numvcr", "cr_nb_cor", "cr_datsup", "cr_heusup", "cr_flarch", "cr_staext", "cr_flimpr", "cr_lockcr", "cr_codmcr", "cr_datmcr", "cr_heumcr", "cr_codacc", "cr_motpas", "cr_libco", "cr_subdic", "cr_subdir", "cr_numprt", "cr_sta_env_prt", "cr_sta_ret_pro", "cr_sta_env_fra", "cr_sta_ret_fra", "cr_codcli", "cr_pri_dic", "cr_dat_dic_tra", "cr_heu_dic_tra", "cr_codfra", "cr_secext", "cr_statut_ext", "cr_simp_job_id", "cr_dat_cr_int", "cr_heu_cr_int", "cr_delai_total", "cr_nb_ligne_ext", "cr_nb_car_ext", "cr_nomext", "cr_subext", "cr_fltbdi", "cr_typdic", "cr_sta_env_ack", "cr_sta_ret_ack", "cr_taille_dic", "cr_chksum_dic", "cr_datmail", "cr_heumail", "cr_codmail", "cr_stadmp", "cr_coddmp", "cr_datdmp", "cr_heudmp", "cr_oiddmp", "cr_visdmp", "cr_scnpat", "cr_datscn", "cr_nummcr", "cr_numcr_cloud", "cr_numdrv", "cr_flarch_d", "cr_refext", "cr_annonce", "cr_periph", "cr_datcre", "cr_heucre", "cr_origine", "cr_oid", "cr_flordo", "cr_idcda", "cr_fltr" FROM "xplore"."h_cr") as x) [numPartitions=1]  (1)
            +- Project (6)
               +- Filter (5)
                  +- Scan JDBCRelation((SELECT "cr_numcr", "cr_numdos", "cr_nomdic", "cr_numdem", "cr_numexa", "cr_typdoc", "cr_prior", "cr_nomdcr", "cr_taidcr", "cr_durdcr", "cr_posdcr", "cr_nomdos", "cr_for_cr", "cr_cr", "cr_statdic", "cr_statsm", "cr_statcr", "cr_coddic", "cr_context", "cr_datdic", "cr_heudic", "cr_heui_d", "cr_heui_f", "cr_codsec", "cr_datsec", "cr_heusec", "cr_codvcr", "cr_datvcr", "cr_heuvcr", "cr_coddcr", "cr_datdcr", "cr_heudcr", "cr_dat_eff_d", "cr_dat_eff_w", "cr_coduti", "cr_datmaj", "cr_codsit", "cr_sectra", "cr_typcr", "cr_codsup", "cr_nivvcr", "cr_numvcr", "cr_nb_cor", "cr_datsup", "cr_heusup", "cr_flarch", "cr_staext", "cr_flimpr", "cr_lockcr", "cr_codmcr", "cr_datmcr", "cr_heumcr", "cr_codacc", "cr_motpas", "cr_libco", "cr_subdic", "cr_subdir", "cr_numprt", "cr_sta_env_prt", "cr_sta_ret_pro", "cr_sta_env_fra", "cr_sta_ret_fra", "cr_codcli", "cr_pri_dic", "cr_dat_dic_tra", "cr_heu_dic_tra", "cr_codfra", "cr_secext", "cr_statut_ext", "cr_simp_job_id", "cr_dat_cr_int", "cr_heu_cr_int", "cr_delai_total", "cr_nb_ligne_ext", "cr_nb_car_ext", "cr_nomext", "cr_subext", "cr_fltbdi", "cr_typdic", "cr_sta_env_ack", "cr_sta_ret_ack", "cr_taille_dic", "cr_chksum_dic", "cr_datmail", "cr_heumail", "cr_codmail", "cr_stadmp", "cr_coddmp", "cr_datdmp", "cr_heudmp", "cr_oiddmp", "cr_visdmp", "cr_scnpat", "cr_datscn", "cr_nummcr", "cr_numcr_cloud", "cr_numdrv", "cr_flarch_d", "cr_refext", "cr_annonce", "cr_periph", "cr_datcre", "cr_heucre", "cr_origine", "cr_oid", "cr_flordo", "cr_idcda", "cr_fltr" FROM "xplore2"."h_cr") as x) [numPartitions=1]  (4)


(1) Scan JDBCRelation((SELECT "cr_numcr", "cr_numdos", "cr_nomdic", "cr_numdem", "cr_numexa", "cr_typdoc", "cr_prior", "cr_nomdcr", "cr_taidcr", "cr_durdcr", "cr_posdcr", "cr_nomdos", "cr_for_cr", "cr_cr", "cr_statdic", "cr_statsm", "cr_statcr", "cr_coddic", "cr_context", "cr_datdic", "cr_heudic", "cr_heui_d", "cr_heui_f", "cr_codsec", "cr_datsec", "cr_heusec", "cr_codvcr", "cr_datvcr", "cr_heuvcr", "cr_coddcr", "cr_datdcr", "cr_heudcr", "cr_dat_eff_d", "cr_dat_eff_w", "cr_coduti", "cr_datmaj", "cr_codsit", "cr_sectra", "cr_typcr", "cr_codsup", "cr_nivvcr", "cr_numvcr", "cr_nb_cor", "cr_datsup", "cr_heusup", "cr_flarch", "cr_staext", "cr_flimpr", "cr_lockcr", "cr_codmcr", "cr_datmcr", "cr_heumcr", "cr_codacc", "cr_motpas", "cr_libco", "cr_subdic", "cr_subdir", "cr_numprt", "cr_sta_env_prt", "cr_sta_ret_pro", "cr_sta_env_fra", "cr_sta_ret_fra", "cr_codcli", "cr_pri_dic", "cr_dat_dic_tra", "cr_heu_dic_tra", "cr_codfra", "cr_secext", "cr_statut_ext", "cr_simp_job_id", "cr_dat_cr_int", "cr_heu_cr_int", "cr_delai_total", "cr_nb_ligne_ext", "cr_nb_car_ext", "cr_nomext", "cr_subext", "cr_fltbdi", "cr_typdic", "cr_sta_env_ack", "cr_sta_ret_ack", "cr_taille_dic", "cr_chksum_dic", "cr_datmail", "cr_heumail", "cr_codmail", "cr_stadmp", "cr_coddmp", "cr_datdmp", "cr_heudmp", "cr_oiddmp", "cr_visdmp", "cr_scnpat", "cr_datscn", "cr_nummcr", "cr_numcr_cloud", "cr_numdrv", "cr_flarch_d", "cr_refext", "cr_annonce", "cr_periph", "cr_datcre", "cr_heucre", "cr_origine", "cr_oid", "cr_flordo", "cr_idcda", "cr_fltr" FROM "xplore"."h_cr") as x) [numPartitions=1] 
Output [108]: [cr_numcr#774739, cr_numdos#774740, cr_nomdic#774741, cr_numdem#774742, cr_numexa#774743, cr_typdoc#774744, cr_prior#774745, cr_nomdcr#774746, cr_taidcr#774747, cr_durdcr#774748, cr_posdcr#774749, cr_nomdos#774750, cr_for_cr#774751, cr_cr#774752, cr_statdic#774753, cr_statsm#774754, cr_statcr#774755, cr_coddic#774756, cr_context#774757, cr_datdic#774758, cr_heudic#774759, cr_heui_d#774760, cr_heui_f#774761, cr_codsec#774762, cr_datsec#774763, cr_heusec#774764, cr_codvcr#774765, cr_datvcr#774766, cr_heuvcr#774767, cr_coddcr#774768, cr_datdcr#774769, cr_heudcr#774770, cr_dat_eff_d#774771, cr_dat_eff_w#774772, cr_coduti#774773, cr_datmaj#774774, cr_codsit#774775, cr_sectra#774776, cr_typcr#774777, cr_codsup#774778, cr_nivvcr#774779, cr_numvcr#774780, cr_nb_cor#774781, cr_datsup#774782, cr_heusup#774783, cr_flarch#774784, cr_staext#774785, cr_flimpr#774786, cr_lockcr#774787, cr_codmcr#774788, cr_datmcr#774789, cr_heumcr#774790, cr_codacc#774791, cr_motpas#774792, cr_libco#774793, cr_subdic#774794, cr_subdir#774795, cr_numprt#774796, cr_sta_env_prt#774797, cr_sta_ret_pro#774798, cr_sta_env_fra#774799, cr_sta_ret_fra#774800, cr_codcli#774801, cr_pri_dic#774802, cr_dat_dic_tra#774803, cr_heu_dic_tra#774804, cr_codfra#774805, cr_secext#774806, cr_statut_ext#774807, cr_simp_job_id#774808, cr_dat_cr_int#774809, cr_heu_cr_int#774810, cr_delai_total#774811, cr_nb_ligne_ext#774812, cr_nb_car_ext#774813, cr_nomext#774814, cr_subext#774815, cr_fltbdi#774816, cr_typdic#774817, cr_sta_env_ack#774818, cr_sta_ret_ack#774819, cr_taille_dic#774820, cr_chksum_dic#774821, cr_datmail#774822, cr_heumail#774823, cr_codmail#774824, cr_stadmp#774825, cr_coddmp#774826, cr_datdmp#774827, cr_heudmp#774828, cr_oiddmp#774829, cr_visdmp#774830, cr_scnpat#774831, cr_datscn#774832, cr_nummcr#774833, cr_numcr_cloud#774834, cr_numdrv#774835, cr_flarch_d#774836, cr_refext#774837, cr_annonce#774838, cr_periph#774839, cr_datcre#774840, cr_heucre#774841, cr_origine#774842, cr_oid#774843, cr_flordo#774844, cr_idcda#774845, cr_fltr#774846]
ReadSchema: struct<cr_numcr:string,cr_numdos:string,cr_nomdic:string,cr_numdem:string,cr_numexa:string,cr_typdoc:string,cr_prior:string,cr_nomdcr:string,cr_taidcr:string,cr_durdcr:string,cr_posdcr:string,cr_nomdos:string,cr_for_cr:string,cr_cr:string,cr_statdic:string,cr_statsm:string,cr_statcr:string,cr_coddic:string,cr_context:string,cr_datdic:string,cr_heudic:string,cr_heui_d:string,cr_heui_f:string,cr_codsec:string,cr_datsec:string,cr_heusec:string,cr_codvcr:string,cr_datvcr:string,cr_heuvcr:string,cr_coddcr:string,cr_datdcr:string,cr_heudcr:string,cr_dat_eff_d:string,cr_dat_eff_w:string,cr_coduti:string,cr_datmaj:string,cr_codsit:string,cr_sectra:string,cr_typcr:string,cr_codsup:string,cr_nivvcr:string,cr_numvcr:string,cr_nb_cor:string,cr_datsup:string,cr_heusup:string,cr_flarch:string,cr_staext:string,cr_flimpr:string,cr_lockcr:string,cr_codmcr:string,cr_datmcr:string,cr_heumcr:string,cr_codacc:string,cr_motpas:string,cr_libco:string,cr_subdic:string,cr_subdir:string,cr_numprt:string,cr_sta_env_prt:string,cr_sta_ret_pro:string,cr_sta_env_fra:string,cr_sta_ret_fra:string,cr_codcli:string,cr_pri_dic:string,cr_dat_dic_tra:string,cr_heu_dic_tra:string,cr_codfra:string,cr_secext:string,cr_statut_ext:string,cr_simp_job_id:string,cr_dat_cr_int:string,cr_heu_cr_int:string,cr_delai_total:string,cr_nb_ligne_ext:string,cr_nb_car_ext:string,cr_nomext:string,cr_subext:string,cr_fltbdi:string,cr_typdic:string,cr_sta_env_ack:string,cr_sta_ret_ack:string,cr_taille_dic:string,cr_chksum_dic:string,cr_datmail:string,cr_heumail:string,cr_codmail:string,cr_stadmp:string,cr_coddmp:string,cr_datdmp:string,cr_heudmp:string,cr_oiddmp:string,cr_visdmp:string,cr_scnpat:string,cr_datscn:string,cr_nummcr:string,cr_numcr_cloud:string,cr_numdrv:string,cr_flarch_d:string,cr_refext:string,cr_annonce:string,cr_periph:string,cr_datcre:string,cr_heucre:string,cr_origine:string,cr_oid:string,cr_flordo:string,cr_idcda:string,cr_fltr:string>

(2) Filter
Input [108]: [cr_numcr#774739, cr_numdos#774740, cr_nomdic#774741, cr_numdem#774742, cr_numexa#774743, cr_typdoc#774744, cr_prior#774745, cr_nomdcr#774746, cr_taidcr#774747, cr_durdcr#774748, cr_posdcr#774749, cr_nomdos#774750, cr_for_cr#774751, cr_cr#774752, cr_statdic#774753, cr_statsm#774754, cr_statcr#774755, cr_coddic#774756, cr_context#774757, cr_datdic#774758, cr_heudic#774759, cr_heui_d#774760, cr_heui_f#774761, cr_codsec#774762, cr_datsec#774763, cr_heusec#774764, cr_codvcr#774765, cr_datvcr#774766, cr_heuvcr#774767, cr_coddcr#774768, cr_datdcr#774769, cr_heudcr#774770, cr_dat_eff_d#774771, cr_dat_eff_w#774772, cr_coduti#774773, cr_datmaj#774774, cr_codsit#774775, cr_sectra#774776, cr_typcr#774777, cr_codsup#774778, cr_nivvcr#774779, cr_numvcr#774780, cr_nb_cor#774781, cr_datsup#774782, cr_heusup#774783, cr_flarch#774784, cr_staext#774785, cr_flimpr#774786, cr_lockcr#774787, cr_codmcr#774788, cr_datmcr#774789, cr_heumcr#774790, cr_codacc#774791, cr_motpas#774792, cr_libco#774793, cr_subdic#774794, cr_subdir#774795, cr_numprt#774796, cr_sta_env_prt#774797, cr_sta_ret_pro#774798, cr_sta_env_fra#774799, cr_sta_ret_fra#774800, cr_codcli#774801, cr_pri_dic#774802, cr_dat_dic_tra#774803, cr_heu_dic_tra#774804, cr_codfra#774805, cr_secext#774806, cr_statut_ext#774807, cr_simp_job_id#774808, cr_dat_cr_int#774809, cr_heu_cr_int#774810, cr_delai_total#774811, cr_nb_ligne_ext#774812, cr_nb_car_ext#774813, cr_nomext#774814, cr_subext#774815, cr_fltbdi#774816, cr_typdic#774817, cr_sta_env_ack#774818, cr_sta_ret_ack#774819, cr_taille_dic#774820, cr_chksum_dic#774821, cr_datmail#774822, cr_heumail#774823, cr_codmail#774824, cr_stadmp#774825, cr_coddmp#774826, cr_datdmp#774827, cr_heudmp#774828, cr_oiddmp#774829, cr_visdmp#774830, cr_scnpat#774831, cr_datscn#774832, cr_nummcr#774833, cr_numcr_cloud#774834, cr_numdrv#774835, cr_flarch_d#774836, cr_refext#774837, cr_annonce#774838, cr_periph#774839, cr_datcre#774840, cr_heucre#774841, cr_origine#774842, cr_oid#774843, cr_flordo#774844, cr_idcda#774845, cr_fltr#774846]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numcr#774739)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numcr#774739)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdos#774740)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdos#774740)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdic#774741)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdic#774741)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdem#774742)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdem#774742)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numexa#774743)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numexa#774743)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typdoc#774744)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typdoc#774744)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_prior#774745)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_prior#774745)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdcr#774746)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdcr#774746)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_taidcr#774747)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_taidcr#774747)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_durdcr#774748)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_durdcr#774748)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_posdcr#774749)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_posdcr#774749)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdos#774750)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdos#774750)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_for_cr#774751)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_for_cr#774751)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_cr#774752)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_cr#774752)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statdic#774753)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statdic#774753)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statsm#774754)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statsm#774754)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statcr#774755)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statcr#774755)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddic#774756)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddic#774756)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_context#774757)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_context#774757)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdic#774758)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdic#774758)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudic#774759)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudic#774759)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heui_d#774760)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heui_d#774760)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heui_f#774761)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heui_f#774761)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsec#774762)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsec#774762)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datsec#774763)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datsec#774763)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heusec#774764)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heusec#774764)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codvcr#774765)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codvcr#774765)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datvcr#774766)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datvcr#774766)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heuvcr#774767)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heuvcr#774767)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddcr#774768)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddcr#774768)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdcr#774769)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdcr#774769)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudcr#774770)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudcr#774770)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_eff_d#774771)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_eff_d#774771)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_eff_w#774772)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_eff_w#774772)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coduti#774773)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coduti#774773)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmaj#774774)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmaj#774774)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsit#774775)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsit#774775)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sectra#774776)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sectra#774776)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typcr#774777)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typcr#774777)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsup#774778)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsup#774778)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nivvcr#774779)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nivvcr#774779)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numvcr#774780)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numvcr#774780)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_cor#774781)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_cor#774781)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datsup#774782)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datsup#774782)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heusup#774783)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heusup#774783)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flarch#774784)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flarch#774784)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_staext#774785)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_staext#774785)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flimpr#774786)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flimpr#774786)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_lockcr#774787)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_lockcr#774787)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codmcr#774788)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codmcr#774788)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmcr#774789)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmcr#774789)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heumcr#774790)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heumcr#774790)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codacc#774791)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codacc#774791)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_motpas#774792)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_motpas#774792)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_libco#774793)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_libco#774793)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subdic#774794)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subdic#774794)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subdir#774795)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subdir#774795)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numprt#774796)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numprt#774796)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_prt#774797)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_prt#774797)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_pro#774798)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_pro#774798)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_fra#774799)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_fra#774799)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_fra#774800)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_fra#774800)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codcli#774801)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codcli#774801)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_pri_dic#774802)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_pri_dic#774802)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_dic_tra#774803)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_dic_tra#774803)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heu_dic_tra#774804)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heu_dic_tra#774804)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codfra#774805)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codfra#774805)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_secext#774806)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_secext#774806)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statut_ext#774807)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statut_ext#774807)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_simp_job_id#774808)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_simp_job_id#774808)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_cr_int#774809)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_cr_int#774809)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heu_cr_int#774810)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heu_cr_int#774810)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_delai_total#774811)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_delai_total#774811)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_ligne_ext#774812)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_ligne_ext#774812)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_car_ext#774813)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_car_ext#774813)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomext#774814)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomext#774814)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subext#774815)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subext#774815)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_fltbdi#774816)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_fltbdi#774816)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typdic#774817)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typdic#774817)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_ack#774818)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_ack#774818)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_ack#774819)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_ack#774819)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_taille_dic#774820)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_taille_dic#774820)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_chksum_dic#774821)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_chksum_dic#774821)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmail#774822)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmail#774822)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heumail#774823)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heumail#774823)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codmail#774824)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codmail#774824)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_stadmp#774825)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_stadmp#774825)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddmp#774826)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddmp#774826)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdmp#774827)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdmp#774827)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudmp#774828)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudmp#774828)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_oiddmp#774829)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_oiddmp#774829)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_visdmp#774830)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_visdmp#774830)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_scnpat#774831)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_scnpat#774831)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datscn#774832)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datscn#774832)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nummcr#774833)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nummcr#774833)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numcr_cloud#774834)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numcr_cloud#774834)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdrv#774835)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdrv#774835)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flarch_d#774836)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flarch_d#774836)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_refext#774837)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_refext#774837)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_annonce#774838)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_annonce#774838)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_periph#774839)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_periph#774839)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datcre#774840)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datcre#774840)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heucre#774841)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heucre#774841)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_origine#774842)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_origine#774842)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_oid#774843)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_oid#774843)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flordo#774844)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flordo#774844)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_idcda#774845)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_idcda#774845)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_fltr#774846)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_fltr#774846)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_A))), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_A))), MAIN) END)

(3) Project
Output: []
Input [108]: [cr_numcr#774739, cr_numdos#774740, cr_nomdic#774741, cr_numdem#774742, cr_numexa#774743, cr_typdoc#774744, cr_prior#774745, cr_nomdcr#774746, cr_taidcr#774747, cr_durdcr#774748, cr_posdcr#774749, cr_nomdos#774750, cr_for_cr#774751, cr_cr#774752, cr_statdic#774753, cr_statsm#774754, cr_statcr#774755, cr_coddic#774756, cr_context#774757, cr_datdic#774758, cr_heudic#774759, cr_heui_d#774760, cr_heui_f#774761, cr_codsec#774762, cr_datsec#774763, cr_heusec#774764, cr_codvcr#774765, cr_datvcr#774766, cr_heuvcr#774767, cr_coddcr#774768, cr_datdcr#774769, cr_heudcr#774770, cr_dat_eff_d#774771, cr_dat_eff_w#774772, cr_coduti#774773, cr_datmaj#774774, cr_codsit#774775, cr_sectra#774776, cr_typcr#774777, cr_codsup#774778, cr_nivvcr#774779, cr_numvcr#774780, cr_nb_cor#774781, cr_datsup#774782, cr_heusup#774783, cr_flarch#774784, cr_staext#774785, cr_flimpr#774786, cr_lockcr#774787, cr_codmcr#774788, cr_datmcr#774789, cr_heumcr#774790, cr_codacc#774791, cr_motpas#774792, cr_libco#774793, cr_subdic#774794, cr_subdir#774795, cr_numprt#774796, cr_sta_env_prt#774797, cr_sta_ret_pro#774798, cr_sta_env_fra#774799, cr_sta_ret_fra#774800, cr_codcli#774801, cr_pri_dic#774802, cr_dat_dic_tra#774803, cr_heu_dic_tra#774804, cr_codfra#774805, cr_secext#774806, cr_statut_ext#774807, cr_simp_job_id#774808, cr_dat_cr_int#774809, cr_heu_cr_int#774810, cr_delai_total#774811, cr_nb_ligne_ext#774812, cr_nb_car_ext#774813, cr_nomext#774814, cr_subext#774815, cr_fltbdi#774816, cr_typdic#774817, cr_sta_env_ack#774818, cr_sta_ret_ack#774819, cr_taille_dic#774820, cr_chksum_dic#774821, cr_datmail#774822, cr_heumail#774823, cr_codmail#774824, cr_stadmp#774825, cr_coddmp#774826, cr_datdmp#774827, cr_heudmp#774828, cr_oiddmp#774829, cr_visdmp#774830, cr_scnpat#774831, cr_datscn#774832, cr_nummcr#774833, cr_numcr_cloud#774834, cr_numdrv#774835, cr_flarch_d#774836, cr_refext#774837, cr_annonce#774838, cr_periph#774839, cr_datcre#774840, cr_heucre#774841, cr_origine#774842, cr_oid#774843, cr_flordo#774844, cr_idcda#774845, cr_fltr#774846]

(4) Scan JDBCRelation((SELECT "cr_numcr", "cr_numdos", "cr_nomdic", "cr_numdem", "cr_numexa", "cr_typdoc", "cr_prior", "cr_nomdcr", "cr_taidcr", "cr_durdcr", "cr_posdcr", "cr_nomdos", "cr_for_cr", "cr_cr", "cr_statdic", "cr_statsm", "cr_statcr", "cr_coddic", "cr_context", "cr_datdic", "cr_heudic", "cr_heui_d", "cr_heui_f", "cr_codsec", "cr_datsec", "cr_heusec", "cr_codvcr", "cr_datvcr", "cr_heuvcr", "cr_coddcr", "cr_datdcr", "cr_heudcr", "cr_dat_eff_d", "cr_dat_eff_w", "cr_coduti", "cr_datmaj", "cr_codsit", "cr_sectra", "cr_typcr", "cr_codsup", "cr_nivvcr", "cr_numvcr", "cr_nb_cor", "cr_datsup", "cr_heusup", "cr_flarch", "cr_staext", "cr_flimpr", "cr_lockcr", "cr_codmcr", "cr_datmcr", "cr_heumcr", "cr_codacc", "cr_motpas", "cr_libco", "cr_subdic", "cr_subdir", "cr_numprt", "cr_sta_env_prt", "cr_sta_ret_pro", "cr_sta_env_fra", "cr_sta_ret_fra", "cr_codcli", "cr_pri_dic", "cr_dat_dic_tra", "cr_heu_dic_tra", "cr_codfra", "cr_secext", "cr_statut_ext", "cr_simp_job_id", "cr_dat_cr_int", "cr_heu_cr_int", "cr_delai_total", "cr_nb_ligne_ext", "cr_nb_car_ext", "cr_nomext", "cr_subext", "cr_fltbdi", "cr_typdic", "cr_sta_env_ack", "cr_sta_ret_ack", "cr_taille_dic", "cr_chksum_dic", "cr_datmail", "cr_heumail", "cr_codmail", "cr_stadmp", "cr_coddmp", "cr_datdmp", "cr_heudmp", "cr_oiddmp", "cr_visdmp", "cr_scnpat", "cr_datscn", "cr_nummcr", "cr_numcr_cloud", "cr_numdrv", "cr_flarch_d", "cr_refext", "cr_annonce", "cr_periph", "cr_datcre", "cr_heucre", "cr_origine", "cr_oid", "cr_flordo", "cr_idcda", "cr_fltr" FROM "xplore2"."h_cr") as x) [numPartitions=1] 
Output [108]: [cr_numcr#775714, cr_numdos#775715, cr_nomdic#775716, cr_numdem#775717, cr_numexa#775718, cr_typdoc#775719, cr_prior#775720, cr_nomdcr#775721, cr_taidcr#775722, cr_durdcr#775723, cr_posdcr#775724, cr_nomdos#775725, cr_for_cr#775726, cr_cr#775727, cr_statdic#775728, cr_statsm#775729, cr_statcr#775730, cr_coddic#775731, cr_context#775732, cr_datdic#775733, cr_heudic#775734, cr_heui_d#775735, cr_heui_f#775736, cr_codsec#775737, cr_datsec#775738, cr_heusec#775739, cr_codvcr#775740, cr_datvcr#775741, cr_heuvcr#775742, cr_coddcr#775743, cr_datdcr#775744, cr_heudcr#775745, cr_dat_eff_d#775746, cr_dat_eff_w#775747, cr_coduti#775748, cr_datmaj#775749, cr_codsit#775750, cr_sectra#775751, cr_typcr#775752, cr_codsup#775753, cr_nivvcr#775754, cr_numvcr#775755, cr_nb_cor#775756, cr_datsup#775757, cr_heusup#775758, cr_flarch#775759, cr_staext#775760, cr_flimpr#775761, cr_lockcr#775762, cr_codmcr#775763, cr_datmcr#775764, cr_heumcr#775765, cr_codacc#775766, cr_motpas#775767, cr_libco#775768, cr_subdic#775769, cr_subdir#775770, cr_numprt#775771, cr_sta_env_prt#775772, cr_sta_ret_pro#775773, cr_sta_env_fra#775774, cr_sta_ret_fra#775775, cr_codcli#775776, cr_pri_dic#775777, cr_dat_dic_tra#775778, cr_heu_dic_tra#775779, cr_codfra#775780, cr_secext#775781, cr_statut_ext#775782, cr_simp_job_id#775783, cr_dat_cr_int#775784, cr_heu_cr_int#775785, cr_delai_total#775786, cr_nb_ligne_ext#775787, cr_nb_car_ext#775788, cr_nomext#775789, cr_subext#775790, cr_fltbdi#775791, cr_typdic#775792, cr_sta_env_ack#775793, cr_sta_ret_ack#775794, cr_taille_dic#775795, cr_chksum_dic#775796, cr_datmail#775797, cr_heumail#775798, cr_codmail#775799, cr_stadmp#775800, cr_coddmp#775801, cr_datdmp#775802, cr_heudmp#775803, cr_oiddmp#775804, cr_visdmp#775805, cr_scnpat#775806, cr_datscn#775807, cr_nummcr#775808, cr_numcr_cloud#775809, cr_numdrv#775810, cr_flarch_d#775811, cr_refext#775812, cr_annonce#775813, cr_periph#775814, cr_datcre#775815, cr_heucre#775816, cr_origine#775817, cr_oid#775818, cr_flordo#775819, cr_idcda#775820, cr_fltr#775821]
ReadSchema: struct<cr_numcr:string,cr_numdos:string,cr_nomdic:string,cr_numdem:string,cr_numexa:string,cr_typdoc:string,cr_prior:string,cr_nomdcr:string,cr_taidcr:string,cr_durdcr:string,cr_posdcr:string,cr_nomdos:string,cr_for_cr:string,cr_cr:string,cr_statdic:string,cr_statsm:string,cr_statcr:string,cr_coddic:string,cr_context:string,cr_datdic:string,cr_heudic:string,cr_heui_d:string,cr_heui_f:string,cr_codsec:string,cr_datsec:string,cr_heusec:string,cr_codvcr:string,cr_datvcr:string,cr_heuvcr:string,cr_coddcr:string,cr_datdcr:string,cr_heudcr:string,cr_dat_eff_d:string,cr_dat_eff_w:string,cr_coduti:string,cr_datmaj:string,cr_codsit:string,cr_sectra:string,cr_typcr:string,cr_codsup:string,cr_nivvcr:string,cr_numvcr:string,cr_nb_cor:string,cr_datsup:string,cr_heusup:string,cr_flarch:string,cr_staext:string,cr_flimpr:string,cr_lockcr:string,cr_codmcr:string,cr_datmcr:string,cr_heumcr:string,cr_codacc:string,cr_motpas:string,cr_libco:string,cr_subdic:string,cr_subdir:string,cr_numprt:string,cr_sta_env_prt:string,cr_sta_ret_pro:string,cr_sta_env_fra:string,cr_sta_ret_fra:string,cr_codcli:string,cr_pri_dic:string,cr_dat_dic_tra:string,cr_heu_dic_tra:string,cr_codfra:string,cr_secext:string,cr_statut_ext:string,cr_simp_job_id:string,cr_dat_cr_int:string,cr_heu_cr_int:string,cr_delai_total:string,cr_nb_ligne_ext:string,cr_nb_car_ext:string,cr_nomext:string,cr_subext:string,cr_fltbdi:string,cr_typdic:string,cr_sta_env_ack:string,cr_sta_ret_ack:string,cr_taille_dic:string,cr_chksum_dic:string,cr_datmail:string,cr_heumail:string,cr_codmail:string,cr_stadmp:string,cr_coddmp:string,cr_datdmp:string,cr_heudmp:string,cr_oiddmp:string,cr_visdmp:string,cr_scnpat:string,cr_datscn:string,cr_nummcr:string,cr_numcr_cloud:string,cr_numdrv:string,cr_flarch_d:string,cr_refext:string,cr_annonce:string,cr_periph:string,cr_datcre:string,cr_heucre:string,cr_origine:string,cr_oid:string,cr_flordo:string,cr_idcda:string,cr_fltr:string>

(5) Filter
Input [108]: [cr_numcr#775714, cr_numdos#775715, cr_nomdic#775716, cr_numdem#775717, cr_numexa#775718, cr_typdoc#775719, cr_prior#775720, cr_nomdcr#775721, cr_taidcr#775722, cr_durdcr#775723, cr_posdcr#775724, cr_nomdos#775725, cr_for_cr#775726, cr_cr#775727, cr_statdic#775728, cr_statsm#775729, cr_statcr#775730, cr_coddic#775731, cr_context#775732, cr_datdic#775733, cr_heudic#775734, cr_heui_d#775735, cr_heui_f#775736, cr_codsec#775737, cr_datsec#775738, cr_heusec#775739, cr_codvcr#775740, cr_datvcr#775741, cr_heuvcr#775742, cr_coddcr#775743, cr_datdcr#775744, cr_heudcr#775745, cr_dat_eff_d#775746, cr_dat_eff_w#775747, cr_coduti#775748, cr_datmaj#775749, cr_codsit#775750, cr_sectra#775751, cr_typcr#775752, cr_codsup#775753, cr_nivvcr#775754, cr_numvcr#775755, cr_nb_cor#775756, cr_datsup#775757, cr_heusup#775758, cr_flarch#775759, cr_staext#775760, cr_flimpr#775761, cr_lockcr#775762, cr_codmcr#775763, cr_datmcr#775764, cr_heumcr#775765, cr_codacc#775766, cr_motpas#775767, cr_libco#775768, cr_subdic#775769, cr_subdir#775770, cr_numprt#775771, cr_sta_env_prt#775772, cr_sta_ret_pro#775773, cr_sta_env_fra#775774, cr_sta_ret_fra#775775, cr_codcli#775776, cr_pri_dic#775777, cr_dat_dic_tra#775778, cr_heu_dic_tra#775779, cr_codfra#775780, cr_secext#775781, cr_statut_ext#775782, cr_simp_job_id#775783, cr_dat_cr_int#775784, cr_heu_cr_int#775785, cr_delai_total#775786, cr_nb_ligne_ext#775787, cr_nb_car_ext#775788, cr_nomext#775789, cr_subext#775790, cr_fltbdi#775791, cr_typdic#775792, cr_sta_env_ack#775793, cr_sta_ret_ack#775794, cr_taille_dic#775795, cr_chksum_dic#775796, cr_datmail#775797, cr_heumail#775798, cr_codmail#775799, cr_stadmp#775800, cr_coddmp#775801, cr_datdmp#775802, cr_heudmp#775803, cr_oiddmp#775804, cr_visdmp#775805, cr_scnpat#775806, cr_datscn#775807, cr_nummcr#775808, cr_numcr_cloud#775809, cr_numdrv#775810, cr_flarch_d#775811, cr_refext#775812, cr_annonce#775813, cr_periph#775814, cr_datcre#775815, cr_heucre#775816, cr_origine#775817, cr_oid#775818, cr_flordo#775819, cr_idcda#775820, cr_fltr#775821]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numcr#775714)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numcr#775714)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdos#775715)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdos#775715)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdic#775716)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdic#775716)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdem#775717)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdem#775717)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numexa#775718)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numexa#775718)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typdoc#775719)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typdoc#775719)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_prior#775720)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_prior#775720)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdcr#775721)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdcr#775721)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_taidcr#775722)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_taidcr#775722)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_durdcr#775723)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_durdcr#775723)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_posdcr#775724)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_posdcr#775724)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdos#775725)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdos#775725)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_for_cr#775726)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_for_cr#775726)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_cr#775727)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_cr#775727)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statdic#775728)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statdic#775728)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statsm#775729)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statsm#775729)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statcr#775730)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statcr#775730)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddic#775731)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddic#775731)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_context#775732)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_context#775732)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdic#775733)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdic#775733)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudic#775734)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudic#775734)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heui_d#775735)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heui_d#775735)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heui_f#775736)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heui_f#775736)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsec#775737)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsec#775737)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datsec#775738)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datsec#775738)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heusec#775739)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heusec#775739)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codvcr#775740)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codvcr#775740)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datvcr#775741)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datvcr#775741)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heuvcr#775742)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heuvcr#775742)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddcr#775743)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddcr#775743)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdcr#775744)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdcr#775744)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudcr#775745)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudcr#775745)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_eff_d#775746)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_eff_d#775746)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_eff_w#775747)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_eff_w#775747)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coduti#775748)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coduti#775748)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmaj#775749)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmaj#775749)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsit#775750)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsit#775750)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sectra#775751)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sectra#775751)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typcr#775752)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typcr#775752)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsup#775753)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsup#775753)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nivvcr#775754)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nivvcr#775754)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numvcr#775755)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numvcr#775755)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_cor#775756)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_cor#775756)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datsup#775757)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datsup#775757)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heusup#775758)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heusup#775758)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flarch#775759)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flarch#775759)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_staext#775760)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_staext#775760)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flimpr#775761)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flimpr#775761)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_lockcr#775762)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_lockcr#775762)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codmcr#775763)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codmcr#775763)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmcr#775764)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmcr#775764)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heumcr#775765)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heumcr#775765)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codacc#775766)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codacc#775766)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_motpas#775767)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_motpas#775767)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_libco#775768)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_libco#775768)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subdic#775769)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subdic#775769)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subdir#775770)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subdir#775770)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numprt#775771)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numprt#775771)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_prt#775772)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_prt#775772)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_pro#775773)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_pro#775773)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_fra#775774)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_fra#775774)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_fra#775775)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_fra#775775)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codcli#775776)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codcli#775776)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_pri_dic#775777)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_pri_dic#775777)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_dic_tra#775778)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_dic_tra#775778)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heu_dic_tra#775779)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heu_dic_tra#775779)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codfra#775780)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codfra#775780)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_secext#775781)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_secext#775781)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statut_ext#775782)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statut_ext#775782)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_simp_job_id#775783)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_simp_job_id#775783)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_cr_int#775784)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_cr_int#775784)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heu_cr_int#775785)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heu_cr_int#775785)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_delai_total#775786)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_delai_total#775786)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_ligne_ext#775787)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_ligne_ext#775787)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_car_ext#775788)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_car_ext#775788)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomext#775789)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomext#775789)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subext#775790)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subext#775790)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_fltbdi#775791)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_fltbdi#775791)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typdic#775792)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typdic#775792)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_ack#775793)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_ack#775793)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_ack#775794)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_ack#775794)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_taille_dic#775795)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_taille_dic#775795)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_chksum_dic#775796)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_chksum_dic#775796)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmail#775797)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmail#775797)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heumail#775798)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heumail#775798)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codmail#775799)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codmail#775799)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_stadmp#775800)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_stadmp#775800)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddmp#775801)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddmp#775801)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdmp#775802)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdmp#775802)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudmp#775803)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudmp#775803)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_oiddmp#775804)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_oiddmp#775804)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_visdmp#775805)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_visdmp#775805)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_scnpat#775806)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_scnpat#775806)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datscn#775807)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datscn#775807)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nummcr#775808)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nummcr#775808)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numcr_cloud#775809)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numcr_cloud#775809)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdrv#775810)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdrv#775810)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flarch_d#775811)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flarch_d#775811)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_refext#775812)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_refext#775812)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_annonce#775813)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_annonce#775813)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_periph#775814)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_periph#775814)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datcre#775815)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datcre#775815)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heucre#775816)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heucre#775816)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_origine#775817)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_origine#775817)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_oid#775818)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_oid#775818)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flordo#775819)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flordo#775819)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_idcda#775820)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_idcda#775820)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_fltr#775821)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_fltr#775821)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_create(Cab_B))), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(str_create(Cab_B))), MAIN) END)

(6) Project
Output: []
Input [108]: [cr_numcr#775714, cr_numdos#775715, cr_nomdic#775716, cr_numdem#775717, cr_numexa#775718, cr_typdoc#775719, cr_prior#775720, cr_nomdcr#775721, cr_taidcr#775722, cr_durdcr#775723, cr_posdcr#775724, cr_nomdos#775725, cr_for_cr#775726, cr_cr#775727, cr_statdic#775728, cr_statsm#775729, cr_statcr#775730, cr_coddic#775731, cr_context#775732, cr_datdic#775733, cr_heudic#775734, cr_heui_d#775735, cr_heui_f#775736, cr_codsec#775737, cr_datsec#775738, cr_heusec#775739, cr_codvcr#775740, cr_datvcr#775741, cr_heuvcr#775742, cr_coddcr#775743, cr_datdcr#775744, cr_heudcr#775745, cr_dat_eff_d#775746, cr_dat_eff_w#775747, cr_coduti#775748, cr_datmaj#775749, cr_codsit#775750, cr_sectra#775751, cr_typcr#775752, cr_codsup#775753, cr_nivvcr#775754, cr_numvcr#775755, cr_nb_cor#775756, cr_datsup#775757, cr_heusup#775758, cr_flarch#775759, cr_staext#775760, cr_flimpr#775761, cr_lockcr#775762, cr_codmcr#775763, cr_datmcr#775764, cr_heumcr#775765, cr_codacc#775766, cr_motpas#775767, cr_libco#775768, cr_subdic#775769, cr_subdir#775770, cr_numprt#775771, cr_sta_env_prt#775772, cr_sta_ret_pro#775773, cr_sta_env_fra#775774, cr_sta_ret_fra#775775, cr_codcli#775776, cr_pri_dic#775777, cr_dat_dic_tra#775778, cr_heu_dic_tra#775779, cr_codfra#775780, cr_secext#775781, cr_statut_ext#775782, cr_simp_job_id#775783, cr_dat_cr_int#775784, cr_heu_cr_int#775785, cr_delai_total#775786, cr_nb_ligne_ext#775787, cr_nb_car_ext#775788, cr_nomext#775789, cr_subext#775790, cr_fltbdi#775791, cr_typdic#775792, cr_sta_env_ack#775793, cr_sta_ret_ack#775794, cr_taille_dic#775795, cr_chksum_dic#775796, cr_datmail#775797, cr_heumail#775798, cr_codmail#775799, cr_stadmp#775800, cr_coddmp#775801, cr_datdmp#775802, cr_heudmp#775803, cr_oiddmp#775804, cr_visdmp#775805, cr_scnpat#775806, cr_datscn#775807, cr_nummcr#775808, cr_numcr_cloud#775809, cr_numdrv#775810, cr_flarch_d#775811, cr_refext#775812, cr_annonce#775813, cr_periph#775814, cr_datcre#775815, cr_heucre#775816, cr_origine#775817, cr_oid#775818, cr_flordo#775819, cr_idcda#775820, cr_fltr#775821]

(7) Union

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

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

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

(11) HashAggregate [codegen id : 2]
Input [1]: [count#777783L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#777670L]
Results [1]: [count(1)#777670L AS count#777671L]

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

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

(14) HashAggregate
Input [1]: [count#777783L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#777670L]
Results [1]: [count(1)#777670L AS count#777671L]

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

SQL / DataFrame Properties

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