cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
cancel
Showing results for 
Search instead for 
Did you mean: 

IDENTITY columns generating every other number when merging

Leszek
Contributor

Hi,

I'm doing merge to my Delta Table which has IDENTITY column:

Id BIGINT GENERATED ALWAYS AS IDENTITY

Inserted data has in the id column every other number, like this:

imageIs this expected behavior? Is there any workaround to make number increasing by 1?

1 REPLY 1

Dataspeaksss
New Contributor II

Were you able to resolve it? I'm facing the same issue.

Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.