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

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