Re: Any ODBC/JDBC driver for Cassandra

2010-10-01 Thread Andrey V. Panov
But there few other drivers for connecting to cassandra. On 1 October 2010 23:58, Weiping He wrote: > I new to Cassandra. I know it is not relational database and it is > NoSQL. Is there any ODBC/JDBC driver for Cassandra? > > > >

Re: [RELEASE] 0.7.0 beta2

2010-10-01 Thread Eric Evans
On Fri, 2010-10-01 at 14:01 -0700, B. Todd Burruss wrote: > i don't see a beta2 subversion tag. is there one? Sorry, the tag is there now. https://svn.apache.org/repos/asf/cassandra/tags/cassandra-0.7.0-beta2 -- Eric Evans eev...@rackspace.com

Re: How do I know when "nodetool snapshot" has completed?

2010-10-01 Thread Jonathan Ellis
It's a mix in 0.6 unfortunately. For 0.7 all have been converted to blocking. On Fri, Oct 1, 2010 at 4:06 PM, Jeremy Davis wrote: > Ok, cool. I thought all the nodetool commands were non blocking. > Thanks, > -JD > > On Fri, Oct 1, 2010 at 2:02 PM, Jonathan Ellis wrote: >> >> snapshot blocks un

Re: How do I know when "nodetool snapshot" has completed?

2010-10-01 Thread Jeremy Davis
Ok, cool. I thought all the nodetool commands were non blocking. Thanks, -JD On Fri, Oct 1, 2010 at 2:02 PM, Jonathan Ellis wrote: > snapshot blocks until it's finished. it's just fast. :) > > On Fri, Oct 1, 2010 at 3:52 PM, Jeremy Davis > wrote: > > > > Since "nodetool snapshot" returns immed

Re: How do I know when "nodetool snapshot" has completed?

2010-10-01 Thread Jonathan Ellis
snapshot blocks until it's finished. it's just fast. :) On Fri, Oct 1, 2010 at 3:52 PM, Jeremy Davis wrote: > > Since "nodetool snapshot" returns immediately, how do I know when the > snapshot process has completed. When is it safe to start copying/taring the > files to back them up elsewhere? >

Re: [RELEASE] 0.7.0 beta2

2010-10-01 Thread B. Todd Burruss
i don't see a beta2 subversion tag. is there one? On 10/01/2010 11:56 AM, Eric Evans wrote: It's like Christmas in October, but without the long lines. First, the obligatory disclaimer. This is beta software. It's like a teenage driver, it seems as though it's up to the task, and it almost i

How do I know when "nodetool snapshot" has completed?

2010-10-01 Thread Jeremy Davis
Since "nodetool snapshot" returns immediately, how do I know when the snapshot process has completed. When is it safe to start copying/taring the files to back them up elsewhere?

[RELEASE] 0.7.0 beta2

2010-10-01 Thread Eric Evans
It's like Christmas in October, but without the long lines. First, the obligatory disclaimer. This is beta software. It's like a teenage driver, it seems as though it's up to the task, and it almost is, but don't be too surprised if you find your trash cans and mailbox smashed. In other words,

Re: Sorting by secondary index

2010-10-01 Thread J T
Hi Jonathan, I don't suppose there's any plan to support subcolumns of supercolumns in secondary indexes in the future ? Regards Jason On Fri, Oct 1, 2010 at 4:18 PM, Jonathan Ellis wrote: > secondary index results are always sorted by indexed column value. > rows with the same index value ar

Re: UnavailableException when data grows

2010-10-01 Thread Rana Aich
And I'm still getting UnavailableException and TimedOutException when there Cassandra daemon is doing either Compaction or Garbage collection... On Thu, Sep 30, 2010 at 2:42 PM, Rana Aich wrote: > I ran the nodetool cleanup...but the scenario doesn't change... > > > On Thu, Sep 30, 2010 at 1:14

Re: Sorting by secondary index

