The avro schema file needs to be in hdfs and reference could be like below.
TBLPROPERTIES ('avro.schema.url'='hdfs:///user/cloudera/categories.avsc')