I am trying to set up an incremental import from a MySQL database using Sqoop 1.4.4. The import works well for most tables, ecxept for one of them which is a bit unfortunately named "order". This name does not seem to cause any issues for most of the queries that Sqoop generates, as it properly quotes the table names. However, when running my saved job for this particular table, I get an error reported with the following message:
INFO tool.ImportTool: Maximal id query for free form incremental import: SELECT MAX(`id`) FROM order ERROR tool.ImportTool: Encountered IOException running import job: java.io.IOException: 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 'order' at line 1
I have tried adding various types of quotes to the table name in my call, but that does not help. Explicitly prefixing the table name with the database name does not work either since some other queries add it automatically.
Hi Knut, thank you very much for reporting the behaviour. It seems to me as something that we might need to fix on Sqoop side. Would you mind filling a JIRA for it ? Please do attach entire stack trace you're getting.