Linux下安装kettle及作业调度

#前提jdk环境已完成安装，最好1.8以上版本
[my@Hadoop102 .kettle]$ java -version
java version "1.8.0_321"
Java(TM) SE Runtime Environment (build 1.8.0_321-b07)
Java HotSpot(TM) 64-Bit Server VM (build 25.321-b07, mixed mode)
[my@Hadoop102 .kettle]$
 
#kettle安装，若需安装到指定用户下，便使用指定用户解压安装包，并指定所有者及权限（一般775权限）
[my@Hadoop102 kettle]$ cd ~
[my@Hadoop102 ~]$ ll
总用量 0
drwxr-xr-x. 2 my my 6 4月  16 13:59 公共
drwxr-xr-x. 2 my my 6 4月  16 13:59 模板
drwxr-xr-x. 2 my my 6 4月  16 13:59 视频
drwxr-xr-x. 2 my my 6 4月  16 13:59 图片
drwxr-xr-x. 2 my my 6 4月  16 13:59 文档
drwxr-xr-x. 2 my my 6 4月  16 13:59 下载
drwxr-xr-x. 2 my my 6 4月  16 13:59 音乐
drwxr-xr-x. 2 my my 6 4月  16 13:59 桌面
[my@Hadoop102 ~]$ echo 创建kettle安装目录
创建kettle安装目录
[my@Hadoop102 ~]$ mkdir /opt/kettle
mkdir: 无法创建目录"/opt/kettle": 文件已存在
 
#将kettle安装包上传至安装文件夹
[my@Hadoop102 ~]$ cd /opt/kettle
[my@Hadoop102 kettle]$ ll
总用量 1541540
-rw-rw-r--. 1 my my 1578536223 2月  14 14:41 kettle-pdi-ce-9.0.0.0-423.zip
[my@Hadoop102 kettle]$ echo 解压对应压缩包
解压对应压缩包
[my@Hadoop102 kettle]$ unzip kettle-pdi-ce-9.0.0.0-423.zip
..........
  inflating: data-integration/system/karaf/system/com/fasterxml/jackson/core/jackson-databind/2.7.0/jackson-databind-2.7.0.jar  
  inflating: data-integration/libswt/win32/swt.jar  
