Skip to main content

MV_INFOS

mv_infos​

Name​

mv_infos

description​

Table function, generating temporary tables for asynchronous materialized views, which can view information about asynchronous materialized views created in a certain database.

This function is used in the from clause.

This funciton is supported since 2.1.0.

syntax​

mv_infos("database"="")

mv_infos() Table structure:

mysql> desc function mv_infos("database"="tpch100");
+--------------------+---------+------+-------+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+---------+------+-------+---------+-------+
| Id | BIGINT | No | false | NULL | NONE |
| Name | TEXT | No | false | NULL | NONE |
| JobName | TEXT | No | false | NULL | NONE |
| State | TEXT | No | false | NULL | NONE |
| SchemaChangeDetail | TEXT | No | false | NULL | NONE |
| RefreshState | TEXT | No | false | NULL | NONE |
| RefreshInfo | TEXT | No | false | NULL | NONE |
| QuerySql | TEXT | No | false | NULL | NONE |
| EnvInfo | TEXT | No | false | NULL | NONE |
| MvProperties | TEXT | No | false | NULL | NONE |
| MvPartitionInfo | TEXT | No | false | NULL | NONE |
| SyncWithBaseTables | BOOLEAN | No | false | NULL | NONE |
+--------------------+---------+------+-------+---------+-------+
12 rows in set (0.01 sec)
  • Id: Materialized View ID
  • Name: Materialized View Name
  • JobName: The job name corresponding to the materialized view
  • State: Materialized View State
  • SchemaChangeDetail: The reason why the materialized view State becomes a SchemeChange
  • RefreshState: Materialized view refresh status
  • RefreshInfo: Refreshing strategy information defined by materialized views
  • QuerySql: Query statements defined by materialized views
  • EnvInfo: Environmental information during the creation of materialized views
  • MvProperties: Materialized visual attributes
  • MvPartitionInfo: Partition information of materialized views
  • SyncWithBaseTables:Is it synchronized with the base table data? To see which partition is not synchronized, please use SHOW PARTITIONS

example​

  1. View all materialized views under db1
mysql> select * from mv_infos("database"="db1");
  1. View the materialized view named mv1 under db1
mysql> select * from mv_infos("database"="db1") where Name = "mv1";
  1. View the status of the materialized view named mv1 under db1
mysql> select State from mv_infos("database"="db1") where Name = "mv1";

keywords​

mv, infos