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