Enable Null Value Insert
EnableNullInsert
This option specifies how the connector inserts NULL values.
-
1)1: The connector inserts all NULL values as specified in INSERT statements. -
0)0: If an INSERT statement only specifies NULL values for a column or does not specify any values for a column, then the connector omits that column when executing the INSERT statement.
Consider the following before modifying this property:
- It is recommended that you leave the property disabled so that the connector does not insert NULL values into empty cells and create tombstones, which may decrease server performance and cause errors to occur. However, this setting may decrease connector performance when executing INSERT statements that affect a large number of rows.
- It is recommended that you enable this property by setting it to
1only when executing INSERT statements that do not contain unnecessary NULL values, because inserting NULL values into empty columns creates tombstones.
For more information about tombstones, see "About deletes" in the Apache Cassandra 3.0 documentation: https://docs.datastax.com/en/cassandra-oss/3.0/cassandra/dml/dmlAboutDeletes.html?hl=deletes.
| Key Name | Default Value | Required |
|---|---|---|
|
|
|
No |