Breaking out the data from bucket logs for Amazon Athena

create.sql

CREATE EXTERNAL TABLE default.bucket_logs (
`bucketowner` string,
  `bucket` string,
  `datetime` string,
  `sourceip` string,
  `requestor_id` string,
   `request_id` string,
  `operation` string,
  `key` string,
  `http_line` string,
  `response_code` string,
  `s3_error` string,
  `bytes_sent` string,
  `object_size` string,
  `total_time` string,
  `turnaround_time` string,
  `referrer` string,
  `user_agent` string,
  `rest` string



)
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.RegexSerDe'
WITH SERDEPROPERTIES (
  'serialization.format' = '1',
  'input.regex' = '([^ ]*) ([^ ]*) ([^\]]*\]) ([^ ]*) ([^ ]*) ([^ ]*) ([^ ]*) ([^ ]*) ("[^"]*") ([^ ]*) ([^ ]*) ([^ ]*) ([^ ]*) ([^ ]*) ([^ ]*) ([^ ]*) ("[^"]*") (.*)'
) LOCATION 's3://my-bucket-log-bucket/logs/'