91超碰碰碰碰久久久久久综合_超碰av人澡人澡人澡人澡人掠_国产黄大片在线观看画质优化_txt小说免费全本

溫馨提示×

溫馨提示×

您好,登錄后才能下訂單哦!

密碼登錄×
登錄注冊×
其他方式登錄
點擊 登錄注冊 即表示同意《億速云用戶服務條款》

MySQL報錯MySQL server syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT'怎么辦

發布時間:2021-11-06 16:15:03 來源:億速云 閱讀:187 作者:小新 欄目:MySQL數據庫

這篇文章主要介紹了MySQL報錯MySQL server syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT'怎么辦,具有一定借鑒價值,感興趣的朋友可以參考下,希望大家閱讀完這篇文章之后大有收獲,下面讓小編帶著大家一起了解一下。

 在hive的應用中,出現如下錯誤時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 'OPTION SQL_SELECT_LIMIT=DEFAULT'是mysql的版本和驅動的版本不匹配導致的,我的mysql版本是5.6的,剛開始使用的驅動是mysql-connector-java-5.0.5-bin.jar,但是mysql5.6已經拋棄了這個參數,所以會報上面錯誤,換成驅動mysql-connector-java-5.1.31-bin.jar后解決。

解決方案:

下載驅動:
http://dev.mysql.com/downloads/connector/j/
選擇平臺,下載(mysql-connector-java-5.1.31.tar.gz)
下載后解壓
tar -xvf mysql-connector-java-5.1.31.tar 
cd mysql-connector-java-5.1.31
cp mysql-connector-java-5.1.31-bin.jar  /usr/local/hive/lib/

Retrying HMSHandler after 2000 ms (attempt 8 of 10) with error: javax.jdo.JDODataStoreException: 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 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1

         at org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:451)

         at org.datanucleus.api.jdo.JDOPersistenceManager.getDataStoreConnection(JDOPersistenceManager.java:2259)

         at org.apache.hadoop.hive.metastore.MetaStoreDirectSql.getProductName(MetaStoreDirectSql.java:155)

         at org.apache.hadoop.hive.metastore.MetaStoreDirectSql.determineDbType(MetaStoreDirectSql.java:146)

         at org.apache.hadoop.hive.metastore.MetaStoreDirectSql.<init>(MetaStoreDirectSql.java:120)

         at org.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:295)

         at org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:258)

         at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:73)

         at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:133)

         at org.apache.hadoop.hive.metastore.RawStoreProxy.<init>(RawStoreProxy.java:56)

         at org.apache.hadoop.hive.metastore.RawStoreProxy.getProxy(RawStoreProxy.java:65)

         at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.newRawStore(HiveMetaStore.java:579)

         at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:557)

         at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_database_core(HiveMetaStore.java:933)

         at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.create_database(HiveMetaStore.java:876)

         at sun.reflect.GeneratedMethodAccessor8.invoke(Unknown Source)

         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

         at java.lang.reflect.Method.invoke(Method.java:606)

         at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:102)

         at com.sun.proxy.$Proxy18.create_database(Unknown Source)

         at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$create_database.getResult(ThriftHiveMetastore.java:8519)

         at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$create_database.getResult(ThriftHiveMetastore.java:8503)

         at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)

         at org.apache.hadoop.hive.metastore.TUGIBasedProcessor$1.run(TUGIBasedProcessor.java:110)

         at org.apache.hadoop.hive.metastore.TUGIBasedProcessor$1.run(TUGIBasedProcessor.java:106)

         at java.security.AccessController.doPrivileged(Native Method)

         at javax.security.auth.Subject.doAs(Subject.java:415)

         at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1671)

         at org.apache.hadoop.hive.metastore.TUGIBasedProcessor.process(TUGIBasedProcessor.java:118)

         at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:285)

         at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

         at java.lang.Thread.run(Thread.java:745)

NestedThrowablesStackTrace:

