Versions Compared

Old Version 55

changes.mady.by.user Lefty Leverenz

Saved on

compared with

New Version 56

changes.mady.by.user Lefty Leverenz

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: more HiveServer2 parameters

...

  • Default Value: (empty)
  • Added In: Hive 0.11.0 with HIVE-2935

LDAP base DN (distinguished name).

hive.server2.custom.authentication.class

...

hive.server2.enable.doAs

...

Setting this property to true will have HiveServer2 execute Hive operations as the user making the calls to it.

hive.server2.

...

transport.mode
  • Default Value: xxbinary
  • Added In: Hive 0.12.0 with HIVE-x0

Server transport mode. Value can be "binary" or "http".X

hive.server2.

...

thrift.http.port
  • Default Value: xx10001
  • Added In: Hive 0.12.0 with HIVE-x0

Port number when in HTTP mode.X

hive.server2.thrift.http.

...

path
  • Default Value: xxcliservice
  • Added In: Hive 0.12.0 with HIVE-x0

Path component of URL endpoint when in HTTP mode.X

hive.server2

...

.thrift.http.min.worker.threads
  • Default Value: xx5
  • Added In: Hive 0.12.0 with HIVE-x

X

hive.server2.x
  • 0

Minimum number of worker threads when in HTTP mode.

hive.server2.thrift.http.max.worker.threads
  • Default Value: 500
  • Added In: Hive 0.12.0

Maximum number of worker threads when in HTTP mode.

hive.server2.thrift.sasl.qop
  • Default Value: auth
  • Added In: Hive 0.12.0

Sasl QOP value; set it to one of the following values to enable higher levels of protection for HiveServer2 communication with clients.

"auth" -- authentication only (default)
"auth-int" -- authentication plus integrity protection
"auth-conf" -- authentication plus integrity and confidentiality protection

This is applicable only if HiveServer2 is configured to use Kerberos authentication.

hive.server2.async.exec.threads
  • Default Value: 50 in Hive 0.12.0, 100 in Hive 0.13.0 and later
  • Added In: Hive 0.12.0

Number of threads in the async thread pool for HiveServer2.

hive.server2.async.exec.shutdown.timeout
  • Default Value: 10
  • Added In: Hive 0.12.0

Time (in seconds) for which HiveServer2 shutdown will wait for async threads to terminate.

hive.server2.authentication.ldap.Domain
  • Default Value: (empty)
  • Added In: Hive 0.12.0

LDAP domain.

hive.server2.table.type.mapping
  • Default Value: CLASSIC
  • Added In: Hive 0.12.0

This setting reflects how HiveServer2 will report the table types for JDBC and other client implementations that retrieve the available tables and supported table types.

HIVE: Exposes Hive's native table types like MANAGED_TABLE, EXTERNAL_TABLE, VIRTUAL_VIEW
CLASSIC: More generic types like TABLE and VIEW

hive.server2.session.hook
  • Default Value: (empty)
  • Added In: Hive 0.12.0 with HIVE-4588

Session-level hook for HiveServer2.

hive.server2.max.start.attempts
  • Default Value: 30
  • Added In: Hive 0.13.0

The number of times HiveServer2 will attempt to start before exiting, sleeping 60 seconds between retries. The default of 30 will keep trying for 30 minutes.

hive.server2.async.exec.wait.queue.size
  • Default Value: 100
  • Added In: Hive 0.13.0

Size of the wait queue for async thread pool in HiveServer2. After hitting this limit, the async thread pool will reject new requests.

hive.server2.async.exec.keepalive.time
  • Default Value: 10
  • Added In: Hive 0.13.0

Time (in seconds) that an idle HiveServer2 async thread (from the thread pool) will wait for a new task to arrive before terminating.

hive.server2.long.polling.timeout
  • Default Value: 5000L
  • Added In: Hive 0.13.0

Time in milliseconds that HiveServer2 will wait, before responding to asynchronous calls that use long polling.

hive.server2.allow.user.substitution
  • Default Value: true
  • Added In: Hive 0.13.0

Allow alternate user to be specified as part of HiveServer2 open connection request.

hive.server2.authentication.spnego.keytab
  • Default Value: (empty)
  • Added In: Hive 0.13.0

Keytab file for SPNEGO principal, optional. A typical value would look like /etc/security/keytabs/spnego.service.keytab. This keytab would be used by HiveServer2 when Kerberos security is enabled and HTTP transport mode is used. This needs to be set only if SPNEGO is to be used in authentication.

SPNEGO authentication would be honored only if valid hive.server2.authentication.spnego.principal and hive.server2.authentication.spnego.keytab are specified.

hive.server2.authentication.spnego.principal
  • Default Value: (empty)
  • Added In: Hive 0.13.0

SPNEGO service principal, optional. A typical value would look like HTTP/_HOST@EXAMPLE.COM. The SPNEGO service principal would be used by HiveServer2 when Kerberos security is enabled and HTTP transport mode is used. This needs to be set only if SPNEGO is to be used in authentication.

hive.server2.authentication.pam.services
  • Default Value: (empty)
  • Added In: Hive 0.13.0 with HIVE-6466

List of the underlying PAM services that should be used when hive.server2.authentication type is PAM. A file with the same name must exist in /etc/pam.d.

hive.server2.use.SSL
  • Default Value: false
  • Added In: Hive 0.13.0

Set this to true for using SSL encryption in HiveServer2.

hive.server2.keystore.path
  • Default Value: (empty)
  • Added In: Hive 0.13.0

SSL certificate keystore location.

hive.server2.keystore.password
  • Default Value: (empty)
  • Added In: Hive 0.13.0

SSL certificate keystore password.

hive.server2.tez.default.queues
  • Default Value: (empty)
  • Added In: Hive 0.13.0 with HIVE-6325

A list of comma separated values corresponding to YARN queues of the same name. When HiveServer2 is launched in Tez mode, this configuration needs to be set for multiple Tez sessions to run in parallel on the cluster.

hive.server2.tez.sessions.per.default.queue
  • Default Value: 1Default Value: xx
  • Added In: Hive 0.1213.0 with HIVE-x

X

A positive integer that determines the number of Tez sessions that should be launched on each of the queues specified by hive.server2

...

  • Default Value: xx
  • Added In: Hive 0.12.0 with HIVE-x

...

.tez.default.queues. Determines the parallelism on each queue.

hive.server2

...

.tez.initialize.default.sessions
  • Default Value: xxfalse
  • Added In: Hive 0.1213.0 with HIVE-x

...

This flag is used in HiveServer 2 to enable a user to use HiveServer 2 without turning on Tez for HiveServer 2. The user could potentially want to run queries
over Tez without the pool of sessions.

Indexing

Indexing was added in Hive 0.7.0 with HIVE-417, and bitmap indexing was added in Hive 0.8.0 with HIVE-1803.  For more information see Indexing.

...