[JBoss JIRA] (TEIID-3960) Otherwise evaluatable constructs will inhibit pushdown
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3960?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-3960:
----------------------------------
Fix Version/s: 8.7.3.6_2
9.0
8.12.5
8.13.1
> Otherwise evaluatable constructs will inhibit pushdown
> ------------------------------------------------------
>
> Key: TEIID-3960
> URL: https://issues.jboss.org/browse/TEIID-3960
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.7.2.6_2
> Reporter: Johnathon Lee
> Assignee: Steven Hawkins
> Fix For: 9.0, 8.12.5, 8.13.1, 8.7.3.6_2
>
>
> TEIID-1522 introduced a corner case regression such that a constant projection was inlined (removing the need for a fake dependent join), but the resulting expressions were not seen as able to be pushded due to a curdate function preventing the pre-evaluation of non-pushable constructs.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 1 month
[JBoss JIRA] (TEIID-3958) NPE Executing Against Web Service Source using invokeHttp() procedure without stream parameter
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-3958?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration updated TEIID-3958:
-------------------------------------------
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1305902
Bugzilla Update: Perform
> NPE Executing Against Web Service Source using invokeHttp() procedure without stream parameter
> ----------------------------------------------------------------------------------------------
>
> Key: TEIID-3958
> URL: https://issues.jboss.org/browse/TEIID-3958
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.7.1, 8.7.1.6_2
> Environment: Migrated web services model from EDS 5.3.1 that does not include 'stream' parameter in the invokeHttp() procedure
> DV 6.1 - translator-ws-8.7.1.redhat-8.jar
> DV 6.2 - translator-ws-8.7.1.6_2-redhat-6.jar
> Reporter: Marc Shirley
> Assignee: Steven Hawkins
>
> Appears to still be an issue similar to TEIID 2537. Executing against the invokeHttp() procedure generated by JBDS 5 for Teiid Designer 7.7.3 without a stream parameter results in a slightly different stack trace, but appears to be the same issue.
> 2016-01-21 12:53:50,297 ERROR \[org.teiid.PROCESSOR\] (Worker22_QueryProcessorQueue117472) TEIID30019 Unexpected exception for request FzkQneotrSUs.5: java.lang.NullPointerException
> at org.teiid.translator.ws.BinaryWSProcedureExecution.getOutputParameterValues(BinaryWSProcedureExecution.java:174)
> at org.teiid.dqp.internal.datamgr.ProcedureBatchHandler.getParameterRow(ProcedureBatchHandler.java:86) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:435) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:207) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:301) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
> at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_65]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.2.6_2-redhat-1.jar:8.7.2.6_2-redhat-1]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_65]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_65]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_65]
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 1 month
[JBoss JIRA] (TEIID-3953) .TeiidRuntimeException: TEIID20001 The modeled datatype string for column 1 doesn't match the runtime type "java.math.BigDecimal".
by Lukas Mro (JIRA)
[ https://issues.jboss.org/browse/TEIID-3953?page=com.atlassian.jira.plugin... ]
Lukas Mro commented on TEIID-3953:
----------------------------------
Thanks a lot for fast response.
I will check it but i have to update Teiid to 8.12.5 which i can do after teiidesigner 9.3 will be release :)
Thanks a lot
> .TeiidRuntimeException: TEIID20001 The modeled datatype string for column 1 doesn't match the runtime type "java.math.BigDecimal".
> ----------------------------------------------------------------------------------------------------------------------------------
>
> Key: TEIID-3953
> URL: https://issues.jboss.org/browse/TEIID-3953
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.9, 8.11.4
> Environment: Windows server 2012 R2
> Reporter: Lukas Mro
> Assignee: Steven Hawkins
> Priority: Blocker
> Fix For: 9.0, 8.12.5, 8.13.1
>
>
> 13:18:51,809 INFO [org.teiid.CONNECTOR] (Worker19_QueryProcessorQueue264) EWgzC7sVHcNy SimpleJDBCExecutionFactory Commit=true;DatabaseProductName=Firebird 2.5.WI;DatabaseProductVersion=WI-V2.5.3.26780;DriverMajorVersion=2;DriverMajorVersion=2;DriverName=Jaybird JCA/JDBC driver;DriverVersion=2.2;IsolationLevel=2
> 13:18:51,855 ERROR [org.teiid.TRANSPORT] (New I/O worker #4) null TEIID40113 Unhandled exception, aborting operation: org.teiid.transport.ObjectEncoder$FailedWriteException: org.teiid.core.TeiidRuntimeException: TEIID20001 The modeled datatype string for column 1 doesn't match the runtime type "java.math.BigDecimal". Please ensure that the column's modeled datatype matches the expected data.
> at org.teiid.transport.ObjectEncoder.handleDownstream(ObjectEncoder.java:136) [teiid-runtime-8.11.4.jar:8.11.4]
> 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:93) [teiid-runtime-8.11.4.jar:8.11.4]
> at org.teiid.transport.SocketClientInstance.send(SocketClientInstance.java:88) [teiid-runtime-8.11.4.jar:8.11.4]
> at org.teiid.transport.ServerWorkItem.sendResult(ServerWorkItem.java:135) [teiid-runtime-8.11.4.jar:8.11.4]
> at org.teiid.transport.ServerWorkItem$1.onCompletion(ServerWorkItem.java:105) [teiid-runtime-8.11.4.jar:8.11.4]
> at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:135) [teiid-client-8.11.4.jar:8.11.4]
> at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:40) [teiid-client-8.11.4.jar:8.11.4]
> at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:79) [teiid-client-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.RequestWorkItem.sendResultsIfNeeded(RequestWorkItem.java:980) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.RequestWorkItem$1.flushBatchDirect(RequestWorkItem.java:662) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.query.processor.BatchCollector.flushBatch(BatchCollector.java:223) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:194) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:457) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:339) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:267) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.11.4.jar:8.11.4]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_75]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_75]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_75]
> Caused by: org.teiid.core.TeiidRuntimeException: TEIID20001 The modeled datatype string for column 1 doesn't match the runtime type "java.math.BigDecimal". Please ensure that the column's modeled datatype matches the expected data.
> at org.teiid.client.BatchSerializer.writeBatch(BatchSerializer.java:878) [teiid-client-8.11.4.jar:8.11.4]
> at org.teiid.client.ResultsMessage.writeExternal(ResultsMessage.java:319) [teiid-client-8.11.4.jar:8.11.4]
> at java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1458) [rt.jar:1.7.0_75]
> at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1429) [rt.jar:1.7.0_75]
> at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1177) [rt.jar:1.7.0_75]
> at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:347) [rt.jar:1.7.0_75]
> at org.teiid.net.socket.Message.writeExternal(Message.java:61) [teiid-client-8.11.4.jar:8.11.4]
> at java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1458) [rt.jar:1.7.0_75]
> at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1429) [rt.jar:1.7.0_75]
> at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1177) [rt.jar:1.7.0_75]
> at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:347) [rt.jar:1.7.0_75]
> at org.teiid.transport.ObjectEncoder.handleDownstream(ObjectEncoder.java:131) [teiid-runtime-8.11.4.jar:8.11.4]
> ... 25 more
> Caused by: java.lang.ClassCastException: java.math.BigDecimal cannot be cast to java.lang.String
> at org.teiid.client.BatchSerializer$StringColumnSerializer3.writeObject(BatchSerializer.java:348) [teiid-client-8.11.4.jar:8.11.4]
> at org.teiid.client.BatchSerializer$ColumnSerializer.writeColumn(BatchSerializer.java:534) [teiid-client-8.11.4.jar:8.11.4]
> at org.teiid.client.BatchSerializer.writeBatch(BatchSerializer.java:867) [teiid-client-8.11.4.jar:8.11.4]
> ... 36 more
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 1 month
[JBoss JIRA] (TEIID-3953) .TeiidRuntimeException: TEIID20001 The modeled datatype string for column 1 doesn't match the runtime type "java.math.BigDecimal".
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3953?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-3953.
-----------------------------------
Resolution: Done
Corrected the dup remove push to use the proper child as the new root.
> .TeiidRuntimeException: TEIID20001 The modeled datatype string for column 1 doesn't match the runtime type "java.math.BigDecimal".
> ----------------------------------------------------------------------------------------------------------------------------------
>
> Key: TEIID-3953
> URL: https://issues.jboss.org/browse/TEIID-3953
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.9, 8.11.4
> Environment: Windows server 2012 R2
> Reporter: Lukas Mro
> Assignee: Steven Hawkins
> Priority: Blocker
> Fix For: 9.0, 8.12.5, 8.13.1
>
>
> 13:18:51,809 INFO [org.teiid.CONNECTOR] (Worker19_QueryProcessorQueue264) EWgzC7sVHcNy SimpleJDBCExecutionFactory Commit=true;DatabaseProductName=Firebird 2.5.WI;DatabaseProductVersion=WI-V2.5.3.26780;DriverMajorVersion=2;DriverMajorVersion=2;DriverName=Jaybird JCA/JDBC driver;DriverVersion=2.2;IsolationLevel=2
> 13:18:51,855 ERROR [org.teiid.TRANSPORT] (New I/O worker #4) null TEIID40113 Unhandled exception, aborting operation: org.teiid.transport.ObjectEncoder$FailedWriteException: org.teiid.core.TeiidRuntimeException: TEIID20001 The modeled datatype string for column 1 doesn't match the runtime type "java.math.BigDecimal". Please ensure that the column's modeled datatype matches the expected data.
> at org.teiid.transport.ObjectEncoder.handleDownstream(ObjectEncoder.java:136) [teiid-runtime-8.11.4.jar:8.11.4]
> 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:93) [teiid-runtime-8.11.4.jar:8.11.4]
> at org.teiid.transport.SocketClientInstance.send(SocketClientInstance.java:88) [teiid-runtime-8.11.4.jar:8.11.4]
> at org.teiid.transport.ServerWorkItem.sendResult(ServerWorkItem.java:135) [teiid-runtime-8.11.4.jar:8.11.4]
> at org.teiid.transport.ServerWorkItem$1.onCompletion(ServerWorkItem.java:105) [teiid-runtime-8.11.4.jar:8.11.4]
> at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:135) [teiid-client-8.11.4.jar:8.11.4]
> at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:40) [teiid-client-8.11.4.jar:8.11.4]
> at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:79) [teiid-client-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.RequestWorkItem.sendResultsIfNeeded(RequestWorkItem.java:980) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.RequestWorkItem$1.flushBatchDirect(RequestWorkItem.java:662) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.query.processor.BatchCollector.flushBatch(BatchCollector.java:223) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:194) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:457) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:339) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:267) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.11.4.jar:8.11.4]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_75]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_75]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_75]
> Caused by: org.teiid.core.TeiidRuntimeException: TEIID20001 The modeled datatype string for column 1 doesn't match the runtime type "java.math.BigDecimal". Please ensure that the column's modeled datatype matches the expected data.
> at org.teiid.client.BatchSerializer.writeBatch(BatchSerializer.java:878) [teiid-client-8.11.4.jar:8.11.4]
> at org.teiid.client.ResultsMessage.writeExternal(ResultsMessage.java:319) [teiid-client-8.11.4.jar:8.11.4]
> at java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1458) [rt.jar:1.7.0_75]
> at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1429) [rt.jar:1.7.0_75]
> at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1177) [rt.jar:1.7.0_75]
> at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:347) [rt.jar:1.7.0_75]
> at org.teiid.net.socket.Message.writeExternal(Message.java:61) [teiid-client-8.11.4.jar:8.11.4]
> at java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1458) [rt.jar:1.7.0_75]
> at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1429) [rt.jar:1.7.0_75]
> at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1177) [rt.jar:1.7.0_75]
> at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:347) [rt.jar:1.7.0_75]
> at org.teiid.transport.ObjectEncoder.handleDownstream(ObjectEncoder.java:131) [teiid-runtime-8.11.4.jar:8.11.4]
> ... 25 more
> Caused by: java.lang.ClassCastException: java.math.BigDecimal cannot be cast to java.lang.String
> at org.teiid.client.BatchSerializer$StringColumnSerializer3.writeObject(BatchSerializer.java:348) [teiid-client-8.11.4.jar:8.11.4]
> at org.teiid.client.BatchSerializer$ColumnSerializer.writeColumn(BatchSerializer.java:534) [teiid-client-8.11.4.jar:8.11.4]
> at org.teiid.client.BatchSerializer.writeBatch(BatchSerializer.java:867) [teiid-client-8.11.4.jar:8.11.4]
> ... 36 more
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 1 month
[JBoss JIRA] (TEIID-3953) .TeiidRuntimeException: TEIID20001 The modeled datatype string for column 1 doesn't match the runtime type "java.math.BigDecimal".
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3953?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-3953:
----------------------------------
Fix Version/s: 8.12.5
> .TeiidRuntimeException: TEIID20001 The modeled datatype string for column 1 doesn't match the runtime type "java.math.BigDecimal".
> ----------------------------------------------------------------------------------------------------------------------------------
>
> Key: TEIID-3953
> URL: https://issues.jboss.org/browse/TEIID-3953
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.9, 8.11.4
> Environment: Windows server 2012 R2
> Reporter: Lukas Mro
> Assignee: Steven Hawkins
> Priority: Blocker
> Fix For: 9.0, 8.12.5, 8.13.1
>
>
> 13:18:51,809 INFO [org.teiid.CONNECTOR] (Worker19_QueryProcessorQueue264) EWgzC7sVHcNy SimpleJDBCExecutionFactory Commit=true;DatabaseProductName=Firebird 2.5.WI;DatabaseProductVersion=WI-V2.5.3.26780;DriverMajorVersion=2;DriverMajorVersion=2;DriverName=Jaybird JCA/JDBC driver;DriverVersion=2.2;IsolationLevel=2
> 13:18:51,855 ERROR [org.teiid.TRANSPORT] (New I/O worker #4) null TEIID40113 Unhandled exception, aborting operation: org.teiid.transport.ObjectEncoder$FailedWriteException: org.teiid.core.TeiidRuntimeException: TEIID20001 The modeled datatype string for column 1 doesn't match the runtime type "java.math.BigDecimal". Please ensure that the column's modeled datatype matches the expected data.
> at org.teiid.transport.ObjectEncoder.handleDownstream(ObjectEncoder.java:136) [teiid-runtime-8.11.4.jar:8.11.4]
> 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:93) [teiid-runtime-8.11.4.jar:8.11.4]
> at org.teiid.transport.SocketClientInstance.send(SocketClientInstance.java:88) [teiid-runtime-8.11.4.jar:8.11.4]
> at org.teiid.transport.ServerWorkItem.sendResult(ServerWorkItem.java:135) [teiid-runtime-8.11.4.jar:8.11.4]
> at org.teiid.transport.ServerWorkItem$1.onCompletion(ServerWorkItem.java:105) [teiid-runtime-8.11.4.jar:8.11.4]
> at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:135) [teiid-client-8.11.4.jar:8.11.4]
> at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:40) [teiid-client-8.11.4.jar:8.11.4]
> at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:79) [teiid-client-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.RequestWorkItem.sendResultsIfNeeded(RequestWorkItem.java:980) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.RequestWorkItem$1.flushBatchDirect(RequestWorkItem.java:662) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.query.processor.BatchCollector.flushBatch(BatchCollector.java:223) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:194) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:457) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:339) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:267) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.11.4.jar:8.11.4]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_75]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_75]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_75]
> Caused by: org.teiid.core.TeiidRuntimeException: TEIID20001 The modeled datatype string for column 1 doesn't match the runtime type "java.math.BigDecimal". Please ensure that the column's modeled datatype matches the expected data.
> at org.teiid.client.BatchSerializer.writeBatch(BatchSerializer.java:878) [teiid-client-8.11.4.jar:8.11.4]
> at org.teiid.client.ResultsMessage.writeExternal(ResultsMessage.java:319) [teiid-client-8.11.4.jar:8.11.4]
> at java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1458) [rt.jar:1.7.0_75]
> at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1429) [rt.jar:1.7.0_75]
> at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1177) [rt.jar:1.7.0_75]
> at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:347) [rt.jar:1.7.0_75]
> at org.teiid.net.socket.Message.writeExternal(Message.java:61) [teiid-client-8.11.4.jar:8.11.4]
> at java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1458) [rt.jar:1.7.0_75]
> at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1429) [rt.jar:1.7.0_75]
> at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1177) [rt.jar:1.7.0_75]
> at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:347) [rt.jar:1.7.0_75]
> at org.teiid.transport.ObjectEncoder.handleDownstream(ObjectEncoder.java:131) [teiid-runtime-8.11.4.jar:8.11.4]
> ... 25 more
> Caused by: java.lang.ClassCastException: java.math.BigDecimal cannot be cast to java.lang.String
> at org.teiid.client.BatchSerializer$StringColumnSerializer3.writeObject(BatchSerializer.java:348) [teiid-client-8.11.4.jar:8.11.4]
> at org.teiid.client.BatchSerializer$ColumnSerializer.writeColumn(BatchSerializer.java:534) [teiid-client-8.11.4.jar:8.11.4]
> at org.teiid.client.BatchSerializer.writeBatch(BatchSerializer.java:867) [teiid-client-8.11.4.jar:8.11.4]
> ... 36 more
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 1 month
[JBoss JIRA] (TEIID-3953) .TeiidRuntimeException: TEIID20001 The modeled datatype string for column 1 doesn't match the runtime type "java.math.BigDecimal".
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3953?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-3953:
----------------------------------
Component/s: Query Engine
Fix Version/s: 9.0
8.13.1
Priority: Blocker (was: Major)
Affects Version/s: 8.9
> .TeiidRuntimeException: TEIID20001 The modeled datatype string for column 1 doesn't match the runtime type "java.math.BigDecimal".
> ----------------------------------------------------------------------------------------------------------------------------------
>
> Key: TEIID-3953
> URL: https://issues.jboss.org/browse/TEIID-3953
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.9, 8.11.4
> Environment: Windows server 2012 R2
> Reporter: Lukas Mro
> Assignee: Steven Hawkins
> Priority: Blocker
> Fix For: 9.0, 8.13.1
>
>
> 13:18:51,809 INFO [org.teiid.CONNECTOR] (Worker19_QueryProcessorQueue264) EWgzC7sVHcNy SimpleJDBCExecutionFactory Commit=true;DatabaseProductName=Firebird 2.5.WI;DatabaseProductVersion=WI-V2.5.3.26780;DriverMajorVersion=2;DriverMajorVersion=2;DriverName=Jaybird JCA/JDBC driver;DriverVersion=2.2;IsolationLevel=2
> 13:18:51,855 ERROR [org.teiid.TRANSPORT] (New I/O worker #4) null TEIID40113 Unhandled exception, aborting operation: org.teiid.transport.ObjectEncoder$FailedWriteException: org.teiid.core.TeiidRuntimeException: TEIID20001 The modeled datatype string for column 1 doesn't match the runtime type "java.math.BigDecimal". Please ensure that the column's modeled datatype matches the expected data.
> at org.teiid.transport.ObjectEncoder.handleDownstream(ObjectEncoder.java:136) [teiid-runtime-8.11.4.jar:8.11.4]
> 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:93) [teiid-runtime-8.11.4.jar:8.11.4]
> at org.teiid.transport.SocketClientInstance.send(SocketClientInstance.java:88) [teiid-runtime-8.11.4.jar:8.11.4]
> at org.teiid.transport.ServerWorkItem.sendResult(ServerWorkItem.java:135) [teiid-runtime-8.11.4.jar:8.11.4]
> at org.teiid.transport.ServerWorkItem$1.onCompletion(ServerWorkItem.java:105) [teiid-runtime-8.11.4.jar:8.11.4]
> at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:135) [teiid-client-8.11.4.jar:8.11.4]
> at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:40) [teiid-client-8.11.4.jar:8.11.4]
> at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:79) [teiid-client-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.RequestWorkItem.sendResultsIfNeeded(RequestWorkItem.java:980) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.RequestWorkItem$1.flushBatchDirect(RequestWorkItem.java:662) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.query.processor.BatchCollector.flushBatch(BatchCollector.java:223) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:194) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:457) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:339) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:267) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.11.4.jar:8.11.4]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_75]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_75]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_75]
> Caused by: org.teiid.core.TeiidRuntimeException: TEIID20001 The modeled datatype string for column 1 doesn't match the runtime type "java.math.BigDecimal". Please ensure that the column's modeled datatype matches the expected data.
> at org.teiid.client.BatchSerializer.writeBatch(BatchSerializer.java:878) [teiid-client-8.11.4.jar:8.11.4]
> at org.teiid.client.ResultsMessage.writeExternal(ResultsMessage.java:319) [teiid-client-8.11.4.jar:8.11.4]
> at java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1458) [rt.jar:1.7.0_75]
> at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1429) [rt.jar:1.7.0_75]
> at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1177) [rt.jar:1.7.0_75]
> at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:347) [rt.jar:1.7.0_75]
> at org.teiid.net.socket.Message.writeExternal(Message.java:61) [teiid-client-8.11.4.jar:8.11.4]
> at java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1458) [rt.jar:1.7.0_75]
> at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1429) [rt.jar:1.7.0_75]
> at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1177) [rt.jar:1.7.0_75]
> at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:347) [rt.jar:1.7.0_75]
> at org.teiid.transport.ObjectEncoder.handleDownstream(ObjectEncoder.java:131) [teiid-runtime-8.11.4.jar:8.11.4]
> ... 25 more
> Caused by: java.lang.ClassCastException: java.math.BigDecimal cannot be cast to java.lang.String
> at org.teiid.client.BatchSerializer$StringColumnSerializer3.writeObject(BatchSerializer.java:348) [teiid-client-8.11.4.jar:8.11.4]
> at org.teiid.client.BatchSerializer$ColumnSerializer.writeColumn(BatchSerializer.java:534) [teiid-client-8.11.4.jar:8.11.4]
> at org.teiid.client.BatchSerializer.writeBatch(BatchSerializer.java:867) [teiid-client-8.11.4.jar:8.11.4]
> ... 36 more
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 1 month
[JBoss JIRA] (TEIID-3953) .TeiidRuntimeException: TEIID20001 The modeled datatype string for column 1 doesn't match the runtime type "java.math.BigDecimal".
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3953?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3953:
---------------------------------------
This looks like a regression with TEIID-3063 - it's a narrow optimization to push a higher level dup removal, but it's not appropriately preserving the projected/output symbols. That results in a plan that delivers a smaller number of columns than is expected. This will be addressed for 9.0 alpha1 and 8.13.1.
> .TeiidRuntimeException: TEIID20001 The modeled datatype string for column 1 doesn't match the runtime type "java.math.BigDecimal".
> ----------------------------------------------------------------------------------------------------------------------------------
>
> Key: TEIID-3953
> URL: https://issues.jboss.org/browse/TEIID-3953
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.11.4
> Environment: Windows server 2012 R2
> Reporter: Lukas Mro
> Assignee: Steven Hawkins
>
> 13:18:51,809 INFO [org.teiid.CONNECTOR] (Worker19_QueryProcessorQueue264) EWgzC7sVHcNy SimpleJDBCExecutionFactory Commit=true;DatabaseProductName=Firebird 2.5.WI;DatabaseProductVersion=WI-V2.5.3.26780;DriverMajorVersion=2;DriverMajorVersion=2;DriverName=Jaybird JCA/JDBC driver;DriverVersion=2.2;IsolationLevel=2
> 13:18:51,855 ERROR [org.teiid.TRANSPORT] (New I/O worker #4) null TEIID40113 Unhandled exception, aborting operation: org.teiid.transport.ObjectEncoder$FailedWriteException: org.teiid.core.TeiidRuntimeException: TEIID20001 The modeled datatype string for column 1 doesn't match the runtime type "java.math.BigDecimal". Please ensure that the column's modeled datatype matches the expected data.
> at org.teiid.transport.ObjectEncoder.handleDownstream(ObjectEncoder.java:136) [teiid-runtime-8.11.4.jar:8.11.4]
> 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:93) [teiid-runtime-8.11.4.jar:8.11.4]
> at org.teiid.transport.SocketClientInstance.send(SocketClientInstance.java:88) [teiid-runtime-8.11.4.jar:8.11.4]
> at org.teiid.transport.ServerWorkItem.sendResult(ServerWorkItem.java:135) [teiid-runtime-8.11.4.jar:8.11.4]
> at org.teiid.transport.ServerWorkItem$1.onCompletion(ServerWorkItem.java:105) [teiid-runtime-8.11.4.jar:8.11.4]
> at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:135) [teiid-client-8.11.4.jar:8.11.4]
> at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:40) [teiid-client-8.11.4.jar:8.11.4]
> at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:79) [teiid-client-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.RequestWorkItem.sendResultsIfNeeded(RequestWorkItem.java:980) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.RequestWorkItem$1.flushBatchDirect(RequestWorkItem.java:662) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.query.processor.BatchCollector.flushBatch(BatchCollector.java:223) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:194) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:457) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:339) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:267) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.11.4.jar:8.11.4]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.11.4.jar:8.11.4]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_75]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_75]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_75]
> Caused by: org.teiid.core.TeiidRuntimeException: TEIID20001 The modeled datatype string for column 1 doesn't match the runtime type "java.math.BigDecimal". Please ensure that the column's modeled datatype matches the expected data.
> at org.teiid.client.BatchSerializer.writeBatch(BatchSerializer.java:878) [teiid-client-8.11.4.jar:8.11.4]
> at org.teiid.client.ResultsMessage.writeExternal(ResultsMessage.java:319) [teiid-client-8.11.4.jar:8.11.4]
> at java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1458) [rt.jar:1.7.0_75]
> at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1429) [rt.jar:1.7.0_75]
> at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1177) [rt.jar:1.7.0_75]
> at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:347) [rt.jar:1.7.0_75]
> at org.teiid.net.socket.Message.writeExternal(Message.java:61) [teiid-client-8.11.4.jar:8.11.4]
> at java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1458) [rt.jar:1.7.0_75]
> at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1429) [rt.jar:1.7.0_75]
> at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1177) [rt.jar:1.7.0_75]
> at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:347) [rt.jar:1.7.0_75]
> at org.teiid.transport.ObjectEncoder.handleDownstream(ObjectEncoder.java:131) [teiid-runtime-8.11.4.jar:8.11.4]
> ... 25 more
> Caused by: java.lang.ClassCastException: java.math.BigDecimal cannot be cast to java.lang.String
> at org.teiid.client.BatchSerializer$StringColumnSerializer3.writeObject(BatchSerializer.java:348) [teiid-client-8.11.4.jar:8.11.4]
> at org.teiid.client.BatchSerializer$ColumnSerializer.writeColumn(BatchSerializer.java:534) [teiid-client-8.11.4.jar:8.11.4]
> at org.teiid.client.BatchSerializer.writeBatch(BatchSerializer.java:867) [teiid-client-8.11.4.jar:8.11.4]
> ... 36 more
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 1 month
[JBoss JIRA] (TEIID-3957) Impala translator - Add pushdown of offset in LIMIT clause to overcome difference in LIMIT clause
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3957?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-3957.
-----------------------------------
Resolution: Done
Added support for pushdown - if no order by is specified, then we'll add a dummy order by 1.
> Impala translator - Add pushdown of offset in LIMIT clause to overcome difference in LIMIT clause
> -------------------------------------------------------------------------------------------------
>
> Key: TEIID-3957
> URL: https://issues.jboss.org/browse/TEIID-3957
> Project: Teiid
> Issue Type: Enhancement
> Components: JDBC Connector
> Affects Versions: 8.12.4
> Environment: Ubuntu Trusty
> Reporter: Don Krapohl
> Assignee: Steven Hawkins
> Priority: Minor
> Fix For: 9.0
>
>
> With the impala translator we issue this LIMIT to Teiid:
> ORDER BY somecolumn DESC LIMIT 75, 25
> this means give me 25 rows starting from *ROW* 76.
> In Impala's SQL this should be translated to:
> ORDER BY somecolumn DESC LIMIT 25 OFFSET 75
> BUT this means give me 25 rows starting from *PAGE * 76 (with page size of 25 rows)
> ref: http://www.cloudera.com/documentation/archive/impala/2-x/2-1-x/topics/imp...
> The Teiid Impala translator doesn't push the offset but sums the limit and offset:
> ORDER BY somecolumn DESC LIMIT 100
> Request we add pushdown, which will be more efficient and overcome the difference in how offsets are handled between Impala and Teiid.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 1 month
[JBoss JIRA] (TEIID-3960) Otherwise evaluatable constructs will inhibit pushdown
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3960?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-3960.
-----------------------------------
Resolution: Done
Updated the capabilities check to more broadly consider evaluatibility.
> Otherwise evaluatable constructs will inhibit pushdown
> ------------------------------------------------------
>
> Key: TEIID-3960
> URL: https://issues.jboss.org/browse/TEIID-3960
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.7.2.6_2
> Reporter: Johnathon Lee
> Assignee: Steven Hawkins
>
> TEIID-1522 introduced a corner case regression such that a constant projection was inlined (removing the need for a fake dependent join), but the resulting expressions were not seen as able to be pushded due to a curdate function preventing the pre-evaluation of non-pushable constructs.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 1 month
[JBoss JIRA] (TEIID-3960) Otherwise evaluatable constructs will inhibit pushdown
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3960?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-3960:
----------------------------------
Description: TEIID-1522 introduced a corner case regression such that a constant projection was inlined (removing the need for a fake dependent join), but the resulting expressions were not seen as able to be pushded due to a curdate function preventing the pre-evaluation of non-pushable constructs. (was: TEIID-1522 introduced a corner case regression around dependent join planning.)
Summary: Otherwise evaluatable constructs will inhibit pushdown (was: corner case regression introduced by TEIID-1522)
> Otherwise evaluatable constructs will inhibit pushdown
> ------------------------------------------------------
>
> Key: TEIID-3960
> URL: https://issues.jboss.org/browse/TEIID-3960
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.7.2.6_2
> Reporter: Johnathon Lee
> Assignee: Steven Hawkins
>
> TEIID-1522 introduced a corner case regression such that a constant projection was inlined (removing the need for a fake dependent join), but the resulting expressions were not seen as able to be pushded due to a curdate function preventing the pre-evaluation of non-pushable constructs.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 1 month