community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Error writting In-Database to HIVE

Highlighted
Alteryx Partner
Hello, Having trouble writing a table using the “Write Date In-DB” tool. The workflow errors out with the below message. There is NO field called ‘HRFA’ that is being written into the Hive Db as suggested in the error message. Error: Write Data In-DB (25): Error running PreSQL on "NoTable": [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 10004]: Line 1:5671 Invalid table alias or column reference 'HRFA': (possible column names are: accountname, accountowner, active_year, billing_group, bur_num, char_prfl_grp_id, current_period, custid, customer_type, division_name, first_five_characteristics, industry, invoiceid, month_name, month_name_short, month_num, orderid, orgid, platform, postingcode, pricinggroup, product, productcode, productdescription, productname, quarter, region, reportinggroup, reseller_flag, revenue, salesgroup, salesteam, second_five_characteristics, servicecategorycode, servicecategoryname, sizeband, source, subscriber_id, subscriber_name, territory_code, territory_name, tier, ttm, ultcustid, ultcustid_name, units, vertical, year, year_month_number, ytd, char)
Meteoroid

Any update on this? I have the similar error

Alteryx
Alteryx

Hi @OJ_TU

 

So this is usually caused because Hive is seeing HRFA as a column rather than a value (which I assume is what you're doing).

 

I would think somewhere in your query you're calling HRFA using double quotes. What we've seen is that Hive actually thinks double quotes is another column, which is why you get the error. If you switch it to single quotes, then it should pass through as a value instead of a column name.

 

Cheers,

Mike

Meteoroid

It worked! thank you MichaelF

Thank you, I just had the same issue and your answer saved me !

The data at the end of the workflow did not contain the word in the error message, so I did not see where this came from. My workflow is quite big and in fact the quoted word was in a "where" clause from one of the source table...

Labels