Re: Question on hive storage plugin

[Wes Peng]

I updated the configuration to this:

{
  "type": "hive",
  "configProps": {
    "hive.metastore.uris": "",
    "javax.jdo.option.ConnectionURL": 
"jdbc:derby:;databaseName=/tmp/drill_hive_db;create=true",
    "hive.metastore.warehouse.dir": "/tmp/drill_hive_wh",
    "fs.default.name": "file:///",
    "hive.metastore.sasl.enabled": "false"
  }
}
And it does not work either.
The log in drill console shows:

 ERROR o.a.h.h.metastore.RetryingHMSHandler - HMSHandler Fatal error: 
MetaException(message:Version information not found in metastore.)


all my haddop, hive are default installed.
They can work separately.

But I don't know how to add drill storage for hive.

Thanks.


On 2022/4/3 8:08 , Wes Peng wrote:

I am running all the HDFS/Hive/Drill in local node for test purpose.

drill: 3.1.2
hadoop: 3.3.1
hive: 2.3.9

hiveserver2 is running there and port 10000 is ready for thrift 
connection. (for which I can connect via beeline.)

Hadoop namenode has the default service running: localhost:9000


When I tried to add the storage plugin from drill's web interface:

{
         "type": "hive",
         "configProps": {
             "hive.metastore.uris": "thrift://127.0.0.1:10000",
             "hive.metastore.sasl.enabled": "false",
             "fs.default.name": "hdfs://127.0.0.1:9000"
         },
        "enabled": true
}