August 2020 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-6013) From where can I download Amazon-s3 translator to read CSV file.

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-6013?page=com.atlassian.jira.plugi... ] Steven Hawkins commented on TEIID-6013: --------------------------------------- > So is there any way to download the amazon-s3 translator? Again it is still in the released teiid versions. http://teiid.io/teiid_wildfly/downloads/ > From where can I download Amazon-s3 translator to read CSV file. > ---------------------------------------------------------------- > > Key: TEIID-6013 > URL: https://issues.redhat.com/browse/TEIID-6013 > Project: Teiid > Issue Type: Feature Request > Reporter: Nayan Bija > Assignee: Steven Hawkins > Priority: Major > > We are referring below link to establish a connection with Google storage using amazon-s3 translator. > [http://teiid.github.io/teiid-documents/master/content/reference/r_amazon-...] > > It is mentioned in the link that > "amzaon-s3 translator is *deprecated*. Please use an s3 source with an appropriate translator such as file or excel" > > We tried to find out the translator on Amazon S3 official website as well as we googled, but couldn't find the appropriate translator for CSV and txt file. > > Could you please provide us a link of s3-translator which supports CSV as well as a text file? -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-6009) How to test web service datasource from Teiid admin console.

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-6009?page=com.atlassian.jira.plugi... ] Steven Hawkins resolved TEIID-6009. ----------------------------------- Resolution: Duplicate Issue See TEIID-6011 > How to test web service datasource from Teiid admin console. > ------------------------------------------------------------ > > Key: TEIID-6009 > URL: https://issues.redhat.com/browse/TEIID-6009 > Project: Teiid > Issue Type: Feature Request > Reporter: Nayan Bija > Assignee: Steven Hawkins > Priority: Major > > We have configured Google auth2 and created a data source of it but couldn't find any way to test it from the Admin console. > Could you please suggest us a way to test connectivity with Google Auth2 using web service data source. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-6008) Add support for maps

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-6008?page=com.atlassian.jira.plugi... ] Steven Hawkins updated TEIID-6008: ---------------------------------- Fix Version/s: 16.0 > Add support for maps > -------------------- > > Key: TEIID-6008 > URL: https://issues.redhat.com/browse/TEIID-6008 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Major > Fix For: 16.0 > > > We should either add a strongly typed map, similar to the array type handling that accepts operations directly - map['key'] - or expand json syntax to postgresql jsonb handling for ->> to make json objects usable as maps. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-992) Improve update of source costing statistics

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-992?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-992. ---------------------------------- Resolution: Out of Date Bulk resolving older issues as out of date. > Improve update of source costing statistics > ------------------------------------------- > > Key: TEIID-992 > URL: https://issues.redhat.com/browse/TEIID-992 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors, Query Engine > Reporter: Marc Shirley > Priority: Major > Fix For: Backlog > > > It is very important that we support the ability to update source statistics at runtime. This is important due to the changing nature of read/write sources and differences between a development data source and a production data source. > The following options should be possible: > 1) Update model/source statistics on VDB deployment. > 2) Update model/source statistics on connector startup. > 3) Update model/source statistics on at a scheduled time. > 4) Update model/source statistics upon a manual request. > case 5920 -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 5 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, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4253) Validate support for Google Cloud SQL

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-4253?page=com.atlassian.jira.plugi... ] Steven Hawkins resolved TEIID-4253. ----------------------------------- Resolution: Out of Date Bulk resolving older issues as out of date. > Validate support for Google Cloud SQL > ------------------------------------- > > Key: TEIID-4253 > URL: https://issues.redhat.com/browse/TEIID-4253 > Project: Teiid > Issue Type: Task > Components: Misc. Connectors > Affects Versions: 9.x > Reporter: Van Halbert > Priority: Major > Fix For: Backlog, Open To Community > > > Validate support for Google Cloud SQL with mysql and postgresql connectivity. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 5 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, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3347) Most subplans do not show node stats

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-3347?page=com.atlassian.jira.plugi... ] Steven Hawkins resolved TEIID-3347. ----------------------------------- Resolution: Out of Date Bulk resolving older issues as out of date. > Most subplans do not show node stats > ------------------------------------ > > Key: TEIID-3347 > URL: https://issues.redhat.com/browse/TEIID-3347 > Project: Teiid > Issue Type: Quality Risk > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Major > Fix For: Backlog > > > When looking at the node stats, only the direct nodes of the current plan have stats. Subqueries, which are executed off of a cloned plan, do not have stats. > There isn't an easy solution for this with the current design. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4219) Support variable and Parameters in HANA Translator

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-4219?page=com.atlassian.jira.plugi... ] Steven Hawkins resolved TEIID-4219. ----------------------------------- Resolution: Out of Date Bulk resolving older issues as out of date. > Support variable and Parameters in HANA Translator > -------------------------------------------------- > > Key: TEIID-4219 > URL: https://issues.redhat.com/browse/TEIID-4219 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Affects Versions: 8.13.4 > Reporter: Ted Jones > Priority: Major > Fix For: Backlog, Open To Community > > > •Variables: > > A Variable can be specified before executing a query on the view. Usually variable values are entered manually by the user on a UI (variable popup). A variable defines a filter on an attribute of the view. Therefore it always has to be assigned to an attribute. The variable values are passed to the engine via the WHERE clause of the SQL statement. Variables are not known by the engine, but only by the clients like Datapreview, MDX, Advanced Analysis for Office or BO Explorer. It is the task of the client to convert the user input into the WHERE clause when accessing the data. > > •Parameters or Input Parameters: > > A parameter (like a variable) can be specified before executing a query on the view. Usually parameter values are entered manually by the user on a UI (variable popup). A Parameter defines an internal parameterization of the view. This means the engine needs to know it and uses the parameter value during the execution (e.g. to calculate a formula for a calculated measure). The parameter value is passed to the engine via the PLACEHOLDER clause of the SQL statement. A parameter can only have single values. For the end user there is no distinction between variables and parameters. Both appear as input fields on the variable popup. > > ------------------ > > There are 4 system tables under the schema _SYS_BI which contains information about Variables. > · BIMC_VARIABLE > · BIMC_VARIABLE_ASSIGNMENT > · BIMC_VARIABLE_VIEW > · BIMC_VARIABLE_VALUE > > SAP HANA documentation on Input parameters: http://help.sap.com/saphelp_hanaplatform/helpdata/en/d5/c8230abb571014acc... > -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 5 months

1
0
0 / 0

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

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-4526?page=com.atlassian.jira.plugi... ] Steven Hawkins resolved TEIID-4526. ----------------------------------- Resolution: Out of Date Bulk resolving older issues as out of date. > Integrate with Debezium for CDC for maintaining materialized views > ------------------------------------------------------------------ > > Key: TEIID-4526 > URL: https://issues.redhat.com/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: Backlog > > > 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.13.8#713008)

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