== Physical Plan ==
Execute CreateViewCommand (1)
+- CreateViewCommand (2)
+- Project (20)
+- Project (19)
+- Project (18)
+- Project (17)
+- Project (16)
+- Project (15)
+- Aggregate (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: `02_ACTES_PATIEN_176286173`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1177392, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#1177393, COL_B01E4E9C_9C1A_413D_9FB4_F0E1F49B4990#1177394, COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#1177395, COL_3A5D02F6_4E3A_45C4_8CDF_BB835CE099A1#1177396, COL_F4778BDA_4A5D_4760_9816_852A7B042FC7#1177397, COL_D5EDAAE4_BF90_4134_AF8E_1039395D3356#1177398, COL_3FE49154_D45D_4F98_B54D_6981EB35F500#1177399, COL_C3324533_C0BB_4B8B_8370_DC4EE8F6BBC6#1177400, COL_F94DAC07_127C_4495_A440_68EF585E7F25#1177401, COL_5FE684A3_C173_4F6B_AD83_F16ADC313E77#1177402, COL_8C23F27C_A334_46F9_AD8F_4D2F98435644#1177403, COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#1177404, COL_4FAE5E83_EEBF_46C7_9422_78ECE1DA2B04#1177405, COL_69B4F97B_AC0E_4905_AA66_0924D4EFC3B6#1177406, COL_0D69EBFF_2BDF_4FD1_B4AC_7B1DEF4C3603#1177407, COL_A764821B_78E0_4C3B_A968_0BB28AD10628#1177408, COL_6CC6F978_0EE3_437E_8A71_6E7AB294A83A#1177409, COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#1177410, COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#1177411, COL_AFCA0F94_47F3_4392_B6C9_D0A473E54762#1177412, COL_C33495F5_0769_434B_A2E2_50AA49F857DD#1177413, COL_7D270645_B926_42AF_A110_EB3A1A53031B#1177414, COL_6A8C3138_77B0_404C_B949_FC01E1C85545#1177415, ... 29 more fields], false
(4) View
Arguments: `00_B_ACTES_PATI_176158173`, true
(5) SubqueryAlias
Arguments: 00_B_ACTES_PATI_176158173
(6) Project
Arguments: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1177392 AS 00_B_ACTES_PATI_176158_COL_64ED17E5_A991_405B_AEED_8A2977283F76#1177557, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#1177393 AS 00_B_ACTES_PATI_176158_COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#1177558, COL_B01E4E9C_9C1A_413D_9FB4_F0E1F49B4990#1177394 AS 00_B_ACTES_PATI_176158_COL_B01E4E9C_9C1A_413D_9FB4_F0E1F49B4990#1177559, COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#1177395 AS 00_B_ACTES_PATI_176158_COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#1177560, COL_3A5D02F6_4E3A_45C4_8CDF_BB835CE099A1#1177396 AS 00_B_ACTES_PATI_176158_COL_3A5D02F6_4E3A_45C4_8CDF_BB835CE099A1#1177561, COL_F4778BDA_4A5D_4760_9816_852A7B042FC7#1177397 AS 00_B_ACTES_PATI_176158_COL_F4778BDA_4A5D_4760_9816_852A7B042FC7#1177562, COL_D5EDAAE4_BF90_4134_AF8E_1039395D3356#1177398 AS 00_B_ACTES_PATI_176158_COL_D5EDAAE4_BF90_4134_AF8E_1039395D3356#1177563, COL_3FE49154_D45D_4F98_B54D_6981EB35F500#1177399 AS 00_B_ACTES_PATI_176158_COL_3FE49154_D45D_4F98_B54D_6981EB35F500#1177564, COL_C3324533_C0BB_4B8B_8370_DC4EE8F6BBC6#1177400 AS 00_B_ACTES_PATI_176158_COL_C3324533_C0BB_4B8B_8370_DC4EE8F6BBC6#1177565, COL_F94DAC07_127C_4495_A440_68EF585E7F25#1177401 AS 00_B_ACTES_PATI_176158_COL_F94DAC07_127C_4495_A440_68EF585E7F25#1177566, COL_5FE684A3_C173_4F6B_AD83_F16ADC313E77#1177402 AS 00_B_ACTES_PATI_176158_COL_5FE684A3_C173_4F6B_AD83_F16ADC313E77#1177567, COL_8C23F27C_A334_46F9_AD8F_4D2F98435644#1177403 AS 00_B_ACTES_PATI_176158_COL_8C23F27C_A334_46F9_AD8F_4D2F98435644#1177568, COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#1177404 AS 00_B_ACTES_PATI_176158_COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#1177569, COL_4FAE5E83_EEBF_46C7_9422_78ECE1DA2B04#1177405 AS 00_B_ACTES_PATI_176158_COL_4FAE5E83_EEBF_46C7_9422_78ECE1DA2B04#1177570, COL_69B4F97B_AC0E_4905_AA66_0924D4EFC3B6#1177406 AS 00_B_ACTES_PATI_176158_COL_69B4F97B_AC0E_4905_AA66_0924D4EFC3B6#1177571, COL_0D69EBFF_2BDF_4FD1_B4AC_7B1DEF4C3603#1177407 AS 00_B_ACTES_PATI_176158_COL_0D69EBFF_2BDF_4FD1_B4AC_7B1DEF4C3603#1177572, COL_A764821B_78E0_4C3B_A968_0BB28AD10628#1177408 AS 00_B_ACTES_PATI_176158_COL_A764821B_78E0_4C3B_A968_0BB28AD10628#1177573, COL_6CC6F978_0EE3_437E_8A71_6E7AB294A83A#1177409 AS 00_B_ACTES_PATI_176158_COL_6CC6F978_0EE3_437E_8A71_6E7AB294A83A#1177574, COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#1177410 AS 00_B_ACTES_PATI_176158_COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#1177575, COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#1177411 AS 00_B_ACTES_PATI_176158_COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#1177576, COL_AFCA0F94_47F3_4392_B6C9_D0A473E54762#1177412 AS 00_B_ACTES_PATI_176158_COL_AFCA0F94_47F3_4392_B6C9_D0A473E54762#1177577, COL_C33495F5_0769_434B_A2E2_50AA49F857DD#1177413 AS 00_B_ACTES_PATI_176158_COL_C33495F5_0769_434B_A2E2_50AA49F857DD#1177578, COL_7D270645_B926_42AF_A110_EB3A1A53031B#1177414 AS 00_B_ACTES_PATI_176158_COL_7D270645_B926_42AF_A110_EB3A1A53031B#1177579, COL_6A8C3138_77B0_404C_B949_FC01E1C85545#1177415 AS 00_B_ACTES_PATI_176158_COL_6A8C3138_77B0_404C_B949_FC01E1C85545#1177580, ... 29 more fields]
(7) Project
Arguments: [cast(00_B_ACTES_PATI_176158_COL_64ED17E5_A991_405B_AEED_8A2977283F76#1177557 as string) AS COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1177668, cast(00_B_ACTES_PATI_176158_COL_F94DAC07_127C_4495_A440_68EF585E7F25#1177566 as string) AS COL_222825DB_CF6B_476D_9220_1F5790868FCE#1177669, cast(00_B_ACTES_PATI_176158_COL_6A8C3138_77B0_404C_B949_FC01E1C85545#1177580 as string) AS COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#1177670, cast(00_B_ACTES_PATI_176158_COL_EA6371C8_0F76_4199_B797_A5888F7D4D43#1177584 as timestamp) AS COL_FBB15BE3_311B_4A50_A657_811052E44533#1177671, cast(00_B_ACTES_PATI_176158_COL_1996D387_9E74_479E_8427_83B4DBA88131#1177603 as string) AS COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#1177672]
(8) Project
Arguments: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1177668 AS COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1177678, COL_222825DB_CF6B_476D_9220_1F5790868FCE#1177669 AS COL_222825DB_CF6B_476D_9220_1F5790868FCE#1177679, COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#1177670 AS COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#1177680, COL_FBB15BE3_311B_4A50_A657_811052E44533#1177671 AS COL_FBB15BE3_311B_4A50_A657_811052E44533#1177681, COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#1177672 AS COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#1177682]
(9) Project
Arguments: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1177678 AS COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1177688, COL_222825DB_CF6B_476D_9220_1F5790868FCE#1177679 AS COL_222825DB_CF6B_476D_9220_1F5790868FCE#1177689, COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#1177680 AS COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#1177690, COL_FBB15BE3_311B_4A50_A657_811052E44533#1177681 AS COL_FBB15BE3_311B_4A50_A657_811052E44533#1177691, COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#1177682 AS COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#1177692]
(10) Project
Arguments: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1177688 AS COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1177698, COL_222825DB_CF6B_476D_9220_1F5790868FCE#1177689 AS COL_222825DB_CF6B_476D_9220_1F5790868FCE#1177699, COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#1177690 AS COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#1177700, COL_FBB15BE3_311B_4A50_A657_811052E44533#1177691 AS COL_FBB15BE3_311B_4A50_A657_811052E44533#1177701, COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#1177692 AS COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#1177702]
(11) Project
Arguments: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1177698, COL_222825DB_CF6B_476D_9220_1F5790868FCE#1177699, COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#1177700, COL_FBB15BE3_311B_4A50_A657_811052E44533#1177701, COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#1177702, str_if_with_rule(((COL_222825DB_CF6B_476D_9220_1F5790868FCE#1177699 <=> cast(1 as string)) AND CASE WHEN isnull(Contains(COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#1177700, cast(2 as string))) THEN false ELSE Contains(COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#1177700, cast(2 as string)) END), cast(SU2 as string), str_if_with_rule((((COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#1177700 <=> cast(3 as string)) OR (COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#1177700 <=> cast(4 as string))) OR (COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#1177700 <=> cast(5 as string))), cast(SU3 as string), cast(null as string))) AS COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#1177708]
(12) Project
Arguments: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1177698 AS COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1177715, COL_222825DB_CF6B_476D_9220_1F5790868FCE#1177699 AS COL_222825DB_CF6B_476D_9220_1F5790868FCE#1177716, COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#1177700 AS COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#1177717, COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#1177708 AS COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#1177718, COL_FBB15BE3_311B_4A50_A657_811052E44533#1177701 AS COL_FBB15BE3_311B_4A50_A657_811052E44533#1177719, COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#1177702 AS COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#1177720]
(13) Project
Arguments: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1177715 AS COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1177727, COL_222825DB_CF6B_476D_9220_1F5790868FCE#1177716 AS COL_222825DB_CF6B_476D_9220_1F5790868FCE#1177728, COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#1177717 AS COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#1177729, COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#1177718 AS COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#1177730, COL_FBB15BE3_311B_4A50_A657_811052E44533#1177719 AS COL_FBB15BE3_311B_4A50_A657_811052E44533#1177731, COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#1177720 AS COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#1177732]
(14) Aggregate
Arguments: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1177727], [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1177727 AS COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#1177739, 1 AS NULL_1#1177752, collect_set(COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#1177730, 0, 0) AS COL_0BFBB0B6_BC27_47A8_80A6_BFB50040893F#1177747, min(COL_FBB15BE3_311B_4A50_A657_811052E44533#1177731) AS COL_44FFC137_1AC4_4401_927A_B506227F1922#1177749, collect_set(COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#1177732, 0, 0) AS COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#1177751]
(15) Project
Arguments: [COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#1177739, COL_0BFBB0B6_BC27_47A8_80A6_BFB50040893F#1177747, COL_44FFC137_1AC4_4401_927A_B506227F1922#1177749, COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#1177751]
(16) Project
Arguments: [COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#1177739 AS COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#1177762, COL_0BFBB0B6_BC27_47A8_80A6_BFB50040893F#1177747 AS COL_0BFBB0B6_BC27_47A8_80A6_BFB50040893F#1177763, COL_44FFC137_1AC4_4401_927A_B506227F1922#1177749 AS COL_44FFC137_1AC4_4401_927A_B506227F1922#1177764, COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#1177751 AS COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#1177765]
(17) Project
Arguments: [COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#1177762 AS COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#1177770, COL_0BFBB0B6_BC27_47A8_80A6_BFB50040893F#1177763 AS COL_0BFBB0B6_BC27_47A8_80A6_BFB50040893F#1177771, COL_44FFC137_1AC4_4401_927A_B506227F1922#1177764 AS COL_44FFC137_1AC4_4401_927A_B506227F1922#1177772, COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#1177765 AS COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#1177773]
(18) Project
Arguments: [COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#1177770, COL_0BFBB0B6_BC27_47A8_80A6_BFB50040893F#1177771, COL_44FFC137_1AC4_4401_927A_B506227F1922#1177772, COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#1177773, str_list_get(COL_0BFBB0B6_BC27_47A8_80A6_BFB50040893F#1177771, cast(0 as bigint)) AS COL_98193CA9_9380_48E6_8792_463790C0A819#1177778]
(19) Project
Arguments: [COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#1177770, COL_0BFBB0B6_BC27_47A8_80A6_BFB50040893F#1177771, COL_44FFC137_1AC4_4401_927A_B506227F1922#1177772, COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#1177773, COL_98193CA9_9380_48E6_8792_463790C0A819#1177778, date_time_to_str(COL_44FFC137_1AC4_4401_927A_B506227F1922#1177772, cast(ddMMyyyy as string), cast(Europe/Paris as string), cast(fr_FR as string)) AS COL_9A06318E_CF05_49E9_94F4_B9B28BCC2340#1177784]
(20) Project
Arguments: [COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#1177770 AS COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#1177791, COL_0BFBB0B6_BC27_47A8_80A6_BFB50040893F#1177771 AS COL_0BFBB0B6_BC27_47A8_80A6_BFB50040893F#1177792, COL_98193CA9_9380_48E6_8792_463790C0A819#1177778 AS COL_98193CA9_9380_48E6_8792_463790C0A819#1177793, COL_9A06318E_CF05_49E9_94F4_B9B28BCC2340#1177784 AS COL_9A06318E_CF05_49E9_94F4_B9B28BCC2340#1177794, COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#1177773 AS COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#1177795]