Are you running Drill in embedded mode or using the Sandbox VM? I don’t believe you can connect to a VM running Drill in Embedded mode from the host using SquirreL with JDBC. JDBC connects via ZooKeeper. It may be best to consider using the Drill SandBox if you would like to use SQuirreL,
What is on the VM where you run Drill? If it is running Amabri do you have ZK running on it? —Andries On Feb 8, 2015, at 12:23 PM, Minnow Noir <[email protected]> wrote: > I am trying to access a drill bit running in a VM from Squirrel on my > desktop. I'm unsure of the Squirrel alias syntax, and having an issue > troubleshooting because I can't access the web interface on 8047 in the > VM. I'm trying this on a VM before worrying about deploying it into a > real cluster. > > 1. I opened the VM FW for 8047 and 2181 so that I could hit them from my > desktop. I also saved and restarted iptables. Iptables is setup to accept > inbound requests from my desktop: > > iptables -L > Chain INPUT (policy ACCEPT) > target prot opt source destination > ACCEPT tcp -- anywhere anywhere tcp > dpt:eforward > ACCEPT tcp -- anywhere anywhere tcp dpt:8047 > > Chain FORWARD (policy ACCEPT) > target prot opt source destination > > Chain OUTPUT (policy ACCEPT) > target prot opt source destination > > 2. I installed and started 0.70 using -u jdbc:drill:zk=local, and then ran > some queries against files on "DFS," which worked fine. Netstat says that > the drillbit is running on 8047, but that nothing is running on the ZK port. > > # netstat -an | egrep "(8047|2181)" > tcp 0 0 :::8047 :::* > LISTEN > > 3. I followed the Squirrel installation instructions, but got hung up > defining the driver and alias because the instructions appear to be for > people not running Drill in "local" mode. > > 4. I thought I'd look at the web UI to see if it gave me any clues about > how to connect Squirrel to the drillbit, but for some reason, I cannot > connect to the drillbit running on exposed port 8047. (I can, however, > connect to Ambari running on 8080.) > > Is it possible to connect Squirrel on the desktop to the local drillbit > running in the VM? > > > Thanks
