Re: Working with legacy data via CQL

2014-11-12 Thread Erik Forsberg
On 2014-11-11 19:40, Alex Popescu wrote: On Tuesday, November 11, 2014, Erik Forsberg forsb...@opera.com mailto:forsb...@opera.com wrote: You'll have better chances to get an answer about the Python driver on its own mailing list

Re: Better option to load data to cassandra

2014-11-12 Thread Brice Dutheil
On our project we wrote ourself a custom batch to load the data to cassandra the way we wanted. -- Brice On Tue, Nov 11, 2014 at 2:33 PM, srinivas rao pinnakasrin...@gmail.com wrote: hi Alexey, i tried with sqoop, and data stax copy command. any other options we can use. i have one more

Re: nodetool repair stalled

2014-11-12 Thread Eric Stevens
Wouldn't it be a better idea to issue removenode on the crashed node, wipe the whole data directory (including system) and let it bootstrap cleanly so that it's not part of the cluster while it gets back up to speed? On Tue, Nov 11, 2014, 12:32 PM Robert Coli rc...@eventbrite.com wrote: On Tue,

Cassandra sort using updatable query

2014-11-12 Thread Chamila Wijayarathna
Hello all, I have a data set with attributes content and year. I want to put them in to CF 'words' with attributes ('content','year','frequency'). The CF should support following operations. - Frequency attribute of a column can be updated (i.e. - : can run query like UPDATE words SET

Re: Cassandra sort using updatable query

2014-11-12 Thread Jonathan Haddad
With Cassandra you're going to want to model tables to meet the requirements of your queries instead of like a relational database where you build tables in 3NF then optimize after. For your optimized select query, your table (with caveat, see below) could start out as: create table words (

Re: nodetool repair stalled

2014-11-12 Thread Robert Coli
On Wed, Nov 12, 2014 at 6:50 AM, Eric Stevens migh...@gmail.com wrote: Wouldn't it be a better idea to issue removenode on the crashed node, wipe the whole data directory (including system) and let it bootstrap cleanly so that it's not part of the cluster while it gets back up to Yes, with

Cassandra patterns/design for setting up a history/version/change log table?

2014-11-12 Thread Jacob Rhoden
Hi Guys, Assuming you have, for example, an “account” table, and an “account_history” table which simply tracks older versions of what a persons account looks like when an administrator edits a customer account. Given that we don’t have the luxury of a safe transaction to update the account

Programmatic Cassandra version detection/extraction

2014-11-12 Thread Otis Gospodnetic
Hi, Is there a way to detect which version of Cassandra one is running? Is there an API for that, or a constant with this value, or maybe an MBean or some other way to get to this info? Here's the use case: SPM monitors Cassandra http://sematext.com/spm/, but Cassandra MBeans and metrics have or

Re: Programmatic Cassandra version detection/extraction

2014-11-12 Thread Michael Shuler
On 11/12/2014 04:44 PM, Otis Gospodnetic wrote: Is there a way to detect which version of Cassandra one is running? Is there an API for that, or a constant with this value, or maybe an MBean or some other way to get to this info? I'm not sure if there are other methods, but this should always

Re: Programmatic Cassandra version detection/extraction

2014-11-12 Thread Michael Shuler
On 11/12/2014 04:58 PM, Michael Shuler wrote: On 11/12/2014 04:44 PM, Otis Gospodnetic wrote: Is there a way to detect which version of Cassandra one is running? Is there an API for that, or a constant with this value, or maybe an MBean or some other way to get to this info? I'm not sure if

Re: Better option to load data to cassandra

2014-11-12 Thread cass savy
Sstableloader works well for large tables if you want to move data from Cassandra to Cassandra. This works if both C* are on the same version. Sstable2json and json2sstable is another alternative. On Nov 11, 2014 4:53 AM, srinivas rao pinnakasrin...@gmail.com wrote: Hi Team, Please suggest me

Re: nodetool repair stalled

2014-11-12 Thread venkat sam
Hi Eric, The data are stored in JBOD. Only one of the disk got crashed other 3 disk still holds the old data . That's why I didn't clean the whole node and issue a fresh restart Thanks Rob. Will do try that way. From: Eric Stevens Sent: ‎Wednesday‎, ‎November‎ ‎12‎, ‎2014 ‎8‎:‎21‎ ‎PM