December 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4623) Add support for analytic function "Lead" and "Lag" with GreenPlum Translator

by Anu Saji (JIRA)

[ https://issues.jboss.org/browse/TEIID-4623?page=com.atlassian.jira.plugin... ] Anu Saji updated TEIID-4623: ---------------------------- Affects Version/s: 8.7 (was: 8.12.x) > Add support for analytic function "Lead" and "Lag" with GreenPlum Translator > ----------------------------------------------------------------------------- > > Key: TEIID-4623 > URL: https://issues.jboss.org/browse/TEIID-4623 > Project: Teiid > Issue Type: Enhancement > Components: Connector API > Affects Versions: 8.7 > Reporter: Anu Saji > Assignee: Steven Hawkins > Fix For: 9.2 > > > Request for adding support for analytical functions Lead and Lag to GreenPlum translator out of box -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4623) Add support for analytic function "Lead" and "Lag" with GreenPlum Translator

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4623?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4623: --------------------------------------- How does this issue relate to TEIID-4598? > Add support for analytic function "Lead" and "Lag" with GreenPlum Translator > ----------------------------------------------------------------------------- > > Key: TEIID-4623 > URL: https://issues.jboss.org/browse/TEIID-4623 > Project: Teiid > Issue Type: Enhancement > Components: Connector API > Affects Versions: 8.12.x > Reporter: Anu Saji > Assignee: Steven Hawkins > Fix For: 9.2 > > > Request for adding support for analytical functions Lead and Lag to GreenPlum translator out of box -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4623) Add support for analytic function "Lead" and "Lag" with GreenPlum Translator

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4623?page=com.atlassian.jira.plugin... ] Ramesh Reddy updated TEIID-4623: -------------------------------- Fix Version/s: 9.2 (was: 8.12.x) > Add support for analytic function "Lead" and "Lag" with GreenPlum Translator > ----------------------------------------------------------------------------- > > Key: TEIID-4623 > URL: https://issues.jboss.org/browse/TEIID-4623 > Project: Teiid > Issue Type: Enhancement > Components: Connector API > Affects Versions: 8.12.x > Reporter: Anu Saji > Assignee: Steven Hawkins > Fix For: 9.2 > > > Request for adding support for analytical functions Lead and Lag to GreenPlum translator out of box -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4623) Add support for analytic function "Lead" and "Lag" with GreenPlum Translator

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4623?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4623: --------------------------------------- To clarify, the translator is advertising support for ElementaryOlapOperations with version 8.4+, based upon the postgresql versioning scheme. Are you indicating here that the greenplum server reports alternatively versions, such that we'll need a different version check? Additionally are you requesting that lead/lag are added as pushdown functions for postregresl/greenplum? And is engine support expected? > Add support for analytic function "Lead" and "Lag" with GreenPlum Translator > ----------------------------------------------------------------------------- > > Key: TEIID-4623 > URL: https://issues.jboss.org/browse/TEIID-4623 > Project: Teiid > Issue Type: Enhancement > Components: Connector API > Affects Versions: 8.12.x > Reporter: Anu Saji > Assignee: Steven Hawkins > Fix For: 8.12.x > > > Request for adding support for analytical functions Lead and Lag to GreenPlum translator out of box -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4623) Add support for analytic function "Lead" and "Lag" with GreenPlum Translator

by Hisanobu Okuda (JIRA)

