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