· 7 years ago · Oct 31, 2018, 10:08 AM
1create external table if not exists {{table_name}}(
2 url string,
3 title string,
4 duration int,
5 play_count int,
6 created_time bigint,
7 last_crawl_time bigint
8)
9ROW FORMAT SERDE
10 'org.openx.data.jsonserde.JsonSerDe'
11STORED AS INPUTFORMAT
12 'org.apache.hadoop.mapred.TextInputFormat'
13OUTPUTFORMAT
14 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
15location "{{hdfs_or_s3_location}}";