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

[#1]

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.

[#2 · Accepted solution]

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