April 2018 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3898) Add OrientDB translator

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3898?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3898: --------------------------------------- It can be left open in the Open To Community bucket. > Add OrientDB translator > ----------------------- > > Key: TEIID-3898 > URL: https://issues.jboss.org/browse/TEIID-3898 > Project: Teiid > Issue Type: Feature Request > Components: JDBC … [View More]

6 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5210) GitBook integration is broken

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5210?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5210. ----------------------------------- Resolution: Done Updated the references in existing docs and submitted a pr for the new community site. > GitBook integration is broken > ----------------------------- > > Key: TEIID-5210 > URL: https://issues.jboss.org/browse/TEIID-5210 > Project: Teiid > Issue … [View More]

6 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3898) Add OrientDB translator

by Rafal Korytkowski (JIRA)

[ https://issues.jboss.org/browse/TEIID-3898?page=com.atlassian.jira.plugin... ] Rafal Korytkowski commented on TEIID-3898: ------------------------------------------ Thanks [~don.krapohl]! [~shawkins], do you want to close the issue in such a case? > Add OrientDB translator > ----------------------- > > Key: TEIID-3898 > URL: https://issues.jboss.org/browse/TEIID-3898 > Project: Teiid > Issue Type: Feature Request &… [View More]

6 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5210) GitBook integration is broken

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5210?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5210: --------------------------------------- Now that there seems to be consensus on this approach, the remaining links to gitbook.io need to be updated. This needs to be completed for: * the legacy site * the new site * teiid quickstarts * teiid spring boot * the teiid readme * teiid embedded examples * wildfly swarm teiid example * teiid tools > GitBook integration is … [View More]

