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)
