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.
Input Data (1) Error SQLPrepare: [Simba][Hardy] (80) Syntax or semantic analysis error thrown in server while executing query. Error message from server: Error while compiling statement: FAILED: SemanticException [Error 10002]: Line 1:33 Invalid column reference 'a.storenum'
Alternatively, user is getting the following error trying to write to Hadoop Hive with the Output tool:
Output Data (2) Unable to find field "test" in output record.
Simba Hive ODBC Driver with DSN configured
Version 2.6 or greater
In the Visual Query Builder, the column names are prefaced by an 'a':
In the Output tool, you can see the table name precede the column name in the field map:
In the Select In-DB tool, the table name is part of the column name in the format tablename.columname:
The below resolutions apply only if the error appears in the context of this change to the column names.
Simba introduced a new feature in their driver that ensures that all column names are unique when reading in data. This feature is resulting in Alteryx not being able to recognize column names. It is a hidden feature that must be turned off in the Registry if the user can't edit the query to avoid the error.
Solution A: Use Select * [...] in the query
1. In the Alteryx workflow, open the Input tool that is throwing the error. 2. Go to the SQL Editor tab. 3. Remove references to individual columns from the query and use the wildcard asterisk (*) instead to read in all columns in the table.
Solution B: Add a Server Side Property to the DSN
Note: This is not a global setting, it is set for each DSN, individually.
Go to the Windows ODBC Data Source Administrator
Open the DSN that is being used to connect for editing
Click on Advanced Options
Click on Server Side Properties
Add the property
and set it to false
Hit OK on all the windows to save the changes
Solution C: Add a Server Side Property to the Driver Configuration
Note: This is a global setting, it will apply to ALL DSNs using the driver.
Browse to the install folder for the Simba Hive ODBC driver. The default location is C:\Program Files\Simba Hive ODBC Driver
Open the /lib folder inside the install folder
Double-click DriverConfiguration64.exe to open the driver configuration dialog