Hi, I'm trying to create a delta table locally containing a generated column as follows:

CREATE TABLE IF NOT EXISTS test_schema.test_table

(

timestamp TIMESTAMP,

year INT GENERATED ALWAYS AS (YEAR(timestamp))

)

USING DELTA LOCATION '/tmp/delta-lake/delta-table'

TBLPROPERTIES(delta.minWriterVersion = '4')

I get the following error:

Syntax error at or near 'GENERATED'

The same table I can create in Databricks with the appropriate location, catalog and schema. Is this feature exclusive to Databricks or am I missing something?

Generate is databricks only

Yes, it's only available in Databricks currently, can see some good discussion in the repo here. The feature depends on Spark 3.4 or greater and there's discussions within the Spark community how best to support the underlying capability. Hopefully we'll see it soon🤞