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)

Reply via email to