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

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.5
• Component/s: driver-jdbc
• Assignee: SushilMohanty
• Reporter: SushilMohanty
• Created: 19/Oct/15 14:03
• Updated: 24/Feb/16 07:09
• Resolved: 25/Oct/15 05:57

Description

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)

Issue Links

• relates to: LENS-846 Not all filters on fact is getting push down