inspect_mv_meta
inspect_mv_meta(mv_name)
This function returns verbose metadata of a materialized view.
Argumentsβ
mv_name
: The name of the materialized view (VARCHAR).
Return Valueβ
Returns a VARCHAR string containing the verbose metadata of the materialized view.
Examplesβ
Example 1: Inspect a materialized view's internal metadata:
mysql> select inspect_mv_meta('mv_on_view_1');
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| inspect_mv_meta('mv_on_view_1') |
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| {"clazz":"LakeMaterializedView","dbId":28651,"refreshScheme":{"moment":"IMMEDIATE","type":"ASYNC","asyncRefreshContext":{"baseTableVisibleVersionMap":{"28673":{"ss":{"id":28672,"version":4,"lastRefreshTime":1751439875145,"lastFileModifiedTime":-1,"fileNumber":-1}}},"baseTableInfoVisibleVersionMap":{},"mvPartitionNameRefBaseTablePartitionMap":{},"defineStartTime":false,"starTime":1751442848,"step":0},"lastRefreshTime":1751439875145},"baseTableInfos":[{"catalogName":"default_catalog","dbId":28651,"tableId":28673,"dbName":"test","tableName":"ss"},{"catalogName":"default_catalog","dbId":28651,"tableId":28805,"dbName":"test","tableName":"view1"}],"active":true,"viewDefineSql":"SELECT `test`.`view1`.`event_day`, `test`.`view1`.`sum_pv`\nFROM `test`.`view1`","simpleDefineSql":"SELECT `view1`.`event_day`, `view1`.`sum_pv`\nFROM `test`.`view1`","originalViewDefineSql":"select * from view1","partitionRefTableExprs":[],"maxMVRewriteStaleness":0,"partitionExprMaps":{},"queryOutputIndices":[],"warehouseId":0,"state":"NORMAL","indexIdToMeta":{"28807":{"indexId":28807,"schema":[{"name":"event_day","columnId":"event_day","uniqueId":-1,"type":{"clazz":"ScalarType","type":"DATE","len":-1,"precision":0,"scale":0},"isAggregationTypeImplicit":false,"isKey":true,"isAllowNull":true,"isAutoIncrement":false,"comment":"","stats":{"avgSerializedSize":-1.0,"maxSize":-1,"numDistinctValues":-1,"numNulls":-1},"physicalName":""},{"name":"sum_pv","columnId":"sum_pv","uniqueId":-1,"type":{"clazz":"ScalarType","type":"BIGINT","len":-1,"precision":0,"scale":0},"isAggregationTypeImplicit":false,"isKey":true,"isAllowNull":true,"isAutoIncrement":false,"comment":"","stats":{"avgSerializedSize":-1.0,"maxSize":-1,"numDistinctValues":-1,"numNulls":-1},"physicalName":""}],"schemaVersion":0,"schemaHash":1933831807,"schemaId":28807,"shortKeyColumnCount":2,"storageType":"COLUMN","keysType":"DUP_KEYS","dbId":0,"isColocateMVIndex":false}},"indexNameToId":{"mv_on_view_1":28807},"keysType":"DUP_KEYS","partitionInfo":{"clazz":"SinglePartitionInfo","type":"UNPARTITIONED","idToDataProperty":{"28820":{"storageMedium":"HDD","cooldownTimeMs":253402271999000}},"idToReplicationNum":{"28820":1},"isMultiColumnPartition":false,"idToInMemory":{"28820":false},"idToStorageCacheInfo":{"28820":{"cacheInfoBytes":[8,1,16,-1,-1,-1,-1,-1,-1,-1,-1,-1,1]}}},"idToPartition":{"28820":{"id":28820,"name":"mv_on_view_1","state":"NORMAL","dpid":28821,"idToSubPartition":{"28821":{"id":28821,"name":"mv_on_view_1_28819_28821","parentId":28820,"shardGroupId":8170,"isImmutable":false,"baseIndex":{"id":28807,"state":"NORMAL","rowCount":0,"virtualBuckets":[28822,28823,28824,28825,28826,28827,28828,28829],"tablets":[{"clazz":"LakeTablet","dataSize":0,"rowCount":0,"dataSizeUpdateTime":0,"id":28822,"signature":-1,"lastCheckTime":-1},{"clazz":"LakeTablet","dataSize":0,"rowCount":0,"dataSizeUpdateTime":0,"id":28823,"signature":-1,"lastCheckTime":-1},{"clazz":"LakeTablet","dataSize":0,"rowCount":0,"dataSizeUpdateTime":0,"id":28824,"signature":-1,"lastCheckTime":-1},{"clazz":"LakeTablet","dataSize":0,"rowCount":0,"dataSizeUpdateTime":0,"id":28825,"signature":-1,"lastCheckTime":-1},{"clazz":"LakeTablet","dataSize":0,"rowCount":0,"dataSizeUpdateTime":0,"id":28826,"signature":-1,"lastCheckTime":-1},{"clazz":"LakeTablet","dataSize":0,"rowCount":0,"dataSizeUpdateTime":0,"id":28827,"signature":-1,"lastCheckTime":-1},{"clazz":"LakeTablet","dataSize":0,"rowCount":0,"dataSizeUpdateTime":0,"id":28828,"signature":-1,"lastCheckTime":-1},{"clazz":"LakeTablet","dataSize":0,"rowCount":0,"dataSizeUpdateTime":0,"id":28829,"signature":-1,"lastCheckTime":-1}],"shardGroupId":8170,"signature":-1,"lastCheckTime":-1},"idToVisibleRollupIndex":{},"idToShadowIndex":{},"visibleVersion":2,"visibleVersionTime":1751442848573,"nextVersion":3,"dataVersion":2,"nextDataVersion":3,"versionEpoch":364078271679168512,"versionTxnType":"TXN_NORMAL","metadataSwitchVersion":0,"bucketNum":8,"signature":-1,"lastCheckTime":-1}},"distributionInfo":{"clazz":"RandomDistributionInfo","b":8,"typeStr":"RANDOM","type":"RANDOM"},"shardGroupId":-1,"isImmutable":false,"idToVisibleRollupIndex":{},"idToShadowIndex":{},"visibleVersion":0,"visibleVersionTime":0,"nextVersion":0,"dataVersion":0,"nextDataVersion":0,"versionEpoch":0,"signature":-1,"lastCheckTime":-1}},"defaultDistributionInfo":{"clazz":"RandomDistributionInfo","b":0,"typeStr":"RANDOM","type":"RANDOM"},"tempPartitions":{"idToPartition":{}},"bfFpp":0.0,"indexes":{"indexes":[],"properties":{}},"baseIndexId":28807,"tableProperty":{"properties":{"replicated_storage":"true","replication_num":"1"},"compressionLevel":-1,"hasDelete":false,"hasForbitGlobalDict":false,"storageInfo":{"storeInfoBytes":[10,-123,2,8,1,18,32,115,116,97,114,114,111,99,107,115,45,99,108,111,117,100,45,100,97,116,97,45,122,104,97,110,103,106,105,97,107,111,117,26,-108,1,10,32,115,116,97,114,114,111,99,107,115,45,99,108,111,117,100,45,100,97,116,97,45,122,104,97,110,103,106,105,97,107,111,117,26,40,111,115,115,45,99,110,45,122,104,97,110,103,106,105,97,107,111,117,45,105,110,116,101,114,110,97,108,46,97,108,105,121,117,110,99,115,46,99,111,109,34,60,18,58,10,24,76,84,65,73,53,116,81,68,100,114,87,77,54,81,56,54,111,68,90,122,77,69,98,102,18,30,73,82,109,109,106,115,50,119,117,121,102,104,108,67,121,55,121,122,86,74,88,81,106,73,90,104,73,100,114,73,42,8,88,88,88,88,88,88,88,88,50,22,98,117,105,108,116,105,110,95,115,116,111,114,97,103,101,95,118,111,108,117,109,101,56,1,82,46,115,51,58,47,47,115,116,97,114,114,111,99,107,115,45,99,108,111,117,100,45,100,97,116,97,45,122,104,97,110,103,106,105,97,107,111,117,47,88,88,88,88,88,88,88,88,18,97,115,51,58,47,47,115,116,97,114,114,111,99,107,115,45,99,108,111,117,100,45,100,97,116,97,45,122,104,97,110,103,106,105,97,107,111,117,47,88,88,88,88,88,88,88,88,47,57,53,99,48,56,55,49,53,45,55,102,53,57,45,52,48,57,50,45,98,50,101,48,45,102,97,49,53,48,57,56,101,98,100,101,102,47,100,98,50,56,54,53,49,47,50,56,56,48,54],"cacheInfoBytes":[8,1,16,-1,-1,-1,-1,-1,-1,-1,-1,-1,1]}},"maxColUniqueId":-1,"maxIndexId":-1,"id":28806,"name":"mv_on_view_1","type":"LAKE_MATERIALIZED_VIEW","createTime":1751442848,"fullSchema":[{"name":"event_day","columnId":"event_day","uniqueId":-1,"type":{"clazz":"ScalarType","type":"DATE","len":-1,"precision":0,"scale":0},"isAggregationTypeImplicit":false,"isKey":true,"isAllowNull":true,"isAutoIncrement":false,"comment":"","stats":{"avgSerializedSize":-1.0,"maxSize":-1,"numDistinctValues":-1,"numNulls":-1},"physicalName":""},{"name":"sum_pv","columnId":"sum_pv","uniqueId":-1,"type":{"clazz":"ScalarType","type":"BIGINT","len":-1,"precision":0,"scale":0},"isAggregationTypeImplicit":false,"isKey":true,"isAllowNull":true,"isAutoIncrement":false,"comment":"","stats":{"avgSerializedSize":-1.0,"maxSize":-1,"numDistinctValues":-1,"numNulls":-1},"physicalName":""}],"comment":"","mvs":[],"signature":-1,"lastCheckTime":-1} |
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.01 sec)