August 2020 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4251) Built in support for Postgres DB as materialization target

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-4251?page=com.atlassian.jira.plugi... ] Steven Hawkins resolved TEIID-4251. ----------------------------------- Resolution: Out of Date Bulk resolving older issues as out of date. > Built in support for Postgres DB as materialization target > ---------------------------------------------------------- > > Key: TEIID-4251 > URL: https://issues.redhat.com/browse/TEIID-4251 > Project: Teiid > Issue Type: Feature Request > Components: Server > Reporter: Ramesh Reddy > Priority: Major > Fix For: Backlog > > > If Postgres database is available along with install or assumed that it is available, then some of the materialization task can be automated, like > - Creation of a common STATUS table > - Creation of the materilization targets (create views on dbms) > - On load, on undeploy and load scripts for all the materialization views > We need to device a way this to be pluggable, such that based on success of this, we can provide additional support for other sources. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 7 months

1
0
0 / 0

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

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-3494?page=com.atlassian.jira.plugi... ] Steven Hawkins resolved TEIID-3494. ----------------------------------- Resolution: Out of Date Bulk resolving older issues as out of date. > TABLE() can execute in parallel > ------------------------------- > > Key: TEIID-3494 > URL: https://issues.redhat.com/browse/TEIID-3494 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Mark Addleman > Priority: Major > Fix For: Backlog > > > 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.13.8#713008)

5 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3734) Add data source support for reading DOC documents

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-3734?page=com.atlassian.jira.plugi... ] Steven Hawkins resolved TEIID-3734. ----------------------------------- Resolution: Out of Date Bulk resolving older issues as out of date. > Add data source support for reading DOC documents > ------------------------------------------------- > > Key: TEIID-3734 > URL: https://issues.redhat.com/browse/TEIID-3734 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Reporter: Van Halbert > Priority: Major > Fix For: Backlog, Open To Community > > > Add data source support for reading DOC documents. > The Apache POI could be an option, as it has support for OLE2 document format. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 7 months

1
0
0 / 0

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

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-3360?page=com.atlassian.jira.plugi... ] Steven Hawkins resolved TEIID-3360. ----------------------------------- Resolution: Out of Date Bulk resolving older issues as out of date. > Provide an option to virtualize source exceptions > ------------------------------------------------- > > Key: TEIID-3360 > URL: https://issues.redhat.com/browse/TEIID-3360 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Priority: Major > Fix For: Backlog > > > 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 (v7.13.8#713008)

5 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3560) support common table expression with insert/update/delete

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-3560?page=com.atlassian.jira.plugi... ] Steven Hawkins resolved TEIID-3560. ----------------------------------- Resolution: Out of Date Bulk resolving older issues as out of date. > support common table expression with insert/update/delete > --------------------------------------------------------- > > Key: TEIID-3560 > URL: https://issues.redhat.com/browse/TEIID-3560 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Priority: Major > Fix For: Backlog > > > We currently have limited our cte support to just query expressions. This should be generalized to more statement types. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3738) Add multi-tenant functionality

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-3738?page=com.atlassian.jira.plugi... ] Steven Hawkins resolved TEIID-3738. ----------------------------------- Resolution: Out of Date Bulk resolving older issues as out of date. > Add multi-tenant functionality > ------------------------------ > > Key: TEIID-3738 > URL: https://issues.redhat.com/browse/TEIID-3738 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors, Query Engine > Reporter: Steven Hawkins > Priority: Major > Fix For: Backlog > > > To supplement multi-source functionality, we should add explicit multi-tenant functionality similar to hibernate - http://docs.jboss.org/hibernate/orm/4.2/devguide/en-US/html/ch16.html > This would mostly be carried out at the datasource level, but would also make us cache aware. Otherwise our current story is to implement multi-source and add row level filters to all multi-source tables to prune based upon the user - which we could choose to expand on in Designer or the server such that the necessary roles are created automatically. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 7 months

1
0
0 / 0

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

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-3660?page=com.atlassian.jira.plugi... ] Steven Hawkins resolved TEIID-3660. ----------------------------------- Resolution: Out of Date Bulk resolving older issues as out of date. > Add support for unnesting anti semijoins > ---------------------------------------- > > Key: TEIID-3660 > URL: https://issues.redhat.com/browse/TEIID-3660 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Priority: Major > Fix For: Backlog > > > 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.13.8#713008)

5 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4162) Swagger: Add XML payload support

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-4162?page=com.atlassian.jira.plugi... ] Steven Hawkins resolved TEIID-4162. ----------------------------------- Resolution: Out of Date Bulk resolving older issues as out of date. > Swagger: Add XML payload support > -------------------------------- > > Key: TEIID-4162 > URL: https://issues.redhat.com/browse/TEIID-4162 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Affects Versions: 9.0 > Reporter: Ramesh Reddy > Priority: Major > Fix For: Backlog, Open To Community > > > The initial version only added support for application/json, and support for application/xml based payloads needs to be added to the translator. > Note that the metadata about XML is not captured currently. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-1096) Allow cost analysis tool to work against custom connectors

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-1096?page=com.atlassian.jira.plugi... ] Steven Hawkins resolved TEIID-1096. ----------------------------------- Resolution: Out of Date Bulk resolving older issues as out of date. > Allow cost analysis tool to work against custom connectors > ---------------------------------------------------------- > > Key: TEIID-1096 > URL: https://issues.redhat.com/browse/TEIID-1096 > Project: Teiid > Issue Type: Sub-task > Components: Server > Reporter: Marc Shirley > Priority: Minor > Fix For: Backlog > > > case 5541 -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4467) Google translator throws exception invalid_query for GROUP BY

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-4467?page=com.atlassian.jira.plugi... ] Steven Hawkins resolved TEIID-4467. ----------------------------------- Resolution: Out of Date Bulk resolving older issues as out of date. > Google translator throws exception invalid_query for GROUP BY > -------------------------------------------------------------- > > Key: TEIID-4467 > URL: https://issues.redhat.com/browse/TEIID-4467 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12 > Reporter: Lucie Fabrikova > Priority: Minor > Fix For: Backlog > > Attachments: googlespreadsheet-vdb.xml, server.log > > > Google translator produces following exception for a query: "SELECT IntKey FROM bqt1.SmallA GROUP BY IntKey": > 16:27:26,955 ERROR [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue14) TEIID30019 Unexpected exception for request vn+N1XY8Atf5.6: org.teiid.resource.adapter.google.common.SpreadsheetOperationException: [invalid_query] > at org.teiid.resource.adapter.google.dataprotocol.GoogleDataProtocolAPI$DataProtocolQueryStrategy.executeAndParse(GoogleDataProtocolAPI.java:196) > ... -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 7 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 August 2020