Hi,
I have a date and a unix timestamp field in my mapping. Experiencing
several issues..
- I cannot get Elasticsearch to accept any kind of date format I have
tried for the date field - Sorting on the unix timestamp field is not working (which is type
float) - Unable to filter on the unix timestamp field ("No filtered registered
for [tstamp_unix]
Example of the data going in (note the fractions of a second):
{
"tstamp" : "2014-07-09 08:33:04.178900",
"tstamp_unix" : 1404894784.178900
}
I'm aware I don't need the unix value however as the mapping just wasn't
working and date is now set to type string. In terms of mapping I have
tried:
{
"type1": {
"tstamp": {
"type" : "date",
"format" : "yyyy-MM-dd HH:mm:ss.S" // also yyyy-MM-dd
HH:mm:ss.SSS, y-M-d H:m:s.S etc etc
}
}
}
Then with the sorting - tstamp_unix is mapped as type float. When
performing a sort against this field, it does something very weird.. one
example, see the resulted sort value..:
// Query - all records newer than 5 minutes ago
{
"size" : 1000,
"fields" : [ "tstamp_unix", "tstamp" ],
"sort": [
{ "tstamp_unix" : {"order" : "desc"} }
],
"query" : {
"filtered": {
"query": {
"range": {
"tstamp_unix":{
"gt": 1404895819
}
}
},
"filter": {
"term": { "grouped_identifier": "some_value" }
}
}
}
}
// Result
{
"_index" : "index",
"_type" : "type",
"_id" : "XYqXjRHPR4m8ndYKyp5-8Q",
"_score" : null,
"fields" : {
"tstamp_unix" : [ "1404896082.123818" ],
"tstamp" : [ "2014-07-09 08:54:42.123818" ]
},
"sort" : [ 1.40489613E9 ]
}
Can't find any other resources on this.. any ideas??
--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/e6bea892-8c58-4b86-aef8-efee01998655%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.