Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 4 1 2 3 4

Search Forums: Search took 0.03 seconds.

  1. Replies
    2
    Views
    237

    That's what I thought by the way the step was...

    That's what I thought by the way the step was organized. This would be a nice feature to add though.
  2. Replies
    2
    Views
    237

    call db procedure parameters

    I am successfully using the call DB procedure step to have Oracle execute procedures that we are using to load data into some tables. I can't find a way to map a field name to a particular parameter...
  3. Replies
    4
    Views
    636

    That seems to have worked! My next question is...

    That seems to have worked! My next question is how do I read it back out and write it to a jpg image file? Do I use text file output and just specify the binary field is the only thing to write to...
  4. Replies
    4
    Views
    636

    Thanks. I will try that tonight and let you know.

    Thanks. I will try that tonight and let you know.
  5. Replies
    4
    Views
    636

    load binary data to table

    I'm trying to load 70,000 picture files to a database table in postresql. I found this page https://wiki.pentaho.com/display/COM/Loading+Binary+Objects+With+Kettle
    but get an error in the...
  6. Replies
    11
    Views
    5,285

    thankyou! I have now imported the certificates.

    thankyou! I have now imported the certificates.
  7. Replies
    11
    Views
    5,285

    I am trying to follow these instructions and have...

    I am trying to follow these instructions and have downloaded the certificates file
    https://help.blackboard.com/Learn/Administrator/SaaS/Integrations/Direct_Data_Access
  8. Replies
    11
    Views
    5,285

    What do you mean by 'put the key file where the...

    What do you mean by 'put the key file where the JVM will find it'? I tried dropping the file into the data-integration\classes directory, but still get SSL errors. I know nothing about SSL and...
  9. I am not using any kind of repository, so I never...

    I am not using any kind of repository, so I never experienced the issues you describe. When I opened spoon the first time, I cancelled out of the connect to repository dialogue.
  10. I just wanted to update this with a note...

    I just wanted to update this with a note regarding PDI 7.1. Simply deleting the xml files does not work any more. You have to edit the 2 xml files and remove the entries inside them, but leave the...
  11. Replies
    8
    Views
    1,830

    I think it is really because it starts as a...

    I think it is really because it starts as a parameter and is turned into a field with a getVariables step. So it treats it as a question of whether or not the object exists regardless of what its...
  12. Replies
    3
    Views
    984

    This is what I did and it does not remember it...

    This is what I did and it does not remember it the next time which is why I am asking this question.
  13. Replies
    3
    Views
    984

    spoon run options

    When you run a job / transformation from spoon, the run options dialogue appears. I want to change the default behavior to use detailed for log level instead of basic. Where is the setting for...
  14. Replies
    11
    Views
    2,716

    that would be possible if all the tables were...

    that would be possible if all the tables were guaranteed to have a primary key field. There are quite a few that do not and we only do this on the source tables themselves. Like I said previously,...
  15. Replies
    8
    Views
    1,830

    It is a parameter that I am doing a getVariables...

    It is a parameter that I am doing a getVariables step to turn into a field. That may be what the issue is. Whenever I do an Alert() on it, it shows 'true' or 'false'.
  16. Replies
    3
    Views
    1,127

    We went from 4.3 to 6.1. Our biggest hurdle in...

    We went from 4.3 to 6.1. Our biggest hurdle in the process were changes to how PDI does code parsing. Some sql scripts worked fine in 4.3, but were broken in 6.1. Even variables in javascript...
  17. We also are using a filesystem repository. What...

    We also are using a filesystem repository. What we do is use eclipse with the SVN plugin to do versioning of the files. Have 3 different branches in version control: dev, test, production and we...
  18. Replies
    11
    Views
    2,716

    For us, we don't have the luxury of modifying...

    For us, we don't have the luxury of modifying tables at the source, so we are limited to doing full table copies every night. What we do is calculate a row hash at extract time and then diff using...
  19. Replies
    8
    Views
    1,830

    javascript if logic

    I have a variable called flag that I want to use in an if statement.

    When I do something like this:


    if(flag)
    {
    // do something
    }
  20. I believe marabu is correct. That is exactly the...

    I believe marabu is correct. That is exactly the behavior I am experiencing. I will have to work around this somehow (possibly with a reformat values). Thank you for all your help on tracking this...
  21. We are also using the JTDS 1.3 driver if that...

    We are also using the JTDS 1.3 driver if that matters.
  22. The date is a date in the create table statement....

    The date is a date in the create table statement. information_schema.columns says it is a 'date'. When I sample the table input step, it reports 'string' as it's type.

    17324

    Note the last...
  23. I am not doing any reformatting of the values. I...

    I am not doing any reformatting of the values. I have 2 table inputs that read from differing versions of the same table and then I send both data streams to a merge rows diff step. The output of...
  24. metadata wrong for date with table input step

    I am using PDI 6.1 CE and talking to MSSQL 2008. I have a table input step reading from a table with date fields. Pentaho is treating them as a string when I show output fields instead of keeping...
  25. Replies
    16
    Views
    2,148

    I found a solution is to pump all the fields...

    I found a solution is to pump all the fields through the 'add XML' step, then hash that. This will work as though there is a field separator being specified and solves the issues we discovered.
  26. Replies
    16
    Views
    2,148

    Thanks' for the help on this. At least you did...

    Thanks' for the help on this. At least you did cause me to look at that bug report again and see that it has not been fixed, so I will have to find a solution to the problem.
  27. Replies
    16
    Views
    2,148

    I misspoke on the last reply. The cast(tbl.* as...

    I misspoke on the last reply. The cast(tbl.* as text) does put it into comma separated form, so it will detect all the changes.
  28. Replies
    16
    Views
    2,148

    Initally I was worried about different values...

    Initally I was worried about different values being calculated, but you bring up a valid issue about how I was doing it in the DB. Here are a couple links that I found for discussing this:
    ...
  29. Replies
    16
    Views
    2,148

    I know. That's why I was initially having the...

    I know. That's why I was initially having the database calculate the hash.I thought http://jira.pentaho.com/browse/PDI-6698 this was fixed, but apparently not. Any ideas as to when it might be done?
  30. Replies
    16
    Views
    2,148

    I am using the 'add checksum step' as part of my...

    I am using the 'add checksum step' as part of my extract process to calculate the hash. Then I can make use of it everywhere else down the ETL process line.
  31. Replies
    16
    Views
    2,148

    In my scenario, it's fine that they are different...

    In my scenario, it's fine that they are different as long as I use the one PDI gives me everywhere. I am guessing it has something to do with how the database is concatenating all field values and...
  32. Replies
    16
    Views
    2,148

    Oracle? I didn't say PLSQL. I am using Postgres.

    Oracle? I didn't say PLSQL. I am using Postgres.
  33. Replies
    16
    Views
    2,148

    Have been off for Christmas, so just now getting...

    Have been off for Christmas, so just now getting back to this. Given my particular constraints, a row hash for CDC detection is actually the best way to do it. Dealing with over 600 tables a...
  34. Replies
    29
    Views
    5,556

    I understand what you are saying about...

    I understand what you are saying about configuration. In my scenario, both PDI and the database are on the same physical server. I have no network between them. I have the lookup field in a...
  35. Replies
    29
    Views
    5,556

    I am actually copying from Oracle and going to...

    I am actually copying from Oracle and going to MSSQL at the same rate as you. I have often wondered if it was simply a driver issue, but since we are talking to different RDBMS systems, it makes me...
  36. Replies
    29
    Views
    5,556

    I too am interested in this as I have only been...

    I too am interested in this as I have only been able to get about 4 r/s using an indexed integer field as the lookup value.
  37. Replies
    16
    Views
    2,148

    row hash md5, sha1

    Can someone explain why PDI gives me a different hash than what the database does (PSQL, MSSQL, etc) for the exact same row of data? I would expect the same data to yield the same hash no matter...
  38. I am having this same issue on Linux. I tried...

    I am having this same issue on Linux. I tried your solution to change file permissions, and it gets farther, but now I am getting this error:

    ERROR [BlueprintContainerImpl] Unable to start...
  39. The PSQL bit data type is not the same as...

    The PSQL bit data type is not the same as boolean. It really is a type to support a string or sequence of 0s and 1s aka a string of bits. If you want boolean, use it instead.
  40. Replies
    0
    Views
    671

    slow delete on MSSQL

    I have a simple transformation that reads the rows to be deleted from a PostgreSQL database, and then delete them from MSSQL. I am only getting about 8 rows a second on the delete step. Does anyone...
  41. Replies
    2
    Views
    1,203

    The first idea that comes to mind is to re-design...

    The first idea that comes to mind is to re-design the transformation in such a way as you can detect which rows are the 'I's and whcih ones are the 'U's. Then you can simply select based on that and...
  42. Try editing the spoon.bat file and adding a -D...

    Try editing the spoon.bat file and adding a -D opton to the line that starts with SET OPT = . . .

    SET OPT=%PENTAHO_DI_JAVA_OPTIONS% "-Djava.library.path=%LIBSPATH%" "-DMYSQL_HOST=servername"
    ...
  43. Replies
    2
    Views
    530

    Having done a similar project, a few years ago...

    Having done a similar project, a few years ago (with PDI 4.3), we basically had to extract out the logic of each DTS package and then translate that into PDI. There is no straight forward conversion...
  44. Replies
    2
    Views
    1,326

    Thank you for the example and explanation. It...

    Thank you for the example and explanation. It works now.
  45. Replies
    2
    Views
    1,326

    javascript compare dates

    I am trying to do a simple date comparison in a javascript step, but it always takes the else / false path. Can someone explain what is wrong?



    var dt = new Date();
    // add 4 seconds to the...
  46. Replies
    2
    Views
    1,000

    Thank you for the explanation. This is something...

    Thank you for the explanation. This is something I never understood before.
  47. Replies
    2
    Views
    1,000

    help understanding java memory usage

    I have a simple job / transformation setup and am trying to understand java memory consumption. 1 job executes 1 transformation with 2 steps in it -- table input -> table output. Both input /...
  48. See comments below.

    See comments below.
  49. It clears the list of results that a previous...

    It clears the list of results that a previous step within a job may have generated before the transformation is called. I use this to have a series of transformations in a job and each one is...
  50. you might want to look at this: ...

    you might want to look at this:

    http://www.pentaho.com/hitachi-data-systems-announces-intent-to-acquire-pentaho
Results 1 to 50 of 152
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.