Chaoyu Tang created HIVE-12607: ---------------------------------- Summary: 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)