AssertionError: assertion failed: Unable to delete the record but I am able to select it though

User16826994223
Databricks Employee
Databricks Employee

Is there any reason this command works well:

%sql 
SELECT * FROM  datanase.table WHERE  salary > 1000

returning 2 rows, while the below:

%sql 
delete FROM  datanase.table WHERE  salary > 1000

Error

Error in SQL statement: AssertionError: assertion failed: No plan for DeleteFromTable