== 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: `F6A74857_A1C1_498E_855F_9A7EA7BE47AE`, 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#422757, al_annval#422758, al_valcou#422759, al_lib30#422760, al_libmaj#422761, al_taux#422762, al_prior#422763, al_type#422764, al_datmaj#422765, al_coduti#422766, al_codsit#422767, al_monnaie#422768, al_typexa#422769, al_numbmp#422770, al_ordre#422771, al_letadm#422772, al_envadm#422773, al_t_red#422774, al_taux_r#422775, al_forfai#422776, al_classe#422777, al_revers#422778, al_rembours#422779, al_taux_t1#422780, ... 35 more fields], false
(4) Project
Arguments: [al_codval#422757 AS COLL0#422875, al_annval#422758 AS COLL1#422876, al_valcou#422759 AS COLL2#422877, al_lib30#422760 AS COLL3#422878, al_libmaj#422761 AS COLL4#422879, al_taux#422762 AS COLL5#422880, al_prior#422763 AS COLL6#422881, al_type#422764 AS COLL7#422882, al_datmaj#422765 AS COLL8#422883, al_coduti#422766 AS COLL9#422884, al_codsit#422767 AS COLL10#422885, al_monnaie#422768 AS COLL11#422886, al_typexa#422769 AS COLL12#422887, al_numbmp#422770 AS COLL13#422888, al_ordre#422771 AS COLL14#422889, al_letadm#422772 AS COLL15#422890, al_envadm#422773 AS COLL16#422891, al_t_red#422774 AS COLL17#422892, al_taux_r#422775 AS COLL18#422893, al_forfai#422776 AS COLL19#422894, al_classe#422777 AS COLL20#422895, al_revers#422778 AS COLL21#422896, al_rembours#422779 AS COLL22#422897, al_taux_t1#422780 AS COLL23#422898, ... 35 more fields]
(5) Project
Arguments: [COLL0#422875 AS COLL0#422993, COLL1#422876 AS COLL1#422994, COLL2#422877 AS COLL2#422995, COLL3#422878 AS COLL3#422996, COLL4#422879 AS COLL4#422997, COLL5#422880 AS COLL5#422998, COLL6#422881 AS COLL6#422999, COLL7#422882 AS COLL7#423000, COLL8#422883 AS COLL8#423001, COLL9#422884 AS COLL9#423002, COLL10#422885 AS COLL10#423003, COLL11#422886 AS COLL11#423004, COLL12#422887 AS COLL12#423005, COLL13#422888 AS COLL13#423006, COLL14#422889 AS COLL14#423007, COLL15#422890 AS COLL15#423008, COLL16#422891 AS COLL16#423009, COLL17#422892 AS COLL17#423010, COLL18#422893 AS COLL18#423011, COLL19#422894 AS COLL19#423012, COLL20#422895 AS COLL20#423013, COLL21#422896 AS COLL21#423014, COLL22#422897 AS COLL22#423015, COLL23#422898 AS COLL23#423016, ... 35 more fields]
(6) Project
Arguments: [COLL0#422993, COLL1#422994, COLL2#422995, COLL3#422996, COLL4#422997, COLL5#422998, COLL6#422999, COLL7#423000, COLL8#423001, COLL9#423002, COLL10#423003, COLL11#423004, COLL12#423005, COLL13#423006, COLL14#423007, COLL15#423008, COLL16#423009, COLL17#423010, COLL18#423011, COLL19#423012, COLL20#423013, COLL21#423014, COLL22#423015, COLL23#423016, ... 35 more fields]
(7) Project
Arguments: [COLL1#422994 AS AL_ANNVAL_438378#423170, COLL20#423013 AS AL_CLASSE_438397#423171, COLL47#423040 AS AL_CODCHA_438424#423172, COLL10#423003 AS AL_CODSIT_438387#423173, COLL9#423002 AS AL_CODUTI_438386#423174, COLL0#422993 AS AL_CODVAL_438377#423175, COLL45#423038 AS AL_COMMENT_438422#423176, COLL43#423036 AS AL_DATEDE_438420#423177, COLL55#423048 AS AL_DATEFI_438432#423178, COLL8#423001 AS AL_DATMAJ_438385#423179, COLL16#423009 AS AL_ENVADM_438393#423180, COLL42#423035 AS AL_FLICPT_438419#423181, COLL41#423034 AS AL_FLSEJ_438418#423182, COLL46#423039 AS AL_FLTELE_438423#423183, COLL19#423012 AS AL_FORFAI_438396#423184, COLL57#423050 AS AL_ICD_438434#423185, COLL52#423045 AS AL_INT_SPE_438429#423186, COLL51#423044 AS AL_INT_STD_438428#423187, COLL15#423008 AS AL_LETADM_438392#423188, COLL48#423041 AS AL_LETADS_438425#423189, COLL3#422996 AS AL_LIB30_438380#423190, COLL4#422997 AS AL_LIBMAJ_438381#423191, COLL11#423004 AS AL_MONNAIE_438388#423192, COLL13#423006 AS AL_NUMBMP_438390#423193, ... 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#423290, al_annval#423291, al_valcou#423292, al_lib30#423293, al_libmaj#423294, al_taux#423295, al_prior#423296, al_type#423297, al_datmaj#423298, al_coduti#423299, al_codsit#423300, al_monnaie#423301, al_typexa#423302, al_numbmp#423303, al_ordre#423304, al_letadm#423305, al_envadm#423306, al_t_red#423307, al_taux_r#423308, al_forfai#423309, al_classe#423310, al_revers#423311, al_rembours#423312, al_taux_t1#423313, ... 35 more fields], false
(9) Project
Arguments: [al_codval#423290 AS COLL0#423408, al_annval#423291 AS COLL1#423409, al_valcou#423292 AS COLL2#423410, al_lib30#423293 AS COLL3#423411, al_libmaj#423294 AS COLL4#423412, al_taux#423295 AS COLL5#423413, al_prior#423296 AS COLL6#423414, al_type#423297 AS COLL7#423415, al_datmaj#423298 AS COLL8#423416, al_coduti#423299 AS COLL9#423417, al_codsit#423300 AS COLL10#423418, al_monnaie#423301 AS COLL11#423419, al_typexa#423302 AS COLL12#423420, al_numbmp#423303 AS COLL13#423421, al_ordre#423304 AS COLL14#423422, al_letadm#423305 AS COLL15#423423, al_envadm#423306 AS COLL16#423424, al_t_red#423307 AS COLL17#423425, al_taux_r#423308 AS COLL18#423426, al_forfai#423309 AS COLL19#423427, al_classe#423310 AS COLL20#423428, al_revers#423311 AS COLL21#423429, al_rembours#423312 AS COLL22#423430, al_taux_t1#423313 AS COLL23#423431, ... 35 more fields]
(10) Project
Arguments: [COLL0#423408 AS COLL0#423526, COLL1#423409 AS COLL1#423527, COLL2#423410 AS COLL2#423528, COLL3#423411 AS COLL3#423529, COLL4#423412 AS COLL4#423530, COLL5#423413 AS COLL5#423531, COLL6#423414 AS COLL6#423532, COLL7#423415 AS COLL7#423533, COLL8#423416 AS COLL8#423534, COLL9#423417 AS COLL9#423535, COLL10#423418 AS COLL10#423536, COLL11#423419 AS COLL11#423537, COLL12#423420 AS COLL12#423538, COLL13#423421 AS COLL13#423539, COLL14#423422 AS COLL14#423540, COLL15#423423 AS COLL15#423541, COLL16#423424 AS COLL16#423542, COLL17#423425 AS COLL17#423543, COLL18#423426 AS COLL18#423544, COLL19#423427 AS COLL19#423545, COLL20#423428 AS COLL20#423546, COLL21#423429 AS COLL21#423547, COLL22#423430 AS COLL22#423548, COLL23#423431 AS COLL23#423549, ... 35 more fields]
(11) Project
Arguments: [COLL0#423526, COLL1#423527, COLL2#423528, COLL3#423529, COLL4#423530, COLL5#423531, COLL6#423532, COLL7#423533, COLL8#423534, COLL9#423535, COLL10#423536, COLL11#423537, COLL12#423538, COLL13#423539, COLL14#423540, COLL15#423541, COLL16#423542, COLL17#423543, COLL18#423544, COLL19#423545, COLL20#423546, COLL21#423547, COLL22#423548, COLL23#423549, ... 35 more fields]
(12) Project
Arguments: [COLL1#423527 AS AL_ANNVAL_438378#423703, COLL20#423546 AS AL_CLASSE_438397#423704, COLL47#423573 AS AL_CODCHA_438424#423705, COLL10#423536 AS AL_CODSIT_438387#423706, COLL9#423535 AS AL_CODUTI_438386#423707, COLL0#423526 AS AL_CODVAL_438377#423708, COLL45#423571 AS AL_COMMENT_438422#423709, COLL43#423569 AS AL_DATEDE_438420#423710, COLL55#423581 AS AL_DATEFI_438432#423711, COLL8#423534 AS AL_DATMAJ_438385#423712, COLL16#423542 AS AL_ENVADM_438393#423713, COLL42#423568 AS AL_FLICPT_438419#423714, COLL41#423567 AS AL_FLSEJ_438418#423715, COLL46#423572 AS AL_FLTELE_438423#423716, COLL19#423545 AS AL_FORFAI_438396#423717, COLL57#423583 AS AL_ICD_438434#423718, COLL52#423578 AS AL_INT_SPE_438429#423719, COLL51#423577 AS AL_INT_STD_438428#423720, COLL15#423541 AS AL_LETADM_438392#423721, COLL48#423574 AS AL_LETADS_438425#423722, COLL3#423529 AS AL_LIB30_438380#423723, COLL4#423530 AS AL_LIBMAJ_438381#423724, COLL11#423537 AS AL_MONNAIE_438388#423725, COLL13#423539 AS AL_NUMBMP_438390#423726, ... 36 more fields]
(13) Union
Arguments: false, false
(14) Project
Arguments: [AL_ANNVAL_438378#423170, AL_CLASSE_438397#423171, AL_CODCHA_438424#423172, AL_CODSIT_438387#423173, AL_CODUTI_438386#423174, AL_CODVAL_438377#423175, AL_COMMENT_438422#423176, AL_DATEDE_438420#423177, AL_DATEFI_438432#423178, AL_DATMAJ_438385#423179, AL_ENVADM_438393#423180, AL_FLICPT_438419#423181, AL_FLSEJ_438418#423182, AL_FLTELE_438423#423183, AL_FORFAI_438396#423184, AL_ICD_438434#423185, AL_INT_SPE_438429#423186, AL_INT_STD_438428#423187, AL_LETADM_438392#423188, AL_LETADS_438425#423189, AL_LIB30_438380#423190, AL_LIBMAJ_438381#423191, AL_MONNAIE_438388#423192, AL_NUMBMP_438390#423193, ... 36 more fields]