IDENTITY columns generating every other number when merging
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-16-2022 04:46 AM
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:
Is this expected behavior? Is there any workaround to make number increasing by 1?
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-26-2023 11:02 PM - edited 10-26-2023 11:03 PM
Were you able to resolve it? I'm facing the same issue.

