Creating a distributed hypertable is very similar to creating a
regular hypertable. The main difference is that you must use the
instead of the regular
CREATE TABLE conditions ( time TIMESTAMPTZ NOT NULL, location TEXT NOT NULL, temperature DOUBLE PRECISION NULL, humidity DOUBLE PRECISION NULL ); SELECT create_distributed_hypertable('conditions', 'time', 'location');
This creates a multi-dimensional distributed hypertable across all
data nodes, partitioned along
location. With the given
partitioning configuration, each data node will be responsible for a
specific subset of the data based on the value of
concurrent and parallel execution of a query across the data nodes.
You can now insert data into the distributed hypertable and the data will automatically be routed to the correct data node.