Inserting and updating data

Steps for updating a CQL-based core.

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

Updates to a CQL-based Solr core replace the entire row. You cannot replace only a field in a CQL table.

To update a CQL-based core:

Procedure

Building on the collections example, insert data into the mykeyspace.mytable data and Solr index.
INSERT INTO mykeyspace.mysolr ('id', 'quotes', 'name', 'title') VALUES ('130', 'Life is a beach', 'unknown', 'Life');

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