Error writting In-Database to HIVE

[OJ_TU]

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)

[raviakaram]

Any update on this? I have the similar error

[MichaelF · Accepted solution]

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

[raviakaram]

It worked! thank you MichaelF

[Thomas_simonet]

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...