|
Parameter |
Type |
Description |
Example |
|---|---|---|---|
|
object |
Materialized view summary data. |
||
| FirstRefreshTime |
string |
The time of the first refresh. |
2025-01-01 09:00:00 |
| QueryRewriteEnabled |
boolean |
Whether query rewrite is enabled for the materialized view. |
false |
| ExplicitHit |
integer |
The total number of explicit query hits in the last 7 days. |
5 |
| IsInactive |
boolean |
Indicates whether the materialized view has not been accessed by explicit or implicit queries for more than 30 days since its creation. |
false |
| RemoteSize |
integer |
The disk space that the materialized view occupies for cold data, in bytes. |
1234 |
| LocalSize |
integer |
The disk space that the materialized view occupies for hot data, in bytes. |
1234 |
| RefreshState |
string |
The refresh model of the materialized view. |
FAST |
| RefreshInterval |
string |
The refresh interval. |
(now() + INTERVAL '10' SECOND) |
| ImplicitHit |
integer |
The total number of implicit query hits in the last 7 days. |
20 |
| UpdatedAt |
string |
The time of the last refresh. |
2025-01-01 10:00:00 |
| ResourceGroup |
string |
The resource group on which the refresh depends. |
user_default |
| BaseTableInfos |
array |
All direct parent base tables of the materialized view. |
|
|
object |
|||
| SchemaName |
string |
The database name. |
test_db |
| TableName |
string |
The table name. |
test_tbl |
| BaseTableIsMv |
boolean |
Whether the base table is a materialized view. |
false |
| TableEngine |
string |
The table engine. |
XUANWU |
| TableEngine |
string |
The table engine. |
XUANWU |
| BaseTableNames |
array |
All direct parent base tables of the materialized view. |
|
|
array |
The database name and table name of the base table. |
||
|
string |
The database name or table name. |
t1 |
|
| EnableDelayAlert |
integer |
Indicates whether to enable alerting for refresh latency. Valid values:
|
false |
| EnableFailureAlert |
integer |
Indicates whether to enable alerting for refresh task failures. Valid values:
|
false |
| LatencyTolerance |
integer |
The refresh latency toleration, in minutes. |
2 |