--- title: SQL Editor for Solr SQL author: admin type: post date: 2016-07-12T14:29:47+00:00 url: /sql-editor-for-solr-sql/ sf_thumbnail_type: - none sf_thumbnail_link_type: - link_to_post sf_detail_type: - none sf_page_title: - 1 sf_page_title_style: - standard sf_no_breadcrumbs: - 1 sf_page_title_bg: - none sf_page_title_text_style: - light sf_background_image_size: - cover sf_social_sharing: - 1 sf_related_articles: - 1 sf_sidebar_config: - left-sidebar sf_left_sidebar: - Sidebar-2 sf_right_sidebar: - Sidebar-1 sf_caption_position: - caption-right sf_remove_promo_bar: - 1 categories: - Querying --- Hue already integrates with Apache Solr and provide [Dynamic Search Dashboards][1]. With the [new SQL Editor][2] of Hue 3.10, Hue opens up to [any database][3], which is great as Solr 6 now provides a [SQL interface][4]. Here is demo where we query a Solr collection like we would query a regular Hive or Impala table.   {{< youtube u4ctEYl5Mlo >}}  
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][7]).   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][8] list, [Solr community][9] or [@gethue][10]! [1]: https://gethue.com/dynamic-search-dashboard-improvements-3/ [2]: https://gethue.com/new-sql-editor/ [3]: https://gethue.com/custom-sql-query-editors/ [4]: http://yonik.com/solr-6/ [5]: https://cdn.gethue.com/uploads/2016/05/solr-sql-editor.png [6]: https://cdn.gethue.com/uploads/2016/05/solr-sql-notebook.png [7]: https://issues.cloudera.org/browse/HUE-3686 [8]: http://groups.google.com/a/cloudera.org/group/hue-user [9]: http://lucene.apache.org/solr/resources.html [10]: https://twitter.com/gethue