Re: SELECT DISTINCT and rows with only static columns

2015-09-09 Thread Robert Coli
On Fri, Sep 4, 2015 at 5:30 PM, Kay Johansen wrote: > > Now that I know this I can plan for this, but I'm wondering why this is > the case so I can understand the underlying mechanism. > While it's not impossible that a question of this nature will be answered on this list, if I were you, I would

SELECT DISTINCT and rows with only static columns

2015-09-04 Thread Kay Johansen
I have a columnfamily with static columns and non-static columns. When I have a row with values only in the static columns, select distinct will return that row, whereas select will not. For example: cqlsh> select distinct id from members where id = 'zyto-8c0db'; plan_id zyto-8c0d