#前提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]$