[
https://issues.apache.org/jira/browse/KYLIN-2284?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15852703#comment-15852703
]
liyang commented on KYLIN-2284:
-------------------------------
This is expected, intersect_count() only works with bitmap count distinct, but
in learn_kylin, the seller_id is of type HLL count distinct.
> 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
> 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)
