Adding column as StructType

[Gilg]

Hi Team,

Just wondering, how can I add a column to an existing table.

I'd tried the below script but giving me an error:

ParseException:

[PARSE_SYNTAX_ERROR] Syntax error at or near '<'(line 1, pos 121)

ALTER TABLE table_clone ADD COLUMNS col_name1 STRUCT<

-------------------------------------------------------------------------------------------------------------------------^^^

$type:STRING,

$values:ARRAY<STRING>

>

ALTER TABLE table_clone 
ADD COLUMNS col_name1 STRUCT<
        $type: STRING,
        $values: ARRAY<STRING>
    >

Cheers,

G

[Anonymous]

@Gil Gonong​ :

In Databricks, you can add a column to an existing table using the ALTER TABLE statement in SQL. Here is an example:

ALTER TABLE table_clone ADD COLUMN col_name1 STRUCT<
    type: STRING,
    values: ARRAY<STRING>
>

Note that you need to have the necessary privileges to modify the table. If you are not the owner of the table, you need to have been granted the ALTER privilege by the owner or an administrator.