Re: Performance / limitations of WHERE ... IN queries

Thanks very much, Aaron, for your answer! Thierry You are effectively doing a multi get. Getting more than one row at a time is normally faster, but there will be a drop off point where the improvements slow down. Run some tests. Also consider that each row you requests creates RF number of c

Performance / limitations of WHERE ... IN queries

Hello, I wonder what are the performances of WHERE ... IN queries especially when the number of elements in the IN grows? Thanks very much for your help! Thierry

Composite columns

Hello, I have a question regarding composite columns. What is the way to create and use them basing on CQL3? Are there some documentations regarding this feature? Is it supported with both versions 1.1 and 1.2 of Cassandra? Thanks very much for your help! Thierry

Re: Super columns and arrays

any copies.> -Original Message- From: Thierry Templier [mailto:thierry.templ...@restlet.com] Sent: Friday, October 12, 2012 13:44 To: user@cassandra.apache.org Subject: Super columns and arrays Hello, I wonder if it's possible to specify an array of values as a value of a supe

Super columns and arrays

Hello, I wonder if it's possible to specify an array of values as a value of a super column... If it's not possible, is there another way to do that? Thanks very much for your help. Thierry

Re: Problem when starting Cassandra 1.1.5

Thanks very much, Adeel! It works much better! Thierry Please upgrade the JAVA with 1.7.X then it will be working. Thanks & Regards *Adeel**Akbar* On 10/8/2012 1:36 PM, Thierry Templier wrote: Hello, I would want to upgrade Cassandra to version 1.1.5 but I have a problem when tryin

Problem when starting Cassandra 1.1.5

Hello, I would want to upgrade Cassandra to version 1.1.5 but I have a problem when trying to start this version: $ ./cassandra -f xss = -ea -javaagent:./../lib/jamm-0.2.5.jar -XX:+UseThreadPriorities -XX:ThreadPriorityPolicy=42 -Xms1024M -Xmx1024M -Xmn256M -XX:+HeapDumpOnOutOfMemoryError -

Introspecting table with CQL3

Hello, I wonder if it's possible to have access to metadata regarding a table/column family (its column names, types...) using CQL3. Thanks very much for your help! Thierry

Problem when deleting a keyspace

Hello, I have a problem when trying to delete a keyspace using cqlsh. It seems to remain existing even after executing a drop keyspace command: cqlsh> use teststore; cqlsh:teststore> drop keyspace teststore; cqlsh:teststore>describe keyspace teststore; CREATE KEYSPACE teststore WITH strategy_

Re: Getting stats of keyspaces

Thanks very much, Manoj. It's exactly what I looked for. Thierry You can get the statistics using jmx. See here : http://www.datastax.com/docs/1.1/operations/monitoring Best regards, Manoj

Re: Enable CQL3 from Astyanax

Hello Aaron, I try to simulate a composition relationship within a single column family / table (for example, an entity and its fields). I dynamically add columns the contained elements. Let's take an example. Here is my table definition with CQL 3: CREATE TABLE "Entity" ( "id" varchar,

Getting stats of keyspaces

Hello, I wonder if it's possible to get statistics for a keyspace like its size, size of each column family it contains. It's something I'd like from a request... Thanks very much for your help. Thierry

Re: Enable CQL3 from Astyanax

Thanks for contributing. I'm behind the curve on CQL 3, but here is a post about some of the changes http://www.datastax.com/dev/blog/whats-new-in-cql-3-0 Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 28/06/2012, at 2:30 AM, Thierry

Re: ClassCastException during Cassandra server startup

Hello Yuki, Could you give me hints about where to find these files. I have a look in the installation folder of Cassandra and in the /var/lib/cassandra folder? Thanks very much for your help. Thierry That was bug in 1.1.1 and fixed in https://issues.apache.org/jira/browse/CASSANDRA-4331. Wo

Re: ClassCastException during Cassandra server startup

Thanks very much, Yuki, for your answer! Thierry That was bug in 1.1.1 and fixed in https://issues.apache.org/jira/browse/CASSANDRA-4331. Workaround is deleting the key cache files for your index CFs should fix this. Yuki

Re: ClassCastException during Cassandra server startup

Hello, My problem seems to occur after a server restart. As a matter of fact, if I clean the data, create a new keyspace and and its structure with cqlsh, I can use the database correctly (both with cqlsh and a Java application with Astyanax). If I stop the server and restart it, I have my pr

ClassCastException during Cassandra server startup

Hello, When I start the Cassandra server, some exceptions occur: INFO 10:22:16,014 reading saved cache /var/lib/cassandra/saved_caches/apispark-CellMessage-KeyCache INFO 10:22:16,016 Opening /var/lib/cassandra/data/apispark/CellMessage/apispark-CellMessage-hd-2 (498 bytes) INFO 10:22:16,016

Re: Enable CQL3 from Astyanax

Hello Aaron, I created an issue on the Astyanax github for this problem. I added a fix to support CQL3 in the tool. See the link https://github.com/Netflix/astyanax/issues/75. Thierry Had a quick look, the current master does not appear to support it. Cheers

Re: Enable CQL3 from Astyanax

loper @aaronmorton http://www.thelastpickle.com On 26/06/2012, at 7:46 AM, Thierry Templier wrote: Hello, How can I enable CQL3 support in Astyanax? Thanks very much for your help! Thierry

Enable CQL3 from Astyanax

Hello, How can I enable CQL3 support in Astyanax? Thanks very much for your help! Thierry

Re: cqlsh commands

Hello Paul, I thought but I can't reproduce the problem anymore... Don't know what really happens. Thanks very much for your message! Thierry What do you mean when you say you can't display the related documentations using the help command? What does cqlsh do instead? I don't know about an

Migrate keyspace from version 1.0.8 to 1.1.1

Hello, What is the correct way to migrate a keyspace version 1.0.8 to 1.1.1? Is there a documentation on this subject? Thanks for your help. Thierry

Re: cqlsh commands

Thanks very much, Jeff. It's exactly what I looked for... Thierry You should be able to get most of this information from the datastax documentation, e.g. http://www.datastax.com/docs/1.0/references/cql/index for version 1.0. Jeff

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

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 ): ASSUME CAPTURE DESC DESCRIBE EXIT HELP SELECT SHOW SOURCE USE Moreover I can't d

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