Hi All, We have a dataset in Avro format with schema inside each Avro file. I want to build Hive table on top of these files, I got the below recommendation from an old question asked here in the community: CREATE EXTERNAL TABLE sampe_table STORED AS AVRO LOCATION 'hdfs:///user/hive/; But whenever I try it I get always the error: Any Suggestions? or do you know any online tool that can split Schema from the file? java.lang.Exception: java.sql.SQLException: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. java.lang.RuntimeException: MetaException(message:org.apache.hadoop.hive.serde2.SerDeException Encountered AvroSerdeException determining schema. Returning signal schema to indicate problem: Neither avro.schema.literal nor avro.schema.url specified, can't determine table schema) ... View more

I have taken the Hortonworks HPCPD exam on 11/06/2017 and till the moment, I got nothing from Hortonworks, and I sent 2 emails after the 5 business days with no response. I want also to complain bunch of issues I faced during the exam, although my internet connection was perfect. I lost more than 45 minutes in resolving issues with moving the opened windows, I was not able to minimize them or even close, the copy paste, works sometimes and sometimes not. The Proctor gave me 40 minutes added to the exam time because of these issues until we resolved them, but I was already lost my nerve and my concentration. I want to file my complaint from the examination process efficiency. Now, I have plans to take other exams depending on my results in this exam, and Hortonworks is really messing up my plans. What should I do? ... View more