Sergio Peña created HIVE-11401:
----------------------------------
Summary: 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
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)