[my@Hadoop102 kettle]$ ls
data-integration  kettle-pdi-ce-9.0.0.0-423.zip
[my@Hadoop102 kettle]$ cd data-integration/
[my@Hadoop102 data-integration]$ ll -a
总用量 384
drwxr-xr-x. 18 my my   4096 1月  31 2020 .
drwxrwxrwx.  3 my my     67 4月  22 23:58 ..
drwxr-xr-x.  3 my my     21 1月  31 2020 ADDITIONAL-FILES
-rw-rw-r--.  1 my my   1494 1月  31 2020 Carte.bat
-rwxr-xr-x.  1 my my   1479 1月  31 2020 carte.sh
drwxrwxrwx.  2 my my    126 1月  31 2020 classes
drwxrwxrwx.  3 my my     35 1月  31 2020 Data Integration.app
drwxr-xr-x.  2 my my     59 1月  31 2020 Data Service JDBC Driver
drwxrwxrwx.  3 my my     39 1月  31 2020 docs
drwxr-xr-x.  2 my my     20 1月  31 2020 drivers
-rw-rw-r--.  1 my my   1081 1月  31 2020 Encr.bat
-rwxr-xr-x.  1 my my   1040 1月  31 2020 encr.sh
-rw-rw-r--.  1 my my   1074 1月  31 2020 Import.bat
-rw-rw-r--.  1 my my   2354 1月  31 2020 import-rules.xml
-rwxr-xr-x.  1 my my   1175 1月  31 2020 import.sh
-rw-rw-r--.  1 my my   1127 1月  31 2020 Kitchen.bat
-rwxr-xr-x.  1 my my   1254 1月  31 2020 kitchen.sh
drwxrwxrwx.  2 my my     75 1月  31 2020 launcher
drwxrwxrwx.  2 my my  12288 1月  31 2020 lib
drwxr-xr-x.  6 my my     58 1月  31 2020 libswt
-rw-rw-r--.  1 my my  13366 1月  31 2020 LICENSE.txt
-rw-rw-r--.  1 my my   1115 1月  31 2020 Pan.bat
-rwxr-xr-x.  1 my my   1220 1月  31 2020 pan.sh
-rw-rw-r--.  1 my my   2053 1月  31 2020 PentahoDataIntegration_OSS_Licenses.html
drwxr-xr-x. 27 my my   4096 1月  31 2020 plugins
-rw-rw-r--.  1 my my   1156 1月  31 2020 purge-utility.bat
-rwxr-xr-x.  1 my my   1250 1月  31 2020 purge-utility.sh
drwxrwxrwx.  2 my my    176 1月  31 2020 pwd
-rw-rw-r--.  1 my my   2741 1月  31 2020 README-spark-app-builder.txt
-rw-rw-r--.  1 my my   1366 1月  31 2020 README.txt
-rw-rw-r--.  1 my my   1466 1月  31 2020 runSamples.bat
-rwxr-xr-x.  1 my my   1205 1月  31 2020 runSamples.sh
drwxrwxrwx.  5 my my     51 1月  31 2020 samples
-rw-rw-r--.  1 my my   5831 1月  31 2020 set-pentaho-env.bat
-rwxr-xr-x.  1 my my   4612 1月  31 2020 set-pentaho-env.sh
drwxrwxrwx.  2 my my     29 1月  31 2020 simple-jndi
-rw-rw-r--.  1 my my   1214 1月  31 2020 Spark-app-builder.bat
-rwxr-xr-x.  1 my my   1209 1月  31 2020 spark-app-builder.sh
-rw-rw-r--.  1 my my   5218 1月  31 2020 Spoon.bat
-rwxr-xr-x.  1 my my   1114 1月  31 2020 spoon.command
-rw-rw-r--.  1 my my   1041 1月  31 2020 SpoonConsole.bat
-rw-rw-r--.  1 my my   2214 1月  31 2020 SpoonDebug.bat
-rwxr-xr-x.  1 my my   1951 1月  31 2020 SpoonDebug.sh
-rw-rw-r--.  1 my my 208133 1月  31 2020 spoon.ico
-rw-rw-r--.  1 my my   1017 1月  31 2020 spoon.png
-rwxr-xr-x.  1 my my   7912 1月  31 2020 spoon.sh
drwxrwxrwx.  4 my my     31 1月  31 2020 static
drwxrwxrwx.  5 my my     47 1月  31 2020 system
drwxrwxrwx.  3 my my   4096 1月  31 2020 ui
-rwxr-xr-x.  1 my my   1643 1月  31 2020 yarn.sh
[my@Hadoop102 data-integration]$ echo 配置环境变量，便于kettle相关命令的使用
配置环境变量，便于kettle相关命令的使用
[my@Hadoop102 data-integration]$ cd /etc/profile.d/
[my@Hadoop102 profile.d]$ echo 创建并编辑kettle环境变量文件
创建并编辑kettle环境变量文件
[my@Hadoop102 profile.d]$ vi kettleenv.sh 
#kettle 环境变量
export KETTLE_HOME=/opt/kettle
export PATH=$PATH:/opt/kettle/data-integration
"kettleenv.sh"
"kettleenv.sh" E212: 无法打开并写入文件
#kettle 环境变量
[my@Hadoop102 profile.d]$ cat kettleenv.sh       
#kettle 环境变量
export KETTLE_HOME=/opt/kettle
export PATH=$PATH:/opt/kettle/data-integration
[my@Hadoop102 profile.d]$ echo 使环境变量生效
使环境变量生效
[my@Hadoop102 profile.d]$ source /etc/profile
[my@Hadoop102 profile.d]$ echo $KETTLE_HOME 
/opt/kettle
[my@Hadoop102 profile.d]$ echo 校验kettle是否安装成功
校验kettle是否安装成功
[my@Hadoop102 profile.d]$ kitchen.sh 
#######################################################################
WARNING:  no libwebkitgtk-1.0 detected, some features will be unavailable
    Consider installing the package with apt-get or yum.
    e.g. 'sudo apt-get install libwebkitgtk-1.0-0'
#######################################################################
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=256m; support was removed in 8.0
Options:
  -rep            = Repository name
  -user           = Repository username
  -trustuser      = !Kitchen.ComdLine.RepUsername!
  -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, Minimal, 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 <NAME>=<VALUE>. 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 <NAME>=<Value>, 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)
 
[my@Hadoop102 profile.d]$ echo kettle安装成功
kettle安装成功
[my@Hadoop102 profile.d]$ echo 当执行kitchen.sh命令后便会生成.kettle文件夹
当执行kitchen.sh命令后便会生成.kettle文件夹
[my@Hadoop102 profile.d]$ find / -name .kettle
.........
 
