INSERT¶

Synopsis¶

INSERT INTO <column_family> (<key_name>, <column_name> [, ...])
 VALUES (<key_value>, <column_value> [, ...])
 [USING <write_option> [AND <write_option> [...] ] ];

<write_option> is:

CONSISTENCY <consistency_level>
TTL <seconds>
TIMESTAMP <integer>

Description¶

An INSERT writes one or more columns to a record in a Cassandra column family. No results are returned. The first column name in the INSERT list must be the name of the column family key (either the KEY keyword or the row key alias defined on the column family). Also, there must be more than one column name specified (Cassandra rows are not considered to exist with only a key and no associated columns).

The first column value in the VALUES list is the row key value to insert. List column values in the same order as the column names are listed in the INSERT list. If a row or column does not exist, it will be inserted. If it does exist, it will be updated.

Unlike SQL, the semantics of INSERT and UPDATE are identical. In either case a record is created if none existed before, and updated when it does.

Specifying Options

You can specify these options:

• Consistency level
• Time-to-live (TTL)
• Timestamp (current time)

TTL columns are automatically marked as deleted (with a tombstone) after the requested amount of time has expired.

Example¶

INSERT INTO NerdMovies (KEY, 11924)
      VALUES ('cfd66ccc-d857-4e90-b1e5-df98a3d40cd6', 'johndoe')
    USING CONSISTENCY LOCAL_QUORUM AND TTL 86400;