INSERT VALUES¶
Synopsis¶
1 2 |
|
Description¶
Produce a row into an existing stream or table and its underlying topic based on explicitly specified values.
If column names are specified, the order of the values must match the
order of the names. Any column not explicitly given a value is set to null
.
Pseudo columns, for example ROWTIME
, may be provided.
If no columns are specified, a value for every column is expected in the same order as the schema, with key columns first.
Note
ROWTIME
may be specified as an explicit column but isn't required
when you omit the column specifications. If not supplied, it defaults to the local machine time.
Example¶
The following statements are valid for a source with a schema like
<KEY_COL VARCHAR, COL_A VARCHAR>
with KEY=KEY_COL
.
1 2 3 4 5 6 7 8 9 10 11 |
|
The values are serialized by using the value_format
specified in the
original CREATE
statement. The key is always serialized as a String.