https://community.cloudera.com/t5/Support-Questions/Best-Practice-JSON-to-Avro-data-type-preserving/m-p/148385#M110911 <P>Hi <A rel="user" href="https://community.cloudera.com/users/10529/akeezhadath.html" nodeid="10529">@Arun A K</A></P><P>This is a known issue where the datatypes are not preserved. <A href="https://issues.apache.org/jira/browse/NIFI-2624" target="_blank">https://issues.apache.org/jira/browse/NIFI-2624</A> which talks about Oracle/SQL datatypes not being preserved. You should also check out <A href="https://gist.github.com/ijokarumawak/69b29fa7b11c2ada656823db614af373" target="_blank">https://gist.github.com/ijokarumawak/69b29fa7b11c2ada656823db614af373</A></P><P>As mentioned by <A rel="user" href="https://community.cloudera.com/users/10180/knarayanan.html" nodeid="10180">@Karthik Narayanan</A>, best approach would be to use Record Oriented processors. </P> Thu, 05 Oct 2017 22:32:50 GMT ArtiW 2017-10-05T22:32:50Z