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! >