How to delete all data from solr and hbase

Question

How do I delete all data from solr by command   We are using solr with lily and hbase   How can I delete data from both hbase and solr   http   lucene apache org solr 4 10 0 tutorial html Deleting Data

User · Answer

To delete all documents of a Solr collection, you can use this request:

curl -X POST -H 'Content-Type: application/json' --data-binary '{"delete":{"query":"*:*" }}' http://localhost:8983/solr/my_collection/update

It uses JSON body.

User · Answer

Post json data  e g  with curl   curl -X POST -H  Content-Type  application json         http    lt host gt   lt port gt  solr  lt core gt  update commit true        -d     delete     query

User · Answer

Solr I am not sure but you can delete all the data from hbase using truncate command like below   truncate  table name    It will delete all row-keys from hbase table

User · Answer

If you want to delete all of the data in Solr via SolrJ do something like this   public static void deleteAllSolrData         HttpSolrServer solr   new HttpSolrServer  http   localhost 8080 solr core         try         solr deleteByQuery               catch  SolrServerException e          throw new RuntimeException  Failed to delete data in Solr                e getMessage    e         catch  IOException e          throw new RuntimeException  Failed to delete data in Solr                e getMessage    e             If you want to delete all of the data in HBase do something like this   public static void deleteHBaseTable String tableName  Configuration conf        HBaseAdmin admin   null          try           admin   new HBaseAdmin conf           admin disableTable tableName           admin deleteTable tableName         catch  MasterNotRunningException e            throw new RuntimeException  Unable to delete the table     tableName              The actual exception is      e getMessage    e         catch  ZooKeeperConnectionException e            throw new RuntimeException  Unable to delete the table     tableName              The actual exception is      e getMessage    e         catch  IOException e            throw new RuntimeException  Unable to delete the table     tableName              The actual exception is      e getMessage    e         finally           close admin

User · Answer

When clearing out a Solr index  you should also do a commit and optimize after running the delete-all query   Full steps required  curl is all you need   http   www alphadevx com a 365-Clearing-a-Solr-search-index

User · Answer

Use the  match all docs  query in a delete by query command     You must also commit after running the delete so  to empty the index  run the following two commands    curl http   localhost 8983 solr update --data   lt delete gt  lt query gt     lt  query gt  lt  delete gt   -H  Content-type text xml  charset utf-8   curl http   localhost 8983 solr update --data   lt commit  gt   -H  Content-type text xml  charset utf-8

User · Answer

I ve used this request to delete all my records but sometimes it s necessary to commit this   For that  add  amp commit true to your request    http   host port solr core update stream body  lt delete gt  lt query gt     lt  query gt  lt  delete gt  amp commit true

User · Answer

You can use the following commands to delete  Use the  match all docs  query in a delete by query command      lt delete gt  lt query gt     lt  query gt  lt  delete gt    You must also commit after running the delete so  to empty the index  run the following two commands   curl http   localhost 8983 solr update --data   lt delete gt  lt query gt     lt  query gt  lt  delete gt   -H  Content-type text xml  charset utf-8  curl http   localhost 8983 solr update --data   lt commit  gt   -H  Content-type text xml  charset utf-8    Another strategy would be to add two bookmarks in your browser   http   localhost 8983 solr update stream body  lt delete gt  lt query gt     lt  query gt  lt  delete gt  http   localhost 8983 solr update stream body  lt commit  gt     Source docs from SOLR   https   wiki apache org solr FAQ How can I delete all documents from my index 3F

User · Answer

If you need to clean out all data  it might be faster to recreate collection  e g   solrctl --zk localhost 2181 solr collection --delete  lt collectionName gt  solrctl --zk localhost 2181 solr collection --create  lt collectionName gt  -s 1

User · Answer

I made a JavaScript bookmark which adds the delete link in Solr Admin UI   x000D   x000D  javascript   function     x000D      var str   a  new href  href  upd str    update stream body  lt delete gt  lt query gt     lt  query gt  lt  delete gt  amp commit true   x000D       a       result a url    x000D      href    a attr  href    x000D      str   href match    solr             1   x000D      new href   href replace str  upd str   x000D          result   prepend   lt a id  url upd  class  address-bar  href      new href      gt  lt strong gt DELETE ALL lt  strong gt        new href     lt  a gt     x000D        x000D   x000D   x000D

User · Answer

