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');
create_distributed_hypertableand the distributed hypertable will not be created. Please review the section on setting up multi-node for information on how to add data nodes.
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.
Found an issue on this page?Report an issue!