You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@sqoop.apache.org by Knut Nordin <kn...@admeta.com> on 2014/02/05 14:53:01 UTC

Table name not quoted in "Maximal id query"

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*

Re: Table name not quoted in "Maximal id query"

Posted by Jarek Jarcec Cecho <ja...@apache.org>.
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 <ja...@apache.org>:
> 
> > 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*

Re: Table name not quoted in "Maximal id query"

Posted by Knut Nordin <kn...@admeta.com>.
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 <ja...@apache.org>:

> 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*

Re: Table name not quoted in "Maximal id query"

Posted by Jarek Jarcec Cecho <ja...@apache.org>.
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*