[HIVE-14495] Add SHOW MATERIALIZED VIEWS statement

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.2.0
• Fix Version/s: 3.0.0
• Component/s: Materialized views
• Labels: TODOC3.0
• Assignee: Jesús Camacho Rodríguez
• Reporter: Jesús Camacho Rodríguez
• Created: 09/Aug/16 17:34
• Updated: 27/Feb/24 22:24
• Resolved: 15/Nov/17 16:51

Description

In the spirit of SHOW TABLES, we should support the following statement:

SHOW MATERIALIZED VIEWS [IN database_name] ['identifier_with_wildcards'];

In contrast to SHOW TABLES, this command would only list the materialized views.

Issue Links

• is related to: HIVE-18843 Improve information shown by SHOW MATERIALIZED VIEWS statement
• links to: RB link