kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ShaoFeng Shi <shaofeng...@gmail.com>
Subject Re: 回复: Re: How does kylin deal with sub query??
Date Sun, 27 Mar 2016 06:18:14 GMT
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" <bingleessdut@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";<shaofengshi@apache.org>;发送时间: 2016年3月25日(星期五)
晚上9:32收件人: "Bin.Li"<bingleessdut@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 <bingleessdut@qq.com>:
hello  ShaoFeng,
 How can I create a JIRA for the issue??
 https://www.atlassian.com/software/jira/  ??
bin.li

------------------ 原始邮件 ------------------发件人: "ShaoFeng Shi";<shaofengshi@apache.org>;发送时间: 2016年3月25日(星期五)
上午9:43收件人: "Bin.Li"<bingleessdut@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 <bingleessdut@qq.com>:
sql1


bin.li

------------------ 原始邮件 ------------------
发件人: "ShaoFeng Shi" <shaofengshi@apache.org>;发送时间: 2016年3月24日(星期四)
13:11收件人: "user" <user@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 <bingleessdut@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







Mime
View raw message