Hi all, I have a table like
CREATE TABLE ks.cf ( pk1 bigint, cc1 bigint, disp_name text , stat_obj text, status int, PRIMARY KEY (pk1, cc1)) WITH CLUSTERING ORDER BY (cc1 ASC) CREATE INDEX idx1 on ks.cf(status); I want to have a queries like *select * from ks.cf <http://ks.cf> where pk1=123 and cc1=345;* and *select * from ks.cf <http://ks.cf> where pk1=123 and status=1;* In this case , I want rows to be sorted based on 'disp_name' (asc/desc) . Can I achieve the same using UDF or anything else ?? (Sorry If my understanding about UDF is wrong). Thanks in advance TechPyaasa