ReUhtyed

1CREATE TABLE IF NOT EXISTS apparel(marketplace string, customer_id string, review_id string, product_id string, product_parent string, product_title string, product_category string, star_rating int, helpful_votes int, total_votes int, vice string, verified_purchases string, review_headline string, review_body string, review_date date)
2ROW FORMAT DELIMITED
3FIELDS TERMINATED BY '\t'
4LINES TERMINATED BY '\n'
5STORED AS TEXTFILE
6TBLPROPERTIES("SKIP.HEADER.LINE.COUNT"="1");