Jesus Camacho Rodriguez created HIVE-21301:
----------------------------------------------
Summary: Show tables statement to include views and materialized
views
Key: HIVE-21301
URL: https://issues.apache.org/jira/browse/HIVE-21301
Project: Hive
Issue Type: Bug
Affects Versions: 4.0.0, 3.2.0
Reporter: Jesus Camacho Rodriguez
Assignee: Jesus Camacho Rodriguez
HIVE-19974 introduced backwards incompatible change, with {{SHOW TABLES}}
statement showing only tables in the system.
This issue will restore old behavior, with {{SHOW TABLES}} showing all
queryable entities, including views and materialized views.
In addition, {{SHOW EXTENDED TABLES}} statement is introduced, which includes
an additional column with the table type for each of the tables listed.
Finally, the possibility to filter the show tables statements with a {{WHERE
`table_type` = 'ANY_TYPE'}} clause is introduced.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
