Blog: SQL Editor for Solr SQL

[Romain Rigaux]

Originally published on http://gethue.com/sql-editor-for-solr-sql/

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.

 

Video: https://vimeo.com/174334432

 

In the Editor

 

In the notebook

 

 

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).

 

But we still hope that you play around with this new promising feature. If you have any questions, feel free to comment here or on the hue-user list, Solr community or @gethue!

Hue Team

[Romain Rigaux]

And here is the live demo of the new SQL Editor: http://demo.gethue.com/notebook/editor?editor=7