Ask Your Question
1

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

{"tags":{"coalmine_code":"00001"},"dps":{"1534859875":157}}
{"tags":{"coalmine_code":"00002"},"dps":{"1534859876":157}}
{"tags":{"coalmine_code":"00003"},"dps":{"1534859881":137}}
{"tags":{"coalmine_code":"00004"},"dps":{"1534859906":102}}

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
0

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

Comments

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

year,thank

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

Question Tools

1 follower

Stats

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

Seen: 61 times

Last updated: Aug 23