Hive change struct column

[kaducangica]

Hi all,

i have the follwing Hive table on Amazon EMR:

CREATE TABLE equipment_users (
  user_id bigint,
  equipment array<struct<identifier:int,hex:string,battery_level:int>>
);

I want to add a new field in equipment column doing this command:

ALTER TABLE equipment_users CHANGE COLUMN equipment equipment
array<struct<identifier:int,hex:string,battery_level:int,date_installed:timestamp>>;

But it is giving me the error:

Error while processing statement: FAILED: Execution Error, return code 1
from org.apache.hadoop.hive.ql.exec.DDLTask. Unable to alter table. The
following columns have types incompatible with the existing columns in
their respective positions :
equipment


Someone can help me do this? Or perhaps sugest another solution to do this.

Thanks in advance.

Best regards,
Carlos.