[ https://issues.jboss.org/browse/TEIID-4623?page=com.atlassian.jira.plugin... ] Hisanobu Okuda updated TEIID-4623: ---------------------------------- > Add support for analytic function "Lead" and "Lag" with GreenPlum Translator > ----------------------------------------------------------------------------- > > Key: TEIID-4623 > URL: https://issues.jboss.org/browse/TEIID-4623 > Project: Teiid > Issue Type: Enhancement > Components: Connector API > Affects Versions: 8.12.x > Reporter: Anu Saji > Assignee: Steven Hawkins > Fix For: 8.12.x > > > Request for adding support for analytical functions Lead and Lag to GreenPlum translator out of box -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4623) Add support for analytic function "Lead" and "Lag" with GreenPlum Translator

by Hisanobu Okuda (JIRA)

[ https://issues.jboss.org/browse/TEIID-4623?page=com.atlassian.jira.plugin... ] Hisanobu Okuda commented on TEIID-4623: --------------------------------------- Now the feature is enabled by setting the translator override "Database Version" to "8.4" or later. The customer wants to have the feature without setting anything. > Add support for analytic function "Lead" and "Lag" with GreenPlum Translator > ----------------------------------------------------------------------------- > > Key: TEIID-4623 > URL: https://issues.jboss.org/browse/TEIID-4623 > Project: Teiid > Issue Type: Enhancement > Components: Connector API > Affects Versions: 8.12.x > Reporter: Anu Saji > Assignee: Steven Hawkins > Fix For: 8.12.x > > > Request for adding support for analytical functions Lead and Lag to GreenPlum translator out of box -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4623) Add support for analytic function "Lead" and "Lag" with GreenPlum Translator

by Anu Saji (JIRA)

[ https://issues.jboss.org/browse/TEIID-4623?page=com.atlassian.jira.plugin... ] Anu Saji updated TEIID-4623: ---------------------------- Description: Request for adding support for analytical functions Lead and Lag to GreenPlum translator out of box (was: Request for adding support for analytical functions Lead and Lag to GreenPlum translator) > Add support for analytic function "Lead" and "Lag" with GreenPlum Translator > ----------------------------------------------------------------------------- > > Key: TEIID-4623 > URL: https://issues.jboss.org/browse/TEIID-4623 > Project: Teiid > Issue Type: Enhancement > Components: Connector API > Affects Versions: 8.12.x > Reporter: Anu Saji > Assignee: Steven Hawkins > Fix For: 8.12.x > > > Request for adding support for analytical functions Lead and Lag to GreenPlum translator out of box -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4623) Add support for analytic function "Lead" and "Lag" with GreenPlum Translator

by Anu Saji (JIRA)

Anu Saji created TEIID-4623: ------------------------------- Summary: Add support for analytic function "Lead" and "Lag" with GreenPlum Translator Key: TEIID-4623 URL: https://issues.jboss.org/browse/TEIID-4623 Project: Teiid Issue Type: Enhancement Components: Connector API Affects Versions: 8.12.x Reporter: Anu Saji Assignee: Steven Hawkins Fix For: 8.12.x Request for adding support for analytical functions Lead and Lag to GreenPlum translator -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4611) Infinispan DSL translator - error deleting rows from table

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4611?page=com.atlassian.jira.plugin... ] Van Halbert updated TEIID-4611: ------------------------------- Fix Version/s: 9.2 > Infinispan DSL translator - error deleting rows from table > ---------------------------------------------------------- > > Key: TEIID-4611 > URL: https://issues.jboss.org/browse/TEIID-4611 > Project: Teiid > Issue Type: Bug > Components: JDG Connector, Misc. Connectors > Affects Versions: 8.12.8.6_3 > Reporter: Juraj Duráni > Assignee: Van Halbert > Priority: Blocker > Fix For: 9.2 > > > DSL translator is not able to delete rows from table: > {code:sql|title=Example queries} > insert into smalla (intkey, stringkey) values (1, '1'); > insert into smalla (intkey, stringkey) values (2, '2'); > delete from smalla > {code} > Teiid seems to try to delete record repeatedly: > {code:plain|title=Exception} > 14:05:20,351 WARN [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue37) TEIID21013 ObjectUpdateExecution: Warning - The object does not exist when trying to delete from table SmallA with key 2 > 14:05:20,352 WARN [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue37) Connector worker process failed for atomic-request=IuoK2RpItaN2.13.0.6: org.teiid.translator.TranslatorException: TEIID21012 Processing error: Unable to delete the object in table SmallA with key 2 > at org.teiid.translator.object.ObjectUpdateExecution.handleDelete(ObjectUpdateExecution.java:385) [translator-object-8.12.8.6_3-redhat-1.jar:8.12.8.6_3-redhat-1] > at org.teiid.translator.object.ObjectUpdateExecution.executeUpdate(ObjectUpdateExecution.java:137) [translator-object-8.12.8.6_3-redhat-1.jar:8.12.8.6_3-redhat-1] > at org.teiid.translator.object.ObjectUpdateExecution.execute(ObjectUpdateExecution.java:100) [translator-object-8.12.8.6_3-redhat-1.jar:8.12.8.6_3-redhat-1] > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem$1.execute(ConnectorWorkItem.java:404) [teiid-engine-8.12.8.6_3-redhat-1.jar:8.12.8.6_3-redhat-1] > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:366) [teiid-engine-8.12.8.6_3-redhat-1.jar:8.12.8.6_3-redhat-1] > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0-internal] > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0-internal] > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0-internal] > at java.lang.reflect.Method.invoke(Method.java:483) [rt.jar:1.8.0-internal] > at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) [teiid-engine-8.12.8.6_3-redhat-1.jar:8.12.8.6_3-redhat-1] > at com.sun.proxy.$Proxy47.execute(Unknown Source) > at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306) [teiid-engine-8.12.8.6_3-redhat-1.jar:8.12.8.6_3-redhat-1] > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) [teiid-engine-8.12.8.6_3-redhat-1.jar:8.12.8.6_3-redhat-1] > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) [teiid-engine-8.12.8.6_3-redhat-1.jar:8.12.8.6_3-redhat-1] > at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0-internal] > at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) [teiid-engine-8.12.8.6_3-redhat-1.jar:8.12.8.6_3-redhat-1] > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280) [teiid-engine-8.12.8.6_3-redhat-1.jar:8.12.8.6_3-redhat-1] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.8.6_3-redhat-1.jar:8.12.8.6_3-redhat-1] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.8.6_3-redhat-1.jar:8.12.8.6_3-redhat-1] > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0-internal] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0-internal] > at java.lang.Thread.run(Thread.java:744) [rt.jar:1.8.0-internal] > {code} > Moreover, Teiid removes only one row (I will log this issue separately): > *Data in table before delete:* > |IntKey|StringKey|...| > |1|1|...| > |2|2|...| > *Data in table after delete:* > |IntKey|StringKey|...| > |2|2|...| -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4611) Infinispan DSL translator - error deleting rows from table

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4611?page=com.atlassian.jira.plugin... ] Van Halbert updated TEIID-4611: ------------------------------- Git Pull Request: https://github.com/teiid/teiid/pull/848 > Infinispan DSL translator - error deleting rows from table > ---------------------------------------------------------- > > Key: TEIID-4611 > URL: https://issues.jboss.org/browse/TEIID-4611 > Project: Teiid > Issue Type: Bug > Components: JDG Connector, Misc. Connectors > Affects Versions: 8.12.8.6_3 > Reporter: Juraj Duráni > Assignee: Van Halbert > Priority: Blocker > > DSL translator is not able to delete rows from table: > {code:sql|title=Example queries} > insert into smalla (intkey, stringkey) values (1, '1'); > insert into smalla (intkey, stringkey) values (2, '2'); > delete from smalla > {code} > Teiid seems to try to delete record repeatedly: > {code:plain|title=Exception} > 14:05:20,351 WARN [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue37) TEIID21013 ObjectUpdateExecution: Warning - The object does not exist when trying to delete from table SmallA with key 2 > 14:05:20,352 WARN [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue37) Connector worker process failed for atomic-request=IuoK2RpItaN2.13.0.6: org.teiid.translator.TranslatorException: TEIID21012 Processing error: Unable to delete the object in table SmallA with key 2 > at org.teiid.translator.object.ObjectUpdateExecution.handleDelete(ObjectUpdateExecution.java:385) [translator-object-8.12.8.6_3-redhat-1.jar:8.12.8.6_3-redhat-1] > at org.teiid.translator.object.ObjectUpdateExecution.executeUpdate(ObjectUpdateExecution.java:137) [translator-object-8.12.8.6_3-redhat-1.jar:8.12.8.6_3-redhat-1] > at org.teiid.translator.object.ObjectUpdateExecution.execute(ObjectUpdateExecution.java:100) [translator-object-8.12.8.6_3-redhat-1.jar:8.12.8.6_3-redhat-1] > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem$1.execute(ConnectorWorkItem.java:404) [teiid-engine-8.12.8.6_3-redhat-1.jar:8.12.8.6_3-redhat-1] > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:366) [teiid-engine-8.12.8.6_3-redhat-1.jar:8.12.8.6_3-redhat-1] > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0-internal] > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0-internal] > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0-internal] > at java.lang.reflect.Method.invoke(Method.java:483) [rt.jar:1.8.0-internal] > at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) [teiid-engine-8.12.8.6_3-redhat-1.jar:8.12.8.6_3-redhat-1] > at com.sun.proxy.$Proxy47.execute(Unknown Source) > at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306) [teiid-engine-8.12.8.6_3-redhat-1.jar:8.12.8.6_3-redhat-1] > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) [teiid-engine-8.12.8.6_3-redhat-1.jar:8.12.8.6_3-redhat-1] > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) [teiid-engine-8.12.8.6_3-redhat-1.jar:8.12.8.6_3-redhat-1] > at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0-internal] > at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) [teiid-engine-8.12.8.6_3-redhat-1.jar:8.12.8.6_3-redhat-1] > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280) [teiid-engine-8.12.8.6_3-redhat-1.jar:8.12.8.6_3-redhat-1] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.8.6_3-redhat-1.jar:8.12.8.6_3-redhat-1] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.8.6_3-redhat-1.jar:8.12.8.6_3-redhat-1] > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0-internal] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0-internal] > at java.lang.Thread.run(Thread.java:744) [rt.jar:1.8.0-internal] > {code} > Moreover, Teiid removes only one row (I will log this issue separately): > *Data in table before delete:* > |IntKey|StringKey|...| > |1|1|...| > |2|2|...| > *Data in table after delete:* > |IntKey|StringKey|...| > |2|2|...| -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues December 2016