Re: Hopping and tumbling windows in streaming SQL

2015-06-29 Thread Yi Pan
anks for > > thinking through this. I also like if we can introduce a TUMBLE function > > with more control over how we define tumbling window size. With the > current > > FLOOR based model we have to perform date/time arithmetic to have > tumbling > > windows such as 5 m

Re: Hopping and tumbling windows in streaming SQL

2015-06-25 Thread Julian Hyde
well. > > Thanks > Milinda > > On Wed, Jun 24, 2015 at 6:32 PM, Julian Hyde wrote: > >> Hi all, >> >> Forgive the cross-post. This is for Calcite devs interested in >> streaming and Samza devs interested in SQL. >> >> I've been thinkin

Re: Hopping and tumbling windows in streaming SQL

2015-06-25 Thread Milinda Pathirage
wrote: > Hi all, > > Forgive the cross-post. This is for Calcite devs interested in > streaming and Samza devs interested in SQL. > > I've been thinking some more about how to implement hopping and > tumbling windows in streaming SQL. I was previously at a loss to find > a

Hopping and tumbling windows in streaming SQL

2015-06-24 Thread Julian Hyde
Hi all, Forgive the cross-post. This is for Calcite devs interested in streaming and Samza devs interested in SQL. I've been thinking some more about how to implement hopping and tumbling windows in streaming SQL. I was previously at a loss to find a concise syntax that is consistent wit