​

Field Details

• ​

  SEARCH

  public static final String SEARCH

  Full text search query with wildcards and boolean operators. Note that for this mode, no column can be specified in columnNames; all string columns of the table that have text search enabled will be searched.

  See Also:

  • Constant Field Values

• ​

  EQUALS

  public static final String EQUALS

  Exact whole-string match (accelerated).

  See Also:

  • Constant Field Values

• ​

  CONTAINS

  public static final String CONTAINS

  Partial substring match (not accelerated). If the column is a string type (non-charN) and the number of records is too large, it will return 0.

  See Also:

  • Constant Field Values

• ​

  STARTS_WITH

  public static final String STARTS_WITH

  Strings that start with the given expression (not accelerated). If the column is a string type (non-charN) and the number of records is too large, it will return 0.

  See Also:

  • Constant Field Values

• ​

  REGEX

  public static final String REGEX

  Full regular expression search (not accelerated). If the column is a string type (non-charN) and the number of records is too large, it will return 0.

  See Also:

  • Constant Field Values

• ​

  SEARCH_STATS

  public static final String SEARCH_STATS

  Cross-shard BM25 corpus statistics for one (column, query) pair. Returns the merged BM25 statistics (max_doc, doc_count, sum_total_term_freq, per-term doc_freq / total_term_freq) needed by callers that score documents themselves (e.g. text_match_bm25_global SQL function pre-pass). Requires COLUMN_NAMES to contain exactly one column with text search enabled. The VIEW_NAME field is ignored — this mode does not produce a result table.

  See Also:

  • Constant Field Values