December 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3868) Add a json type with search support

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3868?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3868: ---------------------------------- Fix Version/s: 10.0 10.0 (was: 9.2) > Add a json type with search support > ----------------------------------- > > Key: TEIID-3868 > URL: https://issues.jboss.org/browse/TEIID-3868 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Affects Versions: 9.0 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 10.0 > > > We should add a json type similar to the json/jsonb types from postgresql. Additional construction and especially search support should added so that most common scenarios will not need intermediate xml processing. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3660) Add support for unnesting anti semijoins

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3660?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3660: ---------------------------------- Fix Version/s: 10.0 10.0 (was: 9.2) > Add support for unnesting anti semijoins > ---------------------------------------- > > Key: TEIID-3660 > URL: https://issues.jboss.org/browse/TEIID-3660 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 10.0 > > > Currently we won't perform the rewrite if it's the anti case. A subquery used as an anti semijoin can be unnested into a left outer join with a filter on the null rows. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4012) Implement XA transaction support for Teiid ODBC

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4012?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4012: ---------------------------------- Fix Version/s: 10.0 10.0 (was: 9.2) > Implement XA transaction support for Teiid ODBC > ----------------------------------------------- > > Key: TEIID-4012 > URL: https://issues.jboss.org/browse/TEIID-4012 > Project: Teiid > Issue Type: Feature Request > Components: ODBC > Affects Versions: 8.7.1.6_2 > Environment: Red Hat JBoss Data Virtualization 6.2.2 on EAP6.4.0 patched to version 6.4.5, > JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157 > 64-bit Windows 7 environment > Reporter: Steve Tran > Assignee: Steven Hawkins > Fix For: 10.0 > > > Without XA support the pg client will hit the following error: > TEIID30020 Processing exception for request ... 'Group does not exist: pg_prepared_xacts' -- This message was sent by Atlassian JIRA (v7.2.3#72005)

9 years, 9 months

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

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4565) Add objects table to system schema

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4565?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4565: ---------------------------------- Fix Version/s: 10.0 10.0 (was: 9.2) > Add objects table to system schema > ---------------------------------- > > Key: TEIID-4565 > URL: https://issues.jboss.org/browse/TEIID-4565 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Tom Johnston > Assignee: Steven Hawkins > Fix For: 10.0 > > > The addition of a objects table would make it simpler to join to when extensions are implemented. > An example might be something similar to this query: > select sysObjects.* > from ( > select t.schemaName as Parent,t.name, t.uid ,'Table' as ObjectType > from sys.tables t > where schemaName not in (select distinct(schemaName) from "SYS"."Tables" where isSystem = true) > UNION > select c.tableName as Parent,c.name, c.uid,'Column' as ObjectType > from sys.columns c > where schemaName not in (select distinct(schemaName) from "SYS"."Tables" where isSystem = true) > UNION > select null as Parent,e.Value as Name,e.uid,'Property' as ObjectType > from sys.properties as e) as SysObjects -- This message was sent by Atlassian JIRA (v7.2.3#72005)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3439) Add support for aliases with .

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3439?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3439: ---------------------------------- Fix Version/s: 10.0 10.0 (was: 9.2) > Add support for aliases with . > ------------------------------ > > Key: TEIID-3439 > URL: https://issues.jboss.org/browse/TEIID-3439 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 10.0 > > > We currently don't allow column or table aliases to contain '.'. This is allowable given a quoted identifier is used. However an early design decision of metamatrix was to relax the rules of naming so that queries against the engine could use quoting (on not) similar to whatever was expected by a given database rather than the engine structure. A lot of resolving and parsing logic will need to change unfortunately to fix this. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

9 years, 9 months

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: 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)

9 years, 9 months

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)

9 years, 9 months

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)

9 years, 9 months

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)

9 years, 9 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues December 2016