== 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_345998172`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [Code+Acte#294696, Montant#294697, Ligne+RSF#294698, Date_effet#294699, Date_r%C3%A9vocation#294700, Trigramme#294701, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#294702], false
(4) Project
Arguments: [Code+Acte#294696 AS Code Acte#294745, Montant#294697, Ligne+RSF#294698, Date_effet#294699, Date_r%C3%A9vocation#294700, Trigramme#294701, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#294702]
(5) Project
Arguments: [Code Acte#294745, Montant#294697 AS Montant#294754, Ligne+RSF#294698, Date_effet#294699, Date_r%C3%A9vocation#294700, Trigramme#294701, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#294702]
(6) Project
Arguments: [Code Acte#294745, Montant#294754, Ligne+RSF#294698 AS Ligne RSF#294762, Date_effet#294699, Date_r%C3%A9vocation#294700, Trigramme#294701, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#294702]
(7) Project
Arguments: [Code Acte#294745, Montant#294754, Ligne RSF#294762, Date_effet#294699 AS Date_effet#294770, Date_r%C3%A9vocation#294700, Trigramme#294701, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#294702]
(8) Project
Arguments: [Code Acte#294745, Montant#294754, Ligne RSF#294762, Date_effet#294770, Date_r%C3%A9vocation#294700 AS Date_révocation#294778, Trigramme#294701, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#294702]
(9) Project
Arguments: [Code Acte#294745, Montant#294754, Ligne RSF#294762, Date_effet#294770, Date_révocation#294778, Trigramme#294701 AS Trigramme#294786, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#294702]
(10) Project
Arguments: [Code Acte#294745, Montant#294754, Ligne RSF#294762, Date_effet#294770, Date_révocation#294778, Trigramme#294786, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#294702 AS TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#294794]
(11) LogicalRelation
Arguments: parquet, [Code+Acte#295205, Montant#295206, Ligne+RSF#295207, Date_effet#295208, Date_r%C3%A9vocation#295209, Trigramme#295210, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#295211], false
(12) Project
Arguments: [Code+Acte#295205 AS Code Acte#295258, Montant#295206, Ligne+RSF#295207, Date_effet#295208, Date_r%C3%A9vocation#295209, Trigramme#295210, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#295211]
(13) Project
Arguments: [Code Acte#295258, Montant#295206 AS Montant#295267, Ligne+RSF#295207, Date_effet#295208, Date_r%C3%A9vocation#295209, Trigramme#295210, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#295211]
(14) Project
Arguments: [Code Acte#295258, Montant#295267, Ligne+RSF#295207 AS Ligne RSF#295275, Date_effet#295208, Date_r%C3%A9vocation#295209, Trigramme#295210, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#295211]
(15) Project
Arguments: [Code Acte#295258, Montant#295267, Ligne RSF#295275, Date_effet#295208 AS Date_effet#295283, Date_r%C3%A9vocation#295209, Trigramme#295210, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#295211]
(16) Project
Arguments: [Code Acte#295258, Montant#295267, Ligne RSF#295275, Date_effet#295283, Date_r%C3%A9vocation#295209 AS Date_révocation#295291, Trigramme#295210, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#295211]
(17) Project
Arguments: [Code Acte#295258, Montant#295267, Ligne RSF#295275, Date_effet#295283, Date_révocation#295291, Trigramme#295210 AS Trigramme#295299, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#295211]
(18) Project
Arguments: [Code Acte#295258, Montant#295267, Ligne RSF#295275, Date_effet#295283, Date_révocation#295291, Trigramme#295299, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#295211 AS TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#295307]
(19) Project
Arguments: [Code Acte#295258, Montant#295267, Ligne RSF#295275, Date_effet#295283, Date_révocation#295291, Trigramme#295299, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#295307]
(20) LogicalRelation
Arguments: parquet, [Code+Acte#295445, Montant#295446, Ligne+RSF#295447, Date_effet#295448, Date_r%C3%A9vocation#295449, Trigramme#295450, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#295451], false
(21) Project
Arguments: [Code+Acte#295445 AS Code Acte#295502, Montant#295446, Ligne+RSF#295447, Date_effet#295448, Date_r%C3%A9vocation#295449, Trigramme#295450, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#295451]
(22) Project
Arguments: [Code Acte#295502, Montant#295446 AS Montant#295511, Ligne+RSF#295447, Date_effet#295448, Date_r%C3%A9vocation#295449, Trigramme#295450, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#295451]
(23) Project
Arguments: [Code Acte#295502, Montant#295511, Ligne+RSF#295447 AS Ligne RSF#295519, Date_effet#295448, Date_r%C3%A9vocation#295449, Trigramme#295450, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#295451]
(24) Project
Arguments: [Code Acte#295502, Montant#295511, Ligne RSF#295519, Date_effet#295448 AS Date_effet#295527, Date_r%C3%A9vocation#295449, Trigramme#295450, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#295451]
(25) Project
Arguments: [Code Acte#295502, Montant#295511, Ligne RSF#295519, Date_effet#295527, Date_r%C3%A9vocation#295449 AS Date_révocation#295535, Trigramme#295450, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#295451]
(26) Project
Arguments: [Code Acte#295502, Montant#295511, Ligne RSF#295519, Date_effet#295527, Date_révocation#295535, Trigramme#295450 AS Trigramme#295543, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#295451]
(27) Project
Arguments: [Code Acte#295502, Montant#295511, Ligne RSF#295519, Date_effet#295527, Date_révocation#295535, Trigramme#295543, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#295451 AS TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#295551]
(28) Project
Arguments: [Code Acte#295502, Montant#295511, Ligne RSF#295519, Date_effet#295527, Date_révocation#295535, Trigramme#295543, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#295551]
(29) Union
Arguments: false, false
(30) Project
Arguments: [Code Acte#294745 AS Code Acte#295566, Montant#294754 AS Montant#295567, Ligne RSF#294762 AS Ligne RSF#295568, Date_effet#294770 AS Date_effet#295569, Date_révocation#294778 AS Date_révocation#295570, Trigramme#294786 AS Trigramme#295571, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#294794 AS TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#295572]
(31) Project
Arguments: [Code Acte#295566, Montant#295567, Ligne RSF#295568, Date_effet#295569, Date_révocation#295570, Trigramme#295571, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#295572]
(32) Project
Arguments: [Code Acte#295566 AS CODE_ACTE_345934#295631, Date_effet#295569 AS DATE_EFFET_345937#295632, Date_révocation#295570 AS DATE_REVOCATION_345938#295633, Ligne RSF#295568 AS LIGNE_RSF_345936#295634, Montant#295567 AS MONTANT_345935#295635, Trigramme#295571 AS TRIGRAMME_345939#295636]
(33) Project
Arguments: [CODE_ACTE_345934#295631, DATE_EFFET_345937#295632, DATE_REVOCATION_345938#295633, LIGNE_RSF_345936#295634, MONTANT_345935#295635, TRIGRAMME_345939#295636]
(34) View
Arguments: `TARIF_FORFAIT_345933172`, true
(35) SubqueryAlias
Arguments: TARIF_FORFAIT_345933172
(36) Project
Arguments: [CODE_ACTE_345934#295631 AS TARIF_FORFAIT_345933_CODE_ACTE_345934#295931, DATE_EFFET_345937#295632 AS TARIF_FORFAIT_345933_DATE_EFFET_345937#295932, DATE_REVOCATION_345938#295633 AS TARIF_FORFAIT_345933_DATE_REVOCATION_345938#295933, LIGNE_RSF_345936#295634 AS TARIF_FORFAIT_345933_LIGNE_RSF_345936#295934, MONTANT_345935#295635 AS TARIF_FORFAIT_345933_MONTANT_345935#295935, TRIGRAMME_345939#295636 AS TARIF_FORFAIT_345933_TRIGRAMME_345939#295936]
(37) Project
Arguments: [cast(TARIF_FORFAIT_345933_CODE_ACTE_345934#295931 as string) AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#295949, cast(TARIF_FORFAIT_345933_MONTANT_345935#295935 as string) AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#295950, cast(TARIF_FORFAIT_345933_LIGNE_RSF_345936#295934 as string) AS COL_C519DD82_4508_4154_B389_405B16413D09#295951, cast(TARIF_FORFAIT_345933_DATE_EFFET_345937#295932 as string) AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#295952, cast(TARIF_FORFAIT_345933_DATE_REVOCATION_345938#295933 as string) AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#295953, cast(TARIF_FORFAIT_345933_TRIGRAMME_345939#295936 as string) AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#295954]
(38) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#295949 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#295961, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#295950 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#295962, COL_C519DD82_4508_4154_B389_405B16413D09#295951 AS COL_C519DD82_4508_4154_B389_405B16413D09#295963, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#295952 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#295964, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#295953 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#295965, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#295954 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#295966]
(39) LogicalRelation
Arguments: csv, [finess_dataapps#295895, region-tarif#295896, login-user#295897], false
(40) Project
Arguments: [finess_dataapps#295895, region-tarif#295896, login-user#295897, cast(null as string) AS login_user#295901]
(41) Project
Arguments: [finess_dataapps#295895, region-tarif#295896, login_user#295901]
(42) Project
Arguments: [finess_dataapps#295895 AS finess_dataapps#295910, region-tarif#295896 AS region-tarif#295911, login_user#295901 AS login_user#295912]
(43) Project
Arguments: [finess_dataapps#295910, region-tarif#295911, login_user#295912]
(44) Project
Arguments: [finess_dataapps#295910 AS INFO_ETAB_FINES_345944#295919, region-tarif#295911 AS REGION_TARIF_345945#295920]
(45) Project
Arguments: [INFO_ETAB_FINES_345944#295919, REGION_TARIF_345945#295920]
(46) View
Arguments: `INFO_DATAAPPS_345943172`, true
(47) SubqueryAlias
Arguments: INFO_DATAAPPS_345943172
(48) Project
Arguments: [INFO_ETAB_FINES_345944#295919 AS INFO_DATAAPPS_345943_INFO_ETAB_FINES_345944#295975, REGION_TARIF_345945#295920 AS INFO_DATAAPPS_345943_REGION_TARIF_345945#295976]
(49) Join
Arguments: Cross
(50) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#295961, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#295962, COL_C519DD82_4508_4154_B389_405B16413D09#295963, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#295964, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#295965, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#295966, INFO_DATAAPPS_345943_REGION_TARIF_345945#295976 AS COL_ABDEDC13_3840_48F7_A962_159F725BF772#295987]
(51) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#295961, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#295962, COL_C519DD82_4508_4154_B389_405B16413D09#295963, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#295964, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#295965, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#295966, COL_ABDEDC13_3840_48F7_A962_159F725BF772#295987, str_replace(COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#295962, cast(. as string), cast(, as string)) AS COL_6AE58BB6_C7FC_4F54_9502_66AD374805CD#295995]
(52) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#295961 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#296004, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#295962 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#296005, COL_C519DD82_4508_4154_B389_405B16413D09#295963 AS COL_C519DD82_4508_4154_B389_405B16413D09#296006, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#295964 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#296007, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#295965 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#296008, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#295966 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#296009, COL_ABDEDC13_3840_48F7_A962_159F725BF772#295987 AS COL_ABDEDC13_3840_48F7_A962_159F725BF772#296010, COL_6AE58BB6_C7FC_4F54_9502_66AD374805CD#295995 AS COL_6AE58BB6_C7FC_4F54_9502_66AD374805CD#296011]
(53) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#296004 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#296020, COL_6AE58BB6_C7FC_4F54_9502_66AD374805CD#296011 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#296021, COL_C519DD82_4508_4154_B389_405B16413D09#296006 AS COL_C519DD82_4508_4154_B389_405B16413D09#296022, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#296007 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#296023, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#296008 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#296024, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#296009 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#296025, COL_ABDEDC13_3840_48F7_A962_159F725BF772#296010 AS COL_ABDEDC13_3840_48F7_A962_159F725BF772#296026, COL_6AE58BB6_C7FC_4F54_9502_66AD374805CD#296011 AS COL_6AE58BB6_C7FC_4F54_9502_66AD374805CD#296027]
(54) Filter
Arguments: (COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#296025 <=> COL_ABDEDC13_3840_48F7_A962_159F725BF772#296026)
(55) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#296020 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#296036, str_to_dec(COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#296021, ##,##) AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#296037, str_to_datez(COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#296023, dd/MM/yyyy, Europe/Paris, fr_FR) AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#296038, str_to_datez(COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#296024, dd/MM/yyyy, Europe/Paris, fr_FR) AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#296039, COL_C519DD82_4508_4154_B389_405B16413D09#296022 AS COL_C519DD82_4508_4154_B389_405B16413D09#296040, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#296025 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#296041, COL_ABDEDC13_3840_48F7_A962_159F725BF772#296026 AS COL_ABDEDC13_3840_48F7_A962_159F725BF772#296042]
(56) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#296036 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#296050, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#296037 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#296051, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#296038 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#296052, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#296039 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#296053, COL_C519DD82_4508_4154_B389_405B16413D09#296040 AS COL_C519DD82_4508_4154_B389_405B16413D09#296054, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#296041 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#296055, COL_ABDEDC13_3840_48F7_A962_159F725BF772#296042 AS COL_ABDEDC13_3840_48F7_A962_159F725BF772#296056]
(57) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#296050 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#296064, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#296051 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#296065, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#296052 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#296066, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#296053 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#296067, COL_C519DD82_4508_4154_B389_405B16413D09#296054 AS COL_C519DD82_4508_4154_B389_405B16413D09#296068, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#296055 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#296069, COL_ABDEDC13_3840_48F7_A962_159F725BF772#296056 AS COL_ABDEDC13_3840_48F7_A962_159F725BF772#296070]