Del via


SEARCH_INDEX_INVALID_PARAMETERS error condition

SQLSTATE: 42K06

Cannot create search index, invalid parameter is given:

CLUSTER_BY_BUCKET_REQUIRES_CLUSTER_BY_CLAUSE

Cannot use cluster_by_bucket_size without a CLUSTER BY clause. Add a CLUSTER BY clause to specify the partitioning column.

CLUSTER_BY_COLUMN_INCOMPATIBLE_BUCKET_SIZE

Bucket size '<bucketSize>' is too granular for column <columnName> of type DATE. Use a bucket size with at least day-level granularity for DATE columns.

INVALID_PARAMETER_VALUE

<parameterName> must be one of the following values: <allowedValues>.

PARAMETER_MUST_BE_GREATER_THAN

<parameterName> must be greater than or equal to <minValue>.

PARAMETER_MUST_BE_INTEGER

<parameterName> must be an integer value.

PARAMETER_MUST_BE_LESS_THAN

<parameterName> must be less than or equal to <maxValue>.

UNKNOWN_PARAMETER_KEYS

<parameterNames> are not recognized parameters.

UNSUPPORTED_PARAMETER_FOR_TOKENIZER

<parameterName> is not supported when using the <tokenizer> tokenizer.