Absolutely! I have added the jira for it now. https://issues.apache.org/jira/browse/SQOOP-1284
Best regards \Knut Nordin 2014-02-06 Jarek Jarcec Cecho <[email protected]>: > 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* > -- Best Regards, *Knut Nordin* *Optimisation Team*
