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

Switch to Threaded View
Sqoop, mail # user - Import data to HDFS using Sqoop2


Copy link to this message
-
Re: Import data to HDFS using Sqoop2
Abraham Elmahrek 2013-09-03, 17:46
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