linux运行kettle遇到问题汇总

1、把本地的repositories.xml 放在跟目录

2、配置机台名解析

vi /etc/hosts

bogon是服务器名字，根据实际情况修改

3、指定内存和字符集

  vi  spoon.sh

-Xms1024m -Xmx2048m -Dfile.encoding=UTF-8

4、执行kettle job

./kitchen.sh /rep pg_kettle /user admin /pass admin -dir=/bingtest -job=aa_convert_job

5、不打印info类日志

方式1

./kitchen.sh /rep pg_kettle /user admin /pass admin -dir=/bingtest -job=aa_convert_job 2>&1 |grep -v ':INFO:' 方式2

./kitchen.sh /rep pg_kettle /user admin /pass admin -dir=/bingtest -job=aa_convert_job 2>&1 |grep -v ':INFO:' |grep -v 'RepositoriesMeta' |grep -v 'lockAcquired'

方式3

new_uuid=$(uuidgen) logFilePath = "/usr/local/kettle/output_$new_uuid.log" execResult=0 ./kitchen.sh /rep pg_kettle /user admin /pass admin -dir=/bingtest -job=aa_convert_job 2>&1 |grep -v ':INFO:' |grep -v 'RepositoriesMeta' |grep -v 'lockAcquired' > $logFilePath cat $logFilePath if grep -q "ERROR" $logFilePath then     execResult=1 fi rm -f $logFilePath exit $execResult

powershell方式

$uuid = [guid]::NewGuid() $logFilePath = "D:\logfile_$uuid.log" $execResult=0 [Console]::OutputEncoding = [System.Text.Encoding]::UTF8  .\Kitchen.bat /rep pg_kettle /user admin /pass admin -dir=/bingtest -job=aa_convert_job > $logFilePath $commands = Get-Content -Path $logFilePath  -Encoding Default Write-Host $commands if ($commands -match "ERROR") {     $execResult=1 }  Remove-Item -Path $logFilePath Write-Host "运行结果 $execResult" exit $execResult

6、集成xxljob命令

execResult=$? echo "运行结果：$execResult" exit $execResult

power shell

Write-Host "运行结果:$LastExitCode" exit $LastExitCode