Hey guys,
I have a problem with a table created in iceberg.
Using the create command, even defining a column as the primary key, I can still insert duplicate records.
i am using the following structure.
create table S3_Mundiale.“dremio-iceberg”.Preparation.saas.tickets.test
(
id int,
created_at TIMESTAMP
);
ALTER table S3_Mundiale.“dremio-iceberg”.Preparation.saas.tickets.test
add PRIMARY KEY (id)
;
insert into S3_Mundiale.“dremio-iceberg”.Preparation.saas.tickets.test
values (99, ‘2024-04-01 00:00:00’), (99, ‘2024-04-01 00:00:00’);
;
select * FROM S3_Mundiale.“dremio-iceberg”.Preparation.saas.tickets.test
Note that it is possible to insert duplicate records even with the primary key. Is it possible that this won’t happen?