drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Nadeau (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-751) INFORMATION_SCHEMA.TABLES shows the view as a table
Date Mon, 09 Jun 2014 05:35:25 GMT

     [ https://issues.apache.org/jira/browse/DRILL-751?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Jacques Nadeau updated DRILL-751:
---------------------------------

    Component/s: Metadata

> INFORMATION_SCHEMA.TABLES shows the view as a table
> ---------------------------------------------------
>
>                 Key: DRILL-751
>                 URL: https://issues.apache.org/jira/browse/DRILL-751
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Metadata
>            Reporter: Rahul Challapalli
>            Assignee: Venki Korukanti
>            Priority: Minor
>
> 1. create view v1 as select * from `/drill/testdata/views/dfs/parquet/rankings`;
> 2. select * from INFORMATION_SCHEMA.`TABLES`; (shows the view as table)
> +---------------+--------------+------------+------------+
> | TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | TABLE_TYPE |
> +---------------+--------------+------------+------------+
> | DRILL         | hive.test    | t1         | TABLE      |
> | DRILL         | dfs.drillTestDirViews | v1         | TABLE      |
> | DRILL         | sys          | drillbits  | TABLE      |
> | DRILL         | sys          | options    | TABLE      |
> | DRILL         | INFORMATION_SCHEMA | VIEWS      | TABLE      |
> | DRILL         | INFORMATION_SCHEMA | COLUMNS    | TABLE      |
> | DRILL         | INFORMATION_SCHEMA | TABLES     | TABLE      |
> | DRILL         | INFORMATION_SCHEMA | CATALOGS   | TABLE      |
> | DRILL         | INFORMATION_SCHEMA | SCHEMATA   | TABLE      |
> +---------------+--------------+------------+------------+



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message