Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-01-2023 09:23 AM
I am trying to use the following code to create a deltatable
%sql
CREATE TABLE rectangles(a INT, b INT, area INT GENERATED ALWAYS AS IDENTITY (START WITH 1, STEP BY 1))
I don't know why but I am always getting the ParseException error.
I tried all other combinations as well such as - CREATE TABLE rectangles(a INT, b INT, area INT GENERATED ALWAYS AS IDENTITY (1, 1)), etc
Error:
ParseException:
extraneous input 'IDENTITY' expecting '('(line 1, pos 67)
Labels:
- Labels:
-
Azure databricks
-
Databricks SQL
-
SQL