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 <sze...@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 <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 >> >> >
