Re: Schema advice: (Single row or multiple row!?) How do I store millions of columns when I need to read a set of around 500 columns at a single read query using column names ?

2012-07-23 Thread Eldad Yamin
in addition, if you don't know how many rows will be needed - in each row, you can store the key of the next one. Just like in a linked list. OR have 1 row that will hold all the keys that combining your other rows. 1st select the main row (with the keys), then select the other rows. On Mon, J

Re: Cassandra London: failure modes and HBase

2011-08-17 Thread Eldad Yamin
HI Dave, unfortunately, me and some guys that are very interesting won't be able to get all the way to London. Can you please consider using a video streaming service? I recommend on using Watchitoo.com (I used to work there) At the moment its free. Thanks! On Tue, Aug 16, 2011 at 12:47 PM, Dave

Re: Best practices when deploying & upgrading a cassandra cluster

2011-08-14 Thread Eldad Yamin
which did not have a > relevant subject, sorry for the spamming) > > Hi Eldad / All, > > On Wed, Aug 10, 2011 at 8:32 AM, Eldad Yamin wrote: > > Can you please explain how did you upgraded. something like step-by-step. > > Thanks! > > > I took the liberty of rep

Re: Planet Cassandra (an aggregation site for Cassandra News)

2011-08-07 Thread Eldad Yamin
gt;> >> On Thu, Aug 4, 2011 at 1:56 PM, Eldad Yamin wrote: >> >>> Great! I hope it will be open soon! >>> >>> >>> On Wed, Aug 3, 2011 at 10:33 PM, Ed Anuff wrote: >>> >>>> Awesome, great news! >>>> >>>> &g

Re: Install Cassandra on EC2

2011-08-03 Thread Eldad Yamin
uster (we need a second virtual DC for analytics), you'll probably > want to use the property file snitch. there's a cross region ec2snitch > that's coming in 1.0. > > would probably be good to add some ec2 specific tips in the wiki. the page > that dave mentioned is a go

Re: Planet Cassandra (an aggregation site for Cassandra News)

2011-08-03 Thread Eldad Yamin
Great! I hope it will be open soon! On Wed, Aug 3, 2011 at 10:33 PM, Ed Anuff wrote: > Awesome, great news! > > > On Wed, Aug 3, 2011 at 11:53 AM, Lynn Bender wrote: > >> Greetings all, >> >> I just wanted to send a note out to let everyone know about Planet >> Cassandra -- an aggregation site

Solandra

2011-08-03 Thread Eldad Yamin
Hello, I have a cluster of 3 Cassandra nodes and I would like to start using Solandra. 1. How can I install Solandra and make use the existing nodes? 2. Will it be better to install Solandra on a new node and add it to the existing cluster? 3. How Solandra index, does it operate automatically or I

Re: Installation Exception

2011-08-03 Thread Eldad Yamin
Thanks! I missed that lol! BTW, how do I compile it? Thanks! On Wed, Aug 3, 2011 at 6:51 PM, samal wrote: > did u compile source code? :) > you have downloaded source code not binary. > > try with binary. > > On Wed, Aug 3, 2011 at 9:14 PM, Eldad Yamin wrote: > >> H

Re: Installation Exception

2011-08-03 Thread Eldad Yamin
> On Wed, Aug 3, 2011 at 10:44 AM, Eldad Yamin wrote: > > Hi, > > I'm trying to install Cassandra on Amazon EC2 without success, this is > what > > I did: > > > > Created new "Small" EC2 instance (this is just for testing), running >

Installation Exception

2011-08-03 Thread Eldad Yamin
Hi, I'm trying to install Cassandra on Amazon EC2 without success, this is what I did: 1. Created new "Small" EC2 instance (this is just for testing), running Ubuntu OS - custom AIM (ami-596f3c1c) from: http://uec-images.ubuntu.com/releases/11.04/release/ 2. Installed Java: # sudo a

Cassandra and Solandra Installation guid

2011-08-03 Thread Eldad Yamin
Hi, I'd like to get tutorials on how to install Cassandra and Solandra - I couldn't find anything helpful. In addition, how to use (index/search) Solandra tutorials will be great. Thanks!

Re: Install Cassandra on EC2

