Hi Drill community,
I'm trying to connect to drill 1.19 using JDBC,
For context: I have a VM running zookeeper and another VM running drillbit.
The web UI is working fine, the queries are working fine.
In my maven dependency I have:
<groupId>org.apache.drill.exec</groupId>
<artifactId>drill-jdbc-all</artifactId>
<version>1.19.0</version>
In my code:
Connection conn = null;
String url = "jdbc:drill:zk=<dns name of zk server in the
cloud>:2181;schema=common1";
String query = "SELECT * FROM `common1`.`products.json` LIMIT 10";
Statement stmt = null;
ResultSet result = null;
conn = DriverManager.getConnection(url);
stmt = conn.createStatement();
result = null;
String column1,column2;
result = stmt.executeQuery(query);
When I run the console app I have a bunch of errors but the most prominent is:
CONNECTION : java.net.UnknownHostException: drill3.internal.cloudapp.net: Name
or service not known
drill3.internal.cloudapp.net is exactly the name that appears on the drill web
UI for my only drillbit node.
It makes sense that it cannot resolve as it looks like an internal address so
what I updated my hosts file (on my dev pc) to resolve the public ip address of
the drill node, but it still gives me the same error.
Do you have any ideas how to make my Java app to resolve the internal address?
thanks in advance
Jorge
