Hi Tao, [1] contains what functions are working with OVER clause. Rank is one of the functions that is supported. Can you take a look?
[1]: https://github.com/apache/beam/blob/master/sdks/java/extensions/sql/src/test/java/org/apache/beam/sdk/extensions/sql/BeamAnalyticFunctionsTest.java -Rui On Tue, Mar 2, 2021 at 9:24 AM Tao Li <t...@zillow.com> wrote: > + Rui Wang. Looks like Rui has been working on this jira. > > > > > > *From: *Tao Li <t...@zillow.com> > *Date: *Monday, March 1, 2021 at 9:51 PM > *To: *"user@beam.apache.org" <user@beam.apache.org> > *Subject: *Regarding the over window query support from Beam SQL > > > > Hi Beam community, > > > > Querying over a window for ranking etc is pretty common in SQL use cases. > I have found this jira https://issues.apache.org/jira/browse/BEAM-9198 > > > > Do we have a plan to support this? If there is no such plan in near > future, are Beam developers supposed to implement this function on their > own (e.g. by using GroupBy)? Thanks! >