[
https://issues.apache.org/jira/browse/HIVE-21272?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Daniel Dai reassigned HIVE-21272:
---------------------------------
Assignee: Daniel Dai
> information_schema.tables should also contain views
> ---------------------------------------------------
>
> Key: HIVE-21272
> URL: https://issues.apache.org/jira/browse/HIVE-21272
> Project: Hive
> Issue Type: Bug
> Components: Database/Schema
> Affects Versions: 3.1.0
> Reporter: Greg Rahn
> Assignee: Daniel Dai
> Priority: Critical
>
> Currently it appears that INFORMATION_SCHEMA.TABLES does not contain views.
> Per the ISO SQL standard,
> {quote}
> The INFORMATION_SCHEMA.TABLES table contains one row for each table
> {color:red}including views.{color}
> {quote}
> Example from Postgres:
> {noformat}
> create table t (i int);
> create view v as select i from t;
> select
> table_catalog,
> table_schema,
> table_name,
> table_type
> from information_schema.tables
> where table_name in ('t','v');
> table_catalog | table_schema | table_name | table_type
> ---------------+--------------+------------+------------
> grahn | public | t | BASE TABLE
> grahn | public | v | VIEW
> {noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
