Do you use Alteryx in a language other than English? If so, we want to hear from you! Please help us improve the international experience of our products by participating in this 5 minute survey.

We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

DE29258 : After Upgrade to Simba Hive Driver 2.6.10.1 in-DB error Syntax or semantic analysis error thrown in server while executing query. Error message from server: Error while compiling statement: FAILED: SemanticException

MichaelAd
Alteryx
Alteryx
Created

Environment Details


DE29258 : After Upgrade to Simba Hive Driver 2.6.10.1 in-DB error Syntax or semantic analysis error thrown in server while executing query. Error message from server: Error while compiling statement: FAILED: SemanticException

  • Designer
    • All
  • Database
    • Apache Hive 3
    • Simba Hive Driver 2.6.10.1
When connecting to Hive Database using Simba 2.6.10 using in-DB tools, the option Use Native Query has to be enabled.
If it is not enabled, the below error will occur. Prior to the upgrade, Use Native Query  was disabled and worked fine.
 
Error message from server: Error while compiling statement: FAILED: SemanticException


Cause


The behaviour is currently known as Product Defect DE29258.



Resolution


Currently, the only workaround for this is to enable Use Native Query for in-DB workflows and to disable it for regular workflows without in-DB tools.
For this, two DSNs should be set up.