Sushil Mohanty created LENS-1028:
------------------------------------
Summary: Convert dimension filter to fact filters for perfomace
improvement on outer join queries
Key: LENS-1028
URL: https://issues.apache.org/jira/browse/LENS-1028
Project: Apache Lens
Issue Type: Improvement
Components: cube
Reporter: Sushil Mohanty
Assignee: Sushil Mohanty
Fix For: 2.6
Filters like the following can be converted to fact filters. This will help in
improving query performance by pushing down filter to driving table i.e fact.
e.g.
where dim.name in ('x', 'y')
becomes
where fact.dimid in (select dim.id from dim where dim.name in ('x','y'))
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
