Re: How to migrate any relational database to Cassandra

2010-08-08 Thread sonia gehlot
Hi Guys, Thanks for sharing your experiences and valuable links these are really helpful. But I want to do ETL and then wanted to load data in Cassandra. I have link 10-15 various source system, presently daily ETL jobs runs load data in our database which is Netezza. How can I do this in Cas

Re: Question about column insert history

2010-08-08 Thread Benjamin Black
You don't, they are not preserved, as discussed in another, almost identical thread in the past 2 days. If you want to retain history, you must do so your self, usually by maintaining indices. On Sun, Aug 8, 2010 at 1:29 PM, Kevin Cox wrote: > Taking from the CassandaraCLI example page for simpl

Re: Question about column insert history

2010-08-08 Thread Aaron Morton
Short answer, you should consider the previous values replaced. Longer, they are kept around for a while but are not available outside of cassandra. They are removed at the next Major compaction, if the change happened more than GCGraceSeconds ago http://www.mail-archive.com/user@cassandra.apache.o

Question about column insert history

2010-08-08 Thread Kevin Cox
Taking from the CassandaraCLI example page for simplicity, one enters the following into the cassandra> set Keyspace1.Standard2['jsmith']['age'] = '42' cassandra> get Keyspace1.Standard2['jsmith'] => (column=last, value=Smith, timestamp=1279780450578000) => (column=first, value=Joh

Re: TokenRange contains endpoints without any port information?

2010-08-08 Thread Benjamin Black
On Sun, Aug 8, 2010 at 5:21 AM, Carsten Krebs wrote: > > I'm wondering why a TokenRange returned by describe_ring(keyspace) of the > thrift API just returns endpoints consisting only of an address but omits any > port information? > My first thought was, this method could be used to expose some

Re: TokenRange contains endpoints without any port information?

2010-08-08 Thread aaron morton
The assumption would be that you will only have one instance of cassandra per machine. So you could contact it on the appropriate port, such as 9160 for thrift. (I've not run this command but assume it's returning IP4 addresses) What sort of client side load balancing where you thinking of? I ju

Re: row cache during bootstrap

2010-08-08 Thread aaron morton
Not sure how feasible it is or if it's planned. But it would probably require that the nodes are able so share the state of their row cache so as to know which parts to warm. Otherwise it sounds like you're assuming the node can hold the entire data set in memory. If you know in your applicati

TokenRange contains endpoints without any port information?

2010-08-08 Thread Carsten Krebs
I'm wondering why a TokenRange returned by describe_ring(keyspace) of the thrift API just returns endpoints consisting only of an address but omits any port information? My first thought was, this method could be used to expose some information about the ring structure to the client, i.e. to do