== Physical Plan ==
Execute CreateViewCommand (1)
+- CreateViewCommand (2)
+- Project (16)
+- SubqueryAlias (15)
+- View (14)
+- 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: `tmp_823f0b32224a46f99cd9da50e8de517e`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [AT_ADHMUT_438081#205393, AT_ADR_1A_438056#205394, AT_ADR_1_438039#205395, AT_ADR_2A_438057#205396, AT_ADR_2_438040#205397, AT_ADR_3A_438095#205398, AT_ADR_3_438093#205399, AT_ALARMES_438112#205400, AT_ANTECE_438038#205401, AT_ART115_438098#205402, AT_CODCAIAT_438078#205403, AT_CODETAB_PROD_438101#205404, AT_CODGESTION_438097#205405, AT_CODINSEENAI_438145#205406, AT_CODMED_438060#205407, AT_CODMTR_438092#205408, AT_CODPERSHLIM_438119#205409, AT_CODPOA_438058#205410, AT_CODPOSNAI_438136#205411, AT_CODPOS_438041#205412, AT_CODREF_438076#205413, AT_CODREGAT_438077#205414, AT_CODROUT_438084#205415, AT_CODSER_438066#205416, ... 112 more fields], false
(4) View
Arguments: `H_PATIEN_43802296`, true
(5) SubqueryAlias
Arguments: H_PATIEN_43802296
(6) Project
Arguments: [AT_ADHMUT_438081#205393 AS H_PATIEN_438022_AT_ADHMUT_438081#205801, AT_ADR_1A_438056#205394 AS H_PATIEN_438022_AT_ADR_1A_438056#205802, AT_ADR_1_438039#205395 AS H_PATIEN_438022_AT_ADR_1_438039#205803, AT_ADR_2A_438057#205396 AS H_PATIEN_438022_AT_ADR_2A_438057#205804, AT_ADR_2_438040#205397 AS H_PATIEN_438022_AT_ADR_2_438040#205805, AT_ADR_3A_438095#205398 AS H_PATIEN_438022_AT_ADR_3A_438095#205806, AT_ADR_3_438093#205399 AS H_PATIEN_438022_AT_ADR_3_438093#205807, AT_ALARMES_438112#205400 AS H_PATIEN_438022_AT_ALARMES_438112#205808, AT_ANTECE_438038#205401 AS H_PATIEN_438022_AT_ANTECE_438038#205809, AT_ART115_438098#205402 AS H_PATIEN_438022_AT_ART115_438098#205810, AT_CODCAIAT_438078#205403 AS H_PATIEN_438022_AT_CODCAIAT_438078#205811, AT_CODETAB_PROD_438101#205404 AS H_PATIEN_438022_AT_CODETAB_PROD_438101#205812, AT_CODGESTION_438097#205405 AS H_PATIEN_438022_AT_CODGESTION_438097#205813, AT_CODINSEENAI_438145#205406 AS H_PATIEN_438022_AT_CODINSEENAI_438145#205814, AT_CODMED_438060#205407 AS H_PATIEN_438022_AT_CODMED_438060#205815, AT_CODMTR_438092#205408 AS H_PATIEN_438022_AT_CODMTR_438092#205816, AT_CODPERSHLIM_438119#205409 AS H_PATIEN_438022_AT_CODPERSHLIM_438119#205817, AT_CODPOA_438058#205410 AS H_PATIEN_438022_AT_CODPOA_438058#205818, AT_CODPOSNAI_438136#205411 AS H_PATIEN_438022_AT_CODPOSNAI_438136#205819, AT_CODPOS_438041#205412 AS H_PATIEN_438022_AT_CODPOS_438041#205820, AT_CODREF_438076#205413 AS H_PATIEN_438022_AT_CODREF_438076#205821, AT_CODREGAT_438077#205414 AS H_PATIEN_438022_AT_CODREGAT_438077#205822, AT_CODROUT_438084#205415 AS H_PATIEN_438022_AT_CODROUT_438084#205823, AT_CODSER_438066#205416 AS H_PATIEN_438022_AT_CODSER_438066#205824, ... 112 more fields]
(7) Project
Arguments: [cast(H_PATIEN_438022_AT_NUMDOS_438023#205888 as string) AS COL_499EB20D_E124_400E_A51E_F020884D243F#206209, cast(H_PATIEN_438022_AT_STAPAT_438024#205920 as string) AS COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#206210, cast(H_PATIEN_438022_AT_PREFIX_438025#205913 as string) AS COL_2B7D9197_D824_41CE_9E49_C420C3822425#206211, cast(H_PATIEN_438022_AT_NOMPAT_438026#205883 as string) AS COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#206212, cast(H_PATIEN_438022_AT_PNOPAT_438027#205909 as string) AS COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#206213, cast(H_PATIEN_438022_AT_NJFPAT_438028#205880 as string) AS COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#206214, cast(H_PATIEN_438022_AT_DATNAI_438029#205847 as string) AS COL_CB4739E1_E2F6_48D7_9602_079F56460634#206215, cast(H_PATIEN_438022_AT_DATNAISS_438030#205846 as string) AS COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#206216, cast(H_PATIEN_438022_AT_SEXE_438031#205916 as string) AS COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#206217, cast(H_PATIEN_438022_AT_NUMPER_438032#205892 as string) AS COL_EA5C2CE3_37BD_44EE_85FF_BCC8246130D3#206218, cast(H_PATIEN_438022_AT_SIGMA_438033#205917 as string) AS COL_22EA1E67_BCCB_478F_8375_8868D11B6D8D#206219, cast(H_PATIEN_438022_AT_VERROU_438034#205933 as string) AS COL_BA4B4DAF_761B_4BED_992C_E6EEE2E8A1C2#206220, cast(H_PATIEN_438022_AT_POIDS_438035#205910 as string) AS COL_39ED4537_07C6_4B41_A001_0A1A3BFF3F7E#206221, cast(H_PATIEN_438022_AT_INDCEN_438036#205864 as string) AS COL_798C924C_DD87_4B2F_80E3_BB9D253CB13E#206222, cast(H_PATIEN_438022_AT_NUMSS_438037#205900 as string) AS COL_A70BC27E_F332_4416_8F73_8330F2D2E0C1#206223, cast(H_PATIEN_438022_AT_ANTECE_438038#205809 as string) AS COL_B8B8D34A_5506_4727_9D6F_1253CCBE1016#206224, cast(H_PATIEN_438022_AT_ADR_1_438039#205803 as string) AS COL_95EB4E8C_82A6_450F_9296_F9779F21D29A#206225, cast(H_PATIEN_438022_AT_ADR_2_438040#205805 as string) AS COL_4BDF68DB_89AA_49A4_BF47_E5B03452F4D6#206226, cast(H_PATIEN_438022_AT_CODPOS_438041#205820 as string) AS COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#206227, cast(H_PATIEN_438022_AT_VILLE_438042#205936 as string) AS COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#206228, cast(H_PATIEN_438022_AT_PAYS_438043#205903 as string) AS COL_554D0EDF_18F1_4FE2_BB3D_F953C0738C32#206229, cast(H_PATIEN_438022_AT_NUMCAI_438044#205885 as string) AS COL_824DAB1C_A7D3_49CA_8C4B_6276F8440CA6#206230, cast(H_PATIEN_438022_AT_NUMMUT_438045#205891 as string) AS COL_526572A4_6517_4EFA_98B4_FD34FBF129E9#206231, cast(H_PATIEN_438022_AT_NUMCHA_438046#205887 as string) AS COL_C5C54146_D5FD_4FF2_AB72_70B9F8F5DB75#206232, ... 112 more fields]
(8) Project
Arguments: [COL_499EB20D_E124_400E_A51E_F020884D243F#206209 AS COL_499EB20D_E124_400E_A51E_F020884D243F#206481, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#206210 AS COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#206482, COL_2B7D9197_D824_41CE_9E49_C420C3822425#206211 AS COL_2B7D9197_D824_41CE_9E49_C420C3822425#206483, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#206212 AS COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#206484, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#206213 AS COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#206485, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#206214 AS COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#206486, COL_CB4739E1_E2F6_48D7_9602_079F56460634#206215 AS COL_CB4739E1_E2F6_48D7_9602_079F56460634#206487, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#206216 AS COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#206488, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#206217 AS COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#206489, COL_EA5C2CE3_37BD_44EE_85FF_BCC8246130D3#206218 AS COL_EA5C2CE3_37BD_44EE_85FF_BCC8246130D3#206490, COL_22EA1E67_BCCB_478F_8375_8868D11B6D8D#206219 AS COL_22EA1E67_BCCB_478F_8375_8868D11B6D8D#206491, COL_BA4B4DAF_761B_4BED_992C_E6EEE2E8A1C2#206220 AS COL_BA4B4DAF_761B_4BED_992C_E6EEE2E8A1C2#206492, COL_39ED4537_07C6_4B41_A001_0A1A3BFF3F7E#206221 AS COL_39ED4537_07C6_4B41_A001_0A1A3BFF3F7E#206493, COL_798C924C_DD87_4B2F_80E3_BB9D253CB13E#206222 AS COL_798C924C_DD87_4B2F_80E3_BB9D253CB13E#206494, COL_A70BC27E_F332_4416_8F73_8330F2D2E0C1#206223 AS COL_A70BC27E_F332_4416_8F73_8330F2D2E0C1#206495, COL_B8B8D34A_5506_4727_9D6F_1253CCBE1016#206224 AS COL_B8B8D34A_5506_4727_9D6F_1253CCBE1016#206496, COL_95EB4E8C_82A6_450F_9296_F9779F21D29A#206225 AS COL_95EB4E8C_82A6_450F_9296_F9779F21D29A#206497, COL_4BDF68DB_89AA_49A4_BF47_E5B03452F4D6#206226 AS COL_4BDF68DB_89AA_49A4_BF47_E5B03452F4D6#206498, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#206227 AS COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#206499, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#206228 AS COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#206500, COL_554D0EDF_18F1_4FE2_BB3D_F953C0738C32#206229 AS COL_554D0EDF_18F1_4FE2_BB3D_F953C0738C32#206501, COL_824DAB1C_A7D3_49CA_8C4B_6276F8440CA6#206230 AS COL_824DAB1C_A7D3_49CA_8C4B_6276F8440CA6#206502, COL_526572A4_6517_4EFA_98B4_FD34FBF129E9#206231 AS COL_526572A4_6517_4EFA_98B4_FD34FBF129E9#206503, COL_C5C54146_D5FD_4FF2_AB72_70B9F8F5DB75#206232 AS COL_C5C54146_D5FD_4FF2_AB72_70B9F8F5DB75#206504, ... 112 more fields]
(9) Project
Arguments: [COL_499EB20D_E124_400E_A51E_F020884D243F#206481 AS COL_499EB20D_E124_400E_A51E_F020884D243F#206753, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#206482 AS COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#206754, COL_2B7D9197_D824_41CE_9E49_C420C3822425#206483 AS COL_2B7D9197_D824_41CE_9E49_C420C3822425#206755, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#206484 AS COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#206756, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#206485 AS COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#206757, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#206486 AS COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#206758, COL_CB4739E1_E2F6_48D7_9602_079F56460634#206487 AS COL_CB4739E1_E2F6_48D7_9602_079F56460634#206759, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#206488 AS COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#206760, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#206489 AS COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#206761, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#206499 AS COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#206762, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#206500 AS COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#206763]
(10) Project
Arguments: [COL_499EB20D_E124_400E_A51E_F020884D243F#206753 AS COL_499EB20D_E124_400E_A51E_F020884D243F#206775, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#206754 AS COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#206776, COL_2B7D9197_D824_41CE_9E49_C420C3822425#206755 AS COL_2B7D9197_D824_41CE_9E49_C420C3822425#206777, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#206756 AS COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#206778, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#206757 AS COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#206779, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#206758 AS COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#206780, COL_CB4739E1_E2F6_48D7_9602_079F56460634#206759 AS COL_CB4739E1_E2F6_48D7_9602_079F56460634#206781, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#206760 AS COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#206782, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#206761 AS COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#206783, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#206762 AS COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#206784, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#206763 AS COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#206785]
(11) Project
Arguments: [COL_499EB20D_E124_400E_A51E_F020884D243F#206775, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#206776, COL_2B7D9197_D824_41CE_9E49_C420C3822425#206777, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#206778, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#206779, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#206780, COL_CB4739E1_E2F6_48D7_9602_079F56460634#206781, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#206782, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#206783, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#206784, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#206785, str_replace_extend(str_replace_extend(COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#206778, 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#206797]
(12) Project
Arguments: [COL_499EB20D_E124_400E_A51E_F020884D243F#206775, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#206776, COL_2B7D9197_D824_41CE_9E49_C420C3822425#206777, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#206778, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#206779, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#206780, COL_CB4739E1_E2F6_48D7_9602_079F56460634#206781, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#206782, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#206783, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#206784, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#206785, COL_D741682E_18A7_4E09_96D0_47ED855868ED#206797, str_replace_extend(str_replace_extend(COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#206779, 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#206810]
(13) Project
Arguments: [COL_499EB20D_E124_400E_A51E_F020884D243F#206775 AS COL_499EB20D_E124_400E_A51E_F020884D243F#206824, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#206776 AS COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#206825, COL_2B7D9197_D824_41CE_9E49_C420C3822425#206777 AS COL_2B7D9197_D824_41CE_9E49_C420C3822425#206826, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#206778 AS COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#206827, COL_D741682E_18A7_4E09_96D0_47ED855868ED#206797 AS COL_D741682E_18A7_4E09_96D0_47ED855868ED#206828, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#206779 AS COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#206829, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#206810 AS COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#206830, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#206780 AS COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#206831, COL_CB4739E1_E2F6_48D7_9602_079F56460634#206781 AS COL_CB4739E1_E2F6_48D7_9602_079F56460634#206832, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#206782 AS COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#206833, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#206783 AS COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#206834, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#206784 AS COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#206835, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#206785 AS COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#206836]
(14) View
Arguments: `H_PATIEN_43851496`, true
(15) SubqueryAlias
Arguments: H_PATIEN_43851496
(16) Project
Arguments: [COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#206827, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#206830, COL_2B7D9197_D824_41CE_9E49_C420C3822425#206826, COL_CB4739E1_E2F6_48D7_9602_079F56460634#206832, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#206834, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#206836, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#206833, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#206835, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#206831, COL_D741682E_18A7_4E09_96D0_47ED855868ED#206828, COL_499EB20D_E124_400E_A51E_F020884D243F#206824, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#206829, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#206825]