Re: How to delete bulk data from cassandra 0.6.3

2011-02-05 Thread Ali Ahsan
Any update on this? On 02/05/2011 12:53 AM, Ali Ahsan wrote: So do we need to write a script ? or its some thing i can do as a system admin without involving and developer.If yes please guide me in this case. On 02/04/2011 10:36 PM, Jonathan Ellis wrote: In that case, you should shut down

Re: Sorting in time order without using TimeUUID type column names

2011-02-05 Thread Bill Speirs
You can specify reverse order through the API when you slice the cols so I don't think you need to write a comparator. Bill- On Feb 4, 2011 9:45 PM, Aditya Narayan ady...@gmail.com wrote: Thanks Aaron, Yes I can put the column names without using the userId in the timeline row, and when I want

Hinted handoffs - how do they work?

2011-02-05 Thread Paul T
Good morning! I have a been reading through Cassandra wiki and have some confusion around how hinted handoffs work. Here is my scenario: Five nodes in the ring (A, B, C, D, E) Replication factor=3 Assume that the replicas for a given key are A, B, C Assume CL=ONE During a write operation,

Re: Hinted handoffs - how do they work?

2011-02-05 Thread Jonathan Ellis
On Sat, Feb 5, 2011 at 6:46 AM, Paul T paulmax6...@yahoo.com wrote: Good morning! I have a been reading through Cassandra wiki and have some confusion around how hinted handoffs work. Here is my scenario: Five nodes in the ring (A, B, C, D, E) Replication factor=3 Assume that the replicas

Re: How to delete bulk data from cassandra 0.6.3

2011-02-05 Thread Edward Capriolo
On Sat, Feb 5, 2011 at 4:12 AM, Ali Ahsan ali.ah...@panasiangroup.com wrote: Any update on this? On 02/05/2011 12:53 AM, Ali Ahsan wrote: So do we need to write a script ? or its some thing i can do as a system admin without involving and developer.If yes please guide me in this case.

Re: How to delete bulk data from cassandra 0.6.3

2011-02-05 Thread Ali Ahsan
Thanks for replying Edward Capriolo.Will this effect cassandra ring integrity? Another question is that will cassandra work properly after this operation.And will it be possible to restore deleted data from backup?. in 0.6.X pkill `pid of cassandra` rm -rf *

How bad is teh impact of compaction on performance?

2011-02-05 Thread buddhasystem
Just wanted to see if someone with experience in running an actual service can advise me: how often do you run nodetool compact on your nodes? Do you stagger it in time, for each node? How badly is performance affected? I know this all seems too generic but then again no two clusters are

Re: How to delete bulk data from cassandra 0.6.3

2011-02-05 Thread Edward Capriolo
On Sat, Feb 5, 2011 at 11:35 AM, Ali Ahsan ali.ah...@panasiangroup.com wrote: Thanks for replying Edward Capriolo.Will this effect cassandra ring  integrity? Another question is that will cassandra work properly after this operation.And will it be possible to restore deleted  data from backup?.

Re: How bad is teh impact of compaction on performance?

2011-02-05 Thread Edward Capriolo
On Sat, Feb 5, 2011 at 11:59 AM, buddhasystem potek...@bnl.gov wrote: Just wanted to see if someone with experience in running an actual service can advise me: how often do you run nodetool compact on your nodes? Do you stagger it in time, for each node? How badly is performance affected?

order of index expressions

2011-02-05 Thread Shaun Cutts
Hello, I'm wondering if cassandra is sensitive to the order of index expressions in (pycassa call) get_indexed_slices? If I have several column indexes available, will it attempt to optimize the order? Thanks, -- Shaun

postgis cassandra?

2011-02-05 Thread Sean Ochoa
Can someone tell me how to represent spatial data (coming from postgis) in Cassandra? - Sean

Re: postgis cassandra?

2011-02-05 Thread William R Speirs
I know nothing about postgis and little about spacial data, but if you're simply talking about data that relates to some latitude longitude pair, you could have your row key simply be the concatenation of the two: lat:long. Can you provide more details about the type of data you're looking to

Re: How bad is teh impact of compaction on performance?

2011-02-05 Thread buddhasystem
Thanks Edward. In our usage scenario, there is never downtime, it's a global 24/7 operation. What is impacted the worst, the read or write? How does a node handle compaction when there is a spike of writes coming to it? Edward Capriolo wrote: On Sat, Feb 5, 2011 at 11:59 AM, buddhasystem

Re: How to delete bulk data from cassandra 0.6.3

2011-02-05 Thread Ali Ahsan
Thanks for detailed replay On 02/05/2011 10:01 PM, Edward Capriolo wrote: On Sat, Feb 5, 2011 at 11:35 AM, Ali Ahsanali.ah...@panasiangroup.com wrote: Thanks for replying Edward Capriolo.Will this effect cassandra ring integrity? Another question is that will cassandra work properly after

How to upgrade cassandra from 0.6.3 to 0.7

