== 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_PATIEN_438022103`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore"."h_patien") as x) [numPartitions=1], [at_numdos#780934, at_stapat#780935, at_prefix#780936, at_nompat#780937, at_pnopat#780938, at_njfpat#780939, at_datnai#780940, at_datnaiss#780941, at_sexe#780942, at_numper#780943, at_sigma#780944, at_verrou#780945, at_poids#780946, at_indcen#780947, at_numss#780948, at_antece#780949, at_adr_1#780950, at_adr_2#780951, at_codpos#780952, at_ville#780953, at_pays#780954, at_numcai#780955, at_nummut#780956, at_numcha#780957, ... 112 more fields], false
(4) Project
Arguments: [at_numdos#780934 AS COLL0#781206, at_stapat#780935 AS COLL1#781207, at_prefix#780936 AS COLL2#781208, at_nompat#780937 AS COLL3#781209, at_pnopat#780938 AS COLL4#781210, at_njfpat#780939 AS COLL5#781211, at_datnai#780940 AS COLL6#781212, at_datnaiss#780941 AS COLL7#781213, at_sexe#780942 AS COLL8#781214, at_numper#780943 AS COLL9#781215, at_sigma#780944 AS COLL10#781216, at_verrou#780945 AS COLL11#781217, at_poids#780946 AS COLL12#781218, at_indcen#780947 AS COLL13#781219, at_numss#780948 AS COLL14#781220, at_antece#780949 AS COLL15#781221, at_adr_1#780950 AS COLL16#781222, at_adr_2#780951 AS COLL17#781223, at_codpos#780952 AS COLL18#781224, at_ville#780953 AS COLL19#781225, at_pays#780954 AS COLL20#781226, at_numcai#780955 AS COLL21#781227, at_nummut#780956 AS COLL22#781228, at_numcha#780957 AS COLL23#781229, ... 112 more fields]
(5) Project
Arguments: [COLL0#781206 AS COLL0#781478, COLL1#781207 AS COLL1#781479, COLL2#781208 AS COLL2#781480, COLL3#781209 AS COLL3#781481, COLL4#781210 AS COLL4#781482, COLL5#781211 AS COLL5#781483, COLL6#781212 AS COLL6#781484, COLL7#781213 AS COLL7#781485, COLL8#781214 AS COLL8#781486, COLL9#781215 AS COLL9#781487, COLL10#781216 AS COLL10#781488, COLL11#781217 AS COLL11#781489, COLL12#781218 AS COLL12#781490, COLL13#781219 AS COLL13#781491, COLL14#781220 AS COLL14#781492, COLL15#781221 AS COLL15#781493, COLL16#781222 AS COLL16#781494, COLL17#781223 AS COLL17#781495, COLL18#781224 AS COLL18#781496, COLL19#781225 AS COLL19#781497, COLL20#781226 AS COLL20#781498, COLL21#781227 AS COLL21#781499, COLL22#781228 AS COLL22#781500, COLL23#781229 AS COLL23#781501, ... 112 more fields]
(6) Project
Arguments: [COLL0#781478, COLL1#781479, COLL2#781480, COLL3#781481, COLL4#781482, COLL5#781483, COLL6#781484, COLL7#781485, COLL8#781486, COLL9#781487, COLL10#781488, COLL11#781489, COLL12#781490, COLL13#781491, COLL14#781492, COLL15#781493, COLL16#781494, COLL17#781495, COLL18#781496, COLL19#781497, COLL20#781498, COLL21#781499, COLL22#781500, COLL23#781501, ... 112 more fields]
(7) Project
Arguments: [COLL58#781536 AS AT_ADHMUT_438081#781886, COLL33#781511 AS AT_ADR_1A_438056#781887, COLL16#781494 AS AT_ADR_1_438039#781888, COLL34#781512 AS AT_ADR_2A_438057#781889, COLL17#781495 AS AT_ADR_2_438040#781890, COLL72#781550 AS AT_ADR_3A_438095#781891, COLL70#781548 AS AT_ADR_3_438093#781892, COLL89#781567 AS AT_ALARMES_438112#781893, COLL15#781493 AS AT_ANTECE_438038#781894, COLL75#781553 AS AT_ART115_438098#781895, COLL55#781533 AS AT_CODCAIAT_438078#781896, COLL78#781556 AS AT_CODETAB_PROD_438101#781897, COLL74#781552 AS AT_CODGESTION_438097#781898, COLL122#781600 AS AT_CODINSEENAI_438145#781899, COLL37#781515 AS AT_CODMED_438060#781900, COLL69#781547 AS AT_CODMTR_438092#781901, COLL96#781574 AS AT_CODPERSHLIM_438119#781902, COLL35#781513 AS AT_CODPOA_438058#781903, COLL113#781591 AS AT_CODPOSNAI_438136#781904, COLL18#781496 AS AT_CODPOS_438041#781905, COLL53#781531 AS AT_CODREF_438076#781906, COLL54#781532 AS AT_CODREGAT_438077#781907, COLL61#781539 AS AT_CODROUT_438084#781908, COLL43#781521 AS AT_CODSER_438066#781909, ... 113 more fields]
(8) LogicalRelation
Arguments: JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore2"."h_patien") as x) [numPartitions=1], [at_numdos#782161, at_stapat#782162, at_prefix#782163, at_nompat#782164, at_pnopat#782165, at_njfpat#782166, at_datnai#782167, at_datnaiss#782168, at_sexe#782169, at_numper#782170, at_sigma#782171, at_verrou#782172, at_poids#782173, at_indcen#782174, at_numss#782175, at_antece#782176, at_adr_1#782177, at_adr_2#782178, at_codpos#782179, at_ville#782180, at_pays#782181, at_numcai#782182, at_nummut#782183, at_numcha#782184, ... 112 more fields], false
(9) Project
Arguments: [at_numdos#782161 AS COLL0#782433, at_stapat#782162 AS COLL1#782434, at_prefix#782163 AS COLL2#782435, at_nompat#782164 AS COLL3#782436, at_pnopat#782165 AS COLL4#782437, at_njfpat#782166 AS COLL5#782438, at_datnai#782167 AS COLL6#782439, at_datnaiss#782168 AS COLL7#782440, at_sexe#782169 AS COLL8#782441, at_numper#782170 AS COLL9#782442, at_sigma#782171 AS COLL10#782443, at_verrou#782172 AS COLL11#782444, at_poids#782173 AS COLL12#782445, at_indcen#782174 AS COLL13#782446, at_numss#782175 AS COLL14#782447, at_antece#782176 AS COLL15#782448, at_adr_1#782177 AS COLL16#782449, at_adr_2#782178 AS COLL17#782450, at_codpos#782179 AS COLL18#782451, at_ville#782180 AS COLL19#782452, at_pays#782181 AS COLL20#782453, at_numcai#782182 AS COLL21#782454, at_nummut#782183 AS COLL22#782455, at_numcha#782184 AS COLL23#782456, ... 112 more fields]
(10) Project
Arguments: [COLL0#782433 AS COLL0#782705, COLL1#782434 AS COLL1#782706, COLL2#782435 AS COLL2#782707, COLL3#782436 AS COLL3#782708, COLL4#782437 AS COLL4#782709, COLL5#782438 AS COLL5#782710, COLL6#782439 AS COLL6#782711, COLL7#782440 AS COLL7#782712, COLL8#782441 AS COLL8#782713, COLL9#782442 AS COLL9#782714, COLL10#782443 AS COLL10#782715, COLL11#782444 AS COLL11#782716, COLL12#782445 AS COLL12#782717, COLL13#782446 AS COLL13#782718, COLL14#782447 AS COLL14#782719, COLL15#782448 AS COLL15#782720, COLL16#782449 AS COLL16#782721, COLL17#782450 AS COLL17#782722, COLL18#782451 AS COLL18#782723, COLL19#782452 AS COLL19#782724, COLL20#782453 AS COLL20#782725, COLL21#782454 AS COLL21#782726, COLL22#782455 AS COLL22#782727, COLL23#782456 AS COLL23#782728, ... 112 more fields]
(11) Project
Arguments: [COLL0#782705, COLL1#782706, COLL2#782707, COLL3#782708, COLL4#782709, COLL5#782710, COLL6#782711, COLL7#782712, COLL8#782713, COLL9#782714, COLL10#782715, COLL11#782716, COLL12#782717, COLL13#782718, COLL14#782719, COLL15#782720, COLL16#782721, COLL17#782722, COLL18#782723, COLL19#782724, COLL20#782725, COLL21#782726, COLL22#782727, COLL23#782728, ... 112 more fields]
(12) Project
Arguments: [COLL58#782763 AS AT_ADHMUT_438081#783113, COLL33#782738 AS AT_ADR_1A_438056#783114, COLL16#782721 AS AT_ADR_1_438039#783115, COLL34#782739 AS AT_ADR_2A_438057#783116, COLL17#782722 AS AT_ADR_2_438040#783117, COLL72#782777 AS AT_ADR_3A_438095#783118, COLL70#782775 AS AT_ADR_3_438093#783119, COLL89#782794 AS AT_ALARMES_438112#783120, COLL15#782720 AS AT_ANTECE_438038#783121, COLL75#782780 AS AT_ART115_438098#783122, COLL55#782760 AS AT_CODCAIAT_438078#783123, COLL78#782783 AS AT_CODETAB_PROD_438101#783124, COLL74#782779 AS AT_CODGESTION_438097#783125, COLL122#782827 AS AT_CODINSEENAI_438145#783126, COLL37#782742 AS AT_CODMED_438060#783127, COLL69#782774 AS AT_CODMTR_438092#783128, COLL96#782801 AS AT_CODPERSHLIM_438119#783129, COLL35#782740 AS AT_CODPOA_438058#783130, COLL113#782818 AS AT_CODPOSNAI_438136#783131, COLL18#782723 AS AT_CODPOS_438041#783132, COLL53#782758 AS AT_CODREF_438076#783133, COLL54#782759 AS AT_CODREGAT_438077#783134, COLL61#782766 AS AT_CODROUT_438084#783135, COLL43#782748 AS AT_CODSER_438066#783136, ... 113 more fields]
(13) Union
Arguments: false, false
(14) Project
Arguments: [AT_ADHMUT_438081#781886, AT_ADR_1A_438056#781887, AT_ADR_1_438039#781888, AT_ADR_2A_438057#781889, AT_ADR_2_438040#781890, AT_ADR_3A_438095#781891, AT_ADR_3_438093#781892, AT_ALARMES_438112#781893, AT_ANTECE_438038#781894, AT_ART115_438098#781895, AT_CODCAIAT_438078#781896, AT_CODETAB_PROD_438101#781897, AT_CODGESTION_438097#781898, AT_CODINSEENAI_438145#781899, AT_CODMED_438060#781900, AT_CODMTR_438092#781901, AT_CODPERSHLIM_438119#781902, AT_CODPOA_438058#781903, AT_CODPOSNAI_438136#781904, AT_CODPOS_438041#781905, AT_CODREF_438076#781906, AT_CODREGAT_438077#781907, AT_CODROUT_438084#781908, AT_CODSER_438066#781909, ... 113 more fields]