· 6 years ago · Aug 08, 2019, 06:30 PM
1CREATE TABLE IF NOT EXISTS apparel(
2 marketplace string, customer_id string,
3 review_id string, product_id string,
4 product_parent string, product_title string,
5 product_category string, star_rating int,
6 helpful_votes int, total_votes int,
7 vine string, verified_purchase string,
8 review_headline string, review_body string,
9 review_date date)
10ROW FORMAT DELIMITED
11FIELDS TERMINATED BY '\t'
12LINES TERMINATED BY '\n'
13STORED AS TEXTFILE
14TBLPROPERTIES("skip.header.line.count"="1");