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)