Re:Apache Solr 6.3.0 released
by IndianAstronaut on Saturday November 12, 2016 @01:19AM
(#12936878)
As a commiter, are there plans to improve the SOLR SQL interface and add features to make it more in line with standard SQL? Also, any plans on adding search syntax to the SQL?
Not by me, but the SQL interface is the bleeding edge of Solr. If the last time you looked was a month ago, look again. The feature set probably doubled since. And, for this, don't rely on documentation, it is not complete yet. Rather, check the Lucene Solr Revolution 2016 slides/videos and search Jira for SQL keyword. And if you have solid use cases, feel free to create a feature-request Jira or even help to test and/or develop it.
I am somewhat biased because I am a - recent - Solr committer. But I also did try to do a very balanced comparison presentation two years ago: http://www.slideshare.net/arafalov/solr-vs-elasticsearch-cas... (kind of popular, 49k views...).
Solr - still - is more flexible than Elasticsearch by several degrees of magnitude. But Elasticsearch has a better vertical integration story, especially for analytics. And size (it IS small), because it does not ship OOTB with documentation (online), full examples (any?), Admin UI (plugin), rich-text extraction (plugin), data import mechanism (with rivers gone), etc.
If you don't need those, the choice is much more close. And many people do not need those. The problem is that most of the people don't know what they need and don't need when they do the evaluation, so they look at the most surface parameters.
Solr 6 has good startup scripts, (overly) comprehensive examples, REST APIs, well maintained 700 pages manual, etc. Some of these features are a bit harder to discover due to legacy information also being very visible. But it is there.