cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
cancel
Showing results for 
Search instead for 
Did you mean: 

Undescriptive error when trying to insert overwrite into a table

cmilligan
Contributor II

I have a query that I'm trying to insert overwrite into a table. In an effort to try and speed up the query I added a range join hint. After adding it I started getting the error below.Screenshot_20230118_104626I can get around this though by creating a temporary view of the same query and caching that temporary view. It will then allow me to insert overwrite into the table.

3 REPLIES 3

Ajay-Pandey
Esteemed Contributor III

Could you please check for the datatype of your source and target table.

There might be mismatch between both.

Both are the same

jose_gonzalez
Moderator
Moderator

Could you share your code and the full error stack trace please? Check the driver logs for the full stack trace.

Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.