You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@kylin.apache.org by ShaoFeng Shi <sh...@gmail.com> on 2016/03/27 08:18:14 UTC
Re: 回复: Re: How does kylin deal with sub query??
I see it, we will check, thank you!
Regards,
Shaofeng Shi
shaofengshi@gmail.com
>From Outlook Mobile
On Sat, Mar 26, 2016 at 11:08 PM -0700, "Bin.Li" <bi...@qq.com> wrote:
hello shaofeng.shi,
There is the issue I created:
https://issues.apache.org/jira/browse/KYLIN-1535
Many tks!!
bin.li
------------------ 原始邮件 ------------------发件人: "ShaoFeng Shi";<sh...@apache.org>;发送时间: 2016年3月25日(星期五) 晚上9:32收件人: "Bin.Li"<bi...@qq.com>; 主题: Re: Re: How does kylin deal with sub query??
Hi Bin,
Apache projects are using JIRA to track all tasks/bugs; The entry page is https://issues.apache.org/jira/secure/Dashboard.jspa, you need firstly create an account, then you will be able to create. Selecting KYLIN as the project name, and then enter the description and other fields. You can find a sample like https://issues.apache.org/jira/browse/KYLIN-1513
2016-03-25 17:03 GMT+08:00 Bin.Li <bi...@qq.com>:
hello ShaoFeng,
How can I create a JIRA for the issue??
https://www.atlassian.com/software/jira/ ??
bin.li
------------------ 原始邮件 ------------------发件人: "ShaoFeng Shi";<sh...@apache.org>;发送时间: 2016年3月25日(星期五) 上午9:43收件人: "Bin.Li"<bi...@qq.com>; 主题: Re: Re: How does kylin deal with sub query??
Hi Bin,
It might be a bug in sql parse/optimization, would you mind to create a JIRA for the issue you found? Many thanks!
2016-03-24 13:13 GMT+08:00 Bin.Li <bi...@qq.com>:
sql1
bin.li
------------------ 原始邮件 ------------------
发件人: "ShaoFeng Shi" <sh...@apache.org>;发送时间: 2016年3月24日(星期四) 13:11收件人: "user" <us...@kylin.apache.org>;主题: Re: How does kylin deal with sub query??
Which SQL in kylin returns a different result by comparing to hive? sql2, or both?
2016-03-24 11:53 GMT+08:00 Bin.Li <bi...@qq.com>:
hello,
The sql is(sql1):
select channel_id,count(*) as shopper from (select shopper_id, channel_id, count(*) from ods.ods_mobile_api where "DAY" = '20160315'group by shopper_id,channel_id) as t group by channel_id order by shopper desc ;
This should be equal to(sql2):select channel_id, count(distinct shopper_id) as shopper from ods_mobile_api where day = '20160315' group by channel_id order by shopper desc;
And sql1, sql2 do can get the same results in hive, but different results between hive & kylin.What the problem is ??
Many tks!!
bin.li
--
Best regards,
Shaofeng Shi
--
Best regards,
Shaofeng Shi
--
Best regards,
Shaofeng Shi