[DRILL-858] When we have a view in hive, none of the Information Schema queries work

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Component/s: Metadata, Storage - Hive
• Assignee: Venki Korukanti
• Reporter: Rahul Kumar Challapalli
• Created: 29/May/14 19:37
• Updated: 16/Apr/15 22:09
• Resolved: 12/Jun/14 16:48

Description

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