If the table already exists, then CREATE TABLE IF NOT EXISTS is a noop.
Drop the table first and then create initially with the COMPRESSION='SNAPPY'
property.
Thanks,
James
On Wed, Jul 2, 2014 at 11:29 AM, puneet <puneet.ku...@pubmatic.com> wrote:
> Hi Team,
>
> I need snappy compression to be used for the Hbase table but it is not
> creating the table as SNAPPY compressed when I look through the DDL's in
> the Hbase shell.
>
> Also while loading the data the size of the data remains the same for
> SNAPPY or NONE.
>
> Please help if I am missing anything.
>
> Details Below:-
>
> CREATE TABLE IF NOT EXISTS adv_cat (
> cat varchar ,
> domain VARCHAR
> CONSTRAINT PK PRIMARY KEY (cat,domain)
> );
>
> DDL:- describe 'ADV_CAT_GZ'
> DESCRIPTION ENABLED
> 'ADV_CAT_GZ', {METHOD => 'table_att', coprocessor$1 =>
> '|org.apache.phoenix.coprocessor.ScanRegionObser true
> ver|1|', coprocessor$2 =>
> '|org.apache.phoenix.coprocessor.UngroupedAggregateRegionObserver|1|',
> coproc
> essor$3 =>
> '|org.apache.phoenix.coprocessor.GroupedAggregateRegionObserver|1|',
> coprocessor$4 => '|org.
> apache.phoenix.coprocessor.ServerCachingEndpointImpl|1|', coprocessor$5
> => '|org.apache.phoenix.hbase.i
>
> ndex.Indexer|1073741823|index.builder=org.apache.phoenix.index.PhoenixIndexBuilder,org.apache.hadoop.hb
>
> ase.index.codec.class=org.apache.phoenix.index.PhoenixIndexCodec'}, {NAME
> => '0', DATA_BLOCK_ENCODING =
> > 'FAST_DIFF', BLOOMFILTER => 'NONE', REPLICATION_SCOPE => '0', VERSIONS
> => '3', COMPRESSION => 'NONE',
> MIN_VERSIONS => '0', TTL => '2147483647', KEEP_DELETED_CELLS => 'true',
> BLOCKSIZE => '65536', IN_MEMOR
> Y => 'false', ENCODE_ON_DISK => 'true', BLOCKCACHE => 'true'}
>
>
> CREATE TABLE IF NOT EXISTS adv_cat_snappy (
> cat varchar ,
> domain VARCHAR
> CONSTRAINT PK PRIMARY KEY (cat,domain)
> ) COMPRESSION='SNAPPY';
>
> describe 'ADV_CAT_SNAPPY'
> DESCRIPTION ENABLED
> 'ADV_CAT_SNAPPY', {METHOD => 'table_att', coprocessor$1 =>
> '|org.apache.phoenix.coprocessor.ScanRegionO true
> bserver|1|', coprocessor$2 =>
> '|org.apache.phoenix.coprocessor.UngroupedAggregateRegionObserver|1|', co
> processor$3 =>
> '|org.apache.phoenix.coprocessor.GroupedAggregateRegionObserver|1|',
> coprocessor$4 => '|
> org.apache.phoenix.coprocessor.ServerCachingEndpointImpl|1|',
> coprocessor$5 => '|org.apache.phoenix.hba
>
> se.index.Indexer|1073741823|index.builder=org.apache.phoenix.index.PhoenixIndexBuilder,org.apache.hadoo
>
> p.hbase.index.codec.class=org.apache.phoenix.index.PhoenixIndexCodec'},
> {NAME => '0', DATA_BLOCK_ENCODI
> NG => 'FAST_DIFF', BLOOMFILTER => 'NONE', REPLICATION_SCOPE => '0',
> VERSIONS => '3', COMPRESSION => 'NO
> NE', MIN_VERSIONS => '0', TTL => '2147483647', KEEP_DELETED_CELLS =>
> 'true', BLOCKSIZE => '65536', IN_M
> EMORY => 'false', ENCODE_ON_DISK => 'true', BLOCKCACHE => 'true'}
> 1 row(s) in 0.0660 seconds
>
> --
> ------------------------------
>
> *Puneet Ojha* | Tech Lead: Data Analytics
> 6th Floor, Amar Paradigm | Baner Road, Pune 411045
> o: +91-20-67285700 | m: +91-8605359898 | Skype: puneetkr.ojha
>
> [image: PubMatic]
> <http://www.pubmatic.com/index-eng.php?utm_source=Footer&utm_medium=Email&utm_content=PuneLogo&utm_campaign=Corporate>
> Every ad. Every sales channel. Every screen. *One platform*
>
> On the Web: [image: Facebook]
> <http://www.pubmatic.com/social/facebook.php?utm_source=Footer&utm_medium=Email&utm_content=PuneFacebook&utm_campaign=Corporate>
> [image:
> Twitter]
> <http://www.pubmatic.com/social/twitter.php?utm_source=Footer&utm_medium=Email&utm_content=PuneTwitter&utm_campaign=Corporate>
> [image:
> LinkedIn]
> <http://www.pubmatic.com/social/linkedin.php?utm_source=Footer&utm_medium=Email&utm_content=PuneLinkedIn&utm_campaign=Corporate>
>
> Find out more about our services: PubConnect
> <http://www.pubmatic.com/pubconnect.php?utm_source=Footer&utm_medium=Email&utm_content=PunePubConnect&utm_campaign=Corporate>
> | PubDirect
> <http://www.pubmatic.com/pubdirect.php?utm_source=Footer&utm_medium=Email&utm_content=PunePubDirect&utm_campaign=Corporate>
> | Solutions for Media Buyers
> <http://www.pubmatic.com/media-buyers-overview.php?utm_source=Footer&utm_medium=Email&utm_content=PuneMediaBuyers&utm_campaign=Corporate>
> What's New: PubMatic Launches Mobile SDK for app developers.
> <http://www.pubmatic.com/press/2013/PubMatic-Launches-Self-Service-Open-SDK.php?utm_source=Footer&utm_medium=Email&utm_content=PuneSDKLink&utm_campaign=Corporate>
> Latest Research: Real-Time Bidding in the United States and Worldwide,
> 2010-2017 (Q4 2013)
> <http://www.pubmatic.com/reports-and-whitepapers.php?utm_source=Footer&utm_medium=Email&utm_content=PuneReportsLink&utm_campaign=Corporate>
> Recent Videos: Ad Revenue 6
> <http://www.pubmatic.com/ar6_videos.php?utm_source=Footer&utm_medium=Email&utm_content=NYCAR6Link&utm_campaign=Corporate>
> | Ad Revenue Europe
> <http://www.pubmatic.com/arE_videos.php?utm_source=Footer&utm_medium=Email&utm_content=NYCAR6Link&utm_campaign=Corporate>
>
