== 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_345998171`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [Code+Acte#318538, Montant#318539, Ligne+RSF#318540, Date_effet#318541, Date_r%C3%A9vocation#318542, Trigramme#318543, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#318544], false
(4) Project
Arguments: [Code+Acte#318538 AS Code Acte#318552, Montant#318539, Ligne+RSF#318540, Date_effet#318541, Date_r%C3%A9vocation#318542, Trigramme#318543, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#318544]
(5) Project
Arguments: [Code Acte#318552, Montant#318539 AS Montant#318561, Ligne+RSF#318540, Date_effet#318541, Date_r%C3%A9vocation#318542, Trigramme#318543, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#318544]
(6) Project
Arguments: [Code Acte#318552, Montant#318561, Ligne+RSF#318540 AS Ligne RSF#318569, Date_effet#318541, Date_r%C3%A9vocation#318542, Trigramme#318543, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#318544]
(7) Project
Arguments: [Code Acte#318552, Montant#318561, Ligne RSF#318569, Date_effet#318541 AS Date_effet#318577, Date_r%C3%A9vocation#318542, Trigramme#318543, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#318544]
(8) Project
Arguments: [Code Acte#318552, Montant#318561, Ligne RSF#318569, Date_effet#318577, Date_r%C3%A9vocation#318542 AS Date_révocation#318585, Trigramme#318543, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#318544]
(9) Project
Arguments: [Code Acte#318552, Montant#318561, Ligne RSF#318569, Date_effet#318577, Date_révocation#318585, Trigramme#318543 AS Trigramme#318593, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#318544]
(10) Project
Arguments: [Code Acte#318552, Montant#318561, Ligne RSF#318569, Date_effet#318577, Date_révocation#318585, Trigramme#318593, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#318544 AS TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#318601]
(11) LogicalRelation
Arguments: parquet, [Code+Acte#318609, Montant#318610, Ligne+RSF#318611, Date_effet#318612, Date_r%C3%A9vocation#318613, Trigramme#318614, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#318615], false
(12) Project
Arguments: [Code+Acte#318609 AS Code Acte#318623, Montant#318610, Ligne+RSF#318611, Date_effet#318612, Date_r%C3%A9vocation#318613, Trigramme#318614, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#318615]
(13) Project
Arguments: [Code Acte#318623, Montant#318610 AS Montant#318632, Ligne+RSF#318611, Date_effet#318612, Date_r%C3%A9vocation#318613, Trigramme#318614, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#318615]
(14) Project
Arguments: [Code Acte#318623, Montant#318632, Ligne+RSF#318611 AS Ligne RSF#318640, Date_effet#318612, Date_r%C3%A9vocation#318613, Trigramme#318614, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#318615]
(15) Project
Arguments: [Code Acte#318623, Montant#318632, Ligne RSF#318640, Date_effet#318612 AS Date_effet#318648, Date_r%C3%A9vocation#318613, Trigramme#318614, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#318615]
(16) Project
Arguments: [Code Acte#318623, Montant#318632, Ligne RSF#318640, Date_effet#318648, Date_r%C3%A9vocation#318613 AS Date_révocation#318656, Trigramme#318614, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#318615]
(17) Project
Arguments: [Code Acte#318623, Montant#318632, Ligne RSF#318640, Date_effet#318648, Date_révocation#318656, Trigramme#318614 AS Trigramme#318664, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#318615]
(18) Project
Arguments: [Code Acte#318623, Montant#318632, Ligne RSF#318640, Date_effet#318648, Date_révocation#318656, Trigramme#318664, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#318615 AS TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#318672]
(19) Project
Arguments: [Code Acte#318623, Montant#318632, Ligne RSF#318640, Date_effet#318648, Date_révocation#318656, Trigramme#318664, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#318672]
(20) LogicalRelation
Arguments: parquet, [Code+Acte#318687, Montant#318688, Ligne+RSF#318689, Date_effet#318690, Date_r%C3%A9vocation#318691, Trigramme#318692, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#318693], false
(21) Project
Arguments: [Code+Acte#318687 AS Code Acte#318701, Montant#318688, Ligne+RSF#318689, Date_effet#318690, Date_r%C3%A9vocation#318691, Trigramme#318692, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#318693]
(22) Project
Arguments: [Code Acte#318701, Montant#318688 AS Montant#318710, Ligne+RSF#318689, Date_effet#318690, Date_r%C3%A9vocation#318691, Trigramme#318692, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#318693]
(23) Project
Arguments: [Code Acte#318701, Montant#318710, Ligne+RSF#318689 AS Ligne RSF#318718, Date_effet#318690, Date_r%C3%A9vocation#318691, Trigramme#318692, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#318693]
(24) Project
Arguments: [Code Acte#318701, Montant#318710, Ligne RSF#318718, Date_effet#318690 AS Date_effet#318726, Date_r%C3%A9vocation#318691, Trigramme#318692, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#318693]
(25) Project
Arguments: [Code Acte#318701, Montant#318710, Ligne RSF#318718, Date_effet#318726, Date_r%C3%A9vocation#318691 AS Date_révocation#318734, Trigramme#318692, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#318693]
(26) Project
Arguments: [Code Acte#318701, Montant#318710, Ligne RSF#318718, Date_effet#318726, Date_révocation#318734, Trigramme#318692 AS Trigramme#318742, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#318693]
(27) Project
Arguments: [Code Acte#318701, Montant#318710, Ligne RSF#318718, Date_effet#318726, Date_révocation#318734, Trigramme#318742, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#318693 AS TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#318750]
(28) Project
Arguments: [Code Acte#318701, Montant#318710, Ligne RSF#318718, Date_effet#318726, Date_révocation#318734, Trigramme#318742, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#318750]
(29) Union
Arguments: false, false
(30) Project
Arguments: [Code Acte#318552 AS Code Acte#318765, Montant#318561 AS Montant#318766, Ligne RSF#318569 AS Ligne RSF#318767, Date_effet#318577 AS Date_effet#318768, Date_révocation#318585 AS Date_révocation#318769, Trigramme#318593 AS Trigramme#318770, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#318601 AS TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#318771]
(31) Project
Arguments: [Code Acte#318765, Montant#318766, Ligne RSF#318767, Date_effet#318768, Date_révocation#318769, Trigramme#318770, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#318771]
(32) Project
Arguments: [Code Acte#318765 AS CODE_ACTE_345934#318786, Date_effet#318768 AS DATE_EFFET_345937#318787, Date_révocation#318769 AS DATE_REVOCATION_345938#318788, Ligne RSF#318767 AS LIGNE_RSF_345936#318789, Montant#318766 AS MONTANT_345935#318790, Trigramme#318770 AS TRIGRAMME_345939#318791]
(33) Project
Arguments: [CODE_ACTE_345934#318786, DATE_EFFET_345937#318787, DATE_REVOCATION_345938#318788, LIGNE_RSF_345936#318789, MONTANT_345935#318790, TRIGRAMME_345939#318791]
(34) View
Arguments: `TARIF_FORFAIT_345933171`, true
(35) SubqueryAlias
Arguments: TARIF_FORFAIT_345933171
(36) Project
Arguments: [CODE_ACTE_345934#318786 AS TARIF_FORFAIT_345933_CODE_ACTE_345934#318857, DATE_EFFET_345937#318787 AS TARIF_FORFAIT_345933_DATE_EFFET_345937#318858, DATE_REVOCATION_345938#318788 AS TARIF_FORFAIT_345933_DATE_REVOCATION_345938#318859, LIGNE_RSF_345936#318789 AS TARIF_FORFAIT_345933_LIGNE_RSF_345936#318860, MONTANT_345935#318790 AS TARIF_FORFAIT_345933_MONTANT_345935#318861, TRIGRAMME_345939#318791 AS TARIF_FORFAIT_345933_TRIGRAMME_345939#318862]
(37) Project
Arguments: [cast(TARIF_FORFAIT_345933_CODE_ACTE_345934#318857 as string) AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#318875, cast(TARIF_FORFAIT_345933_MONTANT_345935#318861 as string) AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#318876, cast(TARIF_FORFAIT_345933_LIGNE_RSF_345936#318860 as string) AS COL_C519DD82_4508_4154_B389_405B16413D09#318877, cast(TARIF_FORFAIT_345933_DATE_EFFET_345937#318858 as string) AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#318878, cast(TARIF_FORFAIT_345933_DATE_REVOCATION_345938#318859 as string) AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#318879, cast(TARIF_FORFAIT_345933_TRIGRAMME_345939#318862 as string) AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#318880]
(38) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#318875 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#318887, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#318876 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#318888, COL_C519DD82_4508_4154_B389_405B16413D09#318877 AS COL_C519DD82_4508_4154_B389_405B16413D09#318889, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#318878 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#318890, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#318879 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#318891, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#318880 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#318892]
(39) LogicalRelation
Arguments: csv, [finess_dataapps#318821, region-tarif#318822, login-user#318823], false
(40) Project
Arguments: [finess_dataapps#318821, region-tarif#318822, login-user#318823, cast(null as string) AS login_user#318827]
(41) Project
Arguments: [finess_dataapps#318821, region-tarif#318822, login_user#318827]
(42) Project
Arguments: [finess_dataapps#318821 AS finess_dataapps#318836, region-tarif#318822 AS region-tarif#318837, login_user#318827 AS login_user#318838]
(43) Project
Arguments: [finess_dataapps#318836, region-tarif#318837, login_user#318838]
(44) Project
Arguments: [finess_dataapps#318836 AS INFO_ETAB_FINES_345944#318845, region-tarif#318837 AS REGION_TARIF_345945#318846]
(45) Project
Arguments: [INFO_ETAB_FINES_345944#318845, REGION_TARIF_345945#318846]
(46) View
Arguments: `INFO_DATAAPPS_345943171`, true
(47) SubqueryAlias
Arguments: INFO_DATAAPPS_345943171
(48) Project
Arguments: [INFO_ETAB_FINES_345944#318845 AS INFO_DATAAPPS_345943_INFO_ETAB_FINES_345944#318901, REGION_TARIF_345945#318846 AS INFO_DATAAPPS_345943_REGION_TARIF_345945#318902]
(49) Join
Arguments: Cross
(50) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#318887, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#318888, COL_C519DD82_4508_4154_B389_405B16413D09#318889, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#318890, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#318891, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#318892, INFO_DATAAPPS_345943_REGION_TARIF_345945#318902 AS COL_ABDEDC13_3840_48F7_A962_159F725BF772#318913]
(51) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#318887, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#318888, COL_C519DD82_4508_4154_B389_405B16413D09#318889, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#318890, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#318891, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#318892, COL_ABDEDC13_3840_48F7_A962_159F725BF772#318913, str_replace(COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#318888, cast(. as string), cast(, as string)) AS COL_6AE58BB6_C7FC_4F54_9502_66AD374805CD#318921]
(52) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#318887 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#318930, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#318888 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#318931, COL_C519DD82_4508_4154_B389_405B16413D09#318889 AS COL_C519DD82_4508_4154_B389_405B16413D09#318932, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#318890 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#318933, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#318891 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#318934, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#318892 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#318935, COL_ABDEDC13_3840_48F7_A962_159F725BF772#318913 AS COL_ABDEDC13_3840_48F7_A962_159F725BF772#318936, COL_6AE58BB6_C7FC_4F54_9502_66AD374805CD#318921 AS COL_6AE58BB6_C7FC_4F54_9502_66AD374805CD#318937]
(53) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#318930 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#318946, COL_6AE58BB6_C7FC_4F54_9502_66AD374805CD#318937 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#318947, COL_C519DD82_4508_4154_B389_405B16413D09#318932 AS COL_C519DD82_4508_4154_B389_405B16413D09#318948, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#318933 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#318949, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#318934 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#318950, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#318935 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#318951, COL_ABDEDC13_3840_48F7_A962_159F725BF772#318936 AS COL_ABDEDC13_3840_48F7_A962_159F725BF772#318952, COL_6AE58BB6_C7FC_4F54_9502_66AD374805CD#318937 AS COL_6AE58BB6_C7FC_4F54_9502_66AD374805CD#318953]
(54) Filter
Arguments: (COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#318951 <=> COL_ABDEDC13_3840_48F7_A962_159F725BF772#318952)
(55) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#318946 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#318962, str_to_dec(COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#318947, ##,##) AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#318963, str_to_datez(COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#318949, dd/MM/yyyy, Europe/Paris, fr_FR) AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#318964, str_to_datez(COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#318950, dd/MM/yyyy, Europe/Paris, fr_FR) AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#318965, COL_C519DD82_4508_4154_B389_405B16413D09#318948 AS COL_C519DD82_4508_4154_B389_405B16413D09#318966, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#318951 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#318967, COL_ABDEDC13_3840_48F7_A962_159F725BF772#318952 AS COL_ABDEDC13_3840_48F7_A962_159F725BF772#318968]
(56) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#318962 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#318976, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#318963 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#318977, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#318964 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#318978, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#318965 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#318979, COL_C519DD82_4508_4154_B389_405B16413D09#318966 AS COL_C519DD82_4508_4154_B389_405B16413D09#318980, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#318967 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#318981, COL_ABDEDC13_3840_48F7_A962_159F725BF772#318968 AS COL_ABDEDC13_3840_48F7_A962_159F725BF772#318982]
(57) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#318976 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#318990, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#318977 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#318991, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#318978 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#318992, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#318979 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#318993, COL_C519DD82_4508_4154_B389_405B16413D09#318980 AS COL_C519DD82_4508_4154_B389_405B16413D09#318994, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#318981 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#318995, COL_ABDEDC13_3840_48F7_A962_159F725BF772#318982 AS COL_ABDEDC13_3840_48F7_A962_159F725BF772#318996]