[
https://issues.apache.org/jira/browse/KYLIN-2284?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15852708#comment-15852708
]
liyang commented on KYLIN-2284:
-------------------------------
Reproduced the error on master branch, the error message now reads good enough:
"Error while executing SQL "select week_beg_dt as week, intersect_count(
SELLER_ID, lstg_format_name, array['FP-GTC']) as a, count(*) as cnt from
test_kylin_fact left join edw.test_cal_dt on test_kylin_fact.cal_dt =
edw.test_cal_dt.CAL_DT where week_beg_dt in (DATE '2013-12-22', DATE
'2012-06-23') group by week_beg_dt LIMIT 50000":
org.apache.kylin.measure.hllc.HLLCounter cannot be cast to
org.apache.kylin.measure.bitmap.BitmapCounter"
> intersect_count function error
> ------------------------------
>
> Key: KYLIN-2284
> URL: https://issues.apache.org/jira/browse/KYLIN-2284
> Project: Kylin
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: v1.6.0
> Environment: windows
> Reporter: Luyuan Zhai
> Assignee: liyang
> Priority: Minor
> Fix For: v2.0.0
>
> Attachments: intersect_count.correct result.png,
> intersect_count.error result.png
>
>
> I explored on the Kylin Web GUI, using datasource learn_kylin, when I inputed
> sql query"select intersect_count(seller_id, LSTG_FORMAT_NAME,
> array['Others']) from KYLIN_SALES", it led to an error"Error while executing
> SQL "select intersect_count(seller_id, LSTG_FORMAT_NAME, array['Others'])
> from KYLIN_SALES LIMIT 50000": Index: 1, Size: 1".
> Yet when I inputed similar sql query including intersect_count function as
> well, then it worked well and the result returned correctly.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
