failed to create keyspace 1.2-beta2 bin protocol

2012-11-11 Thread Pierre Chalamet
Hi all, I'm trying to create a keyspace through the CQL Binary Protocol but lamely failed at doing this simple task with 1.2b2/cql3. Various command tried: DEBUG 18:08:23,240 Received: OPTIONS DEBUG 18:08:23,240 Responding: SUPPORTED {CQL_VERSION=[3.0.0], COMPRESSION=[snappy]} DEBUG

RE: failed to create keyspace 1.2-beta2 bin protocol

2012-11-11 Thread Pierre Chalamet
Forget about it, should have read https://github.com/apache/cassandra/blob/trunk/doc/cql3/CQL.textile instead of source snapshot (not merged in 1.2-b2 snapshot ?) - Pierre From: Pierre Chalamet [mailto:pie...@chalamet.net] Sent: Sunday, November 11, 2012 6:11 PM To: user

cassandra-sharp 2.0-ALPHA available

2012-11-15 Thread Pierre Chalamet
there are some bugs hanging around, so feel free to fill issues/improvements at http://code.google.com/p/cassandra-sharp/issues/list. Hope you will enjoy it ! - Pierre Chalamet

system.peers.tokens is empty after node restart

2013-01-06 Thread Pierre Chalamet
Hello, Using a 2 nodes fresh cluster (127.0.0.1 127.0.0.2) running latest 1.2, I'm querying system.peers to get the nodes of the cluster and their respective token. But it seems there is a problem after either node restart. When both node starts up, querying system.peers seems ok:

Invalid streamId in cql binary protocol when using invalid CL

2013-01-15 Thread Pierre Chalamet
Hello, Executing a query using an invalid CL with binary protocol leads to an invalid response streamId (always 0). I've created following issue then: https://issues.apache.org/jira/browse/CASSANDRA-5164 Thanks, - Pierre

RE: CQL3 Frame Length

2013-01-21 Thread Pierre Chalamet
Hi, That's not a good reason imho. This would have been better to have chunks of data (like in the good old IFF file format). If the client is not able to read the chunk, just skip it. And frankly, that's not a few more bytes that would have killed us. As an example, request tracing was added

RE: Importing data from SQL Server

2013-03-11 Thread Pierre Chalamet
You can quickly create a query using dapper and then transfer all your rows using cassandra-sharp actually. The only thing you have to do is to create a class to materialize a row and obviously the SQL and CQL statements. I also have a pending change for cassandra-sharp-contrib that I'm

Get CL ONE / NTS

2011-09-14 Thread Pierre Chalamet
Hello, I have 2 datacenters. Cassandra is configured as follow: - RackInferringSnitch - NetworkTopologyStrategy for CF - strategy_options: DC1:3 DC2:3 Data are written using CL LOCAL_QUORUM so data written from one datacenter will eventually be replicated to the other datacenter. Data is always

RE: Get CL ONE / NTS

2011-09-14 Thread Pierre Chalamet
not have the data ? It seems to depend on RR as in 3/ Are the answers right ? - Pierre -Original Message- From: Pierre Chalamet [mailto:pie...@chalamet.net] Sent: Wednesday, September 14, 2011 3:33 PM To: user@cassandra.apache.org Subject: Get CL ONE / NTS Hello, I have 2 datacenters

RE: Get CL ONE / NTS

2011-09-14 Thread Pierre Chalamet
. - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 15/09/2011, at 1:33 AM, Pierre Chalamet wrote: Hello, I have 2 datacenters. Cassandra is configured as follow: - RackInferringSnitch - NetworkTopologyStrategy for CF - strategy_options: DC1:3

RE: Get CL ONE / NTS

2011-09-15 Thread Pierre Chalamet
how RR works cross DC) Cheers - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 15/09/2011, at 10:07 AM, Pierre Chalamet wrote: Thanks Aaron, didn't seen your answer before mine. I do agree for 2/ I might have

Re: Get CL ONE / NTS

2011-09-17 Thread Pierre Chalamet
(). Cheers - Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 15/09/2011, at 7:21 PM, Pierre Chalamet wrote: I do not agree here. I trade “consistency” (it’s more data miss than consistency here) over performance in my case. I’m okay

SimpleAuthenticator / SimpleAuthorization missing

