You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "He Yongqiang (JIRA)" <ji...@apache.org> on 2009/08/07 06:03:14 UTC

[jira] Created: (HIVE-735) Queries should be optimized with pre-ordered column

Queries should be optimized with pre-ordered column
---------------------------------------------------

                 Key: HIVE-735
                 URL: https://issues.apache.org/jira/browse/HIVE-735
             Project: Hadoop Hive
          Issue Type: Improvement
          Components: Query Processor
            Reporter: He Yongqiang


If a table has one or some pre-ordered columns and a query has filters(range/point) on these columns. Hive should take advantage of the order information, and only read the needed blocks instead of touching the whole file.  And this will also be useful for sorted summary table index.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[jira] Commented: (HIVE-735) Queries should be optimized with pre-ordered column

Posted by "Namit Jain (JIRA)" <ji...@apache.org>.

    [ https://issues.apache.org/jira/browse/HIVE-735?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12740572#action_12740572 ] 

Namit Jain commented on HIVE-735:
---------------------------------

+1 on this idea - this should bring down the scan volume substantially

> Queries should be optimized with pre-ordered column
> ---------------------------------------------------
>
>                 Key: HIVE-735
>                 URL: https://issues.apache.org/jira/browse/HIVE-735
>             Project: Hadoop Hive
>          Issue Type: Improvement
>          Components: Query Processor
>            Reporter: He Yongqiang
>
> If a table has one or some pre-ordered columns and a query has filters(range/point) on these columns. Hive should take advantage of the order information, and only read the needed blocks instead of touching the whole file.  And this will also be useful for sorted summary table index.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.