OpenTSDB / opentsdb

A scalable, distributed Time Series Database.
http://opentsdb.net
GNU Lesser General Public License v2.1
5k stars 1.25k forks source link

Does opentsdb support multi field value ? #905

Open peaksnail opened 7 years ago

peaksnail commented 7 years ago

hi team, Does opentsdb support multi filed value like

cpu.avg timestamp value1 value2 ... host=local

if not , is there any plan to realize?

manolama commented 7 years ago

Hi, no we don't plan to support any kind of layout like that as it doesn't really make sense. What does value 1 represent vs value 2? If v1 is for core 0 of a multi-core CPU, and v2 is core 1, then you would want to write:

cpu.avg timestamp value1 host=local, core=0
cpu.avg timestamp value2 host=local, core=1

What kind of use case are you looking at?

peaksnail commented 7 years ago

Hi, in our use case,we want to cacalute how many sessions that vistior visit our web site. I have compared openTSDB with InfluxDB these days. I found that InfluxDB support multi field value and the value can be string.

But the key is that session will be unique like uuid. So if I choose InfluxDB that I should put session in the field value . If I choose openTSDB, I should put the session in the tags and it will reach the limitation of the openTSDB uids in 30 days(we will generate 450 thousands data points every day). And the query speed may be more and more slowly

Our data model will be designed like below: web.site.page.view timestamp 1 url="url",refer="url",cookie="xx",session="xx",area="xx",device="xx"

So is't appropriate to use openTSDB in our use case?

Thanks very much!