Jul 24, 2017 · 1 min read
Hi rohangulati: You query a hypertable in TimescaleDB just like you would any standard table. That is, we’ve hidden the fact / abstracted away the fact that all the data is partitioned into smaller chunks, and it just looks like a standard query to you.
http://docs.timescale.com/api#select
The query planner then knows how to properly execute a query on which chunks (based on the query and chunk constraints) and merge the results.
Same on the insert side: You just write one row or even many thousands of rows in a standard INSERT to the hypertable, the database figures out how to route this insert to its proper chunks (and possibly “split” the one insert across multiple chunks if needed).
