You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Prasad Chakka (JIRA)" <ji...@apache.org> on 2009/05/20 02:57:45 UTC

[jira] Updated: (HIVE-497) predicate pushdown fails if all columns are not selected

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

Prasad Chakka updated HIVE-497:
-------------------------------

    Assignee: Prasad Chakka
      Status: Patch Available  (was: Open)

The select operator created by ColumnPruner doesn't have the map of output column to input column names so the code is asserting as expected. Added this map for ColumnPruner as well.

> predicate pushdown fails if all columns are not selected
> --------------------------------------------------------
>
>                 Key: HIVE-497
>                 URL: https://issues.apache.org/jira/browse/HIVE-497
>             Project: Hadoop Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.4.0
>            Reporter: Prasad Chakka
>            Assignee: Prasad Chakka
>             Fix For: 0.4.0
>
>         Attachments: hive-497.patch
>
>
> predicate pushdown seems to fail in some scenarios... it is ok if all the columns are selected.
> create table ppda(a string, b string);
> select a from ppda where ppda.a > 10; --> fails
> select b from ppda where ppda.a > 10; --> ok
> select * from ppda where ppda.a > 10; --> ok
> select b from appd where appd.b > 10 and appd.a > 20; --> ok

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