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!
