Re: release of cassandra-unit 1.1.0.1

yep, good idea, I have created an issue. 2012/6/19 Yuhan Zhang yzh...@onescreen.com Hi Jeremy, Glad to see the update. It would be nice if secondary index in cassandra-unit supports DoubleType. Yuhan On Wed, Jun 13, 2012 at 1:32 PM, Jérémy SEVELLEC jsevel...@gmail.comwrote: Hi all,

Using row cache causes slowdown and unavailable reads

Good day, I'm load testing our cassandra instance. I have a column family with 2300 rows, each being ~ 5MB. And I run same query which asks for same rows. With caching='keys_only response time is adequate. But with caching='ALL', we get four times larger response time and 40-50$ of requests

Re: Snapshot failing on JSON files in 1.1.0

Hi I solved the problem. Some of my sstables where owned by root:root. Probably from a previous cluster I had. A chown -R cassandra:cassandra solved the problem. So it apparently was a combination of JNA + permission problem. No It works like a charm. Thanks ! 2012/6/20 Rob Coli

No lowercase with CQL when using create table

Hello, I'm using CQL 3 to create column families within a keyspace with Cassandra 1.1.1. Column families are created but all names (column families and their column definitions) are in lowercase. Is it possible to prevent from this behavior? Thanks very much for your help. Thierry

cqlsh commands

Hello, I'm using cqlsh tool to create column families and it works fine. However I don't know how to use the following commands: Documented commands (type help topic): ASSUME CAPTURE DESC DESCRIBE EXIT HELP SELECT SHOW SOURCE USE Moreover I

Re: performance problems on new cluster

How did you solve your problem eventually? I am experiencing something similar. Did you run cleanup on the node that has 80GB data? -Raj On Mon, Aug 15, 2011 at 10:12 PM, aaron morton aa...@thelastpickle.comwrote: Just checking do you have read_repair_chance set to something ? The second

Re: No lowercase with CQL when using create table

On Wed, Jun 20, 2012 at 1:45 PM, Thierry Templier thierry.templ...@restlet.com wrote: Hello, I'm using CQL 3 to create column families within a keyspace with Cassandra 1.1.1. Column families are created but all names (column families and their column definitions) are in lowercase. Is it

Re: No lowercase with CQL when using create table

Thanks very much, Sylvain, for the hints. Thierry Yes, you have to use double quotes in CQL3 to force the case of an identifier (so CREATE TABLE FooBar rather than CREATE TABLE FooBar). -- Sylvain

wildcards as both ends

Hi all I'm wondering how or if it's possible to implement efficient wildcards at both ends, e.g. *string* I can think of a few options... please comment, thanks =D - if I can get another equality constraint which narrows down potential result set significantly, I can do a scan. I'm not sure how

Re: store large String as col value

Column values are limited at 2G.Why store them as Base64? that just adds overhead. Storing the raw bytes will save you a bunch. - Original Message -From: quot;Cyril Auburtinquot; ;cyril.aubur...@gmail.com

Re: store large String as col value

Take also into account Thrift's limits. http://wiki.apache.org/cassandra/CassandraLimitations Paolo On Jun 20, 2012 10:11 PM, Dave Brosius dbros...@mebigfatguy.com wrote: Column values are limited at 2G. Why store them as Base64? that just adds overhead. Storing the raw bytes will save you

Re: store large String as col value

why not just store the URL of pic / video, just like the RDBMS did, cassandra is merely a distributed database from some kind point of view. it is more like a schema design issue. Any video or pic should not be put into the DB especially big data table DB as raw binary format. and did this kind of

When will CQL BATCH support binding variable (Query substitution use named parameters)?

Hello, CQL BATCH is good for INSERT/UPDATE performance. But it cannot do binding variable, exposed to SQL injection. Is there a plan to make CQL BATCH to support binding variable in near future? e.g. http://code.google.com/a/apache-extras.org/p/cassandra-dbapi2/ Query substitution Use named

Could not connect to cassandra 1.0.9

Hi list I'd like to connect to remote Cassandra using Java client, the following code I use, but ImcompatibleClassChangeError was occured, the source that was just dependent on the following jars: apache-cassandra-1.0.9.jar, apache-cassandra-clientutil-1.0.9.jar,

Re: Could not connect to cassandra 1.0.9

Thanks. I just fix my problem, I missing a jar named libthrift-0.6.jar. On Thu, Jun 21, 2012 at 10:10 AM, dong.yajun dongt...@gmail.com wrote: Hi list I'd like to connect to remote Cassandra using Java client, the following code I use, but ImcompatibleClassChangeError was occured, the

Creating secondary index CQL3 cassandra 1.1.1

I have the following schema: describe columnfamily visitor_audit; CREATE TABLE visitor_audit ( visitor_id text, audit_id uuid, account_id int, audit_type int, created_at text, PRIMARY KEY (visitor_id, audit_id) ) WITH comment='' AND caching='KEYS_ONLY' AND