I just found this thread and will be investigating this now: http://www.mail-archive.com/hive-u...@hadoop.apache.org/msg01701.html
On Wed, Oct 20, 2010 at 5:52 PM, Chris Bates < christopher.andrew.ba...@gmail.com> wrote: > Oh and we are using CDH2 which I believe is using version 0.4.1 > > > On Wed, Oct 20, 2010 at 5:38 PM, Chris Bates < > christopher.andrew.ba...@gmail.com> wrote: > >> Hi all, >> >> I've done a lot of research about this today, but haven't found the >> solution. I'm importing a bunch of sequencefiles that were created from >> Map/Reduce jobs into Hive tables, but the keys never get imported, just the >> values. >> >> This is my create table syntax: >> >> create external table Feeds (session string, uid string) >> row format delimited fields terminated by '\t' >> stored as sequencefile location >> 'hdfs://deepthought:54310/user/hadoop/analytics/feeduids'; >> >> This is my my result: >> hive> SELECT * FROM Feeds LIMIT 10; >> OK >> 5499002 NULL >> 5675164 NULL >> 1181378 NULL >> 5715167 NULL >> 4810496 NULL >> 4836203 NULL >> 5720872 NULL >> 5674835 NULL >> 5674835 NULL >> 5587007 NULL >> >> The numbers are uids which should be the second column where the NULL >> values are. The Key and Value are both type Text. >> >> Would appreciate any help! >> > >
