These are chat archives for influxdata/influxdb

14th
Apr 2015
Antoine Chwalek
@aChwalek
Apr 14 2015 16:41

Hello,
I'm currently building a POC with Influx 0.9 in a heavy load analytics project.

I have 2 types of measurements (which are different types of events):

{
    "name": "firstMeasurement",
    "tags": {
        "id": "1234",
        "region": "eu-west", 
        "server": "1"
    },
    "fields": {
        "value": 0.12
    }
}

{
    "name": "secondMeasurement",
    "tags": {
        "id": "1234"
    },
    "fields": {
        "value": 15
    }
}

There is only one firstMeasurement with id id but the system will hold 0-n secondMeasurement with id id.

I need to aggregate my data with queries like this (pseudo-code) : count secondMeasurement occurence group by 1 hour and region.

So far, I've tried an inner join to link region tag of the firstMeasurement to the secondMeasurement (But I could not find any documentation about joins, even in the influxQL spec ).

Do you know any other ways to do that ?

Thanks a lot.