== 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_EXAMEN_43781996`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: JDBCRelation((SELECT "xa_codexa", "xa_lib30", "xa_libuti", "xa_typexa", "xa_contra", "xa_durava", "xa_durpen", "xa_durapr", "xa_durtot", "xa_durmed", "xa_protoc", "xa_datmaj", "xa_coduti", "xa_codpro", "xa_coulstd", "xa_couleur", "xa_flmedobl", "xa_flatsobl", "xa_flvalplanif", "xa_flvalaccueil", "xa_nivvcr", "xa_flrtcclq", "xa_fllabochaud", "xa_datede", "xa_datefi", "xa_flgrpjour", "xa_primai", "xa_codpros", "xa_codconv", "xa_later", "xa_incidence", "xa_position", "xa_flgrve", "xa_flexainj", "xa_contrapat", "xa_flprore", "xa_flcacheinet", "xa_flnocot", "xa_codadm", "xa_flgrvi", "xa_reganas", "xa_flrecist", "xa_flnocr", "xa_icd", "xa_type_icd", "xa_flrecist_ec", "xa_codloinc" FROM "xplore"."h_examen") as x) [numPartitions=1], [xa_codexa#786620, xa_lib30#786621, xa_libuti#786622, xa_typexa#786623, xa_contra#786624, xa_durava#786625, xa_durpen#786626, xa_durapr#786627, xa_durtot#786628, xa_durmed#786629, xa_protoc#786630, xa_datmaj#786631, xa_coduti#786632, xa_codpro#786633, xa_coulstd#786634, xa_couleur#786635, xa_flmedobl#786636, xa_flatsobl#786637, xa_flvalplanif#786638, xa_flvalaccueil#786639, xa_nivvcr#786640, xa_flrtcclq#786641, xa_fllabochaud#786642, xa_datede#786643, ... 23 more fields], false
(4) Project
Arguments: [xa_codexa#786620 AS COLL0#786714, xa_lib30#786621 AS COLL1#786715, xa_libuti#786622 AS COLL2#786716, xa_typexa#786623 AS COLL3#786717, xa_contra#786624 AS COLL4#786718, xa_durava#786625 AS COLL5#786719, xa_durpen#786626 AS COLL6#786720, xa_durapr#786627 AS COLL7#786721, xa_durtot#786628 AS COLL8#786722, xa_durmed#786629 AS COLL9#786723, xa_protoc#786630 AS COLL10#786724, xa_datmaj#786631 AS COLL11#786725, xa_coduti#786632 AS COLL12#786726, xa_codpro#786633 AS COLL13#786727, xa_coulstd#786634 AS COLL14#786728, xa_couleur#786635 AS COLL15#786729, xa_flmedobl#786636 AS COLL16#786730, xa_flatsobl#786637 AS COLL17#786731, xa_flvalplanif#786638 AS COLL18#786732, xa_flvalaccueil#786639 AS COLL19#786733, xa_nivvcr#786640 AS COLL20#786734, xa_flrtcclq#786641 AS COLL21#786735, xa_fllabochaud#786642 AS COLL22#786736, xa_datede#786643 AS COLL23#786737, ... 23 more fields]
(5) Project
Arguments: [COLL0#786714 AS COLL0#786808, COLL1#786715 AS COLL1#786809, COLL2#786716 AS COLL2#786810, COLL3#786717 AS COLL3#786811, COLL4#786718 AS COLL4#786812, COLL5#786719 AS COLL5#786813, COLL6#786720 AS COLL6#786814, COLL7#786721 AS COLL7#786815, COLL8#786722 AS COLL8#786816, COLL9#786723 AS COLL9#786817, COLL10#786724 AS COLL10#786818, COLL11#786725 AS COLL11#786819, COLL12#786726 AS COLL12#786820, COLL13#786727 AS COLL13#786821, COLL14#786728 AS COLL14#786822, COLL15#786729 AS COLL15#786823, COLL16#786730 AS COLL16#786824, COLL17#786731 AS COLL17#786825, COLL18#786732 AS COLL18#786826, COLL19#786733 AS COLL19#786827, COLL20#786734 AS COLL20#786828, COLL21#786735 AS COLL21#786829, COLL22#786736 AS COLL22#786830, COLL23#786737 AS COLL23#786831, ... 23 more fields]
(6) Project
Arguments: [COLL0#786808, COLL1#786809, COLL2#786810, COLL3#786811, COLL4#786812, COLL5#786813, COLL6#786814, COLL7#786815, COLL8#786816, COLL9#786817, COLL10#786818, COLL11#786819, COLL12#786820, COLL13#786821, COLL14#786822, COLL15#786823, COLL16#786824, COLL17#786825, COLL18#786826, COLL19#786827, COLL20#786828, COLL21#786829, COLL22#786830, COLL23#786831, ... 23 more fields]
(7) Project
Arguments: [cast(str_create(cast(Cab_A as string)) as string) AS ORIGINE_440144#786997, COLL38#786846 AS XA_CODADM_437858#786950, COLL28#786836 AS XA_CODCONV_437848#786951, COLL0#786808 AS XA_CODEXA_437820#786952, COLL46#786854 AS XA_CODLOINC_437866#786953, COLL27#786835 AS XA_CODPROS_437847#786954, COLL13#786821 AS XA_CODPRO_437833#786955, COLL12#786820 AS XA_CODUTI_437832#786956, COLL34#786842 AS XA_CONTRAPAT_437854#786957, COLL4#786812 AS XA_CONTRA_437824#786958, COLL15#786823 AS XA_COULEUR_437835#786959, COLL14#786822 AS XA_COULSTD_437834#786960, COLL23#786831 AS XA_DATEDE_437843#786961, COLL24#786832 AS XA_DATEFI_437844#786962, COLL11#786819 AS XA_DATMAJ_437831#786963, COLL7#786815 AS XA_DURAPR_437827#786964, COLL5#786813 AS XA_DURAVA_437825#786965, COLL9#786817 AS XA_DURMED_437829#786966, COLL6#786814 AS XA_DURPEN_437826#786967, COLL8#786816 AS XA_DURTOT_437828#786968, COLL17#786825 AS XA_FLATSOBL_437837#786969, COLL36#786844 AS XA_FLCACHEINET_437856#786970, COLL33#786841 AS XA_FLEXAINJ_437853#786971, COLL25#786833 AS XA_FLGRPJOUR_437845#786972, ... 24 more fields]
(8) LogicalRelation
Arguments: JDBCRelation((SELECT "xa_codexa", "xa_lib30", "xa_libuti", "xa_typexa", "xa_contra", "xa_durava", "xa_durpen", "xa_durapr", "xa_durtot", "xa_durmed", "xa_protoc", "xa_datmaj", "xa_coduti", "xa_codpro", "xa_coulstd", "xa_couleur", "xa_flmedobl", "xa_flatsobl", "xa_flvalplanif", "xa_flvalaccueil", "xa_nivvcr", "xa_flrtcclq", "xa_fllabochaud", "xa_datede", "xa_datefi", "xa_flgrpjour", "xa_primai", "xa_codpros", "xa_codconv", "xa_later", "xa_incidence", "xa_position", "xa_flgrve", "xa_flexainj", "xa_contrapat", "xa_flprore", "xa_flcacheinet", "xa_flnocot", "xa_codadm", "xa_flgrvi", "xa_reganas", "xa_flrecist", "xa_flnocr", "xa_icd", "xa_type_icd", "xa_flrecist_ec", "xa_codloinc" FROM "xplore2"."h_examen") as x) [numPartitions=1], [xa_codexa#787046, xa_lib30#787047, xa_libuti#787048, xa_typexa#787049, xa_contra#787050, xa_durava#787051, xa_durpen#787052, xa_durapr#787053, xa_durtot#787054, xa_durmed#787055, xa_protoc#787056, xa_datmaj#787057, xa_coduti#787058, xa_codpro#787059, xa_coulstd#787060, xa_couleur#787061, xa_flmedobl#787062, xa_flatsobl#787063, xa_flvalplanif#787064, xa_flvalaccueil#787065, xa_nivvcr#787066, xa_flrtcclq#787067, xa_fllabochaud#787068, xa_datede#787069, ... 23 more fields], false
(9) Project
Arguments: [xa_codexa#787046 AS COLL0#787140, xa_lib30#787047 AS COLL1#787141, xa_libuti#787048 AS COLL2#787142, xa_typexa#787049 AS COLL3#787143, xa_contra#787050 AS COLL4#787144, xa_durava#787051 AS COLL5#787145, xa_durpen#787052 AS COLL6#787146, xa_durapr#787053 AS COLL7#787147, xa_durtot#787054 AS COLL8#787148, xa_durmed#787055 AS COLL9#787149, xa_protoc#787056 AS COLL10#787150, xa_datmaj#787057 AS COLL11#787151, xa_coduti#787058 AS COLL12#787152, xa_codpro#787059 AS COLL13#787153, xa_coulstd#787060 AS COLL14#787154, xa_couleur#787061 AS COLL15#787155, xa_flmedobl#787062 AS COLL16#787156, xa_flatsobl#787063 AS COLL17#787157, xa_flvalplanif#787064 AS COLL18#787158, xa_flvalaccueil#787065 AS COLL19#787159, xa_nivvcr#787066 AS COLL20#787160, xa_flrtcclq#787067 AS COLL21#787161, xa_fllabochaud#787068 AS COLL22#787162, xa_datede#787069 AS COLL23#787163, ... 23 more fields]
(10) Project
Arguments: [COLL0#787140 AS COLL0#787234, COLL1#787141 AS COLL1#787235, COLL2#787142 AS COLL2#787236, COLL3#787143 AS COLL3#787237, COLL4#787144 AS COLL4#787238, COLL5#787145 AS COLL5#787239, COLL6#787146 AS COLL6#787240, COLL7#787147 AS COLL7#787241, COLL8#787148 AS COLL8#787242, COLL9#787149 AS COLL9#787243, COLL10#787150 AS COLL10#787244, COLL11#787151 AS COLL11#787245, COLL12#787152 AS COLL12#787246, COLL13#787153 AS COLL13#787247, COLL14#787154 AS COLL14#787248, COLL15#787155 AS COLL15#787249, COLL16#787156 AS COLL16#787250, COLL17#787157 AS COLL17#787251, COLL18#787158 AS COLL18#787252, COLL19#787159 AS COLL19#787253, COLL20#787160 AS COLL20#787254, COLL21#787161 AS COLL21#787255, COLL22#787162 AS COLL22#787256, COLL23#787163 AS COLL23#787257, ... 23 more fields]
(11) Project
Arguments: [COLL0#787234, COLL1#787235, COLL2#787236, COLL3#787237, COLL4#787238, COLL5#787239, COLL6#787240, COLL7#787241, COLL8#787242, COLL9#787243, COLL10#787244, COLL11#787245, COLL12#787246, COLL13#787247, COLL14#787248, COLL15#787249, COLL16#787250, COLL17#787251, COLL18#787252, COLL19#787253, COLL20#787254, COLL21#787255, COLL22#787256, COLL23#787257, ... 23 more fields]
(12) Project
Arguments: [cast(str_create(cast(Cab_B as string)) as string) AS ORIGINE_440144#787423, COLL38#787272 AS XA_CODADM_437858#787376, COLL28#787262 AS XA_CODCONV_437848#787377, COLL0#787234 AS XA_CODEXA_437820#787378, COLL46#787280 AS XA_CODLOINC_437866#787379, COLL27#787261 AS XA_CODPROS_437847#787380, COLL13#787247 AS XA_CODPRO_437833#787381, COLL12#787246 AS XA_CODUTI_437832#787382, COLL34#787268 AS XA_CONTRAPAT_437854#787383, COLL4#787238 AS XA_CONTRA_437824#787384, COLL15#787249 AS XA_COULEUR_437835#787385, COLL14#787248 AS XA_COULSTD_437834#787386, COLL23#787257 AS XA_DATEDE_437843#787387, COLL24#787258 AS XA_DATEFI_437844#787388, COLL11#787245 AS XA_DATMAJ_437831#787389, COLL7#787241 AS XA_DURAPR_437827#787390, COLL5#787239 AS XA_DURAVA_437825#787391, COLL9#787243 AS XA_DURMED_437829#787392, COLL6#787240 AS XA_DURPEN_437826#787393, COLL8#787242 AS XA_DURTOT_437828#787394, COLL17#787251 AS XA_FLATSOBL_437837#787395, COLL36#787270 AS XA_FLCACHEINET_437856#787396, COLL33#787267 AS XA_FLEXAINJ_437853#787397, COLL25#787259 AS XA_FLGRPJOUR_437845#787398, ... 24 more fields]
(13) Union
Arguments: false, false
(14) Project
Arguments: [ORIGINE_440144#786997, XA_CODADM_437858#786950, XA_CODCONV_437848#786951, XA_CODEXA_437820#786952, XA_CODLOINC_437866#786953, XA_CODPROS_437847#786954, XA_CODPRO_437833#786955, XA_CODUTI_437832#786956, XA_CONTRAPAT_437854#786957, XA_CONTRA_437824#786958, XA_COULEUR_437835#786959, XA_COULSTD_437834#786960, XA_DATEDE_437843#786961, XA_DATEFI_437844#786962, XA_DATMAJ_437831#786963, XA_DURAPR_437827#786964, XA_DURAVA_437825#786965, XA_DURMED_437829#786966, XA_DURPEN_437826#786967, XA_DURTOT_437828#786968, XA_FLATSOBL_437837#786969, XA_FLCACHEINET_437856#786970, XA_FLEXAINJ_437853#786971, XA_FLGRPJOUR_437845#786972, ... 24 more fields]