hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hive QA (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-20826) Enhance HiveSemiJoin rule to convert join + group by on left side to Left Semi Join
Date Fri, 09 Nov 2018 01:44:00 GMT

    [ https://issues.apache.org/jira/browse/HIVE-20826?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16680716#comment-16680716
] 

Hive QA commented on HIVE-20826:
--------------------------------



Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12947307/HIVE-20826.3.patch

{color:red}ERROR:{color} -1 due to build exiting with an error

Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/14821/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/14821/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-14821/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Tests exited with: Exception: Patch URL https://issues.apache.org/jira/secure/attachment/12947307/HIVE-20826.3.patch
was found in seen patch url's cache and a test was probably run already on it. Aborting...
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12947307 - PreCommit-HIVE-Build

> Enhance HiveSemiJoin rule to convert join + group by on left side to Left Semi Join
> -----------------------------------------------------------------------------------
>
>                 Key: HIVE-20826
>                 URL: https://issues.apache.org/jira/browse/HIVE-20826
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: Vineet Garg
>            Assignee: Vineet Garg
>            Priority: Major
>         Attachments: HIVE-20826.1.patch, HIVE-20826.2.patch, HIVE-20826.3.patch
>
>
> Currently HiveSemiJoin rule looks for pattern where group by is on right side.
> We can convert joins which have group by on left side (assuming group by keys are same
as join keys and none of the columns are being projected from left side) to LEFT SEMI JOIN
by swapping the inputs. e.g. queries such as:
> {code:sql}
> explain select pp.p_partkey from (select distinct p_name from part) p join part pp on
pp.p_name = p.p_name;
> {code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message