CREATE EXTERNAL TABLE events(product STRING, price FLOAT, dt STRING, category STRING, ip STRING)
partitioned by (year String, month String, date String)
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
WITH SERDEPROPERTIES (
   "separatorChar" = ",",
   "quoteChar"     = '"',
   "escapeChar"    = '"'
)

STORED AS SEQUENCEFILE LOCATION "/events";
alter table events add partition (year=2017, month=05, day=01);