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.
- 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 - 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".
- Deploy the Application.
- 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. - 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
Comments
0 comments
Please sign in to leave a comment.