Identifying the partition key

Example:

SELECT id, date, value FROM keyspace.table WHERE id = 'series1' AND solr_query='value:bar*';

CQL partition key restrictions work only with fully specified partition keys.

CREATE TABLE vtbl (k1 text, k2 text, value text, PRIMARY KEY (k1, k2));

For example, with the above table, avoid using a query such as shown below:

SELECT * FROM vtbl WHERE k1 = '50' AND solr_query='value:*'

Use a filter query against the partially specified composite partition key, "fq":"k1:50":

SELECT * FROM valuetable WHERE solr_query='{"q":"value:*", "fq":"k1:50"}'

Solr CQL queries support limited use of the token function. The token function enables targeted search that restricts the nodes queried to reduce latency.

Example:

SELECT id, value FROM keyspace.table WHERE token(id) >= -3074457345618258601 AND token(id) <= 3074457345618258603 AND solr_query='id:*'

Example with an open range:

SELECT id, value FROM keyspace.table WHERE token(id) >= 3074457345618258604 AND solr_query='id:*'

Constraints apply to using the token function with Solr CQL queries:

• token() cannot be used with route.range or route.partition
• Wrapping token() ranges are not supported
• A specified token() range must be owned by a single node; ranges cannot span multiple nodes
• Because DSE uses the Solr single-pass queries, only the fields that are declared in the search schema are returned in the query results. If you have columns that do not need to be indexed but still need to be returned by using a token-restricted query, you can declare the columns as stored non-indexed fields in your schema.xml file.

To prevent the _partitionKey field from being indexed, set indexed to false:

<field name="_partitionKey" type="string" indexed="false"/>

To prevent building docValues for the _partitionKey field, set docValues to false:

<field name="_partitionKey" type="string" docValues="false"/>