== 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_43732490`, 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#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], false
(4) Project
Arguments: [cr_numcr#777784 AS COLL0#778000, cr_numdos#777785 AS COLL1#778001, cr_nomdic#777786 AS COLL2#778002, cr_numdem#777787 AS COLL3#778003, cr_numexa#777788 AS COLL4#778004, cr_typdoc#777789 AS COLL5#778005, cr_prior#777790 AS COLL6#778006, cr_nomdcr#777791 AS COLL7#778007, cr_taidcr#777792 AS COLL8#778008, cr_durdcr#777793 AS COLL9#778009, cr_posdcr#777794 AS COLL10#778010, cr_nomdos#777795 AS COLL11#778011, cr_for_cr#777796 AS COLL12#778012, cr_cr#777797 AS COLL13#778013, cr_statdic#777798 AS COLL14#778014, cr_statsm#777799 AS COLL15#778015, cr_statcr#777800 AS COLL16#778016, cr_coddic#777801 AS COLL17#778017, cr_context#777802 AS COLL18#778018, cr_datdic#777803 AS COLL19#778019, cr_heudic#777804 AS COLL20#778020, cr_heui_d#777805 AS COLL21#778021, cr_heui_f#777806 AS COLL22#778022, cr_codsec#777807 AS COLL23#778023, ... 84 more fields]
(5) Project
Arguments: [COLL0#778000 AS COLL0#778216, COLL1#778001 AS COLL1#778217, COLL2#778002 AS COLL2#778218, COLL3#778003 AS COLL3#778219, COLL4#778004 AS COLL4#778220, COLL5#778005 AS COLL5#778221, COLL6#778006 AS COLL6#778222, COLL7#778007 AS COLL7#778223, COLL8#778008 AS COLL8#778224, COLL9#778009 AS COLL9#778225, COLL10#778010 AS COLL10#778226, COLL11#778011 AS COLL11#778227, COLL12#778012 AS COLL12#778228, COLL13#778013 AS COLL13#778229, COLL14#778014 AS COLL14#778230, COLL15#778015 AS COLL15#778231, COLL16#778016 AS COLL16#778232, COLL17#778017 AS COLL17#778233, COLL18#778018 AS COLL18#778234, COLL19#778019 AS COLL19#778235, COLL20#778020 AS COLL20#778236, COLL21#778021 AS COLL21#778237, COLL22#778022 AS COLL22#778238, COLL23#778023 AS COLL23#778239, ... 84 more fields]
(6) Project
Arguments: [COLL0#778216, COLL1#778217, COLL2#778218, COLL3#778219, COLL4#778220, COLL5#778221, COLL6#778222, COLL7#778223, COLL8#778224, COLL9#778225, COLL10#778226, COLL11#778227, COLL12#778228, COLL13#778229, COLL14#778230, COLL15#778231, COLL16#778232, COLL17#778233, COLL18#778234, COLL19#778235, COLL20#778236, COLL21#778237, COLL22#778238, COLL23#778239, ... 84 more fields]
(7) Project
Arguments: [COLL99#778315 AS CR_ANNONCE_437424#778540, COLL82#778298 AS CR_CHKSUM_DIC_437407#778541, COLL52#778268 AS CR_CODACC_437377#778542, COLL62#778278 AS CR_CODCLI_437387#778543, COLL29#778245 AS CR_CODDCR_437354#778544, COLL17#778233 AS CR_CODDIC_437342#778545, COLL87#778303 AS CR_CODDMP_437412#778546, COLL66#778282 AS CR_CODFRA_437391#778547, COLL85#778301 AS CR_CODMAIL_437410#778548, COLL49#778265 AS CR_CODMCR_437374#778549, COLL23#778239 AS CR_CODSEC_437348#778550, COLL36#778252 AS CR_CODSIT_437361#778551, COLL39#778255 AS CR_CODSUP_437364#778552, COLL34#778250 AS CR_CODUTI_437359#778553, COLL26#778242 AS CR_CODVCR_437351#778554, COLL18#778234 AS CR_CONTEXT_437343#778555, COLL13#778229 AS CR_CR_437338#778556, COLL101#778317 AS CR_DATCRE_437426#778557, COLL30#778246 AS CR_DATDCR_437355#778558, COLL19#778235 AS CR_DATDIC_437344#778559, COLL88#778304 AS CR_DATDMP_437413#778560, COLL83#778299 AS CR_DATMAIL_437408#778561, COLL35#778251 AS CR_DATMAJ_437360#778562, COLL50#778266 AS CR_DATMCR_437375#778563, ... 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#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], false
(9) Project
Arguments: [cr_numcr#778759 AS COLL0#778975, cr_numdos#778760 AS COLL1#778976, cr_nomdic#778761 AS COLL2#778977, cr_numdem#778762 AS COLL3#778978, cr_numexa#778763 AS COLL4#778979, cr_typdoc#778764 AS COLL5#778980, cr_prior#778765 AS COLL6#778981, cr_nomdcr#778766 AS COLL7#778982, cr_taidcr#778767 AS COLL8#778983, cr_durdcr#778768 AS COLL9#778984, cr_posdcr#778769 AS COLL10#778985, cr_nomdos#778770 AS COLL11#778986, cr_for_cr#778771 AS COLL12#778987, cr_cr#778772 AS COLL13#778988, cr_statdic#778773 AS COLL14#778989, cr_statsm#778774 AS COLL15#778990, cr_statcr#778775 AS COLL16#778991, cr_coddic#778776 AS COLL17#778992, cr_context#778777 AS COLL18#778993, cr_datdic#778778 AS COLL19#778994, cr_heudic#778779 AS COLL20#778995, cr_heui_d#778780 AS COLL21#778996, cr_heui_f#778781 AS COLL22#778997, cr_codsec#778782 AS COLL23#778998, ... 84 more fields]
(10) Project
Arguments: [COLL0#778975 AS COLL0#779191, COLL1#778976 AS COLL1#779192, COLL2#778977 AS COLL2#779193, COLL3#778978 AS COLL3#779194, COLL4#778979 AS COLL4#779195, COLL5#778980 AS COLL5#779196, COLL6#778981 AS COLL6#779197, COLL7#778982 AS COLL7#779198, COLL8#778983 AS COLL8#779199, COLL9#778984 AS COLL9#779200, COLL10#778985 AS COLL10#779201, COLL11#778986 AS COLL11#779202, COLL12#778987 AS COLL12#779203, COLL13#778988 AS COLL13#779204, COLL14#778989 AS COLL14#779205, COLL15#778990 AS COLL15#779206, COLL16#778991 AS COLL16#779207, COLL17#778992 AS COLL17#779208, COLL18#778993 AS COLL18#779209, COLL19#778994 AS COLL19#779210, COLL20#778995 AS COLL20#779211, COLL21#778996 AS COLL21#779212, COLL22#778997 AS COLL22#779213, COLL23#778998 AS COLL23#779214, ... 84 more fields]
(11) Project
Arguments: [COLL0#779191, COLL1#779192, COLL2#779193, COLL3#779194, COLL4#779195, COLL5#779196, COLL6#779197, COLL7#779198, COLL8#779199, COLL9#779200, COLL10#779201, COLL11#779202, COLL12#779203, COLL13#779204, COLL14#779205, COLL15#779206, COLL16#779207, COLL17#779208, COLL18#779209, COLL19#779210, COLL20#779211, COLL21#779212, COLL22#779213, COLL23#779214, ... 84 more fields]
(12) Project
Arguments: [COLL99#779290 AS CR_ANNONCE_437424#779515, COLL82#779273 AS CR_CHKSUM_DIC_437407#779516, COLL52#779243 AS CR_CODACC_437377#779517, COLL62#779253 AS CR_CODCLI_437387#779518, COLL29#779220 AS CR_CODDCR_437354#779519, COLL17#779208 AS CR_CODDIC_437342#779520, COLL87#779278 AS CR_CODDMP_437412#779521, COLL66#779257 AS CR_CODFRA_437391#779522, COLL85#779276 AS CR_CODMAIL_437410#779523, COLL49#779240 AS CR_CODMCR_437374#779524, COLL23#779214 AS CR_CODSEC_437348#779525, COLL36#779227 AS CR_CODSIT_437361#779526, COLL39#779230 AS CR_CODSUP_437364#779527, COLL34#779225 AS CR_CODUTI_437359#779528, COLL26#779217 AS CR_CODVCR_437351#779529, COLL18#779209 AS CR_CONTEXT_437343#779530, COLL13#779204 AS CR_CR_437338#779531, COLL101#779292 AS CR_DATCRE_437426#779532, COLL30#779221 AS CR_DATDCR_437355#779533, COLL19#779210 AS CR_DATDIC_437344#779534, COLL88#779279 AS CR_DATDMP_437413#779535, COLL83#779274 AS CR_DATMAIL_437408#779536, COLL35#779226 AS CR_DATMAJ_437360#779537, COLL50#779241 AS CR_DATMCR_437375#779538, ... 85 more fields]
(13) Union
Arguments: false, false
(14) Project
Arguments: [CR_ANNONCE_437424#778540, CR_CHKSUM_DIC_437407#778541, CR_CODACC_437377#778542, CR_CODCLI_437387#778543, CR_CODDCR_437354#778544, CR_CODDIC_437342#778545, CR_CODDMP_437412#778546, CR_CODFRA_437391#778547, CR_CODMAIL_437410#778548, CR_CODMCR_437374#778549, CR_CODSEC_437348#778550, CR_CODSIT_437361#778551, CR_CODSUP_437364#778552, CR_CODUTI_437359#778553, CR_CODVCR_437351#778554, CR_CONTEXT_437343#778555, CR_CR_437338#778556, CR_DATCRE_437426#778557, CR_DATDCR_437355#778558, CR_DATDIC_437344#778559, CR_DATDMP_437413#778560, CR_DATMAIL_437408#778561, CR_DATMAJ_437360#778562, CR_DATMCR_437375#778563, ... 85 more fields]