[
https://issues.apache.org/jira/browse/CALCITE-758?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14588778#comment-14588778
]
Julian Hyde commented on CALCITE-758:
-------------------------------------
I have discovered CALCITE-760. That would seem to explain the problem: your
estimate of row count for the inventory_fact_1997 table was 86837, should have
been 4070. I fixed the row count and now the test suite completes. Will commit
shortly.
I also changed the planner to disregard tiles (i.e. materialized views that are
part of a lattice) when matching materialized views based on tables. Otherwise
a huge number of materialized views are added to the search space. Tiles are
considered later, using a more efficient algorithm.
> Use more than one lattice in the same query
> -------------------------------------------
>
> Key: CALCITE-758
> URL: https://issues.apache.org/jira/browse/CALCITE-758
> Project: Calcite
> Issue Type: Improvement
> Reporter: Rajat Venkatesh
> Assignee: Julian Hyde
>
> Discussed in this thread:
> http://mail-archives.apache.org/mod_mbox/calcite-dev/201506.mbox/%3CCANG6QPyKjG_0Quh-RZBr6-8B7T2M60DbReoDLZ16yUB53zyADw%40mail.gmail.com%3E
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
