December 2016 - teiid-issues - Jboss List Archives

[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: 10.0 10.0 (was: 9.2) > 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: 10.0 > > > 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 (v7.2.3#72005)

8 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4525) postgresql translator - remove all nulls & non printable characters

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4525?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4525: ---------------------------------- Fix Version/s: 10.0 10.0 (was: Open To Community) (was: 9.2) > postgresql translator - remove all nulls & non printable characters > ------------------------------------------------------------------- > > Key: TEIID-4525 > URL: https://issues.jboss.org/browse/TEIID-4525 > Project: Teiid > Issue Type: Feature Request > Components: JDBC Connector > Reporter: Omar Khan > Priority: Minor > Fix For: Open To Community, 10.0 > > > Would like to see the postgresql translator enhanced to add a feature to minimum remove nulls from text strings as some other databases i.e. Teradata allow for them where Postgres does not. This feature would behave in a similar manner as TrimSpaces, but simply remove all \u0000 characters. > Furthermore, if possible, would like the ability to remove non printable characters to as another option provide another additional stripping mechanism, allowing the postgresql database to serve as a data cleaner if need be. > Please refer to https://developer.jboss.org/thread/272644 for details -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years

1
0
0 / 0

[JBoss JIRA] (TEIID-3494) TABLE() can execute in parallel

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3494?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3494: ---------------------------------- Fix Version/s: 10.0 10.0 (was: 9.2) > TABLE() can execute in parallel > ------------------------------- > > Key: TEIID-3494 > URL: https://issues.jboss.org/browse/TEIID-3494 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Mark Addleman > Assignee: Steven Hawkins > Fix For: 10.0 > > > it would be nice if the TABLE() construct was extended to support parallel source executions in the same way that joins can be executed in parallel. - See more at: https://developer.jboss.org/thread/259330#sthash.YjQyw4vR.dpuf -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years

1
0
0 / 0

[JBoss JIRA] (TEIID-3157) Allow streaming without an intermediate copy

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3157?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3157: ---------------------------------- Fix Version/s: 10.0 10.0 (was: 9.2) > Allow streaming without an intermediate copy > -------------------------------------------- > > Key: TEIID-3157 > URL: https://issues.jboss.org/browse/TEIID-3157 > Project: Teiid > Issue Type: Feature Request > Components: JDBC Driver, Server > Reporter: H B > Assignee: Steven Hawkins > Fix For: 10.0 > > > With TEIID-3153 there are scenarios that require streaming larger than 4 gigs of data. We should also provide a mechanism for on demand streaming from the client to accommodate even larger streaming scenarios to eliminate the need for an intermediate copy. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 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: 10.0 10.0 (was: 9.2) > 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: 10.0 > > > 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 (v7.2.3#72005)

8 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4452) Pushdown SQL/XML

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4452?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4452: ---------------------------------- Fix Version/s: 10.0 10.0 (was: 9.2) > Pushdown SQL/XML > ---------------- > > Key: TEIID-4452 > URL: https://issues.jboss.org/browse/TEIID-4452 > Project: Teiid > Issue Type: Enhancement > Components: JDBC Connector > Affects Versions: 9.x > Reporter: Tom Arnold > Fix For: 10.0 > > > It would be helpful to pushdown SQL/XML functions for JDBC databases that support them. > Databases: > - Oracle > - Postgres > Functions: > - XMLELEMENT > - XMLATTRIBUTES > - XMLAGG > - XMLCONCAT > We have an application that uses these functions and we support Oracle, Postgres, and Teiid (to integrate external data sources). Here's an example query generated by this application: > {code:xml} > select > "ITEMS"."ITEM_ID" "ITEM_ID", > ( > select xmlelement ( > name "attributes", > xmlagg( > xmlelement( > name "attribute", > xmlattributes( > "ITEM_ATTRIBUTES"."ATTR_NAME" as "name", > "ITEM_ATTRIBUTES"."ATTR_VALUE" as "value" > ) > ) > ) > ) > from "ITEM_ATTRIBUTES" "ITEM_ATTRIBUTES" > where ( > "ITEMS"."ITEM_ID" = "ITEM_ATTRIBUTES"."ITEM_ID" > ) > ) "ITEM_ATTRIBUTES" > {code} > {code} > ITEM_ID ITEM_ATTRIBUTES > 3 <attributes><attribute name="foo" value="bar"></attribute><attribute name="baz" value="blah"></attribute></attributes> > 4 <attributes><attribute name="foo" value="123"></attribute><attribute name="baz" value="456"></attribute></attributes> > {code} > When we are using Teiid queries like this do not work well because they cannot be pushed down, so we get N-many queries (one per row) and the query ends up taking much longer than if performed directly against Oracle/Postgres. > Since SQL/XML is standard and supported by both Oracle/Postgres it would be good if queries like this could be pushed in their entirety so that there would be no performance difference between going through Teiid and native. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 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: 10.0 10.0 (was: 9.2) > 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: 10.0 > > > 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 (v7.2.3#72005)

8 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: 10.0 10.0 (was: 9.2) > 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: 10.0 > > > 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 (v7.2.3#72005)

8 years

1
0
0 / 0

[JBoss JIRA] (TEIID-3617) Provide an option to Limit per user based connections

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3617?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3617: ---------------------------------- Fix Version/s: 10.0 10.0 (was: 9.2) > Provide an option to Limit per user based connections > ----------------------------------------------------- > > Key: TEIID-3617 > URL: https://issues.jboss.org/browse/TEIID-3617 > Project: Teiid > Issue Type: Feature Request > Components: Server > Reporter: Xian Liu > Assignee: Kylin Soong > Fix For: 10.0 > > > we deploy teiid for users to get data, but some users will create many connections to teiid and they are not necessary, I need to find a good way to limit each user account can only get like 50 connections or so -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4375) Allow bind values to be used for limit/offset in pushdown queries

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4375?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4375: ---------------------------------- Fix Version/s: 10.0 10.0 (was: 9.2) > Allow bind values to be used for limit/offset in pushdown queries > ----------------------------------------------------------------- > > Key: TEIID-4375 > URL: https://issues.jboss.org/browse/TEIID-4375 > Project: Teiid > Issue Type: Quality Risk > Components: JDBC Connector > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 10.0 > > > We always put the literal values of the limit clause into the source query, but for sources that support it, it would be better to use a bind value. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues December 2016