Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Search Forums: Search took 0.02 seconds.

  1. Replies
    2
    Views
    1,359

    Hi, I filed a jira for this and attached a...

    Hi,

    I filed a jira for this and attached a patch. http://jira.pentaho.com/browse/PDI-5007

    - Youngwoo
  2. Replies
    13
    Views
    2,258

    Hi Maria, It's very odd. but I can say that...

    Hi Maria,

    It's very odd. but I can say that the ja text are valid japanese.

    I verified, Inserting the ja text into Oracle(10g), MySQL(5.5) and Greenplum(3.x) table works fine for me.

    -...
  3. Replies
    1
    Views
    1,547

    Hadoop file output, Enclosure issue.

    Hi,

    When I delete enclosure on HFO step(no enclosure), I got an error like below. To avoid this error I had to specify a enclosure. for e.g., '"'

    Youngwoo

    5979
  4. Replies
    4
    Views
    3,826

    Hi Fleming, I believe it's possible to...

    Hi Fleming,

    I believe it's possible to implement kettle plugin using HDFS java API. and there is a workaround for this.
    Sqoop(http://www.cloudera.com/developers/downloads/sqoop/) and...
  5. Hi Emmanuel, Try to use Java script step for...

    Hi Emmanuel,

    Try to use Java script step for converting data.

    Sample JS code:



    Regards,
    Youngwoo
  6. Hi D, ...

    Hi D,

    http://code.google.com/p/power-architect/

    p*a is a opensource data modeling tool and it provides basic features that you needed.

    Regards,
    Youngwoo
  7. Replies
    4
    Views
    1,318

    Hi ysabbah, ...

    Hi ysabbah,

    http://wiki.pentaho.com/display/EAI/Modified+Java+Script+Value

    See the Martin Vlcek's comment.

    Regards

    Youngwoo
  8. Replies
    6
    Views
    2,365

    Hi vlr, You can check or un-check the options...

    Hi vlr,

    You can check or un-check the options -- 'Fail on warning' and 'Fail on error'.


    Youngwoo
  9. FYI: Korean PDI coummunity documentation and Forum for Korean speaking members

    Hi,

    Latest Pentaho Data Integration (aka Kettle) Documentation (Korean): http://wiki.pentaho.com/display/EAIko/

    International Group for Korean members:...
  10. Sticky: Pentaho Data Integration (Kettle) 한글 커뮤니티 문서

    안녕하세요,

    Pentaho Data Integration (Kettle) 프로젝트의 한글 커뮤니티 문서를 위한 공간이 생성되었습니다.

    http://wiki.pentaho.com/display/EAIko/

    관심있는 분들의 많은 참여를 기대합니다. 현재 한글 문서화(번역)를 진행하고 있는 참여자는 아래와 같습니다.

    * 김영우
    * 김정대
  11. Sticky: Pentaho 한국어 커뮤니티 포럼입니다.

    안녕하세요, 김영우입니다.

    Pentaho 한국어 커뮤니티 포럼에 오신 것을 환영합니다!

    본 포럼은 Pentaho 프로젝트 (BI, Data Integration, Reporting ...)에 대한 사용, 문서화, 개발 관련 이슈들의 정보를 교환하고 토론하기위한 공간입니다.

    커뮤니티 참여자, 여러분의 많은 관심과 참여를 기대합니다.
    ...
  12. Hi meenaiyer, I did work that similar to your...

    Hi meenaiyer,

    I did work that similar to your case. in my case,
    DMBS is Oracle and PDI's version is 3.1 RC1.

    I try it using Combination lookup/update and Update step.
    first time, I got a...
  13. Replies
    18
    Views
    4,452

    Simple Dimension Lookup/Update

    Hi DEinspanjer,

    That is just what I want. :)

    Regards,
    -yw kim.
  14. Replies
    3
    Views
    2,255

    Hi Sven, My question was not specific. :-) ...

    Hi Sven,

    My question was not specific. :-)

    I mean the 'code', these are 'Ctrll + character' combinations.

    for e.g., Ctrl + a = ascii(1)

    thanks,
    yw kim.
  15. Replies
    3
    Views
    2,255

    ASCII Code as Delimiter?

    Hi.

    Is it possible to use 'Ascii code' as delimiter in 'Text Input', 'CSV Input', 'Split Fields' step?

    For now, only characters or 'TAB' are allowed.

    Thanks.

    -yw kim.
  16. In my case,

    Hi,
    Check out this thread: http://forums.pentaho.org/showthread.php?t=61792

    and I just set the TK with 1 when lookup key is null. This is Pedro's solution.

    Regards,

    yw kim.
  17. Replies
    3
    Views
    1,178

    Hi Sven. Thanks for your reply. We are...

    Hi Sven.

    Thanks for your reply.



    We are focusing on user's contents. especially the posts, tags(a sort of keywords).
    I agree that the 'tag dimension' useless for reporting blog's usage.
    ...
  18. Replies
    3
    Views
    1,178

    'fact-dimensional' design & implementation

    Hi,

    We have a blog service. Blog posts data are like below...

    postid, userid, contents, tags...

    I'm trying to ETL for our DW.

    My problem is 'tags'. It's multi-valued. so I think It...
  19. OK

    Matt,

    I'm clear with this issue and I understand the change.

    Would you like to give me some advice?

    I'd like to build 'typical ip address dimension' using 'Dimension insert/update' step.
    ...
  20. Matt,

    Matt,

    You know, I do agree with your opinion(or strategy).

    but my point is not about 'SCD'.

    and my point is 'different result' between 3.0.3 and 3.1.0-M2 with same step(dimension...
  21. screenshots

    Hi Matt,

    I attached screenshots of each cases.

    http://jira.pentaho.com/browse/PDI-1226

    Thanks.

    YW Kim.
  22. 'Dimension lookup/update' step problem on Kettle 3.1.0-M2

    Hi,

    A transformation, but different results with Kettle 3.0.3 and Kettle 3.1.0-M2.

    I think,
    'Dimension insert/update' step on Kettle 3.1.0-M2 can't handle 'SCD 1', when the lookup values are...
  23. Replies
    1
    Views
    1,272

    Mondrian and SAS OLAP Server

    Hi everyone,

    I'm looking for the way, how can I configure Mondrian to use 'SAS OLAP Server' as an XML/A source??

    Thanks.

    yw kim.
  24. Replies
    2
    Views
    1,006

    Matt, I send you an email. Thanks. ...

    Matt,

    I send you an email.

    Thanks.

    Regards,
    yw kim.
  25. Replies
    2
    Views
    1,006

    commit translation (ko_KR, Korean)

    Hi,

    I've been translating kettle messages, ko_KR. This is Korean.

    How can I commit(apply) translation?

    Thanks.

    Regards,
    yw kim.
  26. Replies
    5
    Views
    1,629

    Hi Sven, I downloaded 3.1.0 M1 source and I...

    Hi Sven,

    I downloaded 3.1.0 M1 source and I build Kettle 3.1.0-M1.

    I can find 'get data from xml' step.

    I can not find any samples or docs.

    so, Would you like to show me a example?
  27. Replies
    5
    Views
    1,629

    Hi Sven. Thanks for your quick reply. Can I...

    Hi Sven.

    Thanks for your quick reply.

    Can I download nightly build?? or wait for 3.1 GA??

    Thanks.

    Regards,
    yw kim.
  28. Replies
    5
    Views
    1,629

    how can I parse a XML-Text-Field in a row?

    Hi,

    I would like to parse a XML-Field in a row.

    In my case,

    I have a 'String' Field. This filed is look-up result from HTTP lookup.

    This 'HTTP lookup' returns xml text as a result.
  29. fixed.

    Please ignore my first post.

    I modified the code like below...



    var rt = str2date("08/Jan/2007:00:00:00", "dd/MMM/yyyy:HH:mm:ss", 'EN');
    Alert(rt);
  30. 'Modified Java Script Value' step, str2date() function error.

    Hi,

    This is my javascript code.


    var rt = str2date("08/Jan/2007:00:00:00", "dd/MMM/yyyy:HH:mm:ss");
    Alert(rt);


    when I run 'Test Script' then returns 'Test Failed'.
  31. Replies
    2
    Views
    3,620

    thanks, sboden.

    Hi, sboden.

    It's solved.

    2) switch on 'execute for each row'

    and then, It works fine.

    It's my fault, not bug.
  32. Replies
    2
    Views
    3,620

    Table Input with Replace Variables

    Hi,

    I got a problem with Table Input step.

    This is my test transformation,

    'Excel input' -> 'Table Input' with replace variable -> ...

    my environment is...
    1) kettle 3.0.1
  33. Question related 'lazy conversion' on 3.0.0GA

    Hi, kettle users.

    on 'table input' step,
    I tried 'preview' rows after checking 'enable lazy conversion'.
    I can see 'broken' strings.
    but I tried after un-checking 'enable lazy conversion'
    I...
  34. Replies
    6
    Views
    2,344

    http://jira.pentaho.org/browse/PDI-428

    Hi,

    http://jira.pentaho.org/browse/PDI-428

    regards,
    yw kim.
  35. Replies
    26
    Views
    6,749

    scheduling job on linux

    Hi nitinsethi.

    in my case,

    first. I made a Linux account for kettle. e.g., 'kettle'

    and Installed(just unzip!) kettle.

    I modified 'kettle' user's default profile for kettle's environment...
  36. Replies
    6
    Views
    2,344

    Sven,

    Hi Sven,

    I'm using Linux (RHEL 4) and JDK 1.5
    It's a dedicated ETL server. At design time, I'm using Windows XP.

    Job was excuted by kitchen.sh(linux)

    so,

    I made transformation and job...
  37. Replies
    6
    Views
    2,344

    logs on 2.5.2

    Hi Sven,

    Here are logs on 2.5.2


    2007/11/05 00:25:30 - Set Variables.0 - Starting to run...
    2007/11/05 00:25:30 - Generate Rows.0 - Starting to run...
    2007/11/05 00:25:30 - Generate Rows.0 -...
  38. Replies
    6
    Views
    2,344

    FTP entry error on RC2

    Hi everyone.

    I upgraded from 2.5.2 to 3.0.0 RC2.

    I got a problem on 'FTP' job entry.


    INFO 05-11 00:05:28,487 (JobEntryFTP.java:execute:423) -Started FTP job to 10.10.109.126
    INFO 05-11...
  39. execute oracle stored procedure in 'SQL' job entry

    Hi everyone.

    I want to execute my oracle sp in SQL job entry.

    I tried like this ...

    'exec my_orcle_sp;'

    but,
  40. DB Connection's 'SQL' Tab (Upgrading from 2.5.1 to 3.0 RC1)

    Hi, everyone

    I upgraded from kettle 2.5.1 to 3.0 RC1.

    I found strange issue.

    on DB connection's 'SQL' tab,
    The values are filled with 'set sql_mode := ''' automatically.

    maybe a bug??
  41. :-)

    Thanks Sven.

    I can see my mistake on using '\'. :D

    Regards,
    warwithin
  42. Question about 'Regex on Modified JS value'

    Hi,

    I'm running PDI 2.5.1

    I got a question about regex.

    This is my modified sample code.


    var strToMatch = "^[mytag]1234";
  43. Replies
    13
    Views
    3,112

    build_version.txt

    Hi, sboden.

    I got same error message. like '.... build_version.txt ...'

    I checked kettle.jar(2.5.1) there is no build_version.txt file in kettle.jar

    I remember that 2.5 version's kettle.jar...
  44. Replies
    5
    Views
    3,425

    :-)

    Hi,

    OK

    first, I'm not a Talend Guy :-)

    and my favorate ETL tool is 'PDI' (more than Talend?? YES!! :-) )

    but,
  45. Replies
    5
    Views
    3,425

    PUT file via FTP (not SFTP)

    Hello, I'm Youngwoo Kim.

    then,

    Is there any way to put files via FTP (not SFTP) ??

    It's so useful FTP 'PUT' method. and I have seen this feature on Talend Data Studio.

    Thanks.
  46. Replies
    8
    Views
    2,711

    Nice work.

    Hello DEinspanjer.

    I tested your plugin.

    first step is text input. and then, split field to rows step, finally There is text out step.

    It works fine. :)

    Thanks.
  47. "Rows to Columns" Implementation Question.

    Hello,

    I'm trying to implement "Rows to Cols".

    i got a text file, like this
    --------------------------------
    ^[Start]
    ^[field1] field_value_1
    ^[fileld2] field_value_2
    ^[End]
  48. Thread: split rows

    by warwithin
    Replies
    2
    Views
    1,062

    It works :-)

    Thanks sharko_23

    It works.

    Thanks for your help again.


    warwithin.
  49. Thread: split rows

    by warwithin
    Replies
    2
    Views
    1,062

    split rows

    Hello,

    I want to split rows like this,

    rows
    --------------
    my_str_field
    --------------
    a,b
    c,d,e
Results 1 to 49 of 49
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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