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 > > >
