== 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_345998170`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [Code+Acte#283821, Montant#283822, Ligne+RSF#283823, Date_effet#283824, Date_r%C3%A9vocation#283825, Trigramme#283826, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#283827], false
(4) Project
Arguments: [Code+Acte#283821 AS Code Acte#283835, Montant#283822, Ligne+RSF#283823, Date_effet#283824, Date_r%C3%A9vocation#283825, Trigramme#283826, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#283827]
(5) Project
Arguments: [Code Acte#283835, Montant#283822 AS Montant#283844, Ligne+RSF#283823, Date_effet#283824, Date_r%C3%A9vocation#283825, Trigramme#283826, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#283827]
(6) Project
Arguments: [Code Acte#283835, Montant#283844, Ligne+RSF#283823 AS Ligne RSF#283852, Date_effet#283824, Date_r%C3%A9vocation#283825, Trigramme#283826, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#283827]
(7) Project
Arguments: [Code Acte#283835, Montant#283844, Ligne RSF#283852, Date_effet#283824 AS Date_effet#283860, Date_r%C3%A9vocation#283825, Trigramme#283826, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#283827]
(8) Project
Arguments: [Code Acte#283835, Montant#283844, Ligne RSF#283852, Date_effet#283860, Date_r%C3%A9vocation#283825 AS Date_révocation#283868, Trigramme#283826, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#283827]
(9) Project
Arguments: [Code Acte#283835, Montant#283844, Ligne RSF#283852, Date_effet#283860, Date_révocation#283868, Trigramme#283826 AS Trigramme#283876, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#283827]
(10) Project
Arguments: [Code Acte#283835, Montant#283844, Ligne RSF#283852, Date_effet#283860, Date_révocation#283868, Trigramme#283876, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#283827 AS TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#283884]
(11) LogicalRelation
Arguments: parquet, [Code+Acte#283892, Montant#283893, Ligne+RSF#283894, Date_effet#283895, Date_r%C3%A9vocation#283896, Trigramme#283897, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#283898], false
(12) Project
Arguments: [Code+Acte#283892 AS Code Acte#283906, Montant#283893, Ligne+RSF#283894, Date_effet#283895, Date_r%C3%A9vocation#283896, Trigramme#283897, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#283898]
(13) Project
Arguments: [Code Acte#283906, Montant#283893 AS Montant#283915, Ligne+RSF#283894, Date_effet#283895, Date_r%C3%A9vocation#283896, Trigramme#283897, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#283898]
(14) Project
Arguments: [Code Acte#283906, Montant#283915, Ligne+RSF#283894 AS Ligne RSF#283923, Date_effet#283895, Date_r%C3%A9vocation#283896, Trigramme#283897, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#283898]
(15) Project
Arguments: [Code Acte#283906, Montant#283915, Ligne RSF#283923, Date_effet#283895 AS Date_effet#283931, Date_r%C3%A9vocation#283896, Trigramme#283897, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#283898]
(16) Project
Arguments: [Code Acte#283906, Montant#283915, Ligne RSF#283923, Date_effet#283931, Date_r%C3%A9vocation#283896 AS Date_révocation#283939, Trigramme#283897, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#283898]
(17) Project
Arguments: [Code Acte#283906, Montant#283915, Ligne RSF#283923, Date_effet#283931, Date_révocation#283939, Trigramme#283897 AS Trigramme#283947, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#283898]
(18) Project
Arguments: [Code Acte#283906, Montant#283915, Ligne RSF#283923, Date_effet#283931, Date_révocation#283939, Trigramme#283947, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#283898 AS TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#283955]
(19) Project
Arguments: [Code Acte#283906, Montant#283915, Ligne RSF#283923, Date_effet#283931, Date_révocation#283939, Trigramme#283947, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#283955]
(20) LogicalRelation
Arguments: parquet, [Code+Acte#283970, Montant#283971, Ligne+RSF#283972, Date_effet#283973, Date_r%C3%A9vocation#283974, Trigramme#283975, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#283976], false
(21) Project
Arguments: [Code+Acte#283970 AS Code Acte#283984, Montant#283971, Ligne+RSF#283972, Date_effet#283973, Date_r%C3%A9vocation#283974, Trigramme#283975, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#283976]
(22) Project
Arguments: [Code Acte#283984, Montant#283971 AS Montant#283993, Ligne+RSF#283972, Date_effet#283973, Date_r%C3%A9vocation#283974, Trigramme#283975, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#283976]
(23) Project
Arguments: [Code Acte#283984, Montant#283993, Ligne+RSF#283972 AS Ligne RSF#284001, Date_effet#283973, Date_r%C3%A9vocation#283974, Trigramme#283975, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#283976]
(24) Project
Arguments: [Code Acte#283984, Montant#283993, Ligne RSF#284001, Date_effet#283973 AS Date_effet#284009, Date_r%C3%A9vocation#283974, Trigramme#283975, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#283976]
(25) Project
Arguments: [Code Acte#283984, Montant#283993, Ligne RSF#284001, Date_effet#284009, Date_r%C3%A9vocation#283974 AS Date_révocation#284017, Trigramme#283975, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#283976]
(26) Project
Arguments: [Code Acte#283984, Montant#283993, Ligne RSF#284001, Date_effet#284009, Date_révocation#284017, Trigramme#283975 AS Trigramme#284025, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#283976]
(27) Project
Arguments: [Code Acte#283984, Montant#283993, Ligne RSF#284001, Date_effet#284009, Date_révocation#284017, Trigramme#284025, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#283976 AS TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#284033]
(28) Project
Arguments: [Code Acte#283984, Montant#283993, Ligne RSF#284001, Date_effet#284009, Date_révocation#284017, Trigramme#284025, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#284033]
(29) Union
Arguments: false, false
(30) Project
Arguments: [Code Acte#283835 AS Code Acte#284048, Montant#283844 AS Montant#284049, Ligne RSF#283852 AS Ligne RSF#284050, Date_effet#283860 AS Date_effet#284051, Date_révocation#283868 AS Date_révocation#284052, Trigramme#283876 AS Trigramme#284053, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#283884 AS TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#284054]
(31) Project
Arguments: [Code Acte#284048, Montant#284049, Ligne RSF#284050, Date_effet#284051, Date_révocation#284052, Trigramme#284053, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#284054]
(32) Project
Arguments: [Code Acte#284048 AS CODE_ACTE_345934#284069, Date_effet#284051 AS DATE_EFFET_345937#284070, Date_révocation#284052 AS DATE_REVOCATION_345938#284071, Ligne RSF#284050 AS LIGNE_RSF_345936#284072, Montant#284049 AS MONTANT_345935#284073, Trigramme#284053 AS TRIGRAMME_345939#284074]
(33) Project
Arguments: [CODE_ACTE_345934#284069, DATE_EFFET_345937#284070, DATE_REVOCATION_345938#284071, LIGNE_RSF_345936#284072, MONTANT_345935#284073, TRIGRAMME_345939#284074]
(34) View
Arguments: `TARIF_FORFAIT_345933170`, true
(35) SubqueryAlias
Arguments: TARIF_FORFAIT_345933170
(36) Project
Arguments: [CODE_ACTE_345934#284069 AS TARIF_FORFAIT_345933_CODE_ACTE_345934#284140, DATE_EFFET_345937#284070 AS TARIF_FORFAIT_345933_DATE_EFFET_345937#284141, DATE_REVOCATION_345938#284071 AS TARIF_FORFAIT_345933_DATE_REVOCATION_345938#284142, LIGNE_RSF_345936#284072 AS TARIF_FORFAIT_345933_LIGNE_RSF_345936#284143, MONTANT_345935#284073 AS TARIF_FORFAIT_345933_MONTANT_345935#284144, TRIGRAMME_345939#284074 AS TARIF_FORFAIT_345933_TRIGRAMME_345939#284145]
(37) Project
Arguments: [cast(TARIF_FORFAIT_345933_CODE_ACTE_345934#284140 as string) AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#284158, cast(TARIF_FORFAIT_345933_MONTANT_345935#284144 as string) AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#284159, cast(TARIF_FORFAIT_345933_LIGNE_RSF_345936#284143 as string) AS COL_C519DD82_4508_4154_B389_405B16413D09#284160, cast(TARIF_FORFAIT_345933_DATE_EFFET_345937#284141 as string) AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#284161, cast(TARIF_FORFAIT_345933_DATE_REVOCATION_345938#284142 as string) AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#284162, cast(TARIF_FORFAIT_345933_TRIGRAMME_345939#284145 as string) AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#284163]
(38) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#284158 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#284170, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#284159 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#284171, COL_C519DD82_4508_4154_B389_405B16413D09#284160 AS COL_C519DD82_4508_4154_B389_405B16413D09#284172, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#284161 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#284173, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#284162 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#284174, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#284163 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#284175]
(39) LogicalRelation
Arguments: csv, [finess_dataapps#284104, region-tarif#284105, login-user#284106], false
(40) Project
Arguments: [finess_dataapps#284104, region-tarif#284105, login-user#284106, cast(null as string) AS login_user#284110]
(41) Project
Arguments: [finess_dataapps#284104, region-tarif#284105, login_user#284110]
(42) Project
Arguments: [finess_dataapps#284104 AS finess_dataapps#284119, region-tarif#284105 AS region-tarif#284120, login_user#284110 AS login_user#284121]
(43) Project
Arguments: [finess_dataapps#284119, region-tarif#284120, login_user#284121]
(44) Project
Arguments: [finess_dataapps#284119 AS INFO_ETAB_FINES_345944#284128, region-tarif#284120 AS REGION_TARIF_345945#284129]
(45) Project
Arguments: [INFO_ETAB_FINES_345944#284128, REGION_TARIF_345945#284129]
(46) View
Arguments: `INFO_DATAAPPS_345943170`, true
(47) SubqueryAlias
Arguments: INFO_DATAAPPS_345943170
(48) Project
Arguments: [INFO_ETAB_FINES_345944#284128 AS INFO_DATAAPPS_345943_INFO_ETAB_FINES_345944#284184, REGION_TARIF_345945#284129 AS INFO_DATAAPPS_345943_REGION_TARIF_345945#284185]
(49) Join
Arguments: Cross
(50) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#284170, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#284171, COL_C519DD82_4508_4154_B389_405B16413D09#284172, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#284173, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#284174, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#284175, INFO_DATAAPPS_345943_REGION_TARIF_345945#284185 AS COL_ABDEDC13_3840_48F7_A962_159F725BF772#284196]
(51) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#284170, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#284171, COL_C519DD82_4508_4154_B389_405B16413D09#284172, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#284173, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#284174, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#284175, COL_ABDEDC13_3840_48F7_A962_159F725BF772#284196, str_replace(COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#284171, cast(. as string), cast(, as string)) AS COL_6AE58BB6_C7FC_4F54_9502_66AD374805CD#284204]
(52) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#284170 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#284213, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#284171 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#284214, COL_C519DD82_4508_4154_B389_405B16413D09#284172 AS COL_C519DD82_4508_4154_B389_405B16413D09#284215, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#284173 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#284216, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#284174 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#284217, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#284175 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#284218, COL_ABDEDC13_3840_48F7_A962_159F725BF772#284196 AS COL_ABDEDC13_3840_48F7_A962_159F725BF772#284219, COL_6AE58BB6_C7FC_4F54_9502_66AD374805CD#284204 AS COL_6AE58BB6_C7FC_4F54_9502_66AD374805CD#284220]
(53) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#284213 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#284229, COL_6AE58BB6_C7FC_4F54_9502_66AD374805CD#284220 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#284230, COL_C519DD82_4508_4154_B389_405B16413D09#284215 AS COL_C519DD82_4508_4154_B389_405B16413D09#284231, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#284216 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#284232, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#284217 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#284233, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#284218 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#284234, COL_ABDEDC13_3840_48F7_A962_159F725BF772#284219 AS COL_ABDEDC13_3840_48F7_A962_159F725BF772#284235, COL_6AE58BB6_C7FC_4F54_9502_66AD374805CD#284220 AS COL_6AE58BB6_C7FC_4F54_9502_66AD374805CD#284236]
(54) Filter
Arguments: (COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#284234 <=> COL_ABDEDC13_3840_48F7_A962_159F725BF772#284235)
(55) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#284229 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#284245, str_to_dec(COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#284230, ##,##) AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#284246, str_to_datez(COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#284232, dd/MM/yyyy, Europe/Paris, fr_FR) AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#284247, str_to_datez(COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#284233, dd/MM/yyyy, Europe/Paris, fr_FR) AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#284248, COL_C519DD82_4508_4154_B389_405B16413D09#284231 AS COL_C519DD82_4508_4154_B389_405B16413D09#284249, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#284234 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#284250, COL_ABDEDC13_3840_48F7_A962_159F725BF772#284235 AS COL_ABDEDC13_3840_48F7_A962_159F725BF772#284251]
(56) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#284245 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#284259, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#284246 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#284260, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#284247 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#284261, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#284248 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#284262, COL_C519DD82_4508_4154_B389_405B16413D09#284249 AS COL_C519DD82_4508_4154_B389_405B16413D09#284263, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#284250 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#284264, COL_ABDEDC13_3840_48F7_A962_159F725BF772#284251 AS COL_ABDEDC13_3840_48F7_A962_159F725BF772#284265]
(57) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#284259 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#284273, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#284260 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#284274, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#284261 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#284275, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#284262 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#284276, COL_C519DD82_4508_4154_B389_405B16413D09#284263 AS COL_C519DD82_4508_4154_B389_405B16413D09#284277, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#284264 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#284278, COL_ABDEDC13_3840_48F7_A962_159F725BF772#284265 AS COL_ABDEDC13_3840_48F7_A962_159F725BF772#284279]