I'm using a zookeeper connection string to get a connection to a drill
cluster. I would like to log which drillbit (hostname or IP address) I
successfully connected to, but I can't find any property or method on
the java.sql.Connection
class <https://docs.oracle.com/javase/8/docs/api/java/sql/Connection.html>
to get this information.
I tried connection.getMetaData.getURL, but that just returns the zookeeper
connection string I used to get the connection (scala code below):
import java.sql._
Class.forName("com.mapr.drill.jdbc41.Driver")
val con =
DriverManager.getConnection("jdbc:drill:zk=<server1>:5181,<server2>:5181/drill/<cluster_name>...")
con.getMetaData().getURL() // returns "jdbc:drill:zk=<server1>...", so not
what I'm looking for
val st = con.createStatement()
val res = st.executeQuery("select *,'findme' from sys.drillbits")
while(res.next()) { println(res.getString(1)) }
If I "grep" the drillbit_queries.json logs on all of the drillbit servers
for "findme", I can find which drillbit was used to execute the query, and
hence which drillbit I'm currently connected to. For tracking down
connection issues, however, I'd like to be able to log which drillbit is
being used from the application, rather than have to grep logfiles.
This question is also posted on StackOverflow:
https://stackoverflow.com/questions/68042577/how-to-determine-which-apache-drill-drillbit-was-selected-when-connecting-via-zo
