Connecting to HIVE as a data source in DQ+ 4.3 or later versions.

Connecting to Hive Database as Data Source in DQ+ 4.3 or later versions is quite different compared to earlier version of DQ+ (3.3).

Below are the step-by-step instruction.

1. Add `-Digx.runtime.dir=/opt/cafe/runtime` under DEPLOY_JAVA_OPTS of install.properties.
   

   #----------------------------------------------------------------------------------------------------------------
   # Deployment properties
   # The user.timezone property below MUST be modified to the timezone of the local host.
   # The value of user.timezone should be one of the values for the "TZ database name" column at
   # https://en.wikipedia.org/wiki/List_of_tz_database_time_zones that is supported by Java.
   #----------------------------------------------------------------------------------------------------------------
   DEPLOY_JAVA_OPTS=-Dfile.encoding=UTF-8 -Duser.timezone=America/Chicago -Digx.runtime.dir=/opt/cafe/runtime

2. Copy the same keytab file using for Application under /opt/infogix/dqplus-4.3/runtime/, But make sure you use distinct name for keytab file; for example "sagacity.hive.keytab".
   
   
3. Deploy the Application.
   
   
4. After successful deployment, Login into the Application and create Hive Test Data Source to test the connection. And hit the Test button to check the connection between Hive and DQ+.
   
   Set Authentication Method to Kerberos, Principal Name to keytab principal name and Keytab File Name to ${igx.runtime.dir}/keytab_file_name.
   
   
5. Add below values under Execution property of Analysis.
   

   cafe.db.hive.keytab.user  sagacity@EXAMPLE.COM
   
   cafe.db.hive.keytab.file ${igx.runtime.dir}/sagacity.hive.keytab