incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vivek Mishra <mishra.v...@gmail.com>
Subject Using compound primary key
Date Tue, 09 Oct 2012 02:21:31 GMT
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

Mime
View raw message