This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Product - Simba Hive ODBC Driver ODBC (32- and 64-bit)
The following error can occur when writing out to a Hive table, using the Output tool :
or In-DB tools such as Data Stream In or Write Data In-DB :
Error: Data Stream In (6): DataWrap2ODBC::SendBatch: [Simba][Hardy] (80) Syntax or semantic analysis error thrown in server while executing query. Error message from server: Error while compiling statement: FAILED: ParseException line 1:74 cannot recognize input near '?' ')' '' in expression specification Insert into `AYX200409de77bf5e5757b198bf03327808bf6f9f`(`fields`) Values (?)
Some client application using an ODBC DSN for Hive may be "Hive-aware" and emit queries written in HiveQL (SQL-like interface to access structured data). It is not the case of Alteryx Designer. It will expect the ODBC Driver to perform the query transformation.
The error will be encountered if the DSN is configured with the expectation that Designer will send queries that follow the HiveQL specifics.
Solving this issue consists in changing the DSN's configuration so that the driver transforms the queries emitted by Alteryx Designer and converts them into an equivalent form in HiveQL.
The steps are the below :
Open ODBC Data Source Administrator on the machine
Locate the DSN (it can be a User DSN or System DSN) and select "Configure"
On the new window, select "Advanced Options..."
Uncheck the "Use Native Query" box
Save the changes
Run the workflow to confirm that the issue is solved