Using Apache HiveQL
Also available as:
PDF

Show materialized views

You can list all materialized views in the current database or in another database.

  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;