Schemaless - OpenTSDB Telnet Protocol
In this section we will explain how to write into TDengine cloud service using schemaless OpenTSDB Telnet protocols over REST interface.
Config
Run this command in your terminal to save the TDengine cloud token and URL as variables:
- Bash
- CMD
- Powershell
export TDENGINE_CLOUD_TOKEN="<token>"
export TDENGINE_CLOUD_URL="<url>"
set TDENGINE_CLOUD_TOKEN="<token>"
set TDENGINE_CLOUD_URL="<url>"
$env:TDENGINE_CLOUD_TOKEN="<token>"
$env:TDENGINE_CLOUD_URL="<url>"
Insert
You can use any client that supports the http protocol to access the RESTful interface address <cloud_url>/opentsdb/v1/put to write data in OpenTSDB compatible format to TDengine. The EndPoint is as follows:
/opentsdb/v1/put/telnet/<db>?token=<cloud_token>
Insert Example
curl --request POST "$TDENGINE_CLOUD_URL/opentsdb/v1/put/telnet/<db_name>?token=$TDENGINE_CLOUD_TOKEN" --data-binary "sys 1479496100 1.3E0 host=web01 interface=eth0"
Query Example with SQL
sysis the super table name.- you can filter data by tag, like:
where host="web01".
curl -L -d "select * from <db_name>.sys where host=\"web01\"" $TDENGINE_CLOUD_URL/rest/sql/test?token=$TDENGINE_CLOUD_TOKEN
