Page History

...

Whether the version of Hadoop which is running supports sub-directories for tables/partitions. Many Hive optimizations can be applied if the Hadoop version supports sub-directories for tables/partitions. This support was added by MAPREDUCE-1501.

hive.mapred.mode

• Added In: Hive 0.3.0
• Default Value: 
  • Hive 0.3 & later x: nonstrict
  • Hive 1.x: nonstrict
  • Hive 2.x: strict (HIVE-12413)
• Added In: Hive 0.3.0

The mode in which the Hive operations are being performed. In strict mode, some risky queries are not allowed to run. For example, full table scans are prevented (see HIVE-10454) and ORDER BY requires a LIMIT clause.

...

The interval with which to poll the JobTracker for the counters the running job. The smaller it is the more load there will be on the jobtracker, the higher it is the less granular the caught will be.

hive.enforce.bucketing

• Added In: Hive 0.6.0
• Default Value: 
  • Hive 0.6 & later x: false
  • Hive 1.x: false
  • Config is removed in Hive 2.x which has an effect that its : removed, which effectively makes it always true (HIVE-12331)
• Added In: Hive 0.6.0

Whether bucketing is enforced. If true, while inserting into the table, bucketing is enforced.

Set to true to support INSERT ... VALUES, UPDATE, and DELETE transactions (Hive 0.14.0 and later). For a complete list of parameters required for turning on Hive transactions, see hive.txn.manager.

hive.enforce.sorting

• Added In: Hive 0.6.0
• Default Value: 
  • Hive 0.6 & later x: false
  • Hive 1.x: false
  • Config is removed in Hive 2.x which has an effect that its : removed, which effectively makes it always true (HIVE-12331)
• Added In: Hive 0.6.0

Whether sorting is enforced. If true, while inserting into the table, sorting is enforced.

...

datanucleus.fixedDatastore

• Default Value: 
  • Hive 0.x: false
  • Hive 1.x: false
  • Hive 2.x: true (HIVE-1841)
• Added In: Hive 0.12.0

Dictates whether to allow updates to schema or not.

datanucleus.autoCreateSchema

• Default Value: 
  • Hive 0.x: true
  • Hive 1.x: true
  • Hive 2.x: false (HIVE-1841)
• Added In: Hive 0.7.0

Creates necessary schema on a startup if one doesn't does not exist. Set this to false, after creating it once.

...

hive.metastore.schema.verification

• Added In: Hive 0.12.0 with HIVE-3764
• Default Value: 
  • Hive 0.12 & later : false x: false 
  • Hive 1.x: false
  • Hive 2.x: true (HIVE-12436)
• Added In: Hive 0.12.0 with HIVE-3764

Enforce metastore schema version consistency.
True: Verify that version information stored in metastore matches with one from Hive jars. Also disable automatic schema migration attempt (see datanucleus.autoCreateSchema). Users are required to manually migrate schema after Hive upgrade which ensures proper metastore schema migration.
False: Warn if the version information stored in metastore doesn't match with one from Hive jars.

...

For WebHCat configuration, see Configuration Variables in the WebHCat manual.