Re: Perfroming simple CQL Query using pyhton db-api 2.0 fails

2013-01-24 Thread aaron morton
How did you create the table? Anyways that looks like a bug, I *think* they should go here http://code.google.com/a/apache-extras.org/p/cassandra-dbapi2/issues/list Cheers - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On

Re: Perfroming simple CQL Query using pyhton db-api 2.0 fails

2013-01-24 Thread Paul van Hoven
The reason for the error was that I opened the connection to the database wrong. I did: con = cql.connect(host, port, keyspace) but correct is: con = cql.connect(host, port, keyspace, cql_version='3.0.0') Now it works fine. Thanks for reading. 2013/1/24 aaron morton aa...@thelastpickle.com:

Perfroming simple CQL Query using pyhton db-api 2.0 fails

2013-01-23 Thread Paul van Hoven
I try to access my local cassandra database via python. Therefore I installed db-api 2.0 and thrift for accessing the database. Opening and closing a connection works fine. But a simply query is not working: The script looks like this: c = conn.cursor() c.execute(select * from users;)