== Physical Plan ==
Execute CreateViewCommand (1)
+- CreateViewCommand (2)
+- Project (14)
+- Union (13)
:- Project (7)
: +- Project (6)
: +- Project (5)
: +- Project (4)
: +- LogicalRelation (3)
+- Project (12)
+- Project (11)
+- Project (10)
+- Project (9)
+- LogicalRelation (8)
(1) Execute CreateViewCommand
Output: []
(2) CreateViewCommand
Arguments: `H_CR_43732491`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: JDBCRelation((SELECT "cr_numcr", "cr_numdos", "cr_nomdic", "cr_numdem", "cr_numexa", "cr_typdoc", "cr_prior", "cr_nomdcr", "cr_taidcr", "cr_durdcr", "cr_posdcr", "cr_nomdos", "cr_for_cr", "cr_cr", "cr_statdic", "cr_statsm", "cr_statcr", "cr_coddic", "cr_context", "cr_datdic", "cr_heudic", "cr_heui_d", "cr_heui_f", "cr_codsec", "cr_datsec", "cr_heusec", "cr_codvcr", "cr_datvcr", "cr_heuvcr", "cr_coddcr", "cr_datdcr", "cr_heudcr", "cr_dat_eff_d", "cr_dat_eff_w", "cr_coduti", "cr_datmaj", "cr_codsit", "cr_sectra", "cr_typcr", "cr_codsup", "cr_nivvcr", "cr_numvcr", "cr_nb_cor", "cr_datsup", "cr_heusup", "cr_flarch", "cr_staext", "cr_flimpr", "cr_lockcr", "cr_codmcr", "cr_datmcr", "cr_heumcr", "cr_codacc", "cr_motpas", "cr_libco", "cr_subdic", "cr_subdir", "cr_numprt", "cr_sta_env_prt", "cr_sta_ret_pro", "cr_sta_env_fra", "cr_sta_ret_fra", "cr_codcli", "cr_pri_dic", "cr_dat_dic_tra", "cr_heu_dic_tra", "cr_codfra", "cr_secext", "cr_statut_ext", "cr_simp_job_id", "cr_dat_cr_int", "cr_heu_cr_int", "cr_delai_total", "cr_nb_ligne_ext", "cr_nb_car_ext", "cr_nomext", "cr_subext", "cr_fltbdi", "cr_typdic", "cr_sta_env_ack", "cr_sta_ret_ack", "cr_taille_dic", "cr_chksum_dic", "cr_datmail", "cr_heumail", "cr_codmail", "cr_stadmp", "cr_coddmp", "cr_datdmp", "cr_heudmp", "cr_oiddmp", "cr_visdmp", "cr_scnpat", "cr_datscn", "cr_nummcr", "cr_numcr_cloud", "cr_numdrv", "cr_flarch_d", "cr_refext", "cr_annonce", "cr_periph", "cr_datcre", "cr_heucre", "cr_origine", "cr_oid", "cr_flordo", "cr_idcda", "cr_fltr" FROM "xplore"."h_cr") as x) [numPartitions=1], [cr_numcr#774739, cr_numdos#774740, cr_nomdic#774741, cr_numdem#774742, cr_numexa#774743, cr_typdoc#774744, cr_prior#774745, cr_nomdcr#774746, cr_taidcr#774747, cr_durdcr#774748, cr_posdcr#774749, cr_nomdos#774750, cr_for_cr#774751, cr_cr#774752, cr_statdic#774753, cr_statsm#774754, cr_statcr#774755, cr_coddic#774756, cr_context#774757, cr_datdic#774758, cr_heudic#774759, cr_heui_d#774760, cr_heui_f#774761, cr_codsec#774762, ... 84 more fields], false
(4) Project
Arguments: [cr_numcr#774739 AS COLL0#774955, cr_numdos#774740 AS COLL1#774956, cr_nomdic#774741 AS COLL2#774957, cr_numdem#774742 AS COLL3#774958, cr_numexa#774743 AS COLL4#774959, cr_typdoc#774744 AS COLL5#774960, cr_prior#774745 AS COLL6#774961, cr_nomdcr#774746 AS COLL7#774962, cr_taidcr#774747 AS COLL8#774963, cr_durdcr#774748 AS COLL9#774964, cr_posdcr#774749 AS COLL10#774965, cr_nomdos#774750 AS COLL11#774966, cr_for_cr#774751 AS COLL12#774967, cr_cr#774752 AS COLL13#774968, cr_statdic#774753 AS COLL14#774969, cr_statsm#774754 AS COLL15#774970, cr_statcr#774755 AS COLL16#774971, cr_coddic#774756 AS COLL17#774972, cr_context#774757 AS COLL18#774973, cr_datdic#774758 AS COLL19#774974, cr_heudic#774759 AS COLL20#774975, cr_heui_d#774760 AS COLL21#774976, cr_heui_f#774761 AS COLL22#774977, cr_codsec#774762 AS COLL23#774978, ... 84 more fields]
(5) Project
Arguments: [COLL0#774955 AS COLL0#775171, COLL1#774956 AS COLL1#775172, COLL2#774957 AS COLL2#775173, COLL3#774958 AS COLL3#775174, COLL4#774959 AS COLL4#775175, COLL5#774960 AS COLL5#775176, COLL6#774961 AS COLL6#775177, COLL7#774962 AS COLL7#775178, COLL8#774963 AS COLL8#775179, COLL9#774964 AS COLL9#775180, COLL10#774965 AS COLL10#775181, COLL11#774966 AS COLL11#775182, COLL12#774967 AS COLL12#775183, COLL13#774968 AS COLL13#775184, COLL14#774969 AS COLL14#775185, COLL15#774970 AS COLL15#775186, COLL16#774971 AS COLL16#775187, COLL17#774972 AS COLL17#775188, COLL18#774973 AS COLL18#775189, COLL19#774974 AS COLL19#775190, COLL20#774975 AS COLL20#775191, COLL21#774976 AS COLL21#775192, COLL22#774977 AS COLL22#775193, COLL23#774978 AS COLL23#775194, ... 84 more fields]
(6) Project
Arguments: [COLL0#775171, COLL1#775172, COLL2#775173, COLL3#775174, COLL4#775175, COLL5#775176, COLL6#775177, COLL7#775178, COLL8#775179, COLL9#775180, COLL10#775181, COLL11#775182, COLL12#775183, COLL13#775184, COLL14#775185, COLL15#775186, COLL16#775187, COLL17#775188, COLL18#775189, COLL19#775190, COLL20#775191, COLL21#775192, COLL22#775193, COLL23#775194, ... 84 more fields]
(7) Project
Arguments: [COLL99#775270 AS CR_ANNONCE_437424#775495, COLL82#775253 AS CR_CHKSUM_DIC_437407#775496, COLL52#775223 AS CR_CODACC_437377#775497, COLL62#775233 AS CR_CODCLI_437387#775498, COLL29#775200 AS CR_CODDCR_437354#775499, COLL17#775188 AS CR_CODDIC_437342#775500, COLL87#775258 AS CR_CODDMP_437412#775501, COLL66#775237 AS CR_CODFRA_437391#775502, COLL85#775256 AS CR_CODMAIL_437410#775503, COLL49#775220 AS CR_CODMCR_437374#775504, COLL23#775194 AS CR_CODSEC_437348#775505, COLL36#775207 AS CR_CODSIT_437361#775506, COLL39#775210 AS CR_CODSUP_437364#775507, COLL34#775205 AS CR_CODUTI_437359#775508, COLL26#775197 AS CR_CODVCR_437351#775509, COLL18#775189 AS CR_CONTEXT_437343#775510, COLL13#775184 AS CR_CR_437338#775511, COLL101#775272 AS CR_DATCRE_437426#775512, COLL30#775201 AS CR_DATDCR_437355#775513, COLL19#775190 AS CR_DATDIC_437344#775514, COLL88#775259 AS CR_DATDMP_437413#775515, COLL83#775254 AS CR_DATMAIL_437408#775516, COLL35#775206 AS CR_DATMAJ_437360#775517, COLL50#775221 AS CR_DATMCR_437375#775518, ... 85 more fields]
(8) LogicalRelation
Arguments: JDBCRelation((SELECT "cr_numcr", "cr_numdos", "cr_nomdic", "cr_numdem", "cr_numexa", "cr_typdoc", "cr_prior", "cr_nomdcr", "cr_taidcr", "cr_durdcr", "cr_posdcr", "cr_nomdos", "cr_for_cr", "cr_cr", "cr_statdic", "cr_statsm", "cr_statcr", "cr_coddic", "cr_context", "cr_datdic", "cr_heudic", "cr_heui_d", "cr_heui_f", "cr_codsec", "cr_datsec", "cr_heusec", "cr_codvcr", "cr_datvcr", "cr_heuvcr", "cr_coddcr", "cr_datdcr", "cr_heudcr", "cr_dat_eff_d", "cr_dat_eff_w", "cr_coduti", "cr_datmaj", "cr_codsit", "cr_sectra", "cr_typcr", "cr_codsup", "cr_nivvcr", "cr_numvcr", "cr_nb_cor", "cr_datsup", "cr_heusup", "cr_flarch", "cr_staext", "cr_flimpr", "cr_lockcr", "cr_codmcr", "cr_datmcr", "cr_heumcr", "cr_codacc", "cr_motpas", "cr_libco", "cr_subdic", "cr_subdir", "cr_numprt", "cr_sta_env_prt", "cr_sta_ret_pro", "cr_sta_env_fra", "cr_sta_ret_fra", "cr_codcli", "cr_pri_dic", "cr_dat_dic_tra", "cr_heu_dic_tra", "cr_codfra", "cr_secext", "cr_statut_ext", "cr_simp_job_id", "cr_dat_cr_int", "cr_heu_cr_int", "cr_delai_total", "cr_nb_ligne_ext", "cr_nb_car_ext", "cr_nomext", "cr_subext", "cr_fltbdi", "cr_typdic", "cr_sta_env_ack", "cr_sta_ret_ack", "cr_taille_dic", "cr_chksum_dic", "cr_datmail", "cr_heumail", "cr_codmail", "cr_stadmp", "cr_coddmp", "cr_datdmp", "cr_heudmp", "cr_oiddmp", "cr_visdmp", "cr_scnpat", "cr_datscn", "cr_nummcr", "cr_numcr_cloud", "cr_numdrv", "cr_flarch_d", "cr_refext", "cr_annonce", "cr_periph", "cr_datcre", "cr_heucre", "cr_origine", "cr_oid", "cr_flordo", "cr_idcda", "cr_fltr" FROM "xplore2"."h_cr") as x) [numPartitions=1], [cr_numcr#775714, cr_numdos#775715, cr_nomdic#775716, cr_numdem#775717, cr_numexa#775718, cr_typdoc#775719, cr_prior#775720, cr_nomdcr#775721, cr_taidcr#775722, cr_durdcr#775723, cr_posdcr#775724, cr_nomdos#775725, cr_for_cr#775726, cr_cr#775727, cr_statdic#775728, cr_statsm#775729, cr_statcr#775730, cr_coddic#775731, cr_context#775732, cr_datdic#775733, cr_heudic#775734, cr_heui_d#775735, cr_heui_f#775736, cr_codsec#775737, ... 84 more fields], false
(9) Project
Arguments: [cr_numcr#775714 AS COLL0#775930, cr_numdos#775715 AS COLL1#775931, cr_nomdic#775716 AS COLL2#775932, cr_numdem#775717 AS COLL3#775933, cr_numexa#775718 AS COLL4#775934, cr_typdoc#775719 AS COLL5#775935, cr_prior#775720 AS COLL6#775936, cr_nomdcr#775721 AS COLL7#775937, cr_taidcr#775722 AS COLL8#775938, cr_durdcr#775723 AS COLL9#775939, cr_posdcr#775724 AS COLL10#775940, cr_nomdos#775725 AS COLL11#775941, cr_for_cr#775726 AS COLL12#775942, cr_cr#775727 AS COLL13#775943, cr_statdic#775728 AS COLL14#775944, cr_statsm#775729 AS COLL15#775945, cr_statcr#775730 AS COLL16#775946, cr_coddic#775731 AS COLL17#775947, cr_context#775732 AS COLL18#775948, cr_datdic#775733 AS COLL19#775949, cr_heudic#775734 AS COLL20#775950, cr_heui_d#775735 AS COLL21#775951, cr_heui_f#775736 AS COLL22#775952, cr_codsec#775737 AS COLL23#775953, ... 84 more fields]
(10) Project
Arguments: [COLL0#775930 AS COLL0#776146, COLL1#775931 AS COLL1#776147, COLL2#775932 AS COLL2#776148, COLL3#775933 AS COLL3#776149, COLL4#775934 AS COLL4#776150, COLL5#775935 AS COLL5#776151, COLL6#775936 AS COLL6#776152, COLL7#775937 AS COLL7#776153, COLL8#775938 AS COLL8#776154, COLL9#775939 AS COLL9#776155, COLL10#775940 AS COLL10#776156, COLL11#775941 AS COLL11#776157, COLL12#775942 AS COLL12#776158, COLL13#775943 AS COLL13#776159, COLL14#775944 AS COLL14#776160, COLL15#775945 AS COLL15#776161, COLL16#775946 AS COLL16#776162, COLL17#775947 AS COLL17#776163, COLL18#775948 AS COLL18#776164, COLL19#775949 AS COLL19#776165, COLL20#775950 AS COLL20#776166, COLL21#775951 AS COLL21#776167, COLL22#775952 AS COLL22#776168, COLL23#775953 AS COLL23#776169, ... 84 more fields]
(11) Project
Arguments: [COLL0#776146, COLL1#776147, COLL2#776148, COLL3#776149, COLL4#776150, COLL5#776151, COLL6#776152, COLL7#776153, COLL8#776154, COLL9#776155, COLL10#776156, COLL11#776157, COLL12#776158, COLL13#776159, COLL14#776160, COLL15#776161, COLL16#776162, COLL17#776163, COLL18#776164, COLL19#776165, COLL20#776166, COLL21#776167, COLL22#776168, COLL23#776169, ... 84 more fields]
(12) Project
Arguments: [COLL99#776245 AS CR_ANNONCE_437424#776470, COLL82#776228 AS CR_CHKSUM_DIC_437407#776471, COLL52#776198 AS CR_CODACC_437377#776472, COLL62#776208 AS CR_CODCLI_437387#776473, COLL29#776175 AS CR_CODDCR_437354#776474, COLL17#776163 AS CR_CODDIC_437342#776475, COLL87#776233 AS CR_CODDMP_437412#776476, COLL66#776212 AS CR_CODFRA_437391#776477, COLL85#776231 AS CR_CODMAIL_437410#776478, COLL49#776195 AS CR_CODMCR_437374#776479, COLL23#776169 AS CR_CODSEC_437348#776480, COLL36#776182 AS CR_CODSIT_437361#776481, COLL39#776185 AS CR_CODSUP_437364#776482, COLL34#776180 AS CR_CODUTI_437359#776483, COLL26#776172 AS CR_CODVCR_437351#776484, COLL18#776164 AS CR_CONTEXT_437343#776485, COLL13#776159 AS CR_CR_437338#776486, COLL101#776247 AS CR_DATCRE_437426#776487, COLL30#776176 AS CR_DATDCR_437355#776488, COLL19#776165 AS CR_DATDIC_437344#776489, COLL88#776234 AS CR_DATDMP_437413#776490, COLL83#776229 AS CR_DATMAIL_437408#776491, COLL35#776181 AS CR_DATMAJ_437360#776492, COLL50#776196 AS CR_DATMCR_437375#776493, ... 85 more fields]
(13) Union
Arguments: false, false
(14) Project
Arguments: [CR_ANNONCE_437424#775495, CR_CHKSUM_DIC_437407#775496, CR_CODACC_437377#775497, CR_CODCLI_437387#775498, CR_CODDCR_437354#775499, CR_CODDIC_437342#775500, CR_CODDMP_437412#775501, CR_CODFRA_437391#775502, CR_CODMAIL_437410#775503, CR_CODMCR_437374#775504, CR_CODSEC_437348#775505, CR_CODSIT_437361#775506, CR_CODSUP_437364#775507, CR_CODUTI_437359#775508, CR_CODVCR_437351#775509, CR_CONTEXT_437343#775510, CR_CR_437338#775511, CR_DATCRE_437426#775512, CR_DATDCR_437355#775513, CR_DATDIC_437344#775514, CR_DATDMP_437413#775515, CR_DATMAIL_437408#775516, CR_DATMAJ_437360#775517, CR_DATMCR_437375#775518, ... 85 more fields]