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 Threaded View
Sqoop >> mail # user >> Import data to HDFS using Sqoop2


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
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