2011-02-05 Thread Ali Ahsan
Hi All We are planning to upgrade cassanra from 0.6.3 to 0.7 any one can guide me to web link where i can find upgrade procedure.

Re: postgis cassandra?

2011-02-05 Thread Sean Ochoa
That's a good question, Bill. The data that I'm trying to store begins as a simple point. But, moving fo= rward, it will become more like complex geometries. I assume that I can si= mply create a JSON-like object and insert it. Which, for now, that works. = I'm just wondering if theres a

Re: How bad is teh impact of compaction on performance?

2011-02-05 Thread Edward Capriolo
On Sat, Feb 5, 2011 at 12:48 PM, buddhasystem potek...@bnl.gov wrote: Thanks Edward. In our usage scenario, there is never downtime, it's a global 24/7 operation. What is impacted the worst, the read or write? How does a node handle compaction when there is a spike of writes coming to it?

row keys

2011-02-05 Thread Sean Ochoa
Hey all. I'm using Pycassa to insert some spatial data into Cassandra. Here's where I am on the tutorial: http://pycassa.github.com/pycassa/tutorial.html#inserting-data And, I'm not quite understanding where row-keys come from. What mind-set should I have when I generate them for the values

Re: How to upgrade cassandra from 0.6.3 to 0.7

2011-02-05 Thread Ali Ahsan
Ok let me read it out. On 02/06/2011 12:20 AM, Tyler Hobbs wrote: We are planning to upgrade cassanra from 0.6.3 to 0.7 any one can guide me to web link where i can find upgrade procedure. NEWS.txt in an 0.7.0 package covers all the details of upgrading quite well. -- Tyler Hobbs

Re: order of index expressions

2011-02-05 Thread Jonathan Ellis
On Sat, Feb 5, 2011 at 8:48 AM, Shaun Cutts sh...@cuttshome.net wrote: Hello, I'm wondering if cassandra is sensitive to the order of index expressions in (pycassa call) get_indexed_slices? No. If I have several column indexes available, will it attempt to optimize the order? Yes. --

Re: Merging the rows of two column families(with similar attributes) into one ??

2011-02-05 Thread Tyler Hobbs
if you have under control parameters like memtable_throughput memtable_operations which are set per column family basis then you can directly control adjust by splitting the memory space between two CFs in proportion to what you would do in single CF. Hence there should be no extra memory

Re: row keys

2011-02-05 Thread Stephen Connolly
you really need to know how you will be pulling the data back out again. you could use the object id as the row key, timestamp as the column name and long/lat as the value... that would allow you to query by object is and get the time sorted location trace... but if you have a lot of frequent

Re: order of index expressions

2011-02-05 Thread buddhasystem
Jonathan, what's the implementation of that? I.e. is is a product of indexes or nested loops? Thanks, Maxim -- View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/order-of-index-expressions-tp5995909p5996488.html Sent from the

revisioned data

2011-02-05 Thread Raj Bakhru
Hi all - We're new to Cassandra and have read plenty on the data model, but we wanted to poll for thoughts on how to best handle this structure. We have simple objects that have and ID and we want to maintain a history of all the revisions. e.g. MyObject: ID (long) name other fields

Re: revisioned data

2011-02-05 Thread Victor Kabdebon
Hello Raj, No it actually doesn't make sense from the point of view of Cassandra; OrderingPartioner preserves the order of the *keys*. The Ordering will be done according to the *supercolumn name*. In that case you can set the ordering with compare_super_with (sorry I don't remember exactly the

Re: Merging the rows of two column families(with similar attributes) into one ??

2011-02-05 Thread Ertio Lew
Thanks Tyler! I think I'll have to very carefully take into consideration all these factors before deciding upon how to split my data into CFs, as this cannot an objective answer. I am expecting around atleast 8 column families for my entire application, if I split the data strictly according to

Re: order of index expressions

2011-02-05 Thread Shaun Cutts
Thanks for the response! So.. I *may* have a bug to report (at least I can generate radically different response times based on expression order with a multiply indexed columnfamily), but first I'll have to upgrade to a stable version (currently I have 7.0rc2 installed). I was also wondering

Re: order of index expressions

2011-02-05 Thread Jonathan Ellis
ColumnFamilyStore.scan On Sat, Feb 5, 2011 at 10:32 PM, Shaun Cutts sh...@cuttshome.net wrote: Thanks for the response! So.. I *may* have a bug to report (at least I can generate radically different response times based on expression order with a multiply indexed columnfamily), but first

Ruby thrift is trying to write Time as string

2011-02-05 Thread Joshua Partogi
Hi, I don't know whether my assumption is right or not. When I tried to insert a Time value into a column I am getting this exception: vendor/ruby/1.8/gems/thrift-0.5.0/lib/thrift/protocol/binary_protocol.rb:106:in `write_string' vendor/ruby/1.8/gems/thrift-0.5.0/lib/thrift/client.rb:35:in