My Sample JSON File is
{
"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"
}
And the Avro schema inferred by NiFi is
{
"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\"'"
}
]
}
... View more
