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)
