v.20.4New Feature

Add Regexp Input Format Feature

Add Regexp input format. #9196 (Kruglov Pavel)
Introduces a new input format called Regexp that allows parsing input data using regular expressions.

Why it matters

The Regexp input format enables users to import and parse data that matches a specified regular expression pattern. This feature provides flexible and powerful data extraction capabilities from semi-structured or loosely formatted input, solving problems related to complex or irregular data ingestion.

How to use it

Users can enable the Regexp input format by specifying it in the FORMAT clause of their INSERT or SELECT queries and providing the appropriate regular expression pattern to parse the input data accordingly.