For anyone interested..
Fixed the date saving by creating the mapping like;
{
"tstamp" : { "type" : "date", "format" : "basic_date_time" }
}
Then making sure I only send the unix timestamp without microseconds
(sending microseconds in a seperate field).
This fixes the sorting, but I'm still battling with "No filter registered
for [..]"...
On Wednesday, 9 July 2014 10:07:52 UTC+1, Mullac wrote:
>
> Hi,
>
> I have a date and a unix timestamp field in my mapping. Experiencing
> several issues..
>
> 1. I cannot get Elasticsearch to accept any kind of date format I have
> tried for the date field
> 2. Sorting on the unix timestamp field is not working (which is type
> float)
> 3. 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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/fddb6b46-006c-460e-99d4-3467aa653434%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
