HADOOP - Import external Table to Hive

CREATE EXTERNAL TABLE categories STORED AS AVRO

LOCATION 'hdfs:///user/hive/warehouse/categories'

TBLPROPERTIES ('avro.schema.url'='hdfs://quickstart/user/examples/sqoop_import_categories.avsc');