[docs] Refactor Solr connector configuration section
@@ -602,7 +602,7 @@ Then give Hue the information about the database source:
#### SQL
-Query collections like we would query a regular database.
+Query Solr collections like you would query a regular database via [Solr SQL](https://gethue.com/sql-editor-for-solr-sql/).
The dialect should be added to the Python system or Hue Python virtual environment:
@@ -617,17 +617,11 @@ Then give Hue the information about the database source:
interface=sqlalchemy
options='{"url": "solr://<username>:<password>@<host>:<port>/solr/<collection>[?use_ssl=true|false]"}'
-#### Native
+**Note**
-As Solr SQL is pretty recent, the native implementation has some caveats, notably Solr lacks support of:
+There is also a native implementation which has some caveats ([HUE-3686](https://issues.cloudera.org/browse/HUE-3686) but reuses the `Dashboard` configuration which is builtin in CDH/CDP.
-* 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](https://issues.cloudera.org/browse/HUE-3686)).
-
-First make sure Solr search is [configured](#apache-solr):
+First make sure Solr is configured for Dashboards (cf. section just below):
Then add the interpreter:
@@ -637,8 +631,9 @@ Then add the interpreter:
## Name of the collection handler
# options='{"collection": "default"}'
-### Dashboards
-Solr provide great [dashboards](/user/querying/#dashboard). Just point to an existing Solr:
+#### Dashboards
+
+Hue ships the [dynamic dashboards](/user/querying/#dashboard)for exploring datasets visually. Just point to an existing Solr server:
[search]
