Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id A9014D349 for ; Thu, 15 Nov 2012 14:06:03 +0000 (UTC) Received: (qmail 3513 invoked by uid 500); 15 Nov 2012 14:06:01 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 3051 invoked by uid 500); 15 Nov 2012 14:05:56 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 3019 invoked by uid 99); 15 Nov 2012 14:05:54 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 15 Nov 2012 14:05:54 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of arodrime@gmail.com designates 209.85.212.44 as permitted sender) Received: from [209.85.212.44] (HELO mail-vb0-f44.google.com) (209.85.212.44) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 15 Nov 2012 14:05:47 +0000 Received: by mail-vb0-f44.google.com with SMTP id fc26so1830892vbb.31 for ; Thu, 15 Nov 2012 06:05:26 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type; bh=TkvxBwC6kZgj6hsnBKofgdInjG0zySlp1CwPPdmeNpI=; b=PaEySqf+02rV2gh2U42dunKvLQijLpI9N+wltNGLRBByjzMw1gO2bLoF98yDrqBymY +OT4xPls3hdHstKXNb+iT/YQ+6Niw5dxgydiJ/OZuYxv6Z4FVa5l3vQm5M6j0w+yZQNE rhS/3W+0lFnoQGlEAzrvSwO5kBCQMqGgbMsyi4X1XzpOXaVvBHX960h5qCfcVBMdT9OH mfj9cUypjATg10CiGgzsoBrGFjOs7cLO/wiTv2VxpD2HnUM+p5667Z+ATUSe5yk45b7m 1j4+j3wJ1pD9QkYkYbPgTigUMA4WygOR8IL0ymgem0sQm1x6nmkvNUnhWHdg+FcgDTHQ pc4g== Received: by 10.220.153.212 with SMTP id l20mr1484529vcw.1.1352988326638; Thu, 15 Nov 2012 06:05:26 -0800 (PST) MIME-Version: 1.0 Received: by 10.220.249.3 with HTTP; Thu, 15 Nov 2012 06:05:06 -0800 (PST) In-Reply-To: References: From: Alain RODRIGUEZ Date: Thu, 15 Nov 2012 15:05:06 +0100 Message-ID: Subject: Re: Enable compression Cassandra 1.1.2 To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=f46d04339cde9834b804ce8924b3 X-Virus-Checked: Checked by ClamAV on apache.org --f46d04339cde9834b804ce8924b3 Content-Type: text/plain; charset=ISO-8859-1 We just upgrade to C* 1.1.6 We can now change anything using the CLI or cqlsh. So problem solved. 2012/11/14 Alain RODRIGUEZ > Oh! That's obviously the exact same issue. I didn't find this thread while > searching about my issue. > > We will upgrade. > > Thanks for the link. > > > 2012/11/14 aaron morton > >> May be https://issues.apache.org/jira/browse/CASSANDRA-4561 >> >> Can you upgrade to 1.1.6 ? >> >> Cheers >> >> ----------------- >> Aaron Morton >> Freelance Cassandra Developer >> New Zealand >> >> @aaronmorton >> http://www.thelastpickle.com >> >> On 14/11/2012, at 11:39 PM, Alain RODRIGUEZ wrote: >> >> Hi, I am running C* 1.1.2 and there is no way to turn the compression on >> for a CF. >> >> Here is the command I ran in the CLI: >> >> UPDATE COLUMN FAMILY data_action WITH >> compression_options={sstable_compression:SnappyCompressor, chunk_length_kb >> : 64}; >> >> Show schema : >> >> create column family data_action >> with column_type = 'Standard' >> and comparator = 'UTF8Type' >> and default_validation_class = 'UTF8Type' >> and key_validation_class = 'UTF8Type' >> and read_repair_chance = 1.0 >> and dclocal_read_repair_chance = 0.0 >> and gc_grace = 864000 >> and min_compaction_threshold = 4 >> and max_compaction_threshold = 32 >> and replicate_on_write = true >> and compaction_strategy = >> 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy' >> and caching = 'KEYS_ONLY'; >> >> I tried also through cqlsh without success ("ALTER TABLE data_action WITH >> compression_parameters:sstable_compression = 'SnappyCompressor' AND >> compression_parameters:chunk_length_kb = 64;") >> >> I have no error message just these few lines on system.log: >> >> INFO 10:17:12,051 Completed flushing >> /raid0/cassandra/data/system/schema_columnfamilies/system-schema_columnfamilies-hd-20-Data.db >> (1367 bytes) for commitlog position >> ReplayPosition(segmentId=721932060965088, position=116556860) >> INFO 10:17:12,052 Compacting >> [SSTableReader(path='/raid0/cassandra/data/system/schema_columnfamilies/system-schema_columnfamilies-hd-20-Data.db'), >> SSTableReader(path='/raid0/cassandra/data/system/schema_columnfamilies/system-schema_columnfamilies-hd-19-Data.db'), >> SSTableReader(path='/raid0/cassandra/data/system/schema_columnfamilies/system-schema_columnfamilies-hd-17-Data.db'), >> SSTableReader(path='/raid0/cassandra/data/system/schema_columnfamilies/system-schema_columnfamilies-hd-18-Data.db')] >> INFO 10:17:12,134 Compacted to >> [/raid0/cassandra/data/system/schema_columnfamilies/system-schema_columnfamilies-hd-21-Data.db,]. >> 50,928 to 46,827 (~91% of original) bytes for 3 keys at 0.544606MB/s. >> Time: 82ms. >> >> I also tried upgrading sstables but compression is definitely not enabled >> (same size of data + JMX show a CompressionRatio of 0.0). >> >> Does anyone already saw something similar ? >> >> Alain >> >> >> > --f46d04339cde9834b804ce8924b3 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
We just upgrade to C* 1.1.6

