You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Devender Yadav (JIRA)" <ji...@apache.org> on 2015/12/09 07:27:11 UTC
[jira] [Created] (DRILL-4176) Dynamic Schema Discovery is not done
in case of Drill- Hive
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
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
(v6.3.4#6332)