[BEAM-11399] Cassandra sessions should be (cached) reused per keyspace per host

• Type: Improvement
• Status: Triage Needed
• Priority: P3
• Resolution: Unresolved
• Component/s: io-java-cassandra
• Assignee: Unassigned
• Reporter: Manoj Kumar Singh
• Created: 04/Dec/20 12:08
• Updated: 04/Jun/22 18:11

Description

According to the Datastax document for session "As a given session can only be "logged" into one keyspace at a time (where the "logged" keyspace is the one used by queries that don't explicitly use a fully qualified table name), it can make sense to create one session per keyspace used. This is however not necessary when querying multiple keyspaces since it is always possible to use a single session with fully qualified table names in queries."(source: https://docs.datastax.com/en/drivers/java/3.0/com/datastax/driver/core/Session.html). 

The session fields in Mutator<T> class should be cached and reused for a keyspace and host. 

https://github.com/apache/beam/blob/master/sdks/java/io/cassandra/src/main/java/org/apache/beam/sdk/io/cassandra/CassandraIO.java#L1225