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 variable
enable_insert_strict’can be set to true' to ensure that
INSERT` will not be successfully executed when data is filtered out.
The test
table contains two columns c2’.
- Import a row of data into the
test
table
- 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 the
c2’column to import two data into the `test’ table.
- 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 the
label’ import job through the `SHOW LOAD command.
INSERT