Forum Discussion
Post ProdigyHow do you delete specific rows from a Lakehouse table?
Hi arpost ,
Thanks for using Fabric Community.It is possible to delete rows in a Lakehouse table using Spark-SQL in notebooks. I have created a repro of the scenario. I have attached the screenshots for your reference.
Trying to delete the row which has value of 46134
Query succeeded
After deletion of the row:
You can refer this link for more information: Link1
Hope this helps. Do let us know if you have any further issues. Glad to help.
Hi arpost ,
Thanks for using Fabric Community.
It is possible to delete rows in a Lakehouse table using Spark-SQL in notebooks. I have created a repro of the scenario. I have attached the screenshots for your reference.
Trying to delete the row which has value of 46134
Query succeeded
After deletion of the row:
You can refer this link for more information: Link1
Hope this helps. Do let us know if you have any further issues. Glad to help.
I'm new to SparkSQL. Would anyone happen to know how to acheive the following SQL statement? I get the error: Error: Subqueries are not supported in the DELETE
%%SQL
DELETE FROM <Table>
WHERE [ImportDate] < (SELECT MAX([ImportDate]) FROM <Table>)
Thanks in advance
I'm trying to do something similar too. Did you find a solution? Thanks