Support Questions

Find answers, ask questions, and share your expertise

NiFi PutGreenplumRecord Processor and JSONB type

New Contributor

Hi!
Can't insert jsonb data via PutGreenplumRecord. Error: "Unknown Data Type for field data"
Types TEXT and just JSON (without B) are inserted without problems.
Is there a way to solve the problem?
JsonTreeReader schema looks like this
{
"name": "gp_default_record",
"type": "record",
"namespace": "com.acme.avro",
"fields": [
{
"name": "optimum",
"type": "string",
"default": "${now()}"
},
{
"name": "data",
"type": "string"
}
]
}

The attribute "data" in the database has the type JSONB

 

tirdman_0-1656341322098.png

 

0 REPLIES 0
Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.