@Abdi Ismail some examples here https://community.hortonworks.com/questions/15422/hive-and-avro-schema-defined-in-tblproperties-vs-s.html https://community.hortonworks.com/content/kbentry/972/hive-and-xml-pasring.html https://community.hortonworks.com/questions/4345/querying-json-data-using-hive.html https://community.hortonworks.com/questions/18792/pig-and-json.html ... View more