CODEWITHSUNDEEP
pythonsqldatabricks
ApplePie
ApplePie

Reputation: 1185

Databricks not updating in SQL query

I am trying to replace special characters from a table column using SQL a SQL query. However, I get the following error. Can anyone tell me what I did wrong or how I should approach this?

SQL QUERY

UPDATE wine SET description = REPLACE(description, '%', '')

ERROR

error in sql statement: analysisexception: update destination only supports delta sources.

Upvotes: 2

Views: 11278

Answers (2)

Akash Mishra
Akash Mishra

Reputation: 1

CONVERT TO DELTA parquet.s3://path/to/table PARTITIONED BY (column_name INT) ;

--try this for partioned table

Upvotes: 0

Hauke Mallow
Hauke Mallow

Reputation: 3182

Databricks only supports updates for delta (delta lake) tables. The error message indicates that you try the update on a non-delta-table. So you would have to convert your data source to delta. For parquet it is very simple:

CONVERT TO DELTA parquet.`path/to/table` [NO STATISTICS]
[PARTITIONED BY (col_name1 col_type1, col_name2 col_type2, ...)]

See the Documentation for more details.

Upvotes: 2

Related Questions