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

   ### 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
   
   目前Doris版本,是否支持 CTE RECURSIVE?例如下面语句:
   
   WITH RECURSIVE my_cte AS
   (
     SELECT 1 AS n
     UNION ALL
     SELECT 1+n FROM my_cte WHERE n<10
   )
   SELECT * FROM my_cte;
   
   
   期望输出:
   +------+
   | n    |
   +------+
   |    1 |
   |    2 |
   |    3 |
   |    4 |
   |    5 |
   |    6 |
   |    7 |
   |    8 |
   |    9 |
   |   10 |
   +------+
   
   ### Use case
   
   例如,需要基于日期,生成时间序列,如:根据2020-01-01,生成如下时间序列
   
   2020-01-01 00:00
   2020-01-01 00:00
   2020-01-01 00:00
   
   ### 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

Reply via email to