[GitHub] [doris] qinchaofeng commented on issue #11591: [Bug] I want to create a new table from the query results of a table

[GitBox]

qinchaofeng commented on issue #11591:
URL: https://github.com/apache/doris/issues/11591#issuecomment-1210072218

   @longzmkm just like [stalary](https://github.com/stalary) said :
   
   ```
   create table
   information_schema.first_model
   as 
   select * from (
   
   with source_data as (
   
   select * from information_schema.tables
   )
   select
   *
   from source_data) as aa;
   ```


-- 
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

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