Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Number format leads into sql alter table loop

  1. #1
    Join Date
    Feb 2011
    Posts
    12

    Default Number format leads into sql alter table loop

    I have a simple transformation that takes a number from a data grid and inserts into a database table (postgresql backend)

    The first time I hit the "Generate the sql needed for this transformation", it creates the table, which is expected behavior

    I hit that again and it does an alter table on a column

    and I can do this over and over again.. is this normal?



    Code:
    -- Step                : Table output
    -- Database Connection : Sandbox
    -- SQL                  : CREATE TABLE number_loop
    (
      "value" DOUBLE PRECISION
    )
    ;
    Code:
    -- Step                : Table output
    -- Database Connection : Sandbox
    -- SQL                  : ALTER TABLE number_loop 
    
    ADD COLUMN "value"_KTL DOUBLE PRECISION;
    UPDATE number_loop SET "value"_KTL="value";
    ALTER TABLE number_loop DROP COLUMN "value";
    ALTER TABLE number_loop RENAME "value"_KTL TO "value";
    
    ;

    -joe

  2. #2
    Join Date
    Feb 2011
    Posts
    12

    Default

    Should I open a jira ticket for this item?

    -joe

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

    Default

    yes.

  4. #4
    Join Date
    Feb 2011
    Posts
    12

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.