Databricks Community

Hongbo · 07-05-2023

Just wonder what is difference if we declare primary key as binary data type vs string data type

Hongbo · 06-30-2023

Databricks support string data type. But I can still create delta table with varchar data type. Just wonder what is different between delta table with string and delta table with varchar:-- delta table with stringCREATE TABLE persons(first_name STRIN...

Hongbo · 06-30-2023

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, ni...

Hongbo · 06-30-2023

I think the issue is Only CHECK constraints are currently supported

Databricks Community

User Stats

User Activity

Primary Key in Databrick Delta table should be declared as Binary data type or string data type

Delta table with Varchar column vs string column

ParseException: mismatched input 'PRIMARY'

Re: ParseException: mismatched input 'PRIMARY'