ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

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.