大数据导入数据步骤

先将文件放入虚拟机的/export/data目录下

create database iptest;

use iptest;
//首先创建和文件相对应的表结构
create table data(
                               `ip` string,
                               `Date` string,
                               `day` string,
                               `traffic` string,
                               `type` string,
                               `id` string
)
    ROW format delimited fields terminated by ',' STORED AS TEXTFILE;
//接着将文件内容导入该表(预先将文件放入虚拟机的/export/data目录下)
load data local inpath '/export/data/result.csv' into table data;

接着将hive数据导入mysql即可。