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

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

Sushil Mohanty created LENS-1264:
------------------------------------

             Summary: 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)