hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Navis (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-2925) Support non-MR fetching for simple queries with select/limit/filter operations only
Date Mon, 07 Jul 2014 00:54:34 GMT

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

Navis commented on HIVE-2925:
-----------------------------

bq. What does RS mean?
Yes, it's ReduceSinkOperator, which needs a MR task to be evaluated, negating fetch task conversion.

bq. "LIMIT only" and "LIMIT only (TABLESAMPLE, virtual columns)" mean?
In 'minimal', it didn't allowed any virtual columns and sampling directives. But with 'more',
the optimizer can convert those, too.

bq. Does FILTER just mean the WHERE and HAVING clauses?
Yes, and yes. It's any form of predicates in the query. And uppercase would be better.

> Support non-MR fetching for simple queries with select/limit/filter operations only
> -----------------------------------------------------------------------------------
>
>                 Key: HIVE-2925
>                 URL: https://issues.apache.org/jira/browse/HIVE-2925
>             Project: Hive
>          Issue Type: Improvement
>    Affects Versions: 0.10.0
>            Reporter: Navis
>            Assignee: Navis
>            Priority: Trivial
>             Fix For: 0.10.0
>
>         Attachments: ASF.LICENSE.NOT.GRANTED--HIVE-2925.D2607.1.patch, ASF.LICENSE.NOT.GRANTED--HIVE-2925.D2607.2.patch,
ASF.LICENSE.NOT.GRANTED--HIVE-2925.D2607.3.patch, ASF.LICENSE.NOT.GRANTED--HIVE-2925.D2607.4.patch,
HIVE-2925.1.patch.txt, HIVE-2925.2.patch.txt, HIVE-2925.3.patch.txt
>
>
> It's trivial but frequently asked by end-users. Currently, select queries with simple
conditions or limit should run MR job which takes some time especially for big tables, making
the people irritated.
> For that kind of simple queries, using fetch task would make them happy.



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

Mime
View raw message