Skip to main content

Querying Hypertables

Hypertables are accessed like any SQL table or view. There are some rules though. While referring to a Hypertable in a SQL query, always prefix the hypertable name with hypertables.default for live Hypertables and hypertables.scheduled for scheduled Hypertables.

Scheduled Hypertables​

SELECT
  *
FROM
  hypertables.scheduled.ent_assets
WHERE
  region = 'europe'

Live Hypertables​

SELECT
  *
FROM
  hypertables.default.sales_2023
WHERE
  region = 'europe'