== 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_43781989`, 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#785139, xa_lib30#785140, xa_libuti#785141, xa_typexa#785142, xa_contra#785143, xa_durava#785144, xa_durpen#785145, xa_durapr#785146, xa_durtot#785147, xa_durmed#785148, xa_protoc#785149, xa_datmaj#785150, xa_coduti#785151, xa_codpro#785152, xa_coulstd#785153, xa_couleur#785154, xa_flmedobl#785155, xa_flatsobl#785156, xa_flvalplanif#785157, xa_flvalaccueil#785158, xa_nivvcr#785159, xa_flrtcclq#785160, xa_fllabochaud#785161, xa_datede#785162, ... 23 more fields], false
(4) Project
Arguments: [xa_codexa#785139 AS COLL0#785233, xa_lib30#785140 AS COLL1#785234, xa_libuti#785141 AS COLL2#785235, xa_typexa#785142 AS COLL3#785236, xa_contra#785143 AS COLL4#785237, xa_durava#785144 AS COLL5#785238, xa_durpen#785145 AS COLL6#785239, xa_durapr#785146 AS COLL7#785240, xa_durtot#785147 AS COLL8#785241, xa_durmed#785148 AS COLL9#785242, xa_protoc#785149 AS COLL10#785243, xa_datmaj#785150 AS COLL11#785244, xa_coduti#785151 AS COLL12#785245, xa_codpro#785152 AS COLL13#785246, xa_coulstd#785153 AS COLL14#785247, xa_couleur#785154 AS COLL15#785248, xa_flmedobl#785155 AS COLL16#785249, xa_flatsobl#785156 AS COLL17#785250, xa_flvalplanif#785157 AS COLL18#785251, xa_flvalaccueil#785158 AS COLL19#785252, xa_nivvcr#785159 AS COLL20#785253, xa_flrtcclq#785160 AS COLL21#785254, xa_fllabochaud#785161 AS COLL22#785255, xa_datede#785162 AS COLL23#785256, ... 23 more fields]
(5) Project
Arguments: [COLL0#785233 AS COLL0#785327, COLL1#785234 AS COLL1#785328, COLL2#785235 AS COLL2#785329, COLL3#785236 AS COLL3#785330, COLL4#785237 AS COLL4#785331, COLL5#785238 AS COLL5#785332, COLL6#785239 AS COLL6#785333, COLL7#785240 AS COLL7#785334, COLL8#785241 AS COLL8#785335, COLL9#785242 AS COLL9#785336, COLL10#785243 AS COLL10#785337, COLL11#785244 AS COLL11#785338, COLL12#785245 AS COLL12#785339, COLL13#785246 AS COLL13#785340, COLL14#785247 AS COLL14#785341, COLL15#785248 AS COLL15#785342, COLL16#785249 AS COLL16#785343, COLL17#785250 AS COLL17#785344, COLL18#785251 AS COLL18#785345, COLL19#785252 AS COLL19#785346, COLL20#785253 AS COLL20#785347, COLL21#785254 AS COLL21#785348, COLL22#785255 AS COLL22#785349, COLL23#785256 AS COLL23#785350, ... 23 more fields]
(6) Project
Arguments: [COLL0#785327, COLL1#785328, COLL2#785329, COLL3#785330, COLL4#785331, COLL5#785332, COLL6#785333, COLL7#785334, COLL8#785335, COLL9#785336, COLL10#785337, COLL11#785338, COLL12#785339, COLL13#785340, COLL14#785341, COLL15#785342, COLL16#785343, COLL17#785344, COLL18#785345, COLL19#785346, COLL20#785347, COLL21#785348, COLL22#785349, COLL23#785350, ... 23 more fields]
(7) Project
Arguments: [cast(str_create(cast(Cab_A as string)) as string) AS ORIGINE_440144#785516, COLL38#785365 AS XA_CODADM_437858#785469, COLL28#785355 AS XA_CODCONV_437848#785470, COLL0#785327 AS XA_CODEXA_437820#785471, COLL46#785373 AS XA_CODLOINC_437866#785472, COLL27#785354 AS XA_CODPROS_437847#785473, COLL13#785340 AS XA_CODPRO_437833#785474, COLL12#785339 AS XA_CODUTI_437832#785475, COLL34#785361 AS XA_CONTRAPAT_437854#785476, COLL4#785331 AS XA_CONTRA_437824#785477, COLL15#785342 AS XA_COULEUR_437835#785478, COLL14#785341 AS XA_COULSTD_437834#785479, COLL23#785350 AS XA_DATEDE_437843#785480, COLL24#785351 AS XA_DATEFI_437844#785481, COLL11#785338 AS XA_DATMAJ_437831#785482, COLL7#785334 AS XA_DURAPR_437827#785483, COLL5#785332 AS XA_DURAVA_437825#785484, COLL9#785336 AS XA_DURMED_437829#785485, COLL6#785333 AS XA_DURPEN_437826#785486, COLL8#785335 AS XA_DURTOT_437828#785487, COLL17#785344 AS XA_FLATSOBL_437837#785488, COLL36#785363 AS XA_FLCACHEINET_437856#785489, COLL33#785360 AS XA_FLEXAINJ_437853#785490, COLL25#785352 AS XA_FLGRPJOUR_437845#785491, ... 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#785565, xa_lib30#785566, xa_libuti#785567, xa_typexa#785568, xa_contra#785569, xa_durava#785570, xa_durpen#785571, xa_durapr#785572, xa_durtot#785573, xa_durmed#785574, xa_protoc#785575, xa_datmaj#785576, xa_coduti#785577, xa_codpro#785578, xa_coulstd#785579, xa_couleur#785580, xa_flmedobl#785581, xa_flatsobl#785582, xa_flvalplanif#785583, xa_flvalaccueil#785584, xa_nivvcr#785585, xa_flrtcclq#785586, xa_fllabochaud#785587, xa_datede#785588, ... 23 more fields], false
(9) Project
Arguments: [xa_codexa#785565 AS COLL0#785659, xa_lib30#785566 AS COLL1#785660, xa_libuti#785567 AS COLL2#785661, xa_typexa#785568 AS COLL3#785662, xa_contra#785569 AS COLL4#785663, xa_durava#785570 AS COLL5#785664, xa_durpen#785571 AS COLL6#785665, xa_durapr#785572 AS COLL7#785666, xa_durtot#785573 AS COLL8#785667, xa_durmed#785574 AS COLL9#785668, xa_protoc#785575 AS COLL10#785669, xa_datmaj#785576 AS COLL11#785670, xa_coduti#785577 AS COLL12#785671, xa_codpro#785578 AS COLL13#785672, xa_coulstd#785579 AS COLL14#785673, xa_couleur#785580 AS COLL15#785674, xa_flmedobl#785581 AS COLL16#785675, xa_flatsobl#785582 AS COLL17#785676, xa_flvalplanif#785583 AS COLL18#785677, xa_flvalaccueil#785584 AS COLL19#785678, xa_nivvcr#785585 AS COLL20#785679, xa_flrtcclq#785586 AS COLL21#785680, xa_fllabochaud#785587 AS COLL22#785681, xa_datede#785588 AS COLL23#785682, ... 23 more fields]
(10) Project
Arguments: [COLL0#785659 AS COLL0#785753, COLL1#785660 AS COLL1#785754, COLL2#785661 AS COLL2#785755, COLL3#785662 AS COLL3#785756, COLL4#785663 AS COLL4#785757, COLL5#785664 AS COLL5#785758, COLL6#785665 AS COLL6#785759, COLL7#785666 AS COLL7#785760, COLL8#785667 AS COLL8#785761, COLL9#785668 AS COLL9#785762, COLL10#785669 AS COLL10#785763, COLL11#785670 AS COLL11#785764, COLL12#785671 AS COLL12#785765, COLL13#785672 AS COLL13#785766, COLL14#785673 AS COLL14#785767, COLL15#785674 AS COLL15#785768, COLL16#785675 AS COLL16#785769, COLL17#785676 AS COLL17#785770, COLL18#785677 AS COLL18#785771, COLL19#785678 AS COLL19#785772, COLL20#785679 AS COLL20#785773, COLL21#785680 AS COLL21#785774, COLL22#785681 AS COLL22#785775, COLL23#785682 AS COLL23#785776, ... 23 more fields]
(11) Project
Arguments: [COLL0#785753, COLL1#785754, COLL2#785755, COLL3#785756, COLL4#785757, COLL5#785758, COLL6#785759, COLL7#785760, COLL8#785761, COLL9#785762, COLL10#785763, COLL11#785764, COLL12#785765, COLL13#785766, COLL14#785767, COLL15#785768, COLL16#785769, COLL17#785770, COLL18#785771, COLL19#785772, COLL20#785773, COLL21#785774, COLL22#785775, COLL23#785776, ... 23 more fields]
(12) Project
Arguments: [cast(str_create(cast(Cab_B as string)) as string) AS ORIGINE_440144#785942, COLL38#785791 AS XA_CODADM_437858#785895, COLL28#785781 AS XA_CODCONV_437848#785896, COLL0#785753 AS XA_CODEXA_437820#785897, COLL46#785799 AS XA_CODLOINC_437866#785898, COLL27#785780 AS XA_CODPROS_437847#785899, COLL13#785766 AS XA_CODPRO_437833#785900, COLL12#785765 AS XA_CODUTI_437832#785901, COLL34#785787 AS XA_CONTRAPAT_437854#785902, COLL4#785757 AS XA_CONTRA_437824#785903, COLL15#785768 AS XA_COULEUR_437835#785904, COLL14#785767 AS XA_COULSTD_437834#785905, COLL23#785776 AS XA_DATEDE_437843#785906, COLL24#785777 AS XA_DATEFI_437844#785907, COLL11#785764 AS XA_DATMAJ_437831#785908, COLL7#785760 AS XA_DURAPR_437827#785909, COLL5#785758 AS XA_DURAVA_437825#785910, COLL9#785762 AS XA_DURMED_437829#785911, COLL6#785759 AS XA_DURPEN_437826#785912, COLL8#785761 AS XA_DURTOT_437828#785913, COLL17#785770 AS XA_FLATSOBL_437837#785914, COLL36#785789 AS XA_FLCACHEINET_437856#785915, COLL33#785786 AS XA_FLEXAINJ_437853#785916, COLL25#785778 AS XA_FLGRPJOUR_437845#785917, ... 24 more fields]
(13) Union
Arguments: false, false
(14) Project
Arguments: [ORIGINE_440144#785516, XA_CODADM_437858#785469, XA_CODCONV_437848#785470, XA_CODEXA_437820#785471, XA_CODLOINC_437866#785472, XA_CODPROS_437847#785473, XA_CODPRO_437833#785474, XA_CODUTI_437832#785475, XA_CONTRAPAT_437854#785476, XA_CONTRA_437824#785477, XA_COULEUR_437835#785478, XA_COULSTD_437834#785479, XA_DATEDE_437843#785480, XA_DATEFI_437844#785481, XA_DATMAJ_437831#785482, XA_DURAPR_437827#785483, XA_DURAVA_437825#785484, XA_DURMED_437829#785485, XA_DURPEN_437826#785486, XA_DURTOT_437828#785487, XA_FLATSOBL_437837#785488, XA_FLCACHEINET_437856#785489, XA_FLEXAINJ_437853#785490, XA_FLGRPJOUR_437845#785491, ... 24 more fields]