cheers.

On Tue, Oct 11, 2011 at 1= 1:01 PM, Jake Luciani <jakers@gmail.com> wrote:

This hasn't changed in AFAIK, =A0In Bri= sk we had the same problem in CFS so we created a=A0sentinel=A0value that a= ll rows shared then it works. CASSANDRA-2915 should fix it.

On Tue, Oc= t 11, 2011 at 4:48 PM, Sasha Dolgy <sdolgy@gmail.com> wrote:<= br>
I was trying to get a range of rows bas= ed on a secondary_index that was defined. =A0Any rows where age was greater= than or equal to ... it didn't work. =A0Is this a continued limitation= ? =A0Did a quick look in JIRA, couldn't find anything. =A0

The output from "help get;" on the cli contai= ns the following, which led me to believe it was a limitation on Cassandra = 0.7.x and not on 0.8.x ...=A0

get <cf> = where <col> <operator> <value> [

=A0 =A0 and <col> <operator> <value> and ...] [limit= <limit>];
get <cf> where <col> <operator>= ; <function>(<value>) [
=A0 =A0 and <col> <o= perator> <function> and ...] [limit <limit>];

- operator: Operator to test the column valu= e with. Supported operators are
=A0 =3D, >, >=3D, <, <= ;=3D .

=A0 In Cassandra 0.7 at least one =3D opera= tor must be present.

[default@sdo] =A0get user where age >=3D 18;=A0
No indexed columns present in index clause with operator EQ
[default@sdo]=A0 get user where gender =3D 1 and age >=3D 18=
(returns results)

Tested this behavior on 0.8.2, 0= .8.6 and now 0.8.7 ...=A0

create column famil= y user
=A0 with column_type =3D 'Standard'
=A0 = and comparator =3D 'UTF8Type'

=A0 and default_validation_class =3D 'BytesType'
=A0= and key_validation_class =3D 'BytesType'
=A0 and memtabl= e_operations =3D 0.24843749999999998
=A0 and memtable_throughput = =3D 53

=A0 and memtable_flush_after =3D 1440
=A0 and rows_cached = =3D 0.0
=A0 and row_cache_save_period =3D 0
=A0 and key= s_cached =3D 200000.0
=A0 and key_cache_save_period =3D 14400
=A0 and read_repair_chance =3D 1.0

=A0 and gc_grace =3D 864000
=A0 and min_compaction_threshold= =3D 4
=A0 and max_compaction_threshold =3D 32
=A0 and = replicate_on_write =3D true
=A0 and row_cache_provider =3D 'C= oncurrentLinkedHashCacheProvider'

=A0 and column_metadata =3D [
=A0 =A0 {column_nam= e : 'gender',
=A0 =A0 validation_class : LongType,
<= div>=A0 =A0 index_name : 'user_gender_idx',
=A0 =A0 index= _type : 0},

=A0 =A0 {column_name : 'year',
=A0 =A0 va= lidation_class : LongType,
=A0 =A0 index_name : 'user_year_id= x',
=A0 =A0 index_type : 0}];

--
Sasha Dolgy
sasha.dolgy@gmail.com

--
http://twitter.com/tjake

--
Sasha Dolgy<= br>sasha.dolgy@g= mail.com

--0016e6d784a5c1024904af0c47b4--