sqoop2 使用mysql作为元数据库的操作步骤
修改 ../conf/sqoop.properties
org.apache.sqoop.repository.jdbc.handler=org.apache.sqoop.repository.mysql.MySqlRepositoryHandler org.apache.sqoop.repository.jdbc.transaction.isolation=READ_COMMITTED org.apache.sqoop.repository.jdbc.maximum.connections=10 org.apache.sqoop.repository.jdbc.url=jdbc:mysql://192.168.172.103:3306/sqoop2 org.apache.sqoop.repository.jdbc.driver=com.mysql.jdbc.Driver org.apache.sqoop.repository.jdbc.user=root org.apache.sqoop.repository.jdbc.password=123456
对配置的mysql数据库存进行修改
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
Unknown database ‘sqoop2’
确认mysql的sql_mode是否支持 ANSI_QUOTES 如果不支持修改方法
第一、SET GLOBAL sql_mode = ‘ANSI_QUOTES’;
或者:在my.cnf [mysqld]下加入 sql_mode=ANSI_QUOTEScom.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 1000
bytes
修改默认生成的数据库sqoop的编码为latin1
alter database 库名 character set latin1;
select @@session.sql_mode;查看session 级别的