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 >
