[JBoss JIRA] (TEIID-1680) issues with correlation and aggregation
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-1680?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-1680.
-----------------------------------
Resolution: Done
Updated the validation and planner logic to allow correlated grouping expressions.
> issues with correlation and aggregation
> ---------------------------------------
>
> Key: TEIID-1680
> URL: https://issues.jboss.org/browse/TEIID-1680
> Project: Teiid
> …
[View More] Issue Type: Bug
> Components: Query Engine
> Affects Versions: 7.0
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 8.10
>
>
> subqueries used in the having/select clause of a query with grouping only understand correlated element symbols - not correlated grouping expressions or correlated aggregate values.
> If a nested aggregate contains only outer references, then it should be treated as a correlated value.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
[View Less]
10 years, 1 month
[JBoss JIRA] (TEIID-2469) Pre-Load Materialised Views
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2469?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-2469:
----------------------------------
Summary: Pre-Load Materialised Views (was: Load Materialised Views)
Fix Version/s: 8.11
Component/s: Server
Putting into the 8.11 bucket to further align the internal/external materialization logic so that the can be an option to pre-load internal materialized views.
> Pre-Load Materialised Views
> ------------------…
[View More]---------
>
> Key: TEIID-2469
> URL: https://issues.jboss.org/browse/TEIID-2469
> Project: Teiid
> Issue Type: Feature Request
> Components: Server
> Affects Versions: 8.1
> Reporter: Gautam Banerjee
> Assignee: Steven Hawkins
> Fix For: 8.11
>
>
> Currently teiid does not load materialised views automatically. The request has to come for the materialised view or it has to be explicitly loaded. As materialised views are made with the purpose of preloading data, teiid should load the materialised views as default. There can be a tag or switch which will determine if the materialise views are to be preloaded or not.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
[View Less]
10 years, 1 month