Return-Path: X-Original-To: apmail-hive-dev-archive@www.apache.org Delivered-To: apmail-hive-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id DF886DC54 for ; Mon, 8 Oct 2012 18:26:03 +0000 (UTC) Received: (qmail 18945 invoked by uid 500); 8 Oct 2012 18:26:03 -0000 Delivered-To: apmail-hive-dev-archive@hive.apache.org Received: (qmail 18885 invoked by uid 500); 8 Oct 2012 18:26:03 -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 18875 invoked by uid 500); 8 Oct 2012 18:26:03 -0000 Delivered-To: apmail-hadoop-hive-dev@hadoop.apache.org Received: (qmail 18872 invoked by uid 99); 8 Oct 2012 18:26:03 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 08 Oct 2012 18:26:03 +0000 Date: Mon, 8 Oct 2012 18:26:03 +0000 (UTC) From: "Namit Jain (JIRA)" To: hive-dev@hadoop.apache.org Message-ID: <243634076.9747.1349720763274.JavaMail.jiratomcat@arcas> In-Reply-To: <961586360.7926.1349680804741.JavaMail.jiratomcat@arcas> Subject: [jira] [Commented] (HIVE-3550) Early skipping for limit operator at reduce stage MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/HIVE-3550?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13471726#comment-13471726 ] Namit Jain commented on HIVE-3550: ---------------------------------- +1 > Early skipping for limit operator at reduce stage > ------------------------------------------------- > > Key: HIVE-3550 > URL: https://issues.apache.org/jira/browse/HIVE-3550 > Project: Hive > Issue Type: Improvement > Components: Query Processor > Reporter: Navis > Assignee: Navis > Priority: Trivial > Attachments: HIVE-3550.D5943.1.patch > > > Queries with limit clause whose final result is from reduce stage could not be early exited like map stage. But it seemed possible to just skip remaining lines. It can be accomplished by adding just two lines. Is there any reason we should not to do that? > {noformat} > select key from src order by key limit 10; > 1. current > ExtractOperator: 3 forwarded 500 rows > LimitOperator: 4 forwarded 10 rows > 2. early skipping > ExtractOperator: 3 forwarded 12 rows > LimitOperator: 4 forwarded 10 rows > {noformat} -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira