In cassandra 3.0 we have added the client IP address to the system_traces.sessions table, see https://issues.apache.org/jira/browse/CASSANDRA-8162.
It would be good to be able to show the client ip in cqlsh SHOW_SESSION, for which we would need the client added to the QueryTrace class as done in this commit:
https://github.com/thobbs/python-driver/commit/bf2c95871874ab393cc6f0624f74e79b5f6d8498
However, there is one complexity, in that the client is only available in Cassandra 3.0 and not in Cassandra 2.x. Would you be able to handle this?
Shouldn't be a problem. I'm scheduling this for the release following 2.5, which will be mostly focused on C* 3.0 and protocol v4 enhancements.
Thanks for the ticket.
Great, thank you!