com.mysql.jdbc.exceptions.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 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1

         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)

         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941)

         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623)

         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)

         at com.mysql.jdbc.Connection.execSQL(Connection.java:3243)

         at com.mysql.jdbc.Connection.execSQL(Connection.java:3172)

         at com.mysql.jdbc.Statement.executeQuery(Statement.java:1166)

         at com.mysql.jdbc.Connection.getTransactionIsolation(Connection.java:3805)

         at com.jolbox.bonecp.ConnectionHandle.getTransactionIsolation(ConnectionHandle.java:825)

         at org.datanucleus.store.rdbms.ConnectionFactoryImpl$ManagedConnectionImpl.getConnection(ConnectionFactoryImpl.java:444)

         at org.datanucleus.store.rdbms.ConnectionFactoryImpl$ManagedConnectionImpl.getXAResource(ConnectionFactoryImpl.java:378)

         at org.datanucleus.store.connection.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:328)

         at org.datanucleus.store.connection.AbstractConnectionFactory.getConnection(AbstractConnectionFactory.java:94)

         at org.datanucleus.store.rdbms.RDBMSStoreManager.getNucleusConnection(RDBMSStoreManager.java:1357)

         at org.datanucleus.api.jdo.JDOPersistenceManager.getDataStoreConnection(JDOPersistenceManager.java:2245)

         at org.apache.hadoop.hive.metastore.MetaStoreDirectSql.getProductName(MetaStoreDirectSql.java:155)

         at org.apache.hadoop.hive.metastore.MetaStoreDirectSql.determineDbType(MetaStoreDirectSql.java:146)

         at org.apache.hadoop.hive.metastore.MetaStoreDirectSql.<init>(MetaStoreDirectSql.java:120)

         at org.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:295)

         at org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:258)

         at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:73)

         at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:133)

         at org.apache.hadoop.hive.metastore.RawStoreProxy.<init>(RawStoreProxy.java:56)

         at org.apache.hadoop.hive.metastore.RawStoreProxy.getProxy(RawStoreProxy.java:65)

         at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.newRawStore(HiveMetaStore.java:579)

         at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:557)

         at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_database_core(HiveMetaStore.java:933)

         at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.create_database(HiveMetaStore.java:876)

         at sun.reflect.GeneratedMethodAccessor8.invoke(Unknown Source)

         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

         at java.lang.reflect.Method.invoke(Method.java:606)

         at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:102)

         at com.sun.proxy.$Proxy18.create_database(Unknown Source)

         at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$create_database.getResult(ThriftHiveMetastore.java:8519)

         at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$create_database.getResult(ThriftHiveMetastore.java:8503)

         at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)

         at org.apache.hadoop.hive.metastore.TUGIBasedProcessor$1.run(TUGIBasedProcessor.java:110)

         at org.apache.hadoop.hive.metastore.TUGIBasedProcessor$1.run(TUGIBasedProcessor.java:106)

         at java.security.AccessController.doPrivileged(Native Method)

         at javax.security.auth.Subject.doAs(Subject.java:415)

         at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1671)

         at org.apache.hadoop.hive.metastore.TUGIBasedProcessor.process(TUGIBasedProcessor.java:118)

         at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:285)

         at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

         at java.lang.Thread.run(Thread.java:745)

感謝你能夠認真閱讀完這篇文章,希望小編分享的“MySQL報錯MySQL server syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT'怎么辦”這篇文章對大家有幫助,同時也希望大家多多支持億速云,關注億速云行業資訊頻道,更多相關知識等著你來學習!

向AI問一下細節

免責聲明:本站發布的內容(圖片、視頻和文字)以原創、轉載和分享為主,文章觀點不代表本網站立場,如果涉及侵權請聯系站長郵箱:is@yisu.com進行舉報,并提供相關證據,一經查實,將立刻刪除涉嫌侵權內容。

AI

海门市| 昭通市| 甘孜| 平阴县| 合水县| 视频| 新竹县| 宁阳县| 扶余县| 宜川县| 阳谷县| 丰原市| 湖南省| 左贡县| 潍坊市| 晋城| 驻马店市| 新郑市| 孟州市| 西畴县| 任丘市| 崇仁县| 元阳县| 鹤岗市| 东方市| 平定县| 乐清市| 玉树县| 肥西县| 孝昌县| 高唐县| 滨海县| 镶黄旗| 鄱阳县| 星子县| 新宁县| 静安区| 宜兴市| 商洛市| 宣汉县| 扎兰屯市|