There is a table with name newtest and the column name is source of type struct<name:string, size:bigint>.

I want to update/modify this struct type to struct<name:string, size:bigint, index:bigint>

How can I alter/modify source column, which is mentioned above.

Tried with the below sql query it is not working:

ALTER TABLE newtest MODIFY COLUMN source STRUCT<name: STRING, size: bigint, index:bigint>