cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
cancel
Showing results for 
Search instead for 
Did you mean: 

Cannot create delta live table

rocky5
New Contributor III

I created a simple definition of delta live table smth like:

CREATE OR REFRESH STREAMING LIVE TABLE customers_silver

AS SELECT * FROM STREAM(LIVE.customers_bronze)

But I am getting an error when running a pipeline:

com.databricks.sql.transaction.tahoe.DeltaColumnMappingUnsupportedException: Changing column mapping mode from 'name' to 'none' is not supported.

When I remove that notebook (with above definition), pipeline runs correctly for 3 upcoming kafka streams (which I would like to use in above query definition). Do you know what might cause that error?

1 REPLY 1

jose_gonzalez
Moderator
Moderator

You might need to execute the following on your tables to avoid this error message

ALTER TABLE <table_name> SET TBLPROPERTIES (

'delta.minReaderVersion' = '2',

'delta.minWriterVersion' = '5',

'delta.columnMapping.mode' = 'name'

)

Docs https://docs.databricks.com/delta/delta-column-mapping.html

Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.