Re: Creating an "Index" column...

2013-06-27 Thread Tony Anecito
starting to understand it and I agree with you comments it just depends upon your requirements.   Regards, -Tony From: Arthur Zubarev To: Tony Anecito Cc: Robert Coli ; Users-Cassandra Sent: Wednesday, June 26, 2013 9:40 PM Subject: Re: Creating an "Index" column... Appre

Re: Creating an "Index" column...

2013-06-26 Thread Arthur Zubarev
better. Just some thoughts on the matter. -Tony *From:* Arthur Zubarev *To:* Tony Anecito ; Robert Coli ; Users-Cassandra *Sent:* Wednesday, June 26, 2013 3:08 PM *Subject:* Re: Creating an "Index" column... Ton

Re: Creating an "Index" column...

2013-06-26 Thread Tony Anecito
_ From: Arthur Zubarev To: Tony Anecito ; Robert Coli ; Users-Cassandra Sent: Wednesday, June 26, 2013 3:08 PM Subject: Re: Creating an "Index" column... Tony hi,   Yes, in some scenarios (e.g. a DW), e.g. absence of proper PKs or indexes (just too hard to envision, you need

Re: Creating an "Index" column...

2013-06-26 Thread Arthur Zubarev
that is covered here: http://pkghosh.wordpress.com/2012/03/04/cassandra-range-query-made-simple/ Hope that helps. /Arthur From: Tony Anecito Sent: Wednesday, June 26, 2013 1:55 PM To: Robert Coli ; Users-Cassandra Subject: Re: Creating an "Index" column... Hi Robert, Actually that

Re: Creating an "Index" column...

2013-06-26 Thread Tony Anecito
learning fast and there are some challenges when moving to a new data model driven by these factors. Regards, -Tony From: Robert Coli To: user@cassandra.apache.org; Tony Anecito Sent: Wednesday, June 26, 2013 11:32 AM Subject: Re: Creating an "Index&qu

Re: Creating an "Index" column...

2013-06-26 Thread Robert Coli
On Wed, Jun 26, 2013 at 10:20 AM, Tony Anecito wrote: > Never mind I figured it out. I found it via a search for Secondary indexes. In general unless you actually need atomic update of the row and its secondary index, you are probably better off creating your own pseudo secondary index column fam

Re: Creating an "Index" column...

2013-06-26 Thread Tony Anecito
Never mind I figured it out. I found it via a search for Secondary indexes. Regards, -Tony From: Tony Anecito To: Users-Cassandra Sent: Wednesday, June 26, 2013 10:39 AM Subject: Creating an "Index" column... Hi All, I have a column f

Creating an "Index" column...

2013-06-26 Thread Tony Anecito
Hi All, I have a column family with multiple columns and when I try a where clause with one of the columns that is not the "key" column Cassandra gives me an error about it not being an index column. So where can I find an example of creating a column family with one or more columns being "Inde