(v7) Manage the Apache Solr Connector

Manage the Apache Solr Connector

The Composer Apache Solr connector lets you access the data available in your Apache Solr databases using the Composer client. The Composer Apache Solr connector supports Apache Solr versions 7.4 through 8.4.

Before you can establish a connection from Composer to an Apache Solr database, a connector server needs to be installed, configured and enabled. See Manage Connectors and Connector Servers for general instructions and Connect to Apache Solr for details specific to the Apache Solr connector.

After the connector has been set up, you can create data source configurations that specify the necessary connection information and identify the data you want to use. See Manage Data Source Configurations for more information. After data sources are configured, they can be used to create dashboards and visuals from your data. See Create Dashboards.

Composer Feature Support

Apache Solr connector support for specific Composer features is shown in the following table.

Key: Y - Supported; N - Not Supported; N/A - not applicable

Feature	Supported?			Notes
Admin-Defined Functions	N
Box Plots	Y
Custom SQL Queries	N			If you need to access a BigQuery partition, explicitly include an alias for the built in partition column in your select clause, such as select *, _PARTITIONTIME as pt from projectId.datasetId.tableId.
Derived Fields (Row-Level Expressions)	N
Distinct Counts	Y
Fast Distinct Values	Y
Group By Multiple Fields	Y
Group By Time	Y
Group By UNIX Time	Y
Histogram Floating Point Values	N
Histograms	Y
Kerberos Authentication	Y
Last Value	N
Live Mode and Playback	Y
Multivalued Fields	N			The Apache Solr JSON API does not support metrics by multivalued fields.
Nested Fields	N
Partitions	N/A
Pushdown Joins for Fusion Data Sources	N
Schemas	N/A
Text Search	Y			You can sort keyword searches by Best Match and Most Recent (select a preferred time field from the source). Filter your search results by selecting fields in the Filter modal. Select Clear All to clear filtered search results.
TLS	N
User Delegation	Y
Wildcard Filters	Y
Wildcard Filters, Case-Insensitive Mode	N			Case-sensitivity cannot be enforced. Consequently, neither case-sensitive or case-insensitive wildcard filters are supported.
Wildcard Filters, Case-Sensitive Mode	N			Case-sensitivity cannot be enforced. Consequently, neither case-sensitive or case-insensitive wildcard filters are supported.

In addition, Apache Solr supports the Request Handler field on the Tables/Indices tab of the data source configuration. You can use this box at the top of the Field table on the Tables/Indices tab to specify a request handler plug-in that defines the logic used when executing a search request.

For Kerberos authentication instructions, see Connect to Apache Solr Data Stores That Use Kerberos Authentication. For instructions on using user delegation with the Apache Solr connector, see Configure User Delegation for the Apache Solr Connector.

Connect to Apache Solr

You can configure the Composer Apache Solr connector to connect to a kerberized Apache Solr data store. For more information, see Connect to Apache Solr Data Stores That Use Kerberos Authentication.

When establishing a connection to Apache Solr, you must provide the following information.

1. Select the hosting type: Standalone or Cloud.

2. Specify a Solr Base URL.

3. Specify the version of the Solr source that you are going to connect to in the following format: <major>.<minor>.<patch>. This field is optional.

   While connecting to Solr, Composer first checks its version. If the version is not available, Composer checks the version that you have specified in this field and attempts to connect that version.

4. If authentication has been set up, provide the user name and password.

Dashboard and Visual Considerations

Distinct count and percentiles metrics return approximate values in Solr, due to the nature of the data source. The precision of the result returned by distinct count metric depends on the precision threshold setting (default value is 1000).

When you create a bar chart using an Apache Solr data source, you can search for a specific word or phrase using the search box at the top of the dashboard. The Details tab displays the results.

Fields of time groupings with low time granularity may cause loading time issues for the data source.