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 <[email protected]> wrote: > + Yerui. Do you have any idea? > > 2017-07-25 11:25 GMT+08:00 Joanna He (Jingke He) <[email protected]>: > >> The tech blog I referred. >> >> http://kylin.apache.org/blog/2016/11/16/window-function/ >> >> >> >> >> >> 何京珂 >> >> Joanna He >> >> >> >> >> >> *From: *"Joanna He (Jingke He)" <[email protected]> >> *Reply-To: *"[email protected]" <[email protected]> >> *Date: *Tuesday, 25 July 2017 at 9:41 AM >> *To: *"[email protected]" <[email protected]> >> *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 >> >> >> > >
