Re: Working with libcql

2013-07-11 Thread Sorin Manolache
On 2013-07-09 11:46, Shubham Mittal wrote: yeah I tried that and below is the output I get LOG: resolving remote host localhost:9160 libcql is an implementation for the "new binary transport protocol": https://git-wip-us.apache.org/repos/asf?p=cassandra.git;a=blob_plain;f=doc/native_protocol

Re: partition key of composite type and "where partition_key in (...)" clause

2013-06-06 Thread Sorin Manolache
--+-++-+ 0|abc | def | 0 | abc | 0xdeadbeef 1|xyz | uvw | 1 | xyz | 0x8badf00d cqlsh:test> SELECT * FROM tbl WHERE k1=0; k1k2 | k3 | k1 | k2 | m ---+-++-+ 0|abc | def | 0 | abc | 0xdeadbeef -Eric Steven

partition key of composite type and "where partition_key in (...)" clause

2013-06-05 Thread Sorin Manolache
Hello, Is it possible to use the "where partition_key in (...)" clause if the partition key has a composite type? I have a schema as follows: create table tbl ( k1 int, k2 varchar, k3 varchar, m blob, primary key((k1, k2), k3) ) I would like to be able to do something like se

Re: C language - cassandra

2013-05-17 Thread Sorin Manolache
On 2013-05-17 16:42, Apostolis Xekoukoulotakis wrote: Hello, new here, What are my options in using cassandra from a program written in c? A) Thrift has no documentation, so it will take me time to understand. Thrift also doesnt have a balancing pool, asking different nodes every time, which is

Re: C++ Thrift client

2013-05-17 Thread Sorin Manolache
On 2013-05-16 02:58, Bill Hastings wrote: Hi All I am doing very small inserts into Cassandra in the range of say 64 bytes. I use a C++ Thrift client and seem consistently get latencies anywhere between 35-45 ms. Could some one please advise as to what might be happening? Sniff the network tra

Re: Deletes, null values

2013-04-26 Thread Sorin Manolache
;myCF', true, true, ConsistencyLevel::QUORUM, ConsistencyLevel::QUORUM); $my_cf->remove('all', array('1228#16857','1228#16866','1228#16875')); I see. I'm sorry, I know nothing about phpCassa. I use batch_mutation with deletions and it works. But I

Re: Deletes, null values

2013-04-25 Thread Sorin Manolache
On 2013-04-25 11:48, Alain RODRIGUEZ wrote: Hi, I tried to delete some columns using cql2 as well as thrift on C*1.2.2 and instead of being unreachable, deleted columns have a null value. I am using no value in this CF, the only information I use is the existence of the column. So when I select

Re: Prepared Statement - cache duration (CQL3 - Cassandra 1.2.4)

2013-04-21 Thread Sorin Manolache
On 2013-04-19 13:57, Stuart Broad wrote: Hi, I am using Cassandra.Client prepare_cql3_query/execute_prepared_cql3_query to create and run some prepared statements. It is working well but I am unclear as to how long the server side 'caches' the prepared statements. Should a prepared statement b

Re: Prepared Statement - cache duration (CQL3 - Cassandra 1.2.4)

2013-04-19 Thread Sorin Manolache
On 2013-04-19 13:57, Stuart Broad wrote: Hi, I am using Cassandra.Client prepare_cql3_query/execute_prepared_cql3_query to create and run some prepared statements. It is working well but I am unclear as to how long the server side 'caches' the prepared statements. Should a prepared statement b

Re: is the select result grouped by the value of the partition key?

2013-04-12 Thread Sorin Manolache
orton Freelance Cassandra Consultant New Zealand @aaronmorton http://www.thelastpickle.com On 12/04/2013, at 3:19 AM, Sorin Manolache mailto:sor...@gmail.com>> wrote: Hello, Let us consider that we have a table t created as follows: create table t(k1 vachar, k2 varchar, value varchar, prim

is the select result grouped by the value of the partition key?

2013-04-11 Thread Sorin Manolache
Hello, Let us consider that we have a table t created as follows: create table t(k1 vachar, k2 varchar, value varchar, primary key (k1, k2)); Its contents is a m x a n y z 0 9 z 1 8 and I perform a select * from p where k1 in ('a', 'z'); Is it guaranteed that the rows are grouped by the val