Cloudera Community
ankurkapoor_wor
user rank
New Member

Re: Convert Json to Avro processor -- Failed to Pa...

by New Contributor in Support Questions
‎08-21-2019 10:39 AM
‎08-21-2019 10:39 AM
@ankurkapoor_wor Hi, Even I am facing the same issue as @mqureshi. I am trying to fetch data from SQL server in Avro fomat through NiFi and load it to Redshift through copy command. But the generated Avro file is converting the date and timestamp datatypes to string because of which copy command is loading all NULL values in the target table. So I tried to follow your approach, In my case I'm using ExecuteSQLRecord processor to fetch the data from SQL server and writing it to json format and then trying to convert it to Avro format using ConvertJsonToAvro processor but then I am unable to parse Record Schema. Could you please help me also to resolve this issue.  Thanks in advance! Anusha ... View more

Re: Regarding Hortonworks Certified Associate Cert...

by Visitor in Support Questions
‎03-29-2017 11:45 AM
‎03-29-2017 11:45 AM
On this page [1], there is an Exam Objectives link that describes the objectives very well. Focus your study on the content of the Exam Objectives sheet and the linked web pages. Remember, this certification is based on a one day training (HDP OVERVIEW: APACHE HADOOP ESSENTIALS) that is meant as a general introduction to HDP for decision makers, managers, etc. This gives you an idea of the breadth and depth of the exam. Secondly, become familiar with the requirements for actually taking the exam at https://www.examslocal.com/ See their web site for details. You will need to meet the minimum qualifications for web browser, web cam, web connectivity etc - and you will have to pan the camera around the test room so be prepared for that! Ref: 1 https://hortonworks.com/services/training/certification/hca-certification/ ... View more

Re: Regarding Converting XML to Avro schema

by New Member in Support Questions
‎04-26-2018 09:37 AM
‎04-26-2018 09:37 AM
Once you have complex XSD schemas, large volumes of XML files, a streaming requirement, and very large XML files it will quite hard to convert the XML. I have written up a blog post that shows how you can fully automate the conversion of XML to Avro using the Flexter XML converter for XML and JSON. In the post we are using the FpML schema, which is one of the most complex and widely used XML data standard schemas. It also includes an ER diagram and data lineage. ... View more
Contact Me
Online
Offline
Last Visited
‎03-30-2017 01:06 PM
Community Statistics
Member Since ‎02-08-2017 06:26 AM
Last Visited ‎03-30-2017 01:06 PM
Posts 20
Kudos received 1