v.23.10New Feature

Support for Npy Format in ClickHouse

Official CH changelog text
Support for Npy format. SELECT * FROM file('example_array.npy', Npy). #55982 (Yarik Briukhovetskyi).
Added support for the Npy file format in ClickHouse, allowing users to query NumPy array files directly using the file table function.

Why it matters

This feature enables users to seamlessly read and query data stored in NumPy's .npy binary array format without external conversion, simplifying data integration workflows especially for users working with scientific and machine learning data.

How to use it

Use the file table function with the Npy format specified to query .npy files directly. For example:

SELECT * FROM file('example_array.npy', Npy)

Related resources

PreviousNext