Avro data file is not loading in hive

hive

#1

sqoop import
–connect jdbc:mysql://ms.itversity.com:3306/retail_db
–username retail_user
–password itversity
–delete-target-dir
–target-dir /user/hi2rajnish/hive/orders
–table orders
–num-mappers 1
–as-avrodatafile

created orders.avsc using command after downloading avro file on localfrom hadoop

avro-tools getschema part-m-00000.avro > orders.avsc

ran below command to create hive table

CREATE external TABLE hi2rajnish.orders_sq
ROW FORMAT SERDE ‘org.apache.hadoop.hive.serde2.avro.AvroSerDe’
STORED AS INPUTFORMAT ‘org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat’
OUTPUTFORMAT ‘org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat’
LOCATION ‘hdfs://nn01.itversity.com:8020/user/hi2rajnish/hive/orders’
TBLPROPERTIES (‘avro.schema.url’=‘hdfs://nn01.itversity.com:8020/user/hi2rajnish/hive/orders/orders.avsc’);

select failing with below error
Failed with exception java.io.IOException:java.io.IOException: Not a data file.

Tried running command load data , even then select is failing
LOAD DATA INPATH ‘hdfs://nn01.itversity.com:8020/user/hi2rajnish/hive/orders/part-m-00000.avro’ INTO TABLE hi2rajnish.orders_sq;