esper
esper copied to clipboard
Parsing problems when using EXPRESSION and GROUP BY clause
At EsperOnline Version 8.8.0 I get the following error when using Expression (with params) within sentences with a GROUP BY clause:
"Non-aggregated property 'v' in the HAVING clause must occur in the group-by clause"
create schema StockTick(symbol string, price double);
expression F {(v)=>v}
SELECT window(*)
FROM StockTick.std:groupwin(symbol).win:length(2)
GROUP BY symbol
HAVING count(*)>F(1);
On the other hand the following rules work as expected:
create schema StockTick(symbol string, price double);
expression F {(v)=>v}
SELECT window(*)
FROM StockTick.std:groupwin(symbol).win:length(2)
HAVING count(*, group_by:symbol)>F(1);
and
create schema StockTick(symbol string, price double);
expression F {(v)=>v}
SELECT window(*)
FROM StockTick.std:groupwin(symbol).win:length(2)
HAVING count(*)>F(1);
Best.