incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sasha Dolgy <sdo...@gmail.com>
Subject Operator on secondary indexes in 0.8.x (GTE/LTE)
Date Tue, 11 Oct 2011 20:48:56 GMT
I was trying to get a range of rows based on a secondary_index that was
defined.  Any rows where age was greater than or equal to ... it didn't
work.  Is this a continued limitation?  Did a quick look in JIRA, couldn't
find anything.

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

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

- operator: Operator to test the column value with. Supported operators are
  =, >, >=, <, <= .

  In Cassandra 0.7 at least one = operator must be present.

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

Tested this behavior on 0.8.2, 0.8.6 and now 0.8.7 ...

create column family user
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'BytesType'
  and memtable_operations = 0.24843749999999998
  and memtable_throughput = 53
  and memtable_flush_after = 1440
  and rows_cached = 0.0
  and row_cache_save_period = 0
  and keys_cached = 200000.0
  and key_cache_save_period = 14400
  and read_repair_chance = 1.0
  and gc_grace = 864000
  and min_compaction_threshold = 4
  and max_compaction_threshold = 32
  and replicate_on_write = true
  and row_cache_provider = 'ConcurrentLinkedHashCacheProvider'
  and column_metadata = [
    {column_name : 'gender',
    validation_class : LongType,
    index_name : 'user_gender_idx',
    index_type : 0},
    {column_name : 'year',
    validation_class : LongType,
    index_name : 'user_year_idx',
    index_type : 0}];



-- 
Sasha Dolgy
sasha.dolgy@gmail.com

Mime
View raw message