Hi,
I have a SQL like
"select aser, sum(amount) over (rows 10 preceding) FROM OrderA group by aser"
And it will fail with an error Expression 'amount' is not being grouped,
But the attr 'amount' should not need to beging grouped, is that not support
now?
And I saw if I have no groupby it will g
The query is not valid. (Try on other databases; they will tell you the same
thing. Except that MySQL might do something dumb.)
Suppose you have two records with aser = 1, one which occurs at record 100, the
other at record 1 million. The first record will sum amount over rows 90..100,
the seco
and group grammar?
Thanks very much.
Best,
Yuhong
Sender: Julian Hyde [mailto:jh...@apache.org]
Send Time: 2017年1月15日 1:01
Receiver: dev@calcite.apache.org
Theme: Re: Over window with groupby
The query is not valid. (Try on other databases; they will tell you the same
thing. Except that MySQ
27;m confused is the difference between partition and group grammar?
> Thanks very much.
>
> Best,
> Yuhong
>
>
> Sender: Julian Hyde [mailto:jh...@apache.org]
> Send Time: 2017年1月15日 1:01
> Receiver: dev@calcite.apache.org
> Theme: Re: Over window with groupby
>
&