本文介绍了如何使用Hive中的Lateral View特性进行数据处理。通过具体的SQL语句示例，展示了如何创建表、加载数据，并利用Lateral View对数据进行拆分和选择操作。
drop table lateralview;
create table lateralview (col1 string, col2 string)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t';
LOAD DATA LOCAL INPATH '/home/tianzhao/book/lateralview.txt'
OVERWRITE INTO TABLE lateralview;
lateralview.txt 中的数据是
r1 a,b
r2 d,e
select col1, col2 from lateralview;
r1 a,b
r2 d,e
select col1, myCol2
from lateralview
LATERAL VIEW explode(split(col2,',')) myTable1 as myCol2;
r1 a
r1 b
r2 d
r2 e
create table lateralview (col1 string, col2 string)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t';
LOAD DATA LOCAL INPATH '/home/tianzhao/book/lateralview.txt'
OVERWRITE INTO TABLE lateralview;
lateralview.txt 中的数据是
r1 a,b
r2 d,e
select col1, col2 from lateralview;
r1 a,b
r2 d,e
select col1, myCol2
from lateralview
LATERAL VIEW explode(split(col2,',')) myTable1 as myCol2;
r1 a
r1 b
r2 d
r2 e
扫一扫
3348
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
