hive.execution.engine
mapred.reduce.tasks
hive.exec.reducers.max
hive.mapred.local.mem
hive.multigroupby.singlemr
hive.ignore.mapjoin.hint
hive.mapred.mode
hive.exec.parallel
hive.exec.compress.intermediate
hive.exec.compress.output
hive.auto.convert.join
hive.enforce.bucketing
hive.enforce.sorting
hive.cbo.enable
hive.fetch.task.conversion
hive.limit.query.max.table.partition

ACID Properties :

hive.support.concurrency   true (default is false)
hive.enforce.bucketing  true (default is false) (Not required for Hive 2.0)
hive.exec.dynamic.partition.mode    nonstrict (default is strict)


Map Join :
set hive.auto.convert.join=true;
set hive.auto.convert.join.noconditionaltask=true;
set hive.auto.convert.join.noconditionaltask.size=10000000;

set hive.ignore.mapjoin.hint=false;

SMB Map Join :
set hive.auto.convert.sortmerge.join=true;
set hive.optimize.bucketmapjoin = true;
set hive.optimize.bucketmapjoin.sortedmerge = true;
set hive.auto.convert.sortmerge.join.noconditionaltask=true;