2011-10-20 Thread Pierre Chalamet
Hello, SimpleAuthenticator SimpleAuthorization just disappear in release 1.0.0... Will this stay like this or is it a release bug ? Thanks, - Pierre

Re: SimpleAuthenticator / SimpleAuthorization missing

2011-10-20 Thread Pierre Chalamet
On Thu, Oct 20, 2011 at 4:08 AM, Pierre Chalamet pie...@chalamet.netwrote: Hello, SimpleAuthenticator SimpleAuthorization just disappear in release 1.0.0... Will this stay like this or is it a release bug ? Thanks, - Pierre

RE: Second Cassandra users survey

2011-11-05 Thread Pierre Chalamet
Dear Santa, here is my wish list :) - support for atomic operations or batches (if QUORUM fails, data should not be visible with ONE) - TTL on CF, rows and counters - restart the TTL when a row, column or CF is touched - streamed data transfer (both send receive). At least for receive

RE: Second Cassandra users survey

2011-11-06 Thread Pierre Chalamet
- support for atomic operations or batches (if QUORUM fails, data should not be visible with ONE) zookeeper is solving that. Yeah, I can use HBase too. I might have screwed up a little bit since I didn't talk about isolation; let's reformulate: support for read committed (using DB

RE: Second Cassandra users survey

2011-11-06 Thread Pierre Chalamet
I do not want to use HBase because Cassandra is way far easier to deploy and it is working pretty well - and for the 99% of our apps the model fits perfectly. The other 1% has a workaround by ordering writes. I assume the trade off anyway :) Don't miss the point: I love Cassandra and the way it

cassandra most stable version ?

2011-12-06 Thread Pierre Chalamet
Hello, Recent problems with Cassandra 1.0.x versions seems to tell it is still not ready for prime time. We are currently using version 0.8.5 on our development cluster - although we have not seen much problems with this one, maybe recent versions of 0.8.x might be safer to use. So

Re: cassandra most stable version ?

2011-12-07 Thread Pierre Chalamet
version ? We are running 0.8.7. No big issues so far. Thanks, Jahangir. On Tue, Dec 6, 2011 at 5:05 PM, Pierre Chalamet pie...@chalamet.net wrote: Hello, ** ** Recent problems with Cassandra 1.0.x versions seems to tell it is still not ready for prime time. ** ** We are currently

RE: Cassandra 0.8.8

2011-12-09 Thread Pierre Chalamet
0.8.8 has been released last week: http://cassandra.apache.org/download/ https://svn.apache.org/repos/asf/cassandra/tags/cassandra-0.8.8/CHANGES.txt Cheers, - Pierre -Original Message- From: Maxim Potekhin [mailto:potek...@bnl.gov] Sent: vendredi 9 décembre 2011 22:37 To:

Re: column’s timestamp

2012-04-02 Thread Pierre Chalamet
Hi, What about using a ts as column name and do a get sliced instead ? --Original Message-- From: Avi-h To: cassandra-u...@incubator.apache.org ReplyTo: user@cassandra.apache.org Subject: column’s timestamp Sent: Apr 2, 2012 18:24 Is it possible to fetch a column based on the row key

Re: cassandra and .net

2012-04-09 Thread Pierre Chalamet
hello, 9160 is probably the port to use if you use the default config. - Pierre On Apr 10, 2012, at 7:26 AM, puneet loya puneetl...@gmail.com wrote: using System; using System.Collections.Generic; using System.Linq; using System.Text; using Thrift.Collections; using Thrift.Protocol;

Re: cassandra and .net

2012-04-10 Thread Pierre Chalamet
hi, sorry i posted the port as 7000. I m using 9160 but still has the same error. Cannot read, Remote side has closed. Can u guess whats happening?? On Tue, Apr 10, 2012 at 11:00 AM, Pierre Chalamet pie...@chalamet.netwrote: hello, 9160 is probably the port to use if you use the default config

Crash by truncate with cassandra 1.1

2012-04-25 Thread Pierre Chalamet
Hi, With Cassandra 1.1, I have the following crash on a fresh new single node cluster running on Windows 7. On client side: create keyspace toto; create column family titi; truncate titi; The crash server side (the server is dead then) :

RE: Crash by truncate with cassandra 1.1

