Ask Your Question

How do I write data from OpenTSDB to MySQL?

asked 2018-08-23 05:11:00 -0500

hanxuan gravatar image

updated 2018-08-23 09:03:47 -0500

metadaddy gravatar image

The data is json like


The MySQL fields are (id, value) id ='0001', value='157'

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2018-08-23 09:02:27 -0500

metadaddy gravatar image

updated 2018-08-23 09:33:41 -0500

OpenTSDB does not appear to have a JDBC driver, and StreamSets Data Collector doesn't have an OpenTSDB origin. It looks like you should investigate the OpenTSDB HTTP API. Try using the HTTP Client origin to call the /api/query endpoint.

Another option would be to write a custom origin for OpenTSDB.

edit flag offensive delete link more


no,no we now use Grafana can good support, on sreamset 'input terminal 'use httpclient

hanxuan gravatar imagehanxuan ( 2018-08-23 09:19:15 -0500 )edit

Now the way I can think of it is coalmine_code can do,but dps:timestampupdated in real time,so Value is also changing in real time. This point cannot be effectively dealt with

hanxuan gravatar imagehanxuan ( 2018-08-23 09:26:21 -0500 )edit

You're right - HTTP is the way to go. I'm not sure how to deal with the changing timestamps.

metadaddy gravatar imagemetadaddy ( 2018-08-23 09:34:34 -0500 )edit


hanxuan gravatar imagehanxuan ( 2018-08-24 04:27:42 -0500 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-08-23 05:05:15 -0500

Seen: 61 times

Last updated: Aug 23