[JBoss JIRA] (TEIID-2469) Load Materialised Views
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2469?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-2469:
---------------------------------------
A workaround is to use TEIID-2182 to attach a EventListener to trigger the mat view loads when the vdb loads.
> Load Materialised Views
> -----------------------
>
> Key: TEIID-2469
> URL: https://issues.jboss.org/browse/TEIID-2469
> Project: Teiid
> Issue Type: Feature Request
> Affects Versions: 8.1
> Reporter: Gautam Banerjee
> Assignee: Steven Hawkins
>
> 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 is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 2 months
[JBoss JIRA] (TEIID-2469) Load Materialised Views
by Gautam Banerjee (JIRA)
Gautam Banerjee created TEIID-2469:
--------------------------------------
Summary: Load Materialised Views
Key: TEIID-2469
URL: https://issues.jboss.org/browse/TEIID-2469
Project: Teiid
Issue Type: Feature Request
Affects Versions: 8.1
Reporter: Gautam Banerjee
Assignee: Steven Hawkins
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 is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 2 months
[JBoss JIRA] (TEIID-2468) teiid script should return null if an intermediate object is null
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-2468:
-------------------------------------
Summary: teiid script should return null if an intermediate object is null
Key: TEIID-2468
URL: https://issues.jboss.org/browse/TEIID-2468
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 8.2
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.4
A script such as foo.bar.z will throw an npe if bar is null, but return null if foo is null. for consistency null should always be returned when any reference in the script chain is null.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 2 months
[JBoss JIRA] (TEIID-2467) thread waits for matview loads
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-2467:
-------------------------------------
Summary: thread waits for matview loads
Key: TEIID-2467
URL: https://issues.jboss.org/browse/TEIID-2467
Project: Teiid
Issue Type: Quality Risk
Components: Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.4
While a matview is loading other threads attempting to query the same matview are held as waiters on the table info lock.
Also the mat table loading thread is marked is not allowed to throw a blocked exception and is tied to the current loading work.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 2 months
[JBoss JIRA] (TEIID-2381) Expanded source hint support
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2381?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-2381:
----------------------------------
Fix Version/s: 8.4
> Expanded source hint support
> ----------------------------
>
> Key: TEIID-2381
> URL: https://issues.jboss.org/browse/TEIID-2381
> Project: Teiid
> Issue Type: Enhancement
> Components: Query Engine
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 8.4
>
> Attachments: HintsExecutionFactory.java, RandomExecutionFactory.java, RandomNumberStoredProcedureExecution.java, SysviewHintsExecutionTest.java
>
>
> We currently look at the source hint in only the root user query (not in subqueries nor the with clause) and only consider it in a very narrow set of circumstances when it's used in a view.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 2 months
[JBoss JIRA] (TEIID-2381) Expanded source hint support
by Mark Addleman (JIRA)
[ https://issues.jboss.org/browse/TEIID-2381?page=com.atlassian.jira.plugin... ]
Mark Addleman commented on TEIID-2381:
--------------------------------------
Looks good to me
> Expanded source hint support
> ----------------------------
>
> Key: TEIID-2381
> URL: https://issues.jboss.org/browse/TEIID-2381
> Project: Teiid
> Issue Type: Enhancement
> Components: Query Engine
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Attachments: HintsExecutionFactory.java, RandomExecutionFactory.java, RandomNumberStoredProcedureExecution.java, SysviewHintsExecutionTest.java
>
>
> We currently look at the source hint in only the root user query (not in subqueries nor the with clause) and only consider it in a very narrow set of circumstances when it's used in a view.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 2 months
[JBoss JIRA] (TEIID-2465) Add additional size limitations
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-2465:
-------------------------------------
Summary: Add additional size limitations
Key: TEIID-2465
URL: https://issues.jboss.org/browse/TEIID-2465
Project: Teiid
Issue Type: Quality Risk
Components: Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
We should introduce a limit to lob (which is currently only correct for up to 2 gigs) and single tuplebuffer results in storage as to prevent too much resource consumption from a single use.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 2 months