Member since
11-15-2022
3
Posts
0
Kudos Received
0
Solutions
11-15-2022
11:19 PM
I'm able to fix this .. In JSON Tree READER the configuration for `Schema Access Strategy` should be "Infer Schema" Input date format will be "yyyy-MM-dd HH:mm:ss.SSS'Z'" avro schema for the same will be {
"name": "createdAt",
"type": {
"type": "long",
"logicalType": "timestamp-millis"
}
}
... View more
11-15-2022
03:32 AM
@araujo I have faced the similar issue with Apache/Nifi 1.16.3 and 1.16.2, attaching Avro Schema {
"type": "record",
"namespace": "nifi",
"name": "userSchema",
"fields": [
{
"name": "dob",
"type": {
"type": "string",
"logicalType": "timestamp"
}
},
{
"name": "createdAt",
"type": {
"type": "long",
"logicalType": "timestamp"
}
},
{
"name": "full_name",
"type": "string"
},
{
"name": "gender",
"type": "string"
},
{
"name": "email",
"type": "string"
},
{
"name": "address",
"type": "string"
},
{
"name": "uuid",
"type": "string"
},
{
"name": "phone",
"type": "string"
}
]
} the processor/controller services configuration Convert Record Processor Error Image Avro Reader Configuration Avro Record set writer JSON Tree READER
... View more
11-15-2022
03:20 AM
@araujo i'm also facing the similar issue with 1.16.3 and 1.16.2, i'm attaching the referenced images Running NIFI Using docker in Mac M1 JSON input data [ {
"full_name" : "Anatolij Finkbeiner",
"gender" : "male",
"email" : "anatolij.finkbeiner@example.com",
"phone" : "0166-2058423",
"dob" : "2000-09-11T15:40:10.890Z",
"uuid" : "747f27a8-88c0-452e-b360-3ddf5ee67211",
"address" : "Germany, Schleswig-Holstein, Guben",
"createdAt" : "2022-11-15T11:09:35.912Z"
}, {
"full_name" : "Lucia Soto",
"gender" : "female",
"email" : "lucia.soto@example.com",
"phone" : "946-359-112",
"dob" : "1987-09-15T09:58:34.821Z",
"uuid" : "8edb62cd-0bdc-41ee-8806-fecfd6958e33",
"address" : "Spain, Navarra, Santiago de Compostela",
"createdAt" : "2022-11-15T11:09:35.911Z"
} ] Error JSON Tree READER Avro Schema {
"type": "record",
"namespace": "nifi",
"name": "userSchema",
"fields": [
{
"name": "dob",
"type": {
"type": "string",
"logicalType": "timestamp"
}
},
{
"name": "createdAt",
"type": {
"type": "long",
"logicalType": "timestamp"
}
},
{
"name": "full_name",
"type": "string"
},
{
"name": "gender",
"type": "string"
},
{
"name": "email",
"type": "string"
},
{
"name": "address",
"type": "string"
},
{
"name": "uuid",
"type": "string"
},
{
"name": "phone",
"type": "string"
}
]
} Avro Record set writer Avro reader
... View more