jdbc:drill:drillbit=<hostname>:31010 The above should work for connecting to embedded Drill running on a remote host. If it doesn't then I'd test whether Drill has bound to port 31010 on a reachable IP address and whether any firewall is interfering.
Related: https://drill.apache.org/docs/ports-and-bind-addresses-used-by-drill/
On 2023/12/01 20:38, yu sun wrote:
Hi there, I'm trying to replace the previous JDBC driver with Drill. However, I had a hard time configuring Squirrel SQL after going through all the tutorials. My previous alias URL has the format below: jdbc:dataaccess://<database host>:<database port>;ServerDataSource=<data source name> I want to use the embedded mode with Drill. The below URL works in Squirrel SQL. jdbc:drill:drillbit=localhost:31010 But how can I visit the database in the specific host and port, rather than my localhost? Where shall I put the information of <database host>:<database port>;ServerDataSource=<data source name>? I tried to use jdbc:drill:drillbit=<database host>:<database port>;ServerDataSource=<data source name> but it won't work. Thank you so much for your help! Yu Sun
