You can try 'STORED AS SEQUENCEFILE' when creating table. https://cwiki.apache.org/Hive/languagemanual-ddl.html#LanguageManualDDL-Create%252FDropTable
2012/7/10 Daning Wang <dan...@netseer.com> > Hi all, > > New to here. I have sequence files and I want to read in Hive, I did some > search on the net. looks the way I need to do > > 1. Write new FileInputFormat so Hive can read both key and value. > (ref http://osdir.com/ml/hive-user-hadoop-apache/2009-10/msg00034.html) > > 2. Write a SerDe to deserialize custom class data for key and value in > sequence file, I don't need serialize. > > Is this the right way to do? any simple way to do this? > > Thanks, > > Daning >