[
https://issues.apache.org/jira/browse/DRILL-4176?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vitalii Diravka reassigned DRILL-4176:
--------------------------------------
Assignee: Vitalii Diravka
> 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
> Assignee: Vitalii Diravka
> Priority: Major
> Fix For: Future
>
>
> 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?
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
