Hitachi Vantara Pentaho Community Forums

Search Forums:

Type: Posts; User: kettle_alinv; Keyword(s):

Search Forums: Search took 0.02 seconds.

  1. Replies
    16
    Views
    3,115

    I still don't think that things are as they are...

    I still don't think that things are as they are supposed to be right now.
    Look at this scenario: I have a smallint field in a source sql server table and I want to transform it in a string. Using a...
  2. Replies
    16
    Views
    3,115

    I have the same problem using older...

    I have the same problem using older transformations which mapped integer values 0 and 1 to string 'N' and 'Y', using a Select values step to change the metadata and a Value mapper to do the actual...
  3. RE: An error occured upgrading the repository!

    I used 'create like' to create the new user from the old one and I guess that's why I had this problem. I created a fresh new user and now it works.

    Thanks a lot,
    Alin
  4. RE: An error occured upgrading the repository!

    Yes, I'm sure it's a new user, with no tables under its schema.
  5. RE: An error occured upgrading the repository!

    I already tried to manually alter the table, but the upgrade procedure ignores my changes.
    My bad, I missed the Repository Upgrade Guide.
    Now I'm trying to create a new repository, using a new...
  6. An error occured upgrading the repository!

    Couldn't execute SQL: ALTER TABLE R_NOTE MODIFY (VALUE_STR CLOB )


    ORA-22858: invalid alteration of datatype
  7. Replies
    6
    Views
    3,520

    RE: Handling empty strings

    So, it was an oracle thing, afterall.

    Thank you, that did it.

    Alin
  8. Replies
    6
    Views
    3,520

    Handling empty strings

    I'm trying to copy some data from SQL Server into Oracle. The problem is that when kettle finds an empty varchar field (mind it, empty, not null), it tries to insert a null into oracle, which throws...
  9. RE: Get Fields.... Feature enhancement request

    I'll second that.
  10. RE: OutOfMemoryError running a simple update

    I get the data from SQL Server and I put it into Oracle. Before this, I had a simple read/insert transformation for over 30 mil records and it didn't hit this problem.

    I attached the...
  11. RE: OutOfMemoryError running a simple update

    Attachment: update.ktr Oops!
  12. OutOfMemoryError running a simple update

    Attachment: update.ktr Hi,


    I'm trying to run a simple update process on ~200k records. After a while, the spoon process dies, without any explanation. Running it from a console, I managed to...
Results 1 to 12 of 12
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.