Re: Query first 1 columns for each partitioning keys in CQL?

2014-05-17 Thread 後藤 泰陽
Hello, Thank you for your addressing. But I consider LIMIT to be a keyword to limits result numbers from WHOLE results retrieved by the SELECT statement. The result with SELECT.. LIMIT is below. Unfortunately, This is not what I wanted. I wante latest posts of each authors. (Now I doubt if CQL3

Re: Index with same Name but different keyspace

2014-05-17 Thread Mark Reddy
Can you share your schema and the commands you are running? On Thu, May 15, 2014 at 7:54 PM, mahesh rajamani wrote: > Hi, > > I am using Cassandra 2.0.5 version. I trying to setup 2 keyspace with same > tables for different testing. While creating index on the tables, I > realized I am not able

Re: Data modeling for Pinterest-like application

2014-05-17 Thread DuyHai Doan
"A related question is whether it is a good idea to denormalize on read-heavy part of data while normalize on other less frequently-accessed data?" Heavy read -> denormalize Less frequently accessed data -> it depends how "less frequent" it is and whether it's complicated to denormalize in your

Re: Query first 1 columns for each partitioning keys in CQL?

2014-05-17 Thread DuyHai Doan
Clearly with your current data model, having X latest post for each author is not possible. However, what's about this ? CREATE TABLE latest_posts_per_user ( author ascii latest_post map, PRIMARY KEY (author) ) The latest_post will keep a collection of X latest posts for each user. No

Re: What % of cassandra developers are employed by Datastax?

2014-05-17 Thread Peter Lin
if you look at the new committers since 2012 they are mostly datastax On Fri, May 16, 2014 at 9:14 PM, Kevin Burton wrote: > so 30%… according to that data. > > > On Thu, May 15, 2014 at 4:59 PM, Michael Shuler wrote: > >> On 05/14/2014 03:39 PM, Kevin Burton wrote: >> >>> I'm curious what % of

Re: Query first 1 columns for each partitioning keys in CQL?

2014-05-17 Thread Matope Ono
Hmm. Something like a user-managed-index looks the only way to do what I want to do. Thank you, I'll try that. 2014-05-17 18:07 GMT+09:00 DuyHai Doan : > Clearly with your current data model, having X latest post for each author > is not possible. > > However, what's about this ? > > CREATE TAB

Re: What % of cassandra developers are employed by Datastax?

2014-05-17 Thread Dave Brosius
The question assumes that it's likely that datastax employees become committers. Actually, it's more likely that committers become datastax employees. So this underlying tone that datastax only really 'wants' datastax employees to be cassandra committers, is really misleading. Why wouldn't a

Re: Best partition type for Cassandra with JBOD

2014-05-17 Thread James Campbell
Thanks for the thoughts! On May 16, 2014 4:23 PM, Ariel Weisberg wrote: Hi, Recommending nobarrier (mount option barrier=0) when you don't know if a non-volatile cache in play is probably not the way to go. A non-volatile cache will typically ignore write barriers if a given block device is co

Re: Tombstones

2014-05-17 Thread Dimetrio
Thanks! How could I find leveled json manifest? -- View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Tombstones-tp7594467p7594535.html Sent from the cassandra-u...@incubator.apache.org mailing list archive at Nabble.com.

Re: What % of cassandra developers are employed by Datastax?

2014-05-17 Thread Jack Krupansky
I would note that the original question was about “developers”, not “committers” per se. I sort of assumed that the question implied the latter, but that’s not necessarily true. One can “develop” and optionally “contribute” code without being a committer, per se. There are probably plenty of use

RE: Tombstones

2014-05-17 Thread Andreas Finke
Hi Dimetrio, >From the wiki: Since 0.6.8, minor compactions also GC tombstones Regards Andi Dimetrio wrote Does cassandra delete tombstones during simple LCS compaction or I should use node tool repair? Thanks. -- View this message in context: http://cassandra-user-incubator-ap

Re: Data modeling for Pinterest-like application

2014-05-17 Thread ziju feng
I was thinking to use counter type a separate pin counter table and, when I need to update the like count, I would use read-after-write to get the current value and timestamp and then denormalize into pin's detail table and board tables. Is it a viable solution in this case? Thanks -- View th

initial token crashes cassandra

2014-05-17 Thread Tim Dunphy
Hey all, I've set my initial_token in cassandra 2.0.7 using a python script I found at the datastax wiki. I've set the value like this: initial_token: 85070591730234615865843651857942052864 And cassandra crashes when I try to start it: [root@beta:/etc/alternatives/cassandrahome] #./bin/cassan

Java fluent interface for CQL

2014-05-17 Thread Kevin Burton
In our MySQL stack we've been using a fluent interface for Java I developed about five years ago but never open sourced. It's similar to: MSelect sele = MSelect.newInstance(); sele.addTable( Foo.NAME ) .addWhereIsEqual( Foo.COL_A, "bar" ) .setLimit( 10 ) ; … of course embedding CQL

Re: initial token crashes cassandra

2014-05-17 Thread Colin
You may have used the old random partitioner token generator. Use the murmur partitioner token generator instead. -- Colin 320-221-9531 > On May 17, 2014, at 1:15 PM, Tim Dunphy wrote: > > Hey all, > > I've set my initial_token in cassandra 2.0.7 using a python script I found > at the dat

Re: Java fluent interface for CQL

2014-05-17 Thread Kevin Burton
AH… looks like there's one in the Datastax java driver. Looks like it doesn't support everything but probably supports the features I need ;) So I'll just use that! On Sat, May 17, 2014 at 12:39 PM, Kevin Burton wrote: > In our MySQL stack we've been using a fluent interface for Java I > deve

