incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From John Lumby <johnlu...@hotmail.com>
Subject RE: filter using timeuuid column type
Date Wed, 06 Nov 2013 00:11:37 GMT
________________________________
> Date: Tue, 5 Nov 2013 23:20:37 +0100 
> Subject: Re: filter using timeuuid column type 
> From: tom@drillster.com 
> To: user@cassandra.apache.org 
>  
> This is because time2 is not part of the primary key. Only the primary  
> key column(s) can be queried with> and <. Secondary indexes (like  
> your timeuuid_test2_idx)  can only be queried with the = operator. 

Actually not true.   Any orderable column can be queried with < or>

The rule the OP's query is breaking is not referring to what *is* in the query,
it is referring to what is *not* in the query  :
it wants one more predicate on an indexed (primary or secondary) column
and with an = operator.

So e.g. if the OP had an index on message
and changed the query to

select * from timeuuid_test2 where time2<now() and message = "hello world";

then it would run  (but of course not very useful as it is a different query!)

Cheers,   John Lumby
>  
>  
>  
> --  
> [https://bay175.mail.live.com/Handlers/ImageProxy.mvc?bicild=&canary=w75xNah3sc7JkMJQfB1bXWNlWKeabboHXamZYyX6UCc%3d0&url=http%3a%2f%2fwww.drillster.com%2fmedia%2flogo-signature.png]

>  
> Drillster BV 
> Middenburcht 136 
> 3452MT Vleuten 
> Netherlands 
>  
> +31 30 755 5330 
>  
> Open your free account at www.drillster.com<http://www.drillster.com/> 		 	   
	  
Mime
View raw message