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.