You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Hive QA (JIRA)" <ji...@apache.org> on 2014/08/20 09:34:27 UTC

[jira] [Commented] (HIVE-7796) Provide subquery pushdown facility for storage handlers

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

Hive QA commented on HIVE-7796:
-------------------------------



{color:green}Overall{color}: +1 all checks pass

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

{color:green}SUCCESS:{color} +1 6008 tests passed

Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/416/testReport
Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/416/console
Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-416/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12662985

> Provide subquery pushdown facility for storage handlers
> -------------------------------------------------------
>
>                 Key: HIVE-7796
>                 URL: https://issues.apache.org/jira/browse/HIVE-7796
>             Project: Hive
>          Issue Type: Improvement
>          Components: StorageHandler
>            Reporter: Navis
>            Assignee: Navis
>            Priority: Minor
>         Attachments: HIVE-7796.1.patch.txt
>
>
> If underlying storage can handle basic filtering or aggregation, hive can delegate execution of whole subquery to the storage and handle it as a simple scanning operation.
> Experimentally implemented on JDBC / Phoenix handler and seemed working good. Hopefully open the code for those too, but it's not allowed to me yet.



--
This message was sent by Atlassian JIRA
(v6.2#6252)