opentsdb / opentsdbr Goto Github PK

OpenTSDB supports sub-second resolution.
It is disabled by default, but we can enable it using "ms=true" query paramater.
http://opentsdb.net/docs/build/html/api_http/query/index.html

Would you consider to support it?

I am not an R programmer, but it seems that due to a naming clash, this software fails to start.

This is the output when I try to run even the example query from the README.md file:

R version 3.2.1 (2015-06-18) -- "World-Famous Astronaut"
Copyright (C) 2015 The R Foundation for Statistical Computing
Platform: x86_64-pc-linux-gnu (64-bit)

R is free software and comes with ABSOLUTELY NO WARRANTY.
You are welcome to redistribute it under certain conditions.
Type 'license()' or 'licence()' for distribution details.

  Natural language support but running in an English locale

R is a collaborative project with many contributors.
Type 'contributors()' for more information and
'citation()' on how to cite R or R packages in publications.

Type 'demo()' for some demos, 'help()' for on-line help, or
'help.start()' for an HTML browser interface to help.
Type 'q()' to quit R.

> library(opentsdbr)
Loading required package: stringr
Loading required package: httr
Loading required package: lubridate
Loading required package: data.table
data.table 1.9.4  For help type: ?data.table
*** NB: by=.EACHI is now explicit. See README to restore previous behaviour.

Attaching package: ‘data.table’

The following objects are masked from ‘package:lubridate’:

    hour, mday, month, quarter, wday, week, yday, year

> metric <- "SHT15_temp_Celsius"
> start <- ISOdate(2013, 02, 02, 00, tz="America/Los_Angeles")
> (result <- tsd_get(metric, start, tags=c(site="*"), downsample="10m-avg"))
Error: is.interval(interval) is not TRUE

To me (again, not an R programmer), this looks like it could be related to something like this:

http://stackoverflow.com/questions/30249863/lubridate-objects-masked-after-loading-data-table

Can someone with any modicum of R skills see if there is an easy solution to this?

(result <- tsd_get(metric, start, tags=c(site="*"), downsample="10m-avg"))
Error: is.interval(interval) is not TRUE

Hi Holstius,

I just looked in opentsdbr code and tried some example. It is awesome work. I am trying to work on big data analysis on R. I want to run map-reduce on R using Rhipe/rbase. I am trying to get data from opentsdb using API. But I am looking for the way to read data directly from hbase table 'tsdb'. Can you help me with that part. I went through the documentation of opentsdb. I understand how we can get rowkey. But since everything is stored in serialized form. So I have no idea how to read data on hbase table directly from shell. I want to do this. So, that we can analysis performance between using API and reading data directly from hbase. Once it is done. I hope it would be helpful to other people.

Thanks

Hi! Thank you so much for this awesome tie in! We had an analyst who wanted to use R for accessing our OpenTSDB data and I was able to spin up your module and get him up and running.

I saw that the tsd_get() method is using the /q endpoint to fetch data. We're deprecating that in 2.0 and trying to get folks to move over to the new /api/query endpoint. It returns JSON data so hopefully R would be able to parse that fairly easily. And if there is a format that's better for R, we could write a serialization plugin to return results in that format.

Thanks again!

is.interval(ISOdate(2013, 02, 02, 00, tz="America/Los_Angeles")) is FALSE!
tsd_get executes stopifnot(FALSE) then.