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?
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>>>>