All - I am using the MapR ODBC driver. I can get it to connect in direct mode, however, I can't get it to connect in Zookeeper mode. I think I know why.
To start off, I am using a different zk.root in my drill-override. This allows me to have truly unique drill clusters on the same physical clusters. This works well for most things, however, what I have found, is I believe the ODBC driver assumes a hard coded zk.root. (drill). For example, my cluster name is "drillprod" and my zk.root is "drillprod" So, to connect via JDBC I use URL= "jdbc:drill:zk:hadoopmapr4:5181,hadoopmapr5:5181,hadoopmapr6:5181/drillprod" This works However, I set the ZKClusterID to be drillprod in ODBC and I get Failure occurred while trying to connect to zk= hadoopmapr4.brewingintel.com:5181,hadoopmapr5.brewingintel.com:5181, hadoopmapr6.brewingintel.com:5181/drill/drillprod If set the ZKQuorum to be "hadoopmapr4.brewingintel.com:5181, hadoopmapr5.brewingintel.com:5181, hadoopmapr6.brewingintel.com:5181/drillprod" Then I get this error: Failure occurred while trying to connect to zk= hadoopmapr4.brewingintel.com:5181,hadoopmapr5.brewingintel.com:5181, hadoopmapr6.brewingintel.com:5181/drillprod/drill/drillprod The Znode: /drill/drillprod doesn't exist, neither does /drillprod/drill/drillprod. The correct one, for this use case is "/drillprod/drillprod" But I can't seem to get the ODBC driver to check there, as it appears to hard code a /drill rather than allow me to specify the zk.root as the drill-override.conf does. Please advise John