Hue already integrates with Apache Solr and provide Dynamic Search Dashboards. With the new SQL Editor of Hue 3.10, Hue opens up to any database, which is great as Solr 6 now provides a SQL interface.
Here is demo where we query a Solr collection like we would query a regular Hive or Impala table.
As Solr SQL is pretty recent, there are some caveats, notably Solr lacks support of:
- SELECT *
- WHERE close with a LIKE
- resultset pagination
which prevents a SQL UX experience comparable to the standard other databases (but we track it in HUE-3686).