Hitachi Vantara Pentaho Community Forums

Search Forums:

Type: Posts; User: Nishank Goel; Keyword(s):

Page 1 of 2 1 2

Search Forums: Search took 0.03 seconds.

  1. Getting Error while opening pentaho 8 with Java 8.

    Hi All,

    Any help will be appreciated !!!

    I am getting error while running spoon.bat file with java 8 version.
    Below is the error which I will be getting.
    Error: unable to access jarfile
    ...
  2. Thanks Gutlez for the response. Yes tried with...

    Thanks Gutlez for the response.

    Yes tried with Oracle SQL Developer. Getting the below error. :(

    Status : Failure -Test failed: [Cloudera][HiveJDBCDriver](500164) Error initialized or created...
  3. Same error getting in oracle sql server while...

    Same error getting in oracle sql server while connecting with Hive DB.
    Not sure what is the issue.
  4. Error connecting to database [Hive]...

    Error connecting to database [Hive] :org.pentaho.di.core.exception.KettleDatabaseException:
    Error occurred while trying to connect to the database


    Error connecting to database: (using class...
  5. Not able to connect Hive with Pentaho Table Input.

    Hi All,

    I am trying to connect hadoop cluster (hive) with pentaho DI 7th version but not able to connect.
    Can any one tell me that is there any jar required to copy from web in order to connect...
  6. How much is the preferred configuration for a...

    How much is the preferred configuration for a json file of size 400 MB ?
  7. Pentaho JSON Input : GC Overhead Error

    Hi Folks,

    I am trying to load a json file of 400MB using petaho DI version 6. But getting GC overhead error. This error occurs when pentaho trying to load the whole file in one go. I have also...
  8. Thanks for your assistance. I have tried and...

    Thanks for your assistance.

    I have tried and able to do it now.
  9. Can some one help me with SCD 2 in pentaho

    Hi All,

    Can someone send me the pentaho sample to implements SCD2 using dimension lookup step.


    Many Thanks,:confused:
    Nishank
  10. Replies
    0
    Views
    561

    Tutorial #2 : PDI

    https://www.youtube.com/watch?v=AZns-PjfeL4
  11. Replies
    0
    Views
    948

    cfgbuilder - Warning

    cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp


    Is there any way we can get rid of this warning in pdi?

    Thanks...
  12. Hi, I have tried to re-execute the job but it...

    Hi,

    I have tried to re-execute the job but it is not resolved. I have set it to 3 gigabytes but the things not looks like resolve. Getting the same error " Java heap space ".
    Can you help more...
  13. Thanks Isha for the help !!!

    Thanks Isha for the help !!!
  14. Error!!! Java Heap space and GC overhead limit exceed.

    Can anyone help me to identify if these both the errors are same or different ?

    How to resolve these errors in Pentaho.

    Many thanks in advance.

    G_nish

    -------------------------------...
  15. Thanks for your response Gutlez... This issue...

    Thanks for your response Gutlez...

    This issue is resolved while re-run the job.

    Actually the error line:

    2017/01/05 00:07:21 - Set variables - ERROR (version 5.0.1-stable, build 1 from...
  16. Getting error while setting the variable value from Parameter.

    Hi,

    Can someone help me to why I am getting this sort of error.

    XML file [file:///etljobs/wealth-marketing/email-growth/AddMissingAdvisersFromFirmAllocation.ktr]
    2017/01/05 00:00:38 -...
  17. Replies
    10
    Views
    2,058

    Just seen the attached sample got the pain point...

    Just seen the attached sample got the pain point !!!

    Thanks alot !!!
  18. Replies
    10
    Views
    2,058

    This is similar to previous issue: ...

    This is similar to previous issue:

    http://forums.pentaho.com/showthread.php?85857-JSON-Input-Step-Error-quot-We-MUST-have-the-same-number-of-values-for-all-paths-quot

    I have used with dated =...
  19. Replies
    10
    Views
    2,058

    Hi Marabu, I have tried in the similar fashion...

    Hi Marabu,

    I have tried in the similar fashion as you have mentioned:

    In place of
    dated = $.dated and code = $.code with option "Ignore missing path" enabled
    I am using double dots dated =...
  20. Replies
    10
    Views
    2,058

    Hi Marabu, Is there a way to handle the...

    Hi Marabu,

    Is there a way to handle the missing fields inside the block like:




    gazettes: [
  21. Replies
    1
    Views
    826

    Error occur while using Z/OS step

    Hi,

    I am getting error while using Z/OS plugin in pentaho 6.0.1 version in my window7 Machine with Java version 1.7
    It works perfectly fine on pentaho 5.0.1.
    Below is the error I am getting...
  22. Replies
    10
    Views
    2,058

    Yes this is something which I have done...

    Yes this is something which I have done previously.

    Thanks :)
  23. Replies
    10
    Views
    2,058

    Thanks a lot marabu.....For your wild guess. :) ...

    Thanks a lot marabu.....For your wild guess. :)

    I am thinking what should happen with this if this particular field (gazette) is missing.

    Thanks,
    g_nish
  24. Replies
    10
    Views
    2,058

    Json Query

    Hi,

    Can we extract first occurrence from the json file. Here I am using json input step:
    The structure is like:


    gazettes: [

    {
  25. As pentaho 6 is working on java 7+ but pentaho 7...

    As pentaho 6 is working on java 7+ but pentaho 7 req. java 8+

    Can I run both the pentaho version on same machine ?

    Thanks,
    Nishank
  26. Thanks for your response and I am trying with...

    Thanks for your response and I am trying with java 8+
  27. Getting error while lauching the all new pentaho 7

    Hi All,

    I am getting error while launching pentaho 7th version. This error is Java related
    Screenshot attached PFA.

    1738517385
  28. Replies
    7
    Views
    2,678

    Hi Adamnyc, Thanks for your reply. I need...

    Hi Adamnyc,

    Thanks for your reply.

    I need to validate date which is expected to be in format yyyy-mm-dd, if the date is not a valid date then I need to make it <null> using javascript.
    ...
  29. Replies
    7
    Views
    2,678

    How to validate date using Javascript.

    Hi,

    Is it possible to validate date in specified format using Javascript ?

    Thanks,
    g_nish
  30. Replies
    11
    Views
    2,917

    Hi Gultez, Not a problem. I am able to do...

    Hi Gultez,

    Not a problem.

    I am able to do it by try and run.

    Thanks,
    g_nish
  31. Replies
    11
    Views
    2,917

    Yes I have tried but not able to create. Can you...

    Yes I have tried but not able to create. Can you help me in generating key?
  32. Replies
    11
    Views
    2,917

    Hi Mick, Can we generate Name key field...

    Hi Mick,

    Can we generate Name key field present under second table from first table mentioned in the previous query ?

    Thanks,
    g_nish
  33. Hi Marabu, can you help me in sorting this...

    Hi Marabu,

    can you help me in sorting this out.

    http://forums.pentaho.com/showthread.php?208482-Want-to-convert-Rows-to-column

    Thanks in advance.
    g_nish
  34. Replies
    11
    Views
    2,917

    Hi Gultez, Thanks for your productive...

    Hi Gultez,

    Thanks for your productive response.

    But I dn't have Name key Field to de-normalize. Can we generate it ?

    Can you show me one sample.
  35. Replies
    11
    Views
    2,917

    Hi Gultez, Thanks for your quick response on...

    Hi Gultez,

    Thanks for your quick response on this.

    The logic which you have suggested in the last attached example is not working due to another scenario identified in the file.
    The Pain point...
  36. Replies
    11
    Views
    2,917

    can we run a loop in Pentaho using java?

    Hi I want to know can we execute java/javascript to generate key like

    Input is:



    Data
    Value
  37. Replies
    11
    Views
    2,917

    Want to convert Rows to column.

    Hi,

    Can anyone help me in building the logic in which I have to convert rows to column.
    Please check the attached file it is not simple as it looks in query.

    I have created sample input and...
  38. Query on XML Input Stream (StAX) Parsing

    Input file is :


    <Import>
    <Name>abc</Name>
    <Address>pqr</Address>
    <Phone></Phone>
    </Import>
  39. Replies
    1
    Views
    615

    Removed*********

    ********Removed*************
  40. Replies
    0
    Views
    516

    How to add header in Text output.

    Hi,

    I want to know how we get header field in text output step.

    Note: I am using append operation in the text output file.

    Thanks in advance.
    g_nish ;)
  41. Thanks Marabu This helps me to get the...

    Thanks Marabu

    This helps me to get the expected result.
  42. Want to generate key in for Denomaliser.

    Hi,

    I have to denomalise the row to column:
    Below is the data I have:



    DATA
    VALUE
  43. cfgbuilder : Warning message in PentahoDI 6.0.1

    Hi,

    I am getting warning message in Pentaho transformation:

    Below is the warning:

    cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration...
  44. How to use http post step to read data from server with Base64 Authentication.

    Hi,

    I want to know how to use http post step in pentaho to read the data from server ... Note: the authentication is in base64 (UTF8) and the content-type is Json.

    Error I am getting is...
  45. Replies
    1
    Views
    450

    How to drop a table using Pentaho?

    I want to know can we drop a table in pentaho?

    How?

    Please help.


    Thanks,
    Nishank
  46. Can you please recheck the regex it gives me...

    Can you please recheck the regex it gives me error.
  47. And my non printing char is handling in input...

    And my non printing char is handling in input step using encoding UTF-16.

    Thanks for your continuous help over this issue.
  48. I think you have attached blank ktr. Can you...

    I think you have attached blank ktr. Can you please recheck.:confused:
  49. Getting error while using this RE: Unknown...

    Getting error while using this RE:


    Unknown character property name {print} near index 11
    [(^\p{print}]*)$

    dnt know y?
  50. [(^\p{print}]*)$ this is the regex u have given...

    [(^\p{print}]*)$ this is the regex u have given me as a new user I dont know how to search for that particular non printing value.Is there some ascii value required? Can you give me example on this?...
Results 1 to 50 of 93
Page 1 of 2 1 2
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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