[
https://issues.apache.org/jira/browse/KYLIN-3416?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16714679#comment-16714679
]
ASF GitHub Bot commented on KYLIN-3416:
---------------------------------------
asfgit commented on issue #380: KYLIN-3416 Group by with expression can not
aggregate exactly
URL: https://github.com/apache/kylin/pull/380#issuecomment-445805496
Can one of the admins verify this patch?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
> Kylin bitmap null pointer exception
> -----------------------------------
>
> Key: KYLIN-3416
> URL: https://issues.apache.org/jira/browse/KYLIN-3416
> Project: Kylin
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: v2.3.1
> Reporter: Lemont
> Priority: Blocker
> Fix For: v2.6.0
>
>
> Hi,team:
> Ithink there is a conflict between dimensional aggregation and count
> distinct.
> For example:
> select
> (1524931200 - biz_time)/(30*86400),
> count(DISTINCT id) id
> from test
> where pt ='20180621'
> group by (1524931200 - biz_time)/(30*86400)
> Caused by: java.lang.NullPointerException
> at
> org.apache.kylin.measure.bitmap.RoaringBitmapCounter.getMutableBitmap(RoaringBitmapCounter.java:58)
> at
> org.apache.kylin.measure.bitmap.RoaringBitmapCounter.orWith(RoaringBitmapCounter.java:72)
> at
> org.apache.kylin.measure.bitmap.BitmapAggregator.aggregate(BitmapAggregator.java:43)
> at
> org.apache.kylin.measure.bitmap.BitmapDistinctCountAggFunc.add(BitmapDistinctCountAggFunc.java:31)
>
> The problem cased by GTCubeStorageQueryBase.isNeedStorageAggregation
> There are three dimension int the cube,the sql use cuboid 5 and the
> cuboid.getColumns is
> pt,bize_time.
> The groupD is bize_time and singleValueD is pt.
> So isNeedStorageAggregation return false.
> But in fact this sql need storage agregation because the group is (1524931200
> - biz_time)/(30*86400) not only biz_time
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
