This is my old ddl This table has history data.
CREATE TABLE orc_table (
first_name STRING,
address array<struct<num:int,p_num:int,STREEt:string>>
)
STORED AS ORC;
after we altered STREEt to street (camel case changes) in the array of struct column address,all the history data gets nullified for the column.
** Alter command used **
ALTER TABLE orc_table CHANGE COLUMN address address array<struct<num:int,p_num:int,street:string>>
Is it possible to make orc tables metadata as case insensitive or any way to fix history and current data?