Failed with exception java.io.IOException:java.io.IOException: Not a data file

Big Data Apache Hive
#1

Hi All
Kindly help in fixing the issue , not sure why i am getting this error.
hive>
>
>
> create external table orders_avro
> 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 “/user/cloudera/avro_tables/orders”
> tblproperties(“avro.schema.url” = “/user/cloudera/avro_tables/orders/orders.avsc”);
OK
Time taken: 0.443 seconds
hive> select * from orders_avro limit 10 ;
OK
Failed with exception java.io.IOException:java.io.IOException: Not a data file.
Time taken: 0.379 seconds

Thanks
sPradeep

#2

Where are you running this? Cloudera quickstart VM?

#3

Yes Sir , i am running it on Quickstart VM Cloudera

#4

Hi Sir ,
I have now understand why this error was occuring , i was mistakenly adding order.avsc file in the same folder in which avro data files are present. Now i have placed orders.avsc file in other hdfs location and it worked

Thanks for the support