Rahul Challapalli created DRILL-858:
---------------------------------------
Summary: When we have a view in hive, none of the Information
Schema queries work
Key: DRILL-858
URL: https://issues.apache.org/jira/browse/DRILL-858
Project: Apache Drill
Issue Type: Bug
Components: Metadata, Storage - Hive
Reporter: Rahul Challapalli
Attachments: lilith.log, rankings.txt
Following the below steps can reproduce the error. I attached the lilith logs
and data files to the jira
git.commit.id.abbrev=70fab8c
hive> DROP TABLE IF EXISTS rankings;
CREATE EXTERNAL TABLE rankings (
pageRank INT,
pageURL STRING,
avgDuration INT
)
ROW FORMAT DELIMITED FIELDS
TERMINATED BY '|'
STORED AS TEXTFILE LOCATION "/drill/testdata/views/hive/rankings/";
CREATE VIEW v1 AS SELECT * FROM RANKINGS;
drill> select * from INFORMATION_SCHEMA.`TABLES`;
Note : There could be a lag between creating a view in hive and drill picking
it up. So we might need to wait for sometime before hitting the error
--
This message was sent by Atlassian JIRA
(v6.2#6252)
