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 plannin
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 p
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
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:
127
Hello,
Removing the extra parenthesis around the primary key definition seems to
work as expected:
CREATE TABLE foo2 (a int, b text, c uuid, PRIMARY KEY (a, b) );
INSERT INTO foo2 (a, b , c ) VALUES ( 1 , 'aze',
'4d481800-4c5f-11e1-82e0-3f484de45426');
INSERT INTO foo2 (a, b , c ) VALUES ( 1 ,
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
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
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 1
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 a
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: commitlog_sync_ba
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
updat
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
-Origin
Your datacenter is 'datacenter1' not 'DC1'.
- Pierre
-Original Message-
From: Cyril Auburtin
Date: Sat, 26 May 2012 16:51:38
To:
Reply-To: user@cassandra.apache.org
Subject: Re: NetworkTopologyStrategy with 1 node
Here is what happen with 2 cassandra nodes
I use 127.0.0.1 and 127.0.0
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: ca
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 cr
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
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,
ect * from Town where key in (?, ?, ?);
> etc.
>
> and then use the appropriate one each time, but I doubt that would be
> a better solution overall.
>
> p
>
>
> On Mon, Apr 30, 2012 at 4:47 PM, Pierre Chalamet
> wrote:
>>
>> If I prepare select *
query). This is
certainly normal for SQL binding libraries. Not sure why you feel that defeats
statement preparation.
p
On Mon, Apr 30, 2012 at 3:45 PM, Pierre Chalamet wrote:
Hi all,
Is there a support in Cassandra 1.1 for variable range filter parameter (sorry
I can’t fin
-
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 a
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 values
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^
-XX:+UseParN
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) :
D:\Cassandra\apache-cassandra-1.1.0\bin>ca
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 wrote:
> hello,
>
> 9160 is probably the port to use if you use the default config.
>
> - Pierre
>
> On Apr 10
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 wrote:
> using System;
> using System.Collections.Generic;
> using System.Linq;
> using System.Text;
> using Thrift.Collections;
> using Thrift.Protocol;
> using Thrift.Tran
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 an
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: user@cassandra.
far.
Thanks,
Jahangir.
On Tue, Dec 6, 2011 at 5:05 PM, Pierre Chalamet wrote:
> 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.
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 what
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 wo
>>- 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 terminolog
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
(multig
Thanks for the answer.
- Pierre
-Original Message-
From: Yi Yang
Date: Thu, 20 Oct 2011 04:20:25
To: ;
Subject: Re: SimpleAuthenticator / SimpleAuthorization missing
See:
https://issues.apache.org/jira/browse/CASSANDRA-2922
On Thu, Oct 20, 2011 at 4:08 AM, Pierre Chalamet wrote
Hello,
SimpleAuthenticator & SimpleAuthorization just disappear in release 1.0.0...
Will this stay like this or is it a release bug ?
Thanks,
- Pierre
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 to handle the p
nse on the next read (Am
guessing here, cannot remember exactly 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 s
not reachable.
Hope that helps.
-
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:
> - RackInferr
l servers tell they do 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,
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
39 matches
Mail list logo
