== 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_225933169`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [COL_64ED17E5_A991_405B_AEED_8A2977283F76#525771, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#525772, COL_B01E4E9C_9C1A_413D_9FB4_F0E1F49B4990#525773, COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#525774, COL_3A5D02F6_4E3A_45C4_8CDF_BB835CE099A1#525775, COL_F4778BDA_4A5D_4760_9816_852A7B042FC7#525776, COL_D5EDAAE4_BF90_4134_AF8E_1039395D3356#525777, COL_3FE49154_D45D_4F98_B54D_6981EB35F500#525778, COL_C3324533_C0BB_4B8B_8370_DC4EE8F6BBC6#525779, COL_F94DAC07_127C_4495_A440_68EF585E7F25#525780, COL_5FE684A3_C173_4F6B_AD83_F16ADC313E77#525781, COL_8C23F27C_A334_46F9_AD8F_4D2F98435644#525782, COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#525783, COL_4FAE5E83_EEBF_46C7_9422_78ECE1DA2B04#525784, COL_69B4F97B_AC0E_4905_AA66_0924D4EFC3B6#525785, COL_0D69EBFF_2BDF_4FD1_B4AC_7B1DEF4C3603#525786, COL_A764821B_78E0_4C3B_A968_0BB28AD10628#525787, COL_6CC6F978_0EE3_437E_8A71_6E7AB294A83A#525788, COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#525789, COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#525790, COL_AFCA0F94_47F3_4392_B6C9_D0A473E54762#525791, COL_C33495F5_0769_434B_A2E2_50AA49F857DD#525792, COL_7D270645_B926_42AF_A110_EB3A1A53031B#525793, COL_6A8C3138_77B0_404C_B949_FC01E1C85545#525794, ... 29 more fields], false
(4) View
Arguments: `00_B_ACTES_PATI_225863169`, true
(5) SubqueryAlias
Arguments: 00_B_ACTES_PATI_225863169
(6) Project
Arguments: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#525771 AS 00_B_ACTES_PATI_225863_COL_64ED17E5_A991_405B_AEED_8A2977283F76#525965, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#525772 AS 00_B_ACTES_PATI_225863_COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#525966, COL_B01E4E9C_9C1A_413D_9FB4_F0E1F49B4990#525773 AS 00_B_ACTES_PATI_225863_COL_B01E4E9C_9C1A_413D_9FB4_F0E1F49B4990#525967, COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#525774 AS 00_B_ACTES_PATI_225863_COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#525968, COL_3A5D02F6_4E3A_45C4_8CDF_BB835CE099A1#525775 AS 00_B_ACTES_PATI_225863_COL_3A5D02F6_4E3A_45C4_8CDF_BB835CE099A1#525969, COL_F4778BDA_4A5D_4760_9816_852A7B042FC7#525776 AS 00_B_ACTES_PATI_225863_COL_F4778BDA_4A5D_4760_9816_852A7B042FC7#525970, COL_D5EDAAE4_BF90_4134_AF8E_1039395D3356#525777 AS 00_B_ACTES_PATI_225863_COL_D5EDAAE4_BF90_4134_AF8E_1039395D3356#525971, COL_3FE49154_D45D_4F98_B54D_6981EB35F500#525778 AS 00_B_ACTES_PATI_225863_COL_3FE49154_D45D_4F98_B54D_6981EB35F500#525972, COL_C3324533_C0BB_4B8B_8370_DC4EE8F6BBC6#525779 AS 00_B_ACTES_PATI_225863_COL_C3324533_C0BB_4B8B_8370_DC4EE8F6BBC6#525973, COL_F94DAC07_127C_4495_A440_68EF585E7F25#525780 AS 00_B_ACTES_PATI_225863_COL_F94DAC07_127C_4495_A440_68EF585E7F25#525974, COL_5FE684A3_C173_4F6B_AD83_F16ADC313E77#525781 AS 00_B_ACTES_PATI_225863_COL_5FE684A3_C173_4F6B_AD83_F16ADC313E77#525975, COL_8C23F27C_A334_46F9_AD8F_4D2F98435644#525782 AS 00_B_ACTES_PATI_225863_COL_8C23F27C_A334_46F9_AD8F_4D2F98435644#525976, COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#525783 AS 00_B_ACTES_PATI_225863_COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#525977, COL_4FAE5E83_EEBF_46C7_9422_78ECE1DA2B04#525784 AS 00_B_ACTES_PATI_225863_COL_4FAE5E83_EEBF_46C7_9422_78ECE1DA2B04#525978, COL_69B4F97B_AC0E_4905_AA66_0924D4EFC3B6#525785 AS 00_B_ACTES_PATI_225863_COL_69B4F97B_AC0E_4905_AA66_0924D4EFC3B6#525979, COL_0D69EBFF_2BDF_4FD1_B4AC_7B1DEF4C3603#525786 AS 00_B_ACTES_PATI_225863_COL_0D69EBFF_2BDF_4FD1_B4AC_7B1DEF4C3603#525980, COL_A764821B_78E0_4C3B_A968_0BB28AD10628#525787 AS 00_B_ACTES_PATI_225863_COL_A764821B_78E0_4C3B_A968_0BB28AD10628#525981, COL_6CC6F978_0EE3_437E_8A71_6E7AB294A83A#525788 AS 00_B_ACTES_PATI_225863_COL_6CC6F978_0EE3_437E_8A71_6E7AB294A83A#525982, COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#525789 AS 00_B_ACTES_PATI_225863_COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#525983, COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#525790 AS 00_B_ACTES_PATI_225863_COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#525984, COL_AFCA0F94_47F3_4392_B6C9_D0A473E54762#525791 AS 00_B_ACTES_PATI_225863_COL_AFCA0F94_47F3_4392_B6C9_D0A473E54762#525985, COL_C33495F5_0769_434B_A2E2_50AA49F857DD#525792 AS 00_B_ACTES_PATI_225863_COL_C33495F5_0769_434B_A2E2_50AA49F857DD#525986, COL_7D270645_B926_42AF_A110_EB3A1A53031B#525793 AS 00_B_ACTES_PATI_225863_COL_7D270645_B926_42AF_A110_EB3A1A53031B#525987, COL_6A8C3138_77B0_404C_B949_FC01E1C85545#525794 AS 00_B_ACTES_PATI_225863_COL_6A8C3138_77B0_404C_B949_FC01E1C85545#525988, ... 29 more fields]
(7) Project
Arguments: [cast(00_B_ACTES_PATI_225863_COL_64ED17E5_A991_405B_AEED_8A2977283F76#525965 as string) AS COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#526076, cast(00_B_ACTES_PATI_225863_COL_F94DAC07_127C_4495_A440_68EF585E7F25#525974 as string) AS COL_222825DB_CF6B_476D_9220_1F5790868FCE#526077, cast(00_B_ACTES_PATI_225863_COL_6A8C3138_77B0_404C_B949_FC01E1C85545#525988 as string) AS COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#526078, cast(00_B_ACTES_PATI_225863_COL_EA6371C8_0F76_4199_B797_A5888F7D4D43#525992 as timestamp) AS COL_FBB15BE3_311B_4A50_A657_811052E44533#526079, cast(00_B_ACTES_PATI_225863_COL_1996D387_9E74_479E_8427_83B4DBA88131#526011 as string) AS COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#526080]
(8) Project
Arguments: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#526076 AS COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#526086, COL_222825DB_CF6B_476D_9220_1F5790868FCE#526077 AS COL_222825DB_CF6B_476D_9220_1F5790868FCE#526087, COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#526078 AS COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#526088, COL_FBB15BE3_311B_4A50_A657_811052E44533#526079 AS COL_FBB15BE3_311B_4A50_A657_811052E44533#526089, COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#526080 AS COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#526090]
(9) Project
Arguments: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#526086 AS COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#526154, COL_222825DB_CF6B_476D_9220_1F5790868FCE#526087 AS COL_222825DB_CF6B_476D_9220_1F5790868FCE#526156, COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#526088 AS COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#526158, COL_FBB15BE3_311B_4A50_A657_811052E44533#526089 AS COL_FBB15BE3_311B_4A50_A657_811052E44533#526160, COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#526090 AS COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#526162]
(10) Project
Arguments: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#526154 AS COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#526176, COL_222825DB_CF6B_476D_9220_1F5790868FCE#526156 AS COL_222825DB_CF6B_476D_9220_1F5790868FCE#526177, COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#526158 AS COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#526178, COL_FBB15BE3_311B_4A50_A657_811052E44533#526160 AS COL_FBB15BE3_311B_4A50_A657_811052E44533#526179, COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#526162 AS COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#526180]
(11) Project
Arguments: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#526176, COL_222825DB_CF6B_476D_9220_1F5790868FCE#526177, COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#526178, COL_FBB15BE3_311B_4A50_A657_811052E44533#526179, COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#526180, str_if_with_rule(((COL_222825DB_CF6B_476D_9220_1F5790868FCE#526177 <=> cast(1 as string)) AND CASE WHEN isnull(Contains(COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#526178, cast(2 as string))) THEN false ELSE Contains(COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#526178, cast(2 as string)) END), cast(SU2 as string), str_if_with_rule((((COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#526178 <=> cast(3 as string)) OR (COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#526178 <=> cast(4 as string))) OR (COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#526178 <=> cast(5 as string))), cast(SU3 as string), cast(null as string))) AS COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#526186]
(12) Project
Arguments: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#526176 AS COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#526228, COL_222825DB_CF6B_476D_9220_1F5790868FCE#526177 AS COL_222825DB_CF6B_476D_9220_1F5790868FCE#526229, COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#526178 AS COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#526230, COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#526186 AS COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#526231, COL_FBB15BE3_311B_4A50_A657_811052E44533#526179 AS COL_FBB15BE3_311B_4A50_A657_811052E44533#526232, COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#526180 AS COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#526233]
(13) Project
Arguments: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#526228 AS COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#526275, COL_222825DB_CF6B_476D_9220_1F5790868FCE#526229 AS COL_222825DB_CF6B_476D_9220_1F5790868FCE#526276, COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#526230 AS COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#526277, COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#526231 AS COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#526278, COL_FBB15BE3_311B_4A50_A657_811052E44533#526232 AS COL_FBB15BE3_311B_4A50_A657_811052E44533#526279, COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#526233 AS COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#526280]
(14) Aggregate
Arguments: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#526275], [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#526275 AS COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#526287, 1 AS NULL_1#526300, collect_set(COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#526278, 0, 0) AS COL_0BFBB0B6_BC27_47A8_80A6_BFB50040893F#526295, min(COL_FBB15BE3_311B_4A50_A657_811052E44533#526279) AS COL_44FFC137_1AC4_4401_927A_B506227F1922#526297, collect_set(COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#526280, 0, 0) AS COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#526299]
(15) Project
Arguments: [COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#526287, COL_0BFBB0B6_BC27_47A8_80A6_BFB50040893F#526295, COL_44FFC137_1AC4_4401_927A_B506227F1922#526297, COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#526299]
(16) Project
Arguments: [COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#526287 AS COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#526346, COL_0BFBB0B6_BC27_47A8_80A6_BFB50040893F#526295 AS COL_0BFBB0B6_BC27_47A8_80A6_BFB50040893F#526347, COL_44FFC137_1AC4_4401_927A_B506227F1922#526297 AS COL_44FFC137_1AC4_4401_927A_B506227F1922#526348, COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#526299 AS COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#526349]
(17) Project
Arguments: [COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#526346 AS COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#526354, COL_0BFBB0B6_BC27_47A8_80A6_BFB50040893F#526347 AS COL_0BFBB0B6_BC27_47A8_80A6_BFB50040893F#526355, COL_44FFC137_1AC4_4401_927A_B506227F1922#526348 AS COL_44FFC137_1AC4_4401_927A_B506227F1922#526356, COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#526349 AS COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#526357]
(18) Project
Arguments: [COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#526354, COL_0BFBB0B6_BC27_47A8_80A6_BFB50040893F#526355, COL_44FFC137_1AC4_4401_927A_B506227F1922#526356, COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#526357, str_list_get(COL_0BFBB0B6_BC27_47A8_80A6_BFB50040893F#526355, cast(0 as bigint)) AS COL_98193CA9_9380_48E6_8792_463790C0A819#526362]
(19) Project
Arguments: [COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#526354, COL_0BFBB0B6_BC27_47A8_80A6_BFB50040893F#526355, COL_44FFC137_1AC4_4401_927A_B506227F1922#526356, COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#526357, COL_98193CA9_9380_48E6_8792_463790C0A819#526362, date_time_to_str(COL_44FFC137_1AC4_4401_927A_B506227F1922#526356, cast(ddMMyyyy as string), cast(Europe/Paris as string), cast(fr_FR as string)) AS COL_9A06318E_CF05_49E9_94F4_B9B28BCC2340#526368]
(20) Project
Arguments: [COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#526354 AS COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#526375, COL_0BFBB0B6_BC27_47A8_80A6_BFB50040893F#526355 AS COL_0BFBB0B6_BC27_47A8_80A6_BFB50040893F#526376, COL_98193CA9_9380_48E6_8792_463790C0A819#526362 AS COL_98193CA9_9380_48E6_8792_463790C0A819#526377, COL_9A06318E_CF05_49E9_94F4_B9B28BCC2340#526368 AS COL_9A06318E_CF05_49E9_94F4_B9B28BCC2340#526378, COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#526357 AS COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#526379]