Inserting, updating, and deleting data

Steps for updating a CQL-based search index.

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.

To update a CQL-based search index:
  • Building on the Querying CQL collections example, insert data into mykeyspace.mysolr and the search index.
    INSERT INTO mykeyspace.mysolr ('id', 'quotes', 'name', 'title') VALUES ('130', 'Life is a beach', 'unknown', 'Life');

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