Mike, The last URL you connect directly to the drillbit not ZK.
The single biggest issue I have found with JDBC connectivity through ZK is that the host of the client system didn’t resolve the hostname of the ZK system correctly. Check on the Windows Server if you can ping pangolin, easiest way is to set up in the windows/system32/driver/etc/hosts file the host name pangolin with the correct IP so the hostname resolution works. ZK connectivity typically requires that the client can resolve the actual ZK hostname correctly. In your case it may not be the issue, and you may want to check the ZK log for issues. Perhaps the port is blocked. Oh wait you run Drill in embedded mode? Then it is best to connect directly to the drillbit. I don’t believe Drill will use ZK if you run it in embedded mode, you can check ZK with ZKCli and see if there is a /drill with any info in it. Try the Drill Sandbox which is a true on node cluster and see if you can connect to ZK. Keep in mind the ZK port on the Sandbox is 5181. —Andries > On Sep 24, 2015, at 7:40 AM, Mike Beddo <[email protected]> wrote: > > Andries, > > Squirrel runs on my laptop: Latitude E6440, Windows 7 Professional SP 1 (64 > bit). > > TSS runs on Windows Server 2008 R2 dedicated to SQL 2008 R2. > > I found this morning that the connection URL " > jdbc:drill:drillbit=pangolin:31010" satisfies TSS. > > So I don't know why TSS doesn't like the "zk=..." > > - Mike > > -----Original Message----- > From: Andries Engelbrecht [mailto:[email protected]] > Sent: Wednesday, September 23, 2015 4:37 PM > To: [email protected] > Subject: Re: Spotfire server doesn't play nice with Drill 1.1 > > Mike, > > Which machine does TSS run on and which machine does Squirrel run on? > > Perhaps describe your environment a bit more, i.e. what packages are running > on what machines. > > —Andries > > >> On Sep 23, 2015, at 11:47 AM, Mike Beddo <[email protected]> wrote: >> >> Greetings, >> >> I downloaded apache-drill-1.1.0.tar.gz from drill.apache.org. When I run >> drill-embedded, the line just before the message of the day reads "apache >> drill 1.0.0", so I'm a little confused by the seeming mismatch. >> >> I'm running zookeeper and drillbit on a single machine (Pangolin) running >> Ubuntu 12.04.5 LTS. My drill-override.conf contains: >> >> drill.exec: { >> cluster-id: "drillbits1", >> zk.connect: "localhost:2181" >> } >> >> From another machine I am able to connect using Drill Explorer, Squirrel, >> sqlline, etc. All the tools connect and query fine, except for Spotfire. >> >> I'm using Tibco Spotfire 7.0.1. I have followed the directions in the Drill >> documentation for configuring Spotfire Server for Drill. The relevant >> portion of data source XML has been changed from >> >> <connection-url-pattern>jdbc:drill:zk=<zk-node>:5181/drill/<drill-cluster-name>-drillbits</connection-url-pattern> >> >> to >> >> <connection-url-pattern>jdbc:drill:zk=pangolin:2181/drill/drillbits1</connection-url-pattern> >> >> TSS seems happy with this, and the TSS is restarted. >> >> My problems start when configuring Drill data sources with Tibco Spotfire >> Desktop (Step 3 of the Drill instructions). When trying to save, TSS reports >> a connection problem possibly due to a configuration issue. >> >> Squirrel SQL program does just fine with same connection URL. >> >> What might I be doing wrong? >> >> Thanks, >> >> Mike Beddo >> >
