[HIVE-21272] information_schema.tables should also contain views

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Affects Version/s: 3.1.0
• Component/s: Database/Schema
• Assignee: Daniel Dai
• Reporter: Greg Rahn
• Created: 15/Feb/19 01:00
• Updated: 06/Mar/19 05:47

Description

Currently it appears that INFORMATION_SCHEMA.TABLES does not contain views.

Per the ISO SQL standard, 

The INFORMATION_SCHEMA.TABLES table contains one row for each table including views.

Example from Postgres:

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