March 2017 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-1226) Reuse dynamic sql plans and allow for prepared statements in procedure logic

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-1226?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-1226: ---------------------------------- Fix Version/s: 10.x (was: 9.x) > Reuse dynamic sql plans and allow for prepared statements in procedure logic > ---------------------------------------------------------------------------- > > Key: TEIID-1226 > URL: https://issues.jboss.org/browse/TEIID-1226 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Affects Versions: 7.1 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Minor > Fix For: 10.x > > > Dynamic sql plans (for dynamic sql statements, lookup, and matview refreshes) should allow for plan reuse. > Also procedure logic should have a mechanism to execute prepared statements for further plan reuse. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-147) Support for JAVA Stored Procedures

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-147?page=com.atlassian.jira.plugin.... ] Steven Hawkins updated TEIID-147: --------------------------------- Fix Version/s: 10.0 (was: 9.x) We will evaluate in 10.0 if this is something that we want to pursue. We can use logic similar to the script binding that we do for objecttable to allow the procedure to declare it's language. It would then have access to well defined context objects. However with that approach queries will be executed in a synch manner as we won't be able to block/release the thread. > Support for JAVA Stored Procedures > ---------------------------------- > > Key: TEIID-147 > URL: https://issues.jboss.org/browse/TEIID-147 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Affects Versions: 9.x > Reporter: Ramesh Reddy > Fix For: 10.0 > > > Currently the Stored procedure support is lacking for both our procedure language and XQuery. Procedure support could be extended to java (or groovy) code, which will provide a powerful engine to execute a arbitrary queries. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4383) Add teiid javadocs and supplemental api documentation

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4383?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4383. ----------------------------------- Fix Version/s: (was: 9.x) Resolution: Out of Date The javadocs are posted with each major release, but this can be re-opened or re-logged if I'm misinterpreting. > Add teiid javadocs and supplemental api documentation > ----------------------------------------------------- > > Key: TEIID-4383 > URL: https://issues.jboss.org/browse/TEIID-4383 > Project: Teiid > Issue Type: Sub-task > Components: Embedded > Reporter: Kylin Soong > Assignee: Kylin Soong > > We can use maven-javadoc-plugin to generate javadoc, [1] can be a example, reference code repo [2] > [1] https://wildfly-swarm.github.io/wildfly-swarm-javadocs/2016.7-SNAPSHOT/ap... > [2] https://github.com/wildfly-swarm/wildfly-swarm/blob/master/public-javadoc... -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4249) Materialization Improvements

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4249?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4249: ---------------------------------- Fix Version/s: 10.x (was: 9.x) > Materialization Improvements > ---------------------------- > > Key: TEIID-4249 > URL: https://issues.jboss.org/browse/TEIID-4249 > Project: Teiid > Issue Type: Feature Request > Components: Server > Reporter: Ramesh Reddy > Fix For: 10.x > > > This JIRA will be bucket JIRA for the Meterialization improvements -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3531) Better planning of bushy join trees

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3531?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3531: ---------------------------------- Fix Version/s: 10.x (was: 9.x) > Better planning of bushy join trees > ----------------------------------- > > Key: TEIID-3531 > URL: https://issues.jboss.org/browse/TEIID-3531 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 10.x > > > The primary join planning logic considers left linear trees. We also have a hint to preserve structure and some planning that reuses existing subtrees, but nothing general around considering bushy trees. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3931) Add support for odata service geospatial handling

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3931?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3931: ---------------------------------- Fix Version/s: 10.x (was: 9.x) > Add support for odata service geospatial handling > ------------------------------------------------- > > Key: TEIID-3931 > URL: https://issues.jboss.org/browse/TEIID-3931 > Project: Teiid > Issue Type: Enhancement > Components: OData > Reporter: Steven Hawkins > Fix For: 10.x > > > We should use the Edm.Geometry type for the Teiid geometry type (we can also use system metadata to see if it's appropriate to use a geometry subtype) along with any geospatial operations that odata and Teiid support. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-303) Remove the LanguageBridgeFactory

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-303?page=com.atlassian.jira.plugin.... ] Steven Hawkins updated TEIID-303: --------------------------------- Fix Version/s: 10.x (was: 9.x) > Remove the LanguageBridgeFactory > -------------------------------- > > Key: TEIID-303 > URL: https://issues.jboss.org/browse/TEIID-303 > Project: Teiid > Issue Type: Task > Components: Connector API, Query Engine > Affects Versions: 6.0.0 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 10.x > > > Defect Tracker #25061: The language objects at the data layer are redundent with the language objects used in commands. The LanguageBridgeFactory can be removed in favor of simply cloning and issuing a command. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-226) Cacheing translated commands would improve connector performance

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-226?page=com.atlassian.jira.plugin.... ] Steven Hawkins updated TEIID-226: --------------------------------- Fix Version/s: 10.x (was: 9.x) > Cacheing translated commands would improve connector performance > ---------------------------------------------------------------- > > Key: TEIID-226 > URL: https://issues.jboss.org/browse/TEIID-226 > Project: Teiid > Issue Type: Feature Request > Components: Connector API, Query Engine > Affects Versions: 6.0.0 > Reporter: Steven Hawkins > Fix For: 10.x > > > Defect Tracker #16722: AD 2/17/05 - Command translation in connector - approx. half the time taken to create an Execution object is spent in command translation. If there was a way to cache the translated command, then we could eliminate that step for subsequent requests. > Alex 2/17/05 - The problem is that the connector can be used with different vdbs, so the translation may be different even for the same query. Still seems do-able [...]. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-321) Refactor symbol language objects

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-321?page=com.atlassian.jira.plugin.... ] Steven Hawkins updated TEIID-321: --------------------------------- Fix Version/s: 10.x (was: 9.x) > Refactor symbol language objects > -------------------------------- > > Key: TEIID-321 > URL: https://issues.jboss.org/browse/TEIID-321 > Project: Teiid > Issue Type: Task > Components: Query Engine > Affects Versions: 6.0.0 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 10.x > > Original Estimate: 1 week > Remaining Estimate: 1 week > > Defect Tracker #25035: The current structuring of Symbol objects is confusing and makes planning more difficult than necessary. Changes that should be made: > AggregateSymbol should become AggregateFunction (which should not inherit from Function) and not be a Symbol. > SingleElementSymbol, ExpressionSymbol, and AliasSymbol should be merged to a single class DerivedSymbol > DerivedSymbol and MultipleElementSymbol should implement SelectSymbol (as an interface rather than base class) and SelectSymbol should provide a method for getting the projected symbols. > ElementSymbol should not directly be a DerivedSymbol. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4178) OData and Rest wars use different conventions

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4178?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4178: ---------------------------------- Fix Version/s: 10.0 (was: 9.x) > OData and Rest wars use different conventions > --------------------------------------------- > > Key: TEIID-4178 > URL: https://issues.jboss.org/browse/TEIID-4178 > Project: Teiid > Issue Type: Quality Risk > Components: OData, Server > Reporter: Steven Hawkins > Priority: Minor > Fix For: 10.0 > > > OData uses vdb.version while Rest uses vdb_version. If we were to make them the same, there would still need to be a backwards compatibility mode. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 10 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues March 2017