Re: partition key of composite type and "where partition_key in (...)" clause

We indeed don't support that kind of syntax. We might someday (seehttps:// issues.apache.org/jira/browse/CASSANDRA-4851, even though the description is more general, this kind of would introduce that kind of syntax). *But* another solution is just to do 2 (or more) separate queries (instead of usi

Re: smallest/largest UUIDs for LexicalUUIDType

> I'm trying to use composite column names to organize 10**8 records. Each > record has a unique pair of UUIDs. The first UUID is often repeated, so I > want to use column_start and column_finish to find all the records that > have a given UUID as the first UUID in the pair. > > I thought a simpl

Dynamic Columns Question Cassandra 1.2.5, Datastax Java Driver 1.0

Hi, I'm having some problems figuring out how to append a dynamic column on a column family using the datastax java driver 1.0 and CQL3 on Cassandra 1.2.5. Below is what i'm trying: *cqlsh:simplex> create table user (firstname text primary key, lastname text); cqlsh:simplex> insert into user (fir

Re: Dynamic Columns Question Cassandra 1.2.5, Datastax Java Driver 1.0

Dynamic columns are not supported in CQL3. We just had a discussion a day or two ago about this where Eric Stevens explained it. Please see this: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/CQL-3-returning-duplicate-keys-td7588181.html Regards, Shahab On Thu, Jun 6, 2013 at

Re: Dynamic Columns Question Cassandra 1.2.5, Datastax Java Driver 1.0

Hi, CQL3 does now support dynamic columns. For tags or metadata values you could use a Collection: http://www.datastax.com/dev/blog/cql3_collections For wide rows there's the enhanced primary keys, which I personally prefer over the composite columns of yore: http://www.datastax.com/dev/blog/

Re: Dynamic Columns Question Cassandra 1.2.5, Datastax Java Driver 1.0

> > CQL3 does now support dynamic columns. For tags or metadata values you > could use a Collection: > This should probably be clarified. A collection is a super useful tool, but it is *not* the same thing as a dynamic column. It has many advantages, but there is one huge disadvantage in that yo

Re: Dynamic Columns Question Cassandra 1.2.5, Datastax Java Driver 1.0

The problem about "being careful about how much you store in a collection" is that Cassandra is a blind-write system. Knowing how much data is currently in the collection before you write is an anti-pattern, read before write. Cassandra Rule 1: DON'T READ BEFORE WRITE Cassandra Rule 2: ROWS CAN HA

Re: Dynamic Columns Question Cassandra 1.2.5, Datastax Java Driver 1.0

This is becoming something of a FAQ, so I wrote an more in-depth answer: http://www.datastax.com/dev/blog/does-cql-support-dynamic-columns-wide-rows On Thu, Jun 6, 2013 at 8:02 AM, Joe Greenawalt wrote: > Hi, > I'm having some problems figuring out how to append a dynamic column on a > column fa

Re: Dynamic Columns Question Cassandra 1.2.5, Datastax Java Driver 1.0

Your data model should take into consideration the number of items you're storing in a collection. If you expect it will grow over time with no small upper bound, don't use a collection. You don't need to read before write to answer this question, it's a decision made at modeling time (before you

Re: Dynamic Columns Question Cassandra 1.2.5, Datastax Java Driver 1.0

Not sure if you remember this Jonathan, but Sylvain already wrote a very clear documentation about it : http://www.datastax.com/dev/blog/thrift-to-cql3 (OCTOBER 26, 2012) Yet a second page will give to this important topic a greater visibility. 2013/6/6 Jonathan Ellis > This is becoming someth

Re: Dynamic Columns Question Cassandra 1.2.5, Datastax Java Driver 1.0

Hey, this is good info. Seems like i have the same capabilities, i just need to twist my brain a bit to see it better. Thanks for all the feedback, much appreciated. Joe On Thu, Jun 6, 2013 at 11:27 AM, Alain RODRIGUEZ wrote: > Not sure if you remember this Jonathan, but Sylvain already wrot

Re: partition key of composite type and "where partition_key in (...)" clause

On 2013-06-06 11:36, Sylvain Lebresne wrote: We indeed don't support that kind of syntax. We might someday (seehttps://issues.apache.org/jira/browse/CASSANDRA-4851 , even though the description is more general, this kind of would introduce that

[Cassandra] Conflict resolution in Cassandra

Hi All, Can someone tell me about the conflict resolution mechanisms provided by Cassandra? More specifically does Cassandra provides a way to define application specific conflict resolution mechanisms (per row basis  / column basis)?             or  Does it automatically manage the conflicts b

replication factor is zero

We have multi-center deployment. data from some tables we don't want to sync to other center. could we set replication factor to 0 on other data center? what is the best to way for not syncing some data in a cluster? Thanks in advance, Daning

Re: replication factor is zero

On Thu, Jun 6, 2013 at 1:28 PM, Daning Wang wrote: > could we set replication factor to 0 on other data center? what is the > best to way for not syncing some data in a cluster? Yes, you can set it to 0, and that's the recommended way to handle this. -- Tyler Hobbs DataStax

Re: replication factor is zero

But afaik you can set the RF only per Keyspace. So you will have to pull those tables apart, in a different Keyspace. 2013/6/6 Tyler Hobbs > > On Thu, Jun 6, 2013 at 1:28 PM, Daning Wang wrote: > >> could we set replication factor to 0 on other data center? what is the >> best to way for not s

Re: [Cassandra] Conflict resolution in Cassandra

For generic questions like this, google is your friend: http://lmgtfy.com/?q=cassandra+conflict+resolution -Bryan On Thu, Jun 6, 2013 at 11:23 AM, Emalayan Vairavanathan < svemala...@yahoo.com> wrote: > Hi All, > > Can someone tell me about the conflict resolution mechanisms provided by > Cassa

Re: [Cassandra] Conflict resolution in Cassandra

I tried google and found conflicting answers. Thats why wanted to double check with user forum.  Thanks From: Bryan Talbot To: user@cassandra.apache.org; Emalayan Vairavanathan Sent: Thursday, 6 June 2013 3:19 PM Subject: Re: [Cassandra] Conflict resolution

Bulk loader with Cassandra 1.2.5

Hi, I am currently using Cassandra 1.2.5 on RHEL6 with Oracle JVM. I want to try to build a bulk loader for stock prices that I have available in CSV format. However, I have started exploring Cassandra from something easier, focussing on the example available in the manual. I cannot manage to have

Re: Bulk loader with Cassandra 1.2.5

Could it be because you are writing age as a long but have it defined as an integer in the table definition? Davide Anastasia wrote: Hi, I am currently using Cassandra 1.2.5 on RHEL6 with Oracle JVM. I want to try to build a bulk loader for stock prices that I have available in CSV format. H

Isolated node data access

Dear list members, I have a 1.2.5 node isolated via firewall rules (iptables), and cassandra-cli can get rows from it with "consistencylevel as one", but other tools (cqlsh and pycassa) are dying with UnavailableException. Does anyone have some advice on how to use a somewhat more performant tool

Re: Populating seeds dynamically

On Mon, 2013-06-03 at 17:20 -0700, Aiman Parvaiz wrote: > @Faraaz check out the comment by Aaron morton here : > http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Seed-Nodes-td6077958.html > Having same nodes is a good idea but it is not necessary. > > In your case, sure the nodes w

Re: Isolated node data access

On Thu, Jun 6, 2013 at 4:58 PM, Pas wrote: > I have a 1.2.5 node isolated via firewall rules (iptables), and > cassandra-cli can get rows from it with "consistencylevel as one", but > other tools (cqlsh and pycassa) are dying with UnavailableException. > > Does anyone have some advice on how to us

Re: smallest/largest UUIDs for LexicalUUIDType

I'll note that if you have the choice, you can use UUIDType rather than LexicalUUIDType. UUIDType fixes that behavior and use a proper lexical comparison for non-type-1 uuids (the other behavior of UUIDType is that for type 1 uuid, it compares them by time first, i.e. it is equivalent to TimeUU

Large number of files for Leveled Compaction

Hi, We are trialling Cassandra-1.2(.4) with Leveled compaction as it looks like it may be a win for us. The first step of testing was to push a fairly large slab of data into the Column Family - we did this much faster (> x100) than we would in a production environment. This has left the Column F

Re: Bulk loader with Cassandra 1.2.5

Hi, I've just tried to change it to integer and I get exactly the same error. Thanks, Davide On 6 June 2013 23:53, Keith Wright wrote: > Could it be because you are writing age as a long but have it defined as an > integer in the table definition? > > Davide Anastasia wrote: > > > Hi, > I