You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Rahul Challapalli (JIRA)" <ji...@apache.org> on 2014/05/29 21:39:01 UTC
[jira] [Created] (DRILL-858) When we have a view in hive, none of
the Information Schema queries work
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)