以手机流量信息为例插入30w行数据oop
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";
列名不能与关键字相同code
load data inpath '/hadoop/input/flow.log' into table flow;
1s加载完成orm
select * from flow;
===============================================ip