Re: The mutations to delete sub-columns can't be batched?

2010-12-27 Thread Ran Tavory
an oversight as well. as you can imagine, non of us is a fan of super columns... On Tue, Dec 28, 2010 at 6:28 AM, Roshan Dawrani wrote: > Hi, > > I think I may have found another oversight on the Hector API. > > OrderedRows has a convenient peekLast() method, but it is missing in > OrderedSuperRo

can't bootstrap new node

2010-12-27 Thread Nick S Kanakakorn
I have a 3 nodes cluster with replication factor = 3. I'm testing a complete node failure scenario. Here is my work flow. 1. Bring down node #3. We'll simulate that this node has failed. 2. Bring up a new node #4 with different IP address. Set bootstrap = True. Start cassandra. The 4th did n

Re: Supercolumn Maximums

2010-12-27 Thread David G. Boney
I am confused. In NEWS.txt in the source code, it says for Cassandra 7.0,"Row size limit increased from 2GB to 2 billion columns". Does this mean that the maximum number of supercolumns is also 2 billion? I am not asking about secondary indexes. I am asking if the keys for the supercolumns are

Re: Supercolumn Maximums

2010-12-27 Thread Narendra Sharma
#1 - No limit #2 - If you are referring to secondary indexes then NO. Also see https://issues.apache.org/jira/browse/CASSANDRA-598 #3 - No limit Following are key limitations: 1. All data for a single row must fit (on disk) on a single machine in the cluster 2. A single column value may not be lar

Re: Any GUI for Cassandra database on Windows?

2010-12-27 Thread Roshan Dawrani
Sorry. Will do that. I am using Cassandra 0.7.0-rc2. I will try this DB client. Thanks. On Tue, Dec 28, 2010 at 10:41 AM, Narendra Sharma wrote: > Please do mention the Cassandra version you are using in all ur queries. It > helps. > > Try https://github.com/driftx/chiton > > Thanks, > Naren >

Re: Any GUI for Cassandra database on Windows?

2010-12-27 Thread Narendra Sharma
Please do mention the Cassandra version you are using in all ur queries. It helps. Try https://github.com/driftx/chiton Thanks, Naren On Mon, Dec 27, 2010 at 7:37 PM, Roshan Dawrani wrote: > Hi, > > Is there a GUI client for a Cassandra database for a Windows based setup? > > I tried the one av

Supercolumn Maximums

2010-12-27 Thread David G. Boney
1. What are the maximum number of supercolumns that a row can have? 2. Are supercolumns indexed? 3. What are the maximum number of subcolumns in a supercolumn? - Sincerely, David G. Boney dbon...@semanticartifacts.com http://www.semanticartifacts.com

Re: The mutations to delete sub-columns can't be batched?

2010-12-27 Thread Roshan Dawrani
Hi, I think I may have found another oversight on the Hector API. OrderedRows has a convenient peekLast() method, but it is missing in OrderedSuperRows. I am trying to get the rows in a batched manner, and being able to peek at the last one to make it the start key of the next batch is convenien

Any GUI for Cassandra database on Windows?

2010-12-27 Thread Roshan Dawrani
Hi, Is there a GUI client for a Cassandra database for a Windows based setup? I tried the one available at http://code.google.com/p/cassandra-gui/, but it always fails to connect with "error: Cannot read. Remote site has closed. Tried to read 4 bytes, but only got 0 bytes." -- Roshan Blog: http

Re: read repair across datacenters?

2010-12-27 Thread Jonathan Ellis
https://issues.apache.org/jira/browse/CASSANDRA-982 On Mon, Dec 27, 2010 at 5:55 PM, Shu Zhang wrote: > Brandon, for a read with quorum CL, a response is returned to the client > after half (rounded up) the replica nodes responds. Do you mean that those > half are RR'ed before the response is r

RE: read repair across datacenters?

2010-12-27 Thread Shu Zhang
Brandon, for a read with quorum CL, a response is returned to the client after half (rounded up) the replica nodes responds. Do you mean that those half are RR'ed before the response is returned to the client and the other half RR'ed asynchronously? Or is it that the other half of replicas are n

Re: Having trouble getting cassandra to stay up

2010-12-27 Thread Alex Quan
I started over and used a m1 type instance and everything seems to be working fine now, thanks for all the help Alex On Mon, Dec 27, 2010 at 7:18 AM, Gary Dusbabek wrote: > You might want to try starting over. Configure your initial keyspaces > in conf/cassandra.yaml and load them into your cl

Re: read repair across datacenters?

2010-12-27 Thread Brandon Williams
On Mon, Dec 27, 2010 at 4:44 PM, Narendra Sharma wrote: > The comment in the cassandra.yaml says: > "specifies the probability with which read repairs should be invoked on * > non-quorum* reads" > > Does this mean RR chance is applicable only for non-quorum reads? > Yes, because on quorum or grea

Re: read repair across datacenters?

2010-12-27 Thread Narendra Sharma
The comment in the cassandra.yaml says: "specifies the probability with which read repairs should be invoked on * non-quorum* reads" Does this mean RR chance is applicable only for non-quorum reads? Another question on same topic: Will RR use one of the node in the other datacenter as coordinat

