Update Spark SQL special charaters

Question

Update Spark SQL special charaters

RobStelter12 6

I am trying to update a delta table column in azure databricks using spark sql. It throws an error, as the column I am trying to update is an array element and so has special characters in its name.
Example. Column to be updates looks like - arrayname[0].ColumnName

So my update script look like:

Update Tablename
Set arrayname[0].ColumnName='a'

Any help is appreicated.

PRADEEPCHEEKATLA 91,866 Reputation points

2021-04-08T09:36:57.147+00:00

Hello @RobStelter12 ,

Welcome to the Microsoft Q&A platform.

Could you please share the complete error message which you are experiencing along with the screenshot of the error message?
PRADEEPCHEEKATLA 91,866 Reputation points

2021-04-09T09:31:46.177+00:00

Hello @RobStelter12 ,

Just checking in if you have had a chance to see the previous response. We need the following information to understand/investigate this issue further.