I need to perform query operation on openTSDB to get the dps points for last 1 year. Suppose opentsdb is having dps only for last 1 month. There will be unnecessary quering happening for 11 more months. I tried below approach. curl -X POST -H "Content-Type: application/json" -d '{ "start": "0", "queries": [ { "metric": "abc", "aggregator": "sum" } ] }' http://localhost:4242/api/query | jq '.[0].dps | keys | .[0]' Is there a better/direct way to get the first data point in opentsdb beforehand? Please note, if I query for last 1 year for 1.7 billion dps, opentsdb throttles and terminate in between using the above query. So i need a way which can directly give me the first epoch time present in opentsdb. Continue reading...
