I see it, we will check, thank you! Regards，
Shaofeng Shi [email protected] >From Outlook Mobile On Sat, Mar 26, 2016 at 11:08 PM -0700, "Bin.Li" <[email protected]> wrote: hello shaofeng.shi, There is the issue I created: https://issues.apache.org/jira/browse/KYLIN-1535 Many tks!! bin.li ------------------ 原始邮件 ------------------发件人: "ShaoFeng Shi";<[email protected]>;发送时间: 2016年3月25日(星期五) 晚上9:32收件人: "Bin.Li"<[email protected]>; 主题: 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 <[email protected]>: hello ShaoFeng, How can I create a JIRA for the issue?? https://www.atlassian.com/software/jira/ ?? bin.li ------------------ 原始邮件 ------------------发件人: "ShaoFeng Shi";<[email protected]>;发送时间: 2016年3月25日(星期五) 上午9:43收件人: "Bin.Li"<[email protected]>; 主题: 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 <[email protected]>: sql1 bin.li ------------------ 原始邮件 ------------------ 发件人: "ShaoFeng Shi" <[email protected]>;发送时间: 2016年3月24日(星期四) 13:11收件人: "user" <[email protected]>;主题: 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 <[email protected]>: 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
