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

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

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

Sushil Mohanty updated LENS-1028:
---------------------------------
    Status: Patch Available  (was: Open)

> 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
>
>         Attachments: LENS-1028-6.patch
>
>
> 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)