[GitHub] [doris] zy-kkk opened a new issue, #14140: [Feature] (function) The explode function supports use without the lateral view

[GitBox]

zy-kkk opened a new issue, #14140:
URL: https://github.com/apache/doris/issues/14140

   ### Search before asking
   
   - [X] I had searched in the 
[issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and 
found no similar issues.
   
   
   ### Description
   
   At present, Doris's explore function can only be used with lateral view, 
which is rather tedious，but ClickHouse has an arrayjoin function that allows 
the array passed in to explore.
   So I want Doris's explode function supports use without the lateral view, or 
 implement a new function to achieve the function of arrayjoin
   
   ### Use case
   
   Doris:
   
![image](https://user-images.githubusercontent.com/70795751/200989047-de1bc183-91ee-40fd-a84d-ecdbbcbf3ba0.png)
   
   ClickHouse:
   
![image](https://user-images.githubusercontent.com/70795751/200988977-20e61f36-a820-48a3-a906-cde4934e63ba.png)
   
   
   ### Related issues
   
   _No response_
   
   ### 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