Re: CQL3 and column slices

In the absence of streaming, how does one retrieve a large result set in CQL3? E.g., to use the same example: > CREATE TABLE bug_test (a int, b int, c int, d int, e int, f text, PRIMARY > KEY (a, b, c, d, e) ); > with some data in it: > > SELECT * FROM bug_test; > > Results: > > a | b | c | d | e |

Cassandra FAILED_TO_UNCOMPRESS

Hi, We are using DataStax cassandra (2 nodes)& have recently upgraded from 0.8.x to 1.0.x. Followed the steps on http://www.datastax.com/docs/1.0/install/upgrading#upgrading-cassandra-0-8-x-to-1-0-x however on running the final repair on Node1 we get a error message as below. Please can you guide.

Re: Secondary Index Limitation / DOes it exist in Cassandra 1.1.2

That's only a small part of the problem. A larger issue is that what follows the index read is basically a multiget within that node, which generates a lot of non-sequential I/O. The second issue is that nodes are queried sequentially to get more result rows until the requested row count has been

Secondary Index Limitation / DOes it exist in Cassandra 1.1.2

Hi All, Correct me if I am wrong, but I know that secondary indexes are stored to local column families on each node. Previously where the default cache key value was 200,000 rows, and you couldn't really tune the local index column family, that posed a limitation on low cardinality of the possibl

Mixed cluster node with version 1.1.2 and 1.0.6 gives errors

Hi I have 3 node development cluster and all running 1.0.6 version without any issue. As the part of the upgrade to 1.1.2, I just upgrade one node to 1.1.2 version. When start the upgraded 1.1.2 node, the other 1.0.6 nodes getting the below exceptions? 2012-08-01 18:31:15,990 INFO [IncomingTcpCo

Re: Dynamic CF

I thought I'd give this a try: create columnfamily at_event__ac_c ( ac_c text, ac_creation bigint, ac_name text, ac_value text, PRIMARY KEY (ac_c, ac_creation) ) with compression_parameters:sstable_compression = ''; Then, insert a few columns: begin batch using consistenc

thrift/cassandra stacktrace....

1. I would think thrift would give better errors, I have no idea where to look(thrift or cassandra?). Anyone have any idea how to figure this out? (I was hoping thrift would give astyanax a better error than it did :( )…. 2. Anyone know if I am feeding my composite column info incorrectly belo

RE: Cannot create CF in Cassandra 1.1.2

Now I got tired of this, so I cleaned up everything and started from the empty keyspace. Everything is ok so far. How can I prevent this from happening in the future? -Original Message- From: Leonid Ilyevsky [mailto:lilyev...@mooncapital.com] Sent: Tuesday, July 31, 2012 3:11 PM To: 'user

RE: Cannot create CF in Cassandra 1.1.2

Yes, I tried it now with CLI, the same thing. No error, it says that schema agrees across the cluster, but when I call "describe", the new column family is not there. Another proof is, I can repeat the same create statement multiple times, and it does not complain that it exists already. I am p

RE: Cannot create CF in Cassandra 1.1.2

No, I am using cql 3, but it should not matter. The point is, it used to work, and I am sure that if I just clean up the whole thing and start from scratch, it will work again. Something got corrupted. But I will give a shot to the cli, just to rule out any cql 3 issues. -Original Message---

Re: Cannot create CF in Cassandra 1.1.2

I believe u r using cassandra-cli. Please use "help create" for the proper syntax.. See http://wiki.apache.org/cassandra/DataModel/ for cassandra datamodel. Also, the flushing events are expected. For example run "create keyspace " , "use " , "create column family " This should work with default

How to create a COLUMNFAMILY with Leveled Compaction?

Sorry for my stupid simple question. How to create a COLUMNFAMILY with Leveled Compaction? There is no example in documentation: http://www.datastax.com/docs/1.1/configuration/storage_configuration#compaction-strategy I try it on Cassandra 1.1.0 and 1.1.2, both failed. The COLUMNFAMILY is still '

Cannot create CF in Cassandra 1.1.2

My cassandra used to work fine, now it does not create a table. No error message, but the table is not there. I execute "create table" statement many times, the same thing. When I do it, I see in the system.log the the lines below. What can be the problem? Pre-history: before I noticed it is bro

Re: unsubscribe

On Mon, Jul 30, 2012 at 8:31 PM, Alvin UW wrote: > thx http://wiki.apache.org/cassandra/FAQ#unsubscribe You are welcome. -- Eric Evans Acunu | http://www.acunu.com | @acunu

Re: Read latency skyrockets after 95-98th percentile

Victor, the data is a single composite column with a string value. The key is a UTF8 string I can reproduce this exact behavior with only 100 of these items on a 2GB heap. Also, please see -XX:+PrintGCDetails output below, i'm not convinced it's GC. With a 100 items no garbage collection is log

RE: Read latency skyrockets after 95-98th percentile

What is a data load? Does it fits in RAM? I bet it's due to GC. Since this is a 1 node only, dynamic snitch is out of scope. Best regards / Pagarbiai Viktor Jevdokimov Senior Developer Email: viktor.jevdoki...@adform.com Phone: +370 5 212 3063, Fax +370 5

Read latency skyrockets after 95-98th percentile

hey list, i've been trying to understand why we are seeing rather nasty read latency peaks in as much as 2% of our total read ( not sure what the underlying thrift call is, should be get_slice ) requests that we have been **unable to tie to garbage collection or blocking I/O.** This is what i m

[RELEASE] Apache Cassandra 1.0.11 released

The Cassandra team is pleased to announce the release of Apache Cassandra version 1.0.11. Cassandra is a highly scalable second-generation distributed database, bringing together Dynamo's fully distributed design and Bigtable's ColumnFamily-based data model. You can read more here: http://cassan

Re: Creating counter columns in cassandra

Hi all, Thanks all for the valuable feedback. I have a problem with running queries with Cqlsh. My query is SELECT * FROM rule1 WHERE sms=3; java.lang.NumberFormatException: An hex string representing bytes must have an even length at org.apache.cassandra.utils.Hex.hexToBytes(Hex.java:52) at org.