[jira] [Commented] (KYLIN-490) Support multiple column distinct count
[ https://issues.apache.org/jira/browse/KYLIN-490?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16836293#comment-16836293 ] hejian commented on KYLIN-490: -- hi,[~R0ger] [~yimingliu] [~Shaofengshi] what's new about this isue? I found the query engine can't parse it correctly in kylin-2.4.0, for example: the result of *count(distinct day_id, seller_id)* and *count(distinct day_id)* are same > 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 >Assignee: Roger Shi >Priority: Major > Labels: github-import > Fix For: v2.0.0 > > Attachments: > 0001-KYLIN-490-support-multiple-column-distinct-count.patch, > 0002-KYLIN-490-support-multiple-column-distinct-count.patch > > > 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 (v7.6.3#76005)
[jira] [Commented] (KYLIN-490) Support multiple column distinct count
[ https://issues.apache.org/jira/browse/KYLIN-490?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15962923#comment-15962923 ] Billy Liu commented on KYLIN-490: - Thanks [~R0ger], great contribution. > 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 >Assignee: Roger Shi > Labels: github-import > Fix For: v2.0.0 > > Attachments: > 0001-KYLIN-490-support-multiple-column-distinct-count.patch, > 0002-KYLIN-490-support-multiple-column-distinct-count.patch > > > 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.15#6346)
[jira] [Commented] (KYLIN-490) Support multiple column distinct count
[ https://issues.apache.org/jira/browse/KYLIN-490?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15962758#comment-15962758 ] Roger Shi commented on KYLIN-490: - Fixed in commit 636282db889973fe29269b43e417414effb68b76 88a1c71dde855c693b230f67b92c4cd067d43b2b > 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.15#6346)
[jira] [Commented] (KYLIN-490) Support multiple column distinct count
[
https://issues.apache.org/jira/browse/KYLIN-490?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=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 5": 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
5": 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)
