Can a not null constraint be applied on a identity column
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-23-2023 04:20 AM
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-23-2023 06:59 AM
Hi Harish,
Here is the documentation for this issue