Enable joins

To enable join on a search index that previously had join disabled, set the _partitionKey, docValues, and indexed attributes to true, reload the schema, and rebuild the index.

Rebuilding the search index on a large dataset might take longer than the default timeout for cqlsh. Before launching cqlsh, you can override the timeout. See Adjusting timeout for index management.

Procedure

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;
```

Enable joins

Procedure

Was this helpful?

Give Feedback