== 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: `4CD7BB82_4C16_4DE3_9664_89DEAEA9CAEE`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: JDBCRelation((SELECT "al_codval", "al_annval", "al_valcou", "al_lib30", "al_libmaj", "al_taux", "al_prior", "al_type", "al_datmaj", "al_coduti", "al_codsit", "al_monnaie", "al_typexa", "al_numbmp", "al_ordre", "al_letadm", "al_envadm", "al_t_red", "al_taux_r", "al_forfai", "al_classe", "al_revers", "al_rembours", "al_taux_t1", "al_taux_t2", "al_taux_t3", "al_taux_t4", "al_taux_t5", "al_taux_t6", "al_taux_t7", "al_taux_t8", "al_taux_t9", "al_taux_t1r", "al_taux_t2r", "al_taux_t3r", "al_taux_t4r", "al_taux_t5r", "al_taux_t6r", "al_taux_t7r", "al_taux_t8r", "al_taux_t9r", "al_flsej", "al_flicpt", "al_datede", "al_numcpt", "al_comment", "al_fltele", "al_codcha", "al_letads", "al_sites", "al_urg", "al_int_std", "al_int_spe", "al_spl_trans", "al_rcp", "al_datefi", "al_primai", "al_icd", "al_type_icd" FROM "xplore"."h_valeu") as x) [numPartitions=1], [al_codval#424645, al_annval#424646, al_valcou#424647, al_lib30#424648, al_libmaj#424649, al_taux#424650, al_prior#424651, al_type#424652, al_datmaj#424653, al_coduti#424654, al_codsit#424655, al_monnaie#424656, al_typexa#424657, al_numbmp#424658, al_ordre#424659, al_letadm#424660, al_envadm#424661, al_t_red#424662, al_taux_r#424663, al_forfai#424664, al_classe#424665, al_revers#424666, al_rembours#424667, al_taux_t1#424668, ... 35 more fields], false
(4) Project
Arguments: [al_codval#424645 AS COLL0#424763, al_annval#424646 AS COLL1#424764, al_valcou#424647 AS COLL2#424765, al_lib30#424648 AS COLL3#424766, al_libmaj#424649 AS COLL4#424767, al_taux#424650 AS COLL5#424768, al_prior#424651 AS COLL6#424769, al_type#424652 AS COLL7#424770, al_datmaj#424653 AS COLL8#424771, al_coduti#424654 AS COLL9#424772, al_codsit#424655 AS COLL10#424773, al_monnaie#424656 AS COLL11#424774, al_typexa#424657 AS COLL12#424775, al_numbmp#424658 AS COLL13#424776, al_ordre#424659 AS COLL14#424777, al_letadm#424660 AS COLL15#424778, al_envadm#424661 AS COLL16#424779, al_t_red#424662 AS COLL17#424780, al_taux_r#424663 AS COLL18#424781, al_forfai#424664 AS COLL19#424782, al_classe#424665 AS COLL20#424783, al_revers#424666 AS COLL21#424784, al_rembours#424667 AS COLL22#424785, al_taux_t1#424668 AS COLL23#424786, ... 35 more fields]
(5) Project
Arguments: [COLL0#424763 AS COLL0#424881, COLL1#424764 AS COLL1#424882, COLL2#424765 AS COLL2#424883, COLL3#424766 AS COLL3#424884, COLL4#424767 AS COLL4#424885, COLL5#424768 AS COLL5#424886, COLL6#424769 AS COLL6#424887, COLL7#424770 AS COLL7#424888, COLL8#424771 AS COLL8#424889, COLL9#424772 AS COLL9#424890, COLL10#424773 AS COLL10#424891, COLL11#424774 AS COLL11#424892, COLL12#424775 AS COLL12#424893, COLL13#424776 AS COLL13#424894, COLL14#424777 AS COLL14#424895, COLL15#424778 AS COLL15#424896, COLL16#424779 AS COLL16#424897, COLL17#424780 AS COLL17#424898, COLL18#424781 AS COLL18#424899, COLL19#424782 AS COLL19#424900, COLL20#424783 AS COLL20#424901, COLL21#424784 AS COLL21#424902, COLL22#424785 AS COLL22#424903, COLL23#424786 AS COLL23#424904, ... 35 more fields]
(6) Project
Arguments: [COLL0#424881, COLL1#424882, COLL2#424883, COLL3#424884, COLL4#424885, COLL5#424886, COLL6#424887, COLL7#424888, COLL8#424889, COLL9#424890, COLL10#424891, COLL11#424892, COLL12#424893, COLL13#424894, COLL14#424895, COLL15#424896, COLL16#424897, COLL17#424898, COLL18#424899, COLL19#424900, COLL20#424901, COLL21#424902, COLL22#424903, COLL23#424904, ... 35 more fields]
(7) Project
Arguments: [COLL1#424882 AS AL_ANNVAL_438378#425058, COLL20#424901 AS AL_CLASSE_438397#425059, COLL47#424928 AS AL_CODCHA_438424#425060, COLL10#424891 AS AL_CODSIT_438387#425061, COLL9#424890 AS AL_CODUTI_438386#425062, COLL0#424881 AS AL_CODVAL_438377#425063, COLL45#424926 AS AL_COMMENT_438422#425064, COLL43#424924 AS AL_DATEDE_438420#425065, COLL55#424936 AS AL_DATEFI_438432#425066, COLL8#424889 AS AL_DATMAJ_438385#425067, COLL16#424897 AS AL_ENVADM_438393#425068, COLL42#424923 AS AL_FLICPT_438419#425069, COLL41#424922 AS AL_FLSEJ_438418#425070, COLL46#424927 AS AL_FLTELE_438423#425071, COLL19#424900 AS AL_FORFAI_438396#425072, COLL57#424938 AS AL_ICD_438434#425073, COLL52#424933 AS AL_INT_SPE_438429#425074, COLL51#424932 AS AL_INT_STD_438428#425075, COLL15#424896 AS AL_LETADM_438392#425076, COLL48#424929 AS AL_LETADS_438425#425077, COLL3#424884 AS AL_LIB30_438380#425078, COLL4#424885 AS AL_LIBMAJ_438381#425079, COLL11#424892 AS AL_MONNAIE_438388#425080, COLL13#424894 AS AL_NUMBMP_438390#425081, ... 36 more fields]
(8) LogicalRelation
Arguments: JDBCRelation((SELECT "al_codval", "al_annval", "al_valcou", "al_lib30", "al_libmaj", "al_taux", "al_prior", "al_type", "al_datmaj", "al_coduti", "al_codsit", "al_monnaie", "al_typexa", "al_numbmp", "al_ordre", "al_letadm", "al_envadm", "al_t_red", "al_taux_r", "al_forfai", "al_classe", "al_revers", "al_rembours", "al_taux_t1", "al_taux_t2", "al_taux_t3", "al_taux_t4", "al_taux_t5", "al_taux_t6", "al_taux_t7", "al_taux_t8", "al_taux_t9", "al_taux_t1r", "al_taux_t2r", "al_taux_t3r", "al_taux_t4r", "al_taux_t5r", "al_taux_t6r", "al_taux_t7r", "al_taux_t8r", "al_taux_t9r", "al_flsej", "al_flicpt", "al_datede", "al_numcpt", "al_comment", "al_fltele", "al_codcha", "al_letads", "al_sites", "al_urg", "al_int_std", "al_int_spe", "al_spl_trans", "al_rcp", "al_datefi", "al_primai", "al_icd", "al_type_icd" FROM "xplore2"."h_valeu") as x) [numPartitions=1], [al_codval#425178, al_annval#425179, al_valcou#425180, al_lib30#425181, al_libmaj#425182, al_taux#425183, al_prior#425184, al_type#425185, al_datmaj#425186, al_coduti#425187, al_codsit#425188, al_monnaie#425189, al_typexa#425190, al_numbmp#425191, al_ordre#425192, al_letadm#425193, al_envadm#425194, al_t_red#425195, al_taux_r#425196, al_forfai#425197, al_classe#425198, al_revers#425199, al_rembours#425200, al_taux_t1#425201, ... 35 more fields], false
(9) Project
Arguments: [al_codval#425178 AS COLL0#425296, al_annval#425179 AS COLL1#425297, al_valcou#425180 AS COLL2#425298, al_lib30#425181 AS COLL3#425299, al_libmaj#425182 AS COLL4#425300, al_taux#425183 AS COLL5#425301, al_prior#425184 AS COLL6#425302, al_type#425185 AS COLL7#425303, al_datmaj#425186 AS COLL8#425304, al_coduti#425187 AS COLL9#425305, al_codsit#425188 AS COLL10#425306, al_monnaie#425189 AS COLL11#425307, al_typexa#425190 AS COLL12#425308, al_numbmp#425191 AS COLL13#425309, al_ordre#425192 AS COLL14#425310, al_letadm#425193 AS COLL15#425311, al_envadm#425194 AS COLL16#425312, al_t_red#425195 AS COLL17#425313, al_taux_r#425196 AS COLL18#425314, al_forfai#425197 AS COLL19#425315, al_classe#425198 AS COLL20#425316, al_revers#425199 AS COLL21#425317, al_rembours#425200 AS COLL22#425318, al_taux_t1#425201 AS COLL23#425319, ... 35 more fields]
(10) Project
Arguments: [COLL0#425296 AS COLL0#425414, COLL1#425297 AS COLL1#425415, COLL2#425298 AS COLL2#425416, COLL3#425299 AS COLL3#425417, COLL4#425300 AS COLL4#425418, COLL5#425301 AS COLL5#425419, COLL6#425302 AS COLL6#425420, COLL7#425303 AS COLL7#425421, COLL8#425304 AS COLL8#425422, COLL9#425305 AS COLL9#425423, COLL10#425306 AS COLL10#425424, COLL11#425307 AS COLL11#425425, COLL12#425308 AS COLL12#425426, COLL13#425309 AS COLL13#425427, COLL14#425310 AS COLL14#425428, COLL15#425311 AS COLL15#425429, COLL16#425312 AS COLL16#425430, COLL17#425313 AS COLL17#425431, COLL18#425314 AS COLL18#425432, COLL19#425315 AS COLL19#425433, COLL20#425316 AS COLL20#425434, COLL21#425317 AS COLL21#425435, COLL22#425318 AS COLL22#425436, COLL23#425319 AS COLL23#425437, ... 35 more fields]
(11) Project
Arguments: [COLL0#425414, COLL1#425415, COLL2#425416, COLL3#425417, COLL4#425418, COLL5#425419, COLL6#425420, COLL7#425421, COLL8#425422, COLL9#425423, COLL10#425424, COLL11#425425, COLL12#425426, COLL13#425427, COLL14#425428, COLL15#425429, COLL16#425430, COLL17#425431, COLL18#425432, COLL19#425433, COLL20#425434, COLL21#425435, COLL22#425436, COLL23#425437, ... 35 more fields]
(12) Project
Arguments: [COLL1#425415 AS AL_ANNVAL_438378#425591, COLL20#425434 AS AL_CLASSE_438397#425592, COLL47#425461 AS AL_CODCHA_438424#425593, COLL10#425424 AS AL_CODSIT_438387#425594, COLL9#425423 AS AL_CODUTI_438386#425595, COLL0#425414 AS AL_CODVAL_438377#425596, COLL45#425459 AS AL_COMMENT_438422#425597, COLL43#425457 AS AL_DATEDE_438420#425598, COLL55#425469 AS AL_DATEFI_438432#425599, COLL8#425422 AS AL_DATMAJ_438385#425600, COLL16#425430 AS AL_ENVADM_438393#425601, COLL42#425456 AS AL_FLICPT_438419#425602, COLL41#425455 AS AL_FLSEJ_438418#425603, COLL46#425460 AS AL_FLTELE_438423#425604, COLL19#425433 AS AL_FORFAI_438396#425605, COLL57#425471 AS AL_ICD_438434#425606, COLL52#425466 AS AL_INT_SPE_438429#425607, COLL51#425465 AS AL_INT_STD_438428#425608, COLL15#425429 AS AL_LETADM_438392#425609, COLL48#425462 AS AL_LETADS_438425#425610, COLL3#425417 AS AL_LIB30_438380#425611, COLL4#425418 AS AL_LIBMAJ_438381#425612, COLL11#425425 AS AL_MONNAIE_438388#425613, COLL13#425427 AS AL_NUMBMP_438390#425614, ... 36 more fields]
(13) Union
Arguments: false, false
(14) Project
Arguments: [AL_ANNVAL_438378#425058, AL_CLASSE_438397#425059, AL_CODCHA_438424#425060, AL_CODSIT_438387#425061, AL_CODUTI_438386#425062, AL_CODVAL_438377#425063, AL_COMMENT_438422#425064, AL_DATEDE_438420#425065, AL_DATEFI_438432#425066, AL_DATMAJ_438385#425067, AL_ENVADM_438393#425068, AL_FLICPT_438419#425069, AL_FLSEJ_438418#425070, AL_FLTELE_438423#425071, AL_FORFAI_438396#425072, AL_ICD_438434#425073, AL_INT_SPE_438429#425074, AL_INT_STD_438428#425075, AL_LETADM_438392#425076, AL_LETADS_438425#425077, AL_LIB30_438380#425078, AL_LIBMAJ_438381#425079, AL_MONNAIE_438388#425080, AL_NUMBMP_438390#425081, ... 36 more fields]