[teiid-issues] [JBoss JIRA] (TEIID-4694) PrestoDB translator - NULL values not supported in SemiJoin
Steven Hawkins (JIRA)
issues at jboss.org
Wed Jan 11 11:14:00 EST 2017
[ https://issues.jboss.org/browse/TEIID-4694?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins reassigned TEIID-4694:
-------------------------------------
Fix Version/s: 9.2.1
Assignee: Kylin Soong (was: Steven Hawkins)
> PrestoDB translator - NULL values not supported in SemiJoin
> -----------------------------------------------------------
>
> Key: TEIID-4694
> URL: https://issues.jboss.org/browse/TEIID-4694
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.12.8.6_3
> Reporter: Juraj Duráni
> Assignee: Kylin Soong
> Fix For: 9.2.1
>
>
> PrestoDB does not allows NULL values in SemiJoin operator. It means, that query like \[1\] causes an exception \[2\]. However, this is disallowed in version 0.162 but worked in 0.161. According to GitHub issues \[3\], this will be fixed in one of the future versions of PrestoDB. Do we want to handle it somehow?
> Development and release frequency of PrestoDB seems to be pretty fast (new release every 2 or 3 week).
> {code:sql|title=\[1\] Query}
> SELECT IntKey, ShortValue FROM BQT1.SmallA WHERE BQT1.SmallA.ShortValue IN (SELECT ShortValue FROM BQT1.SmallB)
> {code}
> {code:plain|title=\[2\] Exception}
> org.teiid.jdbc.TeiidSQLException: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 Source: Unexpected exception while translating results: Query failed (#20170110_072908_00117_gftb8): NULL values are not allowed on the probe side of SemiJoin operator. See the query plan for details.
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135)
> ...
> Caused by: java.lang.RuntimeException: Remote com.facebook.presto.jdbc.internal.client.FailureInfo$FailureException: NULL values are not allowed on the probe side of SemiJoin operator. See the query plan for details.
> at com.facebook.presto.operator.HashSemiJoinOperator.addInput(HashSemiJoinOperator.java:179)
> at com.facebook.presto.operator.Driver.processInternal(Driver.java:384)
> at com.facebook.presto.operator.Driver.processFor(Driver.java:301)
> at com.facebook.presto.execution.SqlTaskExecution$DriverSplitRunner.processFor(SqlTaskExecution.java:622)
> at com.facebook.presto.execution.TaskExecutor$PrioritizedSplitRunner.process(TaskExecutor.java:534)
> at com.facebook.presto.execution.TaskExecutor$Runner.run(TaskExecutor.java:670)
> ... 3 more
> {code}
> \[3\] https://github.com/prestodb/presto/issues/6991
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
More information about the teiid-issues
mailing list