Re: cql query

thank you very much. i will try and let you know whether its working or not On Thu, May 2, 2013 at 7:04 PM, Jabbar Azam wrote: > Hello Sri, > > As far as I know you can if name and age are part of your partition key > and timestamp is the cluster key e.g. > > create table columnfamily ( > n

Re: Failing to install C* error

Indeed, I figured this post is outdated. The proper location of the packages is deb http://www.apache.org/dist/cassandra/debian 12x main Arthur Original Message From: Arthur Zubarev To: user Sent: Thu, May 2, 2013 10:59 pm Subject: Failing to install C* error Hello: I am

Cassandra won't restart : 7365....6c73 is not defined as a collection

Hello, I'm running a 3-node development cluster on OpenStack VMs and recently updated to DataStax's 1.2.4 debs on Ubuntu Raring after which the cluster was fine. I shut it down for a few days and after getting back to Cassandra today and booting the VMs, Cassandra is unable to start. Below i

Re: RPM for cassandra with CQL 3.0.2?

Cassandra 1.2.4 is the current release, even the current 1.2 branch still uses CQL 3.0.1.  You may need to use the trunk to get CQL 3.0.2 (I've not looked).  Is there something specific you are looking for ? We're using token() and were hitting an issue that we thought might be fixed by 3.0

Re: Cassandra multi-datacenter

Look at the broadcast_address in the yaml file Cheers - Aaron Morton Freelance Cassandra Consultant New Zealand @aaronmorton http://www.thelastpickle.com On 3/05/2013, at 9:10 AM, Jabbar Azam wrote: > I'm not sure why you want to use public Ip's in the other data centre. You're

Re: RPM for cassandra with CQL 3.0.2?

Cassandra 1.2.4 is the current release, even the current 1.2 branch still uses CQL 3.0.1. You may need to use the trunk to get CQL 3.0.2 (I've not looked). Is there something specific you are looking for ? Cheers - Aaron Morton Freelance Cassandra Consultant New Zealand @aar

Re: Exception inserting UUID's into Cassandra using JDBC driver

There is an open ticket for this https://code.google.com/a/apache-extras.org/p/cassandra-jdbc/issues/detail?id=72 Cheers - Aaron Morton Freelance Cassandra Consultant New Zealand @aaronmorton http://www.thelastpickle.com On 3/05/2013, at 1:57 AM, Robert Wille wrote: > Just do

Re: Cassandra multi-datacenter

I'm not sure why you want to use public Ip's in the other data centre. You're cassandra nodes in the other datacentre will be accessible from the internet Personally I would use private IP addresses in the second data centre, on a different IP subnet. A VPN is your only solution if you want to ke

Cassandra multi-datacenter

Hi all, We are deploying Cassandra on two data centers. there is slower network connection between data centers. Looks casandra should use internal ip to communicate with nodes in the same data center, and public ip to talk to nodes in other data center. We know VPN is a solution, but want to kno

Re: Repair session failed

Hold off on running scrub (but yes it's an online operation). This is an issue with the token ranges. What version are you using ? Are you using vNodes ? Can you share the output of nodetool ring (if no vnodes) or nodetool status (if using vnodes) ? Cheers - Aaron Morton Free

Re: SSTables not opened on new cluste

> When I created the schema, the KS were created as directory in the .../data/ > directory Can you provide the logs from start up ? > I just noticed that when the new cluster nodes start up, auto_bootstrap is > set to true. Given that it's no longer in the YAML file, I didn't set it to > fals

Cassandra NYC event followup

The videos from the NYC* Big Data Tech Day are all up. I blogged about my favorites here: http://www.datastax.com/dev/blog/my-top-five-talks-from-nyc-big-data-tech-day Good to meet the NYC community again! -- Jonathan Ellis Project Chair, Apache Cassandra co-founder, http://www.datastax.com @spy

RPM for cassandra with CQL 3.0.2?

Is there a pre-built RPM for cassandra with CQL 3.0.2? It appears that this latest community RPM does not: http://rpm.datastax.com/community/noarch/ cassandra12-1.2.4-1.noarch.rpm 2013-Apr-26 22:31:32 Am I missing something? jrf

Exception inserting UUID's into Cassandra using JDBC driver

Just downloaded the latest Cassandra and JDBC driver. When I try to insert UUID's into a column family, I get an exception. Here's how I created the column family: CREATE TABLE browse.tree (tree_id UUID PRIMARY KEY, activation_time TIMESTAMP, tree_lock_id INT, sql_publication_id INT); Here's som

Re: cql query

Hello Sri, As far as I know you can if name and age are part of your partition key and timestamp is the cluster key e.g. create table columnfamily ( name varchar, age varchar, tstamp timestamp, partition key((name, age), tstamp) ); Thanks Jabbar Azam On 2 May 2013 11:45, Sri

Re: Repair Hanging C* 1.2.4

Hi, I am running the repair, nodetool repair mykeyspace I do not specify any thing else. Sent from my iPhone On 2 May 2013, at 13:17, Yuki Morishita wrote: > Hi, > >> ERROR [Thread-12725] 2013-05-01 14:30:54,304 StorageService.java (line 2420) >> Repair session failed: >> >> java.lang.Ill

cql query

hi Can some body tell me is it possible to to do multiple query on cassandra like "Select * from columnfamily where name='foo' and age ='21' and timestamp >= 'unixtimestamp' "; Please tell me some guidence for these kind of queries Thank you

Re: Secondary Index on table with a lot of data crashes Cassandra

Hi, this is true for CQL2, it doesn't work for CQL3: cqlsh:c4> SELECT id from some_table WHERE indexed_column='test'; ... cqlsh:c4> SELECT KEY from some_table WHERE indexed_column='test'; Bad Request: Undefined name key in selection clause Perhaps you meant to use CQL 2? Try using the -2 option w

Re: How does a healthy node look like?

Well, maybe should you describe us your hardware and the C* release toi are using. Also give us some metrics. Le 30 avr. 2013 18:48, "Steppacher Ralf" < ralf.steppac...@derivativepartners.com> a écrit : > Hi, > > I have troubles finding some quantitative information as to how a healthy > Cassandr