You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2016/11/23 07:09:00 UTC
[Issue 127225] New: sqoop2
https://bz.apache.org/ooo/show_bug.cgi?id=127225
Issue ID: 127225
Issue Type: DEFECT
Summary: sqoop2
Product: Base
Version: 4.2.0-dev
Hardware: Other
OS: Linux 64-bit
Status: UNCONFIRMED
Severity: Normal
Priority: P5 (lowest)
Component: help
Assignee: issues@openoffice.apache.org
Reporter: 136605088@qq.com
Target Milestone: ---
Created attachment 85863
--> https://bz.apache.org/ooo/attachment.cgi?id=85863&action=edit
sqoop2,mysql_to_hfss
sqoop version 1.99.7 ,jdk 1.7 hadoop 2.7.1
Caused by: Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
Message:
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 '"sqoop"."test"' at line 1
Stack trace:
at sun.reflect.GeneratedConstructorAccessor77 (null:-1)
at sun.reflect.DelegatingConstructorAccessorImpl
(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor (Constructor.java:526)
at com.mysql.jdbc.Util (Util.java:406)
at com.mysql.jdbc.Util (Util.java:381)
at com.mysql.jdbc.SQLError (SQLError.java:1030)
at com.mysql.jdbc.SQLError (SQLError.java:956)
at com.mysql.jdbc.MysqlIO (MysqlIO.java:3491)
at com.mysql.jdbc.MysqlIO (MysqlIO.java:3423)
at com.mysql.jdbc.MysqlIO (MysqlIO.java:1936)
at com.mysql.jdbc.MysqlIO (MysqlIO.java:2060)
at com.mysql.jdbc.ConnectionImpl (ConnectionImpl.java:2542)
at com.mysql.jdbc.PreparedStatement (PreparedStatement.java:1734)
at com.mysql.jdbc.PreparedStatement (PreparedStatement.java:1885)
at org.apache.sqoop.connector.jdbc.GenericJdbcFromInitializer
(GenericJdbcFromInitializer.java:257)
at org.apache.sqoop.connector.jdbc.GenericJdbcFromInitializer
(GenericJdbcFromInitializer.java:61)
at org.apache.sqoop.connector.jdbc.GenericJdbcFromInitializer
(GenericJdbcFromInitializer.java:47)
at org.apache.sqoop.driver.JobManager$1 (JobManager.java:520)
at org.apache.sqoop.driver.JobManager$1 (JobManager.java:517)
at org.apache.sqoop.utils.ClassUtils (ClassUtils.java:281)
at org.apache.sqoop.driver.JobManager (JobManager.java:516)
at org.apache.sqoop.driver.JobManager (JobManager.java:423)
at org.apache.sqoop.driver.JobManager (JobManager.java:317)
at org.apache.sqoop.handler.JobRequestHandler
(JobRequestHandler.java:353)
at org.apache.sqoop.handler.JobRequestHandler
(JobRequestHandler.java:114)
at org.apache.sqoop.server.v1.JobServlet (JobServlet.java:84)
at org.apache.sqoop.server.SqoopProtocolServlet
(SqoopProtocolServlet.java:81)
at javax.servlet.http.HttpServlet (HttpServlet.java:710)
at javax.servlet.http.HttpServlet (HttpServlet.java:790)
at org.eclipse.jetty.servlet.ServletHolder (ServletHolder.java:808)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain
(ServletHandler.java:1669)
at
org.apache.hadoop.security.authentication.server.AuthenticationFilter
(AuthenticationFilter.java:595)
at
org.apache.hadoop.security.token.delegation.web.DelegationTokenAuthenticationFilter
(DelegationTokenAuthenticationFilter.java:291)
at
org.apache.hadoop.security.authentication.server.AuthenticationFilter
(AuthenticationFilter.java:554)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain
(ServletHandler.java:1652)
at org.eclipse.jetty.servlet.ServletHandler (ServletHandler.java:585)
at org.eclipse.jetty.server.handler.ContextHandler
(ContextHandler.java:1127)
at org.eclipse.jetty.servlet.ServletHandler (ServletHandler.java:515)
at org.eclipse.jetty.server.handler.ContextHandler
(ContextHandler.java:1061)
at org.eclipse.jetty.server.handler.ScopedHandler
(ScopedHandler.java:141)
at org.eclipse.jetty.server.handler.HandlerWrapper
(HandlerWrapper.java:97)
at org.eclipse.jetty.server.Server (Server.java:499)
at org.eclipse.jetty.server.HttpChannel (HttpChannel.java:310)
at org.eclipse.jetty.server.HttpConnection (HttpConnection.java:257)
at org.eclipse.jetty.io.AbstractConnection$2
(AbstractConnection.java:540)
at java.util.concurrent.ThreadPoolExecutor
(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker
(ThreadPoolExecutor.java:615)
at java.lang.Thread (Thread.java:745)
sqoop:000> update job -n cmd
Updating job with name cmd
Please update job:
Name: cmd
Database source
Schema name: sqoop
Table name: test
SQL statement:
Column names:
There are currently 1 values in the list:
proctor=tcp
element#
Partition column:
Partition column nullable:
Boundary query:
Incremental read
Check column:
Last value:
Target configuration
Override null value:
Null value:
File format:
0 : TEXT_FILE
1 : SEQUENCE_FILE
2 : PARQUET_FILE
Choose: 0
Compression codec:
0 : NONE
1 : DEFAULT
2 : DEFLATE
3 : GZIP
4 : BZIP2
5 : LZO
6 : LZ4
7 : SNAPPY
8 : CUSTOM
Choose: 0
Custom codec:
Output directory: hdfs://mycat:9000/home/sqoop
Append mode:
Throttling resources
Extractors: 2
Loaders: 2
Classpath configuration
Extra mapper jars:
There are currently 1 values in the list:
proctor=tcp
element#
Job was successfully updated with status OK
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127225] sqoop2
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127225
Marcus <ma...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |CLOSED
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127225] sqoop2
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127225
Marcus <ma...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |DUPLICATE
--- Comment #1 from Marcus <ma...@apache.org> ---
duplicate
*** This issue has been marked as a duplicate of issue 127224 ***
--
You are receiving this mail because:
You are the assignee for the issue.