You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Jesus Camacho Rodriguez (JIRA)" <ji...@apache.org> on 2015/04/20 22:55:58 UTC
[jira] [Comment Edited] (CALCITE-688) splitCondition does not
behave correctly when one side of the condition references columns from
different inputs
[ https://issues.apache.org/jira/browse/CALCITE-688?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14503591#comment-14503591 ]
Jesus Camacho Rodriguez edited comment on CALCITE-688 at 4/20/15 8:55 PM:
--------------------------------------------------------------------------
[~julianhyde], no worries, HIVE-10388 solved the problem in the Hive side. Once we get a new Calcite release, I will change that code to point to the fixed method in Calcite.
About the fix in Calcite, I will rewrite it following your advice.
The following query was the one that was causing the problem in Hive:
{noformat}
SELECT src1.key, src3.value
FROM src src1 JOIN src src2 ON (src1.key = src2.key) JOIN src src3 ON (src1.key + src2.key = src3.key);
{noformat}
was (Author: jcamachorodriguez):
[~julianhyde], no worries, HIVE-10388 solved the problem in the Hive side. Once we get a new Calcite release, I will change that code to point to the fixed method in Calcite.
About the fix in Calcite, I rewrite it following your advice.
The following query was the one that was causing the problem in Hive:
{noformat}
SELECT src1.key, src3.value
FROM src src1 JOIN src src2 ON (src1.key = src2.key) JOIN src src3 ON (src1.key + src2.key = src3.key);
{noformat}
> splitCondition does not behave correctly when one side of the condition references columns from different inputs
> ----------------------------------------------------------------------------------------------------------------
>
> Key: CALCITE-688
> URL: https://issues.apache.org/jira/browse/CALCITE-688
> Project: Calcite
> Issue Type: Bug
> Reporter: Jesus Camacho Rodriguez
> Assignee: Jesus Camacho Rodriguez
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)