influxdata / influxdata/docs-v2

Schema design: Provide suggestions to accommodate or correct poor design

Open
#4,535 0 comments 0 reactions 0 assignees View on GitHub
product:v2 product:v2-cloud source:feedback
Dominant language
JavaScript
Stars
82
Forks
326
Avg merge
1d 1h
Merged PRs (30d)
82

Description

Provide help for working with or correcting scenarios (common problems?) like the following:

New user feedback!
Page: https://docs.influxdata.com/influxdb/cloud/write-data/best-practices/schema-design/
Feedback: Hello. This article does not offer guidance how to handle case when tag has many values. Real-world example: I have a test system which produces 100 000 points (field values) for one test run. The number of test runs itself is in order of 1 000 000. That leads to "testid" tag with 1 000 000 tag values, with each tag used to tie together series of 100 000 points for each test. This is discouraged, obviously, but how can I count, say, individual average for each test run and put that into bins, if I cannot filter on "testid" tag?

Contributor guide

No contributing guide indexed for this repository

Research direction

Start with the linked schema-design article and the user feedback in this issue. Determine what guidance is needed for a testid tag with 1,000,000 values and how users can calculate per-test averages and group them into bins. Done means the documentation addresses this scenario with an actionable recommendation.

Written by the indexing model from the issue text.

Assessment

Domain
databases, documentation
Issue type
Documentation
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.