September 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4444) Add a built-in delegating translator that allows overriding all supports

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4444?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4444: --------------------------------------- Added TEIIDDES-2920 > Add a built-in delegating translator that allows overriding all supports > ------------------------------------------------------------------------ > > Key: TEIID-4444 > URL: https://issues.jboss.org/browse/TEIID-4444 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Reporter: Steven Hawkins > Assignee: Ramesh Reddy > Labels: CR1 > Fix For: 9.1 > > > To assist in toggling specific capabilities without a patch, we should provide a built-in delegating translator that can selective toggle capabilities. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4475) Add a built-in delegating translator that allows overriding all supports

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-4475: ------------------------------------- Summary: Add a built-in delegating translator that allows overriding all supports Key: TEIID-4475 URL: https://issues.jboss.org/browse/TEIID-4475 Project: Teiid Issue Type: Feature Request Components: Misc. Connectors Reporter: Steven Hawkins Assignee: Ramesh Reddy Fix For: 9.1 To assist in toggling specific capabilities without a patch, we should provide a built-in delegating translator that can selective toggle capabilities. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4459) Convert project semi-joins to (dependent) join queries

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4459?page=com.atlassian.jira.plugin... ] Steven Hawkins edited comment on TEIID-4459 at 9/26/16 4:29 PM: ---------------------------------------------------------------- Added the initial work that is hint driven or requires the use of the system property subqueryUnnestDefault=true. The odata logic was updated to automatically add the hint. The hint is a leading mj (merge join): {code} select x, /*+ mj */ (select ...) as sub from ... {code} was (Author: shawkins): Added the initial work that is hint driven or requires the use of the system property subqueryUnnestDefault=true. The odata logic was updated to automatically add the hint. > Convert project semi-joins to (dependent) join queries > ------------------------------------------------------ > > Key: TEIID-4459 > URL: https://issues.jboss.org/browse/TEIID-4459 > Project: Teiid > Issue Type: Quality Risk > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1 > > > In many situations subqueries in the where clause can be planned as semi-joins. The same logic should be updated to handle the select clause. > This will also help ensure better performance with odata generated array_agg queries. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4459) Convert project semi-joins to (dependent) join queries

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4459?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4459. ----------------------------------- Resolution: Done Added the initial work that is hint driven or requires the use of the system property subqueryUnnestDefault=true. The odata logic was updated to automatically add the hint. > Convert project semi-joins to (dependent) join queries > ------------------------------------------------------ > > Key: TEIID-4459 > URL: https://issues.jboss.org/browse/TEIID-4459 > Project: Teiid > Issue Type: Quality Risk > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1 > > > In many situations subqueries in the where clause can be planned as semi-joins. The same logic should be updated to handle the select clause. > This will also help ensure better performance with odata generated array_agg queries. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4473) Google translator string empty cell is evaluated as NULL

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4473?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4473. ----------------------------------- Fix Version/s: 9.1 Resolution: Done Changed the doc to say that null will be returned for all types. > Google translator string empty cell is evaluated as NULL > -------------------------------------------------------- > > Key: TEIID-4473 > URL: https://issues.jboss.org/browse/TEIID-4473 > Project: Teiid > Issue Type: Bug > Components: Documentation > Reporter: Lucie Fabrikova > Assignee: Steven Hawkins > Fix For: 9.1 > > > In documentation [1] is said "Any non-string column with an empty cell has the value retrieved as null, otherwise it is the empty string." however empty cell of string column is evaluated as NULL instead of empty string. > [1] https://teiid.gitbooks.io/documents/content/reference/Google_Spreadsheet_... > [2] https://access.redhat.com/documentation/en/red-hat-jboss-data-virtualizat... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4469) Insert with query expression does not apply source hint to target

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4469?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4469. ----------------------------------- Fix Version/s: 9.1 9.0.5 Resolution: Done Added tracking of the source hint on the parent project node. > Insert with query expression does not apply source hint to target > ----------------------------------------------------------------- > > Key: TEIID-4469 > URL: https://issues.jboss.org/browse/TEIID-4469 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7.1.6_2 > Reporter: Marc Shirley > Assignee: Steven Hawkins > Fix For: 9.1, 9.0.5 > > > "INSERT INTO ... SELECT ..." statements result in a ProjectIntoNode which seems to prevent any source hints from being passed down to the relevant source. These work correctly with an "INSERT INTO ... VALUES ..." statement. I've included example user and final query plan data below for the non-working [1] and working [2] insert statements. > [1] source hint not applied to ProjectIntoNode: > USER COMMAND: > INSERT /*+sh test:'append' */ INTO test.TEST (ID, "VALUE") SELECT X.id AS ID, X."value" AS "VALUE" FROM (SELECT bqt.SMALLA.INTKEY AS id, bqt.SMALLA.INTNUM AS "value" FROM bqt.SMALLA WHERE bqt.SMALLA.INTKEY = 0) AS X > ... > OPTIMIZATION COMPLETE: > PROCESSOR PLAN: > ProjectIntoNode(0) output=[Count] test.TEST > AccessNode(1) output=[bqt.SMALLA.INTKEY AS ID, bqt.SMALLA.INTNUM AS "VALUE"] SELECT /*+sh test:'append' */ g_0.INTKEY, g_0.INTNUM FROM bqt.SMALLA AS g_0 WHERE g_0.INTKEY = 0 > [2] source hint applied to AccessNode: > USER COMMAND: > INSERT /*+sh test:'append' */ INTO test.TEST (ID, "VALUE") VALUES ('-1', '-1') > ... > OPTIMIZATION COMPLETE: > PROCESSOR PLAN: > AccessNode(0) output=[Count] INSERT /*+sh test:'append' */ INTO test.TEST (ID, "VALUE") VALUES ('-1', '-1') -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4474) Re-license under a more permissive license

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-4474: ------------------------------------- Summary: Re-license under a more permissive license Key: TEIID-4474 URL: https://issues.jboss.org/browse/TEIID-4474 Project: Teiid Issue Type: Task Reporter: Steven Hawkins Assignee: Steven Hawkins There has been some interest in Teiid re-licensing with a more permissive license, such as the ASL or MIT license. Beyond the obvious work of altering headers and license files, we need permission from the original copyright/copyleft holders to approve the change. We'd likely want to use the ASL, but if there are any concerns about GPL compatibility we'll consider the MIT license. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4473) Google translator string empty cell is evaluated as NULL

