== 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_438514103`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [AT_ADHMUT_438081#255408, AT_ADR_1A_438056#255409, AT_ADR_1_438039#255410, AT_ADR_2A_438057#255411, AT_ADR_2_438040#255412, AT_ADR_3A_438095#255413, AT_ADR_3_438093#255414, AT_ALARMES_438112#255415, AT_ANTECE_438038#255416, AT_ART115_438098#255417, AT_CODCAIAT_438078#255418, AT_CODETAB_PROD_438101#255419, AT_CODGESTION_438097#255420, AT_CODINSEENAI_438145#255421, AT_CODMED_438060#255422, AT_CODMTR_438092#255423, AT_CODPERSHLIM_438119#255424, AT_CODPOA_438058#255425, AT_CODPOSNAI_438136#255426, AT_CODPOS_438041#255427, AT_CODREF_438076#255428, AT_CODREGAT_438077#255429, AT_CODROUT_438084#255430, AT_CODSER_438066#255431, ... 112 more fields], false
(4) View
Arguments: `H_PATIEN_438022103`, true
(5) SubqueryAlias
Arguments: H_PATIEN_438022103
(6) Project
Arguments: [AT_ADHMUT_438081#255408 AS H_PATIEN_438022_AT_ADHMUT_438081#256356, AT_ADR_1A_438056#255409 AS H_PATIEN_438022_AT_ADR_1A_438056#256357, AT_ADR_1_438039#255410 AS H_PATIEN_438022_AT_ADR_1_438039#256358, AT_ADR_2A_438057#255411 AS H_PATIEN_438022_AT_ADR_2A_438057#256359, AT_ADR_2_438040#255412 AS H_PATIEN_438022_AT_ADR_2_438040#256360, AT_ADR_3A_438095#255413 AS H_PATIEN_438022_AT_ADR_3A_438095#256361, AT_ADR_3_438093#255414 AS H_PATIEN_438022_AT_ADR_3_438093#256362, AT_ALARMES_438112#255415 AS H_PATIEN_438022_AT_ALARMES_438112#256363, AT_ANTECE_438038#255416 AS H_PATIEN_438022_AT_ANTECE_438038#256364, AT_ART115_438098#255417 AS H_PATIEN_438022_AT_ART115_438098#256365, AT_CODCAIAT_438078#255418 AS H_PATIEN_438022_AT_CODCAIAT_438078#256366, AT_CODETAB_PROD_438101#255419 AS H_PATIEN_438022_AT_CODETAB_PROD_438101#256367, AT_CODGESTION_438097#255420 AS H_PATIEN_438022_AT_CODGESTION_438097#256368, AT_CODINSEENAI_438145#255421 AS H_PATIEN_438022_AT_CODINSEENAI_438145#256369, AT_CODMED_438060#255422 AS H_PATIEN_438022_AT_CODMED_438060#256370, AT_CODMTR_438092#255423 AS H_PATIEN_438022_AT_CODMTR_438092#256371, AT_CODPERSHLIM_438119#255424 AS H_PATIEN_438022_AT_CODPERSHLIM_438119#256372, AT_CODPOA_438058#255425 AS H_PATIEN_438022_AT_CODPOA_438058#256373, AT_CODPOSNAI_438136#255426 AS H_PATIEN_438022_AT_CODPOSNAI_438136#256374, AT_CODPOS_438041#255427 AS H_PATIEN_438022_AT_CODPOS_438041#256375, AT_CODREF_438076#255428 AS H_PATIEN_438022_AT_CODREF_438076#256376, AT_CODREGAT_438077#255429 AS H_PATIEN_438022_AT_CODREGAT_438077#256377, AT_CODROUT_438084#255430 AS H_PATIEN_438022_AT_CODROUT_438084#256378, AT_CODSER_438066#255431 AS H_PATIEN_438022_AT_CODSER_438066#256379, ... 112 more fields]
(7) Project
Arguments: [cast(H_PATIEN_438022_AT_NUMDOS_438023#256443 as string) AS COL_499EB20D_E124_400E_A51E_F020884D243F#257088, cast(H_PATIEN_438022_AT_STAPAT_438024#256475 as string) AS COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#257089, cast(H_PATIEN_438022_AT_PREFIX_438025#256468 as string) AS COL_2B7D9197_D824_41CE_9E49_C420C3822425#257090, cast(H_PATIEN_438022_AT_NOMPAT_438026#256438 as string) AS COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#257091, cast(H_PATIEN_438022_AT_PNOPAT_438027#256464 as string) AS COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#257092, cast(H_PATIEN_438022_AT_NJFPAT_438028#256435 as string) AS COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#257093, cast(H_PATIEN_438022_AT_DATNAI_438029#256402 as string) AS COL_CB4739E1_E2F6_48D7_9602_079F56460634#257094, cast(H_PATIEN_438022_AT_DATNAISS_438030#256401 as string) AS COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#257095, cast(H_PATIEN_438022_AT_SEXE_438031#256471 as string) AS COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#257096, cast(H_PATIEN_438022_AT_NUMPER_438032#256447 as string) AS COL_EA5C2CE3_37BD_44EE_85FF_BCC8246130D3#257097, cast(H_PATIEN_438022_AT_SIGMA_438033#256472 as string) AS COL_22EA1E67_BCCB_478F_8375_8868D11B6D8D#257098, cast(H_PATIEN_438022_AT_VERROU_438034#256488 as string) AS COL_BA4B4DAF_761B_4BED_992C_E6EEE2E8A1C2#257099, cast(H_PATIEN_438022_AT_POIDS_438035#256465 as string) AS COL_39ED4537_07C6_4B41_A001_0A1A3BFF3F7E#257100, cast(H_PATIEN_438022_AT_INDCEN_438036#256419 as string) AS COL_798C924C_DD87_4B2F_80E3_BB9D253CB13E#257101, cast(H_PATIEN_438022_AT_NUMSS_438037#256455 as string) AS COL_A70BC27E_F332_4416_8F73_8330F2D2E0C1#257102, cast(H_PATIEN_438022_AT_ANTECE_438038#256364 as string) AS COL_B8B8D34A_5506_4727_9D6F_1253CCBE1016#257103, cast(H_PATIEN_438022_AT_ADR_1_438039#256358 as string) AS COL_95EB4E8C_82A6_450F_9296_F9779F21D29A#257104, cast(H_PATIEN_438022_AT_ADR_2_438040#256360 as string) AS COL_4BDF68DB_89AA_49A4_BF47_E5B03452F4D6#257105, cast(H_PATIEN_438022_AT_CODPOS_438041#256375 as string) AS COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#257106, cast(H_PATIEN_438022_AT_VILLE_438042#256491 as string) AS COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#257107, cast(H_PATIEN_438022_AT_PAYS_438043#256458 as string) AS COL_554D0EDF_18F1_4FE2_BB3D_F953C0738C32#257108, cast(H_PATIEN_438022_AT_NUMCAI_438044#256440 as string) AS COL_824DAB1C_A7D3_49CA_8C4B_6276F8440CA6#257109, cast(H_PATIEN_438022_AT_NUMMUT_438045#256446 as string) AS COL_526572A4_6517_4EFA_98B4_FD34FBF129E9#257110, cast(H_PATIEN_438022_AT_NUMCHA_438046#256442 as string) AS COL_C5C54146_D5FD_4FF2_AB72_70B9F8F5DB75#257111, ... 112 more fields]
(8) Project
Arguments: [COL_499EB20D_E124_400E_A51E_F020884D243F#257088 AS COL_499EB20D_E124_400E_A51E_F020884D243F#257408, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#257089 AS COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#257409, COL_2B7D9197_D824_41CE_9E49_C420C3822425#257090 AS COL_2B7D9197_D824_41CE_9E49_C420C3822425#257410, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#257091 AS COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#257411, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#257092 AS COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#257412, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#257093 AS COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#257413, COL_CB4739E1_E2F6_48D7_9602_079F56460634#257094 AS COL_CB4739E1_E2F6_48D7_9602_079F56460634#257414, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#257095 AS COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#257415, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#257096 AS COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#257416, COL_EA5C2CE3_37BD_44EE_85FF_BCC8246130D3#257097 AS COL_EA5C2CE3_37BD_44EE_85FF_BCC8246130D3#257417, COL_22EA1E67_BCCB_478F_8375_8868D11B6D8D#257098 AS COL_22EA1E67_BCCB_478F_8375_8868D11B6D8D#257418, COL_BA4B4DAF_761B_4BED_992C_E6EEE2E8A1C2#257099 AS COL_BA4B4DAF_761B_4BED_992C_E6EEE2E8A1C2#257419, COL_39ED4537_07C6_4B41_A001_0A1A3BFF3F7E#257100 AS COL_39ED4537_07C6_4B41_A001_0A1A3BFF3F7E#257420, COL_798C924C_DD87_4B2F_80E3_BB9D253CB13E#257101 AS COL_798C924C_DD87_4B2F_80E3_BB9D253CB13E#257421, COL_A70BC27E_F332_4416_8F73_8330F2D2E0C1#257102 AS COL_A70BC27E_F332_4416_8F73_8330F2D2E0C1#257422, COL_B8B8D34A_5506_4727_9D6F_1253CCBE1016#257103 AS COL_B8B8D34A_5506_4727_9D6F_1253CCBE1016#257423, COL_95EB4E8C_82A6_450F_9296_F9779F21D29A#257104 AS COL_95EB4E8C_82A6_450F_9296_F9779F21D29A#257424, COL_4BDF68DB_89AA_49A4_BF47_E5B03452F4D6#257105 AS COL_4BDF68DB_89AA_49A4_BF47_E5B03452F4D6#257425, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#257106 AS COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#257426, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#257107 AS COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#257427, COL_554D0EDF_18F1_4FE2_BB3D_F953C0738C32#257108 AS COL_554D0EDF_18F1_4FE2_BB3D_F953C0738C32#257428, COL_824DAB1C_A7D3_49CA_8C4B_6276F8440CA6#257109 AS COL_824DAB1C_A7D3_49CA_8C4B_6276F8440CA6#257429, COL_526572A4_6517_4EFA_98B4_FD34FBF129E9#257110 AS COL_526572A4_6517_4EFA_98B4_FD34FBF129E9#257430, COL_C5C54146_D5FD_4FF2_AB72_70B9F8F5DB75#257111 AS COL_C5C54146_D5FD_4FF2_AB72_70B9F8F5DB75#257431, ... 112 more fields]
(9) Project
Arguments: [COL_499EB20D_E124_400E_A51E_F020884D243F#257408 AS COL_499EB20D_E124_400E_A51E_F020884D243F#257719, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#257409 AS COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#257720, COL_2B7D9197_D824_41CE_9E49_C420C3822425#257410 AS COL_2B7D9197_D824_41CE_9E49_C420C3822425#257721, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#257411 AS COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#257722, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#257412 AS COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#257723, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#257413 AS COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#257724, COL_CB4739E1_E2F6_48D7_9602_079F56460634#257414 AS COL_CB4739E1_E2F6_48D7_9602_079F56460634#257725, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#257415 AS COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#257726, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#257416 AS COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#257727, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#257426 AS COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#257728, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#257427 AS COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#257729]
(10) Project
Arguments: [COL_499EB20D_E124_400E_A51E_F020884D243F#257719 AS COL_499EB20D_E124_400E_A51E_F020884D243F#257795, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#257720 AS COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#257796, COL_2B7D9197_D824_41CE_9E49_C420C3822425#257721 AS COL_2B7D9197_D824_41CE_9E49_C420C3822425#257797, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#257722 AS COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#257798, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#257723 AS COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#257799, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#257724 AS COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#257800, COL_CB4739E1_E2F6_48D7_9602_079F56460634#257725 AS COL_CB4739E1_E2F6_48D7_9602_079F56460634#257801, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#257726 AS COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#257802, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#257727 AS COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#257803, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#257728 AS COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#257804, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#257729 AS COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#257805]
(11) Project
Arguments: [COL_499EB20D_E124_400E_A51E_F020884D243F#257795, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#257796, COL_2B7D9197_D824_41CE_9E49_C420C3822425#257797, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#257798, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#257799, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#257800, COL_CB4739E1_E2F6_48D7_9602_079F56460634#257801, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#257802, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#257803, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#257804, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#257805, str_replace_extend(str_replace_extend(COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#257798, 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#257817]
(12) Project
Arguments: [COL_499EB20D_E124_400E_A51E_F020884D243F#257795, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#257796, COL_2B7D9197_D824_41CE_9E49_C420C3822425#257797, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#257798, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#257799, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#257800, COL_CB4739E1_E2F6_48D7_9602_079F56460634#257801, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#257802, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#257803, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#257804, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#257805, COL_D741682E_18A7_4E09_96D0_47ED855868ED#257817, str_replace_extend(str_replace_extend(COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#257799, 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#257847]
(13) Project
Arguments: [COL_499EB20D_E124_400E_A51E_F020884D243F#257795 AS COL_499EB20D_E124_400E_A51E_F020884D243F#257895, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#257796 AS COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#257896, COL_2B7D9197_D824_41CE_9E49_C420C3822425#257797 AS COL_2B7D9197_D824_41CE_9E49_C420C3822425#257897, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#257798 AS COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#257898, COL_D741682E_18A7_4E09_96D0_47ED855868ED#257817 AS COL_D741682E_18A7_4E09_96D0_47ED855868ED#257899, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#257799 AS COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#257900, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#257847 AS COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#257901, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#257800 AS COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#257902, COL_CB4739E1_E2F6_48D7_9602_079F56460634#257801 AS COL_CB4739E1_E2F6_48D7_9602_079F56460634#257903, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#257802 AS COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#257904, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#257803 AS COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#257905, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#257804 AS COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#257906, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#257805 AS COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#257907]