本文共 1145 字,大约阅读时间需要 3 分钟。
本文隶属于专栏《1000个问题搞定大数据技术体系》,该专栏为笔者原创,引用请注明来源,不足和错误之处请在评论区帮忙指出,谢谢!
本专栏目录结构和参考文献请见
create table t1 (id String, name string)row format SerDe 'org.apache.hadoop.hive.contrib.SerDe2.MultiDelimitSerDe'WITH SERDEPROPERTIES ("field.delim"="##");
1##xiaoming2##xiaowang3##xiaozhang
load data local inpath '/home/hadoop/t1.txt' into table t1;
0: jdbc:hive2://node1:10000> select * from t1;+--------+------------+--+| t1.id | t1.name |+--------+------------+--+| 1 | xiaoming || 2 | xiaowang || 3 | xiaozhang |+--------+------------+--+
create table t2(id int, name string)row format SerDe 'org.apache.hadoop.hive.SerDe2.RegexSerDe' WITH SERDEPROPERTIES ("input.regex" = "^(.*)\\#\\#(.*)$");
1##xiaoming2##xiaowang3##xiaozhang
load data local inpath '/home/hadoop/t1.txt' into table t2;
0: jdbc:hive2://node1:10000> select * from t2;+--------+------------+--+| t2.id | t2.name |+--------+------------+--+| 1 | xiaoming || 2 | xiaowang || 3 | xiaozhang |+--------+------------+--+
转载地址:http://ezgji.baihongyu.com/