topic Re: Adding column as StructType in Data Engineering

Adding column as StructType

Gilg — Fri, 31 Mar 2023 06:24:03 GMT

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,

Re: Adding column as StructType

Anonymous — Sun, 02 Apr 2023 16:19:07 GMT

@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.

Re: Adding column as StructType

sandeepmankikar — Fri, 16 May 2025 04:04:09 GMT

To add a STRUCT column to an existing table, use the correct syntax without $ symbols, such as ALTER TABLE table_clone ADD COLUMNS (col_name1 STRUCT<type: STRING, values: ARRAY<STRING>>)