Hive从HDFS中加载数据

建表

        以手机流量信息为例插入30w行数据

 

create table flow(id string,phonenum string,mac string,ip string,num1 int,num2 int,up int,down int,allflow int) row format delimited fields terminated by "\t";

列名不能与关键字相同

加载数据

 

load data inpath '/hadoop/input/flow.log' into table flow;

1s加载完成

 

查询

 

select * from flow;

 

结果

===============================================