CONTAINS_SUBSEQUENCE

Syntax

CONTAINS_SUBSEQUENCE( array_1, array_2 )

Description

Returns TRUE if array_2 is a continuous subsequence of array_1. In other words, returns TRUE if and only if array1 = prefix + array2 + suffix.

Argument types:

  • array_1 — Array of fractional numbers | Array of integers | Array of strings
  • array_2 — Array of fractional numbers | Array of integers | Array of strings

Return type: Boolean

Example

[array1] [array2] CONTAINS_SUBSEQUENCE([array1], [array2])
'[1,2,3]' '[1,2]' True
'[1,2,3]' '[2,1]' False
'[1,2,3]' '[1,3]' False

Data source support

ClickHouse 21.8.

Previous
CONTAINS_ANY
Next
COUNT_ITEM