drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Devender Yadav (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-4176) Dynamic Schema Discovery is not done in case of Drill- Hive
Date Wed, 09 Dec 2015 06:27:11 GMT
Devender Yadav  created DRILL-4176:

             Summary: Dynamic Schema Discovery is not done in case of Drill- Hive
                 Key: DRILL-4176
                 URL: https://issues.apache.org/jira/browse/DRILL-4176
             Project: Apache Drill
          Issue Type: Bug
    Affects Versions: 1.3.0
            Reporter: Devender Yadav 

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

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?

This message was sent by Atlassian JIRA

View raw message