[HIVE-11977] Hive should handle an external avro table with zero length files present

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.14.0, 1.0.0, 1.2.0, 1.1.0, 1.2.1
• Fix Version/s: 2.0.0
• Component/s: Serializers/Deserializers
• Target Version/s: 1.3.0
• Assignee: Aaron Dossett
• Reporter: Aaron Dossett
• Created: 28/Sep/15 18:25
• Updated: 04/Apr/18 08:16
• Resolved: 07/Oct/15 16:26

Description

If a zero length file is in the top level directory housing an external avro table, all hive queries on the table fail.

This issue is that org.apache.hadoop.hive.ql.io.avro.AvroGenericRecordReader creates a new org.apache.avro.file.DataFileReader and DataFileReader throws an exception when trying to read an empty file (because the empty file lacks the magic number marking it as avro).

AvroGenericRecordReader should detect an empty file and then behave reasonably.

Caused by: java.io.IOException: Not a data file.
at org.apache.avro.file.DataFileStream.initialize(DataFileStream.java:102)
at org.apache.avro.file.DataFileReader.<init>(DataFileReader.java:97)
at org.apache.hadoop.hive.ql.io.avro.AvroGenericRecordReader.<init>(AvroGenericRecordReader.java:81)
at org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat.getRecordReader(AvroContainerInputFormat.java:51)
at org.apache.hadoop.hive.ql.io.HiveInputFormat.getRecordReader(HiveInputFormat.java:246)
... 25 more

Issue Links

• duplicates: HIVE-7316 Hive fails on zero length files
• relates to: HIVE-12607 Hive fails on zero length sequence files
• relates to: AVRO-1530 Java DataFileStream does not allow distinguishing between empty files and corrupt files