I have 2 years worth of data in a Hive ORC table. One of the column in the table is a struct type.
Existing - STRUCT<X:DOUBLE, Y:DOUBLE>>
I want to add new field Z to the Struct
New - STRUCT<X:DOUBLE, Y:DOUBLE, Z:DOUBLE>>
How can I alter the HIVE table to make it backward compatible. On-going data will comply to the new Schema.