[jira] [Created] (LENS-1028) Convert dimension filter to fact filters for perfomace improvement on outer join queries

["Sushil Mohanty (JIRA)" <ji...@apache.org>]

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)