hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Techy Teck <comptechge...@gmail.com>
Subject Difference between storing data as a TextFile and SequenceFile
Date Wed, 01 Aug 2012 18:32:14 GMT
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

Mime
View raw message