For Solr 6, ParallelSQL and Solr JDBC driver are going to be developed more as well as JSON facets. The Solr JDBC driver that is in Solr 6 contains SOLR-8502. There are further improvements coming in SOLR-8659 that didn't make it into 6.0. The Solr JDBC piece leverages ParallelSQL and in some cases uses JSON facets under the hood.
The Solr JDBC driver should enable BI tools to connect to Solr and use the language of SQL. This is also a familiar interface for many Java developers. Just a note: Solr is not an RDBMS and shouldn't be treated like one even with a JDBC driver. The Solr JDBC driver is more of a convenience for querying. Kevin Risden On Tue, Apr 12, 2016 at 6:24 PM, Erick Erickson <erickerick...@gmail.com> wrote: > The unsatisfactory answer is that the have different characteristics. > > The analytics contrib does not work in distributed mode. It's not > receiving a lot of love at this point. > > The JSON facets are estimations. Generally very close but are not > guaranteed to be 100% accurate. The variance, as I understand it, > is something on the order of < 1% in most cases. > > The pivot facets are accurate, but more expensive than the JSON > facets. > > And, to make matters worse, the ParllelSQL way of doing some > aggregations is going to give yet another approach. > > Best, > Erick > > On Tue, Apr 12, 2016 at 7:15 AM, Pablo <anzorena.f...@gmail.com> wrote: > > Hello, > > I think this topic is important for solr users that are planning to use > solr > > as a BI Tool. > > Speaking about facets, nowadays there are three majors way of doing > (more or > > less) the same in solr. > > First, you have the pivot facets, on the other hand you have the > Analytics > > component and finally you have the JSON Facet Api. > > So, which line is Solr following? Which of these component is going to > be in > > constant development and which one is going to be deprecated sooner. > > In Yonik page, there are some test that shows how JSON Facet Api performs > > better than legacy facets, also the Api was way simpler than the pivot > > facets, so in my case that was enough to base my solution around the JSON > > Api. But I would like to know what are the thoughts of the solr > developers. > > > > Thanks! > > > > > > > > -- > > View this message in context: > http://lucene.472066.n3.nabble.com/Which-line-is-solr-following-in-terms-of-a-BI-Tool-tp4269597.html > > Sent from the Solr - User mailing list archive at Nabble.com. >
