[
https://issues.apache.org/jira/browse/HIVE-11401?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sergio Peña updated HIVE-11401:
-------------------------------
Attachment: HIVE-11401.1.patch
> Predicate push down does not work with Parquet when partitions are in the
> expression
> ------------------------------------------------------------------------------------
>
> Key: HIVE-11401
> URL: https://issues.apache.org/jira/browse/HIVE-11401
> Project: Hive
> Issue Type: Bug
> Affects Versions: 1.2.0
> Reporter: Sergio Peña
> Assignee: Sergio Peña
> Attachments: HIVE-11401.1.patch
>
>
> When filtering Parquet tables using a partition column, the query fails
> saying the column does not exist:
> {noformat}
> hive> create table part1 (id int, content string) partitioned by (p string)
> stored as parquet;
> hive> alter table part1 add partition (p='p1');
> hive> insert into table part1 partition (p='p1') values (1, 'a'), (2, 'b');
> hive> select id from part1 where p='p1';
> Failed with exception java.io.IOException:java.lang.IllegalArgumentException:
> Column [p] was not found in schema!
> Time taken: 0.151 seconds
> {noformat}
> It is correct that the partition column is not part of the Parquet schema.
> So, the fix should be to remove such expression from the Parquet PPD.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
