flink sql function array_contains demo

Thomas2143

已于 2024-12-03 14:24:44 修改

阅读量175

点赞数 2

分类专栏： free 文章标签： flink sql 大数据

于 2024-12-03 14:24:20 首次发布

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

版权

free 专栏收录该内容

275 篇文章

订阅专栏

Flink SQL> select array_contains(array[11,22,33],22);
+--------+
| EXPR$0 |
+--------+
|   TRUE |
+--------+
1 row in set (1.28 seconds)

Flink SQL> select array_contains(array[11,22,33],null);
+--------+
| EXPR$0 |
+--------+
|  FALSE |
+--------+
1 row in set (0.28 seconds)

Flink SQL> select array_contains(array[11,22,33],99);
+--------+
| EXPR$0 |
+--------+
|  FALSE |
+--------+
1 row in set (0.28 seconds)

Flink SQL> select array_contains(null,99);
[ERROR] Could not execute SQL statement. Reason:
org.apache.calcite.sql.validate.SqlValidatorException: Illegal use of 'NULL'

Flink SQL> select array_contains(cast(null as array<int>),99);
+--------+
| EXPR$0 |
+--------+
| <NULL> |
+--------+
1 row in set (0.34 seconds)

Flink SQL> select array_contains(cast(null as array<int>),99) is true;
+--------+
| EXPR$0 |
+--------+
|  FALSE |
+--------+
1 row in set (0.34 seconds)