[
https://issues.apache.org/jira/browse/LENS-136?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14248158#comment-14248158
]
Amareshwari Sriramadasu commented on LENS-136:
----------------------------------------------
I think aliases wont work in group by clause in hive, can you check that first?
> Cube ql to Hive ql translation should use aliases across groupby and select
> ---------------------------------------------------------------------------
>
> Key: LENS-136
> URL: https://issues.apache.org/jira/browse/LENS-136
> Project: Apache Lens
> Issue Type: Improvement
> Reporter: Rajat Khandelwal
>
> cube query:
> {noformat}
> cube select msr1 from cube1 group by expr(fields)
> {noformat}
> hive query(in current logic):
> {noformat}
> select expr(fields), sum(msr1) .... group by expr(fields)
> {noformat}
> expr(fields) should be aliased in select and that alias should be used in
> group by.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
