[jira] [Created] (HIVE-21272) information_schema.tables should also contain views

["Greg Rahn (JIRA)" <ji...@apache.org>]

Greg Rahn created HIVE-21272:
--------------------------------

             Summary: 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


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_schema = 'public'
and 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)