Forum Discussion
Delete on warehouse table timed out
Hi,
i'm building a little warehouse and created some staging tables. Before loading data into these tables, i want to delete the table data.
1. Delete from [testtable]
2. Insert into [testtable] select * from [basetable]
The statements are executes via script activity in a data pipeline
In most cases the statements ran in timeout error "Operation on target delete destination table failed: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding."
A select on DMV sys.dm_exec_requests shows wait type "EDC_EXEC" (?) , also after getting the timeout error...
4 Replies
- AnonymousNot applicable
Hi cw88
It seems like you are experiencing a timeout error while trying to delete data from a table before loading new data into it. This error can occur if the table is too large or if there are too many rows to delete.
How do you run the queries here?
If you use any client tool, increasing the timeout helps?
or,
I think providing a statement Id or / Ids might help
Regards
Geetha
- cw88
Helper IV
Hi,
truncate is not supported in warehouse, or is there any news?
- AnonymousNot applicable
My bad I have updated my comment if you can help to provide more info.
Regards
Geetha
- mikeburek
Advocate III
Just to close out this question if anyone lands on it, the TRUNCATE command was added to the Fabric Warehouse in Aug 2024:
- https://www.reddit.com/r/MicrosoftFabric/comments/1er251b/fabric_warehouse_now_supports_truncate/
- https://www.youtube.com/watch?v=NB_iZ0sqgn0
- https://www.c-sharpcorner.com/article/new-in-fabric-warehouse-sql-truncate/