Yes, you'd have a series for each unique trip ID. The car would be
identified by the "id" tag, presumably.

You probably want to use a tag for "trip" so that you can group by trip ID
and performantly query by trip ID.

However, if you anticipate millions of trip IDs, it would be better to
store it as a field so that your series cardinality
<https://docs.influxdata.com/influxdb/v0.13/concepts/glossary/#series-cardinality>
doesn't rise too high and require lots of RAM
<https://docs.influxdata.com/influxdb/v0.13/guides/hardware_sizing/#when-do-i-need-more-ram>
.

On Mon, Jul 11, 2016 at 11:28 AM, Emiliano Heyns <
[email protected]> wrote:

> On Monday, July 11, 2016 at 7:14:36 PM UTC+2, Sean Beckett wrote:
>>
>> It is not possible to query across measurements, there are no JOINs, etc.
>> We generally recommend that all series with a similar field set be grouped
>> under the same measurement. It's also advantageous to have multiple fields
>> per point. Given all that, I'd recommend the latter:
>>
>> car,id=1 tank_level=0.5,speed=10 <timestamp>
>>
>>
> Super, thanks. Each timestamped set of measurements also belongs to a
> specific trip; if I'd enter them as
>
> car,id=1,trip=323 tank_level=0.5,speed=10 <timestamp>
>
> that would create a series for each, right? All those trips would still be
> for that particular car. Should I use a tag or a field for such groupings
> of measurements?
>
> --
> Remember to include the InfluxDB version number with all issue reports
> ---
> You received this message because you are subscribed to the Google Groups
> "InfluxDB" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To post to this group, send email to [email protected].
> Visit this group at https://groups.google.com/group/influxdb.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/influxdb/f148ce45-5ae8-4988-a2df-d81b90f1ec9c%40googlegroups.com
> <https://groups.google.com/d/msgid/influxdb/f148ce45-5ae8-4988-a2df-d81b90f1ec9c%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>
> For more options, visit https://groups.google.com/d/optout.
>



-- 
Sean Beckett
Director of Support and Professional Services
InfluxDB

-- 
Remember to include the InfluxDB version number with all issue reports
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/CALGqCvN5xvjy7VT_sdFt7ho2MnxjsD7XQ1-t9x0huWFYvfKcUQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to