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

Shaofeng SHI commented on KYLIN-490:
------------------------------------

I know the cube can build HLL counter for multiple columns, but the query 
engine couldn't parse it properly; here is the error:

{code}
Message: Error while executing SQL "select count(distinct seller_id, 
LSTG_FORMAT_NAME) from kylin_sales LIMIT 50000": Can't find any realization. 
Please confirm with providers. SQL digest: fact table DEFAULT.KYLIN_SALES,group 
by [],filter on [],with aggregates[FunctionDesc [expression=COUNT_DISTINCT, 
parameter=ParameterDesc [type=column, value=SELLER_ID, nextParam=null], 
returnType=null]].
==========================[QUERY]===============================

2016-12-01 19:44:32,644 ERROR [http-bio-7070-exec-7] 
controller.BasicController:44 :
org.apache.kylin.rest.exception.InternalErrorException: Error while executing 
SQL "select count(distinct seller_id, LSTG_FORMAT_NAME) from kylin_sales LIMIT 
50000": Can't find any realization. Please confirm with providers. SQL digest: 
fact table DEFAULT.KYLIN_SALES,group by [],filter on [],with 
aggregates[FunctionDesc [expression=COUNT_DISTINCT, parameter=ParameterDesc 
[type=column, value=SELLER_ID, nextParam=null], returnType=null]].
        at 
org.apache.kylin.rest.controller.QueryController.doQueryWithCache(QueryController.java:225)
        at 
org.apache.kylin.rest.controller.QueryController.query(QueryController.java:94)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at 
org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
        at 
org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.ja
{code}

> Support multiple column distinct count
> --------------------------------------
>
>                 Key: KYLIN-490
>                 URL: https://issues.apache.org/jira/browse/KYLIN-490
>             Project: Kylin
>          Issue Type: Improvement
>            Reporter: Luke Han
>              Labels: github-import
>
> Make count distinct(A, B) work, currently calcite only support count distinct 
> on one column.
> ---------------- Imported from GitHub ----------------
> Url: https://github.com/KylinOLAP/Kylin/issues/15
> Created by: [liyang-gmt8|https://github.com/liyang-gmt8]
> Labels: enhancement, 
> Milestone: v0.6.2 Release
> Assignee: [liyang-gmt8|https://github.com/liyang-gmt8]
> Created at: Fri Oct 24 15:27:20 CST 2014
> State: open



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to