Re: How to do DateDiff in Kylin

Julian, from which version Calcite supports the minus operation between two dates? I tried "select cal_dt, (current_date - cal_dt) as diff from kylin_cal_dt" in Kylin, but get this error: Error while executing SQL "select cal_dt, (current_date - cal_dt) as diff from kylin_cal_dt LIMIT 5":

答复: 答复: snapshot table not update

I updated all the rows. Actually, I dropped the table and created it again. 发件人: ShaoFeng Shi-2 [via Apache Kylin] [mailto:ml-node+s74782n490...@n6.nabble.com] 发送时间: 2016年6月12日 10:07 收件人: yubo-ds1(于渤.大数据中心.大数据平台部) 主题: Re: 答复: snapshot table not update I checked the code, it is very likely a

Re: How to name derived dimensions & hierarchy dimensions in Chinese

The rule of thumb is: who want it, who build it. You can open a JIRA first. On Wed, Jun 8, 2016 at 5:44 PM, 251469031 <251469...@qq.com> wrote: > Thank you for you suggestion. > > > Whether kylin will add a description to derived & hierarchy dimensions in > the future or not? > > > > > > >

Re: How to do DateDiff in Kylin

You need to include a time unit, e.g. DAY or MONTH or YEAR TO MONTH. The syntax is (datetime - datetime) timeunit e.g. (d2 - d1) DAY (d2 - d1) YEAR TO MONTH This has been in Calcite for quite a few releases. > On Jun 11, 2016, at 3:27 AM, ShaoFeng Shi wrote:

[jira] [Created] (KYLIN-1779) Add descriptions to derived dimensions & hierarchy dimensions

Yinwei Li created KYLIN-1779: Summary: Add descriptions to derived dimensions & hierarchy dimensions Key: KYLIN-1779 URL: https://issues.apache.org/jira/browse/KYLIN-1779 Project: Kylin Issue

Re: snapshot table not update

To confirm understanding. You built a cube, updated the lookup table in hive, and built it again. And the second build didn't pick up the latest lookup table. Is that correct? On Wed, Jun 8, 2016 at 11:45 AM, yubo-...@yolo24.com wrote: > I define a loopup table in a

Re: How to do DateDiff in Kylin

Thanks Julian; I added the time unit, there is no SQL syntax error anymore; Although the diff values are all "+0", it should be Kylin's issue; Uma, please try the query, if you see the same result, then pls open a JIRA to Kylin: http://issues.apache.org/jira/secure/Dashboard.jspa Thanks;

Re: select * from fact_table

Cool Xiaoyu! Best Regards! - Luke Han On Wed, Jun 8, 2016 at 10:57 AM, Li Yang wrote: > Yeah~~ Thanks Xiaoyu! > > On Sun, Jun 5, 2016 at 8:47 PM, 王晓雨 wrote: > > > I add a document about RAW measure. > > see: > >

Re: kylin.war not deployed correctly with version 1.5

If you have installed v1.2/v1.3 and now you directly install v1.5.x, you should very carefully to check the metadata URI to make sure it points to right one (ensure the new instance, say v1.5.x will not use old one). Thanks. Best Regards! - Luke Han On Fri, Jun 10, 2016 at

Re: 答复: 答复: 答复: snapshot table not update

Issue created, please subscribe it for update: https://issues.apache.org/jira/browse/KYLIN-1780 2016-06-12 11:54 GMT+08:00 yubo-...@yolo24.com : > Yes. All rows in the table changed > > 发件人: ShaoFeng Shi-2 [via Apache Kylin] [mailto: > ml-node+s74782n4911...@n6.nabble.com] >

Re: 答复: 答复: snapshot table not update

Is the table content changed in between? 2016-06-12 10:55 GMT+08:00 yubo-...@yolo24.com : > I updated all the rows. > > Actually, I dropped the table and created it again. > > 发件人: ShaoFeng Shi-2 [via Apache Kylin] [mailto: > ml-node+s74782n490...@n6.nabble.com] > 发送时间:

Blog to introduce the Diagnosis Tool

Hello community, I wrote a blog about the Diagnosis functionality introduced since 1.5.2. http://kylin.apache.org/blog/2016/06/10/diagnosis-tool/ Please have a view if you need it. Thanks, Dong

答复: 答复: 答复: snapshot table not update

Yes. All rows in the table changed 发件人: ShaoFeng Shi-2 [via Apache Kylin] [mailto:ml-node+s74782n4911...@n6.nabble.com] 发送时间: 2016年6月12日 11:11 收件人: yubo-ds1(于渤.大数据中心.大数据平台部) 主题: Re: 答复: 答复: snapshot table not update Is the table content changed in between? 2016-06-12 10:55 GMT+08:00 [hidden

Re: Blog to introduce the Diagnosis Tool

cool! hope it could help people more from the community :) On Sun, Jun 12, 2016 at 11:37 AM, Dong Li wrote: > Hello community, > > > I wrote a blog about the Diagnosis functionality introduced since 1.5.2. > > http://kylin.apache.org/blog/2016/06/10/diagnosis-tool/ > > >

[jira] [Created] (KYLIN-1780) Potential issue in SnapshotTable.equas()

Shaofeng SHI created KYLIN-1780: --- Summary: Potential issue in SnapshotTable.equas() Key: KYLIN-1780 URL: https://issues.apache.org/jira/browse/KYLIN-1780 Project: Kylin Issue Type: Bug

[jira] [Created] (KYLIN-1781) kylin.properties encoding while contain chinese prop key or value

zhaotianshuo created KYLIN-1781: --- Summary: kylin.properties encoding while contain chinese prop key or value Key: KYLIN-1781 URL: https://issues.apache.org/jira/browse/KYLIN-1781 Project: Kylin