Re: Composite Keys in cassandra 1.2

2015-03-03 Thread Kai Wang
This is a tough one. One thing I can think of is to use Spark/Spark SQL to run ad-hoc queries on C* cluster. You can post on "Spark Cassandra Connector" user group. On Tue, Mar 3, 2015 at 10:18 AM, Yulian Oifa wrote: > Hello > Initially problem is that customer wants to have an option for ANY qu

Re: Composite Keys in cassandra 1.2

2015-03-03 Thread Yulian Oifa
Hello Initially problem is that customer wants to have an option for ANY query , which does not fits good with NOSQL.However the size of data is too big for Relational DB. There are no typical queries on the data, there are 10 fields , based on which ( any mix of them also ) queries should be made.

Re: Composite Keys in cassandra 1.2

2015-03-02 Thread Kai Wang
AFIK it's not possible. The fact you need to query the data by partial row key indicates your data model isn't proper. What are your typical queries on the data? On Sun, Mar 1, 2015 at 7:24 AM, Yulian Oifa wrote: > Hello to all. > Lets assume a scenario where key is compound type with 3 types in

Composite Keys in cassandra 1.2

2015-03-01 Thread Yulian Oifa
Hello to all. Lets assume a scenario where key is compound type with 3 types in it ( Long , UTF8, UTF8 ). Each row stores timeuuids as column names and empty values. Is it possible to retreive data by single key part ( for example by long only ) by using java thrift? Best regards Yulian Oifa