4

What are some good rules and examples of how to choose between storing data in fields vs. tags when designing InfluxDB schemas?

What I've found so far is:

a measurement that changes over time should be a field, and metadata about the measurement should be in tags

tags and fields are effectively columns in the table. tags are indexed, fields are not

the values that are highly variant and not usually part of a WHERE clause are put into fields

Store data in fields if you plan to use them with an InfluxQL function

Tags containing highly variable information like UUIDs, hashes, and random strings will lead to a large number of series in the database, known colloquially as high series cardinality. High series cardinality is a primary driver of high memory usage for many database workloads.

But let's say you store filled orders in an e-commerce application: order id, sale price, currency.

  • Should the order id be a tag, or a field?
  • Should the currency be a tag, or a field?
1

I would suggest both order and currency be the tags. Because you will probably need to make queries like WHERE order = orderid or WHERE currency = currencyid. Making order and currency as tags has advantages in this case, because they will be implicitly indexed.

Generally speaking, first write down all the queries you application will run on database and then you will see what should be tags

  • That was my thought for currency, too, but for orderId, storing it in a tag would lead to high series cardinality. – Dan Dascalescu Feb 7 '17 at 8:30
  • Do you have only one record for each order? – 0x2207 Feb 7 '17 at 12:05
  • Yes, only one record per order. – Dan Dascalescu Feb 8 '17 at 10:11
  • As far as I remember, influxdb doesn't build indices for values at all. And it doen't know tree-like indices. I mean WHERE order = orderid will require full scan in any case. So, making it a value would be better – 0x2207 Feb 11 '17 at 18:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.