[
https://issues.apache.org/jira/browse/SQOOP-2928?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Szabolcs Vasas resolved SQOOP-2928.
-----------------------------------
Resolution: Not A Problem
The database create and upgrade scripts work fine on MySQL you just have to
specify the Database Hostname field in CM the following way:
mysql.server?sessionVariables=sql_mode='ANSI_QUOTES'
> Sqoop2: Fix MySQL repository creation
> -------------------------------------
>
> Key: SQOOP-2928
> URL: https://issues.apache.org/jira/browse/SQOOP-2928
> Project: Sqoop
> Issue Type: Bug
> Affects Versions: 1.99.6
> Reporter: Szabolcs Vasas
> Assignee: Szabolcs Vasas
> Labels: newbie
>
> Currently the MySQL repository creation/update fails with the following error:
> Can't execute query: CREATE DATABASE IF NOT EXISTS"SQOOP"
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 uses the nonstandard ` (backtick) character instead of " to quote
> system identifiers so the database creation command constant has to be fixed.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
