Re: write timeout

2015-03-23 Thread Anishek Agarwal
Forgot to mention I am using Cassandra 2.0.13 On Mon, Mar 23, 2015 at 5:59 PM, Anishek Agarwal anis...@gmail.com wrote: Hello, I am using a single node server class machine with 16 CPUs with 32GB RAM with a single drive attached to it. my table structure is as below CREATE TABLE t1(id

Re: 2d or multi dimension range query in cassandra CQL

2015-03-23 Thread Asit KAUSHIK
i am using Startio Cassandra it way better than stargate as it works on the latest release of Cassandra and is better on my performance. we are using it for fulltext search use case Regards Asit On Sun, Mar 22, 2015 at 12:14 PM, Mehak Mehta meme...@cs.stonybrook.edu wrote: Hi, On the basis

write timeout

2015-03-23 Thread Anishek Agarwal
Hello, I am using a single node server class machine with 16 CPUs with 32GB RAM with a single drive attached to it. my table structure is as below CREATE TABLE t1(id bigint, ts timestamp, cat1 settext, cat2 settext, lat float, lon float, a bigint, primary key (id, ts)); I am trying to insert

Re: cassandra triggers

2015-03-23 Thread Asit KAUSHIK
attached is the code . You follow the process for compiling and using the code. If anything more is required please let me know. The Jar file has to be put into /usr/share/cassandra/conf/triggers. Hope this helps Regards asit On Mon, Mar 23, 2015 at 3:20 PM, Rahul Bhardwaj

Re: write timeout

2015-03-23 Thread Brian Tarbox
My group is seeing the same thing and also can not figure out why its happening. On Mon, Mar 23, 2015 at 8:36 AM, Anishek Agarwal anis...@gmail.com wrote: Forgot to mention I am using Cassandra 2.0.13 On Mon, Mar 23, 2015 at 5:59 PM, Anishek Agarwal anis...@gmail.com wrote: Hello, I am

Re: cassandra triggers

2015-03-23 Thread Jason Wee
okay, if you leave a comment in the blog on what is breaking and what cassandra, I can take a look at the code when I get the time. :-) jason On Mon, Mar 23, 2015 at 8:15 PM, Asit KAUSHIK asitkaushikno...@gmail.com wrote: attached is the code . You follow the process for compiling and using

Re: Unknown CF / Schema OK

2015-03-23 Thread Tim Olson
I did figure this out: When adding a columnfamily, the query timed out before all nodes replied, and I sent the schema out again. Half the nodes ended up with the CF having UUID A and half the nodes ended up with the new CF but UUID B. UnknownColumnFamilyExceptions were thrown until the enqueued

Re: cassandra triggers

2015-03-23 Thread Rahul Bhardwaj
Yes Asit you can share it with me, let c if we can implement with our requirement. Regards: Rahul Bhardwaj On Mon, Mar 23, 2015 at 1:43 PM, Asit KAUSHIK asitkaushikno...@gmail.com wrote: Hi Rahul, i have created a trigger which inserts a default value into the table. But everyone are

Re: Really high read latency

2015-03-23 Thread Dave Galbraith
Duncan: I'm thinking it might be something like that. I'm also seeing just a ton of garbage collection on the box, could it be pulling rows for all 100k attrs for a given row_time into memory since only row_time is the partition key? Jens: I'm not using EBS (although I used to until I read up on

Re: Really high read latency

2015-03-23 Thread Jens Rantil
Also, two control questions: - Are you using EBS for data storage? It might introduce additional latencies. - Are you doing proper paging when querying the keyspace? Cheers, Jens On Mon, Mar 23, 2015 at 5:56 AM, Dave Galbraith david92galbra...@gmail.com wrote: Hi! So I've got a table

Re: Logging client ID for YCSB workloads on Cassandra?

2015-03-23 Thread Jatin Ganhotra
Sure. I updated the YCSB code to pass a client ID as input parameter and then stored the clientID in the properties and used it in the DBWrapper class for logging per operation *YCSB/core/src/main/java/com/yahoo/ycsb/DBWrapper.java* Please let me know if you need more information and I can share

