Re: Sequence file compression in Hive

2013-06-10 Thread tofunmibabatunde
Unsubscribe Sent from my BlackBerry® wireless handheld from Glo Mobile. -Original Message- From: Alexander Pivovarov Date: Mon, 10 Jun 2013 11:37:30 To: Reply-To: user@hive.apache.org Subject: Re: Sequence file compression in Hive Sachin, it works SET hive.exec.compress.output=true

Re: Sequence file compression in Hive

2013-06-10 Thread Alexander Pivovarov
Sachin, it works SET hive.exec.compress.output=true; SET mapred.output.compression.codec=org.apache.hadoop.io.compress.GzipCodec; SET mapred.output.compression.type=BLOCK; create table data1_seq STORED AS SEQUENCEFILE as select * from date1; hadoop fs -cat /user/hive/warehouse/data1_seq/00_0

Re: Sequence file compression in Hive

2013-06-10 Thread Alexander Pivovarov
Sachin, it works SET hive.exec.compress.output=true; SET mapred.output.compression.codec=org.apache.hadoop.io.compress.GzipCodec; SET mapred.output.compression.type=BLOCK; create table data1_seq STORED AS SEQUENCEFILE as select * from date1; hadoop fs -cat /user/hive/warehouse/data1_seq/00_0

Re: Sequence file compression in Hive

2013-06-10 Thread Stephen Sprague
On Mon, Jun 10, 2013 at 12:48 AM, Sachin Sudarshana wrote: what's the header of the first sequence file look like? *$ dfs -cat /user/hive/warehouse/facts_520.db/test3facts520_gzip_seq/00_0 | head *