建表

以手机流量信息为例插入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;

结果

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