From user-return-25957-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org Sun May 6 11:52:30 2012 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 16F30C60F for ; Sun, 6 May 2012 11:52:29 +0000 (UTC) Received: (qmail 14758 invoked by uid 500); 6 May 2012 11:52:26 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 14727 invoked by uid 500); 6 May 2012 11:52:26 -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 14719 invoked by uid 99); 6 May 2012 11:52:26 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 06 May 2012 11:52:26 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [74.125.82.172] (HELO mail-we0-f172.google.com) (74.125.82.172) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 06 May 2012 11:52:21 +0000 Received: by werf13 with SMTP id f13so1901932wer.31 for ; Sun, 06 May 2012 04:51:59 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=from:to:references:in-reply-to:subject:date:message-id:mime-version :content-type:x-mailer:thread-index:content-language :x-gm-message-state; bh=aNiPM0bkLMLKJMSkNt5NUMbLMnjITiUSwtLa0V9VHpw=; b=FdIyZ0Iw0mXgyr23jKn/UEgOQkE6uLjU/YZEAsQxouNxnXZp5N7oUED+6hTje10kTA KMEBuayUpc2ToqfGzmOC+yCdcg6M22g2S8yzFfCoB4KubK5mpj7BaSLCgX6UW1S/TnWr rT5ILjCfmuiO320nlzQBtVd2Oq/uM4Ux+nvqb2d3VvOhekznmgsvR97XTjkJHURcMvgu l3F3XD1DsK1QUUpZWFTV22TeWuM5gMG+n6mLzaPKSfIXGKlm2IMUURSAP8vLzP3tDbeE UqaiT7LyczJECm6ImZk9TBpTyRVzT9ktM7lsgzHH1pUeoPrc43GEu14ZqiuK/EqxpA49 HPCg== Received: by 10.180.76.232 with SMTP id n8mr5553965wiw.2.1336305119193; Sun, 06 May 2012 04:51:59 -0700 (PDT) Received: from SNOWWHITE (sat78-2-82-237-57-246.fbx.proxad.net. [82.237.57.246]) by mx.google.com with ESMTPS id fn2sm21032848wib.0.2012.05.06.04.51.58 (version=TLSv1/SSLv3 cipher=OTHER); Sun, 06 May 2012 04:51:58 -0700 (PDT) From: "Pierre Chalamet" To: References: <002a01cd2b69$333368a0$999a39e0$@net> In-Reply-To: Subject: RE: creating keyspace with 1.1 Date: Sun, 6 May 2012 13:51:57 +0200 Message-ID: <000601cd2b7e$a44ee540$ececafc0$@chalamet.net> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0007_01CD2B8F.67D93BE0" X-Mailer: Microsoft Outlook 14.0 Thread-Index: AQEhPseJF9ibcw6FRF1cLXYwNfCSlAL0K0L5AdZHuz4Cf/1KupfaKdUg Content-Language: fr X-Gm-Message-State: ALoCoQnkPXYfXFAtUCQFLejRsUOFGhcNglf/t85ONHYDWiLqb/dIHg4bEd7OfO6ogEFflnliuElO X-Virus-Checked: Checked by ClamAV on apache.org This is a multipart message in MIME format. ------=_NextPart_000_0007_01CD2B8F.67D93BE0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Caching has quite change a lot in 1.1. See http://www.datastax.com/dev/blog/caching-in-cassandra-1-1 You need to set appropriate value in cassandra conf : key_cache_size_in_mb, key_cache_save_period and row_cache_size_in_mb. You will probably need to change the caching properties on CF with ALL or ROWS_ONLY if you want to enable rows caching. Something like this: create column family Application with caching='ALL'; By default, only keys are cached. - Pierre From: cyril auburtin [mailto:cyril.auburtin@gmail.com] Sent: dimanche 6 mai 2012 12:22 To: user@cassandra.apache.org Subject: Re: creating keyspace with 1.1 and one more thing For migration 0.7.10 ->1.1 I had to remove rows_cached, keys_cached, and key_cache_save_period from CF declarations? What would it change for my application create column family Application with column_type = 'Standard' and comparator = 'UTF8Type' and rows_cached = 100.0 and keys_cached = 1000.0 and key_cache_save_period = 3600; 2012/5/6 cyril auburtin thx Other question (I'm moving from cassandra 0.7.10 to 1.1) the class org.apache.cassandra.thrift.Column.Column 's constructor arguments is now just name instead of (name, value, timestamp) So it should be called like this? new Column(myColumnName).setValue(myVal).setTimestamp(System.currentTimeMillis() ); Larger.. , but no choice 2012/5/6 Pierre Chalamet Hi, I bet you are using cql commands in cassandra-cli. If you are using cli, use instead: create keyspace Excelsior with placement_strategy='SimpleStrategy' and strategy_options = [{replication_factor:1}] From: cyril auburtin [mailto:cyril.auburtin@gmail.com] Sent: Sunday, May 06, 2012 10:31 AM To: user@cassandra.apache.org Subject: creating keyspace with 1.1 Hello I have just installed cassandra 1.1 CREATE KEYSPACE Excelsior WITH strategy_class = 'SimpleStrategy' AND strategy_options:replication_factor = 1; gives this error: Syntax error at position 85: mismatched input ':' expecting '=' I've looked in changes but didn't found Thanks ------=_NextPart_000_0007_01CD2B8F.67D93BE0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

 

