Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Trying to read geometry field from Oracle11 by TableInput

  1. #1
    Join Date
    Jun 2017
    Posts
    3

    Default Trying to read geometry field from Oracle11 by TableInput

    Pentaho 7.1, GEO Plugin installed, Oracle11 table with a field of type geometry. Cannot read this field by using step TableInput. What to do?

  2. #2
    Join Date
    Sep 2011
    Posts
    152

    Default

    what is the query you have used in table input step?

    I tested below query and found it fetching the value in table input.
    SELECT ST_AsText(geometry_column) FROM geom;

  3. #3
    Join Date
    Jun 2017
    Posts
    3

    Default

    My query is: select id,geometry_column from table_name. In the preview I see a list of id's with the geometry_column as <null>. No error but also no data. Also: the geometry_column is recognized as 'String' not as 'Geometry'. But I need is as 'geometry' because the next step will be one of the options from the gis-plugin: 'Geometry-information'. Strange thing is that someone in another firm has this all working with the same Pentaho version, same Oracle version, same table, same Java version.

  4. #4
    Join Date
    Jun 2017
    Posts
    3

    Default

    Apparantly the gis-plugin was installed wrong or it was a wrong version. Reinstalled the latest version and it works!

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.