== 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_43712789`, 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#315486, zd_numdem#315487, zd_numdos#315488, zd_numpco#315489, zd_primai#315490, zd_annval#315491, zd_monnaie#315492, zd_cod_acte#315493, zd_ver_ccam#315494, zd_codsit#315495, zd_coduti#315496, zd_datmaj#315497, zd_cod_aa#315498, zd_modificateur#315499, zd_codper#315500, zd_codser#315501, zd_numsal#315502, zd_flassprev#315503, zd_assnonprev#315504, zd_numord#315505, zd_priuni#315506, zd_coefmino#315507, zd_mino#315508, zd_majo#315509, ... 56 more fields], false
(4) Project
Arguments: [zd_numcot#315486 AS COLL0#315646, zd_numdem#315487 AS COLL1#315647, zd_numdos#315488 AS COLL2#315648, zd_numpco#315489 AS COLL3#315649, zd_primai#315490 AS COLL4#315650, zd_annval#315491 AS COLL5#315651, zd_monnaie#315492 AS COLL6#315652, zd_cod_acte#315493 AS COLL7#315653, zd_ver_ccam#315494 AS COLL8#315654, zd_codsit#315495 AS COLL9#315655, zd_coduti#315496 AS COLL10#315656, zd_datmaj#315497 AS COLL11#315657, zd_cod_aa#315498 AS COLL12#315658, zd_modificateur#315499 AS COLL13#315659, zd_codper#315500 AS COLL14#315660, zd_codser#315501 AS COLL15#315661, zd_numsal#315502 AS COLL16#315662, zd_flassprev#315503 AS COLL17#315663, zd_assnonprev#315504 AS COLL18#315664, zd_numord#315505 AS COLL19#315665, zd_priuni#315506 AS COLL20#315666, zd_coefmino#315507 AS COLL21#315667, zd_mino#315508 AS COLL22#315668, zd_majo#315509 AS COLL23#315669, ... 56 more fields]
(5) Project
Arguments: [COLL0#315646 AS COLL0#315806, COLL1#315647 AS COLL1#315807, COLL2#315648 AS COLL2#315808, COLL3#315649 AS COLL3#315809, COLL4#315650 AS COLL4#315810, COLL5#315651 AS COLL5#315811, COLL6#315652 AS COLL6#315812, COLL7#315653 AS COLL7#315813, COLL8#315654 AS COLL8#315814, COLL9#315655 AS COLL9#315815, COLL10#315656 AS COLL10#315816, COLL11#315657 AS COLL11#315817, COLL12#315658 AS COLL12#315818, COLL13#315659 AS COLL13#315819, COLL14#315660 AS COLL14#315820, COLL15#315661 AS COLL15#315821, COLL16#315662 AS COLL16#315822, COLL17#315663 AS COLL17#315823, COLL18#315664 AS COLL18#315824, COLL19#315665 AS COLL19#315825, COLL20#315666 AS COLL20#315826, COLL21#315667 AS COLL21#315827, COLL22#315668 AS COLL22#315828, COLL23#315669 AS COLL23#315829, ... 56 more fields]
(6) Project
Arguments: [COLL0#315806, COLL1#315807, COLL2#315808, COLL3#315809, COLL4#315810, COLL5#315811, COLL6#315812, COLL7#315813, COLL8#315814, COLL9#315815, COLL10#315816, COLL11#315817, COLL12#315818, COLL13#315819, COLL14#315820, COLL15#315821, COLL16#315822, COLL17#315823, COLL18#315824, COLL19#315825, COLL20#315826, COLL21#315827, COLL22#315828, COLL23#315829, ... 56 more fields]
(7) Project
Arguments: [cast(str_create(cast(Cab_A as string)) as string) AS ORIGINE_440136#316127, COLL72#315878 AS ZD_ACR_437200#316047, COLL45#315851 AS ZD_AMCID_437173#316048, COLL43#315849 AS ZD_AMOID_437171#316049, COLL53#315859 AS ZD_AMOIKM_437181#316050, COLL57#315863 AS ZD_AMOIKS_437185#316051, COLL49#315855 AS ZD_AMOIK_437177#316052, COLL5#315811 AS ZD_ANNVAL_437133#316053, COLL18#315824 AS ZD_ASSNONPREV_437146#316054, COLL65#315871 AS ZD_ASSNONPREV_C_437193#316055, COLL62#315868 AS ZD_A_FACT_437190#316056, COLL24#315830 AS ZD_BASRMB_437152#316057, COLL73#315879 AS ZD_CODAPP_437201#316058, COLL77#315883 AS ZD_CODEXTDOC_437205#316059, COLL79#315885 AS ZD_CODEXTPMSI_437207#316060, COLL75#315881 AS ZD_CODIND_437203#316061, COLL74#315880 AS ZD_CODPER2_437202#316062, COLL14#315820 AS ZD_CODPER_437142#316063, COLL76#315882 AS ZD_CODRES_437204#316064, COLL15#315821 AS ZD_CODSER_437143#316065, COLL9#315815 AS ZD_CODSIT_437137#316066, COLL60#315866 AS ZD_CODTIT_437188#316067, COLL67#315873 AS ZD_CODUAM_437195#316068, COLL10#315816 AS ZD_CODUTI_437138#316069, ... 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#316209, zd_numdem#316210, zd_numdos#316211, zd_numpco#316212, zd_primai#316213, zd_annval#316214, zd_monnaie#316215, zd_cod_acte#316216, zd_ver_ccam#316217, zd_codsit#316218, zd_coduti#316219, zd_datmaj#316220, zd_cod_aa#316221, zd_modificateur#316222, zd_codper#316223, zd_codser#316224, zd_numsal#316225, zd_flassprev#316226, zd_assnonprev#316227, zd_numord#316228, zd_priuni#316229, zd_coefmino#316230, zd_mino#316231, zd_majo#316232, ... 56 more fields], false
(9) Project
Arguments: [zd_numcot#316209 AS COLL0#316369, zd_numdem#316210 AS COLL1#316370, zd_numdos#316211 AS COLL2#316371, zd_numpco#316212 AS COLL3#316372, zd_primai#316213 AS COLL4#316373, zd_annval#316214 AS COLL5#316374, zd_monnaie#316215 AS COLL6#316375, zd_cod_acte#316216 AS COLL7#316376, zd_ver_ccam#316217 AS COLL8#316377, zd_codsit#316218 AS COLL9#316378, zd_coduti#316219 AS COLL10#316379, zd_datmaj#316220 AS COLL11#316380, zd_cod_aa#316221 AS COLL12#316381, zd_modificateur#316222 AS COLL13#316382, zd_codper#316223 AS COLL14#316383, zd_codser#316224 AS COLL15#316384, zd_numsal#316225 AS COLL16#316385, zd_flassprev#316226 AS COLL17#316386, zd_assnonprev#316227 AS COLL18#316387, zd_numord#316228 AS COLL19#316388, zd_priuni#316229 AS COLL20#316389, zd_coefmino#316230 AS COLL21#316390, zd_mino#316231 AS COLL22#316391, zd_majo#316232 AS COLL23#316392, ... 56 more fields]
(10) Project
Arguments: [COLL0#316369 AS COLL0#316529, COLL1#316370 AS COLL1#316530, COLL2#316371 AS COLL2#316531, COLL3#316372 AS COLL3#316532, COLL4#316373 AS COLL4#316533, COLL5#316374 AS COLL5#316534, COLL6#316375 AS COLL6#316535, COLL7#316376 AS COLL7#316536, COLL8#316377 AS COLL8#316537, COLL9#316378 AS COLL9#316538, COLL10#316379 AS COLL10#316539, COLL11#316380 AS COLL11#316540, COLL12#316381 AS COLL12#316541, COLL13#316382 AS COLL13#316542, COLL14#316383 AS COLL14#316543, COLL15#316384 AS COLL15#316544, COLL16#316385 AS COLL16#316545, COLL17#316386 AS COLL17#316546, COLL18#316387 AS COLL18#316547, COLL19#316388 AS COLL19#316548, COLL20#316389 AS COLL20#316549, COLL21#316390 AS COLL21#316550, COLL22#316391 AS COLL22#316551, COLL23#316392 AS COLL23#316552, ... 56 more fields]
(11) Project
Arguments: [COLL0#316529, COLL1#316530, COLL2#316531, COLL3#316532, COLL4#316533, COLL5#316534, COLL6#316535, COLL7#316536, COLL8#316537, COLL9#316538, COLL10#316539, COLL11#316540, COLL12#316541, COLL13#316542, COLL14#316543, COLL15#316544, COLL16#316545, COLL17#316546, COLL18#316547, COLL19#316548, COLL20#316549, COLL21#316550, COLL22#316551, COLL23#316552, ... 56 more fields]
(12) Project
Arguments: [cast(str_create(cast(Cab_B as string)) as string) AS ORIGINE_440136#316850, COLL72#316601 AS ZD_ACR_437200#316770, COLL45#316574 AS ZD_AMCID_437173#316771, COLL43#316572 AS ZD_AMOID_437171#316772, COLL53#316582 AS ZD_AMOIKM_437181#316773, COLL57#316586 AS ZD_AMOIKS_437185#316774, COLL49#316578 AS ZD_AMOIK_437177#316775, COLL5#316534 AS ZD_ANNVAL_437133#316776, COLL18#316547 AS ZD_ASSNONPREV_437146#316777, COLL65#316594 AS ZD_ASSNONPREV_C_437193#316778, COLL62#316591 AS ZD_A_FACT_437190#316779, COLL24#316553 AS ZD_BASRMB_437152#316780, COLL73#316602 AS ZD_CODAPP_437201#316781, COLL77#316606 AS ZD_CODEXTDOC_437205#316782, COLL79#316608 AS ZD_CODEXTPMSI_437207#316783, COLL75#316604 AS ZD_CODIND_437203#316784, COLL74#316603 AS ZD_CODPER2_437202#316785, COLL14#316543 AS ZD_CODPER_437142#316786, COLL76#316605 AS ZD_CODRES_437204#316787, COLL15#316544 AS ZD_CODSER_437143#316788, COLL9#316538 AS ZD_CODSIT_437137#316789, COLL60#316589 AS ZD_CODTIT_437188#316790, COLL67#316596 AS ZD_CODUAM_437195#316791, COLL10#316539 AS ZD_CODUTI_437138#316792, ... 57 more fields]
(13) Union
Arguments: false, false
(14) Project
Arguments: [ORIGINE_440136#316127, ZD_ACR_437200#316047, ZD_AMCID_437173#316048, ZD_AMOID_437171#316049, ZD_AMOIKM_437181#316050, ZD_AMOIKS_437185#316051, ZD_AMOIK_437177#316052, ZD_ANNVAL_437133#316053, ZD_ASSNONPREV_437146#316054, ZD_ASSNONPREV_C_437193#316055, ZD_A_FACT_437190#316056, ZD_BASRMB_437152#316057, ZD_CODAPP_437201#316058, ZD_CODEXTDOC_437205#316059, ZD_CODEXTPMSI_437207#316060, ZD_CODIND_437203#316061, ZD_CODPER2_437202#316062, ZD_CODPER_437142#316063, ZD_CODRES_437204#316064, ZD_CODSER_437143#316065, ZD_CODSIT_437137#316066, ZD_CODTIT_437188#316067, ZD_CODUAM_437195#316068, ZD_CODUTI_437138#316069, ... 57 more fields]