kettle 设置null值空字符串

NBSPNBS

已于 2022-11-26 21:15:03 修改

阅读量873

点赞数

分类专栏： kettle 文章标签： etl

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

本文链接：https://blog.csdn.net/NBSPNBSP1/article/details/128057277

版权

kettle 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

找到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 即可