This statement creates the table structure by returning the results from the Select statement and imports the data at the same time

    illustrate:

    • The user needs to havepermission for the source table andpermission for the target database
    • After a table is created, data is imported. If the import fails, the table is deleted
    • All columns of type string (varchar/var/string) are created as type “string”.
    • If the created source is an external table and the first column is of type String, the first column is automatically set to VARCHAR(65533). Because of Doris internal table, String column is not allowed as first column.

    1. Using the field names in the SELECT statement