[jira] [Work started] (LENS-1264) Group by promotion not happening with aggregate dim attributes

["Sushil Mohanty (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/LENS-1264?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Work on LENS-1264 started by Sushil Mohanty.
--------------------------------------------
> Group by promotion not happening with aggregate dim attributes 
> ---------------------------------------------------------------
>
>                 Key: LENS-1264
>                 URL: https://issues.apache.org/jira/browse/LENS-1264
>             Project: Apache Lens
>          Issue Type: Bug
>            Reporter: Sushil Mohanty
>            Assignee: Sushil Mohanty
>
> {CODE}
> <expression name="distinct_users" _type="BIGINT" display_string="Distinct Users">
> <expr_spec expr="count(distinct(user))"/>
> </expression>
> cube query : 
> query execute cube select country,distinct_users from testcube where time_range_in(time_col,'2016-07-31-00','2016-07-31-01')
> rewritten query :
> SELECT distinct (testcube.country), count(distinct (testcube.user)) FROM db.fact_table testcube WHERE (((testcube.dt) in ('2016-07-31-00')))
> {CODE}
> Query  fails with the following:
> Error Message: Line 1:226 Not yet supported place for UDAF 'count'
> Column testcube.country should be part of group by as there is already aggregate column used in select.



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