[
https://issues.apache.org/jira/browse/HIVE-11035?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14591293#comment-14591293
]
Gopal V commented on HIVE-11035:
--------------------------------
Needs ETL strategy to skip entire splits.
Patch LGTM - +1.
> PPD: Orc Split elimination fails because filterColumns=[-1]
> -----------------------------------------------------------
>
> Key: HIVE-11035
> URL: https://issues.apache.org/jira/browse/HIVE-11035
> Project: Hive
> Issue Type: Bug
> Affects Versions: 0.14.0, 1.0.0, 1.2.0, 1.1.0, 1.3.0, 2.0.0
> Reporter: Gopal V
> Assignee: Prasanth Jayachandran
> Attachments: HIVE-11035.patch
>
>
> {code}
> create temporary table xx (x int) stored as orc ;
> insert into xx values (20),(200);
> set hive.fetch.task.conversion=none;
> select * from xx where x is null;
> {code}
> This should generate zero tasks after optional split elimination in the app
> master, instead of generating the 1 task which for sure hits the row-index
> filters and removes all rows anyway.
> Right now, this runs 1 task for the stripe containing (min=20, max=200,
> has_null=false), which is broken.
> Instead, it returns YES_NO_NULL from the following default case
> https://github.com/apache/hive/blob/master/ql/src/java/org/apache/hadoop/hive/ql/io/orc/OrcInputFormat.java#L976
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
