== Physical Plan ==
Execute CreateViewCommand (1)
+- CreateViewCommand (2)
+- Project (57)
+- Project (56)
+- Project (55)
+- Filter (54)
+- Project (53)
+- Project (52)
+- Project (51)
+- Project (50)
+- Join (49)
:- Project (38)
: +- Project (37)
: +- Project (36)
: +- SubqueryAlias (35)
: +- View (34)
: +- Project (33)
: +- Project (32)
: +- Project (31)
: +- Project (30)
: +- Union (29)
: :- Project (10)
: : +- Project (9)
: : +- Project (8)
: : +- Project (7)
: : +- Project (6)
: : +- Project (5)
: : +- Project (4)
: : +- LogicalRelation (3)
: :- Project (19)
: : +- Project (18)
: : +- Project (17)
: : +- Project (16)
: : +- Project (15)
: : +- Project (14)
: : +- Project (13)
: : +- Project (12)
: : +- LogicalRelation (11)
: +- Project (28)
: +- Project (27)
: +- Project (26)
: +- Project (25)
: +- Project (24)
: +- Project (23)
: +- Project (22)
: +- Project (21)
: +- LogicalRelation (20)
+- Project (48)
+- SubqueryAlias (47)
+- View (46)
+- Project (45)
+- Project (44)
+- Project (43)
+- Project (42)
+- Project (41)
+- Project (40)
+- LogicalRelation (39)
(1) Execute CreateViewCommand
Output: []
(2) CreateViewCommand
Arguments: `TARIF_HISTORIQU_345998174`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [Code+Acte#342190, Montant#342191, Ligne+RSF#342192, Date_effet#342193, Date_r%C3%A9vocation#342194, Trigramme#342195, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#342196], false
(4) Project
Arguments: [Code+Acte#342190 AS Code Acte#342204, Montant#342191, Ligne+RSF#342192, Date_effet#342193, Date_r%C3%A9vocation#342194, Trigramme#342195, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#342196]
(5) Project
Arguments: [Code Acte#342204, Montant#342191 AS Montant#342213, Ligne+RSF#342192, Date_effet#342193, Date_r%C3%A9vocation#342194, Trigramme#342195, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#342196]
(6) Project
Arguments: [Code Acte#342204, Montant#342213, Ligne+RSF#342192 AS Ligne RSF#342221, Date_effet#342193, Date_r%C3%A9vocation#342194, Trigramme#342195, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#342196]
(7) Project
Arguments: [Code Acte#342204, Montant#342213, Ligne RSF#342221, Date_effet#342193 AS Date_effet#342229, Date_r%C3%A9vocation#342194, Trigramme#342195, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#342196]
(8) Project
Arguments: [Code Acte#342204, Montant#342213, Ligne RSF#342221, Date_effet#342229, Date_r%C3%A9vocation#342194 AS Date_révocation#342237, Trigramme#342195, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#342196]
(9) Project
Arguments: [Code Acte#342204, Montant#342213, Ligne RSF#342221, Date_effet#342229, Date_révocation#342237, Trigramme#342195 AS Trigramme#342245, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#342196]
(10) Project
Arguments: [Code Acte#342204, Montant#342213, Ligne RSF#342221, Date_effet#342229, Date_révocation#342237, Trigramme#342245, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#342196 AS TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#342253]
(11) LogicalRelation
Arguments: parquet, [Code+Acte#342469, Montant#342470, Ligne+RSF#342471, Date_effet#342472, Date_r%C3%A9vocation#342473, Trigramme#342474, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#342475], false
(12) Project
Arguments: [Code+Acte#342469 AS Code Acte#342483, Montant#342470, Ligne+RSF#342471, Date_effet#342472, Date_r%C3%A9vocation#342473, Trigramme#342474, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#342475]
(13) Project
Arguments: [Code Acte#342483, Montant#342470 AS Montant#342492, Ligne+RSF#342471, Date_effet#342472, Date_r%C3%A9vocation#342473, Trigramme#342474, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#342475]
(14) Project
Arguments: [Code Acte#342483, Montant#342492, Ligne+RSF#342471 AS Ligne RSF#342552, Date_effet#342472, Date_r%C3%A9vocation#342473, Trigramme#342474, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#342475]
(15) Project
Arguments: [Code Acte#342483, Montant#342492, Ligne RSF#342552, Date_effet#342472 AS Date_effet#342561, Date_r%C3%A9vocation#342473, Trigramme#342474, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#342475]
(16) Project
Arguments: [Code Acte#342483, Montant#342492, Ligne RSF#342552, Date_effet#342561, Date_r%C3%A9vocation#342473 AS Date_révocation#342569, Trigramme#342474, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#342475]
(17) Project
Arguments: [Code Acte#342483, Montant#342492, Ligne RSF#342552, Date_effet#342561, Date_révocation#342569, Trigramme#342474 AS Trigramme#342577, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#342475]
(18) Project
Arguments: [Code Acte#342483, Montant#342492, Ligne RSF#342552, Date_effet#342561, Date_révocation#342569, Trigramme#342577, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#342475 AS TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#342585]
(19) Project
Arguments: [Code Acte#342483, Montant#342492, Ligne RSF#342552, Date_effet#342561, Date_révocation#342569, Trigramme#342577, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#342585]
(20) LogicalRelation
Arguments: parquet, [Code+Acte#342654, Montant#342655, Ligne+RSF#342656, Date_effet#342657, Date_r%C3%A9vocation#342658, Trigramme#342659, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#342660], false
(21) Project
Arguments: [Code+Acte#342654 AS Code Acte#342668, Montant#342655, Ligne+RSF#342656, Date_effet#342657, Date_r%C3%A9vocation#342658, Trigramme#342659, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#342660]
(22) Project
Arguments: [Code Acte#342668, Montant#342655 AS Montant#342677, Ligne+RSF#342656, Date_effet#342657, Date_r%C3%A9vocation#342658, Trigramme#342659, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#342660]
(23) Project
Arguments: [Code Acte#342668, Montant#342677, Ligne+RSF#342656 AS Ligne RSF#342685, Date_effet#342657, Date_r%C3%A9vocation#342658, Trigramme#342659, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#342660]
(24) Project
Arguments: [Code Acte#342668, Montant#342677, Ligne RSF#342685, Date_effet#342657 AS Date_effet#342693, Date_r%C3%A9vocation#342658, Trigramme#342659, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#342660]
(25) Project
Arguments: [Code Acte#342668, Montant#342677, Ligne RSF#342685, Date_effet#342693, Date_r%C3%A9vocation#342658 AS Date_révocation#342701, Trigramme#342659, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#342660]
(26) Project
Arguments: [Code Acte#342668, Montant#342677, Ligne RSF#342685, Date_effet#342693, Date_révocation#342701, Trigramme#342659 AS Trigramme#342709, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#342660]
(27) Project
Arguments: [Code Acte#342668, Montant#342677, Ligne RSF#342685, Date_effet#342693, Date_révocation#342701, Trigramme#342709, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#342660 AS TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#342717]
(28) Project
Arguments: [Code Acte#342668, Montant#342677, Ligne RSF#342685, Date_effet#342693, Date_révocation#342701, Trigramme#342709, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#342717]
(29) Union
Arguments: false, false
(30) Project
Arguments: [Code Acte#342204 AS Code Acte#342732, Montant#342213 AS Montant#342733, Ligne RSF#342221 AS Ligne RSF#342734, Date_effet#342229 AS Date_effet#342735, Date_révocation#342237 AS Date_révocation#342736, Trigramme#342245 AS Trigramme#342737, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#342253 AS TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#342738]
(31) Project
Arguments: [Code Acte#342732, Montant#342733, Ligne RSF#342734, Date_effet#342735, Date_révocation#342736, Trigramme#342737, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#342738]
(32) Project
Arguments: [Code Acte#342732 AS CODE_ACTE_345934#342753, Date_effet#342735 AS DATE_EFFET_345937#342754, Date_révocation#342736 AS DATE_REVOCATION_345938#342755, Ligne RSF#342734 AS LIGNE_RSF_345936#342756, Montant#342733 AS MONTANT_345935#342757, Trigramme#342737 AS TRIGRAMME_345939#342758]
(33) Project
Arguments: [CODE_ACTE_345934#342753, DATE_EFFET_345937#342754, DATE_REVOCATION_345938#342755, LIGNE_RSF_345936#342756, MONTANT_345935#342757, TRIGRAMME_345939#342758]
(34) View
Arguments: `TARIF_FORFAIT_345933174`, true
(35) SubqueryAlias
Arguments: TARIF_FORFAIT_345933174
(36) Project
Arguments: [CODE_ACTE_345934#342753 AS TARIF_FORFAIT_345933_CODE_ACTE_345934#342935, DATE_EFFET_345937#342754 AS TARIF_FORFAIT_345933_DATE_EFFET_345937#342936, DATE_REVOCATION_345938#342755 AS TARIF_FORFAIT_345933_DATE_REVOCATION_345938#342937, LIGNE_RSF_345936#342756 AS TARIF_FORFAIT_345933_LIGNE_RSF_345936#342938, MONTANT_345935#342757 AS TARIF_FORFAIT_345933_MONTANT_345935#342939, TRIGRAMME_345939#342758 AS TARIF_FORFAIT_345933_TRIGRAMME_345939#342940]
(37) Project
Arguments: [cast(TARIF_FORFAIT_345933_CODE_ACTE_345934#342935 as string) AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#342953, cast(TARIF_FORFAIT_345933_MONTANT_345935#342939 as string) AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#342954, cast(TARIF_FORFAIT_345933_LIGNE_RSF_345936#342938 as string) AS COL_C519DD82_4508_4154_B389_405B16413D09#342955, cast(TARIF_FORFAIT_345933_DATE_EFFET_345937#342936 as string) AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#342956, cast(TARIF_FORFAIT_345933_DATE_REVOCATION_345938#342937 as string) AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#342957, cast(TARIF_FORFAIT_345933_TRIGRAMME_345939#342940 as string) AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#342958]
(38) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#342953 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#342965, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#342954 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#342966, COL_C519DD82_4508_4154_B389_405B16413D09#342955 AS COL_C519DD82_4508_4154_B389_405B16413D09#342967, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#342956 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#342968, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#342957 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#342969, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#342958 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#342970]
(39) LogicalRelation
Arguments: csv, [finess_dataapps#342843, region-tarif#342844, login-user#342845], false
(40) Project
Arguments: [finess_dataapps#342843, region-tarif#342844, login-user#342845, cast(null as string) AS login_user#342849]
(41) Project
Arguments: [finess_dataapps#342843, region-tarif#342844, login_user#342849]
(42) Project
Arguments: [finess_dataapps#342843 AS finess_dataapps#342913, region-tarif#342844 AS region-tarif#342914, login_user#342849 AS login_user#342915]
(43) Project
Arguments: [finess_dataapps#342913, region-tarif#342914, login_user#342915]
(44) Project
Arguments: [finess_dataapps#342913 AS INFO_ETAB_FINES_345944#342923, region-tarif#342914 AS REGION_TARIF_345945#342924]
(45) Project
Arguments: [INFO_ETAB_FINES_345944#342923, REGION_TARIF_345945#342924]
(46) View
Arguments: `INFO_DATAAPPS_345943174`, true
(47) SubqueryAlias
Arguments: INFO_DATAAPPS_345943174
(48) Project
Arguments: [INFO_ETAB_FINES_345944#342923 AS INFO_DATAAPPS_345943_INFO_ETAB_FINES_345944#342979, REGION_TARIF_345945#342924 AS INFO_DATAAPPS_345943_REGION_TARIF_345945#342980]
(49) Join
Arguments: Cross
(50) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#342965, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#342966, COL_C519DD82_4508_4154_B389_405B16413D09#342967, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#342968, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#342969, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#342970, INFO_DATAAPPS_345943_REGION_TARIF_345945#342980 AS COL_ABDEDC13_3840_48F7_A962_159F725BF772#342991]
(51) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#342965, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#342966, COL_C519DD82_4508_4154_B389_405B16413D09#342967, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#342968, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#342969, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#342970, COL_ABDEDC13_3840_48F7_A962_159F725BF772#342991, str_replace(COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#342966, cast(. as string), cast(, as string)) AS COL_6AE58BB6_C7FC_4F54_9502_66AD374805CD#342999]
(52) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#342965 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#343008, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#342966 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#343009, COL_C519DD82_4508_4154_B389_405B16413D09#342967 AS COL_C519DD82_4508_4154_B389_405B16413D09#343010, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#342968 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#343011, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#342969 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#343012, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#342970 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#343013, COL_ABDEDC13_3840_48F7_A962_159F725BF772#342991 AS COL_ABDEDC13_3840_48F7_A962_159F725BF772#343014, COL_6AE58BB6_C7FC_4F54_9502_66AD374805CD#342999 AS COL_6AE58BB6_C7FC_4F54_9502_66AD374805CD#343015]
(53) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#343008 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#343024, COL_6AE58BB6_C7FC_4F54_9502_66AD374805CD#343015 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#343025, COL_C519DD82_4508_4154_B389_405B16413D09#343010 AS COL_C519DD82_4508_4154_B389_405B16413D09#343026, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#343011 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#343027, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#343012 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#343028, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#343013 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#343029, COL_ABDEDC13_3840_48F7_A962_159F725BF772#343014 AS COL_ABDEDC13_3840_48F7_A962_159F725BF772#343030, COL_6AE58BB6_C7FC_4F54_9502_66AD374805CD#343015 AS COL_6AE58BB6_C7FC_4F54_9502_66AD374805CD#343031]
(54) Filter
Arguments: (COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#343029 <=> COL_ABDEDC13_3840_48F7_A962_159F725BF772#343030)
(55) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#343024 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#343040, str_to_dec(COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#343025, ##,##) AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#343041, str_to_datez(COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#343027, dd/MM/yyyy, Europe/Paris, fr_FR) AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#343042, str_to_datez(COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#343028, dd/MM/yyyy, Europe/Paris, fr_FR) AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#343043, COL_C519DD82_4508_4154_B389_405B16413D09#343026 AS COL_C519DD82_4508_4154_B389_405B16413D09#343044, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#343029 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#343045, COL_ABDEDC13_3840_48F7_A962_159F725BF772#343030 AS COL_ABDEDC13_3840_48F7_A962_159F725BF772#343046]
(56) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#343040 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#343054, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#343041 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#343055, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#343042 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#343056, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#343043 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#343057, COL_C519DD82_4508_4154_B389_405B16413D09#343044 AS COL_C519DD82_4508_4154_B389_405B16413D09#343058, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#343045 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#343059, COL_ABDEDC13_3840_48F7_A962_159F725BF772#343046 AS COL_ABDEDC13_3840_48F7_A962_159F725BF772#343060]
(57) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#343054 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#343068, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#343055 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#343069, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#343056 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#343070, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#343057 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#343071, COL_C519DD82_4508_4154_B389_405B16413D09#343058 AS COL_C519DD82_4508_4154_B389_405B16413D09#343072, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#343059 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#343073, COL_ABDEDC13_3840_48F7_A962_159F725BF772#343060 AS COL_ABDEDC13_3840_48F7_A962_159F725BF772#343074]