You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Jesus Camacho Rodriguez (JIRA)" <ji...@apache.org> on 2016/08/09 17:35:20 UTC

[jira] [Created] (HIVE-14495) Add SHOW MATERIALIZED VIEWS statement

Jesus Camacho Rodriguez created HIVE-14495:
----------------------------------------------

             Summary: Add SHOW MATERIALIZED VIEWS statement
                 Key: HIVE-14495
                 URL: https://issues.apache.org/jira/browse/HIVE-14495
             Project: Hive
          Issue Type: Sub-task
          Components: Materialized views
    Affects Versions: 2.2.0
            Reporter: Jesus Camacho Rodriguez


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

{code:sql}
SHOW MATERIALIZED VIEWS [IN database_name] ['identifier_with_wildcards'];
{sql}

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



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)