代码之家  ›  专栏  ›  技术社区  ›  Jack BeNimble

Pentaho Kettle-批处理脚本不产生输出

  •  1
  • Jack BeNimble  · 技术社区  · 14 年前

    我写了一个非常简单的pentaho水壶脚本,当我从spoon ide启动它时,它工作得很好。它接受一个csv文件并将其写入文本文件和xml文件。但是,如果我使用pan.bat将其作为批处理作业运行,它不会创建或更新它应该创建或更新的任何一个文件。我将它作为xml运行(而不是通过存储库)

    下面是命令:

    C:\test\data-integration>pan.bat /file ./demo/hello.ktr /level:Basic
    

    以下是输出:

    INFO  24-11 13:18:43,765 - Using "C:\DOCUME~1\mcd\LOCALS~1\Temp\vfs_cache" as te
    mporary files store.
    INFO  24-11 13:18:44,156 - Pan - Pan
    INFO  24-11 13:18:44,156 - Pan - Pan
    INFO  24-11 13:18:44,312 - hello - Dispatching started for transformation [hello
    ]
    INFO  24-11 13:18:44,343 - hello - This transformation can be replayed with repl
    ay date: 2010/11/24 13:18:44
    INFO  24-11 13:18:44,343 - File with Greetings - Opening output stream in encodi
    ng: UTF-8
    INFO  24-11 13:18:44,375 - CSV file input - Header row skipped in file 'file:///
    C:/test/data-integration/demo/list.csv'
    INFO  24-11 13:18:44,375 - CSV file input - Finished processing (I=7, O=0, R=0,
    W=6, U=0, E=0)
    INFO  24-11 13:18:44,593 - Greetings - Finished processing (I=0, O=0, R=6, W=12,
     U=0, E=0)
    INFO  24-11 13:18:44,593 - File with Greetings - Finished processing (I=0, O=6,
    R=6, W=6, U=0, E=0)
    INFO  24-11 13:18:44,593 - Text file output - Finished processing (I=0, O=7, R=6
    , W=6, U=0, E=0)
    INFO  24-11 13:18:44,593 - Pan - Pan
    INFO  24-11 13:18:44,593 - Pan - Pan
    INFO  24-11 13:18:44,593 - Pan - Pan
    INFO  24-11 13:18:44,609 - hello -
    INFO  24-11 13:18:44,609 - hello - Step CSV file input.0 ended successfully, processed 6 lines. ( - lines/s)
    INFO  24-11 13:18:44,609 - hello - Step Greetings.0 ended successfully, processe
    d 12 lines. ( - lines/s)
    INFO  24-11 13:18:44,609 - hello - Step File with Greetings.0 ended successfully
    , processed 6 lines. ( - lines/s)
    INFO  24-11 13:18:44,609 - hello - Step Text file output.0 ended successfully, p
    rocessed 6 lines. ( - lines/s)
    

    这应该会创建/更新几个文件,但什么也不会发生。有什么想法吗?

    1 回复  |  直到 14 年前
        1
  •  2
  •   Jack BeNimble    14 年前

    问题解决了-输出指向的目录与我想象的不同。我肯定已经更正了,但我必须将更改输入到原始文件,而不是我正在使用的文件。除非你需要,否则不要复印。

    推荐文章