RowKey in hexadecimal in CLI

Hello! Since we installed cassandra 0.8, the RowKeys are displayed in hexadecimal in the CLI. Any idea why and how to fix that? Thanks in advance Sebastien

Re: CQL where clause and "OR"

> > hi!, > > It`s posible > > for exemple: > > select * from aw_advancednewsletter_subscriptions where id='1' OR id='3'; > > > > > > Un Saludo > > Miguel Ángel Ausó > > > > > > 2011/5/2 Sébastien Druon > >

CQL where clause and "OR"

Hi! Is it possible to use an "OR" operator in the "WHERE" clause of a "SELECT" statement? I do not find any documentation on that i.e. SELECT name1 FROM cf1 WHERE name1=value1 OR name1=value2 Thanks a lot in advance Sébastien Druon

query all the rows having a specific column defined, with Hector

Hi! I would like to query all the rows having a specific column defined, with Hector For example: - CF is a column family - rows 1 and 3 contain columns A and B - rows 2 and 4 contain column A only as a result of a query "column A" I would like to get rows 1-4, with column A inside as a result of

Error on startup after upgrading from 0.7.0 to 0.7.4

Hello After having updgraded from 0.7.0 to 0.7.4, cassandra does not start anymore. I have the following errot stack: INFO 11:47:04,112 Finished reading /var/lib/cassandra/commitlog/CommitLog-1296815168287.log ERROR 11:47:04,114 Exception encountered during startup. java.lang.NullPointerExceptio

Re: Secondary indexes on super columns

Thanks a lot for the info Sebastien On 2 February 2011 16:53, Jonathan Ellis wrote: > On Wed, Feb 2, 2011 at 7:37 AM, Sébastien Druon > wrote: > > Hi! > > I would like to know if secondary indexes are foreseen for super columns > / > > columns inside of super co

Secondary indexes on super columns

Hi! I would like to know if secondary indexes are foreseen for super columns / columns inside of super columns? If yes, will it be in a near future? Thanks a lot in advance Sébastien Druon

Cassandra and count

Hello, I have a question concerning count in cassandra, as I would like to count the rows of a CF: - is it mandatory to specify a range? - what is the cost of a count operation on a CF? Thanks in advance for the answers Sebastien

Cassandra automatic startup script on ubuntu

Hello! I am using cassandra on a ubuntu machine and installed it from the binary found on the cassandra home page. However, I did not find any scripts to start it up at boot time. Where can I find this kind of script? Thanks a lot in advance Sebastien

Hector and secondary indexes

Hello! How is it possible to query a secondary index with Hector? The equivalent of the following CLI command for example: get users where birth_date = 1973; with a secondary index defined on birth_date Thanks in advance for the help Sebastien Druon

Re: N to N relationships

serve these queries. > > > Hope that helps. > Aaron > > > > On 10 Dec, 2010,at 07:02 AM, Sébastien Druon > wrote: > > > > I mean if I have secondary indexes. Appa

Re: N to N relationships

I mean if I have secondary indexes. Apparently they are calculated in the background... On 9 December 2010 18:33, David Boxenhorn wrote: > What do you mean by indexing? > > On Thu, Dec 9, 2010 at 7:30 PM, Sébastien Druon wrote: > >> Thanks a lot for the answer >> >>

Re: N to N relationships

> column (N gets), and it would be very easy to add element N+1. > > > On Thu, Dec 9, 2010 at 1:48 PM, Sébastien Druon wrote: > >> Hello, >> >> For a specific case, we are thinking about representing a N to N >> relationship with a NxN Matrix in Cassandra. &

N to N relationships

+1. What impact in terms of time would it have on the indexation job? Thanks a lot for the answers, Best regards, Sébastien Druon