find: ‘/opt/java/.cache’: 权限不够
find: ‘/opt/java/.dbus’: 权限不够
find: ‘/opt/java/.pki’: 权限不够
find: ‘/opt/.cache’: 权限不够
find: ‘/opt/.dbus’: 权限不够
find: ‘/opt/.pki’: 权限不够
/opt/kettle/.kettle
[my@Hadoop102 profile.d]$ cd /opt/kettle/.kettle
[my@Hadoop102 .kettle]$ ll -a
总用量 4
drwxrwxr-x. 2 my my  31 4月  23 00:06 .
drwxrwxrwx. 4 my my  82 4月  23 00:06 ..
-rw-rw-r--. 1 my my 274 4月  23 00:06 kettle.properties
[my@Hadoop102 .kettle]$ echo .kettle文件夹中的文件即kettle相关配置文件
.kettle文件夹中的文件即kettle相关配置文件
[my@Hadoop102 .kettle]$ 
[my@Hadoop102 .kettle]$ 
[my@Hadoop102 .kettle]$ 
[my@Hadoop102 .kettle]$ 
[my@Hadoop102 .kettle]$ 
[my@Hadoop102 .kettle]$ echo 若需要连接数据库，则需将对应数据库jdbc连接驱动放入kettle安装目录的lib目录下
若需要连接数据库，则需将对应数据库jdbc连接驱动放入kettle安装目录的lib目录下
[my@Hadoop102 .kettle]$ cd $KETTLE_HOME
[my@Hadoop102 kettle]$ cd data-integration/
[my@Hadoop102 data-integration]$ cd bin
-bash: cd: bin: 没有那个文件或目录
[my@Hadoop102 data-integration]$ ls
ADDITIONAL-FILES          Import.bat        Pan.bat                                   runSamples.sh          SpoonDebug.bat
Carte.bat                 import-rules.xml  pan.sh                                    samples                SpoonDebug.sh
carte.sh                  import.sh         PentahoDataIntegration_OSS_Licenses.html  set-pentaho-env.bat    spoon.ico
classes                   Kitchen.bat       plugins                                   set-pentaho-env.sh     spoon.png
Data Integration.app      kitchen.sh        purge-utility.bat                         simple-jndi            spoon.sh
Data Service JDBC Driver  launcher          purge-utility.sh                          Spark-app-builder.bat  static
docs                      lib               pwd                                       spark-app-builder.sh   system
drivers                   libswt            README-spark-app-builder.txt              Spoon.bat              ui
Encr.bat                  LICENSE.txt       README.txt                                spoon.command          yarn.sh
encr.sh                   logs              runSamples.bat                            SpoonConsole.bat
[my@Hadoop102 data-integration]$ cd lib
[my@Hadoop102 lib]$ echo 如为了连接mysql数据库，便将对应的驱动放入lib文件夹下
如为了连接mysql数据库，便将对应的驱动放入lib文件夹下
[my@Hadoop102 lib]$ ls mys*
ls: 无法访问mys*: 没有那个文件或目录
[my@Hadoop102 lib]$ pwd
/opt/kettle/data-integration/lib
[my@Hadoop102 lib]$ ls mys*
mysql-connector-java-5.1.27-bin.jar
[my@Hadoop102 lib]$ echo 此时kettle便可连接mysql数据库
此时kettle便可连接mysql数据库
[my@Hadoop102 lib]$ 
[my@Hadoop102 lib]$ 
[my@Hadoop102 lib]$ 
[my@Hadoop102 lib]$ 
[my@Hadoop102 lib]$ 
[my@Hadoop102 lib]$ echo 现使用kitchen.sh命令调用已经开发好的非本地式数据库资源仓库类kettle job
现使用kitchen.sh命令调用已经开发好的非本地式数据库资源仓库类kettle job
[my@Hadoop102 lib]$ 
[my@Hadoop102 lib]$ 将kettle工程开发环境下的.kettle文件夹下的repositories.xml文件上传更新至服务运行环境下的.kettle文件夹下
bash: 将kettle工程开发环境下的.kettle文件夹下的repositories.xml文件上传更新至服务运行环境下的.kettle文件夹下: 未找到命令...
[my@Hadoop102 lib]$ 
[my@Hadoop102 lib]$ find / -name .kettle
find: ‘/boot/lost+found’: 权限不够
.....
find: ‘/opt/.pki’: 权限不够
/opt/kettle/.kettle
[my@Hadoop102 lib]$ 成都/opt/kettle/.kettle
-bash: 成都/opt/kettle/.kettle: 没有那个文件或目录
[my@Hadoop102 lib]$ cd /opt/kettle/.kettle 
[my@Hadoop102 .kettle]$ ll -a
总用量 8
drwxrwxr-x. 2 my my   55 4月  23 00:13 .
drwxrwxrwx. 4 my my   82 4月  23 00:06 ..
-rw-rw-r--. 1 my my  274 4月  23 00:06 kettle.properties
-rw-rw-r--. 1 my my 1606 4月  22 18:35 repositories.xml
[my@Hadoop102 .kettle]$ cat repositories.xml^C
[my@Hadoop102 .kettle]$ ^C
[my@Hadoop102 .kettle]$ 
[my@Hadoop102 .kettle]$ 
[my@Hadoop102 .kettle]$ cat repositories.xml
<?xml version="1.0" encoding="UTF-8"?>
<repositories>
  <connection>
    <name>hadoop102kettle</name>
    <server>hadoop102</server>
    <type>MYSQL</type>
    <access>Native</access>
    <database>mysql</database>
    <port>3306</port>
    <username>root</username>
    <password>Encrypted 2be98afc86aa7f2e4cb79ff228dc6fa8c</password>
    <servername/>
    <data_tablespace/>
    <index_tablespace/>
    <attributes>
      <attribute><code>FORCE_IDENTIFIERS_TO_LOWERCASE</code><attribute>N</attribute></attribute>
      <attribute><code>FORCE_IDENTIFIERS_TO_UPPERCASE</code><attribute>N</attribute></attribute>
      <attribute><code>IS_CLUSTERED</code><attribute>N</attribute></attribute>
      <attribute><code>PORT_NUMBER</code><attribute>3306</attribute></attribute>
      <attribute><code>PRESERVE_RESERVED_WORD_CASE</code><attribute>Y</attribute></attribute>
      <attribute><code>QUOTE_ALL_FIELDS</code><attribute>N</attribute></attribute>
      <attribute><code>STREAM_RESULTS</code><attribute>Y</attribute></attribute>
      <attribute><code>SUPPORTS_BOOLEAN_DATA_TYPE</code><attribute>Y</attribute></attribute>
      <attribute><code>SUPPORTS_TIMESTAMP_DATA_TYPE</code><attribute>Y</attribute></attribute>
      <attribute><code>USE_POOLING</code><attribute>N</attribute></attribute>
    </attributes>
  </connection>
  <repository>    <id>KettleDatabaseRepository</id>
    <name>hadoop102</name>
    <description>Database repository</description>
    <is_default>false</is_default>
    <connection>hadoop102kettle</connection>
  </repository>  </repositories>
