You can run in embedded mode within Squirrel but you would need to use the same classpath that the drillbit startup creates for your driver rather than using the jdbc-driver jar (the jdbc-driver jar doesn't support embedded mode). Once started in embedded, the web interface will be available.
On Sun, Feb 8, 2015 at 2:40 PM, Andries Engelbrecht < [email protected]> wrote: > 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 > >
