Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 4 1 2 3 4

Search Forums: Search took 0.02 seconds.

  1. I tried it and could not make it work ... Like...

    I tried it and could not make it work ...
    Like I stated the names of the fields don't show up in the GUI under the info tab etc.
    Thanks

    Kent
  2. Anyone? "bueller... bueller... bueller..."

    Anyone? "bueller... bueller... bueller..."
  3. UDJC Can you have Multiple Info Streams as in More than 1 Info Step attached to UDJC?

    Hi,

    Just curious as I can make a UDJC work with one info stream but as soon as I add more than one I get errors.

    When you define the second info step:

    The first odd thing is that in the GUI...
  4. Replies
    2
    Views
    2,549

    Hi I believe the issue your having is do to the...

    Hi I believe the issue your having is do to the JDBC driver which doesn't allow a dynamic bind for table name. It can use a dynamic binding in the WHERE clause or in part of the SELECT but when it...
  5. Hi, Perhaps you could have a Main job that...

    Hi,

    Perhaps you could have a Main job that calls you others jobs and transformations.

    You could then use CRON or Windoze Scheduler to call Kitchen which calls runs your Main job.

    Thanks
    ...
  6. Replies
    3
    Views
    1,111

    Hi, I think you could have a central directory...

    Hi,

    I think you could have a central directory for the properties file for everyone that has all the db connection vars mapped to dev dbs.

    Then each developer would make an env var in windows, ...
  7. Hi Matt

    I have done some pretty intensive testing and generalized again but it seems the issue is the 2nd filter step after the gather_rows cannot get the data fast enough.

    8211

    I must confess I'm...
  8. Simplified example screenshots

    Hi Matt,

    Very simplified but from my testing what I'm seeing is it is faster to put all the logic that is being done in the transformation steps after the filter steps into one Javascript step...
  9. Question on Performance Degradation from Joining Streams using Dummy Step

    Hi All,

    Just curious if others have experienced this and if it has something to do with the older version of PDI being used (PDI 3.2.3).

    The volume is a few million rows being input by CSV and...
  10. Feature request created as...

    Feature request created as http://jira.pentaho.com/browse/PDI-7215 please vote if you are so inclined!

    :-)
  11. Yeah it throws: Error processing temp-file!...

    Yeah it throws:

    Error processing temp-file!
    Error creating output file!

    So I guess you would have to create every dir first if you want to do the work-around.

    Thanks!

    Kent
  12. Embed the value of a parameter into the sort steps "TMP-file prefix"

    Hi All,

    Does anyone know if the sort step can allow a variable to be used in the name or part of the name for its "TMP-file prefix"?

    ex:

    I have a trans that has a parameter named FOO, FOO's...
  13. Curious if any of the Web_Service steps allow "WS_SECURITY" to be used?

    Hi All,

    Anyone been able to configure PDI to call services that use "WS_SECURITY" ?

    I don't think the standard PDI steps can work with that type of authentication ... might be wrong?

    If not...
  14. Wow! Great Idea... I have used GATE before and...

    Wow!

    Great Idea... I have used GATE before and it is excellent at ripping out entities from reqs etc.

    My 2 cents!

    Kent
  15. Can you Start Multiple Copies of a Filter Step that has a True and False Hop?

    Hi All,

    I read on the web "Also, in your filter steps, running them in multiple copies isn't going to be very useful
    since they are configured with true and false paths the true and false paths...
  16. Thread: JOINs

    by kandrews
    Replies
    12
    Views
    1,738

    Hey dat789, I think what Matt was trying to...

    Hey dat789,

    I think what Matt was trying to say is you can "in-line" or "short-circuit" a filter step by entering a "condition" like color = blue ... you DO NOT put anything in the 2 fields above...
  17. Shell Script that kills off the Sub Threads (Java) that Kitchen starts

    Hi All,

    Just curious if anyone has ever wrote a decent "handler" script that starts off Kitchen and when killed off can also kill off all the sub processes (threads) it starts?

    You call...
  18. Replies
    3
    Views
    10,139

    Hi, Well from what I've read etc... you are...

    Hi,

    Well from what I've read etc... you are better using 3 steps instead of one JS step.

    The steps take up real estate in spoon GUI but outperform the JS when running.

    But do your due...
  19. Replies
    3
    Views
    10,139

    Hi, Perhaps use the Calculator step. Add a...

    Hi,

    Perhaps use the Calculator step.

    Add a Set field to Constant Value A ... in the value put in Super, set the rest of the settings maybe even remove = y.

    Add another that is A + B and in...
  20. Replies
    2
    Views
    1,767

    Hi Will, Try doing table input step with your...

    Hi Will,

    Try doing table input step with your query then sort the rows by loc_id, prop_codes, us using the sort step.
    Next up use the Group By step and that is where you will Play around learning...
  21. Replies
    3
    Views
    1,150

    Hi nth, You could possibly do: XML Read...

    Hi nth,

    You could possibly do:

    XML Read
    Insert/Update step to your Target Table

    If you set the PK correctly in the Insert/Update step it should insert records that don't exist and Not...
  22. Hi, How many values do you expect to be in...

    Hi,

    How many values do you expect to be in "lastID" ... for each run?
    If it is more than one you should look in the samples dir for a job like "Process all tables" that shows how to do this type...
  23. Hi, In the "TRANSF_TESTE_GETROWS_FROM_RESULT"...

    Hi,

    In the "TRANSF_TESTE_GETROWS_FROM_RESULT" try keeping the variable as a String and NOT an Integer in Get Variables step.

    Then in the Execute SQL script step use the following syntax:

    ...
  24. Replies
    3
    Views
    1,717

    Hey All, Why not use a Table Input Step that...

    Hey All,

    Why not use a Table Input Step that gets the keys & return values you were using in the DB lkup step. Now use a Stream Lkup step to join those values to your main stream ... I believe...
  25. Replies
    6
    Views
    2,613

    If you are running using Spoon .. make sure you...

    If you are running using Spoon .. make sure you shut it down and restart it now that you added something into its path.

    Might work!

    Kent
  26. Replies
    13
    Views
    9,030

    Classic :-)

    Classic :-)
  27. Hi All, Just curious as I have not dived into...

    Hi All,

    Just curious as I have not dived into the Web Service capabilities of PDI but I know others who need to use "ws-security".

    Does the work-arounds in this thread provide a method to...
  28. Hi Vishal, If you just need Kitchen to run a...

    Hi Vishal,

    If you just need Kitchen to run a job why not use CRON or similar for your OS.

    Write a shell script that invokes Kitchen and your job.

    Add an entry to the CRONTAB to run your...
  29. Replies
    3
    Views
    3,254

    Hey Matt, thanks again! Looks like the JS...

    Hey Matt,

    thanks again!

    Looks like the JS trick as stated in http://forums.pentaho.com/showthread.php?68313-Convert-epoch-to-date-without-adding-hours-for-timezone&highlight=epoch works!

    Kent
  30. Replies
    3
    Views
    3,254

    Unix/Epoch Time ?

    Hi All,

    I'm having issues with converting a date coming in from CSV Input as a String to be Unix/Epoch Time.

    I'm using the following in Ver 3.2.3's User Defined Java Exp step:

    new Long(new...
  31. Replies
    3
    Views
    4,482

    Hi Jallen, In a Trans use the "Replace in...

    Hi Jallen,

    In a Trans use the "Replace in string" step ... put a '.0' in the search field and nothing in the replace with field.

    Thx

    Kent
  32. Replies
    3
    Views
    1,509

    With a trans starting everything up in parallel...

    With a trans starting everything up in parallel it can get tricky to make sure that the tran pops the value that you have as a param before the connections initialize.

    This is why wrapping it in a...
  33. Hi, Does it have to be Carte that is started?...

    Hi,

    Does it have to be Carte that is started?

    If it is just a job that you need run why not write a wrapper script in a lang that can run on your windows box and that script would start Kitchen...
  34. Replies
    3
    Views
    1,509

    Hi DRod, Try wrapping the trans in a JOB and...

    Hi DRod,

    Try wrapping the trans in a JOB and defining the params in the JOB.

    Then in the Trans Step within the Job that points to your Trans make sure you have the Pass All the Param Values...
  35. Thread: New field

    by kandrews
    Replies
    2
    Views
    1,456

    You use the Add Constants step, or a Script step...

    You use the Add Constants step, or a Script step ...
    Once you add it in you should be able to preview outgoing rows and see your new field.

    Good Luck

    Kent
  36. Hey Matt, Thanks for the input. I figured...

    Hey Matt,

    Thanks for the input.

    I figured that I would have to remove the sort's unique rows and move that operation to a "Unique Rows" step which follows the merge.

    Nonetheless glad I...
  37. Behavior of Starting Multiple Copies of a Sort Step with Only Pass Unique Rows

    Hi All,

    Just a question on the affects of starting multiple copies of a sort step with Only Pass Unique Rows checked.

    I do have the "merge join" step following the multiple copies started sort...
  38. Replies
    1
    Views
    1,145

    Hi, Double check that the info incl name of...

    Hi,

    Double check that the info incl name of server and port it listens on matches what you have configured in Spoon.

    So whatever you past into the cmd line to start up a carte server on another...
  39. HI

    Hey ...

    I think you need to add a counter variable that is scoped/created outside your function then you should increase it everytime you append a "FIELD_NAME_*" to the line, then do acheck to...
  40. Hey I'd add in don't forget the dos2unix command...

    Hey I'd add in don't forget the dos2unix command once you have them on the linux box.
  41. Hi, Use one trans form for all. Have the...

    Hi,

    Use one trans form for all.

    Have the 1st db input then connect the 2nd that takes input from the 1st. (see the manual for this basically Table Input step with "Insert data from" checked as...
  42. Hi, Not sure about the Enterprise Edition...

    Hi,

    Not sure about the Enterprise Edition Restart but you can achieve a similar concept by following... ...
  43. Replies
    9
    Views
    6,695

    Hi Tomaz Check out VoltDB ... I hear that is...

    Hi Tomaz

    Check out VoltDB ... I hear that is same idea as the non-blocking, all in memory db's.

    Seems like it may be a good soln.

    Also OSS version.

    Thanks
  44. Hi Maria, I tried that and it seems that even...

    Hi Maria,

    I tried that and it seems that even though the variable is scoped at the Parent Job, another iteration through the loop overwrites the same Parent Job vars.

    for ex.

    1st Iteration...
  45. Bump Please anyone have any ideas?

    Bump

    Please anyone have any ideas?
  46. How to keep a Variable Safe from being Reset in a Loop Situation

    7408

    PDI 3.2.3 on Linux

    So I've got a parallel loop set up and it works except that I can't seem to keep the Value of the Variable/Parameter that is passed into the "This is The Work" job safe....
  47. Thoughts on Starting more threads while System Load is Below Certain Threshold

    Hi All,

    PDI 3.2.3 on Linux

    Looking for a way to keep starting more threads/jobs while the system is below a certain threshold.

    So I would be querying the Top cmd and parsing the Average Load...
  48. Hi, If it's in a trans then you should choose...

    Hi,

    If it's in a trans then you should choose what you want to pass along by using a select values step and then connect a Copy rows to result step to that.

    Then in the next trans you use a Get...
  49. PDI 3.2.3 GA Issue with CSV Input Running More than 1 copy with Running Parallel set

    Hi All,

    I have an interesting thing going on.

    The file I'm trying to process is > 500,000,000 million rows but only 6 columns wide. So it's big!

    It is running on a Linux box with lot's of...
  50. Hi Matt, Verified that the linux user running...

    Hi Matt,

    Verified that the linux user running kitchen can indeed change file via /bin/chmod -x file

    The working directory is indeed an mounted filesystem available via a link.

    That same user...
Results 1 to 50 of 170
Page 1 of 4 1 2 3 4
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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