Configuring search index joins

DataStax Enterprise supports solr_query joins on the partition key field (_partitionKey). By default, the solr_query join functionality is enabled and DSE indexes the partitioning columns in this additional field. This field, _partitionKey, increases search index size. Disabling joins can decrease the amount of disk space the search indexes uses.

Join settings in the schema

DESCRIBE ACTIVE SEARCH INDEX displays the schema settings of a search index. DSE hides the definition of the _partitionKey when joins are enabled.

If the schema contains a field named _partitionKey, support for joins is:

Enabled: attributes docValues and indexed are set to true. For example:

<field name="_partitionKey" **docValues="true"** **indexed="true"** stored="false" type="StrField"/>

Disabled: attributes docValues and indexed are set to false. For example:

<field **docValues="false"** **indexed="false"** multiValued="false" name="_partitionKey" omitNorms="true" **stored="false"** type="StrField"/>

If the schema contains no field definition for _partitionKey, then joins are enabled.

Start cqlsh on a node that is running DSE Search.

Set the docValues and indexed attributes to true:

ALTER SEARCH INDEX SCHEMA ON wiki.solr
SET field[@name='_partitionKey']@docValues='true';
ALTER SEARCH INDEX SCHEMA ON wiki.solr
SET field[@name='_partitionKey']@indexed='true';

Reload the schema to make it active:
```
RELOAD SEARCH INDEX ON wiki.solr;
```

Reload the schema to make it active:
```
RELOAD SEARCH INDEX ON wiki.solr;
```
Rebuild the search index:
```
REBUILD SEARCH INDEX ON wiki.solr;
```

include:disablesJoins.adoc[leveloffset=+1]

Configuring search index joins

Join settings in the schema

Prerequisite

Enable joins

Procedure

Was this helpful?

Give Feedback