Hi All,
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?
-Vivek
