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)

Reply via email to