I am new to Avro and any input on below clarifications is appreciated.
I got clarifications While reading Article on Avro with Hive.
Article Link
1)we are not mentioning .avsc schema file here.I read in some other article where they will be mentioning .avsc file in Table properties.Is it mandatory or optional?
hive> CREATE EXTERNAL TABLE user_profile (id BIGINT, name STRING, bday STRING) STORED AS avro;
2)For the below change do I need to recreate the .avsc file each and every time?Is it one-time activity or for every step like a,b,c i need to recreate the .avsc file?
You can see that a number of operations can be allowed as a simple requirement change:
a)Adding a new column to a table (the “country” column in the 2nd file)
b)Dropping a column from a table (the “id” column in the 3nd file)
b)Renaming a column (the “birthday” column in the 4th file)