Datastax cassandra-driver (python) failed import

Well, it looks like names conflict. Your script is cassandra.py and so it is the module for the driver. Try to rename your script (and don't forget to delete its .pyc) and try again

Install CQL interactive terminal:

sudo pip install cqlsh