In an effort to answer your questions, I did a little digging on this one. Does Cassandra capture microseconds with timestamp data type? Microseconds no, milliseconds yes. If I create your table, insert a row, and try to query it by the truncated time, it doesn’t work: aploetz@cqlsh:stackoverflow> INSERT INTO data (datetime, id, type, data) … Read more
You need to edit cassandra.yaml on the node you are trying to connect to and set the node ip address for rpc_address and listen_address and restart Cassandra. rpc_address is the address on which Cassandra listens to the client calls. listen_address is the address on which Cassandra listens to the other Cassandra nodes.
You are running into CASSANDRA-11850, where cqlsh breaks with Python 2.7.11+. This ticket has been marked as “Resolved” and a patch has been applied to Cassandra 3.9 which has not been released yet. I believe I installed all the necessary packages such as java 8 and python 2.7.12. In the interim (until 3.9 is released) … Read more