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-8c0db

(1 rows)

cqlsh> select id from members where  id = 'zyto-8c0db';

(0 rows)


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.

Using Cassandra 2.0.11.83.

Thanks in advance for any insight,
-Kay

-- 
Kay Johansen, Software Craftsman
Pluralsight | democratizing professional training
(801) 784-9007

Reply via email to