Hi, I have a mapred that ends with an IntSumReducer that produces a SequenceFile<TextFormat, IntWritable> .
I tried to create an external table over the sequence files with the following statement is : CREATE EXTERNAL TABLE IF NOT EXISTS foo(key string, value int) STORED AS SEQUENCE FILE LOCATION '/tmp/output' ; but I get this error : Failed with exception java.io.IOException:org.apache.hadoop.hive.serde2.SerDeException: class org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe: expects either BytesWritable or Text object! The sequence file is valid : I can read it with Pig ou "hadoop fs -text" . Does anyone has the correct syntax to create the external table ? Regards, Laurent
