Downloads 6.0kthis week

GitHub stars 6

Extension descriptor (YAML)

Read HDF5 datasets and attributes

Compatibility Matrix

This table covers all DuckDB releases that have not reached end-of-life, including LTS releases, and shows the 2 most recent patch releases of each. Older patch releases are not listed, but the extension may be available for them as well.

Installing and Loading

INSTALL h5db FROM community;
LOAD h5db;

Example

FROM h5_read('file.h5', '/some/dataset', '/another');

About h5db

This extension provides functions for reading data and metadata from HDF5 files.

Features include:

• h5_read() table function to read datasets.
• h5_tree() table function to list groups and datasets in a file, optionally including projected attributes.
• h5_attributes() table function to read attributes.
• h5_ls() table and scalar functions to list entries in groups.
• Multiple datasets: Read multiple datasets into separate columns.
• Multi-dimensional arrays: Support for 1D to 4D datasets.
• Projection pushdown: Read only the datasets that are actually needed.
• Index column: Optionally adds an index column that supports predicate pushdown of constant range filters (>, <=, BETWEEN, etc.) for efficient selective reads.
• Reads datasets that are larger than memory.
• Remote reads over HTTPS, S3, etc., via the DuckDB httpfs extension.
• Remote reads over SFTP via a built-in SFTP client.
• Globbing: Combine datasets from multiple files vertically (UNION ALL).

For full documentation, see the h5db repository.

Added Functions

Overloaded Functions

This extension does not add any function overloads.

Added Types

This extension does not add any types.

Added Settings