Re: Select with filtering

2014-04-25 Thread Peter Lin
Other people have expressed an interest and there's existing jira ticket for this type if feature. Unfortunately it hasn't gotten much traction and the tickets are basically dead Sent from my iPhone > On Apr 25, 2014, at 12:03 PM, Mikhail Mazursky wrote: > > Hello Paco, > > thanks for respo

Re: Select with filtering

2014-04-25 Thread Mikhail Mazursky
Hello Paco, thanks for response. IMHO this is a not implemented feature in such case. Instead of fetching whole wide row using partitioning key and filtering it on client side this can be done on server side. In my particular case this will be more optimal than adding secondary index. Maybe in ca

RE: Select with filtering

2014-04-25 Thread Paco Trujillo
Hi Mikhail It is not a bug/not implemented feature and you are not doing nothing wrong. As you can check on the documentation you can only filter on a key name or a column that has a secondary index created on it: http://www.datastax.com/documentation/cql/3.1/cql/cql_reference/select_r.html F