== Physical Plan ==
Execute CreateViewCommand (1)
+- CreateViewCommand (2)
+- Project (38)
+- SubqueryAlias (37)
+- View (36)
+- Project (35)
+- Project (34)
+- Join (33)
:- Project (23)
: +- Project (22)
: +- Project (21)
: +- Project (20)
: +- Project (19)
: +- Project (18)
: +- Aggregate (17)
: +- Project (16)
: +- Project (15)
: +- Project (14)
: +- Project (13)
: +- Project (12)
: +- Window (11)
: +- Project (10)
: +- Project (9)
: +- Project (8)
: +- Project (7)
: +- Project (6)
: +- SubqueryAlias (5)
: +- View (4)
: +- LogicalRelation (3)
+- Project (32)
+- SubqueryAlias (31)
+- View (30)
+- Project (29)
+- Project (28)
+- Project (27)
+- Project (26)
+- Project (25)
+- LogicalRelation (24)
(1) Execute CreateViewCommand
Output: []
(2) CreateViewCommand
Arguments: `tmp_7630dd40e9d1415a90eb4e4f42a9d81a`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [COL_705D0B7E_8155_46C9_9B93_18623CBF49DC#17150, COL_B142EF3F_71B0_4D92_BD69_8DF6AD3E44B5#17151, COL_978B0DEE_2DCE_4FB2_A6CA_5AE6DD32165A#17152, COL_C4FE0F58_5E2E_492F_84B9_628755FF1880#17153, COL_DB8FC899_BF27_4279_982B_FFCEE338F16A#17154, COL_645FCC28_5790_45EA_B45E_B11B7DFF53D3#17155, COL_5F1A47E4_67BE_41D1_8453_55577AADF4CD#17156, COL_E0C242BC_BB28_44E6_8D21_39E257DD657E#17157, COL_D381351D_FD6E_4CF8_BA68_8BB060F3D0D6#17158, COL_00F78AD4_6820_4C6D_B84B_E4947BB26D30#17159, COL_27B72E15_85A7_4EFE_A0E3_7BB54B13D5B8#17160, COL_A732B6FB_2C04_410B_9FF1_9CDD88B628D8#17161, COL_2D4DC0DD_0A65_45DC_9D91_2673F383225A#17162, COL_FE68E565_24DB_43F9_817B_1FA126D27DE3#17163, COL_5F9E2981_E99A_41D8_B0DE_E1EF460812B1#17164, COL_9E3657C5_CBB1_42B3_B7DF_5798933B093D#17165, COL_897BC460_A0CF_4B30_917D_F05F23819D91#17166, COL_A930901B_ABB4_4551_8D40_E801C71AED97#17167, COL_17E4FF08_BE9B_4830_86CA_127525EAF8A9#17168, COL_A3CF83E8_BEC0_4F20_B46C_4643C25DE1C5#17169, COL_B73A24BB_1DA4_44AE_B61B_E77FD59D7457#17170, COL_597BFCA5_D746_476F_9730_F7814A501193#17171, COL_774E47A9_EF1A_40D2_8A1F_1422B4B5F473#17172, COL_7B76CEE0_7D73_4BC7_99FA_2D8CEEA85715#17173, ... 9 more fields], false
(4) View
Arguments: `SALES_AND_MORE__185817180`, true
(5) SubqueryAlias
Arguments: SALES_AND_MORE__185817180
(6) Project
Arguments: [COL_705D0B7E_8155_46C9_9B93_18623CBF49DC#17150 AS SALES_AND_MORE__185817_COL_705D0B7E_8155_46C9_9B93_18623CBF49DC#17249, COL_B142EF3F_71B0_4D92_BD69_8DF6AD3E44B5#17151 AS SALES_AND_MORE__185817_COL_B142EF3F_71B0_4D92_BD69_8DF6AD3E44B5#17250, COL_978B0DEE_2DCE_4FB2_A6CA_5AE6DD32165A#17152 AS SALES_AND_MORE__185817_COL_978B0DEE_2DCE_4FB2_A6CA_5AE6DD32165A#17251, COL_C4FE0F58_5E2E_492F_84B9_628755FF1880#17153 AS SALES_AND_MORE__185817_COL_C4FE0F58_5E2E_492F_84B9_628755FF1880#17252, COL_DB8FC899_BF27_4279_982B_FFCEE338F16A#17154 AS SALES_AND_MORE__185817_COL_DB8FC899_BF27_4279_982B_FFCEE338F16A#17253, COL_645FCC28_5790_45EA_B45E_B11B7DFF53D3#17155 AS SALES_AND_MORE__185817_COL_645FCC28_5790_45EA_B45E_B11B7DFF53D3#17254, COL_5F1A47E4_67BE_41D1_8453_55577AADF4CD#17156 AS SALES_AND_MORE__185817_COL_5F1A47E4_67BE_41D1_8453_55577AADF4CD#17255, COL_E0C242BC_BB28_44E6_8D21_39E257DD657E#17157 AS SALES_AND_MORE__185817_COL_E0C242BC_BB28_44E6_8D21_39E257DD657E#17256, COL_D381351D_FD6E_4CF8_BA68_8BB060F3D0D6#17158 AS SALES_AND_MORE__185817_COL_D381351D_FD6E_4CF8_BA68_8BB060F3D0D6#17257, COL_00F78AD4_6820_4C6D_B84B_E4947BB26D30#17159 AS SALES_AND_MORE__185817_COL_00F78AD4_6820_4C6D_B84B_E4947BB26D30#17258, COL_27B72E15_85A7_4EFE_A0E3_7BB54B13D5B8#17160 AS SALES_AND_MORE__185817_COL_27B72E15_85A7_4EFE_A0E3_7BB54B13D5B8#17259, COL_A732B6FB_2C04_410B_9FF1_9CDD88B628D8#17161 AS SALES_AND_MORE__185817_COL_A732B6FB_2C04_410B_9FF1_9CDD88B628D8#17260, COL_2D4DC0DD_0A65_45DC_9D91_2673F383225A#17162 AS SALES_AND_MORE__185817_COL_2D4DC0DD_0A65_45DC_9D91_2673F383225A#17261, COL_FE68E565_24DB_43F9_817B_1FA126D27DE3#17163 AS SALES_AND_MORE__185817_COL_FE68E565_24DB_43F9_817B_1FA126D27DE3#17262, COL_5F9E2981_E99A_41D8_B0DE_E1EF460812B1#17164 AS SALES_AND_MORE__185817_COL_5F9E2981_E99A_41D8_B0DE_E1EF460812B1#17263, COL_9E3657C5_CBB1_42B3_B7DF_5798933B093D#17165 AS SALES_AND_MORE__185817_COL_9E3657C5_CBB1_42B3_B7DF_5798933B093D#17264, COL_897BC460_A0CF_4B30_917D_F05F23819D91#17166 AS SALES_AND_MORE__185817_COL_897BC460_A0CF_4B30_917D_F05F23819D91#17265, COL_A930901B_ABB4_4551_8D40_E801C71AED97#17167 AS SALES_AND_MORE__185817_COL_A930901B_ABB4_4551_8D40_E801C71AED97#17266, COL_17E4FF08_BE9B_4830_86CA_127525EAF8A9#17168 AS SALES_AND_MORE__185817_COL_17E4FF08_BE9B_4830_86CA_127525EAF8A9#17267, COL_A3CF83E8_BEC0_4F20_B46C_4643C25DE1C5#17169 AS SALES_AND_MORE__185817_COL_A3CF83E8_BEC0_4F20_B46C_4643C25DE1C5#17268, COL_B73A24BB_1DA4_44AE_B61B_E77FD59D7457#17170 AS SALES_AND_MORE__185817_COL_B73A24BB_1DA4_44AE_B61B_E77FD59D7457#17269, COL_597BFCA5_D746_476F_9730_F7814A501193#17171 AS SALES_AND_MORE__185817_COL_597BFCA5_D746_476F_9730_F7814A501193#17270, COL_774E47A9_EF1A_40D2_8A1F_1422B4B5F473#17172 AS SALES_AND_MORE__185817_COL_774E47A9_EF1A_40D2_8A1F_1422B4B5F473#17271, COL_7B76CEE0_7D73_4BC7_99FA_2D8CEEA85715#17173 AS SALES_AND_MORE__185817_COL_7B76CEE0_7D73_4BC7_99FA_2D8CEEA85715#17272, ... 9 more fields]
(7) Project
Arguments: [cast(SALES_AND_MORE__185817_COL_705D0B7E_8155_46C9_9B93_18623CBF49DC#17249 as string) AS COL_7144344F_2F01_4673_88B7_1F67EB23F4BC#17318, cast(SALES_AND_MORE__185817_COL_645FCC28_5790_45EA_B45E_B11B7DFF53D3#17254 as string) AS COL_B3733E6D_704D_4E25_899C_8F91D38D81B2#17319, cast(SALES_AND_MORE__185817_COL_A732B6FB_2C04_410B_9FF1_9CDD88B628D8#17260 as timestamp) AS COL_40227A98_4CD7_4E32_8A5D_7044A3C76FCA#17320]
(8) Project
Arguments: [COL_7144344F_2F01_4673_88B7_1F67EB23F4BC#17318 AS COL_7144344F_2F01_4673_88B7_1F67EB23F4BC#17324, COL_B3733E6D_704D_4E25_899C_8F91D38D81B2#17319 AS COL_B3733E6D_704D_4E25_899C_8F91D38D81B2#17325, COL_40227A98_4CD7_4E32_8A5D_7044A3C76FCA#17320 AS COL_40227A98_4CD7_4E32_8A5D_7044A3C76FCA#17326]
(9) Project
Arguments: [COL_7144344F_2F01_4673_88B7_1F67EB23F4BC#17324, COL_B3733E6D_704D_4E25_899C_8F91D38D81B2#17325, COL_40227A98_4CD7_4E32_8A5D_7044A3C76FCA#17326, 1 AS CONST#17331]
(10) Project
Arguments: [COL_7144344F_2F01_4673_88B7_1F67EB23F4BC#17324, COL_B3733E6D_704D_4E25_899C_8F91D38D81B2#17325, COL_40227A98_4CD7_4E32_8A5D_7044A3C76FCA#17326, CONST#17331]
(11) Window
Arguments: [count(COL_7144344F_2F01_4673_88B7_1F67EB23F4BC#17324) windowspecdefinition(COL_B3733E6D_704D_4E25_899C_8F91D38D81B2#17325, CONST#17331 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_5936F214_0A5E_4CDF_9711_9FF261957CDB#17338L], [COL_B3733E6D_704D_4E25_899C_8F91D38D81B2#17325], [CONST#17331 DESC NULLS LAST]
(12) Project
Arguments: [COL_7144344F_2F01_4673_88B7_1F67EB23F4BC#17324, COL_B3733E6D_704D_4E25_899C_8F91D38D81B2#17325, COL_40227A98_4CD7_4E32_8A5D_7044A3C76FCA#17326, CONST#17331, COL_5936F214_0A5E_4CDF_9711_9FF261957CDB#17338L, COL_5936F214_0A5E_4CDF_9711_9FF261957CDB#17338L]
(13) Project
Arguments: [COL_7144344F_2F01_4673_88B7_1F67EB23F4BC#17324, COL_B3733E6D_704D_4E25_899C_8F91D38D81B2#17325, COL_40227A98_4CD7_4E32_8A5D_7044A3C76FCA#17326, CONST#17331, COL_5936F214_0A5E_4CDF_9711_9FF261957CDB#17338L]
(14) Project
Arguments: [COL_7144344F_2F01_4673_88B7_1F67EB23F4BC#17324, COL_B3733E6D_704D_4E25_899C_8F91D38D81B2#17325, COL_40227A98_4CD7_4E32_8A5D_7044A3C76FCA#17326, COL_5936F214_0A5E_4CDF_9711_9FF261957CDB#17338L]
(15) Project
Arguments: [COL_7144344F_2F01_4673_88B7_1F67EB23F4BC#17324 AS COL_7144344F_2F01_4673_88B7_1F67EB23F4BC#17348, COL_B3733E6D_704D_4E25_899C_8F91D38D81B2#17325 AS COL_B3733E6D_704D_4E25_899C_8F91D38D81B2#17349, COL_40227A98_4CD7_4E32_8A5D_7044A3C76FCA#17326 AS COL_40227A98_4CD7_4E32_8A5D_7044A3C76FCA#17350, COL_5936F214_0A5E_4CDF_9711_9FF261957CDB#17338L AS COL_5936F214_0A5E_4CDF_9711_9FF261957CDB#17351L]
(16) Project
Arguments: [COL_7144344F_2F01_4673_88B7_1F67EB23F4BC#17348 AS COL_7144344F_2F01_4673_88B7_1F67EB23F4BC#17356, COL_B3733E6D_704D_4E25_899C_8F91D38D81B2#17349 AS COL_B3733E6D_704D_4E25_899C_8F91D38D81B2#17357, COL_40227A98_4CD7_4E32_8A5D_7044A3C76FCA#17350 AS COL_40227A98_4CD7_4E32_8A5D_7044A3C76FCA#17358, COL_5936F214_0A5E_4CDF_9711_9FF261957CDB#17351L AS COL_5936F214_0A5E_4CDF_9711_9FF261957CDB#17359L]
(17) Aggregate
Arguments: [COL_B3733E6D_704D_4E25_899C_8F91D38D81B2#17357, COL_7144344F_2F01_4673_88B7_1F67EB23F4BC#17356], [COL_B3733E6D_704D_4E25_899C_8F91D38D81B2#17357 AS COL_42AE0C18_6D08_4097_A55F_6FBD1A219F27#17364, COL_7144344F_2F01_4673_88B7_1F67EB23F4BC#17356 AS COL_5A1F5317_E9FB_4023_83DA_81CBB75ED88F#17365, 1 AS NULL_1#17375, max(COL_5936F214_0A5E_4CDF_9711_9FF261957CDB#17359L) AS COL_8FE81702_6A12_4158_BF24_DAAC2651F008#17371L, count(1) AS COL_F6D1C58F_AE89_4DE9_9E24_E3CA7DA858AE#17374L]
(18) Project
Arguments: [COL_42AE0C18_6D08_4097_A55F_6FBD1A219F27#17364, COL_5A1F5317_E9FB_4023_83DA_81CBB75ED88F#17365, COL_8FE81702_6A12_4158_BF24_DAAC2651F008#17371L, COL_F6D1C58F_AE89_4DE9_9E24_E3CA7DA858AE#17374L]
(19) Project
Arguments: [COL_42AE0C18_6D08_4097_A55F_6FBD1A219F27#17364 AS COL_42AE0C18_6D08_4097_A55F_6FBD1A219F27#17385, COL_5A1F5317_E9FB_4023_83DA_81CBB75ED88F#17365 AS COL_5A1F5317_E9FB_4023_83DA_81CBB75ED88F#17386, COL_8FE81702_6A12_4158_BF24_DAAC2651F008#17371L AS COL_8FE81702_6A12_4158_BF24_DAAC2651F008#17387L, COL_F6D1C58F_AE89_4DE9_9E24_E3CA7DA858AE#17374L AS COL_F6D1C58F_AE89_4DE9_9E24_E3CA7DA858AE#17388L]
(20) Project
Arguments: [COL_42AE0C18_6D08_4097_A55F_6FBD1A219F27#17385 AS COL_42AE0C18_6D08_4097_A55F_6FBD1A219F27#17393, COL_5A1F5317_E9FB_4023_83DA_81CBB75ED88F#17386 AS COL_5A1F5317_E9FB_4023_83DA_81CBB75ED88F#17394, COL_8FE81702_6A12_4158_BF24_DAAC2651F008#17387L AS COL_8FE81702_6A12_4158_BF24_DAAC2651F008#17395L, COL_F6D1C58F_AE89_4DE9_9E24_E3CA7DA858AE#17388L AS COL_F6D1C58F_AE89_4DE9_9E24_E3CA7DA858AE#17396L]
(21) Project
Arguments: [COL_42AE0C18_6D08_4097_A55F_6FBD1A219F27#17393, COL_5A1F5317_E9FB_4023_83DA_81CBB75ED88F#17394, COL_8FE81702_6A12_4158_BF24_DAAC2651F008#17395L, COL_F6D1C58F_AE89_4DE9_9E24_E3CA7DA858AE#17396L, dec_mult(array(dec_div(array(COL_F6D1C58F_AE89_4DE9_9E24_E3CA7DA858AE#17396L, COL_8FE81702_6A12_4158_BF24_DAAC2651F008#17395L)), cast(5 as double))) AS COL_CFAA4AB9_CDC7_4934_B862_0EB2E4AC1399#17401]
(22) Project
Arguments: [COL_42AE0C18_6D08_4097_A55F_6FBD1A219F27#17393 AS COL_42AE0C18_6D08_4097_A55F_6FBD1A219F27#17407, COL_5A1F5317_E9FB_4023_83DA_81CBB75ED88F#17394 AS COL_5A1F5317_E9FB_4023_83DA_81CBB75ED88F#17408, COL_CFAA4AB9_CDC7_4934_B862_0EB2E4AC1399#17401 AS COL_CFAA4AB9_CDC7_4934_B862_0EB2E4AC1399#17409]
(23) Project
Arguments: [COL_42AE0C18_6D08_4097_A55F_6FBD1A219F27#17407 AS COL_42AE0C18_6D08_4097_A55F_6FBD1A219F27#17413, COL_5A1F5317_E9FB_4023_83DA_81CBB75ED88F#17408 AS COL_5A1F5317_E9FB_4023_83DA_81CBB75ED88F#17414, COL_CFAA4AB9_CDC7_4934_B862_0EB2E4AC1399#17409 AS COL_CFAA4AB9_CDC7_4934_B862_0EB2E4AC1399#17415]
(24) LogicalRelation
Arguments: JDBCRelation((SELECT "Produit_ID", "Categorie_Products_ref", "Type_Products_ref", "Prix_unitaire", "Prix_revient", "Date_Maj" FROM "naos_ref"."naos_products_catalogue") as x) [numPartitions=1], [Produit_ID#17088, Categorie_Products_ref#17089, Type_Products_ref#17090, Prix_unitaire#17091, Prix_revient#17092, Date_Maj#17093], false
(25) Project
Arguments: [Produit_ID#17088 AS COLL0#17100, Categorie_Products_ref#17089 AS COLL1#17101, Type_Products_ref#17090 AS COLL2#17102, Prix_unitaire#17091 AS COLL3#17103, Prix_revient#17092 AS COLL4#17104, Date_Maj#17093 AS COLL5#17105]
(26) Project
Arguments: [COLL0#17100 AS COLL0#17112, COLL1#17101 AS COLL1#17113, COLL2#17102 AS COLL2#17114, COLL3#17103 AS COLL3#17115, COLL4#17104 AS COLL4#17116, COLL5#17105 AS COLL5#17117]
(27) Project
Arguments: [COLL0#17112, COLL1#17113, COLL2#17114, COLL3#17115, COLL4#17116, COLL5#17117]
(28) Project
Arguments: [COLL1#17113 AS CATEGORIE_PRODU_185811#17130, COLL5#17117 AS DATE_MAJ_185815#17131, COLL4#17116 AS PRIX_REVIENT_185814#17132, COLL3#17115 AS PRIX_UNITAIRE_185813#17133, COLL0#17112 AS PRODUIT_ID_185810#17134, COLL2#17114 AS TYPE_PRODUCTS_R_185812#17135]
(29) Project
Arguments: [CATEGORIE_PRODU_185811#17130, DATE_MAJ_185815#17131, PRIX_REVIENT_185814#17132, PRIX_UNITAIRE_185813#17133, PRODUIT_ID_185810#17134, TYPE_PRODUCTS_R_185812#17135, str_remove(TYPE_PRODUCTS_R_185812#17135, cast(G_ as string)) AS TEST_225188#17142]
(30) View
Arguments: `NAOS_PRODUCTS_C_185809180`, true
(31) SubqueryAlias
Arguments: NAOS_PRODUCTS_C_185809180
(32) Project
Arguments: [CATEGORIE_PRODU_185811#17130 AS NAOS_PRODUCTS_C_185809_CATEGORIE_PRODU_185811#17426, DATE_MAJ_185815#17131 AS NAOS_PRODUCTS_C_185809_DATE_MAJ_185815#17427, PRIX_REVIENT_185814#17132 AS NAOS_PRODUCTS_C_185809_PRIX_REVIENT_185814#17428, PRIX_UNITAIRE_185813#17133 AS NAOS_PRODUCTS_C_185809_PRIX_UNITAIRE_185813#17429, PRODUIT_ID_185810#17134 AS NAOS_PRODUCTS_C_185809_PRODUIT_ID_185810#17430, TYPE_PRODUCTS_R_185812#17135 AS NAOS_PRODUCTS_C_185809_TYPE_PRODUCTS_R_185812#17431, TEST_225188#17142 AS NAOS_PRODUCTS_C_185809_TEST_225188#17432]
(33) Join
Arguments: LeftOuter, (COL_5A1F5317_E9FB_4023_83DA_81CBB75ED88F#17414 = NAOS_PRODUCTS_C_185809_PRODUIT_ID_185810#17430)
(34) Project
Arguments: [COL_42AE0C18_6D08_4097_A55F_6FBD1A219F27#17413, COL_5A1F5317_E9FB_4023_83DA_81CBB75ED88F#17414, COL_CFAA4AB9_CDC7_4934_B862_0EB2E4AC1399#17415, NAOS_PRODUCTS_C_185809_CATEGORIE_PRODU_185811#17426 AS COL_53C70D87_AC05_4572_9222_6797452476E1#17460, NAOS_PRODUCTS_C_185809_PRIX_UNITAIRE_185813#17429 AS COL_A5417D91_8B16_4EE1_8B98_53227C998F85#17461, NAOS_PRODUCTS_C_185809_PRIX_REVIENT_185814#17428 AS COL_18F8F324_C377_42C0_A36D_24D287703D22#17462]
(35) Project
Arguments: [COL_42AE0C18_6D08_4097_A55F_6FBD1A219F27#17413 AS COL_42AE0C18_6D08_4097_A55F_6FBD1A219F27#17469, COL_5A1F5317_E9FB_4023_83DA_81CBB75ED88F#17414 AS COL_5A1F5317_E9FB_4023_83DA_81CBB75ED88F#17470, COL_CFAA4AB9_CDC7_4934_B862_0EB2E4AC1399#17415 AS COL_CFAA4AB9_CDC7_4934_B862_0EB2E4AC1399#17471, COL_53C70D87_AC05_4572_9222_6797452476E1#17460 AS COL_53C70D87_AC05_4572_9222_6797452476E1#17472, COL_A5417D91_8B16_4EE1_8B98_53227C998F85#17461 AS COL_A5417D91_8B16_4EE1_8B98_53227C998F85#17473, COL_18F8F324_C377_42C0_A36D_24D287703D22#17462 AS COL_18F8F324_C377_42C0_A36D_24D287703D22#17474]
(36) View
Arguments: `PRODUCT_EVALUAT_186578180`, true
(37) SubqueryAlias
Arguments: PRODUCT_EVALUAT_186578180
(38) Project
Arguments: [COL_42AE0C18_6D08_4097_A55F_6FBD1A219F27#17469, COL_5A1F5317_E9FB_4023_83DA_81CBB75ED88F#17470, COL_CFAA4AB9_CDC7_4934_B862_0EB2E4AC1399#17471, COL_53C70D87_AC05_4572_9222_6797452476E1#17472, COL_A5417D91_8B16_4EE1_8B98_53227C998F85#17473, COL_18F8F324_C377_42C0_A36D_24D287703D22#17474]