If u have a file of this type already - loading it into Hive is trivial. - create table xxx (<schema>) ... stored as sequencefile - load data infile yyy into table xxx
assuming yyy is already in hdfs. See the wiki for additional create table documentation: http://wiki.apache.org/hadoop/Hive/UserGuide , http://wiki.apache.org/hadoop/Hive/HiveQL ________________________________ From: Jeremy Chow [mailto:coderp...@gmail.com] Sent: Monday, January 12, 2009 1:20 AM To: hive-user@hadoop.apache.org Subject: Can hive load a table from a SequenceFile? hi list, Let's assume that we have a SequenceFile with a format like this, <LongWritable key, Text value>. All of the keys will discard when loading into a hive table. Each value, which is delimited by tabs, will be transformed into a row of a hive table. Can hive load a table from this kind of files? How can I implement it ? Thanks, Jeremy -- My research interests are distributed systems, parallel computing and bytecode based virtual machine. http://coderplay.javaeye.com
