How can we improve Microsoft Azure Data Lake?

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.

19 votes
Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)

We’ll send you updates on this idea

databash shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

2 comments

Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)
Submitting...
  • Michael Rys commented  ·   ·  Flag as inappropriate

    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.

Feedback and Knowledge Base