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.

Unable to modify hive.in.test parameter during runtime

Highlighted

Unable to modify hive.in.test parameter during runtime

New Contributor

I have a HDP 2.3 cluster, setup using Ambari 2.2.1. I need to modify "hive.in.test" parameter at runtime. When I try to set this from Hive CLI I'm getting the below exception:

Query returned non-zero code: 1, cause: Cannot modify hive.in.test at runtime. It is in the list of parameters that can't be modified at runtime

I have added this parameter to "hive.security.authorization.sqlstd.confwhitelist.append" to custom hive-site.xml and hiveserver2-site.xml and have restarted Hive-server2. I'm still facing the same issue. Please suggest a solution.