gistfile1.sql

CREATE EXTERNAL TABLE orders (
    order_id        string,
    item_id         string,
    quantity        int,
    checkout_price  double,
    address_id      string
) PARTITIONED BY (orderDate string)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'
STORED AS TEXTFILE
LOCATION '/tables/orders/us';