· 9 years ago · Jan 08, 2017, 11:52 AM
1CREATE EXTERNAL TABLE IF NOT EXISTS goduncan.flow_logs (
2 src string,
3 spt int,
4 dst string,
5 dpt string,
6 proto string,
7 start_time string,
8 end_time string,
9 out_bytes string
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'