2012-04-30 Thread Pierre Chalamet
Hi Aaron, No, I just avoid truncating for the moment L (I'm adding CQL prepared statement to Cassandra-Sharp). It's a bit strange anyway, JVM options are: set JAVA_OPTS=-ea^ -javaagent:%CASSANDRA_HOME%\lib\jamm-0.2.5.jar^ -Xms1G^ -Xmx1G^ -XX:+HeapDumpOnOutOfMemoryError^

execute_prepared_cql_query and variable range filter parameter

2012-04-30 Thread Pierre Chalamet
Hi all, Is there a support in Cassandra 1.1 for variable range filter parameter (sorry I can't find a right name for that): select * from TestCF where key in (?) using execute_prepared_cql_query ? In the query above, it seems I can only bind one value to '?'. I mean, if several

RE: Crash by truncate with cassandra 1.1

2012-04-30 Thread Pierre Chalamet
- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 30/04/2012, at 10:33 PM, Pierre Chalamet wrote: Hi Aaron, No, I just avoid truncating for the moment L (I'm adding CQL prepared statement to Cassandra-Sharp). It's a bit strange anyway, JVM

RE: execute_prepared_cql_query and variable range filter parameter

2012-04-30 Thread Pierre Chalamet
. Not sure why you feel that defeats statement preparation. p On Mon, Apr 30, 2012 at 3:45 PM, Pierre Chalamet pie...@chalamet.net wrote: Hi all, Is there a support in Cassandra 1.1 for variable range filter parameter (sorry I can’t find a right name for that): select * from TestCF where

RE: execute_prepared_cql_query and variable range filter parameter

2012-05-02 Thread Pierre Chalamet
be a better solution overall. p On Mon, Apr 30, 2012 at 4:47 PM, Pierre Chalamet pie...@chalamet.net wrote: If I prepare “select * from Town where key in (?)” I will be able to bind ? to 'Paris' for example [è select * from Town where key in ('Paris')]. If I want to query for 'Paris

RE: creating keyspace with 1.1

2012-05-06 Thread 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.aubur...@gmail.com] Sent: Sunday, May 06,

RE: creating keyspace with 1.1

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

RE: [1.1] Can't create column

2012-05-06 Thread Pierre Chalamet
create column family Post with comparator=UTF8Type and colum_metadata=[{column_name : user, validation_class : UTF8Type}] and comment='bla'; - 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

RE: cassandra1.1 can't start

2012-05-08 Thread Pierre Chalamet
This looks like CASSANDRA-4201 where map() was failing with oom under 32 bits jvm. Jonathan provided a patch 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:

Re: NetworkTopologyStrategy with 1 node

2012-05-26 Thread Pierre Chalamet
Your datacenter is 'datacenter1' not 'DC1'. - Pierre -Original Message- From: Cyril Auburtin cyril.aubur...@gmail.com Date: Sat, 26 May 2012 16:51:38 To: user@cassandra.apache.org Reply-To: user@cassandra.apache.org Subject: Re: NetworkTopologyStrategy with 1 node Here is what happen

Re: Doubt in Row key range scan

2012-05-28 Thread Pierre Chalamet
Hi, It's normal. Keys to replicas are determined with a hash (md5) when using the random partitionner (which you are using I guess). You probably want to switch to the order preserving partionner or tweak your data model in order to rely on 2nd index for such filtering. - Pierre

Re: commitlog_sync_batch_window_in_ms change in 0.7

2012-05-28 Thread Pierre Chalamet
Hi, Using nodetool for each node one by one: 1. disablethrift 2. drain 3. Shutdown your daemon 4. Modify the config 5. Restart the node You won't lose the data on your nodes - clients might see a node down, it is usually not a problem if your c* client is smart enough. You also won't lose

Re: commitlog_sync_batch_window_in_ms change in 0.7

2012-05-29 Thread Pierre Chalamet
You'd better use version 1.0.9 (using this one in production) or 1.0.10. 1.1 is still a bit young to be ready for prod unfortunately. --Original Message-- From: Rob Coli To: user@cassandra.apache.org To: osish...@gmail.com ReplyTo: user@cassandra.apache.org Subject: Re:

Re: Loading data on-demand in Cassandra

2012-08-13 Thread Pierre Chalamet
Hi, You do not need to have 700 Go of data in RAM. Cassandra is able to store on disks and query from there if data is not cached in memory. Caches are maintained by C* by itself but you still have to some configuration. Supposing you want to store around 800 Go and with a RF=3, you will need