Did you use the “--cql3” option with the cqlsh command?

 

From: Vivek Mishra [mailto:mishra.vivs@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