6 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5330) FIRST_VALUE/LAST_VALUE/LEAD/LAG functions always try to return integer

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-5330?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-5330: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1572224 Bugzilla Update: Perform > FIRST_VALUE/LAST_VALUE/LEAD/LAG functions always try to return integer > ---------------------------------------------------------------------- > > Key: TEIID-5330 > … [View More]URL: https://issues.jboss.org/browse/TEIID-5330 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.12.13.6_4 > Reporter: Jan Martiska > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 10.3, 10.1.4, 10.2.2 > > > The FIRST_VALUE/LAST_VALUE/LEAD/LAG functions always try to return integer, no matter what the type of the column is. > If integer can be cast to the target type, the query will successfully return, but the return type will be integer instead of the expected one. If integer cannot be cast to the requested type, the query will fail. > For example, when running this against a CSV source and a string column: > {noformat} > SELECT FIRST_VALUE(stringkey) OVER (ORDER BY stringkey) FROM BQT1.smallA > {noformat} > This fails with: > {noformat} > 14:54:49,328 ERROR [org.teiid.TRANSPORT] (New I/O worker #2) TEIID40113 Unhandled exception, aborting operation: org.teiid.transport.ObjectEncoder$FailedWriteException: org.teiid.core.TeiidRuntimeException: TEIID20001 The modeled datatype integer for column 0 doesn't match the runtime type "java.lang.String". Please ensure that the column's modeled datatype matches the expected data. > at org.teiid.transport.ObjectEncoder.handleDownstream(ObjectEncoder.java:136) [teiid-runtime-8.12.13.6_4-redhat-64-1.jar:8.12.13.6_4-redhat-64-1] > at org.jboss.netty.channel.Channels.write(Channels.java:704) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1] > at org.jboss.netty.channel.Channels.write(Channels.java:671) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1] > at org.jboss.netty.channel.AbstractChannel.write(AbstractChannel.java:248) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1] > at org.teiid.transport.SSLAwareChannelHandler$ObjectChannelImpl.write(SSLAwareChannelHandler.java:94) [teiid-runtime-8.12.13.6_4-redhat-64-1.jar:8.12.13.6_4-redhat-64-1] > at org.teiid.transport.SocketClientInstance.send(SocketClientInstance.java:94) [teiid-runtime-8.12.13.6_4-redhat-64-1.jar:8.12.13.6_4-redhat-64-1] > at org.teiid.transport.ServerWorkItem.sendResult(ServerWorkItem.java:135) [teiid-runtime-8.12.13.6_4-redhat-64-1.jar:8.12.13.6_4-redhat-64-1] > at org.teiid.transport.ServerWorkItem$1.onCompletion(ServerWorkItem.java:105) [teiid-runtime-8.12.13.6_4-redhat-64-1.jar:8.12.13.6_4-redhat-64-1] > at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:135) [teiid-client-8.12.13.6_4-redhat-64-1.jar:8.12.13.6_4-redhat-64-1] > at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:40) [teiid-client-8.12.13.6_4-redhat-64-1.jar:8.12.13.6_4-redhat-64-1] > at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:79) [teiid-client-8.12.13.6_4-redhat-64-1.jar:8.12.13.6_4-redhat-64-1] > at org.teiid.dqp.internal.process.RequestWorkItem.sendResultsIfNeeded(RequestWorkItem.java:996) [teiid-engine-8.12.13.6_4-redhat-64-1.jar:8.12.13.6_4-redhat-64-1] > at org.teiid.dqp.internal.process.RequestWorkItem$1.flushBatchDirect(RequestWorkItem.java:676) [teiid-engine-8.12.13.6_4-redhat-64-1.jar:8.12.13.6_4-redhat-64-1] > at org.teiid.query.processor.BatchCollector.flushBatch(BatchCollector.java:223) [teiid-engine-8.12.13.6_4-redhat-64-1.jar:8.12.13.6_4-redhat-64-1] > at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:194) [teiid-engine-8.12.13.6_4-redhat-64-1.jar:8.12.13.6_4-redhat-64-1] > at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.12.13.6_4-redhat-64-1.jar:8.12.13.6_4-redhat-64-1] > at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:472) [teiid-engine-8.12.13.6_4-redhat-64-1.jar:8.12.13.6_4-redhat-64-1] > at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:348) [teiid-engine-8.12.13.6_4-redhat-64-1.jar:8.12.13.6_4-redhat-64-1] > at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.12.13.6_4-redhat-64-1.jar:8.12.13.6_4-redhat-64-1] > at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274) [teiid-engine-8.12.13.6_4-redhat-64-1.jar:8.12.13.6_4-redhat-64-1] > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:284) [teiid-engine-8.12.13.6_4-redhat-64-1.jar:8.12.13.6_4-redhat-64-1] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.13.6_4-redhat-64-1.jar:8.12.13.6_4-redhat-64-1] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.13.6_4-redhat-64-1.jar:8.12.13.6_4-redhat-64-1] > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [rt.jar:1.8.0_151] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [rt.jar:1.8.0_151] > at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_151] > Caused by: org.teiid.core.TeiidRuntimeException: TEIID20001 The modeled datatype integer for column 0 doesn't match the runtime type "java.lang.String". Please ensure that the column's modeled datatype matches the expected data. > at org.teiid.client.BatchSerializer.writeBatch(BatchSerializer.java:878) [teiid-client-8.12.13.6_4-redhat-64-1.jar:8.12.13.6_4-redhat-64-1] > at org.teiid.client.ResultsMessage.writeExternal(ResultsMessage.java:319) [teiid-client-8.12.13.6_4-redhat-64-1.jar:8.12.13.6_4-redhat-64-1] > at java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1459) [rt.jar:1.8.0_151] > at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1430) [rt.jar:1.8.0_151] > at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1178) [rt.jar:1.8.0_151] > at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:348) [rt.jar:1.8.0_151] > at org.teiid.net.socket.Message.writeExternal(Message.java:61) [teiid-client-8.12.13.6_4-redhat-64-1.jar:8.12.13.6_4-redhat-64-1] > at java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1459) [rt.jar:1.8.0_151] > at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1430) [rt.jar:1.8.0_151] > at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1178) [rt.jar:1.8.0_151] > at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:348) [rt.jar:1.8.0_151] > at org.teiid.transport.ObjectEncoder.handleDownstream(ObjectEncoder.java:131) [teiid-runtime-8.12.13.6_4-redhat-64-1.jar:8.12.13.6_4-redhat-64-1] > ... 25 more > Caused by: java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Integer > at org.teiid.client.BatchSerializer$IntColumnSerializer.writeObject(BatchSerializer.java:563) [teiid-client-8.12.13.6_4-redhat-64-1.jar:8.12.13.6_4-redhat-64-1] > at org.teiid.client.BatchSerializer$ColumnSerializer.writeColumn(BatchSerializer.java:534) [teiid-client-8.12.13.6_4-redhat-64-1.jar:8.12.13.6_4-redhat-64-1] > at org.teiid.client.BatchSerializer.writeBatch(BatchSerializer.java:867) [teiid-client-8.12.13.6_4-redhat-64-1.jar:8.12.13.6_4-redhat-64-1] > ... 36 more > {noformat} -- This message was sent by Atlassian JIRA (v7.5.0#75005) [View Less]

