data get truncated.

[Kim Chew]

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