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