hiverc

-- set hive.exec.reducers.bytes.per.reducer=<number>
-- set hive.exec.reducers.max=<number>
-- set mapred.reduce.tasks=<number>

set hive.exec.dynamic.partition.mode=nonstrict;
set hive.optimize.ppd=true;

add jar /opt/mapr/hadoop/hadoop-0.20.2/contrib/streaming/hadoop-0.20.2-dev-streaming.jar;
add jar /opt/jars/parquet-hive-bundle-1.2.10.jar;

set mapred.job.priority=VERY_LOW;
set hive.cli.print.header=true;

-- see https://cwiki.apache.org/confluence/display/Hive/Vectorized+Query+Execution
set hive.vectorized.execution.enabled = true;
set hive.enforce.sorting = true;
set hive.enforce.bucketing = true;


-- and perhaps set these, per
-- http://answers.mapr.com/questions/2913/if-maprfs-compresses-files-transparently-is-it-unnecessary-to-compress-output-in-hive
-- set mapred.output.compress=true;
-- set mapred.compress.map.output=true;
-- SET mapred.map.output.compression.codec=org.apache.hadoop.io.compress.SnappyCodec;
-- SET mapred.output.compression.codec=org.apache.hadoop.io.compress.SnappyCodec;
-- SET mapred.output.compression.type=BLOCK;
-- SET mapreduce.maprfs.use.compression=true;
-- SET hive.exec.compress.output=true;