[my@Hadoop102 .kettle]$ 
[my@Hadoop102 .kettle]$ 
[my@Hadoop102 .kettle]$ echo 使用kitchen.sh命令进行作业调度
使用kitchen.sh命令进行作业调度
[my@Hadoop102 .kettle]$ 
[my@Hadoop102 .kettle]$ 将kettle工程开发环境下的.kettle文件夹下的repositories.xml文件上传更新至服务运行环境下的.kettle文件夹 
[my@Hadoop102 .kettle]$ echo 现使用kitchen.sh命令调用已经开发好的非本地式数据库资源仓库类kettle job                          
[my@Hadoop102 .kettle]$ 将kettle工程开发环境下的.kettle文件夹下的repositories.xml文件上传更新至服务运行环境下的.kettle文件夹 
[my@Hadoop102 .kettle]$ echo 现使用kitchen.sh命令调用已经开发好的非本地式数据库资源仓库类kettle job      
 
#kitchen.sh -rep repository-name(资源仓库名) -user admin(连接用户) -pass admin(连接密码) -dir /test/job(job文件所在路径) -job create-table(job对象名)
#rep名对应repositories.xml中repository.name
[my@Hadoop102 .kettle]$ kitchen.sh -rep hadoop102 -user admin -pass admin -dir /test/job -job create-table
#######################################################################
WARNING:  no libwebkitgtk-1.0 detected, some features will be unavailable
    Consider installing the package with apt-get or yum.
    e.g. 'sudo apt-get install libwebkitgtk-1.0-0'
