[jira] [Commented] (KYLIN-490) Support multiple column distinct count

["Shaofeng SHI (JIRA)" <ji...@apache.org>]

    [ 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)