Dynamic Schema Discovery is not done in case of Drill- Hive

[Devender Yadav]

Hi All,

I am using hive with drill.

*Storage Plugin* info:

{
  "type": "hive",
  "enabled": true,
  "configProps": {
    "hive.metastore.uris": "",
    "javax.jdo.option.ConnectionURL":
"jdbc:mysql://localhost:3306/metastore_hive",
    "javax.jdo.option.ConnectionDriverName": "com.mysql.jdbc.Driver",
    "javax.jdo.option.ConnectionUserName": "root",
    "javax.jdo.option.ConnectionPassword": "root",
    "hive.metastore.warehouse.dir": "/user/hive/warehouse",
    "fs.default.name": "file:///",
    "hive.metastore.sasl.enabled": "false"
  }
}

It's working fine for querying and all.

*Then I wanted to check whether it automatically discover newly created
tables in hive or not.*

I started drill in embedded mode and used a particular database in hive
using

use hive.testDB;

Here testDB is a database in Hive with tables t1 & t2. Then I queried:

show tables;

It gave me table names

t1
t2

I created a table t3 in hive and again fired show tables; in Drill. It's
still showing t1 t2. After 5-10 min I fired show tables; again and it's
showing t1 t2 t3.

I think it should show t3 immediately after adding t3 in hive.

What can be reason for this behavior and how drill is handling it
internally?



Regards,
Devender