[ 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)