Re: understanding of native indexes: limitations, potential side effects,...

2012-05-16 Thread David Vanderfeesten
This corresponds with my thoughts, but I don't see the issue with high cardinality columns. In worst case you get potentially as many rows in the index as in the indexed cf (each having one column). On Wed, May 16, 2012 at 9:03 PM, Dave Brosius wrote: > Each index you define on the source CF is

Re: understanding of native indexes: limitations, potential side effects,...

2012-05-16 Thread Dave Brosius
Each index you define on the source CF is created using an internal CF that has as its key the value of the column it's indexing, and as its columns, all the keys of all the rows in the source CF that have that value. So if all your rows in your source CF have the same value, then your index cf

Re: understanding of native indexes: limitations, potential side effects,...

2012-05-16 Thread David Vanderfeesten
Txs Jeremiah, But I am not sure I am following " number of columns could be equal to number of rows ". Is native index implemented as one cf shared over all the indexes (one row in the idx CF corresponding to one index) or is there an internal index cf per index?. My (potential wrong) mindset was

RE: understanding of native indexes: limitations, potential side effects,...

2012-05-16 Thread Jeremiah Jordan
The limitation is because number of columns could be equal to number of rows. If number of rows is large this can become an issue. -Jeremiah From: David Vanderfeesten [feest...@gmail.com] Sent: Wednesday, May 16, 2012 6:58 AM To: user@cassandra.apache.org Subjec