== 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_172706173`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1141099, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#1141100, COL_B01E4E9C_9C1A_413D_9FB4_F0E1F49B4990#1141101, COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#1141102, COL_3A5D02F6_4E3A_45C4_8CDF_BB835CE099A1#1141103, COL_F4778BDA_4A5D_4760_9816_852A7B042FC7#1141104, COL_D5EDAAE4_BF90_4134_AF8E_1039395D3356#1141105, COL_3FE49154_D45D_4F98_B54D_6981EB35F500#1141106, COL_C3324533_C0BB_4B8B_8370_DC4EE8F6BBC6#1141107, COL_F94DAC07_127C_4495_A440_68EF585E7F25#1141108, COL_5FE684A3_C173_4F6B_AD83_F16ADC313E77#1141109, COL_8C23F27C_A334_46F9_AD8F_4D2F98435644#1141110, COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#1141111, COL_4FAE5E83_EEBF_46C7_9422_78ECE1DA2B04#1141112, COL_69B4F97B_AC0E_4905_AA66_0924D4EFC3B6#1141113, COL_0D69EBFF_2BDF_4FD1_B4AC_7B1DEF4C3603#1141114, COL_A764821B_78E0_4C3B_A968_0BB28AD10628#1141115, COL_6CC6F978_0EE3_437E_8A71_6E7AB294A83A#1141116, COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#1141117, COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#1141118, COL_AFCA0F94_47F3_4392_B6C9_D0A473E54762#1141119, COL_C33495F5_0769_434B_A2E2_50AA49F857DD#1141120, COL_7D270645_B926_42AF_A110_EB3A1A53031B#1141121, COL_6A8C3138_77B0_404C_B949_FC01E1C85545#1141122, ... 29 more fields], false
(4) View
Arguments: `00_B_ACTES_PATI_172578173`, true
(5) SubqueryAlias
Arguments: 00_B_ACTES_PATI_172578173
(6) Project
Arguments: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1141099 AS 00_B_ACTES_PATI_172578_COL_64ED17E5_A991_405B_AEED_8A2977283F76#1141258, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#1141100 AS 00_B_ACTES_PATI_172578_COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#1141259, COL_B01E4E9C_9C1A_413D_9FB4_F0E1F49B4990#1141101 AS 00_B_ACTES_PATI_172578_COL_B01E4E9C_9C1A_413D_9FB4_F0E1F49B4990#1141260, COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#1141102 AS 00_B_ACTES_PATI_172578_COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#1141261, COL_3A5D02F6_4E3A_45C4_8CDF_BB835CE099A1#1141103 AS 00_B_ACTES_PATI_172578_COL_3A5D02F6_4E3A_45C4_8CDF_BB835CE099A1#1141262, COL_F4778BDA_4A5D_4760_9816_852A7B042FC7#1141104 AS 00_B_ACTES_PATI_172578_COL_F4778BDA_4A5D_4760_9816_852A7B042FC7#1141263, COL_D5EDAAE4_BF90_4134_AF8E_1039395D3356#1141105 AS 00_B_ACTES_PATI_172578_COL_D5EDAAE4_BF90_4134_AF8E_1039395D3356#1141264, COL_3FE49154_D45D_4F98_B54D_6981EB35F500#1141106 AS 00_B_ACTES_PATI_172578_COL_3FE49154_D45D_4F98_B54D_6981EB35F500#1141265, COL_C3324533_C0BB_4B8B_8370_DC4EE8F6BBC6#1141107 AS 00_B_ACTES_PATI_172578_COL_C3324533_C0BB_4B8B_8370_DC4EE8F6BBC6#1141266, COL_F94DAC07_127C_4495_A440_68EF585E7F25#1141108 AS 00_B_ACTES_PATI_172578_COL_F94DAC07_127C_4495_A440_68EF585E7F25#1141267, COL_5FE684A3_C173_4F6B_AD83_F16ADC313E77#1141109 AS 00_B_ACTES_PATI_172578_COL_5FE684A3_C173_4F6B_AD83_F16ADC313E77#1141268, COL_8C23F27C_A334_46F9_AD8F_4D2F98435644#1141110 AS 00_B_ACTES_PATI_172578_COL_8C23F27C_A334_46F9_AD8F_4D2F98435644#1141269, COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#1141111 AS 00_B_ACTES_PATI_172578_COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#1141270, COL_4FAE5E83_EEBF_46C7_9422_78ECE1DA2B04#1141112 AS 00_B_ACTES_PATI_172578_COL_4FAE5E83_EEBF_46C7_9422_78ECE1DA2B04#1141271, COL_69B4F97B_AC0E_4905_AA66_0924D4EFC3B6#1141113 AS 00_B_ACTES_PATI_172578_COL_69B4F97B_AC0E_4905_AA66_0924D4EFC3B6#1141272, COL_0D69EBFF_2BDF_4FD1_B4AC_7B1DEF4C3603#1141114 AS 00_B_ACTES_PATI_172578_COL_0D69EBFF_2BDF_4FD1_B4AC_7B1DEF4C3603#1141273, COL_A764821B_78E0_4C3B_A968_0BB28AD10628#1141115 AS 00_B_ACTES_PATI_172578_COL_A764821B_78E0_4C3B_A968_0BB28AD10628#1141274, COL_6CC6F978_0EE3_437E_8A71_6E7AB294A83A#1141116 AS 00_B_ACTES_PATI_172578_COL_6CC6F978_0EE3_437E_8A71_6E7AB294A83A#1141275, COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#1141117 AS 00_B_ACTES_PATI_172578_COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#1141276, COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#1141118 AS 00_B_ACTES_PATI_172578_COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#1141277, COL_AFCA0F94_47F3_4392_B6C9_D0A473E54762#1141119 AS 00_B_ACTES_PATI_172578_COL_AFCA0F94_47F3_4392_B6C9_D0A473E54762#1141278, COL_C33495F5_0769_434B_A2E2_50AA49F857DD#1141120 AS 00_B_ACTES_PATI_172578_COL_C33495F5_0769_434B_A2E2_50AA49F857DD#1141279, COL_7D270645_B926_42AF_A110_EB3A1A53031B#1141121 AS 00_B_ACTES_PATI_172578_COL_7D270645_B926_42AF_A110_EB3A1A53031B#1141280, COL_6A8C3138_77B0_404C_B949_FC01E1C85545#1141122 AS 00_B_ACTES_PATI_172578_COL_6A8C3138_77B0_404C_B949_FC01E1C85545#1141281, ... 29 more fields]
(7) Project
Arguments: [cast(00_B_ACTES_PATI_172578_COL_64ED17E5_A991_405B_AEED_8A2977283F76#1141258 as string) AS COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1141369, cast(00_B_ACTES_PATI_172578_COL_F94DAC07_127C_4495_A440_68EF585E7F25#1141267 as string) AS COL_222825DB_CF6B_476D_9220_1F5790868FCE#1141370, cast(00_B_ACTES_PATI_172578_COL_6A8C3138_77B0_404C_B949_FC01E1C85545#1141281 as string) AS COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#1141371, cast(00_B_ACTES_PATI_172578_COL_EA6371C8_0F76_4199_B797_A5888F7D4D43#1141285 as timestamp) AS COL_FBB15BE3_311B_4A50_A657_811052E44533#1141372, cast(00_B_ACTES_PATI_172578_COL_1996D387_9E74_479E_8427_83B4DBA88131#1141304 as string) AS COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#1141373]
(8) Project
Arguments: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1141369 AS COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1141379, COL_222825DB_CF6B_476D_9220_1F5790868FCE#1141370 AS COL_222825DB_CF6B_476D_9220_1F5790868FCE#1141380, COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#1141371 AS COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#1141381, COL_FBB15BE3_311B_4A50_A657_811052E44533#1141372 AS COL_FBB15BE3_311B_4A50_A657_811052E44533#1141382, COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#1141373 AS COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#1141383]
(9) Project
Arguments: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1141379 AS COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1141389, COL_222825DB_CF6B_476D_9220_1F5790868FCE#1141380 AS COL_222825DB_CF6B_476D_9220_1F5790868FCE#1141390, COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#1141381 AS COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#1141391, COL_FBB15BE3_311B_4A50_A657_811052E44533#1141382 AS COL_FBB15BE3_311B_4A50_A657_811052E44533#1141392, COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#1141383 AS COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#1141393]
(10) Project
Arguments: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1141389 AS COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1141399, COL_222825DB_CF6B_476D_9220_1F5790868FCE#1141390 AS COL_222825DB_CF6B_476D_9220_1F5790868FCE#1141400, COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#1141391 AS COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#1141401, COL_FBB15BE3_311B_4A50_A657_811052E44533#1141392 AS COL_FBB15BE3_311B_4A50_A657_811052E44533#1141402, COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#1141393 AS COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#1141403]
(11) Project
Arguments: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1141399, COL_222825DB_CF6B_476D_9220_1F5790868FCE#1141400, COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#1141401, COL_FBB15BE3_311B_4A50_A657_811052E44533#1141402, COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#1141403, str_if_with_rule(((COL_222825DB_CF6B_476D_9220_1F5790868FCE#1141400 <=> cast(1 as string)) AND CASE WHEN isnull(Contains(COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#1141401, cast(2 as string))) THEN false ELSE Contains(COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#1141401, cast(2 as string)) END), cast(SU2 as string), str_if_with_rule((((COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#1141401 <=> cast(3 as string)) OR (COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#1141401 <=> cast(4 as string))) OR (COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#1141401 <=> cast(5 as string))), cast(SU3 as string), cast(null as string))) AS COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#1141409]
(12) Project
Arguments: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1141399 AS COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1141416, COL_222825DB_CF6B_476D_9220_1F5790868FCE#1141400 AS COL_222825DB_CF6B_476D_9220_1F5790868FCE#1141417, COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#1141401 AS COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#1141418, COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#1141409 AS COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#1141419, COL_FBB15BE3_311B_4A50_A657_811052E44533#1141402 AS COL_FBB15BE3_311B_4A50_A657_811052E44533#1141420, COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#1141403 AS COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#1141421]
(13) Project
Arguments: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1141416 AS COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1141428, COL_222825DB_CF6B_476D_9220_1F5790868FCE#1141417 AS COL_222825DB_CF6B_476D_9220_1F5790868FCE#1141429, COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#1141418 AS COL_EE9732CA_6340_4A62_9F3B_51BFA0AF8EC7#1141430, COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#1141419 AS COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#1141431, COL_FBB15BE3_311B_4A50_A657_811052E44533#1141420 AS COL_FBB15BE3_311B_4A50_A657_811052E44533#1141432, COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#1141421 AS COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#1141433]
(14) Aggregate
Arguments: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1141428], [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#1141428 AS COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#1141440, 1 AS NULL_1#1141453, collect_set(COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#1141431, 0, 0) AS COL_0BFBB0B6_BC27_47A8_80A6_BFB50040893F#1141448, min(COL_FBB15BE3_311B_4A50_A657_811052E44533#1141432) AS COL_44FFC137_1AC4_4401_927A_B506227F1922#1141450, collect_set(COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#1141433, 0, 0) AS COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#1141452]
(15) Project
Arguments: [COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#1141440, COL_0BFBB0B6_BC27_47A8_80A6_BFB50040893F#1141448, COL_44FFC137_1AC4_4401_927A_B506227F1922#1141450, COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#1141452]
(16) Project
Arguments: [COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#1141440 AS COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#1141463, COL_0BFBB0B6_BC27_47A8_80A6_BFB50040893F#1141448 AS COL_0BFBB0B6_BC27_47A8_80A6_BFB50040893F#1141464, COL_44FFC137_1AC4_4401_927A_B506227F1922#1141450 AS COL_44FFC137_1AC4_4401_927A_B506227F1922#1141465, COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#1141452 AS COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#1141466]
(17) Project
Arguments: [COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#1141463 AS COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#1141471, COL_0BFBB0B6_BC27_47A8_80A6_BFB50040893F#1141464 AS COL_0BFBB0B6_BC27_47A8_80A6_BFB50040893F#1141472, COL_44FFC137_1AC4_4401_927A_B506227F1922#1141465 AS COL_44FFC137_1AC4_4401_927A_B506227F1922#1141473, COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#1141466 AS COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#1141474]
(18) Project
Arguments: [COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#1141471, COL_0BFBB0B6_BC27_47A8_80A6_BFB50040893F#1141472, COL_44FFC137_1AC4_4401_927A_B506227F1922#1141473, COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#1141474, str_list_get(COL_0BFBB0B6_BC27_47A8_80A6_BFB50040893F#1141472, cast(0 as bigint)) AS COL_98193CA9_9380_48E6_8792_463790C0A819#1141479]
(19) Project
Arguments: [COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#1141471, COL_0BFBB0B6_BC27_47A8_80A6_BFB50040893F#1141472, COL_44FFC137_1AC4_4401_927A_B506227F1922#1141473, COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#1141474, COL_98193CA9_9380_48E6_8792_463790C0A819#1141479, date_time_to_str(COL_44FFC137_1AC4_4401_927A_B506227F1922#1141473, cast(ddMMyyyy as string), cast(Europe/Paris as string), cast(fr_FR as string)) AS COL_9A06318E_CF05_49E9_94F4_B9B28BCC2340#1141485]
(20) Project
Arguments: [COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#1141471 AS COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#1141492, COL_0BFBB0B6_BC27_47A8_80A6_BFB50040893F#1141472 AS COL_0BFBB0B6_BC27_47A8_80A6_BFB50040893F#1141493, COL_98193CA9_9380_48E6_8792_463790C0A819#1141479 AS COL_98193CA9_9380_48E6_8792_463790C0A819#1141494, COL_9A06318E_CF05_49E9_94F4_B9B28BCC2340#1141485 AS COL_9A06318E_CF05_49E9_94F4_B9B28BCC2340#1141495, COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#1141474 AS COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#1141496]