Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Geookettle - 'group by' step and geometries

  1. #1
    Join Date
    Jun 2015
    Posts
    9

    Default Geookettle - 'group by' step and geometries

    Hi,

    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,
    Pedro

  2. #2
    Join Date
    Jun 2015
    Posts
    9

    Default

    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
    Posts
    5,534

    Default

    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.