Return-Path: Delivered-To: apmail-hive-dev-archive@www.apache.org Received: (qmail 32715 invoked from network); 17 Apr 2011 10:28:46 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 17 Apr 2011 10:28:46 -0000 Received: (qmail 17517 invoked by uid 500); 17 Apr 2011 10:28:46 -0000 Delivered-To: apmail-hive-dev-archive@hive.apache.org Received: (qmail 17444 invoked by uid 500); 17 Apr 2011 10:28:46 -0000 Mailing-List: contact dev-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hive.apache.org Delivered-To: mailing list dev@hive.apache.org Received: (qmail 17283 invoked by uid 500); 17 Apr 2011 10:28:45 -0000 Delivered-To: apmail-hadoop-hive-dev@hadoop.apache.org Received: (qmail 17250 invoked by uid 99); 17 Apr 2011 10:28:45 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 17 Apr 2011 10:28:45 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED,T_RP_MATCHES_RCVD X-Spam-Check-By: apache.org Received: from [140.211.11.116] (HELO hel.zones.apache.org) (140.211.11.116) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 17 Apr 2011 10:28:43 +0000 Received: from hel.zones.apache.org (hel.zones.apache.org [140.211.11.116]) by hel.zones.apache.org (Postfix) with ESMTP id C3D7AA5F40 for ; Sun, 17 Apr 2011 10:28:05 +0000 (UTC) Date: Sun, 17 Apr 2011 10:28:05 +0000 (UTC) From: "Namit Jain (JIRA)" To: hive-dev@hadoop.apache.org Message-ID: <567617763.63075.1303036085799.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 X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/HIVE-2068?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-2068: ----------------------------- Status: Open (was: Patch Available) > 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, HIVE-2068.4.patch, HIVE-2068.5.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