points_int#

Integer time series: counters, discrete states, bitfields, and anything else recorded as a whole number.

Telemetry table, so every query must filter by dataset_rid.

For what a channel is, see Channels in the data model.

Columns#

Column

Type

Nullable

Notes

ts

TIMESTAMP

No

Sample time, nanosecond precision.

value

BIGINT

Yes

The sample. Null where a sample exists but carries no value.

channel

VARCHAR

No

Channel name.

dataset_rid

VARCHAR

No

Dataset the sample belongs to. Required in the WHERE clause.

tags

MAP

No

Key-value pairs recorded with the series. See Filtering by tag.

Examples#

Read a counter over time:

SELECT ts, value
FROM points_int
WHERE dataset_rid = '<dataset-rid>'
  AND channel = 'packet_count'
ORDER BY ts
LIMIT 1000

How long each discrete state was reported:

SELECT value AS state, COUNT(*) AS samples
FROM points_int
WHERE dataset_rid = '<dataset-rid>'
  AND channel = 'system_mode'
GROUP BY value
ORDER BY samples DESC

Test a single bit of a status word. The bitwise functions are telemetry-only and take a literal bit index from 0 to 63:

SELECT ts, BIT_TEST(value, 3) AS fault_bit_set
FROM points_int
WHERE dataset_rid = '<dataset-rid>'
  AND channel = 'status_word'
ORDER BY ts

Next steps#