Time Series: Device Readings with Metadata

CrateDB supports effective time series analysis with enhanced features for fast aggregations.

What’s Inside

• Rich data types for storing structured nested data (OBJECT) alongside time series data.

• A rich set of built-in functions for aggregations.

• Relational JOIN operations.

• Common table expressions (CTEs).

Combine time series data with document data: CrateDB is all you need.

Analyzing Device Readings with Metadata Integration

Time Series: Advanced SQL

CrateDB provides enhanced features for querying time series data.

What’s Inside

• Run aggregations with gap filling / interpolation, using common table expressions (CTEs) and LAG / LEAD window functions.

• Find maximum values using the MAX_BY aggregate function, returning the value from one column based on the maximum or minimum value of another column within a group.

Advanced queries on time series data: CrateDB is all you need.

Analyzing Weather Data