[jira] [Created] (NIFI-5246) ExecuteSQL Fails When Querying From PostgreSQL Geometric Types

["Scott Wilburn (JIRA)" <ji...@apache.org>]

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)