Inserting, updating, and deleting data

For DSE Search, inserting and updating data uses the same CQL statements like any update to the database.

Updates to a CQL-based search index replaces the entire row. You cannot replace only a field in a CQL table.

The following example builds on the example from Querying a CQL collection set. This statement inserts data into mykeyspace.mysolr and the search index:

When using CQL to update a field, DSE Search implicitly updates individual fields in the Apache Solr™ document. The reindexing of data occurs automatically.