While Livy Server is in Windows OS

The following are the steps to create a Hive connection with Kerberos on windows operating system:

      Note: while giving path Instead of "\" use "/"

  1. Obtain the Kerberos Principle name, hive.keytab and krb5.conf for the environments which you are trying to connect. place them in your desired folder. (make sure that folder path don't have any spaces)
  2. Rename krb5.conf as krb5.ini then place it in C:/windows/ 
  3. Copy the file jassconfig.conf from the DataOpsSuite Installation directory (C:/app/Datagaps/DataOpsSuite/Server/apache-tomcat/files)place it in your desired folder.
  4. modify the principle name and hive keytab file path in jassconfig.conf file. 
  5. Log in to DataOps Suite.
  6. On the side menu, click Data Sources.
  7. Click Data Source +.
  8. Select Hive.
  9. Specify the following Data Source Information.
    • Name. Enter a name for the connection.
    • DataSystem. Select the Datasystem under which this connection should be created.
    • JDBC Connection URL. Enter the connection URL in the following format: jdbc:hive2://"host name of hivedatasource":"port"/"Databasename";AuthMech=1;principal=hive/"hostname"@"REALM";KrbServiceName=hive;KrbHostFQDN="host FQDN";KrbRealm="REALM";krbAuthType=1
    • Driver. Enter the driver as com.cloudera.hive.jdbc41.HS2Driver.
    • Is Kerberos Enabled. Select this checkbox to enable Kerberos for Hive connection.
    • Kerberos Conf Location. Specify the Kerberos Conf file location c:/windows/krb5.ini
    • JAAS Conf Location.  Specify the JAAS Conf file location (Path to jassconfig.ini)
  10. Click Save to save the connection.
  11. if the hive Datasource hostname and kerberos realm hostname are not resolvable make an entry in the file "c:\windows\system32\drivers\etc\hosts" (append at the end of file "ipaddress hostname")