Manage the Apache Solr Connector
This material applies to Composer v7.9 and earlier. The data source configuration wizard has been removed from Composer as of version 7.10. See Define a Data Source Configuration.
- To add a source, navigate to the Sources page in Composer and select Add Source.
- To edit a source, select the source from the list on the Sources page in Composer to open and edit the source.
- Fields referenced in this procedure can be found in the Source Creation tab (was Tables/Indices tab and General tab), Fields tab, Cache tab (was Refresh tab), or Global Settings tab (was Visual tab and default Visual settings tab).
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.
Apache Solr connector support for specific Composer features is shown in the following table.
Key: Y - Supported; N - Not Supported; N/A - not applicable
|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 |
|Derived Fields (Row-Level Expressions)||N|
|Fast Distinct Values||Y|
|Group By Multiple Fields||Y|
|Group By Time||Y|
|Group By UNIX Time||Y|
|Histogram Floating Point Values||N|
|Live Mode and Playback||Y|
|Multivalued Fields||N||The Apache Solr JSON API does not support metrics by multivalued fields.
|Pushdown Joins for Fusion Data Sources||N|
|Text Search||Y||You can sort keyword searches by Best Match and Most Recent (when you 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.|
|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.
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.
Select the hosting type: Standalone or Cloud.
Specify a Solr Base URL.
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.
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.