Wednesday, 15 August 2012

Esper Grouping Causes Duplicates -



Esper Grouping Causes Duplicates -

i have basic esper query follows:

@name("mytestquery") @description("my first test query") select sum(qty), venue mytestwindow grouping venue

the query seems duplicate results of sum i.e. if send in qty of 10 query fire multiple times , output:

10, 20, 30, 40

however, if remove grouping function outputs 10.

is able advise why might happen?

typically need qualify stream name (mytestwindow) window, "from mytestwindow.win:time(1 sec) ". need select appropriate window type many epser offers, depending on application.

this example:

select sum(qty), venue mytestwindow.win:time_batch(1 sec) grouping venue having sum(qty) not null

you can run simple test of @ http://esper-epl-tryout.appspot.com/epltryout/mainform.html

esper

No comments:

Post a Comment