Sushil Mohanty created LENS-835:
-----------------------------------
Summary: Optimizing fact subquery by removing non aggregated
expression columns from group by clause
Key: LENS-835
URL: https://issues.apache.org/jira/browse/LENS-835
Project: Apache Lens
Issue Type: Improvement
Components: driver-jdbc
Reporter: Sushil Mohanty
Assignee: Sushil Mohanty
Currently the fact keys used in SQL are part of group by clause by default. If
single row functions e.g case, having fact keys part of it and used in an
aggregate expression such keys need to be removed from fact subquery group by
clause.
Eg. sum(case when fact.key1 = '123' then msr1 when fact.key2 = '345' then msr2
end)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
