Forum Discussion
anterior
Oct 02, 2023Copper Contributor
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