flinksql1.17 cast(... as int) 报错 java.lang.NumberFormatException: For input string: ‘null‘. Invalid

Thomas2143

已于 2023-08-05 12:24:16 修改

阅读量475

点赞数

分类专栏：总结文章标签： flink flinksql

于 2023-08-05 12:23:48 首次发布

本文链接：https://blog.csdn.net/qq_35515661/article/details/132118345

版权

总结专栏收录该内容

791 篇文章 ¥99.90 ¥299.90

订阅专栏

在Flink SQL 1.17中遇到`cast(... as int)`错误，原因是尝试将包含字符串'null'的JSON值转换为整数。解决方法是在SQL客户端中设置`sql-client.execution.result-mode`为'tableau'来规避。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

报错内容

[ERROR] Could not execute SQL statement. Reason:
java.lang.NumberFormatException: For input string: 'null'. Invalid character found.

原因

json中存在value为null,但是这里的null是字符串 "null"

如何sql改动来规避

sql-client.sh

SET 'sql-client.execution.result-mode' = 'tableau';

Flink SQL> select cast(json_value('{"k1":100}','$.k1') as int);
+----+-------------+
| op |      EXPR$0 |
+----+-------------+
| +I |         100 |
+----+-------------+
Received a total of 1 row

Flink SQL> select cast(json_value('{"k1":null}','$.k1') as int);
+----+-------------+
| op |      EXPR$0

了解本专栏