2010-10-01 Thread Jonathan Ellis
No, additional expressions (the GTE here) only affect what rows come back and do not affect sort order. On Fri, Oct 1, 2010 at 10:55 AM, Petr Odut wrote: > OK, > I have a query with 2 expressions: > 1st: with GTE operator > 2nd: with EQ operator > both columns are indexed, but results are sorted

Re: Sorting by secondary index

2010-10-01 Thread Petr Odut
OK, I have a query with 2 expressions: 1st: with GTE operator 2nd: with EQ operator both columns are indexed, but results are sorted in token order (I should expect to be sorted by 1st expression column values). Am I correct? On Fri, Oct 1, 2010 at 5:18 PM, Jonathan Ellis wrote: > secondary ind

Re: Sorting by secondary index

2010-10-01 Thread Jonathan Ellis
secondary index results are always sorted by indexed column value. rows with the same index value are sorted in token order (although support for comparator order is planned). sorting by a different column is not possible to do efficiently server-side and therefore is left to the client. On Fri,

Sorting by secondary index

2010-10-01 Thread Petr Odut
Hi, is it possible to sort results based on secondary index search? Typical use case is to get most recent comments from specified group CF: comments * SI: group * SI: timestamp I've asked before, but I can't still found any information. Thanks -- Petr Odut [petr.o...@gmail.com]

Re: Any ODBC/JDBC driver for Cassandra

2010-10-01 Thread Jonathan Ellis
No. On Fri, Oct 1, 2010 at 9:58 AM, Weiping He wrote: > I new to Cassandra. I know it is not relational database and it is > NoSQL. Is there any ODBC/JDBC driver for Cassandra? > > > > -- Jonathan Ellis Project Chair, Apache Cassandra co-founder of Riptano, the source for professional Cassand

Any ODBC/JDBC driver for Cassandra

2010-10-01 Thread Weiping He
I new to Cassandra. I know it is not relational database and it is NoSQL. Is there any ODBC/JDBC driver for Cassandra?

Re: Can I retrieve specific key range from a table in RandomPartitioner?

2010-10-01 Thread ilndinesh
I cam through the same problem. I have set the end key same as start key, it worked. (Kinda temp fix...) -- View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Can-I-retrieve-specific-key-range-from-a-table-in-RandomPartitioner-tp5415347p5591681.html Se

Re: Secondary Indexes aren't updated when removing whole row

2010-10-01 Thread Jonathan Ellis
Yes, this is a bug. Can you create a ticket? On Fri, Oct 1, 2010 at 4:02 AM, Petr Odut wrote: > Hi, > I have CF User with secondary index on "email" column. > When I remove a whole row, > del User['row'] > SI is not updated and get_indexed_slices still returns the deleted data. > Is it still ope

Re: Secondary Indexes and Super/SubColumns, is it possible ??

2010-10-01 Thread Jonathan Ellis
On Fri, Oct 1, 2010 at 2:37 AM, J T wrote: > Hi, > I've managed to get secondary indexes working on Normal Columns. I've even > managed to get multiple IndexExpressions to work when querying. > However, its not clear to me > 1) If I should be able to have a secondary index on a sub-column of a > s

Re: OutOfMemory on deletes

2010-10-01 Thread Jonathan Ellis
this looks like compaction is OOMing while processing a large row. On Fri, Oct 1, 2010 at 1:36 AM, Sudhir j wrote: > Hi, > We are using cassandra 0.6.5 to store some analysis data. Recently we added > a timer task to remove data older than a month and deployed on a test > setup. > The removal wor

Secondary Indexes aren't updated when removing whole row

2010-10-01 Thread Petr Odut
Hi, I have CF User with secondary index on "email" column. When I remove a whole row, del User['row'] SI is not updated and get_indexed_slices still returns the deleted data. Is it still open bug? Using latest nightly build. -- Petr Odut [petr.o...@gmail.com]

Secondary Indexes and Super/SubColumns, is it possible ??

2010-10-01 Thread J T
Hi, I've managed to get secondary indexes working on Normal Columns. I've even managed to get multiple IndexExpressions to work when querying. However, its not clear to me 1) If I should be able to have a secondary index on a sub-column of a super-column 2) Assuming 1 is supported, how to speci