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 [1]? Please do attach entire stack trace you're getting.
Jarcec Links: 1: https://issues.apache.org/jira/browse/SQOOP On Wed, Feb 05, 2014 at 02:53:01PM +0100, Knut Nordin wrote: > Hi, > > 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. > > Please advise! > > \Knut Nordin > > -- > Best Regards, > > *Knut Nordin* > *Optimisation Team*
signature.asc
Description: Digital signature
