October 2018 - teiid-issues - Jboss List Archives

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

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-4162?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4162: ---------------------------------- Fix Version/s: 12.x (was: 11.x) > Swagger: Add XML payload support > -------------------------------- > > Key: TEIID-4162 > URL: https://issues.jboss.org/browse/TEIID-4162 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Affects Versions: 9.0 > Reporter: Ramesh Reddy > Priority: Major > Fix For: Open To Community, 12.x > > > 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.12.1#712002)

6 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4526) Integrate with Debezium for CDC for maintaining materialized views

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-4526?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4526: ---------------------------------- Fix Version/s: 12.x (was: 11.x) > Integrate with Debezium for CDC for maintaining materialized views > ------------------------------------------------------------------ > > Key: TEIID-4526 > URL: https://issues.jboss.org/browse/TEIID-4526 > Project: Teiid > Issue Type: Sub-task > Components: Server > Affects Versions: 9.2 > Reporter: Van Halbert > Assignee: Ramesh Reddy > Priority: Critical > Fix For: 12.x > > > Integrate with Debezium so that Teiid will be able to consume and react to the row-level change events and do something interesting with them, such as update the materialized view(s). -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4558) Query Plan Analyzer

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-4558?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4558: ---------------------------------- Fix Version/s: 12.x (was: 11.x) > Query Plan Analyzer > ------------------- > > Key: TEIID-4558 > URL: https://issues.jboss.org/browse/TEIID-4558 > Project: Teiid > Issue Type: Feature Request > Components: Tools > Affects Versions: 9.2 > Reporter: Van Halbert > Priority: Major > Fix For: 12.x > > > Provide a tool that would take a query plan and provide feed back. > Example: > - indicate where there maybe a problem in the structure of the query that may impact performance > - indicate in the plan where there maybe issues (like table scan, no rows, etc.) > - provide recommendations for improving performance > etc.. -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4536) Support create schema with multiple statements

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-4536?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4536: ---------------------------------- Fix Version/s: 12.x (was: 11.x) > Support create schema with multiple statements > ---------------------------------------------- > > Key: TEIID-4536 > URL: https://issues.jboss.org/browse/TEIID-4536 > Project: Teiid > Issue Type: Sub-task > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Major > Fix For: 12.x > > > Create schema can support following create statements being directly associated rather than requiring an intermediate use schema > create schema x > create view ... > ... > ; -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4523) CXF is not used by Salesforce BulkConnection

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-4523?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4523: ---------------------------------- Fix Version/s: 12.x (was: 11.x) > CXF is not used by Salesforce BulkConnection > -------------------------------------------- > > Key: TEIID-4523 > URL: https://issues.jboss.org/browse/TEIID-4523 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Affects Versions: 8.12 > Reporter: Steven Hawkins > Assignee: Ramesh Reddy > Priority: Major > Fix For: 12.x > > > TEIID-3493 added the CXF transport, but it's not used by the salesforce BulkConnection. In v22 they make use of a static call, so we won't make a change there. With 34 we can extend the SalesforceConnectorConfig createConnection - but a HttpURLConnection is expected so this may not be straight-forward. -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4498) Generalize subquery batch processing

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-4498?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4498: ---------------------------------- Fix Version/s: 12.x (was: 11.x) > Generalize subquery batch processing > ------------------------------------ > > Key: TEIID-4498 > URL: https://issues.jboss.org/browse/TEIID-4498 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Major > Fix For: 12.x > > > For subqueries that cannot be unnested, but can be modified to project their correlation, we should have at least batch processing rather than the row by row default. -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 2 months

1
0
0 / 0

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

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-4467?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4467: ---------------------------------- Fix Version/s: 12.x (was: 11.x) > Google translator throws exception invalid_query for GROUP BY > -------------------------------------------------------------- > > Key: TEIID-4467 > URL: https://issues.jboss.org/browse/TEIID-4467 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12 > Reporter: Lucie Fabrikova > Priority: Minor > Fix For: 12.x > > 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.12.1#712002)

6 years, 2 months

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: 12.x (was: 11.x) > 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 > Priority: Major > Fix For: 12.x > > > 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.12.1#712002)

6 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4438) Crate ability to filter include/exclude tables during the import across all translators

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-4438?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4438: ---------------------------------- Fix Version/s: 12.x (was: 11.x) > Crate ability to filter include/exclude tables during the import across all translators > --------------------------------------------------------------------------------------- > > Key: TEIID-4438 > URL: https://issues.jboss.org/browse/TEIID-4438 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Reporter: Ramesh Reddy > Priority: Major > Fix For: 12.x > > > Currently only JDBC translator allows exclude tables, inclusion and exclusion of tables to import during the metadata import needs to be added as generic feature across all translators to support TEIID-2578's DDL import command > IMPORT FOREIGN SCHEMA .. INCLUDE .. EXCLUDE .. -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 2 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: 12.x (was: 11.x) > 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 > Priority: Major > Fix For: 12.x > > > 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.12.1#712002)

6 years, 2 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues October 2018