The tech blog I referred.
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.
,sum(price) as sales
from KYLIN_Sales s
join KYLIN_CAL_DT c
join KYLIN_CATEGORY_GROUPINGS g
group by g.categ_lvl3_name, month_id
order by g.categ_lvl3_name,month_id