Re: Download solr data(only one field) to csv

[Emir Arnautović]

Hi Selvam,
Using start/rows to download 10M docs is what is called deep paging. You need 
to either use cursors 
(https://lucene.apache.org/solr/guide/6_6/pagination-of-results.html 
) or 
export handler 
(https://lucene.apache.org/solr/guide/6_6/exporting-result-sets.html 
).

HTH,
Emir
--
Monitoring - Log Management - Alerting - Anomaly Detection
Solr & Elasticsearch Consulting Support Training - http://sematext.com/



> On 23 Feb 2018, at 13:38, Selvam Raman  wrote:
> 
> Hi,
> 
> I have 10 million of record in solr index. I want to download whole record
> in csv format with one field.
> 
> I have 20+ fields, but i want to download data with (fl=title) only title
> field.
> 
> http://localhost:8983/solr/containerMetadata/select?q=*&fl=external_id_s,container_title_en&wt=csv&indent=true&rows=100
> 
> the above command not seems to effective to download 10 million record.
> Could you please suggest an idea?
> 
> -- 
> Selvam Raman
> "லஞ்சம் தவிர்த்து நெஞ்சம் நிமிர்த்து"

Download solr data(only one field) to csv

[Selvam Raman]

Hi,

I have 10 million of record in solr index. I want to download whole record
in csv format with one field.

I have 20+ fields, but i want to download data with (fl=title) only title
field.

http://localhost:8983/solr/containerMetadata/select?q=*&fl=external_id_s,container_title_en&wt=csv&indent=true&rows=100

the above command not seems to effective to download 10 million record.
Could you please suggest an idea?

-- 
Selvam Raman
"லஞ்சம் தவிர்த்து நெஞ்சம் நிமிர்த்து"