September 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3360) Provide an option to virtualize source exceptions

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3360?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3360: ---------------------------------- Fix Version/s: 9.2 (was: 9.1) > Provide an option to virtualize source exceptions > ------------------------------------------------- > > Key: TEIID-3360 > URL: https://issues.jboss.org/browse/TEIID-3360 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.2 > > > Currently we'll pass the source exception along with the Teiid exception. And from source sql exceptions we'll also rely the sql state/code. When connecting to databases of different types it would be best to return a common set of codes. > There is exception mapping logic in Hibernate that we could reuse, but this could apply to the non-jdbc sources such that a predictable code will seen by Teiid clients. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years

1
0
0 / 0

[JBoss JIRA] (TEIID-2703) Refactor value retrieval to class based

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2703?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-2703: ---------------------------------- Fix Version/s: 9.2 (was: 9.1) > Refactor value retrieval to class based > --------------------------------------- > > Key: TEIID-2703 > URL: https://issues.jboss.org/browse/TEIID-2703 > Project: Teiid > Issue Type: Enhancement > Components: JDBC Connector > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.2 > > > Similar to Hibernate, we need to introduce encapsulated value retrieval methods. The current approach (which is legacy back to the mmx days) typically uses a switch block with other checks, which can largely be avoided and should improve performance. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4208) Increase plan parallelism

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4208?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4208: ---------------------------------- Fix Version/s: 9.2 (was: 9.1) > Increase plan parallelism > ------------------------- > > Key: TEIID-4208 > URL: https://issues.jboss.org/browse/TEIID-4208 > Project: Teiid > Issue Type: Sub-task > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.2 > > > Increased parallelism within the plan, which includes parallelization of source queries via partitioning beyond multi-source and parallelizing the execution of union branches. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years

1
0
0 / 0

[JBoss JIRA] (TEIID-3537) Use array binding for postgresql dependent join

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3537?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3537: ---------------------------------- Fix Version/s: 9.2 (was: 9.1) > Use array binding for postgresql dependent join > ----------------------------------------------- > > Key: TEIID-3537 > URL: https://issues.jboss.org/browse/TEIID-3537 > Project: Teiid > Issue Type: Enhancement > Components: JDBC Connector > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.2 > > > Rather than creating a large sql statement or rely upon a small fixed limit to the number of binding, we can bind array values to perform dependent query comparisons - where id = ANY ? > This however only seems to work for single values or composites of the same type. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4099) Improve with clause performance with incremental materialization

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4099?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4099: ---------------------------------- Fix Version/s: 9.2 (was: 9.1) > Improve with clause performance with incremental materialization > ---------------------------------------------------------------- > > Key: TEIID-4099 > URL: https://issues.jboss.org/browse/TEIID-4099 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.2 > > > When a with clause item is first referenced it is fully materialized before use. We should generally allow iterative processing for full table scans - in scenarios where the table hasn't been augmented to add inferred indexes. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years

1
0
0 / 0

[JBoss JIRA] (TEIID-3529) Add pushdown support for regexp_replace

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3529?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3529: ---------------------------------- Fix Version/s: 9.2 (was: 9.1) > Add pushdown support for regexp_replace > --------------------------------------- > > Key: TEIID-3529 > URL: https://issues.jboss.org/browse/TEIID-3529 > Project: Teiid > Issue Type: Sub-task > Components: Misc. Connectors, Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.2 > > > At least for sources with similar regex and flags support, we should offer pushdown support. This may require additional support methods to determine if the pattern is acceptable. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years

1
0
0 / 0

[JBoss JIRA] (TEIID-3883) Properly project generated keys

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3883?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3883: ---------------------------------- Fix Version/s: 9.2 (was: 9.1) > Properly project generated keys > ------------------------------- > > Key: TEIID-3883 > URL: https://issues.jboss.org/browse/TEIID-3883 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.2 > > > Even with the generated keys refinements from TEIID-3872 we still are not fully projecting back the generated key values through virtual layers (possibly including masking affects, type, or column name changes). -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4456) Enable the abiltiy to support nested and non-nested message descriptors

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4456?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4456. ----------------------------------- Resolution: Done Merged the pull request. > Enable the abiltiy to support nested and non-nested message descriptors > ----------------------------------------------------------------------- > > Key: TEIID-4456 > URL: https://issues.jboss.org/browse/TEIID-4456 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Reporter: Van Halbert > Assignee: Van Halbert > Fix For: 9.1 > > > Protobuf definition files can have messages defined in a nested and non-nested form. > Nested: > {code} > package bigdata; > message DataEntity { > .. > optional MetaData context = 6; > message MetaData { > ... > } > } > {code} > Non-nested: > {code} > package bigdata; > message DataEntity { > .. > optional MetaData context = 6; > } > message MetaData { > ... > } > {code} > The ProtobufMetadataProcessor needs to be changed to so that it can create the metadata from either use case. > Currently it obtains the child descriptor messages from the parent descriptor. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4478) The 1-to-1 relationship currently doesn't work and doesn't error either

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4478?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4478. ----------------------------------- Resolution: Done Merged the pull request. > The 1-to-1 relationship currently doesn't work and doesn't error either > ----------------------------------------------------------------------- > > Key: TEIID-4478 > URL: https://issues.jboss.org/browse/TEIID-4478 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 9.1 > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Critical > Fix For: 9.1 > > > The 1-to-1 relationship currently doesn't work or produce an exception. It appears to not be specifically handled. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4481) Support for the upsert statement which is provided by Salesforce API

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4481?page=com.atlassian.jira.plugin... ] Steven Hawkins reassigned TEIID-4481: ------------------------------------- Component/s: (was: VDB) Fix Version/s: 9.2 (was: 9.1) Assignee: (was: Steven Hawkins) Moving to 9.2. With TEIID-4481 committed it is possible to update both the translator and the resource adapter to handle the pushdown of an insert marked as an upsert. > Support for the upsert statement which is provided by Salesforce API > -------------------------------------------------------------------- > > Key: TEIID-4481 > URL: https://issues.jboss.org/browse/TEIID-4481 > Project: Teiid > Issue Type: Sub-task > Components: Connector API, Query Engine, Salesforce Connector > Reporter: Thomas Esche > Fix For: 9.2 > > > The Salesforce API provides a "upsert" statement, which combines insert and update functionality. > It would be great to use these feature either by using > - the connector directly or > - the UDF's or > - per SQL. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues September 2016