We can now change anyt= hing using the CLI or cqlsh. So problem solved.
<= br>
2012/11/14 Alain RODRIGUEZ <arodrime@gm= ail.com>
Oh! That's obviously the exact same issu= e. I didn't find this thread while searching about my issue.

We will upgrade.

Thanks for the link.


2012/11/14 aaron morton &l= t;aaron@thelas= tpickle.com>
May be=A0https://issues.apache.= org/jira/browse/CASSANDRA-4561

Can you upgrade to 1.= 1.6 ?=A0

Cheers

-----------------
Aaron Morton
Freelance Cassandra= Developer
New Zealand


On 14/11/2012, at 11:39 PM, Alain RODRIGUEZ <arodrime@gmail.com> wrote= :

Hi, I am running C* 1.1.2 and there is= no way to turn the compression on for a CF.

Here is the command I ran in the CLI:

UPDATE COLUMN FAMILY data_action WITH compression_options=3D{sstabl= e_compression:SnappyCompressor, chunk_length_kb : 64};

Show schema :

creat= e column family data_action
=A0 with column_type =3D 'Standar= d'
=A0 and comparator =3D 'UTF8Type'
=A0 an= d default_validation_class =3D 'UTF8Type'
=A0 and key_validation_class =3D 'UTF8Type'
=A0 and = read_repair_chance =3D 1.0
=A0 and dclocal_read_repair_chance =3D= 0.0
=A0 and gc_grace =3D 864000
=A0 and min_compaction= _threshold =3D 4
=A0 and max_compaction_threshold =3D 32
=A0 and replicate_on= _write =3D true
=A0 and compaction_strategy =3D 'org.apache.c= assandra.db.compaction.SizeTieredCompactionStrategy'
=A0 and = caching =3D 'KEYS_ONLY';

I tried also through cqlsh without success ("= ;ALTER TABLE data_action WITH compression_parameters:sstable_compression = =3D 'SnappyCompressor' AND compression_parameters:chunk_length_kb = =3D 64;")

I have no error message just these few lines on system.= log:

INFO 10:17:12,051 Completed flushing /ra= id0/cassandra/data/system/schema_columnfamilies/system-schema_columnfamilie= s-hd-20-Data.db (1367 bytes) for commitlog position ReplayPosition(segmentI= d=3D721932060965088, position=3D116556860)
=A0INFO 10:17:12,052 Compacting [SSTableReader(path=3D'/raid0/cass= andra/data/system/schema_columnfamilies/system-schema_columnfamilies-hd-20-= Data.db'), SSTableReader(path=3D'/raid0/cassandra/data/system/schem= a_columnfamilies/system-schema_columnfamilies-hd-19-Data.db'), SSTableR= eader(path=3D'/raid0/cassandra/data/system/schema_columnfamilies/system= -schema_columnfamilies-hd-17-Data.db'), SSTableReader(path=3D'/raid= 0/cassandra/data/system/schema_columnfamilies/system-schema_columnfamilies-= hd-18-Data.db')]
=A0INFO 10:17:12,134 Compacted to [/raid0/cassandra/data/system/schema= _columnfamilies/system-schema_columnfamilies-hd-21-Data.db,]. =A050,928 to = 46,827 (~91% of original) bytes for 3 keys at 0.544606MB/s. =A0Time: 82ms.<= /div>

I also tried upgrading sstables but compression i= s definitely not enabled (same size of data + JMX show a CompressionRatio o= f 0.0).

Does anyone already saw something similar = ?

Alain



--f46d04339cde9834b804ce8924b3--