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.
Solved! Go to Solution.
Solution B worked for me from this post: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/Error-quot-SQLPrepare-Simba...