== Physical Plan ==
Execute CreateViewCommand (1)
+- CreateViewCommand (2)
+- Project (58)
+- Filter (57)
+- Project (56)
+- Project (55)
+- Project (54)
+- Project (53)
+- Join (52)
:- Project (34)
: +- Project (33)
: +- Project (32)
: +- Aggregate (31)
: +- Filter (30)
: +- Project (29)
: +- Project (28)
: +- Filter (27)
: +- Project (26)
: +- Project (25)
: +- Project (24)
: +- Project (23)
: +- Project (22)
: +- Project (21)
: +- Project (20)
: +- Window (19)
: +- Project (18)
: +- Project (17)
: +- Filter (16)
: +- GlobalLimit (15)
: +- LocalLimit (14)
: +- Project (13)
: +- Project (12)
: +- Project (11)
: +- SubqueryAlias (10)
: +- View (9)
: +- Project (8)
: +- Project (7)
: +- Project (6)
: +- Project (5)
: +- Project (4)
: +- LogicalRelation (3)
+- Project (51)
+- SubqueryAlias (50)
+- View (49)
+- Project (48)
+- Project (47)
+- Project (46)
+- Project (45)
+- Project (44)
+- SubqueryAlias (43)
+- View (42)
+- Project (41)
+- Project (40)
+- Project (39)
+- Project (38)
+- Project (37)
+- Project (36)
+- LogicalRelation (35)
(1) Execute CreateViewCommand
Output: []
(2) CreateViewCommand
Arguments: `CTRL_FINESS_RSF_345995167`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [_c0#272148], false
(4) Project
Arguments: [_c0#272148 AS COLL0#272150]
(5) Project
Arguments: [COLL0#272150 AS COLL0#272153]
(6) Project
Arguments: [COLL0#272153]
(7) Project
Arguments: [cast(str_create(cast( as string)) as string) AS ETABLISSEMENT_345942#272158, COLL0#272153 AS _C0_345941#272157]
(8) Project
Arguments: [ETABLISSEMENT_345942#272158, _C0_345941#272157]
(9) View
Arguments: `RSF_345940167`, true
(10) SubqueryAlias
Arguments: RSF_345940167
(11) Project
Arguments: [ETABLISSEMENT_345942#272158 AS RSF_345940_ETABLISSEMENT_345942#272165, _C0_345941#272157 AS RSF_345940__C0_345941#272166]
(12) Project
Arguments: [cast(RSF_345940__C0_345941#272166 as string) AS COL_0B816CAF_81A1_4E69_B9E3_E6597EABCC0D#272171, cast(RSF_345940_ETABLISSEMENT_345942#272165 as string) AS COL_80933A43_413D_4028_A7DB_94D6A9FA84C1#272172]
(13) Project
Arguments: [COL_0B816CAF_81A1_4E69_B9E3_E6597EABCC0D#272171 AS COL_0B816CAF_81A1_4E69_B9E3_E6597EABCC0D#272175, COL_80933A43_413D_4028_A7DB_94D6A9FA84C1#272172 AS COL_80933A43_413D_4028_A7DB_94D6A9FA84C1#272176]
(14) LocalLimit
Arguments: 3
(15) GlobalLimit
Arguments: 3
(16) Filter
Arguments: true
(17) Project
Arguments: [COL_0B816CAF_81A1_4E69_B9E3_E6597EABCC0D#272175, COL_80933A43_413D_4028_A7DB_94D6A9FA84C1#272176, 1 AS CONST#272179]
(18) Project
Arguments: [COL_0B816CAF_81A1_4E69_B9E3_E6597EABCC0D#272175, COL_80933A43_413D_4028_A7DB_94D6A9FA84C1#272176, CONST#272179]
(19) Window
Arguments: [row_number() windowspecdefinition(1, CONST#272179 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_466B8114_A534_4700_99C5_61D90974826A#272184], [1], [CONST#272179 DESC NULLS LAST]
(20) Project
Arguments: [COL_0B816CAF_81A1_4E69_B9E3_E6597EABCC0D#272175, COL_80933A43_413D_4028_A7DB_94D6A9FA84C1#272176, CONST#272179, COL_466B8114_A534_4700_99C5_61D90974826A#272184, COL_466B8114_A534_4700_99C5_61D90974826A#272184]
(21) Project
Arguments: [COL_0B816CAF_81A1_4E69_B9E3_E6597EABCC0D#272175, COL_80933A43_413D_4028_A7DB_94D6A9FA84C1#272176, CONST#272179, COL_466B8114_A534_4700_99C5_61D90974826A#272184]
(22) Project
Arguments: [COL_0B816CAF_81A1_4E69_B9E3_E6597EABCC0D#272175, COL_80933A43_413D_4028_A7DB_94D6A9FA84C1#272176, COL_466B8114_A534_4700_99C5_61D90974826A#272184]
(23) Project
Arguments: [COL_0B816CAF_81A1_4E69_B9E3_E6597EABCC0D#272175 AS COL_0B816CAF_81A1_4E69_B9E3_E6597EABCC0D#272192, COL_80933A43_413D_4028_A7DB_94D6A9FA84C1#272176 AS COL_80933A43_413D_4028_A7DB_94D6A9FA84C1#272193, COL_466B8114_A534_4700_99C5_61D90974826A#272184 AS COL_466B8114_A534_4700_99C5_61D90974826A#272194]
(24) Project
Arguments: [COL_0B816CAF_81A1_4E69_B9E3_E6597EABCC0D#272192 AS COL_0B816CAF_81A1_4E69_B9E3_E6597EABCC0D#272198, COL_80933A43_413D_4028_A7DB_94D6A9FA84C1#272193 AS COL_80933A43_413D_4028_A7DB_94D6A9FA84C1#272199, COL_466B8114_A534_4700_99C5_61D90974826A#272194 AS COL_466B8114_A534_4700_99C5_61D90974826A#272200]
(25) Project
Arguments: [COL_0B816CAF_81A1_4E69_B9E3_E6597EABCC0D#272198, COL_80933A43_413D_4028_A7DB_94D6A9FA84C1#272199, COL_466B8114_A534_4700_99C5_61D90974826A#272200, str_extract(COL_0B816CAF_81A1_4E69_B9E3_E6597EABCC0D#272198, cast(LEFT as string), cast(1 as bigint)) AS COL_05407152_049D_46F2_8E36_4129E0BC5272#272204]
(26) Project
Arguments: [COL_0B816CAF_81A1_4E69_B9E3_E6597EABCC0D#272198, COL_80933A43_413D_4028_A7DB_94D6A9FA84C1#272199, COL_466B8114_A534_4700_99C5_61D90974826A#272200, COL_05407152_049D_46F2_8E36_4129E0BC5272#272204, str_extract_middle(COL_0B816CAF_81A1_4E69_B9E3_E6597EABCC0D#272198, cast(2 as bigint), cast(9 as bigint)) AS COL_CD1100A9_9106_47C2_93C6_E2EF19A395A4#272209]
(27) Filter
Arguments: (((COL_466B8114_A534_4700_99C5_61D90974826A#272200 <=> cast(1 as int)) AND (COL_05407152_049D_46F2_8E36_4129E0BC5272#272204 <=> cast(A as string))) OR CASE WHEN isnull((COL_466B8114_A534_4700_99C5_61D90974826A#272200 > cast(1 as int))) THEN false ELSE (COL_466B8114_A534_4700_99C5_61D90974826A#272200 > cast(1 as int)) END)
(28) Project
Arguments: [COL_0B816CAF_81A1_4E69_B9E3_E6597EABCC0D#272198 AS COL_0B816CAF_81A1_4E69_B9E3_E6597EABCC0D#272215, COL_80933A43_413D_4028_A7DB_94D6A9FA84C1#272199 AS COL_80933A43_413D_4028_A7DB_94D6A9FA84C1#272216, COL_466B8114_A534_4700_99C5_61D90974826A#272200 AS COL_466B8114_A534_4700_99C5_61D90974826A#272217, COL_05407152_049D_46F2_8E36_4129E0BC5272#272204 AS COL_05407152_049D_46F2_8E36_4129E0BC5272#272218, COL_CD1100A9_9106_47C2_93C6_E2EF19A395A4#272209 AS COL_CD1100A9_9106_47C2_93C6_E2EF19A395A4#272219]
(29) Project
Arguments: [COL_0B816CAF_81A1_4E69_B9E3_E6597EABCC0D#272215 AS COL_0B816CAF_81A1_4E69_B9E3_E6597EABCC0D#272225, COL_80933A43_413D_4028_A7DB_94D6A9FA84C1#272216 AS COL_80933A43_413D_4028_A7DB_94D6A9FA84C1#272226, COL_466B8114_A534_4700_99C5_61D90974826A#272217 AS COL_466B8114_A534_4700_99C5_61D90974826A#272227, COL_05407152_049D_46F2_8E36_4129E0BC5272#272218 AS COL_05407152_049D_46F2_8E36_4129E0BC5272#272228, COL_CD1100A9_9106_47C2_93C6_E2EF19A395A4#272219 AS COL_CD1100A9_9106_47C2_93C6_E2EF19A395A4#272229]
(30) Filter
Arguments: true
(31) Aggregate
Arguments: [COL_CD1100A9_9106_47C2_93C6_E2EF19A395A4#272229], [COL_CD1100A9_9106_47C2_93C6_E2EF19A395A4#272229 AS COL_467B8EF8_7CFB_46F2_8CD4_3805AEA1E17D#272235, 1 AS NULL_1#272241]
(32) Project
Arguments: [COL_467B8EF8_7CFB_46F2_8CD4_3805AEA1E17D#272235]
(33) Project
Arguments: [COL_467B8EF8_7CFB_46F2_8CD4_3805AEA1E17D#272235 AS COL_467B8EF8_7CFB_46F2_8CD4_3805AEA1E17D#272245]
(34) Project
Arguments: [COL_467B8EF8_7CFB_46F2_8CD4_3805AEA1E17D#272245 AS COL_467B8EF8_7CFB_46F2_8CD4_3805AEA1E17D#272247]
(35) LogicalRelation
Arguments: csv, [finess_dataapps#272083, region-tarif#272084, login-user#272085], false
(36) Project
Arguments: [finess_dataapps#272083, region-tarif#272084, login-user#272085, cast(null as string) AS login_user#272089]
(37) Project
Arguments: [finess_dataapps#272083, region-tarif#272084, login_user#272089]
(38) Project
Arguments: [finess_dataapps#272083 AS finess_dataapps#272098, region-tarif#272084 AS region-tarif#272099, login_user#272089 AS login_user#272100]
(39) Project
Arguments: [finess_dataapps#272098, region-tarif#272099, login_user#272100]
(40) Project
Arguments: [finess_dataapps#272098 AS INFO_ETAB_FINES_345944#272107, region-tarif#272099 AS REGION_TARIF_345945#272108]
(41) Project
Arguments: [INFO_ETAB_FINES_345944#272107, REGION_TARIF_345945#272108]
(42) View
Arguments: `INFO_DATAAPPS_345943167`, true
(43) SubqueryAlias
Arguments: INFO_DATAAPPS_345943167
(44) Project
Arguments: [INFO_ETAB_FINES_345944#272107 AS INFO_DATAAPPS_345943_INFO_ETAB_FINES_345944#272115, REGION_TARIF_345945#272108 AS INFO_DATAAPPS_345943_REGION_TARIF_345945#272116]
(45) Project
Arguments: [cast(INFO_DATAAPPS_345943_INFO_ETAB_FINES_345944#272115 as string) AS COL_D78E5A4B_5147_439E_B045_CC77D9B56ECA#272120]
(46) Project
Arguments: [COL_D78E5A4B_5147_439E_B045_CC77D9B56ECA#272120 AS COL_D78E5A4B_5147_439E_B045_CC77D9B56ECA#272122]
(47) Project
Arguments: [COL_D78E5A4B_5147_439E_B045_CC77D9B56ECA#272122, str_create(COL_D78E5A4B_5147_439E_B045_CC77D9B56ECA#272122) AS COL_A9C3D939_A6C7_4DC2_8CC2_91076A4A2CFC#272124]
(48) Project
Arguments: [COL_A9C3D939_A6C7_4DC2_8CC2_91076A4A2CFC#272124 AS COL_A9C3D939_A6C7_4DC2_8CC2_91076A4A2CFC#272127, COL_D78E5A4B_5147_439E_B045_CC77D9B56ECA#272122 AS COL_D78E5A4B_5147_439E_B045_CC77D9B56ECA#272128]
(49) View
Arguments: `INFO_DATAAPPS_346034167`, true
(50) SubqueryAlias
Arguments: INFO_DATAAPPS_346034167
(51) Project
Arguments: [COL_A9C3D939_A6C7_4DC2_8CC2_91076A4A2CFC#272127 AS INFO_DATAAPPS_346034_COL_A9C3D939_A6C7_4DC2_8CC2_91076A4A2CFC#272251, COL_D78E5A4B_5147_439E_B045_CC77D9B56ECA#272128 AS INFO_DATAAPPS_346034_COL_D78E5A4B_5147_439E_B045_CC77D9B56ECA#272252]
(52) Join
Arguments: Cross
(53) Project
Arguments: [COL_467B8EF8_7CFB_46F2_8CD4_3805AEA1E17D#272247, INFO_DATAAPPS_346034_COL_A9C3D939_A6C7_4DC2_8CC2_91076A4A2CFC#272251 AS COL_A755B8E4_00B9_4ACC_89D8_A49641AE5BF6#272258]
(54) Project
Arguments: [COL_467B8EF8_7CFB_46F2_8CD4_3805AEA1E17D#272247 AS COL_467B8EF8_7CFB_46F2_8CD4_3805AEA1E17D#272261, COL_A755B8E4_00B9_4ACC_89D8_A49641AE5BF6#272258 AS COL_A755B8E4_00B9_4ACC_89D8_A49641AE5BF6#272262]
(55) Project
Arguments: [COL_467B8EF8_7CFB_46F2_8CD4_3805AEA1E17D#272261 AS COL_467B8EF8_7CFB_46F2_8CD4_3805AEA1E17D#272265, COL_A755B8E4_00B9_4ACC_89D8_A49641AE5BF6#272262 AS COL_A755B8E4_00B9_4ACC_89D8_A49641AE5BF6#272266]
(56) Project
Arguments: [COL_467B8EF8_7CFB_46F2_8CD4_3805AEA1E17D#272265, COL_A755B8E4_00B9_4ACC_89D8_A49641AE5BF6#272266, str_if_with_rule((COL_A755B8E4_00B9_4ACC_89D8_A49641AE5BF6#272266 <=> COL_467B8EF8_7CFB_46F2_8CD4_3805AEA1E17D#272265), cast(null as string), cast(Incohérence entre le FINESS saisi et le FINESS du fichier RSF as string)) AS COL_42952156_A6E1_4158_96AE_E70CF0ED9DCE#272269]
(57) Filter
Arguments: isnotnull(COL_42952156_A6E1_4158_96AE_E70CF0ED9DCE#272269)
(58) Project
Arguments: [COL_42952156_A6E1_4158_96AE_E70CF0ED9DCE#272269 AS COL_42952156_A6E1_4158_96AE_E70CF0ED9DCE#272273, COL_A755B8E4_00B9_4ACC_89D8_A49641AE5BF6#272266 AS COL_A755B8E4_00B9_4ACC_89D8_A49641AE5BF6#272274]