cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Help
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

IDENTITY columns generating every other number when merging

Leszek
Contributor

‎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:

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

Labels:
Preview file
2 KB
1 REPLY 1

Dataspeaksss
New Contributor II

‎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.

0 Kudos

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.

If there isn’t a group near you, start one and help create a community that brings people together.

Request a New Group
Announcements