Forum Discussion
aarongiust
2 years agoFrequent Visitor
Cannot delete from lakehouse table
I am aware of the fact that you have to use a notebook to delete rows from a lakehouse table but every method I have used gives me the same error. I have tried Spark SQL and two methods using Python ...
govindarajan_d
Super User
2 years agoHi aarongiust ,
Can you try the below on your table and then see if it works out?
ALTER TABLE <table-identifier> SET TBLPROPERTIES('delta.minReaderVersion' = '1', 'delta.minWriterVersion' = '2')
aarongiust
2 years agoFrequent Visitor
I get the same error when I run the ALTER statement.
- Anonymous2 years agoNot applicable
Hi aarongiust ,
Apologies for the issue you are facing, it require a deeper investigation from our engineering team about your workspace and the logic behind it to properly understand what might be happening.
Please go ahead and raise a support ticket to reach our support team: support-ticket
Please provide the ticket number here as we can keep an eye on it.- aarongiust2 years agoFrequent Visitor
I submitted ticket #2401030040011861.