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 <mkhlud...@griddynamics.com>: > On Wed, Feb 25, 2015 at 10:31 PM, Hakim Benoudjit <h.benoud...@gmail.com> > 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 are interested in relatively short result set, you > can /select&wt=csv no facets in this case, sadly. Just fyi. > > > > > > 2015-02-25 19:10 GMT+01:00 Mikhail Khludnev <mkhlud...@griddynamics.com > >: > > > > > 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 far. > > > > > > On Wed, Feb 25, 2015 at 6:15 PM, Hakim Benoudjit < > h.benoud...@gmail.com> > > > wrote: > > > > > > > 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 <arafa...@gmail.com > >: > > > > > > > > > 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 newsletter: > > > > > http://www.solr-start.com/ > > > > > > > > > > > > > > > On 25 February 2015 at 08:52, Hakim Benoudjit < > h.benoud...@gmail.com > > > > > > > > wrote: > > > > > > 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 > > > > > > > > > > > > > > > > > > > > > -- > > > > Cordialement, > > > > Best regards, > > > > Hakim Benoudjit > > > > > > > > > > > > > > > > -- > > > Sincerely yours > > > Mikhail Khludnev > > > Principal Engineer, > > > Grid Dynamics > > > > > > <http://www.griddynamics.com> > > > <mkhlud...@griddynamics.com> > > > > > > > > > > > -- > > Cordialement, > > Best regards, > > Hakim Benoudjit > > > > > > -- > Sincerely yours > Mikhail Khludnev > Principal Engineer, > Grid Dynamics > > <http://www.griddynamics.com> > <mkhlud...@griddynamics.com> > -- Cordialement, Best regards, Hakim Benoudjit
