Re: cql3 and cli composites columns

2012-10-07 Thread Cyril Auburtin
that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 2/10/2012, at 10:37 PM, Cyril Auburtin cyril.aubur...@gmail.com wrote: I wanted to know why the highlighted sections below are printed differently, the 2 column families

Re: Cassandra supercolumns with same name

2012-10-01 Thread Cyril Auburtin
:33 AM, Cyril Auburtin cyril.aubur...@gmail.com wrote: First sorry but I'm using an old version 0.7.10 and recently I've come up seeing this = (super_column=mymed_embrun.ma...@gmail.com, (column=permission, value=1, timestamp=1347895421475)) = (super_column=mymed_embrun.ma...@gmail.com

Re: Cassandra supercolumns with same name

2012-10-01 Thread Cyril Auburtin
:33 AM, Cyril Auburtin cyril.aubur...@gmail.com wrote: First sorry but I'm using an old version 0.7.10 and recently I've come up seeing this = (super_column=mymed_embrun.ma...@gmail.com, (column=permission, value=1, timestamp=1347895421475)) = (super_column=mymed_embrun.ma...@gmail.com

[solved] Cassandra columns with same name

2012-10-01 Thread Cyril Auburtin
the super column ? Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 18/09/2012, at 5:33 AM, Cyril Auburtin cyril.aubur...@gmail.com wrote: First sorry but I'm using an old version 0.7.10 and recently I've come up seeing

Re: Thrift batch_mutate erase previous data?

2012-08-20 Thread Cyril Auburtin
no right it's ok, it was a bug on my side 2012/8/11 Tyler Hobbs ty...@datastax.com On Thu, Aug 9, 2012 at 10:43 AM, Cyril Auburtin cyril.aubur...@gmail.comwrote: It seems the Thrift method *batch-mutate*, with Mutations, will not update the previous data with the mutation given

Thrift batch_mutate erase previous data?

2012-08-09 Thread Cyril Auburtin
Hello It seems the Thrift method *batch-mutate*, with Mutations, will not update the previous data with the mutation given, but clear and replace by it? right? thanks for answers How could I do if I have more than one field to update, I should send several thrft *insert*?

large Rows Vs multinodes ring

2012-06-18 Thread Cyril Auburtin
In what extent, having possibly large rows, (many columns (sorted as timeststamp, or geohash or ...) will be nefast for a muli-node ring. I guess a row can be read/write just on one node, if yes it's more likely to fail, (than having one row per timestamp ..) thanks for explanations

Re: large Rows Vs multinodes ring

2012-06-18 Thread Cyril Auburtin
make repair do more work than is needed. * Rows wider than in_memory_compaction_limit_in_mb (64) make compaction run slower Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 19/06/2012, at 5:18 AM, Cyril Auburtin wrote: In what

Re: RESTful API for GET

2012-06-12 Thread Cyril Auburtin
Ok actually in my query call instead of page=14, I will put page=colName141st, 2012/6/12 Sasha Dolgy sdo...@gmail.com https://github.com/hmsonline/virgil Brian O'Neill posted this a while ago ... sits on top of Cassandra to give you the RESTful API you want Another option ...

Re: About Composite range queries

2012-06-01 Thread Cyril Auburtin
what you mean. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 1/06/2012, at 12:52 AM, Cyril Auburtin wrote: but sorry, I dont undertand If you hash 4 composite keys, let's say ('A','B','C'), ('A','D','C'), ('A','E','X'), ('A','R

Re: About Composite range queries

2012-05-31 Thread Cyril Auburtin
advantage compared to super column families? They are faster. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 29/05/2012, at 10:08 PM, Cyril Auburtin wrote: How is it done in Cassandra to be able to range query on a composite key? key1

Re: About Composite range queries

2012-05-31 Thread Cyril Auburtin
- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 31/05/2012, at 7:00 PM, Cyril Auburtin wrote: Thx for the answer 1 more thing, a Composite key is not hashed only once I guess? It's hashed the number of part the composite have? So

About Composite range queries

2012-05-29 Thread Cyril Auburtin
How is it done in Cassandra to be able to range query on a composite key? key1 = (A:A:C), (A:B:C), (A:C:C), (A:D:C), (B,A,C) like get_range (key1, start_column=(A,), end_column=(A, C)); will return [ (A:B:C), (A:C:C) ] (in pycassa) I mean does the composite implementation add much overhead to

Re: Nodetool talking to an old IP address (and timing out)

2012-05-27 Thread Cyril Auburtin
specify the jmx port to nodetool, hard coded in conf/cassandra-env.sh nodetool -h localhost -p [jmx port] ring 2012/5/27 Douglas Muth doug.m...@gmail.com Hi folks, I'm a relative newbie to Cassandra, and have been trying to get up to speed on it so that I can start using it at $WORK. I

Re: NetworkTopologyStrategy with 1 node

2012-05-26 Thread Cyril Auburtin
is: strategy_options = [{DC1:1}] On Fri, May 25, 2012 at 1:47 PM, Cyril Auburtin cyril.aubur...@gmail.com wrote: I was using a single node, on cassandra 0.7.10 with Network strategy = SimpleStrategy, and replication factor = 1, everything is fine, I was using a consistency level of ONE

Re: NetworkTopologyStrategy with 1 node

2012-05-26 Thread Cyril Auburtin
) at org.apache.cassandra.cli.CliClient.executeCLIStatement(CliClient.java:213) at org.apache.cassandra.cli.CliMain.processStatementInteractive(CliMain.java:219) at org.apache.cassandra.cli.CliMain.main(CliMain.java:346) 2012/5/26 Cyril Auburtin cyril.aubur...@gmail.com thx, but still not I did: update

Re: NetworkTopologyStrategy with 1 node

2012-05-26 Thread Cyril Auburtin
of nodetool ring? Does the cluster actually think your node is in DC1? -Jeremiah On May 26, 2012, at 6:36 AM, Cyril Auburtin wrote: I get the same issue on Cassandra 1.1: create keyspace ks with strategy_class = 'NetworkTopologyStrategy' AND strategy_options ={DC1:1}; then for example

Re: NetworkTopologyStrategy with 1 node

2012-05-26 Thread Cyril Auburtin
I update it in cassandra.topology.properties ? it has this for the 2 cassandra folders: 127.0.0.1=DC1:r1 127.0.0.2=DC1:r1 default=DC1:r1 2012/5/26 Pierre Chalamet pie...@chalamet.net ** Your datacenter is 'datacenter1' not 'DC1'. - Pierre -- *From: * Cyril

Re: Composite keys question

2012-05-25 Thread Cyril Auburtin
I'm not much advanced in cassandra, but seeing the pycassa doc http://pycassa.github.com/pycassa/assorted/composite_types.html, for composites you can't even search for the second term, you need a first term, the second will filter, you just do range slices on the composite columns it's totally

Re: C 1.1 CQL 2.0 or 3.0?

2012-05-16 Thread Cyril Auburtin
a Jira ticket. p On Fri, May 11, 2012 at 2:05 PM, cyril auburtin cyril.aubur...@gmail.comwrote: yes it seems so as long as I create (more than just create keyspace mykeyspace) it with cassandra cli, by creating CF, then I can't connect to it with cqlsh -3 I'll need to translate

Re: C 1.1 CQL 2.0 or 3.0?

2012-05-16 Thread Cyril Auburtin
what you're asking for. But since your keyspace was created with some capital letters in its name, you just need to quote the name in CQL 3: cqlsh use Mykeyspace; p On Wed, May 16, 2012 at 3:33 AM, Cyril Auburtin cyril.aubur...@gmail.comwrote: well yes, since I can retrieve the keyspace

primary keys query

2012-05-11 Thread cyril auburtin
Sorry for askign that but Why is it necessary to always have at least one EQ comparison [default@Keyspace1] get test where birth_year1985; No indexed columns present in index clause with operator EQ It oblige to have one dummy indexed column, to do this query [default@Keyspace1] get test

Re: primary keys query

2012-05-11 Thread cyril auburtin
that need to be read into memory to a manageable size. Although obviously you can still get into trouble with that as well. On 05/11/2012 09:39 AM, cyril auburtin wrote: Sorry for askign that but Why is it necessary to always have at least one EQ comparison [default@Keyspace1] get test

C 1.1 CQL 2.0 or 3.0?

2012-05-11 Thread cyril auburtin
I have C* 1.1 but it seems to only come with cql 2.0 INFO 19:35:21,579 Cassandra version: 1.1.0 INFO 19:35:21,581 Thrift API version: 19.30.0 INFO 19:35:21,583 CQL supported versions: 2.0.0,3.0.0-beta1 (default: 2.0.0) the problem is I would like to create such CF : CREATE COLUMNFAMILY

Re: C 1.1 CQL 2.0 or 3.0?

2012-05-11 Thread cyril auburtin
connection. Are you using cqlsh? If so, use the -3 parameter for version 3... -- *From:* cyril auburtin [mailto:cyril.aubur...@gmail.com] *Sent:* Friday, May 11, 2012 10:51 AM *To:* user@cassandra.apache.org *Subject:* C 1.1 CQL 2.0 or 3.0? I have C* 1.1

Re: C 1.1 CQL 2.0 or 3.0?

2012-05-11 Thread cyril auburtin
it works with a 'raw' keyspace (create keyspace mykeyspace;) but not with create keyspace mykeyspace with placement_strategy='SimpleStrategy' and strategy_options = {replication_factor:1}; ( ^ the config mykeyspace had) 2012/5/11 cyril auburtin cyril.aubur...@gmail.com thx just: can't connect

Re: C 1.1 CQL 2.0 or 3.0?

2012-05-11 Thread cyril auburtin
to create the keyspace under the context of a v3 connection. Maybe someone else can confirm? -- *From:* cyril auburtin [mailto:cyril.aubur...@gmail.com] *Sent:* Friday, May 11, 2012 11:46 AM *To:* user@cassandra.apache.org *Subject:* Re: C 1.1 CQL 2.0 or 3.0? thx

Re: .bat files in cassandra1.1?

2012-05-10 Thread cyril auburtin
sorry found something interesting here http://www.datastax.com/download/community 2012/5/10 cyril auburtin cyril.aubur...@gmail.com I wanted to use on Windows, but I don't see the .bat files for cassandra, cassandra-cli I remember they existed for 0.7.10 I think thx

Re: cassandra1.1 can't start

2012-05-08 Thread cyril auburtin
, at 1:29, cyril auburtin cyril.aubur...@gmail.com wrote: well I uncommented lines9697 in cassandra-env.sh, with lower values MAX_HEAP_SIZE=500M HEAP_NEWSIZE=100M seems to fix, it 2012/5/7 cyril auburtin cyril.aubur...@gmail.com The xassandra lauch command worked the first time then now

Re: cassandra1.1 can't start

2012-05-08 Thread cyril auburtin
for that. You can apply it on top of 1.1. ** ** - Pierre ** ** *From:* cyril auburtin [mailto:cyril.aubur...@gmail.com] *Sent:* mardi 8 mai 2012 08:56 *To:* user@cassandra.apache.org *Subject:* Re: cassandra1.1 can't start ** ** 8G, by default the jvm was taking 2G, and I had

cassandra1.1 can't start

2012-05-07 Thread cyril auburtin
The xassandra lauch command worked the first time then now I keep getting INFO 18:18:39,354 Starting up server gossip ERROR 18:18:39,357 Exception in thread Thread[COMMIT-LOG-ALLOCATOR,5,main] java.io.IOError: java.io.IOException: Map failed at

Re: cassandra1.1 can't start

2012-05-07 Thread cyril auburtin
well I uncommented lines9697 in cassandra-env.sh, with lower values MAX_HEAP_SIZE=500M HEAP_NEWSIZE=100M seems to fix, it 2012/5/7 cyril auburtin cyril.aubur...@gmail.com The xassandra lauch command worked the first time then now I keep getting INFO 18:18:39,354 Starting up server gossip

creating keyspace with 1.1

2012-05-06 Thread cyril auburtin
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

Re: creating keyspace with 1.1

2012-05-06 Thread cyril auburtin
’ and strategy_options = [{replication_factor:1}] ** ** ** ** *From:* cyril auburtin [mailto:cyril.aubur...@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

Re: creating keyspace with 1.1

2012-05-06 Thread cyril auburtin
and keys_cached = 1000.0 and key_cache_save_period = 3600; 2012/5/6 cyril auburtin cyril.aubur...@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

[1.1] Can't create column

2012-05-06 Thread cyril auburtin
[default@ks] create column family Post with column_type = 'Standard' and column_metadata = [{column_name: 'user', validation_class: 'UTF8Type'}, {column_name: 'type', validation_class: 'UTF8Type'}] and comment = 'bla'; java.lang.RuntimeException: org.apache.cassandra.db.marshal.MarshalException:

Re: [1.1] Can't create column

2012-05-06 Thread cyril auburtin
’; ** ** - Pierre ** ** *From:* cyril auburtin [mailto:cyril.aubur...@gmail.com] *Sent:* dimanche 6 mai 2012 13:10 *To:* user@cassandra.apache.org *Subject:* [1.1] Can't create column ** ** [default@ks] create column family Post with column_type = 'Standard' and column_metadata