You can use a lookup table for calendar dates, like the "KYLIN_CAL_DT" table in sample cube.
2017-04-04 17:13 GMT+08:00 Li Yang <[email protected]>: > Please provide detailed error messages or logs, or no one can help you. > > > how can i group by "year" and "month" with cloumn "dates" ? > There are SQL functions like: > - EXTRACT(MONTH FROM "TEST_CAL_DT"."WEEK_BEG_DT") > - EXTRACT(YEAR FROM "TEST_CAL_DT"."WEEK_BEG_DT") > > > On Sat, Apr 1, 2017 at 12:14 PM, shuaishuai <[email protected]> wrote: > > > i have a fact table named "A" with 4 cloumns clicks cost > > dates product 1 1 1.00 2016-01-02 > > A 2 2 3.00 2016-01-03 B 3 5 > > 16.00 > > 2016-01-03 A 4 3 6.00 2016-01-04 > A > > there have an error when use the sql like "select sum(clicks)/sum(cost) > > from > > xxxx group xxxx " and how can i group by "year" and "month" with cloumn > > "dates" ? > > > > -- > > View this message in context: http://apache-kylin.74782.x6. > > nabble.com/How-can-i-use-the-sql-function-by-kylin-version- > 1-6-tp7566.html > > Sent from the Apache Kylin mailing list archive at Nabble.com. > > > -- Best regards, Shaofeng Shi 史少锋
