Yep, you can have a single database with multiple retention policies. For
example:
create RETENTION POLICY "1hour" on "telegraf" DURATION 1h REPLICATION 1
DEFAULT
create RETENTION POLICY "1day" on "telegraf" DURATION 1d REPLICATION 1
create RETENTION POLICY "1week" on "telegraf" DURATION 1w
>From memory I did this with a continuous query similar to example 3 here:
https://docs.influxdata.com/influxdb/v1.4/query_language/continuous_queries/#examples-of-basic-syntax
CREATE CONTINUOUS QUERY "cq_basic_br" ON "transportation"
BEGIN
SELECT mean(*) INTO