fire this in the browser  http   localhost 8983 solr update stream body  lt delete gt  lt query gt     lt  query gt  lt  delete gt  amp commit true  this commmand will delete all the documents in index in solr

User · Answer

I ve used this query to delete all my records   http   host solr core-name update stream body  3Cdelete 3E 3Cquery 3E    3C query 3E 3C delete 3E amp commit true

User · Answer

The curl examples above all failed for me when I ran them from a cygwin terminal  There were errors like this when i ran the script example    curl http   192 168 2 20 7773 solr CORE1 update --data   lt delete gt  lt query gt     lt  query gt  lt  delete gt   -H  Content-type text xml  charset utf-8   lt  xml version  1 0  encoding  UTF-8   gt   lt response gt   lt lst name  responseHeader  gt  lt int name  status  gt 0 lt  int gt  lt int name  QTime  gt 1 lt  int gt  lt  lst gt   lt  response gt   lt  --       It looks like it deleted stuff  but it did not go away      maybe because the committing call failed like so  -- gt  curl http   192 168 1 2 7773 solr CORE1 update --data-binary    -H  Content-type text xml  charset utf-8   lt  xml version  1 0  encoding  UTF-8   gt   lt response gt   lt lst name  responseHeader  gt  lt int name  status  gt 400 lt  int gt  lt int name  QTime  gt 2 lt  int gt  lt  lst gt  lt lst name  error  gt  lt str name  msg  gt Unexpected EOF in prolog  at  row col  unknown-source     1 0  lt  str gt  lt int name  code  gt 400 lt  int gt  lt  lst gt   lt  response gt    I needed to use the delete in a loop on core names to wipe them all out in a project   This query below worked for me in the Cygwin terminal script   curl http   192 168 1 2 7773 hpi CORE1 update stream body  lt delete gt  lt query gt     lt  query gt  lt  delete gt  amp commit true  lt  xml version  1 0  encoding  UTF-8   gt   lt response gt   lt lst name  responseHeader  gt  lt int name  status  gt 0 lt  int gt  lt int name  QTime  gt 1 lt  int gt  lt  lst gt   lt  response gt    This one line made the data go away and the change persisted

User · Answer

I tried the below steps  It works well    Please make sure the SOLR server it running Just click the link Delete all SOLR data which will hit and delete all your SOLR indexed datas then you will get the following details on the screen as output    lt response gt     lt lst name  responseHeader  gt       lt int name  status  gt 0 lt  int gt       lt int name  QTime  gt 494 lt  int gt     lt  lst gt   lt  response gt   if you are not getting the above output then please make sure the following    I used the default host  localhost  and port  8080  on the above link  please alter the host and port if it is different in your end   The default core name should be collection   collection1  I used collection1 in the above link  please change it too if your core name is different

User · Answer

If you re using Cloudera 5 x  Here in this documentation is mentioned that Lily maintains the Real time updations and deletions also   Configuring the Lily HBase NRT Indexer Service for Use with Cloudera Search     As HBase applies inserts  updates  and deletes to HBase table cells    the indexer keeps Solr consistent with the HBase table contents  using   standard HBase replication    Not sure iftruncate  hTable  is also supported in the same   Else you create a Trigger or Service to clear up your data from both Solr and HBase on a particular Event or anything

User · Answer

I came here looking to delete all documents from solr instance through  Net framework using SolrNet  Here is how I was able to do it   Startup Init lt MyEntity gt   http   localhost 8081 solr    ISolrOperations lt MyEntity gt  solr       ServiceLocator Current GetInstance lt ISolrOperations lt MyEntity gt  gt     SolrQuery sq   new SolrQuery         solr Delete sq   solr Commit      This has cleared all the documents   I am not sure if this could be recovered  I am in learning and testing phase of Solr  so please consider backup before using this code

User · Answer

From the command line use    bin post -c core name -type text xml -out yes -d    lt delete gt  lt query gt     lt  query gt  lt  delete gt

User · Answer

If you want to clean up Solr index -   you can fire http url -    http   host port solr  core name  update stream body  lt delete gt  lt query gt     lt  query gt  lt  delete gt  amp commit true    replace  core name  with the name of the core you want to delete from   Or use this if posting data xml data    lt delete gt  lt query gt     lt  query gt  lt  delete gt    Be sure you use commit true to commit the changes    Don t have much idea with clearing hbase data though

[solr] How to delete all data from solr and hbase

Examples related to solr

Examples related to hbase