

Using the default install path on Windows, this becomes: Note the dummy path to the keytab and the dummy principal in this file template:Ĭom.Krb5LoginModule Specify your keytab path with forward slashes (even though your deployment is on Windows). You'll need a nf file, which points to the keytab file. The basic nf file layout is below. The keytab file - If you're authenticating to Kerberos via a keytab, you'll need to obtain a keytab file (usually generated by a Kerberos admin or other knowledgeable resource), and the user principal associated with the keytab.Ģc. On Windows, the file may be called krb5.ini.Ģb. nf (krb5.ini) file - From your Kerberos admin or other knowledgeable resource, obtain a nf file. You can download it from Hortonworks here or (at the time of this writing) from this github.Ģa. Note: winutils.exe is not distributed with Hadoop. You will also need hadoop winutils.exe for 1a and 1b. Note: If you have previously deployed Hive driver jars, you should delete them from the Agent driver directory before you deploy the driver jars from your Hive server. Note that you'll need to match your Hive version to the driver version that you download.ĭeploy the driver jar(s) to your Agent you can find instructions for this procedure here.

You can download this driver from this github. QuerySurge's vendor, RTTS, partners with CData you can see information about the CData driver offering here.ġc. Note: For Zookeeper URLs (see Step 5), additional jar files may be required: curator-client-X.X.X.jar, curator-framework-X.X.X.jar.ġb. Get the JDBC driver jars for your Hive distro from your Hive server (asterisks indicate distribution-specific notations): If you receive this outcome, we recommend trying one of the other options listed below (1b or 1c).ġa. The typical result in this case is that your connection attempt will error out with either a NoClassDefFoundError or a ClassNotFoundException. Note: Due to changes in recent releases of the Apache Hive "standalone" driver jar (see 1a), depending on your version, the list of required jars shown may not be correct or complete for kerberized Hive connections.
#Dbvisualizer pass kerberos cache file drivers#
We strongly encourage using the specific Apache drivers from your Hadoop distro and version. The drivers on which this procedure is based are the standard Apache Hive JDBC drivers. This procedure is for QuerySurge Agents deployed on Windows.
