metastore.HiveMetaStore: admin role already exists InvalidObjectException(message:Role admin already exists.)

Stack Overflow | prometheus2305 | 4 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Hive CLI: DEBUG metastore.HiveMetaStore: admin role already exists

    Stack Overflow | 4 months ago | prometheus2305
    metastore.HiveMetaStore: admin role already exists InvalidObjectException(message:Role admin already exists.)

    Root Cause Analysis

    1. metastore.HiveMetaStore

      admin role already exists InvalidObjectException(message:Role admin already exists.)

      at org.apache.hadoop.hive.metastore.ObjectStore.addRole()
    2. Hive Metastore
      ObjectStore.addRole
      1. org.apache.hadoop.hive.metastore.ObjectStore.addRole(ObjectStore.java:3223)
      1 frame
    3. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:498)
      4 frames
    4. Hive Metastore
      RawStoreProxy.invoke
      1. org.apache.hadoop.hive.metastore.RawStoreProxy.invoke(RawStoreProxy.java:114)
      1 frame
    5. com.sun.proxy
      $Proxy6.addRole
      1. com.sun.proxy.$Proxy6.addRole(Unknown Source)
      1 frame
    6. Hive Metastore
      HiveMetaStoreClient.<init>
      1. org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultRoles_core(HiveMetaStore.java:656)
      2. org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultRoles(HiveMetaStore.java:645)
      3. org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:462)
      4. org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:66)
      5. org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:72)
      6. org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:5762)
      7. org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:199)
      7 frames
    7. Hive Query Language
      SessionHiveMetaStoreClient.<init>
      1. org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.<init>(SessionHiveMetaStoreClient.java:74)
      1 frame
    8. Java RT
      Constructor.newInstance
      1. sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      2. sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
      3. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
      4. java.lang.reflect.Constructor.newInstance(Constructor.java:423)
      4 frames
    9. Hive Metastore
      RetryingMetaStoreClient.getProxy
      1. org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1521)
      2. org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:86)
      3. org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:132)
      4. org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:104)
      4 frames
    10. Hive Query Language
      SessionState.start
      1. org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:3005)
      2. org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3024)
      3. org.apache.hadoop.hive.ql.metadata.Hive.getAllDatabases(Hive.java:1234)
      4. org.apache.hadoop.hive.ql.metadata.Hive.reloadFunctions(Hive.java:174)
      5. org.apache.hadoop.hive.ql.metadata.Hive.<clinit>(Hive.java:166)
      6. org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:503)
      6 frames
    11. org.apache.hadoop
      CliDriver.main
      1. org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:677)
      2. org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:621)
      2 frames
    12. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:498)
      4 frames
    13. Hadoop
      RunJar.main
      1. org.apache.hadoop.util.RunJar.run(RunJar.java:221)
      2. org.apache.hadoop.util.RunJar.main(RunJar.java:136)
      2 frames