kettle linux 界面,在非图形界面的linux下部署kettle并使用示例

kitchen.sh

Options:

-rep = Repository name

-user = Repository username

-pass = Repository password

-job = The name of the job to launch

-dir = The directory (dont forget the leading /)

-file = The filename (Job XML) to launch

-level = The logging level (Basic, Detailed, Debug, Rowlevel, Error, Nothing)

-logfile = The logging file to write to

-listdir = List the directories in the repository

-listjobs = List the jobs in the specified directory

-listrep = List the available repositories

-norep = Do not log into the repository

-version = show the version, revision and build date

-param = Set a named parameter =. For example -param:FILE=customers.csv

-listparam = List information concerning the defined parameters in the specified job.

-export = Exports all linked resources of the specified job. The argument is the name of a ZIP file.

-custom = Set a custom plugin specific option as a String value in the job using =, for example: -custom:COLOR=Red

-maxloglines = The maximum number of log lines that are kept internally by Kettle. Set to 0 to keep all rows (default)

-maxlogtimeout = The maximum age (in minutes) of a log line while being kept internally by Kettle. Set to 0 to keep all rows indefinitely (default)

[root@WL-APP-001 data-integration]# ./kitchen.sh -rep:product-id -job:./skap/test-skap -level:Basic -logfile:/data/wonhigh/kettle.log

2014/07/17 10:03:52 - Kitchen - Logging is at level : 基本日志

2014/07/17 10:03:52 - Kitchen - Start of run.

2014/07/17 10:03:52 - RepositoriesMeta - Reading repositories XML file: /usr/local/wonhigh/o2o/data-integration/.kettle/repositories.xml

2014/07/17 10:03:54 - ./skap/test-skap - 开始执行任务

2014/07/17 10:03:54 - ./skap/test-skap - 开始项[coloth_t-skap-i2]

2014/07/17 10:03:54 - coloth_t-skap-i2 - Loading transformation from repository [coloth_t-skap-i2] in directory [/skap]

2014/07/17 10:03:54 - coloth_t-skap-i2 - 为了转换解除补丁开始 [coloth_t-skap-i2]

2014/07/17 10:03:54 - coloth_t-output.0 - Connected to database [I2STG] (commit=1000)

2014/07/17 10:04:17 - coloth_t.0 - Finished reading query, closing connection.

2014/07/17 10:04:17 - coloth_t.0 - 完成处理 (I=34786, O=0, R=0, W=34786, U=0, E=0

2014/07/17 10:04:25 - coloth_t-output.0 - 完成处理 (I=0, O=34786, R=34786, W=34786, U=0, E=0

2014/07/17 10:04:25 - ./skap/test-skap - 完成作业项[coloth_t-skap-i2] (结果=[true])

2014/07/17 10:04:25 - ./skap/test-skap - 任务执行完毕

2014/07/17 10:04:25 - Kitchen - Finished!

2014/07/17 10:04:25 - Kitchen - Start=2014/07/17 10:03:52.683, Stop=2014/07/17 10:04:25.704

2014/07/17 10:04:25 - Kitchen - Processing ended after 33 seconds

注：在无UI界面的情况下要使用集群必须以job为入口，在job的配置中设置