max_hyperscan_* session settings

These settings are available in system.settings and are autogenerated from source.

max_hyperscan_regexp_length

Type

UInt64

Default

Defines the maximum length for each regular expression in the hyperscan multi-match functions.

Possible values:

Positive integer.
0 - The length is not limited.

Example

Query:

SELECT multiMatchAny('abcd', ['ab','bcd','c','d']) SETTINGS max_hyperscan_regexp_length = 3;

Result:

┌─multiMatchAny('abcd', ['ab', 'bcd', 'c', 'd'])─┐
│                                              1 │
└────────────────────────────────────────────────┘

Query:

SELECT multiMatchAny('abcd', ['ab','bcd','c','d']) SETTINGS max_hyperscan_regexp_length = 2;

Result:

Exception: Regexp length too large.

See Also

max_hyperscan_regexp_total_length

max_hyperscan_regexp_total_length

Type

UInt64

Default

Sets the maximum length total of all regular expressions in each hyperscan multi-match function.

Possible values:

Positive integer.
0 - The length is not limited.

Example

Query:

SELECT multiMatchAny('abcd', ['a','b','c','d']) SETTINGS max_hyperscan_regexp_total_length = 5;

Result:

┌─multiMatchAny('abcd', ['a', 'b', 'c', 'd'])─┐
│                                           1 │
└─────────────────────────────────────────────┘

Query:

SELECT multiMatchAny('abcd', ['ab','bc','c','d']) SETTINGS max_hyperscan_regexp_total_length = 5;

Result:

Exception: Total regexp lengths too large.

See Also

max_hyperscan_regexp_length