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