Re: How to pass PROCTIME through an aggregate

2021-02-26 Thread Rex Fenley
This is great Timo. Maybe it only works in SQL but not Table API in the middle of a plan, which is fine. We'll give this a shot, thank you so much. On Fri, Feb 26, 2021 at 2:00 AM Timo Walther wrote: > Hi Rex, > > as far as I know, we recently allowed PROCTIME() also at arbitrary > locations in

Re: How to pass PROCTIME through an aggregate

2021-02-26 Thread Timo Walther
Hi Rex, as far as I know, we recently allowed PROCTIME() also at arbitrary locations in the query. So you don't have to pass it through the aggregate but you can call it afterwards again. Does that work in your use case? Something like: SELECT i, COUNT(*) FROM customers GROUP BY i,

Re: How to pass PROCTIME through an aggregate

2021-02-24 Thread Arvid Heise
Hi Rex, just an idea, wouldn't it be possible to just add UNIX_TIMESTAMP() right before your window operation? On Sat, Feb 20, 2021 at 2:14 AM Rex Fenley wrote: > Hello, > > Using the table api, I have a CREATE DDL which adds a PROCTIME() column > and I need to use it deep (like 10

How to pass PROCTIME through an aggregate

2021-02-19 Thread Rex Fenley
Hello, Using the table api, I have a CREATE DDL which adds a PROCTIME() column and I need to use it deep (like 10 operators deep) in our plan. However, I explicitly do not want to use it before that point. The problem I'm running into is for any group by UDAF I use I then lose the proctime