== 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_345998167`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [Code+Acte#297960, Montant#297961, Ligne+RSF#297962, Date_effet#297963, Date_r%C3%A9vocation#297964, Trigramme#297965, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#297966], false
(4) Project
Arguments: [Code+Acte#297960 AS Code Acte#297974, Montant#297961, Ligne+RSF#297962, Date_effet#297963, Date_r%C3%A9vocation#297964, Trigramme#297965, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#297966]
(5) Project
Arguments: [Code Acte#297974, Montant#297961 AS Montant#297983, Ligne+RSF#297962, Date_effet#297963, Date_r%C3%A9vocation#297964, Trigramme#297965, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#297966]
(6) Project
Arguments: [Code Acte#297974, Montant#297983, Ligne+RSF#297962 AS Ligne RSF#297991, Date_effet#297963, Date_r%C3%A9vocation#297964, Trigramme#297965, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#297966]
(7) Project
Arguments: [Code Acte#297974, Montant#297983, Ligne RSF#297991, Date_effet#297963 AS Date_effet#297999, Date_r%C3%A9vocation#297964, Trigramme#297965, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#297966]
(8) Project
Arguments: [Code Acte#297974, Montant#297983, Ligne RSF#297991, Date_effet#297999, Date_r%C3%A9vocation#297964 AS Date_révocation#298007, Trigramme#297965, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#297966]
(9) Project
Arguments: [Code Acte#297974, Montant#297983, Ligne RSF#297991, Date_effet#297999, Date_révocation#298007, Trigramme#297965 AS Trigramme#298015, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#297966]
(10) Project
Arguments: [Code Acte#297974, Montant#297983, Ligne RSF#297991, Date_effet#297999, Date_révocation#298007, Trigramme#298015, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#297966 AS TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#298023]
(11) LogicalRelation
Arguments: parquet, [Code+Acte#298085, Montant#298086, Ligne+RSF#298087, Date_effet#298088, Date_r%C3%A9vocation#298089, Trigramme#298090, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#298091], false
(12) Project
Arguments: [Code+Acte#298085 AS Code Acte#298099, Montant#298086, Ligne+RSF#298087, Date_effet#298088, Date_r%C3%A9vocation#298089, Trigramme#298090, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#298091]
(13) Project
Arguments: [Code Acte#298099, Montant#298086 AS Montant#298108, Ligne+RSF#298087, Date_effet#298088, Date_r%C3%A9vocation#298089, Trigramme#298090, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#298091]
(14) Project
Arguments: [Code Acte#298099, Montant#298108, Ligne+RSF#298087 AS Ligne RSF#298116, Date_effet#298088, Date_r%C3%A9vocation#298089, Trigramme#298090, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#298091]
(15) Project
Arguments: [Code Acte#298099, Montant#298108, Ligne RSF#298116, Date_effet#298088 AS Date_effet#298124, Date_r%C3%A9vocation#298089, Trigramme#298090, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#298091]
(16) Project
Arguments: [Code Acte#298099, Montant#298108, Ligne RSF#298116, Date_effet#298124, Date_r%C3%A9vocation#298089 AS Date_révocation#298132, Trigramme#298090, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#298091]
(17) Project
Arguments: [Code Acte#298099, Montant#298108, Ligne RSF#298116, Date_effet#298124, Date_révocation#298132, Trigramme#298090 AS Trigramme#298140, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#298091]
(18) Project
Arguments: [Code Acte#298099, Montant#298108, Ligne RSF#298116, Date_effet#298124, Date_révocation#298132, Trigramme#298140, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#298091 AS TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#298148]
(19) Project
Arguments: [Code Acte#298099, Montant#298108, Ligne RSF#298116, Date_effet#298124, Date_révocation#298132, Trigramme#298140, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#298148]
(20) LogicalRelation
Arguments: parquet, [Code+Acte#298274, Montant#298275, Ligne+RSF#298276, Date_effet#298277, Date_r%C3%A9vocation#298278, Trigramme#298279, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#298280], false
(21) Project
Arguments: [Code+Acte#298274 AS Code Acte#298288, Montant#298275, Ligne+RSF#298276, Date_effet#298277, Date_r%C3%A9vocation#298278, Trigramme#298279, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#298280]
(22) Project
Arguments: [Code Acte#298288, Montant#298275 AS Montant#298297, Ligne+RSF#298276, Date_effet#298277, Date_r%C3%A9vocation#298278, Trigramme#298279, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#298280]
(23) Project
Arguments: [Code Acte#298288, Montant#298297, Ligne+RSF#298276 AS Ligne RSF#298305, Date_effet#298277, Date_r%C3%A9vocation#298278, Trigramme#298279, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#298280]
(24) Project
Arguments: [Code Acte#298288, Montant#298297, Ligne RSF#298305, Date_effet#298277 AS Date_effet#298313, Date_r%C3%A9vocation#298278, Trigramme#298279, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#298280]
(25) Project
Arguments: [Code Acte#298288, Montant#298297, Ligne RSF#298305, Date_effet#298313, Date_r%C3%A9vocation#298278 AS Date_révocation#298321, Trigramme#298279, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#298280]
(26) Project
Arguments: [Code Acte#298288, Montant#298297, Ligne RSF#298305, Date_effet#298313, Date_révocation#298321, Trigramme#298279 AS Trigramme#298329, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#298280]
(27) Project
Arguments: [Code Acte#298288, Montant#298297, Ligne RSF#298305, Date_effet#298313, Date_révocation#298321, Trigramme#298329, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#298280 AS TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#298337]
(28) Project
Arguments: [Code Acte#298288, Montant#298297, Ligne RSF#298305, Date_effet#298313, Date_révocation#298321, Trigramme#298329, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#298337]
(29) Union
Arguments: false, false
(30) Project
Arguments: [Code Acte#297974 AS Code Acte#298352, Montant#297983 AS Montant#298353, Ligne RSF#297991 AS Ligne RSF#298354, Date_effet#297999 AS Date_effet#298355, Date_révocation#298007 AS Date_révocation#298356, Trigramme#298015 AS Trigramme#298357, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#298023 AS TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#298358]
(31) Project
Arguments: [Code Acte#298352, Montant#298353, Ligne RSF#298354, Date_effet#298355, Date_révocation#298356, Trigramme#298357, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#298358]
(32) Project
Arguments: [Code Acte#298352 AS CODE_ACTE_345934#298373, Date_effet#298355 AS DATE_EFFET_345937#298374, Date_révocation#298356 AS DATE_REVOCATION_345938#298375, Ligne RSF#298354 AS LIGNE_RSF_345936#298376, Montant#298353 AS MONTANT_345935#298377, Trigramme#298357 AS TRIGRAMME_345939#298378]
(33) Project
Arguments: [CODE_ACTE_345934#298373, DATE_EFFET_345937#298374, DATE_REVOCATION_345938#298375, LIGNE_RSF_345936#298376, MONTANT_345935#298377, TRIGRAMME_345939#298378]
(34) View
Arguments: `TARIF_FORFAIT_345933167`, true
(35) SubqueryAlias
Arguments: TARIF_FORFAIT_345933167
(36) Project
Arguments: [CODE_ACTE_345934#298373 AS TARIF_FORFAIT_345933_CODE_ACTE_345934#298780, DATE_EFFET_345937#298374 AS TARIF_FORFAIT_345933_DATE_EFFET_345937#298781, DATE_REVOCATION_345938#298375 AS TARIF_FORFAIT_345933_DATE_REVOCATION_345938#298782, LIGNE_RSF_345936#298376 AS TARIF_FORFAIT_345933_LIGNE_RSF_345936#298783, MONTANT_345935#298377 AS TARIF_FORFAIT_345933_MONTANT_345935#298784, TRIGRAMME_345939#298378 AS TARIF_FORFAIT_345933_TRIGRAMME_345939#298785]
(37) Project
Arguments: [cast(TARIF_FORFAIT_345933_CODE_ACTE_345934#298780 as string) AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#298798, cast(TARIF_FORFAIT_345933_MONTANT_345935#298784 as string) AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#298799, cast(TARIF_FORFAIT_345933_LIGNE_RSF_345936#298783 as string) AS COL_C519DD82_4508_4154_B389_405B16413D09#298800, cast(TARIF_FORFAIT_345933_DATE_EFFET_345937#298781 as string) AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#298801, cast(TARIF_FORFAIT_345933_DATE_REVOCATION_345938#298782 as string) AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#298802, cast(TARIF_FORFAIT_345933_TRIGRAMME_345939#298785 as string) AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#298803]
(38) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#298798 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#298810, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#298799 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#298811, COL_C519DD82_4508_4154_B389_405B16413D09#298800 AS COL_C519DD82_4508_4154_B389_405B16413D09#298812, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#298801 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#298813, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#298802 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#298814, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#298803 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#298815]
(39) LogicalRelation
Arguments: csv, [finess_dataapps#298744, region-tarif#298745, login-user#298746], false
(40) Project
Arguments: [finess_dataapps#298744, region-tarif#298745, login-user#298746, cast(null as string) AS login_user#298750]
(41) Project
Arguments: [finess_dataapps#298744, region-tarif#298745, login_user#298750]
(42) Project
Arguments: [finess_dataapps#298744 AS finess_dataapps#298759, region-tarif#298745 AS region-tarif#298760, login_user#298750 AS login_user#298761]
(43) Project
Arguments: [finess_dataapps#298759, region-tarif#298760, login_user#298761]
(44) Project
Arguments: [finess_dataapps#298759 AS INFO_ETAB_FINES_345944#298768, region-tarif#298760 AS REGION_TARIF_345945#298769]
(45) Project
Arguments: [INFO_ETAB_FINES_345944#298768, REGION_TARIF_345945#298769]
(46) View
Arguments: `INFO_DATAAPPS_345943167`, true
(47) SubqueryAlias
Arguments: INFO_DATAAPPS_345943167
(48) Project
Arguments: [INFO_ETAB_FINES_345944#298768 AS INFO_DATAAPPS_345943_INFO_ETAB_FINES_345944#298936, REGION_TARIF_345945#298769 AS INFO_DATAAPPS_345943_REGION_TARIF_345945#298937]
(49) Join
Arguments: Cross
(50) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#298810, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#298811, COL_C519DD82_4508_4154_B389_405B16413D09#298812, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#298813, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#298814, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#298815, INFO_DATAAPPS_345943_REGION_TARIF_345945#298937 AS COL_ABDEDC13_3840_48F7_A962_159F725BF772#298948]
(51) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#298810, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#298811, COL_C519DD82_4508_4154_B389_405B16413D09#298812, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#298813, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#298814, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#298815, COL_ABDEDC13_3840_48F7_A962_159F725BF772#298948, str_replace(COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#298811, cast(. as string), cast(, as string)) AS COL_6AE58BB6_C7FC_4F54_9502_66AD374805CD#298956]
(52) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#298810 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#298965, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#298811 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#298966, COL_C519DD82_4508_4154_B389_405B16413D09#298812 AS COL_C519DD82_4508_4154_B389_405B16413D09#298967, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#298813 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#298968, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#298814 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#298969, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#298815 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#298970, COL_ABDEDC13_3840_48F7_A962_159F725BF772#298948 AS COL_ABDEDC13_3840_48F7_A962_159F725BF772#298971, COL_6AE58BB6_C7FC_4F54_9502_66AD374805CD#298956 AS COL_6AE58BB6_C7FC_4F54_9502_66AD374805CD#298972]
(53) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#298965 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#298981, COL_6AE58BB6_C7FC_4F54_9502_66AD374805CD#298972 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#298982, COL_C519DD82_4508_4154_B389_405B16413D09#298967 AS COL_C519DD82_4508_4154_B389_405B16413D09#298983, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#298968 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#298984, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#298969 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#298985, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#298970 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#298986, COL_ABDEDC13_3840_48F7_A962_159F725BF772#298971 AS COL_ABDEDC13_3840_48F7_A962_159F725BF772#298987, COL_6AE58BB6_C7FC_4F54_9502_66AD374805CD#298972 AS COL_6AE58BB6_C7FC_4F54_9502_66AD374805CD#298988]
(54) Filter
Arguments: (COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#298986 <=> COL_ABDEDC13_3840_48F7_A962_159F725BF772#298987)
(55) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#298981 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#298997, str_to_dec(COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#298982, ##,##) AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#298998, str_to_datez(COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#298984, dd/MM/yyyy, Europe/Paris, fr_FR) AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#298999, str_to_datez(COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#298985, dd/MM/yyyy, Europe/Paris, fr_FR) AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#299000, COL_C519DD82_4508_4154_B389_405B16413D09#298983 AS COL_C519DD82_4508_4154_B389_405B16413D09#299001, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#298986 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#299002, COL_ABDEDC13_3840_48F7_A962_159F725BF772#298987 AS COL_ABDEDC13_3840_48F7_A962_159F725BF772#299003]
(56) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#298997 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#299011, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#298998 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#299012, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#298999 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#299013, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#299000 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#299014, COL_C519DD82_4508_4154_B389_405B16413D09#299001 AS COL_C519DD82_4508_4154_B389_405B16413D09#299015, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#299002 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#299016, COL_ABDEDC13_3840_48F7_A962_159F725BF772#299003 AS COL_ABDEDC13_3840_48F7_A962_159F725BF772#299017]
(57) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#299011 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#299025, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#299012 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#299026, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#299013 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#299027, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#299014 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#299028, COL_C519DD82_4508_4154_B389_405B16413D09#299015 AS COL_C519DD82_4508_4154_B389_405B16413D09#299029, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#299016 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#299030, COL_ABDEDC13_3840_48F7_A962_159F725BF772#299017 AS COL_ABDEDC13_3840_48F7_A962_159F725BF772#299031]