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

simon_jespersen — Tue, 12 Jun 2018 18:27:36 GMT

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.

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

simon_jespersen — Wed, 13 Jun 2018 19:02:50 GMT

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