Amareshwari Sriramadasu created LENS-204:
--------------------------------------------
Summary: 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
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)