Adding Assessment Database Parameters

This option allows you to add run time parameters for HIVE.

For example,

SET mapred.reduce.tasks = 1000;SET mapred.child.java.opts = -Xmx2048m; SET SESSION FORCE PARALLEL DML PARALLEL 8; ALTER SESSION FORCE PARALLEL DML PARALLEL 8;

Note:

No space is allowed between ; and SET.