3 ms·
We store "dimensions" as table columns with no artificial limits on column count. If you able to send all dimensions in the same message, they will be stored on
by bluestreak 6y ago
We store "dimensions" as table columns with no artificial limits on column count. If you able to send all dimensions in the same message, they will be stored on one row of data. If dimensions are sent as separate messages, current implementation will store them on different rows. This will make columns sparse. We can change that if need be and "update" the same row as dimensions arrive as long as they have the same timestamp value.
There is an option to store set of dimensions separately as asof/splice join separate tables.
- hintymad 6y agoThanks for the explanation.
- architectonic 6y agoCan you handle multiple time dimensions efficiently? We have 3 of them, can one get away without having to physically store "slices" on one of them?
- bluestreak 6y agoif you can send all three in the same message, Influx Line Protocol for example, we will store them as 3 columns in one table. Does this help?