Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Geookettle - 'group by' step and geometries

  1. #1
    Join Date
    Jun 2015

    Default Geookettle - 'group by' step and geometries


    Hope that someone use geokettle in here

    I have a transformation where my goal is to merge the geometries by an attribute field and then update a postgresql/postgis. I used the 'Group by' step to make this.
    I got this error: Caused by: org.postgresql.util.PSQLException: ERROR: Geometry type (Polygon) does not match column type (MultiPolygon)

    My problem is that in the input table I have the geometry type = Multipolygon.
    After the 'Group by' step the geometries that were "merged" changed the geometry=polygon
    The others that didn't were "merged" stay geometry type = Multipolygon

    Because of that, when I try to update/insert my Postgis table I got the error Geometry type (Polygon) does not match column type (MultiPolygon)

    Do any one have a suggestion how should I handle this?

    Thanks in advance,

  2. #2
    Join Date
    Jun 2015


    Replying to myself...

    I solve this by changing the column type of my postgis table to geometry (from MultiPolygon)....

  3. #3
    Join Date
    Jun 2012


    I like it when people post their own solutions instead of abandoning an open thread.

    Thank you very much.
    So long, and thanks for all the fish.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.