[jira] [Updated] (LENS-204) Support union across tables in cube rewriting

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

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

Sushil Mohanty updated LENS-204:
--------------------------------
    Attachment: LENS-204-1.patch

> Support union across tables in cube rewriting
> ---------------------------------------------
>
>                 Key: LENS-204
>                 URL: https://issues.apache.org/jira/browse/LENS-204
>             Project: Apache Lens
>          Issue Type: Improvement
>          Components: cube
>            Reporter: Amareshwari Sriramadasu
>            Assignee: Sushil Mohanty
>         Attachments: LENS-204-1.patch
>
>
> Right now, if query rewriting requires union across two or more tables, the query fails. We would need union across two or more tables for the following use cases
> # The time range queried is spread across two or more storage tables of a fact
> # The time range queried is spread across two or more fact tables
> # This is debatable use case - the same measure is present in two fact tables
> ** When same measure is present in more than one fact table, we pick one candidate fact table right now. Optionally, we should allow union with other facts through fact property. I won't push for this, but putting it here as we have seen this in our internal data model.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)