Create New Flow Logs table

create_flow_table.sql

CREATE EXTERNAL TABLE IF NOT EXISTS goduncan.flow_logs (
  src string,
  spt int,
  dst string,
  dpt int,
  proto int,
  start_time bigint,
  end_time bigint,
  out_bytes bigint
)
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
WITH SERDEPROPERTIES (
  'serialization.format' = ',',
  'field.delim' = ',',
  'collection.delim' = 'undefined',
  'mapkey.delim' = 'undefined'
) LOCATION 'your.s3.bucket.com'