hdh-spark-job - Details for Query 1479

Submitted Time: 2026/10/23 13:29:42
Duration: 15 s
Succeeded Jobs: 1472 1477

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 2147.0: task 1874)) 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 2147.0: task 1874)) 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 2147.0: task 1874))"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n4.8 s (2.3 s, 2.4 s, 2.4 s (stage 2147.0: task 1874))"; 5 [labelType="html" label="HashAggregate time in aggregation build total (min, med, max (stageId: taskId)) 4.8 s (2.3 s, 2.4 s, 2.4 s (stage 2147.0: task 1874)) 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=40570]

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

WholeStageCodegen (1)

Union

Project

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numcr#760319)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numcr#760319)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdos#760320)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdos#760320)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdic#760321)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdic#760321)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdem#760322)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdem#760322)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numexa#760323)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numexa#760323)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typdoc#760324)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typdoc#760324)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_prior#760325)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_prior#760325)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdcr#760326)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdcr#760326)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_taidcr#760327)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_taidcr#760327)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_durdcr#760328)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_durdcr#760328)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_posdcr#760329)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_posdcr#760329)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdos#760330)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdos#760330)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_for_cr#760331)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_for_cr#760331)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_cr#760332)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_cr#760332)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statdic#760333)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statdic#760333)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statsm#760334)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statsm#760334)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statcr#760335)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statcr#760335)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddic#760336)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddic#760336)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_context#760337)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_context#760337)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdic#760338)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdic#760338)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudic#760339)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudic#760339)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heui_d#760340)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heui_d#760340)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heui_f#760341)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heui_f#760341)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsec#760342)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsec#760342)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datsec#760343)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datsec#760343)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heusec#760344)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heusec#760344)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codvcr#760345)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codvcr#760345)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datvcr#760346)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datvcr#760346)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heuvcr#760347)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heuvcr#760347)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddcr#760348)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddcr#760348)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdcr#760349)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdcr#760349)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudcr#760350)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudcr#760350)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_eff_d#760351)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_eff_d#760351)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_eff_w#760352)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_eff_w#760352)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coduti#760353)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coduti#760353)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmaj#760354)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmaj#760354)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsit#760355)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsit#760355)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sectra#760356)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sectra#760356)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typcr#760357)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typcr#760357)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsup#760358)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsup#760358)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nivvcr#760359)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nivvcr#760359)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numvcr#760360)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numvcr#760360)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_cor#760361)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_cor#760361)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datsup#760362)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datsup#760362)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heusup#760363)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heusup#760363)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flarch#760364)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flarch#760364)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_staext#760365)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_staext#760365)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flimpr#760366)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flimpr#760366)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_lockcr#760367)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_lockcr#760367)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codmcr#760368)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codmcr#760368)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmcr#760369)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmcr#760369)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heumcr#760370)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heumcr#760370)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codacc#760371)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codacc#760371)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_motpas#760372)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_motpas#760372)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_libco#760373)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_libco#760373)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subdic#760374)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subdic#760374)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subdir#760375)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subdir#760375)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numprt#760376)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numprt#760376)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_prt#760377)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_prt#760377)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_pro#760378)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_pro#760378)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_fra#760379)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_fra#760379)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_fra#760380)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_fra#760380)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codcli#760381)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codcli#760381)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_pri_dic#760382)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_pri_dic#760382)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_dic_tra#760383)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_dic_tra#760383)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heu_dic_tra#760384)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heu_dic_tra#760384)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codfra#760385)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codfra#760385)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_secext#760386)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_secext#760386)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statut_ext#760387)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statut_ext#760387)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_simp_job_id#760388)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_simp_job_id#760388)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_cr_int#760389)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_cr_int#760389)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heu_cr_int#760390)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heu_cr_int#760390)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_delai_total#760391)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_delai_total#760391)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_ligne_ext#760392)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_ligne_ext#760392)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_car_ext#760393)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_car_ext#760393)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomext#760394)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomext#760394)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subext#760395)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subext#760395)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_fltbdi#760396)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_fltbdi#760396)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typdic#760397)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typdic#760397)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_ack#760398)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_ack#760398)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_ack#760399)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_ack#760399)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_taille_dic#760400)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_taille_dic#760400)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_chksum_dic#760401)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_chksum_dic#760401)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmail#760402)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmail#760402)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heumail#760403)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heumail#760403)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codmail#760404)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codmail#760404)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_stadmp#760405)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_stadmp#760405)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddmp#760406)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddmp#760406)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdmp#760407)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdmp#760407)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudmp#760408)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudmp#760408)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_oiddmp#760409)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_oiddmp#760409)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_visdmp#760410)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_visdmp#760410)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_scnpat#760411)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_scnpat#760411)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datscn#760412)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datscn#760412)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nummcr#760413)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nummcr#760413)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numcr_cloud#760414)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numcr_cloud#760414)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdrv#760415)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdrv#760415)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flarch_d#760416)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flarch_d#760416)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_refext#760417)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_refext#760417)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_annonce#760418)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_annonce#760418)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_periph#760419)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_periph#760419)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datcre#760420)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datcre#760420)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heucre#760421)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heucre#760421)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_origine#760422)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_origine#760422)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_oid#760423)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_oid#760423)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flordo#760424)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flordo#760424)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_idcda#760425)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_idcda#760425)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_fltr#760426)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_fltr#760426)), 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#760319,cr_numdos#760320,cr_nomdic#760321,cr_numdem#760322,cr_numexa#760323,cr_typdoc#760324,cr_prior#760325,cr_nomdcr#760326,cr_taidcr#760327,cr_durdcr#760328,cr_posdcr#760329,cr_nomdos#760330,cr_for_cr#760331,cr_cr#760332,cr_statdic#760333,cr_statsm#760334,cr_statcr#760335,cr_coddic#760336,cr_context#760337,cr_datdic#760338,cr_heudic#760339,cr_heui_d#760340,cr_heui_f#760341,cr_codsec#760342,... 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#761568)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numcr#761568)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdos#761569)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdos#761569)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdic#761570)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdic#761570)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdem#761571)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdem#761571)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numexa#761572)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numexa#761572)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typdoc#761573)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typdoc#761573)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_prior#761574)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_prior#761574)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdcr#761575)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdcr#761575)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_taidcr#761576)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_taidcr#761576)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_durdcr#761577)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_durdcr#761577)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_posdcr#761578)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_posdcr#761578)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdos#761579)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdos#761579)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_for_cr#761580)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_for_cr#761580)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_cr#761581)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_cr#761581)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statdic#761582)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statdic#761582)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statsm#761583)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statsm#761583)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statcr#761584)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statcr#761584)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddic#761585)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddic#761585)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_context#761586)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_context#761586)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdic#761587)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdic#761587)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudic#761588)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudic#761588)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heui_d#761589)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heui_d#761589)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heui_f#761590)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heui_f#761590)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsec#761591)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsec#761591)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datsec#761592)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datsec#761592)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heusec#761593)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heusec#761593)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codvcr#761594)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codvcr#761594)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datvcr#761595)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datvcr#761595)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heuvcr#761596)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heuvcr#761596)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddcr#761597)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddcr#761597)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdcr#761598)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdcr#761598)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudcr#761599)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudcr#761599)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_eff_d#761600)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_eff_d#761600)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_eff_w#761601)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_eff_w#761601)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coduti#761602)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coduti#761602)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmaj#761603)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmaj#761603)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsit#761604)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsit#761604)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sectra#761605)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sectra#761605)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typcr#761606)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typcr#761606)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsup#761607)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsup#761607)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nivvcr#761608)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nivvcr#761608)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numvcr#761609)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numvcr#761609)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_cor#761610)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_cor#761610)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datsup#761611)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datsup#761611)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heusup#761612)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heusup#761612)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flarch#761613)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flarch#761613)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_staext#761614)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_staext#761614)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flimpr#761615)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flimpr#761615)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_lockcr#761616)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_lockcr#761616)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codmcr#761617)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codmcr#761617)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmcr#761618)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmcr#761618)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heumcr#761619)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heumcr#761619)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codacc#761620)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codacc#761620)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_motpas#761621)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_motpas#761621)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_libco#761622)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_libco#761622)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subdic#761623)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subdic#761623)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subdir#761624)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subdir#761624)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numprt#761625)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numprt#761625)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_prt#761626)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_prt#761626)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_pro#761627)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_pro#761627)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_fra#761628)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_fra#761628)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_fra#761629)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_fra#761629)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codcli#761630)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codcli#761630)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_pri_dic#761631)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_pri_dic#761631)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_dic_tra#761632)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_dic_tra#761632)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heu_dic_tra#761633)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heu_dic_tra#761633)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codfra#761634)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codfra#761634)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_secext#761635)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_secext#761635)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statut_ext#761636)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statut_ext#761636)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_simp_job_id#761637)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_simp_job_id#761637)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_cr_int#761638)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_cr_int#761638)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heu_cr_int#761639)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heu_cr_int#761639)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_delai_total#761640)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_delai_total#761640)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_ligne_ext#761641)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_ligne_ext#761641)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_car_ext#761642)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_car_ext#761642)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomext#761643)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomext#761643)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subext#761644)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subext#761644)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_fltbdi#761645)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_fltbdi#761645)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typdic#761646)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typdic#761646)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_ack#761647)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_ack#761647)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_ack#761648)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_ack#761648)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_taille_dic#761649)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_taille_dic#761649)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_chksum_dic#761650)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_chksum_dic#761650)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmail#761651)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmail#761651)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heumail#761652)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heumail#761652)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codmail#761653)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codmail#761653)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_stadmp#761654)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_stadmp#761654)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddmp#761655)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddmp#761655)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdmp#761656)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdmp#761656)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudmp#761657)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudmp#761657)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_oiddmp#761658)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_oiddmp#761658)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_visdmp#761659)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_visdmp#761659)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_scnpat#761660)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_scnpat#761660)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datscn#761661)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datscn#761661)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nummcr#761662)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nummcr#761662)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numcr_cloud#761663)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numcr_cloud#761663)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdrv#761664)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdrv#761664)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flarch_d#761665)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flarch_d#761665)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_refext#761666)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_refext#761666)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_annonce#761667)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_annonce#761667)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_periph#761668)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_periph#761668)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datcre#761669)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datcre#761669)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heucre#761670)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heucre#761670)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_origine#761671)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_origine#761671)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_oid#761672)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_oid#761672)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flordo#761673)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flordo#761673)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_idcda#761674)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_idcda#761674)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_fltr#761675)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_fltr#761675)), 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#761568,cr_numdos#761569,cr_nomdic#761570,cr_numdem#761571,cr_numexa#761572,cr_typdoc#761573,cr_prior#761574,cr_nomdcr#761575,cr_taidcr#761576,cr_durdcr#761577,cr_posdcr#761578,cr_nomdos#761579,cr_for_cr#761580,cr_cr#761581,cr_statdic#761582,cr_statsm#761583,cr_statcr#761584,cr_coddic#761585,cr_context#761586,cr_datdic#761587,cr_heudic#761588,cr_heui_d#761589,cr_heui_f#761590,cr_codsec#761591,... 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#760319, cr_numdos#760320, cr_nomdic#760321, cr_numdem#760322, cr_numexa#760323, cr_typdoc#760324, cr_prior#760325, cr_nomdcr#760326, cr_taidcr#760327, cr_durdcr#760328, cr_posdcr#760329, cr_nomdos#760330, cr_for_cr#760331, cr_cr#760332, cr_statdic#760333, cr_statsm#760334, cr_statcr#760335, cr_coddic#760336, cr_context#760337, cr_datdic#760338, cr_heudic#760339, cr_heui_d#760340, cr_heui_f#760341, cr_codsec#760342, cr_datsec#760343, cr_heusec#760344, cr_codvcr#760345, cr_datvcr#760346, cr_heuvcr#760347, cr_coddcr#760348, cr_datdcr#760349, cr_heudcr#760350, cr_dat_eff_d#760351, cr_dat_eff_w#760352, cr_coduti#760353, cr_datmaj#760354, cr_codsit#760355, cr_sectra#760356, cr_typcr#760357, cr_codsup#760358, cr_nivvcr#760359, cr_numvcr#760360, cr_nb_cor#760361, cr_datsup#760362, cr_heusup#760363, cr_flarch#760364, cr_staext#760365, cr_flimpr#760366, cr_lockcr#760367, cr_codmcr#760368, cr_datmcr#760369, cr_heumcr#760370, cr_codacc#760371, cr_motpas#760372, cr_libco#760373, cr_subdic#760374, cr_subdir#760375, cr_numprt#760376, cr_sta_env_prt#760377, cr_sta_ret_pro#760378, cr_sta_env_fra#760379, cr_sta_ret_fra#760380, cr_codcli#760381, cr_pri_dic#760382, cr_dat_dic_tra#760383, cr_heu_dic_tra#760384, cr_codfra#760385, cr_secext#760386, cr_statut_ext#760387, cr_simp_job_id#760388, cr_dat_cr_int#760389, cr_heu_cr_int#760390, cr_delai_total#760391, cr_nb_ligne_ext#760392, cr_nb_car_ext#760393, cr_nomext#760394, cr_subext#760395, cr_fltbdi#760396, cr_typdic#760397, cr_sta_env_ack#760398, cr_sta_ret_ack#760399, cr_taille_dic#760400, cr_chksum_dic#760401, cr_datmail#760402, cr_heumail#760403, cr_codmail#760404, cr_stadmp#760405, cr_coddmp#760406, cr_datdmp#760407, cr_heudmp#760408, cr_oiddmp#760409, cr_visdmp#760410, cr_scnpat#760411, cr_datscn#760412, cr_nummcr#760413, cr_numcr_cloud#760414, cr_numdrv#760415, cr_flarch_d#760416, cr_refext#760417, cr_annonce#760418, cr_periph#760419, cr_datcre#760420, cr_heucre#760421, cr_origine#760422, cr_oid#760423, cr_flordo#760424, cr_idcda#760425, cr_fltr#760426]
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#760319, cr_numdos#760320, cr_nomdic#760321, cr_numdem#760322, cr_numexa#760323, cr_typdoc#760324, cr_prior#760325, cr_nomdcr#760326, cr_taidcr#760327, cr_durdcr#760328, cr_posdcr#760329, cr_nomdos#760330, cr_for_cr#760331, cr_cr#760332, cr_statdic#760333, cr_statsm#760334, cr_statcr#760335, cr_coddic#760336, cr_context#760337, cr_datdic#760338, cr_heudic#760339, cr_heui_d#760340, cr_heui_f#760341, cr_codsec#760342, cr_datsec#760343, cr_heusec#760344, cr_codvcr#760345, cr_datvcr#760346, cr_heuvcr#760347, cr_coddcr#760348, cr_datdcr#760349, cr_heudcr#760350, cr_dat_eff_d#760351, cr_dat_eff_w#760352, cr_coduti#760353, cr_datmaj#760354, cr_codsit#760355, cr_sectra#760356, cr_typcr#760357, cr_codsup#760358, cr_nivvcr#760359, cr_numvcr#760360, cr_nb_cor#760361, cr_datsup#760362, cr_heusup#760363, cr_flarch#760364, cr_staext#760365, cr_flimpr#760366, cr_lockcr#760367, cr_codmcr#760368, cr_datmcr#760369, cr_heumcr#760370, cr_codacc#760371, cr_motpas#760372, cr_libco#760373, cr_subdic#760374, cr_subdir#760375, cr_numprt#760376, cr_sta_env_prt#760377, cr_sta_ret_pro#760378, cr_sta_env_fra#760379, cr_sta_ret_fra#760380, cr_codcli#760381, cr_pri_dic#760382, cr_dat_dic_tra#760383, cr_heu_dic_tra#760384, cr_codfra#760385, cr_secext#760386, cr_statut_ext#760387, cr_simp_job_id#760388, cr_dat_cr_int#760389, cr_heu_cr_int#760390, cr_delai_total#760391, cr_nb_ligne_ext#760392, cr_nb_car_ext#760393, cr_nomext#760394, cr_subext#760395, cr_fltbdi#760396, cr_typdic#760397, cr_sta_env_ack#760398, cr_sta_ret_ack#760399, cr_taille_dic#760400, cr_chksum_dic#760401, cr_datmail#760402, cr_heumail#760403, cr_codmail#760404, cr_stadmp#760405, cr_coddmp#760406, cr_datdmp#760407, cr_heudmp#760408, cr_oiddmp#760409, cr_visdmp#760410, cr_scnpat#760411, cr_datscn#760412, cr_nummcr#760413, cr_numcr_cloud#760414, cr_numdrv#760415, cr_flarch_d#760416, cr_refext#760417, cr_annonce#760418, cr_periph#760419, cr_datcre#760420, cr_heucre#760421, cr_origine#760422, cr_oid#760423, cr_flordo#760424, cr_idcda#760425, cr_fltr#760426]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numcr#760319)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numcr#760319)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdos#760320)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdos#760320)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdic#760321)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdic#760321)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdem#760322)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdem#760322)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numexa#760323)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numexa#760323)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typdoc#760324)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typdoc#760324)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_prior#760325)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_prior#760325)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdcr#760326)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdcr#760326)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_taidcr#760327)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_taidcr#760327)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_durdcr#760328)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_durdcr#760328)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_posdcr#760329)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_posdcr#760329)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdos#760330)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdos#760330)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_for_cr#760331)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_for_cr#760331)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_cr#760332)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_cr#760332)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statdic#760333)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statdic#760333)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statsm#760334)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statsm#760334)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statcr#760335)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statcr#760335)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddic#760336)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddic#760336)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_context#760337)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_context#760337)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdic#760338)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdic#760338)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudic#760339)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudic#760339)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heui_d#760340)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heui_d#760340)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heui_f#760341)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heui_f#760341)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsec#760342)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsec#760342)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datsec#760343)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datsec#760343)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heusec#760344)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heusec#760344)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codvcr#760345)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codvcr#760345)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datvcr#760346)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datvcr#760346)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heuvcr#760347)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heuvcr#760347)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddcr#760348)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddcr#760348)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdcr#760349)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdcr#760349)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudcr#760350)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudcr#760350)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_eff_d#760351)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_eff_d#760351)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_eff_w#760352)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_eff_w#760352)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coduti#760353)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coduti#760353)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmaj#760354)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmaj#760354)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsit#760355)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsit#760355)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sectra#760356)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sectra#760356)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typcr#760357)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typcr#760357)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsup#760358)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsup#760358)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nivvcr#760359)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nivvcr#760359)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numvcr#760360)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numvcr#760360)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_cor#760361)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_cor#760361)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datsup#760362)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datsup#760362)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heusup#760363)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heusup#760363)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flarch#760364)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flarch#760364)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_staext#760365)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_staext#760365)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flimpr#760366)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flimpr#760366)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_lockcr#760367)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_lockcr#760367)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codmcr#760368)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codmcr#760368)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmcr#760369)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmcr#760369)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heumcr#760370)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heumcr#760370)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codacc#760371)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codacc#760371)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_motpas#760372)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_motpas#760372)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_libco#760373)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_libco#760373)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subdic#760374)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subdic#760374)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subdir#760375)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subdir#760375)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numprt#760376)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numprt#760376)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_prt#760377)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_prt#760377)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_pro#760378)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_pro#760378)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_fra#760379)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_fra#760379)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_fra#760380)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_fra#760380)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codcli#760381)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codcli#760381)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_pri_dic#760382)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_pri_dic#760382)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_dic_tra#760383)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_dic_tra#760383)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heu_dic_tra#760384)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heu_dic_tra#760384)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codfra#760385)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codfra#760385)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_secext#760386)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_secext#760386)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statut_ext#760387)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statut_ext#760387)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_simp_job_id#760388)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_simp_job_id#760388)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_cr_int#760389)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_cr_int#760389)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heu_cr_int#760390)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heu_cr_int#760390)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_delai_total#760391)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_delai_total#760391)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_ligne_ext#760392)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_ligne_ext#760392)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_car_ext#760393)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_car_ext#760393)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomext#760394)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomext#760394)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subext#760395)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subext#760395)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_fltbdi#760396)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_fltbdi#760396)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typdic#760397)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typdic#760397)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_ack#760398)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_ack#760398)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_ack#760399)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_ack#760399)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_taille_dic#760400)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_taille_dic#760400)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_chksum_dic#760401)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_chksum_dic#760401)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmail#760402)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmail#760402)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heumail#760403)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heumail#760403)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codmail#760404)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codmail#760404)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_stadmp#760405)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_stadmp#760405)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddmp#760406)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddmp#760406)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdmp#760407)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdmp#760407)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudmp#760408)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudmp#760408)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_oiddmp#760409)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_oiddmp#760409)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_visdmp#760410)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_visdmp#760410)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_scnpat#760411)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_scnpat#760411)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datscn#760412)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datscn#760412)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nummcr#760413)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nummcr#760413)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numcr_cloud#760414)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numcr_cloud#760414)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdrv#760415)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdrv#760415)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flarch_d#760416)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flarch_d#760416)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_refext#760417)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_refext#760417)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_annonce#760418)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_annonce#760418)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_periph#760419)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_periph#760419)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datcre#760420)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datcre#760420)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heucre#760421)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heucre#760421)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_origine#760422)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_origine#760422)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_oid#760423)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_oid#760423)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flordo#760424)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flordo#760424)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_idcda#760425)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_idcda#760425)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_fltr#760426)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_fltr#760426)), 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#760319, cr_numdos#760320, cr_nomdic#760321, cr_numdem#760322, cr_numexa#760323, cr_typdoc#760324, cr_prior#760325, cr_nomdcr#760326, cr_taidcr#760327, cr_durdcr#760328, cr_posdcr#760329, cr_nomdos#760330, cr_for_cr#760331, cr_cr#760332, cr_statdic#760333, cr_statsm#760334, cr_statcr#760335, cr_coddic#760336, cr_context#760337, cr_datdic#760338, cr_heudic#760339, cr_heui_d#760340, cr_heui_f#760341, cr_codsec#760342, cr_datsec#760343, cr_heusec#760344, cr_codvcr#760345, cr_datvcr#760346, cr_heuvcr#760347, cr_coddcr#760348, cr_datdcr#760349, cr_heudcr#760350, cr_dat_eff_d#760351, cr_dat_eff_w#760352, cr_coduti#760353, cr_datmaj#760354, cr_codsit#760355, cr_sectra#760356, cr_typcr#760357, cr_codsup#760358, cr_nivvcr#760359, cr_numvcr#760360, cr_nb_cor#760361, cr_datsup#760362, cr_heusup#760363, cr_flarch#760364, cr_staext#760365, cr_flimpr#760366, cr_lockcr#760367, cr_codmcr#760368, cr_datmcr#760369, cr_heumcr#760370, cr_codacc#760371, cr_motpas#760372, cr_libco#760373, cr_subdic#760374, cr_subdir#760375, cr_numprt#760376, cr_sta_env_prt#760377, cr_sta_ret_pro#760378, cr_sta_env_fra#760379, cr_sta_ret_fra#760380, cr_codcli#760381, cr_pri_dic#760382, cr_dat_dic_tra#760383, cr_heu_dic_tra#760384, cr_codfra#760385, cr_secext#760386, cr_statut_ext#760387, cr_simp_job_id#760388, cr_dat_cr_int#760389, cr_heu_cr_int#760390, cr_delai_total#760391, cr_nb_ligne_ext#760392, cr_nb_car_ext#760393, cr_nomext#760394, cr_subext#760395, cr_fltbdi#760396, cr_typdic#760397, cr_sta_env_ack#760398, cr_sta_ret_ack#760399, cr_taille_dic#760400, cr_chksum_dic#760401, cr_datmail#760402, cr_heumail#760403, cr_codmail#760404, cr_stadmp#760405, cr_coddmp#760406, cr_datdmp#760407, cr_heudmp#760408, cr_oiddmp#760409, cr_visdmp#760410, cr_scnpat#760411, cr_datscn#760412, cr_nummcr#760413, cr_numcr_cloud#760414, cr_numdrv#760415, cr_flarch_d#760416, cr_refext#760417, cr_annonce#760418, cr_periph#760419, cr_datcre#760420, cr_heucre#760421, cr_origine#760422, cr_oid#760423, cr_flordo#760424, cr_idcda#760425, cr_fltr#760426]

(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#761568, cr_numdos#761569, cr_nomdic#761570, cr_numdem#761571, cr_numexa#761572, cr_typdoc#761573, cr_prior#761574, cr_nomdcr#761575, cr_taidcr#761576, cr_durdcr#761577, cr_posdcr#761578, cr_nomdos#761579, cr_for_cr#761580, cr_cr#761581, cr_statdic#761582, cr_statsm#761583, cr_statcr#761584, cr_coddic#761585, cr_context#761586, cr_datdic#761587, cr_heudic#761588, cr_heui_d#761589, cr_heui_f#761590, cr_codsec#761591, cr_datsec#761592, cr_heusec#761593, cr_codvcr#761594, cr_datvcr#761595, cr_heuvcr#761596, cr_coddcr#761597, cr_datdcr#761598, cr_heudcr#761599, cr_dat_eff_d#761600, cr_dat_eff_w#761601, cr_coduti#761602, cr_datmaj#761603, cr_codsit#761604, cr_sectra#761605, cr_typcr#761606, cr_codsup#761607, cr_nivvcr#761608, cr_numvcr#761609, cr_nb_cor#761610, cr_datsup#761611, cr_heusup#761612, cr_flarch#761613, cr_staext#761614, cr_flimpr#761615, cr_lockcr#761616, cr_codmcr#761617, cr_datmcr#761618, cr_heumcr#761619, cr_codacc#761620, cr_motpas#761621, cr_libco#761622, cr_subdic#761623, cr_subdir#761624, cr_numprt#761625, cr_sta_env_prt#761626, cr_sta_ret_pro#761627, cr_sta_env_fra#761628, cr_sta_ret_fra#761629, cr_codcli#761630, cr_pri_dic#761631, cr_dat_dic_tra#761632, cr_heu_dic_tra#761633, cr_codfra#761634, cr_secext#761635, cr_statut_ext#761636, cr_simp_job_id#761637, cr_dat_cr_int#761638, cr_heu_cr_int#761639, cr_delai_total#761640, cr_nb_ligne_ext#761641, cr_nb_car_ext#761642, cr_nomext#761643, cr_subext#761644, cr_fltbdi#761645, cr_typdic#761646, cr_sta_env_ack#761647, cr_sta_ret_ack#761648, cr_taille_dic#761649, cr_chksum_dic#761650, cr_datmail#761651, cr_heumail#761652, cr_codmail#761653, cr_stadmp#761654, cr_coddmp#761655, cr_datdmp#761656, cr_heudmp#761657, cr_oiddmp#761658, cr_visdmp#761659, cr_scnpat#761660, cr_datscn#761661, cr_nummcr#761662, cr_numcr_cloud#761663, cr_numdrv#761664, cr_flarch_d#761665, cr_refext#761666, cr_annonce#761667, cr_periph#761668, cr_datcre#761669, cr_heucre#761670, cr_origine#761671, cr_oid#761672, cr_flordo#761673, cr_idcda#761674, cr_fltr#761675]
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#761568, cr_numdos#761569, cr_nomdic#761570, cr_numdem#761571, cr_numexa#761572, cr_typdoc#761573, cr_prior#761574, cr_nomdcr#761575, cr_taidcr#761576, cr_durdcr#761577, cr_posdcr#761578, cr_nomdos#761579, cr_for_cr#761580, cr_cr#761581, cr_statdic#761582, cr_statsm#761583, cr_statcr#761584, cr_coddic#761585, cr_context#761586, cr_datdic#761587, cr_heudic#761588, cr_heui_d#761589, cr_heui_f#761590, cr_codsec#761591, cr_datsec#761592, cr_heusec#761593, cr_codvcr#761594, cr_datvcr#761595, cr_heuvcr#761596, cr_coddcr#761597, cr_datdcr#761598, cr_heudcr#761599, cr_dat_eff_d#761600, cr_dat_eff_w#761601, cr_coduti#761602, cr_datmaj#761603, cr_codsit#761604, cr_sectra#761605, cr_typcr#761606, cr_codsup#761607, cr_nivvcr#761608, cr_numvcr#761609, cr_nb_cor#761610, cr_datsup#761611, cr_heusup#761612, cr_flarch#761613, cr_staext#761614, cr_flimpr#761615, cr_lockcr#761616, cr_codmcr#761617, cr_datmcr#761618, cr_heumcr#761619, cr_codacc#761620, cr_motpas#761621, cr_libco#761622, cr_subdic#761623, cr_subdir#761624, cr_numprt#761625, cr_sta_env_prt#761626, cr_sta_ret_pro#761627, cr_sta_env_fra#761628, cr_sta_ret_fra#761629, cr_codcli#761630, cr_pri_dic#761631, cr_dat_dic_tra#761632, cr_heu_dic_tra#761633, cr_codfra#761634, cr_secext#761635, cr_statut_ext#761636, cr_simp_job_id#761637, cr_dat_cr_int#761638, cr_heu_cr_int#761639, cr_delai_total#761640, cr_nb_ligne_ext#761641, cr_nb_car_ext#761642, cr_nomext#761643, cr_subext#761644, cr_fltbdi#761645, cr_typdic#761646, cr_sta_env_ack#761647, cr_sta_ret_ack#761648, cr_taille_dic#761649, cr_chksum_dic#761650, cr_datmail#761651, cr_heumail#761652, cr_codmail#761653, cr_stadmp#761654, cr_coddmp#761655, cr_datdmp#761656, cr_heudmp#761657, cr_oiddmp#761658, cr_visdmp#761659, cr_scnpat#761660, cr_datscn#761661, cr_nummcr#761662, cr_numcr_cloud#761663, cr_numdrv#761664, cr_flarch_d#761665, cr_refext#761666, cr_annonce#761667, cr_periph#761668, cr_datcre#761669, cr_heucre#761670, cr_origine#761671, cr_oid#761672, cr_flordo#761673, cr_idcda#761674, cr_fltr#761675]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numcr#761568)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numcr#761568)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdos#761569)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdos#761569)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdic#761570)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdic#761570)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdem#761571)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdem#761571)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numexa#761572)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numexa#761572)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typdoc#761573)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typdoc#761573)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_prior#761574)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_prior#761574)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdcr#761575)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdcr#761575)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_taidcr#761576)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_taidcr#761576)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_durdcr#761577)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_durdcr#761577)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_posdcr#761578)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_posdcr#761578)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdos#761579)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdos#761579)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_for_cr#761580)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_for_cr#761580)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_cr#761581)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_cr#761581)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statdic#761582)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statdic#761582)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statsm#761583)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statsm#761583)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statcr#761584)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statcr#761584)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddic#761585)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddic#761585)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_context#761586)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_context#761586)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdic#761587)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdic#761587)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudic#761588)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudic#761588)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heui_d#761589)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heui_d#761589)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heui_f#761590)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heui_f#761590)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsec#761591)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsec#761591)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datsec#761592)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datsec#761592)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heusec#761593)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heusec#761593)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codvcr#761594)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codvcr#761594)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datvcr#761595)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datvcr#761595)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heuvcr#761596)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heuvcr#761596)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddcr#761597)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddcr#761597)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdcr#761598)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdcr#761598)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudcr#761599)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudcr#761599)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_eff_d#761600)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_eff_d#761600)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_eff_w#761601)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_eff_w#761601)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coduti#761602)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coduti#761602)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmaj#761603)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmaj#761603)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsit#761604)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsit#761604)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sectra#761605)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sectra#761605)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typcr#761606)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typcr#761606)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsup#761607)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsup#761607)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nivvcr#761608)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nivvcr#761608)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numvcr#761609)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numvcr#761609)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_cor#761610)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_cor#761610)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datsup#761611)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datsup#761611)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heusup#761612)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heusup#761612)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flarch#761613)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flarch#761613)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_staext#761614)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_staext#761614)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flimpr#761615)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flimpr#761615)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_lockcr#761616)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_lockcr#761616)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codmcr#761617)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codmcr#761617)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmcr#761618)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmcr#761618)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heumcr#761619)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heumcr#761619)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codacc#761620)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codacc#761620)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_motpas#761621)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_motpas#761621)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_libco#761622)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_libco#761622)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subdic#761623)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subdic#761623)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subdir#761624)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subdir#761624)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numprt#761625)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numprt#761625)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_prt#761626)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_prt#761626)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_pro#761627)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_pro#761627)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_fra#761628)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_fra#761628)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_fra#761629)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_fra#761629)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codcli#761630)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codcli#761630)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_pri_dic#761631)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_pri_dic#761631)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_dic_tra#761632)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_dic_tra#761632)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heu_dic_tra#761633)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heu_dic_tra#761633)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codfra#761634)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codfra#761634)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_secext#761635)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_secext#761635)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statut_ext#761636)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statut_ext#761636)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_simp_job_id#761637)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_simp_job_id#761637)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_cr_int#761638)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_cr_int#761638)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heu_cr_int#761639)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heu_cr_int#761639)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_delai_total#761640)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_delai_total#761640)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_ligne_ext#761641)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_ligne_ext#761641)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_car_ext#761642)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_car_ext#761642)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomext#761643)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomext#761643)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subext#761644)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subext#761644)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_fltbdi#761645)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_fltbdi#761645)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typdic#761646)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typdic#761646)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_ack#761647)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_ack#761647)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_ack#761648)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_ack#761648)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_taille_dic#761649)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_taille_dic#761649)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_chksum_dic#761650)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_chksum_dic#761650)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmail#761651)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmail#761651)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heumail#761652)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heumail#761652)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codmail#761653)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codmail#761653)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_stadmp#761654)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_stadmp#761654)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddmp#761655)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddmp#761655)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdmp#761656)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdmp#761656)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudmp#761657)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudmp#761657)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_oiddmp#761658)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_oiddmp#761658)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_visdmp#761659)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_visdmp#761659)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_scnpat#761660)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_scnpat#761660)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datscn#761661)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datscn#761661)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nummcr#761662)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nummcr#761662)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numcr_cloud#761663)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numcr_cloud#761663)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdrv#761664)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdrv#761664)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flarch_d#761665)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flarch_d#761665)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_refext#761666)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_refext#761666)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_annonce#761667)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_annonce#761667)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_periph#761668)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_periph#761668)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datcre#761669)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datcre#761669)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heucre#761670)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heucre#761670)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_origine#761671)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_origine#761671)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_oid#761672)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_oid#761672)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flordo#761673)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flordo#761673)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_idcda#761674)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_idcda#761674)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_fltr#761675)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_fltr#761675)), 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#761568, cr_numdos#761569, cr_nomdic#761570, cr_numdem#761571, cr_numexa#761572, cr_typdoc#761573, cr_prior#761574, cr_nomdcr#761575, cr_taidcr#761576, cr_durdcr#761577, cr_posdcr#761578, cr_nomdos#761579, cr_for_cr#761580, cr_cr#761581, cr_statdic#761582, cr_statsm#761583, cr_statcr#761584, cr_coddic#761585, cr_context#761586, cr_datdic#761587, cr_heudic#761588, cr_heui_d#761589, cr_heui_f#761590, cr_codsec#761591, cr_datsec#761592, cr_heusec#761593, cr_codvcr#761594, cr_datvcr#761595, cr_heuvcr#761596, cr_coddcr#761597, cr_datdcr#761598, cr_heudcr#761599, cr_dat_eff_d#761600, cr_dat_eff_w#761601, cr_coduti#761602, cr_datmaj#761603, cr_codsit#761604, cr_sectra#761605, cr_typcr#761606, cr_codsup#761607, cr_nivvcr#761608, cr_numvcr#761609, cr_nb_cor#761610, cr_datsup#761611, cr_heusup#761612, cr_flarch#761613, cr_staext#761614, cr_flimpr#761615, cr_lockcr#761616, cr_codmcr#761617, cr_datmcr#761618, cr_heumcr#761619, cr_codacc#761620, cr_motpas#761621, cr_libco#761622, cr_subdic#761623, cr_subdir#761624, cr_numprt#761625, cr_sta_env_prt#761626, cr_sta_ret_pro#761627, cr_sta_env_fra#761628, cr_sta_ret_fra#761629, cr_codcli#761630, cr_pri_dic#761631, cr_dat_dic_tra#761632, cr_heu_dic_tra#761633, cr_codfra#761634, cr_secext#761635, cr_statut_ext#761636, cr_simp_job_id#761637, cr_dat_cr_int#761638, cr_heu_cr_int#761639, cr_delai_total#761640, cr_nb_ligne_ext#761641, cr_nb_car_ext#761642, cr_nomext#761643, cr_subext#761644, cr_fltbdi#761645, cr_typdic#761646, cr_sta_env_ack#761647, cr_sta_ret_ack#761648, cr_taille_dic#761649, cr_chksum_dic#761650, cr_datmail#761651, cr_heumail#761652, cr_codmail#761653, cr_stadmp#761654, cr_coddmp#761655, cr_datdmp#761656, cr_heudmp#761657, cr_oiddmp#761658, cr_visdmp#761659, cr_scnpat#761660, cr_datscn#761661, cr_nummcr#761662, cr_numcr_cloud#761663, cr_numdrv#761664, cr_flarch_d#761665, cr_refext#761666, cr_annonce#761667, cr_periph#761668, cr_datcre#761669, cr_heucre#761670, cr_origine#761671, cr_oid#761672, cr_flordo#761673, cr_idcda#761674, cr_fltr#761675]

(7) Union

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

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

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

(11) HashAggregate [codegen id : 2]
Input [1]: [count#767565L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#766232L]
Results [1]: [count(1)#766232L AS COL_94098eed-e5f6-4f7b-8d4c-2a3dcba2a09b#766234L]

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

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

(14) HashAggregate
Input [1]: [count#767565L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#766232L]
Results [1]: [count(1)#766232L AS COL_94098eed-e5f6-4f7b-8d4c-2a3dcba2a09b#766234L]

(15) AdaptiveSparkPlan
Output [1]: [COL_94098eed-e5f6-4f7b-8d4c-2a3dcba2a09b#766234L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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