[jira] [Created] (HIVE-20970) ORC table with bloom filter fails on PPD query

["Gabriel C Balan (JIRA)" <ji...@apache.org>]

Gabriel C Balan created HIVE-20970:
--------------------------------------

             Summary: ORC table with bloom filter fails on PPD query
                 Key: HIVE-20970
                 URL: https://issues.apache.org/jira/browse/HIVE-20970
             Project: Hive
          Issue Type: Bug
          Components: File Formats, Hive, ORC
    Affects Versions: 2.1.0
            Reporter: Gabriel C Balan


I encountered this issue in hive2.1.0-cdh6.0.0.
{noformat:title=Reproducer}
drop table if exists t1;

create table t1(c1 string, c2 int) stored as orc
TBLPROPERTIES ("orc.compress"="NONE", 
               "orc.bloom.filter.columns"="c2");


INSERT INTO TABLE t1 VALUES ("row 1", 1), ("row 2", 2), ("row 3", 3);

--this works fine
set hive.optimize.index.filter=false;
select * from t1 where c2=2;

--this fails
set hive.optimize.index.filter=true;
select * from t1 where c2=2;
{noformat}
These three items are essential to reproducing the issue:
 # hive.optimize.index.filter=true;
 # "orc.compress"="NONE" in TBLPROPERTIES
 # "orc.bloom.filter.columns"="c2" in TBLPROPERTIES

That is, if any of the above mentioned items are taken out, the query will not fail anymore.

Finally, here is the stack: 
{noformat:title=Stack trace in log4j file}
java.io.IOException: java.lang.IllegalStateException: InputStream#read(byte[]) returned invalid result: 0
The InputStream implementation is buggy.
        at org.apache.hadoop.hive.ql.exec.FetchOperator.getNextRow(FetchOperator.java:521)
        at org.apache.hadoop.hive.ql.exec.FetchOperator.pushRow(FetchOperator.java:428)
        at org.apache.hadoop.hive.ql.exec.FetchTask.fetch(FetchTask.java:146)
        at org.apache.hadoop.hive.ql.Driver.getResults(Driver.java:2188)
        at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:259)
        at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:187)
        at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:409)
        at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:838)
        at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:774)
        at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:701)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:483)
        at org.apache.hadoop.util.RunJar.run(RunJar.java:313)
        at org.apache.hadoop.util.RunJar.main(RunJar.java:227)
Caused by: java.lang.IllegalStateException: InputStream#read(byte[]) returned invalid result: 0
The InputStream implementation is buggy.
        at com.google.protobuf.CodedInputStream.refillBuffer(CodedInputStream.java:739)
        at com.google.protobuf.CodedInputStream.isAtEnd(CodedInputStream.java:701)
        at com.google.protobuf.CodedInputStream.readTag(CodedInputStream.java:99)
        at org.apache.orc.OrcProto$RowIndex.<init>(OrcProto.java:7429)
        at org.apache.orc.OrcProto$RowIndex.<init>(OrcProto.java:7393)
        at org.apache.orc.OrcProto$RowIndex$1.parsePartialFrom(OrcProto.java:7482)
        at org.apache.orc.OrcProto$RowIndex$1.parsePartialFrom(OrcProto.java:7477)
        at com.google.protobuf.AbstractParser.parsePartialFrom(AbstractParser.java:200)
        at com.google.protobuf.AbstractParser.parseFrom(AbstractParser.java:217)
        at com.google.protobuf.AbstractParser.parseFrom(AbstractParser.java:223)
        at com.google.protobuf.AbstractParser.parseFrom(AbstractParser.java:49)
        at org.apache.orc.OrcProto$RowIndex.parseFrom(OrcProto.java:7593)
        at org.apache.orc.impl.RecordReaderUtils$DefaultDataReader.readRowIndex(RecordReaderUtils.java:138)
        at org.apache.orc.impl.RecordReaderImpl.readRowIndex(RecordReaderImpl.java:1151)
        at org.apache.orc.impl.RecordReaderImpl.readRowIndex(RecordReaderImpl.java:1134)
        at org.apache.orc.impl.RecordReaderImpl.pickRowGroups(RecordReaderImpl.java:800)
        at org.apache.orc.impl.RecordReaderImpl.readStripe(RecordReaderImpl.java:830)
        at org.apache.orc.impl.RecordReaderImpl.advanceStripe(RecordReaderImpl.java:986)
        at org.apache.orc.impl.RecordReaderImpl.advanceToNextRow(RecordReaderImpl.java:1021)
        at org.apache.orc.impl.RecordReaderImpl.<init>(RecordReaderImpl.java:215)
        at org.apache.hadoop.hive.ql.io.orc.RecordReaderImpl.<init>(RecordReaderImpl.java:63)
        at org.apache.hadoop.hive.ql.io.orc.ReaderImpl.rowsOptions(ReaderImpl.java:87)
        at org.apache.hadoop.hive.ql.io.orc.OrcInputFormat.createReaderFromFile(OrcInputFormat.java:314)
        at org.apache.hadoop.hive.ql.io.orc.OrcInputFormat$OrcRecordReader.<init>(OrcInputFormat.java:225)
        at org.apache.hadoop.hive.ql.io.orc.OrcInputFormat.getRecordReader(OrcInputFormat.java:1691)
        at org.apache.hadoop.hive.ql.exec.FetchOperator$FetchInputFormatSplit.getRecordReader(FetchOperator.java:695)
        at org.apache.hadoop.hive.ql.exec.FetchOperator.getRecordReader(FetchOperator.java:333)
        at org.apache.hadoop.hive.ql.exec.FetchOperator.getNextRow(FetchOperator.java:459)
        ... 15 more
{noformat}
 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)