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 Re: Key values not importing for SequenceFiles
Date Wed, 20 Oct 2010 22:03:27 GMT
I just found this thread and will be investigating this now:
http://www.mail-archive.com/hive-user@hadoop.apache.org/msg01701.html

On Wed, Oct 20, 2010 at 5:52 PM, Chris Bates <
christopher.andrew.bates@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.bates@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!
>>
>
>

Mime
View raw message