SiddharthaMurao-7908 avatar image
0 Votes"
SiddharthaMurao-7908 asked PRADEEPCHEEKATLA-MSFT commented

Update Spark SQL special charaters

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.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @SiddharthaMurao-7908,

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?

0 Votes 0 ·

Hello @SiddharthaMurao-7908,

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.

0 Votes 0 ·

0 Answers