GetMaterializedView - Simple Log Service - Alibaba Cloud Documentation Center

Retrieves a materialized view.

Try it now

Try this API in OpenAPI Explorer, no manual signing needed. Successful calls auto-generate SDK code matching your parameters. Download it with built-in credential security for local usage.

Test

RAM authorization

No authorization for this operation. If you encounter issues with this operation, contact technical support.

Request syntax

GET /materializedviews/{name} HTTP/1.1

Path Parameters

Parameter	Type	Required	Description	Example
name	string	No	The name of the data view.	my_storeview

Request parameters

Parameter	Type	Required	Description	Example
project	string	No	The name of the project.	ali-test-project
Content-Type	string	No	The content type of the response. Simple Log Service supports application/json and application/x-protobuf response types.	application/json
returnStatus	boolean	No	Specifies whether to return the materialized view status information.	false

Response elements

Element	Type	Description	Example
	object	Schema of Response
name	string	Id of the request	alert-123456
logstore	string	The Logstore from which the materialized view sources its data.	ali-test-logstore
originalSql	string	The original SQL statement executed by the materialized view.	* \| select count(*) from log
aggIntervalMins	integer	The aggregation interval of the materialized view results, in minutes.	5
startTime	integer	The time from which the materialized view starts processing data.	1448748198
ttl	integer	The number of days that the materialized view results are retained.	1
enabled	boolean	Indicates whether the materialized view is enabled.	false
createTime	integer	The time when the materialized view was created.	1722411060
shardCount	integer	The number of shards used by the Logstore that stores the materialized view data.	2
status	object	The status information of the materialized view.	{}
lastRunTime	integer	The time when the materialized view was last executed.	1787647228
maxCursorTime	integer	The latest position up to which the materialized view has processed data.	1787647228
lastRunError	string	The error message from the last execution of the materialized view.	column 'value' not defined
stats	object	The execute statistics information of the materialized view.	{}
hits	integer	The number of times the materialized view was used in the last day.	0
queries	array	The top 3 most frequently accelerated SQL statements by the materialized view.	[]
	string	The string type.	"select count(*) from log"

Examples

Success response

JSON format

{
  "name": "alert-123456",
  "logstore": "ali-test-logstore",
  "originalSql": "* | select count(*) from log",
  "aggIntervalMins": 5,
  "startTime": 1448748198,
  "ttl": 1,
  "enabled": false,
  "createTime": 1722411060,
  "shardCount": 2,
  "status": {
    "lastRunTime": 1787647228,
    "maxCursorTime": 1787647228,
    "lastRunError": "column 'value' not defined",
    "stats": {
      "hits": 0,
      "queries": [
        "\"select count(*) from log\""
      ]
    }
  }
}

Error codes

See Error Codes for a complete list.

Release notes

See Release Notes for a complete list.