Fetch all rows with entry in one specific column

Hi, is there a way to fetch all row, where the value of one specific column has a entry? And when yes, is this supported by CQL? In normal SQL the statement would call like "SELECT key FROM table WHERE column IS NOT NULL;" I searched the CQL pages and CLI pages on Datastax.com and found nothin

Re: CQL: No indexed column error when < or <= in WHERE clause

;No > >> indexed columns present in by-columns clause with "equals" operator"). > >> The lookup will then be done based on that column and additional > >> filtering (such as for "less than") will be done on the result of the > >> first lookup

Re: CQL: No indexed column error when < or <= in WHERE clause

; http://www.datastax.com/dev/blog/whats-new-cassandra-07-secondary-indexes > > On Sat, Aug 13, 2011 at 2:49 PM, Jens Hartung wrote: > > Hi together, > > > > first, I'm using Cassandra Version 0.8.4 and access it via CQL 1.0.3. > > > > When I select data from

CQL: No indexed column error when < or <= in WHERE clause

Hi together, first, I'm using Cassandra Version 0.8.4 and access it via CQL 1.0.3. When I select data from Cassandra with = in WHERE clause, everything works fine, but when using <= or < in WHERE clause, I always get following Exception: java.sql.SQLException: No indexed columns present in by-c

Re: CQL: How to escape single quotes?

quotes? > On Wed, 2011-08-03 at 03:58 +0200, Jens Hartung wrote: > > Is there a way, to insert Strings with single quotes to Cassandra via > > CQL? > > Yes, escape them with another single quote ('aa''bb'). > > -- > Eric Evans > eev...@racksp

CQL: How to escape single quotes?

Hi all, first, i'm new to Cassandra. I'm use Cassandra 0.8.2 with CQL JDBC Driver Version 1.0.3. My problem is, that I have to insert a large amount of weather data to Cassandra via JAVA. Some of the weather station have single quotes in their name. When I insert them directly via a Statement