Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-13-2024 06:53 AM
Same problem with Athena and TABLE_REDIRECTION_ERROR
Works on runtime 13.3 but not on 14.3 LTS.
CREATE TABLE IF NOT EXISTS tablename (
myid BIGINT GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1),
name string,
age int
)
USING delta
LOCATION 's3://location'
TBLPROPERTIES('delta.feature.allowColumnDefaults' = 'supported',delta.targetFileSize='128mb',delta.autoOptimize.autoCompact=true,delta.autoOptimize.optimizeWrite = true,spark.databricks.delta.schema.autoMerge.enabled = true)
