[
https://issues.apache.org/jira/browse/LENS-204?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sushil Mohanty updated LENS-204:
--------------------------------
Status: Patch Available (was: Open)
> 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
> Fix For: 2.2
>
> Attachments: LENS-204-1.patch, LENS-204-4.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)
