You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "yangwei (JIRA)" <ji...@apache.org> on 2018/11/20 03:03:00 UTC
[jira] [Created] (KYLIN-3696) TOPN度量在同一个模型下2个cube同时开启统计值不准与真实值差得较多
yangwei created KYLIN-3696:
------------------------------
Summary: TOPN度量在同一个模型下2个cube同时开启统计值不准与真实值差得较多
Key: KYLIN-3696
URL: https://issues.apache.org/jira/browse/KYLIN-3696
Project: Kylin
Issue Type: Bug
Components: Measure - TopN
Affects Versions: v2.5.1
Reporter: yangwei
Attachments: image-2018-11-20-10-57-28-546.png, image-2018-11-20-11-01-25-120.png
我使用的是v2.5.1,度量topN使用上出现不准的总量。
问题再现:
一,二个cube使用同一个模型就是同一张物理事实表。
二,二个cube同时包含相同的topN度量
三,二个cube状态都是Ready
目前我暂时的解决方法是在其中一个cube去掉一个topN度量
同一个sql在hive与kylin里查的的结果对不上相差很远,下面给出sql
SELECT IP ,
SUM(ACCESS_COUNT) c
FROM API_ACCESS
WHERE TAG_DATE = CAST('2018-11-19' AS DATE)
group by ip
ORDER BY
c DESC
LIMIT 10;
二个cube中的度量:
cube1:
!image-2018-11-20-10-57-28-546.png!
cube2:
!image-2018-11-20-11-01-25-120.png!
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)