With regard to adding column to Hive table you can add a column that will be created as NULL but you cannot set its value to non null
hive> alter table dummy2 add columns (new_col varchar(30)); OK Time taken: 1.171 seconds hive> desc dummy2; OK id int clustered int scattered int randomised int random_string varchar(50) small_vc varchar(10) padding varchar(10) *new_col varchar(30)*Time taken: 0.046 seconds, Fetched: 8 row(s) hive> update dummy2 set new_col = 'abc'; FAILED: SemanticException [Error 10122]: Bucketized tables do not support INSERT INTO: Table: test.dummy2 Check the discussion in Hive user mailing list here <http://mail-archives.apache.org/mod_mbox/hive-user/201512.mbox/%3cd290a400.39823%25ekoif...@hortonworks.com%3E> Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* http://talebzadehmich.wordpress.com On 8 April 2016 at 20:49, Joanne Chan <joannec...@gmail.com> wrote: > > How does schema evolution work for orc table in hive 0.14? > > Does it support add column at the end of the row only? > > What else is supported? > >
