hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kim Chew <kchew...@gmail.com>
Subject Re: data get truncated.
Date Sat, 08 Mar 2014 09:29:18 GMT
No, I haven't. Let me try putting a delimiter between rows, thanks.

Kim


On Fri, Mar 7, 2014 at 5:53 PM, Szehon Ho <szehon@cloudera.com> wrote:

> Hi, did you try specifying row, field delimiter on create table ?
>
> Thanks
> Szehon
>
>
>
> On Fri, Mar 7, 2014 at 5:27 PM, Kim Chew <kchew534@gmail.com> wrote:
>
>> I have an input file in Sequence File format which has the format,
>>      <length of value><value>
>> which has the type <IntWritable><Text>
>>
>> Then I created a table,
>>
>> CREATE TABLE if not exists TEST (
>>     value string)
>> STORED AS SEQUENCEFILE;
>>
>> and then I load the input file to the table. However when I do a query,
>>
>> select value from TEST;
>>
>> I found that 'value is truncated. For example, the value in my input file
>> is
>>
>>
>> 14031|11748184969223627771|172.31.2.71|0|sta1|1365546305|976912181|10.196.121.204|172.26.4.10|HTTP|NURL|0|1|1|-420|1|PST|PDT|
>>
>> what returned from the query is,
>>
>> 031|11748184969223627771|172.31.2.71|0|sta1|13655463
>>
>> What went wrong?
>>
>> TIA
>>
>> Kim
>>
>>
>

Mime
View raw message