Re: Hadoop jobs and data locality

2013-05-04 Thread Shamim
Hello,   We have also came across this issue in our dev environment, when we upgrade Cassandra from 1.1.5 to 1.2.1 version. I have mentioned this issue in few times in this forum but haven't got any answer yet. For quick work around you can use pig.splitCombination false in your pig script to av

Cassandra running High Load with no one using the cluster

2013-05-04 Thread Aiman Parvaiz
Since last night I am seeing CPU load spikes on our cassandra boxes(Occasionally load goes up to 20, its a Amazon EC2 c1.xlarge with 300 iops EBS). After digging around a little I believe its related to heap memory and flushing memtables. >From logs: WARN 03:22:03,414 Heap is 0.7786981388910019 fu

hector or astyanax

2013-05-04 Thread 李 晗
hello, i want to know which cassandra client is better? and what are their advantages and disadvantages? thanks

Re: Look table structuring advice

2013-05-04 Thread Dave Brosius
I just used 'synthetic key' as it's a term used with standard rdbms to mean a key that means nothing in the model, and is often a sequence or such. There's nothing particular to cassandra specific to that term. Just thought it would be something familiar to someone who understood rdbms. On 05

Re: Look table structuring advice

2013-05-04 Thread Jabbar Azam
I never thought about using a synthetic key, but in this instance with about a dozen rows it's probably ok. Thanks for your great idea. Where did you read about the synthetic key idea? I've not come across it before. Thanks Jabbar Azam On 4 May 2013 19:30, Dave Brosius wrote: > if you want

Re: Look table structuring advice

2013-05-04 Thread Dave Brosius
if you want to store all the roles in one row, you can do create table roles (synthetic_key int, name text, primary key(synthetic_key, name)) with compact storage when inserting roles, just use the same key insert into roles (synthetic_key, name) values (0, 'Programmer'); insert into roles (s

Look table structuring advice

2013-05-04 Thread Jabbar Azam
Hello, I want to create a simple table holding user roles e.g. create table roles ( name text, primary key(name) ); If I want to get a list of roles for some admin tool I can use the following CQL3 select * from roles; When a new name is added it will be stored on a different hos

Re: cql query

2013-05-04 Thread Sri Ramya
thanks for ur reply. On Fri, May 3, 2013 at 11:45 PM, Jabbar Azam wrote: > Sorry Sri, I've never used hector. How ever it's straightforward in > astyanax. There are examples on the github page. > On 3 May 2013 18:50, "Sri Ramya" wrote: > >> Can you tell me how to do this in hector. Can you gi

Re: SSTables not opened on new cluste

2013-05-04 Thread Philippe
After trying every possible combination of parameters, config and the rest, I ended up downgrading the new node from 1.1.11 to 1.1.2 to match the existing 3 nodes. And that solved the issue immediately : the schema was propagated and the node started handling reads & writes. 2013/5/3 Philippe >