[Sqoop2 error] org.apache.sqoop.connector.jdbc.GeneriCjdbcfrominitializer.confi

question :

Sqoop: 000>

start job -name m2hException has occurred during processing command Exception: org.apache.sqoop.common.SqoopException Message: GENERIC_JDBC_CONNECTOR_0016: Can not fetch schema – d] 2019-06-01 10: 23: 53,689 INFO [org.apache.sqoop .connector.jdbc.GenericJdbcFromInitializer.configurePartitionProperties (GenericJdbcFromInitializer.java:152)] Using partition column: deviceid2019-06-01 10: 23: 53,689 INFO [org.apache.sqoop.connector.jdbc.GenericJdbcFromInitializer.configurePartitionProperties (GenericJdbcFromInitializer.java: 181)] Incremental New Max Value Query: SELECT MAX (“DeviceID”) from “MQH”. “Device” 2019-06-01 10: 23: 53,715 Error [org.apache.sqoop.server.sqoopprotocolServlet.doput (SqoopProtocolServlet. java: 86)] Exception in PUT http: // localhost: 12000 / sqoop / v1 / job / job-m2h / startorg.apache.sqoop.common.SqoopException: GENERIC_JDBC_CONNECTOR_0016: Can not fetch schemaat org.apache.sqoop.connector .jdbc.genericjdbcfrominitializer.initialize (genericjdbcfrominitializer.java: 64) at Org.apache.sqoop.connector.jdb c.GenericJdbcFromInitializer.initialize (GenericJdbcFromInitializer.java:47) at org.apache.sqoop.driver.JobManager $ 1.call (JobManager.java:520) at org.apache.sqoop.driver.JobManager $ 1.call (JobManager.java: 517) at org.apache.sqoop.utils.ClassUtils.executeWithClassLoader (ClassUtils.java:281) at org.apache.sqoop.driver.JobManager.initializeConnector (JobManager.java:516) at org.apache.sqoop.driver.JobManager .createJobRequest (JobManager.java:423) at org.apache.sqoop.driver.JobManager.start (JobManager.java:317) at org.apache.sqoop.handler.JobRequestHandler.startJob (JobRequestHandler.java:353) at org. Apache.sqoop.handler.jobrequestHandler.HandleEvent (JobRequestHandler.java: 114) at Org.apache.sqoop.Server.v1.jobservlet.HandlePutRequest (JobServlet.java:

84) at org.apache.sqoop.server.SqoopProtocolServlet.doPut (SqoopProtocolServlet.java:81) at javax.servlet.http.HttpServlet.service (HttpServlet.java:710) at javax.servlet.http.HttpServlet.service (HttpServlet .java: 790) at org.eclipse.jetty.servlet.ServletHolder.handle (ServletHolder.java:808) at org.eclipse.jetty.servlet.ServletHandler $ CachedChain.doFilter (ServletHandler.java:1669) at org.apache. hadoop.security.authentication.server.AuthenticationFilter.doFilter (AuthenticationFilter.java:574) at org.apache.hadoop.security.token.delegation.web.DelegationTokenAuthenticationFilter.doFilter (DelegationTokenAuthenticationFilter.java:269) at org.apache.hadoop. security.authentication.server.AuthenticationFilter.doFilter (AuthenticationFilter.java:544) at org.eclipse.jetty.servlet.ServletHandler $ CachedChain.doFilter (ServletHandler.java:1652) at org.eclipse.jetty.servlet.ServletHandler.doHandle ( ServletHandler.java:585) ORG.ECLIPSE.JETTY.SERVER.Handler.ContextHandler.doHandle (ContextHandler.java: 1127) AT Org.e clipse.jetty.servlet.ServletHandler.doScope (ServletHandler.java:515) at org.eclipse.jetty.server.handler.ContextHandler.doScope (ContextHandler.java:1061) at org.eclipse.jetty.server.handler.ScopedHandler. Handle (ScopedHandler.java: 141) at Org.eclipse.jetty.server.handler.HandlerWrapper.Handle (HandlerWrapper.java: 97) at Org.Eclipse.jetty.server.server.handle (Server.java: 499) At Org .eclipse.jetty.server.HttpChannel.handle (HttpChannel.java:310) at org.eclipse.jetty.server.HttpConnection.onFillable (HttpConnection.java:257) at org.eclipse.jetty.io.AbstractConnection $ 2.run ( AbstractConnection.java:540) Java.util.concurrent.threadpoolexecutor.Runworker (Threadpoolexecutor.java:

1149) at java.util.concurrent.ThreadPoolExecutor $ Worker.run (ThreadPoolExecutor.java:624) at java.lang.Thread.run (Thread.java:748) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ “mqh” “device” WHERE 1 = 2.’ at line 1at sun.reflect.NativeConstructorAccessorImpl.newInstance0 (Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance (NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance (DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance (Constructor.java:423 AT com.mysql.jdbc.util.handlenewinstance (Util.java: 425) at com.mysql.jdbc.util.GetInstance (Util.java: 408) at com.mysql.jdbc.sqlerror.createsqlexception (SQLError.java: 944) At com.mysql.jdbc.mysqlio.checkerrorpacket (mysqlio.java: 3978) at com.mysql.jdbc.mysqlio.checkerrorpacket (mysqlio.java: 3914) AT CO m.mysql.jdbc.MysqlIO.sendCommand (MysqlIO.java:2530) at com.mysql.jdbc.MysqlIO.sqlQueryDirect (MysqlIO.java:2683) at com.mysql.jdbc.ConnectionImpl.execSQL (ConnectionImpl.java:2495) at com.mysql.jdbc.PreparedStatement.executeInternal (PreparedStatement.java:1903) at com.mysql.jdbc.PreparedStatement.executeQuery (PreparedStatement.java:2011) at org.apache.sqoop.connector.jdbc.GenericJdbcFromInitializer.configurePartitionProperties (GenericJdbcFromInitializer .java: 185) at Org.apache.sqoop.connector.jdbc.Genericjdbcfrominitializer.Initialize (genericjdbcfrominitializer.java: 61) … 32 more Solution:

Identifier Enclose: Specifies the delimiter of the identifier in the SQL, that is, some SQL flags are a quotation marks: select * from “Table_Name”, this delimiter is reported in MySQL. This property default is dual quotation marks, so you can’t use it, you must cover it, you can use spaces to overwrite this value.

Identifier Enclose: Enter space donation developer

Under the driving of interest, write a free thing, have a joy, and sweat, I hope you like my work, and you can support it.Of course, there is money to hold a money field (support Alipay and WeChat and buckle group), no money to hold a person, thank you.

Personal Homepage: http://knight-ble-bob.iteye.com/

Thank you for your sponsor, I will do better!

Related Posts