topic Re: ParseException: mismatched input 'PRIMARY' in Data Engineering

ParseException: mismatched input 'PRIMARY'

Hongbo — Fri, 30 Jun 2023 13:34:12 GMT

I got parseException issue and I have no idea what cause the problem:

ParseException: mismatched input 'PRIMARY' expecting {')', ',', 'CONSTRAINT'}(line 2, pos 44)

== SQL ==

CREATE TABLE persons(first_name STRING NOT NULL, last_name STRING NOT NULL, nickname STRING, CONSTRAINT person_pk PRIMARY KEY (first_name, last_name)

--------------------------------------------^^^

)

Hongbo — Fri, 30 Jun 2023 17:41:13 GMT

I think the issue is Only CHECK constraints are currently supported

erigaud — Mon, 03 Jul 2023 12:29:18 GMT

You can only declare Primary and foreign keys on fields on Unity Catalog.

You also need Databricks Runtime 11.1+

Otherwise only NOT NULL and CHECK constraints are supported.

BriceBuso — Mon, 03 Jul 2023 12:31:03 GMT

Hello erigaud,

Thanks for your answer, had the same issue.