Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 8 1 2 3 4

Search Forums: Search took 0.03 seconds.

  1. Replies
    5
    Views
    1,424

    There is also a possibility to LOAD TABLE from a...

    There is also a possibility to LOAD TABLE from a file on your local machine, assuming you have the proper client tools. Otherwise Sybase IQ and Pentaho are probably not a good mix since IQ's LOAD...
  2. Replies
    1
    Views
    459

    It depends entirely on the database engine.

    It depends entirely on the database engine.
  3. I don't understand your question. What I meant...

    I don't understand your question.
    What I meant is this. In a transformation, get the list of tables you want to stage (from a configuration file, or somehow derive this information from the DB...
  4. Pentaho doesn't have any special requirements...

    Pentaho doesn't have any special requirements from the OS it's running on. It runs on Java so you can pretty much run in on a toaster if you so desire. In your question, you seem to be mixing two...
  5. Try thinking in the direction of reusable,...

    Try thinking in the direction of reusable, metadata-driven transformations. Then maybe you can have one transformation running in multiple threads on different tables. Maybe you need to wrap a job...
  6. Replies
    1
    Views
    1,773

    In the end I solved it. There is a jQuery call...

    In the end I solved it.
    There is a jQuery call to /pentaho/plugin/saiku/api/load/plugin/plugins which for whatever reason fails on our environment. But the results are not used for anything, so the...
  7. Replies
    8
    Views
    1,039

    Click on the hop leading to the table output to...

    Click on the hop leading to the table output to disable it (will show as grey instead of black), then the table output will receive no rows to write to the database. Disable the "truncate" option in...
  8. Xaction logging is crap, but at the very least it...

    Xaction logging is crap, but at the very least it tells you that the problem is in the step where you call Kettle. So either this step is configured wrong, or the job failed, which you could see in...
  9. Are you sure it's not an infrastructure issue?...

    Are you sure it's not an infrastructure issue? Does the server have enough memory?
  10. Replies
    4
    Views
    687

    Not really strange, if the output format is a...

    Not really strange, if the output format is a COBOL style fixed file.
  11. Replies
    1
    Views
    1,648

    Yes, we have used the defaultRowPrefetch and...

    Yes, we have used the defaultRowPrefetch and performance was in the 10 000s of rows/s. In Spoon, where you configure the connection properties, on the Parameters tab put...
  12. Replies
    1
    Views
    693

    Pentaho server comes with its own Tomcat, you...

    Pentaho server comes with its own Tomcat, you don't have to install any. PRD is a standalone application and also doesn't need Tomcat.
  13. Replies
    1
    Views
    1,773

    Saiku Analytics plugin doesn't load

    We're trying to install Saiku Analytics on Pentaho server CE 8.0. Our production server uses a PostgreSQL back-end for its Jackrabbit, Hibernate and Quartz, CAS for single sign-on, and we access it...
  14. It could work as a subreport which inherits the...

    It could work as a subreport which inherits the query and then does a different grouping on it. If you can convince Report Designer to put in onto separate sheets.
  15. Pentaho uses Spring Security libraries, so it is...

    Pentaho uses Spring Security libraries, so it is possible to use your own authentication provider. But you will need a skilled developer with good knowledge of Spring Security and it will take some...
  16. Replies
    1
    Views
    470

    IE uses the enterprise compatibility settings by...

    IE uses the enterprise compatibility settings by default for all intranet websites. Have you tried disabling it for Pentaho? Also important: which Pentaho version do you have? Older versions do not...
  17. Replies
    1
    Views
    955

    Hi, for starters let's not confuse source...

    Hi, for starters let's not confuse source repositories like Git or SVN with repositories for the Kettle ETLs (file, database, "enterprise" repository on the server).
    My preferred setup is to use a...
  18. Replies
    8
    Views
    796

    I haven't used the Multiway merge join, but with...

    I haven't used the Multiway merge join, but with Merge join and string keys, ordering is important. Pentaho expects binary collation.
  19. Replies
    6
    Views
    879

    Add the city column to the first stream with a...

    Add the city column to the first stream with a constant/null value, then you can union the streams.
  20. Replies
    16
    Views
    3,852

    What is the speed (rows per second) of the Delete...

    What is the speed (rows per second) of the Delete step when you run it? You probably won't get much more than 1000-3000 r/s, but that could be sufficient if you have just a few million rows to...
  21. It should work with OpenJDK, but needs version 8.

    It should work with OpenJDK, but needs version 8.
  22. Replies
    3
    Views
    860

    And what exactly doesn't work? With PDI jobs it's...

    And what exactly doesn't work? With PDI jobs it's usually no problems, reports have to be opened and saved in the new version of PRD in order to work correctly on the server (but they often work...
  23. Replies
    9
    Views
    1,890

    Because the equality operator should be ==, not =.

    Because the equality operator should be ==, not =.
  24. Replies
    5
    Views
    1,838

    You don't have to "define" a variable explicitly....

    You don't have to "define" a variable explicitly. Once it's used, Kettle will look if the value is set anywhere (e.g. in Spoon at runtime, on the BI server using kettle.properties, in a previous job...
  25. Replies
    3
    Views
    958

    What does the server log say? Is the Kettle...

    What does the server log say? Is the Kettle transformation deployed in the repository as well, in the correct folder?
  26. Replies
    5
    Views
    1,272

    Download, unpack, run start-pentaho.sh? Then...

    Download, unpack, run start-pentaho.sh?
    Then there are of course some advanced configuration steps like setting up the database back-end for Jackrabbit and Quartz, but you can find some instructions...
  27. The button to the right of the page selection...

    The button to the right of the page selection should show or hide the parameter panel. If that doesn't do anything, it looks like a Chrome issue rather than a Pentaho issue.
  28. You should keep your transformations in a version...

    You should keep your transformations in a version control system like Subversion or Git, and deploy them to the production environment the same way as when you create a development environment on...
  29. I haven't tried this specifically on Postgres,...

    I haven't tried this specifically on Postgres, but I think you have to define the parameter as a multivalue list, then maybe hide it from the user and fill it using a MultiValueQuery formula?
  30. Replies
    5
    Views
    2,002

    When you run the transformation in Spoon, look at...

    When you run the transformation in Spoon, look at the Step Metrics tab, specifically at the input/output column. If the Table input is the bottleneck, it will show low numbers (100/100) for all...
  31. Each developer should work on their local...

    Each developer should work on their local machine, and you should have a defined process of deploying kjb/ktr files to the production machine. In these regards it should be the same as any other...
  32. Replies
    1
    Views
    597

    Hello Srikan, did you migrate those reports from...

    Hello Srikan, did you migrate those reports from a previous version, or create them? Is is the report generation that takes long, or does it take long to show the parameter prompts?
  33. What you're seeing is either a string...

    What you're seeing is either a string representation of a binary file or the file encoded as base64. There are standard Java libraries for handling base64 and you can write it out to a file, again...
  34. Hmm, so what else... The "Add id" step, does it...

    Hmm, so what else... The "Add id" step, does it generate a sequence in Pentaho or does it use a database sequence? (Still, that would just cause it to be slow but not get progressively slower)
  35. Does the target table in the database have...

    Does the target table in the database have indexes?
  36. Replies
    4
    Views
    3,504

    If you add the JDBC driver to the lib folder,...

    If you add the JDBC driver to the lib folder, then you should be able to use Generic database connection with the proper class name and JDBC connection string.
  37. Replies
    16
    Views
    1,309

    The preview button of the Table input doesn't...

    The preview button of the Table input doesn't work in this case, because the parameters are not supplied. That only happens when you execute the transformation and then you can see some rows in the...
  38. I'm not aware of the possibility. On my previous...

    I'm not aware of the possibility. On my previous project we generated some reports as a batch and we used PDFbox (a Java library) to join multiple PDFs into one file. I don't know the specifics, but...
  39. Clearing the result fields in Javascript step

    Hi guys, the UDJC step has a handy option to clear the result fields, meaning, the step will only output whatever fields you defined in it and drops everything that comes in. Do you know if there is...
  40. Replies
    4
    Views
    2,901

    For parsing JSON, I recommend you look either at...

    For parsing JSON, I recommend you look either at the JSON Input step (already mentioned) or the Modified Java Script Value, because Javascript has some native JSON-parsing utilities you can use.
  41. Replies
    3
    Views
    709

    We have some ETLs implemented which load data...

    We have some ETLs implemented which load data from a user-provided Excel (so the original poster could do the same, but use the ETL as a report datasource), but this Excel has to be put at an exact...
  42. Thread: PRD Parameters

    by Lukfi
    Replies
    3
    Views
    752

    query_name is the name of a table in the database?

    query_name is the name of a table in the database?
  43. Ah, I saw your post a few days back and wanted to...

    Ah, I saw your post a few days back and wanted to reply, but for some reason my account was blocked at the time. I wanted to suggest using the built-in HSQL database...
  44. You can make a transformation which "copies to...

    You can make a transformation which "copies to result" the parameters, then pass it to the job's parameters and setting it to "Execute for every input row".
  45. No, Kettle is not dropping the fields. What the...

    No, Kettle is not dropping the fields. What the SQL button does is, it looks at the columns you've specified in the steps and tells you the DDL which you would need to run to create such a...
  46. 1) I agree this depends on the overall design. In...

    1) I agree this depends on the overall design. In my last project we used calculated dimension keys so we didn't need lookups, and we assigned the key during staging, so data from the staging area...
  47. I would recommend not using Sort Rows at all (or...

    I would recommend not using Sort Rows at all (or only for "presorted" sets) unless you absolutely have to because it has to load all rows into memory/temp, and instead do the sorting on the database.
  48. If you want to trigger an error from inside a...

    If you want to trigger an error from inside a transformation, use the Abort step. (Although, depending on how you're running it, Jenkins may not pick it up - we had this problem with Bamboo that...
  49. In this case I'd go with the Xeon. It has 6...

    In this case I'd go with the Xeon. It has 6 physical cores but 12 threads thanks to HT, while the Opteron has 16 physical cores. PDI is very parallel, but also there are situations where one step is...
  50. Replies
    3
    Views
    1,544

    This can happen because the Apache libraries used...

    This can happen because the Apache libraries used for reading XLSX load the whole data set into memory. Newer versions of Pentaho (5.4 and newer?) have a "streaming" option, but I'm not sure if it...
Results 1 to 50 of 364
Page 1 of 8 1 2 3 4
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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