hive
use trafficdata;
在hive中创建cancelreason表格,并从cancelorder中搜索撤销理由最多的前10种插入到cancelreason表中
create table cancelreason as select cancelreason,count(*) num from cancelorder where cancelreason != '未知' group by cancelreason order by num desc limi10;
查询表格内容如下
复制命令行打开mysql
mysql -h127.0.0.1 -uroot -p123123
创建数据库
create database trafficdata;
use trafficdata;
创建表格
create table cancelreason(cancelreason varchar(255),num int not null);
退出
exit;
sqoop export --connect jdbc:mysql://127.0.0.1:3306/trafficdata --username root --password 123123 --export-dir '/opt/hive/warehouse/trafficdata.db/cancelreason' --table cancelreason --fields-terminated-by '|'
最后导入数据这里,出现了问题,一直导入不成功,报错说是路径的问题,有人可以解决吗?