Query Apache TsFile table-model files directly from DuckDB
Maintainer(s):
ColinLeeo
Installing and Loading
INSTALL tsfile FROM community;
LOAD tsfile;
Example
INSTALL tsfile FROM community;
LOAD tsfile;
SELECT time, device_id, temperature
FROM read_tsfile('/data/measurements.tsfile', 'sensors')
WHERE time BETWEEN 1700000000000 AND 1700003600000;
About tsfile
The TsFile extension exposes the read_tsfile(path, table_name) table function for querying Apache TsFile table-model files. It maps TsFile columns to DuckDB types, pushes projections and time predicates into the reader, and streams results in DuckDB vector-sized batches.
The initial release supports one local file and one table per scan. Tree-model files, multi-file scans, automatic table discovery, parallel scans, and TAG/FIELD predicate pushdown are not yet implemented.
Added Functions
| function_name | function_type | description | comment | examples |
|---|---|---|---|---|
| read_tsfile | table | NULL | NULL |
Overloaded Functions
This extension does not add any function overloads.
Added Types
This extension does not add any types.
Added Settings
This extension does not add any settings.