hdh-spark-job - Details for Query 1486

Submitted Time: 2026/10/23 13:32:17
Duration: 6 s
Succeeded Jobs: 1484 1486

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

digraph G { 0 [labelType="html" label=" CollectLimit "]; 1 [labelType="html" label=" Union "]; 2 [labelType="html" label=" LocalLimit "]; 3 [labelType="html" label=" Project "]; 4 [labelType="html" label="Filter number of output rows: 456"]; 5 [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"]; 6 [labelType="html" label=" LocalLimit "]; 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 \"xplore2\".\"h_cr\") as x) [numPartitions=1] number of output rows: 17,658"]; 1->0; 2->1; 3->2; 4->3; 5->4; 6->1; 7->6; 8->7; 9->8; }

CollectLimit 1500

Union

LocalLimit 1500

Project [cr_numcr#777784 AS COL_A5FD2FFB_EA2D_41C1_B705_A25C6D05B881#780388, cr_numdos#777785 AS COL_64D04F29_71AD_4640_AE57_436271A40AAD#780389, cr_nomdic#777786 AS COL_07C23FC6_64AF_4416_A9DA_3B743B210524#780390, cr_numdem#777787 AS COL_2FC30DFB_98B9_4BE0_B7DC_9F13599A65BA#780391, cr_numexa#777788 AS COL_A04C8A18_E8B3_4BF7_8A7A_1EDA5C5F9DF0#780392, cr_typdoc#777789 AS COL_299D9BA0_8FA2_42EA_8F2D_D78E8CBFD81B#780393, cr_prior#777790 AS COL_5A2C34D4_7E98_4346_8C97_158E6F48FE49#780394, cr_nomdcr#777791 AS COL_7282BF09_129C_40F9_8EE4_EEC60F93AFAE#780395, cr_taidcr#777792 AS COL_8A6EB039_CA89_4B16_8197_682903EF7C1C#780396, cr_durdcr#777793 AS COL_C9DE7F48_376F_41F6_97A8_CD5FB8FA9B58#780397, cr_posdcr#777794 AS COL_D8A27729_C788_4130_A480_984B888D85D8#780398, cr_nomdos#777795 AS COL_6192AFD2_0418_40A2_9842_897148E1D9BC#780399, cr_for_cr#777796 AS COL_74C447AE_C67B_4743_B5A4_E214C520D341#780400, cr_cr#777797 AS COL_AFF38E06_FEE0_45CA_B340_F7E760AB1936#780401, cr_statdic#777798 AS COL_5FCDAEB6_03F2_4001_80EE_0354905769B3#780402, cr_statsm#777799 AS COL_A92BBADE_4785_479D_BD34_7EB44808C644#780403, cr_statcr#777800 AS COL_73339033_5C81_431B_930C_0965557C512B#780404, cr_coddic#777801 AS COL_86007AE7_37F7_48B3_A21D_A524E3A64B02#780405, cr_context#777802 AS COL_8DA45796_0796_4CB5_ADB4_A31D1EDAA108#780406, cr_datdic#777803 AS COL_30606282_BB39_4DFE_98AA_AF17AB383066#780407, cr_heudic#777804 AS COL_922AF799_656F_43C0_B28E_F0FF0CC804EE#780408, cr_heui_d#777805 AS COL_A76288E8_5FC6_470E_8A0A_C1960DE77146#780409, cr_heui_f#777806 AS COL_55380C47_11F0_4716_B1D5_AB1ED3C6CB4B#780410, cr_codsec#777807 AS COL_405ACAA7_292F_4054_890E_4403B60A6036#780411, ... 85 more fields]

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numcr#777784)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numcr#777784)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdos#777785)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdos#777785)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdic#777786)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdic#777786)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdem#777787)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdem#777787)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numexa#777788)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numexa#777788)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typdoc#777789)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typdoc#777789)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_prior#777790)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_prior#777790)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdcr#777791)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdcr#777791)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_taidcr#777792)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_taidcr#777792)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_durdcr#777793)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_durdcr#777793)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_posdcr#777794)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_posdcr#777794)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdos#777795)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdos#777795)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_for_cr#777796)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_for_cr#777796)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_cr#777797)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_cr#777797)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statdic#777798)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statdic#777798)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statsm#777799)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statsm#777799)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statcr#777800)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statcr#777800)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddic#777801)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddic#777801)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_context#777802)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_context#777802)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdic#777803)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdic#777803)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudic#777804)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudic#777804)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heui_d#777805)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heui_d#777805)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heui_f#777806)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heui_f#777806)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsec#777807)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsec#777807)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datsec#777808)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datsec#777808)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heusec#777809)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heusec#777809)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codvcr#777810)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codvcr#777810)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datvcr#777811)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datvcr#777811)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heuvcr#777812)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heuvcr#777812)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddcr#777813)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddcr#777813)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdcr#777814)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdcr#777814)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudcr#777815)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudcr#777815)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_eff_d#777816)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_eff_d#777816)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_eff_w#777817)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_eff_w#777817)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coduti#777818)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coduti#777818)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmaj#777819)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmaj#777819)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsit#777820)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsit#777820)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sectra#777821)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sectra#777821)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typcr#777822)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typcr#777822)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsup#777823)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsup#777823)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nivvcr#777824)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nivvcr#777824)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numvcr#777825)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numvcr#777825)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_cor#777826)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_cor#777826)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datsup#777827)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datsup#777827)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heusup#777828)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heusup#777828)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flarch#777829)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flarch#777829)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_staext#777830)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_staext#777830)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flimpr#777831)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flimpr#777831)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_lockcr#777832)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_lockcr#777832)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codmcr#777833)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codmcr#777833)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmcr#777834)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmcr#777834)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heumcr#777835)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heumcr#777835)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codacc#777836)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codacc#777836)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_motpas#777837)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_motpas#777837)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_libco#777838)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_libco#777838)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subdic#777839)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subdic#777839)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subdir#777840)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subdir#777840)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numprt#777841)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numprt#777841)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_prt#777842)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_prt#777842)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_pro#777843)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_pro#777843)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_fra#777844)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_fra#777844)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_fra#777845)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_fra#777845)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codcli#777846)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codcli#777846)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_pri_dic#777847)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_pri_dic#777847)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_dic_tra#777848)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_dic_tra#777848)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heu_dic_tra#777849)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heu_dic_tra#777849)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codfra#777850)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codfra#777850)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_secext#777851)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_secext#777851)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statut_ext#777852)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statut_ext#777852)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_simp_job_id#777853)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_simp_job_id#777853)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_cr_int#777854)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_cr_int#777854)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heu_cr_int#777855)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heu_cr_int#777855)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_delai_total#777856)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_delai_total#777856)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_ligne_ext#777857)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_ligne_ext#777857)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_car_ext#777858)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_car_ext#777858)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomext#777859)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomext#777859)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subext#777860)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subext#777860)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_fltbdi#777861)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_fltbdi#777861)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typdic#777862)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typdic#777862)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_ack#777863)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_ack#777863)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_ack#777864)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_ack#777864)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_taille_dic#777865)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_taille_dic#777865)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_chksum_dic#777866)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_chksum_dic#777866)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmail#777867)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmail#777867)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heumail#777868)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heumail#777868)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codmail#777869)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codmail#777869)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_stadmp#777870)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_stadmp#777870)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddmp#777871)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddmp#777871)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdmp#777872)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdmp#777872)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudmp#777873)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudmp#777873)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_oiddmp#777874)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_oiddmp#777874)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_visdmp#777875)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_visdmp#777875)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_scnpat#777876)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_scnpat#777876)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datscn#777877)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datscn#777877)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nummcr#777878)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nummcr#777878)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numcr_cloud#777879)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numcr_cloud#777879)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdrv#777880)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdrv#777880)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flarch_d#777881)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flarch_d#777881)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_refext#777882)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_refext#777882)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_annonce#777883)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_annonce#777883)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_periph#777884)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_periph#777884)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datcre#777885)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datcre#777885)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heucre#777886)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heucre#777886)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_origine#777887)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_origine#777887)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_oid#777888)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_oid#777888)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flordo#777889)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flordo#777889)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_idcda#777890)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_idcda#777890)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_fltr#777891)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_fltr#777891)), 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#777784,cr_numdos#777785,cr_nomdic#777786,cr_numdem#777787,cr_numexa#777788,cr_typdoc#777789,cr_prior#777790,cr_nomdcr#777791,cr_taidcr#777792,cr_durdcr#777793,cr_posdcr#777794,cr_nomdos#777795,cr_for_cr#777796,cr_cr#777797,cr_statdic#777798,cr_statsm#777799,cr_statcr#777800,cr_coddic#777801,cr_context#777802,cr_datdic#777803,cr_heudic#777804,cr_heui_d#777805,cr_heui_f#777806,cr_codsec#777807,... 84 more fields] PushedFilters: [], ReadSchema: struct<cr_numcr:string,cr_numdos:string,cr_nomdic:string,cr_numdem:string,cr_numexa:string,cr_typ...

LocalLimit 1500

Project [cr_numcr#778759 AS COL_A5FD2FFB_EA2D_41C1_B705_A25C6D05B881#780715, cr_numdos#778760 AS COL_64D04F29_71AD_4640_AE57_436271A40AAD#780716, cr_nomdic#778761 AS COL_07C23FC6_64AF_4416_A9DA_3B743B210524#780717, cr_numdem#778762 AS COL_2FC30DFB_98B9_4BE0_B7DC_9F13599A65BA#780718, cr_numexa#778763 AS COL_A04C8A18_E8B3_4BF7_8A7A_1EDA5C5F9DF0#780719, cr_typdoc#778764 AS COL_299D9BA0_8FA2_42EA_8F2D_D78E8CBFD81B#780720, cr_prior#778765 AS COL_5A2C34D4_7E98_4346_8C97_158E6F48FE49#780721, cr_nomdcr#778766 AS COL_7282BF09_129C_40F9_8EE4_EEC60F93AFAE#780722, cr_taidcr#778767 AS COL_8A6EB039_CA89_4B16_8197_682903EF7C1C#780723, cr_durdcr#778768 AS COL_C9DE7F48_376F_41F6_97A8_CD5FB8FA9B58#780724, cr_posdcr#778769 AS COL_D8A27729_C788_4130_A480_984B888D85D8#780725, cr_nomdos#778770 AS COL_6192AFD2_0418_40A2_9842_897148E1D9BC#780726, cr_for_cr#778771 AS COL_74C447AE_C67B_4743_B5A4_E214C520D341#780727, cr_cr#778772 AS COL_AFF38E06_FEE0_45CA_B340_F7E760AB1936#780728, cr_statdic#778773 AS COL_5FCDAEB6_03F2_4001_80EE_0354905769B3#780729, cr_statsm#778774 AS COL_A92BBADE_4785_479D_BD34_7EB44808C644#780730, cr_statcr#778775 AS COL_73339033_5C81_431B_930C_0965557C512B#780731, cr_coddic#778776 AS COL_86007AE7_37F7_48B3_A21D_A524E3A64B02#780732, cr_context#778777 AS COL_8DA45796_0796_4CB5_ADB4_A31D1EDAA108#780733, cr_datdic#778778 AS COL_30606282_BB39_4DFE_98AA_AF17AB383066#780734, cr_heudic#778779 AS COL_922AF799_656F_43C0_B28E_F0FF0CC804EE#780735, cr_heui_d#778780 AS COL_A76288E8_5FC6_470E_8A0A_C1960DE77146#780736, cr_heui_f#778781 AS COL_55380C47_11F0_4716_B1D5_AB1ED3C6CB4B#780737, cr_codsec#778782 AS COL_405ACAA7_292F_4054_890E_4403B60A6036#780738, ... 85 more fields]

Filter ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numcr#778759)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numcr#778759)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdos#778760)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdos#778760)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdic#778761)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdic#778761)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdem#778762)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdem#778762)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numexa#778763)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numexa#778763)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typdoc#778764)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typdoc#778764)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_prior#778765)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_prior#778765)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdcr#778766)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdcr#778766)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_taidcr#778767)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_taidcr#778767)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_durdcr#778768)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_durdcr#778768)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_posdcr#778769)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_posdcr#778769)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdos#778770)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdos#778770)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_for_cr#778771)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_for_cr#778771)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_cr#778772)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_cr#778772)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statdic#778773)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statdic#778773)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statsm#778774)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statsm#778774)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statcr#778775)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statcr#778775)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddic#778776)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddic#778776)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_context#778777)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_context#778777)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdic#778778)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdic#778778)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudic#778779)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudic#778779)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heui_d#778780)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heui_d#778780)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heui_f#778781)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heui_f#778781)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsec#778782)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsec#778782)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datsec#778783)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datsec#778783)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heusec#778784)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heusec#778784)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codvcr#778785)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codvcr#778785)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datvcr#778786)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datvcr#778786)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heuvcr#778787)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heuvcr#778787)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddcr#778788)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddcr#778788)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdcr#778789)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdcr#778789)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudcr#778790)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudcr#778790)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_eff_d#778791)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_eff_d#778791)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_eff_w#778792)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_eff_w#778792)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coduti#778793)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coduti#778793)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmaj#778794)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmaj#778794)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsit#778795)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsit#778795)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sectra#778796)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sectra#778796)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typcr#778797)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typcr#778797)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsup#778798)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsup#778798)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nivvcr#778799)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nivvcr#778799)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numvcr#778800)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numvcr#778800)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_cor#778801)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_cor#778801)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datsup#778802)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datsup#778802)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heusup#778803)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heusup#778803)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flarch#778804)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flarch#778804)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_staext#778805)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_staext#778805)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flimpr#778806)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flimpr#778806)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_lockcr#778807)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_lockcr#778807)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codmcr#778808)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codmcr#778808)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmcr#778809)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmcr#778809)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heumcr#778810)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heumcr#778810)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codacc#778811)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codacc#778811)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_motpas#778812)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_motpas#778812)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_libco#778813)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_libco#778813)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subdic#778814)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subdic#778814)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subdir#778815)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subdir#778815)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numprt#778816)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numprt#778816)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_prt#778817)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_prt#778817)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_pro#778818)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_pro#778818)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_fra#778819)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_fra#778819)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_fra#778820)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_fra#778820)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codcli#778821)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codcli#778821)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_pri_dic#778822)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_pri_dic#778822)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_dic_tra#778823)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_dic_tra#778823)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heu_dic_tra#778824)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heu_dic_tra#778824)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codfra#778825)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codfra#778825)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_secext#778826)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_secext#778826)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statut_ext#778827)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statut_ext#778827)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_simp_job_id#778828)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_simp_job_id#778828)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_cr_int#778829)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_cr_int#778829)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heu_cr_int#778830)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heu_cr_int#778830)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_delai_total#778831)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_delai_total#778831)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_ligne_ext#778832)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_ligne_ext#778832)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_car_ext#778833)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_car_ext#778833)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomext#778834)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomext#778834)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subext#778835)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subext#778835)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_fltbdi#778836)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_fltbdi#778836)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typdic#778837)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typdic#778837)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_ack#778838)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_ack#778838)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_ack#778839)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_ack#778839)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_taille_dic#778840)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_taille_dic#778840)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_chksum_dic#778841)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_chksum_dic#778841)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmail#778842)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmail#778842)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heumail#778843)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heumail#778843)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codmail#778844)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codmail#778844)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_stadmp#778845)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_stadmp#778845)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddmp#778846)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddmp#778846)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdmp#778847)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdmp#778847)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudmp#778848)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudmp#778848)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_oiddmp#778849)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_oiddmp#778849)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_visdmp#778850)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_visdmp#778850)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_scnpat#778851)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_scnpat#778851)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datscn#778852)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datscn#778852)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nummcr#778853)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nummcr#778853)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numcr_cloud#778854)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numcr_cloud#778854)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdrv#778855)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdrv#778855)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flarch_d#778856)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flarch_d#778856)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_refext#778857)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_refext#778857)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_annonce#778858)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_annonce#778858)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_periph#778859)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_periph#778859)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datcre#778860)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datcre#778860)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heucre#778861)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heucre#778861)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_origine#778862)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_origine#778862)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_oid#778863)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_oid#778863)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flordo#778864)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flordo#778864)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_idcda#778865)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_idcda#778865)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_fltr#778866)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_fltr#778866)), 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#778759,cr_numdos#778760,cr_nomdic#778761,cr_numdem#778762,cr_numexa#778763,cr_typdoc#778764,cr_prior#778765,cr_nomdcr#778766,cr_taidcr#778767,cr_durdcr#778768,cr_posdcr#778769,cr_nomdos#778770,cr_for_cr#778771,cr_cr#778772,cr_statdic#778773,cr_statsm#778774,cr_statcr#778775,cr_coddic#778776,cr_context#778777,cr_datdic#778778,cr_heudic#778779,cr_heui_d#778780,cr_heui_f#778781,cr_codsec#778782,... 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 ==
CollectLimit (10)
+- Union (9)
   :- LocalLimit (4)
   :  +- 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)
   +- LocalLimit (8)
      +- Project (7)
         +- Filter (6)
            +- 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]  (5)


