Can a not null constraint be applied on a identity column

harish446 — Mon, 23 Oct 2023 11:20:34 GMT

I had a table creation script as follows for example:

CREATE TABLE default.test2

( id BIGINT GENERATED BY DEFAULT AS IDENTITY(),

name String)

using delta

location "/mnt/datalake/xxxx"

What are the possible ways to apply not null constraint on the existing delta table on id column

Re: Can a not null constraint be applied on a identity column

Krishnamatta — Mon, 23 Oct 2023 13:59:23 GMT

Hi Harish,

Here is the documentation for this issue