Difference between storing data as a TextFile and SequenceFile

[Techy Teck <co...@gmail.com>]

What is the difference between storing the data as a TextFile and
SequenceFile? And which will be faster while doing Hive queries.

I am creating a table like this-

create table quality
( id bigint,
  total_chkout bigint,
  total_errpds bigint
 )
 partitioned by (ds string)
row format delimited fields terminated by '\t'
stored as textfile
location '/user/uname/quality';

And I am storing the data as a TextFile format. So storing the data in
TextFile will be good or storing the data in SequenceFile (LZO compression)
will be good? So that when I am doing hive queries it is fast enough.Differe