Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Thu, 31 Mar 2011 08:09:05 +0000 (UTC)
From: "Siying Dong (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Message-ID: 
 <788593166.23733.1301558945750.JavaMail.tomcat@hel.zones.apache.org>
In-Reply-To: 
 <408545978.2960.1300755965726.JavaMail.tomcat@hel.zones.apache.org>
Subject: [jira] [Updated] (HIVE-2068) Speed up query "select xx,xx from xxx
 LIMIT xxx" if no filtering or aggregation
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ https://issues.apache.org/jira/browse/HIVE-2068?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Siying Dong updated HIVE-2068:
------------------------------

    Attachment: HIVE-2068.3.patch

previous patch missed a file.

> Speed up query "select xx,xx from xxx LIMIT xxx" if no filtering or aggregation
> -------------------------------------------------------------------------------
>
>                 Key: HIVE-2068
>                 URL: https://issues.apache.org/jira/browse/HIVE-2068
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: Siying Dong
>            Assignee: Siying Dong
>         Attachments: HIVE-2068.1.patch, HIVE-2068.2.patch, HIVE-2068.3.patch
>
>
> Currently, "select xx,xx from xxx where ...(only partition conditions) LIMIT xxx" will start a MapReduce job with input to be the whole table or partition. The latency can be huge if the table or partition is big. We could reduce number of input files to speed up the queries.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira