Forum Discussion

anterior's avatar
anterior
Copper Contributor
Oct 02, 2023

Issue querying delta lake with synapse: The log file points to an non-existing file

I am getting the below error when querying a delta table, the log file has information about a non-existing file. This is due to a manual deletion of that file rather than deleting it from code. Is ther a command that can fix this issue? or something similar to DBCC on sql server? The table is very large, and I don't think re-creating it is an option. 

 

Cannot process the file "https://abcdev01.dfs.core.windows.net/serverdev01/FixDelta/Date=20230726/InstanceName=Mizuho/part-00005-3dcc3b04-f1bc-446a-b9b5-b82956ef300f.c000.snappy.parquet" because it does not exist or you don't have file access rights.

No RepliesBe the first to reply

Resources