Is there a way to do RangeSuperSlicesQuery for composite columns? Using the setup below(which I can change), I want to be able to do a range scan on the key, the a subsequent scan on the composite type. This would resolve a query like
select * from LastNameFirstNameZip
where lName like 'You%'
and FName like 'Regin%'
and Zip like '300%'
Which i would expect to return:
-------------------
RowKey: Youdelman_123
=> (column=Regina:30082, value=123, timestamp=1342618064598000)
-------------------
RowKey: Youdelman_125
=> (column=Regin:30080, value=125, timestamp=1342618064623001)
Column Family definition:
create column family LastNameFirstNameZip
with comparator = 'CompositeType(UTF8Type,UTF8Type)'
and key_validation_class = 'UTF8Type'
and default_validation_class = 'UTF8Type';
data:
-------------------
RowKey: Youdelman_123
=> (column=Regina:30082, value=123, timestamp=1342618064598000)
-------------------
RowKey: Youdelman_124
=> (column=Reggie:30082, value=124, timestamp=1342618064623000)
-------------------
RowKey: Youdelman_125
=> (column=Regin:30080, value=125, timestamp=1342618064623001)
-------------------
RowKey: Youdelman_126
=> (column=Ella:30080, value=126, timestamp=1342618064623002)