#######################################################################
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=256m; support was removed in 8.0
00:26:11,002 INFO  [KarafBoot] Checking to see if org.pentaho.clean.karaf.cache is enabled
00:26:11,332 INFO  [KarafInstance] 
*******************************************************************************
*** Karaf Instance Number: 1 at /opt/kettle/data-integration/./system/karaf ***
***   /caches/kitchen/data-1                                                ***
*** Karaf Port:8802                                                         ***
*** OSGI Service Port:9051                                                  ***
*******************************************************************************
四月 23, 2022 12:26:12 上午 org.apache.karaf.main.Main launch
信息: Installing and starting initial bundles
四月 23, 2022 12:26:13 上午 org.apache.karaf.main.Main launch
信息: All initial bundles installed and set to start
四月 23, 2022 12:26:14 上午 org.apache.karaf.main.Main$KarafLockCallback lockAcquired
信息: Lock acquired. Setting startlevel to 100
2022/04/23 00:26:14 - Kitchen - Start of run.
2022/04/23 00:26:14 - RepositoriesMeta - Reading repositories XML file: /opt/kettle/.kettle/repositories.xml
四月 23, 2022 12:26:36 上午 org.pentaho.caching.impl.PentahoCacheManagerFactory$RegistrationHandler$1 onSuccess
信息: New Caching Service registered
四月 23, 2022 12:26:48 上午 org.apache.aries.spifly.BaseActivator log
信息: Examining bundle for SPI provider: org.eclipse.jetty.http
四月 23, 2022 12:26:48 上午 org.apache.aries.spifly.BaseActivator log
信息: Found SPI resource: bundle://160.0:0/META-INF/services/org.eclipse.jetty.http.HttpFieldPreEncoder
四月 23, 2022 12:26:48 上午 org.apache.aries.spifly.BaseActivator log
信息: Loaded SPI provider: class org.eclipse.jetty.http.Http1FieldPreEncoder
四月 23, 2022 12:26:48 上午 org.apache.aries.spifly.BaseActivator log
信息: Registered service: org.apache.felix.framework.ServiceRegistrationImpl@63ba2471
四月 23, 2022 12:26:48 上午 org.apache.aries.spifly.BaseActivator log
信息: Registered provider: org.eclipse.jetty.http.HttpFieldPreEncoder in bundle org.eclipse.jetty.http
四月 23, 2022 12:26:48 上午 org.apache.aries.spifly.BaseActivator log
信息: Examining bundle for SPI provider: org.eclipse.jetty.websocket.common
四月 23, 2022 12:26:48 上午 org.apache.aries.spifly.BaseActivator log
信息: Found SPI resource: bundle://177.0:0/META-INF/services/org.eclipse.jetty.websocket.api.extensions.Extension
四月 23, 2022 12:26:48 上午 org.apache.aries.spifly.BaseActivator log
信息: Loaded SPI provider: class org.eclipse.jetty.websocket.common.extensions.identity.IdentityExtension
四月 23, 2022 12:26:48 上午 org.apache.aries.spifly.BaseActivator log
信息: Registered service: org.apache.felix.framework.ServiceRegistrationImpl@663fa495
四月 23, 2022 12:26:48 上午 org.apache.aries.spifly.BaseActivator log
信息: Registered provider: org.eclipse.jetty.websocket.api.extensions.Extension in bundle org.eclipse.jetty.websocket.common
四月 23, 2022 12:26:48 上午 org.apache.aries.spifly.BaseActivator log
信息: Loaded SPI provider: class org.eclipse.jetty.websocket.common.extensions.fragment.FragmentExtension
四月 23, 2022 12:26:48 上午 org.apache.aries.spifly.BaseActivator log
信息: Registered service: org.apache.felix.framework.ServiceRegistrationImpl@4ae8e64b
四月 23, 2022 12:26:48 上午 org.apache.aries.spifly.BaseActivator log
信息: Registered provider: org.eclipse.jetty.websocket.api.extensions.Extension in bundle org.eclipse.jetty.websocket.common
四月 23, 2022 12:26:48 上午 org.apache.aries.spifly.BaseActivator log
信息: Loaded SPI provider: class org.eclipse.jetty.websocket.common.extensions.compress.PerMessageDeflateExtension
四月 23, 2022 12:26:48 上午 org.apache.aries.spifly.BaseActivator log
信息: Registered service: org.apache.felix.framework.ServiceRegistrationImpl@5d6944e4
四月 23, 2022 12:26:48 上午 org.apache.aries.spifly.BaseActivator log
信息: Registered provider: org.eclipse.jetty.websocket.api.extensions.Extension in bundle org.eclipse.jetty.websocket.common
四月 23, 2022 12:26:48 上午 org.apache.aries.spifly.BaseActivator log
信息: Loaded SPI provider: class org.eclipse.jetty.websocket.common.extensions.compress.DeflateFrameExtension
四月 23, 2022 12:26:48 上午 org.apache.aries.spifly.BaseActivator log
信息: Registered service: org.apache.felix.framework.ServiceRegistrationImpl@4b8f251a
四月 23, 2022 12:26:48 上午 org.apache.aries.spifly.BaseActivator log
信息: Registered provider: org.eclipse.jetty.websocket.api.extensions.Extension in bundle org.eclipse.jetty.websocket.common
四月 23, 2022 12:26:48 上午 org.apache.aries.spifly.BaseActivator log
信息: Loaded SPI provider: class org.eclipse.jetty.websocket.common.extensions.compress.XWebkitDeflateFrameExtension
四月 23, 2022 12:26:48 上午 org.apache.aries.spifly.BaseActivator log
信息: Registered service: org.apache.felix.framework.ServiceRegistrationImpl@52de7bf3
四月 23, 2022 12:26:48 上午 org.apache.aries.spifly.BaseActivator log
信息: Registered provider: org.eclipse.jetty.websocket.api.extensions.Extension in bundle org.eclipse.jetty.websocket.common
四月 23, 2022 12:26:48 上午 org.apache.aries.spifly.BaseActivator log
信息: Examining bundle for SPI provider: org.eclipse.jetty.websocket.server
四月 23, 2022 12:26:48 上午 org.apache.aries.spifly.BaseActivator log
信息: Found SPI resource: bundle://180.0:0/META-INF/services/javax.servlet.ServletContainerInitializer
四月 23, 2022 12:26:48 上午 org.apache.aries.spifly.BaseActivator log
信息: Loaded SPI provider: class org.eclipse.jetty.websocket.server.NativeWebSocketServletContainerInitializer
四月 23, 2022 12:26:48 上午 org.apache.aries.spifly.BaseActivator log
信息: Registered service: org.apache.felix.framework.ServiceRegistrationImpl@48b652b
四月 23, 2022 12:26:48 上午 org.apache.aries.spifly.BaseActivator log
信息: Registered provider: javax.servlet.ServletContainerInitializer in bundle org.eclipse.jetty.websocket.server
四月 23, 2022 12:26:48 上午 org.apache.aries.spifly.BaseActivator log
信息: Examining bundle for SPI provider: org.eclipse.jetty.websocket.javax.websocket
四月 23, 2022 12:26:48 上午 org.apache.aries.spifly.BaseActivator log
信息: Found SPI resource: bundle://178.0:0/META-INF/services/javax.websocket.ContainerProvider
四月 23, 2022 12:26:48 上午 org.apache.aries.spifly.BaseActivator log
信息: Loaded SPI provider: class org.eclipse.jetty.websocket.jsr356.JettyClientContainerProvider
四月 23, 2022 12:26:48 上午 org.apache.aries.spifly.BaseActivator log
信息: Registered service: org.apache.felix.framework.ServiceRegistrationImpl@d206550
四月 23, 2022 12:26:48 上午 org.apache.aries.spifly.BaseActivator log
信息: Registered provider: javax.websocket.ContainerProvider in bundle org.eclipse.jetty.websocket.javax.websocket
四月 23, 2022 12:26:48 上午 org.apache.aries.spifly.BaseActivator log
信息: Examining bundle for SPI provider: org.eclipse.jetty.websocket.javax.websocket.server
四月 23, 2022 12:26:48 上午 org.apache.aries.spifly.BaseActivator log
信息: Found SPI resource: bundle://179.0:0/META-INF/services/javax.servlet.ServletContainerInitializer
四月 23, 2022 12:26:48 上午 org.apache.aries.spifly.BaseActivator log
信息: Loaded SPI provider: class org.eclipse.jetty.websocket.jsr356.server.deploy.WebSocketServerContainerInitializer
四月 23, 2022 12:26:48 上午 org.apache.aries.spifly.BaseActivator log
信息: Registered service: org.apache.felix.framework.ServiceRegistrationImpl@33a2bb5e
四月 23, 2022 12:26:48 上午 org.apache.aries.spifly.BaseActivator log
信息: Registered provider: javax.servlet.ServletContainerInitializer in bundle org.eclipse.jetty.websocket.javax.websocket.server
四月 23, 2022 12:26:48 上午 org.apache.aries.spifly.BaseActivator log
信息: Found SPI resource: bundle://179.0:0/META-INF/services/javax.websocket.server.ServerEndpointConfig$Configurator
四月 23, 2022 12:26:48 上午 org.apache.aries.spifly.BaseActivator log
信息: Loaded SPI provider: class org.eclipse.jetty.websocket.jsr356.server.ContainerDefaultConfigurator
四月 23, 2022 12:26:48 上午 org.apache.aries.spifly.BaseActivator log
信息: Registered service: org.apache.felix.framework.ServiceRegistrationImpl@11ac9bc0
四月 23, 2022 12:26:48 上午 org.apache.aries.spifly.BaseActivator log
信息: Registered provider: javax.websocket.server.ServerEndpointConfig$Configurator in bundle org.eclipse.jetty.websocket.javax.websocket.server
2022-04-23 00:26:49.216:INFO::features-3-thread-1: Logging initialized @44746ms to org.eclipse.jetty.util.log.StdErrLog
四月 23, 2022 12:26:50 上午 org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
信息: Adding the extensions from bundle org.apache.cxf.cxf-rt-management (132) [org.apache.cxf.management.InstrumentationManager]
四月 23, 2022 12:26:50 上午 org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
信息: Adding the extensions from bundle org.apache.cxf.cxf-rt-rs-service-description (137) [org.apache.cxf.jaxrs.model.wadl.WadlGenerator]
四月 23, 2022 12:26:50 上午 org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
信息: Adding the extensions from bundle org.apache.cxf.cxf-rt-transports-http (139) [org.apache.cxf.transport.http.HTTPTransportFactory, org.apache.cxf.transport.http.HTTPWSDLExtensionLoader, org.apache.cxf.transport.http.policy.HTTPClientAssertionBuilder, org.apache.cxf.transport.http.policy.HTTPServerAssertionBuilder, org.apache.cxf.transport.http.policy.NoOpPolicyInterceptorProvider]
四月 23, 2022 12:26:50 上午 org.apache.cxf.transport.http.osgi.ServletExporter updated
信息: Registering new instance of "/cxf" servlet
四月 23, 2022 12:26:53 上午 org.apache.cxf.endpoint.ServerImpl initDestination
信息: Setting the server's publish address to be /i18n
2022-04-23 00:26:54.165:INFO:oejws.WebSocketServerFactory:CM Configuration Updater (ManagedService Update: pid=[org.apache.cxf.osgi]): No DecoratedObjectFactory provided, using new org.eclipse.jetty.util.DecoratedObjectFactory[decorators=1]
2022-04-23 00:26:54.770:INFO:oejs.session:CM Configuration Updater (ManagedService Update: pid=[org.apache.cxf.osgi]): DefaultSessionIdManager workerName=node0
2022-04-23 00:26:54.770:INFO:oejs.session:CM Configuration Updater (ManagedService Update: pid=[org.apache.cxf.osgi]): No SessionScavenger set, using defaults
2022-04-23 00:26:54.772:INFO:oejs.session:CM Configuration Updater (ManagedService Update: pid=[org.apache.cxf.osgi]): node0 Scavenging every 600000ms
2022-04-23 00:26:54.826:INFO:oejws.WebSocketServerFactory:features-3-thread-1: No DecoratedObjectFactory provided, using new org.eclipse.jetty.util.DecoratedObjectFactory[decorators=1]
2022-04-23 00:26:54.853:INFO:oejsh.ContextHandler:features-3-thread-1: Started HttpServiceContext{httpContext=DefaultHttpContext [bundle=pentaho-i18n-webservice-bundle [224], contextID=default]}
2022-04-23 00:26:54.878:INFO:oejs.Server:features-3-thread-1: jetty-9.4.18.v20190429; built: 2019-04-29T20:42:08.989Z; git: e1bc35120a6617ee3df052294e433f3a25ce7097; jvm 1.8.0_321-b07
2022-04-23 00:26:54.914:INFO:oejsh.ContextHandler:CM Configuration Updater (ManagedService Update: pid=[org.apache.cxf.osgi]): Started HttpServiceContext{httpContext=DefaultHttpContext [bundle=org.apache.cxf.cxf-rt-transports-http [139], contextID=default]}
2022-04-23 00:26:55.063:INFO:oejs.AbstractConnector:features-3-thread-1: Started default@737398b5{HTTP/1.1,[http/1.1]}{0.0.0.0:9051}
2022-04-23 00:26:55.063:INFO:oejs.Server:features-3-thread-1: Started @50594ms
2022-04-23 00:27:13.953:INFO:oejws.WebSocketServerFactory:features-3-thread-1: No DecoratedObjectFactory provided, using new org.eclipse.jetty.util.DecoratedObjectFactory[decorators=1]
2022-04-23 00:27:13.987:INFO:oejsh.ContextHandler:features-3-thread-1: Started HttpServiceContext{httpContext=DefaultHttpContext [bundle=pentaho-webjars-underscore [263], contextID=default]}
2022-04-23 00:27:14.037:INFO:oejws.WebSocketServerFactory:features-3-thread-1: No DecoratedObjectFactory provided, using new org.eclipse.jetty.util.DecoratedObjectFactory[decorators=1]
2022-04-23 00:27:14.064:INFO:oejsh.ContextHandler:features-3-thread-1: Started HttpServiceContext{httpContext=DefaultHttpContext [bundle=pentaho-webjars-angular-ui-bootstrap-bower [261], contextID=default]}
2022-04-23 00:27:14.104:INFO:oejws.WebSocketServerFactory:features-3-thread-1: No DecoratedObjectFactory provided, using new org.eclipse.jetty.util.DecoratedObjectFactory[decorators=1]
2022-04-23 00:27:14.132:INFO:oejsh.ContextHandler:features-3-thread-1: Started HttpServiceContext{httpContext=DefaultHttpContext [bundle=pentaho-webjars-angular [256], contextID=default]}
2022-04-23 00:27:14.178:INFO:oejws.WebSocketServerFactory:features-3-thread-1: No DecoratedObjectFactory provided, using new org.eclipse.jetty.util.DecoratedObjectFactory[decorators=1]
2022-04-23 00:27:14.197:INFO:oejsh.ContextHandler:features-3-thread-1: Started HttpServiceContext{httpContext=DefaultHttpContext [bundle=pentaho-webjars-angular-route [258], contextID=default]}
2022-04-23 00:27:14.710:INFO:oejws.WebSocketServerFactory:features-3-thread-1: No DecoratedObjectFactory provided, using new org.eclipse.jetty.util.DecoratedObjectFactory[decorators=1]
2022-04-23 00:27:14.716:INFO:oejsh.ContextHandler:features-3-thread-1: Started HttpServiceContext{httpContext=DefaultHttpContext [bundle=org.pentaho.requirejs-manager-impl [254], contextID=default]}
2022-04-23 00:27:14.782:INFO:oejws.WebSocketServerFactory:features-3-thread-1: No DecoratedObjectFactory provided, using new org.eclipse.jetty.util.DecoratedObjectFactory[decorators=1]
2022-04-23 00:27:14.823:INFO:oejsh.ContextHandler:features-3-thread-1: Started HttpServiceContext{httpContext=DefaultHttpContext [bundle=pentaho-webjars-angular-sanitize [259], contextID=default]}
2022-04-23 00:27:14.861:INFO:oejws.WebSocketServerFactory:features-3-thread-1: No DecoratedObjectFactory provided, using new org.eclipse.jetty.util.DecoratedObjectFactory[decorators=1]
2022-04-23 00:27:14.878:INFO:oejsh.ContextHandler:features-3-thread-1: Started HttpServiceContext{httpContext=DefaultHttpContext [bundle=pentaho-webjars-angular-translate [260], contextID=default]}
2022-04-23 00:27:14.919:INFO:oejws.WebSocketServerFactory:features-3-thread-1: No DecoratedObjectFactory provided, using new org.eclipse.jetty.util.DecoratedObjectFactory[decorators=1]
2022-04-23 00:27:14.942:INFO:oejsh.ContextHandler:features-3-thread-1: Started HttpServiceContext{httpContext=DefaultHttpContext [bundle=pentaho-webjars-angular-animate [257], contextID=default]}
2022-04-23 00:27:14.997:INFO:oejws.WebSocketServerFactory:features-3-thread-1: No DecoratedObjectFactory provided, using new org.eclipse.jetty.util.DecoratedObjectFactory[decorators=1]
2022-04-23 00:27:15.003:INFO:oejsh.ContextHandler:features-3-thread-1: Started HttpServiceContext{httpContext=DefaultHttpContext [bundle=pentaho-webjars-jquery [262], contextID=default]}
四月 23, 2022 12:27:17 上午 org.apache.cxf.endpoint.ServerImpl initDestination
信息: Setting the server's publish address to be /marketplace
00:27:17,634 INFO  [DriverManager] Installing driver kars.
00:27:17,636 INFO  [DriverManager] 0 drivers will be installed.
00:27:17,637 INFO  [DriverManager] Finished installing drivers kars.
2022-04-23 00:27:19.612:INFO:oejws.WebSocketServerFactory:FelixDispatchQueue: No DecoratedObjectFactory provided, using new org.eclipse.jetty.util.DecoratedObjectFactory[decorators=1]
2022-04-23 00:27:19.718:INFO:oejsh.ContextHandler:FelixDispatchQueue: Started HttpServiceContext{httpContext=DefaultHttpContext [bundle=pentaho-marketplace-di [255], contextID=default]}
2022/04/23 00:27:20 - create-table - 开始执行任务
2022/04/23 00:27:20 - Carte - Installing timer to purge stale objects after 1440 minutes.
2022/04/23 00:27:20 - create-table - 开始项[转换]
四月 23, 2022 12:27:20 上午 org.apache.cxf.endpoint.ServerImpl initDestination
信息: Setting the server's publish address to be /marketplace
2022/04/23 00:27:21 - 转换 - Using run configuration [Pentaho local]
2022/04/23 00:27:21 - 转换 - Running transformation using the Kettle execution engine
2022/04/23 00:27:21 - create-table - 为了转换解除补丁开始  [create-table]
2022/04/23 00:27:21 - 执行SQL脚本.0 - Finished reading query, closing connection.
2022/04/23 00:27:21 - 执行SQL脚本.0 - 完成处理 (I=0, O=0, R=0, W=1, U=0, E=0)
2022/04/23 00:27:21 - create-table - 开始项[成功]
2022/04/23 00:27:21 - create-table - 完成作业项[成功] (结果=[true])
2022/04/23 00:27:21 - create-table - 完成作业项[转换] (结果=[true])
2022/04/23 00:27:21 - create-table - 任务执行完毕
2022/04/23 00:27:21 - Kitchen - Finished!
2022/04/23 00:27:21 - Kitchen - Start=2022/04/23 00:26:14.844, Stop=2022/04/23 00:27:21.896
2022/04/23 00:27:21 - Kitchen - Processing ended after 1 minutes and 7 seconds (67 seconds total).
[my@Hadoop102 .kettle]$ 
[my@Hadoop102 .kettle]$ 
[my@Hadoop102 .kettle]$ echo 作业调度完成
作业调度完成
[my@Hadoop102 .kettle]$ 
[my@Hadoop102 .kettle]$ echo 若需定时调度，可使用系统的定时任务辅助实现
若需定时调度，可使用系统的定时任务辅助实现
[my@Hadoop102 .kettle]$