esper icon indicating copy to clipboard operation
esper copied to clipboard

Parsing problems when using EXPRESSION and GROUP BY clause

Open mrutid opened this issue 3 years ago • 0 comments

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.

mrutid avatar Feb 16 '22 08:02 mrutid