kettle 设置null值空字符串

原创已于 2022-11-26 21:15:03 修改 · 1.2k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#etl

于 2022-11-26 21:14:20 首次发布

kettle 专栏收录该内容

2 篇文章

订阅专栏

本文指导如何找到Kettle配置文件并修改空字符串处理规则，以适应项目需求。只需几步，助你解决空值处理问题并重启Spotify服务生效。

找到kettle配置文件一般是在

C:\用户\用户名\.kettle\kettle.properties

最后一行添加 KETTLE_EMPTY_STRING_DIFFERS_FROM_NULL=Y

# This file was generated by Pentaho Data Integration version 8.2.0.0-342.
# 
# Here are a few examples of variables to set: 
#
# PRODUCTION_SERVER = hercules
# TEST_SERVER = zeus
# DEVELOPMENT_SERVER = thor
#
# Note: lines like these with a # in front of it are comments
#
KETTLE_EMPTY_STRING_DIFFERS_FROM_NULL=Y

保存后重启spoon.bat 即可