[ https://issues.apache.org/jira/browse/HIVE-13999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15335229#comment-15335229 ]
gaojun commented on HIVE-13999: ------------------------------- @Sergio Peña Many Thanks ! I solved the issue by set hive.security.authorization.sqlstd.confwhitelist.append=|mapreduce.job.*|mapreduce.map.*|mapreduce.reduce.* . >From the document I know hs2 limits set parameters when security is enabled . >By default mapreduce.job.name is not in param >hive.security.authorization.sqlstd.confwhitelist . https://cwiki.apache.org/confluence/display/Hive/SQL+Standard+Based+Hive+Authorization > Cannot modify mapreduce.job.name at runtime when hive security authorization > is enabled > ---------------------------------------------------------------------------------------- > > Key: HIVE-13999 > URL: https://issues.apache.org/jira/browse/HIVE-13999 > Project: Hive > Issue Type: Bug > Components: Authorization, Beeline > Affects Versions: 0.14.0 > Environment: centos 6.5 > ranger 0.4.0 > hive 0.14.0 > Reporter: gaojun > Labels: security > > Cannot set mapreduce.job.name at runtime when hive security authorization is > enabled ! > I use ranger and enabled hiveserver2 and hivecli security authorization. > I use hivecli and I can set mapreduce.job.name property by 'set > mapreduce.job.name=job1 ' . > I use beeline and connect the security hiveserver2 , then I run 'set > mapreduce.job.name=job1 ' but it is wrong , I get the exception like this : > Error: Error while processing statement: Cannot modify mapreduce.job.name at > runtime. It is not in list of params that are allowed to be modified at > runtime (state=42000,code=1). > so what`s wrong with it? -- This message was sent by Atlassian JIRA (v6.3.4#6332)