Support Questions
Find answers, ask questions, and share your expertise

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

@Vinitkumar Pandey

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

New Contributor

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

Contributor

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

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

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.

New Contributor

@Sriram,

Can you attach screen shot of error scenario ?