hdh-spark-job - Details for Query 1433

Submitted Time: 2026/10/23 13:29:14
Duration: 15 s
Succeeded Jobs: 1429 1434

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 2076.0: task 1813)) 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 2076.0: task 1813)) 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 2076.0: task 1813))"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n5.8 s (2.9 s, 2.9 s, 2.9 s (stage 2076.0: task 1814))"; 5 [labelType="html" label="HashAggregate time in aggregation build total (min, med, max (stageId: taskId)) 5.8 s (2.9 s, 2.9 s, 2.9 s (stage 2076.0: task 1814)) 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=39020]

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

WholeStageCodegen (1)

Union

Project

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numcr#725466)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numcr#725466)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdos#725467)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdos#725467)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdic#725468)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdic#725468)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdem#725469)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdem#725469)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numexa#725470)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numexa#725470)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typdoc#725471)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typdoc#725471)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_prior#725472)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_prior#725472)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdcr#725473)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdcr#725473)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_taidcr#725474)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_taidcr#725474)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_durdcr#725475)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_durdcr#725475)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_posdcr#725476)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_posdcr#725476)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdos#725477)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdos#725477)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_for_cr#725478)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_for_cr#725478)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_cr#725479)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_cr#725479)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statdic#725480)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statdic#725480)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statsm#725481)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statsm#725481)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statcr#725482)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statcr#725482)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddic#725483)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddic#725483)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_context#725484)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_context#725484)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdic#725485)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdic#725485)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudic#725486)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudic#725486)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heui_d#725487)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heui_d#725487)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heui_f#725488)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heui_f#725488)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsec#725489)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsec#725489)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datsec#725490)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datsec#725490)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heusec#725491)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heusec#725491)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codvcr#725492)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codvcr#725492)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datvcr#725493)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datvcr#725493)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heuvcr#725494)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heuvcr#725494)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddcr#725495)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddcr#725495)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdcr#725496)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdcr#725496)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudcr#725497)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudcr#725497)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_eff_d#725498)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_eff_d#725498)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_eff_w#725499)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_eff_w#725499)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coduti#725500)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coduti#725500)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmaj#725501)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmaj#725501)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsit#725502)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsit#725502)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sectra#725503)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sectra#725503)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typcr#725504)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typcr#725504)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsup#725505)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsup#725505)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nivvcr#725506)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nivvcr#725506)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numvcr#725507)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numvcr#725507)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_cor#725508)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_cor#725508)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datsup#725509)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datsup#725509)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heusup#725510)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heusup#725510)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flarch#725511)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flarch#725511)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_staext#725512)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_staext#725512)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flimpr#725513)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flimpr#725513)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_lockcr#725514)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_lockcr#725514)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codmcr#725515)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codmcr#725515)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmcr#725516)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmcr#725516)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heumcr#725517)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heumcr#725517)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codacc#725518)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codacc#725518)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_motpas#725519)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_motpas#725519)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_libco#725520)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_libco#725520)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subdic#725521)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subdic#725521)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subdir#725522)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subdir#725522)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numprt#725523)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numprt#725523)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_prt#725524)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_prt#725524)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_pro#725525)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_pro#725525)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_fra#725526)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_fra#725526)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_fra#725527)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_fra#725527)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codcli#725528)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codcli#725528)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_pri_dic#725529)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_pri_dic#725529)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_dic_tra#725530)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_dic_tra#725530)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heu_dic_tra#725531)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heu_dic_tra#725531)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codfra#725532)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codfra#725532)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_secext#725533)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_secext#725533)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statut_ext#725534)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statut_ext#725534)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_simp_job_id#725535)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_simp_job_id#725535)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_cr_int#725536)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_cr_int#725536)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heu_cr_int#725537)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heu_cr_int#725537)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_delai_total#725538)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_delai_total#725538)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_ligne_ext#725539)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_ligne_ext#725539)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_car_ext#725540)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_car_ext#725540)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomext#725541)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomext#725541)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subext#725542)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subext#725542)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_fltbdi#725543)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_fltbdi#725543)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typdic#725544)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typdic#725544)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_ack#725545)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_ack#725545)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_ack#725546)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_ack#725546)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_taille_dic#725547)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_taille_dic#725547)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_chksum_dic#725548)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_chksum_dic#725548)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmail#725549)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmail#725549)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heumail#725550)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heumail#725550)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codmail#725551)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codmail#725551)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_stadmp#725552)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_stadmp#725552)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddmp#725553)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddmp#725553)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdmp#725554)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdmp#725554)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudmp#725555)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudmp#725555)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_oiddmp#725556)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_oiddmp#725556)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_visdmp#725557)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_visdmp#725557)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_scnpat#725558)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_scnpat#725558)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datscn#725559)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datscn#725559)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nummcr#725560)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nummcr#725560)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numcr_cloud#725561)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numcr_cloud#725561)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdrv#725562)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdrv#725562)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flarch_d#725563)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flarch_d#725563)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_refext#725564)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_refext#725564)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_annonce#725565)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_annonce#725565)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_periph#725566)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_periph#725566)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datcre#725567)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datcre#725567)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heucre#725568)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heucre#725568)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_origine#725569)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_origine#725569)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_oid#725570)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_oid#725570)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flordo#725571)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flordo#725571)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_idcda#725572)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_idcda#725572)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_fltr#725573)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_fltr#725573)), 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#725466,cr_numdos#725467,cr_nomdic#725468,cr_numdem#725469,cr_numexa#725470,cr_typdoc#725471,cr_prior#725472,cr_nomdcr#725473,cr_taidcr#725474,cr_durdcr#725475,cr_posdcr#725476,cr_nomdos#725477,cr_for_cr#725478,cr_cr#725479,cr_statdic#725480,cr_statsm#725481,cr_statcr#725482,cr_coddic#725483,cr_context#725484,cr_datdic#725485,cr_heudic#725486,cr_heui_d#725487,cr_heui_f#725488,cr_codsec#725489,... 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#726441)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numcr#726441)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdos#726442)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdos#726442)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdic#726443)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdic#726443)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdem#726444)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdem#726444)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numexa#726445)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numexa#726445)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typdoc#726446)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typdoc#726446)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_prior#726447)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_prior#726447)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdcr#726448)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdcr#726448)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_taidcr#726449)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_taidcr#726449)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_durdcr#726450)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_durdcr#726450)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_posdcr#726451)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_posdcr#726451)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdos#726452)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdos#726452)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_for_cr#726453)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_for_cr#726453)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_cr#726454)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_cr#726454)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statdic#726455)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statdic#726455)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statsm#726456)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statsm#726456)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statcr#726457)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statcr#726457)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddic#726458)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddic#726458)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_context#726459)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_context#726459)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdic#726460)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdic#726460)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudic#726461)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudic#726461)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heui_d#726462)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heui_d#726462)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heui_f#726463)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heui_f#726463)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsec#726464)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsec#726464)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datsec#726465)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datsec#726465)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heusec#726466)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heusec#726466)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codvcr#726467)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codvcr#726467)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datvcr#726468)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datvcr#726468)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heuvcr#726469)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heuvcr#726469)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddcr#726470)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddcr#726470)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdcr#726471)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdcr#726471)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudcr#726472)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudcr#726472)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_eff_d#726473)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_eff_d#726473)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_eff_w#726474)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_eff_w#726474)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coduti#726475)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coduti#726475)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmaj#726476)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmaj#726476)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsit#726477)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsit#726477)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sectra#726478)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sectra#726478)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typcr#726479)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typcr#726479)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsup#726480)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsup#726480)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nivvcr#726481)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nivvcr#726481)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numvcr#726482)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numvcr#726482)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_cor#726483)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_cor#726483)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datsup#726484)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datsup#726484)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heusup#726485)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heusup#726485)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flarch#726486)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flarch#726486)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_staext#726487)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_staext#726487)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flimpr#726488)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flimpr#726488)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_lockcr#726489)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_lockcr#726489)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codmcr#726490)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codmcr#726490)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmcr#726491)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmcr#726491)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heumcr#726492)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heumcr#726492)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codacc#726493)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codacc#726493)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_motpas#726494)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_motpas#726494)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_libco#726495)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_libco#726495)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subdic#726496)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subdic#726496)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subdir#726497)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subdir#726497)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numprt#726498)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numprt#726498)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_prt#726499)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_prt#726499)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_pro#726500)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_pro#726500)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_fra#726501)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_fra#726501)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_fra#726502)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_fra#726502)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codcli#726503)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codcli#726503)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_pri_dic#726504)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_pri_dic#726504)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_dic_tra#726505)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_dic_tra#726505)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heu_dic_tra#726506)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heu_dic_tra#726506)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codfra#726507)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codfra#726507)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_secext#726508)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_secext#726508)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statut_ext#726509)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statut_ext#726509)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_simp_job_id#726510)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_simp_job_id#726510)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_cr_int#726511)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_cr_int#726511)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heu_cr_int#726512)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heu_cr_int#726512)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_delai_total#726513)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_delai_total#726513)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_ligne_ext#726514)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_ligne_ext#726514)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_car_ext#726515)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_car_ext#726515)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomext#726516)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomext#726516)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subext#726517)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subext#726517)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_fltbdi#726518)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_fltbdi#726518)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typdic#726519)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typdic#726519)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_ack#726520)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_ack#726520)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_ack#726521)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_ack#726521)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_taille_dic#726522)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_taille_dic#726522)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_chksum_dic#726523)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_chksum_dic#726523)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmail#726524)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmail#726524)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heumail#726525)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heumail#726525)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codmail#726526)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codmail#726526)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_stadmp#726527)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_stadmp#726527)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddmp#726528)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddmp#726528)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdmp#726529)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdmp#726529)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudmp#726530)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudmp#726530)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_oiddmp#726531)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_oiddmp#726531)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_visdmp#726532)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_visdmp#726532)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_scnpat#726533)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_scnpat#726533)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datscn#726534)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datscn#726534)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nummcr#726535)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nummcr#726535)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numcr_cloud#726536)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numcr_cloud#726536)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdrv#726537)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdrv#726537)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flarch_d#726538)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flarch_d#726538)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_refext#726539)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_refext#726539)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_annonce#726540)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_annonce#726540)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_periph#726541)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_periph#726541)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datcre#726542)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datcre#726542)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heucre#726543)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heucre#726543)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_origine#726544)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_origine#726544)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_oid#726545)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_oid#726545)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flordo#726546)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flordo#726546)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_idcda#726547)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_idcda#726547)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_fltr#726548)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_fltr#726548)), 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#726441,cr_numdos#726442,cr_nomdic#726443,cr_numdem#726444,cr_numexa#726445,cr_typdoc#726446,cr_prior#726447,cr_nomdcr#726448,cr_taidcr#726449,cr_durdcr#726450,cr_posdcr#726451,cr_nomdos#726452,cr_for_cr#726453,cr_cr#726454,cr_statdic#726455,cr_statsm#726456,cr_statcr#726457,cr_coddic#726458,cr_context#726459,cr_datdic#726460,cr_heudic#726461,cr_heui_d#726462,cr_heui_f#726463,cr_codsec#726464,... 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#725466, cr_numdos#725467, cr_nomdic#725468, cr_numdem#725469, cr_numexa#725470, cr_typdoc#725471, cr_prior#725472, cr_nomdcr#725473, cr_taidcr#725474, cr_durdcr#725475, cr_posdcr#725476, cr_nomdos#725477, cr_for_cr#725478, cr_cr#725479, cr_statdic#725480, cr_statsm#725481, cr_statcr#725482, cr_coddic#725483, cr_context#725484, cr_datdic#725485, cr_heudic#725486, cr_heui_d#725487, cr_heui_f#725488, cr_codsec#725489, cr_datsec#725490, cr_heusec#725491, cr_codvcr#725492, cr_datvcr#725493, cr_heuvcr#725494, cr_coddcr#725495, cr_datdcr#725496, cr_heudcr#725497, cr_dat_eff_d#725498, cr_dat_eff_w#725499, cr_coduti#725500, cr_datmaj#725501, cr_codsit#725502, cr_sectra#725503, cr_typcr#725504, cr_codsup#725505, cr_nivvcr#725506, cr_numvcr#725507, cr_nb_cor#725508, cr_datsup#725509, cr_heusup#725510, cr_flarch#725511, cr_staext#725512, cr_flimpr#725513, cr_lockcr#725514, cr_codmcr#725515, cr_datmcr#725516, cr_heumcr#725517, cr_codacc#725518, cr_motpas#725519, cr_libco#725520, cr_subdic#725521, cr_subdir#725522, cr_numprt#725523, cr_sta_env_prt#725524, cr_sta_ret_pro#725525, cr_sta_env_fra#725526, cr_sta_ret_fra#725527, cr_codcli#725528, cr_pri_dic#725529, cr_dat_dic_tra#725530, cr_heu_dic_tra#725531, cr_codfra#725532, cr_secext#725533, cr_statut_ext#725534, cr_simp_job_id#725535, cr_dat_cr_int#725536, cr_heu_cr_int#725537, cr_delai_total#725538, cr_nb_ligne_ext#725539, cr_nb_car_ext#725540, cr_nomext#725541, cr_subext#725542, cr_fltbdi#725543, cr_typdic#725544, cr_sta_env_ack#725545, cr_sta_ret_ack#725546, cr_taille_dic#725547, cr_chksum_dic#725548, cr_datmail#725549, cr_heumail#725550, cr_codmail#725551, cr_stadmp#725552, cr_coddmp#725553, cr_datdmp#725554, cr_heudmp#725555, cr_oiddmp#725556, cr_visdmp#725557, cr_scnpat#725558, cr_datscn#725559, cr_nummcr#725560, cr_numcr_cloud#725561, cr_numdrv#725562, cr_flarch_d#725563, cr_refext#725564, cr_annonce#725565, cr_periph#725566, cr_datcre#725567, cr_heucre#725568, cr_origine#725569, cr_oid#725570, cr_flordo#725571, cr_idcda#725572, cr_fltr#725573]
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#725466, cr_numdos#725467, cr_nomdic#725468, cr_numdem#725469, cr_numexa#725470, cr_typdoc#725471, cr_prior#725472, cr_nomdcr#725473, cr_taidcr#725474, cr_durdcr#725475, cr_posdcr#725476, cr_nomdos#725477, cr_for_cr#725478, cr_cr#725479, cr_statdic#725480, cr_statsm#725481, cr_statcr#725482, cr_coddic#725483, cr_context#725484, cr_datdic#725485, cr_heudic#725486, cr_heui_d#725487, cr_heui_f#725488, cr_codsec#725489, cr_datsec#725490, cr_heusec#725491, cr_codvcr#725492, cr_datvcr#725493, cr_heuvcr#725494, cr_coddcr#725495, cr_datdcr#725496, cr_heudcr#725497, cr_dat_eff_d#725498, cr_dat_eff_w#725499, cr_coduti#725500, cr_datmaj#725501, cr_codsit#725502, cr_sectra#725503, cr_typcr#725504, cr_codsup#725505, cr_nivvcr#725506, cr_numvcr#725507, cr_nb_cor#725508, cr_datsup#725509, cr_heusup#725510, cr_flarch#725511, cr_staext#725512, cr_flimpr#725513, cr_lockcr#725514, cr_codmcr#725515, cr_datmcr#725516, cr_heumcr#725517, cr_codacc#725518, cr_motpas#725519, cr_libco#725520, cr_subdic#725521, cr_subdir#725522, cr_numprt#725523, cr_sta_env_prt#725524, cr_sta_ret_pro#725525, cr_sta_env_fra#725526, cr_sta_ret_fra#725527, cr_codcli#725528, cr_pri_dic#725529, cr_dat_dic_tra#725530, cr_heu_dic_tra#725531, cr_codfra#725532, cr_secext#725533, cr_statut_ext#725534, cr_simp_job_id#725535, cr_dat_cr_int#725536, cr_heu_cr_int#725537, cr_delai_total#725538, cr_nb_ligne_ext#725539, cr_nb_car_ext#725540, cr_nomext#725541, cr_subext#725542, cr_fltbdi#725543, cr_typdic#725544, cr_sta_env_ack#725545, cr_sta_ret_ack#725546, cr_taille_dic#725547, cr_chksum_dic#725548, cr_datmail#725549, cr_heumail#725550, cr_codmail#725551, cr_stadmp#725552, cr_coddmp#725553, cr_datdmp#725554, cr_heudmp#725555, cr_oiddmp#725556, cr_visdmp#725557, cr_scnpat#725558, cr_datscn#725559, cr_nummcr#725560, cr_numcr_cloud#725561, cr_numdrv#725562, cr_flarch_d#725563, cr_refext#725564, cr_annonce#725565, cr_periph#725566, cr_datcre#725567, cr_heucre#725568, cr_origine#725569, cr_oid#725570, cr_flordo#725571, cr_idcda#725572, cr_fltr#725573]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numcr#725466)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numcr#725466)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdos#725467)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdos#725467)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdic#725468)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdic#725468)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdem#725469)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdem#725469)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numexa#725470)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numexa#725470)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typdoc#725471)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typdoc#725471)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_prior#725472)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_prior#725472)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdcr#725473)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdcr#725473)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_taidcr#725474)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_taidcr#725474)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_durdcr#725475)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_durdcr#725475)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_posdcr#725476)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_posdcr#725476)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdos#725477)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdos#725477)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_for_cr#725478)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_for_cr#725478)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_cr#725479)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_cr#725479)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statdic#725480)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statdic#725480)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statsm#725481)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statsm#725481)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statcr#725482)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statcr#725482)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddic#725483)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddic#725483)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_context#725484)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_context#725484)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdic#725485)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdic#725485)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudic#725486)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudic#725486)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heui_d#725487)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heui_d#725487)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heui_f#725488)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heui_f#725488)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsec#725489)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsec#725489)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datsec#725490)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datsec#725490)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heusec#725491)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heusec#725491)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codvcr#725492)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codvcr#725492)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datvcr#725493)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datvcr#725493)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heuvcr#725494)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heuvcr#725494)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddcr#725495)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddcr#725495)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdcr#725496)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdcr#725496)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudcr#725497)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudcr#725497)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_eff_d#725498)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_eff_d#725498)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_eff_w#725499)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_eff_w#725499)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coduti#725500)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coduti#725500)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmaj#725501)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmaj#725501)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsit#725502)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsit#725502)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sectra#725503)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sectra#725503)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typcr#725504)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typcr#725504)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsup#725505)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsup#725505)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nivvcr#725506)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nivvcr#725506)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numvcr#725507)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numvcr#725507)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_cor#725508)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_cor#725508)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datsup#725509)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datsup#725509)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heusup#725510)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heusup#725510)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flarch#725511)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flarch#725511)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_staext#725512)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_staext#725512)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flimpr#725513)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flimpr#725513)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_lockcr#725514)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_lockcr#725514)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codmcr#725515)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codmcr#725515)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmcr#725516)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmcr#725516)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heumcr#725517)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heumcr#725517)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codacc#725518)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codacc#725518)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_motpas#725519)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_motpas#725519)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_libco#725520)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_libco#725520)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subdic#725521)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subdic#725521)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subdir#725522)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subdir#725522)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numprt#725523)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numprt#725523)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_prt#725524)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_prt#725524)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_pro#725525)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_pro#725525)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_fra#725526)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_fra#725526)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_fra#725527)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_fra#725527)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codcli#725528)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codcli#725528)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_pri_dic#725529)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_pri_dic#725529)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_dic_tra#725530)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_dic_tra#725530)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heu_dic_tra#725531)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heu_dic_tra#725531)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codfra#725532)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codfra#725532)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_secext#725533)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_secext#725533)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statut_ext#725534)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statut_ext#725534)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_simp_job_id#725535)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_simp_job_id#725535)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_cr_int#725536)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_cr_int#725536)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heu_cr_int#725537)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heu_cr_int#725537)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_delai_total#725538)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_delai_total#725538)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_ligne_ext#725539)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_ligne_ext#725539)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_car_ext#725540)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_car_ext#725540)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomext#725541)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomext#725541)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subext#725542)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subext#725542)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_fltbdi#725543)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_fltbdi#725543)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typdic#725544)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typdic#725544)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_ack#725545)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_ack#725545)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_ack#725546)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_ack#725546)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_taille_dic#725547)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_taille_dic#725547)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_chksum_dic#725548)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_chksum_dic#725548)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmail#725549)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmail#725549)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heumail#725550)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heumail#725550)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codmail#725551)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codmail#725551)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_stadmp#725552)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_stadmp#725552)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddmp#725553)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddmp#725553)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdmp#725554)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdmp#725554)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudmp#725555)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudmp#725555)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_oiddmp#725556)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_oiddmp#725556)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_visdmp#725557)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_visdmp#725557)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_scnpat#725558)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_scnpat#725558)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datscn#725559)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datscn#725559)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nummcr#725560)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nummcr#725560)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numcr_cloud#725561)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numcr_cloud#725561)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdrv#725562)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdrv#725562)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flarch_d#725563)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flarch_d#725563)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_refext#725564)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_refext#725564)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_annonce#725565)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_annonce#725565)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_periph#725566)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_periph#725566)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datcre#725567)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datcre#725567)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heucre#725568)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heucre#725568)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_origine#725569)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_origine#725569)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_oid#725570)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_oid#725570)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flordo#725571)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flordo#725571)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_idcda#725572)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_idcda#725572)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_fltr#725573)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_fltr#725573)), 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#725466, cr_numdos#725467, cr_nomdic#725468, cr_numdem#725469, cr_numexa#725470, cr_typdoc#725471, cr_prior#725472, cr_nomdcr#725473, cr_taidcr#725474, cr_durdcr#725475, cr_posdcr#725476, cr_nomdos#725477, cr_for_cr#725478, cr_cr#725479, cr_statdic#725480, cr_statsm#725481, cr_statcr#725482, cr_coddic#725483, cr_context#725484, cr_datdic#725485, cr_heudic#725486, cr_heui_d#725487, cr_heui_f#725488, cr_codsec#725489, cr_datsec#725490, cr_heusec#725491, cr_codvcr#725492, cr_datvcr#725493, cr_heuvcr#725494, cr_coddcr#725495, cr_datdcr#725496, cr_heudcr#725497, cr_dat_eff_d#725498, cr_dat_eff_w#725499, cr_coduti#725500, cr_datmaj#725501, cr_codsit#725502, cr_sectra#725503, cr_typcr#725504, cr_codsup#725505, cr_nivvcr#725506, cr_numvcr#725507, cr_nb_cor#725508, cr_datsup#725509, cr_heusup#725510, cr_flarch#725511, cr_staext#725512, cr_flimpr#725513, cr_lockcr#725514, cr_codmcr#725515, cr_datmcr#725516, cr_heumcr#725517, cr_codacc#725518, cr_motpas#725519, cr_libco#725520, cr_subdic#725521, cr_subdir#725522, cr_numprt#725523, cr_sta_env_prt#725524, cr_sta_ret_pro#725525, cr_sta_env_fra#725526, cr_sta_ret_fra#725527, cr_codcli#725528, cr_pri_dic#725529, cr_dat_dic_tra#725530, cr_heu_dic_tra#725531, cr_codfra#725532, cr_secext#725533, cr_statut_ext#725534, cr_simp_job_id#725535, cr_dat_cr_int#725536, cr_heu_cr_int#725537, cr_delai_total#725538, cr_nb_ligne_ext#725539, cr_nb_car_ext#725540, cr_nomext#725541, cr_subext#725542, cr_fltbdi#725543, cr_typdic#725544, cr_sta_env_ack#725545, cr_sta_ret_ack#725546, cr_taille_dic#725547, cr_chksum_dic#725548, cr_datmail#725549, cr_heumail#725550, cr_codmail#725551, cr_stadmp#725552, cr_coddmp#725553, cr_datdmp#725554, cr_heudmp#725555, cr_oiddmp#725556, cr_visdmp#725557, cr_scnpat#725558, cr_datscn#725559, cr_nummcr#725560, cr_numcr_cloud#725561, cr_numdrv#725562, cr_flarch_d#725563, cr_refext#725564, cr_annonce#725565, cr_periph#725566, cr_datcre#725567, cr_heucre#725568, cr_origine#725569, cr_oid#725570, cr_flordo#725571, cr_idcda#725572, cr_fltr#725573]

(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#726441, cr_numdos#726442, cr_nomdic#726443, cr_numdem#726444, cr_numexa#726445, cr_typdoc#726446, cr_prior#726447, cr_nomdcr#726448, cr_taidcr#726449, cr_durdcr#726450, cr_posdcr#726451, cr_nomdos#726452, cr_for_cr#726453, cr_cr#726454, cr_statdic#726455, cr_statsm#726456, cr_statcr#726457, cr_coddic#726458, cr_context#726459, cr_datdic#726460, cr_heudic#726461, cr_heui_d#726462, cr_heui_f#726463, cr_codsec#726464, cr_datsec#726465, cr_heusec#726466, cr_codvcr#726467, cr_datvcr#726468, cr_heuvcr#726469, cr_coddcr#726470, cr_datdcr#726471, cr_heudcr#726472, cr_dat_eff_d#726473, cr_dat_eff_w#726474, cr_coduti#726475, cr_datmaj#726476, cr_codsit#726477, cr_sectra#726478, cr_typcr#726479, cr_codsup#726480, cr_nivvcr#726481, cr_numvcr#726482, cr_nb_cor#726483, cr_datsup#726484, cr_heusup#726485, cr_flarch#726486, cr_staext#726487, cr_flimpr#726488, cr_lockcr#726489, cr_codmcr#726490, cr_datmcr#726491, cr_heumcr#726492, cr_codacc#726493, cr_motpas#726494, cr_libco#726495, cr_subdic#726496, cr_subdir#726497, cr_numprt#726498, cr_sta_env_prt#726499, cr_sta_ret_pro#726500, cr_sta_env_fra#726501, cr_sta_ret_fra#726502, cr_codcli#726503, cr_pri_dic#726504, cr_dat_dic_tra#726505, cr_heu_dic_tra#726506, cr_codfra#726507, cr_secext#726508, cr_statut_ext#726509, cr_simp_job_id#726510, cr_dat_cr_int#726511, cr_heu_cr_int#726512, cr_delai_total#726513, cr_nb_ligne_ext#726514, cr_nb_car_ext#726515, cr_nomext#726516, cr_subext#726517, cr_fltbdi#726518, cr_typdic#726519, cr_sta_env_ack#726520, cr_sta_ret_ack#726521, cr_taille_dic#726522, cr_chksum_dic#726523, cr_datmail#726524, cr_heumail#726525, cr_codmail#726526, cr_stadmp#726527, cr_coddmp#726528, cr_datdmp#726529, cr_heudmp#726530, cr_oiddmp#726531, cr_visdmp#726532, cr_scnpat#726533, cr_datscn#726534, cr_nummcr#726535, cr_numcr_cloud#726536, cr_numdrv#726537, cr_flarch_d#726538, cr_refext#726539, cr_annonce#726540, cr_periph#726541, cr_datcre#726542, cr_heucre#726543, cr_origine#726544, cr_oid#726545, cr_flordo#726546, cr_idcda#726547, cr_fltr#726548]
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#726441, cr_numdos#726442, cr_nomdic#726443, cr_numdem#726444, cr_numexa#726445, cr_typdoc#726446, cr_prior#726447, cr_nomdcr#726448, cr_taidcr#726449, cr_durdcr#726450, cr_posdcr#726451, cr_nomdos#726452, cr_for_cr#726453, cr_cr#726454, cr_statdic#726455, cr_statsm#726456, cr_statcr#726457, cr_coddic#726458, cr_context#726459, cr_datdic#726460, cr_heudic#726461, cr_heui_d#726462, cr_heui_f#726463, cr_codsec#726464, cr_datsec#726465, cr_heusec#726466, cr_codvcr#726467, cr_datvcr#726468, cr_heuvcr#726469, cr_coddcr#726470, cr_datdcr#726471, cr_heudcr#726472, cr_dat_eff_d#726473, cr_dat_eff_w#726474, cr_coduti#726475, cr_datmaj#726476, cr_codsit#726477, cr_sectra#726478, cr_typcr#726479, cr_codsup#726480, cr_nivvcr#726481, cr_numvcr#726482, cr_nb_cor#726483, cr_datsup#726484, cr_heusup#726485, cr_flarch#726486, cr_staext#726487, cr_flimpr#726488, cr_lockcr#726489, cr_codmcr#726490, cr_datmcr#726491, cr_heumcr#726492, cr_codacc#726493, cr_motpas#726494, cr_libco#726495, cr_subdic#726496, cr_subdir#726497, cr_numprt#726498, cr_sta_env_prt#726499, cr_sta_ret_pro#726500, cr_sta_env_fra#726501, cr_sta_ret_fra#726502, cr_codcli#726503, cr_pri_dic#726504, cr_dat_dic_tra#726505, cr_heu_dic_tra#726506, cr_codfra#726507, cr_secext#726508, cr_statut_ext#726509, cr_simp_job_id#726510, cr_dat_cr_int#726511, cr_heu_cr_int#726512, cr_delai_total#726513, cr_nb_ligne_ext#726514, cr_nb_car_ext#726515, cr_nomext#726516, cr_subext#726517, cr_fltbdi#726518, cr_typdic#726519, cr_sta_env_ack#726520, cr_sta_ret_ack#726521, cr_taille_dic#726522, cr_chksum_dic#726523, cr_datmail#726524, cr_heumail#726525, cr_codmail#726526, cr_stadmp#726527, cr_coddmp#726528, cr_datdmp#726529, cr_heudmp#726530, cr_oiddmp#726531, cr_visdmp#726532, cr_scnpat#726533, cr_datscn#726534, cr_nummcr#726535, cr_numcr_cloud#726536, cr_numdrv#726537, cr_flarch_d#726538, cr_refext#726539, cr_annonce#726540, cr_periph#726541, cr_datcre#726542, cr_heucre#726543, cr_origine#726544, cr_oid#726545, cr_flordo#726546, cr_idcda#726547, cr_fltr#726548]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numcr#726441)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numcr#726441)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdos#726442)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdos#726442)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdic#726443)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdic#726443)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdem#726444)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdem#726444)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numexa#726445)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numexa#726445)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typdoc#726446)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typdoc#726446)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_prior#726447)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_prior#726447)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdcr#726448)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdcr#726448)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_taidcr#726449)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_taidcr#726449)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_durdcr#726450)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_durdcr#726450)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_posdcr#726451)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_posdcr#726451)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdos#726452)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdos#726452)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_for_cr#726453)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_for_cr#726453)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_cr#726454)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_cr#726454)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statdic#726455)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statdic#726455)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statsm#726456)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statsm#726456)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statcr#726457)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statcr#726457)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddic#726458)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddic#726458)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_context#726459)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_context#726459)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdic#726460)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdic#726460)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudic#726461)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudic#726461)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heui_d#726462)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heui_d#726462)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heui_f#726463)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heui_f#726463)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsec#726464)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsec#726464)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datsec#726465)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datsec#726465)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heusec#726466)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heusec#726466)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codvcr#726467)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codvcr#726467)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datvcr#726468)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datvcr#726468)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heuvcr#726469)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heuvcr#726469)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddcr#726470)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddcr#726470)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdcr#726471)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdcr#726471)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudcr#726472)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudcr#726472)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_eff_d#726473)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_eff_d#726473)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_eff_w#726474)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_eff_w#726474)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coduti#726475)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coduti#726475)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmaj#726476)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmaj#726476)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsit#726477)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsit#726477)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sectra#726478)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sectra#726478)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typcr#726479)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typcr#726479)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsup#726480)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsup#726480)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nivvcr#726481)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nivvcr#726481)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numvcr#726482)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numvcr#726482)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_cor#726483)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_cor#726483)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datsup#726484)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datsup#726484)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heusup#726485)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heusup#726485)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flarch#726486)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flarch#726486)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_staext#726487)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_staext#726487)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flimpr#726488)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flimpr#726488)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_lockcr#726489)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_lockcr#726489)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codmcr#726490)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codmcr#726490)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmcr#726491)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmcr#726491)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heumcr#726492)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heumcr#726492)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codacc#726493)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codacc#726493)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_motpas#726494)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_motpas#726494)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_libco#726495)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_libco#726495)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subdic#726496)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subdic#726496)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subdir#726497)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subdir#726497)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numprt#726498)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numprt#726498)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_prt#726499)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_prt#726499)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_pro#726500)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_pro#726500)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_fra#726501)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_fra#726501)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_fra#726502)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_fra#726502)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codcli#726503)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codcli#726503)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_pri_dic#726504)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_pri_dic#726504)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_dic_tra#726505)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_dic_tra#726505)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heu_dic_tra#726506)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heu_dic_tra#726506)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codfra#726507)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codfra#726507)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_secext#726508)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_secext#726508)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statut_ext#726509)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statut_ext#726509)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_simp_job_id#726510)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_simp_job_id#726510)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_cr_int#726511)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_cr_int#726511)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heu_cr_int#726512)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heu_cr_int#726512)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_delai_total#726513)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_delai_total#726513)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_ligne_ext#726514)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_ligne_ext#726514)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_car_ext#726515)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_car_ext#726515)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomext#726516)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomext#726516)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subext#726517)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subext#726517)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_fltbdi#726518)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_fltbdi#726518)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typdic#726519)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typdic#726519)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_ack#726520)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_ack#726520)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_ack#726521)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_ack#726521)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_taille_dic#726522)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_taille_dic#726522)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_chksum_dic#726523)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_chksum_dic#726523)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmail#726524)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmail#726524)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heumail#726525)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heumail#726525)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codmail#726526)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codmail#726526)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_stadmp#726527)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_stadmp#726527)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddmp#726528)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddmp#726528)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdmp#726529)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdmp#726529)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudmp#726530)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudmp#726530)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_oiddmp#726531)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_oiddmp#726531)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_visdmp#726532)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_visdmp#726532)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_scnpat#726533)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_scnpat#726533)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datscn#726534)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datscn#726534)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nummcr#726535)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nummcr#726535)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numcr_cloud#726536)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numcr_cloud#726536)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdrv#726537)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdrv#726537)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flarch_d#726538)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flarch_d#726538)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_refext#726539)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_refext#726539)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_annonce#726540)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_annonce#726540)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_periph#726541)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_periph#726541)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datcre#726542)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datcre#726542)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heucre#726543)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heucre#726543)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_origine#726544)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_origine#726544)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_oid#726545)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_oid#726545)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flordo#726546)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flordo#726546)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_idcda#726547)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_idcda#726547)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_fltr#726548)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_fltr#726548)), 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#726441, cr_numdos#726442, cr_nomdic#726443, cr_numdem#726444, cr_numexa#726445, cr_typdoc#726446, cr_prior#726447, cr_nomdcr#726448, cr_taidcr#726449, cr_durdcr#726450, cr_posdcr#726451, cr_nomdos#726452, cr_for_cr#726453, cr_cr#726454, cr_statdic#726455, cr_statsm#726456, cr_statcr#726457, cr_coddic#726458, cr_context#726459, cr_datdic#726460, cr_heudic#726461, cr_heui_d#726462, cr_heui_f#726463, cr_codsec#726464, cr_datsec#726465, cr_heusec#726466, cr_codvcr#726467, cr_datvcr#726468, cr_heuvcr#726469, cr_coddcr#726470, cr_datdcr#726471, cr_heudcr#726472, cr_dat_eff_d#726473, cr_dat_eff_w#726474, cr_coduti#726475, cr_datmaj#726476, cr_codsit#726477, cr_sectra#726478, cr_typcr#726479, cr_codsup#726480, cr_nivvcr#726481, cr_numvcr#726482, cr_nb_cor#726483, cr_datsup#726484, cr_heusup#726485, cr_flarch#726486, cr_staext#726487, cr_flimpr#726488, cr_lockcr#726489, cr_codmcr#726490, cr_datmcr#726491, cr_heumcr#726492, cr_codacc#726493, cr_motpas#726494, cr_libco#726495, cr_subdic#726496, cr_subdir#726497, cr_numprt#726498, cr_sta_env_prt#726499, cr_sta_ret_pro#726500, cr_sta_env_fra#726501, cr_sta_ret_fra#726502, cr_codcli#726503, cr_pri_dic#726504, cr_dat_dic_tra#726505, cr_heu_dic_tra#726506, cr_codfra#726507, cr_secext#726508, cr_statut_ext#726509, cr_simp_job_id#726510, cr_dat_cr_int#726511, cr_heu_cr_int#726512, cr_delai_total#726513, cr_nb_ligne_ext#726514, cr_nb_car_ext#726515, cr_nomext#726516, cr_subext#726517, cr_fltbdi#726518, cr_typdic#726519, cr_sta_env_ack#726520, cr_sta_ret_ack#726521, cr_taille_dic#726522, cr_chksum_dic#726523, cr_datmail#726524, cr_heumail#726525, cr_codmail#726526, cr_stadmp#726527, cr_coddmp#726528, cr_datdmp#726529, cr_heudmp#726530, cr_oiddmp#726531, cr_visdmp#726532, cr_scnpat#726533, cr_datscn#726534, cr_nummcr#726535, cr_numcr_cloud#726536, cr_numdrv#726537, cr_flarch_d#726538, cr_refext#726539, cr_annonce#726540, cr_periph#726541, cr_datcre#726542, cr_heucre#726543, cr_origine#726544, cr_oid#726545, cr_flordo#726546, cr_idcda#726547, cr_fltr#726548]

(7) Union

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

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

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

(11) HashAggregate [codegen id : 2]
Input [1]: [count#728514L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#728288L]
Results [1]: [count(1)#728288L AS COL_4b212f6b-8d93-46ee-ad01-8854a39b4f88#728290L]

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

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

(14) HashAggregate
Input [1]: [count#728514L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#728288L]
Results [1]: [count(1)#728288L AS COL_4b212f6b-8d93-46ee-ad01-8854a39b4f88#728290L]

(15) AdaptiveSparkPlan
Output [1]: [COL_4b212f6b-8d93-46ee-ad01-8854a39b4f88#728290L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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