2011-08-03 Thread Eldad Yamin
change what > folders are pointed to what drives (not sure if you can or not...I'm sure > you could), or change the yaml file to point the /mnt folder. > > > On Wed, Aug 3, 2011 at 6:28 AM, Eldad Yamin wrote: > >> Hi, >> Is there any manual or important

Install Cassandra on EC2

2011-08-03 Thread Eldad Yamin
Hi, Is there any manual or important notes I should know before I try to install Cassandra on EC2? Thanks!

Re: HOW TO select a column or all columns that start with X

2011-08-03 Thread Eldad Yamin
with column_start="ABC_" , count to whatever, and column_finish not >>> provided. >>> >>> You can also provide a finish and use the highest encoded character, e.g. >>> ascii 126 is ~ so if you used column_finish = "ABC_~" you would get >>> everything that starts wit

Re: cassandra consistency level

2011-08-03 Thread Eldad Yamin
CL ONE reads are also sent to all UP replicas. > > Hope that helps. > > - > Aaron Morton > Freelance Cassandra Developer > @aaronmorton > http://www.thelastpickle.com > > On 3 Aug 2011, at 09:32, Eldad Yamin wrote: > > > Is consistency level "All&

geo-data in Cassandra

2011-08-02 Thread Eldad Yamin
Hello, I'm trying to save geo-data in Cassandra, according to SimpleGeo they did that using nested tree: http://www.readwriteweb.com/cloud/2011/02/video-simplegeo-cassandra.php I wonder if someone already implement something like that and how he accomplished that without transaction supports (whi

cassandra consistency level

2011-08-02 Thread Eldad Yamin
Is consistency level "All" for write actually grenty that my data is updated in all of my node? is it apply to read actions as-well? I've read it on the wiki, I just want to make sure. Thanks!

HOW TO select a column or all columns that start with X

2011-08-02 Thread Eldad Yamin
Hello, I wonder if I can select a column or all columns that start with X. E.g I have columns ABC_1, ABC_2, ZZZ_1 and I want to select all columns that start with ABC_ - is that possible? Thanks!

Question about eventually consistent in Cassandra

2011-08-02 Thread Eldad Yamin
any different if the changes will be made withing the same data center? Thanks! Eldad Yamin

Question about eventually consistent

2011-07-31 Thread Eldad Yamin
Hi, Let’s say that I have 2 datacenters, a key is changed on both of my datacenters in the exact same time (even in 1-2 seconds diff). Datacenter #1 remove a column and Datacenter #2 add 2 new columns. Is there any problem with consistency or Cassandra will handle this situation easily. Thanks

Re: b-tree

2011-07-22 Thread Eldad Yamin
orton > http://www.thelastpickle.com > > On 22 Jul 2011, at 00:06, Eldad Yamin wrote: > >> Aaron, >> Nested set is exactly what I had in mind. >> But how will you be able to maintain it while it evolves and new data is added without transactions? >> >> Thanks!

Re: how to stop the whole cluster, start the whole cluster like in hadoop/hbase?

2011-07-21 Thread Eldad Yamin
I wonder if it wont make problems... Anyine did it already? On Jul 21, 2011 10:39 PM, "Jonathan Ellis" wrote: > dsh -c -g cassandra /etc/init.d/cassandra stop > > http://www.netfort.gr.jp/~dancer/software/dsh.html.en > > P.S. mostly people are concerned about making sure their entire > cluster do

Re: b-tree

2011-07-21 Thread Eldad Yamin
y tree are not the same thing. A binary tree is a > basic fundamental data structure, A b-tree is an approach to storing and > indexing data on disc for a database. > > Which do you mean? > > > On Wed, Jul 20, 2011 at 4:30 PM, Eldad Yamin wrote: > >> Hello, >>

Re: b-tree

2011-07-21 Thread Eldad Yamin
t; > Im not sure if I have an answer for you, anyway, but I'm curious > > A b-tree and a binary tree are not the same thing. A binary tree is a > basic fundamental data structure, A b-tree is an approach to storing and > indexing data on disc for a database. > > Whi

b-tree

2011-07-20 Thread Eldad Yamin
Hello, Is there any good way of storing a binary-tree in Cassandra? I wonder if someone already implement something like that and how accomplished that without transaction supports (while the tree keep evolving)? I'm asking that becouse I want to save geospatial-data, and SimpleGeo did it using b-

Re: Cassandra Secondary index/Twissandra

2011-07-11 Thread Eldad Yamin
> http://thelastpickle.com/2011/07/04/Cassandra-Query-Plans/ > > Cheers > > > - > Aaron Morton > Freelance Cassandra Developer > @aaronmorton > http://www.thelastpickle.com > > On 10 Jul 2011, at 00:14, Eldad Yamin wrote: > > Aaron - Thank you for

Re: Cassandra Secondary index/Twissandra

2011-07-10 Thread Eldad Yamin
rations have > to pay a constant cost to decode the row level column index, this can be > tuned though. AFAIK the comparator type has very little to do with the > performance. > > Hope that helps. > > - > - > Aaron Morton > Freelance Cassand

Cassandra Secondary index/Twissandra

2011-07-09 Thread Eldad Yamin
Hi, I have few questions: *Secondary index* 1. Is there a limit on the number of columns in a single column family that serve as secondary indexes? 2. Does performance decrease (significantly) if the uniqueness of the column’s values is high? *Twissandra* 1. Why in the source (o

Re: Pre-CassandraSF Happy Hour on Sunday

2011-07-09 Thread Eldad Yamin
Can you please Watchitoo.com (its' free) and broadcast the event? On Fri, Jul 8, 2011 at 8:54 PM, Richard Low wrote: > Hi all, > > If you're in San Francisco for CassandraSF on Monday 11th, then come > and join fellow Cassandra users and committers on Sunday evening. > Starting at 6:30pm at Thir

Re: Any meet ups in southern california

2011-07-07 Thread Eldad Yamin
You can use Watchitoo.com (LIke GoToMeeting/WebEX) to host an event. using that tool, everyone around the world can join and take action. the great thing about is that it's FREE! On Wed, Jul 6, 2011 at 10:25 PM, Mike Rapuano wrote: > Hi all > > Are there any active cassandra meet ups in souther