Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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 ','
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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB