1,修改/etc/profile文件
export PATH=/usr/local/mysql/bin:$PATH
export PATH=/opt/cloudera/parcels/CDH-5.0.0-1.cdh5.0.0.p0.47/lib/sqoop/bin:$PATH
2,使用sqoop:
将mysql-connector-java-5.1.16-bin.jar文件复制到$SQOOP_HOME/lib文件夹下
3,列出mysql数据库中的所有数据库命令
sqoop list-databases --connect jdbc:mysql://localhost:3306/ --username bigdata --password testqaz
DROP TABLE IF EXISTS error;
CREATE TABLE error(
id int(11) auto_increment not null primary key,
appkey varchar(20),
sessionid varchar(20) ,
isvalidstart varchar(20),
serialnumber int,
strategy varchar(20),
issessionstop boolean,
sessionduration int ,
clienttime varchar(20) ,
iscaught boolean ,
exceptionname varchar(20) ,
customexceptionname varchar(20) ,
stack varchar(20)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
数据导出命令:
sqoop export --connect jdbc:mysql://10.200.200.56:3306/mdlog?autoReconnect=true --username bigdata --password testqaz --table error --export-dir hdfs:///user/hive/mdlog/mderror;
数据导入命令: