Error creating table in Hive

Question

When I create a new table in Hive. It gives me the following error: Error: Output Data (4): Unable to find field "field_name" in output record.

If I check the db, the table was created but the data was not written.

I notice that in the db, the columns are named: "table_name.field_name". I'm not sure why the same tool that created the table is not able to add the data into it.

anamaguggis · Accepted Answer

Solution B worked for me from this post: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/Error-quot-SQLPrepare-Simba-Hardy-80-Syntax-or-semantic-analysis/ta-p/659179