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

KNOWLEDGE BASE

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

Published: 31 May 2017
Last Modified Date: 08 Jul 2022

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.

Click here to return to our Support page.

Open a new case

Click here to go to our Support page.

Get detailed answers and how-to step-by-step instructions for your issues and technical questions.

Find and share solutions with our active community through forums, user groups and ideas.

Browse a complete list of product manuals and guides. Available online, offline and PDF formats.

Learn how to master Tableau’s products with our on-demand, live or class room training.