Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 100 1 2 3 4

Search Forums: Search took 0.07 seconds.

  1. You could use a Calculator step to create a...

    You could use a Calculator step to create a hexadecimal representation of the field value.
    On the other hand, you could use an Editor capable of showing control characters (e.g. Notepad++) to make...
  2. My question was: How did you assert there's no...

    My question was: How did you assert there's no linebreak in that field value?

    Just because you don't see it, it still could be there.
  3. You are producing a CSV file using...

    You are producing a CSV file using Text-File-Output and there is a linebreak where none should be?
    Either the linebreak is part of the field value that comes from the database, or it's just a...
  4. The requested information can be found in an...

    The requested information can be found in an article written by Slawomir Chodnicki.
  5. Please, tell us more about your project. How...

    Please, tell us more about your project.
    How many rows do you want to buffer and why can't you use the buffering standard steps like Group-By?
    What are the complex calculations?
    Generally,...
  6. Replies
    2
    Views
    321

    Don't use "Remove special character", then. ...

    Don't use "Remove special character", then.
    Left-trimming alone should do the trick.
  7. So it's something like //F/*[name()!="F"] you...

    So it's something like //F/*[name()!="F"] you want to use as your Loop XPath ?
  8. I don't know how others do it, but I read a text...

    I don't know how others do it, but I read a text sequentially.

    What a ride:


    Poor choice of an input sample, then: There's only one F node qualifiying.


    Try not to confuse your readers -...
  9. Replies
    4
    Views
    633

    You're looking in the wrong place, I'm afraid....

    You're looking in the wrong place, I'm afraid.
    Kettle isn't a Data Processor as defined by the GDPR.

    Also, isn't it a bit late to worry about GDPR?
    Work on it began in 2012, approval was 2016....
  10. Job entry Check-If-A-Folder-Is-Empty tests the...

    Job entry Check-If-A-Folder-Is-Empty tests the absence of certain (or all) files.
    That means if you use the pattern .+\.kjb on folder ${Internal.Job.Filename.Directory} the result would be FALSE...
  11. Replies
    1
    Views
    729

    PEBCAC? PS: Why don't you attach your test...

    PEBCAC?

    PS: Why don't you attach your test case instead of unreadable images?
  12. Replies
    4
    Views
    709

    Not a good idea. Both steps have distinct...

    Not a good idea. Both steps have distinct features. Learn about them and decide which step to use according to your requirements.
  13. Replies
    4
    Views
    709

    Tell us why CSV-File-Input doesn't work for you.

    Tell us why CSV-File-Input doesn't work for you.
  14. Just for feature completeness: You can configure...

    Just for feature completeness: You can configure a SQL script into the Database Connection (Advanced section) that is executed right after the connection is established.
  15. Get-File-Names should be your starting point....

    Get-File-Names should be your starting point.
    FileNameUtils (Apache Commons) can be used to extract the basename.
    Adjust to your requirements.
  16. Replies
    5
    Views
    2,106

    Did you make sure the tunnel is working without...

    Did you make sure the tunnel is working without Kettle, i.e. the firewall settings are ok?
  17. Replies
    5
    Views
    2,106

    Trust me, you don't want an ETL tool (like...

    Trust me, you don't want an ETL tool (like Kettle) to do network management.

    What exactly is your problem - creating the ssh tunnel or using it from Kettle?
  18. Didn't you find the Sort-Rows step, yet?

    Didn't you find the Sort-Rows step, yet?
  19. Replies
    2
    Views
    672

    There's a pure dataflow solution to guard against...

    There's a pure dataflow solution to guard against divison-by-zero, but you could use a Java Expression with a ternary operator as well.

    19174
  20. I don't see this is PDI 7 related. I would look...

    I don't see this is PDI 7 related.
    I would look into JDBC timeout settings.
  21. Replies
    2
    Views
    513

    Your performance problem seems to be related to...

    Your performance problem seems to be related to the way you store those new hash values. Is it a Table-Output step?

    Executing a statement like INSERT INTO Hash_Table_A (Hash) SELECT Hash FROM...
  22. Replies
    1
    Views
    732

    So, you have a Table-Input step with a SELECT...

    So, you have a Table-Input step with a SELECT statement having a WHERE clause with a condition like "date_expr BETWEEN low_date AND high_date", and you are looking for a way to keep the interval...
  23. Replies
    6
    Views
    764

    My use of the Calculator step is only to retrieve...

    My use of the Calculator step is only to retrieve the XML document from the note element.

    Of course, you can specify XPath expressions without the help of the buttons.
    They are just a convenience...
  24. Replies
    6
    Views
    764

    I just posted the whole document you gave in your...

    I just posted the whole document you gave in your opening post.
  25. Replies
    6
    Views
    764

    When you press button "Get XPath nodes" on the...

    When you press button "Get XPath nodes" on the Content tab of Get-Data-From-XML, Kettle suggest /*[name()='VerifyEmailResult'] as your Loop XPath.
  26. Replies
    3
    Views
    678

    For me the step idling forever is an - albeit...

    For me the step idling forever is an - albeit poor - consequence of the memory exhaustion, not vice versa.
    But I could be wrong, of course.
    Good luck.
  27. Replies
    3
    Views
    1,672

    Guys, if you don't specify "Input field which...

    Guys, if you don't specify "Input field which contains upload file name" Kettle will assume it's the field with name UPLOAD.
    Obviously, there's no field named UPLOAD in you input stream.
  28. So, you need support from Meta Integration?

    So, you need support from Meta Integration?
  29. Replies
    3
    Views
    678

    Your JDBC driver needs more memory it seems. ...

    Your JDBC driver needs more memory it seems.

    If you're loooking for improvements to the Vertica-Bulk-Loader step, you'll have to turn to file a bug report - if no one already did that.

    Also,...
  30. Sure you can, the job entry you're looking for is...

    Sure you can, the job entry you're looking for is named Evaluate-rows-number-in-a-table.
  31. Replies
    1
    Views
    395

    You have two streams containing tuples (id,...

    You have two streams containing tuples (id, mobile) and want to aggregate the mobile field?
    Just unite the streams, sort them on the id, and follow up with aggregation.

    19142

    Also, no need to...
  32. Replies
    1
    Views
    481

    A better problem description would be nice. ...

    A better problem description would be nice.

    Also, screenshots shouldn't be inserted as images to stay readable.
  33. Replies
    4
    Views
    1,073

    Under Windows, you should introduce a symlink...

    Under Windows, you should introduce a symlink (mklink /D Java ...) in the same folder that contains your newly installed JDK, so your PATH and all environment variables can always refer to a generic...
  34. What about the Meta Integration page on Pentaho...

    What about the Meta Integration page on Pentaho - is there nothing in there?
  35. Replies
    1
    Views
    446

    That's not how this forum works ... PS:...

    That's not how this forum works ...

    PS: Basically, with one field holding part of the filename and another field holding the file content, you add a step like User-Defined-Java-Expression to...
  36. Replies
    8
    Views
    1,295

    Answering your question in the title: No, you'll...

    Answering your question in the title: No, you'll have to use Carte for that.

    Edit: @johan didn't see you coming ...
  37. Replies
    3
    Views
    615

    It seems like the feed parser doesn't work well...

    It seems like the feed parser doesn't work well with the kaspersky server.
    Here is a workaround.
  38. KETTLE_HOME is the wrong variable for this. ...

    KETTLE_HOME is the wrong variable for this.

    try java -Djava.io.tmpdir=D:/%USERNAME%/Temp
  39. I knew about your use of Oracle from your opening...

    I knew about your use of Oracle from your opening post.
    I just had a feeling it's not that important because of your use of the phrase "is also unsupported" - and most CE users use version...
  40. Guys, the thread owner (EE user) seems to be...

    Guys, the thread owner (EE user) seems to be worried, that his support contract "suddenly" covers server based installations only, i.e. DI-Server in connection with Pentaho Repository.

    He's...
  41. Replies
    8
    Views
    1,706

    If SELECT INTO returns a result set, Table-Input...

    If SELECT INTO returns a result set, Table-Input could use a temporary table via subquery like SELECT * FROM (SELECT .... INTO TEMP TABLE ...)
    Performance could be measured that way, but lifetime of...
  42. The highlighted class is mistyped in the original...

    The highlighted class is mistyped in the original source.
    You'll have to correct the classname and compile from source.
    Or try a newer version.
  43. Replies
    8
    Views
    1,706

    You are right, a redshift temp table is gone...

    You are right, a redshift temp table is gone after the connection is closed, and Kettle closes a connection as soon as possible.
    If you want a database connection to persist during a job, try to...
  44. Replies
    8
    Views
    1,706

    Table-Input must have a single SELECT statement...

    Table-Input must have a single SELECT statement returning a result set.
    Creating and populating a temporary table must be done somewhere else.
    You can have multiple statements in your connection...
  45. If you provide a detailed step-by-step procedure,...

    If you provide a detailed step-by-step procedure, I certainly will try to reproduce this.
  46. This is the community forum, not the bug tracker...

    This is the community forum, not the bug tracker.
  47. Replies
    4
    Views
    704

    I still find it strange when people store...

    I still find it strange when people store presentation formats in a database.
    But maybe the thread owner wanted to write Text-File-Output instead of Table-Output:
  48. Generally, sending a single mail to one or more...

    Generally, sending a single mail to one or more recipients is best done in a Kettle job: Start -> YourTransformation -> Mail
    Let's assume the last step of your transformation is a Text-File-Output...
  49. Replies
    1
    Views
    401

    As long as you only need that parameter for...

    As long as you only need that parameter for filenames, reformatting the date should be done on the job level.
  50. You have chosen Stream-Lookup because you don't...

    You have chosen Stream-Lookup because you don't have to sort the rows?
    Stream-Lookup will hash the key values, so lookup will rely on binary search followed by sequential search in case of...
Results 1 to 50 of 5000
Page 1 of 100 1 2 3 4
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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