April 2019 - teiid-issues - Jboss List Archives

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIIDSB-64?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIIDSB-64: --------------------------------------- On sticky routes. According to the docs they are sticky by default. The only issue is if there is another load-balancer in front of the router in which the source ip is the same for all requests and all traffic is routed to a single pod. The only way around that limitation is to use a different strategy and cookies - which could be done for odata, but not pg/jdbc. > Research HA > ----------- > > Key: TEIIDSB-64 > URL: https://issues.jboss.org/browse/TEIIDSB-64 > Project: Teiid Spring Boot > Issue Type: Quality Risk > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Major > > Teiid's pg, and jdbc assume session affinity. Also OData pagination works best with session affinity. > For HA, and horizontal scaling, it would be good to have more than 1 pod alive and receiving traffic. It appears that there is a sessionAffinity setting at a service level https://kubernetes.io/docs/concepts/services-networking/service/ and some work that can be done to customize routes https://docs.openshift.com/container-platform/3.9/architecture/networking... - but that doesn't appear to work for just tcp traffic. -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5720) PSQL client fails to report the metadata

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5720?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5720: --------------------------------------- The initial commit is in. We now better match the semantics of pg wrt char to string comparisons. The always false case still exists - if you compare for example "'ab' = charValue" with widen comparisons turned off (the default) you'll still get an exception. > PSQL client fails to report the metadata > ---------------------------------------- > > Key: TEIID-5720 > URL: https://issues.jboss.org/browse/TEIID-5720 > Project: Teiid > Issue Type: Bug > Components: ODBC > Reporter: Ramesh Reddy > Assignee: Steven Hawkins > Priority: Major > > When using psql client and issuing the "\dt" command I see this exception instead of returning the table names. > {code} > WARN: TEIID30020 Processing exception for request grF9mx6fyMfD.1 'TEIID30082 Expected value of type 'char' but '''' is of type 'string' and no implicit conversion is available.'. Originally QueryResolverException ResolverUtil.java:230. > org.teiid.api.exception.query.QueryResolverException: TEIID30082 Expected value of type 'char' but '''' is of type 'string' and no implicit conversion is available. > at org.teiid.query.resolver.util.ResolverUtil.convertExpression(ResolverUtil.java:230) > at org.teiid.query.resolver.util.ResolverVisitor.resolveSetCriteria(ResolverVisitor.java:1203) > at org.teiid.query.resolver.util.ResolverVisitor.visit(ResolverVisitor.java:294) > at org.teiid.query.sql.lang.SetCriteria.acceptVisitor(SetCriteria.java:96) > at org.teiid.query.sql.navigator.AbstractNavigator.visitVisitor(AbstractNavigator.java:50) > at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.postVisitVisitor(PreOrPostOrderNavigator.java:57) > at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.postVisitVisitor(SimpleQueryResolver.java:229) > at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:345) > at org.teiid.query.sql.lang.SetCriteria.acceptVisitor(SetCriteria.java:96) > at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:59) > at org.teiid.query.sql.navigator.AbstractNavigator.visitNodes(AbstractNavigator.java:72) > at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:135) > at org.teiid.query.sql.lang.CompoundCriteria.acceptVisitor(CompoundCriteria.java:231) > at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:59) > at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.visit(SimpleQueryResolver.java:244) > at org.teiid.query.resolver.command.SimpleQueryResolver.resolveCommand(SimpleQueryResolver.java:66) > at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:178) > at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:120) > at org.teiid.dqp.internal.process.Request.resolveCommand(Request.java:282) > at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:418) > at org.teiid.dqp.internal.process.Request.processRequest(Request.java:486) > at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:672) > at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:351) > at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:43) > at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:285) > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:281) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:124) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$2.run(ThreadReuseExecutor.java:212) > at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) > at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) > at java.base/java.lang.Thread.run(Thread.java:834) > {code} -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5708) Secure maven access for all repositories in the Teiid organization

by RH Bugzilla Integration (Jira)

