Re: Using CQL to insert a column to a row dynamically

2013-05-28 Thread Edward Capriolo
Or just: cli > create column family ride_events with comparator(Int32Type,Int32Type,Int32Type); On Tue, May 28, 2013 at 4:45 AM, Tristan Seligmann wrote: > On Mon, May 27, 2013 at 11:38 PM, Matthew Hillsborough < > matthew.hillsboro...@gmail.com> wrote: > >> Originally what I thought of doing wa

Re: Using CQL to insert a column to a row dynamically

2013-05-28 Thread Tristan Seligmann
On Mon, May 27, 2013 at 11:38 PM, Matthew Hillsborough < matthew.hillsboro...@gmail.com> wrote: > Originally what I thought of doing was creating a column family in > Cassandra named `ride_events`. Each row key would be a rideID that's simply > an integer. I would then arbitrarily create columns w

Re: Using CQL to insert a column to a row dynamically

2013-05-27 Thread Matthew Hillsborough
Thanks for the reply so far. If I can describe my data model, maybe it'll be easier to see why I wanted to have "wide rows". Maybe there's a better way to model this data using Cassandra or perhaps Cassandra isn't the right tool. Here's an example. Let's say I have a database (relational for argum

Re: Using CQL to insert a column to a row dynamically

2013-05-27 Thread Jonathan Ellis
On Mon, May 27, 2013 at 9:28 AM, Matthew Hillsborough wrote: > I am trying to understand some fundamentals in Cassandra, I was under the > impression that one of the advantages a developer can take in designing a > data model is by dynamically adding columns to a row identified by a key. > That me

Re: Using CQL to insert a column to a row dynamically

2013-05-27 Thread Edward Capriolo
> Later, > Dean > > From: Matthew Hillsborough matthew.hillsboro...@gmail.com>> > Reply-To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" < > user@cassandra.apache.org<mailto:user@cassandra.apache.org>> > Date: Monday, May 27, 2013 8:2

Re: Using CQL to insert a column to a row dynamically

2013-05-27 Thread Hiller, Dean
ailto:user@cassandra.apache.org>" mailto:user@cassandra.apache.org>> Subject: Using CQL to insert a column to a row dynamically Hi all, I posted a similar thread on stackoverflow - hope it's not repetitive for anyone here. Looking for better insight from the community on wh

Using CQL to insert a column to a row dynamically

2013-05-27 Thread Matthew Hillsborough
Hi all, I posted a similar thread on stackoverflow - hope it's not repetitive for anyone here. Looking for better insight from the community on whether Cassandra is the right tool for me or not. I am trying to understand some fundamentals in Cassandra, I was under the impression that one of the a