[influxdb] how to store/query forecast timeseries i.e. two timeseries keys pair

[Gautier]

Hi, I find this issue on github, https://github.com/influxdata/influxdb/issues/4314 which was not an issue but a good question...

Here is an exact copy of the question as the author never posted here on googlegroup as suggested (or I didn't find it)

hi there, is influxdb suitable for the following type of data? if so, could you please give me some hints on how shall I store them in order to query them efficiently? thanks

forecast_date, value_date, value
2015-01-01 23:00:00, 2015-01-01 00:00:00, 100.00
2015-01-01 23:00:00, 2015-01-01 12:00:00, 110.00
2015-01-02 00:00:00, 2015-01-02 12:00:00, 120.00
2015-01-02 00:00:00, 2015-01-03 00:00:00, 130.00

e.g. I want to query the latest forecast for each value_date point i.e.

2015-01-01 00:00:00, 100.00
2015-01-02 12:00:00, 120.00
2015-01-03 00:00:00, 130.00

[g***@fortilink.com]

Question is moved here :
https://community.influxdata.com/t/how-to-store-query-forecast-timeseries-i-e-two-timeseries-keys-pair/725

Gautier,
I would suggest using a `forecast_id` as a tag to differentiate the forecasts from one another. Then store the `value_date` as the timestamp. This is what I do when using `holt_winters`. In the future can you ask questions like this over on `community.influxdata.com`? We have moved the Q&A over there.
On Monday, April 24, 2017 at 5:55:13 AM UTC-7, Gautier wrote:Hi, I find this issue on github, https://github.com/influxdata/influxdb/issues/4314 which was not an issue but a good question...
Here is an exact copy of the question as the author never posted here on googlegroup as suggested (or I didn't find it)
hi there, is influxdb suitable for the following type of data? if so, could you please give me some hints on how shall I store them in order to query them efficiently? thanks
forecast_date, value_date, value
2015-01-01 23:00:00, 2015-01-01 00:00:00, 100.00
2015-01-01 23:00:00, 2015-01-01 12:00:00, 110.00
2015-01-02 00:00:00, 2015-01-02 12:00:00, 120.00
2015-01-02 00:00:00, 2015-01-03 00:00:00, 130.00
e.g. I want to query the latest forecast for each value_date point i.e.
2015-01-01 00:00:00, 100.00
2015-01-02 12:00:00, 120.00
2015-01-03 00:00:00, 130.00