topic Primary key and not null in Get Started Discussions

Primary key and not null

Shree23 — Tue, 07 Nov 2023 09:37:36 GMT

Hi Expert,

how we can get primary key and not null and cluster index in table creation

%Sql

create table table1 values (id int , product char)

expected output

create table table1 values (id int not null primary key, product char) and cluster index

Shree23 — Tue, 07 Nov 2023 20:29:33 GMT

it is giving error message Dataanalysisexception:table constraint are only supported in unity catalog

Shree23 — Tue, 07 Nov 2023 21:11:17 GMT

Also tried this steps but still not working ...

Shree23 — Wed, 08 Nov 2023 20:24:28 GMT

Suggestion please

Shree23 — Fri, 10 Nov 2023 13:13:21 GMT

sugggestion pls