ElasticSearch的Script逻辑查询

————————————————
版权声明：本文为CSDN博主「CTO修炼手册」的原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。
原文链接：https://blog.csdn.net/Prepared/article/details/102893852

在使用 ES 进行统计的时候，经常会用到查询某个小时的统计数据，比如统计每个小时的数据；比如计算早晚高峰的数据。

这些场景都可以使用 script 进行查询、统计。

ES 语句

1. {

2. "query": {

3. "bool": {

4. "filter": [{

5. "range": {

6. "datetime": {

7. "from": "2019-10-01 00:00:00",

8. "to": "2019-11-01 12:00:00",

9. "include_lower": true,

10. "include_upper": true,

11. "boost": 1.0

12. }

13. }

14. }, {

15. "script": {

16. "script": {

17. "source": "(doc['datetime'].value.hourOfDay)>=17",

18. "lang": "painless"

19. },

20. "boost": 1.0

21. }

22. }, {

23. "script": {

24. "script": {

25. "source": "(doc['datetime'].value.hourOfDay)<19",

26. "lang": "painless"

27. },

28. "boost": 1.0

29. }

30. }, {

31. "exists": {

32. "field": "linkdirname",

33. "boost": 1.0

34. }

35. }],

36. "adjust_pure_negative": true,

37. "boost": 1.0

38. }

39. },

40. "sort": [{

41. "datetime": {

42. "order": "desc"

43. }

44. }],

45. "aggregations": {

46. "sum_volume": {

47. "sum": {

48. "field": "volume"

49. }

50. }

51. }

1. /**

2. * 计算早晚高峰流量

3. * @param startDate

4. * @param endDate

5. * @param volume_max

6. * @param startHour

7. * @param endHour

8. * @param sumId

9. * @return

10. */

11. private int computeMorningAndEveningPeak(String startDate, String endDate, SumAggregationBuilder volume_max,

12. int startHour, int endHour, String sumId, String comField) throws ParseException {

13. BoolQueryBuilder boolQueryBuilder = new BoolQueryBuilder();

14. SearchSourceBuilder sourceBuilder = new SearchSourceBuilder();

15. boolQueryBuilder.filter(QueryBuilders.rangeQuery("datetime").gte(startDate).lte(endDate));

16. boolQueryBuilder.filter(QueryBuilders.scriptQuery(new Script("(doc['datetime'].value.hourOfDay)>=" + startHour)));

17. boolQueryBuilder.filter(QueryBuilders.scriptQuery(new Script("(doc['datetime'].value.hourOfDay)<" + endHour)));

19. boolQueryBuilder.filter(QueryBuilders.existsQuery(comField));

20. sourceBuilder.query(boolQueryBuilder);

21. sourceBuilder.aggregation(volume_max).sort("datetime", SortOrder.DESC);

22. // 查询ES

23. SearchResponse response = ElasticsearchUtil.search(restHighLevelClient, sourceBuilder, ES_FLOW_5MIN, ES_DATA);

24. return getSumFlowByResponse(response, sumId);

25. }

这个属性能取哪些值，取决于 org.joda.time.MutableDateTime，有需要的可以查看源码。

1. mills

2. Chronology

3. Zone

4. ZoneRetainFields

5. Year

6. Weekyear

7. MonthOfYear

8. WeekOfWeekyear

9. DayOfYear

10. DayOfMonth

11. DayOfWeek

12. HourOfDay

13. MinuteOfHour

14. SecondOfDay

15. SecondOfMinute

16. MillisOfDay

17. MillisOfSecond