I encountered an error when trying to create a SOURCE with UPSERT_AVRO in a database system. The error message mentions specifying a single primary key column or leaving the columns and primary key fields empty. How can I resolve this error and successfully create the SOURCE with UPSERT_AVRO?
Bui Tien
Asked on May 07, 2023
upsert='true'
option in the WITH
clause when creating the SOURCE with UPSERT_AVRO.CREATE SOURCE IF NOT EXISTS source_abc (a int primary key)
.CREATE TABLE
instead of CREATE SOURCE
for defining the primary key.