HIVE

Use HiveServer2

hive

Datasource Parameters

Datasource	Description
Datasource	Select HIVE.
Datasource name	Enter the name of the DataSource.
Description	Enter a description of the DataSource.
IP/Host Name	Enter the HIVE service IP.
Port	Enter the HIVE service port.
Username	Set the username for HIVE connection.
Password	Set the password for HIVE connection.
Database name	Enter the database name of the HIVE connection.
Jdbc connection parameters	Parameter settings for HIVE connection, in JSON format.

NOTICE: If you wish to execute multiple HIVE SQL in the same session, you could set support.hive.oneSession = true in common.properties. It is helpful when you try to set env variables before running HIVE SQL. Default value of support.hive.oneSession is false and multi-SQLs run in different sessions.

Use HiveServer2 HA ZooKeeper

hive-server2

NOTICE: If Kerberos is disabled, ensure the parameter hadoop.security.authentication.startup.state is false, and parameter java.security.krb5.conf.path value sets null. If Kerberos is enabled, needs to set the following parameters in common.properties:

# whether to startup kerberos
hadoop.security.authentication.startup.state=true

# java.security.krb5.conf path
java.security.krb5.conf.path=/opt/krb5.conf

# login user from keytab username
login.user.keytab.username=hdfs-mycluster@ESZ.COM

# login user from keytab path
login.user.keytab.path=/opt/hdfs.headless.keytab

Native Supported

Yes, could use this datasource by default.