Creating Hypertables

To create a hypertable, you start with a regular SQL table, and then convert it into a hypertable via the function .

Next, transform it into a hypertable with create_hypertable:

TIP:The ‘time’ column used in the function supports timestamp, date, or integer types, so you can use a parameter that is not explicitly time-based, as long as it can increment. For example, a monotonically increasing id would work. You must specify a chunk time interval when creating a hypertable if you use a monotonically increasing id.

Inserting & Querying

Inserting data into the hypertable is done via normal SQL INSERT commands, e.g. using millisecond timestamps:

Similarly, querying data is done via normal SQL commands.