Caching has quite change a lot in 1.1. See http://www.datastax.com/dev/blog/caching-in-cassandra-1-1

 

You need to set appropriate value = in cassandra conf : key_cache_size_in_mb, key_cache_save_period and = row_cache_size_in_mb.

 

You will probably need to change the caching properties on = CF with ALL or ROWS_ONLY if you want to enable rows caching. Something = like this:

create column family = Application with caching=3D'ALL’;

By default, only keys are = cached.

 

- Pierre

 

From:= cyril = auburtin [mailto:cyril.auburtin@gmail.com]
Sent: dimanche 6 = mai 2012 12:22
To: = user@cassandra.apache.org
Subject: Re: creating keyspace with = 1.1

 

and one more thing

 

For migration 0.7.10 = ->1.1

I had to remove = rows_cached, keys_cached, and key_cache_save_period from CF = declarations?

What would = it change for my application

 

create column family Application with column_type =3D = 'Standard' and comparator =3D 'UTF8Type' and rows_cached =3D 100.0 and = keys_cached =3D 1000.0 and key_cache_save_period =3D = 3600;

 

2012/5/6 cyril auburtin <cyril.auburtin@gmail.com>

thx

 

Other question

 

(I'm moving from cassandra 0.7.10 to = 1.1)

 

the = class org.apache.cassandra.thrift.Column.Column 's constructor = arguments is now just name instead of (name, value, = timestamp)

 

So it should be called like = this?

 

new = Column(myColumnName).setValue(myVal).setTimestamp(System.currentTimeMilli= s());

 

Larger.. , but no = choice

 

 

 

2012/5/6 Pierre Chalamet <pierre@chalamet.net>

Hi,

 

I bet you are using cql commands in = cassandra-cli.

 

If you are using cli, use instead:

create keyspace Excelsior with = placement_strategy=3D’SimpleStrategy’ and strategy_options = =3D [{replication_factor:1}]

 

 

From:= cyril = auburtin [mailto:cyril.auburtin@gmail.com]
Sent: Sunday, = May 06, 2012 10:31 AM
To: user@cassandra.apache.org
Subject: = creating keyspace with 1.1

 <= /o:p>

Hello

 <= /o:p>

I have just = installed cassandra 1.1

 <= /o:p>

 CREATE= KEYSPACE Excelsior WITH strategy_class =3D 'SimpleStrategy' AND = strategy_options:replication_factor =3D = 1;

 <= /o:p>

gives this = error:

 <= /o:p>

Syntax = error at position 85: mismatched input ':' expecting = '=3D'

 <= /o:p>

I've looked = in changes but didn't found 

Thanks<= /o:p>

 

 

------=_NextPart_000_0007_01CD2B8F.67D93BE0--