INSERT

    When the INSERT'statement is currently executed, the default behavior for data that does not conform to the target table is filtering, such as string length. However, for business scenarios where data is not filtered, the session variableenable_insert_strict’can be set to true' to ensure thatINSERT` will not be successfully executed when data is filtered out.

    The testtable contains two columns c2’.

    1. Import a row of data into the test table
    1. Import multiline data into the test table at one time

    The effect of the first and second statements is the same, and two data are imported into the test'table at one time. The effect of the third and fourth statements is known, using the default value of thec2’column to import two data into the `test’ table.

    1. Insert into table with specified partition and label

    Asynchronous imports are, in fact, encapsulated asynchronously by a synchronous import. Filling in streaming is as efficient as not filling in * execution.

    Since Doris used to import asynchronously, in order to be compatible with the old usage habits, the INSERT'statement without streaming will still return a label. Users need to view the status of thelabel’ import job through the `SHOW LOAD command.

    INSERT