Page History

...

This document describes the Hive configuration properties (sometimes called parameters, variables, or options) , noting and notes the releases that introduced new properties.

The canonical list of configuration properties is managed in the HiveConf Java class, so refer to the HiveConf.java file for a complete list of configuration properties available in your Hive release.

...

Size per reducer. The default is 1G, that is, i.e if the input size is 10G , it will use then 10 reducers will be used.

hive.exec.reducers.max

• Default Value: 999
• Added In:

Max number of reducers will be used. If the one specified in the configuration parameter property mapred.reduce.tasks is negative, hive Hive will use this one as the max number of reducers when automatically determine number of reducers.

...

• Default Value: (empty)
• Added In:

List of comma-separated listeners for metastore events.

...

• Default Value: (empty)
• Added In:

List of comma seperated -separated keys occurring in table properties which will get inherited to newly created partitions. * implies all the keys will get inherited.

...

• Default Value: (empty)
• Added In:

List of comma-separated listeners for the end of metastore functions.

...

• Default Value: Table,StorageDescriptor,SerDeInfo,Partition,Database,Type,FieldSchema,Order
• Added In:

List of comma-separated metastore object types that should be pinned in the cache.

...

• Default Value: false
• Added In:

Enable or disable the hive Hive client authorization.

hive.security.authorization.manager

• Default Value: org.apache.hadoop.hive.ql.security.authorization.DefaultHiveAuthorizationProvider
• Added In:

The hive Hive client authorization manager class name. The user defined authorization class should implement interface org.apache.hadoop.hive.ql.security.authorization.HiveAuthorizationProvider.

...

Hive client authenticator manager class name. The user-defined authenticator should implement interface org.apache.hadoop.hive.ql.security.HiveAuthenticationProvider.

...

The privileges automatically granted to the owner whenever a table gets created. An example like "select,drop" will grant select and drop privilege to the owner of the table.

hive.security.command.whitelist

• Default Value: set,reset,dfs,add,delete
• Added In: Hive 0.13.0 with HIVE-5400

Comma separated list of non-SQL Hive commands that users are authorized to execute. This can be used to restrict the set of authorized commands. The currently supported command list is "set,reset,dfs,add,delete" and by default all these commands are authorized. To restrict any of these commands, set hive.security.command.whitelist to a value that does not have the command in it.

Hive Metastore Security

hive.security.metastore.authorization.manager

...

A storage-based authorization implementation is provided to use as the value of this parameterconfiguration property:

• org.apache.hadoop.hive.ql.security.authorization.StorageBasedAuthorizationProvider

...

The pre-event listener classes to be loaded on the metastore side to run code whenever databases, tables, and partitions are created, altered, or dropped. Set this parameter configuration property to org.apache.hadoop.hive.ql.security.authorization.AuthorizationPreEventListener in hive-site.xml for Hive metastore security.

...

Whether to include the current database in the hive Hive prompt.

HBase StorageHandler

...

• Default Value: false
• Added In:

Whether hive Hive is running in test mode. If yes, it turns on sampling and prefixes the output tablename.

...

• Default Value: test_
• Added In:

If hive Hive is running in test mode, prefixes the output table by this string.

...

• Default Value: 32
• Added In:

If hive Hive is running in test mode and table is not bucketed, sampling frequency.

...

• Default Value: (empty)
• Added In:

If hive Hive is running in test mode, don't sample the above comma separated list of tables.

...