v.19.14New Feature

Table Function Values (the Name Is Case-insensitive)

Official CH changelog text
Table function values (the name is case-insensitive). It allows to read from VALUES list proposed in #5984. Example: SELECT * FROM VALUES('a UInt64, s String', (1, 'one'), (2, 'two'), (3, 'three')). #6217. #6209 (dimarub2000)
Introduces a case-insensitive table function values that allows reading data directly from an inline VALUES list in a query.

Why it matters

This feature enables users to easily create in-memory datasets and perform queries on them without needing to create temporary tables or external files, improving convenience and flexibility for ad-hoc data processing and testing.

How to use it

Use the values table function by specifying the column definitions as a string and providing tuples of data rows, for example:

SELECT * FROM values('a UInt64, s String', (1, 'one'), (2, 'two'), (3, 'three'))


The function name values is case-insensitive.

Related resources

PreviousNext