Elasticsearch 6.3：多条件过滤实战，日期、时段与MAC查询优化

curl -X POST "localhost:9200/ims__default__material_play/_doc/_search?pretty" -H 'Content-Type: application/json' -d'
{
    "query" : {
        "bool" : {
            "filter": [
                {
                    "range" : {
                        "date" : {
                            "gte" : "2013-01-01T00:00:00",
                            "lt" : "2015-01-02T00:00:00"
                        }
                    }
                },
                {
                    "script" : {
                        "script" : {
                            "inline": "ReadableDateTime date=doc[\u0027date\u0027].getDate(); long minute = date.getMinuteOfDay(); return minute>=params.start_minute && minute<params.end_minute;",
                            "params": { 
                                "start_minute": 120,  // hour*60 + minute
                                "end_minute": 123
                            },
                            "lang": "painless"
                         }
                    }
                },
                {
                    "term": {
                        "event": "play"
                    }
                },