Hi, did you try specifying row, field delimiter on create table ? Thanks Szehon
On Fri, Mar 7, 2014 at 5:27 PM, Kim Chew <kchew...@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 > >
