[I] [Bug] Could not find function explode_json_array_json_outer [doris]

[via GitHub]

xujunwei916 opened a new issue, #49946:
URL: https://github.com/apache/doris/issues/49946

   ### Search before asking
   
   - [x] I had searched in the 
[issues](https://github.com/apache/doris/issues?q=is%3Aissue) 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  执行  函数找不到
   ```sql 
   -- 创建表
   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;
   
   ```
   
   
![Image](https://github.com/user-attachments/assets/fb523db8-d368-467e-b1f0-725b5531625e)
   
   
   
   
   
   ### 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 版本直接查询临时数据时执行报错，报错信息不一致
   
   
![Image](https://github.com/user-attachments/assets/c19ab1d2-9759-47f1-9f95-765ed00e4f44)
   
   
![Image](https://github.com/user-attachments/assets/c78e1dba-1206-446a-a32d-94a09eba31d4)
   
   ### Are you willing to submit PR?
   
   - [ ] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [x] I agree to follow this project's [Code of 
Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org