hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chris Bates <christopher.andrew.ba...@gmail.com>
Subject Key values not importing for SequenceFiles
Date Wed, 20 Oct 2010 21:38:53 GMT
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!

Mime
View raw message