You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@lens.apache.org by "Amareshwari Sriramadasu (JIRA)" <ji...@apache.org> on 2016/02/24 08:10:18 UTC

[jira] [Closed] (LENS-835) Optimizing fact subquery by removing non aggregated expression columns from group by clause

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

Amareshwari Sriramadasu closed LENS-835.
----------------------------------------

> 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
>             Fix For: 2.5
>
>         Attachments: LENS-835.patch
>
>
> 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)