DQL Data Query¶
POST /api/v1/df/{workspace_uuid}/query_data
Overview¶
Route Parameters¶
| Parameter Name | Type | Required | Description |
|---|---|---|---|
| workspace_uuid | string | Y | The uuid of the workspace to query |
Body Request Parameters¶
| Parameter Name | Type | Required | Description |
|---|---|---|---|
| sceneUUID | string | Scene UUID Allow empty: False |
|
| dashboardUUID | string | Dashboard UUID Allow empty: False |
|
| testTimeout | float | Timeout for ban operation (effective in debug mode) Allow empty: False |
|
| queries | array | Multi-command query, whose content is a list of query objects Allow empty: False |
|
| fieldTagDescNeeded | boolean | Whether field or tag description information is needed Allow empty: False |
|
| expensiveQueryCheck | boolean | Whether to check for wildcard left * cases Allow empty: False |
|
| dataQueryPreview | json | Preview function for data access Allow empty: False |
|
| dataQueryPreview.maskFields | string | Masked fields, multiple fields separated by commas Example: message,host Allow empty: False Allow empty string: True |
|
| dataQueryPreview.reExprs | array | Regular expressions Example: [{'name': 'jjj', 'reExpr': 'ss', 'enable': 0}, {'name': 'lll', 'reExpr': 'ss', 'enable': 1}] Allow empty: False |
Parameter Additional Instructions¶
Query Instructions
- Queries Array Element Field Instructions
| Parameter Name | Type | Required | Description |
|---|---|---|---|
| sceneUUID | string | Y | Scene UUID |
| dashboardUUID | string | Y | Dashboard UUID |
| queries[*] | string | Y | Query List |
-
DQL JSON Structure Parameter Instructions (queries[*] Element)
-
Basic Fields *
| Parameter Name | Type | Required | Description |
|---|---|---|---|
| qtype | string | Y | Type of query statement dql: indicates dql type query statement; promql: indicates PromQl type query statement |
| query | json | Y | Query structure |
| query.q | string | Query statement consistent with qtype, such as dql or promql query statement | |
| query.promqlType | enum | Effective when qtype=promql, promql query type, optional values instantQuery and rangeQuery, default value rangeQuery |
|
| query.highlight | boolean | Whether to display highlighted data | |
| query.timeRange | array | Timestamp list of time range | |
| query.disableMultipleField | bool | Whether to enable single column mode, default is true |
|
| query.showLabel | bool | Whether to display object labels, default none | |
| query.funcList | array | Further aggregation to modify dql return value, note that when disableMultipleField=Flse, this parameter is invalid | |
| query.slimit | integer | Time series group size, only effective for metric queries | |
| query.soffset | integer | Time series group offset | |
| query.limit | integer | Pagination size | |
| query.offset | integer | Pagination offset | |
| query.orderby | array | Sorting list, {fieldName:method} , note that sorting for metric set queries only supports fieldName=time; method in ["desc", "asc"]; note that sorting for metric set queries only supports fieldName=time |
|
| query.sorderby | array | Sorting list, sorderby's column is an expression, supports all aggregation functions returning a single value min max last avg p90 p95 count, {fieldName:method}, structure consistent with orderby |
|
| query.order_by | array | Sorting list, structure is [{"column": "field", "order": "DESC"}], doris engine compatible field | |
| query.sorder_by | array | Sorting list, structure is [{"column": "field", "order": "DESC"}], doris engine compatible field | |
| query.density | string | Response point density, priority lower than autoDensity and higher than density set in dql statement | |
| query.interval | integer | Unit is seconds, time slice interval, used to calculate response points; calculated points less than or equal to density=high points are valid, otherwise invalid | |
| query.search_after | array | Pagination mark, returned by the current interface, used to pass in the next request | |
| query.maxPointCount | integer | Maximum points | |
| query.workspaceUUID | string | The uuid of the workspace to query | |
| query.output_format | string | lineprotocol: line protocol output, default if not filled, default keeps the existing output format unchanged | |
| query.cursor_time | integer | Segmented query threshold: when performing the first segmented query, cursor_time needs to be set to end_time; for subsequent segmented queries, cursor_time needs to be set to next_cursor_time in the response | |
| query.cursor_token | string | Pagination query token (returned by the engine cursor_token value): when performing pagination query, the next_cursor_token returned by the last query needs to be set as the cursor_token of this query; requests without cursor_token may cause data with the same timestamp to be skipped during pagination. | |
| query.disable_sampling | bool | Sampling disable switch, default value is false |
- Response Point Density
densityParameter Value Instructions *
| Optional Value | Description |
|---|---|
| lower | Lower, 60 points |
| low | Low, 180 points |
| medium | Medium, 360 points |
| high | Low, 720 points |
-
Note the priority of point density parameters, maximum density
density[high]* maxPointCount > interval > density > control parameters in dql statement -
Common Query Instructions