== Physical Plan ==
Execute CreateViewCommand (1)
+- CreateViewCommand (2)
+- Project (34)
+- SubqueryAlias (33)
+- View (32)
+- Project (31)
+- Project (30)
+- Project (29)
+- Project (28)
+- Project (27)
+- Project (26)
+- Project (25)
+- Window (24)
+- Project (23)
+- Project (22)
+- Project (21)
+- Project (20)
+- Project (19)
+- Project (18)
+- Project (17)
+- SubqueryAlias (16)
+- View (15)
+- 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: `tmp_2dc9d4bcc19c49e6b61f13eff14096a1`, 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]
(15) View
Arguments: `H_PATIEN_438022103`, true
(16) SubqueryAlias
Arguments: H_PATIEN_438022103
(17) Project
Arguments: [AT_ADHMUT_438081#781886 AS H_PATIEN_438022_AT_ADHMUT_438081#783799, AT_ADR_1A_438056#781887 AS H_PATIEN_438022_AT_ADR_1A_438056#783800, AT_ADR_1_438039#781888 AS H_PATIEN_438022_AT_ADR_1_438039#783801, AT_ADR_2A_438057#781889 AS H_PATIEN_438022_AT_ADR_2A_438057#783802, AT_ADR_2_438040#781890 AS H_PATIEN_438022_AT_ADR_2_438040#783803, AT_ADR_3A_438095#781891 AS H_PATIEN_438022_AT_ADR_3A_438095#783804, AT_ADR_3_438093#781892 AS H_PATIEN_438022_AT_ADR_3_438093#783805, AT_ALARMES_438112#781893 AS H_PATIEN_438022_AT_ALARMES_438112#783806, AT_ANTECE_438038#781894 AS H_PATIEN_438022_AT_ANTECE_438038#783807, AT_ART115_438098#781895 AS H_PATIEN_438022_AT_ART115_438098#783808, AT_CODCAIAT_438078#781896 AS H_PATIEN_438022_AT_CODCAIAT_438078#783809, AT_CODETAB_PROD_438101#781897 AS H_PATIEN_438022_AT_CODETAB_PROD_438101#783810, AT_CODGESTION_438097#781898 AS H_PATIEN_438022_AT_CODGESTION_438097#783811, AT_CODINSEENAI_438145#781899 AS H_PATIEN_438022_AT_CODINSEENAI_438145#783812, AT_CODMED_438060#781900 AS H_PATIEN_438022_AT_CODMED_438060#783813, AT_CODMTR_438092#781901 AS H_PATIEN_438022_AT_CODMTR_438092#783814, AT_CODPERSHLIM_438119#781902 AS H_PATIEN_438022_AT_CODPERSHLIM_438119#783815, AT_CODPOA_438058#781903 AS H_PATIEN_438022_AT_CODPOA_438058#783816, AT_CODPOSNAI_438136#781904 AS H_PATIEN_438022_AT_CODPOSNAI_438136#783817, AT_CODPOS_438041#781905 AS H_PATIEN_438022_AT_CODPOS_438041#783818, AT_CODREF_438076#781906 AS H_PATIEN_438022_AT_CODREF_438076#783819, AT_CODREGAT_438077#781907 AS H_PATIEN_438022_AT_CODREGAT_438077#783820, AT_CODROUT_438084#781908 AS H_PATIEN_438022_AT_CODROUT_438084#783821, AT_CODSER_438066#781909 AS H_PATIEN_438022_AT_CODSER_438066#783822, ... 113 more fields]
(18) Project
Arguments: [cast(H_PATIEN_438022_AT_NUMDOS_438023#783886 as string) AS COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#784210, cast(H_PATIEN_438022_AT_STAPAT_438024#783918 as string) AS COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#784211, cast(H_PATIEN_438022_AT_PREFIX_438025#783911 as string) AS COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#784212, cast(H_PATIEN_438022_AT_NOMPAT_438026#783881 as string) AS COL_1903FED0_88C4_4416_9E39_453E598975A3#784213, cast(H_PATIEN_438022_AT_PNOPAT_438027#783907 as string) AS COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#784214, cast(H_PATIEN_438022_AT_NJFPAT_438028#783878 as string) AS COL_1173BDDB_4834_434B_B562_ADD54184DF6C#784215, cast(H_PATIEN_438022_AT_DATNAI_438029#783845 as string) AS COL_B39F2F25_9917_471C_9C72_927B15008A79#784216, cast(H_PATIEN_438022_AT_DATNAISS_438030#783844 as string) AS COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#784217, cast(H_PATIEN_438022_AT_SEXE_438031#783914 as string) AS COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#784218, cast(H_PATIEN_438022_AT_NUMPER_438032#783890 as string) AS COL_13CE186A_07CB_408F_9DC8_70B055FE7906#784219, cast(H_PATIEN_438022_AT_SIGMA_438033#783915 as string) AS COL_A0192148_E136_47DD_A208_9DBBD298623D#784220, cast(H_PATIEN_438022_AT_VERROU_438034#783931 as string) AS COL_C44E1D51_FC35_412F_8587_4766F26D2005#784221, cast(H_PATIEN_438022_AT_POIDS_438035#783908 as string) AS COL_9E13EF38_5775_4086_A4E9_98C998913F90#784222, cast(H_PATIEN_438022_AT_INDCEN_438036#783862 as string) AS COL_E87784AF_5F41_4E47_9387_5366F03DAA96#784223, cast(H_PATIEN_438022_AT_NUMSS_438037#783898 as string) AS COL_3504B97C_435E_4E37_A619_AA21336EF10E#784224, cast(H_PATIEN_438022_AT_ANTECE_438038#783807 as string) AS COL_B7BCED3D_2AAF_4C34_9A6C_BCC6E9B03201#784225, cast(H_PATIEN_438022_AT_ADR_1_438039#783801 as string) AS COL_CA815AB9_09B3_4740_986E_6F1DDB66E02F#784226, cast(H_PATIEN_438022_AT_ADR_2_438040#783803 as string) AS COL_6B953A41_0F06_4A7F_AD96_E965AC66AF81#784227, cast(H_PATIEN_438022_AT_CODPOS_438041#783818 as string) AS COL_FFDDC6A1_B194_432A_BC32_BB97C06335B1#784228, cast(H_PATIEN_438022_AT_VILLE_438042#783934 as string) AS COL_25B5799B_6DCE_45E0_A785_300BB54B3E56#784229, cast(H_PATIEN_438022_AT_PAYS_438043#783901 as string) AS COL_35D908BC_8CAD_4B25_BFA1_055730BEE381#784230, cast(H_PATIEN_438022_AT_NUMCAI_438044#783883 as string) AS COL_DBA3E86A_81F2_4574_A13B_09ED9A697CA0#784231, cast(H_PATIEN_438022_AT_NUMMUT_438045#783889 as string) AS COL_BCE9D038_A28A_4881_9E60_024BBBAAF301#784232, cast(H_PATIEN_438022_AT_NUMCHA_438046#783885 as string) AS COL_D21231AE_A687_456F_9167_9D4B76E2EDF5#784233, ... 113 more fields]
(19) Project
Arguments: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#784210 AS COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#784484, COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#784211 AS COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#784485, COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#784212 AS COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#784486, COL_1903FED0_88C4_4416_9E39_453E598975A3#784213 AS COL_1903FED0_88C4_4416_9E39_453E598975A3#784487, COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#784214 AS COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#784488, COL_1173BDDB_4834_434B_B562_ADD54184DF6C#784215 AS COL_1173BDDB_4834_434B_B562_ADD54184DF6C#784489, COL_B39F2F25_9917_471C_9C72_927B15008A79#784216 AS COL_B39F2F25_9917_471C_9C72_927B15008A79#784490, COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#784217 AS COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#784491, COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#784218 AS COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#784492, COL_13CE186A_07CB_408F_9DC8_70B055FE7906#784219 AS COL_13CE186A_07CB_408F_9DC8_70B055FE7906#784493, COL_A0192148_E136_47DD_A208_9DBBD298623D#784220 AS COL_A0192148_E136_47DD_A208_9DBBD298623D#784494, COL_C44E1D51_FC35_412F_8587_4766F26D2005#784221 AS COL_C44E1D51_FC35_412F_8587_4766F26D2005#784495, COL_9E13EF38_5775_4086_A4E9_98C998913F90#784222 AS COL_9E13EF38_5775_4086_A4E9_98C998913F90#784496, COL_E87784AF_5F41_4E47_9387_5366F03DAA96#784223 AS COL_E87784AF_5F41_4E47_9387_5366F03DAA96#784497, COL_3504B97C_435E_4E37_A619_AA21336EF10E#784224 AS COL_3504B97C_435E_4E37_A619_AA21336EF10E#784498, COL_B7BCED3D_2AAF_4C34_9A6C_BCC6E9B03201#784225 AS COL_B7BCED3D_2AAF_4C34_9A6C_BCC6E9B03201#784499, COL_CA815AB9_09B3_4740_986E_6F1DDB66E02F#784226 AS COL_CA815AB9_09B3_4740_986E_6F1DDB66E02F#784500, COL_6B953A41_0F06_4A7F_AD96_E965AC66AF81#784227 AS COL_6B953A41_0F06_4A7F_AD96_E965AC66AF81#784501, COL_FFDDC6A1_B194_432A_BC32_BB97C06335B1#784228 AS COL_FFDDC6A1_B194_432A_BC32_BB97C06335B1#784502, COL_25B5799B_6DCE_45E0_A785_300BB54B3E56#784229 AS COL_25B5799B_6DCE_45E0_A785_300BB54B3E56#784503, COL_35D908BC_8CAD_4B25_BFA1_055730BEE381#784230 AS COL_35D908BC_8CAD_4B25_BFA1_055730BEE381#784504, COL_DBA3E86A_81F2_4574_A13B_09ED9A697CA0#784231 AS COL_DBA3E86A_81F2_4574_A13B_09ED9A697CA0#784505, COL_BCE9D038_A28A_4881_9E60_024BBBAAF301#784232 AS COL_BCE9D038_A28A_4881_9E60_024BBBAAF301#784506, COL_D21231AE_A687_456F_9167_9D4B76E2EDF5#784233 AS COL_D21231AE_A687_456F_9167_9D4B76E2EDF5#784507, ... 113 more fields]
(20) Project
Arguments: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#784484 AS COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#784758, COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#784485 AS COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#784759, COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#784486 AS COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#784760, COL_1903FED0_88C4_4416_9E39_453E598975A3#784487 AS COL_1903FED0_88C4_4416_9E39_453E598975A3#784761, COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#784488 AS COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#784762, COL_1173BDDB_4834_434B_B562_ADD54184DF6C#784489 AS COL_1173BDDB_4834_434B_B562_ADD54184DF6C#784763, COL_B39F2F25_9917_471C_9C72_927B15008A79#784490 AS COL_B39F2F25_9917_471C_9C72_927B15008A79#784764, COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#784491 AS COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#784765, COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#784492 AS COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#784766]
(21) Project
Arguments: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#784758 AS COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#784776, COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#784759 AS COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#784777, COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#784760 AS COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#784778, COL_1903FED0_88C4_4416_9E39_453E598975A3#784761 AS COL_1903FED0_88C4_4416_9E39_453E598975A3#784779, COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#784762 AS COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#784780, COL_1173BDDB_4834_434B_B562_ADD54184DF6C#784763 AS COL_1173BDDB_4834_434B_B562_ADD54184DF6C#784781, COL_B39F2F25_9917_471C_9C72_927B15008A79#784764 AS COL_B39F2F25_9917_471C_9C72_927B15008A79#784782, COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#784765 AS COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#784783, COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#784766 AS COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#784784]
(22) Project
Arguments: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#784776, COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#784777, COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#784778, COL_1903FED0_88C4_4416_9E39_453E598975A3#784779, COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#784780, COL_1173BDDB_4834_434B_B562_ADD54184DF6C#784781, COL_B39F2F25_9917_471C_9C72_927B15008A79#784782, COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#784783, COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#784784, 1 AS CONST#784794]
(23) Project
Arguments: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#784776, COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#784777, COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#784778, COL_1903FED0_88C4_4416_9E39_453E598975A3#784779, COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#784780, COL_1173BDDB_4834_434B_B562_ADD54184DF6C#784781, COL_B39F2F25_9917_471C_9C72_927B15008A79#784782, COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#784783, COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#784784, CONST#784794]
(24) Window
Arguments: [row_number() windowspecdefinition(1, CONST#784794 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#784806], [1], [CONST#784794 DESC NULLS LAST]
(25) Project
Arguments: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#784776, COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#784777, COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#784778, COL_1903FED0_88C4_4416_9E39_453E598975A3#784779, COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#784780, COL_1173BDDB_4834_434B_B562_ADD54184DF6C#784781, COL_B39F2F25_9917_471C_9C72_927B15008A79#784782, COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#784783, COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#784784, CONST#784794, COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#784806, COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#784806]
(26) Project
Arguments: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#784776, COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#784777, COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#784778, COL_1903FED0_88C4_4416_9E39_453E598975A3#784779, COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#784780, COL_1173BDDB_4834_434B_B562_ADD54184DF6C#784781, COL_B39F2F25_9917_471C_9C72_927B15008A79#784782, COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#784783, COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#784784, CONST#784794, COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#784806]
(27) Project
Arguments: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#784776, COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#784777, COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#784778, COL_1903FED0_88C4_4416_9E39_453E598975A3#784779, COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#784780, COL_1173BDDB_4834_434B_B562_ADD54184DF6C#784781, COL_B39F2F25_9917_471C_9C72_927B15008A79#784782, COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#784783, COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#784784, COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#784806]
(28) Project
Arguments: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#784776 AS COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#784828, COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#784777 AS COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#784829, COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#784778 AS COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#784830, COL_1903FED0_88C4_4416_9E39_453E598975A3#784779 AS COL_1903FED0_88C4_4416_9E39_453E598975A3#784831, COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#784780 AS COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#784832, COL_1173BDDB_4834_434B_B562_ADD54184DF6C#784781 AS COL_1173BDDB_4834_434B_B562_ADD54184DF6C#784833, COL_B39F2F25_9917_471C_9C72_927B15008A79#784782 AS COL_B39F2F25_9917_471C_9C72_927B15008A79#784834, COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#784783 AS COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#784835, COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#784784 AS COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#784836, COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#784806 AS COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#784837]
(29) Project
Arguments: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#784828 AS COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#784848, COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#784829 AS COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#784849, COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#784830 AS COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#784850, COL_1903FED0_88C4_4416_9E39_453E598975A3#784831 AS COL_1903FED0_88C4_4416_9E39_453E598975A3#784851, COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#784832 AS COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#784852, COL_1173BDDB_4834_434B_B562_ADD54184DF6C#784833 AS COL_1173BDDB_4834_434B_B562_ADD54184DF6C#784853, COL_B39F2F25_9917_471C_9C72_927B15008A79#784834 AS COL_B39F2F25_9917_471C_9C72_927B15008A79#784854, COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#784835 AS COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#784855, COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#784836 AS COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#784856, COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#784837 AS COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#784857]
(30) Project
Arguments: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#784848, COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#784849, COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#784850, COL_1903FED0_88C4_4416_9E39_453E598975A3#784851, COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#784852, COL_1173BDDB_4834_434B_B562_ADD54184DF6C#784853, COL_B39F2F25_9917_471C_9C72_927B15008A79#784854, COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#784855, COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#784856, COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#784857, str_concat(array(cast(U1 as string), str_complete(bigint_to_str(COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#784857), cast(0 as string), cast(10 as bigint), cast(LEFT as string)))) AS COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#784868]
(31) Project
Arguments: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#784848 AS COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#784880, COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#784849 AS COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#784881, COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#784850 AS COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#784882, COL_1903FED0_88C4_4416_9E39_453E598975A3#784851 AS COL_1903FED0_88C4_4416_9E39_453E598975A3#784883, COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#784852 AS COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#784884, COL_1173BDDB_4834_434B_B562_ADD54184DF6C#784853 AS COL_1173BDDB_4834_434B_B562_ADD54184DF6C#784885, COL_B39F2F25_9917_471C_9C72_927B15008A79#784854 AS COL_B39F2F25_9917_471C_9C72_927B15008A79#784886, COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#784855 AS COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#784887, COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#784856 AS COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#784888, COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#784857 AS COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#784889, COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#784868 AS COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#784890]
(32) View
Arguments: `H_PATIEN_440160103`, true
(33) SubqueryAlias
Arguments: H_PATIEN_440160103
(34) Project
Arguments: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#784880, COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#784881, COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#784882, COL_1903FED0_88C4_4416_9E39_453E598975A3#784883, COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#784884, COL_1173BDDB_4834_434B_B562_ADD54184DF6C#784885, COL_B39F2F25_9917_471C_9C72_927B15008A79#784886, COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#784887, COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#784888, COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#784889, COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#784890]