为非结构化数据创建 Hive 表

Question

如何为以下数据创建蜂巢表..？？

3.94.78.5 - 69827    [15/Sep/2013:23:58:36 +0100] "GET /KBDOC-00033.html HTTP/1.0"
19.38.140.62 - 21475 [15/Sep/2013:23:58:34 +0100] "GET /KBDOC-00033.html HTTP/1.0"
19.38.140.62 - 21475 [15/Sep/2013:23:58:34 +0100] "GET /KBDOC-00033.html HTTP/1.0"

Answer 1

我已经得到了上述问题的答案，谢谢

create table weblogs4(id String,sal int,time string,gets String)
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.RegexSerDe'
WITH SERDEPROPERTIES ('input.regex'='^(\S+)\s+\S+\s+(\S+)\s+.(\S+\s+\S+).\s+.(\S+\s+\S+\s+\S+).');