Getting issue while running sqoop import command

Am running sqoop import command but getting following issue
command:
hive> create external table departments_avro
> row format serde ‘org.apache.hadoop.hive.serde2.avro.AvroSerDe’
> stored as avro
> location ‘/user/jayantm1988/departments_avro’
> tblproperties (‘avro.schema.url’=‘hdfs://gw01.itversity.com/home/jayantm1988/departments.avsc’);

Error: Unable to read schema from given path: hdfs://gw01.itversity.com/home/jayantm1988/departments.avsc).
But avsc file is there .

for more info please look at snapshot .

i thik the schema path is not your hdfs path but local.
move the schema to hdfs path and try once.

It should be in hdfs ?

yes, external table path and schema should be in HDFS.