[
https://issues.apache.org/jira/browse/HIVE-12607?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15045712#comment-15045712
]
Chaoyu Tang commented on HIVE-12607:
------------------------------------
It is the sequence file case of HIVE-7316, whose Arvo case has been resolved in
HIVE-11977. The 0-length sequence file misses the header which fails the
org.apache.hadoop.io.SequenceFile$Reader.
> Hive fails on zero length sequence files
> ----------------------------------------
>
> Key: HIVE-12607
> URL: https://issues.apache.org/jira/browse/HIVE-12607
> Project: Hive
> Issue Type: Bug
> Components: Serializers/Deserializers
> Affects Versions: 1.2.1
> Reporter: Chaoyu Tang
> Assignee: Chaoyu Tang
>
> Flume will, at times, generate zero length sequence files which cause the
> Hive query failure.
> To reproduce the issue:
> {code}
> > create external table test (id string)
> partitioned by (system string,date string)
> STORED AS SEQUENCEFILE
> LOCATION '/user/me/test';
> hadoop fs -mkdir /user/me/test/logs
> hadoop fs -mkdir /user/me/test/logs/date=2014
> hadoop fs -touchz /user/me/test/logs/date=2014/a.txt
> hive
> -> ALTER TABLE test ADD PARTITION (system = 'logs',date='2014') location
> '/user/me/test/logs/date=2014';
> -> select * from test t1,test t2 where t1.id = t2.id;
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
