If you create the external table by reference to the .avsc file (TBLPROPERTIES ( 'avro.schema.url'='hdfs://foo.avsc')) the all you have to do is update that avsc file in a compatible way and Hive should reflect the new schema. I've implemented this pattern in my production system for several months now.
-Aaron From: "Lunagariya, Dhaval" <[email protected]<mailto:[email protected]>> Reply-To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Date: Wednesday, March 23, 2016 at 6:32 AM To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Cc: "'[email protected]<mailto:'[email protected]>'" <[email protected]<mailto:[email protected]>> Subject: Want to Add New Column in Avro Schema Hey folks, I want to add new column in existing Hive Table. We created external hive table with the help of .avsc. Now I want to add new column in that table. How can I do that without disturbing any data present in table? Please Help. Regards, Dhaval
