Read HDF5 datasets and attributes
Maintainer(s):
jokasimr
Installing and Loading
INSTALL h5db FROM community;
LOAD h5db;
Example
FROM h5_read('file.h5', '/some/dataset', '/another');
About h5db
This extension provides table functions for reading data and metadata from HDF5 files.
Features include:
h5_tree()table function to list groups and datasets in a file.h5_read()table function to read datasets.h5_attributes()table function to access attributes.- Multiple datasets: Read and combine multiple datasets in a single query.
- Multi-dimensional arrays: Support for 1D to 4D datasets.
- Projection pushdown: Reads only the datasets that are actually needed.
- Index column: Optionally adds an
indexcolumn that supports pushdown of constant range filters (>,<=,BETWEEN, etc.) for efficient selective reads. - Reads datasets that are larger than memory.
- Remote dataset reads via the
httpfsextension.
For full documentation, see: https://github.com/jokasimr/h5db.
Added Functions
| function_name | function_type | description | comment | examples |
|---|---|---|---|---|
| h5_alias | scalar | NULL | NULL | |
| h5_attributes | table | NULL | NULL | |
| h5_index | scalar | NULL | NULL | |
| h5_read | table | NULL | NULL | |
| h5_rse | scalar | NULL | NULL | |
| h5_tree | table | NULL | NULL | |
| h5db_version | scalar | NULL | NULL |
Overloaded Functions
| function_name | function_type | description | comment | examples | |—————|—————|————-|———|———-|
Added Types
| type_name | type_size | logical_type | type_category | internal | |———–|———-:|————–|—————|———-|
Added Settings
| name | description | input_type | scope | aliases |
|---|---|---|---|---|
| h5db_batch_size | Target batch size for h5_read chunk caching (e.g. 1MB, 8MB) | VARCHAR | GLOBAL | [] |
| h5db_swmr_default | Default to SWMR read mode for h5db table functions | BOOLEAN | GLOBAL | [] |