-
Notifications
You must be signed in to change notification settings - Fork 24.7k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Date format error when search last year data #103778
Comments
Thank you very much for your interest in Elasticsearch. Unfortunately the issue you have reported relates to Elasticsearch version 7.5.2 which is very old and has passed end-of-life. We will not investigate issues related to unsupported versions here on Github, so I am closing this to indicate that no action is needed from the Elasticsearch development team. It's possible that you will find a volunteer to help you with this issue on the community forums, but our strong recommendation would be to upgrade to a supported version of Elasticsearch as a matter of some urgency. If you can reproduce your issue on a supported version then please open a fresh bug report. Quoting the bug report form:
|
Elasticsearch Version
7.5.2
Installed Plugins
No response
Java Version
bundled
OS Version
Linux bsa162 3.10.0-957.el7.x86_64 #1 SMP Thu Nov 8 23:39:32 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux
Problem Description
It's 2024.1.2.
I search data of 2023.12. 31。 The result of 2023.12. 31 is wrong: the key is right(1703952000000,2023-12-31 00:00:00), but the key_as_string is wrong(2024-12-31)。
Steps to Reproduce
Query:
curl -XGET 'http://10.67.X.X:XX/XX-2023123*/_search?pretty' -H 'Content-Type:application/json' -d'{"query":{"bool":{"filter":[{"range":{"start_time":{"gt":1703606400000,"lte":1704167251155}}}]}},"track_total_hits":true,"aggs":{"group":{"date_histogram":{"field":"start_time","interval":"1d","time_zone":"+08:00","min_doc_count":0,"format":"YYYY-MM-dd"}}},"size":0}
Result:
{
"took" : 0,
"timed_out" : false,
"_shards" : {
"total" : 2,
"successful" : 2,
"skipped" : 0,
"failed" : 0
},
"hits" : {
"total" : {
"value" : 238,
"relation" : "eq"
},
"max_score" : null,
"hits" : [ ]
},
"aggregations" : {
"group" : {
"buckets" : [
{
"key_as_string" : "2023-12-30",
"key" : 1703865600000,
"doc_count" : 130
},
{
"key_as_string" : "2024-12-31",
"key" : 1703952000000,
"doc_count" : 108
}
]
}
}
}
Logs (if relevant)
No response
The text was updated successfully, but these errors were encountered: