1.restfu查询方式:
首先设置滚动查询并设置超时时间
curl -H "Content-Type: application/json" -u root:111111 -XPOST '172.16.17.212:9201/t3/_search?pretty&scroll=1m' -d '{"sort":"t1"}'
返回的结果会带有这次滚动查询的scroll_id用于接下来的查询:
{
"_scroll_id" : "DnF1ZXJ5VGhlbkZldGNoBgAAAAAAAAFJFlB5N0txeVRlVG5xTU9xUWFhTkIzTEEAAAAAAAABTBZQeTdLcXlUZVRucU1PcVFhYU5CM0xBAAAAAAAAAUoWUHk3S3F5VGVUbnFNT3FRYWFOQjNMQQAAAAAAAAFNFlB5N0txeVRlVG5xTU9xUWFhTkIzTEEAAAAAAAABSxZQeTdLcXlUZVRucU1PcVFhYU5CM0xBAAAAAAAAAU4WUHk3S3F5VGVUbnFNT3FRYWFOQjNMQQ==",
"took" : 5,
"timed_out" : false,
"_shards" : {
"total" : 6,
"successful" : 6,
"skipped" : 0,
"failed" : 0
},
"hits" : {
"total" : 200,
"max_score" : null,
"hits" : [
{
"_index" : "t3_20190423",
"_type" : "20190423",
"_id" : "PpcISWoBwQxG9TTQoTR-",
"_score" : null,
"_source" : {
"t1" : "1",
"t2" : "1",
"t3" : "caster",
"t4" : "20190423181850"
},
"sort" : [
1
]
},
{
"_index" : "t3_20190423",
"_type" : "20190423",
"_id" : "R5cISWoBwQxG9TTQoTR_",
"_score" : null,
"_source" : {
"t1" : "10",
"t2" : "1",
"t3" : "caster",
"t4" : "20190423181850"
},
"sort" : [
10
]
}
]
}
}
接下来的查询使用返回的id进行查询即可:
curl -H "Content-Type: application/json" -u root:111111 -XPOST '172.16.17.212:9201/_search/scroll?pretty' -d '{ "scroll" : "1m","scroll_id":"DnF1ZXJ5VGhlbkZldGNoBgAAAAAAAAFJFlB5N0txeVRlVG5xTU9xUWFhTkIzTEEAAAAAAAABTBZQeTdLcXlUZVRucU1PcVFhYU5CM0xBAAAAAAAAAUoWUHk3S3F5VGVUbnFNT3FRYWFOQjNMQQAAAAAAAAFNFlB5N0txeVRlVG5xTU9xUWFhTkIzTEEAAAAAAAABSxZQeTdLcXlUZVRucU1PcVFhYU5CM0xBAAAAAAAAAU4WUHk3S3F5VGVUbnFNT3FRYWFOQjNMQQ=="}'
2.SQL查询方式:
xpack.sql使用方式如下:通过fetch_size进行分页设置
curl -H "Content-Type: application/json" -u root:111111 -XPOST '172.16.17.213:9200/_xpack/sql?format=json' -d '{"query":"select * from t1", "fetch_size": 5}'
返回结果如下:除了带有查询结果,还带有cursor用于后续查询
{
"columns": [
{
"name": "t1",
"type": "keyword"
},
{
"name": "t2",
"type": "keyword"
},
{
"name": "t3",
"type": "keyword"
},
{
"name": "t4",
"type": "long"
},
{
"name": "t5",
"type": "text"
},
{
"name": "t6",
"type": "geo_point"
}
],
"rows": [
[
"id_423159",
"id_153005",
"call-id_769148",
3619942,
"aerTv afWDg pdEcl Crgqt",
"-60.50252303481102, -37.10943100042641"
],
[
"id_521510",
"id_600941",
"call-id_017549",
4364815,
"EHbcJ vmjbh XfDjD dhuPh",
"-80.12339604087174, -55.92544407583773"
],
[
"id_300243",
"id_616046",
"call-id_092436",
4852402,
"bQOkk NOUsw lhiIX vQuAf",
"16.380679984577, -24.128756001591682"
],
[
"id_786766",
"id_382938",
"call-id_171220",
9182918,
"sunlU eZMfK xnzkO QrsxL",
"-41.530255023390055, -60.80054202117026"
],
[
"id_174869",
"id_782048",
"call-id_997480",
9695688,
"CVvyF SOrwQ UtWzG FWWsF",
"30.78904597554356, -63.00599902868271"
]
],
"cursor": "w6XxAgFz5AFEbkYxWlhKNVZHaGxia1psZEdOb0JRQUFBQUFBQUNDOEZsbHVVRmN5WmpOa1ZFdGhOMjVHY0dSa05HbzFkMEVBQUFBQUFBQWd2UlpaYmxCWE1tWXpaRlJMWVRkdVJuQmtaRFJxTlhkQkFBQUFBQUFBSU1BV1dXNVFWekptTTJSVVMyRTNia1p3WkdRMGFqVjNRUUFBQUFBQUFDQy1GbGx1VUZjeVpqTmtWRXRoTjI1R2NHUmtOR28xZDBFQUFBQUFBQUFndnhaWmJsQlhNbVl6WkZSTFlUZHVSbkJrWkRScU5YZEL/DwYBZgJ0MQEHa2V5d29yZAEAAWYCdDIBB2tleXdvcmQBAAFmAnQzAQdrZXl3b3JkAQABZgJ0NAEEbG9uZwEAAWYCdDUBBHRleHQAAAFmAnQ2AQlnZW9fcG9pbnQBAA==",
"total": 1100
}
后续查询使用cursor查询即可:
curl -H "Content-Type: application/json" -u root:111111 -XPOST '172.16.17.213:9200/_xpack/sql?format=json' -d '{ "cursor": ""}'