How to change the column type in Hue of a hive table?

Question

I'm trying to create a hive table manually, however I want to change the column type of "order" into an array with a structure (orderline).

My current table is as follows:

I want to have the same type as orders:

How can I change the type of a column?

Answer 1

I figured it out, could just edit the types through the hive query editor, with simple SQL statements like:

ALTER TABLE person CHANGE orders order ARRAY<STRUCT<status:string,creation_date:string,orderlines:array<STRUCT<depature_date:string,return_date : string, travel_days : int, creation_date: string,
                   price : int, booking_class : string, airline_code : string,
                   psg_gender : string, psg_lastname : string, psg_firstname : string, psg_dob : string>>>>

Result: