Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Nifi executeSql on postgresql produce error cannot be converted to Avro type

avatar
Expert Contributor

Hi

When executing a select statement in executeSql processor on a posrgresql i get this error

Unknown SQL type 1111 cannot be converted to Avro type

The column causing this is a json type column, i have tried to google how to cast the json to a string put i doesn't seems to be so simple.

It works fine when i does it without that column

Does anybody know about a workaround on this.

1 ACCEPTED SOLUTION

avatar
Expert Contributor

I found the solution my self, much more simple than i first thought, just cast the json type to text and avro will accept it.

select cast (json column as text ) columnName

from table

View solution in original post

1 REPLY 1

avatar
Expert Contributor

I found the solution my self, much more simple than i first thought, just cast the json type to text and avro will accept it.

select cast (json column as text ) columnName

from table