== 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_CCAMDET_43712791`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: JDBCRelation((SELECT "zd_numcot", "zd_numdem", "zd_numdos", "zd_numpco", "zd_primai", "zd_annval", "zd_monnaie", "zd_cod_acte", "zd_ver_ccam", "zd_codsit", "zd_coduti", "zd_datmaj", "zd_cod_aa", "zd_modificateur", "zd_codper", "zd_codser", "zd_numsal", "zd_flassprev", "zd_assnonprev", "zd_numord", "zd_priuni", "zd_coefmino", "zd_mino", "zd_majo", "zd_basrmb", "zd_factur", "zd_typexo", "zd_taucai", "zd_parcai", "zd_taumut", "zd_parmut", "zd_ligrgr", "zd_regrou_cod", "zd_cod_aap", "zd_qualdp", "zd_flrmbexc", "zd_flsuppcharge", "zd_donncompl", "zd_dents", "zd_depmnt", "zd_flid", "zd_mttid", "zd_tauid", "zd_amoid", "zd_tauid_amc", "zd_amcid", "zd_nbrik", "zd_mttik", "zd_tauik", "zd_amoik", "zd_nbrikm", "zd_mttikm", "zd_tauikm", "zd_amoikm", "zd_nbriks", "zd_mttiks", "zd_tauiks", "zd_amoiks", "zd_forc", "zd_formamc", "zd_codtit", "zd_flald", "zd_a_fact", "zd_x_exo_tm", "zd_modiffact", "zd_assnonprev_c", "zd_qualdp_c", "zd_coduam", "zd_mtdep", "zd_mtpenhps", "zd_flpav", "zd_mttori", "zd_acr", "zd_codapp", "zd_codper2", "zd_codind", "zd_codres", "zd_codextdoc", "zd_numexa", "zd_codextpmsi" FROM "xplore"."h_ccamdet") as x) [numPartitions=1], [zd_numcot#304540, zd_numdem#304541, zd_numdos#304542, zd_numpco#304543, zd_primai#304544, zd_annval#304545, zd_monnaie#304546, zd_cod_acte#304547, zd_ver_ccam#304548, zd_codsit#304549, zd_coduti#304550, zd_datmaj#304551, zd_cod_aa#304552, zd_modificateur#304553, zd_codper#304554, zd_codser#304555, zd_numsal#304556, zd_flassprev#304557, zd_assnonprev#304558, zd_numord#304559, zd_priuni#304560, zd_coefmino#304561, zd_mino#304562, zd_majo#304563, ... 56 more fields], false
(4) Project
Arguments: [zd_numcot#304540 AS COLL0#304700, zd_numdem#304541 AS COLL1#304701, zd_numdos#304542 AS COLL2#304702, zd_numpco#304543 AS COLL3#304703, zd_primai#304544 AS COLL4#304704, zd_annval#304545 AS COLL5#304705, zd_monnaie#304546 AS COLL6#304706, zd_cod_acte#304547 AS COLL7#304707, zd_ver_ccam#304548 AS COLL8#304708, zd_codsit#304549 AS COLL9#304709, zd_coduti#304550 AS COLL10#304710, zd_datmaj#304551 AS COLL11#304711, zd_cod_aa#304552 AS COLL12#304712, zd_modificateur#304553 AS COLL13#304713, zd_codper#304554 AS COLL14#304714, zd_codser#304555 AS COLL15#304715, zd_numsal#304556 AS COLL16#304716, zd_flassprev#304557 AS COLL17#304717, zd_assnonprev#304558 AS COLL18#304718, zd_numord#304559 AS COLL19#304719, zd_priuni#304560 AS COLL20#304720, zd_coefmino#304561 AS COLL21#304721, zd_mino#304562 AS COLL22#304722, zd_majo#304563 AS COLL23#304723, ... 56 more fields]
(5) Project
Arguments: [COLL0#304700 AS COLL0#304860, COLL1#304701 AS COLL1#304861, COLL2#304702 AS COLL2#304862, COLL3#304703 AS COLL3#304863, COLL4#304704 AS COLL4#304864, COLL5#304705 AS COLL5#304865, COLL6#304706 AS COLL6#304866, COLL7#304707 AS COLL7#304867, COLL8#304708 AS COLL8#304868, COLL9#304709 AS COLL9#304869, COLL10#304710 AS COLL10#304870, COLL11#304711 AS COLL11#304871, COLL12#304712 AS COLL12#304872, COLL13#304713 AS COLL13#304873, COLL14#304714 AS COLL14#304874, COLL15#304715 AS COLL15#304875, COLL16#304716 AS COLL16#304876, COLL17#304717 AS COLL17#304877, COLL18#304718 AS COLL18#304878, COLL19#304719 AS COLL19#304879, COLL20#304720 AS COLL20#304880, COLL21#304721 AS COLL21#304881, COLL22#304722 AS COLL22#304882, COLL23#304723 AS COLL23#304883, ... 56 more fields]
(6) Project
Arguments: [COLL0#304860, COLL1#304861, COLL2#304862, COLL3#304863, COLL4#304864, COLL5#304865, COLL6#304866, COLL7#304867, COLL8#304868, COLL9#304869, COLL10#304870, COLL11#304871, COLL12#304872, COLL13#304873, COLL14#304874, COLL15#304875, COLL16#304876, COLL17#304877, COLL18#304878, COLL19#304879, COLL20#304880, COLL21#304881, COLL22#304882, COLL23#304883, ... 57 more fields]
(7) Project
Arguments: [COLL80#305020 AS ORIGINE_440135#305102, COLL72#304932 AS ZD_ACR_437200#305103, COLL45#304905 AS ZD_AMCID_437173#305104, COLL43#304903 AS ZD_AMOID_437171#305105, COLL53#304913 AS ZD_AMOIKM_437181#305106, COLL57#304917 AS ZD_AMOIKS_437185#305107, COLL49#304909 AS ZD_AMOIK_437177#305108, COLL5#304865 AS ZD_ANNVAL_437133#305109, COLL18#304878 AS ZD_ASSNONPREV_437146#305110, COLL65#304925 AS ZD_ASSNONPREV_C_437193#305111, COLL62#304922 AS ZD_A_FACT_437190#305112, COLL24#304884 AS ZD_BASRMB_437152#305113, COLL73#304933 AS ZD_CODAPP_437201#305114, COLL77#304937 AS ZD_CODEXTDOC_437205#305115, COLL79#304939 AS ZD_CODEXTPMSI_437207#305116, COLL75#304935 AS ZD_CODIND_437203#305117, COLL74#304934 AS ZD_CODPER2_437202#305118, COLL14#304874 AS ZD_CODPER_437142#305119, COLL76#304936 AS ZD_CODRES_437204#305120, COLL15#304875 AS ZD_CODSER_437143#305121, COLL9#304869 AS ZD_CODSIT_437137#305122, COLL60#304920 AS ZD_CODTIT_437188#305123, COLL67#304927 AS ZD_CODUAM_437195#305124, COLL10#304870 AS ZD_CODUTI_437138#305125, ... 57 more fields]
(8) LogicalRelation
Arguments: JDBCRelation((SELECT "zd_numcot", "zd_numdem", "zd_numdos", "zd_numpco", "zd_primai", "zd_annval", "zd_monnaie", "zd_cod_acte", "zd_ver_ccam", "zd_codsit", "zd_coduti", "zd_datmaj", "zd_cod_aa", "zd_modificateur", "zd_codper", "zd_codser", "zd_numsal", "zd_flassprev", "zd_assnonprev", "zd_numord", "zd_priuni", "zd_coefmino", "zd_mino", "zd_majo", "zd_basrmb", "zd_factur", "zd_typexo", "zd_taucai", "zd_parcai", "zd_taumut", "zd_parmut", "zd_ligrgr", "zd_regrou_cod", "zd_cod_aap", "zd_qualdp", "zd_flrmbexc", "zd_flsuppcharge", "zd_donncompl", "zd_dents", "zd_depmnt", "zd_flid", "zd_mttid", "zd_tauid", "zd_amoid", "zd_tauid_amc", "zd_amcid", "zd_nbrik", "zd_mttik", "zd_tauik", "zd_amoik", "zd_nbrikm", "zd_mttikm", "zd_tauikm", "zd_amoikm", "zd_nbriks", "zd_mttiks", "zd_tauiks", "zd_amoiks", "zd_forc", "zd_formamc", "zd_codtit", "zd_flald", "zd_a_fact", "zd_x_exo_tm", "zd_modiffact", "zd_assnonprev_c", "zd_qualdp_c", "zd_coduam", "zd_mtdep", "zd_mtpenhps", "zd_flpav", "zd_mttori", "zd_acr", "zd_codapp", "zd_codper2", "zd_codind", "zd_codres", "zd_codextdoc", "zd_numexa", "zd_codextpmsi" FROM "xplore2"."h_ccamdet") as x) [numPartitions=1], [zd_numcot#305264, zd_numdem#305265, zd_numdos#305266, zd_numpco#305267, zd_primai#305268, zd_annval#305269, zd_monnaie#305270, zd_cod_acte#305271, zd_ver_ccam#305272, zd_codsit#305273, zd_coduti#305274, zd_datmaj#305275, zd_cod_aa#305276, zd_modificateur#305277, zd_codper#305278, zd_codser#305279, zd_numsal#305280, zd_flassprev#305281, zd_assnonprev#305282, zd_numord#305283, zd_priuni#305284, zd_coefmino#305285, zd_mino#305286, zd_majo#305287, ... 56 more fields], false
(9) Project
Arguments: [zd_numcot#305264 AS COLL0#305424, zd_numdem#305265 AS COLL1#305425, zd_numdos#305266 AS COLL2#305426, zd_numpco#305267 AS COLL3#305427, zd_primai#305268 AS COLL4#305428, zd_annval#305269 AS COLL5#305429, zd_monnaie#305270 AS COLL6#305430, zd_cod_acte#305271 AS COLL7#305431, zd_ver_ccam#305272 AS COLL8#305432, zd_codsit#305273 AS COLL9#305433, zd_coduti#305274 AS COLL10#305434, zd_datmaj#305275 AS COLL11#305435, zd_cod_aa#305276 AS COLL12#305436, zd_modificateur#305277 AS COLL13#305437, zd_codper#305278 AS COLL14#305438, zd_codser#305279 AS COLL15#305439, zd_numsal#305280 AS COLL16#305440, zd_flassprev#305281 AS COLL17#305441, zd_assnonprev#305282 AS COLL18#305442, zd_numord#305283 AS COLL19#305443, zd_priuni#305284 AS COLL20#305444, zd_coefmino#305285 AS COLL21#305445, zd_mino#305286 AS COLL22#305446, zd_majo#305287 AS COLL23#305447, ... 56 more fields]
(10) Project
Arguments: [COLL0#305424 AS COLL0#305584, COLL1#305425 AS COLL1#305585, COLL2#305426 AS COLL2#305586, COLL3#305427 AS COLL3#305587, COLL4#305428 AS COLL4#305588, COLL5#305429 AS COLL5#305589, COLL6#305430 AS COLL6#305590, COLL7#305431 AS COLL7#305591, COLL8#305432 AS COLL8#305592, COLL9#305433 AS COLL9#305593, COLL10#305434 AS COLL10#305594, COLL11#305435 AS COLL11#305595, COLL12#305436 AS COLL12#305596, COLL13#305437 AS COLL13#305597, COLL14#305438 AS COLL14#305598, COLL15#305439 AS COLL15#305599, COLL16#305440 AS COLL16#305600, COLL17#305441 AS COLL17#305601, COLL18#305442 AS COLL18#305602, COLL19#305443 AS COLL19#305603, COLL20#305444 AS COLL20#305604, COLL21#305445 AS COLL21#305605, COLL22#305446 AS COLL22#305606, COLL23#305447 AS COLL23#305607, ... 56 more fields]
(11) Project
Arguments: [COLL0#305584, COLL1#305585, COLL2#305586, COLL3#305587, COLL4#305588, COLL5#305589, COLL6#305590, COLL7#305591, COLL8#305592, COLL9#305593, COLL10#305594, COLL11#305595, COLL12#305596, COLL13#305597, COLL14#305598, COLL15#305599, COLL16#305600, COLL17#305601, COLL18#305602, COLL19#305603, COLL20#305604, COLL21#305605, COLL22#305606, COLL23#305607, ... 57 more fields]
(12) Project
Arguments: [COLL80#305744 AS ORIGINE_440135#305826, COLL72#305656 AS ZD_ACR_437200#305827, COLL45#305629 AS ZD_AMCID_437173#305828, COLL43#305627 AS ZD_AMOID_437171#305829, COLL53#305637 AS ZD_AMOIKM_437181#305830, COLL57#305641 AS ZD_AMOIKS_437185#305831, COLL49#305633 AS ZD_AMOIK_437177#305832, COLL5#305589 AS ZD_ANNVAL_437133#305833, COLL18#305602 AS ZD_ASSNONPREV_437146#305834, COLL65#305649 AS ZD_ASSNONPREV_C_437193#305835, COLL62#305646 AS ZD_A_FACT_437190#305836, COLL24#305608 AS ZD_BASRMB_437152#305837, COLL73#305657 AS ZD_CODAPP_437201#305838, COLL77#305661 AS ZD_CODEXTDOC_437205#305839, COLL79#305663 AS ZD_CODEXTPMSI_437207#305840, COLL75#305659 AS ZD_CODIND_437203#305841, COLL74#305658 AS ZD_CODPER2_437202#305842, COLL14#305598 AS ZD_CODPER_437142#305843, COLL76#305660 AS ZD_CODRES_437204#305844, COLL15#305599 AS ZD_CODSER_437143#305845, COLL9#305593 AS ZD_CODSIT_437137#305846, COLL60#305644 AS ZD_CODTIT_437188#305847, COLL67#305651 AS ZD_CODUAM_437195#305848, COLL10#305594 AS ZD_CODUTI_437138#305849, ... 57 more fields]
(13) Union
Arguments: false, false
(14) Project
Arguments: [ORIGINE_440135#305102, ZD_ACR_437200#305103, ZD_AMCID_437173#305104, ZD_AMOID_437171#305105, ZD_AMOIKM_437181#305106, ZD_AMOIKS_437185#305107, ZD_AMOIK_437177#305108, ZD_ANNVAL_437133#305109, ZD_ASSNONPREV_437146#305110, ZD_ASSNONPREV_C_437193#305111, ZD_A_FACT_437190#305112, ZD_BASRMB_437152#305113, ZD_CODAPP_437201#305114, ZD_CODEXTDOC_437205#305115, ZD_CODEXTPMSI_437207#305116, ZD_CODIND_437203#305117, ZD_CODPER2_437202#305118, ZD_CODPER_437142#305119, ZD_CODRES_437204#305120, ZD_CODSER_437143#305121, ZD_CODSIT_437137#305122, ZD_CODTIT_437188#305123, ZD_CODUAM_437195#305124, ZD_CODUTI_437138#305125, ... 57 more fields]