{"id":9218,"date":"2023-09-14T05:06:18","date_gmt":"2023-09-14T03:06:18","guid":{"rendered":"https:\/\/myoceane.fr\/?p=9218"},"modified":"2023-09-27T08:10:58","modified_gmt":"2023-09-27T06:10:58","slug":"roles_already_set","status":"publish","type":"post","link":"https:\/\/myoceane.fr\/index.php\/roles_already_set\/","title":{"rendered":"[Hive] Index part #0 for `ROLES` already set"},"content":{"rendered":"<div id=\"fb-root\"><\/div>\n<p style=\"text-align: justify;\">\u6ab8\u6aac\u7238\u5728\u524d\u9762\u5e7e\u7bc7\u4ecb\u7d39\u4e86\u6709\u95dc <a href=\"https:\/\/myoceane.fr\/index.php\/hive-%e5%9c%a8-spark-%e5%ad%98%e5%8f%96%e8%87%aa%e5%b7%b1%e7%9a%84-hive-metastore\/\">Hive Metastore<\/a>, Hive on Spark \u548c Spark Thrift Server \u7b49\u7b49\u7684\u89c0\u5ff5\uff0c\u672c\u7bc7\u60f3\u8981\u7d00\u9304\u4e00\u500b\u82b1\u4e86\u4e0d\u5c11\u6642\u9593\u7684\u9664\u932f\u904e\u7a0b\uff0c\u932f\u8aa4\u767c\u751f\u7684\u74b0\u5883\u662f\u5728 <a href=\"https:\/\/myoceane.fr\/index.php\/application-hive-metastore-server\/\">Spark Standalone \u7684\u53e2\u96c6\u4e0a\u555f\u52d5\u7684 Spark Thrift Server<\/a> \u5617\u8a66\u53bb\u9023\u63a5\u5728 MySQL \u4e0a\u7684 Hive Metastore\uff0c\u6210\u529f\u4f7f\u7528\u4e00\u6bb5\u6642\u9593\u4e4b\u5f8c\u6703\u6642\u4e0d\u6642\u5730\u9047\u5230\u9019\u500b Bug (org.datanucleus.exceptions.NucleusException: Index part #0 for `ROLES` already set)\uff0c\u5f8c\u4f86\u7684\u89e3\u6c7a\u65b9\u6cd5\u662f\u91cd\u65b0\u5275\u5efa MySQL \u7684\u4f7f\u7528\u8005\u3002<\/p>\n<h4>\u932f\u8aa4\u8a0a\u606f<\/h4>\n<p>\u4ee5\u4e0b\u6211\u5011\u64f7\u53d6\u5728 Spark Thrift Server \u4e0a\u9762\u89c0\u5bdf\u5230\u7684\u932f\u8aa4\u8a0a\u606f\uff0c\u4e3b\u8981\u6709\u5e7e\u500b\u91cd\u9ede\uff1a<\/p>\n<ol>\n<li>Query for candidates of org.apache.hadoop.hive.metastore.model.MRole and subclasses resulted in no possible candidates<\/li>\n<li>org.datanucleus.exceptions.NucleusException: Index part #0 for `ROLES` already set<\/li>\n<\/ol>\n<pre class=\"lang:bash\">02:49:05.966 WARN  Query - Query for candidates of org.apache.hadoop.hive.metastore.model.MRole and subclasses resulted in no possible candidates\norg.datanucleus.exceptions.NucleusException: Index part 0 for `ROLES` already set\n\tat org.datanucleus.store.rdbms.key.Index.setColumn(Index.java:99) ~[datanucleus-rdbms-4.1.19.jar:?]\n\tat org.datanucleus.store.rdbms.table.TableImpl.getExistingIndices(TableImpl.java:1146) ~[datanucleus-rdbms-4.1.19.jar:?]\n\tat org.datanucleus.store.rdbms.table.TableImpl.validateIndices(TableImpl.java:566) ~[datanucleus-rdbms-4.1.19.jar:?]\n\tat org.datanucleus.store.rdbms.table.TableImpl.validateConstraints(TableImpl.java:387) ~[datanucleus-rdbms-4.1.19.jar:?]\n\tat org.datanucleus.store.rdbms.table.ClassTable.validateConstraints(ClassTable.java:3576) ~[datanucleus-rdbms-4.1.19.jar:?]\n\tat org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:3471) ~[datanucleus-rdbms-4.1.19.jar:?]\n\tat org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2896) ~[datanucleus-rdbms-4.1.19.jar:?]\n\tat org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:119) ~[datanucleus-rdbms-4.1.19.jar:?]\n\tat org.datanucleus.store.rdbms.RDBMSStoreManager.manageClasses(RDBMSStoreManager.java:1627) ~[datanucleus-rdbms-4.1.19.jar:?]\n\tat org.datanucleus.store.rdbms.RDBMSStoreManager.getDatastoreClass(RDBMSStoreManager.java:672) ~[datanucleus-rdbms-4.1.19.jar:?]\n\tat org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getStatementForCandidates(RDBMSQueryUtils.java:425) ~[datanucleus-rdbms-4.1.19.jar:?]\n\tat org.datanucleus.store.rdbms.query.JDOQLQuery.compileQueryFull(JDOQLQuery.java:865) ~[datanucleus-rdbms-4.1.19.jar:?]\n\tat org.datanucleus.store.rdbms.query.JDOQLQuery.compileInternal(JDOQLQuery.java:347) ~[datanucleus-rdbms-4.1.19.jar:?]\n\tat org.datanucleus.store.query.Query.executeQuery(Query.java:1816) ~[datanucleus-core-4.1.17.jar:?]\n\tat org.datanucleus.store.query.Query.executeWithArray(Query.java:1744) ~[datanucleus-core-4.1.17.jar:?]\n\tat org.datanucleus.api.jdo.JDOQuery.executeInternal(JDOQuery.java:368) ~[datanucleus-api-jdo-4.2.4.jar:?]\n\tat org.datanucleus.api.jdo.JDOQuery.execute(JDOQuery.java:228) ~[datanucleus-api-jdo-4.2.4.jar:?]\n\tat org.apache.hadoop.hive.metastore.ObjectStore.getMRole(ObjectStore.java:4429) ~[hive-metastore-2.3.9.jar:2.3.9]\n\tat org.apache.hadoop.hive.metastore.ObjectStore.addRole(ObjectStore.java:4084) ~[hive-metastore-2.3.9.jar:2.3.9]\n\tat sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source) ~[?:?]\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_362]\n\tat java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_362]\n\tat org.apache.hadoop.hive.metastore.RawStoreProxy.invoke(RawStoreProxy.java:101) ~[hive-metastore-2.3.9.jar:2.3.9]\n\tat com.sun.proxy.$Proxy41.addRole(Unknown Source) ~[?:?]\n\tat org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultRoles_core(HiveMetaStore.java:691) ~[hive-metastore-2.3.9.jar:2.3.9]\n\tat org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultRoles(HiveMetaStore.java:683) ~[hive-metastore-2.3.9.jar:2.3.9]\n\tat org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:432) ~[hive-metastore-2.3.9.jar:2.3.9]\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_362]\n\tat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_362]\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_362]\n\tat java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_362]\n\tat org.apache.hadoop.hive.metastore.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:148) ~[hive-metastore-2.3.9.jar:2.3.9]\n\tat org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:107) ~[hive-metastore-2.3.9.jar:2.3.9]\n\tat org.apache.hadoop.hive.metastore.RetryingHMSHandler.&lt;init&gt;(RetryingHMSHandler.java:79) ~[hive-metastore-2.3.9.jar:2.3.9]\n\tat org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:92) ~[hive-metastore-2.3.9.jar:2.3.9]\n\tat org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:6902) ~[hive-metastore-2.3.9.jar:2.3.9]\n\tat org.apache.hadoop.hive.metastore.HiveMetaStoreClient.&lt;init&gt;(HiveMetaStoreClient.java:162) ~[hive-metastore-2.3.9.jar:2.3.9]\n\tat org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.&lt;init&gt;(SessionHiveMetaStoreClient.java:70) ~[hive-exec-2.3.9-core.jar:2.3.9]\n\tat sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_362]\n\tat sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:1.8.0_362]\n\tat sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_362]\n\tat java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[?:1.8.0_362]\n\tat org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1740) ~[hive-metastore-2.3.9.jar:2.3.9]\n\tat org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.&lt;init&gt;(RetryingMetaStoreClient.java:83) ~[hive-metastore-2.3.9.jar:2.3.9]\n\tat org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:133) ~[hive-metastore-2.3.9.jar:2.3.9]\n\tat org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:104) ~[hive-metastore-2.3.9.jar:2.3.9]\n\tat org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:3607) ~[hive-exec-2.3.9-core.jar:2.3.9]\n\tat org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3659) ~[hive-exec-2.3.9-core.jar:2.3.9]\n\tat org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3639) ~[hive-exec-2.3.9-core.jar:2.3.9]\n\tat org.apache.hadoop.hive.ql.metadata.Hive.getAllFunctions(Hive.java:3901) ~[hive-exec-2.3.9-core.jar:2.3.9]\n\tat org.apache.hadoop.hive.ql.metadata.Hive.reloadFunctions(Hive.java:248) ~[hive-exec-2.3.9-core.jar:2.3.9]\n\tat org.apache.hadoop.hive.ql.metadata.Hive.registerAllFunctionsOnce(Hive.java:231) ~[hive-exec-2.3.9-core.jar:2.3.9]\n\tat org.apache.hadoop.hive.ql.metadata.Hive.&lt;init&gt;(Hive.java:395) ~[hive-exec-2.3.9-core.jar:2.3.9]\n\tat org.apache.hadoop.hive.ql.metadata.Hive.create(Hive.java:339) ~[hive-exec-2.3.9-core.jar:2.3.9]\n\tat org.apache.hadoop.hive.ql.metadata.Hive.getInternal(Hive.java:319) ~[hive-exec-2.3.9-core.jar:2.3.9]\n\tat org.apache.hadoop.hive.ql.metadata.Hive.get(Hive.java:288) ~[hive-exec-2.3.9-core.jar:2.3.9]\n\tat org.apache.hive.service.cli.session.HiveSessionImplwithUGI.&lt;init&gt;(HiveSessionImplwithUGI.java:57) ~[spark-hive-thriftserver_2.12-3.3.0.jar:3.3.0]\n\tat org.apache.hive.service.cli.session.SessionManager.openSession(SessionManager.java:263) ~[spark-hive-thriftserver_2.12-3.3.0.jar:3.3.0]\n\tat org.apache.spark.sql.hive.thriftserver.SparkSQLSessionManager.openSession(SparkSQLSessionManager.scala:56) ~[spark-hive-thriftserver_2.12-3.3.0.jar:3.3.0]\n\tat org.apache.hive.service.cli.CLIService.openSessionWithImpersonation(CLIService.java:203) ~[spark-hive-thriftserver_2.12-3.3.0.jar:3.3.0]\n\tat org.apache.hive.service.cli.thrift.ThriftCLIService.getSessionHandle(ThriftCLIService.java:370) ~[spark-hive-thriftserver_2.12-3.3.0.jar:3.3.0]\n\tat org.apache.hive.service.cli.thrift.ThriftCLIService.OpenSession(ThriftCLIService.java:242) ~[spark-hive-thriftserver_2.12-3.3.0.jar:3.3.0]\n\tat org.apache.hive.service.rpc.thrift.TCLIService$Processor$OpenSession.getResult(TCLIService.java:1497) ~[hive-service-rpc-3.1.2.jar:3.1.2]\n\tat org.apache.hive.service.rpc.thrift.TCLIService$Processor$OpenSession.getResult(TCLIService.java:1482) ~[hive-service-rpc-3.1.2.jar:3.1.2]\n\tat org.apache.thrift.ProcessFunction.process(ProcessFunction.java:38) ~[libthrift-0.12.0.jar:0.12.0]\n\tat org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39) ~[libthrift-0.12.0.jar:0.12.0]\n\tat org.apache.thrift.server.TServlet.doPost(TServlet.java:83) ~[libthrift-0.12.0.jar:0.12.0]\n\tat org.apache.hive.service.cli.thrift.ThriftHttpServlet.doPost(ThriftHttpServlet.java:180) ~[spark-hive-thriftserver_2.12-3.3.0.jar:3.3.0]\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:523) ~[jakarta.servlet-api-4.0.3.jar:4.0.3]\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:590) ~[jakarta.servlet-api-4.0.3.jar:4.0.3]\n\tat org.sparkproject.jetty.servlet.ServletHolder.handle(ServletHolder.java:799) ~[spark-core_2.12-3.3.0.jar:3.3.0]\n\tat org.sparkproject.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:550) ~[spark-core_2.12-3.3.0.jar:3.3.0]\n\tat org.sparkproject.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) ~[spark-core_2.12-3.3.0.jar:3.3.0]\n\tat org.sparkproject.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1624) ~[spark-core_2.12-3.3.0.jar:3.3.0]\n\tat org.sparkproject.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) ~[spark-core_2.12-3.3.0.jar:3.3.0]\n\tat org.sparkproject.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1440) ~[spark-core_2.12-3.3.0.jar:3.3.0]\n\tat org.sparkproject.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188) ~[spark-core_2.12-3.3.0.jar:3.3.0]\n\tat org.sparkproject.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501) ~[spark-core_2.12-3.3.0.jar:3.3.0]\n\tat org.sparkproject.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1594) ~[spark-core_2.12-3.3.0.jar:3.3.0]\n\tat org.sparkproject.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186) ~[spark-core_2.12-3.3.0.jar:3.3.0]\n\tat org.sparkproject.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1355) ~[spark-core_2.12-3.3.0.jar:3.3.0]\n\tat org.sparkproject.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) ~[spark-core_2.12-3.3.0.jar:3.3.0]\n\tat org.sparkproject.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[spark-core_2.12-3.3.0.jar:3.3.0]\n\tat org.sparkproject.jetty.server.Server.handle(Server.java:516) ~[spark-core_2.12-3.3.0.jar:3.3.0]\n\tat org.sparkproject.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:487) ~[spark-core_2.12-3.3.0.jar:3.3.0]\n\tat org.sparkproject.jetty.server.HttpChannel.dispatch(HttpChannel.java:732) ~[spark-core_2.12-3.3.0.jar:3.3.0]\n\tat org.sparkproject.jetty.server.HttpChannel.handle(HttpChannel.java:479) ~[spark-core_2.12-3.3.0.jar:3.3.0]\n\tat org.sparkproject.jetty.server.HttpConnection.onFillable(HttpConnection.java:277) ~[spark-core_2.12-3.3.0.jar:3.3.0]\n\tat org.sparkproject.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) ~[spark-core_2.12-3.3.0.jar:3.3.0]\n\tat org.sparkproject.jetty.io.FillInterest.fillable(FillInterest.java:105) ~[spark-core_2.12-3.3.0.jar:3.3.0]\n\tat org.sparkproject.jetty.io.ssl.SslConnection$DecryptedEndPoint.onFillable(SslConnection.java:555) ~[spark-core_2.12-3.3.0.jar:3.3.0]\n\tat org.sparkproject.jetty.io.ssl.SslConnection.onFillable(SslConnection.java:410) ~[spark-core_2.12-3.3.0.jar:3.3.0]\n\tat org.sparkproject.jetty.io.ssl.SslConnection$2.succeeded(SslConnection.java:164) ~[spark-core_2.12-3.3.0.jar:3.3.0]\n\tat org.sparkproject.jetty.io.FillInterest.fillable(FillInterest.java:105) ~[spark-core_2.12-3.3.0.jar:3.3.0]\n\tat org.sparkproject.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) ~[spark-core_2.12-3.3.0.jar:3.3.0]\n\tat org.sparkproject.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338) ~[spark-core_2.12-3.3.0.jar:3.3.0]\n\tat org.sparkproject.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315) ~[spark-core_2.12-3.3.0.jar:3.3.0]\n\tat org.sparkproject.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173) ~[spark-core_2.12-3.3.0.jar:3.3.0]\n\tat org.sparkproject.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131) ~[spark-core_2.12-3.3.0.jar:3.3.0]\n\tat org.sparkproject.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:409) ~[spark-core_2.12-3.3.0.jar:3.3.0]\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_362]\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_362]\n\tat java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_362]\n02:49:05.987 ERROR RetryingHMSHandler - Retrying HMSHandler after 2000 ms (attempt 4 of 10) with error: javax.jdo.JDOFatalInternalException: Index part #0 for `ROLES` already set\n\tat org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:673)\n\tat org.datanucleus.api.jdo.JDOPersistenceManager.jdoMakePersistent(JDOPersistenceManager.java:729)\n\tat org.datanucleus.api.jdo.JDOPersistenceManager.makePersistent(JDOPersistenceManager.java:749)\n\tat org.apache.hadoop.hive.metastore.ObjectStore.addRole(ObjectStore.java:4090)\n\tat sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat java.lang.reflect.Method.invoke(Method.java:498)\n\tat org.apache.hadoop.hive.metastore.RawStoreProxy.invoke(RawStoreProxy.java:101)\n\tat com.sun.proxy.$Proxy41.addRole(Unknown Source)\n\tat org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultRoles_core(HiveMetaStore.java:691)\n\tat org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultRoles(HiveMetaStore.java:683)\n\tat org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:432)\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n\tat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat java.lang.reflect.Method.invoke(Method.java:498)\n\tat org.apache.hadoop.hive.metastore.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:148)\n\tat org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:107)\n\tat org.apache.hadoop.hive.metastore.RetryingHMSHandler.&lt;init&gt;(RetryingHMSHandler.java:79)\n\tat org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:92)\n\tat org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:6902)\n\tat org.apache.hadoop.hive.metastore.HiveMetaStoreClient.&lt;init&gt;(HiveMetaStoreClient.java:162)\n\tat org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.&lt;init&gt;(SessionHiveMetaStoreClient.java:70)\n\tat sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)\n\tat sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)\n\tat sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)\n\tat java.lang.reflect.Constructor.newInstance(Constructor.java:423)\n\tat org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1740)\n\tat org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.&lt;init&gt;(RetryingMetaStoreClient.java:83)\n\tat org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:133)\n\tat org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:104)\n\tat org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:3607)\n\tat org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3659)\n\tat org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3639)\n\tat org.apache.hadoop.hive.ql.metadata.Hive.getAllFunctions(Hive.java:3901)\n\tat org.apache.hadoop.hive.ql.metadata.Hive.reloadFunctions(Hive.java:248)\n\tat org.apache.hadoop.hive.ql.metadata.Hive.registerAllFunctionsOnce(Hive.java:231)\n\tat org.apache.hadoop.hive.ql.metadata.Hive.&lt;init&gt;(Hive.java:395)\n\tat org.apache.hadoop.hive.ql.metadata.Hive.create(Hive.java:339)\n\tat org.apache.hadoop.hive.ql.metadata.Hive.getInternal(Hive.java:319)\n\tat org.apache.hadoop.hive.ql.metadata.Hive.get(Hive.java:288)\n\tat org.apache.hive.service.cli.session.HiveSessionImplwithUGI.&lt;init&gt;(HiveSessionImplwithUGI.java:57)\n\tat org.apache.hive.service.cli.session.SessionManager.openSession(SessionManager.java:263)\n\tat org.apache.spark.sql.hive.thriftserver.SparkSQLSessionManager.openSession(SparkSQLSessionManager.scala:56)\n\tat org.apache.hive.service.cli.CLIService.openSessionWithImpersonation(CLIService.java:203)\n\tat org.apache.hive.service.cli.thrift.ThriftCLIService.getSessionHandle(ThriftCLIService.java:370)\n\tat org.apache.hive.service.cli.thrift.ThriftCLIService.OpenSession(ThriftCLIService.java:242)\n\tat org.apache.hive.service.rpc.thrift.TCLIService$Processor$OpenSession.getResult(TCLIService.java:1497)\n\tat org.apache.hive.service.rpc.thrift.TCLIService$Processor$OpenSession.getResult(TCLIService.java:1482)\n\tat org.apache.thrift.ProcessFunction.process(ProcessFunction.java:38)\n\tat org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)\n\tat org.apache.thrift.server.TServlet.doPost(TServlet.java:83)\n\tat org.apache.hive.service.cli.thrift.ThriftHttpServlet.doPost(ThriftHttpServlet.java:180)\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:523)\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:590)\n\tat org.sparkproject.jetty.servlet.ServletHolder.handle(ServletHolder.java:799)\n\tat org.sparkproject.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:550)\n\tat org.sparkproject.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)\n\tat org.sparkproject.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1624)\n\tat org.sparkproject.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)\n\tat org.sparkproject.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1440)\n\tat org.sparkproject.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188)\n\tat org.sparkproject.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501)\n\tat org.sparkproject.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1594)\n\tat org.sparkproject.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186)\n\tat org.sparkproject.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1355)\n\tat org.sparkproject.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)\n\tat org.sparkproject.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)\n\tat org.sparkproject.jetty.server.Server.handle(Server.java:516)\n\tat org.sparkproject.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:487)\n\tat org.sparkproject.jetty.server.HttpChannel.dispatch(HttpChannel.java:732)\n\tat org.sparkproject.jetty.server.HttpChannel.handle(HttpChannel.java:479)\n\tat org.sparkproject.jetty.server.HttpConnection.onFillable(HttpConnection.java:277)\n\tat org.sparkproject.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)\n\tat org.sparkproject.jetty.io.FillInterest.fillable(FillInterest.java:105)\n\tat org.sparkproject.jetty.io.ssl.SslConnection$DecryptedEndPoint.onFillable(SslConnection.java:555)\n\tat org.sparkproject.jetty.io.ssl.SslConnection.onFillable(SslConnection.java:410)\n\tat org.sparkproject.jetty.io.ssl.SslConnection$2.succeeded(SslConnection.java:164)\n\tat org.sparkproject.jetty.io.FillInterest.fillable(FillInterest.java:105)\n\tat org.sparkproject.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104)\n\tat org.sparkproject.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338)\n\tat org.sparkproject.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315)\n\tat org.sparkproject.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173)\n\tat org.sparkproject.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131)\n\tat org.sparkproject.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:409)\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)\n\tat java.lang.Thread.run(Thread.java:750)\nNestedThrowablesStackTrace:\nIndex part #0 for `ROLES` already set\norg.datanucleus.exceptions.NucleusException: Index part #0 for `ROLES` already set\n\tat org.datanucleus.store.rdbms.key.Index.setColumn(Index.java:99)\n\tat org.datanucleus.store.rdbms.table.TableImpl.getExistingIndices(TableImpl.java:1146)\n\tat org.datanucleus.store.rdbms.table.TableImpl.validateIndices(TableImpl.java:566)\n\tat org.datanucleus.store.rdbms.table.TableImpl.validateConstraints(TableImpl.java:387)\n\tat org.datanucleus.store.rdbms.table.ClassTable.validateConstraints(ClassTable.java:3576)\n\tat org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:3471)\n\tat org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2896)\n\tat org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:119)\n\tat org.datanucleus.store.rdbms.RDBMSStoreManager.manageClasses(RDBMSStoreManager.java:1627)\n\tat org.datanucleus.store.rdbms.RDBMSStoreManager.getDatastoreClass(RDBMSStoreManager.java:672)\n\tat org.datanucleus.store.rdbms.RDBMSStoreManager.getPropertiesForGenerator(RDBMSStoreManager.java:2088)\n\tat org.datanucleus.store.AbstractStoreManager.getStrategyValue(AbstractStoreManager.java:1271)\n\tat org.datanucleus.ExecutionContextImpl.newObjectId(ExecutionContextImpl.java:3760)\n\tat org.datanucleus.state.StateManagerImpl.setIdentity(StateManagerImpl.java:2267)\n\tat org.datanucleus.state.StateManagerImpl.initialiseForPersistentNew(StateManagerImpl.java:484)\n\tat org.datanucleus.state.StateManagerImpl.initialiseForPersistentNew(StateManagerImpl.java:120)\n\tat org.datanucleus.state.ObjectProviderFactoryImpl.newForPersistentNew(ObjectProviderFactoryImpl.java:218)\n\tat org.datanucleus.ExecutionContextImpl.persistObjectInternal(ExecutionContextImpl.java:2079)\n\tat org.datanucleus.ExecutionContextImpl.persistObjectWork(ExecutionContextImpl.java:1923)\n\tat org.datanucleus.ExecutionContextImpl.persistObject(ExecutionContextImpl.java:1778)\n\tat org.datanucleus.ExecutionContextThreadedImpl.persistObject(ExecutionContextThreadedImpl.java:217)\n\tat org.datanucleus.api.jdo.JDOPersistenceManager.jdoMakePersistent(JDOPersistenceManager.java:724)\n\tat org.datanucleus.api.jdo.JDOPersistenceManager.makePersistent(JDOPersistenceManager.java:749)\n\tat org.apache.hadoop.hive.metastore.ObjectStore.addRole(ObjectStore.java:4090)\n\tat sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat java.lang.reflect.Method.invoke(Method.java:498)\n\tat org.apache.hadoop.hive.metastore.RawStoreProxy.invoke(RawStoreProxy.java:101)\n\tat com.sun.proxy.$Proxy41.addRole(Unknown Source)\n\tat org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultRoles_core(HiveMetaStore.java:691)\n\tat org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultRoles(HiveMetaStore.java:683)\n\tat org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:432)\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n\tat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat java.lang.reflect.Method.invoke(Method.java:498)\n\tat org.apache.hadoop.hive.metastore.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:148)\n\tat org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:107)\n\tat org.apache.hadoop.hive.metastore.RetryingHMSHandler.&lt;init&gt;(RetryingHMSHandler.java:79)\n\tat org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:92)\n\tat org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:6902)\n\tat org.apache.hadoop.hive.metastore.HiveMetaStoreClient.&lt;init&gt;(HiveMetaStoreClient.java:162)\n\tat org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.&lt;init&gt;(SessionHiveMetaStoreClient.java:70)\n\tat sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)\n\tat sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)\n\tat sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)\n\tat java.lang.reflect.Constructor.newInstance(Constructor.java:423)\n\tat org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1740)\n\tat org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.&lt;init&gt;(RetryingMetaStoreClient.java:83)\n\tat org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:133)\n\tat org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:104)\n\tat org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:3607)\n\tat org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3659)\n\tat org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3639)\n\tat org.apache.hadoop.hive.ql.metadata.Hive.getAllFunctions(Hive.java:3901)\n\tat org.apache.hadoop.hive.ql.metadata.Hive.reloadFunctions(Hive.java:248)\n\tat org.apache.hadoop.hive.ql.metadata.Hive.registerAllFunctionsOnce(Hive.java:231)\n\tat org.apache.hadoop.hive.ql.metadata.Hive.&lt;init&gt;(Hive.java:395)\n\tat org.apache.hadoop.hive.ql.metadata.Hive.create(Hive.java:339)\n\tat org.apache.hadoop.hive.ql.metadata.Hive.getInternal(Hive.java:319)\n\tat org.apache.hadoop.hive.ql.metadata.Hive.get(Hive.java:288)\n\tat org.apache.hive.service.cli.session.HiveSessionImplwithUGI.&lt;init&gt;(HiveSessionImplwithUGI.java:57)\n\tat org.apache.hive.service.cli.session.SessionManager.openSession(SessionManager.java:263)\n\tat org.apache.spark.sql.hive.thriftserver.SparkSQLSessionManager.openSession(SparkSQLSessionManager.scala:56)\n\tat org.apache.hive.service.cli.CLIService.openSessionWithImpersonation(CLIService.java:203)\n\tat org.apache.hive.service.cli.thrift.ThriftCLIService.getSessionHandle(ThriftCLIService.java:370)\n\tat org.apache.hive.service.cli.thrift.ThriftCLIService.OpenSession(ThriftCLIService.java:242)\n\tat org.apache.hive.service.rpc.thrift.TCLIService$Processor$OpenSession.getResult(TCLIService.java:1497)\n\tat org.apache.hive.service.rpc.thrift.TCLIService$Processor$OpenSession.getResult(TCLIService.java:1482)\n\tat org.apache.thrift.ProcessFunction.process(ProcessFunction.java:38)\n\tat org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)\n\tat org.apache.thrift.server.TServlet.doPost(TServlet.java:83)\n\tat org.apache.hive.service.cli.thrift.ThriftHttpServlet.doPost(ThriftHttpServlet.java:180)\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:523)\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:590)\n\tat org.sparkproject.jetty.servlet.ServletHolder.handle(ServletHolder.java:799)\n\tat org.sparkproject.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:550)\n\tat org.sparkproject.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)\n\tat org.sparkproject.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1624)\n\tat org.sparkproject.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)\n\tat org.sparkproject.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1440)\n\tat org.sparkproject.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188)\n\tat org.sparkproject.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501)\n\tat org.sparkproject.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1594)\n\tat org.sparkproject.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186)\n\tat org.sparkproject.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1355)\n\tat org.sparkproject.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)\n\tat org.sparkproject.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)\n\tat org.sparkproject.jetty.server.Server.handle(Server.java:516)\n\tat org.sparkproject.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:487)\n\tat org.sparkproject.jetty.server.HttpChannel.dispatch(HttpChannel.java:732)\n\tat org.sparkproject.jetty.server.HttpChannel.handle(HttpChannel.java:479)\n\tat org.sparkproject.jetty.server.HttpConnection.onFillable(HttpConnection.java:277)\n\tat org.sparkproject.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)\n\tat org.sparkproject.jetty.io.FillInterest.fillable(FillInterest.java:105)\n\tat org.sparkproject.jetty.io.ssl.SslConnection$DecryptedEndPoint.onFillable(SslConnection.java:555)\n\tat org.sparkproject.jetty.io.ssl.SslConnection.onFillable(SslConnection.java:410)\n\tat org.sparkproject.jetty.io.ssl.SslConnection$2.succeeded(SslConnection.java:164)\n\tat org.sparkproject.jetty.io.FillInterest.fillable(FillInterest.java:105)\n\tat org.sparkproject.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104)\n\tat org.sparkproject.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338)\n\tat org.sparkproject.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315)\n\tat org.sparkproject.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173)\n\tat org.sparkproject.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131)\n\tat org.sparkproject.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:409)\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)\n\tat java.lang.Thread.run(Thread.java:750)<\/pre>\n<h4><a href=\"https:\/\/kb.databricks.com\/metastore\/hive-metastore-troubleshooting\">\u5176\u4ed6\u985e\u4f3c\u7684 Hive \u932f\u8aa4<\/a><\/h4>\n<p>\u5617\u8a66\u641c\u5c0b\u6709\u985e\u4f3c\u7684 Hive \u932f\u8aa4\uff0c\u4f46\u662f\u6c92\u6709\u76f4\u63a5\u7684\u5e6b\u52a9\u3002<\/p>\n<h4>\u89e3\u6c7a\u65b9\u6cd5<\/h4>\n<p>\u5f8c\u4f86\u5728\u89c0\u5bdf\u5230\u53ea\u6709\u7279\u5b9a\u7684 MySQL Users \u6703\u6709\u4ee5\u4e0a\u7684\u73fe\u8c61\uff0c\u5728\u5229\u7528\u4ee5\u4e0b\u7684\u6307\u4ee4\u91cd\u65b0\u5efa\u7acb MySQL \u4f7f\u7528\u8005\u4e4b\u5f8c\uff0c\u6210\u529f\u89e3\u6c7a\u4ee5\u4e0a\u7684\u554f\u984c\uff1a<\/p>\n<pre class=\"lang:sql\">SELECT user, host FROM mysql.user;\nDROP USER yourUser@'%';\nCREATE USER yourUser@'%' IDENTIFIED BY 'yourPasswd';\nGRANT ALL PRIVILEGES ON yourDB.* TO 'yourUser'@'%';\nSHOW GRANTS FOR 'yourUser'@'%';<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u6ab8\u6aac\u7238\u5728\u524d\u9762\u5e7e\u7bc7\u4ecb\u7d39\u4e86\u6709\u95dc Hive Metastore, Hive on Spark \u548c Spark Thrift Server \u7b49\u7b49\u7684\u89c0\u5ff5\uff0c\u672c\u7bc7\u60f3\u8981\u7d00\u9304\u4e00\u500b\u82b1\u4e86\u4e0d\u5c11\u6642\u9593\u7684\u9664\u932f\u904e\u7a0b\uff0c\u932f\u8aa4\u767c\u751f\u7684\u74b0\u5883\u662f\u5728 Spark Standalone \u7684\u53e2\u96c6\u4e0a\u555f\u52d5\u7684 Spark Thrift Server \u5617\u8a66\u53bb\u9023\u63a5\u5728 MySQL \u4e0a\u7684 Hive Metastore\uff0c\u6210\u529f\u4f7f\u7528\u4e00\u6bb5\u6642\u9593\u4e4b\u5f8c\u6703\u6642\u4e0d\u6642\u5730\u9047\u5230\u9019\u500b Bug\uff0c\u5f8c\u4f86\u7684\u89e3\u6c7a\u65b9\u6cd5\u662f\u91cd\u65b0\u5275\u5efa MySQL \u7684\u4f7f\u7528\u8005\u3002<\/p>\n","protected":false},"author":1,"featured_media":8950,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[21,152,1724],"class_list":["post-9218","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bigdata-ml","tag-hive","tag-spark","tag-spark-thrift-server"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Hive] Index part #0 for `ROLES` already set - \u60f3\u65b9\u6d89\u6cd5 - \u91cf\u74f6\u5916\u7684\u5929\u7a7a M-Y-Oceane<\/title>\n<meta name=\"description\" content=\"\u6ab8\u6aac\u7238\u5728\u524d\u9762\u5e7e\u7bc7\u4ecb\u7d39\u4e86\u6709\u95dc Hive Metastore, Hive on Spark \u548c Spark Thrift Server \u7b49\u7b49\u7684\u89c0\u5ff5\uff0c\u672c\u7bc7\u60f3\u8981\u7d00\u9304\u4e00\u500b\u82b1\u4e86\u4e0d\u5c11\u6642\u9593\u7684\u9664\u932f\u904e\u7a0b\uff0c\u932f\u8aa4\u767c\u751f\u7684\u74b0\u5883\u662f\u5728 Spark Standalone \u7684\u53e2\u96c6\u4e0a\u555f\u52d5\u7684 Spark Thrift Server \u5617\u8a66\u53bb\u9023\u63a5\u5728 MySQL \u4e0a\u7684 Hive Metastore\uff0c\u6210\u529f\u4f7f\u7528\u4e00\u6bb5\u6642\u9593\u4e4b\u5f8c\u6703\u6642\u4e0d\u6642\u5730\u9047\u5230\u9019\u500b Bug (org.datanucleus.exceptions.NucleusException: Index part #0 for `ROLES` already set)\uff0c\u5f8c\u4f86\u7684\u89e3\u6c7a\u65b9\u6cd5\u662f\u91cd\u65b0\u5275\u5efa MySQL \u7684\u4f7f\u7528\u8005\u3002\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/myoceane.fr\/index.php\/roles_already_set\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Hive] Index part #0 for `ROLES` already set - \u60f3\u65b9\u6d89\u6cd5 - \u91cf\u74f6\u5916\u7684\u5929\u7a7a M-Y-Oceane\" \/>\n<meta property=\"og:description\" content=\"\u6ab8\u6aac\u7238\u5728\u524d\u9762\u5e7e\u7bc7\u4ecb\u7d39\u4e86\u6709\u95dc Hive Metastore, Hive on Spark \u548c Spark Thrift Server \u7b49\u7b49\u7684\u89c0\u5ff5\uff0c\u672c\u7bc7\u60f3\u8981\u7d00\u9304\u4e00\u500b\u82b1\u4e86\u4e0d\u5c11\u6642\u9593\u7684\u9664\u932f\u904e\u7a0b\uff0c\u932f\u8aa4\u767c\u751f\u7684\u74b0\u5883\u662f\u5728 Spark Standalone \u7684\u53e2\u96c6\u4e0a\u555f\u52d5\u7684 Spark Thrift Server \u5617\u8a66\u53bb\u9023\u63a5\u5728 MySQL \u4e0a\u7684 Hive Metastore\uff0c\u6210\u529f\u4f7f\u7528\u4e00\u6bb5\u6642\u9593\u4e4b\u5f8c\u6703\u6642\u4e0d\u6642\u5730\u9047\u5230\u9019\u500b Bug (org.datanucleus.exceptions.NucleusException: Index part #0 for `ROLES` already set)\uff0c\u5f8c\u4f86\u7684\u89e3\u6c7a\u65b9\u6cd5\u662f\u91cd\u65b0\u5275\u5efa MySQL \u7684\u4f7f\u7528\u8005\u3002\" \/>\n<meta property=\"og:url\" content=\"https:\/\/myoceane.fr\/index.php\/roles_already_set\/\" \/>\n<meta property=\"og:site_name\" content=\"\u60f3\u65b9\u6d89\u6cd5 - \u91cf\u74f6\u5916\u7684\u5929\u7a7a M-Y-Oceane\" \/>\n<meta property=\"article:published_time\" content=\"2023-09-14T03:06:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-09-27T06:10:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/myoceane.fr\/wp-content\/uploads\/2022\/09\/HiveMetastore-scaled.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1509\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"\u6ab8\u6aac\u7238\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u6ab8\u6aac\u7238\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"17 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/myoceane.fr\/index.php\/roles_already_set\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/myoceane.fr\/index.php\/roles_already_set\/\"},\"author\":{\"name\":\"\u6ab8\u6aac\u7238\",\"@id\":\"https:\/\/myoceane.fr\/#\/schema\/person\/4a4552fb8c27693083d465e12db7658b\"},\"headline\":\"[Hive] Index part #0 for `ROLES` already set\",\"datePublished\":\"2023-09-14T03:06:18+00:00\",\"dateModified\":\"2023-09-27T06:10:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/myoceane.fr\/index.php\/roles_already_set\/\"},\"wordCount\":71,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/myoceane.fr\/#\/schema\/person\/4a4552fb8c27693083d465e12db7658b\"},\"image\":{\"@id\":\"https:\/\/myoceane.fr\/index.php\/roles_already_set\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/myoceane.fr\/wp-content\/uploads\/2022\/09\/HiveMetastore-scaled.jpeg\",\"keywords\":[\"Hive\",\"Spark\",\"Spark Thrift Server\"],\"articleSection\":[\"Big Data &amp; Machine Learning\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/myoceane.fr\/index.php\/roles_already_set\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/myoceane.fr\/index.php\/roles_already_set\/\",\"url\":\"https:\/\/myoceane.fr\/index.php\/roles_already_set\/\",\"name\":\"[Hive] Index part #0 for `ROLES` already set - \u60f3\u65b9\u6d89\u6cd5 - \u91cf\u74f6\u5916\u7684\u5929\u7a7a M-Y-Oceane\",\"isPartOf\":{\"@id\":\"https:\/\/myoceane.fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/myoceane.fr\/index.php\/roles_already_set\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/myoceane.fr\/index.php\/roles_already_set\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/myoceane.fr\/wp-content\/uploads\/2022\/09\/HiveMetastore-scaled.jpeg\",\"datePublished\":\"2023-09-14T03:06:18+00:00\",\"dateModified\":\"2023-09-27T06:10:58+00:00\",\"description\":\"\u6ab8\u6aac\u7238\u5728\u524d\u9762\u5e7e\u7bc7\u4ecb\u7d39\u4e86\u6709\u95dc Hive Metastore, Hive on Spark \u548c Spark Thrift Server \u7b49\u7b49\u7684\u89c0\u5ff5\uff0c\u672c\u7bc7\u60f3\u8981\u7d00\u9304\u4e00\u500b\u82b1\u4e86\u4e0d\u5c11\u6642\u9593\u7684\u9664\u932f\u904e\u7a0b\uff0c\u932f\u8aa4\u767c\u751f\u7684\u74b0\u5883\u662f\u5728 Spark Standalone \u7684\u53e2\u96c6\u4e0a\u555f\u52d5\u7684 Spark Thrift Server \u5617\u8a66\u53bb\u9023\u63a5\u5728 MySQL \u4e0a\u7684 Hive Metastore\uff0c\u6210\u529f\u4f7f\u7528\u4e00\u6bb5\u6642\u9593\u4e4b\u5f8c\u6703\u6642\u4e0d\u6642\u5730\u9047\u5230\u9019\u500b Bug (org.datanucleus.exceptions.NucleusException: Index part #0 for `ROLES` already set)\uff0c\u5f8c\u4f86\u7684\u89e3\u6c7a\u65b9\u6cd5\u662f\u91cd\u65b0\u5275\u5efa MySQL \u7684\u4f7f\u7528\u8005\u3002\",\"breadcrumb\":{\"@id\":\"https:\/\/myoceane.fr\/index.php\/roles_already_set\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/myoceane.fr\/index.php\/roles_already_set\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/myoceane.fr\/index.php\/roles_already_set\/#primaryimage\",\"url\":\"https:\/\/myoceane.fr\/wp-content\/uploads\/2022\/09\/HiveMetastore-scaled.jpeg\",\"contentUrl\":\"https:\/\/myoceane.fr\/wp-content\/uploads\/2022\/09\/HiveMetastore-scaled.jpeg\",\"width\":2560,\"height\":1509},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/myoceane.fr\/index.php\/roles_already_set\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/myoceane.fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Hive] Index part #0 for `ROLES` already set\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/myoceane.fr\/#website\",\"url\":\"https:\/\/myoceane.fr\/\",\"name\":\"M-Y-Oceane \u60f3\u65b9\u6d89\u6cd5\u3002\u91cf\u74f6\u5916\u7684\u5929\u7a7a\",\"description\":\"\u60f3\u65b9\u6d89\u6cd5, France, Taiwan, Health, Information Technology\",\"publisher\":{\"@id\":\"https:\/\/myoceane.fr\/#\/schema\/person\/4a4552fb8c27693083d465e12db7658b\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/myoceane.fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/myoceane.fr\/#\/schema\/person\/4a4552fb8c27693083d465e12db7658b\",\"name\":\"\u6ab8\u6aac\u7238\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/myoceane.fr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/6cc678684664f8ad45a8d56a6630b183?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/6cc678684664f8ad45a8d56a6630b183?s=96&d=mm&r=g\",\"caption\":\"\u6ab8\u6aac\u7238\"},\"logo\":{\"@id\":\"https:\/\/myoceane.fr\/#\/schema\/person\/image\/\"},\"url\":\"https:\/\/myoceane.fr\/index.php\/author\/johnny5584767gmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Hive] Index part #0 for `ROLES` already set - \u60f3\u65b9\u6d89\u6cd5 - \u91cf\u74f6\u5916\u7684\u5929\u7a7a M-Y-Oceane","description":"\u6ab8\u6aac\u7238\u5728\u524d\u9762\u5e7e\u7bc7\u4ecb\u7d39\u4e86\u6709\u95dc Hive Metastore, Hive on Spark \u548c Spark Thrift Server \u7b49\u7b49\u7684\u89c0\u5ff5\uff0c\u672c\u7bc7\u60f3\u8981\u7d00\u9304\u4e00\u500b\u82b1\u4e86\u4e0d\u5c11\u6642\u9593\u7684\u9664\u932f\u904e\u7a0b\uff0c\u932f\u8aa4\u767c\u751f\u7684\u74b0\u5883\u662f\u5728 Spark Standalone \u7684\u53e2\u96c6\u4e0a\u555f\u52d5\u7684 Spark Thrift Server \u5617\u8a66\u53bb\u9023\u63a5\u5728 MySQL \u4e0a\u7684 Hive Metastore\uff0c\u6210\u529f\u4f7f\u7528\u4e00\u6bb5\u6642\u9593\u4e4b\u5f8c\u6703\u6642\u4e0d\u6642\u5730\u9047\u5230\u9019\u500b Bug (org.datanucleus.exceptions.NucleusException: Index part #0 for `ROLES` already set)\uff0c\u5f8c\u4f86\u7684\u89e3\u6c7a\u65b9\u6cd5\u662f\u91cd\u65b0\u5275\u5efa MySQL \u7684\u4f7f\u7528\u8005\u3002","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/myoceane.fr\/index.php\/roles_already_set\/","og_locale":"en_US","og_type":"article","og_title":"[Hive] Index part #0 for `ROLES` already set - \u60f3\u65b9\u6d89\u6cd5 - \u91cf\u74f6\u5916\u7684\u5929\u7a7a M-Y-Oceane","og_description":"\u6ab8\u6aac\u7238\u5728\u524d\u9762\u5e7e\u7bc7\u4ecb\u7d39\u4e86\u6709\u95dc Hive Metastore, Hive on Spark \u548c Spark Thrift Server \u7b49\u7b49\u7684\u89c0\u5ff5\uff0c\u672c\u7bc7\u60f3\u8981\u7d00\u9304\u4e00\u500b\u82b1\u4e86\u4e0d\u5c11\u6642\u9593\u7684\u9664\u932f\u904e\u7a0b\uff0c\u932f\u8aa4\u767c\u751f\u7684\u74b0\u5883\u662f\u5728 Spark Standalone \u7684\u53e2\u96c6\u4e0a\u555f\u52d5\u7684 Spark Thrift Server \u5617\u8a66\u53bb\u9023\u63a5\u5728 MySQL \u4e0a\u7684 Hive Metastore\uff0c\u6210\u529f\u4f7f\u7528\u4e00\u6bb5\u6642\u9593\u4e4b\u5f8c\u6703\u6642\u4e0d\u6642\u5730\u9047\u5230\u9019\u500b Bug (org.datanucleus.exceptions.NucleusException: Index part #0 for `ROLES` already set)\uff0c\u5f8c\u4f86\u7684\u89e3\u6c7a\u65b9\u6cd5\u662f\u91cd\u65b0\u5275\u5efa MySQL \u7684\u4f7f\u7528\u8005\u3002","og_url":"https:\/\/myoceane.fr\/index.php\/roles_already_set\/","og_site_name":"\u60f3\u65b9\u6d89\u6cd5 - \u91cf\u74f6\u5916\u7684\u5929\u7a7a M-Y-Oceane","article_published_time":"2023-09-14T03:06:18+00:00","article_modified_time":"2023-09-27T06:10:58+00:00","og_image":[{"width":2560,"height":1509,"url":"https:\/\/myoceane.fr\/wp-content\/uploads\/2022\/09\/HiveMetastore-scaled.jpeg","type":"image\/jpeg"}],"author":"\u6ab8\u6aac\u7238","twitter_card":"summary_large_image","twitter_misc":{"Written by":"\u6ab8\u6aac\u7238","Est. reading time":"17 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/myoceane.fr\/index.php\/roles_already_set\/#article","isPartOf":{"@id":"https:\/\/myoceane.fr\/index.php\/roles_already_set\/"},"author":{"name":"\u6ab8\u6aac\u7238","@id":"https:\/\/myoceane.fr\/#\/schema\/person\/4a4552fb8c27693083d465e12db7658b"},"headline":"[Hive] Index part #0 for `ROLES` already set","datePublished":"2023-09-14T03:06:18+00:00","dateModified":"2023-09-27T06:10:58+00:00","mainEntityOfPage":{"@id":"https:\/\/myoceane.fr\/index.php\/roles_already_set\/"},"wordCount":71,"commentCount":0,"publisher":{"@id":"https:\/\/myoceane.fr\/#\/schema\/person\/4a4552fb8c27693083d465e12db7658b"},"image":{"@id":"https:\/\/myoceane.fr\/index.php\/roles_already_set\/#primaryimage"},"thumbnailUrl":"https:\/\/myoceane.fr\/wp-content\/uploads\/2022\/09\/HiveMetastore-scaled.jpeg","keywords":["Hive","Spark","Spark Thrift Server"],"articleSection":["Big Data &amp; Machine Learning"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/myoceane.fr\/index.php\/roles_already_set\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/myoceane.fr\/index.php\/roles_already_set\/","url":"https:\/\/myoceane.fr\/index.php\/roles_already_set\/","name":"[Hive] Index part #0 for `ROLES` already set - \u60f3\u65b9\u6d89\u6cd5 - \u91cf\u74f6\u5916\u7684\u5929\u7a7a M-Y-Oceane","isPartOf":{"@id":"https:\/\/myoceane.fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/myoceane.fr\/index.php\/roles_already_set\/#primaryimage"},"image":{"@id":"https:\/\/myoceane.fr\/index.php\/roles_already_set\/#primaryimage"},"thumbnailUrl":"https:\/\/myoceane.fr\/wp-content\/uploads\/2022\/09\/HiveMetastore-scaled.jpeg","datePublished":"2023-09-14T03:06:18+00:00","dateModified":"2023-09-27T06:10:58+00:00","description":"\u6ab8\u6aac\u7238\u5728\u524d\u9762\u5e7e\u7bc7\u4ecb\u7d39\u4e86\u6709\u95dc Hive Metastore, Hive on Spark \u548c Spark Thrift Server \u7b49\u7b49\u7684\u89c0\u5ff5\uff0c\u672c\u7bc7\u60f3\u8981\u7d00\u9304\u4e00\u500b\u82b1\u4e86\u4e0d\u5c11\u6642\u9593\u7684\u9664\u932f\u904e\u7a0b\uff0c\u932f\u8aa4\u767c\u751f\u7684\u74b0\u5883\u662f\u5728 Spark Standalone \u7684\u53e2\u96c6\u4e0a\u555f\u52d5\u7684 Spark Thrift Server \u5617\u8a66\u53bb\u9023\u63a5\u5728 MySQL \u4e0a\u7684 Hive Metastore\uff0c\u6210\u529f\u4f7f\u7528\u4e00\u6bb5\u6642\u9593\u4e4b\u5f8c\u6703\u6642\u4e0d\u6642\u5730\u9047\u5230\u9019\u500b Bug (org.datanucleus.exceptions.NucleusException: Index part #0 for `ROLES` already set)\uff0c\u5f8c\u4f86\u7684\u89e3\u6c7a\u65b9\u6cd5\u662f\u91cd\u65b0\u5275\u5efa MySQL \u7684\u4f7f\u7528\u8005\u3002","breadcrumb":{"@id":"https:\/\/myoceane.fr\/index.php\/roles_already_set\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/myoceane.fr\/index.php\/roles_already_set\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/myoceane.fr\/index.php\/roles_already_set\/#primaryimage","url":"https:\/\/myoceane.fr\/wp-content\/uploads\/2022\/09\/HiveMetastore-scaled.jpeg","contentUrl":"https:\/\/myoceane.fr\/wp-content\/uploads\/2022\/09\/HiveMetastore-scaled.jpeg","width":2560,"height":1509},{"@type":"BreadcrumbList","@id":"https:\/\/myoceane.fr\/index.php\/roles_already_set\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/myoceane.fr\/"},{"@type":"ListItem","position":2,"name":"[Hive] Index part #0 for `ROLES` already set"}]},{"@type":"WebSite","@id":"https:\/\/myoceane.fr\/#website","url":"https:\/\/myoceane.fr\/","name":"M-Y-Oceane \u60f3\u65b9\u6d89\u6cd5\u3002\u91cf\u74f6\u5916\u7684\u5929\u7a7a","description":"\u60f3\u65b9\u6d89\u6cd5, France, Taiwan, Health, Information Technology","publisher":{"@id":"https:\/\/myoceane.fr\/#\/schema\/person\/4a4552fb8c27693083d465e12db7658b"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/myoceane.fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/myoceane.fr\/#\/schema\/person\/4a4552fb8c27693083d465e12db7658b","name":"\u6ab8\u6aac\u7238","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/myoceane.fr\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6cc678684664f8ad45a8d56a6630b183?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6cc678684664f8ad45a8d56a6630b183?s=96&d=mm&r=g","caption":"\u6ab8\u6aac\u7238"},"logo":{"@id":"https:\/\/myoceane.fr\/#\/schema\/person\/image\/"},"url":"https:\/\/myoceane.fr\/index.php\/author\/johnny5584767gmail-com\/"}]}},"amp_enabled":false,"_links":{"self":[{"href":"https:\/\/myoceane.fr\/index.php\/wp-json\/wp\/v2\/posts\/9218","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/myoceane.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/myoceane.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/myoceane.fr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/myoceane.fr\/index.php\/wp-json\/wp\/v2\/comments?post=9218"}],"version-history":[{"count":17,"href":"https:\/\/myoceane.fr\/index.php\/wp-json\/wp\/v2\/posts\/9218\/revisions"}],"predecessor-version":[{"id":9312,"href":"https:\/\/myoceane.fr\/index.php\/wp-json\/wp\/v2\/posts\/9218\/revisions\/9312"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/myoceane.fr\/index.php\/wp-json\/wp\/v2\/media\/8950"}],"wp:attachment":[{"href":"https:\/\/myoceane.fr\/index.php\/wp-json\/wp\/v2\/media?parent=9218"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/myoceane.fr\/index.php\/wp-json\/wp\/v2\/categories?post=9218"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/myoceane.fr\/index.php\/wp-json\/wp\/v2\/tags?post=9218"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}