tencent cloud

All product documents
TencentDB for CTSDB
DocumentationTencentDB for CTSDBHTTP API ReferencesCTSDB 1.0Batch Querying Data
Batch Querying Data
Download PDF
Last updated: 2023-03-02 14:42:21
Batch Querying Data
Last updated: 2023-03-02 14:42:21
Download PDF

Request address

The address is the instance IP and port, such as 10.13.20.15:9200, which can be obtained in the console.

Request path and method

Path: /_msearch Method: GET

Request parameters

You can set the _routing parameter during data write to improve the query efficiency as instructed in the sample. You can also set the filter_path parameter to filter and simplify the returned results. Its value contains multiple JSON paths separated by comma, and each JSON path is constructed by concatenating elements with dots. You can also use the * wildcard to match any character, the * * wildcard to match any path, and the - prefix to remove certain returned fields. For example, responses._shards.f* indicates fields starting with "f" in _shards in responses, and responses.* * ._score indicates all _score fields in responses.

Request content

Queries mainly include regular queries and aggregate queries. Query requests are fully compatible with Elasticsearch APIs. For the specific request content, see the samples.

Response

You can check whether a request is successful based on the error field. If the response content contains the error field, the request failed. For the error details, see the error field description. Some common returned fields for queries are as detailed below. You can set the filter_path parameter to simplify the returned query results.
Field name
Description
hits
Matched query results. Here, the total field indicates the number of matched data records. The hits field is an array, which contains the first ten query results if not specified. Each result in the hits array contains _index (child metric as described in Creating Metric involved in the query). If docvalue_fields is specified in the query, the fields field will be returned to indicate the value of each field.
took
Time in milliseconds taken by the entire query.
_shards
Number of shards involved in the query. Here, total indicates the total number of shards, successful the shards that were successfully queried, failed the shards that failed to be queried, and skipped skipped shards.
timed_out
Indicates whether query timed out. Valid values: false, true.
status
Status code returned for the query. 2XX indicates success.

Sample code for curl

Request without the filter_path parameter:
Request:
curl -u root:le201909 -H 'Content-Type:application/json' -X GET 172.16.345.14:9201/_msearch -d'
{"index" : "amyli_weather","routing":"host_20"}
{"query" : {"match_all" : {}}, "from" : 0, "size" : 10}
{"index" : "ctsdb_test2017","routing":"host_100"}
{"query" : {"match_all" : {}}, "from" : 0, "size" : 10}
'
Response:
{
      "responses": 
        [
            {
              "took": 0,
              "timed_out": false,
              "_shards": {
                "total": 0,
                "successful": 0,
                "skipped": 0,
                "failed": 0
              },
              "hits": {
                "total": 0,
                "max_score": 0,
                "hits": []
              },
              "status": 200
            },
            {
              "took": 1,
              "timed_out": false,
              "_shards": {
                "total": 3,
                "successful": 3,
                "skipped": 0,
                "failed": 0
              },
              "hits": {
                "total": 1,
                "max_score": 1,
                "hits": [
                  {
                    "_index": "ctsdb_test2017@-979200000_30",
                    "_type": "doc",
                    "_id": "AV_8fBhlUAkC9PF9L-2t",
                    "_score": 1
                  }
                ]
              },
              "status": 200
            }
      	]
    }
Request with the filter_path parameter:
Request:
curl -u root:le201909 -H 'Content-Type:application/json' -X GET 172.16.345.14:9201/_msearch?filter_path=responses.\\*\\*.hits,responses._shards.f\\*,-responses.\\*\\*._score -d'
{"index" : "amyli_weather","routing":"host_20"}
{"query" : {"match_all" : {}}, "from" : 0, "size" : 10}
{"index" : "ctsdb_test2017","routing":"host_100"}
{"query" : {"match_all" : {}}, "from" : 0, "size" : 10}
'
Response:
{
      "responses": [
    {
      "_shards": {
        "failed": 0
      }
    },
    {
      "_shards": {
        "failed": 0
      },
      "hits": {
        "hits": [
          {
            "_index": "ctsdb_test2017@-979200000_30",
            "_type": "doc",
            "_id": "AV_8fBhlUAkC9PF9L-2t"
          }
        ]
      }
    }
      ]
    }
Notes
If both match and filter conditions are set in the filter_path parameter, the filter condition will be applied first for the returned results and then the match condition.
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback

Contact Us

Contact our sales team or business advisors to help your business.

Contact Us
Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 available.

Submit a Ticket
7x24 Phone Support
Hong Kong, China
+852 800 906 020 (Toll Free)
United States
+1 844 606 0804 (Toll Free)
United Kingdom
+44 808 196 4551 (Toll Free)
Canada
+1 888 605 7930 (Toll Free)
Australia
+61 1300 986 386 (Toll Free)
EdgeOne hotline
+852 300 80699
More local hotlines coming soon