0

Duplicate records are ingested into Azure delta tables when using BY DEFAULT parameter.

I have followed below steps.

1)Created table with identity column GENERATED BY DEFAULT
2)Inserted 2 records with id, 1 and 2
3)When inserted third row without id, it inserted id as 1 creating duplicates A similar issue has been reported here

dileepVikram
  • 890
  • 4
  • 14
  • 30

1 Answers1

0

An alter command will solve this.Use below command to sync identity column

alter table table_name change column col_name sync identity

dileepVikram
  • 890
  • 4
  • 14
  • 30