Skip to main content

SEARCH_REQUIRES_SEARCHABLE_COLUMNS error condition

SQLSTATE: 42809

<context> requires columns with searchable types (STRING COLLATE UTF8_BINARY, VARIANT, or ARRAY).

STAR_EXPANDED_TO_NONE

The wildcard (<starTarget>*) expanded to no searchable columns. Please explicitly specify columns or structs with searchable types (STRING COLLATE UTF8_BINARY, VARIANT, or ARRAY) instead of using the wildcard.

STRUCT_HAS_NO_SEARCHABLE_FIELDS

Struct <fieldName> contains no searchable fields. Please specify a different struct that contains at least one searchable column of type STRING COLLATE UTF8_BINARY, VARIANT, or ARRAY, or select individual searchable columns.

UNSUPPORTED_COLUMN_TYPE

Column <columnName> has type <dataType>. Please specify a different column or struct with searchable types (STRING COLLATE UTF8_BINARY, VARIANT, or ARRAY).