Thank you Knut! Jarcec
On Fri, Feb 07, 2014 at 01:56:10PM +0100, Knut Nordin wrote: > 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*
signature.asc
Description: Digital signature
