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

ExecuteSQL Fails When Querying From PostgreSQL Geometric Types

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment