hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ferdinand Xu (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-17261) Hive use deprecated ParquetInputSplit constructor which blocked parquet dictionary filter
Date Fri, 15 Sep 2017 06:36:00 GMT

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

Ferdinand Xu commented on HIVE-17261:
-------------------------------------

Thanks [~junjie] for the investigation. Hive should cast constant in the filter as char 10
in this case. You can see the following table schema for table newtypestbl.

{noformat}
create table newtypestbl(c char(10), v varchar(10), d decimal(5,3), da date) stored as parquet;
{noformat}


> Hive use deprecated ParquetInputSplit constructor which blocked parquet dictionary filter
> -----------------------------------------------------------------------------------------
>
>                 Key: HIVE-17261
>                 URL: https://issues.apache.org/jira/browse/HIVE-17261
>             Project: Hive
>          Issue Type: Improvement
>          Components: Database/Schema
>    Affects Versions: 2.2.0
>            Reporter: Junjie Chen
>            Assignee: Junjie Chen
>             Fix For: 3.0.0
>
>         Attachments: HIVE-17261.10.patch, HIVE-17261.11.patch, HIVE-17261.2.patch, HIVE-17261.3.patch,
HIVE-17261.4.patch, HIVE-17261.5.patch, HIVE-17261.6.patch, HIVE-17261.7.patch, HIVE-17261.8.patch,
HIVE-17261.diff, HIVE-17261.patch
>
>
> Hive use deprecated ParquetInputSplit in [https://github.com/apache/hive/blob/master/ql/src/java/org/apache/hadoop/hive/ql/io/parquet/ParquetRecordReaderBase.java#L128]
> Please see interface definition in [https://github.com/apache/parquet-mr/blob/master/parquet-hadoop/src/main/java/org/apache/parquet/hadoop/ParquetInputSplit.java#L80]
> Old interface set rowgroupoffset values which will lead to skip dictionary filter in
parquet.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message