· 9 years ago · Jan 08, 2017, 12:38 PM
1CREATE EXTERNAL TABLE IF NOT EXISTS goduncan.flow_logs (
2 src string,
3 spt int,
4 dst string,
5 dpt int,
6 proto int,
7 start_time bigint,
8 end_time bigint,
9 out_bytes bigint
10)
11ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
12WITH SERDEPROPERTIES (
13 'serialization.format' = ',',
14 'field.delim' = ',',
15 'collection.delim' = 'undefined',
16 'mapkey.delim' = 'undefined'
17) LOCATION 'your.s3.bucket.com'