Fellow users,
I created the table as follows using the mapreduce output file CREATE EXTERNAL TABLE mytable ( word string, count int ) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS SEQUENCEFILE LOCATION 's3://mydata/'; This is what i have in my reduce method, key is of type Text * output.collect(key, new IntWritable(sum));* *The exception returned by Hive* ** *Failed with exception java.io.IOException:java.io.IOException: s3://mydata/part-00000 not a SequenceFile* *Thank you so much :)* On Tue, Mar 6, 2012 at 4:47 PM, Wei Shung Chung <weish...@gmail.com> wrote: > Hi users, > > I have a sequence file produced by mapreduce with TEXT, INTWRITABLE key > value pair...I tried to create a external hive table using the file but > hive can't read it. > > Thank you > > Sent from my iPhone
