Uploaded image for project: 'Apache NiFi'
  1. Apache NiFi
  2. NIFI-5246

ExecuteSQL Fails When Querying From PostgreSQL Geometric Types

    XMLWordPrintableJSON

    Details

      Description

      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

       

       

       

       

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              tcots Scott Wilburn
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: