[Bug] Could not find function explode_json_array_json_outer

[xujunwei916]

Search before asking

• I had searched in the issues and found no similar issues.

Version

2.1.9

What's Wrong?

参照文档 https://doris.apache.org/zh-CN/docs/sql-manual/sql-functions/table-functions/explode-json-array-json
把 explode_json_array_json 替换成 explode_json_array_json_outer 执行 函数找不到

-- 创建表
CREATE TABLE json_array_example (
    id INT,
    json_array STRING
)DUPLICATE KEY(id)
DISTRIBUTED BY HASH(id) BUCKETS AUTO
PROPERTIES (
"replication_allocation" = "tag.location.default: 1");

-- 插入数据

INSERT INTO json_array_example (id, json_array) VALUES
(1, '[1, 2, 3, 4, 5]'),
(2, '[1.1, 2.2, 3.3, 4.4]'),
(3, '["apple", "banana", "cherry"]'),
(4, '[{"a": 1}, {"b": 2}, {"c": 3}]'),
(5, '[]'),
(6, 'NULL');

-- 查询

SELECT id, e1
FROM json_array_example
LATERAL VIEW EXPLODE_JSON_ARRAY_JSON_OUTER(json_array) tmp1 AS e1
WHERE id = 4;

What You Expected?

函数explode_json_array_json_outer 能够找到并且 和 explode_json_array_json 执行保持一致

2.1.2 版本执行是没有问题的，升级到2.1.9 版本时出现的错误。

How to Reproduce?

参照描述

Anything Else?

explode_json_array_json_outer 函数在2.1.2和2.1.9 版本直接查询临时数据时执行报错，报错信息不一致

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[xujunwei916]

3.0.4 有相同的错误

[yiguolei]

@zhangstar333 Pls take a look at it.

[zhangstar333]

#50164

[yiguolei]

The bugfix PR will be merged to 2.1.10