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 >> Import data to HDFS using Sqoop2


+
陳彥廷 2013-09-03, 10:03
Copy link to this message
-
Re: Import data to HDFS using Sqoop2
Hey User,

It looks like the schema "invoice" does not exist in your database. Could
you please provide your database schema? Also, "*" is unnecessary when
specifying "Table column names". If you leave it blank it will import all
columns by default.

-Abe
On Tue, Sep 3, 2013 at 3:03 AM, 陳彥廷(Yanting Chen) <[EMAIL PROTECTED]>wrote:

> According to the official guide,
> http://sqoop.apache.org/docs/1.99.2/Sqoop5MinutesDemo.html , I
> successfully created a job.
>
> However, when I executed the command, submission start --jid 1, I got this
> error message: "Exception has occurred during processing command Server has
> returned exception: Exception: java.lang.Throwable Message:
> GENERIC_JDBC_CONNECTOR_0002:Unable to execute the SQL statement"
>
> This is the information of my job.
>
> Database configuration
>
> Schema name: invoice
> Table name: ds_msg_log
> Table SQL statement:
> Table column names: *
> Partition column name:
> Boundary query:
>
> Output configuration
>
> Storage type: HDFS
> Output format: TEXT_FILE
> Output directory: /user/root/ds_msg_log
>
> Throttling resources Extractors: Loaders:
>
> Since there is no information in the official guide talking about how to
> set the values above, does any know anything wrong in my job setting?
>
> This is the log: Stack trace: at
> org.apache.sqoop.connector.jdbc.GenericJdbcExecutor
> (GenericJdbcExecutor.java:59)
> at org.apache.sqoop.connector.jdbc.GenericJdbcImportInitializer
> (GenericJdbcImportInitializer.java:155)
> at org.apache.sqoop.connector.jdbc.GenericJdbcImportInitializer
> (GenericJdbcImportInitializer.java:48)
> at org.apache.sqoop.connector.jdbc.GenericJdbcImportInitializer
> (GenericJdbcImportInitializer.java:37)
> at org.apache.sqoop.framework.FrameworkManager (FrameworkManager.java:447)
> at org.apache.sqoop.handler.SubmissionRequestHandler
> (SubmissionRequestHandler.java:112)
> at org.apache.sqoop.handler.SubmissionRequestHandler
> (SubmissionRequestHandler.java:98)
> at org.apache.sqoop.handler.SubmissionRequestHandler
> (SubmissionRequestHandler.java:68)
> at org.apache.sqoop.server.v1.SubmissionServlet (SubmissionServlet.java:44)
> at org.apache.sqoop.server.SqoopProtocolServlet
> (SqoopProtocolServlet.java:63)
> at javax.servlet.http.HttpServlet (HttpServlet.java:637)
> at javax.servlet.http.HttpServlet (HttpServlet.java:717)
> at org.apache.catalina.core.ApplicationFilterChain
> (ApplicationFilterChain.java:290)
> at org.apache.catalina.core.ApplicationFilterChain
> (ApplicationFilterChain.java:206)
> at org.apache.catalina.core.StandardWrapperValve
> (StandardWrapperValve.java:233)
> at org.apache.catalina.core.StandardContextValve
> (StandardContextValve.java:191)
> at org.apache.catalina.core.StandardHostValve (StandardHostValve.java:127)
> at org.apache.catalina.valves.ErrorReportValve (ErrorReportValve.java:102)
> at org.apache.catalina.core.StandardEngineValve
> (StandardEngineValve.java:109)
> at org.apache.catalina.connector.CoyoteAdapter (CoyoteAdapter.java:293)
> at org.apache.coyote.http11.Http11Processor (Http11Processor.java:859)
> at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler
> (Http11Protocol.java:602)
> at org.apache.tomcat.util.net.JIoEndpoint$Worker (JIoEndpoint.java:489)
> at java.lang.Thread (Thread.java:724)
> Caused by: Exception: java.lang.Throwable Message: ERROR: schema "invoice"
> does not exist Position: 46 Stack trace: at
> org.postgresql.core.v3.QueryExecutorImpl (QueryExecutorImpl.java:2102)
> at org.postgresql.core.v3.QueryExecutorImpl (QueryExecutorImpl.java:1835)
> at org.postgresql.core.v3.QueryExecutorImpl (QueryExecutorImpl.java:257)
> at org.postgresql.jdbc2.AbstractJdbc2Statement
> (AbstractJdbc2Statement.java:500)
> at org.postgresql.jdbc2.AbstractJdbc2Statement
> (AbstractJdbc2Statement.java:374)
> at org.postgresql.jdbc2.AbstractJdbc2Statement
> (AbstractJdbc2Statement.java:254)
> at org.apache.sqoop.connector.jdbc.GenericJdbcExecutor
> (GenericJdbcExecutor.java:56)
> at org.apache.sqoop.connector.jdbc.GenericJdbcImportInitializer
+
陳彥廷 2013-09-04, 01:06
+
Abraham Elmahrek 2013-09-04, 01:23
+
Abraham Elmahrek 2013-09-04, 01:24
+
Yanting Chen 2013-09-04, 01:34
+
Abraham Elmahrek 2013-09-04, 22:11
+
Yanting Chen 2013-09-05, 01:37
+
Mengwei Ding 2013-09-05, 02:17
+
Yanting Chen 2013-09-05, 02:23
+
Mengwei Ding 2013-09-05, 02:32
+
Yanting Chen 2013-09-05, 02:35
+
Abraham Elmahrek 2013-09-05, 02:33
+
Yanting Chen 2013-09-05, 02:36
+
Abraham Elmahrek 2013-09-05, 17:55
+
Yanting Chen 2013-09-06, 01:02
+
Yanting Chen 2013-09-09, 07:18
+
Abraham Elmahrek 2013-09-09, 16:22
+
Yanting Chen 2013-09-10, 09:19
+
Abraham Elmahrek 2013-09-13, 18:09
+
Yanting Chen 2013-09-10, 07:32
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