Re: how to make unique coloumns in cassandra

2015-03-01 Thread Rahul Srivastava
but what if i want to fetch the value using on table then this idea might fail On Mon, Mar 2, 2015 at 12:46 PM, Ajaya Agrawal wrote: > Make a table for each of the unique keys. For e.g. > > If primary key for user table is user_id and you want the phone number > column to be unique then create a

Re: how to make unique coloumns in cassandra

2015-03-01 Thread Ajaya Agrawal
Make a table for each of the unique keys. For e.g. If primary key for user table is user_id and you want the phone number column to be unique then create another table wherein the primary key is (phone_number, user_id). Before inserting to main table try to insert to this table first with "if not

using or in select query in cassandra

2015-03-01 Thread Rahul Srivastava
Hi I want to make uniqueness for my data so i need to add OR clause in my WHERE clause. ex: select * from table where id =123 OR name ='abc' so in above i want that i get data if my id is 123 or my name is abc . is there any possibility in cassandra to achieve this .

Optimal Batch size (Unlogged) for Java driver

2015-03-01 Thread Ajay
Hi, I am looking at a way to compute the optimal batch size in the client side similar to the below mentioned bug in the server side (generic as we are exposing REST APIs for Cassandra, the column family and the data are different each request). https://issues.apache.org/jira/browse/CASSANDRA-648

does need to disable 'rpc_keepalive' if 'rpc_max_threads' is get larger?

2015-03-01 Thread pprun
rpc_max_threads is set to 2048 and the 'rpc_server_type' is 'hsha', after 2 days running, observed that there's a high I/O activity and the number of 'RCP thread' grow to '2048' and VisualVm shows most of them is 'waiting'/'sleeping' (color: yellow). I want to know if I set rpc_keepalive to fa

Re: How to extract all the user id from a single table in Cassandra?

2015-03-01 Thread Check Peck
Sending again as I didn't got any response on this. Any thoughts? On Fri, Feb 27, 2015 at 8:24 PM, Check Peck wrote: > I have a Cassandra table like this - > > create table user_record (user_id text, record_name text, record_value > blob, primary key (user_id, record_name)); > > What is the

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