Loading seq file into hive

[Mapred Learn <ma...@gmail.com>]

Hi,
I have seq files with key as line number and value is ctrl B delimited text.
a sample value is:
45454^B567^Brtrt^B-7.8
56577^B345^Bdrtd^B-0.9

when I create a table like:
create table temp_seq (no. int, code string, rank string, amt string)
row format delimited fields terminated by '\002' lines terminated by '\n'
stored as sequencefile;

It creates the table.

When I load a file as:

load data inpath '/tmp/test' into table temp_seq;

even this succeeds.

But when I try to select *, I don't see the fields that were loaded as
delmiited text and I see it separated as some weird boundaries and some
fields in text of seq file combined in select * output and rest all fields
at the end, coming as NULL, as follows:

 45454567  rtrt-7.8 NULL NULL
 56577345 drtd-0.9 NULL NULL.

how can I get this data to correspond to the exact fields in Seq File Values
output ?

Thanks in advance,
-JJ