Re: read repair across datacenters?

2010-12-27 Thread Brandon Williams
On Mon, Dec 27, 2010 at 3:17 PM, Shu Zhang wrote: > Hi, I'm pretty new to cassandra and read a couple of contradictory things > on this topic. Does read repair get triggered across datacenters if you > query with a consistency level of local_quorum? > If the RR chance is 100% (default), it's tri

read repair across datacenters?

2010-12-27 Thread Shu Zhang
Hi, I'm pretty new to cassandra and read a couple of contradictory things on this topic. Does read repair get triggered across datacenters if you query with a consistency level of local_quorum? Thanks, Shu

Re: complexity

2010-12-27 Thread Brandon Williams
On Fri, Dec 24, 2010 at 10:35 PM, Kevin Irwig wrote: > thanks all - and just to clarify the cost of getting a column (and a column > given a SuperColumn) is also O(log N) ? > Since subcolumns are not indexed ( https://issues.apache.org/jira/browse/CASSANDRA-598) retrieving them from a SuperColu

Re: I have TimeUUID sorted keys. Can I get the range query return rows in the same order as sorted keys?

2010-12-27 Thread Roshan Dawrani
Thanks for the references. I will have a look at them to become familiar with them. But for now, my rather simplistic need is fulfilled by first getting the time-sorted keys from sub-columns and then arranging the result of a multi_get_slice_query in the same order at the app level. For now I don

Re: I have TimeUUID sorted keys. Can I get the range query return rows in the same order as sorted keys?

2010-12-27 Thread Tyler Hobbs
Might as well link to this nice article for any discussions of OPP vs RP: http://ria101.wordpress.com/2010/02/22/cassandra-randompartitioner-vs-orderpreservingpartitioner/ - Tyler On Mon, Dec 27, 2010 at 11:18 AM, Narendra Sharma wrote: > You will need to use OPP to perform range scans. Look f

Re: I have TimeUUID sorted keys. Can I get the range query return rows in the same order as sorted keys?

2010-12-27 Thread Narendra Sharma
You will need to use OPP to perform range scans. Look for Range Queries on http://wiki.apache.org/cassandra/DataModel Look at this to understand why range queries are not supported for RamdomPartitioner (https://issues.apache.org/jira/browse/CASSANDRA-1750) Thanks, Naren On Mon, Dec 27, 2010 at

How to setup a big shared files system

2010-12-27 Thread nicolas lattuada
Hi I am working for an afiliate marketing program, we are logging a lot of data, and thinking about using Cassandra. But i wonder which is the way to setup properly a cassandra cluster. For example let s say i would like to store about 100 000 Giga bytes of data, and will need to access them

Re: The mutations to delete sub-columns can't be batched?

2010-12-27 Thread Nate McCall
Huh. That appears to be an oversight on our part. I'll add an addSubDeletion to the Mutator class in trunk. Thank you for bringing this up. On Sun, Dec 26, 2010 at 10:47 PM, Roshan Dawrani wrote: > There doesn't really seem to be an inherent limitation in batching > sub-column deletes. > > Pelops

Re: I have TimeUUID sorted keys. Can I get the range query return rows in the same order as sorted keys?

2010-12-27 Thread Roshan Dawrani
I had seen RangeSlicesQuery, but I didn't notice that I could also give a key range there. How does a KeyRange work? Doesn't it need some sort from the partitioner - whether that is order preserving or not? I couldn't be sure of a query that was based on order of the rows in the column family, so

Re: I have TimeUUID sorted keys. Can I get the range query return rows in the same order as sorted keys?

2010-12-27 Thread Narendra Sharma
Did you look at get_range_slices? Once you get the columns from super column, pick the first and last to form the range and fire the get_range_slice. Thanks, -Naren On Mon, Dec 27, 2010 at 6:12 AM, Roshan Dawrani wrote: > This silly question is retrieved back with apology. There couldn't be > an

Re: Having trouble getting cassandra to stay up

2010-12-27 Thread Gary Dusbabek
You might want to try starting over. Configure your initial keyspaces in conf/cassandra.yaml and load them into your cluster with bin/schematool. That nasty stack trace indicates the server is getting data that is not formatted the way it expects. Please verify that your cassandra servers are bo

Re: I have TimeUUID sorted keys. Can I get the range query return rows in the same order as sorted keys?

2010-12-27 Thread Roshan Dawrani
This silly question is retrieved back with apology. There couldn't be anything easier to handle at the application level. rgds, Roshan On Mon, Dec 27, 2010 at 9:04 AM, Roshan Dawrani wrote: > Hi, > I have the following 2 column families - one being used to store full rows > for an entity and oth

Re: Adding secondary index: java.lang.ArithmeticException: / by zero

2010-12-27 Thread Timo Nentwig
On Dec 24, 2010, at 14:33, Timo Nentwig wrote: > Any advice what to do with it? So, to continue this monologue: I reduced the memtable size for that CF and the by means of the MBeans figured out that the secondary index is a CF as well which presumably also holds up to 3 memtables in memory...