== Physical Plan ==
Execute CreateViewCommand (1)
+- CreateViewCommand (2)
+- Project (13)
+- Project (12)
+- Project (11)
+- Project (10)
+- Project (9)
+- Project (8)
+- Project (7)
+- Project (6)
+- SubqueryAlias (5)
+- View (4)
+- LogicalRelation (3)
(1) Execute CreateViewCommand
Output: []
(2) CreateViewCommand
Arguments: `H_PATIEN_43851496`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [AT_ADHMUT_438081#261076, AT_ADR_1A_438056#261077, AT_ADR_1_438039#261078, AT_ADR_2A_438057#261079, AT_ADR_2_438040#261080, AT_ADR_3A_438095#261081, AT_ADR_3_438093#261082, AT_ALARMES_438112#261083, AT_ANTECE_438038#261084, AT_ART115_438098#261085, AT_CODCAIAT_438078#261086, AT_CODETAB_PROD_438101#261087, AT_CODGESTION_438097#261088, AT_CODINSEENAI_438145#261089, AT_CODMED_438060#261090, AT_CODMTR_438092#261091, AT_CODPERSHLIM_438119#261092, AT_CODPOA_438058#261093, AT_CODPOSNAI_438136#261094, AT_CODPOS_438041#261095, AT_CODREF_438076#261096, AT_CODREGAT_438077#261097, AT_CODROUT_438084#261098, AT_CODSER_438066#261099, ... 112 more fields], false
(4) View
Arguments: `H_PATIEN_43802296`, true
(5) SubqueryAlias
Arguments: H_PATIEN_43802296
(6) Project
Arguments: [AT_ADHMUT_438081#261076 AS H_PATIEN_438022_AT_ADHMUT_438081#262024, AT_ADR_1A_438056#261077 AS H_PATIEN_438022_AT_ADR_1A_438056#262025, AT_ADR_1_438039#261078 AS H_PATIEN_438022_AT_ADR_1_438039#262026, AT_ADR_2A_438057#261079 AS H_PATIEN_438022_AT_ADR_2A_438057#262027, AT_ADR_2_438040#261080 AS H_PATIEN_438022_AT_ADR_2_438040#262028, AT_ADR_3A_438095#261081 AS H_PATIEN_438022_AT_ADR_3A_438095#262029, AT_ADR_3_438093#261082 AS H_PATIEN_438022_AT_ADR_3_438093#262030, AT_ALARMES_438112#261083 AS H_PATIEN_438022_AT_ALARMES_438112#262031, AT_ANTECE_438038#261084 AS H_PATIEN_438022_AT_ANTECE_438038#262032, AT_ART115_438098#261085 AS H_PATIEN_438022_AT_ART115_438098#262033, AT_CODCAIAT_438078#261086 AS H_PATIEN_438022_AT_CODCAIAT_438078#262034, AT_CODETAB_PROD_438101#261087 AS H_PATIEN_438022_AT_CODETAB_PROD_438101#262035, AT_CODGESTION_438097#261088 AS H_PATIEN_438022_AT_CODGESTION_438097#262036, AT_CODINSEENAI_438145#261089 AS H_PATIEN_438022_AT_CODINSEENAI_438145#262037, AT_CODMED_438060#261090 AS H_PATIEN_438022_AT_CODMED_438060#262038, AT_CODMTR_438092#261091 AS H_PATIEN_438022_AT_CODMTR_438092#262039, AT_CODPERSHLIM_438119#261092 AS H_PATIEN_438022_AT_CODPERSHLIM_438119#262040, AT_CODPOA_438058#261093 AS H_PATIEN_438022_AT_CODPOA_438058#262041, AT_CODPOSNAI_438136#261094 AS H_PATIEN_438022_AT_CODPOSNAI_438136#262042, AT_CODPOS_438041#261095 AS H_PATIEN_438022_AT_CODPOS_438041#262043, AT_CODREF_438076#261096 AS H_PATIEN_438022_AT_CODREF_438076#262044, AT_CODREGAT_438077#261097 AS H_PATIEN_438022_AT_CODREGAT_438077#262045, AT_CODROUT_438084#261098 AS H_PATIEN_438022_AT_CODROUT_438084#262046, AT_CODSER_438066#261099 AS H_PATIEN_438022_AT_CODSER_438066#262047, ... 112 more fields]
(7) Project
Arguments: [cast(H_PATIEN_438022_AT_NUMDOS_438023#262111 as string) AS COL_499EB20D_E124_400E_A51E_F020884D243F#262756, cast(H_PATIEN_438022_AT_STAPAT_438024#262143 as string) AS COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#262757, cast(H_PATIEN_438022_AT_PREFIX_438025#262136 as string) AS COL_2B7D9197_D824_41CE_9E49_C420C3822425#262758, cast(H_PATIEN_438022_AT_NOMPAT_438026#262106 as string) AS COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#262759, cast(H_PATIEN_438022_AT_PNOPAT_438027#262132 as string) AS COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#262760, cast(H_PATIEN_438022_AT_NJFPAT_438028#262103 as string) AS COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#262761, cast(H_PATIEN_438022_AT_DATNAI_438029#262070 as string) AS COL_CB4739E1_E2F6_48D7_9602_079F56460634#262762, cast(H_PATIEN_438022_AT_DATNAISS_438030#262069 as string) AS COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#262763, cast(H_PATIEN_438022_AT_SEXE_438031#262139 as string) AS COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#262764, cast(H_PATIEN_438022_AT_NUMPER_438032#262115 as string) AS COL_EA5C2CE3_37BD_44EE_85FF_BCC8246130D3#262765, cast(H_PATIEN_438022_AT_SIGMA_438033#262140 as string) AS COL_22EA1E67_BCCB_478F_8375_8868D11B6D8D#262766, cast(H_PATIEN_438022_AT_VERROU_438034#262156 as string) AS COL_BA4B4DAF_761B_4BED_992C_E6EEE2E8A1C2#262767, cast(H_PATIEN_438022_AT_POIDS_438035#262133 as string) AS COL_39ED4537_07C6_4B41_A001_0A1A3BFF3F7E#262768, cast(H_PATIEN_438022_AT_INDCEN_438036#262087 as string) AS COL_798C924C_DD87_4B2F_80E3_BB9D253CB13E#262769, cast(H_PATIEN_438022_AT_NUMSS_438037#262123 as string) AS COL_A70BC27E_F332_4416_8F73_8330F2D2E0C1#262770, cast(H_PATIEN_438022_AT_ANTECE_438038#262032 as string) AS COL_B8B8D34A_5506_4727_9D6F_1253CCBE1016#262771, cast(H_PATIEN_438022_AT_ADR_1_438039#262026 as string) AS COL_95EB4E8C_82A6_450F_9296_F9779F21D29A#262772, cast(H_PATIEN_438022_AT_ADR_2_438040#262028 as string) AS COL_4BDF68DB_89AA_49A4_BF47_E5B03452F4D6#262773, cast(H_PATIEN_438022_AT_CODPOS_438041#262043 as string) AS COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#262774, cast(H_PATIEN_438022_AT_VILLE_438042#262159 as string) AS COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#262775, cast(H_PATIEN_438022_AT_PAYS_438043#262126 as string) AS COL_554D0EDF_18F1_4FE2_BB3D_F953C0738C32#262776, cast(H_PATIEN_438022_AT_NUMCAI_438044#262108 as string) AS COL_824DAB1C_A7D3_49CA_8C4B_6276F8440CA6#262777, cast(H_PATIEN_438022_AT_NUMMUT_438045#262114 as string) AS COL_526572A4_6517_4EFA_98B4_FD34FBF129E9#262778, cast(H_PATIEN_438022_AT_NUMCHA_438046#262110 as string) AS COL_C5C54146_D5FD_4FF2_AB72_70B9F8F5DB75#262779, ... 112 more fields]
(8) Project
Arguments: [COL_499EB20D_E124_400E_A51E_F020884D243F#262756 AS COL_499EB20D_E124_400E_A51E_F020884D243F#263076, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#262757 AS COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#263077, COL_2B7D9197_D824_41CE_9E49_C420C3822425#262758 AS COL_2B7D9197_D824_41CE_9E49_C420C3822425#263078, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#262759 AS COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#263079, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#262760 AS COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#263080, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#262761 AS COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#263081, COL_CB4739E1_E2F6_48D7_9602_079F56460634#262762 AS COL_CB4739E1_E2F6_48D7_9602_079F56460634#263082, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#262763 AS COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#263083, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#262764 AS COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#263084, COL_EA5C2CE3_37BD_44EE_85FF_BCC8246130D3#262765 AS COL_EA5C2CE3_37BD_44EE_85FF_BCC8246130D3#263085, COL_22EA1E67_BCCB_478F_8375_8868D11B6D8D#262766 AS COL_22EA1E67_BCCB_478F_8375_8868D11B6D8D#263086, COL_BA4B4DAF_761B_4BED_992C_E6EEE2E8A1C2#262767 AS COL_BA4B4DAF_761B_4BED_992C_E6EEE2E8A1C2#263087, COL_39ED4537_07C6_4B41_A001_0A1A3BFF3F7E#262768 AS COL_39ED4537_07C6_4B41_A001_0A1A3BFF3F7E#263088, COL_798C924C_DD87_4B2F_80E3_BB9D253CB13E#262769 AS COL_798C924C_DD87_4B2F_80E3_BB9D253CB13E#263089, COL_A70BC27E_F332_4416_8F73_8330F2D2E0C1#262770 AS COL_A70BC27E_F332_4416_8F73_8330F2D2E0C1#263090, COL_B8B8D34A_5506_4727_9D6F_1253CCBE1016#262771 AS COL_B8B8D34A_5506_4727_9D6F_1253CCBE1016#263091, COL_95EB4E8C_82A6_450F_9296_F9779F21D29A#262772 AS COL_95EB4E8C_82A6_450F_9296_F9779F21D29A#263092, COL_4BDF68DB_89AA_49A4_BF47_E5B03452F4D6#262773 AS COL_4BDF68DB_89AA_49A4_BF47_E5B03452F4D6#263093, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#262774 AS COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#263094, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#262775 AS COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#263095, COL_554D0EDF_18F1_4FE2_BB3D_F953C0738C32#262776 AS COL_554D0EDF_18F1_4FE2_BB3D_F953C0738C32#263096, COL_824DAB1C_A7D3_49CA_8C4B_6276F8440CA6#262777 AS COL_824DAB1C_A7D3_49CA_8C4B_6276F8440CA6#263097, COL_526572A4_6517_4EFA_98B4_FD34FBF129E9#262778 AS COL_526572A4_6517_4EFA_98B4_FD34FBF129E9#263098, COL_C5C54146_D5FD_4FF2_AB72_70B9F8F5DB75#262779 AS COL_C5C54146_D5FD_4FF2_AB72_70B9F8F5DB75#263099, ... 112 more fields]
(9) Project
Arguments: [COL_499EB20D_E124_400E_A51E_F020884D243F#263076 AS COL_499EB20D_E124_400E_A51E_F020884D243F#263387, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#263077 AS COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#263388, COL_2B7D9197_D824_41CE_9E49_C420C3822425#263078 AS COL_2B7D9197_D824_41CE_9E49_C420C3822425#263389, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#263079 AS COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#263390, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#263080 AS COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#263391, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#263081 AS COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#263392, COL_CB4739E1_E2F6_48D7_9602_079F56460634#263082 AS COL_CB4739E1_E2F6_48D7_9602_079F56460634#263393, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#263083 AS COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#263394, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#263084 AS COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#263395, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#263094 AS COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#263396, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#263095 AS COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#263397]
(10) Project
Arguments: [COL_499EB20D_E124_400E_A51E_F020884D243F#263387 AS COL_499EB20D_E124_400E_A51E_F020884D243F#263463, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#263388 AS COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#263464, COL_2B7D9197_D824_41CE_9E49_C420C3822425#263389 AS COL_2B7D9197_D824_41CE_9E49_C420C3822425#263465, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#263390 AS COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#263466, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#263391 AS COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#263467, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#263392 AS COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#263468, COL_CB4739E1_E2F6_48D7_9602_079F56460634#263393 AS COL_CB4739E1_E2F6_48D7_9602_079F56460634#263469, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#263394 AS COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#263470, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#263395 AS COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#263471, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#263396 AS COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#263472, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#263397 AS COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#263473]
(11) Project
Arguments: [COL_499EB20D_E124_400E_A51E_F020884D243F#263463, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#263464, COL_2B7D9197_D824_41CE_9E49_C420C3822425#263465, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#263466, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#263467, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#263468, COL_CB4739E1_E2F6_48D7_9602_079F56460634#263469, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#263470, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#263471, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#263472, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#263473, str_replace_extend(str_replace_extend(COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#263466, array(cast(A as string), cast(E as string), cast(I as string), cast(O as string), cast(U as string), cast(Y as string)), array(cast(P as string), cast(S as string), cast(B as string), cast(G as string), cast(H as string), cast(J as string))), array(cast(D as string), cast(L as string), cast(M as string), cast(S as string), cast(C as string), cast(V as string), cast(R as string), cast(G as string)), array(cast(U as string), cast(E as string), cast(U as string), cast(K as string), cast(J as string), cast(O as string), cast(Y as string), cast(Z as string))) AS COL_D741682E_18A7_4E09_96D0_47ED855868ED#263485]
(12) Project
Arguments: [COL_499EB20D_E124_400E_A51E_F020884D243F#263463, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#263464, COL_2B7D9197_D824_41CE_9E49_C420C3822425#263465, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#263466, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#263467, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#263468, COL_CB4739E1_E2F6_48D7_9602_079F56460634#263469, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#263470, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#263471, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#263472, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#263473, COL_D741682E_18A7_4E09_96D0_47ED855868ED#263485, str_replace_extend(str_replace_extend(COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#263467, array(cast(A as string), cast(E as string), cast(I as string), cast(O as string), cast(U as string), cast(Y as string)), array(cast(P as string), cast(S as string), cast(B as string), cast(G as string), cast(H as string), cast(J as string))), array(cast(D as string), cast(L as string), cast(M as string), cast(S as string), cast(C as string), cast(V as string), cast(R as string), cast(G as string)), array(cast(U as string), cast(E as string), cast(U as string), cast(K as string), cast(J as string), cast(O as string), cast(Y as string), cast(Z as string))) AS COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#263515]
(13) Project
Arguments: [COL_499EB20D_E124_400E_A51E_F020884D243F#263463 AS COL_499EB20D_E124_400E_A51E_F020884D243F#263563, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#263464 AS COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#263564, COL_2B7D9197_D824_41CE_9E49_C420C3822425#263465 AS COL_2B7D9197_D824_41CE_9E49_C420C3822425#263565, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#263466 AS COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#263566, COL_D741682E_18A7_4E09_96D0_47ED855868ED#263485 AS COL_D741682E_18A7_4E09_96D0_47ED855868ED#263567, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#263467 AS COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#263568, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#263515 AS COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#263569, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#263468 AS COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#263570, COL_CB4739E1_E2F6_48D7_9602_079F56460634#263469 AS COL_CB4739E1_E2F6_48D7_9602_079F56460634#263571, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#263470 AS COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#263572, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#263471 AS COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#263573, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#263472 AS COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#263574, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#263473 AS COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#263575]