Clickhouse: Regular expressions in function Clickhouse

Created on 11 Aug 2019 · 2Comments · Source: ClickHouse/ClickHouse

Hello. study ClickHouse. I am interested in the syntax of regular expressions. For example, I need to find string that contain character '2' followed by '3' or '4'. Has tried: '\2[3-4]' not particularly helps. Maybe someone can help, thank you.

question

Source

Eiilin-Maur

Most helpful comment


select x, match(x, '2[3-4]') as match from (select arrayJoin(['12345', '224', '125432']) x)

┌─x──────┬─match─┐
│ 12345  │     1 │
│ 224    │     1 │
│ 125432 │     0 │
└────────┴───────┘

den-crane on 11 Aug 2019

👍3

All 2 comments


select x, match(x, '2[3-4]') as match from (select arrayJoin(['12345', '224', '125432']) x)

┌─x──────┬─match─┐
│ 12345  │     1 │
│ 224    │     1 │
│ 125432 │     0 │
└────────┴───────┘

den-crane on 11 Aug 2019

👍3

We use re2 syntax that is a limited version of PCRE:
https://clickhouse.yandex/docs/en/query_language/functions/string_search_functions/#match-haystack-pattern