cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
cancel
Showing results for 
Search instead for 
Did you mean: 

Databricks SQL CREATE TABLE ParseException

Sid0610
New Contributor II

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)

1 ACCEPTED SOLUTION
3 REPLIES 3

Priyag1
Honored Contributor II

What is parse exception?

emiratesevisaon
New Contributor II

How can we use SQL for my website emiratesevisaonline.com backend date?

Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.