[
https://issues.apache.org/jira/browse/DRILL-858?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Venki Korukanti updated DRILL-858:
----------------------------------
Attachment: DRILL-858-1.patch
Attaching patch which fixes bugs in handling Hive views in InfoSchema
generation.
Also:
- Added a new interface DrillViewInfoProvider which provides view related info
to components such as InfoSchema. Drill or Hive view table implement this
interface.
- Throw UnsupportedOperationException if any queries use Hive views as querying
Hive views is not supported in current version.
> 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
> Assignee: Venki Korukanti
> Fix For: 1.0.0-BETA1
>
> Attachments: DRILL-858-1.patch, 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)
