SQL Functions
Overview
These functions return the results of a user-defined SQL query.
Reference
executeSqlQuery
executeSqlQuery(string query) collection[collection[string]]
Returns the result of SQL query
. The first row contains headers consisting of column labels.
The response is limited to 1,000 rows.
If query q
is empty or not valid, an error is thrown.
Examples:
executeSqlQuery('SELECT datetime, value FROM http.sessions WHERE datetime > current_hour LIMIT 2')
[
[datetime, value],
[2018-01-25T19:00:12.346Z, 1],
[2018-01-25T19:00:27.347Z, 1]
]
executeSqlQuery("SELECT entity, avg(value) AS \"Average Value\" " +
"FROM jvm_memory_used WHERE datetime > current_hour GROUP BY entity")
[
[entity, Average Value],
[atsd, 467675162.105]
]
query = 'SELECT datetime, value FROM http.sessions WHERE datetime > current_hour LIMIT 2'
//
addTable(executeSqlQuery(query), 'ascii', true)
+--------------------------+-------+
| datetime | value |
+--------------------------+-------+
| 2018-01-26T13:00:14.098Z | 23 |
| 2018-01-26T13:00:29.110Z | 22 |
+--------------------------+-------+