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

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


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.


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


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


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