hive中建表并导入数据
create table test(day_id String,sale_nbr String,buy_nbr String,cnt String,round String) ROW format delimited fields terminated by ',' STORED AS TEXTFILE;
②导入数据:load data local inpath '/opt/module/data/0.csv' into table test;
③进入mysql:mysql -uroot -p000000