Using Apache HiveQL
Also available as:
PDF

Show materialized views

You can list all or a filtered list of materialized views in all databases or a specific database.

You can use regular expression wildcards to filter the list of materialized views you want to see. The following wildcards are supported:
  • Asterisk (*)

    Represents one or more characters.

  • Pipe symbol (|)

    Represents a choice.

For example, mv_q* and *mv|q1* match the materialized view mv_q1. Finding no match does not cause an error.

  1. List materialized views in the current database.
    SHOW MATERIALIZED VIEWS;
  2. List materialized views in a particular database.
    SHOW MATERIALIZED VIEWS IN my_database;
  3. Show materialized views having names that begin with mv.
    SHOW MATERAILIZED VIEWS mv*