I am trying to create a external table for hdfs files which partitioned with some columns;
But I got an syntax error;
create table web_sales3
(
ws_sold_date_sk integer,
ws_sold_time_sk integer,
ws_ship_date_sk integer,
ws_item_sk integer not null,
ws_bill_customer_sk integer,
ws_bill_cdemo_sk integer,
ws_bill_hdemo_sk integer,
ws_bill_addr_sk integer,
ws_ship_customer_sk integer,
ws_ship_cdemo_sk integer,
ws_ship_hdemo_sk integer,
ws_ship_addr_sk integer,
ws_web_page_sk integer,
ws_web_site_sk integer,
ws_ship_mode_sk integer,
ws_warehouse_sk integer,
ws_promo_sk integer,
ws_order_number integer not null,
ws_quantity integer,
ws_wholesale_cost decimal(7, 2),
ws_list_price decimal(7, 2),
ws_sales_price decimal(7, 2),
ws_ext_discount_amt decimal(7, 2),
ws_ext_sales_price decimal(7, 2),
ws_ext_wholesale_cost decimal(7, 2),
ws_ext_list_price decimal(7, 2),
ws_ext_tax decimal(7, 2),
ws_coupon_amt decimal(7, 2),
ws_ext_ship_cost decimal(7, 2),
ws_net_paid decimal(7, 2),
ws_net_paid_inc_tax decimal(7, 2),
ws_net_paid_inc_ship decimal(7, 2),
ws_net_paid_inc_ship_tax decimal(7, 2),
ws_net_profit decimal(7, 2)
)engine=FILE
PARTITION BY( ws_sold_date_sk integer)
PROPERTIES
(
"path" = "hdfs://7.225.2.179:9000/user/hive/warehouse/perfn_rn.db/web_sales",
"format" = "parquet"
);
the error as following; You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(' at line 38