Support Questions

Find answers, ask questions, and share your expertise

params that are allowed to be modified at runtime - beeline

avatar
Expert Contributor

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.

1 REPLY 1

avatar
Expert Contributor

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.