Fwd: [RELEASE] Kundera-2.16 (Added support for Cassandra's UDTs)

2015-03-23 Thread karthik prasad
On Tuesday, 17 March 2015 22:42:30 UTC+5:30, Chhavi Gangwal wrote: Hi All, We are happy to announce Kundera-2.16 release. Kundera is a JPA 2.1 compliant, polyglot object-datastore mapping library for NoSQL datastores. The idea behind Kundera is to make working with NoSQL databases

Cassandra time series + Spark

2015-03-23 Thread Rumph, Frens Jan
Hi, I'm working on a system which has to deal with time series data. I've been happy using Cassandra for time series and Spark looks promising as a computational platform. I consider chunking time series in Cassandra necessary, e.g. by 3 weeks as kairosdb does it. This allows an 8 byte chunk

Re: cassandra triggers

2015-03-23 Thread Asit KAUSHIK
Hi Rahul, i have created a trigger which inserts a default value into the table. But everyone are against using it. As its an external code which may be uncompatible in future releases. Its was a chnallenge as all the examples are of old 2.0.X veresion where RowMutable package is used which is

Re: Really high read latency

2015-03-23 Thread Chris Lohfink
Compacted partition maximum bytes: 36904729268 thats huge... 36gb rows are gonna cause a lot of problems, even when you specify a precise cell under this it still is going to have an enormous column index to deserialize on every read for the partition. As mentioned above, you should include

Re: Really high read latency

2015-03-23 Thread Dave Galbraith
I haven't deleted anything. Here's output from a traced cqlsh query (I tried to make the spaces line up, hope it's legible): Execute CQL3 query | 2015-03-23 21:04:37.422000 | 172.31.32.211 | 0 Parsing select * from default.metrics where row_time = 16511 and attrs = '[redacted]' limit

Re: 2d or multi dimension range query in cassandra CQL

2015-03-23 Thread Mehak Mehta
Hi, I checked Startio Cassandra but couldn't get any good documentation for the same. Can you give me some pointers on how to use it. Do I have to build it from the source or I can use it directly with jar files as in case of Stargate. Since I was looking for solution which I don't need a full

Re: cassandra triggers

2015-03-23 Thread Robert Coli
On Sun, Mar 22, 2015 at 10:31 PM, Rahul Bhardwaj rahul.bhard...@indiamart.com wrote: I want to use triggers in cassandra. Is there any tutorial on creating triggers in cassandra . For the record, it is my understanding that you almost certainly should not use the current Cassandra triggers

Re: write timeout

2015-03-23 Thread Robert Coli
On Mon, Mar 23, 2015 at 7:27 AM, Brian Tarbox briantar...@gmail.com wrote: My group is seeing the same thing and also can not figure out why its happening. On Mon, Mar 23, 2015 at 8:36 AM, Anishek Agarwal anis...@gmail.com wrote: Forgot to mention I am using Cassandra 2.0.13 This seems

Re: Really high read latency

2015-03-23 Thread Eric Stevens
Enable tracing in cqlsh and see how many sstables are being lifted to satisfy the query (are you repeatedly writing to the same partition [row_time]) over time?). Also watch for whether you're hitting a lot of tombstones (are you deleting lots of values in the same partition over time?). On Mon,

Re: 2d or multi dimension range query in cassandra CQL

2015-03-23 Thread Andres de la Peña
Hi, You can download Stratio Cassandra binaries from https://s3.amazonaws.com/stratioorg/cassandra/stratio-cassandra-2.1.3.1-bin.tar.gz You can get info about how to build and getting started at its README file https://github.com/Stratio/stratio-cassandra/blob/master/README.md. More detailed

Re: Really high read latency

2015-03-23 Thread Ben Bromhead
nodetool cfhistograms is also very helpful in diagnosing these kinds of data modelling issues. On 23 March 2015 at 14:43, Chris Lohfink clohfin...@gmail.com wrote: Compacted partition maximum bytes: 36904729268 thats huge... 36gb rows are gonna cause a lot of problems, even when you

Deleted columns reappear after repair

2015-03-23 Thread Roman Tkachenko
Hey guys, We're having a very strange issue: deleted columns get resurrected when repair is run on a node. Info about the setup. Cassandra 2.0.13, multi datacenter with 12 nodes in one datacenter and 6 nodes in another one. Schema: cqlsh describe keyspace blackbook; CREATE KEYSPACE blackbook