[HIVE-21301] Show tables statement to include views and materialized views

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.2.0, 4.0.0
• Fix Version/s: 3.2.0, 4.0.0-alpha-1
• Labels: TODOC3.2 pull-request-available
• Assignee: Jesus Camacho Rodriguez
• Reporter: Jesus Camacho Rodriguez
• Created: 21/Feb/19 02:29
• Updated: 17/Nov/22 08:55
• Resolved: 22/Feb/19 19:54

Description

HIVE-19974 introduced backwards incompatible change, with SHOW TABLES statement showing only managed/external tables in the system.
This issue will restore old behavior, with SHOW TABLES showing all queryable entities, including views and materialized views.
Instead, to provide information about table types, SHOW EXTENDED TABLES statement is introduced, which includes an additional column with the table type for each of the tables listed.
Besides, the possibility to filter the show tables statements with a WHERE `table_type` = 'ANY_TYPE' clause is introduced.

Issue Links

• duplicates: HIVE-21501 Invisible views using ODBC
• is duplicated by: HIVE-21501 Invisible views using ODBC
• is related to: IMPALA-8738 Add a column representing the type（table or view） in the show tables output
• relates to: HIVE-19974 Show tables statement includes views and materialized views
• links to: GitHub Pull Request #542