[ https://issues.jboss.org/browse/TEIID-5708?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-5708: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1695621|https://bugzilla.redhat.com/show_bug.cgi?id=1695621] from NEW to MODIFIED > Secure maven access for all repositories in the Teiid organization > ------------------------------------------------------------------ > > Key: TEIID-5708 > URL: https://issues.jboss.org/browse/TEIID-5708 > Project: Teiid > Issue Type: Task > Components: Build/Kits > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Priority: Major > Fix For: 12.2 > > > convert the access to "https" for any dependency repositories. -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 8 months

1
0
0 / 0

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

by Ramesh Reddy (Jira)

Ramesh Reddy created TEIID-5723: ----------------------------------- Summary: Built in support for Postgres DB as materialization target Key: TEIID-5723 URL: https://issues.jboss.org/browse/TEIID-5723 Project: Teiid Issue Type: Feature Request Components: Server Reporter: Ramesh Reddy Assignee: Steven Hawkins Fix For: 12.2 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.12.1#712002)

5 years, 8 months

1
0
0 / 0

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

by Ramesh Reddy (Jira)

[ https://issues.jboss.org/browse/TEIID-4251?page=com.atlassian.jira.plugin... ] Ramesh Reddy updated TEIID-4251: -------------------------------- Parent: (was: TEIID-4249) Issue Type: Feature Request (was: Sub-task) > Built in support for Postgres DB as materialization target > ---------------------------------------------------------- > > Key: TEIID-4251 > URL: https://issues.jboss.org/browse/TEIID-4251 > Project: Teiid > Issue Type: Feature Request > Components: Server > Reporter: Ramesh Reddy > Assignee: Steven Hawkins > Priority: Major > Fix For: 12.2 > > > 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.12.1#712002)

5 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-80) OpenApi 3.0 Support for OData

by Ramesh Reddy (Jira)

Ramesh Reddy created TEIIDSB-80: ----------------------------------- Summary: OpenApi 3.0 Support for OData Key: TEIIDSB-80 URL: https://issues.jboss.org/browse/TEIIDSB-80 Project: Teiid Spring Boot Issue Type: Feature Request Reporter: Ramesh Reddy Assignee: Ramesh Reddy Fix For: 1.1.0 Support OpenAPI 3.0 document generation with OData service -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-79) Develop OpenShift Operator for deploying VDBs

by Ramesh Reddy (Jira)

Ramesh Reddy created TEIIDSB-79: ----------------------------------- Summary: Develop OpenShift Operator for deploying VDBs Key: TEIIDSB-79 URL: https://issues.jboss.org/browse/TEIIDSB-79 Project: Teiid Spring Boot Issue Type: Feature Request Components: OpenShift Reporter: Ramesh Reddy Need to develop a GO lang based Operator for deploying the VDBs and its configuration. -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-78) Provide GoogleSheets support

by Ramesh Reddy (Jira)

Ramesh Reddy created TEIIDSB-78: ----------------------------------- Summary: Provide GoogleSheets support Key: TEIIDSB-78 URL: https://issues.jboss.org/browse/TEIIDSB-78 Project: Teiid Spring Boot Issue Type: Feature Request Components: datasource Reporter: Ramesh Reddy Fix For: 1.1.0 Provide data source support for Google Sheets. Must support the same authentication mechanism as Syndesis. -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-77) Provide OData Source support

by Ramesh Reddy (Jira)

Ramesh Reddy created TEIIDSB-77: ----------------------------------- Summary: Provide OData Source support Key: TEIIDSB-77 URL: https://issues.jboss.org/browse/TEIIDSB-77 Project: Teiid Spring Boot Issue Type: Feature Request Components: datasource Reporter: Ramesh Reddy Provide the OData as source support. -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-76) Provide Salesforce source support

by Ramesh Reddy (Jira)

Ramesh Reddy created TEIIDSB-76: ----------------------------------- Summary: Provide Salesforce source support Key: TEIIDSB-76 URL: https://issues.jboss.org/browse/TEIIDSB-76 Project: Teiid Spring Boot Issue Type: Feature Request Components: datasource Affects Versions: 1.1.0 Reporter: Ramesh Reddy Assignee: Ramesh Reddy Salesforce data source needs to be supported. Should support the same authentication as the Syndesis -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 8 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues April 2019