[JBoss JIRA] (TEIID-3990) Issues with nested correlated references
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3990?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-3990:
----------------------------------
Fix Version/s: (was: 8.12.6.6_3)
> Issues with nested correlated references
> ----------------------------------------
>
> Key: TEIID-3990
> URL: https://issues.jboss.org/browse/TEIID-3990
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.4
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 9.0, 8.12.5, 8.13.2
>
>
> There are several issues with nested correlated reference handling generally around having the same table name/alias in several levels of the query. For example with a having c1, c2 columns, b having c3, c4, and c having c5, c6:
> SELECT (select c2 from b where c3 = (select c5 from c as x where c6 = c1)) FROM a as x group by c1, c2
> Results in an exception since the inner most reference to c1 is seen as actually resolving to c as x - rather than the outer a as x.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 5 months
[JBoss JIRA] (TEIID-3990) Issues with nested correlated references
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3990?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-3990:
----------------------------------
Fix Version/s: 8.12.6.6_3
> Issues with nested correlated references
> ----------------------------------------
>
> Key: TEIID-3990
> URL: https://issues.jboss.org/browse/TEIID-3990
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.4
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 9.0, 8.12.5, 8.13.2
>
>
> There are several issues with nested correlated reference handling generally around having the same table name/alias in several levels of the query. For example with a having c1, c2 columns, b having c3, c4, and c having c5, c6:
> SELECT (select c2 from b where c3 = (select c5 from c as x where c6 = c1)) FROM a as x group by c1, c2
> Results in an exception since the inner most reference to c1 is seen as actually resolving to c as x - rather than the outer a as x.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 5 months
[JBoss JIRA] (TEIID-4686) PrestoDB translator - ordering of joined tables fails
by Juraj Duráni (JIRA)
[ https://issues.jboss.org/browse/TEIID-4686?page=com.atlassian.jira.plugin... ]
Juraj Duráni commented on TEIID-4686:
-------------------------------------
The bug should be fixed in next release (0.162) which has been already tagged on GitHub. I will wait for official release. Maybe we could close this without note in the doc.
> PrestoDB translator - ordering of joined tables fails
> -----------------------------------------------------
>
> Key: TEIID-4686
> URL: https://issues.jboss.org/browse/TEIID-4686
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.12.8.6_3
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
>
> Issuing query like \[1\] causes an exception in PrestoDB. This seems to be PrestoDB issue. I found similar issue \[2\], but that one should be fixed. I have created a new issue \[3\]. Removing one column from ORDER BY, query returns correct result.
> Not sure if we can do something about it without avoiding pushing JOIN.
> I suggest either to fix this (if simple enough) or add a note to the documentation.
> \[1\]
> {code:sql}
> SELECT a.intkey, b.intkey FROM BQT1.SmallA AS a INNER JOIN BQT1.SmallB AS b on a.intkey = b.intkey ORDER BY 1, 2
> {code}
> \[2\] https://github.com/prestodb/presto/issues/1621
> \[3\] https://github.com/prestodb/presto/issues/7010
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 5 months
[JBoss JIRA] (TEIID-4688) PrestoDB translator - no value available
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4688?page=com.atlassian.jira.plugin... ]
Work on TEIID-4688 started by Steven Hawkins.
---------------------------------------------
> PrestoDB translator - no value available
> ----------------------------------------
>
> Key: TEIID-4688
> URL: https://issues.jboss.org/browse/TEIID-4688
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.12.8.6_3
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
>
> Evaluation of query \[1\] ends up with exception produced by Teiid \[2\].
> {code:sql|title=\[1\]}
> SELECT INTKEY, CHARVALUE FROM BQT1.SMALLA AS A WHERE CHARVALUE <= (SELECT MAX(CHARVALUE) FROM BQT1.SMALLA AS B WHERE A.INTKEY = B.INTKEY) ORDER BY INTKEY
> {code}
> {code:plain|title=\[2\]}
> 15:56:58,754 ERROR [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue69) TEIID30019 Unexpected exception for request DEf6D1zaxo6u.19: org.teiid.core.TeiidComponentException: TEIID30328 Unable to evaluate MAX(B.CharValue): No value was available
> at org.teiid.query.util.CommandContext.getFromContext(CommandContext.java:506) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:718) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:693) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:362) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.eval.Evaluator.internalEvaluateTVL(Evaluator.java:237) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.eval.Evaluator.evaluateTVL(Evaluator.java:226) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:220) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.JoinNode.matchesCriteria(JoinNode.java:353) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.MergeJoinStrategy.process(MergeJoinStrategy.java:248) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:227) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:150) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.common.buffer.AbstractTupleSource.nextTuple(AbstractTupleSource.java:48) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.SortUtility.initialSort(SortUtility.java:262) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.SortUtility.sort(SortUtility.java:196) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.SortNode.sortPhase(SortNode.java:112) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.SortNode.getBufferDirect(SortNode.java:206) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.RelationalNode.getBuffer(RelationalNode.java:634) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.RelationalPlan.getBuffer(RelationalPlan.java:285) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.QueryProcessor.getBuffer(QueryProcessor.java:290) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:154) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:472) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:348) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_92]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_92]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_92]
> {code}
> {code:plain|title=Log}
> 15:58:51,125 DEBUG [org.teiid.TRANSPORT] (New I/O worker #2) processing message:MessageHolder: key=400 contents=Invoke interface org.teiid.client.DQP.executeRequest
> 15:58:51,126 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue70) Request Thread DEf6D1zaxo6u.20 with state NEW
> 15:58:51,126 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20 Command has no cache hint and result set cache mode is not on.
> 15:58:51,126 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20 executing SELECT INTKEY, CHARVALUE FROM BQT1.SMALLA AS A WHERE CHARVALUE <= (SELECT MAX(CHARVALUE) FROM BQT1.SMALLA AS B WHERE A.INTKEY = B.INTKEY) ORDER BY INTKEY
> 15:58:51,132 DEBUG [org.teiid.PLANNER] (Worker16_QueryProcessorQueue70) [LOW [Relational Planner] Non-literal comparison not supported by source. Source - SmallA__1.CharValue <= (SELECT MAX(B.CharValue) FROM BQT1.SmallA AS B WHERE B.IntKey = A.IntKey) was not pushed, LOW [Relational Planner] Conditions met (hint or cost) - Converting to a semi merge join Select(groups=[Source.SmallA AS SmallA__1], props={SELECT_CRITERIA=SmallA__1.CharValue <= (SELECT MAX(B.CharValue) FROM BQT1.SmallA AS B WHERE B.IntKey = A.IntKey), OUTPUT_COLS=[SmallA__1.IntKey, SmallA__1.CharValue], EST_CARDINALITY=16.666666, EST_COL_STATS={SmallA__1.IntKey=[-1.0, -1.0], SmallA__1.CharValue=[-1.0, -1.0]}}]
> 15:58:51,133 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue70) ProcessTree for DEf6D1zaxo6u.20 SortNode(4) output=[SmallA__1.IntKey, SmallA__1.CharValue] [SORT] [SmallA__1.IntKey]
> ProjectNode(5) output=[SmallA__1.IntKey, SmallA__1.CharValue] [SmallA__1.IntKey, SmallA__1.CharValue]
> JoinNode(6) [MERGE JOIN (ALREADY_SORTED/ALREADY_SORTED)] [SEMI JOIN] criteria=[SmallA__1.IntKey=B.IntKey, SmallA__1.CharValue <= MAX(B.CharValue)] output=[SmallA__1.IntKey, SmallA__1.CharValue]
> AccessNode(7) output=[SmallA__1.CharValue, SmallA__1.IntKey] SELECT g_0.CharValue AS c_0, g_0.IntKey AS c_1 FROM Source.SmallA AS g_0 ORDER BY c_1
> PlanExecutionNode(8) output=[MAX(B.CharValue), B.IntKey]
> 15:58:51,133 DEBUG [org.teiid.TXN_LOG] (Worker16_QueryProcessorQueue70) before getOrCreateTransactionContext:org.teiid.dqp.internal.process.TransactionServerImpl@65d4dce6(DEf6D1zaxo6u)
> 15:58:51,133 DEBUG [org.teiid.TXN_LOG] (Worker16_QueryProcessorQueue70) after getOrCreateTransactionContext : DEf6D1zaxo6u NONE ID:NONE
> 15:58:51,134 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue70) Creating TupleBuffer: 30 [A.IntKey, A.CharValue] [class java.lang.Integer, class java.lang.Character] batch size 2048 of type FINAL
> 15:58:51,134 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20.7.22 Create State
> 15:58:51,134 DEBUG [org.teiid.PROCESSOR] (Worker15_QueryProcessorQueue71) Running task for parent thread Worker16_QueryProcessorQueue70
> 15:58:51,134 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20.3.23 Create State
> 15:58:51,135 DEBUG [org.teiid.CONNECTOR] (Worker15_QueryProcessorQueue71) DEf6D1zaxo6u.20.7.22 Processing NEW request: SELECT g_0.CharValue AS c_0, g_0.IntKey AS c_1 FROM Source.SmallA AS g_0 ORDER BY c_1
> 15:58:51,135 DEBUG [org.teiid.PROCESSOR] (Worker17_QueryProcessorQueue72) Running task for parent thread Worker16_QueryProcessorQueue70
> 15:58:51,135 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue70) Creating TupleBuffer: 31 [SmallA__1.IntKey, SmallA__1.CharValue] [class java.lang.Integer, class java.lang.Character] batch size 2048 of type PROCESSOR
> 15:58:51,135 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue70) Created intermediate sort buffer 31
> 15:58:51,135 DEBUG [org.teiid.CONNECTOR] (Worker15_QueryProcessorQueue71) DEf6D1zaxo6u.20.7.22 Obtained execution
> 15:58:51,135 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue72) DEf6D1zaxo6u.20.3.23 Processing NEW request: SELECT MAX(g_0.CharValue) AS c_0, g_0.IntKey AS c_1 FROM Source.SmallA AS g_0 GROUP BY g_0.IntKey ORDER BY c_1
> 15:58:51,135 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20.7.22 Blocking on source query DEf6D1zaxo6u.20.7.22
> 15:58:51,135 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20 Blocking on source request(s).
> 15:58:51,135 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue70) Creating TupleBuffer: 32 [MAX(B.CharValue), B.IntKey] [class java.lang.Character, class java.lang.Integer] batch size 2048 of type PROCESSOR
> 15:58:51,136 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20.3.23 Blocking on source query DEf6D1zaxo6u.20.3.23
> 15:58:51,135 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue72) DEf6D1zaxo6u.20.3.23 Obtained execution
> 15:58:51,136 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20 Blocking on source request(s).
> 15:58:51,136 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue70) Request Thread DEf6D1zaxo6u.20 - processor blocked
> 15:58:51,136 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue72) Source-specific command: SELECT MAX(g_0.charvalue) AS c_0, g_0.intkey AS c_1 FROM smalla AS g_0 GROUP BY g_0.intkey ORDER BY c_1
> 15:58:51,138 DEBUG [org.teiid.CONNECTOR] (Worker15_QueryProcessorQueue71) Source-specific command: SELECT g_0.charvalue AS c_0, g_0.intkey AS c_1 FROM smalla AS g_0 ORDER BY c_1
> 15:58:51,634 DEBUG [org.teiid.CONNECTOR] (Worker15_QueryProcessorQueue71) DEf6D1zaxo6u.20.7.22 Executed command
> 15:58:51,634 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue72) DEf6D1zaxo6u.20.3.23 Executed command
> 15:58:51,634 DEBUG [org.teiid.CONNECTOR] (Worker15_QueryProcessorQueue71) DEf6D1zaxo6u.20.7.22 Processing MORE request
> 15:58:51,634 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue72) DEf6D1zaxo6u.20.3.23 Processing MORE request
> 15:58:51,634 DEBUG [org.teiid.CONNECTOR] (Worker15_QueryProcessorQueue71) DEf6D1zaxo6u.20.7.22 Getting results from connector
> 15:58:51,634 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue72) DEf6D1zaxo6u.20.3.23 Getting results from connector
> 15:58:51,796 DEBUG [org.teiid.CONNECTOR] (Worker15_QueryProcessorQueue71) DEf6D1zaxo6u.20.7.22 Obtained last batch, total row count: 50
> 15:58:51,796 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue72) DEf6D1zaxo6u.20.3.23 Obtained last batch, total row count: 50
> 15:58:51,796 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue73) Request Thread DEf6D1zaxo6u.20 with state PROCESSING
> 15:58:51,797 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.7.22 Remove State
> 15:58:51,797 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.7.22 Processing Close : SELECT g_0.CharValue AS c_0, g_0.IntKey AS c_1 FROM Source.SmallA AS g_0 ORDER BY c_1
> 15:58:51,797 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.7.22 Closed execution
> 15:58:51,797 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.7.22 Closed connection
> 15:58:51,798 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.3.23 Remove State
> 15:58:51,798 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.3.23 Processing Close : SELECT MAX(g_0.CharValue) AS c_0, g_0.IntKey AS c_1 FROM Source.SmallA AS g_0 GROUP BY g_0.IntKey ORDER BY c_1
> 15:58:51,798 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.3.23 Closed execution
> 15:58:51,798 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.3.23 Closed connection
> 15:58:51,799 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue73) Removing TupleBuffer: 31
> 15:58:51,799 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue73) QueryProcessor: closing processor
> 15:58:51,799 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue73) Removing TupleBuffer: 32
> 15:58:51,800 ERROR [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue73) TEIID30019 Unexpected exception for request DEf6D1zaxo6u.20: org.teiid.core.TeiidComponentException: TEIID30328 Unable to evaluate MAX(B.CharValue): No value was available
> at org.teiid.query.util.CommandContext.getFromContext(CommandContext.java:506) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:718) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:693) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:362) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.eval.Evaluator.internalEvaluateTVL(Evaluator.java:237) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.eval.Evaluator.evaluateTVL(Evaluator.java:226) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:220) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.JoinNode.matchesCriteria(JoinNode.java:353) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.MergeJoinStrategy.process(MergeJoinStrategy.java:248) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:227) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:150) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.common.buffer.AbstractTupleSource.nextTuple(AbstractTupleSource.java:48) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.SortUtility.initialSort(SortUtility.java:262) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.SortUtility.sort(SortUtility.java:196) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.SortNode.sortPhase(SortNode.java:112) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.SortNode.getBufferDirect(SortNode.java:206) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.RelationalNode.getBuffer(RelationalNode.java:634) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.RelationalPlan.getBuffer(RelationalPlan.java:285) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.QueryProcessor.getBuffer(QueryProcessor.java:290) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:154) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:472) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:348) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_92]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_92]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_92]
> 15:58:51,802 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue73) Removing tuplesource for the request DEf6D1zaxo6u.20
> 15:58:51,802 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue73) Removing TupleBuffer: 30
> 15:58:51,802 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20 Finished Processing
> 15:58:51,802 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue73) org.teiid.core.TeiidComponentException: TEIID30328 Unable to evaluate MAX(B.CharValue): No value was available Sending error to client DEf6D1zaxo6u.20
> 15:58:51,802 DEBUG [org.teiid.TRANSPORT] (Worker16_QueryProcessorQueue73) send message: MessageHolder: key=400 contents=ResultsMessage rowCount=0 finalRow=-1
> 15:58:52,435 DEBUG [org.teiid.TRANSPORT] (New I/O worker #3) processing message:MessageHolder: key=401 contents=Invoke interface org.teiid.client.security.ILogon.ping
> 15:58:52,435 DEBUG [org.teiid.TRANSPORT] (New I/O worker #3) send message: MessageHolder: key=401 contents=null
> 15:58:52,436 DEBUG [org.teiid.TRANSPORT] (New I/O worker #3) processing message:MessageHolder: key=402 contents=Invoke interface org.teiid.client.security.ILogon.ping
> 15:58:52,436 DEBUG [org.teiid.SECURITY] (New I/O worker #3) Keep-alive ping received for session: DEf6D1zaxo6u
> 15:58:52,436 DEBUG [org.teiid.TRANSPORT] (New I/O worker #3) send message: MessageHolder: key=402 contents=null
> {code}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 5 months
[JBoss JIRA] (TEIID-4688) PrestoDB translator - no value available
by Juraj Duráni (JIRA)
Juraj Duráni created TEIID-4688:
-----------------------------------
Summary: PrestoDB translator - no value available
Key: TEIID-4688
URL: https://issues.jboss.org/browse/TEIID-4688
Project: Teiid
Issue Type: Bug
Affects Versions: 8.12.8.6_3
Reporter: Juraj Duráni
Assignee: Steven Hawkins
Evaluation of query \[1\] ends up with exception produced by Teiid \[2\].
{code:sql|title=\[1\]}
SELECT INTKEY, CHARVALUE FROM BQT1.SMALLA AS A WHERE CHARVALUE <= (SELECT MAX(CHARVALUE) FROM BQT1.SMALLA AS B WHERE A.INTKEY = B.INTKEY) ORDER BY INTKEY
{code}
{code:plain|title=\[2\]}
15:56:58,754 ERROR [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue69) TEIID30019 Unexpected exception for request DEf6D1zaxo6u.19: org.teiid.core.TeiidComponentException: TEIID30328 Unable to evaluate MAX(B.CharValue): No value was available
at org.teiid.query.util.CommandContext.getFromContext(CommandContext.java:506) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:718) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:693) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:362) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.eval.Evaluator.internalEvaluateTVL(Evaluator.java:237) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.eval.Evaluator.evaluateTVL(Evaluator.java:226) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:220) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.JoinNode.matchesCriteria(JoinNode.java:353) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.MergeJoinStrategy.process(MergeJoinStrategy.java:248) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:227) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:150) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.common.buffer.AbstractTupleSource.nextTuple(AbstractTupleSource.java:48) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.SortUtility.initialSort(SortUtility.java:262) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.SortUtility.sort(SortUtility.java:196) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.SortNode.sortPhase(SortNode.java:112) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.SortNode.getBufferDirect(SortNode.java:206) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.RelationalNode.getBuffer(RelationalNode.java:634) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.RelationalPlan.getBuffer(RelationalPlan.java:285) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.QueryProcessor.getBuffer(QueryProcessor.java:290) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:154) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:472) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:348) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_92]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_92]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_92]
{code}
{code:plain|title=Log}
15:58:51,125 DEBUG [org.teiid.TRANSPORT] (New I/O worker #2) processing message:MessageHolder: key=400 contents=Invoke interface org.teiid.client.DQP.executeRequest
15:58:51,126 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue70) Request Thread DEf6D1zaxo6u.20 with state NEW
15:58:51,126 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20 Command has no cache hint and result set cache mode is not on.
15:58:51,126 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20 executing SELECT INTKEY, CHARVALUE FROM BQT1.SMALLA AS A WHERE CHARVALUE <= (SELECT MAX(CHARVALUE) FROM BQT1.SMALLA AS B WHERE A.INTKEY = B.INTKEY) ORDER BY INTKEY
15:58:51,132 DEBUG [org.teiid.PLANNER] (Worker16_QueryProcessorQueue70) [LOW [Relational Planner] Non-literal comparison not supported by source. Source - SmallA__1.CharValue <= (SELECT MAX(B.CharValue) FROM BQT1.SmallA AS B WHERE B.IntKey = A.IntKey) was not pushed, LOW [Relational Planner] Conditions met (hint or cost) - Converting to a semi merge join Select(groups=[Source.SmallA AS SmallA__1], props={SELECT_CRITERIA=SmallA__1.CharValue <= (SELECT MAX(B.CharValue) FROM BQT1.SmallA AS B WHERE B.IntKey = A.IntKey), OUTPUT_COLS=[SmallA__1.IntKey, SmallA__1.CharValue], EST_CARDINALITY=16.666666, EST_COL_STATS={SmallA__1.IntKey=[-1.0, -1.0], SmallA__1.CharValue=[-1.0, -1.0]}}]
15:58:51,133 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue70) ProcessTree for DEf6D1zaxo6u.20 SortNode(4) output=[SmallA__1.IntKey, SmallA__1.CharValue] [SORT] [SmallA__1.IntKey]
ProjectNode(5) output=[SmallA__1.IntKey, SmallA__1.CharValue] [SmallA__1.IntKey, SmallA__1.CharValue]
JoinNode(6) [MERGE JOIN (ALREADY_SORTED/ALREADY_SORTED)] [SEMI JOIN] criteria=[SmallA__1.IntKey=B.IntKey, SmallA__1.CharValue <= MAX(B.CharValue)] output=[SmallA__1.IntKey, SmallA__1.CharValue]
AccessNode(7) output=[SmallA__1.CharValue, SmallA__1.IntKey] SELECT g_0.CharValue AS c_0, g_0.IntKey AS c_1 FROM Source.SmallA AS g_0 ORDER BY c_1
PlanExecutionNode(8) output=[MAX(B.CharValue), B.IntKey]
15:58:51,133 DEBUG [org.teiid.TXN_LOG] (Worker16_QueryProcessorQueue70) before getOrCreateTransactionContext:org.teiid.dqp.internal.process.TransactionServerImpl@65d4dce6(DEf6D1zaxo6u)
15:58:51,133 DEBUG [org.teiid.TXN_LOG] (Worker16_QueryProcessorQueue70) after getOrCreateTransactionContext : DEf6D1zaxo6u NONE ID:NONE
15:58:51,134 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue70) Creating TupleBuffer: 30 [A.IntKey, A.CharValue] [class java.lang.Integer, class java.lang.Character] batch size 2048 of type FINAL
15:58:51,134 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20.7.22 Create State
15:58:51,134 DEBUG [org.teiid.PROCESSOR] (Worker15_QueryProcessorQueue71) Running task for parent thread Worker16_QueryProcessorQueue70
15:58:51,134 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20.3.23 Create State
15:58:51,135 DEBUG [org.teiid.CONNECTOR] (Worker15_QueryProcessorQueue71) DEf6D1zaxo6u.20.7.22 Processing NEW request: SELECT g_0.CharValue AS c_0, g_0.IntKey AS c_1 FROM Source.SmallA AS g_0 ORDER BY c_1
15:58:51,135 DEBUG [org.teiid.PROCESSOR] (Worker17_QueryProcessorQueue72) Running task for parent thread Worker16_QueryProcessorQueue70
15:58:51,135 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue70) Creating TupleBuffer: 31 [SmallA__1.IntKey, SmallA__1.CharValue] [class java.lang.Integer, class java.lang.Character] batch size 2048 of type PROCESSOR
15:58:51,135 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue70) Created intermediate sort buffer 31
15:58:51,135 DEBUG [org.teiid.CONNECTOR] (Worker15_QueryProcessorQueue71) DEf6D1zaxo6u.20.7.22 Obtained execution
15:58:51,135 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue72) DEf6D1zaxo6u.20.3.23 Processing NEW request: SELECT MAX(g_0.CharValue) AS c_0, g_0.IntKey AS c_1 FROM Source.SmallA AS g_0 GROUP BY g_0.IntKey ORDER BY c_1
15:58:51,135 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20.7.22 Blocking on source query DEf6D1zaxo6u.20.7.22
15:58:51,135 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20 Blocking on source request(s).
15:58:51,135 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue70) Creating TupleBuffer: 32 [MAX(B.CharValue), B.IntKey] [class java.lang.Character, class java.lang.Integer] batch size 2048 of type PROCESSOR
15:58:51,136 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20.3.23 Blocking on source query DEf6D1zaxo6u.20.3.23
15:58:51,135 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue72) DEf6D1zaxo6u.20.3.23 Obtained execution
15:58:51,136 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20 Blocking on source request(s).
15:58:51,136 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue70) Request Thread DEf6D1zaxo6u.20 - processor blocked
15:58:51,136 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue72) Source-specific command: SELECT MAX(g_0.charvalue) AS c_0, g_0.intkey AS c_1 FROM smalla AS g_0 GROUP BY g_0.intkey ORDER BY c_1
15:58:51,138 DEBUG [org.teiid.CONNECTOR] (Worker15_QueryProcessorQueue71) Source-specific command: SELECT g_0.charvalue AS c_0, g_0.intkey AS c_1 FROM smalla AS g_0 ORDER BY c_1
15:58:51,634 DEBUG [org.teiid.CONNECTOR] (Worker15_QueryProcessorQueue71) DEf6D1zaxo6u.20.7.22 Executed command
15:58:51,634 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue72) DEf6D1zaxo6u.20.3.23 Executed command
15:58:51,634 DEBUG [org.teiid.CONNECTOR] (Worker15_QueryProcessorQueue71) DEf6D1zaxo6u.20.7.22 Processing MORE request
15:58:51,634 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue72) DEf6D1zaxo6u.20.3.23 Processing MORE request
15:58:51,634 DEBUG [org.teiid.CONNECTOR] (Worker15_QueryProcessorQueue71) DEf6D1zaxo6u.20.7.22 Getting results from connector
15:58:51,634 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue72) DEf6D1zaxo6u.20.3.23 Getting results from connector
15:58:51,796 DEBUG [org.teiid.CONNECTOR] (Worker15_QueryProcessorQueue71) DEf6D1zaxo6u.20.7.22 Obtained last batch, total row count: 50
15:58:51,796 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue72) DEf6D1zaxo6u.20.3.23 Obtained last batch, total row count: 50
15:58:51,796 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue73) Request Thread DEf6D1zaxo6u.20 with state PROCESSING
15:58:51,797 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.7.22 Remove State
15:58:51,797 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.7.22 Processing Close : SELECT g_0.CharValue AS c_0, g_0.IntKey AS c_1 FROM Source.SmallA AS g_0 ORDER BY c_1
15:58:51,797 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.7.22 Closed execution
15:58:51,797 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.7.22 Closed connection
15:58:51,798 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.3.23 Remove State
15:58:51,798 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.3.23 Processing Close : SELECT MAX(g_0.CharValue) AS c_0, g_0.IntKey AS c_1 FROM Source.SmallA AS g_0 GROUP BY g_0.IntKey ORDER BY c_1
15:58:51,798 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.3.23 Closed execution
15:58:51,798 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.3.23 Closed connection
15:58:51,799 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue73) Removing TupleBuffer: 31
15:58:51,799 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue73) QueryProcessor: closing processor
15:58:51,799 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue73) Removing TupleBuffer: 32
15:58:51,800 ERROR [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue73) TEIID30019 Unexpected exception for request DEf6D1zaxo6u.20: org.teiid.core.TeiidComponentException: TEIID30328 Unable to evaluate MAX(B.CharValue): No value was available
at org.teiid.query.util.CommandContext.getFromContext(CommandContext.java:506) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:718) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:693) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:362) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.eval.Evaluator.internalEvaluateTVL(Evaluator.java:237) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.eval.Evaluator.evaluateTVL(Evaluator.java:226) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:220) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.JoinNode.matchesCriteria(JoinNode.java:353) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.MergeJoinStrategy.process(MergeJoinStrategy.java:248) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:227) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:150) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.common.buffer.AbstractTupleSource.nextTuple(AbstractTupleSource.java:48) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.SortUtility.initialSort(SortUtility.java:262) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.SortUtility.sort(SortUtility.java:196) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.SortNode.sortPhase(SortNode.java:112) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.SortNode.getBufferDirect(SortNode.java:206) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.RelationalNode.getBuffer(RelationalNode.java:634) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.RelationalPlan.getBuffer(RelationalPlan.java:285) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.QueryProcessor.getBuffer(QueryProcessor.java:290) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:154) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:472) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:348) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_92]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_92]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_92]
15:58:51,802 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue73) Removing tuplesource for the request DEf6D1zaxo6u.20
15:58:51,802 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue73) Removing TupleBuffer: 30
15:58:51,802 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20 Finished Processing
15:58:51,802 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue73) org.teiid.core.TeiidComponentException: TEIID30328 Unable to evaluate MAX(B.CharValue): No value was available Sending error to client DEf6D1zaxo6u.20
15:58:51,802 DEBUG [org.teiid.TRANSPORT] (Worker16_QueryProcessorQueue73) send message: MessageHolder: key=400 contents=ResultsMessage rowCount=0 finalRow=-1
15:58:52,435 DEBUG [org.teiid.TRANSPORT] (New I/O worker #3) processing message:MessageHolder: key=401 contents=Invoke interface org.teiid.client.security.ILogon.ping
15:58:52,435 DEBUG [org.teiid.TRANSPORT] (New I/O worker #3) send message: MessageHolder: key=401 contents=null
15:58:52,436 DEBUG [org.teiid.TRANSPORT] (New I/O worker #3) processing message:MessageHolder: key=402 contents=Invoke interface org.teiid.client.security.ILogon.ping
15:58:52,436 DEBUG [org.teiid.SECURITY] (New I/O worker #3) Keep-alive ping received for session: DEf6D1zaxo6u
15:58:52,436 DEBUG [org.teiid.TRANSPORT] (New I/O worker #3) send message: MessageHolder: key=402 contents=null
{code}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 5 months
[JBoss JIRA] (TEIID-4636) In the SWARM readme's, need to indicate the URL to connect
by Kylin Soong (JIRA)
[ https://issues.jboss.org/browse/TEIID-4636?page=com.atlassian.jira.plugin... ]
Kylin Soong commented on TEIID-4636:
------------------------------------
No, I just account for Van, why swarm teiid can no use system property to bind port, that because DV server also not design to use system property bind a port.
Do you think we need use system property to bind the jdbc and odbc port? if yes, I can do this.
> In the SWARM readme's, need to indicate the URL to connect
> ----------------------------------------------------------
>
> Key: TEIID-4636
> URL: https://issues.jboss.org/browse/TEIID-4636
> Project: Teiid
> Issue Type: Enhancement
> Components: Quick Starts
> Affects Versions: 9.2
> Reporter: Van Halbert
> Assignee: Van Halbert
> Priority: Minor
>
> The quickstarts needs to include the information (i.e, URL, username, password, etc.) needed to connect to the swarm example.
> Per Kylin:
> By default 0.0.0.0 be bound as IP, 31000 as port. To bind a specific IP use system properties
> ---
> -Dswarm.bind.address=127.0.0.1
> ---
> Some Fractions use a system properties to change the port number, but teiid not support it at moment.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 5 months
[JBoss JIRA] (TEIID-4687) PrestoDB translator - unsupported corelated subquery
by Juraj Duráni (JIRA)
Juraj Duráni created TEIID-4687:
-----------------------------------
Summary: PrestoDB translator - unsupported corelated subquery
Key: TEIID-4687
URL: https://issues.jboss.org/browse/TEIID-4687
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 8.12.8.6_3
Reporter: Juraj Duráni
Assignee: Steven Hawkins
Running query \[1\], PrestoDB throws exception (log \[2\]) for translated query.
{code:sql|title=\[1\]}
SELECT intkey, stringkey, floatnum, bytenum, (SELECT bytenum FROM bqt1.smalla AS b WHERE (bytenum = a.longnum) AND (intkey = '10')) AS longnum FROM bqt1.smalla AS a
{code}
{code:plain|title=\[2\]}
15:51:58,928 DEBUG [org.teiid.TRANSPORT] (New I/O worker #2) processing message:MessageHolder: key=386 contents=Invoke interface org.teiid.client.DQP.executeRequest
15:51:58,930 DEBUG [org.teiid.PROCESSOR] (Worker13_QueryProcessorQueue47) Request Thread DEf6D1zaxo6u.14 with state NEW
15:51:58,930 DEBUG [org.teiid.PROCESSOR] (Worker13_QueryProcessorQueue47) DEf6D1zaxo6u.14 Command has no cache hint and result set cache mode is not on.
15:51:58,931 DEBUG [org.teiid.PROCESSOR] (Worker13_QueryProcessorQueue47) DEf6D1zaxo6u.14 executing SELECT intkey, stringkey, floatnum, bytenum, (SELECT bytenum FROM bqt1.smalla AS b WHERE (bytenum = a.longnum) AND (intkey = '10')) AS longnum FROM bqt1.smalla AS a
15:51:58,936 DEBUG [org.teiid.PROCESSOR] (Worker13_QueryProcessorQueue47) ProcessTree for DEf6D1zaxo6u.14 AccessNode(1) output=[SmallA__1.IntKey, SmallA__1.StringKey, convert(SmallA__1.FloatNum, float), convert(SmallA__1.ByteNum, byte), (SELECT convert(g_0.ByteNum, byte) AS c_0 FROM Source.SmallA AS g_0 WHERE (convert(convert(g_0.ByteNum, byte), long) = SmallA__1.LongNum) AND (g_0.IntKey = 10)) AS longnum] SELECT g_0.IntKey, g_0.StringKey, convert(g_0.FloatNum, float), convert(g_0.ByteNum, byte), (SELECT convert(g_1.ByteNum, byte) FROM Source.SmallA AS g_1 WHERE (convert(convert(g_1.ByteNum, byte), long) = g_0.LongNum) AND (g_1.IntKey = 10)) FROM Source.SmallA AS g_0
15:51:58,938 DEBUG [org.teiid.TXN_LOG] (Worker13_QueryProcessorQueue47) before getOrCreateTransactionContext:org.teiid.dqp.internal.process.TransactionServerImpl@65d4dce6(DEf6D1zaxo6u)
15:51:58,938 DEBUG [org.teiid.TXN_LOG] (Worker13_QueryProcessorQueue47) after getOrCreateTransactionContext : DEf6D1zaxo6u NONE ID:NONE
15:51:58,939 DEBUG [org.teiid.BUFFER_MGR] (Worker13_QueryProcessorQueue47) Creating TupleBuffer: 19 [a.IntKey, a.StringKey, a.FloatNum, a.ByteNum, (SELECT b.ByteNum FROM BQT1.SmallA AS b WHERE (convert(b.ByteNum, long) = a.LongNum) AND (b.IntKey = 10) LIMIT 2) AS longnum] [class java.lang.Integer, class java.lang.String, class java.lang.Float, class java.lang.Byte, class java.lang.Byte] batch size 1024 of type PROCESSOR
15:51:58,940 DEBUG [org.teiid.CONNECTOR] (Worker13_QueryProcessorQueue47) DEf6D1zaxo6u.14.1.14 Create State
15:51:58,941 DEBUG [org.teiid.BUFFER_MGR] (Worker13_QueryProcessorQueue47) DEf6D1zaxo6u.14.1.14 Blocking on source query DEf6D1zaxo6u.14.1.14
15:51:58,942 DEBUG [org.teiid.BUFFER_MGR] (Worker13_QueryProcessorQueue47) DEf6D1zaxo6u.14 Blocking on source request(s).
15:51:58,942 DEBUG [org.teiid.PROCESSOR] (Worker13_QueryProcessorQueue47) Request Thread DEf6D1zaxo6u.14 - processor blocked
15:51:58,942 DEBUG [org.teiid.PROCESSOR] (Worker14_QueryProcessorQueue48) Running task for parent thread Worker13_QueryProcessorQueue47
15:51:58,943 DEBUG [org.teiid.CONNECTOR] (Worker14_QueryProcessorQueue48) DEf6D1zaxo6u.14.1.14 Processing NEW request: SELECT g_0.IntKey, g_0.StringKey, convert(g_0.FloatNum, float), convert(g_0.ByteNum, byte), (SELECT convert(g_1.ByteNum, byte) FROM Source.SmallA AS g_1 WHERE (convert(convert(g_1.ByteNum, byte), long) = g_0.LongNum) AND (g_1.IntKey = 10)) FROM Source.SmallA AS g_0
15:51:58,943 DEBUG [org.teiid.CONNECTOR] (Worker14_QueryProcessorQueue48) DEf6D1zaxo6u.14.1.14 Obtained execution
15:51:58,944 DEBUG [org.teiid.CONNECTOR] (Worker14_QueryProcessorQueue48) Source-specific command: SELECT g_0.intkey, g_0.stringkey, g_0.floatnum, g_0.bytenum, (SELECT g_1.bytenum FROM smalla AS g_1 WHERE cast(g_1.bytenum AS bigint) = g_0.longnum AND g_1.intkey = 10) FROM smalla AS g_0
15:51:59,443 WARN [org.teiid.CONNECTOR] (Worker14_QueryProcessorQueue48) Connector worker process failed for atomic-request=DEf6D1zaxo6u.14.1.14: org.teiid.translator.jdbc.JDBCExecutionException: 65536 TEIID11008:TEIID11004 Error executing statement(s): [SQL: SELECT g_0.intkey, g_0.stringkey, g_0.floatnum, g_0.bytenum, (SELECT g_1.bytenum FROM smalla AS g_1 WHERE cast(g_1.bytenum AS bigint) = g_0.longnum AND g_1.intkey = 10) FROM smalla AS g_0]
at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:131) [translator-jdbc-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:364)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_92]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_92]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_92]
at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_92]
at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211)
at com.sun.proxy.$Proxy48.execute(Unknown Source)
at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306)
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_92]
at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276)
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:1142) [rt.jar:1.8.0_92]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_92]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_92]
Caused by: java.sql.SQLException: Query failed (#20170106_145159_04181_k4ss5): Unsupported correlated subquery type
at com.facebook.presto.jdbc.PrestoResultSet.resultsException(PrestoResultSet.java:1799)
at com.facebook.presto.jdbc.PrestoResultSet.getColumns(PrestoResultSet.java:1747)
at com.facebook.presto.jdbc.PrestoResultSet.<init>(PrestoResultSet.java:125)
at com.facebook.presto.jdbc.PrestoStatement.execute(PrestoStatement.java:212)
at com.facebook.presto.jdbc.PrestoStatement.executeQuery(PrestoStatement.java:69)
at org.jboss.jca.adapters.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:344)
at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:119) [translator-jdbc-8.12.5.redhat-8.jar:8.12.5.redhat-8]
... 18 more
Caused by: java.lang.IllegalArgumentException: Unsupported correlated subquery type
at com.facebook.presto.sql.planner.sanity.NoApplyNodeLeftChecker$1.visitApply(NoApplyNodeLeftChecker.java:42)
at com.facebook.presto.sql.planner.plan.ApplyNode.accept(ApplyNode.java:142)
at com.facebook.presto.sql.planner.SimplePlanVisitor.visitPlan(SimplePlanVisitor.java:26)
at com.facebook.presto.sql.planner.SimplePlanVisitor.visitPlan(SimplePlanVisitor.java:19)
at com.facebook.presto.sql.planner.plan.PlanVisitor.visitProject(PlanVisitor.java:40)
at com.facebook.presto.sql.planner.plan.ProjectNode.accept(ProjectNode.java:81)
at com.facebook.presto.sql.planner.SimplePlanVisitor.visitPlan(SimplePlanVisitor.java:26)
at com.facebook.presto.sql.planner.SimplePlanVisitor.visitPlan(SimplePlanVisitor.java:19)
at com.facebook.presto.sql.planner.plan.PlanVisitor.visitExchange(PlanVisitor.java:175)
at com.facebook.presto.sql.planner.plan.ExchangeNode.accept(ExchangeNode.java:209)
at com.facebook.presto.sql.planner.SimplePlanVisitor.visitPlan(SimplePlanVisitor.java:26)
at com.facebook.presto.sql.planner.SimplePlanVisitor.visitPlan(SimplePlanVisitor.java:19)
at com.facebook.presto.sql.planner.plan.PlanVisitor.visitOutput(PlanVisitor.java:50)
at com.facebook.presto.sql.planner.plan.OutputNode.accept(OutputNode.java:81)
at com.facebook.presto.sql.planner.sanity.NoApplyNodeLeftChecker.validate(NoApplyNodeLeftChecker.java:33)
at com.facebook.presto.sql.planner.sanity.PlanSanityChecker.lambda$validate$0(PlanSanityChecker.java:44)
at java.lang.Iterable.forEach(Iterable.java:75) [rt.jar:1.8.0_92]
at com.facebook.presto.sql.planner.sanity.PlanSanityChecker.validate(PlanSanityChecker.java:44)
at com.facebook.presto.sql.planner.LogicalPlanner.plan(LogicalPlanner.java:127)
at com.facebook.presto.sql.planner.LogicalPlanner.plan(LogicalPlanner.java:111)
at com.facebook.presto.execution.SqlQueryExecution.doAnalyzeQuery(SqlQueryExecution.java:292)
at com.facebook.presto.execution.SqlQueryExecution.analyzeQuery(SqlQueryExecution.java:271)
at com.facebook.presto.execution.SqlQueryExecution.start(SqlQueryExecution.java:229)
at com.facebook.presto.execution.QueuedExecution.lambda$start$1(QueuedExecution.java:62)
... 3 more
15:51:59,452 DEBUG [org.teiid.PROCESSOR] (Worker13_QueryProcessorQueue49) Request Thread DEf6D1zaxo6u.14 with state PROCESSING
15:51:59,452 DEBUG [org.teiid.CONNECTOR] (Worker13_QueryProcessorQueue49) DEf6D1zaxo6u.14.1.14 Remove State
15:51:59,452 DEBUG [org.teiid.CONNECTOR] (Worker13_QueryProcessorQueue49) DEf6D1zaxo6u.14.1.14 Processing Close : SELECT g_0.IntKey, g_0.StringKey, convert(g_0.FloatNum, float), convert(g_0.ByteNum, byte), (SELECT convert(g_1.ByteNum, byte) FROM Source.SmallA AS g_1 WHERE (convert(convert(g_1.ByteNum, byte), long) = g_0.LongNum) AND (g_1.IntKey = 10)) FROM Source.SmallA AS g_0
15:51:59,453 DEBUG [org.teiid.CONNECTOR] (Worker13_QueryProcessorQueue49) DEf6D1zaxo6u.14.1.14 Closed execution
15:51:59,453 DEBUG [org.teiid.CONNECTOR] (Worker13_QueryProcessorQueue49) DEf6D1zaxo6u.14.1.14 Closed connection
15:51:59,454 DEBUG [org.teiid.PROCESSOR] (Worker13_QueryProcessorQueue49) QueryProcessor: closing processor
15:51:59,454 WARN [org.teiid.PROCESSOR] (Worker13_QueryProcessorQueue49) TEIID30020 Processing exception for request DEf6D1zaxo6u.14 'TEIID30504 Source: 65536 TEIID11008:TEIID11004 Error executing statement(s): [SQL: SELECT g_0.intkey, g_0.stringkey, g_0.floatnum, g_0.bytenum, (SELECT g_1.bytenum FROM smalla AS g_1 WHERE cast(g_1.bytenum AS bigint) = g_0.longnum AND g_1.intkey = 10) FROM smalla AS g_0]'. Originally TeiidProcessingException 'Unsupported correlated subquery type' NoApplyNodeLeftChecker.java:42.: org.teiid.core.TeiidProcessingException: TEIID30504 Source: 65536 TEIID11008:TEIID11004 Error executing statement(s): [SQL: SELECT g_0.intkey, g_0.stringkey, g_0.floatnum, g_0.bytenum, (SELECT g_1.bytenum FROM smalla AS g_1 WHERE cast(g_1.bytenum AS bigint) = g_0.longnum AND g_1.intkey = 10) FROM smalla AS g_0]
at org.teiid.dqp.internal.process.DataTierTupleSource.exceptionOccurred(DataTierTupleSource.java:401) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:161) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:391) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:472) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:348) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_92]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_92]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_92]
Caused by: org.teiid.translator.jdbc.JDBCExecutionException: 65536 TEIID11008:TEIID11004 Error executing statement(s): [SQL: SELECT g_0.intkey, g_0.stringkey, g_0.floatnum, g_0.bytenum, (SELECT g_1.bytenum FROM smalla AS g_1 WHERE cast(g_1.bytenum AS bigint) = g_0.longnum AND g_1.intkey = 10) FROM smalla AS g_0]
at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:131)
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:364) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_92]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_92]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_92]
at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_92]
at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at com.sun.proxy.$Proxy48.execute(Unknown Source)
at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_92]
at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
... 6 more
Caused by: java.sql.SQLException: Query failed (#20170106_145159_04181_k4ss5): Unsupported correlated subquery type
at com.facebook.presto.jdbc.PrestoResultSet.resultsException(PrestoResultSet.java:1799)
at com.facebook.presto.jdbc.PrestoResultSet.getColumns(PrestoResultSet.java:1747)
at com.facebook.presto.jdbc.PrestoResultSet.<init>(PrestoResultSet.java:125)
at com.facebook.presto.jdbc.PrestoStatement.execute(PrestoStatement.java:212)
at com.facebook.presto.jdbc.PrestoStatement.executeQuery(PrestoStatement.java:69)
at org.jboss.jca.adapters.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:344)
at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:119)
... 18 more
Caused by: java.lang.IllegalArgumentException: Unsupported correlated subquery type
at com.facebook.presto.sql.planner.sanity.NoApplyNodeLeftChecker$1.visitApply(NoApplyNodeLeftChecker.java:42)
at com.facebook.presto.sql.planner.plan.ApplyNode.accept(ApplyNode.java:142)
at com.facebook.presto.sql.planner.SimplePlanVisitor.visitPlan(SimplePlanVisitor.java:26)
at com.facebook.presto.sql.planner.SimplePlanVisitor.visitPlan(SimplePlanVisitor.java:19)
at com.facebook.presto.sql.planner.plan.PlanVisitor.visitProject(PlanVisitor.java:40)
at com.facebook.presto.sql.planner.plan.ProjectNode.accept(ProjectNode.java:81)
at com.facebook.presto.sql.planner.SimplePlanVisitor.visitPlan(SimplePlanVisitor.java:26)
at com.facebook.presto.sql.planner.SimplePlanVisitor.visitPlan(SimplePlanVisitor.java:19)
at com.facebook.presto.sql.planner.plan.PlanVisitor.visitExchange(PlanVisitor.java:175)
at com.facebook.presto.sql.planner.plan.ExchangeNode.accept(ExchangeNode.java:209)
at com.facebook.presto.sql.planner.SimplePlanVisitor.visitPlan(SimplePlanVisitor.java:26)
at com.facebook.presto.sql.planner.SimplePlanVisitor.visitPlan(SimplePlanVisitor.java:19)
at com.facebook.presto.sql.planner.plan.PlanVisitor.visitOutput(PlanVisitor.java:50)
at com.facebook.presto.sql.planner.plan.OutputNode.accept(OutputNode.java:81)
at com.facebook.presto.sql.planner.sanity.NoApplyNodeLeftChecker.validate(NoApplyNodeLeftChecker.java:33)
at com.facebook.presto.sql.planner.sanity.PlanSanityChecker.lambda$validate$0(PlanSanityChecker.java:44)
at java.lang.Iterable.forEach(Iterable.java:75) [rt.jar:1.8.0_92]
at com.facebook.presto.sql.planner.sanity.PlanSanityChecker.validate(PlanSanityChecker.java:44)
at com.facebook.presto.sql.planner.LogicalPlanner.plan(LogicalPlanner.java:127)
at com.facebook.presto.sql.planner.LogicalPlanner.plan(LogicalPlanner.java:111)
at com.facebook.presto.execution.SqlQueryExecution.doAnalyzeQuery(SqlQueryExecution.java:292)
at com.facebook.presto.execution.SqlQueryExecution.analyzeQuery(SqlQueryExecution.java:271)
at com.facebook.presto.execution.SqlQueryExecution.start(SqlQueryExecution.java:229)
at com.facebook.presto.execution.QueuedExecution.lambda$start$1(QueuedExecution.java:62)
... 3 more
15:51:59,460 DEBUG [org.teiid.PROCESSOR] (Worker13_QueryProcessorQueue49) Removing tuplesource for the request DEf6D1zaxo6u.14
15:51:59,460 DEBUG [org.teiid.BUFFER_MGR] (Worker13_QueryProcessorQueue49) Removing TupleBuffer: 19
15:51:59,460 DEBUG [org.teiid.PROCESSOR] (Worker13_QueryProcessorQueue49) DEf6D1zaxo6u.14 Finished Processing
15:51:59,460 DEBUG [org.teiid.PROCESSOR] (Worker13_QueryProcessorQueue49) org.teiid.core.TeiidProcessingException: TEIID30504 Source: 65536 TEIID11008:TEIID11004 Error executing statement(s): [SQL: SELECT g_0.intkey, g_0.stringkey, g_0.floatnum, g_0.bytenum, (SELECT g_1.bytenum FROM smalla AS g_1 WHERE cast(g_1.bytenum AS bigint) = g_0.longnum AND g_1.intkey = 10) FROM smalla AS g_0] Sending error to client DEf6D1zaxo6u.14
{code}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 5 months