Hey Vivek, The same thing happened to me the other day. You may be missing a component in your compound key.
See this thread: http://mail-archives.apache.org/mod_mbox/cassandra-dev/201210.mbox/%3ccajhhpg20rrcajqjdnf8sf7wnhblo6j+aofksgbxyxwcoocg...@mail.gmail.com%3E I also wrote a couple blogs on it: http://brianoneill.blogspot.com/2012/09/composite-keys-connecting-dots-between.html http://brianoneill.blogspot.com/2012/10/cql-astyanax-and-compoundcomposite-keys.html They've fixed this in the 1.2 beta, whereby it checks (at the thrift layer) to ensure you have the requisite number of components in the compound/composite key. -brian On Oct 8, 2012, at 10:32 PM, Vivek Mishra wrote: > Certainly. As these are available with cql3 only! > Example mentioned on datastax website is working fine, only difference is i > tried with a compound primary key with 3 composite columns in place of 2 > > -Vivek > > On Tue, Oct 9, 2012 at 7:57 AM, Arindam Barua <aba...@247-inc.com> wrote: > > > Did you use the “--cql3” option with the cqlsh command? > > > > From: Vivek Mishra [mailto:mishra.v...@gmail.com] > Sent: Monday, October 08, 2012 7:22 PM > To: user@cassandra.apache.org > > > Subject: Using compound primary key > > > > Hi, > > > > I am trying to use compound primary key column name and i am referring to: > > http://www.datastax.com/dev/blog/whats-new-in-cql-3-0 > > > > As mentioned on this example, i tried to create a column family containing > compound primary key (one or more) as: > > > > CREATE TABLE altercations ( > > instigator text, > > started_at timestamp, > > ships_destroyed int, > > energy_used float, > > alliance_involvement boolean, > > PRIMARY KEY (instigator,started_at,ships_destroyed) > > ); > > > > And i am getting: > > > > ********************************************************************** > > TSocket read 0 bytes > > cqlsh:testcomp> > > ********************************************************************** > > > > > > Then followed by insert and select statements giving me following errors: > > > > ******************************************************************************************************************************************** > > > > cqlsh:testcomp> INSERT INTO altercations (instigator, started_at, > ships_destroyed, > > ... energy_used, > alliance_involvement) > > ... VALUES ('Jayne Cobb', '2012-07-23', 2, > 4.6, 'false'); > > TSocket read 0 bytes > > > > cqlsh:testcomp> select * from altercations; > > Traceback (most recent call last): > > File "bin/cqlsh", line 1008, in perform_statement > > self.cursor.execute(statement, decoder=decoder) > > File "bin/../lib/cql-internal-only-1.0.10.zip/cql-1.0.10/cql/cursor.py", > line 117, in execute > > response = self.handle_cql_execution_errors(doquery, prepared_q, compress) > > File "bin/../lib/cql-internal-only-1.0.10.zip/cql-1.0.10/cql/cursor.py", > line 132, in handle_cql_execution_errors > > return executor(*args, **kwargs) > > File > "bin/../lib/cql-internal-only-1.0.10.zip/cql-1.0.10/cql/cassandra/Cassandra.py", > line 1583, in execute_cql_query > > self.send_execute_cql_query(query, compression) > > File > "bin/../lib/cql-internal-only-1.0.10.zip/cql-1.0.10/cql/cassandra/Cassandra.py", > line 1593, in send_execute_cql_query > > self._oprot.trans.flush() > > File > "bin/../lib/thrift-python-internal-only-0.7.0.zip/thrift/transport/TTransport.py", > line 293, in flush > > self.__trans.write(buf) > > File > "bin/../lib/thrift-python-internal-only-0.7.0.zip/thrift/transport/TSocket.py", > line 117, in write > > plus = self.handle.send(buff) > > error: [Errno 32] Broken pipe > > > > cqlsh:testcomp> > > > > ******************************************************************************************************************************************** > > > > > > > > Any idea? Is it a problem with CQL3 or with cassandra? > > > > P.S: I did post same query on dev group as well to get a quick response. > > > > > > -Vivek > > -- Brian ONeill Lead Architect, Health Market Science (http://healthmarketscience.com) mobile:215.588.6024 blog: http://weblogs.java.net/blog/boneill42/ blog: http://brianoneill.blogspot.com/