Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: using Netezza sequence through kettle get sequrence

  1. #1
    Join Date
    May 2009
    Posts
    16

    Default using Netezza sequence through kettle get sequrence

    I'm trying to use the Netezza DB to get the sequence in kettle but no able to make it work. It's giving me following error


    2009/07/16 13:21:25 - AutoincrementValue.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Because of an error, this step can't continue:
    2009/07/16 13:21:25 - AutoincrementValue.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Error reading next value of sequence [autoincrement] from database
    2009/07/16 13:21:25 - AutoincrementValue.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :
    2009/07/16 13:21:25 - AutoincrementValue.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Unable to get next value for sequence : autoincrement
    2009/07/16 13:21:25 - AutoincrementValue.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : ERROR: Relation 'autoincrement' does not exist


    See below for testing of sequence in Netezza

    TEST_DB=> create sequence test_num as int start with 1 increment by 1 maxvalue 100;
    CREATE SEQUENCE

    TEST_DB=> insert into aa select next value for test_num, 'name';
    INSERT 0 1

    TEST_DB=> select * from aa;
    ID | NAME
    ----+------
    1 | name
    (1 row)

    TEST_DB=> insert into aa select next value for test_num, 'name';
    INSERT 0 1

    TEST_DB=> select * from aa;
    ID | NAME
    ----+------
    2 | name
    1 | name
    (2 rows)


    In kettle i did select or tick the "Use DB to get sequence" with Connection name and sequence name. Sequence is in the correct schema.

    I'm using 3.2 and when i run the transformation, it showing a red box around the sequence step.

    Any help would be highly appreciable.

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    To my knowledge Netezza sequences aren't supported yet.
    File a feature request.

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.