Re: Connect Solr with ODBC to Excel

2015-02-25 Thread Hakim Benoudjit
I'll need to use /export since I retrieve large amount of data. And I don't really need facets, so it won't be an issue. Thanks again for your help. 2015-02-25 21:26 GMT+01:00 Mikhail Khludnev : > On Wed, Feb 25, 2015 at 10:31 PM, Hakim Benoudjit > wrote: > > > Thanks for the two links. > > The

Re: Connect Solr with ODBC to Excel

2015-02-25 Thread Mikhail Khludnev
On Wed, Feb 25, 2015 at 10:31 PM, Hakim Benoudjit wrote: > Thanks for the two links. > The first one could be helpful if it works. > Regarding the second one, > I think it's quite similar to using /select to > return json format. > not really. /export yields much more data faster. Also, if you

Re: Connect Solr with ODBC to Excel

2015-02-25 Thread Hakim Benoudjit
Thanks for the two links. The first one could be helpful if it works. Regarding the second one, I think it's quite similar to using /select to return json format. 2015-02-25 19:10 GMT+01:00 Mikhail Khludnev : > Some time ago I encounter https://github.com/kawasima/solr-jdbc never > tried > it.Any

Re: Connect Solr with ODBC to Excel

2015-02-25 Thread Mikhail Khludnev
Some time ago I encounter https://github.com/kawasima/solr-jdbc never tried it.Anyway, it doesn't help to connect from odbc. On top of my head, is https://cwiki.apache.org/confluence/display/solr/Exporting+Result+Sets but it returns only JSON, not csv. That's I wonder why. Seems like a dead end so

Re: Connect Solr with ODBC to Excel

2015-02-25 Thread Hakim Benoudjit
Thanks for your answer. For a one-off it seems like a nice way to import my data. For an ODBC connection, the only solution I found is to replicate my Solr data in Apache Hive (or Cassandra...), and then connect to that database through ODBC. 2015-02-25 15:49 GMT+01:00 Alexandre Rafalovitch : >

Re: Connect Solr with ODBC to Excel

2015-02-25 Thread Alexandre Rafalovitch
Which direction? You want import data from Solr into Excel? One off or repeatedly? For one off Solr -> Excel, you could probably use Excel's Open from Web and load data directly from Solr using CSV output format. Regards, Alex. Solr Analyzers, Tokenizers, Filters, URPs and even a newslett

Connect Solr with ODBC to Excel

2015-02-25 Thread Hakim Benoudjit
Hi there, I'm looking for a library to connect Solr throught ODBC to Excel in order to do some reporting on my Solr data? Anybody knows a library for that? Thanks. -- Cordialement, Best regards, Hakim Benoudjit