Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Cannot modify mapreduce.framework.name at runtime

Highlighted

Cannot modify mapreduce.framework.name at runtime

Explorer

Hi,

I am trying to connect to Hive using Talend , but getting below error :-

Cannot modify mapreduce.framework.name at runtime.

[FATAL]: dev_workspace.job_prod_fmly_d_0_1.job_PROD_FMLY_D - tHiveConnection_1 Error while processing statement: Cannot modify mapreduce.framework.name at runtime. It is not in list of params that are allowed to be modified at runtime

Please suggest action needed here.

6 REPLIES 6
Highlighted

Re: Cannot modify mapreduce.framework.name at runtime

@Vinitkumar Pandey

Are you using any Ranger or Standard SQL Authorizations? If yes, they are not allowing some properties to be changes at runtime.

Highlighted

Re: Cannot modify mapreduce.framework.name at runtime

New Contributor

You can modify by setting this property value "hive.security.authorization.sqlstd.confwhitelist.append"

Highlighted

Re: Cannot modify mapreduce.framework.name at runtime

Contributor

@D Gaur what value do we need to set to the property hive.security.authorization.sqlstd.conf.whitelist.append?

Highlighted

Re: Cannot modify mapreduce.framework.name at runtime

New Contributor

Hey @Sriram,

You can set property value which you want to modify at run time in hiveserver2-site.xml.

e.g if you want to modify hive driver name and connection url at run time then you can set like

<property>

<name>hive.security.authorization.sqlstd.confwhitelist.append</name>

<value>driver|url</value>

</property>

Thanks

Highlighted

Re: Cannot modify mapreduce.framework.name at runtime

Contributor

@D Gaur ....Sorry to bother you and I am novice in this terminology and could you please provide me an example with little bit more explanation around it, it is really appreciated.

Also, as a work around I disabled HS2 authorization using Ambari and it has helped me to get rid of the issue.

But would like to know how to give values and I am novice over here.

Highlighted

Re: Cannot modify mapreduce.framework.name at runtime

New Contributor

@Sriram,

Can you attach screen shot of error scenario ?

Don't have an account?
Coming from Hortonworks? Activate your account here