6 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5331) LEAD/LAG ignores ORDER BY in the OVER clause

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5331?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5331. ----------------------------------- Fix Version/s: 10.3 10.1.4 10.2.2 Resolution: Done lead/lag were incorrectly implemented as row value functions (row_number), rather than normal window functions, which caused the logic to compute the wrong offset index for the lead/lag row. > LEAD/LAG ignores ORDER BY in the OVER clause &… [View More]gt; -------------------------------------------- > > Key: TEIID-5331 > URL: https://issues.jboss.org/browse/TEIID-5331 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.12.13.6_4 > Reporter: Andrej Šmigala > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 10.3, 10.1.4, 10.2.2 > > > Consider the following query: > {code:sql} > select charvalue, intkey, lead(intkey, 1, NULL) over (order by charvalue, intkey) from smalla order by intkey > {code} > This is expected to mean that the database orders the rows by charvalue, then intkey, then for each row finds the lead value in the ordered data set, _then_ sorts all the results by intkey. > Indeed, when run against e.g. postgres or oracle datasource, the results are as follows: > ||charvalue||intkey||lead|| > |1|0|2| > |0|1|3| > |1|2|4| > |0|3|5| > |1|4|6| > |...|...|...| > The results are also the same when running the query against teiid with e.g. postgres datasource, as the lead/lag is pushed down. > However, when run against teiid with datasource that does not support lead/lag pushdown (such as csv), the results are different: > ||charvalue||intkey||lead|| > |1|0|1| > |0|1|2| > |1|2|3| > |0|3|4| > |1|4|5| > |...|...|...| > I. e. it appears that the ORDER BY in the OVER clause is ignored and the LEAD/LAG uses the (possibly arbitrary) ordering returned from the datasource (which in this case is actually sorted by intkey, but we've seen random ordering from other datasources such as couchbase). > Please note that the same result comes from teiid even when removing either of the columns from the OVER (ORDER BY ...) clause, as well when removing the overall ORDER BY clause. > Processor plan for the above query: > {code} > OPTIMIZATION COMPLETE: > PROCESSOR PLAN: > ProjectNode(0) output=[A.CHARVALUE AS charvalue, A.INTKEY AS intkey, lead(A.INTKEY, 1, null) OVER (ORDER BY A.CHARVALUE, A.INTKEY)] [A.CHARVALUE AS charvalue, A.INTKEY AS intkey, lead(A.INTKEY, 1, null) OVER (ORDER BY A.CHARVALUE, A.INTKEY)] > WindowFunctionProjectNode(1) output=[lead(A.INTKEY, 1, null) OVER (ORDER BY A.CHARVALUE, A.INTKEY), A.CHARVALUE, A.INTKEY] > LimitNode(2) output=[A.CHARVALUE, A.INTKEY] limit 100 > SortNode(3) output=[A.CHARVALUE, A.INTKEY] [SORT] [A.INTKEY] > JoinNode(4) [NESTED TABLE JOIN] [CROSS JOIN] output=[A.CHARVALUE, A.INTKEY] > ProjectNode(5) output=[file] [sourceModel.getTextFiles.file] > AccessNode(6) output=[sourceModel.getTextFiles.file, sourceModel.getTextFiles.filePath] EXEC sourceModel.getTextFiles('smallaCsv.csv') > TextTableNode(7) output=[A.CHARVALUE, A.INTKEY] > {code} -- This message was sent by Atlassian JIRA (v7.5.0#75005) [View Less]

6 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5332) Change JDG translator/connector to package the jars and include in distro

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-5332?page=com.atlassian.jira.plugin... ] Work on TEIID-5332 started by Van Halbert. ------------------------------------------ > Change JDG translator/connector to package the jars and include in distro > ------------------------------------------------------------------------- > > Key: TEIID-5332 > URL: https://issues.jboss.org/browse/TEIID-5332 > Project: Teiid > Issue Type: … [View More]

6 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5332) Change JDG translator/connector to package the jars and include in distro

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-5332?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-5332: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1572204 Bugzilla Update: Perform > Change JDG translator/connector to package the jars and include in distro > ------------------------------------------------------------------------- > > Key: TEIID-5332 > … [View More]

6 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5332) Change JDG translator/connector to package the jars and include in distro

by Van Halbert (JIRA)

Van Halbert created TEIID-5332: ---------------------------------- Summary: Change JDG translator/connector to package the jars and include in distro Key: TEIID-5332 URL: https://issues.jboss.org/browse/TEIID-5332 Project: Teiid Issue Type: Enhancement Components: Infinispan Affects Versions: 8.12.12.6_4 Reporter: Van Halbert Assignee: Ramesh Reddy Priority: Blocker JDG … [View More]

6 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5332) Change JDG translator/connector to package the jars and include in distro

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-5332?page=com.atlassian.jira.plugin... ] Van Halbert reassigned TEIID-5332: ---------------------------------- Assignee: Van Halbert (was: Ramesh Reddy) > Change JDG translator/connector to package the jars and include in distro > ------------------------------------------------------------------------- > > Key: TEIID-5332 > URL: https://issues.jboss.org/browse/TEIID-5332 > Project: … [View More]

6 years, 11 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues April 2018