https://community.cloudera.com/t5/Support-Questions/Best-Practice-JSON-to-Avro-data-type-preserving/m-p/148375#M110901 <P>My Sample JSON File is </P><PRE>{ "timestamp": "2017-01-26T00:00:00-05:00", "c1": 73.0, "c2": 36.5, "c3": 43.8, "c4": 0.1, "c5": 75.4, "c6": 997.8, "c7": 0.5, "c8": 4.58, "c9": 43.8, "c10": 1.5, "c11": 40.6, "postal_code": "08863", "country": "us" }</PRE> And the Avro schema inferred by NiFi is <PRE>{ "type": "record", "name": "date", "fields": [ { "name": "timestamp", "type": "string" }, { "name": "c1", "type": "double", "doc": "Type inferred from '73'" }, { "name": "c2", "type": "double", "doc": "Type inferred from '36.5'" }, { "name": "c3", "type": "double", "doc": "Type inferred from '43.8'" }, { "name": "c4", "type": "double", "doc": "Type inferred from '0'" }, { "name": "c5", "type": "double", "doc": "Type inferred from '75.4'" }, { "name": "c6", "type": "double", "doc": "Type inferred from '997.8'" }, { "name": "c7", "type": "double", "doc": "Type inferred from '0'" }, { "name": "c8", "type": "double", "doc": "Type inferred from '4.58'" }, { "name": "c9", "type": "double", "doc": "Type inferred from '43.8'" }, { "name": "c10", "type": "double", "doc": "Type inferred from '1.5'" }, { "name": "c11", "type": "double", "doc": "Type inferred from '40.6'" }, { "name": "postal_code", "type": "string", "doc": "Type inferred from '\"08863\"'" }, { "name": "country", "type": "string", "doc": "Type inferred from '\"us\"'" } ] }</PRE> Fri, 27 Jan 2017 02:31:18 GMT arunak 2017-01-27T02:31:18Z