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

Switch to Plain View
Sqoop, mail # user - Sqoop export failed: Incorrect syntax near ','


+
Chun-fan Ivan Liao 2012-12-04, 09:51
+
Jarek Jarcec Cecho 2012-12-04, 16:01
Copy link to this message
-
Re: Sqoop export failed: Incorrect syntax near ','
Chun-fan Ivan Liao 2012-12-05, 04:25
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
12/12/05 12:08:57 DEBUG orm.ClassWriter:   ZipCode
12/12/05 12:08:57 DEBUG orm.ClassWriter:   VATID
12/12/05 12:08:57 DEBUG orm.ClassWriter:   Language
12/12/05 12:08:57 DEBUG orm.ClassWriter:   rec_letter
12/12/05 12:08:57 DEBUG orm.ClassWriter:   rec_promotion
12/12/05 12:08:57 DEBUG orm.ClassWriter:   rec_type
12/12/05 12:08:57 DEBUG orm.ClassWriter:   JointSource
12/12/05 12:08:57 DEBUG orm.ClassWriter:   CustomerLevel
12/12/05 12:08:57 DEBUG orm.ClassWriter:   UpdateDate
12/12/05 12:08:57 DEBUG orm.ClassWriter:   CreateDate
12/12/05 12:08:57 DEBUG orm.ClassWriter:   FirstLoginDate
12/12/05 12:08:57 DEBUG orm.ClassWriter:   LastLoginDate
12/12/05 12:08:57 DEBUG orm.ClassWriter:   LastVisit
12/12/05 12:08:57 DEBUG orm.ClassWriter:   isValid
12/12/05 12:08:57 DEBUG orm.ClassWriter:   nJoint
12/12/05 12:08:57 DEBUG orm.ClassWriter:   Upd_SubDate
12/12/05 12:08:57 DEBUG orm.ClassWriter:   UnSub_Type
12/12/05 12:08:57 DEBUG orm.ClassWriter:   CreateDateFloat
12/12/05 12:08:57 DEBUG orm.ClassWriter: Writing source file:
/tmp/sqoop-hadoop/compile/14ce35e69f66546d9d0d41065fac0971/member_main.java
12/12/05 12:08:57 DEBUG orm.ClassWriter: Table name: member_main
12/12/05 12:08:57 DEBUG orm.ClassWriter: Columns: MemberId:4, USERNAME:12,
FirstName:-9, LastName:-9, EmailAddress:12, Password:12, Password_E5:12,
Birthday:93, CompanyName:-9, Gender:12, Age:5, Education:12, Country:5,
Title:-9, Phone1:12, Phone2:12, Fax:12, State:-9, City:-9, Address1:-9,
Address2:-9, ZipCode:12, VATID:12, Language:12, rec_letter:-7,
rec_promotion:-7, rec_type:5, JointSource:12, CustomerLevel:4,
UpdateDate:93, CreateDate:93, FirstLoginDate:93, LastLoginDate:93,
LastVisit:93, isValid:-7, nJoint:4, Upd_SubDate:93, UnSub_Type:4,
CreateDateFloat:8,
12/12/05 12:08:57 DEBUG orm.ClassWriter: sourceFilename is member_main.java
12/12/05 12:08:57 DEBUG orm.CompilationManager: Found existing
/tmp/sqoop-hadoop/compile/14ce35e69f66546d9d0d41065fac0971/
12/12/05 12:08:57 INFO orm.CompilationManager: HADOOP_HOME is
/usr/local/hadoop/libexec/..
12/12/05 12:08:57 DEBUG orm.CompilationManager: Adding source file:
/tmp/sqoop-hadoop/compile/14ce35e69f66546d9d0d41065fac0971/member_main.java
12/12/05 12:08:57 DEBUG orm.CompilationManager: Invoking javac with args:
12/12/05 12:08:57 DEBUG orm.CompilationManager:   -sourcepath
12/12/05 12:08:57 DEBUG orm.CompilationManager:
/tmp/sqoop-hadoop/compile/14ce35e69f66546d9d0d41065fac0971/
12/12/05 12:08:57 DEBUG orm.CompilationManager:   -d
12/12/05 12:08:57 DEBUG orm.CompilationManager:
/tmp/sqoop-hadoop/compile/14ce35e69f66546d9d0d41065fac0971/
12/12/05 12:08:57 DEBUG orm.CompilationManager:   -classpath
12/12/05 12:08:57 DEBUG orm.CompilationManager:
/usr/local/hadoop/libexec/../conf:/usr/lib/jvm/java-6-openjdk-amd64/lib/tools.jar:/usr/local/hadoop/libexec/..:/usr/local/hadoop/libexec/../hadoop-core-1.0.3.jar:/usr/local/hadoop/libexec/../lib/asm-3.2.jar:/usr/local/hadoop/libexec/../lib/aspectjrt-1.6.5.jar:/usr/local/hadoop/libexec/../lib/aspectjtools-1.6.5.jar:/usr/local/hadoop/libexec/../lib/commons-beanutils-1.7.0.jar:/usr/local/hadoop/libexec/../
+
Jarek Jarcec Cecho 2012-12-05, 16:23
+
Ivangelion 2012-12-06, 04:03
+
Jarek Jarcec Cecho 2012-12-06, 16:28
+
Chun-fan Ivan Liao 2012-12-07, 03:19
+
Jarek Jarcec Cecho 2012-12-07, 04:01
+
Chun-fan Ivan Liao 2012-12-07, 07:45
+
Jarek Jarcec Cecho 2012-12-07, 16:02
+
Chun-fan Ivan Liao 2012-12-10, 07:08