hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Siying Dong (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-2068) Speed up query "select xx,xx from xxx LIMIT xxx" if no filtering or aggregation
Date Tue, 22 Mar 2011 01:06:05 GMT
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


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

Mime
View raw message