Github user Vlad-Storona commented on a diff in the pull request:

    https://github.com/apache/drill/pull/774#discussion_r148957497
  
    --- Diff: contrib/storage-opentsdb/README.md ---
    @@ -0,0 +1,64 @@
    +# drill-storage-openTSDB
    +
    +Implementation of TSDB storage plugin. Plugin uses REST API to work with 
TSDB. 
    +
    +For more information about openTSDB follow this link <http://opentsdb.net>
    +
    +There is list of required params:
    +
    +* metric     - The name of a metric stored in the db.
    +
    +* start      - The start time for the query. This can be a relative or 
absolute timestamp.
    +
    +* aggregator - The name of an aggregation function to use.
    +
    +optional param is: 
    +
    +* downsample - An optional downsampling function to reduce the amount of 
data returned.
    +
    +* end - An end time for the query. If not supplied, the TSD will assume 
the local system time on the server. 
    +This may be a relative or absolute timestamp. This param is optional, and 
if it isn't specified we will send null
    +to the db in this field, but in this case db will assume the local system 
time on the server.
    +
    +List of supported aggregators
    +
    +<http://opentsdb.net/docs/build/html/user_guide/query/aggregators.html>
    +
    +List of supported time 
    +
    +<http://opentsdb.net/docs/build/html/user_guide/query/dates.html>
    +
    +Params must be specified in FROM clause of the query separated by commas. 
For example
    +
    +`openTSDB.(metric=metric_name, start=4d-ago, aggregator=sum)`
    +
    +Supported queries for now are listed below:
    +
    +```
    +USE openTSDB
    +```
    +
    +```
    +SHOW tables
    +```
    +Will print available metrics. Max number of the printed results is a 
Integer.MAX value
    +
    +```
    +SELECT * FROM openTSDB. `(metric=warp.speed.test, start=47y-ago, 
aggregator=sum)` 
    +```
    +Return aggregated elements from `warp.speed.test` table since 47y-ago 
    +
    +```
    +SELECT * FROM openTSDB.`(metric=warp.speed.test, aggregator=avg, 
start=47y-ago)`
    +```
    +Return aggregated elements from `warp.speed.test` table
    +
    +```
    +SELECT `timestamp`, sum(`aggregated value`) FROM 
openTSDB.`(metric=warp.speed.test, aggregator=avg, start=47y-ago)` GROUP BY 
`timestamp`
    --- End diff --
    
    Ok, I will add it.


---

Reply via email to