November 2017 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-5167) PrestoDB translator - NULL values are not allowed on the probe side of SemiJoin operator

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-5167?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-5167: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1515761|https://bugzilla.redhat.com/show_bug.cgi?id=1515761] from NEW to ASSIGNED > PrestoDB translator - NULL values are not allowed on the probe side of SemiJoin operator > ---------------------------------------------------------------------------------------- > > Key: TEIID-5167 > URL: https://issues.jboss.org/browse/TEIID-5167 > Project: Teiid > Issue Type: Bug > Components: JDBC Driver > Affects Versions: 8.12.x-6.4 > Reporter: Andrej Šmigala > Assignee: Steven Hawkins > > When running queries containg a subquery such as > {code:sql} > SELECT INTKEY, DOUBLENUM FROM BQT1.SMALLA WHERE DOUBLENUM <> ALL (SELECT DOUBLENUM FROM BQT1.SMALLA WHERE INTKEY = 40) > {code} > An exception is thrown: > {noformat} > org.teiid.translator.TranslatorException: Unexpected exception while translating results: Query failed (#20171121_103829_00016_8zhqn): NULL values are not allowed on the probe side of SemiJoin operator. See the query plan for details. > at org.teiid.translator.jdbc.JDBCQueryExecution.next(JDBCQueryExecution.java:351) [translator-jdbc-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7] > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:433) > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:236) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_141] > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_141] > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_141] > at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_141] > at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) > at com.sun.proxy.$Proxy80.more(Unknown Source) > at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:309) > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) > at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_141] > at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:284) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [rt.jar:1.8.0_141] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [rt.jar:1.8.0_141] > at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_141] > Caused by: java.sql.SQLException: Query failed (#20171121_103829_00016_8zhqn): NULL values are not allowed on the probe side of SemiJoin operator. See the query plan for details. > at com.facebook.presto.jdbc.PrestoResultSet.resultsException(PrestoResultSet.java:1799) > at com.facebook.presto.jdbc.PrestoResultSet$ResultsPageIterator.computeNext(PrestoResultSet.java:1787) > at com.facebook.presto.jdbc.PrestoResultSet$ResultsPageIterator.computeNext(PrestoResultSet.java:1756) > at com.facebook.presto.jdbc.internal.guava.collect.AbstractIterator.tryToComputeNext(AbstractIterator.java:145) > at com.facebook.presto.jdbc.internal.guava.collect.AbstractIterator.hasNext(AbstractIterator.java:140) > at com.facebook.presto.jdbc.internal.guava.collect.TransformedIterator.hasNext(TransformedIterator.java:42) > at com.facebook.presto.jdbc.internal.guava.collect.MultitransformedIterator.hasNext(MultitransformedIterator.java:50) > at com.facebook.presto.jdbc.internal.guava.collect.MultitransformedIterator.hasNext(MultitransformedIterator.java:50) > at com.facebook.presto.jdbc.PrestoResultSet.next(PrestoResultSet.java:149) > at org.jboss.jca.adapters.jdbc.WrappedResultSet.next(WrappedResultSet.java:1862) > at org.teiid.translator.jdbc.JDBCQueryExecution.next(JDBCQueryExecution.java:338) [translator-jdbc-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7] > ... 19 more > {noformat} > The query is translated as > {code:sql} > SELECT g_0.intkey AS c_0, g_0.doublenum AS c_1 FROM smalla AS g_0 WHERE g_0.doublenum NOT IN (SELECT g_1.doublenum FROM smalla AS g_1 WHERE g_1.intkey = 40) > {code} -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5160) Quickstarts undocumented projects and artifacts

by Jan Stastny (JIRA)

