azure - U-SQL error while table rebuild -
error occurs when call alter table rebuild in 1 stored procedure , try select data in simultaneously. create procedure if not exists rebuildcontent() begin insert dbo.log (date, message) values ( datetime.utcnow, "starting content table rebuilding ..." ); alter table dbo.content rebuild; alter table dbo.contentcrc rebuild; insert dbo.log (date, message) values ( datetime.utcnow, "completed content table rebuilding ..." ); end; are there solutions avoid it? thank in advance! you running race condition between rebuilding , reading same table. rebuilding table creates new file compacting files got created insertion. unfortunately right now, once rebuild deleting old file, lose access old version , error message. we aware of issue , have created work item preserve access old file started queries (providing snapshot semantics). however, not have eta @ moment. thus until then, please schedule rebuild , read jobs without overlaps. note: c...
