HI ALL :
I have the following sql:
select name, row_number() over(partition by id, age order by id, age) rn
from t; In fact, it can be optimized into
select name ,row_number() over(partition by id,age) rn from t;
Remove order by because order by and partition by are repeated. Since they
are
Let’s suppose that the information in HepRelVertex could somehow be moved into
the RelNode. (Since the data structure is a DAG it seems plausible.) Now each
RelNode would contain mutable state that relates to the HEP planner’s
algorithm. That state needs to be managed (e.g. reinitialized when
With so many commits it's definitely a good time to cut a new release.
I can be the RM for 1.39.0 or 1.40.0 depending on the timing.
Best,
Stamatis
On Wed, Feb 21, 2024 at 12:10 AM Sergey Nuyanzin wrote:
>
> Thanks for starting the discussion
>
> > @Sergey, are you still available for being