Hortonworks.com
  • Explore
    • All Tags
    • All Questions
    • All Repos
    • All SKB
    • All Articles
    • All Ideas
    • All Users
    • All Badges
    • Leaderboard
  • Create
    • Ask a question
    • Add Repo
    • Create Article
    • Post Idea
  • Tracks
    • All Tracks
    • Community Help
    • Cloud & Operations
    • CyberSecurity
    • Data Ingestion & Streaming
    • Data Processing
    • Data Science & Advanced Analytics
    • Design & Architecture
    • Governance & Lifecycle
    • Hadoop Core
    • Sandbox & Learning
    • Security
    • Solutions
  • Login
HCC Hortonworks Community Connection
  • Home /
  • Solutions /
  • Home /
  • Solutions /
avatar image

"Error while processing statement: Cannot modify hive.mapred.supports.subdirectories at runtime" after upgrading HDP 2.4.2 to HDP 2.5.3

Vani created · Dec 05, 2017 at 11:30 AM
0

SupportKB

Problem Description:
After upgrading from HDP 2.4.2 to HDP 2.5.3, when setting the hive.mapred.supports.subdirectories property from Hive beeline, the following error is displayed:
Error: Error while processing statement: Cannot modify hive.mapred.supports.subdirectories at runtime. 
It is not in list of params that are allowed to be modified at runtime (state=42000,code=1)

Cause:
This issue is happening because of  for a Bug ( HIVE-11582), which resulted in the removal of subdirectory parameter by default in hive.security.authorization.sqlstd.confwhitelist. 
 
Solution:
To resolve this issue, edit or add hive.security.authorization.sqlstd.confwhitelist.append property in Custom hive-site from Ambari:
hive.security.authorization.sqlstd.confwhitelist.append=hive\.mapred\.supports\.subdirectories

About:
This article created by Hortonworks Support (Article: 000005893) on 2017-07-26 18:02
OS: Linux
Type: Executing_Jobs
Version: 2.6.1, 2.5.5, 2.5.3, 2.6, 2.5
Support ID: 000005893
thub.nodes.view.add-new-comment
solutionhwsupportHive
Add comment
10 |6000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Follow

Follow

avatar image avatar image avatar image avatar image avatar image
avatar image avatar image avatar image avatar image avatar image
avatar image avatar image avatar image avatar image avatar image
avatar image avatar image avatar image avatar image avatar image
avatar image

Related posts

How to enable debug HIVE CLI logging?

Hive table displays junk characters when UTF-8 data is inserted to the table

Special characters and blank spaces inserted in ORC table when getting data from DB2 using Sqoop into AVRO

Unable to generate hive-log4j.properties file on nodes on which the Hiveserver2 is installed.

Error:"Exception in thread "main" java.lang.StackOverflowError"when running a Hive query with ~5000 filter conditions in SemanticAnalysis

Unable to start HiveServer2 Interactive

ERROR: "Skipping stack-select on MYSQL_SERVER because it does not exist in the stack-select package structure." when installing MySQL("mysql-community-server") from Ambari on CentOS 7.4

ERROR:"Exception in thread "main" java.lang.NoClassDefFoundError" when running a PreUpgradeTool

Error:"Current health = 66.67%, has been below health threshold of 80% for 300 secs"occurs as LLAP application fails when running queries

"Error message: MetaException(message:java.lang.NullPointerException)" when connecting Hive LLAP through ODBC using HTTP

This website uses cookies for analytics, personalisation and advertising. To learn more or change your cookie settings, please read our Cookie Policy. By continuing to browse, you agree to our use of cookies.

HCC Guidelines | HCC FAQs | HCC Privacy Policy | Privacy Policy | Terms of Service

© 2011-2019 Hortonworks Inc. All Rights Reserved.

Hadoop, Falcon, Atlas, Sqoop, Flume, Kafka, Pig, Hive, HBase, Accumulo, Storm, Solr, Spark, Ranger, Knox, Ambari, ZooKeeper, Oozie and the Hadoop elephant logo are trademarks of the Apache Software Foundation.

  • Anonymous
  • Login
  • Create
  • Ask a question
  • Add Repo
  • Create SupportKB
  • Create Article
  • Post Idea
  • Tracks
  • Community Help
  • Cloud & Operations
  • CyberSecurity
  • Data Ingestion & Streaming
  • Data Processing
  • Data Science & Advanced Analytics
  • Design & Architecture
  • Governance & Lifecycle
  • Hadoop Core
  • Sandbox & Learning
  • Security
  • Solutions
  • Explore
  • All Tags
  • All Questions
  • All Repos
  • All SKB
  • All Articles
  • All Ideas
  • All Users
  • Leaderboard
  • All Badges