my index mapping:
{
"order": 0,
"template": "test_index*",
"settings": {
"index": {
"refresh_interval": "1s"
}
},
"mappings": {
"logs": {
"properties": {
"sell_date_start": {
"format": "yyy-MM-dd HH:mm:ss||yyyy-MM-dd||epoch_millis",
"type": "date"
}
},
"_all": {
"enabled": false
}
}
},
"aliases": {}
}
and my test data:
{"sell_date_start":"2016-07-16 10:00:00", "@timestamp":"2016-07-21T06:18:38.659Z"}
{"sell_date_start":"2016-07-17 20:00:00", "@timestamp":"2016-07-21T06:18:50.659Z"}
{"sell_date_start":"2016-07-17 10:00:00", "@timestamp":"2016-07-21T06:18:00.659Z"}
{"sell_date_start":"2016-07-16 15:00:00", "@timestamp":"2016-07-21T06:18:18.659Z"}
{"sell_date_start":"2016-07-16 20:00:00", "@timestamp":"2016-07-21T06:18:28.659Z"}
{"sell_date_start":"2016-07-16 11:00:00", "@timestamp":"2016-07-21T06:19:38.659Z"}
the following query doesn't get any result:
{
"query": {
"query_string": {
"query": "sell_date_start:[1468634400000 TO 1468641600000]"
}
}
}
or
{
"query": {
"query_string": {
"query": "sell_date_start:1468634400000"
}
}
}
But the following query can:
{
"query": {
"query_string": {
"query": "sell_date_start:[1468634400000 TO 1468670400000]"
}
}
}
or
{
"query": {
"query_string": {
"query": "sell_date_start:[1468634400000 TO *]"
}
}
}
es version: 2.3.3
Why ?????
Can anyone tell me why??
thanks