USQL catalog - support IDENTITY or SEQUENCE
In USQL managed table, we need column IDENTITY property similar to T-SQL or USQL catalog level SEQUENCE object.
CREATE TABLE X
ID Int64 IDENTITY(1,1)
As a workaround we can use ROW_NUMBER(). But something like IDENTITY or SEQUENCE would mean we don't have to work out the next value.
Ronnie Overby commented
Since the tables need a clustered index, conventional guids aren't ideal.
Michael Rys commented
One of the problems in scale-out systems is to provide a scalable IDENTITY function to avoid the need to synchronize or serialize. One way to work around it is with ROW_NUMBER(), another is to use GUIDs instead of an integer value, since GUID creation does not need a global coordination.