You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@cassandra.apache.org by Jeff Williams <je...@wherethebitsroam.com> on 2012/06/22 09:57:56 UTC

Find rows without a column

Hi,

It doesn't look like this is possible, but can I select all rows missing a certain column? The equivalent of "select * where col is null" in SQL.

Regards,
Jeff

Re: Find rows without a column

Posted by Dave Brosius <db...@mebigfatguy.com>.

On 06/22/2012 03:57 AM, Jeff Williams wrote:
> Hi,
>
> It doesn't look like this is possible, but can I select all rows missing a certain column? The equivalent of "select * where col is null" in SQL.
>
> Regards,
> Jeff

remember that there really is no such thing as a row, just arbitrary 
columns associated with a key. So no, can't find 'rows' where a column 
is missing.