Search Shortcut cmd + k | ctrl + k
tsfile

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.