Aggregation-"sql like" optimization guidance with elasticsearch 1.0.0

[Maxime Nay]

Hi,

We are experimenting elasticsearch 1.0.0, and are particularly excited 
about the new aggregation feature.

Here is one of our use-case that we would like to optimize :

Right now, to imitate a basic SQL group by query that would look like : 
SELECT day, hour, id, SUM(views), SUM(clicks), SUM(video_plays) FROM events 
GROUP BY day, hour, id

we are issuing this kind of queries :

{  
    "size" : 0,
    "query":{"match_all":{}},
    "aggs" : {
        "test_aggregation" : {
            "terms" : {
                "script" : "doc['day'].date + '-' + doc['hour'].value + '-' 
+ doc['id'].value",
                "order" : { "_term" : "asc" },
                "size": 
            },
            "aggs" : {
                "sum_click" : { "sum" : { "field" : "clicks" } },
                "sum_views" : { "sum" : { "field" : "views" } },
                "sum_video_plays" : { "sum" : { "field" : "video_plays" } }
            }
        }
    }
}

But the perfs for this kind of queries are kind of low. Thus, we would like 
to know if there are a more optimized way to get what we want.

Thanks !
Maxime

-- 
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+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/elasticsearch/4fc6e81a-6cc2-4050-84f5-4f82b69e9764%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.