Scott Wilburn created NIFI-5246:
-----------------------------------
Summary: ExecuteSQL Fails When Querying From PostgreSQL Geometric
Types
Key: NIFI-5246
URL: https://issues.apache.org/jira/browse/NIFI-5246
Project: Apache NiFi
Issue Type: Bug
Components: Extensions
Affects Versions: 1.5.0
Reporter: Scott Wilburn
ExecuteSQL processor errors when querying PostgreSQL database tables that
contain geometric types, such as polygons, lines, and points. If Avro types are
incompatible with any source types, then it needs to have a way cast to
text/string so that queries do not fail.
The following is the error from NiFi:
ExecuteSQL[id=016366bb-22ff-1f1e-8061-a95b6f956fda]
ExecuteSQL[id=0145610bb-22ff-1f1e-8061-a95b6f956fda] failed to process session
due to java.lang.IllegalArgumentException: createSchema: Unknown SQL type 1111
/ geometry (table: buildings, column: spatialobject) cannot be converted to
Avro type: createSchema: Unknown SQL type 1111 / geometry (table: buildings,
column: spatialobject) cannot be converted to Avro type
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