(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#777784, cr_numdos#777785, cr_nomdic#777786, cr_numdem#777787, cr_numexa#777788, cr_typdoc#777789, cr_prior#777790, cr_nomdcr#777791, cr_taidcr#777792, cr_durdcr#777793, cr_posdcr#777794, cr_nomdos#777795, cr_for_cr#777796, cr_cr#777797, cr_statdic#777798, cr_statsm#777799, cr_statcr#777800, cr_coddic#777801, cr_context#777802, cr_datdic#777803, cr_heudic#777804, cr_heui_d#777805, cr_heui_f#777806, cr_codsec#777807, cr_datsec#777808, cr_heusec#777809, cr_codvcr#777810, cr_datvcr#777811, cr_heuvcr#777812, cr_coddcr#777813, cr_datdcr#777814, cr_heudcr#777815, cr_dat_eff_d#777816, cr_dat_eff_w#777817, cr_coduti#777818, cr_datmaj#777819, cr_codsit#777820, cr_sectra#777821, cr_typcr#777822, cr_codsup#777823, cr_nivvcr#777824, cr_numvcr#777825, cr_nb_cor#777826, cr_datsup#777827, cr_heusup#777828, cr_flarch#777829, cr_staext#777830, cr_flimpr#777831, cr_lockcr#777832, cr_codmcr#777833, cr_datmcr#777834, cr_heumcr#777835, cr_codacc#777836, cr_motpas#777837, cr_libco#777838, cr_subdic#777839, cr_subdir#777840, cr_numprt#777841, cr_sta_env_prt#777842, cr_sta_ret_pro#777843, cr_sta_env_fra#777844, cr_sta_ret_fra#777845, cr_codcli#777846, cr_pri_dic#777847, cr_dat_dic_tra#777848, cr_heu_dic_tra#777849, cr_codfra#777850, cr_secext#777851, cr_statut_ext#777852, cr_simp_job_id#777853, cr_dat_cr_int#777854, cr_heu_cr_int#777855, cr_delai_total#777856, cr_nb_ligne_ext#777857, cr_nb_car_ext#777858, cr_nomext#777859, cr_subext#777860, cr_fltbdi#777861, cr_typdic#777862, cr_sta_env_ack#777863, cr_sta_ret_ack#777864, cr_taille_dic#777865, cr_chksum_dic#777866, cr_datmail#777867, cr_heumail#777868, cr_codmail#777869, cr_stadmp#777870, cr_coddmp#777871, cr_datdmp#777872, cr_heudmp#777873, cr_oiddmp#777874, cr_visdmp#777875, cr_scnpat#777876, cr_datscn#777877, cr_nummcr#777878, cr_numcr_cloud#777879, cr_numdrv#777880, cr_flarch_d#777881, cr_refext#777882, cr_annonce#777883, cr_periph#777884, cr_datcre#777885, cr_heucre#777886, cr_origine#777887, cr_oid#777888, cr_flordo#777889, cr_idcda#777890, cr_fltr#777891]
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#777784, cr_numdos#777785, cr_nomdic#777786, cr_numdem#777787, cr_numexa#777788, cr_typdoc#777789, cr_prior#777790, cr_nomdcr#777791, cr_taidcr#777792, cr_durdcr#777793, cr_posdcr#777794, cr_nomdos#777795, cr_for_cr#777796, cr_cr#777797, cr_statdic#777798, cr_statsm#777799, cr_statcr#777800, cr_coddic#777801, cr_context#777802, cr_datdic#777803, cr_heudic#777804, cr_heui_d#777805, cr_heui_f#777806, cr_codsec#777807, cr_datsec#777808, cr_heusec#777809, cr_codvcr#777810, cr_datvcr#777811, cr_heuvcr#777812, cr_coddcr#777813, cr_datdcr#777814, cr_heudcr#777815, cr_dat_eff_d#777816, cr_dat_eff_w#777817, cr_coduti#777818, cr_datmaj#777819, cr_codsit#777820, cr_sectra#777821, cr_typcr#777822, cr_codsup#777823, cr_nivvcr#777824, cr_numvcr#777825, cr_nb_cor#777826, cr_datsup#777827, cr_heusup#777828, cr_flarch#777829, cr_staext#777830, cr_flimpr#777831, cr_lockcr#777832, cr_codmcr#777833, cr_datmcr#777834, cr_heumcr#777835, cr_codacc#777836, cr_motpas#777837, cr_libco#777838, cr_subdic#777839, cr_subdir#777840, cr_numprt#777841, cr_sta_env_prt#777842, cr_sta_ret_pro#777843, cr_sta_env_fra#777844, cr_sta_ret_fra#777845, cr_codcli#777846, cr_pri_dic#777847, cr_dat_dic_tra#777848, cr_heu_dic_tra#777849, cr_codfra#777850, cr_secext#777851, cr_statut_ext#777852, cr_simp_job_id#777853, cr_dat_cr_int#777854, cr_heu_cr_int#777855, cr_delai_total#777856, cr_nb_ligne_ext#777857, cr_nb_car_ext#777858, cr_nomext#777859, cr_subext#777860, cr_fltbdi#777861, cr_typdic#777862, cr_sta_env_ack#777863, cr_sta_ret_ack#777864, cr_taille_dic#777865, cr_chksum_dic#777866, cr_datmail#777867, cr_heumail#777868, cr_codmail#777869, cr_stadmp#777870, cr_coddmp#777871, cr_datdmp#777872, cr_heudmp#777873, cr_oiddmp#777874, cr_visdmp#777875, cr_scnpat#777876, cr_datscn#777877, cr_nummcr#777878, cr_numcr_cloud#777879, cr_numdrv#777880, cr_flarch_d#777881, cr_refext#777882, cr_annonce#777883, cr_periph#777884, cr_datcre#777885, cr_heucre#777886, cr_origine#777887, cr_oid#777888, cr_flordo#777889, cr_idcda#777890, cr_fltr#777891]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numcr#777784)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numcr#777784)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdos#777785)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdos#777785)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdic#777786)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdic#777786)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdem#777787)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdem#777787)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numexa#777788)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numexa#777788)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typdoc#777789)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typdoc#777789)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_prior#777790)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_prior#777790)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdcr#777791)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdcr#777791)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_taidcr#777792)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_taidcr#777792)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_durdcr#777793)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_durdcr#777793)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_posdcr#777794)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_posdcr#777794)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdos#777795)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdos#777795)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_for_cr#777796)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_for_cr#777796)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_cr#777797)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_cr#777797)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statdic#777798)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statdic#777798)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statsm#777799)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statsm#777799)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statcr#777800)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statcr#777800)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddic#777801)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddic#777801)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_context#777802)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_context#777802)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdic#777803)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdic#777803)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudic#777804)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudic#777804)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heui_d#777805)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heui_d#777805)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heui_f#777806)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heui_f#777806)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsec#777807)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsec#777807)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datsec#777808)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datsec#777808)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heusec#777809)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heusec#777809)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codvcr#777810)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codvcr#777810)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datvcr#777811)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datvcr#777811)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heuvcr#777812)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heuvcr#777812)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddcr#777813)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddcr#777813)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdcr#777814)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdcr#777814)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudcr#777815)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudcr#777815)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_eff_d#777816)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_eff_d#777816)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_eff_w#777817)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_eff_w#777817)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coduti#777818)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coduti#777818)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmaj#777819)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmaj#777819)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsit#777820)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsit#777820)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sectra#777821)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sectra#777821)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typcr#777822)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typcr#777822)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsup#777823)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsup#777823)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nivvcr#777824)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nivvcr#777824)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numvcr#777825)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numvcr#777825)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_cor#777826)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_cor#777826)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datsup#777827)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datsup#777827)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heusup#777828)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heusup#777828)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flarch#777829)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flarch#777829)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_staext#777830)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_staext#777830)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flimpr#777831)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flimpr#777831)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_lockcr#777832)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_lockcr#777832)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codmcr#777833)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codmcr#777833)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmcr#777834)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmcr#777834)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heumcr#777835)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heumcr#777835)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codacc#777836)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codacc#777836)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_motpas#777837)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_motpas#777837)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_libco#777838)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_libco#777838)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subdic#777839)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subdic#777839)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subdir#777840)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subdir#777840)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numprt#777841)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numprt#777841)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_prt#777842)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_prt#777842)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_pro#777843)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_pro#777843)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_fra#777844)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_fra#777844)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_fra#777845)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_fra#777845)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codcli#777846)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codcli#777846)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_pri_dic#777847)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_pri_dic#777847)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_dic_tra#777848)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_dic_tra#777848)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heu_dic_tra#777849)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heu_dic_tra#777849)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codfra#777850)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codfra#777850)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_secext#777851)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_secext#777851)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statut_ext#777852)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statut_ext#777852)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_simp_job_id#777853)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_simp_job_id#777853)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_cr_int#777854)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_cr_int#777854)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heu_cr_int#777855)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heu_cr_int#777855)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_delai_total#777856)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_delai_total#777856)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_ligne_ext#777857)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_ligne_ext#777857)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_car_ext#777858)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_car_ext#777858)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomext#777859)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomext#777859)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subext#777860)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subext#777860)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_fltbdi#777861)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_fltbdi#777861)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typdic#777862)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typdic#777862)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_ack#777863)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_ack#777863)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_ack#777864)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_ack#777864)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_taille_dic#777865)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_taille_dic#777865)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_chksum_dic#777866)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_chksum_dic#777866)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmail#777867)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmail#777867)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heumail#777868)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heumail#777868)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codmail#777869)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codmail#777869)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_stadmp#777870)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_stadmp#777870)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddmp#777871)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddmp#777871)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdmp#777872)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdmp#777872)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudmp#777873)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudmp#777873)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_oiddmp#777874)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_oiddmp#777874)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_visdmp#777875)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_visdmp#777875)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_scnpat#777876)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_scnpat#777876)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datscn#777877)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datscn#777877)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nummcr#777878)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nummcr#777878)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numcr_cloud#777879)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numcr_cloud#777879)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdrv#777880)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdrv#777880)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flarch_d#777881)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flarch_d#777881)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_refext#777882)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_refext#777882)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_annonce#777883)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_annonce#777883)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_periph#777884)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_periph#777884)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datcre#777885)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datcre#777885)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heucre#777886)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heucre#777886)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_origine#777887)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_origine#777887)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_oid#777888)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_oid#777888)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flordo#777889)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flordo#777889)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_idcda#777890)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_idcda#777890)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_fltr#777891)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_fltr#777891)), 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 [109]: [cr_numcr#777784 AS COL_A5FD2FFB_EA2D_41C1_B705_A25C6D05B881#780388, cr_numdos#777785 AS COL_64D04F29_71AD_4640_AE57_436271A40AAD#780389, cr_nomdic#777786 AS COL_07C23FC6_64AF_4416_A9DA_3B743B210524#780390, cr_numdem#777787 AS COL_2FC30DFB_98B9_4BE0_B7DC_9F13599A65BA#780391, cr_numexa#777788 AS COL_A04C8A18_E8B3_4BF7_8A7A_1EDA5C5F9DF0#780392, cr_typdoc#777789 AS COL_299D9BA0_8FA2_42EA_8F2D_D78E8CBFD81B#780393, cr_prior#777790 AS COL_5A2C34D4_7E98_4346_8C97_158E6F48FE49#780394, cr_nomdcr#777791 AS COL_7282BF09_129C_40F9_8EE4_EEC60F93AFAE#780395, cr_taidcr#777792 AS COL_8A6EB039_CA89_4B16_8197_682903EF7C1C#780396, cr_durdcr#777793 AS COL_C9DE7F48_376F_41F6_97A8_CD5FB8FA9B58#780397, cr_posdcr#777794 AS COL_D8A27729_C788_4130_A480_984B888D85D8#780398, cr_nomdos#777795 AS COL_6192AFD2_0418_40A2_9842_897148E1D9BC#780399, cr_for_cr#777796 AS COL_74C447AE_C67B_4743_B5A4_E214C520D341#780400, cr_cr#777797 AS COL_AFF38E06_FEE0_45CA_B340_F7E760AB1936#780401, cr_statdic#777798 AS COL_5FCDAEB6_03F2_4001_80EE_0354905769B3#780402, cr_statsm#777799 AS COL_A92BBADE_4785_479D_BD34_7EB44808C644#780403, cr_statcr#777800 AS COL_73339033_5C81_431B_930C_0965557C512B#780404, cr_coddic#777801 AS COL_86007AE7_37F7_48B3_A21D_A524E3A64B02#780405, cr_context#777802 AS COL_8DA45796_0796_4CB5_ADB4_A31D1EDAA108#780406, cr_datdic#777803 AS COL_30606282_BB39_4DFE_98AA_AF17AB383066#780407, cr_heudic#777804 AS COL_922AF799_656F_43C0_B28E_F0FF0CC804EE#780408, cr_heui_d#777805 AS COL_A76288E8_5FC6_470E_8A0A_C1960DE77146#780409, cr_heui_f#777806 AS COL_55380C47_11F0_4716_B1D5_AB1ED3C6CB4B#780410, cr_codsec#777807 AS COL_405ACAA7_292F_4054_890E_4403B60A6036#780411, cr_datsec#777808 AS COL_86B35698_98C1_4027_87BE_466D67154CDA#780412, cr_heusec#777809 AS COL_91C4030F_5CA8_48E5_BCAF_EA04AC1FA569#780413, cr_codvcr#777810 AS COL_B5D55717_D6DB_4DAF_B78C_DB3CDC08A17C#780414, cr_datvcr#777811 AS COL_DD7BBCA2_E42A_4242_88E7_9EC6E011777D#780415, cr_heuvcr#777812 AS COL_1735EFC6_9C31_4AEF_A1A4_2FF13C802677#780416, cr_coddcr#777813 AS COL_862857FB_7601_4431_955A_97FA0550C6D6#780417, cr_datdcr#777814 AS COL_355E32CA_5732_428C_BEA2_F818BE32AE3D#780418, cr_heudcr#777815 AS COL_2446CFE1_B149_43E0_9C0C_F256AEFC695C#780419, cr_dat_eff_d#777816 AS COL_412B6464_0C35_4ABB_92DF_61911E810730#780420, cr_dat_eff_w#777817 AS COL_ACD02CA3_5ACE_48DC_B11D_965FC838ED96#780421, cr_coduti#777818 AS COL_6C0F3495_A333_43AD_8AB8_E978F9C7778C#780422, cr_datmaj#777819 AS COL_8DC59167_BBA8_48EE_98A9_CBA38F177650#780423, cr_codsit#777820 AS COL_DE5A4824_3468_45D3_8F5C_3F99D2ECE803#780424, cr_sectra#777821 AS COL_1430D520_EE19_4CA1_80B4_CF08F024E8E0#780425, cr_typcr#777822 AS COL_5387F313_148A_48EB_8773_9B807072D4AB#780426, cr_codsup#777823 AS COL_50CD5E9E_CAFC_4BC2_A7F5_37A096483BC7#780427, cr_nivvcr#777824 AS COL_A0E3A34E_6F81_4CF1_A2B9_07D0205D468F#780428, cr_numvcr#777825 AS COL_B6BD65F9_21EB_46C8_8516_4280AC0C9C30#780429, cr_nb_cor#777826 AS COL_3C1C3CF4_564D_4576_80D4_0F9C0B871D35#780430, cr_datsup#777827 AS COL_1037DE0B_2D1B_48DF_A102_90E9AA2907E0#780431, cr_heusup#777828 AS COL_081DDC6D_4F46_436E_A979_A4139933C55C#780432, cr_flarch#777829 AS COL_178997CE_26BE_48DB_9DED_0DE2D691D042#780433, cr_staext#777830 AS COL_9B243761_415C_4333_86E0_3DC141222B9B#780434, cr_flimpr#777831 AS COL_45D24D4B_F594_45B4_BC94_7EFA7C022E62#780435, cr_lockcr#777832 AS COL_A6849D0F_B22A_428B_8C5F_73328DA3324C#780436, cr_codmcr#777833 AS COL_4877DEB4_F2F4_476F_AF1A_39F7FF1CFB06#780437, cr_datmcr#777834 AS COL_02210589_99C4_4D2F_9331_52C4E5471205#780438, cr_heumcr#777835 AS COL_5BD74E13_12D3_47C5_A2AE_F7CBB2F4603C#780439, cr_codacc#777836 AS COL_C399C620_26B9_4132_9F75_005D9C151882#780440, cr_motpas#777837 AS COL_F804C358_A682_4AE6_98F6_8C32159CFEC8#780441, cr_libco#777838 AS COL_DBA477C2_41F6_4A73_8E74_83F0D603CD62#780442, cr_subdic#777839 AS COL_6A9BAEFA_2A93_4DD3_ADDD_4F704B95B2CC#780443, cr_subdir#777840 AS COL_E348C9EF_9E21_43BE_9A10_A72269002495#780444, cr_numprt#777841 AS COL_0D18CD1D_2D68_4BC2_9EE8_B6625C66D80B#780445, cr_sta_env_prt#777842 AS COL_12942E95_D007_4822_8694_EE91406418E2#780446, cr_sta_ret_pro#777843 AS COL_EAD711A3_8FBD_4B92_BBD9_35E85D9021F1#780447, cr_sta_env_fra#777844 AS COL_AE73DCBC_E4C2_4B8B_A88C_79238BCBCE07#780448, cr_sta_ret_fra#777845 AS COL_E89D2C97_24F7_4277_B1B1_06FD84CC1403#780449, cr_codcli#777846 AS COL_A6C40E7B_11AE_4358_ABEE_0BCAFF0B5693#780450, cr_pri_dic#777847 AS COL_BA70D3E1_5364_486C_8871_37A97AAB9CF7#780451, cr_dat_dic_tra#777848 AS COL_7710260B_5254_4719_942C_B867E93D30FD#780452, cr_heu_dic_tra#777849 AS COL_8B8F51D6_81A3_4449_9128_3A01CBC5D67F#780453, cr_codfra#777850 AS COL_A57AEB8B_29AD_45B4_8640_F677F708060B#780454, cr_secext#777851 AS COL_D5BC3694_92C8_4C34_A30C_FC9512290844#780455, cr_statut_ext#777852 AS COL_28F1ED04_927D_43E2_8FFD_9B5BDC0D1BB9#780456, cr_simp_job_id#777853 AS COL_984A491F_66D2_44C6_8E6C_EA97D39CDF7F#780457, cr_dat_cr_int#777854 AS COL_A40A33DE_EE0D_45FD_BDF1_C2F9F392AA2D#780458, cr_heu_cr_int#777855 AS COL_EA5FEFD5_3E07_4EC6_92B5_54F51F5D3865#780459, cr_delai_total#777856 AS COL_C258C2EB_5D23_49E3_BCB4_707C97E80AAC#780460, cr_nb_ligne_ext#777857 AS COL_8CB35AC2_28FD_451A_936A_FCD3F3CD254F#780461, cr_nb_car_ext#777858 AS COL_2E32BEA0_3B93_4179_B4A5_29B45582BBA9#780462, cr_nomext#777859 AS COL_CDDF1F93_D091_47A6_B45F_03654730D0F8#780463, cr_subext#777860 AS COL_AD06E124_EC8A_49F2_B806_73F06FACCFF7#780464, cr_fltbdi#777861 AS COL_36983E73_F6B6_4C4D_8AEA_B2D8017C29E5#780465, cr_typdic#777862 AS COL_5767C590_C029_475C_BBFB_CD87DC6C345F#780466, cr_sta_env_ack#777863 AS COL_EF424C7F_3AC0_4EF1_A32D_8C9D99FA4AA1#780467, cr_sta_ret_ack#777864 AS COL_4E03A5FD_83D1_42C2_AA7D_74E85A717A38#780468, cr_taille_dic#777865 AS COL_6A65B1A2_E62E_4992_8693_EBFC3B3FDA68#780469, cr_chksum_dic#777866 AS COL_05DDCC74_2100_4549_A82B_528EE1835140#780470, cr_datmail#777867 AS COL_60D8A30D_6D91_4996_AEA7_8C3153D621A1#780471, cr_heumail#777868 AS COL_BAABA3B3_B141_4DEB_A0FE_37598B14464B#780472, cr_codmail#777869 AS COL_269191BA_16C3_438F_9E0F_9CF29A900ADF#780473, cr_stadmp#777870 AS COL_0125E55E_CBD7_43A5_A980_270750CB5E96#780474, cr_coddmp#777871 AS COL_E7419800_128E_4276_8987_AE143B149447#780475, cr_datdmp#777872 AS COL_814B008F_DDCA_47C2_B2E0_EF793DDFE5FD#780476, cr_heudmp#777873 AS COL_58D4E267_7D6C_415A_96DA_788BFB9DBA60#780477, cr_oiddmp#777874 AS COL_F3E6DA0E_7FDB_408F_BFD5_54A72312104D#780478, cr_visdmp#777875 AS COL_8D7B7DDC_1A29_4F9C_9D1D_83E50DD1BC0C#780479, cr_scnpat#777876 AS COL_8E4F3101_3D34_48F8_9C19_57AD706903BF#780480, cr_datscn#777877 AS COL_E52E826F_E6FC_41A7_AFEB_A0C4AF687C52#780481, cr_nummcr#777878 AS COL_EE8068D9_774B_4B3D_99D8_AF2025E7AED3#780482, cr_numcr_cloud#777879 AS COL_41D295F3_CD48_4188_AD1C_CB5E42197E47#780483, cr_numdrv#777880 AS COL_F2F926AE_EF0B_420A_BBEC_575535DA4BD4#780484, cr_flarch_d#777881 AS COL_16788A89_623A_4650_84BC_3EAB0EE9F4CD#780485, cr_refext#777882 AS COL_A82D6ED3_B7B3_42E3_8893_625D1D14FB25#780486, cr_annonce#777883 AS COL_E5CF0353_B6F4_4345_978B_AFF6237B0D74#780487, cr_periph#777884 AS COL_BCAAC178_531E_4DFC_ABF3_10C5E2BEEAE0#780488, cr_datcre#777885 AS COL_746684AF_3E9A_4296_BA22_3E9C8A0567DF#780489, cr_heucre#777886 AS COL_ECC81622_553B_4B71_A2FD_E33A7FD7E445#780490, cr_origine#777887 AS COL_A1263368_5404_419C_B22B_C77308902308#780491, cr_oid#777888 AS COL_26FEC51F_8DB9_47B1_B696_EADEAAB4CB21#780492, cr_flordo#777889 AS COL_0C13A3BC_6875_419D_879A_2A62C23213C5#780493, cr_idcda#777890 AS COL_6BA67D61_3D1A_4D83_B3F0_5B5774671216#780494, cr_fltr#777891 AS COL_3E564F6F_F1E0_4CBB_9C50_4D06C1838AB4#780495, str_create(Cab_A) AS COL_4D5E0228_2377_4432_B9A4_2D16E56FB956#780496]
Input [108]: [cr_numcr#777784, cr_numdos#777785, cr_nomdic#777786, cr_numdem#777787, cr_numexa#777788, cr_typdoc#777789, cr_prior#777790, cr_nomdcr#777791, cr_taidcr#777792, cr_durdcr#777793, cr_posdcr#777794, cr_nomdos#777795, cr_for_cr#777796, cr_cr#777797, cr_statdic#777798, cr_statsm#777799, cr_statcr#777800, cr_coddic#777801, cr_context#777802, cr_datdic#777803, cr_heudic#777804, cr_heui_d#777805, cr_heui_f#777806, cr_codsec#777807, cr_datsec#777808, cr_heusec#777809, cr_codvcr#777810, cr_datvcr#777811, cr_heuvcr#777812, cr_coddcr#777813, cr_datdcr#777814, cr_heudcr#777815, cr_dat_eff_d#777816, cr_dat_eff_w#777817, cr_coduti#777818, cr_datmaj#777819, cr_codsit#777820, cr_sectra#777821, cr_typcr#777822, cr_codsup#777823, cr_nivvcr#777824, cr_numvcr#777825, cr_nb_cor#777826, cr_datsup#777827, cr_heusup#777828, cr_flarch#777829, cr_staext#777830, cr_flimpr#777831, cr_lockcr#777832, cr_codmcr#777833, cr_datmcr#777834, cr_heumcr#777835, cr_codacc#777836, cr_motpas#777837, cr_libco#777838, cr_subdic#777839, cr_subdir#777840, cr_numprt#777841, cr_sta_env_prt#777842, cr_sta_ret_pro#777843, cr_sta_env_fra#777844, cr_sta_ret_fra#777845, cr_codcli#777846, cr_pri_dic#777847, cr_dat_dic_tra#777848, cr_heu_dic_tra#777849, cr_codfra#777850, cr_secext#777851, cr_statut_ext#777852, cr_simp_job_id#777853, cr_dat_cr_int#777854, cr_heu_cr_int#777855, cr_delai_total#777856, cr_nb_ligne_ext#777857, cr_nb_car_ext#777858, cr_nomext#777859, cr_subext#777860, cr_fltbdi#777861, cr_typdic#777862, cr_sta_env_ack#777863, cr_sta_ret_ack#777864, cr_taille_dic#777865, cr_chksum_dic#777866, cr_datmail#777867, cr_heumail#777868, cr_codmail#777869, cr_stadmp#777870, cr_coddmp#777871, cr_datdmp#777872, cr_heudmp#777873, cr_oiddmp#777874, cr_visdmp#777875, cr_scnpat#777876, cr_datscn#777877, cr_nummcr#777878, cr_numcr_cloud#777879, cr_numdrv#777880, cr_flarch_d#777881, cr_refext#777882, cr_annonce#777883, cr_periph#777884, cr_datcre#777885, cr_heucre#777886, cr_origine#777887, cr_oid#777888, cr_flordo#777889, cr_idcda#777890, cr_fltr#777891]

(4) LocalLimit
Input [109]: [COL_A5FD2FFB_EA2D_41C1_B705_A25C6D05B881#780388, COL_64D04F29_71AD_4640_AE57_436271A40AAD#780389, COL_07C23FC6_64AF_4416_A9DA_3B743B210524#780390, COL_2FC30DFB_98B9_4BE0_B7DC_9F13599A65BA#780391, COL_A04C8A18_E8B3_4BF7_8A7A_1EDA5C5F9DF0#780392, COL_299D9BA0_8FA2_42EA_8F2D_D78E8CBFD81B#780393, COL_5A2C34D4_7E98_4346_8C97_158E6F48FE49#780394, COL_7282BF09_129C_40F9_8EE4_EEC60F93AFAE#780395, COL_8A6EB039_CA89_4B16_8197_682903EF7C1C#780396, COL_C9DE7F48_376F_41F6_97A8_CD5FB8FA9B58#780397, COL_D8A27729_C788_4130_A480_984B888D85D8#780398, COL_6192AFD2_0418_40A2_9842_897148E1D9BC#780399, COL_74C447AE_C67B_4743_B5A4_E214C520D341#780400, COL_AFF38E06_FEE0_45CA_B340_F7E760AB1936#780401, COL_5FCDAEB6_03F2_4001_80EE_0354905769B3#780402, COL_A92BBADE_4785_479D_BD34_7EB44808C644#780403, COL_73339033_5C81_431B_930C_0965557C512B#780404, COL_86007AE7_37F7_48B3_A21D_A524E3A64B02#780405, COL_8DA45796_0796_4CB5_ADB4_A31D1EDAA108#780406, COL_30606282_BB39_4DFE_98AA_AF17AB383066#780407, COL_922AF799_656F_43C0_B28E_F0FF0CC804EE#780408, COL_A76288E8_5FC6_470E_8A0A_C1960DE77146#780409, COL_55380C47_11F0_4716_B1D5_AB1ED3C6CB4B#780410, COL_405ACAA7_292F_4054_890E_4403B60A6036#780411, COL_86B35698_98C1_4027_87BE_466D67154CDA#780412, COL_91C4030F_5CA8_48E5_BCAF_EA04AC1FA569#780413, COL_B5D55717_D6DB_4DAF_B78C_DB3CDC08A17C#780414, COL_DD7BBCA2_E42A_4242_88E7_9EC6E011777D#780415, COL_1735EFC6_9C31_4AEF_A1A4_2FF13C802677#780416, COL_862857FB_7601_4431_955A_97FA0550C6D6#780417, COL_355E32CA_5732_428C_BEA2_F818BE32AE3D#780418, COL_2446CFE1_B149_43E0_9C0C_F256AEFC695C#780419, COL_412B6464_0C35_4ABB_92DF_61911E810730#780420, COL_ACD02CA3_5ACE_48DC_B11D_965FC838ED96#780421, COL_6C0F3495_A333_43AD_8AB8_E978F9C7778C#780422, COL_8DC59167_BBA8_48EE_98A9_CBA38F177650#780423, COL_DE5A4824_3468_45D3_8F5C_3F99D2ECE803#780424, COL_1430D520_EE19_4CA1_80B4_CF08F024E8E0#780425, COL_5387F313_148A_48EB_8773_9B807072D4AB#780426, COL_50CD5E9E_CAFC_4BC2_A7F5_37A096483BC7#780427, COL_A0E3A34E_6F81_4CF1_A2B9_07D0205D468F#780428, COL_B6BD65F9_21EB_46C8_8516_4280AC0C9C30#780429, COL_3C1C3CF4_564D_4576_80D4_0F9C0B871D35#780430, COL_1037DE0B_2D1B_48DF_A102_90E9AA2907E0#780431, COL_081DDC6D_4F46_436E_A979_A4139933C55C#780432, COL_178997CE_26BE_48DB_9DED_0DE2D691D042#780433, COL_9B243761_415C_4333_86E0_3DC141222B9B#780434, COL_45D24D4B_F594_45B4_BC94_7EFA7C022E62#780435, COL_A6849D0F_B22A_428B_8C5F_73328DA3324C#780436, COL_4877DEB4_F2F4_476F_AF1A_39F7FF1CFB06#780437, COL_02210589_99C4_4D2F_9331_52C4E5471205#780438, COL_5BD74E13_12D3_47C5_A2AE_F7CBB2F4603C#780439, COL_C399C620_26B9_4132_9F75_005D9C151882#780440, COL_F804C358_A682_4AE6_98F6_8C32159CFEC8#780441, COL_DBA477C2_41F6_4A73_8E74_83F0D603CD62#780442, COL_6A9BAEFA_2A93_4DD3_ADDD_4F704B95B2CC#780443, COL_E348C9EF_9E21_43BE_9A10_A72269002495#780444, COL_0D18CD1D_2D68_4BC2_9EE8_B6625C66D80B#780445, COL_12942E95_D007_4822_8694_EE91406418E2#780446, COL_EAD711A3_8FBD_4B92_BBD9_35E85D9021F1#780447, COL_AE73DCBC_E4C2_4B8B_A88C_79238BCBCE07#780448, COL_E89D2C97_24F7_4277_B1B1_06FD84CC1403#780449, COL_A6C40E7B_11AE_4358_ABEE_0BCAFF0B5693#780450, COL_BA70D3E1_5364_486C_8871_37A97AAB9CF7#780451, COL_7710260B_5254_4719_942C_B867E93D30FD#780452, COL_8B8F51D6_81A3_4449_9128_3A01CBC5D67F#780453, COL_A57AEB8B_29AD_45B4_8640_F677F708060B#780454, COL_D5BC3694_92C8_4C34_A30C_FC9512290844#780455, COL_28F1ED04_927D_43E2_8FFD_9B5BDC0D1BB9#780456, COL_984A491F_66D2_44C6_8E6C_EA97D39CDF7F#780457, COL_A40A33DE_EE0D_45FD_BDF1_C2F9F392AA2D#780458, COL_EA5FEFD5_3E07_4EC6_92B5_54F51F5D3865#780459, COL_C258C2EB_5D23_49E3_BCB4_707C97E80AAC#780460, COL_8CB35AC2_28FD_451A_936A_FCD3F3CD254F#780461, COL_2E32BEA0_3B93_4179_B4A5_29B45582BBA9#780462, COL_CDDF1F93_D091_47A6_B45F_03654730D0F8#780463, COL_AD06E124_EC8A_49F2_B806_73F06FACCFF7#780464, COL_36983E73_F6B6_4C4D_8AEA_B2D8017C29E5#780465, COL_5767C590_C029_475C_BBFB_CD87DC6C345F#780466, COL_EF424C7F_3AC0_4EF1_A32D_8C9D99FA4AA1#780467, COL_4E03A5FD_83D1_42C2_AA7D_74E85A717A38#780468, COL_6A65B1A2_E62E_4992_8693_EBFC3B3FDA68#780469, COL_05DDCC74_2100_4549_A82B_528EE1835140#780470, COL_60D8A30D_6D91_4996_AEA7_8C3153D621A1#780471, COL_BAABA3B3_B141_4DEB_A0FE_37598B14464B#780472, COL_269191BA_16C3_438F_9E0F_9CF29A900ADF#780473, COL_0125E55E_CBD7_43A5_A980_270750CB5E96#780474, COL_E7419800_128E_4276_8987_AE143B149447#780475, COL_814B008F_DDCA_47C2_B2E0_EF793DDFE5FD#780476, COL_58D4E267_7D6C_415A_96DA_788BFB9DBA60#780477, COL_F3E6DA0E_7FDB_408F_BFD5_54A72312104D#780478, COL_8D7B7DDC_1A29_4F9C_9D1D_83E50DD1BC0C#780479, COL_8E4F3101_3D34_48F8_9C19_57AD706903BF#780480, COL_E52E826F_E6FC_41A7_AFEB_A0C4AF687C52#780481, COL_EE8068D9_774B_4B3D_99D8_AF2025E7AED3#780482, COL_41D295F3_CD48_4188_AD1C_CB5E42197E47#780483, COL_F2F926AE_EF0B_420A_BBEC_575535DA4BD4#780484, COL_16788A89_623A_4650_84BC_3EAB0EE9F4CD#780485, COL_A82D6ED3_B7B3_42E3_8893_625D1D14FB25#780486, COL_E5CF0353_B6F4_4345_978B_AFF6237B0D74#780487, COL_BCAAC178_531E_4DFC_ABF3_10C5E2BEEAE0#780488, COL_746684AF_3E9A_4296_BA22_3E9C8A0567DF#780489, COL_ECC81622_553B_4B71_A2FD_E33A7FD7E445#780490, COL_A1263368_5404_419C_B22B_C77308902308#780491, COL_26FEC51F_8DB9_47B1_B696_EADEAAB4CB21#780492, COL_0C13A3BC_6875_419D_879A_2A62C23213C5#780493, COL_6BA67D61_3D1A_4D83_B3F0_5B5774671216#780494, COL_3E564F6F_F1E0_4CBB_9C50_4D06C1838AB4#780495, COL_4D5E0228_2377_4432_B9A4_2D16E56FB956#780496]
Arguments: 1500

(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] 
Output [108]: [cr_numcr#778759, cr_numdos#778760, cr_nomdic#778761, cr_numdem#778762, cr_numexa#778763, cr_typdoc#778764, cr_prior#778765, cr_nomdcr#778766, cr_taidcr#778767, cr_durdcr#778768, cr_posdcr#778769, cr_nomdos#778770, cr_for_cr#778771, cr_cr#778772, cr_statdic#778773, cr_statsm#778774, cr_statcr#778775, cr_coddic#778776, cr_context#778777, cr_datdic#778778, cr_heudic#778779, cr_heui_d#778780, cr_heui_f#778781, cr_codsec#778782, cr_datsec#778783, cr_heusec#778784, cr_codvcr#778785, cr_datvcr#778786, cr_heuvcr#778787, cr_coddcr#778788, cr_datdcr#778789, cr_heudcr#778790, cr_dat_eff_d#778791, cr_dat_eff_w#778792, cr_coduti#778793, cr_datmaj#778794, cr_codsit#778795, cr_sectra#778796, cr_typcr#778797, cr_codsup#778798, cr_nivvcr#778799, cr_numvcr#778800, cr_nb_cor#778801, cr_datsup#778802, cr_heusup#778803, cr_flarch#778804, cr_staext#778805, cr_flimpr#778806, cr_lockcr#778807, cr_codmcr#778808, cr_datmcr#778809, cr_heumcr#778810, cr_codacc#778811, cr_motpas#778812, cr_libco#778813, cr_subdic#778814, cr_subdir#778815, cr_numprt#778816, cr_sta_env_prt#778817, cr_sta_ret_pro#778818, cr_sta_env_fra#778819, cr_sta_ret_fra#778820, cr_codcli#778821, cr_pri_dic#778822, cr_dat_dic_tra#778823, cr_heu_dic_tra#778824, cr_codfra#778825, cr_secext#778826, cr_statut_ext#778827, cr_simp_job_id#778828, cr_dat_cr_int#778829, cr_heu_cr_int#778830, cr_delai_total#778831, cr_nb_ligne_ext#778832, cr_nb_car_ext#778833, cr_nomext#778834, cr_subext#778835, cr_fltbdi#778836, cr_typdic#778837, cr_sta_env_ack#778838, cr_sta_ret_ack#778839, cr_taille_dic#778840, cr_chksum_dic#778841, cr_datmail#778842, cr_heumail#778843, cr_codmail#778844, cr_stadmp#778845, cr_coddmp#778846, cr_datdmp#778847, cr_heudmp#778848, cr_oiddmp#778849, cr_visdmp#778850, cr_scnpat#778851, cr_datscn#778852, cr_nummcr#778853, cr_numcr_cloud#778854, cr_numdrv#778855, cr_flarch_d#778856, cr_refext#778857, cr_annonce#778858, cr_periph#778859, cr_datcre#778860, cr_heucre#778861, cr_origine#778862, cr_oid#778863, cr_flordo#778864, cr_idcda#778865, cr_fltr#778866]
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>

(6) Filter
Input [108]: [cr_numcr#778759, cr_numdos#778760, cr_nomdic#778761, cr_numdem#778762, cr_numexa#778763, cr_typdoc#778764, cr_prior#778765, cr_nomdcr#778766, cr_taidcr#778767, cr_durdcr#778768, cr_posdcr#778769, cr_nomdos#778770, cr_for_cr#778771, cr_cr#778772, cr_statdic#778773, cr_statsm#778774, cr_statcr#778775, cr_coddic#778776, cr_context#778777, cr_datdic#778778, cr_heudic#778779, cr_heui_d#778780, cr_heui_f#778781, cr_codsec#778782, cr_datsec#778783, cr_heusec#778784, cr_codvcr#778785, cr_datvcr#778786, cr_heuvcr#778787, cr_coddcr#778788, cr_datdcr#778789, cr_heudcr#778790, cr_dat_eff_d#778791, cr_dat_eff_w#778792, cr_coduti#778793, cr_datmaj#778794, cr_codsit#778795, cr_sectra#778796, cr_typcr#778797, cr_codsup#778798, cr_nivvcr#778799, cr_numvcr#778800, cr_nb_cor#778801, cr_datsup#778802, cr_heusup#778803, cr_flarch#778804, cr_staext#778805, cr_flimpr#778806, cr_lockcr#778807, cr_codmcr#778808, cr_datmcr#778809, cr_heumcr#778810, cr_codacc#778811, cr_motpas#778812, cr_libco#778813, cr_subdic#778814, cr_subdir#778815, cr_numprt#778816, cr_sta_env_prt#778817, cr_sta_ret_pro#778818, cr_sta_env_fra#778819, cr_sta_ret_fra#778820, cr_codcli#778821, cr_pri_dic#778822, cr_dat_dic_tra#778823, cr_heu_dic_tra#778824, cr_codfra#778825, cr_secext#778826, cr_statut_ext#778827, cr_simp_job_id#778828, cr_dat_cr_int#778829, cr_heu_cr_int#778830, cr_delai_total#778831, cr_nb_ligne_ext#778832, cr_nb_car_ext#778833, cr_nomext#778834, cr_subext#778835, cr_fltbdi#778836, cr_typdic#778837, cr_sta_env_ack#778838, cr_sta_ret_ack#778839, cr_taille_dic#778840, cr_chksum_dic#778841, cr_datmail#778842, cr_heumail#778843, cr_codmail#778844, cr_stadmp#778845, cr_coddmp#778846, cr_datdmp#778847, cr_heudmp#778848, cr_oiddmp#778849, cr_visdmp#778850, cr_scnpat#778851, cr_datscn#778852, cr_nummcr#778853, cr_numcr_cloud#778854, cr_numdrv#778855, cr_flarch_d#778856, cr_refext#778857, cr_annonce#778858, cr_periph#778859, cr_datcre#778860, cr_heucre#778861, cr_origine#778862, cr_oid#778863, cr_flordo#778864, cr_idcda#778865, cr_fltr#778866]
Condition : ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numcr#778759)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numcr#778759)), MAIN) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdos#778760)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdos#778760)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdic#778761)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdic#778761)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdem#778762)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdem#778762)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numexa#778763)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numexa#778763)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typdoc#778764)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typdoc#778764)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_prior#778765)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_prior#778765)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdcr#778766)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdcr#778766)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_taidcr#778767)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_taidcr#778767)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_durdcr#778768)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_durdcr#778768)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_posdcr#778769)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_posdcr#778769)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomdos#778770)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomdos#778770)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_for_cr#778771)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_for_cr#778771)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_cr#778772)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_cr#778772)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statdic#778773)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statdic#778773)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statsm#778774)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statsm#778774)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statcr#778775)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statcr#778775)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddic#778776)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddic#778776)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_context#778777)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_context#778777)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdic#778778)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdic#778778)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudic#778779)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudic#778779)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heui_d#778780)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heui_d#778780)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heui_f#778781)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heui_f#778781)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsec#778782)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsec#778782)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datsec#778783)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datsec#778783)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heusec#778784)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heusec#778784)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codvcr#778785)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codvcr#778785)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datvcr#778786)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datvcr#778786)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heuvcr#778787)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heuvcr#778787)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddcr#778788)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddcr#778788)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdcr#778789)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdcr#778789)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudcr#778790)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudcr#778790)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_eff_d#778791)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_eff_d#778791)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_eff_w#778792)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_eff_w#778792)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coduti#778793)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coduti#778793)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmaj#778794)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmaj#778794)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsit#778795)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsit#778795)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sectra#778796)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sectra#778796)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typcr#778797)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typcr#778797)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codsup#778798)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codsup#778798)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nivvcr#778799)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nivvcr#778799)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numvcr#778800)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numvcr#778800)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_cor#778801)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_cor#778801)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datsup#778802)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datsup#778802)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heusup#778803)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heusup#778803)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flarch#778804)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flarch#778804)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_staext#778805)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_staext#778805)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flimpr#778806)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flimpr#778806)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_lockcr#778807)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_lockcr#778807)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codmcr#778808)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codmcr#778808)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmcr#778809)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmcr#778809)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heumcr#778810)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heumcr#778810)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codacc#778811)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codacc#778811)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_motpas#778812)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_motpas#778812)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_libco#778813)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_libco#778813)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subdic#778814)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subdic#778814)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subdir#778815)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subdir#778815)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numprt#778816)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numprt#778816)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_prt#778817)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_prt#778817)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_pro#778818)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_pro#778818)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_fra#778819)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_fra#778819)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_fra#778820)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_fra#778820)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codcli#778821)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codcli#778821)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_pri_dic#778822)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_pri_dic#778822)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_dic_tra#778823)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_dic_tra#778823)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heu_dic_tra#778824)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heu_dic_tra#778824)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codfra#778825)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codfra#778825)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_secext#778826)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_secext#778826)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_statut_ext#778827)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_statut_ext#778827)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_simp_job_id#778828)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_simp_job_id#778828)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_dat_cr_int#778829)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_dat_cr_int#778829)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heu_cr_int#778830)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heu_cr_int#778830)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_delai_total#778831)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_delai_total#778831)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_ligne_ext#778832)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_ligne_ext#778832)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nb_car_ext#778833)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nb_car_ext#778833)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nomext#778834)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nomext#778834)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_subext#778835)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_subext#778835)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_fltbdi#778836)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_fltbdi#778836)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_typdic#778837)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_typdic#778837)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_env_ack#778838)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_env_ack#778838)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_sta_ret_ack#778839)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_sta_ret_ack#778839)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_taille_dic#778840)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_taille_dic#778840)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_chksum_dic#778841)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_chksum_dic#778841)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datmail#778842)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datmail#778842)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heumail#778843)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heumail#778843)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_codmail#778844)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_codmail#778844)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_stadmp#778845)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_stadmp#778845)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_coddmp#778846)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_coddmp#778846)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datdmp#778847)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datdmp#778847)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heudmp#778848)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heudmp#778848)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_oiddmp#778849)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_oiddmp#778849)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_visdmp#778850)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_visdmp#778850)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_scnpat#778851)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_scnpat#778851)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datscn#778852)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datscn#778852)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_nummcr#778853)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_nummcr#778853)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numcr_cloud#778854)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numcr_cloud#778854)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_numdrv#778855)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_numdrv#778855)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flarch_d#778856)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flarch_d#778856)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_refext#778857)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_refext#778857)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_annonce#778858)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_annonce#778858)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_periph#778859)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_periph#778859)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_datcre#778860)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_datcre#778860)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_heucre#778861)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_heucre#778861)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_origine#778862)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_origine#778862)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_oid#778863)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_oid#778863)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_flordo#778864)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_flordo#778864)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_idcda#778865)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_idcda#778865)), MAIN) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(cr_fltr#778866)), MAIN)) THEN false ELSE Contains(str_remove_accent(upper(cr_fltr#778866)), 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)

(7) Project
Output [109]: [cr_numcr#778759 AS COL_A5FD2FFB_EA2D_41C1_B705_A25C6D05B881#780715, cr_numdos#778760 AS COL_64D04F29_71AD_4640_AE57_436271A40AAD#780716, cr_nomdic#778761 AS COL_07C23FC6_64AF_4416_A9DA_3B743B210524#780717, cr_numdem#778762 AS COL_2FC30DFB_98B9_4BE0_B7DC_9F13599A65BA#780718, cr_numexa#778763 AS COL_A04C8A18_E8B3_4BF7_8A7A_1EDA5C5F9DF0#780719, cr_typdoc#778764 AS COL_299D9BA0_8FA2_42EA_8F2D_D78E8CBFD81B#780720, cr_prior#778765 AS COL_5A2C34D4_7E98_4346_8C97_158E6F48FE49#780721, cr_nomdcr#778766 AS COL_7282BF09_129C_40F9_8EE4_EEC60F93AFAE#780722, cr_taidcr#778767 AS COL_8A6EB039_CA89_4B16_8197_682903EF7C1C#780723, cr_durdcr#778768 AS COL_C9DE7F48_376F_41F6_97A8_CD5FB8FA9B58#780724, cr_posdcr#778769 AS COL_D8A27729_C788_4130_A480_984B888D85D8#780725, cr_nomdos#778770 AS COL_6192AFD2_0418_40A2_9842_897148E1D9BC#780726, cr_for_cr#778771 AS COL_74C447AE_C67B_4743_B5A4_E214C520D341#780727, cr_cr#778772 AS COL_AFF38E06_FEE0_45CA_B340_F7E760AB1936#780728, cr_statdic#778773 AS COL_5FCDAEB6_03F2_4001_80EE_0354905769B3#780729, cr_statsm#778774 AS COL_A92BBADE_4785_479D_BD34_7EB44808C644#780730, cr_statcr#778775 AS COL_73339033_5C81_431B_930C_0965557C512B#780731, cr_coddic#778776 AS COL_86007AE7_37F7_48B3_A21D_A524E3A64B02#780732, cr_context#778777 AS COL_8DA45796_0796_4CB5_ADB4_A31D1EDAA108#780733, cr_datdic#778778 AS COL_30606282_BB39_4DFE_98AA_AF17AB383066#780734, cr_heudic#778779 AS COL_922AF799_656F_43C0_B28E_F0FF0CC804EE#780735, cr_heui_d#778780 AS COL_A76288E8_5FC6_470E_8A0A_C1960DE77146#780736, cr_heui_f#778781 AS COL_55380C47_11F0_4716_B1D5_AB1ED3C6CB4B#780737, cr_codsec#778782 AS COL_405ACAA7_292F_4054_890E_4403B60A6036#780738, cr_datsec#778783 AS COL_86B35698_98C1_4027_87BE_466D67154CDA#780739, cr_heusec#778784 AS COL_91C4030F_5CA8_48E5_BCAF_EA04AC1FA569#780740, cr_codvcr#778785 AS COL_B5D55717_D6DB_4DAF_B78C_DB3CDC08A17C#780741, cr_datvcr#778786 AS COL_DD7BBCA2_E42A_4242_88E7_9EC6E011777D#780742, cr_heuvcr#778787 AS COL_1735EFC6_9C31_4AEF_A1A4_2FF13C802677#780743, cr_coddcr#778788 AS COL_862857FB_7601_4431_955A_97FA0550C6D6#780744, cr_datdcr#778789 AS COL_355E32CA_5732_428C_BEA2_F818BE32AE3D#780745, cr_heudcr#778790 AS COL_2446CFE1_B149_43E0_9C0C_F256AEFC695C#780746, cr_dat_eff_d#778791 AS COL_412B6464_0C35_4ABB_92DF_61911E810730#780747, cr_dat_eff_w#778792 AS COL_ACD02CA3_5ACE_48DC_B11D_965FC838ED96#780748, cr_coduti#778793 AS COL_6C0F3495_A333_43AD_8AB8_E978F9C7778C#780749, cr_datmaj#778794 AS COL_8DC59167_BBA8_48EE_98A9_CBA38F177650#780750, cr_codsit#778795 AS COL_DE5A4824_3468_45D3_8F5C_3F99D2ECE803#780751, cr_sectra#778796 AS COL_1430D520_EE19_4CA1_80B4_CF08F024E8E0#780752, cr_typcr#778797 AS COL_5387F313_148A_48EB_8773_9B807072D4AB#780753, cr_codsup#778798 AS COL_50CD5E9E_CAFC_4BC2_A7F5_37A096483BC7#780754, cr_nivvcr#778799 AS COL_A0E3A34E_6F81_4CF1_A2B9_07D0205D468F#780755, cr_numvcr#778800 AS COL_B6BD65F9_21EB_46C8_8516_4280AC0C9C30#780756, cr_nb_cor#778801 AS COL_3C1C3CF4_564D_4576_80D4_0F9C0B871D35#780757, cr_datsup#778802 AS COL_1037DE0B_2D1B_48DF_A102_90E9AA2907E0#780758, cr_heusup#778803 AS COL_081DDC6D_4F46_436E_A979_A4139933C55C#780759, cr_flarch#778804 AS COL_178997CE_26BE_48DB_9DED_0DE2D691D042#780760, cr_staext#778805 AS COL_9B243761_415C_4333_86E0_3DC141222B9B#780761, cr_flimpr#778806 AS COL_45D24D4B_F594_45B4_BC94_7EFA7C022E62#780762, cr_lockcr#778807 AS COL_A6849D0F_B22A_428B_8C5F_73328DA3324C#780763, cr_codmcr#778808 AS COL_4877DEB4_F2F4_476F_AF1A_39F7FF1CFB06#780764, cr_datmcr#778809 AS COL_02210589_99C4_4D2F_9331_52C4E5471205#780765, cr_heumcr#778810 AS COL_5BD74E13_12D3_47C5_A2AE_F7CBB2F4603C#780766, cr_codacc#778811 AS COL_C399C620_26B9_4132_9F75_005D9C151882#780767, cr_motpas#778812 AS COL_F804C358_A682_4AE6_98F6_8C32159CFEC8#780768, cr_libco#778813 AS COL_DBA477C2_41F6_4A73_8E74_83F0D603CD62#780769, cr_subdic#778814 AS COL_6A9BAEFA_2A93_4DD3_ADDD_4F704B95B2CC#780770, cr_subdir#778815 AS COL_E348C9EF_9E21_43BE_9A10_A72269002495#780771, cr_numprt#778816 AS COL_0D18CD1D_2D68_4BC2_9EE8_B6625C66D80B#780772, cr_sta_env_prt#778817 AS COL_12942E95_D007_4822_8694_EE91406418E2#780773, cr_sta_ret_pro#778818 AS COL_EAD711A3_8FBD_4B92_BBD9_35E85D9021F1#780774, cr_sta_env_fra#778819 AS COL_AE73DCBC_E4C2_4B8B_A88C_79238BCBCE07#780775, cr_sta_ret_fra#778820 AS COL_E89D2C97_24F7_4277_B1B1_06FD84CC1403#780776, cr_codcli#778821 AS COL_A6C40E7B_11AE_4358_ABEE_0BCAFF0B5693#780777, cr_pri_dic#778822 AS COL_BA70D3E1_5364_486C_8871_37A97AAB9CF7#780778, cr_dat_dic_tra#778823 AS COL_7710260B_5254_4719_942C_B867E93D30FD#780779, cr_heu_dic_tra#778824 AS COL_8B8F51D6_81A3_4449_9128_3A01CBC5D67F#780780, cr_codfra#778825 AS COL_A57AEB8B_29AD_45B4_8640_F677F708060B#780781, cr_secext#778826 AS COL_D5BC3694_92C8_4C34_A30C_FC9512290844#780782, cr_statut_ext#778827 AS COL_28F1ED04_927D_43E2_8FFD_9B5BDC0D1BB9#780783, cr_simp_job_id#778828 AS COL_984A491F_66D2_44C6_8E6C_EA97D39CDF7F#780784, cr_dat_cr_int#778829 AS COL_A40A33DE_EE0D_45FD_BDF1_C2F9F392AA2D#780785, cr_heu_cr_int#778830 AS COL_EA5FEFD5_3E07_4EC6_92B5_54F51F5D3865#780786, cr_delai_total#778831 AS COL_C258C2EB_5D23_49E3_BCB4_707C97E80AAC#780787, cr_nb_ligne_ext#778832 AS COL_8CB35AC2_28FD_451A_936A_FCD3F3CD254F#780788, cr_nb_car_ext#778833 AS COL_2E32BEA0_3B93_4179_B4A5_29B45582BBA9#780789, cr_nomext#778834 AS COL_CDDF1F93_D091_47A6_B45F_03654730D0F8#780790, cr_subext#778835 AS COL_AD06E124_EC8A_49F2_B806_73F06FACCFF7#780791, cr_fltbdi#778836 AS COL_36983E73_F6B6_4C4D_8AEA_B2D8017C29E5#780792, cr_typdic#778837 AS COL_5767C590_C029_475C_BBFB_CD87DC6C345F#780793, cr_sta_env_ack#778838 AS COL_EF424C7F_3AC0_4EF1_A32D_8C9D99FA4AA1#780794, cr_sta_ret_ack#778839 AS COL_4E03A5FD_83D1_42C2_AA7D_74E85A717A38#780795, cr_taille_dic#778840 AS COL_6A65B1A2_E62E_4992_8693_EBFC3B3FDA68#780796, cr_chksum_dic#778841 AS COL_05DDCC74_2100_4549_A82B_528EE1835140#780797, cr_datmail#778842 AS COL_60D8A30D_6D91_4996_AEA7_8C3153D621A1#780798, cr_heumail#778843 AS COL_BAABA3B3_B141_4DEB_A0FE_37598B14464B#780799, cr_codmail#778844 AS COL_269191BA_16C3_438F_9E0F_9CF29A900ADF#780800, cr_stadmp#778845 AS COL_0125E55E_CBD7_43A5_A980_270750CB5E96#780801, cr_coddmp#778846 AS COL_E7419800_128E_4276_8987_AE143B149447#780802, cr_datdmp#778847 AS COL_814B008F_DDCA_47C2_B2E0_EF793DDFE5FD#780803, cr_heudmp#778848 AS COL_58D4E267_7D6C_415A_96DA_788BFB9DBA60#780804, cr_oiddmp#778849 AS COL_F3E6DA0E_7FDB_408F_BFD5_54A72312104D#780805, cr_visdmp#778850 AS COL_8D7B7DDC_1A29_4F9C_9D1D_83E50DD1BC0C#780806, cr_scnpat#778851 AS COL_8E4F3101_3D34_48F8_9C19_57AD706903BF#780807, cr_datscn#778852 AS COL_E52E826F_E6FC_41A7_AFEB_A0C4AF687C52#780808, cr_nummcr#778853 AS COL_EE8068D9_774B_4B3D_99D8_AF2025E7AED3#780809, cr_numcr_cloud#778854 AS COL_41D295F3_CD48_4188_AD1C_CB5E42197E47#780810, cr_numdrv#778855 AS COL_F2F926AE_EF0B_420A_BBEC_575535DA4BD4#780811, cr_flarch_d#778856 AS COL_16788A89_623A_4650_84BC_3EAB0EE9F4CD#780812, cr_refext#778857 AS COL_A82D6ED3_B7B3_42E3_8893_625D1D14FB25#780813, cr_annonce#778858 AS COL_E5CF0353_B6F4_4345_978B_AFF6237B0D74#780814, cr_periph#778859 AS COL_BCAAC178_531E_4DFC_ABF3_10C5E2BEEAE0#780815, cr_datcre#778860 AS COL_746684AF_3E9A_4296_BA22_3E9C8A0567DF#780816, cr_heucre#778861 AS COL_ECC81622_553B_4B71_A2FD_E33A7FD7E445#780817, cr_origine#778862 AS COL_A1263368_5404_419C_B22B_C77308902308#780818, cr_oid#778863 AS COL_26FEC51F_8DB9_47B1_B696_EADEAAB4CB21#780819, cr_flordo#778864 AS COL_0C13A3BC_6875_419D_879A_2A62C23213C5#780820, cr_idcda#778865 AS COL_6BA67D61_3D1A_4D83_B3F0_5B5774671216#780821, cr_fltr#778866 AS COL_3E564F6F_F1E0_4CBB_9C50_4D06C1838AB4#780822, str_create(Cab_B) AS COL_4D5E0228_2377_4432_B9A4_2D16E56FB956#780823]
Input [108]: [cr_numcr#778759, cr_numdos#778760, cr_nomdic#778761, cr_numdem#778762, cr_numexa#778763, cr_typdoc#778764, cr_prior#778765, cr_nomdcr#778766, cr_taidcr#778767, cr_durdcr#778768, cr_posdcr#778769, cr_nomdos#778770, cr_for_cr#778771, cr_cr#778772, cr_statdic#778773, cr_statsm#778774, cr_statcr#778775, cr_coddic#778776, cr_context#778777, cr_datdic#778778, cr_heudic#778779, cr_heui_d#778780, cr_heui_f#778781, cr_codsec#778782, cr_datsec#778783, cr_heusec#778784, cr_codvcr#778785, cr_datvcr#778786, cr_heuvcr#778787, cr_coddcr#778788, cr_datdcr#778789, cr_heudcr#778790, cr_dat_eff_d#778791, cr_dat_eff_w#778792, cr_coduti#778793, cr_datmaj#778794, cr_codsit#778795, cr_sectra#778796, cr_typcr#778797, cr_codsup#778798, cr_nivvcr#778799, cr_numvcr#778800, cr_nb_cor#778801, cr_datsup#778802, cr_heusup#778803, cr_flarch#778804, cr_staext#778805, cr_flimpr#778806, cr_lockcr#778807, cr_codmcr#778808, cr_datmcr#778809, cr_heumcr#778810, cr_codacc#778811, cr_motpas#778812, cr_libco#778813, cr_subdic#778814, cr_subdir#778815, cr_numprt#778816, cr_sta_env_prt#778817, cr_sta_ret_pro#778818, cr_sta_env_fra#778819, cr_sta_ret_fra#778820, cr_codcli#778821, cr_pri_dic#778822, cr_dat_dic_tra#778823, cr_heu_dic_tra#778824, cr_codfra#778825, cr_secext#778826, cr_statut_ext#778827, cr_simp_job_id#778828, cr_dat_cr_int#778829, cr_heu_cr_int#778830, cr_delai_total#778831, cr_nb_ligne_ext#778832, cr_nb_car_ext#778833, cr_nomext#778834, cr_subext#778835, cr_fltbdi#778836, cr_typdic#778837, cr_sta_env_ack#778838, cr_sta_ret_ack#778839, cr_taille_dic#778840, cr_chksum_dic#778841, cr_datmail#778842, cr_heumail#778843, cr_codmail#778844, cr_stadmp#778845, cr_coddmp#778846, cr_datdmp#778847, cr_heudmp#778848, cr_oiddmp#778849, cr_visdmp#778850, cr_scnpat#778851, cr_datscn#778852, cr_nummcr#778853, cr_numcr_cloud#778854, cr_numdrv#778855, cr_flarch_d#778856, cr_refext#778857, cr_annonce#778858, cr_periph#778859, cr_datcre#778860, cr_heucre#778861, cr_origine#778862, cr_oid#778863, cr_flordo#778864, cr_idcda#778865, cr_fltr#778866]

(8) LocalLimit
Input [109]: [COL_A5FD2FFB_EA2D_41C1_B705_A25C6D05B881#780715, COL_64D04F29_71AD_4640_AE57_436271A40AAD#780716, COL_07C23FC6_64AF_4416_A9DA_3B743B210524#780717, COL_2FC30DFB_98B9_4BE0_B7DC_9F13599A65BA#780718, COL_A04C8A18_E8B3_4BF7_8A7A_1EDA5C5F9DF0#780719, COL_299D9BA0_8FA2_42EA_8F2D_D78E8CBFD81B#780720, COL_5A2C34D4_7E98_4346_8C97_158E6F48FE49#780721, COL_7282BF09_129C_40F9_8EE4_EEC60F93AFAE#780722, COL_8A6EB039_CA89_4B16_8197_682903EF7C1C#780723, COL_C9DE7F48_376F_41F6_97A8_CD5FB8FA9B58#780724, COL_D8A27729_C788_4130_A480_984B888D85D8#780725, COL_6192AFD2_0418_40A2_9842_897148E1D9BC#780726, COL_74C447AE_C67B_4743_B5A4_E214C520D341#780727, COL_AFF38E06_FEE0_45CA_B340_F7E760AB1936#780728, COL_5FCDAEB6_03F2_4001_80EE_0354905769B3#780729, COL_A92BBADE_4785_479D_BD34_7EB44808C644#780730, COL_73339033_5C81_431B_930C_0965557C512B#780731, COL_86007AE7_37F7_48B3_A21D_A524E3A64B02#780732, COL_8DA45796_0796_4CB5_ADB4_A31D1EDAA108#780733, COL_30606282_BB39_4DFE_98AA_AF17AB383066#780734, COL_922AF799_656F_43C0_B28E_F0FF0CC804EE#780735, COL_A76288E8_5FC6_470E_8A0A_C1960DE77146#780736, COL_55380C47_11F0_4716_B1D5_AB1ED3C6CB4B#780737, COL_405ACAA7_292F_4054_890E_4403B60A6036#780738, COL_86B35698_98C1_4027_87BE_466D67154CDA#780739, COL_91C4030F_5CA8_48E5_BCAF_EA04AC1FA569#780740, COL_B5D55717_D6DB_4DAF_B78C_DB3CDC08A17C#780741, COL_DD7BBCA2_E42A_4242_88E7_9EC6E011777D#780742, COL_1735EFC6_9C31_4AEF_A1A4_2FF13C802677#780743, COL_862857FB_7601_4431_955A_97FA0550C6D6#780744, COL_355E32CA_5732_428C_BEA2_F818BE32AE3D#780745, COL_2446CFE1_B149_43E0_9C0C_F256AEFC695C#780746, COL_412B6464_0C35_4ABB_92DF_61911E810730#780747, COL_ACD02CA3_5ACE_48DC_B11D_965FC838ED96#780748, COL_6C0F3495_A333_43AD_8AB8_E978F9C7778C#780749, COL_8DC59167_BBA8_48EE_98A9_CBA38F177650#780750, COL_DE5A4824_3468_45D3_8F5C_3F99D2ECE803#780751, COL_1430D520_EE19_4CA1_80B4_CF08F024E8E0#780752, COL_5387F313_148A_48EB_8773_9B807072D4AB#780753, COL_50CD5E9E_CAFC_4BC2_A7F5_37A096483BC7#780754, COL_A0E3A34E_6F81_4CF1_A2B9_07D0205D468F#780755, COL_B6BD65F9_21EB_46C8_8516_4280AC0C9C30#780756, COL_3C1C3CF4_564D_4576_80D4_0F9C0B871D35#780757, COL_1037DE0B_2D1B_48DF_A102_90E9AA2907E0#780758, COL_081DDC6D_4F46_436E_A979_A4139933C55C#780759, COL_178997CE_26BE_48DB_9DED_0DE2D691D042#780760, COL_9B243761_415C_4333_86E0_3DC141222B9B#780761, COL_45D24D4B_F594_45B4_BC94_7EFA7C022E62#780762, COL_A6849D0F_B22A_428B_8C5F_73328DA3324C#780763, COL_4877DEB4_F2F4_476F_AF1A_39F7FF1CFB06#780764, COL_02210589_99C4_4D2F_9331_52C4E5471205#780765, COL_5BD74E13_12D3_47C5_A2AE_F7CBB2F4603C#780766, COL_C399C620_26B9_4132_9F75_005D9C151882#780767, COL_F804C358_A682_4AE6_98F6_8C32159CFEC8#780768, COL_DBA477C2_41F6_4A73_8E74_83F0D603CD62#780769, COL_6A9BAEFA_2A93_4DD3_ADDD_4F704B95B2CC#780770, COL_E348C9EF_9E21_43BE_9A10_A72269002495#780771, COL_0D18CD1D_2D68_4BC2_9EE8_B6625C66D80B#780772, COL_12942E95_D007_4822_8694_EE91406418E2#780773, COL_EAD711A3_8FBD_4B92_BBD9_35E85D9021F1#780774, COL_AE73DCBC_E4C2_4B8B_A88C_79238BCBCE07#780775, COL_E89D2C97_24F7_4277_B1B1_06FD84CC1403#780776, COL_A6C40E7B_11AE_4358_ABEE_0BCAFF0B5693#780777, COL_BA70D3E1_5364_486C_8871_37A97AAB9CF7#780778, COL_7710260B_5254_4719_942C_B867E93D30FD#780779, COL_8B8F51D6_81A3_4449_9128_3A01CBC5D67F#780780, COL_A57AEB8B_29AD_45B4_8640_F677F708060B#780781, COL_D5BC3694_92C8_4C34_A30C_FC9512290844#780782, COL_28F1ED04_927D_43E2_8FFD_9B5BDC0D1BB9#780783, COL_984A491F_66D2_44C6_8E6C_EA97D39CDF7F#780784, COL_A40A33DE_EE0D_45FD_BDF1_C2F9F392AA2D#780785, COL_EA5FEFD5_3E07_4EC6_92B5_54F51F5D3865#780786, COL_C258C2EB_5D23_49E3_BCB4_707C97E80AAC#780787, COL_8CB35AC2_28FD_451A_936A_FCD3F3CD254F#780788, COL_2E32BEA0_3B93_4179_B4A5_29B45582BBA9#780789, COL_CDDF1F93_D091_47A6_B45F_03654730D0F8#780790, COL_AD06E124_EC8A_49F2_B806_73F06FACCFF7#780791, COL_36983E73_F6B6_4C4D_8AEA_B2D8017C29E5#780792, COL_5767C590_C029_475C_BBFB_CD87DC6C345F#780793, COL_EF424C7F_3AC0_4EF1_A32D_8C9D99FA4AA1#780794, COL_4E03A5FD_83D1_42C2_AA7D_74E85A717A38#780795, COL_6A65B1A2_E62E_4992_8693_EBFC3B3FDA68#780796, COL_05DDCC74_2100_4549_A82B_528EE1835140#780797, COL_60D8A30D_6D91_4996_AEA7_8C3153D621A1#780798, COL_BAABA3B3_B141_4DEB_A0FE_37598B14464B#780799, COL_269191BA_16C3_438F_9E0F_9CF29A900ADF#780800, COL_0125E55E_CBD7_43A5_A980_270750CB5E96#780801, COL_E7419800_128E_4276_8987_AE143B149447#780802, COL_814B008F_DDCA_47C2_B2E0_EF793DDFE5FD#780803, COL_58D4E267_7D6C_415A_96DA_788BFB9DBA60#780804, COL_F3E6DA0E_7FDB_408F_BFD5_54A72312104D#780805, COL_8D7B7DDC_1A29_4F9C_9D1D_83E50DD1BC0C#780806, COL_8E4F3101_3D34_48F8_9C19_57AD706903BF#780807, COL_E52E826F_E6FC_41A7_AFEB_A0C4AF687C52#780808, COL_EE8068D9_774B_4B3D_99D8_AF2025E7AED3#780809, COL_41D295F3_CD48_4188_AD1C_CB5E42197E47#780810, COL_F2F926AE_EF0B_420A_BBEC_575535DA4BD4#780811, COL_16788A89_623A_4650_84BC_3EAB0EE9F4CD#780812, COL_A82D6ED3_B7B3_42E3_8893_625D1D14FB25#780813, COL_E5CF0353_B6F4_4345_978B_AFF6237B0D74#780814, COL_BCAAC178_531E_4DFC_ABF3_10C5E2BEEAE0#780815, COL_746684AF_3E9A_4296_BA22_3E9C8A0567DF#780816, COL_ECC81622_553B_4B71_A2FD_E33A7FD7E445#780817, COL_A1263368_5404_419C_B22B_C77308902308#780818, COL_26FEC51F_8DB9_47B1_B696_EADEAAB4CB21#780819, COL_0C13A3BC_6875_419D_879A_2A62C23213C5#780820, COL_6BA67D61_3D1A_4D83_B3F0_5B5774671216#780821, COL_3E564F6F_F1E0_4CBB_9C50_4D06C1838AB4#780822, COL_4D5E0228_2377_4432_B9A4_2D16E56FB956#780823]
Arguments: 1500

(9) Union

(10) CollectLimit
Input [109]: [COL_A5FD2FFB_EA2D_41C1_B705_A25C6D05B881#780388, COL_64D04F29_71AD_4640_AE57_436271A40AAD#780389, COL_07C23FC6_64AF_4416_A9DA_3B743B210524#780390, COL_2FC30DFB_98B9_4BE0_B7DC_9F13599A65BA#780391, COL_A04C8A18_E8B3_4BF7_8A7A_1EDA5C5F9DF0#780392, COL_299D9BA0_8FA2_42EA_8F2D_D78E8CBFD81B#780393, COL_5A2C34D4_7E98_4346_8C97_158E6F48FE49#780394, COL_7282BF09_129C_40F9_8EE4_EEC60F93AFAE#780395, COL_8A6EB039_CA89_4B16_8197_682903EF7C1C#780396, COL_C9DE7F48_376F_41F6_97A8_CD5FB8FA9B58#780397, COL_D8A27729_C788_4130_A480_984B888D85D8#780398, COL_6192AFD2_0418_40A2_9842_897148E1D9BC#780399, COL_74C447AE_C67B_4743_B5A4_E214C520D341#780400, COL_AFF38E06_FEE0_45CA_B340_F7E760AB1936#780401, COL_5FCDAEB6_03F2_4001_80EE_0354905769B3#780402, COL_A92BBADE_4785_479D_BD34_7EB44808C644#780403, COL_73339033_5C81_431B_930C_0965557C512B#780404, COL_86007AE7_37F7_48B3_A21D_A524E3A64B02#780405, COL_8DA45796_0796_4CB5_ADB4_A31D1EDAA108#780406, COL_30606282_BB39_4DFE_98AA_AF17AB383066#780407, COL_922AF799_656F_43C0_B28E_F0FF0CC804EE#780408, COL_A76288E8_5FC6_470E_8A0A_C1960DE77146#780409, COL_55380C47_11F0_4716_B1D5_AB1ED3C6CB4B#780410, COL_405ACAA7_292F_4054_890E_4403B60A6036#780411, COL_86B35698_98C1_4027_87BE_466D67154CDA#780412, COL_91C4030F_5CA8_48E5_BCAF_EA04AC1FA569#780413, COL_B5D55717_D6DB_4DAF_B78C_DB3CDC08A17C#780414, COL_DD7BBCA2_E42A_4242_88E7_9EC6E011777D#780415, COL_1735EFC6_9C31_4AEF_A1A4_2FF13C802677#780416, COL_862857FB_7601_4431_955A_97FA0550C6D6#780417, COL_355E32CA_5732_428C_BEA2_F818BE32AE3D#780418, COL_2446CFE1_B149_43E0_9C0C_F256AEFC695C#780419, COL_412B6464_0C35_4ABB_92DF_61911E810730#780420, COL_ACD02CA3_5ACE_48DC_B11D_965FC838ED96#780421, COL_6C0F3495_A333_43AD_8AB8_E978F9C7778C#780422, COL_8DC59167_BBA8_48EE_98A9_CBA38F177650#780423, COL_DE5A4824_3468_45D3_8F5C_3F99D2ECE803#780424, COL_1430D520_EE19_4CA1_80B4_CF08F024E8E0#780425, COL_5387F313_148A_48EB_8773_9B807072D4AB#780426, COL_50CD5E9E_CAFC_4BC2_A7F5_37A096483BC7#780427, COL_A0E3A34E_6F81_4CF1_A2B9_07D0205D468F#780428, COL_B6BD65F9_21EB_46C8_8516_4280AC0C9C30#780429, COL_3C1C3CF4_564D_4576_80D4_0F9C0B871D35#780430, COL_1037DE0B_2D1B_48DF_A102_90E9AA2907E0#780431, COL_081DDC6D_4F46_436E_A979_A4139933C55C#780432, COL_178997CE_26BE_48DB_9DED_0DE2D691D042#780433, COL_9B243761_415C_4333_86E0_3DC141222B9B#780434, COL_45D24D4B_F594_45B4_BC94_7EFA7C022E62#780435, COL_A6849D0F_B22A_428B_8C5F_73328DA3324C#780436, COL_4877DEB4_F2F4_476F_AF1A_39F7FF1CFB06#780437, COL_02210589_99C4_4D2F_9331_52C4E5471205#780438, COL_5BD74E13_12D3_47C5_A2AE_F7CBB2F4603C#780439, COL_C399C620_26B9_4132_9F75_005D9C151882#780440, COL_F804C358_A682_4AE6_98F6_8C32159CFEC8#780441, COL_DBA477C2_41F6_4A73_8E74_83F0D603CD62#780442, COL_6A9BAEFA_2A93_4DD3_ADDD_4F704B95B2CC#780443, COL_E348C9EF_9E21_43BE_9A10_A72269002495#780444, COL_0D18CD1D_2D68_4BC2_9EE8_B6625C66D80B#780445, COL_12942E95_D007_4822_8694_EE91406418E2#780446, COL_EAD711A3_8FBD_4B92_BBD9_35E85D9021F1#780447, COL_AE73DCBC_E4C2_4B8B_A88C_79238BCBCE07#780448, COL_E89D2C97_24F7_4277_B1B1_06FD84CC1403#780449, COL_A6C40E7B_11AE_4358_ABEE_0BCAFF0B5693#780450, COL_BA70D3E1_5364_486C_8871_37A97AAB9CF7#780451, COL_7710260B_5254_4719_942C_B867E93D30FD#780452, COL_8B8F51D6_81A3_4449_9128_3A01CBC5D67F#780453, COL_A57AEB8B_29AD_45B4_8640_F677F708060B#780454, COL_D5BC3694_92C8_4C34_A30C_FC9512290844#780455, COL_28F1ED04_927D_43E2_8FFD_9B5BDC0D1BB9#780456, COL_984A491F_66D2_44C6_8E6C_EA97D39CDF7F#780457, COL_A40A33DE_EE0D_45FD_BDF1_C2F9F392AA2D#780458, COL_EA5FEFD5_3E07_4EC6_92B5_54F51F5D3865#780459, COL_C258C2EB_5D23_49E3_BCB4_707C97E80AAC#780460, COL_8CB35AC2_28FD_451A_936A_FCD3F3CD254F#780461, COL_2E32BEA0_3B93_4179_B4A5_29B45582BBA9#780462, COL_CDDF1F93_D091_47A6_B45F_03654730D0F8#780463, COL_AD06E124_EC8A_49F2_B806_73F06FACCFF7#780464, COL_36983E73_F6B6_4C4D_8AEA_B2D8017C29E5#780465, COL_5767C590_C029_475C_BBFB_CD87DC6C345F#780466, COL_EF424C7F_3AC0_4EF1_A32D_8C9D99FA4AA1#780467, COL_4E03A5FD_83D1_42C2_AA7D_74E85A717A38#780468, COL_6A65B1A2_E62E_4992_8693_EBFC3B3FDA68#780469, COL_05DDCC74_2100_4549_A82B_528EE1835140#780470, COL_60D8A30D_6D91_4996_AEA7_8C3153D621A1#780471, COL_BAABA3B3_B141_4DEB_A0FE_37598B14464B#780472, COL_269191BA_16C3_438F_9E0F_9CF29A900ADF#780473, COL_0125E55E_CBD7_43A5_A980_270750CB5E96#780474, COL_E7419800_128E_4276_8987_AE143B149447#780475, COL_814B008F_DDCA_47C2_B2E0_EF793DDFE5FD#780476, COL_58D4E267_7D6C_415A_96DA_788BFB9DBA60#780477, COL_F3E6DA0E_7FDB_408F_BFD5_54A72312104D#780478, COL_8D7B7DDC_1A29_4F9C_9D1D_83E50DD1BC0C#780479, COL_8E4F3101_3D34_48F8_9C19_57AD706903BF#780480, COL_E52E826F_E6FC_41A7_AFEB_A0C4AF687C52#780481, COL_EE8068D9_774B_4B3D_99D8_AF2025E7AED3#780482, COL_41D295F3_CD48_4188_AD1C_CB5E42197E47#780483, COL_F2F926AE_EF0B_420A_BBEC_575535DA4BD4#780484, COL_16788A89_623A_4650_84BC_3EAB0EE9F4CD#780485, COL_A82D6ED3_B7B3_42E3_8893_625D1D14FB25#780486, COL_E5CF0353_B6F4_4345_978B_AFF6237B0D74#780487, COL_BCAAC178_531E_4DFC_ABF3_10C5E2BEEAE0#780488, COL_746684AF_3E9A_4296_BA22_3E9C8A0567DF#780489, COL_ECC81622_553B_4B71_A2FD_E33A7FD7E445#780490, COL_A1263368_5404_419C_B22B_C77308902308#780491, COL_26FEC51F_8DB9_47B1_B696_EADEAAB4CB21#780492, COL_0C13A3BC_6875_419D_879A_2A62C23213C5#780493, COL_6BA67D61_3D1A_4D83_B3F0_5B5774671216#780494, COL_3E564F6F_F1E0_4CBB_9C50_4D06C1838AB4#780495, COL_4D5E0228_2377_4432_B9A4_2D16E56FB956#780496]
Arguments: 1500

SQL / DataFrame Properties

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