HiveServer2 Connection - Not in list of params that are allowed to be modified

Problem

During creation of a Connection to HiveServer2, an error message is received. 

[admin]  INFO [<timestamp>] [<thread>] (SetJsonOutputCommand.java:29) - Triggering HQL:SET hive.ddl.output.format=json
[admin]  WARN [<timestamp>] [<thread>] (DataStore.java:196) - connection fails: java.lang.RuntimeException: Error while processing statement: Cannot modify hive.ddl.output.format at runtime
. It is not in list of params that are allowed to be modified at runtime
datameer.com.google.common.util.concurrent.UncheckedExecutionException: java.lang.RuntimeException: Error while processing statement: Cannot modify hive.ddl.output.format at runtime. It is not in list of params t
hat are allowed to be modified at runtime

Cause

The issue seems to be mainly caused by permissions set at hive.security.authorization.sqlstd.confwhitelist.append in hive-site.xml. 

The data format to use for DDL output (e.g. DESCRIBE table) is either set to 'text' (for human readable text) or 'json' (for a json object). In this case, the format is set to text per default, where expected data format is JSON. (As of Hive 0.9.0.)

Solution

Whitelist the variable hive.ddl.output.format as per Hive Configuration Variables.