Mailing-List: contact issues-help@drill.incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@drill.incubator.apache.org
Date: Thu, 29 May 2014 19:41:01 +0000 (UTC)
From: "Rahul Challapalli (JIRA)" <jira@apache.org>
To: issues@drill.incubator.apache.org
Message-ID: <JIRA.12717344.1401392263546.41731.1401392461445@arcas>
In-Reply-To: <JIRA.12717344.1401392263546@arcas>
References: <JIRA.12717344.1401392263546@arcas>
Subject: [jira] [Commented] (DRILL-858) When we have a view in hive, none of
 the Information Schema queries work
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/DRILL-858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14012783#comment-14012783 ] 

Rahul Challapalli commented on DRILL-858:
-----------------------------------------

Querying against any table in INFORMATION_SCHEMA is giving the same problem.

> 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)