Re: initial token crashes cassandra

2014-05-17 Thread Tim Dunphy
Hi and thanks for your response. The puzzling thing is that yes I am using the murmur partition, yet I am still getting the error I just told you guys about: [root@beta:/etc/alternatives/cassandrahome] #grep -i partition conf/cassandra.yaml | grep -v '#' partitioner: org.apache.cassandra.dht.Murm

Re: Java fluent interface for CQL

2014-05-17 Thread Tupshin Harper
Pull requests encouraged. :) -Tupshin On May 17, 2014 7:43 PM, "Kevin Burton" wrote: > AH… looks like there's one in the Datastax java driver. Looks like it > doesn't support everything but probably supports the features I need ;) > > So I'll just use that! > > > On Sat, May 17, 2014 at 12:39 P

Re: initial token crashes cassandra

2014-05-17 Thread Colin Clark
You probably generated the wrong token type. Look for a murmur token generator on the Datastax site. -- Colin 320-221-9531 On May 17, 2014, at 7:00 PM, Tim Dunphy wrote: Hi and thanks for your response. The puzzling thing is that yes I am using the murmur partition, yet I am still getting th

Re: initial token crashes cassandra

2014-05-17 Thread Dave Brosius
What Colin is saying is that the tool you used to create the token, is not creating tokens usable for the Murmur3Partitioner. That tool is probably generating tokens for the (original) RandomPartitioner, which has a different range. On 05/17/2014 07:20 PM, Tim Dunphy wrote: Hi and thanks for

Re: initial token crashes cassandra

2014-05-17 Thread Tim Dunphy
> > You probably generated the wrong token type. Look for a murmur token > generator on the Datastax site. What Colin is saying is that the tool you used to create the token, is not > creating tokens usable for the Murmur3Partitioner. That tool is probably > generating tokens for the (original) R

vcdiff/bmdiff , cassandra , and the ordered partitioner…

2014-05-17 Thread Kevin Burton
So I see that Cassandra doesn't support bmdiff/vcdiff. Is this primarily because most people aren't using the ordered partitioner? bmdiff gets good compression by storing similar content next to each page on disk. So lots of HTML content would compress well. but if everything is being stored a

Re: vcdiff/bmdiff , cassandra , and the ordered partitioner…

2014-05-17 Thread Colin
Cassandra offers compression out of the box. Look into the options available upon table creation. The use of orderedpartitioner is an anti-pattern 999/1000 times. It creates hot spots - the use of wide rows can often accomplish the same result through the use of clustering columns. -- Colin

Re: initial token crashes cassandra

2014-05-17 Thread Colin Clark
Looks like you may have put the token next to num-tokens property in the yaml file for one node. I would double check the yaml's to make sure the tokens are setup correctly and that the ip addresses are associated with the right entries as well. Compare them to a fresh download if possible to see

Re: initial token crashes cassandra

2014-05-17 Thread Tim Dunphy
Hey Colin, Looks like you may have put the token next to num-tokens property in the > yaml file for one node. I would double check the yaml's to make sure the > tokens are setup correctly and that the ip addresses are associated with > the right entries as well. > Compare them to a fresh download

Re: vcdiff/bmdiff , cassandra , and the ordered partitioner…

2014-05-17 Thread Kevin Burton
"compression" … sure.. but bmdiff? Not that I can find. BMDiff is an algorithm that in some situations could result in 10x compression due to the way it's able to find long commons runs. This is a pathological case though. But if you were to copy the US constitution into itself … 10x… bm