Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 2 1 2

Search Forums: Search took 0.02 seconds.

  1. Thanks Marabu! I was backing out after I read...

    Thanks Marabu! I was backing out after I read that:

    So, the behaviour of this kind of jobs is definitly unpredictable, especially in production environments. In the worst case, the whole engine...
  2. Keep repeating a Job/Transformation as many times as it fails

    Hi friends!

    I came up with that need.
    Is that possible?

    I assume the only way to loop in Kettle is through execution for each row, so I guess that could not be possible in the flow as I don't...
  3. Thanks! Because I don't find it practical to...

    Thanks!

    Because I don't find it practical to keep 3 files which represent the same logical unit, specially when considering this is due to some limitations on the row flow.
    At the end, I only...
  4. A way to avoid executing certain transformation steps

    Hi!

    I observed there are some steps that are executed either with or without rows incoming.

    For instance, ETL metainjector seems to be executed always does not matter if you connect it to a...
  5. Solved it! I fanally managed to make my plugin...

    Solved it!

    I fanally managed to make my plugin work by copying it to ~/.kettle/. Seems like plugin classpath is not read.
  6. Thanks Marabu! That link is what I checked!...

    Thanks Marabu!

    That link is what I checked!
    I'll ask in the forum.

    It's not a critical issue, but it is indeed the first time in my short kettle lifespan that something working in spoon does...
  7. When I read you I was cmopletly sure it all had...

    When I read you I was cmopletly sure it all had sense as annotations are not present in old javas. But even using the new one it seems it does not help with my problem. Plugin is still not...
  8. Let me reformulate it again. If Google...

    Let me reformulate it again.

    If Google Spreadheet, R executor plugins are not relying on plugin.xml nor annotations in their code, how can they be installed/handled by Spoon actually?

    Thanks!
  9. Plugin not working in Kitchen (has no plugin.xml)

    I'm using an old plugin and I cannot understand why it does not work in Kitchen but does in Spoon.
    So I look for any particularities and I found that some plugins from marketplace like Google...
  10. No worries gutlez, but truth is I am myself a...

    No worries gutlez, but truth is I am myself a in-house integrator (my company, which is an end client). Indeed I am trying to become a kettle expert within it, that is why I am always asking more...
  11. Conditional flow WITHIN transformations

    Is there any evident way to achieve that?

    I got 2 table inputs where all the row flow start, but I'd like them to start fetching only if a condition is satisfied.

    If that field in that table is...
  12. Replies
    2
    Views
    1,073

    I don't see it neither at job level nor at...

    I don't see it neither at job level nor at transformation level. I'm using 5.0.1
  13. XML Schema 1.1 support for XSD Validation

    Is XML Schema 1.1 supported in XSD Validation Step?
    I am getting some errors, and wiki does not say anything, so I'd like to be sure before debugging it.

    Thanks!
  14. I'll try that way, experimenting with it, thanks!

    I'll try that way, experimenting with it, thanks!
  15. Nice feature! unfortunately we don't use EE DI...

    Nice feature! unfortunately we don't use EE DI Server :'(. Thanks anyway! Hope I'll use it someday!
  16. Hi ! Thanks! Do you mean having a parallel...

    Hi ! Thanks!

    Do you mean having a parallel flow sleeping during some time and then use it for aborting the job?
    Mmh, that's an option but if so I think it's a bit annoying implementing that for...
  17. Replies
    2
    Views
    1,073

    Vertica Bulk Loader

    Hi!

    I see there is a dev plugin step from 2009 to bulk load into Vertica using its high performance methods.
    Is that plugin recommended yet? Is it planned any integration of Vertica's native...
  18. Handling Idle connections within the flow

    Hi friends!

    I got some connections that sometimes get hung because of the network or something. As long as we don't identify the concrete problem and fix, I am wondering if there is any sort of...
  19. Thanks! That's exactly what I had thought :)

    Thanks! That's exactly what I had thought :)
  20. Strategy for executing only those transformations in a parameter

    Hi!

    I'm wondering if there is such a feature out-of-the-box, that allows us to debug certain job entries without having to define mock values with local parameters and execute the transformation...
  21. Replies
    6
    Views
    936

    It's impossible... I tried everything. It...

    It's impossible... I tried everything.

    It seems that is not possible unless the step read data in Xpath 2.0 and allowed "for" expressions for retrieving a value. Then there is a trick as M.Kay...
  22. Replies
    6
    Views
    936

    I found the key point ...

    I found the key point

    http://stackoverflow.com/questions/6595034/xpath-xslt-nested-predicates-how-to-get-the-context-of-outer-predicate
  23. Replies
    6
    Views
    936

    Thanks! But I can't access current node with a...

    Thanks!

    But I can't access current node with a relative path, because I am addressing a field that has nothing todo with the current node.

    I mean:

    for each X
    return me every Y which has...
  24. Replies
    3
    Views
    595

    Thanks as always for kindly explaining it to me,...

    Thanks as always for kindly explaining it to me, Marabu!
    My question was more oriented regarding how the local sync works between local copies and shared file. Can you enlight me a bit on that?
  25. Replies
    6
    Views
    936

    GetXMLData XPATH's Current node

    Hi!

    given that the step iterates over a XPATH expression and then fetches a field accoridng to another expression,

    I'd like to know how can I refer the current node of the iteration instead of...
  26. Replies
    2
    Views
    643

    Select Values step will make your day ;)!

    Select Values step will make your day ;)!
  27. Replies
    3
    Views
    595

    On Shared Connections

    Hi!

    I'm studying the behaviour regarding shared connections. Can somebody confirm the following is true?

    - When sharing connections, each of the jobs and transformations as soon as used make a...
  28. Replies
    11
    Views
    1,384

    No, I don't store the output in database either ;)

    No, I don't store the output in database either ;)
  29. Yes, since I discovered ETL Metadata Injection...

    Yes, since I discovered ETL Metadata Injection half of my dynamic doubts went away. The only problem is that it seems buggy to me on the last stable PDI, as it clears any sort/denormalize/normalize...
  30. Replies
    11
    Views
    1,384

    Thanks again Mick, but unfortunately -...

    Thanks again Mick, but unfortunately

    - Neither Add Sequence or add sequence on changing value allow to INCREMENT de sequence only on value change
    - I meant splitting the table in columns not...
  31. Replies
    0
    Views
    442

    ETL Metadata Injection

    I've noticed that each time I execute the ETL Metadata Inejction on a transformation, any parameter defined in a Sorting Step within it (order by fields) suddenly appears cleared in the after...
  32. Replies
    12
    Views
    4,943

    Affirmative Mim, I own what I think it is the...

    Affirmative Mim, I own what I think it is the most recent one, downloaded a week ago from the marketplace through the very interface of Kettle (Help > Marketplace). So I guess I'm using an updated...
  33. Rename a column/field according to a variable

    I have fields such as this

    1 2 3
    val1 val2 val3

    I am wondering if I can rename those fields accorindg to a table such as

    Key Param
    1 MyParam1
    2 MyParam2
  34. Remove column/field if all its values are null

    Is that possible some way?
    Yes, it need to wait for all the rows to load, but also sorting does.
  35. Ok I used the solution kindly provided by you....

    Ok I used the solution kindly provided by you.
    Simply as a JS value step like this really.

    var i=(!i)?0:i;
    var prev;

    if (!Col1.equals(prev)) i++;
    prev = Col1;

    It expects the input sorted...
  36. Are you sure timezone can be specified from the...

    Are you sure timezone can be specified from the command line? I browsed about the command line options and didn't find any info on the topic
    ...
  37. Yes, but Select values does not allow...

    Yes, but Select values does not allow parametrizing the timezone, so I need to hardcoded for every incoming field, thus not dynamic
    I'll check Stax and Get Daat from XML.

    Did not know kitchen and...
  38. Are you sure it is a good idea to rely on a new...

    Are you sure it is a good idea to rely on a new connection, a particular table created to mock the creation of a key.. i would like to do it in runtime in the ETL

    If only adding sequence on...
  39. Replies
    11
    Views
    1,384

    Thanks gutlez but sometimes I read from a CSV or...

    Thanks gutlez but sometimes I read from a CSV or any other non relational source and I need to emulate the normalized behaviour of a RDBM, so I must generate the key as if were the database. If I had...
  40. Replies
    12
    Views
    4,943

    I am not sure I understand you correctly. I'd do...

    I am not sure I understand you correctly.
    I'd do a test (sorry if it is actually what you are doing).
    Use an standard step for inputing from CSV. Connect that step to R script. Define in the input...
  41. That's a very nice snippet, I'll use it, thanks!

    That's a very nice snippet, I'll use it, thanks!
  42. Replies
    11
    Views
    1,384

    Some steps I missed at some time: - Eval step...

    Some steps I missed at some time:

    - Eval step -> It evaluates all values passed, in a loop fashion as in named parameters if possible (${PARAM1} = "this is my ${PARAM2}" = "this is my param2")
    -...
  43. Thanks! Do you mean seting an environtment var?...

    Thanks!
    Do you mean seting an environtment var?
    By the way, can I make a reference to the "lastrow" in JS?
  44. Select values > localize TimeZones Dynamically

    I'm feeding the global vars through an XML.

    I need a mechanism to localize datestamps, but Select Values does not allow to parametrically specify TimeZone, so I need to hardcode within Kettle the...
  45. Add value fields chang. sequence without increment (or increment only on change value

    Hi friends!

    Any easy way to implement this? Perhaps a different trick?

    seq
    fieldvalue1 1
    fieldvalue1 1
    fieldvalue2 2
    fieldvalue2 2
    fieldvalue2 2
  46. Replies
    12
    Views
    4,943

    What are your inputs? Did you test receiving...

    What are your inputs? Did you test receiving fields and rows as a simple dataframe and print it out to check the basic I/O is working?

    I had to fight last week with it and I finally managed to...
  47. Replies
    2
    Views
    575

    Nice Thanks!!!

    Nice Thanks!!!
  48. Replies
    2
    Views
    575

    Row Denomarlization

    I've read 2 or 3 posts about denormalizing. One of them asks for a dynamic solution without having to know the name of denormalized columns beforehand. One of the answers states that that would be...
  49. Thread: Eval step

    by bizintreader
    Replies
    8
    Views
    1,028

    Summing up, I'd like to know how the following...

    Summing up, I'd like to know how the following would be performed without compatibility mode on:

    for (var i=0;i<getInputRowMeta().size();i++){
    row[i].setValue(myValueParser(row[i]));
    }
  50. Thread: Eval step

    by bizintreader
    Replies
    8
    Views
    1,028

    Could anyone shed some light about best practices...

    Could anyone shed some light about best practices for this?
Results 1 to 50 of 81
Page 1 of 2 1 2
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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