params that are allowed to be modified at runtime - beeline

[#1]

Hi,

The below properties are working in hive shell but not in beeline and getting

Error: Error while processing statement: Cannot modify mapred.compress.map.output at runtime. It is not in list of params that are allowed to be modified at runtime

SET mapred.output.compress

SET mapred.compress.map.output

How to whitelist these properties for beeline.

Thank you.

[#2]

Go to

Ambari -> Hive -> Configs -> Advanced -> Custom hive-site

Click Add Property

Insert followings into the opening window:

hive.security.authorization.sqlstd.confwhitelist.append=mapred.compress.map.output

After saving, restart hive services. Then connect to beeline and set your parameter.

I experienced a similar problem for mapreduce.job.reduces parameter and it worked.