You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Lefty Leverenz (JIRA)" <ji...@apache.org> on 2014/08/02 04:45:39 UTC
[jira] [Commented] (HIVE-2925) Support non-MR fetching for simple
queries with select/limit/filter operations only
[ https://issues.apache.org/jira/browse/HIVE-2925?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14083303#comment-14083303 ]
Lefty Leverenz commented on HIVE-2925:
--------------------------------------
Thanks [~navis]. I revised the description of *hive.fetch.task.conversion* in the wiki, keeping it as close as possible to the original since that's what appears in HiveConf.java and the template file.
But I have one more question: in the description of "more" does "SELECT" imply "SELECT *"?
bq. 2. more: SELECT, FILTER, LIMIT only (including TABLESAMPLE, virtual columns)
* [ConfigurationProperties -- hive.fetch.task.conversion | https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-hive.fetch.task.conversion]
> 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)