v.24.5New Feature

Add NPy Output Format Support

Add NPy output format. #62430 (豪肥肥).
Added support for the NPy output format in ClickHouse.

Why it matters

This feature introduces the NPy output format to enable easy export of query results into the NumPy binary file format (.npy), which is widely used for efficient storage and sharing of large numerical arrays in Python. It streamlines integration with Python-based data workflows by allowing direct output from ClickHouse to a format readily consumable by NumPy.

How to use it

To use the new NPy output format, specify it in the FORMAT clause of your query as follows:

SELECT * FROM <table_name> FORMAT NPy

This will output the query results in the NumPy binary format.