Some test queries: https://github.com/apache/kylin/blob/master/kylin-it/src/test/resources/query/sql_window/query01.sql https://github.com/apache/kylin/blob/master/kylin-it/src/test/resources/query/sql_window/query02.sql https://github.com/apache/kylin/blob/master/kylin-it/src/test/resources/query/sql_window/query03.sql
On Tue, Jul 25, 2017 at 11:31 AM, Billy Liu <billy...@apache.org> wrote: > + Yerui. Do you have any idea? > > 2017-07-25 11:25 GMT+08:00 Joanna He (Jingke He) <jingke...@kyligence.io>: > >> The tech blog I referred. >> >> http://kylin.apache.org/blog/2016/11/16/window-function/ >> >> >> >> >> >> 何京珂 >> >> Joanna He >> >> >> >> >> >> *From: *"Joanna He (Jingke He)" <jingke...@kyligence.io> >> *Reply-To: *"user@kylin.apache.org" <user@kylin.apache.org> >> *Date: *Tuesday, 25 July 2017 at 9:41 AM >> *To: *"user@kylin.apache.org" <user@kylin.apache.org> >> *Subject: *Kylin window function >> >> >> >> Anyone familiar with kylin window function? I am trying to get running >> total of past 12 months sales based on sql below and I am having >> difficulties getting the correct syntax. >> >> The tech blog below mentioned kylin syntax follow calcite but on the >> calcite function page, it does not specify the syntax within the window. >> >> >> >> >> >> >> >> select g.categ_lvl3_name >> >> ,c.month_id >> >> ,sum(price) as sales >> >> from KYLIN_Sales s >> >> join KYLIN_CAL_DT c >> >> on s.part_dt=c.cal_dt >> >> join KYLIN_CATEGORY_GROUPINGS g >> >> on s.leaf_categ_id=g.leaf_categ_id >> >> and s.LSTG_SITE_ID=g.SITE_ID >> >> group by g.categ_lvl3_name, month_id >> >> order by g.categ_lvl3_name,month_id >> >> >> >> >> >> 何京珂 >> >> Joanna He >> >> >> > >
