Menu
I need to export solr data to EXCEL or CSV. I have SOLR code with millions of records and I need a way to export them by a certain query to CSV/EXCEL. In addition I need to control the headers inside the EXCEL.
What do you suggest? Is there a 3rd party API that does it? Should I use CSV format and just extract them and then manipulate the csv?
970
asked Oct 01 '17 08:10
You can use /export to make requests to export the result set of a query. All queries must include sort and fl parameters, or the query will return an error. Filter queries are also supported. The supported response writers are json and javabin .
Procedure. In the DA Explorer view, right-click the connection name that contains the model that you want to export. Click Export to File as CSV. In the Export to CSV window, select the location where you want to save the data and click Save.
The best tool to export your Solr data is the /export request handler [1].
Unfortunately, from the official Solr documentation, csv is not supported as an output.
Json is the default. If you can manage Json transformations to obtain the data format you want in CSV, the /export is definitely the best way to proceed. If performance is not an issue, the standard select request handler using the CSV response writer should do the trick [2].
http:/localhost:8983/solr/collection1/select?q=*:*&wt=csv&indent=true&rows=N
[1] https://lucene.apache.org/solr/guide/6_6/exporting-result-sets.html
[2] http:/localhost:8886/solr/tech/select?q=:&wt=csv&indent=true
136
answered Sep 16 '22 20:09
You may use Solr select endpoint to extract all documents with q=*:* and csv responseWriter.
Example:
http:/localhost:8886/solr/tech/select?q=*:*&wt=csv&indent=true
More details about csv ResponseWriter can be found here.
29
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
