qubaCHxL

1CREATE EXTERNAL TABLE IF NOT EXISTS nasa_logs (
2Source STRING,
3datefield STRING,
4Request STRING,
5Status STRING
6)
7ROW FORMAT SERDE "org.apache.hadoop.hive.serde2.RegexSerDe"
8WITH SERDEPROPERTIES(
9'input.regex'='^([^ ]*) - - \\[([^ ]*[\\d]{4})[^ ]* [^ ]* \"([^ ]* [^ ]*) [^ ]* ([\\d]{3}) [^ ]*$',
10"output.format.string" = "%1$s %2$s %3$s %4$s")
11LOCATION
12  's3://emrdemo100/input'
13;