Evolve an Avro schema by changing JSON files

Dear All,

Hope you are doing great. !

i have tried few sceneros after adding a new fields and assigning a default values. I have few doubts around it

  1. What could be the default values w.r.t datatype ? I think we have to specify while schema evolving

Datatye and Default values
Int = -1 ?
string = BLANK or NULL ?
NULL = NULL
boolean= ?
FLOAT = -1.0 ?
LONG =?
DOUBLE = ?
BYTES = ?

  1. What types of scenarios should i cover to become confident on that topic.?

  2. Lets see i have .avsc schema file and i want to create a hive table by using, how would i specify that schema file in TBLPROPERTIES ? How to specify the NN location and all
    I videos we are following that pattern as it is localhost

CREATE EXTERNAL TABLE customers
STORED AS AVRO
LOCATION 'hdfs:///user/cloudera/sqoop_import/customers’
TBLPROPERTIES (‘avro.schema.url’=‘hdfs://quickstart.cloudera/user/cloudera/avsc_files/sqoop_import_customers.avsc’);

Thank You.