[jira] [Updated] (KYLIN-3262) Produce jacoco exec files for integration test

[Billy Liu (JIRA)]

 [ 
https://issues.apache.org/jira/browse/KYLIN-3262?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Billy Liu updated KYLIN-3262:
-
Fix Version/s: v2.4.0

> Produce jacoco exec files for integration test
> --
>
> Key: KYLIN-3262
> URL: https://issues.apache.org/jira/browse/KYLIN-3262
> Project: Kylin
>  Issue Type: Task
>Reporter: Zhong Yanghong
>Assignee: Zhong Yanghong
>Priority: Major
> Fix For: v2.4.0
>
> Attachments: APACHE-KYLIN-3262.patch
>
>
> Currently to calculate code coverage, kylin only considers UT. However, IT 
> also covers lots of code. It's better to include this for code coverage.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Commented] (KYLIN-3262) Produce jacoco exec files for integration test

[ASF subversion and git services (JIRA)]

[ 
https://issues.apache.org/jira/browse/KYLIN-3262?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16397746#comment-16397746
 ] 

ASF subversion and git services commented on KYLIN-3262:


Commit 537ae8afd1c60d374980c099e5c5fead2c215684 in kylin's branch 
refs/heads/master from [~yimingliu]
[ https://gitbox.apache.org/repos/asf?p=kylin.git;h=537ae8a ]

KYLIN-3262 add JaCoCo Java Agent for integration test


> Produce jacoco exec files for integration test
> --
>
> Key: KYLIN-3262
> URL: https://issues.apache.org/jira/browse/KYLIN-3262
> Project: Kylin
>  Issue Type: Task
>Reporter: Zhong Yanghong
>Assignee: Zhong Yanghong
>Priority: Major
> Attachments: APACHE-KYLIN-3262.patch
>
>
> Currently to calculate code coverage, kylin only considers UT. However, IT 
> also covers lots of code. It's better to include this for code coverage.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Commented] (KYLIN-3262) Produce jacoco exec files for integration test

[ASF subversion and git services (JIRA)]

[ 
https://issues.apache.org/jira/browse/KYLIN-3262?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16397744#comment-16397744
 ] 

ASF subversion and git services commented on KYLIN-3262:


Commit cb3913b681a1230130376215cfa30477eb3692f0 in kylin's branch 
refs/heads/master from Zhong
[ https://gitbox.apache.org/repos/asf?p=kylin.git;h=cb3913b ]

APACHE-KYLIN-3262: add on-the-fly instrumentation with using JaCoCo Java Agent 
for integration test

Signed-off-by: Billy Liu 


> Produce jacoco exec files for integration test
> --
>
> Key: KYLIN-3262
> URL: https://issues.apache.org/jira/browse/KYLIN-3262
> Project: Kylin
>  Issue Type: Task
>Reporter: Zhong Yanghong
>Assignee: Zhong Yanghong
>Priority: Major
> Attachments: APACHE-KYLIN-3262.patch
>
>
> Currently to calculate code coverage, kylin only considers UT. However, IT 
> also covers lots of code. It's better to include this for code coverage.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Created] (KYLIN-3291) 在构建好的cube上提交逻辑相同的sql查询结果不同

[zhang (JIRA)]

zhang created KYLIN-3291:


 Summary: 在构建好的cube上提交逻辑相同的sql查询结果不同
 Key: KYLIN-3291
 URL: https://issues.apache.org/jira/browse/KYLIN-3291
 Project: Kylin
  Issue Type: Bug
  Components: Query Engine
Affects Versions: v2.0.0
 Environment: kylin 2.0hbase 1.2.0
Reporter: zhang


select 
a.agent
,b.channel_name
,a.ONLINE_SECONDS_TYPE
,a.pt_dt
,count(*) ct
from (
select
agent , ONLINE_SECONDS_TYPE ,pt_dt
from zhangyc02.DM_CHL_REGUSER_1D_WIDETABLE_D 
where pt_dt>='2017-12-01' and pt_dt<='2017-12-03' and agent in (6,3)
) a
left join zhangyc02.dim_res_info b
on a.agent = b.channel_id
group by a.agent,b.channel_name,a.ONLINE_SECONDS_TYPE,a.pt_dt
order by agent, pt_dt , ONLINE_SECONDS_TYPE ;
这种查询结果是错误的

select
a.agent
,b.channel_name agent_name
,a.ONLINE_SECONDS_TYPE
,pt_dt
,count(*) ct
from zhangyc02.DM_CHL_REGUSER_1D_WIDETABLE_D a
left join zhangyc02.dim_res_info b
on a.agent = b.channel_id
where pt_dt>='2017-12-01' and pt_dt<='2017-12-03' and a.agent in (6,3)
group by a.agent,b.channel_name,a.ONLINE_SECONDS_TYPE,a.pt_dt
order by agent, pt_dt , ONLINE_SECONDS_TYPE ;
这种查询结果是正确的

校验方式：我将两个sql在impala中分别查询，结果一致并且与kylin中的下面的sql结果一致。



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)