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.
User is attempting to read data from Hadoop Hive and getting the following error:
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 attempting to write to Hadoop Hive and getting the following error:
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:
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
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
Note This is not a global setting, it is set for each DSN, individually.