ElasticSearch学习
ElasticSearch学习
分组:
按series_name字段分组取前几条数据:
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
{ "query": { "bool": { "filter": [ { "range": { "request_time": { "gt": "2019-07-03", "lt": "2019-07-05" } } }, { "bool": { "must": [ { "match_phrase": { "province_code": { "query": "00644" } } } ] } } ] } }, "aggs": { "group_by_series_name": { "terms": { "field": "series_name.keyword", "size": 5, "order": { "_count": "desc" } } } }, "size": 0 }
match_all: 全部查询
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
GET dw_app_car_offering_price_ds/_search { "query": { "match_all": {} } }
单个查询
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
GET dw_app_car_offering_price_ds/_search { "query": { "term": { "model_code": { "value": "12550-n" } } } }
size:默认10条
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
GET dw_app_car_offering_price_ds/_search { "query": { "term": { "model_code": { "value": "12550-n" } } }, "size": 20 }
from size :从某个from索引的size条数据
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
GET dw_app_car_offering_price_ds/_search { "query": { "term": { "source": { "value": "che168" } } }, "from": 10, "size": 10 }
sort :排序
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
GET dw_app_car_offering_price_ds/_search { "query": { "bool": { "must": [ { "term": { "model_code": { "value": "201795" } } }, { "term": { "source": { "value": "che168" } } }, { "term": { "city_code": { "value": "00002" } } } ] } }, "size": 100, "sort": [ { "ds": { "order": "desc" } } ] }
_source:条件查询
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
GET dw_app_car_offering_price_ds/_search { "query": { "term": { "model_code": { "value": "12550-n" } } }, "_source": ["offering_price_50","city_code"] }
参考:https://www.cnblogs.com/pilihaotian/p/5830754.html
2.0的语法: