== 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_345995174`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [_c0#316639], false
(4) Project
Arguments: [_c0#316639 AS COLL0#316641]
(5) Project
Arguments: [COLL0#316641 AS COLL0#316644]
(6) Project
Arguments: [COLL0#316644]
(7) Project
Arguments: [cast(str_create(cast( as string)) as string) AS ETABLISSEMENT_345942#316649, COLL0#316644 AS _C0_345941#316648]
(8) Project
Arguments: [ETABLISSEMENT_345942#316649, _C0_345941#316648]
(9) View
Arguments: `RSF_345940174`, true
(10) SubqueryAlias
Arguments: RSF_345940174
(11) Project
Arguments: [ETABLISSEMENT_345942#316649 AS RSF_345940_ETABLISSEMENT_345942#316656, _C0_345941#316648 AS RSF_345940__C0_345941#316657]
(12) Project
Arguments: [cast(RSF_345940__C0_345941#316657 as string) AS COL_0B816CAF_81A1_4E69_B9E3_E6597EABCC0D#316662, cast(RSF_345940_ETABLISSEMENT_345942#316656 as string) AS COL_80933A43_413D_4028_A7DB_94D6A9FA84C1#316663]
(13) Project
Arguments: [COL_0B816CAF_81A1_4E69_B9E3_E6597EABCC0D#316662 AS COL_0B816CAF_81A1_4E69_B9E3_E6597EABCC0D#316666, COL_80933A43_413D_4028_A7DB_94D6A9FA84C1#316663 AS COL_80933A43_413D_4028_A7DB_94D6A9FA84C1#316667]
(14) LocalLimit
Arguments: 3
(15) GlobalLimit
Arguments: 3
(16) Filter
Arguments: true
(17) Project
Arguments: [COL_0B816CAF_81A1_4E69_B9E3_E6597EABCC0D#316666, COL_80933A43_413D_4028_A7DB_94D6A9FA84C1#316667, 1 AS CONST#316670]
(18) Project
Arguments: [COL_0B816CAF_81A1_4E69_B9E3_E6597EABCC0D#316666, COL_80933A43_413D_4028_A7DB_94D6A9FA84C1#316667, CONST#316670]
(19) Window
Arguments: [row_number() windowspecdefinition(1, CONST#316670 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_466B8114_A534_4700_99C5_61D90974826A#316675], [1], [CONST#316670 DESC NULLS LAST]
(20) Project
Arguments: [COL_0B816CAF_81A1_4E69_B9E3_E6597EABCC0D#316666, COL_80933A43_413D_4028_A7DB_94D6A9FA84C1#316667, CONST#316670, COL_466B8114_A534_4700_99C5_61D90974826A#316675, COL_466B8114_A534_4700_99C5_61D90974826A#316675]
(21) Project
Arguments: [COL_0B816CAF_81A1_4E69_B9E3_E6597EABCC0D#316666, COL_80933A43_413D_4028_A7DB_94D6A9FA84C1#316667, CONST#316670, COL_466B8114_A534_4700_99C5_61D90974826A#316675]
(22) Project
Arguments: [COL_0B816CAF_81A1_4E69_B9E3_E6597EABCC0D#316666, COL_80933A43_413D_4028_A7DB_94D6A9FA84C1#316667, COL_466B8114_A534_4700_99C5_61D90974826A#316675]
(23) Project
Arguments: [COL_0B816CAF_81A1_4E69_B9E3_E6597EABCC0D#316666 AS COL_0B816CAF_81A1_4E69_B9E3_E6597EABCC0D#316683, COL_80933A43_413D_4028_A7DB_94D6A9FA84C1#316667 AS COL_80933A43_413D_4028_A7DB_94D6A9FA84C1#316684, COL_466B8114_A534_4700_99C5_61D90974826A#316675 AS COL_466B8114_A534_4700_99C5_61D90974826A#316685]
(24) Project
Arguments: [COL_0B816CAF_81A1_4E69_B9E3_E6597EABCC0D#316683 AS COL_0B816CAF_81A1_4E69_B9E3_E6597EABCC0D#316689, COL_80933A43_413D_4028_A7DB_94D6A9FA84C1#316684 AS COL_80933A43_413D_4028_A7DB_94D6A9FA84C1#316690, COL_466B8114_A534_4700_99C5_61D90974826A#316685 AS COL_466B8114_A534_4700_99C5_61D90974826A#316691]
(25) Project
Arguments: [COL_0B816CAF_81A1_4E69_B9E3_E6597EABCC0D#316689, COL_80933A43_413D_4028_A7DB_94D6A9FA84C1#316690, COL_466B8114_A534_4700_99C5_61D90974826A#316691, str_extract(COL_0B816CAF_81A1_4E69_B9E3_E6597EABCC0D#316689, cast(LEFT as string), cast(1 as bigint)) AS COL_05407152_049D_46F2_8E36_4129E0BC5272#316695]
(26) Project
Arguments: [COL_0B816CAF_81A1_4E69_B9E3_E6597EABCC0D#316689, COL_80933A43_413D_4028_A7DB_94D6A9FA84C1#316690, COL_466B8114_A534_4700_99C5_61D90974826A#316691, COL_05407152_049D_46F2_8E36_4129E0BC5272#316695, str_extract_middle(COL_0B816CAF_81A1_4E69_B9E3_E6597EABCC0D#316689, cast(2 as bigint), cast(9 as bigint)) AS COL_CD1100A9_9106_47C2_93C6_E2EF19A395A4#316700]
(27) Filter
Arguments: (((COL_466B8114_A534_4700_99C5_61D90974826A#316691 <=> cast(1 as int)) AND (COL_05407152_049D_46F2_8E36_4129E0BC5272#316695 <=> cast(A as string))) OR CASE WHEN isnull((COL_466B8114_A534_4700_99C5_61D90974826A#316691 > cast(1 as int))) THEN false ELSE (COL_466B8114_A534_4700_99C5_61D90974826A#316691 > cast(1 as int)) END)
(28) Project
Arguments: [COL_0B816CAF_81A1_4E69_B9E3_E6597EABCC0D#316689 AS COL_0B816CAF_81A1_4E69_B9E3_E6597EABCC0D#316706, COL_80933A43_413D_4028_A7DB_94D6A9FA84C1#316690 AS COL_80933A43_413D_4028_A7DB_94D6A9FA84C1#316707, COL_466B8114_A534_4700_99C5_61D90974826A#316691 AS COL_466B8114_A534_4700_99C5_61D90974826A#316708, COL_05407152_049D_46F2_8E36_4129E0BC5272#316695 AS COL_05407152_049D_46F2_8E36_4129E0BC5272#316709, COL_CD1100A9_9106_47C2_93C6_E2EF19A395A4#316700 AS COL_CD1100A9_9106_47C2_93C6_E2EF19A395A4#316710]
(29) Project
Arguments: [COL_0B816CAF_81A1_4E69_B9E3_E6597EABCC0D#316706 AS COL_0B816CAF_81A1_4E69_B9E3_E6597EABCC0D#316716, COL_80933A43_413D_4028_A7DB_94D6A9FA84C1#316707 AS COL_80933A43_413D_4028_A7DB_94D6A9FA84C1#316717, COL_466B8114_A534_4700_99C5_61D90974826A#316708 AS COL_466B8114_A534_4700_99C5_61D90974826A#316718, COL_05407152_049D_46F2_8E36_4129E0BC5272#316709 AS COL_05407152_049D_46F2_8E36_4129E0BC5272#316719, COL_CD1100A9_9106_47C2_93C6_E2EF19A395A4#316710 AS COL_CD1100A9_9106_47C2_93C6_E2EF19A395A4#316720]
(30) Filter
Arguments: true
(31) Aggregate
Arguments: [COL_CD1100A9_9106_47C2_93C6_E2EF19A395A4#316720], [COL_CD1100A9_9106_47C2_93C6_E2EF19A395A4#316720 AS COL_467B8EF8_7CFB_46F2_8CD4_3805AEA1E17D#316726, 1 AS NULL_1#316732]
(32) Project
Arguments: [COL_467B8EF8_7CFB_46F2_8CD4_3805AEA1E17D#316726]
(33) Project
Arguments: [COL_467B8EF8_7CFB_46F2_8CD4_3805AEA1E17D#316726 AS COL_467B8EF8_7CFB_46F2_8CD4_3805AEA1E17D#316736]
(34) Project
Arguments: [COL_467B8EF8_7CFB_46F2_8CD4_3805AEA1E17D#316736 AS COL_467B8EF8_7CFB_46F2_8CD4_3805AEA1E17D#316738]
(35) LogicalRelation
Arguments: csv, [finess_dataapps#316574, region-tarif#316575, login-user#316576], false
(36) Project
Arguments: [finess_dataapps#316574, region-tarif#316575, login-user#316576, cast(null as string) AS login_user#316580]
(37) Project
Arguments: [finess_dataapps#316574, region-tarif#316575, login_user#316580]
(38) Project
Arguments: [finess_dataapps#316574 AS finess_dataapps#316589, region-tarif#316575 AS region-tarif#316590, login_user#316580 AS login_user#316591]
(39) Project
Arguments: [finess_dataapps#316589, region-tarif#316590, login_user#316591]
(40) Project
Arguments: [finess_dataapps#316589 AS INFO_ETAB_FINES_345944#316598, region-tarif#316590 AS REGION_TARIF_345945#316599]
(41) Project
Arguments: [INFO_ETAB_FINES_345944#316598, REGION_TARIF_345945#316599]
(42) View
Arguments: `INFO_DATAAPPS_345943174`, true
(43) SubqueryAlias
Arguments: INFO_DATAAPPS_345943174
(44) Project
Arguments: [INFO_ETAB_FINES_345944#316598 AS INFO_DATAAPPS_345943_INFO_ETAB_FINES_345944#316606, REGION_TARIF_345945#316599 AS INFO_DATAAPPS_345943_REGION_TARIF_345945#316607]
(45) Project
Arguments: [cast(INFO_DATAAPPS_345943_INFO_ETAB_FINES_345944#316606 as string) AS COL_D78E5A4B_5147_439E_B045_CC77D9B56ECA#316611]
(46) Project
Arguments: [COL_D78E5A4B_5147_439E_B045_CC77D9B56ECA#316611 AS COL_D78E5A4B_5147_439E_B045_CC77D9B56ECA#316613]
(47) Project
Arguments: [COL_D78E5A4B_5147_439E_B045_CC77D9B56ECA#316613, str_create(COL_D78E5A4B_5147_439E_B045_CC77D9B56ECA#316613) AS COL_A9C3D939_A6C7_4DC2_8CC2_91076A4A2CFC#316615]
(48) Project
Arguments: [COL_A9C3D939_A6C7_4DC2_8CC2_91076A4A2CFC#316615 AS COL_A9C3D939_A6C7_4DC2_8CC2_91076A4A2CFC#316618, COL_D78E5A4B_5147_439E_B045_CC77D9B56ECA#316613 AS COL_D78E5A4B_5147_439E_B045_CC77D9B56ECA#316619]
(49) View
Arguments: `INFO_DATAAPPS_346034174`, true
(50) SubqueryAlias
Arguments: INFO_DATAAPPS_346034174
(51) Project
Arguments: [COL_A9C3D939_A6C7_4DC2_8CC2_91076A4A2CFC#316618 AS INFO_DATAAPPS_346034_COL_A9C3D939_A6C7_4DC2_8CC2_91076A4A2CFC#316742, COL_D78E5A4B_5147_439E_B045_CC77D9B56ECA#316619 AS INFO_DATAAPPS_346034_COL_D78E5A4B_5147_439E_B045_CC77D9B56ECA#316743]
(52) Join
Arguments: Cross
(53) Project
Arguments: [COL_467B8EF8_7CFB_46F2_8CD4_3805AEA1E17D#316738, INFO_DATAAPPS_346034_COL_A9C3D939_A6C7_4DC2_8CC2_91076A4A2CFC#316742 AS COL_A755B8E4_00B9_4ACC_89D8_A49641AE5BF6#316749]
(54) Project
Arguments: [COL_467B8EF8_7CFB_46F2_8CD4_3805AEA1E17D#316738 AS COL_467B8EF8_7CFB_46F2_8CD4_3805AEA1E17D#316752, COL_A755B8E4_00B9_4ACC_89D8_A49641AE5BF6#316749 AS COL_A755B8E4_00B9_4ACC_89D8_A49641AE5BF6#316753]
(55) Project
Arguments: [COL_467B8EF8_7CFB_46F2_8CD4_3805AEA1E17D#316752 AS COL_467B8EF8_7CFB_46F2_8CD4_3805AEA1E17D#316756, COL_A755B8E4_00B9_4ACC_89D8_A49641AE5BF6#316753 AS COL_A755B8E4_00B9_4ACC_89D8_A49641AE5BF6#316757]
(56) Project
Arguments: [COL_467B8EF8_7CFB_46F2_8CD4_3805AEA1E17D#316756, COL_A755B8E4_00B9_4ACC_89D8_A49641AE5BF6#316757, str_if_with_rule((COL_A755B8E4_00B9_4ACC_89D8_A49641AE5BF6#316757 <=> COL_467B8EF8_7CFB_46F2_8CD4_3805AEA1E17D#316756), 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#316760]
(57) Filter
Arguments: isnotnull(COL_42952156_A6E1_4158_96AE_E70CF0ED9DCE#316760)
(58) Project
Arguments: [COL_42952156_A6E1_4158_96AE_E70CF0ED9DCE#316760 AS COL_42952156_A6E1_4158_96AE_E70CF0ED9DCE#316764, COL_A755B8E4_00B9_4ACC_89D8_A49641AE5BF6#316757 AS COL_A755B8E4_00B9_4ACC_89D8_A49641AE5BF6#316765]