== 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#339587, Montant#339588, Ligne+RSF#339589, Date_effet#339590, Date_r%C3%A9vocation#339591, Trigramme#339592, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#339593], false
(4) Project
Arguments: [Code+Acte#339587 AS Code Acte#339639, Montant#339588, Ligne+RSF#339589, Date_effet#339590, Date_r%C3%A9vocation#339591, Trigramme#339592, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#339593]
(5) Project
Arguments: [Code Acte#339639, Montant#339588 AS Montant#339648, Ligne+RSF#339589, Date_effet#339590, Date_r%C3%A9vocation#339591, Trigramme#339592, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#339593]
(6) Project
Arguments: [Code Acte#339639, Montant#339648, Ligne+RSF#339589 AS Ligne RSF#339656, Date_effet#339590, Date_r%C3%A9vocation#339591, Trigramme#339592, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#339593]
(7) Project
Arguments: [Code Acte#339639, Montant#339648, Ligne RSF#339656, Date_effet#339590 AS Date_effet#339664, Date_r%C3%A9vocation#339591, Trigramme#339592, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#339593]
(8) Project
Arguments: [Code Acte#339639, Montant#339648, Ligne RSF#339656, Date_effet#339664, Date_r%C3%A9vocation#339591 AS Date_révocation#339672, Trigramme#339592, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#339593]
(9) Project
Arguments: [Code Acte#339639, Montant#339648, Ligne RSF#339656, Date_effet#339664, Date_révocation#339672, Trigramme#339592 AS Trigramme#339680, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#339593]
(10) Project
Arguments: [Code Acte#339639, Montant#339648, Ligne RSF#339656, Date_effet#339664, Date_révocation#339672, Trigramme#339680, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#339593 AS TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#339688]
(11) LogicalRelation
Arguments: parquet, [Code+Acte#339858, Montant#339859, Ligne+RSF#339860, Date_effet#339861, Date_r%C3%A9vocation#339862, Trigramme#339863, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#339864], false
(12) Project
Arguments: [Code+Acte#339858 AS Code Acte#339872, Montant#339859, Ligne+RSF#339860, Date_effet#339861, Date_r%C3%A9vocation#339862, Trigramme#339863, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#339864]
(13) Project
Arguments: [Code Acte#339872, Montant#339859 AS Montant#339881, Ligne+RSF#339860, Date_effet#339861, Date_r%C3%A9vocation#339862, Trigramme#339863, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#339864]
(14) Project
Arguments: [Code Acte#339872, Montant#339881, Ligne+RSF#339860 AS Ligne RSF#339931, Date_effet#339861, Date_r%C3%A9vocation#339862, Trigramme#339863, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#339864]
(15) Project
Arguments: [Code Acte#339872, Montant#339881, Ligne RSF#339931, Date_effet#339861 AS Date_effet#339940, Date_r%C3%A9vocation#339862, Trigramme#339863, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#339864]
(16) Project
Arguments: [Code Acte#339872, Montant#339881, Ligne RSF#339931, Date_effet#339940, Date_r%C3%A9vocation#339862 AS Date_révocation#339948, Trigramme#339863, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#339864]
(17) Project
Arguments: [Code Acte#339872, Montant#339881, Ligne RSF#339931, Date_effet#339940, Date_révocation#339948, Trigramme#339863 AS Trigramme#339956, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#339864]
(18) Project
Arguments: [Code Acte#339872, Montant#339881, Ligne RSF#339931, Date_effet#339940, Date_révocation#339948, Trigramme#339956, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#339864 AS TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#339964]
(19) Project
Arguments: [Code Acte#339872, Montant#339881, Ligne RSF#339931, Date_effet#339940, Date_révocation#339948, Trigramme#339956, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#339964]
(20) LogicalRelation
Arguments: parquet, [Code+Acte#340114, Montant#340115, Ligne+RSF#340116, Date_effet#340117, Date_r%C3%A9vocation#340118, Trigramme#340119, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#340120], false
(21) Project
Arguments: [Code+Acte#340114 AS Code Acte#340220, Montant#340115, Ligne+RSF#340116, Date_effet#340117, Date_r%C3%A9vocation#340118, Trigramme#340119, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#340120]
(22) Project
Arguments: [Code Acte#340220, Montant#340115 AS Montant#340229, Ligne+RSF#340116, Date_effet#340117, Date_r%C3%A9vocation#340118, Trigramme#340119, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#340120]
(23) Project
Arguments: [Code Acte#340220, Montant#340229, Ligne+RSF#340116 AS Ligne RSF#340237, Date_effet#340117, Date_r%C3%A9vocation#340118, Trigramme#340119, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#340120]
(24) Project
Arguments: [Code Acte#340220, Montant#340229, Ligne RSF#340237, Date_effet#340117 AS Date_effet#340291, Date_r%C3%A9vocation#340118, Trigramme#340119, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#340120]
(25) Project
Arguments: [Code Acte#340220, Montant#340229, Ligne RSF#340237, Date_effet#340291, Date_r%C3%A9vocation#340118 AS Date_révocation#340299, Trigramme#340119, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#340120]
(26) Project
Arguments: [Code Acte#340220, Montant#340229, Ligne RSF#340237, Date_effet#340291, Date_révocation#340299, Trigramme#340119 AS Trigramme#340307, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#340120]
(27) Project
Arguments: [Code Acte#340220, Montant#340229, Ligne RSF#340237, Date_effet#340291, Date_révocation#340299, Trigramme#340307, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#340120 AS TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#340315]
(28) Project
Arguments: [Code Acte#340220, Montant#340229, Ligne RSF#340237, Date_effet#340291, Date_révocation#340299, Trigramme#340307, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#340315]
(29) Union
Arguments: false, false
(30) Project
Arguments: [Code Acte#339639 AS Code Acte#340330, Montant#339648 AS Montant#340331, Ligne RSF#339656 AS Ligne RSF#340332, Date_effet#339664 AS Date_effet#340333, Date_révocation#339672 AS Date_révocation#340334, Trigramme#339680 AS Trigramme#340335, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#339688 AS TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#340336]
(31) Project
Arguments: [Code Acte#340330, Montant#340331, Ligne RSF#340332, Date_effet#340333, Date_révocation#340334, Trigramme#340335, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#340336]
(32) Project
Arguments: [Code Acte#340330 AS CODE_ACTE_345934#340351, Date_effet#340333 AS DATE_EFFET_345937#340352, Date_révocation#340334 AS DATE_REVOCATION_345938#340353, Ligne RSF#340332 AS LIGNE_RSF_345936#340354, Montant#340331 AS MONTANT_345935#340355, Trigramme#340335 AS TRIGRAMME_345939#340356]
(33) Project
Arguments: [CODE_ACTE_345934#340351, DATE_EFFET_345937#340352, DATE_REVOCATION_345938#340353, LIGNE_RSF_345936#340354, MONTANT_345935#340355, TRIGRAMME_345939#340356]
(34) View
Arguments: `TARIF_FORFAIT_345933170`, true
(35) SubqueryAlias
Arguments: TARIF_FORFAIT_345933170
(36) Project
Arguments: [CODE_ACTE_345934#340351 AS TARIF_FORFAIT_345933_CODE_ACTE_345934#340422, DATE_EFFET_345937#340352 AS TARIF_FORFAIT_345933_DATE_EFFET_345937#340423, DATE_REVOCATION_345938#340353 AS TARIF_FORFAIT_345933_DATE_REVOCATION_345938#340424, LIGNE_RSF_345936#340354 AS TARIF_FORFAIT_345933_LIGNE_RSF_345936#340425, MONTANT_345935#340355 AS TARIF_FORFAIT_345933_MONTANT_345935#340426, TRIGRAMME_345939#340356 AS TARIF_FORFAIT_345933_TRIGRAMME_345939#340427]
(37) Project
Arguments: [cast(TARIF_FORFAIT_345933_CODE_ACTE_345934#340422 as string) AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#340440, cast(TARIF_FORFAIT_345933_MONTANT_345935#340426 as string) AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#340441, cast(TARIF_FORFAIT_345933_LIGNE_RSF_345936#340425 as string) AS COL_C519DD82_4508_4154_B389_405B16413D09#340442, cast(TARIF_FORFAIT_345933_DATE_EFFET_345937#340423 as string) AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#340443, cast(TARIF_FORFAIT_345933_DATE_REVOCATION_345938#340424 as string) AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#340444, cast(TARIF_FORFAIT_345933_TRIGRAMME_345939#340427 as string) AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#340445]
(38) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#340440 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#340452, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#340441 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#340453, COL_C519DD82_4508_4154_B389_405B16413D09#340442 AS COL_C519DD82_4508_4154_B389_405B16413D09#340454, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#340443 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#340455, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#340444 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#340456, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#340445 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#340457]
(39) LogicalRelation
Arguments: csv, [finess_dataapps#340386, region-tarif#340387, login-user#340388], false
(40) Project
Arguments: [finess_dataapps#340386, region-tarif#340387, login-user#340388, cast(null as string) AS login_user#340392]
(41) Project
Arguments: [finess_dataapps#340386, region-tarif#340387, login_user#340392]
(42) Project
Arguments: [finess_dataapps#340386 AS finess_dataapps#340401, region-tarif#340387 AS region-tarif#340402, login_user#340392 AS login_user#340403]
(43) Project
Arguments: [finess_dataapps#340401, region-tarif#340402, login_user#340403]
(44) Project
Arguments: [finess_dataapps#340401 AS INFO_ETAB_FINES_345944#340410, region-tarif#340402 AS REGION_TARIF_345945#340411]
(45) Project
Arguments: [INFO_ETAB_FINES_345944#340410, REGION_TARIF_345945#340411]
(46) View
Arguments: `INFO_DATAAPPS_345943170`, true
(47) SubqueryAlias
Arguments: INFO_DATAAPPS_345943170
(48) Project
Arguments: [INFO_ETAB_FINES_345944#340410 AS INFO_DATAAPPS_345943_INFO_ETAB_FINES_345944#340466, REGION_TARIF_345945#340411 AS INFO_DATAAPPS_345943_REGION_TARIF_345945#340467]
(49) Join
Arguments: Cross
(50) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#340452, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#340453, COL_C519DD82_4508_4154_B389_405B16413D09#340454, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#340455, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#340456, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#340457, INFO_DATAAPPS_345943_REGION_TARIF_345945#340467 AS COL_ABDEDC13_3840_48F7_A962_159F725BF772#340478]
(51) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#340452, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#340453, COL_C519DD82_4508_4154_B389_405B16413D09#340454, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#340455, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#340456, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#340457, COL_ABDEDC13_3840_48F7_A962_159F725BF772#340478, str_replace(COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#340453, cast(. as string), cast(, as string)) AS COL_6AE58BB6_C7FC_4F54_9502_66AD374805CD#340486]
(52) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#340452 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#340495, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#340453 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#340496, COL_C519DD82_4508_4154_B389_405B16413D09#340454 AS COL_C519DD82_4508_4154_B389_405B16413D09#340497, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#340455 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#340498, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#340456 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#340499, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#340457 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#340500, COL_ABDEDC13_3840_48F7_A962_159F725BF772#340478 AS COL_ABDEDC13_3840_48F7_A962_159F725BF772#340501, COL_6AE58BB6_C7FC_4F54_9502_66AD374805CD#340486 AS COL_6AE58BB6_C7FC_4F54_9502_66AD374805CD#340502]
(53) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#340495 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#340511, COL_6AE58BB6_C7FC_4F54_9502_66AD374805CD#340502 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#340512, COL_C519DD82_4508_4154_B389_405B16413D09#340497 AS COL_C519DD82_4508_4154_B389_405B16413D09#340513, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#340498 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#340514, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#340499 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#340515, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#340500 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#340516, COL_ABDEDC13_3840_48F7_A962_159F725BF772#340501 AS COL_ABDEDC13_3840_48F7_A962_159F725BF772#340517, COL_6AE58BB6_C7FC_4F54_9502_66AD374805CD#340502 AS COL_6AE58BB6_C7FC_4F54_9502_66AD374805CD#340518]
(54) Filter
Arguments: (COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#340516 <=> COL_ABDEDC13_3840_48F7_A962_159F725BF772#340517)
(55) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#340511 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#340527, str_to_dec(COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#340512, ##,##) AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#340528, str_to_datez(COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#340514, dd/MM/yyyy, Europe/Paris, fr_FR) AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#340529, str_to_datez(COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#340515, dd/MM/yyyy, Europe/Paris, fr_FR) AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#340530, COL_C519DD82_4508_4154_B389_405B16413D09#340513 AS COL_C519DD82_4508_4154_B389_405B16413D09#340531, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#340516 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#340532, COL_ABDEDC13_3840_48F7_A962_159F725BF772#340517 AS COL_ABDEDC13_3840_48F7_A962_159F725BF772#340533]
(56) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#340527 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#340541, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#340528 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#340542, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#340529 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#340543, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#340530 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#340544, COL_C519DD82_4508_4154_B389_405B16413D09#340531 AS COL_C519DD82_4508_4154_B389_405B16413D09#340545, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#340532 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#340546, COL_ABDEDC13_3840_48F7_A962_159F725BF772#340533 AS COL_ABDEDC13_3840_48F7_A962_159F725BF772#340547]
(57) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#340541 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#340555, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#340542 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#340556, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#340543 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#340557, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#340544 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#340558, COL_C519DD82_4508_4154_B389_405B16413D09#340545 AS COL_C519DD82_4508_4154_B389_405B16413D09#340559, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#340546 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#340560, COL_ABDEDC13_3840_48F7_A962_159F725BF772#340547 AS COL_ABDEDC13_3840_48F7_A962_159F725BF772#340561]