Re: apache kylin left join 数据查询混乱咨询

2018-11-21 Thread ShaoFeng Shi
Interesting finding; I guess it is a bug of Calcite. Kylin's calcite is a little old, we will upgrade it to a newer version, maybe it can be fixed with that. Best regards, Shaofeng Shi 史少锋 Apache Kylin PMC Work email: shaofeng@kyligence.io Kyligence Inc: https://kyligence.io/ Apache Kylin

回复: apache kylin left join 数据查询混乱咨询

2018-11-21 Thread May Zhou
Hi Lin, Nice finding!!! Could you open a JIRA to track this issue? Thank you. BRs, May -- 原始邮件 -- 发件人: "王林"<1059790...@qq.com>; 发送时间: 2018年11月21日(星期三) 下午4:50 收件人: "dev";"shaofengshi"; 主题: 回复: apache kylin left join 数据查询混乱咨询 SELECT c.DT,COALESCE

Re: [DISCUSS] Kylin On Druid Storage

2018-11-21 Thread Luke Han
Nice to see this, thanks Kaisen. Best Regards! - Luke Han On Wed, Nov 21, 2018 at 4:25 PM ShaoFeng Shi wrote: > Kaisen, > > Thank you for the information! > > We internally have evaluated this solution and run it successfully. Let's > continuously refine this solution on

Re: [REPORT] Kylin - November 2018

2018-11-21 Thread Luke Han
You are right, there are a lot of contributions in this H2, great community! Best Regards! - Luke Han On Tue, Nov 20, 2018 at 4:46 PM ShaoFeng Shi wrote: > Wow, I can't believe we have so many activities in the second half year of > 2018; Thanks to every Kylin community

回复: apache kylin left join 数据查询混乱咨询

2018-11-21 Thread 王林
SELECT c.DT,COALESCE (C.weekActivityCount, 0), COALESCE (D.monthActivityCount, 0) FROM ( SELECT DT AS DT, count(*) AS weekActivityCount FROMST_DEVICE_INFO_FACT_TABLE WHERE 6 >= LAST_ONLINE_DT_DIFF_DAY

Re: [DISCUSS] Kylin On Druid Storage

2018-11-21 Thread ShaoFeng Shi
Kaisen, Thank you for the information! We internally have evaluated this solution and run it successfully. Let's continuously refine this solution on the "kylin-on-druid" branch; So far the todo actions I can see include: - Integration test ; - Complex measure support: bitmap, extended