you can use extract functions on ts like tableau did however you need to notice that a ts dimension may has really high cardinality (if you didn't do normalization), thus the cube expansion rate can be huge and performance can be poor.
On Mon, Feb 29, 2016 at 10:31 AM, 凡梦星尘 <[email protected]> wrote: > Hi Luke, > > yeah, the query SQL like below: > > SELECT ts, c, os, count(hid) hids FROM tableName GROUP BY ts, c, os LIMIT > 50; > > The ts default format is 'yyyy-MM-dd HH:mm:ss.S', but I want the result > group by hours very day, Is there had other way to come true? > > Thanks. > > Senhui.Lee > > 2016-02-28 17:22 GMT+08:00 Luke Han <[email protected]>: > > > Hi Senhui, > > Would you mind to give us one sample SQL for your requirement? > > > > Kylin 1.x does not support timestamp yet, but Kylin 2 will support. > > > > Thanks. > > Luke > > > > > > Best Regards! > > --------------------- > > > > Luke Han > > > > On Fri, Feb 26, 2016 at 6:02 PM, 凡梦星尘 <[email protected]> wrote: > > > > > Hi guys. > > > > > > Today I had integration the Kylin 1.3-SNAPSHOT version, then create a > > > simple project and cube. the query result include the timestamp value. > > Also > > > I want to format the value in hours then group by it. Is the Kylin > > support > > > it? > > > > > > Thanks. > > > > > > Senhui.Lee > > > > > > -- Regards, *Bin Mahone | 马洪宾* Apache Kylin: http://kylin.io Github: https://github.com/binmahone
