KNOWLEDGE BASE

"Cannot modify <parameter> at runtime" error with Hortonworks Hadoop Hive


Published: 31 May 2017
Last Modified Date: 28 Sep 2017

Issue

When you try to connect to Hortonworks Hadoop Hive with initial or custom SQL, the following error occurs: 
 
Syntax or semantic analysis error thrown in server while executing query. Error message from server: Error while processing statement: Cannot modify execution.engine at runtime. It is not in list of params that are allowed to be modified at runtime.

Environment

  • Tableau Desktop 
  • Tableau Server 
  • Hortonworks Hadoop Hive
  • Hortonworks ODBC Driver for Apache Hive version 2.1.5 or later

Resolution

Whitelist the short parameter name being used (for above error, this would be execution.engine, not hive.execution.engine) in the Hive driver. 
 

Cause

Configuration change in the Hive driver. 
Did this article resolve the issue?