Using the Solr HTTP API

Using the Solr HTTP API to query data indexed in DSE Search/Solr.

The Solr HTTP API is preferred over CQL solr_query statements for querying Cassandra for correctness and performance reasons; the solr_query is suitable only for simple, brief, and occasional testing and for simple administrative tasks, not for production usage. You can use the Solr HTTP API to query data indexed in DSE Search/Solr just as you would search for data indexed in OSS.

Solr HTTP API example

Assuming you performed the example of using a collection set, to find the titles in the mykeyspace.mysolr table that begin with the letters Succ in XML, use this URL:
http://localhost:8983/solr/mykeyspace.mysolr/select?q=%20title%3ASucc*&fl=title
The response is:
<response>
 <lst name="responseHeader">
   <int name="status">0</int>
   <int name="QTime">2</int>
   <lst name="params">
     <str name="fl">title</str>
     <str name="q">title:Succ*</str>
   </lst>
 </lst>
 <result name="response" numFound="2" start="0">
   <doc>
     <str name="title">Success</str>
   </doc>
   <doc>
     <str name="title">Success</str>
   </doc>
 </result>
</response>

Delete by query 

After you issue a delete by query, documents start getting deleted immediately and deletions continue until all documents are removed. For example you can delete the data that you inserted using this command on the operating system command line:

$ curl http://localhost:8983/solr/mykeyspace.mysolr/update --data
  '<delete><query>*:*</query></delete>' -H
   'Content-type:text/xml; charset=utf-8'