sqoop2 初始化时 sql语法错误

 

sqoop.properties配置mysql作为元数据库

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://localhost:3306/SQOOP
org.apache.sqoop.repository.jdbc.driver=com.mysql.jdbc.Driver
org.apache.sqoop.repository.jdbc.user=root
org.apache.sqoop.repository.jdbc.password=123456

 

在sqoop2安装过程中出现错误： 

1、Can't execute query: CREATE DATABASE IF NOT EXISTS"SQOOP"

2、Unable to run specified query - CREATE DATABASE IF NOT EXISTS"SQOOP"
3、You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"SQOOP"' at line 1

解决方法：

mysql> drop database if exists sqoop;

mysql> create database sqoop;

mysql> SET GLOBAL sql_mode = ANSI_QUOTES; 

解释：

sql_mode: 定义了MySQL支持的sql语法，对数据的校验等等

select @@sql_mode；查看我们当前数据库的sql_mode；

 

注：mysql每次重启之后，sql_mode会重置，所以可能需要手动设置sql_mode