Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Dimension Look up update/ Vertica

  1. #1
    Join Date
    Jan 2015
    Posts
    10

    Default Dimension Look up update/ Vertica

    Hi,
    I am using PDI version 8.1. I am using the dimension lookup update step and connecting to vertica. The use auto increment key for the technical key gets disabled as soon as i select my vertica connection. I have an identity column in vertica and it uses internal sequences in vertica. I am unable to select the auto increment. It results in error. Is this option disabled for vertica database?

  2. #2
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    The problem is in the code...

    https://github.com/pentaho/pentaho-k...Meta.java#L262

    and
    https://github.com/pentaho/pentaho-k...abaseMeta.java

    Vertica 5+ fixes the driver name.

    There's a plug-in available that brings support for Vertica 9. You might want to try that.
    https://github.com/twineworks/vertic...pentaho-kettle
    But it looks like it won't help...
    https://github.com/twineworks/vertic...Meta.java#L811
    Last edited by gutlez; 03-11-2019 at 04:05 PM.

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.