Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Sqoop >> mail # user >> Sqoop export failed: Incorrect syntax near ','


Copy link to this message
-
Re: Sqoop export failed: Incorrect syntax near ','
Hi Chun-fan,
thank you very much for sharing the log with us. You are using Microsoft SQL Connector because you're downloaded manually from Microsoft web pages and you can also confirm that by following log lines:

> 12/12/05 12:08:57 DEBUG sqoop.ConnFactory: Added factory
> com.microsoft.sqoop.SqlServer.MSSQLServerManagerFactory specified by
> /usr/local/sqoop/conf/managers.d/mssqoop-sqlserver
...
> 12/12/05 12:08:57 DEBUG sqoop.ConnFactory: Instantiated ConnManager
> com.microsoft.sqoop.SqlServer.MSSQLServerManager@736921fd

I'm not sure what is going wrong as it seems that the data were parsed correctly, but submitting the query to SQL server will fail. As a next step I would recommend turning Microsoft Connector off and using build-in one instead to see if the issue is specific to Sqoop or the Connector. You can do that by temporarily moving file /usr/local/sqoop/conf/managers.d/mssqoop-sqlserver somewhere else.

Jarcec

On Wed, Dec 05, 2012 at 12:25:24PM +0800, Chun-fan Ivan Liao wrote:
> Thank you, Jarcec. I'm not sure which connector we use. I've downloaded
> "Microsoft SQL Server Connector for Apache Hadoop" from
> http://www.microsoft.com/en-us/download/details.aspx?id=27584, but I didn't
> remember if we really used that. How to make sure?
>
> And here is the verbose log:
>
> ==========> 12/12/05 12:08:57 DEBUG tool.BaseSqoopTool: Enabled debug logging.
> 12/12/05 12:08:57 DEBUG sqoop.ConnFactory: Added factory
> com.microsoft.sqoop.SqlServer.MSSQLServerManagerFactory specified by
> /usr/local/sqoop/conf/managers.d/mssqoop-sqlserver
> 12/12/05 12:08:57 DEBUG sqoop.ConnFactory: Loaded manager factory:
> com.microsoft.sqoop.SqlServer.MSSQLServerManagerFactory
> 12/12/05 12:08:57 DEBUG sqoop.ConnFactory: Loaded manager factory:
> com.cloudera.sqoop.manager.DefaultManagerFactory
> 12/12/05 12:08:57 DEBUG sqoop.ConnFactory: Trying ManagerFactory:
> com.microsoft.sqoop.SqlServer.MSSQLServerManagerFactory
> 12/12/05 12:08:57 INFO SqlServer.MSSQLServerManagerFactory: Using
> Microsoft's SQL Server - Hadoop Connector
> 12/12/05 12:08:57 INFO manager.SqlManager: Using default fetchSize of 1000
> 12/12/05 12:08:57 DEBUG sqoop.ConnFactory: Instantiated ConnManager
> com.microsoft.sqoop.SqlServer.MSSQLServerManager@736921fd
> 12/12/05 12:08:57 INFO tool.CodeGenTool: Beginning code generation
> 12/12/05 12:08:57 DEBUG manager.SqlManager: No connection paramenters
> specified. Using regular API for making connection.
> 12/12/05 12:08:57 DEBUG manager.SqlManager: Using fetchSize for next query:
> 1000
> 12/12/05 12:08:57 INFO manager.SqlManager: Executing SQL statement: SELECT
> TOP 1 * FROM [member_main]
> 12/12/05 12:08:57 DEBUG manager.SqlManager: Using fetchSize for next query:
> 1000
> 12/12/05 12:08:57 INFO manager.SqlManager: Executing SQL statement: SELECT
> TOP 1 * FROM [member_main]
> 12/12/05 12:08:57 DEBUG orm.ClassWriter: selected columns:
> 12/12/05 12:08:57 DEBUG orm.ClassWriter:   MemberId
> 12/12/05 12:08:57 DEBUG orm.ClassWriter:   USERNAME
> 12/12/05 12:08:57 DEBUG orm.ClassWriter:   FirstName
> 12/12/05 12:08:57 DEBUG orm.ClassWriter:   LastName
> 12/12/05 12:08:57 DEBUG orm.ClassWriter:   EmailAddress
> 12/12/05 12:08:57 DEBUG orm.ClassWriter:   Password
> 12/12/05 12:08:57 DEBUG orm.ClassWriter:   Password_E5
> 12/12/05 12:08:57 DEBUG orm.ClassWriter:   Birthday
> 12/12/05 12:08:57 DEBUG orm.ClassWriter:   CompanyName
> 12/12/05 12:08:57 DEBUG orm.ClassWriter:   Gender
> 12/12/05 12:08:57 DEBUG orm.ClassWriter:   Age
> 12/12/05 12:08:57 DEBUG orm.ClassWriter:   Education
> 12/12/05 12:08:57 DEBUG orm.ClassWriter:   Country
> 12/12/05 12:08:57 DEBUG orm.ClassWriter:   Title
> 12/12/05 12:08:57 DEBUG orm.ClassWriter:   Phone1
> 12/12/05 12:08:57 DEBUG orm.ClassWriter:   Phone2
> 12/12/05 12:08:57 DEBUG orm.ClassWriter:   Fax
> 12/12/05 12:08:57 DEBUG orm.ClassWriter:   State
> 12/12/05 12:08:57 DEBUG orm.ClassWriter:   City
> 12/12/05 12:08:57 DEBUG orm.ClassWriter:   Address1
> 12/12/05 12:08:57 DEBUG orm.ClassWriter:   Address2