by Lucie Fabrikova (JIRA)

Lucie Fabrikova created TEIID-4473: -------------------------------------- Summary: Google translator string empty cell is evaluated as NULL Key: TEIID-4473 URL: https://issues.jboss.org/browse/TEIID-4473 Project: Teiid Issue Type: Bug Components: Documentation Reporter: Lucie Fabrikova Assignee: Steven Hawkins In documentation [1] is said "Any non-string column with an empty cell has the value retrieved as null, otherwise it is the empty string." however empty cell of string column is evaluated as NULL instead of empty string. [1] https://teiid.gitbooks.io/documents/content/reference/Google_Spreadsheet_... [2] https://access.redhat.com/documentation/en/red-hat-jboss-data-virtualizat... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4213) Cassandra translator: enable pushdown of aggregate functions

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4213?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4213: --------------------------------------- Since aggregate functions weren't added until 2.2, it would be best to have the support marked as conditional - or update the admin guide to state that it's our minimum expected server version. It also looks like we're due for a client driver upgrade, as even our version detection logic wouldn't work in this case as we are using the 2.1 client. > Cassandra translator: enable pushdown of aggregate functions > ------------------------------------------------------------ > > Key: TEIID-4213 > URL: https://issues.jboss.org/browse/TEIID-4213 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Affects Versions: 8.12.x > Reporter: Jan Stastny > Assignee: Ramesh Reddy > Priority: Minor > Fix For: 9.1 > > > Cassandra supports basic aggregate functions: > MIN(),MAX(),SUM() and AVG() > Currently Teiid doesn't push such queries. > NOTE:In case of AVG() there is difference between the values returned from Teiid vs. Cassandra for an integer column. Cassandra returns only whole part of the number as integer, Teiid returns bigdecimal. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3329) Rationalize older spatial support with the new

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3329?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3329: --------------------------------------- The core st_ system functions are mapped to oracle, so we should be good there. > Rationalize older spatial support with the new > ---------------------------------------------- > > Key: TEIID-3329 > URL: https://issues.jboss.org/browse/TEIID-3329 > Project: Teiid > Issue Type: Quality Risk > Components: Misc. Connectors > Reporter: Steven Hawkins > Assignee: Ramesh Reddy > Fix For: 9.1 > > > MongoDB and Oracle had existing spatial support that should be updated to account for the new support if possible. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 9 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues September 2016