topic Re: Databricks SQL CREATE TABLE ParseException in Data Engineering

Databricks SQL CREATE TABLE ParseException

Sid0610 — Mon, 01 May 2023 16:23:06 GMT

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)

fabio2352 — Tue, 02 May 2023 20:01:30 GMT

HI, you can see this post. I belive can help you.

Priyag1 — Wed, 03 May 2023 01:45:16 GMT

What is parse exception?

emiratesevisaon — Fri, 05 May 2023 11:52:09 GMT

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