== 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_345998169`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [Code+Acte#274047, Montant#274048, Ligne+RSF#274049, Date_effet#274050, Date_r%C3%A9vocation#274051, Trigramme#274052, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#274053], false
(4) Project
Arguments: [Code+Acte#274047 AS Code Acte#274061, Montant#274048, Ligne+RSF#274049, Date_effet#274050, Date_r%C3%A9vocation#274051, Trigramme#274052, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#274053]
(5) Project
Arguments: [Code Acte#274061, Montant#274048 AS Montant#274070, Ligne+RSF#274049, Date_effet#274050, Date_r%C3%A9vocation#274051, Trigramme#274052, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#274053]
(6) Project
Arguments: [Code Acte#274061, Montant#274070, Ligne+RSF#274049 AS Ligne RSF#274078, Date_effet#274050, Date_r%C3%A9vocation#274051, Trigramme#274052, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#274053]
(7) Project
Arguments: [Code Acte#274061, Montant#274070, Ligne RSF#274078, Date_effet#274050 AS Date_effet#274086, Date_r%C3%A9vocation#274051, Trigramme#274052, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#274053]
(8) Project
Arguments: [Code Acte#274061, Montant#274070, Ligne RSF#274078, Date_effet#274086, Date_r%C3%A9vocation#274051 AS Date_révocation#274094, Trigramme#274052, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#274053]
(9) Project
Arguments: [Code Acte#274061, Montant#274070, Ligne RSF#274078, Date_effet#274086, Date_révocation#274094, Trigramme#274052 AS Trigramme#274102, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#274053]
(10) Project
Arguments: [Code Acte#274061, Montant#274070, Ligne RSF#274078, Date_effet#274086, Date_révocation#274094, Trigramme#274102, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#274053 AS TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#274110]
(11) LogicalRelation
Arguments: parquet, [Code+Acte#274118, Montant#274119, Ligne+RSF#274120, Date_effet#274121, Date_r%C3%A9vocation#274122, Trigramme#274123, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#274124], false
(12) Project
Arguments: [Code+Acte#274118 AS Code Acte#274132, Montant#274119, Ligne+RSF#274120, Date_effet#274121, Date_r%C3%A9vocation#274122, Trigramme#274123, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#274124]
(13) Project
Arguments: [Code Acte#274132, Montant#274119 AS Montant#274141, Ligne+RSF#274120, Date_effet#274121, Date_r%C3%A9vocation#274122, Trigramme#274123, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#274124]
(14) Project
Arguments: [Code Acte#274132, Montant#274141, Ligne+RSF#274120 AS Ligne RSF#274149, Date_effet#274121, Date_r%C3%A9vocation#274122, Trigramme#274123, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#274124]
(15) Project
Arguments: [Code Acte#274132, Montant#274141, Ligne RSF#274149, Date_effet#274121 AS Date_effet#274157, Date_r%C3%A9vocation#274122, Trigramme#274123, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#274124]
(16) Project
Arguments: [Code Acte#274132, Montant#274141, Ligne RSF#274149, Date_effet#274157, Date_r%C3%A9vocation#274122 AS Date_révocation#274165, Trigramme#274123, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#274124]
(17) Project
Arguments: [Code Acte#274132, Montant#274141, Ligne RSF#274149, Date_effet#274157, Date_révocation#274165, Trigramme#274123 AS Trigramme#274173, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#274124]
(18) Project
Arguments: [Code Acte#274132, Montant#274141, Ligne RSF#274149, Date_effet#274157, Date_révocation#274165, Trigramme#274173, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#274124 AS TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#274181]
(19) Project
Arguments: [Code Acte#274132, Montant#274141, Ligne RSF#274149, Date_effet#274157, Date_révocation#274165, Trigramme#274173, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#274181]
(20) LogicalRelation
Arguments: parquet, [Code+Acte#274196, Montant#274197, Ligne+RSF#274198, Date_effet#274199, Date_r%C3%A9vocation#274200, Trigramme#274201, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#274202], false
(21) Project
Arguments: [Code+Acte#274196 AS Code Acte#274210, Montant#274197, Ligne+RSF#274198, Date_effet#274199, Date_r%C3%A9vocation#274200, Trigramme#274201, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#274202]
(22) Project
Arguments: [Code Acte#274210, Montant#274197 AS Montant#274219, Ligne+RSF#274198, Date_effet#274199, Date_r%C3%A9vocation#274200, Trigramme#274201, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#274202]
(23) Project
Arguments: [Code Acte#274210, Montant#274219, Ligne+RSF#274198 AS Ligne RSF#274227, Date_effet#274199, Date_r%C3%A9vocation#274200, Trigramme#274201, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#274202]
(24) Project
Arguments: [Code Acte#274210, Montant#274219, Ligne RSF#274227, Date_effet#274199 AS Date_effet#274235, Date_r%C3%A9vocation#274200, Trigramme#274201, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#274202]
(25) Project
Arguments: [Code Acte#274210, Montant#274219, Ligne RSF#274227, Date_effet#274235, Date_r%C3%A9vocation#274200 AS Date_révocation#274243, Trigramme#274201, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#274202]
(26) Project
Arguments: [Code Acte#274210, Montant#274219, Ligne RSF#274227, Date_effet#274235, Date_révocation#274243, Trigramme#274201 AS Trigramme#274251, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#274202]
(27) Project
Arguments: [Code Acte#274210, Montant#274219, Ligne RSF#274227, Date_effet#274235, Date_révocation#274243, Trigramme#274251, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#274202 AS TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#274259]
(28) Project
Arguments: [Code Acte#274210, Montant#274219, Ligne RSF#274227, Date_effet#274235, Date_révocation#274243, Trigramme#274251, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#274259]
(29) Union
Arguments: false, false
(30) Project
Arguments: [Code Acte#274061 AS Code Acte#274274, Montant#274070 AS Montant#274275, Ligne RSF#274078 AS Ligne RSF#274276, Date_effet#274086 AS Date_effet#274277, Date_révocation#274094 AS Date_révocation#274278, Trigramme#274102 AS Trigramme#274279, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#274110 AS TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#274280]
(31) Project
Arguments: [Code Acte#274274, Montant#274275, Ligne RSF#274276, Date_effet#274277, Date_révocation#274278, Trigramme#274279, TARIF_FORFAIT_S_345912HEADER_COL_DETAIL_DEPOT#274280]
(32) Project
Arguments: [Code Acte#274274 AS CODE_ACTE_345934#274295, Date_effet#274277 AS DATE_EFFET_345937#274296, Date_révocation#274278 AS DATE_REVOCATION_345938#274297, Ligne RSF#274276 AS LIGNE_RSF_345936#274298, Montant#274275 AS MONTANT_345935#274299, Trigramme#274279 AS TRIGRAMME_345939#274300]
(33) Project
Arguments: [CODE_ACTE_345934#274295, DATE_EFFET_345937#274296, DATE_REVOCATION_345938#274297, LIGNE_RSF_345936#274298, MONTANT_345935#274299, TRIGRAMME_345939#274300]
(34) View
Arguments: `TARIF_FORFAIT_345933169`, true
(35) SubqueryAlias
Arguments: TARIF_FORFAIT_345933169
(36) Project
Arguments: [CODE_ACTE_345934#274295 AS TARIF_FORFAIT_345933_CODE_ACTE_345934#274366, DATE_EFFET_345937#274296 AS TARIF_FORFAIT_345933_DATE_EFFET_345937#274367, DATE_REVOCATION_345938#274297 AS TARIF_FORFAIT_345933_DATE_REVOCATION_345938#274368, LIGNE_RSF_345936#274298 AS TARIF_FORFAIT_345933_LIGNE_RSF_345936#274369, MONTANT_345935#274299 AS TARIF_FORFAIT_345933_MONTANT_345935#274370, TRIGRAMME_345939#274300 AS TARIF_FORFAIT_345933_TRIGRAMME_345939#274371]
(37) Project
Arguments: [cast(TARIF_FORFAIT_345933_CODE_ACTE_345934#274366 as string) AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#274384, cast(TARIF_FORFAIT_345933_MONTANT_345935#274370 as string) AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#274385, cast(TARIF_FORFAIT_345933_LIGNE_RSF_345936#274369 as string) AS COL_C519DD82_4508_4154_B389_405B16413D09#274386, cast(TARIF_FORFAIT_345933_DATE_EFFET_345937#274367 as string) AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#274387, cast(TARIF_FORFAIT_345933_DATE_REVOCATION_345938#274368 as string) AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#274388, cast(TARIF_FORFAIT_345933_TRIGRAMME_345939#274371 as string) AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#274389]
(38) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#274384 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#274396, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#274385 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#274397, COL_C519DD82_4508_4154_B389_405B16413D09#274386 AS COL_C519DD82_4508_4154_B389_405B16413D09#274398, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#274387 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#274399, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#274388 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#274400, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#274389 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#274401]
(39) LogicalRelation
Arguments: csv, [finess_dataapps#274330, region-tarif#274331, login-user#274332], false
(40) Project
Arguments: [finess_dataapps#274330, region-tarif#274331, login-user#274332, cast(null as string) AS login_user#274336]
(41) Project
Arguments: [finess_dataapps#274330, region-tarif#274331, login_user#274336]
(42) Project
Arguments: [finess_dataapps#274330 AS finess_dataapps#274345, region-tarif#274331 AS region-tarif#274346, login_user#274336 AS login_user#274347]
(43) Project
Arguments: [finess_dataapps#274345, region-tarif#274346, login_user#274347]
(44) Project
Arguments: [finess_dataapps#274345 AS INFO_ETAB_FINES_345944#274354, region-tarif#274346 AS REGION_TARIF_345945#274355]
(45) Project
Arguments: [INFO_ETAB_FINES_345944#274354, REGION_TARIF_345945#274355]
(46) View
Arguments: `INFO_DATAAPPS_345943169`, true
(47) SubqueryAlias
Arguments: INFO_DATAAPPS_345943169
(48) Project
Arguments: [INFO_ETAB_FINES_345944#274354 AS INFO_DATAAPPS_345943_INFO_ETAB_FINES_345944#274410, REGION_TARIF_345945#274355 AS INFO_DATAAPPS_345943_REGION_TARIF_345945#274411]
(49) Join
Arguments: Cross
(50) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#274396, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#274397, COL_C519DD82_4508_4154_B389_405B16413D09#274398, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#274399, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#274400, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#274401, INFO_DATAAPPS_345943_REGION_TARIF_345945#274411 AS COL_ABDEDC13_3840_48F7_A962_159F725BF772#274422]
(51) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#274396, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#274397, COL_C519DD82_4508_4154_B389_405B16413D09#274398, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#274399, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#274400, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#274401, COL_ABDEDC13_3840_48F7_A962_159F725BF772#274422, str_replace(COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#274397, cast(. as string), cast(, as string)) AS COL_6AE58BB6_C7FC_4F54_9502_66AD374805CD#274430]
(52) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#274396 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#274439, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#274397 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#274440, COL_C519DD82_4508_4154_B389_405B16413D09#274398 AS COL_C519DD82_4508_4154_B389_405B16413D09#274441, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#274399 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#274442, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#274400 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#274443, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#274401 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#274444, COL_ABDEDC13_3840_48F7_A962_159F725BF772#274422 AS COL_ABDEDC13_3840_48F7_A962_159F725BF772#274445, COL_6AE58BB6_C7FC_4F54_9502_66AD374805CD#274430 AS COL_6AE58BB6_C7FC_4F54_9502_66AD374805CD#274446]
(53) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#274439 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#274455, COL_6AE58BB6_C7FC_4F54_9502_66AD374805CD#274446 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#274456, COL_C519DD82_4508_4154_B389_405B16413D09#274441 AS COL_C519DD82_4508_4154_B389_405B16413D09#274457, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#274442 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#274458, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#274443 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#274459, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#274444 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#274460, COL_ABDEDC13_3840_48F7_A962_159F725BF772#274445 AS COL_ABDEDC13_3840_48F7_A962_159F725BF772#274461, COL_6AE58BB6_C7FC_4F54_9502_66AD374805CD#274446 AS COL_6AE58BB6_C7FC_4F54_9502_66AD374805CD#274462]
(54) Filter
Arguments: (COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#274460 <=> COL_ABDEDC13_3840_48F7_A962_159F725BF772#274461)
(55) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#274455 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#274471, str_to_dec(COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#274456, ##,##) AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#274472, str_to_datez(COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#274458, dd/MM/yyyy, Europe/Paris, fr_FR) AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#274473, str_to_datez(COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#274459, dd/MM/yyyy, Europe/Paris, fr_FR) AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#274474, COL_C519DD82_4508_4154_B389_405B16413D09#274457 AS COL_C519DD82_4508_4154_B389_405B16413D09#274475, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#274460 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#274476, COL_ABDEDC13_3840_48F7_A962_159F725BF772#274461 AS COL_ABDEDC13_3840_48F7_A962_159F725BF772#274477]
(56) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#274471 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#274485, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#274472 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#274486, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#274473 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#274487, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#274474 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#274488, COL_C519DD82_4508_4154_B389_405B16413D09#274475 AS COL_C519DD82_4508_4154_B389_405B16413D09#274489, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#274476 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#274490, COL_ABDEDC13_3840_48F7_A962_159F725BF772#274477 AS COL_ABDEDC13_3840_48F7_A962_159F725BF772#274491]
(57) Project
Arguments: [COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#274485 AS COL_4FC1702B_D536_486B_A3CD_72A23D2B5BAA#274499, COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#274486 AS COL_4E66942F_BA3B_4E22_B8E1_500F4936FD8C#274500, COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#274487 AS COL_64B392B2_FCA5_4927_9F1A_B44D84ECADE2#274501, COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#274488 AS COL_7F16036B_1AF3_4AA1_9426_8813252C1C63#274502, COL_C519DD82_4508_4154_B389_405B16413D09#274489 AS COL_C519DD82_4508_4154_B389_405B16413D09#274503, COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#274490 AS COL_54DBEBD9_A5A3_4990_8F41_8B1522569AD7#274504, COL_ABDEDC13_3840_48F7_A962_159F725BF772#274491 AS COL_ABDEDC13_3840_48F7_A962_159F725BF772#274505]