Filtering on terms

Filter rows on terms using the Solr Standard Parser syntax in CQL.

Filter rows returned by a CQL SELECT statement on terms using the Solr Standard Parser syntax.

The basic syntax to limit queries has the following syntax:

SELECT column_list FROM table_name
WHERE solr_query = 'standard_term_expression ...';

The Solr Standard Parser is a case-sensitive term search that supports boolean expressions with wildcards.

Tip: CQL for DSE Search also supports more complex searches using JSON-formatted query strings.

This section uses the Wikipedia Demo included in DataStax Enterprise. Replace standard_term_expression with the solr_query value from corresponding tables below to return the results:

SELECT count(*) FROM solr
WHERE solr_query = 'q_search_expression';

Attention: CQL Solr queries do not support native functions or column aliases as selectors. Only count(*) is supported with search index queries. Results use the Solr count process. Results might vary from the native CQL count function.