[ https://issues.jboss.org/browse/TEIID-5160?page=com.atlassian.jira.plugin... ] Jan Stastny commented on TEIID-5160: ------------------------------------ I will add restservice into the table as supported and both jdg-* quickstarts with note encouraging users to prefer jdg7-* quickstarts. > Quickstarts undocumented projects and artifacts > ----------------------------------------------- > > Key: TEIID-5160 > URL: https://issues.jboss.org/browse/TEIID-5160 > Project: Teiid > Issue Type: Bug > Components: Quick Starts > Affects Versions: 8.12.x-6.4 > Reporter: Jan Stastny > Assignee: Van Halbert > Priority: Blocker > > There are two undocumented projects: > JDG 6.x projects (still valid) > * jdg-remote-cache > * jdg-remote-cache-materialization > And in dynamicvdb-materialization there is undocumented vdb for internal materialization: > * portfolio-intermat-vdb.xml -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5166) Google spreadsheet insert fails

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-5166?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-5166: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1516455|https://bugzilla.redhat.com/show_bug.cgi?id=1516455] from NEW to MODIFIED > Google spreadsheet insert fails > ------------------------------- > > Key: TEIID-5166 > URL: https://issues.jboss.org/browse/TEIID-5166 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 10.0, 9.3.4, 9.2.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Critical > Fix For: 8.12.x-6.4, 9.3.5, 10.1, 10.0.1 > > > TEIID-4870 introduced a regression that causes an NPE when an insert is issued. The connection was changed to expect the sheet title to passed in, but the SpreadsheetUpdateExecution is passing the sheet key, which will likely not be found. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4315) HBase Quickstart issues

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4315?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4315: ------------------------------------------------ Jan Stastny <jstastny(a)redhat.com> changed the Status of [bug 1335004|https://bugzilla.redhat.com/show_bug.cgi?id=1335004] from ON_QA to VERIFIED > HBase Quickstart issues > ----------------------- > > Key: TEIID-4315 > URL: https://issues.jboss.org/browse/TEIID-4315 > Project: Teiid > Issue Type: Bug > Components: Quick Starts > Affects Versions: 9.x > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Minor > Fix For: 8.12.x-6.4, 9.3.1 > > > remove.cli script does not work. You need to remove items in revers order. You cannot remove driver if some data source is still using it. Please update remove.cli script: > From: > > module remove --name=org.apache.phoenix > > /subsystem=datasources/jdbc-driver=phoenix:remove() > > /subsystem=datasources/data-source=QSPhoenixDS:remove() > To: > > /subsystem=datasources/data-source=QSPhoenixDS:remove() > > /subsystem=datasources/jdbc-driver=phoenix:remove() > > module remove --name=org.apache.phoenix > ------- > As far as I know, option 'enabled=true' of 'add' operation for data-source is deprecated in CLI. Moreover, user needs to reload server to be able to use create data source. Please, update the script like follows: > From: > > /subsystem=datasources/data-source=QSPhoenixDS:add(jndi-name="java:/QSPhoenixDS",driver-name=phoenix,connection-url=jdbc:phoenix:127.0.0.1:2181,user-name=sa,password=sa,enabled=true,use-java-context=true) > To: > > /subsystem=datasources/data-source=QSPhoenixDS:add(jndi-name="java:/QSPhoenixDS",driver-name=phoenix,connection-url=jdbc:phoenix:127.0.0.1:2181,user-name=sa,password=sa,use-java-context=true) > > /subsystem=datasources/data-source=QSPhoenixDS:enable > ------ > Files: hbase-as-a-datasource/README.md, hbase-as-a-datasource/src/scripts/setup.cli > Line: 57 - 3) Setup Phoenix Data Source > 1 - --resources=phoenix-4.2.1-client.jar > Please add an instruction to update phoenix version in setup.cli script if user uses different version of phoenix/hbase. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5166) Google spreadsheet insert fails

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-5166?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-5166: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1516455 Bugzilla Update: Perform > Google spreadsheet insert fails > ------------------------------- > > Key: TEIID-5166 > URL: https://issues.jboss.org/browse/TEIID-5166 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 10.0, 9.3.4, 9.2.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Critical > Fix For: 8.12.x-6.4, 9.3.5, 10.1, 10.0.1 > > > TEIID-4870 introduced a regression that causes an NPE when an insert is issued. The connection was changed to expect the sheet title to passed in, but the SpreadsheetUpdateExecution is passing the sheet key, which will likely not be found. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5160) Quickstarts undocumented projects and artifacts

by Jan Stastny (JIRA)

[ https://issues.jboss.org/browse/TEIID-5160?page=com.atlassian.jira.plugin... ] Jan Stastny commented on TEIID-5160: ------------------------------------ plus there is 'dynamicvdb-restservice' missing in the readme. > Quickstarts undocumented projects and artifacts > ----------------------------------------------- > > Key: TEIID-5160 > URL: https://issues.jboss.org/browse/TEIID-5160 > Project: Teiid > Issue Type: Bug > Components: Quick Starts > Affects Versions: 8.12.x-6.4 > Reporter: Jan Stastny > Assignee: Van Halbert > Priority: Blocker > > There are two undocumented projects: > JDG 6.x projects (still valid) > * jdg-remote-cache > * jdg-remote-cache-materialization > And in dynamicvdb-materialization there is undocumented vdb for internal materialization: > * portfolio-intermat-vdb.xml -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5169) Quickstart dynamicvdb-restservice cli script error

by Jan Stastny (JIRA)

Jan Stastny created TEIID-5169: ---------------------------------- Summary: Quickstart dynamicvdb-restservice cli script error Key: TEIID-5169 URL: https://issues.jboss.org/browse/TEIID-5169 Project: Teiid Issue Type: Bug Components: Quick Starts Affects Versions: 8.12.x-6.4 Reporter: Jan Stastny Assignee: Van Halbert Priority: Critical The cli script dynamicvdb-restservice/src/scripts/deploy_vdb.cli contains {code} deploy ../quickstarts/dynamicvdb-materializaton/src/vdb/portfolio-rest-vdb.xml {code} it should point at dynamicvdb-restservice quickstart instead. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4290) Rollback to savepoint should be a no op

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4290?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4290: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1516418 Bugzilla Update: Perform > Rollback to savepoint should be a no op > --------------------------------------- > > Key: TEIID-4290 > URL: https://issues.jboss.org/browse/TEIID-4290 > Project: Teiid > Issue Type: Bug > Components: ODBC > Affects Versions: 8.4 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1, 8.13.6, 9.0.1, 8.12.x-6.4 > > > Save points are not supported and the creation of a save point by an ODBC client is effectively ignored, but the rollback is treated as a full rollback of the transaction. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4290) Rollback to savepoint should be a no op

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4290?page=com.atlassian.jira.plugin... ] Steven Hawkins reopened TEIID-4290: ----------------------------------- > Rollback to savepoint should be a no op > --------------------------------------- > > Key: TEIID-4290 > URL: https://issues.jboss.org/browse/TEIID-4290 > Project: Teiid > Issue Type: Bug > Components: ODBC > Affects Versions: 8.4 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1, 8.13.6, 9.0.1, 8.12.x-6.4 > > > Save points are not supported and the creation of a save point by an ODBC client is effectively ignored, but the rollback is treated as a full rollback of the transaction. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4290) Rollback to savepoint should be a no op

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4290?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4290: ---------------------------------- Fix Version/s: 8.12.x-6.4 > Rollback to savepoint should be a no op > --------------------------------------- > > Key: TEIID-4290 > URL: https://issues.jboss.org/browse/TEIID-4290 > Project: Teiid > Issue Type: Bug > Components: ODBC > Affects Versions: 8.4 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1, 8.13.6, 9.0.1, 8.12.x-6.4 > > > Save points are not supported and the creation of a save point by an ODBC client is effectively ignored, but the rollback is treated as a full rollback of the transaction. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 3 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues November 2017