精准匹配:
match_phrasedsl = { "query": { "bool": { "must": [ {"match_phrase": { "players.role": "tenderer_winner" }} ] } }}
多条件查询
current_triplet_dsl =
{"query": {
"bool": {
"must": [
{"term":{"company": company}},
{"term":{"client":common_client}}]}}}
多range条件查询
{"query":{"bool":{"must":[{"range":{"org_count":{"gte":1}}},{"range":{"sum_count":{"gte":2}}}]}}}
groupby 聚合操作
{"query":{"match_all":{}},"aggs":{"group_by_key":{"terms":{"field":"field","size":100}}}}
如果field类型是text,记得用field.keyword
模糊查询
{"query":{"wildcard":{"name":"*银行*"}}}
数组length长度查询
{"query":{"script":{"script":"doc['timedelta'].size() >= 6"}}}
index 重命名
{"source":{"index":"prophet_filtered_org_pair_res_20220310"},"dest":{"index":"prophet_filtered_org_to_field_pair_res_20220310"}}
查看某一字段存在的结果
{"query":{"bool":{"must_not":{"exists":{"field":"pre"}}}}}
以某数组的长度为key进行排序
{"query":{"match_all":{}},"sort":{"_script":{"script":"doc['timedelta'].size()","type":"number","order":"desc"}}}
按照_id查询数据
GET index_name/_doc/160657
or
GET index_name/_search{
"query": {
"term": {
"_id": "1fd1ab67acd4ea042661b03a4d9c1cfb62095b79"
}
}
}
多个词查询数据
{
"query": {
"terms": {
"post.keyword": [
"区块链","隐私计算"
]
}
}
}